1. 創建文件app/middleware/SqlLogger.php

<?php
namespace app\middleware;use think\facade\Db;
use think\facade\Session;class SqlLogger
{public function handle($request, \Closure $next){// 監聽所有SQL $request->ip()Db::listen(function($sql, $time) {if (preg_match('/^(INSERT|UPDATE|DELETE|REPLACE)/i', $sql)) {$log = ['user_id' => Session::get('userid', 'guest'),'sql'     => $sql,'time'    => date('Y-m-d H:i:s'),'ip'      => '127.1.1.1'];file_put_contents("D:/phpstudy_pro/WWW/sql.log", json_encode($log)."\n", FILE_APPEND);}});return $next($request);}
}?>

2. 打開app/middleware.php文件并注冊該中間件

<?php
// 全局中間件定義文件
return [// 全局請求緩存// \think\middleware\CheckRequestCache::class,// 多語言加載// \think\middleware\LoadLangPack::class,// Session初始化\think\middleware\SessionInit::class,//跨中間件\think\middleware\AllowCrossDomain::class,\app\middleware\SqlLogger::class
];

3. 最終效果：執行修改sql后，會自動觸發該方法