Daily archives: 17th February 2016

Logging SQL queries in Laravel 5

This entry was posted in Laravel on by

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;