1234567891011121314151617181920212223242526272829303132333435363738 |
- <?php
- namespace App\Http\Middleware;
- use Closure;
- use Illuminate\Support\Facades\DB;
- class SqlMiddleware
- {
- /**
- * Handle an incoming request.
- *
- * @param \Illuminate\Http\Request $request
- * @param \Closure $next
- * @return mixed
- */
- public function handle($request, Closure $next)
- {
- if ($request->sql_debug==1) {
- DB::connection()->enableQueryLog();
- }
- $response = $next($request);
- if ($request->get('sql_debug')) {
- $queries = DB::getQueryLog();
- if (!empty($queries)) {
- foreach ($queries as &$query) {
- $query['full_query'] = vsprintf(str_replace('?', '%s', $query['query']), $query['bindings']);
- }
- }
- dd($queries);exit;
- }
- return $response;
- }
- }
|