Drop files here

SQL upload ( 0 ) x -

Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Query failed Database: Queried time:
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
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 `c` . `name` AS `category` , SUM ( `p` . `a... sakila 39 1301688121000 0 0 29 0 464 12 2024-06-16 10:03:20.731172 2024-06-16 10:03:46.048878 a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4...
SELECT `concat` ( `c` . `city` , (_charset) ? , `c... sakila 33 960160723000 0 0 25 0 50 2 2024-06-16 10:03:17.925111 2024-06-16 10:03:38.617528 e93a551af16493cd58cb06c9b4b21c3e15c6db7cb66f6c868e...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 156 793318089000 0 0 156 0 201 1 2024-06-16 10:01:03.076152 2024-06-16 10:06:03.401351 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 151 696726866000 0 0 151 0 228 2 2024-06-16 10:01:02.563266 2024-06-16 10:06:14.581459 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 693 372780049000 0 0 369 0 11134 16 2024-06-16 10:01:02.640802 2024-06-16 10:06:14.636241 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 151 365116138000 0 0 148 0 884 6 2024-06-16 10:01:02.587948 2024-06-16 10:06:14.650243 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 504 323114548000 0 0 270 0 8140 16 2024-06-16 10:01:02.928865 2024-06-16 10:06:13.495428 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 120 308025605000 0 0 111 0 1233 10 2024-06-16 10:01:03.119601 2024-06-16 10:06:03.397979 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 4 277538744000 0 0 1 0 1 0 2024-06-16 10:03:09.972472 2024-06-16 10:03:30.012345 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 422 264041029000 0 0 212 0 6362 15 2024-06-16 10:01:02.772452 2024-06-16 10:06:03.457838 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 147 233202913000 0 0 147 0 1530 10 2024-06-16 10:01:02.765204 2024-06-16 10:06:12.787765 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 260 230443310000 0 0 186 0 4465 17 2024-06-16 10:01:02.511700 2024-06-16 10:06:14.585107 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 340 175901889000 0 0 170 0 5120 15 2024-06-16 10:01:05.317910 2024-06-16 10:06:15.021698 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 169 172756899000 0 0 169 0 9801 58 2024-06-16 10:01:05.034945 2024-06-16 10:06:14.902166 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 3 132011075000 0 0 3 0 10 3 2024-06-16 10:01:18.703696 2024-06-16 10:01:26.396148 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 143 114184622000 0 0 108 0 535 4 2024-06-16 10:01:02.999320 2024-06-16 10:06:03.407044 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 10 95755626000 0 0 9 0 15 2 2024-06-16 10:01:18.760626 2024-06-16 10:04:17.293483 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... pw 6 91422432000 0 0 6 0 12 2 2024-06-16 10:01:54.220430 2024-06-16 10:01:58.540625 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 85 83665556000 0 0 85 0 85 1 2024-06-16 10:01:05.032688 2024-06-16 10:06:14.890852 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 209 77972203000 0 0 64 0 1922 9 2024-06-16 10:01:04.206393 2024-06-16 10:05:39.751531 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... NULL 2 71118482000 0 0 4 0 176 88 2024-06-16 10:02:54.114958 2024-06-16 10:02:55.825798 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sku 8 64719747000 0 0 7 0 7 1 2024-06-16 10:01:47.874497 2024-06-16 10:02:20.934643 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sku 6 57681293000 0 0 6 0 6 1 2024-06-16 10:01:47.781427 2024-06-16 10:01:52.949019 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... hit-db-demo 102 56706168000 0 0 50 0 1550 15 2024-06-16 10:05:34.714377 2024-06-16 10:06:09.949097 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 85 54062598000 0 0 85 0 258 3 2024-06-16 10:01:05.035786 2024-06-16 10:06:14.893936 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
Query results operations