在项目app/Helper/helper.php中添加以下代码即可
/**
* sql 调试
*/
if (!function_exists('get_sql')) {
function get_sql()
{
DB::listen(function ($sql) {
dump($sql);
$singleSql = $sql->sql;
if ($sql->bindings) {
foreach ($sql->bindings as $replace) {
$value = is_numeric($replace) ? $replace : "'" . $replace . "'";
$singleSql = preg_replace('/\?/', $value, $singleSql, 1);
}
dump($singleSql);
} else {
dump($singleSql);
}
});
}
}