1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
| <?php
namespace App\Http\Middleware;
use Carbon\Carbon;
use Illuminate\Support\Facades\DB;
use Monolog\Formatter\LineFormatter;
use Monolog\Handler\RotatingFileHandler;
use Monolog\Handler\StreamHandler;
use Monolog\Logger;
/**
* Class QueryDebugMiddleware
* @package App\Http\Middleware
*
*/
class QueryDebugMiddleware
{
public function handle($request, \Closure $next)
{
$logger = app('customer_logger');
DB::listen(function ($query) use ($logger) {
$caller = $this->getCallerInfo();
$file = $caller['file'];
$line = $caller['line'];
// 在这里进行自定义的记录逻辑，例如使用日志记录
$logger->info('SQL Query', [
'fullSql' => vsprintf(str_replace('?', "'%s'", $query->sql), $query->bindings),
'time' => $query->time,
'file' => $file,
'line' => $line,
]);
});
return $next($request);
}
protected function getCallerInfo()
{
$queryFiles = [
'Illuminate/Database/',
];
$traces = collect(debug_backtrace())->pluck('line', 'file');
$start = false;
$end = true;
foreach ($traces as $file => $line) {
if (!$start) {
$start = collect($queryFiles)->contains(function ($value) use ($file) {
return strpos($file, $value) !== false;
});
} else {
$end = collect($queryFiles)->contains(function ($value) use ($file) {
return strpos($file, $value) !== false;
});
}
if (!$end && $file && $line) {
return [
'file' => $file,
'line' => $line,
];
}
}
return [
'file' => 'Unknown',
'line' => 'Unknown',
];
}
}
|
