\DB::listen(function($query) {
$bindings=$query->bindings;
$sql=$query->sql;
foreach($bindingsas$replace) {
$value= is_numeric($replace) ?$replace:"'".$replace."'";
$sql= preg_replace('/\?/',$value,$sql,1);
}
file_put_contents(base_path() .'/storage/logs/sluggish-'. date('Y-m-d') .'.log',$sql.PHP_EOL,FILE_APPEND);
var_dump($sql);
});
执行sql:
$db = DB::reconnect('sa_db');
$res = $db->select($sql);
print_r($res);
DIE;
网友评论