Laravel query debugger

larave-query-debugger.php

<?php

/**
 * Original: https://github.com/morrislaptop/laravel-query-builder-dump/blob/master/src/QueryBuilderDumpServiceProvider.php
 */

if (app()->environment() != 'production') {
    \DB::listen(function ($executed) {
        $flat = \Arr::flatten($executed->bindings);
        foreach ($flat as $binding) {
            $binded = $binding instanceof \DateTime ? $binding->format('Y-m-d H:i:s') : $binding;
            $binded = is_numeric($binded) ? $binded : "'{$binded}'";
            $executed->sql = preg_replace('/\?/', $binded, $executed->sql, 1);
        }
        \Log::info($executed->sql);
    });
}