Laravel 打印生成 Sql

  • 仅有?占位符sql,没有具体数据
    $sql = DB::table(‘car_data’)->select()->toSql();

  • 方法二:可查看具体绑定数据信息

DB::connection()->enableQueryLog();		//开启执行日志
DB::table('car_data')->insert($data);	
dd(DB::getQueryLog());					//获取具体日志信息

输出结果:

array:2 [
  0 => array:3 [
    "query" => "select * from `car_data` where `status` != ? and `humidity` between ? and ? and `temperature` between ? and ? and `pressure` between ? and ? and `catch_time` between ? and ? order by `catch_time` desc limit 20 offset 0"
    "bindings" => array:9 [
      0 => -1
      1 => 0
      2 => 100
      3 => -100
      4 => 200
      5 => 0
      6 => 200
      7 => "2019-05-14 16:00:00"
      8 => "2019-05-16 13:53:51"
    ]
    "time" => 631.04
  ]
  1 => array:3 [
    "query" => "select count(*) as aggregate from `car_data` where `status` != ? and `humidity` between ? and ? and `temperature` between ? and ? and `pressure` between ? and ? and `catch_time` between ? and ? limit 20 offset 0"
    "bindings" => array:9 [
      0 => -1
      1 => 0
      2 => 100
      3 => -100
      4 => 200
      5 => 0
      6 => 200
      7 => "2019-05-14 16:00:00"
      8 => "2019-05-16 13:53:51"
    ]
    "time" => 63.0
  ]
]
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值