Laravel 打印SQL语句

DB::connection()->enableQueryLog();#开启执行日志
$a = self::where(['investorid'=>$id])->whereBetween('inserttime',[$start,$end])->where('deposit','>',0)->orderBy('id','asc')->Paginate(20);
 print_r(DB::getQueryLog());   //获取查询语句、参数和执行时间

 

posted on 2018-07-30 13:44  降魔  阅读(18578)  评论(0编辑  收藏  举报