Laravel query sql and bindings

private function getSql($query)
{
    $bindings = $query->getBindings();

    return preg_replace_callback('/\?/', function ($match) use (&$bindings, $query) {
        return $query->getConnection()->getPdo()->quote(array_shift($bindings));
    }, $query->toSql());
}

use Illuminate\Database\Events\QueryExecuted;
use Illuminate\Support\Facades\Event;
use Illuminate\Support\Facades\Log;

Event::listen(QueryExecuted, function (QueryExecuted $event) {
    if ($event->time > 1000) {
        Log::info('Slow query detected.', [
            // ...
        ]);
    }
});

use Illuminate\Database\Connection;
use Illuminate\Support\Facades\DB;

DB::whenQueryingForLongerThan(1000, function (Connection $connection) {
    Log::info('Queries collectively took longer than 1 second.', [
        // ...
    ]);
});