|
@@ 58-61 (lines=4) @@
|
| 55 |
|
{ |
| 56 |
|
$data = Cache::get(config('laravel-query-adviser.cache.key'), []); |
| 57 |
|
|
| 58 |
|
if (isset($data[$request->get('time')][$request->get('time-key')])) { |
| 59 |
|
$query = $data[$request->get('time')][$request->get('time-key')]; |
| 60 |
|
return DB::connection()->select($query['sql'], $query['bindings']); |
| 61 |
|
} |
| 62 |
|
|
| 63 |
|
return []; |
| 64 |
|
} |
|
@@ 76-79 (lines=4) @@
|
| 73 |
|
public function explain(Request $request): array |
| 74 |
|
{ |
| 75 |
|
$data = Cache::get(config('laravel-query-adviser.cache.key'), []); |
| 76 |
|
if (isset($data[$request->get('time')][$request->get('time-key')])) { |
| 77 |
|
$query = $data[$request->get('time')][$request->get('time-key')]; |
| 78 |
|
return QueryBuilderHelper::analyze($query['sql'], $query['bindings']); |
| 79 |
|
} |
| 80 |
|
|
| 81 |
|
return ['queryParts' => "", 'query' => "", 'optimized' => ""]; |
| 82 |
|
} |