/** * Bootstrap the application services. * * @return void */ public function boot() { // If we are in debug mode, listen to database events // and log queries to the log file. if (env('DB_DEBUG', false)) { DB::listen(function ($query) { $positional = 0; $full_query = ''; foreach (str_split($query->sql) as $char) { if ($char === '?') { $full_query = $full_query . '"' . $query->bindings[$positional] . '"'; $positional++; } else { $full_query = $full_query . $char; } } logger()->debug(' ---> QUERY DEBUG: ' . $full_query . ' <---'); }); } $this->publishes([__DIR__ . '/database/migrations/' => database_path('migrations')]); }
/** * Bootstrap any application services. * * 这里面能做很多跟监控有关的事情 * * @return void */ public function boot() { // 监听数据库查询 打印LOG DB::listen(function ($sql, $bindings, $time) { Log::info('query db' . $sql . ' and the time is ' . $time); }); }
/** * Bootstrap any application services. * * @return void */ public function boot() { $monolog = Log::getMonolog(); $monolog->pushHandler(new LDTHandler()); DB::listen(function ($query) { \DPodsiadlo\LDT\Facades\LDT::query($query); }); }
private function logDb() { if (env('APP_DEBUG') === true) { DB::listen(function ($sql, $bindings, $time) { $monolog = new Logger('log'); $monolog->pushHandler(new StreamHandler($this->dbLogStoragePath), Logger::INFO); $monolog->info($sql, compact('bindings', 'time')); }); } }
public function register() { $log = new Logger('db'); $log->pushHandler(new StreamHandler(storage_path() . '/logs/laravel-db.log')); DB::listen(function ($sql, $bindings, $time) use($log) { $sql = str_replace(['%', '?'], ['%%', '%s'], $sql); $full_sql = vsprintf($sql, $bindings); //echo PHP_EOL.'- BEGIN QUERY -'.PHP_EOL.$full_sql.PHP_EOL.'- END QUERY -'.PHP_EOL; $log->addInfo($full_sql); }); }
/** * Bootstrap any application services. * * @return void */ public function boot() { view()->composer('home', function ($view) { //$viewData = $view->getData(); //$charts = Location::findOrFail($viewData['']->charts); //$view->with('charts', Location::first()->charts); }); // Logs all SQL queries DB::listen(function ($sql, $bindings, $time) { Log::info($sql); }); }
protected function bootWhenLocal() { //开发环境 if (!$this->app->isLocal()) { return; } //日志 $logger = Log::getMonolog(); $logger->pushHandler(new BrowserConsoleHandler()); //DB事件 DB::listen(function ($query) { Log::info('sql :' . $query->sql, ['binding' => $query->bindings, 'time' => $query->time]); }); }