Simple Laravel 5 package to dump all running queries on the page. If it's
SELECT query, it will also show
EXPLAIN information against it.
- PHP >= 5.6
- Laravel 5 (tested on Laravel 5.1, 5.2, 5.3 and 5.4)
Install via composer
composer require sarfraznawaz2005/querydumper
Add Service Provider to
php artisan vendor:publish to publish package's config file. You should now have
querydumper.php file published in
enabled: Enable or disable QueryDumper. By default it is disabled. If you are on local environment, you can also just add
QUERYDUMPER=trueto env file to enable it.
querystring_name: Whatever value for this config is set, you will be able to see all running quries by appending this value in your url as query string. Example:
http://www.yourapp.com/someurl?qqq. Default value is
format_sql: If true, it will also format shown SQL queries. Default
same_page: If true, it will dump queries on current page you are on. If it affects your layout, you can set this to
falseand be able to view dumped queries on a page available at url
http://yoursite.com/querydumper/dump. In this case, first visit the page you want to see queries of by appending
?querystring_namevalue there and then visit
querydumper/dumproute to see quries for your last visited page. Default
This code is published under the MIT License. This means you can do almost anything with it, as long as the copyright notice and the accompanying license file is left intact.