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 29 406305692000 0 0 29 0 1274 44 2022-12-01 11:48:00.157639 2022-12-01 11:53:21.180053 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 20 220590415000 0 0 20 0 42 2 2022-12-01 11:49:36.310014 2022-12-01 11:53:21.182646 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... pw 3 121265816000 0 0 3 0 382 127 2022-12-01 11:48:06.672217 2022-12-01 11:48:06.891188 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 99 82921169000 0 0 66 0 1980 20 2022-12-01 11:47:16.245733 2022-12-01 11:53:22.934677 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 81 72495024000 0 0 60 0 297 4 2022-12-01 11:49:36.272392 2022-12-01 11:53:21.201731 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... vedettfak 3 54436346000 0 0 3 0 376 125 2022-12-01 11:51:55.070653 2022-12-01 11:51:55.195719 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sakila 81 47578689000 0 0 46 0 1380 17 2022-12-01 11:48:00.778814 2022-12-01 11:53:21.206599 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `sys` . `format_statement` ( `performance_s... sys 2 27661233000 0 0 1 0 19 10 2022-12-01 11:52:13.861704 2022-12-01 11:52:13.870383 052a72a0116d540db9d6e2e3f5cc85815ce2f1c697f9c658b1...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL 24 21900641000 0 0 12 0 360 15 2022-12-01 11:47:49.317832 2022-12-01 11:53:19.167897 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4 9623249000 0 0 4 0 4 1 2022-12-01 11:48:01.629108 2022-12-01 11:53:13.282064 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... vedettfak 5 8471390000 0 0 2 0 60 12 2022-12-01 11:51:55.155929 2022-12-01 11:51:55.185538 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... pw 5 8308762000 0 0 2 0 60 12 2022-12-01 11:48:06.851670 2022-12-01 11:48:06.881876 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 2 7651667000 0 0 2 0 2 1 2022-12-01 11:52:56.081705 2022-12-01 11:52:56.086414 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema 4 7154686000 0 0 2 0 60 15 2022-12-01 11:52:56.164570 2022-12-01 11:52:56.183984 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 3 6439339000 0 0 3 0 3 1 2022-12-01 11:52:56.115742 2022-12-01 11:52:56.158606 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 6 6042324000 0 0 6 0 48 8 2022-12-01 11:47:57.459333 2022-12-01 11:52:13.892770 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 1 5538643000 0 0 1 0 24 24 2022-12-01 11:53:13.263445 2022-12-01 11:53:13.263445 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 2 5077024000 0 0 2 0 2 1 2022-12-01 11:47:57.447065 2022-12-01 11:47:57.448299 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys 7 3464518000 0 0 4 0 120 17 2022-12-01 11:47:57.479340 2022-12-01 11:52:13.898794 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema 8 3363440000 0 0 4 0 120 15 2022-12-01 11:48:01.645501 2022-12-01 11:53:13.278106 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 1 3326226000 0 0 1 0 67 67 2022-12-01 11:52:56.074081 2022-12-01 11:52:56.074081 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Stefano 4 2869018000 0 0 2 0 60 15 2022-12-01 11:47:18.123563 2022-12-01 11:47:18.130457 db22765f86fdb091d2faced7479895f8497b40140b15fad577...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 4 2241092000 0 0 4 0 45 11 2022-12-01 11:48:01.635526 2022-12-01 11:53:13.271276 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Stefano 1 1807761000 0 0 1 0 1 1 2022-12-01 11:47:18.134951 2022-12-01 11:47:18.134951 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58...
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 1 1671341000 0 0 1 0 3 3 2022-12-01 11:53:13.265457 2022-12-01 11:53:13.265457 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c...
Query results operations