监听式
DB::listen(function($query) {
$bindings = $query->bindings;
$sql = $query->sql;
foreach ($bindings as $replace){
$value = is_numeric($replace) ? $replace : "'".$replace."'";
$sql = preg_replace('/\?/', $value, $sql, 1);
}
dd($sql);
});
//执行的Sql语句
.........
启用式
DB::connection()->enableQueryLog()
//查询语句
......dd(DB::getQueryLog());