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 13 123228722000 0 0 12 0 56 4 2022-12-03 03:47:22.961039 2022-12-03 03:51:50.872362 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 11 109113591000 0 0 11 0 20 2 2022-12-03 03:47:23.005408 2022-12-03 03:51:48.231265 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 82 92794584000 0 0 42 0 1260 15 2022-12-03 03:47:32.133374 2022-12-03 03:51:54.765874 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 74 69921001000 0 0 48 0 1440 19 2022-12-03 03:47:14.579175 2022-12-03 03:51:50.141793 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 41 51493756000 0 0 33 0 162 4 2022-12-03 03:47:22.972111 2022-12-03 03:51:48.240553 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 36 24275515000 0 0 22 0 660 18 2022-12-03 03:47:23.094247 2022-12-03 03:51:48.245547 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 21 20689961000 0 0 9 0 46 2 2022-12-03 03:48:15.408915 2022-12-03 03:51:50.999388 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT IF ( ( `performance_schema` . `memory_summa... sys 2 19813595000 0 0 5 0 15 8 2022-12-03 03:47:20.208896 2022-12-03 03:47:20.216728 87d1ed412cb4f9329b857bcd6110396ac410693635c4c9c191...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... students 2020 8 12287181000 0 0 8 0 372 47 2022-12-03 03:47:10.104476 2022-12-03 03:50:16.920519 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
( SELECT DISTINCTROW `User` , `Host` FROM `mysql` ... mysql 2 9137482000 0 0 2 0 18 9 2022-12-03 03:50:54.202688 2022-12-03 03:51:50.130605 6fde62466af48d108728b06ee676e9cbd6817cf5b67f2a46e5...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 8 7967209000 0 0 4 0 120 15 2022-12-03 03:47:40.472990 2022-12-03 03:48:34.372612 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4 7539722000 0 0 4 0 4 1 2022-12-03 03:47:40.420176 2022-12-03 03:48:34.376941 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4 6327493000 0 0 4 0 41 10 2022-12-03 03:47:40.439008 2022-12-03 03:48:34.365473 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... students 2020 8 5458058000 0 0 4 0 120 15 2022-12-03 03:47:10.128533 2022-12-03 03:50:16.918172 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 2 3574324000 0 0 2 0 66 33 2022-12-03 03:50:54.192843 2022-12-03 03:51:50.130070 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
( SELECT `User` , `Host` , `Select_priv` , `Insert... NULL 1 3274431000 0 0 1 0 5 5 2022-12-03 03:48:15.419626 2022-12-03 03:48:15.419626 d1a3131f33f7939484023b450706e7c8cd6c56644a0eab0775...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 1 2212709000 0 0 1 0 2 2 2022-12-03 03:47:40.436164 2022-12-03 03:47:40.436164 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 3 2205841000 0 0 3 0 36 12 2022-12-03 03:47:20.212146 2022-12-03 03:47:20.247770 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 1 1907466000 0 0 1 0 20 20 2022-12-03 03:48:34.358087 2022-12-03 03:48:34.358087 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 4 1739297000 0 0 2 0 60 15 2022-12-03 03:47:20.249348 2022-12-03 03:47:20.254073 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 1 1124359000 0 0 1 0 2 2 2022-12-03 03:48:34.359506 2022-12-03 03:48:34.359506 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT * , IF ( `authentication_string` = (_charse... mysql 2 965195000 0 0 2 0 18 9 2022-12-03 03:50:54.187567 2022-12-03 03:51:50.128764 7e35898f02101bb4b68e88cb043db562a54aa4e9dc32262467...
Query results operations