>[info] Laravel監聽 sql 語句 1.**創建監聽器** ~~~ php artisan make:listener QueryListener ~~~ 修改`handle`方法 ~~~ use Illuminate\Database\Events\QueryExecuted; use Illuminate\Support\Facades\Log; public function handle(QueryExecuted $event) { // 只在測試環境下輸出 log 日志 if (!app()->environment(['testing', 'local'])) { return; } $sql = $event->sql; $bindings = $event->bindings; $time = $event->time; // 毫秒 $bindings = array_map(function ($binding) { if (is_string($binding)) { return (string)$binding; } if ($binding instanceof \DateTime) { return $binding->format("'Y-m-d H:i:s'"); } return $binding; }, $bindings); $sql = str_replace('?', '%s', $sql); $sql = sprintf($sql, ...$bindings); Log::info('sql_log', ['sql' => $sql, 'time' => $time . 'ms']); } ~~~ 2.**注冊監聽事件** 在系統的服務提供者`App\Providers\EventServiceProvider`中注冊監聽事件 ~~~ protected $listen = [ QueryExecuted::class => [ QueryListener::class, ], ]; ~~~ 3.**執行 sql 查看日志** 可以在日志文件中看到 sql 的執行時間、sql 語句、毫秒數 ~~~ [2022-05-08 22:45:04] local.INFO: sql_log {"sql":"select * from `user` where `user`.`id` = 3 limit 1","time":"51.59ms"} ~~~