laravel5日志设置篇(2/3) – 记录sql日志

想要实现的功能


 
 
 

  
获取laravel运行时执行的sql语句
  
sql相关的日志保存到指定文件（sql.log）
  
接口访问与artisan 命令日志分开保存
 

例如
- sql.log

[2017-10-21 22:27:42] production.DEBUG: select count(*) as aggregate from `stocks_input` where `stocks_input`.`deleted_at` is null; {"time":0.55} 
[2017-10-21 22:27:42] production.DEBUG: select * from `stocks_input` where `stocks_input`.`deleted_at` is null order by `created_at` desc limit 10 offset 0; {"time":0.84} 
[2017-10-21 22:27:42] production.DEBUG: select * from `goods` where `goods`.`id` = 1 limit 1; {"time":0.74} 



 
 
 

  
cli.sql.log
 

[2017-10-21 22:28:15] production.DEBUG: select * from `goods` where `goods`.`id` = 1 limit 1; {"time":0.76} 
[2017-10-21 22:28:15] production.DEBUG: select * from `regions` where `regions`.`id` = 110102 limit 1; {"time":0.87} 
[2017-10-21 22:28:15] production.DEBUG: select * from `regions` where `regions`.`id` = 110000 limit 1; {"time":0.81} 



 
 

环境


 
 
 

  
php 7.0.22
  
laravel 5.2.*
 

具体实现


 
 
 

  
编写日志服务类LogServiceProvider
  
在Application中注册LogServiceProvider
  
编写sql查询日志输出事件监听器
  
sql查询日志输出事件注册
 

LogServiceProvider类编写

<?php

namespace App\Providers;

use Carbon\Carbon;
use Illuminate\Support\ServiceProvider;
use Illuminate\Log\Writer;
use Monolog\Logger as Monolog;

/**
 * 日志记录器服务
 *
 * @package app