SQLServiceProvider.php 897 B

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. namespace App\Providers;
  3. use DB;
  4. use Illuminate\Routing\Route;
  5. use Illuminate\Support\ServiceProvider;
  6. use Log;
  7. use Illuminate\Http\Request;
  8. class SQLServiceProvider extends ServiceProvider
  9. {
  10. /**
  11. * Bootstrap the application services.
  12. *
  13. * @return void
  14. */
  15. public function boot(Request $request)
  16. {
  17. DB::listen(function ($query) use($request) {
  18. try{
  19. //$sql_mode = str_replace('?','%s',$query->sql);
  20. //$sql = vsprintf($sql_mode,$query->bindings);
  21. //Log::info('TIME:'.$query->time.'--SQL:'.$sql.'----route:'.$request->url());
  22. }catch (\Exception $e){
  23. Log::info($e);
  24. }
  25. });
  26. }
  27. /**
  28. * Register the application services.
  29. *
  30. * @return void
  31. */
  32. public function register()
  33. {
  34. //
  35. }
  36. }