SQLServiceProvider.php 924 B

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