SELECT * FROM `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 `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... | mysql | 546 | 1.89 s | 0 | 0 | 470 | 0 | 946 | 2 | 2024-05-18 12:31:01.788234 | 2024-05-18 12:43:19.791037 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | mysql | 983 | 1.51 s | 0 | 0 | 678 | 0 | 9542 | 10 | 2024-05-18 12:31:01.813346 | 2024-05-18 12:43:19.857887 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATA ... database` ( `sc... | mysql | 2905 | 1.39 s | 0 | 0 | 1200 | 0 | 41348 | 14 | 2024-05-18 12:31:01.461886 | 2024-05-18 12:43:23.421200 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `concat` ( `c` . `city` ... cy` . `country`... | sakila | 50 | 1.31 s | 0 | 0 | 38 | 0 | 76 | 2 | 2024-05-18 12:41:27.887755 | 2024-05-18 12:41:50.359990 | e93a551af16493cd58cb06c9b4b21c3e15c6db7cb66f6c868e... | |
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... | sakila | 4 | 1.13 s | 0 | 0 | 4 | 0 | 800 | 200 | 2024-05-18 12:43:07.484188 | 2024-05-18 12:43:13.906864 | 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... | |
SELECT `cat` . `name` AS `CATA ... database` ( `sc... | NULL | 1610 | 1.10 s | 0 | 0 | 762 | 0 | 25828 | 16 | 2024-05-18 12:31:01.195622 | 2024-05-18 12:43:18.154198 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `c` . `name` AS `catego ... e` ORDER BY `to... | sakila | 28 | 943.73 ms | 0 | 0 | 21 | 0 | 336 | 12 | 2024-05-18 12:41:51.140607 | 2024-05-18 12:42:04.611445 | a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4... | |
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... | mysql | 898 | 819.53 ms | 0 | 0 | 606 | 0 | 11855 | 13 | 2024-05-18 12:31:01.406410 | 2024-05-18 12:43:23.399785 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | performance_schema | 915 | 675.36 ms | 0 | 0 | 251 | 0 | 557 | 1 | 2024-05-18 12:31:01.160984 | 2024-05-18 12:43:23.473997 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATA ... database` ( `sc... | performance_schema | 1427 | 584.92 ms | 0 | 0 | 494 | 0 | 16726 | 12 | 2024-05-18 12:31:01.244838 | 2024-05-18 12:43:23.184939 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... | performance_schema | 716 | 548.08 ms | 0 | 0 | 494 | 0 | 26818 | 37 | 2024-05-18 12:31:01.165016 | 2024-05-18 12:43:23.475682 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GR... | sys | 7 | 514.63 ms | 0 | 0 | 7 | 0 | 206 | 29 | 2024-05-18 12:33:47.841996 | 2024-05-18 12:42:33.678884 | 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... | |
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... | sys | 3 | 487.08 ms | 2 | 1 | 4 | 0 | 838 | 279 | 2024-05-18 12:37:34.518898 | 2024-05-18 12:37:34.673416 | ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | NULL | 308 | 388.17 ms | 0 | 0 | 245 | 0 | 2116 | 7 | 2024-05-18 12:31:01.385484 | 2024-05-18 12:43:18.166560 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | sakila | 485 | 282.32 ms | 0 | 0 | 10 | 0 | 10 | 0 | 2024-05-18 12:31:29.440115 | 2024-05-18 12:43:13.568683 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... | sakila | 91 | 279.67 ms | 0 | 0 | 9 | 0 | 21 | 0 | 2024-05-18 12:31:29.472042 | 2024-05-18 12:43:13.527839 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... | performance_schema | 473 | 226.71 ms | 0 | 0 | 251 | 0 | 739 | 2 | 2024-05-18 12:31:01.166375 | 2024-05-18 12:43:23.466719 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... | information_schema | 280 | 167.62 ms | 0 | 0 | 208 | 0 | 2624 | 9 | 2024-05-18 12:31:03.037015 | 2024-05-18 12:42:30.894296 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | Table_insertion | 25 | 144.16 ms | 0 | 0 | 23 | 0 | 41 | 2 | 2024-05-18 12:36:45.826653 | 2024-05-18 12:38:31.485810 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... | Table_insertion | 10 | 126.74 ms | 0 | 0 | 10 | 0 | 20 | 2 | 2024-05-18 12:37:34.619372 | 2024-05-18 12:38:31.452590 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | |
SELECT `t` . `THREAD_ID` AS `t ... T_NUMBER_OF_BYT... | sys | 4 | 122.57 ms | 0 | 0 | 6 | 0 | 272 | 68 | 2024-05-18 12:42:38.347131 | 2024-05-18 12:42:38.510488 | 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... | |
SELECT `cat` . `name` AS `CATA ... database` ( `sc... | information_schema | 241 | 103.53 ms | 0 | 0 | 80 | 0 | 2682 | 11 | 2024-05-18 12:31:03.064378 | 2024-05-18 12:43:08.460761 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | tec | 61 | 102.23 ms | 0 | 0 | 60 | 0 | 12 | 0 | 2024-05-18 12:33:08.996865 | 2024-05-18 12:39:38.926189 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... | world | 28 | 100.70 ms | 0 | 0 | 6 | 0 | 18 | 1 | 2024-05-18 12:36:33.113103 | 2024-05-18 12:43:22.591091 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `CATA ... database` ( `sc... | sakila | 405 | 87.32 ms | 0 | 0 | 20 | 0 | 656 | 2 | 2024-05-18 12:31:29.522718 | 2024-05-18 12:43:13.553170 | 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