How to Get the Query Executed in Laravel 5

Better Stack Team
Updated on November 23, 2022

By default, the query log is disabled in Laravel 5:

Don’t worry, you can enable the query log by running the following:

 
// enable query log
DB::enableQueryLog();

Then you can display the log like this:

 
// get the query log
dd(DB::getQueryLog());

Or alternatively, you can register an event listener and listen for logs:

 
DB::listen(
    function ($sql, $bindings, $time) {
        //  $sql - contains the SQL query
    }
);
Got an article suggestion? Let us know
Explore more
How to do error logging in CodeIgniter (PHP)
Questions
How to enable MySQL Query Log?
Questions
Where can I find error log files for PHP?
Questions
Licensed under CC-BY-NC-SA

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.