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=

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