php打印sql语句函数,laravel 打印sql语句

laravel 打印sql语句

主要依靠DB::COnnection()函数DB::connection()->enableQueryLog();

//执行的sql语句

var_dump(DB::getQueryLog());

直接上代码：DB::connection()->enableQueryLog();

$data = DB::table("down as a")

->leftJoin('files as b','a.img_files_id','=','b.id')

->leftJoin('files as c','a.down_files_id','=','c.id');

if((int)$type==1) {

$data = $data->where("a.goods_type",'=','1');

}elseif((int)$type==2){

$data = $data->where("a.goods_type",'=','2');

}else{

$data = $data->Where(function($query){

$query->where('a.goods_type','=', 1)->orWhere("a.goods_type",'=','2');

});

}

$list = $data->orderBy("a.id","DESC")->offset(($page-1)*$pageSize)->limit($pageSize)->get(['a.*','b.files_url', 'c.files_size']);

var_dump(DB::getQueryLog());

laravel 打印sql语句  试试吧！