Laravel技巧集錦（16）：使用DB::listen查找慢SQL

1、AppServiceProvider.php中

\DB::listen(function ($query){
           $sql = $query->sql;
           $bindings = $query->bindings;
           $time = $query->time;
            if($time>10){  //when time > 10 print
               \Log::debug(var_export(compact(['sql','bindings','time']),true));
            }
       });