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 | 52 | 3251547096000 | 38 | 1 | 114 | 0 | 33301 | 640 | 2024-09-27 15:01:04.243638 | 2024-09-27 15:09:21.629210 | bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | 4782 | 1337451888000 | 0 | 0 | 764 | 0 | 25227 | 5 | 2024-09-27 15:00:54.761949 | 2024-09-27 15:11:45.537345 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 2025 | 1157951378000 | 0 | 0 | 559 | 0 | 25585 | 13 | 2024-09-27 15:00:54.615807 | 2024-09-27 15:11:45.431279 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | information_schema | 4550 | 1122311852000 | 0 | 0 | 382 | 0 | 12768 | 3 | 2024-09-27 15:00:54.866399 | 2024-09-27 15:11:46.971103 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 2668 | 1052522169000 | 0 | 0 | 277 | 0 | 371 | 0 | 2024-09-27 15:00:54.704862 | 2024-09-27 15:11:45.558326 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | 3179 | 1048140900000 | 0 | 0 | 580 | 0 | 18478 | 6 | 2024-09-27 15:00:54.660103 | 2024-09-27 15:11:46.524671 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | 1510 | 1003824828000 | 0 | 0 | 481 | 0 | 14870 | 10 | 2024-09-27 15:00:54.717354 | 2024-09-27 15:11:46.909729 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 2607 | 875936732000 | 0 | 0 | 173 | 0 | 173 | 0 | 2024-09-27 15:00:54.909609 | 2024-09-27 15:11:47.081074 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 1375 | 866678506000 | 0 | 0 | 306 | 0 | 632 | 0 | 2024-09-27 15:00:54.652287 | 2024-09-27 15:11:45.411782 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 1180 | 669775473000 | 0 | 0 | 343 | 0 | 18924 | 16 | 2024-09-27 15:00:54.911668 | 2024-09-27 15:11:46.989311 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 233 | 631646172000 | 0 | 0 | 101 | 0 | 198 | 1 | 2024-09-27 15:00:56.752675 | 2024-09-27 15:11:46.403605 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | information_schema | 930 | 612944048000 | 0 | 0 | 353 | 0 | 7159 | 8 | 2024-09-27 15:00:54.772109 | 2024-09-27 15:11:45.249415 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | 2363 | 604566957000 | 0 | 0 | 344 | 0 | 11614 | 5 | 2024-09-27 15:00:54.979769 | 2024-09-27 15:11:47.069127 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... | sys | 27 | 563347646000 | 0 | 0 | 36 | 0 | 1612 | 60 | 2024-09-27 15:01:23.360818 | 2024-09-27 15:11:16.810637 | 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... | |
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 `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 522 | 322265440000 | 0 | 0 | 35 | 0 | 35 | 0 | 2024-09-27 15:00:56.627238 | 2024-09-27 15:11:46.468882 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `extract_schema_from_file_name` ( `performa... | sys | 33 | 300146294000 | 0 | 0 | 24 | 0 | 3122 | 95 | 2024-09-27 15:01:04.543932 | 2024-09-27 15:11:18.200291 | bd914fd84f93d2b27f3871dfcd403dfa26335a4f26eda232ed... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 1002 | 298231667000 | 0 | 0 | 172 | 0 | 492 | 0 | 2024-09-27 15:00:54.913002 | 2024-09-27 15:11:46.980257 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 494 | 215151493000 | 0 | 0 | 72 | 0 | 636 | 1 | 2024-09-27 15:00:56.640850 | 2024-09-27 15:11:46.411665 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | weebsite | 311 | 161896657000 | 0 | 0 | 128 | 0 | 4474 | 14 | 2024-09-27 15:02:08.136701 | 2024-09-27 15:05:14.475042 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | weebsite | 237 | 146289075000 | 0 | 0 | 113 | 0 | 76 | 0 | 2024-09-27 15:02:08.084459 | 2024-09-27 15:06:45.567210 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | sakila | 553 | 138986623000 | 0 | 0 | 74 | 0 | 2442 | 4 | 2024-09-27 15:00:56.822079 | 2024-09-27 15:11:46.456699 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `c` . `name` AS `category` , SUM ( `p` . `a... | sakila | 4 | 127463697000 | 0 | 0 | 2 | 0 | 32 | 8 | 2024-09-27 15:01:49.409896 | 2024-09-27 15:11:13.886055 | a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | sys | 231 | 61121553000 | 0 | 0 | 34 | 0 | 1120 | 5 | 2024-09-27 15:01:03.465274 | 2024-09-27 15:11:36.874318 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | loja_online | 102 | 53776129000 | 0 | 0 | 48 | 0 | 1652 | 16 | 2024-09-27 15:02:32.032638 | 2024-09-27 15:05:48.800995 | 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