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 `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 61 1178554729000 0 0 60 0 148 2 2024-06-16 17:15:54.468196 2024-06-16 17:18:19.162598 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 34 1069749111000 0 0 34 0 60 2 2024-06-16 17:15:59.653512 2024-06-16 17:17:58.414858 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 171 500959721000 0 0 171 0 2104 12 2024-06-16 17:15:54.409804 2024-06-16 17:18:34.736092 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys 9 468046071000 0 0 9 0 203 23 2024-06-16 17:15:58.623359 2024-06-16 17:18:26.968401 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 696 433575218000 0 0 372 0 11348 16 2024-06-16 17:15:54.312448 2024-06-16 17:18:33.912587 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 46 412364585000 0 0 46 0 204 4 2024-06-16 17:15:55.090240 2024-06-16 17:18:17.951005 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 66 390445482000 0 0 66 0 119 2 2024-06-16 17:15:55.554987 2024-06-16 17:18:11.001100 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 5 388250908000 5 1 14 0 3548 710 2024-06-16 17:15:58.455045 2024-06-16 17:18:13.654193 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 19 353836972000 0 0 19 0 107 6 2024-06-16 17:15:59.772861 2024-06-16 17:18:09.950501 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... NULL 1 293546285000 1 1 3 0 582 582 2024-06-16 17:16:02.089035 2024-06-16 17:16:02.089035 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4...
SELECT `c` . `name` AS `category` , SUM ( `p` . `a... NULL 1 220423496000 0 0 1 0 16 16 2024-06-16 17:15:55.409503 2024-06-16 17:15:55.409503 a5caeb258efa481e69eb8ef233fdcdc5da21db15e515ca13d4...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys 8 196521646000 0 0 13 0 572 72 2024-06-16 17:17:16.422763 2024-06-16 17:18:13.679163 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 344 183175723000 0 0 190 0 5803 17 2024-06-16 17:15:55.072013 2024-06-16 17:18:31.766625 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... pw 21 163751255000 0 0 21 0 42 2 2024-06-16 17:16:48.382027 2024-06-16 17:18:18.908616 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 114 161166725000 0 0 112 0 1278 11 2024-06-16 17:16:00.576376 2024-06-16 17:18:19.169033 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 1 131431128000 1 1 2 0 728 728 2024-06-16 17:18:13.035248 2024-06-16 17:18:13.035248 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 396 122344305000 0 0 66 0 2014 5 2024-06-16 17:15:57.274091 2024-06-16 17:18:34.797053 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 231 120567790000 0 0 118 0 3616 16 2024-06-16 17:15:54.984377 2024-06-16 17:18:30.102832 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... pw 18 113150922000 0 0 18 0 46 3 2024-06-16 17:16:12.940065 2024-06-16 17:18:18.948822 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `sys` . `format_statement` ( `performance_s... NULL 1 112701040000 0 0 1 0 1 1 2024-06-16 17:16:01.966425 2024-06-16 17:16:01.966425 5dedbc181166dbc1f2ceb4aab65601b32e171682a23591851c...
SELECT `concat` ( `c` . `city` , (_charset) ? , `c... sakila 2 105727591000 0 0 2 0 4 2 2024-06-16 17:18:10.447122 2024-06-16 17:18:10.487481 e93a551af16493cd58cb06c9b4b21c3e15c6db7cb66f6c868e...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 107 102409793000 0 0 102 0 3056 29 2024-06-16 17:15:54.970795 2024-06-16 17:18:30.053312 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys 1 98251916000 1 1 2 0 644 644 2024-06-16 17:18:12.903492 2024-06-16 17:18:12.903492 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 107 97918862000 0 0 81 0 2635 25 2024-06-16 17:15:55.523589 2024-06-16 17:18:17.912003 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 102 89496111000 0 0 54 0 888 9 2024-06-16 17:15:57.259086 2024-06-16 17:18:34.763141 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
Query results operations