laravel 打印 sql

首先开启SQL日志

执行你的SQL或model

 

$queries= DB::getQueryLog();
$sqlData = [];
foreach ($queries as $k=> $b){
    $bi  = $b['bindings'];
    $bi = array_map(function($a){
        return '\''.$a.'\'';
    },$bi);

    $sql = str_replace('?', '%s', $b['query']);
    $sql2 = sprintf($sql, ...$bi);
    $sqlData[$k] = $sql2;
}
$sqlData = implode(';',$sqlData);