SaigonTech Vault
Loại: knowledge-doc 2026-09-29 active #wiki-import

Các bước để log all queries

  1. Add to config/logging.php
'query' => [ 
    'driver' => 'daily',
    'path'   => storage_path('logs/query.log'),
    'level'  => env('LOG_LEVEL', 'debug'),
    'days'   => 14,
],
 ```

2. Add to `app/Providers/AppServiceProvider.php`


```php
public function boot()
{
    if (app()->environment(['local'])) {
        DB::listen(function ($query) {
            Log::channel('query')->info($query->time.' '.$query->sql, $query->bindings);
        });
    }
}
  1. Output storage/logs/query-2021-11-05.log