laravel打印输出完整sql,执行时间和explain分析

function toRawSql($getQueryLog)
{
    $sqlArr = [];
    foreach ($getQueryLog as $k=>$log){
        $sql = $log['query'];
        foreach ($log['bindings'] as $binding){
            $binding = is_numeric($binding) ? $binding : "'".$binding."'";
            //正则匹配替换
            $sql = preg_replace('/\?/',$binding,$sql,1);
        }
        //输出sql语句
        $sqlArr[$k]['sql'] = $sql;
        //执行时间
        $sqlArr[$k]['time'] = $log['time'];
        //使用explain分析sql语句
        $sqlArr[$k]['explain'] = \DB::select('explain '.$log['query'],$log['bindings']);
    }
    return $sqlArr;
}Copy

DB::connection()->enableQueryLog();
//
//执行代码
dd(toRawSql(DB::getQueryLog()));Copy