Quickly Dumping Laravel Queries

When you are building an application and utilizing Laravel Eloquent it’s very easy to hit the N+1 problem. This is where you select a model and then later use lazy loading to fetch child records.

As an example pretend you are selecting a user:

1User::where('name', 'Eric')->first();

Then in your view you might do something like:

1@foreach ($user->posts as $post)

Because the posts haven’t been initially loaded with the User Eloquent has to perform a new query for each of these records.

The solution is to utilize the with method on the select.

1User::where('name', 'Eric')->with('posts')->first();

Of course, finding these can get tricky and one solution is to use something like the Laravel Debugbar or the Laravel database profiler in local development. It will print out a list of all queries and give you a heads up if they are getting out of control.

Over on the Laravel Reddit channel, the user magkopian shared another quick solution to see all the queries ran on a page.

Inside AppServiceProvider.php add the following to the boot method:

 1use DB;
 2use Event;
 3
 4//..
 5
 6public function boot()
 7{
 8    if (env('APP_ENV') === 'local') {
 9        DB::connection()->enableQueryLog();
10        Event::listen('kernel.handled', function ($request, $response) {
11            if ( $request->has('sql-debug') ) {
12                $queries = DB::getQueryLog();
13                dd($queries);
14            }
15        });
16    }
17}

Now while you are developing on any URL you can append ?sql-debug=1 and get an output of all the queries ran.

One minor improvement instead of using dd is to use the dump helper so you can get a little nicer output:

Granted this is quick and dirty but I have came across situations where I just need to see what all is happening on a specific page and this will solve that without installing a dedicated package.

Do you have a better way of handling this? Let me know on Twitter or Facebook.