webikevn/query-logger

A dev tool to log all queries for laravel application.

1.0 2020-09-29 17:17 UTC

Requires

• laravel/framework: ~5.5||~6.0||~7.0||~8.0

MIT

• Nguyen Giang

README

📝 A dev tool to log all queries for Laravel application.

Installing

$ composer require webikevn/query-logger --dev

Query Logger will be enabled when LOG_QUERY is true.

Please keep the --dev option.

Usage

$ tail -f ./storage/logs/laravel.log

[2017-09-05 14:52:14] local.DEBUG: [800μs] select count(*) as aggregate from `discussions` where `discussions`.`deleted_at` is null | GET: http://laravel.app/discussions
[2017-09-05 14:52:14] local.DEBUG: [1.07ms] select * from `discussions` where `discussions`.`deleted_at` is null order by `is_top` desc, `created_at` desc limit 15 offset 0 | GET: http://laravel.app/discussions
[2017-09-05 14:52:14] local.DEBUG: [3.63s] select `tags`.*, `taggables`.`taggable_id` as `pivot_taggable_id`, `taggables`.`tag_id` as `pivot_tag_id` from `tags` inner join `taggables` on `tags`.`id` = `taggables`.`tag_id` where `taggables`.`taggable_id` in ('1', '2', '3', '4', '5', '6', '7', '8') and `taggables`.`taggable_type` = 'App\\Models\\Discussion' order by `order_column` asc | GET: http://laravel.app/discussions
[2017-09-05 14:52:14] local.DEBUG: [670μs] select * from `users` where `users`.`id` in ('1', '2', '4') and `users`.`deleted_at` is null | GET: http://laravel.app/discussions
...

Configuration

If you want to use it in a environment, you can control whether or not to log a query via the configuration file：

config/logging.php:

return [
    //...
    'query' => [
        'enabled' => env('LOG_QUERY', false),
         
        // Only record queries that are slower than the following time
        // Unit: milliseconds
        'slower_than' => 0, 
    ],
];