Laravel 打印SQL

149 阅读1分钟

 监听式

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());