包简介

Detect slow queries and N+1 problems in your Laravel app. Logs warnings with query details, execution time, and origin.

README 文档

README

A lightweight Laravel package that detects slow database queries and N+1 problems, logging them with execution time and origin trace.

Installation

composer require furkankufrevi/laravel-slow-query-detector

The service provider is auto-discovered. To publish the config:

php artisan vendor:publish --tag=slow-query-detector-config

Setup

Add the middleware to your routes or groups:

// bootstrap/app.php (Laravel 11+)
->withMiddleware(function (Middleware $middleware) {
    $middleware->append(\SlowQueryDetector\Middleware\SlowQueryMiddleware::class);
})

// app/Http/Kernel.php (Laravel 10)
protected $middleware = [
    \SlowQueryDetector\Middleware\SlowQueryMiddleware::class,
];

Configuration

Set via .env or publish the config file:

SLOW_QUERY_DETECTOR_ENABLED=true
SLOW_QUERY_THRESHOLD=100
SLOW_QUERY_LOG_CHANNEL=

Option	Default	Description
`enabled`	`true`	Enable/disable the detector
`threshold`	`100`	Slow query threshold in milliseconds
`detect_n_plus_one`	`true`	Enable N+1 duplicate query detection
`duplicate_threshold`	`3`	Min repeated queries to trigger N+1 warning
`log_channel`	`null`	Log channel (null = default)
`include_trace`	`true`	Include origin stack trace in logs
`trace_depth`	`5`	Max stack frames to capture

Log Output

Slow query:

[Slow Query] GET /users | 250.00ms | select * from users where active = 1 | Origin: UserController.php:42

N+1 detection:

[N+1 Detected] GET /posts | Query repeated 15x: select * from comments where post_id = '3'

Summary:

[Query Summary] GET /posts | 18 queries | 320.50ms total

License

MIT

furkankufrevi/laravel-slow-query-detector 适用场景与选型建议

furkankufrevi/laravel-slow-query-detector 是一款基于 PHP 开发的 Composer 扩展包，目前已累计 0 次下载、GitHub Stars 达 0，最近一次更新时间为 2026 年 03 月 16 日，在 PHP 生态内属于活跃度较高的组件。

它主要适用于以下技术方向：「performance」「debugging」「laravel」「n-plus-one」「slow-query」「query-detector」等业务场景。在实际项目中，围绕这些方向常见需要落地的问题包括：接口对接、性能调优、并发安全、与既有框架（Laravel / ThinkPHP / Yii / Webman 等）的兼容适配，以及生产环境的日志埋点与稳定性保障。

我们在过去多个企业项目中使用过 furkankufrevi/laravel-slow-query-detector 或与其功能相近的方案，如果你在选型或落地过程中遇到问题，例如 版本兼容、二次改造、私有化封装、与内部系统对接、生产 BUG 排查，欢迎联系我们协助评估。

围绕 furkankufrevi/laravel-slow-query-detector 我们能提供哪些服务？

定制开发 / 二次开发

基于 furkankufrevi/laravel-slow-query-detector 在你已有业务上做功能扩展、字段裁剪、UI 适配、与内部账号 / 权限 / 日志系统的深度对接。

BUG 修复 & 性能优化

线上偶发问题、内存泄漏、慢查询、并发异常等排查修复；针对高流量场景做缓存、队列、索引层面的调优。

项目外包 & 长期维护

承接完整的项目从需求 → 设计 → 开发 → 上线 → 长期运维；也可按月提供技术保姆服务。

yvsm@zunyunkeji.com QQ：316430983 微信：yvsm316 西安尊云信息科技 · 专注 PHP / Go / 分布式系统研发

与 furkankufrevi/laravel-slow-query-detector 相关的其它包

同方向 / 同关键字的高下载量 PHP Composer 包推荐，方便对比选型：

g4/profiler 0

g4 application profiler package

sgalinski/scriptmerger 0

CSS/Javascript Minificator, Compressor and Concatenator for TYPO3 - highly configurable frontend asset optimization for CSS/JS merging, minification and compression with optional body parsing, async/defer loading, inline output, data-ignore exclusions, SRI integrity validation/calculation, external

wearerequired/jquery-light 1

WordPress mu-plugin to remove jQuery Migrate from the list of jQuery dependencies and to allow jQuery to enqueue before </body> instead of in the <head>.

opsdev/cache-breaker 4

Create link to static resources with cache-breaking segment based on md5 of the file

michaeljennings/snapshot 7

A PHP package that takes a snapshot of your application and allows you to retrieve it later to help with debugging.

web-chefs/db-lojack 3

Laravel Database Query Logger and debug helper.

furkankufrevi/laravel-slow-query-detector

包简介

关键字：