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 `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 `CATA ... database` ( `sc... NULL 1815 1.44 s 0 0 1118 0 35750 20 2024-06-17 19:01:01.381549 2024-06-17 19:11:08.420078 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila 24 385.68 ms 0 0 24 0 288 12 2024-06-17 19:01:01.361871 2024-06-17 19:09:53.163426 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql 664 370.55 ms 0 0 416 0 13529 20 2024-06-17 19:01:05.724504 2024-06-17 19:11:08.545713 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... New 654 365.40 ms 0 0 326 0 10892 17 2024-06-17 19:03:57.029751 2024-06-17 19:10:39.341313 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 14 354.01 ms 0 0 14 0 33 2 2024-06-17 19:01:02.956397 2024-06-17 19:09:53.133491 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL 177 279.88 ms 0 0 177 0 1180 7 2024-06-17 19:01:02.803332 2024-06-17 19:10:55.245157 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `rtn` . `name` AS `SPEC ...  . `name` ) WHE... NULL 190 215.49 ms 0 0 190 0 78 0 2024-06-17 19:01:06.148096 2024-06-17 19:10:54.999926 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... zoo 328 188.48 ms 0 0 164 0 5566 17 2024-06-17 19:06:03.089010 2024-06-17 19:10:37.067086 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... NULL 9 181.00 ms 0 0 9 0 22 2 2024-06-17 19:01:28.677468 2024-06-17 19:06:47.607661 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... E.EJP 291 156.01 ms 0 0 146 0 4532 16 2024-06-17 19:02:21.058628 2024-06-17 19:10:47.919175 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 28 154.31 ms 0 0 28 0 58 2 2024-06-17 19:01:09.280083 2024-06-17 19:11:03.582664 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... E.EJP 137 153.06 ms 0 0 137 0 30 0 2024-06-17 19:02:13.718228 2024-06-17 19:10:47.932159 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... Zoo 263 151.25 ms 0 0 130 0 4212 16 2024-06-17 19:03:29.114304 2024-06-17 19:06:05.509596 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... test19 5 130.05 ms 0 0 5 0 29 6 2024-06-17 19:02:51.860760 2024-06-17 19:10:03.927527 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema 33 97.18 ms 0 0 33 0 441 13 2024-06-17 19:01:05.029708 2024-06-17 19:10:53.454387 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... Table_insertion 1 91.74 ms 0 0 1 0 4 4 2024-06-17 19:01:04.919871 2024-06-17 19:01:04.919871 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql 33 87.23 ms 0 0 33 0 193 6 2024-06-17 19:01:09.307321 2024-06-17 19:11:03.595137 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... StdMdDB 10 80.07 ms 0 0 10 0 34 3 2024-06-17 19:02:14.846540 2024-06-17 19:06:12.941268 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... DRT 49 74.91 ms 0 0 49 0 26 1 2024-06-17 19:08:16.700016 2024-06-17 19:11:06.173213 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sku 3 74.32 ms 0 0 3 0 15 5 2024-06-17 19:05:03.464619 2024-06-17 19:05:03.618909 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 73 72.30 ms 0 0 68 0 3007 41 2024-06-17 19:01:09.244096 2024-06-17 19:11:03.596449 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema 124 66.57 ms 0 0 62 0 2022 16 2024-06-17 19:01:05.326242 2024-06-17 19:10:53.597651 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATA ... database` ( `sc... DRT 106 58.90 ms 0 0 52 0 1798 17 2024-06-17 19:08:16.747254 2024-06-17 19:11:06.162678 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... pw 3 58.52 ms 0 0 3 0 15 5 2024-06-17 19:10:09.009834 2024-06-17 19:10:09.169189 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 57 55.96 ms 0 0 57 0 3039 53 2024-06-17 19:01:05.034570 2024-06-17 19:10:53.469707 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
Query results operations