azizramdan

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;

azizramdan

\DB::listen(function ($query) {
    dump($query->sql, $query->bindings);
});