Quickly debugging the amount of database queries per request in Laravel.
For Laravel <= 5.3, please use the 1.1 branch!
$ composer require squareboat/sql-doctor
If you are using laravel 5.5 or higher you should skip this step.
If you are using laravel 5.4, simply add the service provider to your project's config/app.php file:
SquareBoat\SqlDoctor\SqlDoctorServiceProvider::class,
Now while your app.debug is set true then on any URL you can append ?sql-doctor=1 and get an output of complete list of queries that ran.
| Query Param | Value | Output |
|---|---|---|
| sql-doctor | 1 | Default query |
| sql-doctor | 2 | Binds values to their parameters in the query. |
SQL Doctor, originally developed after the reddit thread by magkopian.
The MIT License. Please see License File for more information. Copyright © 2017 SquareBoat