SELECT * FROM `events_statements_summary_by_digest`
|
SCHEMA_NAME | DIGEST | DIGEST_TEXT | COUNT_STAR | SUM_TIMER_WAIT | MIN_TIMER_WAIT | AVG_TIMER_WAIT | MAX_TIMER_WAIT | SUM_LOCK_TIME | SUM_ERRORS | SUM_WARNINGS | SUM_ROWS_AFFECTED | SUM_ROWS_SENT | SUM_ROWS_EXAMINED | SUM_CREATED_TMP_DISK_TABLES | SUM_CREATED_TMP_TABLES | SUM_SELECT_FULL_JOIN | SUM_SELECT_FULL_RANGE_JOIN | SUM_SELECT_RANGE | SUM_SELECT_RANGE_CHECK | SUM_SELECT_SCAN | SUM_SORT_MERGE_PASSES | SUM_SORT_RANGE | SUM_SORT_ROWS | SUM_SORT_SCAN | SUM_NO_INDEX_USED | SUM_NO_GOOD_INDEX_USED | FIRST_SEEN | LAST_SEEN | QUANTILE_95 | QUANTILE_99 | QUANTILE_999 | QUERY_SAMPLE_TEXT | QUERY_SAMPLE_SEEN | QUERY_SAMPLE_TIMER_WAIT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NULL | 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... | SELECT @@`skip_networking` , @@`skip_name_resolve`... | 1 | 3182001000 | 3182001000 | 3182001000 | 3182001000 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:47.824535 | 2024-09-27 15:00:47.824535 | 3311311214 | 3311311214 | 3311311214 | SELECT @@skip_networking, @@skip_name_resolve, @@h... | 2024-09-27 15:00:47.824535 | 3182001000 | |
NULL | a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... | SELECT @@`version` , @@`version_comment` | 5475 | 604808785000 | 30170000 | 110467000 | 538424000 | 0 | 0 | 0 | 0 | 5475 | 5475 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.580508 | 2024-09-27 15:14:56.745941 | 239883291 | 288403150 | 346736850 | SELECT @@version, @@version_comment | 2024-09-27 15:14:11.128668 | 335744000 | |
NULL | 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... | SET NAMES ? COLLATE ? | 5475 | 354383925000 | 16483000 | 64727000 | 251862000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.580663 | 2024-09-27 15:14:56.746055 | 151356124 | 181970085 | 229086765 | SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' | 2024-09-27 15:14:24.101522 | 198351000 | |
NULL | 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... | SET `lc_messages` = ? | 5326 | 384261690000 | 15264000 | 72148000 | 12640886000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.580752 | 2024-09-27 15:14:56.746126 | 151356124 | 181970085 | 5248074602 | SET lc_messages = 'da_DK' | 2024-09-27 15:14:49.456546 | 184615000 | |
NULL | f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... | SHOW TABLES FROM `phpmyadmin` | 5476 | 1171682122000 | 69539000 | 213966000 | 953482000 | 474787000000 | 5476 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.581614 | 2024-09-27 15:14:56.746385 | 457088189 | 549540873 | 691830970 | SHOW TABLES FROM `phpmyadmin` | 2024-09-27 15:14:22.498600 | 546094000 | |
NULL | d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... | SET `collation_connection` = ? | 5475 | 358164449000 | 17661000 | 65418000 | 1170711000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.582716 | 2024-09-27 15:14:56.747373 | 158489319 | 190546071 | 251188643 | SET collation_connection = 'utf8mb4_unicode_ci' | 2024-09-27 15:14:30.860174 | 470486000 | |
NULL | caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... | SELECT ? FROM `mysql` . `user` LIMIT ? | 4728 | 667174329000 | 47131000 | 141111000 | 19341868000 | 328898000000 | 0 | 0 | 0 | 4728 | 4728 | 0 | 0 | 0 | 0 | 0 | 0 | 4728 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.599207 | 2024-09-27 15:14:56.763646 | 208929613 | 316227766 | 549540873 | SELECT 1 FROM mysql.user LIMIT 1 | 2024-09-27 15:14:25.004572 | 602951000 | |
NULL | ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... | SELECT SCHEMA ( ) | 2830 | 126106322000 | 13261000 | 44560000 | 473503000 | 0 | 0 | 0 | 0 | 2830 | 2830 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.600094 | 2024-09-27 15:14:56.764386 | 66069344 | 87096358 | 131825673 | SELECT DATABASE() | 2024-09-27 15:14:23.749387 | 101960000 | |
mysql | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | SHOW SESSION VARIABLES LIKE ? | 2097 | 1764936851000 | 624149000 | 841648000 | 5279970000 | 185308000000 | 0 | 0 | 0 | 2097 | 1203678 | 0 | 2097 | 0 | 0 | 0 | 0 | 4194 | 0 | 0 | 0 | 0 | 2097 | 0 | 2024-09-27 15:00:54.605777 | 2024-09-27 15:14:54.412224 | 1202264434 | 1737800828 | 2754228703 | SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' | 2024-09-27 15:14:16.674384 | 1729373000 | |
mysql | ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... | SELECT * FROM `user` LIMIT ?, ... | 929 | 167841590000 | 112826000 | 180669000 | 827347000 | 58439000000 | 0 | 0 | 0 | 6195 | 6195 | 0 | 0 | 0 | 0 | 0 | 0 | 929 | 0 | 0 | 0 | 0 | 929 | 0 | 2024-09-27 15:00:54.606407 | 2024-09-27 15:14:54.346917 | 263026799 | 331131121 | 831763771 | SELECT * FROM `user` LIMIT 0, 25 | 2024-09-27 15:13:54.757483 | 443639000 | |
mysql | 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... | SHOW WARNINGS | 1010 | 31354811000 | 13230000 | 31044000 | 174144000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.606743 | 2024-09-27 15:14:54.347299 | 43651583 | 60255958 | 72443596 | SHOW WARNINGS | 2024-09-27 15:14:35.532082 | 61332000 | |
mysql | 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... | SELECT @@`lower_case_table_names` | 1208 | 56602445000 | 21836000 | 46856000 | 142064000 | 0 | 0 | 0 | 0 | 1208 | 1208 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.607086 | 2024-09-27 15:14:55.588652 | 69183097 | 91201083 | 131825673 | SELECT @@lower_case_table_names | 2024-09-27 15:14:46.586803 | 142064000 | |
mysql | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 10920 | 1765005429000 | 70521000 | 161630000 | 4748683000 | 239213000000 | 9759 | 0 | 0 | 0 | 3481 | 0 | 0 | 0 | 0 | 0 | 0 | 1161 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.611935 | 2024-09-27 15:14:55.589800 | 363078054 | 524807460 | 1000000000 | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | 2024-09-27 15:14:13.754900 | 702540000 | |
mysql | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 2640 | 1377567622000 | 161805000 | 521805000 | 4226564000 | 242946000000 | 2016 | 0 | 0 | 25853 | 132546 | 0 | 559 | 0 | 0 | 0 | 0 | 624 | 0 | 0 | 25585 | 559 | 0 | 0 | 2024-09-27 15:00:54.615807 | 2024-09-27 15:14:55.560057 | 1258925411 | 1737800828 | 3467368504 | SHOW FULL COLUMNS FROM `mysql`.`user` | 2024-09-27 15:14:22.554263 | 1051400000 | |
NULL | 6737a4df618b229813d6fbb82717cbe2f6df37f6b6c6694c53... | SHOW TABLES FROM `fearzonedbs` | 15 | 2434711000 | 91033000 | 162314000 | 686618000 | 1126000000 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.643007 | 2024-09-27 15:01:45.403390 | 691830970 | 691830970 | 691830970 | SHOW TABLES FROM `fearzonedbs` | 2024-09-27 15:00:54.643007 | 686618000 | |
NULL | 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... | SELECT CURRENT_USER ( ) | 1724 | 117131880000 | 19087000 | 67941000 | 540129000 | 0 | 0 | 0 | 0 | 1724 | 1724 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.649973 | 2024-09-27 15:14:56.291670 | 173780082 | 199526231 | 288403150 | SELECT CURRENT_USER() | 2024-09-27 15:14:36.201924 | 183644000 | |
NULL | 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... | SHOW GRANTS | 917 | 92896495000 | 41444000 | 101304000 | 506163000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.650935 | 2024-09-27 15:14:56.291816 | 239883291 | 288403150 | 524807460 | SHOW GRANTS | 2024-09-27 15:14:52.029092 | 289564000 | |
mysql | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 1869 | 979065838000 | 152828000 | 523844000 | 90268222000 | 115051000000 | 1563 | 0 | 0 | 632 | 17330 | 0 | 306 | 0 | 0 | 0 | 0 | 306 | 0 | 0 | 632 | 306 | 0 | 0 | 2024-09-27 15:00:54.652287 | 2024-09-27 15:14:54.350724 | 794328234 | 1096478196 | 83176377110 | SHOW INDEXES FROM `mysql`.`user` | 2024-09-27 15:14:49.270408 | 1445513000 | |
mysql | 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... | SHOW CREATE TABLE `mysql` . `user` | 1028 | 330391889000 | 124085000 | 321392000 | 131159647000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.656094 | 2024-09-27 15:14:54.351041 | 263026799 | 398107170 | 12022644346 | SHOW CREATE TABLE `mysql`.`user` | 2024-09-27 15:14:02.824533 | 314499000 | |
NULL | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | 4072 | 1194311060000 | 72816000 | 293298000 | 8310430000 | 247387000000 | 3095 | 0 | 0 | 9926 | 64477 | 0 | 2244 | 1345 | 0 | 0 | 0 | 2244 | 0 | 0 | 18478 | 580 | 977 | 0 | 2024-09-27 15:00:54.660103 | 2024-09-27 15:14:56.315308 | 954992586 | 1584893192 | 3801893963 | SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... | 2024-09-27 15:14:39.705761 | 562334000 | |
mysql | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 3789 | 1366013420000 | 190661000 | 360520000 | 37121886000 | 119931000000 | 3512 | 0 | 0 | 371 | 46352 | 0 | 274 | 226 | 0 | 0 | 0 | 277 | 0 | 0 | 371 | 277 | 226 | 0 | 2024-09-27 15:00:54.704862 | 2024-09-27 15:14:55.589504 | 794328234 | 1380384264 | 13803842646 | SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAM... | 2024-09-27 15:14:16.797157 | 1725335000 | |
NULL | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 1270 | 260934413000 | 82200000 | 205460000 | 1504092000 | 64222000000 | 980 | 0 | 0 | 0 | 318 | 0 | 0 | 0 | 0 | 0 | 0 | 290 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.715869 | 2024-09-27 15:14:56.328175 | 457088189 | 575439937 | 870963589 | SELECT 1 FROM information_schema.VIEWS WHERE TABLE... | 2024-09-27 15:14:43.728531 | 245257000 | |
NULL | 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... | SELECT @@`lower_case_table_names` | 613 | 34750898000 | 28551000 | 56689000 | 255858000 | 0 | 0 | 0 | 0 | 613 | 613 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.716204 | 2024-09-27 15:14:56.326913 | 158489319 | 199526231 | 263026799 | SELECT @@lower_case_table_names | 2024-09-27 15:14:30.870684 | 163258000 | |
NULL | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | 2067 | 1233682558000 | 188444000 | 596846000 | 18332015000 | 280224000000 | 1586 | 0 | 0 | 14870 | 51170 | 0 | 172 | 168 | 0 | 0 | 0 | 481 | 0 | 0 | 14870 | 481 | 168 | 0 | 2024-09-27 15:00:54.717354 | 2024-09-27 15:14:56.595428 | 1318256738 | 3019951720 | 15135612484 | SHOW TABLES FROM `information_schema` | 2024-09-27 15:14:29.985536 | 1482571000 | |
NULL | 359f6bd78d51dcc8b66e843aa1e1fe857dbeb83505a8f51958... | SHOW TABLE STATUS FROM `fearzonedbs` WHERE `Name` ... | 152 | 16944574000 | 70963000 | 111477000 | 666046000 | 9175000000 | 152 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2024-09-27 15:00:54.717802 | 2024-09-27 15:02:33.454266 | 151356124 | 229086765 | 691830970 | SHOW TABLE STATUS FROM `fearzonedbs` WHERE `Name` ... | 2024-09-27 15:02:33.454266 | 104585000 |
|
Warning in ./src/Table/Table.php#291
Undefined array key "Create_time"Backtrace
Warning in ./src/Table/Table.php#291
Undefined array key "TABLE_COMMENT"Backtrace