Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Set default
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`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
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` .... sakila 22 180431307000 0 0 22 0 43 2 2022-12-02 00:47:48.172546 2022-12-02 00:59:32.906406 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 22 177962891000 0 0 22 0 22 1 2022-12-02 00:47:48.108392 2022-12-02 00:59:32.895073 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 2 88059914000 0 0 2 0 5 3 2022-12-02 00:49:09.669958 2022-12-02 00:54:46.481404 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 86 85271845000 0 0 66 0 342 4 2022-12-02 00:47:48.113101 2022-12-02 00:59:32.978953 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 64 58854795000 0 0 41 0 1230 19 2022-12-02 00:47:39.971332 2022-12-02 00:57:00.959214 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 72 42482738000 0 0 44 0 1320 18 2022-12-02 00:47:48.199514 2022-12-02 00:59:32.985610 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 58 32805685000 0 0 4 0 120 2 2022-12-02 00:49:22.676459 2022-12-02 00:54:29.029085 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 3 21680859000 0 0 3 0 35 12 2022-12-02 00:47:40.469915 2022-12-02 00:54:46.541486 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 4 20142245000 0 0 4 0 304 76 2022-12-02 00:47:53.983168 2022-12-02 00:53:02.039575 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 16 15623169000 0 0 8 0 240 15 2022-12-02 00:47:22.792540 2022-12-02 00:56:14.197984 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... world 2 15103667000 0 0 2 0 2 1 2022-12-02 00:49:09.681779 2022-12-02 00:49:09.730674 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 8 14225227000 0 0 5 0 54 7 2022-12-02 00:49:22.667933 2022-12-02 00:54:29.019599 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT IF ( ( `performance_schema` . `memory_summa... sys 2 14110434000 0 0 5 0 15 8 2022-12-02 00:54:48.477466 2022-12-02 00:54:48.485039 87d1ed412cb4f9329b857bcd6110396ac410693635c4c9c191...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 12 7582718000 0 0 6 0 180 15 2022-12-02 00:47:54.018552 2022-12-02 00:54:48.528101 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 12 6104272000 0 0 6 0 180 15 2022-12-02 00:51:22.252343 2022-12-02 00:57:35.596494 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 5 4997353000 0 0 5 0 54 11 2022-12-02 00:53:02.041523 2022-12-02 00:54:48.521720 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 7 4799147000 0 0 7 0 60 9 2022-12-02 00:51:22.247469 2022-12-02 00:57:35.589487 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 3 4168399000 0 0 3 0 135 45 2022-12-02 00:49:22.659718 2022-12-02 00:54:28.832952 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... teste_teste 8 4000264000 0 0 4 0 120 15 2022-12-02 00:48:30.145174 2022-12-02 00:50:44.280432 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... world 3 3535613000 0 0 2 0 60 20 2022-12-02 00:49:09.710732 2022-12-02 00:49:09.713558 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 3 2643873000 0 0 3 0 3 1 2022-12-02 00:51:22.243900 2022-12-02 00:57:35.584105 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... world 1 2248489000 0 0 1 0 4 4 2022-12-02 00:49:09.698646 2022-12-02 00:49:09.698646 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 1 2224404000 0 0 1 0 7 7 2022-12-02 00:54:46.499486 2022-12-02 00:54:46.499486 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
( SELECT DISTINCTROW `User` , `Host` FROM `mysql` ... mysql 1 1999610000 0 0 1 0 9 9 2022-12-02 00:47:40.472087 2022-12-02 00:47:40.472087 6fde62466af48d108728b06ee676e9cbd6817cf5b67f2a46e5...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 2 1979474000 0 0 2 0 11 6 2022-12-02 00:49:09.632591 2022-12-02 00:54:46.430131 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
Query results operations