## 監聽laravel 執行的mysql語句并且寫入文件中 1. 找到`app/Providers/AppServiceProvider.php`文件 2. 在boot方法中加入這個方法 ~~~ public function boot() { $this->listenSql(); } ~~~ `listenSql`方法內容如下 ~~~ \DB::listen( function ($sql) { foreach ($sql->bindings as $i => $binding) { if ($binding instanceof \DateTime) { $sql->bindings[$i] = $binding->format('\'Y-m-d H:i:s\''); } else { if (is_string($binding)) { $sql->bindings[$i] = "'$binding'"; } } } // Insert bindings into query $query = str_replace(array('%', '?'), array('%%', '%s'), $sql->sql); $query = vsprintf($query, $sql->bindings); // Save the query to file $logFile = fopen( storage_path('logs' . DIRECTORY_SEPARATOR . date('Y-m-d') . '_query.log'), 'a+' ); fwrite($logFile, date('Y-m-d H:i:s') . ': ' . $query . PHP_EOL); fclose($logFile); } ); ~~~ 最終效果  內容 ~~~ 2022-07-11 14:10:33: select * from `user where `status` = 0 and `expire_at` <= '2022-07-11 00:00:00' 2022-07-11 14:10:54: select * from `user ` where `status` = 0 and `expire_at` <= '2022-07-11 00:00:00' ~~~