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` .... performance_schema 5630 0 0 7491281546000 8844677000 1330600000 2415125000000 375412 67 1893950 336 0 0 5630 0 375412 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-08-09 13:31:01.704945 2024-08-09 13:36:27.278753
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 11261 0 0 7328528816000 7622994000 650788000 2700423000000 100710 9 684631 61 0 0 25335 0 184528 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-08-09 13:31:01.857672 2024-08-09 13:36:27.373940
SHOW SESSION VARIABLES LIKE ? performance_schema * 5629 0 0 5067847591000 5422884000 900310000 503957000000 5629 1 3231046 574 0 0 5629 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-08-09 13:31:01.641827 2024-08-09 13:36:27.347466
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 17028 0 0 4699366281000 3981843000 275978000 2559321000000 16998 1 102078 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-08-09 13:32:24.085867 2024-08-09 13:36:18.639333
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 2818 0 0 3283104158000 88027515000 1165047000 1457174000000 3124 1 394526 140 0 0 2816 0 3124 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-08-09 13:31:01.698808 2024-08-09 13:36:27.267856
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 5657 0 0 2425526025000 5054205000 428765000 1377736000000 0 0 16971 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-08-09 13:31:01.694300 2024-08-09 13:36:27.269466
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 2815 0 0 2090415275000 4900364000 742598000 1108132000000 8436 3 47819 17 0 0 2815 0 8436 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-08-09 13:31:01.706800 2024-08-09 13:36:27.271278
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema * 2468 0 0 1600608090000 8164528000 648544000 582056000000 2468 1 9872 4 0 0 17276 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-08-09 13:31:01.892800 2024-08-09 13:36:27.233028
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema * 2690 0 0 1516051760000 3546766000 563588000 109066000000 2690 1 0 0 0 0 0 0 0 0 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... 2024-08-09 13:31:01.701461 2024-08-09 13:36:27.268656
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 45 0 6 1318693124000 65139627000 29304291000 20563000000 220 5 809 18 0 0 120 0 3052 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-08-09 13:32:24.084483 2024-08-09 13:36:18.690021
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema * 2690 0 0 946445309000 4772702000 351838000 213520000000 67250 25 67250 25 0 0 0 0 0 0 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... 2024-08-09 13:31:01.647068 2024-08-09 13:36:27.262124
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 1091 0 14 745171660000 5175072000 683017000 274147000000 10990 10 69576 64 0 0 2438 0 19039 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-08-09 13:31:02.341206 2024-08-09 13:36:27.126591
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 1053 0 0 723641663000 4851168000 687219000 261521000000 9985 9 66340 63 0 0 2396 0 18444 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-08-09 13:31:02.011859 2024-08-09 13:36:27.188473
SHOW CREATE TABLE `performance_schema` . `table_lo... performance_schema 2690 0 0 675819355000 3661788000 251233000 0 0 0 0 0 0 0 0 0 0 0 bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... 2024-08-09 13:31:01.709765 2024-08-09 13:36:27.272724
SELECT @@`version` , @@`version_comment` NULL 3995 0 0 654795903000 372734596000 163903000 0 3995 1 3995 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2024-08-09 13:31:01.616543 2024-08-09 13:36:27.386012
SHOW TABLES FROM `phpmyadmin` NULL 3995 3995 0 574918747000 1292608000 143909000 233128000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-08-09 13:31:01.618281 2024-08-09 13:36:27.386637
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 411 0 0 559454826000 8370539000 1361203000 66131000000 687 2 17046 41 0 0 399 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-08-09 13:31:06.553685 2024-08-09 13:36:12.179431
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 422 0 0 509921427000 7258399000 1208344000 176242000000 21435 51 109285 259 0 0 422 0 21435 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-08-09 13:31:02.219079 2024-08-09 13:36:26.977490
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 3600 0 0 501908709000 1570762000 139419000 244672000000 3600 1 3600 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2024-08-09 13:31:01.635144 2024-08-09 13:36:27.393431
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 620 0 0 495850974000 5892056000 799759000 253335000000 9844 16 46342 75 0 0 281 0 7475 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-08-09 13:31:02.742552 2024-08-09 13:36:26.501631
SELECT `performance_schema` . `events_statements_s... sys * 3 0 0 489566057000 487300537000 163188685000 388000000 26 9 643 214 0 0 0 0 26 0 8b22b06fe671437418edb1a3633c0f481cc712f261f1eb7654... 2024-08-09 13:34:53.282004 2024-08-09 13:34:53.482823
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... Sailors * 694 0 0 447293740000 2409580000 644515000 169809000000 6067 9 39697 57 0 0 1530 0 11086 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-08-09 13:31:36.930643 2024-08-09 13:36:12.161241
SELECT ? FROM `performance_schema` . `table_lock_w... performance_schema * 2688 0 0 432986293000 2201957000 161081000 202615000000 2688 1 2688 1 0 0 0 0 0 0 0a8822d56431a0b278bf28d018ce42545a1bffb9d7c5ab4593... 2024-08-09 13:31:01.915995 2024-08-09 13:36:27.364911
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 626 0 0 426331241000 5119332000 681040000 158362000000 5687 9 37895 61 0 0 1312 0 10442 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-08-09 13:31:02.802047 2024-08-09 13:36:26.666609
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 562 0 0 393122699000 5758465000 699506000 242081000000 0 0 1686 3 0 0 562 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-08-09 13:31:02.743500 2024-08-09 13:36:26.502455
Query results operations