DEV Community

Manish Chaudhary
Manish Chaudhary

Posted on

1 1

Listen to query event and save to separate log file in Laravel

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
    );
);
Enter fullscreen mode Exit fullscreen mode

The all the query that are run in your app will be saved in storage/logs/query.log file

Top comments (1)

Collapse
 
theccode profile image
Eric A. Kumah

Concise but quite handy piece of code. Great!

Postmark Image

Speedy emails, satisfied customers

Are delayed transactional emails costing you user satisfaction? Postmark delivers your emails almost instantly, keeping your customers happy and connected.

Sign up