Analyse your SQL queries with Laravel Debugbar

Last Updated at : February 4, 2018 By - Usama Muneer | 2018

    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.

    debugbar

    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.

    blog user
    Usama Muneer

    A web enthusiastic, self-motivated & detail-oriented professional Full-Stack Web Developer from Karachi, Pakistan with experience in developing applications using JavaScript, WordPress & Laravel specifically. Loves to write on different web technologies with an equally useful skill to make some sense out of it.

    Related Posts

    Importing Excel files come handy when you’re building some large scale inventory kind of an application where you need to import set of data from CSV or excel files. In this short tutorial, we’ll go through on importing excel files with Laravel & look on for some crazy hacks and tricks in between.

    Gear up fellow developers, another Laravel Meetup is coming back to Lahore & it will be a great milestone while helping our fellow web developers across the city to become motivated and will help them grow as Laravel developers.

    Getting an app developed is not the only thing that one needs to ensure in terms of digital visibility and e-commerce. Yes, having an app is important but to stay updated and to be abreast with the competition Optimization of performance is necessary.

    Telescope gives knowledge into the solicitations coming into your application, exemptions, log sections, database questions, lined employments, mail, notices, reserve activities, planned errands, variable dumps and that's just the beginning.