SELECT * FROM `x$statements_with_sorting`
|
query | db | exec_count | total_latency | sort_merge_passes | avg_sort_merges | sorts_using_scans | sort_using_range | rows_sorted | avg_rows_sorted | first_seen | last_seen | digest | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... | sys | 12 | 1109779898000 | 8 | 1 | 24 | 0 | 5551 | 463 | 2024-09-27 15:01:04.243638 | 2024-09-27 15:03:53.038144 | bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | 1928 | 941963367000 | 0 | 0 | 764 | 0 | 25227 | 13 | 2024-09-27 15:00:54.761949 | 2024-09-27 15:05:06.248424 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | information_schema | 3081 | 920824217000 | 0 | 0 | 382 | 0 | 12768 | 4 | 2024-09-27 15:00:54.866399 | 2024-09-27 15:05:06.377249 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | 1292 | 728247937000 | 0 | 0 | 580 | 0 | 18478 | 14 | 2024-09-27 15:00:54.660103 | 2024-09-27 15:05:06.358530 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 800 | 706967196000 | 0 | 0 | 559 | 0 | 25585 | 32 | 2024-09-27 15:00:54.615807 | 2024-09-27 15:05:06.434143 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 440 | 662555758000 | 0 | 0 | 306 | 0 | 632 | 1 | 2024-09-27 15:00:54.652287 | 2024-09-27 15:05:06.424655 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | 636 | 635380237000 | 0 | 0 | 481 | 0 | 14870 | 23 | 2024-09-27 15:00:54.717354 | 2024-09-27 15:05:06.389305 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 125 | 607172086000 | 0 | 0 | 101 | 0 | 198 | 2 | 2024-09-27 15:00:56.752675 | 2024-09-27 15:05:03.682823 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | information_schema | 752 | 548152114000 | 0 | 0 | 353 | 0 | 7159 | 10 | 2024-09-27 15:00:54.772109 | 2024-09-27 15:05:06.346494 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 570 | 470392858000 | 0 | 0 | 277 | 0 | 371 | 1 | 2024-09-27 15:00:54.704862 | 2024-09-27 15:05:06.433198 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 455 | 418799381000 | 0 | 0 | 343 | 0 | 18924 | 42 | 2024-09-27 15:00:54.911668 | 2024-09-27 15:05:05.113735 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | 912 | 412414630000 | 0 | 0 | 344 | 0 | 11614 | 13 | 2024-09-27 15:00:54.979769 | 2024-09-27 15:05:05.180917 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | fearzonedbs | 37 | 399480553000 | 0 | 0 | 18 | 0 | 318 | 9 | 2024-09-27 15:02:54.987085 | 2024-09-27 15:04:36.294029 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... | sys | 15 | 321628149000 | 0 | 0 | 20 | 0 | 900 | 60 | 2024-09-27 15:01:23.360818 | 2024-09-27 15:04:31.176432 | 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 501 | 279065530000 | 0 | 0 | 173 | 0 | 173 | 0 | 2024-09-27 15:00:54.909609 | 2024-09-27 15:05:05.192664 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 122 | 211438986000 | 0 | 0 | 35 | 0 | 35 | 0 | 2024-09-27 15:00:56.627238 | 2024-09-27 15:05:03.756902 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | weebsite | 300 | 160387624000 | 0 | 0 | 128 | 0 | 4474 | 15 | 2024-09-27 15:02:08.136701 | 2024-09-27 15:05:03.213174 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 282 | 140378917000 | 0 | 0 | 172 | 0 | 492 | 2 | 2024-09-27 15:00:54.913002 | 2024-09-27 15:05:05.107228 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | weebsite | 217 | 140302597000 | 0 | 0 | 113 | 0 | 76 | 0 | 2024-09-27 15:02:08.084459 | 2024-09-27 15:05:03.228150 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 206 | 127866794000 | 0 | 0 | 72 | 0 | 636 | 3 | 2024-09-27 15:00:56.640850 | 2024-09-27 15:05:03.691299 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `extract_schema_from_file_name` ( `performa... | sys | 13 | 117603147000 | 0 | 0 | 9 | 0 | 980 | 75 | 2024-09-27 15:01:04.543932 | 2024-09-27 15:04:50.931132 | bd914fd84f93d2b27f3871dfcd403dfa26335a4f26eda232ed... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | sakila | 211 | 94333692000 | 0 | 0 | 74 | 0 | 2442 | 12 | 2024-09-27 15:00:56.822079 | 2024-09-27 15:05:03.744939 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `c` . `name` AS `category` , SUM ( `p` . `a... | sakila | 2 | 75907811000 | 0 | 0 | 1 | 0 | 16 | 8 | 2024-09-27 15:01:49.409896 | 2024-09-27 15:01:49.567037 | a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | loja_online | 98 | 52988795000 | 0 | 0 | 48 | 0 | 1652 | 17 | 2024-09-27 15:02:32.032638 | 2024-09-27 15:03:29.134197 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | sys | 88 | 42000292000 | 0 | 0 | 34 | 0 | 1120 | 13 | 2024-09-27 15:01:03.465274 | 2024-09-27 15:04:50.886603 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... |
|
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