Helper Database::log() to dump query logs. Useful for debugging artisan commands or migrations.

Database.php

<?php

namespace App\Support;

use Closure;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;

class Database
{
    public static function log(): void
    {
        if (!config('app.debug')) {
            return;
        }

        DB::listen(function ($query) {
            $bindings = array_map(
                fn ($value) => is_numeric($value) ? $value : "'{$value}'",
                $query->bindings,
            );

            $trace = collect(debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS, 25))
                ->slice(3)
                ->first(fn (array $info) => empty($info['file']) || !Str::contains($info['file'], 'framework/src/Illuminate/Database/'));

            $trace = $trace ? sprintf('%s:%d @%s', $trace['file'] ?? '', $trace['line'] ?? '', $trace['function']) : '';

            dump([
                'query' => Str::replaceArray('?', $bindings, $query->sql),
                'time (s)' => $query->time,
                'trace' => $trace,
            ]);
        });
    }
}