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
  ]
]