记录 sql 查询日志

好像在哪见过 ？

@redrain 这个是 百度找到的

if (env('APP_DEBUG') == true) {
            $sql = str_replace("?", "'%s'", $event->sql);
            $log = vsprintf($sql, $event->bindings); 
            (new Logger('sql'))->pushHandler(new RotatingFileHandler(storage_path('logs/sql.log')))->info($log);
        }

这样貌似更 “优雅“。

学习了 ！！

foreach($event->bindings as $key =>$binding){ if($binding instanceof \DateTime){ $event->bindings[$key] = $binding->format('Y-m-d H:i:s'); } }
用passport后,数据库添加语句用到DateTime class 会报错

@moore0903 报错截图 提供下

@xufu

不需要调用event(new QueryExecuted)触发吗

@kylesean 感觉这样确实比较优雅

DB::listen(function ($query) {
     $bindings = [];
     foreach ($query->bindings as $binding) {
          $bindings[] = $binding instanceof DateTime ? $binding->format('YYYY-MM-DD HH:mm:ss') : $binding;
     }

     Log::debug("[{$query->time}ms] " . str_replace_array('?', $bindings, $query->sql) . PHP_EOL);
});

public function boot()
{
    if (env('APP_DEBUG') == true) {
        DB::listen(function ($query) {
            $sql = str_replace("?", "'%s'", $query->sql);
            $log = "[{$query->time}ms] " .vsprintf($sql, $query->bindings);
            Log::channel('daily_sql')->info($log);
        });
    }
}

    'daily_sql' => [//logging.php  配置文件配置频道
        'driver' => 'daily',
        'path' => storage_path('logs/sql.log'),
        'level' => 'debug',
        'days' => 10,
    ],

为啥不用数据库的审计功能呢？代码层面实现有什么优势吗？