Debugging Database Queries

Quickly debugging the amount of database queries per request in Laravel.

sql-doctor example image

Install

$ 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.