laravel-queries.log

AppServiceProvider.php

<?php

namespace App\Providers;

use DB;
use Illuminate\Support\Str;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        $queryCount = 1;
        DB::listen(function ($query) use (&$queryCount) {
            $bindings = collect($query->bindings)->map(function ($param) {
                if (is_numeric($param)) {
                    return $param;
                } else {
                    return "'${param}'";
                }
            });
            Log::info("QUERY (${queryCount})  ====> " . Str::replaceArray('?', $bindings->toArray(), $query->sql));
            $queryCount++;
        });
    }
}

Source1 Source2

tail -f storage/logs/laravel.log

custom log file for different tasks

\Illuminate\Support\Facades\Log::channel('single')->debug('hello');

        $queryCount = 1;
        DB::listen(function ($query) use (&$queryCount) {
            $bindings = collect($query->bindings)->map(function ($param) {
                if (is_numeric($param)) {
                    return $param;
                } else {
                    return "'${param}'";
                }
            });
            Log::channel('single')->info("QUERY (${queryCount})  ====> " . Str::replaceArray('?', $bindings->toArray(), $query->sql));
            $queryCount++;
        });