One should be careful while developing any application with the number of SQL
queries triggered for each request. Here we're talking about analysing SQL
queries for your Laravel
application.
Laravel Debugbar for the rescue
Laravel Debugbar is an open-source package built to integrate PHP
Debug bar with your Laravel
application & keep track of all your SQL
queries, so that you can analyse and optimise your code accordingly.
It will give you the nice popup toolbar just like the chrome developer tools.
Installation
Right into your project root, install the package using composer
.
composer require barryvdh/laravel-debugbar
Adding the Service Provider
This package is only required for Development, so instead of adding the ServiceProvider
in config/app.php
, we'll do add this in app/Providers/AppServiceProvider.php
instead.
Right into the register method,
public function register() { if ( $this->app->isLocal() ) { $this->app->register( \Barryvdh\Debugbar\ServiceProvider::class ); } } }
Now if you head back to your browser, you may see a nice little popup listing your SQL
queries.
Conclusion
Its always a good practice to keep track of your SQL
queries to avoid n+1
trap where multiple queries are running for a simple thing.
Do follow us on Twitter.