在laravel框架中如何查看自己写的sql原生格式,比如下面的sql生成的原生格式:
//查询评论信息
$data = DB::table('ysbt_order_comments as a')
->leftjoin('ysbt_orders as c','a.order_id','=','c.order_id')
->leftjoin('sky_user_data_master.user_base_info as d','c.seller_id','=','d.user_id')
->leftjoin('sky_user_data_master.user_version_info as e','c.seller_id','=','e.user_id')
->select('a.votes','a.content','a.created_at','d.user_name','e.thumbnail_image_url')
->where('a.order_id',$order_id)
->first();
如果我们想要知道上面这个查询构造器构造出来的sql到底是啥样子的,那么我们可以通过下面的这个方法来进行处理,这里我们需要用到如下的这个代码块:
DB::connection()->enableQueryLog();
$sql=DB::getQueryLog();
dump($sql);
具体的使用方法如下所示,我们只需要将查询构造器中的SQL放入到上面这个代码块的第一和第二行代码之间,然后运行程序即可输出原生sql.
DB::connection()->enableQueryLog();
//查询评论信息
$data = DB::table('ysbt_order_comments as a')
->leftjoin('ysbt_orders as c','a.order_id','=','c.order_id')
->leftjoin('sky_user_data_master.user_base_info as d','c.seller_id','=','d.user_id')
->leftjoin('sky_user_data_master.user_version_info as e','c.seller_id','=','e.user_id')
->select('a.votes','a.content','a.created_at','d.user_name','e.thumbnail_image_url')
->where('a.order_id',$order_id)
->first();
$sql=DB::getQueryLog();
dump($sql);
运行程序后,通过上面的这种方式得到的最终结果如下所示:
得到的最终查看结果如下所示:
select `a`.`votes`, `a`.`content`, `a`.`created_at`, `d`.`user_name`, `e`.`thumbnail_image_url`
from `ysbt_order_comments` as `a`
left join `ysbt_orders` as `c` on `a`.`order_id` = `c`.`order_id`
left join `sky_user_data_master`.`user_base_info` as `d` on `c`.`seller_id` = `d`.`user_id`
left join `sky_user_data_master`.`user_version_info` as `e` on `c`.`seller_id` = `e`.`user_id`
where `a`.`order_id` = '243221473235558460'
limit 1;
到此为止就结束了!~
(2)第二种laravel框架查看原生的sql
//把下面这行代码放到路由文件(route.php)中的时候,当运行相关接口的时候,把把该接口里面涉及到的所有sql语句打印到输出页面上
Event::listen('illuminate.query',function($query){
var_dump($query);
});
//前提是你需要在你接口里面打印输出返回结果才显示,如下所示:
var_dump(result);