Add below code to AppServiceProvider boot method
DB::listen(function ($query) {
File::append(storage_path('/logs/query.log'),
'[' . date('Y-m-d H:i:s') . ']' . PHP_EOL . $query->sql .
' [' . implode(', ',$query->bindings) . ']' . PHP_EOL .
PHP_EOL
);
);
The all the query that are run in your app will be saved in storage/logs/query.log file
Top comments (1)
Concise but quite handy piece of code. Great!