laravel 打印sql

DB::connection()->enableQueryLog();#开启执行日志
$goodLists = DB::table('ds_goods')->where(['goods_advword'=>['like' => "%{$title}%"],'goods_state' => 1])->orWhere(function($query) use ($title) {
  // 闭包添加搜索条件
    $query->where(['goods_name'=>['like' => "%{$title}%"],'goods_state' => 1]);
})->get();
dd(DB::getQueryLog()); //获取查询语句、参数和执行时间
posted @ 2020-08-27 18:23  をもって剣を制す  阅读(97)  评论(0编辑  收藏  举报