Laravle(DB::listen)(数据库监听)

Laravel-数据库监听

1. php
3. namespace App\Providers;
4. class AppServiceProvider extends ServiceProvider
5. {
6. public function boot(){
7. DB::listen(function($query){
8. //剔除命令行sql
9. if(app()->runningInConsole()) return;
10. $request = request();
11. //防止重复录入形成死循环 sql_log有关的表不显示
12. if(strpos($query->sql,'sql_log' !=false)) return;
13. $sqlLog = [
14. 'sql' => vsprintf(str_replace("?", "'%s'", $query->sql), $query->bindings),
15. 'time' => $query->time,
16. 'url' => $query->url,
17. 'fingerprint' => $request->fingerprint()
18. ];
19. });
20. }
21. }