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$statement_analysis`
query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 14124 0 0 3597529646000 2859377000 254710000 1941197000000 14103 1 84681 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 00:46:05.103171 2024-06-16 00:54:31.791688
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 118 0 0 1577091803000 131744931000 13365184000 74926000000 264 2 3364 29 0 0 118 0 264 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 00:46:04.192641 2024-06-16 00:54:53.729891
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1861 0 0 1003581218000 3239522000 539269000 369210000000 15798 8 105974 57 0 0 4195 0 28820 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 00:46:02.084262 2024-06-16 00:54:51.614133
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 14 0 0 934835713000 150541283000 66773979000 5834000000 12 1 47662 3404 0 0 72 0 396 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-16 00:47:21.062461 2024-06-16 00:54:31.937558
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 267 0 0 860825113000 111990356000 3224064000 107001000000 535 2 8590 32 0 0 267 0 535 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 00:46:03.616555 2024-06-16 00:54:52.174400
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 847 0 0 852772380000 7704693000 1006815000 340587000000 31040 37 156123 184 0 0 803 0 30231 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 00:46:02.055011 2024-06-16 00:54:51.544456
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 1175 0 0 733246111000 8184395000 624039000 271412000000 10019 9 67261 57 0 0 2651 0 18290 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 00:46:02.275969 2024-06-16 00:54:53.784106
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 687 0 0 710076334000 3840970000 1033590000 85097000000 2135 3 29523 43 0 0 668 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 00:46:02.521150 2024-06-16 00:54:44.177852
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... NULL * 1 0 0 704988826000 704988826000 704988826000 172000000 1 1 9607 9607 0 0 8 1 731 1 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-16 00:48:20.475056 2024-06-16 00:48:20.475056
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 263 0 0 597766932000 54097636000 2272878000 123610000000 1687 6 26756 102 0 0 223 0 1687 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 00:46:02.262077 2024-06-16 00:54:53.798774
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys * 880 0 2 557106591000 16989855000 633075000 265091000000 6 0 8499 10 0 0 878 0 5 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 00:46:05.104553 2024-06-16 00:54:31.755744
SHOW SESSION VARIABLES LIKE ? performance_schema * 579 0 0 492662723000 3294271000 850885000 56137000000 579 1 332346 574 0 0 579 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 00:46:03.092234 2024-06-16 00:54:51.602439
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 502 0 0 484743629000 4437243000 965624000 216720000000 502 1 69006 137 0 0 502 0 502 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 00:46:02.109026 2024-06-16 00:54:51.534926
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys * 216 0 0 467295787000 259991703000 2163406000 90035000000 1116 5 31011 144 0 0 205 0 1116 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 00:46:05.427699 2024-06-16 00:50:01.967010
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 2 0 1 446099255000 423144955000 223049627000 419000000 2 1 2 1 0 0 8 2 1196 2 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-16 00:50:01.958238 2024-06-16 00:50:02.076145
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 17 0 0 440824888000 423861797000 25930875000 5761000000 109 6 1577 93 0 0 3 0 3 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 00:46:03.857104 2024-06-16 00:52:59.254822
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 0 435269092000 413875663000 145089697000 1126000000 26 9 19422 6474 0 0 17 2 1524 2 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-16 00:51:01.110977 2024-06-16 00:51:01.725214
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 12 0 1 433547161000 206677090000 36128930000 3485000000 82 7 136 11 0 0 32 0 714 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 00:46:55.939255 2024-06-16 00:54:31.673998
SELECT ? FROM `information_schema` . `INNODB_BUFFE... information_schema * 2 0 0 429521296000 419862245000 214760648000 144000000 2 1 2 1 0 0 2 2 0 0 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76... 2024-06-16 00:51:18.438839 2024-06-16 00:51:18.521846
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 133 0 0 426011043000 88214475000 3203090000 52335000000 224 2 2428 18 0 0 133 0 224 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 00:46:21.909254 2024-06-16 00:53:03.578273
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 681 0 4 375809341000 7343992000 551849000 142457000000 6621 10 40956 60 0 0 1417 0 11023 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 00:46:03.624935 2024-06-16 00:54:52.242953
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 493 0 0 372962968000 2679525000 756517000 196175000000 1149 2 7053 14 0 0 493 0 1149 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 00:46:02.056965 2024-06-16 00:54:51.538658
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 220 0 0 358284212000 4952597000 1628564000 146328000000 3182 14 16528 75 0 0 216 0 2920 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 00:46:04.171469 2024-06-16 00:54:53.731169
SHOW TABLES FROM `phpmyadmin` NULL 1295 1295 0 330837648000 6630393000 255473000 137212000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-16 00:46:02.039000 2024-06-16 00:54:53.811390
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 343 0 0 319668629000 4029589000 931978000 147927000000 8339 24 43399 127 0 0 320 0 8231 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 00:46:03.504406 2024-06-16 00:54:52.185981
Query results operations