squareboat / sql-doctor by akaamitgupta

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

1,428

Package Data
Maintainer Username:	akaamitgupta
Maintainer Contact:	akaamitgupta@gmail.com (Amit Gupta)
Package Create Date:	2016-12-03
Package Last Update:	2017-10-15
Language:	PHP
License:	MIT
Last Refreshed:	2024-11-09 15:03:20

Package Statistics
Total Downloads:	1,428
Monthly Downloads:	0
Daily Downloads:	0
Total Stars:	57
Total Watchers:	5
Total Forks:	1
Total Open Issues:	0

Debugging Database Queries

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

sql-doctor example image

Install

Install via composer

For Laravel <= 5.3, please use the 1.1 branch!

$ composer require squareboat/sql-doctor

Configure Laravel

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:

Service Provider

SquareBoat\SqlDoctor\SqlDoctorServiceProvider::class,

Usage

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

Credits

SQL Doctor, originally developed after the reddit thread by magkopian.