Laravel Count Number of Queries to the Database

by

If you want to know how many times your Laravel query is hitting the database you can use this snippet by @Tarasovych from StackOverflow.

$counter = 0;
\DB::listen(function($sql) {
    $counter++; //increment for each query was run
});
// Execute your query here
echo $counter;

Pretty handy!

Related posts:

  1. Laravel Query Builder Distinct
  2. Curl Error Using Guzzle using Laravel Valet and Passport
  3. Fast Insert CSV Data to Laravel From S3
  4. Laravel with relationship but use join instead

2 thoughts on “Laravel Count Number of Queries to the Database”

    • You should pass it by reference, otherwise value is not written to the variable outside function:
      Final code is:

      $counter = 0;

      \DB::listen(function() use (&$counter) {
      $counter++; //increment for each query was run
      });

      echo $counter;

      Reply

Leave a Comment