Capture all queries in a log file.

AppServiceProvider.php

// Add this in the register() method.
// Credit to @trovster -> https://twitter.com/trovster/status/1537082202709803008

if (! $this->app->isProduction()) {
    DB::listen(function ($query): void {
        $date = Carbon::today()->toDateString();
        $filepath = storage_path("logs/queries-{$date}.log");
        File::append( 
            $filepath,
            $query->sql . '[' . implode(', ', $query->bindings) . ']' . PHP_EOL
        );
    });
}