eloquent 5 sql log

eloquent5sqllog.php

use Illuminate\Database\Capsule\Manager as DB;

DB::enableQueryLog();

DB::listen(
    function ($sql, $bindings, $time) {
        //  $sql - select * from `ncv_users` where `ncv_users`.`id` = ? limit 1
        //  $bindings - [5]
        //  $time(in milliseconds) - 0.38

        // Uncomment this if you want to include bindings to queries
        $sql = str_replace(array('%', '?'), array('%%', '%s'), $sql);
        $sql = vsprintf($sql, $bindings);

        $time_now = (new DateTime)->format('Y-m-d H:i:s');;
        $log = $time_now . ' | ' . $sql . ' | ' . $time . 'ms' . PHP_EOL;
        echo $log;
    }
);

Ref:

• http://laravel-tricks.com/tricks/real-time-log-of-eloquent-sql-queries
• http://stackoverflow.com/questions/29499939/use-raw-eloquent-queries-with-slim-php