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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
|
<?php declare(strict_types = 1);
/**
* Raw database query output.
*
* @package query-monitor
*/
class QM_Output_Raw_DB_Queries extends QM_Output_Raw {
/**
* Collector instance.
*
* @var QM_Collector_DB_Queries Collector.
*/
protected $collector;
/**
* @var int
*/
public $query_row = 0;
/**
* @return string
*/
public function name() {
return __( 'Database Queries', 'query-monitor' );
}
/**
* @return array<string, mixed>
* @phpstan-return array{
* total: int,
* time: float,
* queries: mixed[],
* errors?: array{
* total: int,
* errors: array<int, array<string, mixed>>,
* },
* dupes?: array{
* total: int,
* queries: array<string, int[]>,
* },
* }|array{}
*/
public function get_output() {
/** @var QM_Data_DB_Queries $data */
$data = $this->collector->get_data();
if ( empty( $data->rows ) ) {
return array();
}
$output = array(
'total' => $data->total_qs,
'time' => round( $data->total_time, 4 ),
'queries' => array_map( array( $this, 'output_query_row' ), $data->rows ),
);
if ( ! empty( $data->errors ) ) {
$output['errors'] = array(
'total' => count( $data->errors ),
'errors' => $data->errors,
);
}
if ( ! empty( $data->dupes ) ) {
$dupes = $data->dupes;
// Filter out SQL queries that do not have dupes
$dupes = array_filter( $dupes, array( $this->collector, 'filter_dupe_items' ) );
// Ignore dupes from `WP_Query->set_found_posts()`
unset( $dupes['SELECT FOUND_ROWS()'] );
$output['dupes'] = array(
'total' => count( $dupes ),
'queries' => $dupes,
);
}
return $output;
}
/**
* @param array<string, mixed> $row
* @return array<string, mixed>
*/
protected function output_query_row( array $row ) {
$output = array();
$output['i'] = ++$this->query_row;
$output['sql'] = $row['sql'];
$output['time'] = round( $row['ltime'], 4 );
if ( isset( $row['trace'] ) ) {
$stack = array();
$filtered_trace = $row['trace']->get_filtered_trace();
foreach ( $filtered_trace as $item ) {
$stack[] = $item['display'];
}
} else {
$stack = $row['stack'];
}
$output['stack'] = $stack;
$output['result'] = $row['result'];
return $output;
}
}
/**
* @param array<string, QM_Output> $output
* @param QM_Collectors $collectors
* @return array<string, QM_Output>
*/
function register_qm_output_raw_db_queries( array $output, QM_Collectors $collectors ) {
$collector = QM_Collectors::get( 'db_queries' );
if ( $collector ) {
$output['db_queries'] = new QM_Output_Raw_DB_Queries( $collector );
}
return $output;
}
add_filter( 'qm/outputter/raw', 'register_qm_output_raw_db_queries', 20, 2 );
|