README

📝 一个用于记录 Laravel/Lumen 应用所有查询的开发工具。

安装

$ composer require anik/laravel-query-logger --dev

请保留 --dev 选项。

使用方法

1. 您需要明确地将 LOG_DB_QUERIES 定义为您想要的值。(bool) false 不会记录任何查询。
2. 如果将 LOG_DB_QUERIES 设置为 daily，它将每天记录。
3. 对于 Lumen，您必须在 bootstrap/app.php 中注册 ServiceProvider。

$app->register(Anik\LaravelQueryLogger\ServiceProvider::class);

$ tail -f storage/logs/queries.log

或者

$ tail -f storage/logs/queries-2019-01-27.log

============ URL: http://laravel.app/discussions ===============
[2019-01-27 18:52:14] [.....800μs] select count(*) as aggregate from `discussions` where `discussions`.`deleted_at` is null
[2019-01-27 18:52:14] [....1.07ms] select * from `discussions` where `discussions`.`deleted_at` is null order by `is_top` desc, `created_at` desc limit 15 offset 0
[2019-01-27 18:52:14] [.....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
[2019-01-27 18:52:14] [.....670μs] select * from `users` where `users`.`id` in ('1', '2', '4') and `users`.`deleted_at` is null
================================================================================

许可协议

MIT