forked from kormoc/Query-Digest-UI
/
explain.php
94 lines (82 loc) · 3.65 KB
/
explain.php
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
<?php
require_once('init.php');
$return = array();
if (strlen($reviewhost['history_table'])) {
$where = '';
if (isset($_REQUEST['primary']) && count($_REQUEST['primary']) > 0) {
foreach( $_REQUEST['primary'] AS $field => $value)
$where .= ' AND '.Database::escapeField($field).' = '.Database::find('review')->escape_string($value);
}
$query = Database::find('review')->query_col('SELECT review.sample
FROM '.Database::escapeField($reviewhost['history_table']).' AS review
WHERE review.checksum = ? '.$where.'
ORDER BY review.ts_max DESC
LIMIT 1',
$_REQUEST['checksum']
);
}
else {
$query = Database::find('review')->query_col('SELECT review.sample
FROM '.Database::escapeField($reviewhost['review_table']).' AS review
WHERE review.checksum = ?',
$_REQUEST['checksum']
);
}
$Query = new QueryRewrite();
$Query->setQuery($query);
$sample = $Query->asExtendedExplain();
$return['QueryRewrite'] = (array) $Query;
$return['oQuery'] = $query;
$return['eQuery'] = $sample;
$return['_REQUEST'] = $_REQUEST;
if (is_null($sample)) {
$return['Warnings'][] = array('Code' => '0', 'Level' => 'Error', 'Message' => "I can't explain this type of query yet");
}
else {
list($label, $database) = explode('`.`', $_REQUEST['explainDb']);
$label = str_replace('`', '', $label);
$database = str_replace('`', '', $database);
$host = $explainhosts[$label];
Database::connect(null, $host['user'], $host['password'], null, null, 'pdo', array('dsn' => $host['dsn']), $label);
Database::find($label)->query('USE '.Database::escapeField($database));
Database::find($label)->disable_fatal_errors();
$query = @Database::find($label)->query($sample);
Database::find($label)->enable_fatal_errors();
if (!is_null($query)) {
while ($row = $query->fetch_assoc()) {
$row['possible_keys'] = str_replace(',', ', ', $row['possible_keys']);
$row['ref'] = str_replace(',', ', ', $row['ref']);
$row['Extra'] = str_replace(array('Using ', ';'), array('', ', '), $row['Extra']);
foreach ($row as $key => $val) {
if (is_null($row[$key]))
$row[$key] = '';
$row[$key] = htmlentities($row[$key]);
}
$return['Explain'][] = $row;
}
}
$query = Database::find($label)->query('SHOW WARNINGS');
while ($row = $query->fetch_assoc()) {
if ($row['Code'] == 1003)
$return['Query'] = str_replace(',', ', ', $row['Message']);
else
$return['Warnings'][] = $row;
}
if (array_key_exists('Query', $return)) {
$return['Query'] = preg_replace("/`([-_a-zA-Z0-9]+)`\.`([-_a-zA-Z0-9]+)`\.`([-_a-zA-Z0-9]+)`/U",
" <a class=\"database\" onclick=\"lookupDatabase ('$label', '\${1}')\">`\${1}`</a>"
.".<a class=\"table\" onclick=\"lookupTable ('$label', '\${1}', '\${2}')\">`\${2}`</a>"
.".<a class=\"column\" onclick=\"lookupCol ('$label', '\${1}', '\${2}', '\${3}')\">`\${3}`</a>",
$return['Query']
);
$return['Query'] = preg_replace("/`([-_a-zA-Z0-9]+)`\.`([-_a-zA-Z0-9]+)`/U",
" <a class=\"database\" onclick=\"lookupDatabase ('$label', '\${1}')\">`\${1}`</a>"
.".<a class=\"table\" onclick=\"lookupTable ('$label', '\${1}', '\${2}')\">`\${2}`</a>",
$return['Query']
);
}
}
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
header('Content-type: application/json');
echo json_encode($return);