laravel 打印完整sql语句

1.使用toSql()方法#

2.用DB自带的getQueryLog方法直接打印：

use Illuminate\Support\Facades\DB;
 
 DB::connection()->enableQueryLog();  // 开启QueryLog
 \App\User::find(1);
 dump(DB::getQueryLog());exit;

得到的结果语句与参数是分开的，非常不方便验证

array:1 [
   0 => array:3 [
     "query" => "select * from `fook_platform_ordercode` where `fook_platform_ordercode`.`id` = ? limit 1"
     "bindings" => array:1 [
       0 => 1
     ]
     "time" => 11.47
   ]
 ]

(推荐使用)打印出完整的sql语句，可将以下代码复制到AppServiceProvider中的boot方法中：

 \DB::listen(
     function ($sql) {
         foreach ($sql->bindings as $i => $binding) {