平气飞 / laravel-query-logger
一个用于记录Laravel应用所有查询的开发工具。
v1.0.0
2020-03-02 09:35 UTC
Requires
- laravel/framework: >=5.6
This package is auto-updated.
Last update: 2024-09-29 05:21:53 UTC
README
📝 一个用于记录Laravel应用所有查询的开发工具,独立于框架的日志。
安装
$ composer require pianqifei/laravel-query-logger --dev -vvv
php artisan vendor:publish --provider="Pqf\LaravelQueryLogger\ServiceProvider" 发布querylog配置文件,自定义日志记录开关和日志频道
当 QUERY_LOG 设置为 true 时,Laravel Query Logger 将被启用。
请保留
--dev选项。
使用
$ tail -f ./storage/logs/laravel-y-m-d.log
[2019-06-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
[2019-06-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
[2019-06-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
[2019-06-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
...
许可证
MIT