Home / Snippets / How to Count The Number of Queries to the Database in Laravel
How to Count The Number of Queries to the Database in Laravel cover

How to Count The Number of Queries to the Database in Laravel

1K

2 years ago

0 comments

To know how many times your Laravel query is hitting the database, you can make use of the "listen()" method from the "DB" facade.

Below is the code example of how you can listen to the "DB" facade.
<?php

use \DB;

$count = 0;

DB::listen(fn ($sql) => $count++);

dd($count); // get the total count
notion avatar

Ahmad Aziz

Week-end developer currently experimenting with web, mobile, and all things programming.

Topics:

Frontend

Resource

Average

Average

Support Us

If you like our tutorial, support us by being our Patreon or buy us some coffee ☕️

Post Tutorials

Learn trending tutorials for ReactJs, React Native, VueJS, NextJs, Laravel, Tailwind CSS, and Flutter development.
View Tutorials

Code Components

Collection of Tailwind CSS components for everyone to use. Browse all of the components that's right for your web projects
View Components

Welcome to PostSrc V3

PostSrc Dark Logo

You have to login to favorite this