Daily Archives: 17th February 2016


Logging SQL queries in Laravel 5

To create Log entries for every sql query, include the following before the code you need to check. Even drop it into the routes file if you want to log every transaction.

DB::listen(function ($sql) {
        Log::info($sql->sql);
        Log::info('Bindings: ' . implode(', ',$sql->bindings));
        Log::info('Last Query took ' . $sql->time . ' seconds');
    }
); 

If including in a controller, you will need to add at the top of the controller

use DB;
use Log;