larave8中添加sql运行日志

在app/Providers/EventServiceProvider.php的boot方法中加入监听：

public function boot()
    {
        try{
            if (env('APP_DEBUG_SQL') == true) {
                DB::listen(function ($query) {
                    $tmp = str_replace('?', '"'.'%s'.'"', $query->sql);
                    $arrBindings = [];
                    foreach ($query->bindings as $key => $value) {
                        if (is_numeric($key)) {
                            $arrBindings[] = $value;
                        } else {
                            $tmp = str_replace(':'.$key, '"'.$value.'"', $tmp);
                        }
                    }
                    if($arrBindings){
                        $tmp = vsprintf($tmp, $arrBindings);
                        $tmp = str_replace("\\", "", $tmp);
                    }
                    $logFile = fopen(
                        storage_path('logs' . DIRECTORY_SEPARATOR . date('Y-m-d') . '_query.log'),
                        'a+'
                    );
                    $strShowLog='--------------------------------------------------------------------start'. PHP_EOL;
                    $strShowLog.=date('Y-m-d H:i:s') . ': ' . ' '.Request::url(). ' '.Common::get_real_ip() . PHP_EOL;
                    $strShowLog.=date('Y-m-d H:i:s') . ': ' . ' execution time: '.$query->time.'ms; '.$tmp . PHP_EOL;
                    $strShowLog.='--------------------------------------------------------------------end'. PHP_EOL;
                    fwrite($logFile, $strShowLog);
                    fclose($logFile);
                });
            }else{
                //关闭debug不记录sql
            }
        }catch (\Exception $e){
            //异常继续
        }
    }