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` .... NULL 294 2578110188000 0 0 294 0 603 2 2022-09-27 09:17:04.608821 2022-09-27 09:28:05.488690 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 31 597843484000 0 0 29 0 957 31 2022-09-27 09:21:21.762191 2022-09-27 09:28:06.100548 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 116 437740729000 0 0 37 0 624 5 2022-09-27 09:16:50.396326 2022-09-27 09:28:29.860227 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 309 354802959000 0 0 226 0 1486 5 2022-09-27 09:16:50.407894 2022-09-27 09:28:29.938549 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 292 304763733000 0 0 78 0 1595 5 2022-09-27 09:17:04.603940 2022-09-27 09:28:06.752578 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 294 294945929000 0 0 287 0 1778 6 2022-09-27 09:17:04.607804 2022-09-27 09:28:05.487951 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 202 217645734000 0 0 172 0 5392 27 2022-09-27 09:16:51.932574 2022-09-27 09:28:06.724792 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 79 210697314000 0 0 79 0 213 3 2022-09-27 09:16:50.442377 2022-09-27 09:28:29.871153 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 166 125979081000 0 0 101 0 3121 19 2022-09-27 09:16:51.362043 2022-09-27 09:28:06.083094 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 177 117491074000 0 0 102 0 3122 18 2022-09-27 09:16:50.558473 2022-09-27 09:28:29.948959 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... pw 15 105331627000 0 0 15 0 75 5 2022-09-27 09:22:10.342690 2022-09-27 09:27:02.597155 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... StdMdDB 4 77472504000 0 0 3 0 12 3 2022-09-27 09:26:24.361022 2022-09-27 09:26:30.902624 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys 2 66515339000 0 0 2 0 88 44 2022-09-27 09:28:16.764630 2022-09-27 09:28:16.773445 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... baza7 16 64831168000 0 0 12 0 8 1 2022-09-27 09:25:58.558919 2022-09-27 09:28:06.341934 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `sys` . `format_statement` ( `performance_s... sys 2 38310563000 0 0 1 0 25 13 2022-09-27 09:26:25.702484 2022-09-27 09:26:25.713207 4762b230873d55f6aff0188d5acbda058b9eb045b5153225eb...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Students Database 17 35117099000 0 0 12 0 7 0 2022-09-27 09:22:35.770767 2022-09-27 09:25:49.534700 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... StdMdDB 1 27098481000 0 0 1 0 1 1 2022-09-27 09:26:30.938710 2022-09-27 09:26:30.938710 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... table 8 24538307000 0 0 8 0 8 1 2022-09-27 09:17:37.185119 2022-09-27 09:18:25.985794 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 8 19743434000 0 0 5 0 79 10 2022-09-27 09:21:40.314841 2022-09-27 09:27:14.672319 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... students 3 19115271000 0 0 3 0 3 1 2022-09-27 09:25:46.070816 2022-09-27 09:25:46.103887 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 1 15432853000 0 0 1 0 1 1 2022-09-27 09:25:39.739964 2022-09-27 09:25:39.739964 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 2 15163921000 0 0 1 0 1 1 2022-09-27 09:25:39.718290 2022-09-27 09:25:39.783016 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... baza7 10 10252419000 0 0 10 0 42 4 2022-09-27 09:26:40.650700 2022-09-27 09:28:06.334154 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 12 9619910000 0 0 12 0 231 19 2022-09-27 09:24:10.783182 2022-09-27 09:28:16.796378 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `performance_schema` . `events_statements_s... sys 2 8512905000 0 0 1 0 21 11 2022-09-27 09:24:10.780182 2022-09-27 09:24:10.787795 460ca1d49578214f11985bab8be1d9153d556dd2db66af434c...
Query results operations