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 `CATALOG_NAME` , `sch` . ... mysql * 1572 674 5 724444717000 4487931000 460842000 212009000000 7887 5 50795 32 0 0 2008 0 13830 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:23.042381 2024-07-30 15:48:04.411642
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 2701 1748 0 713099580000 2284287000 264013000 208817000000 0 0 2859 1 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.797175 2024-07-30 15:48:04.423732
SHOW SESSION VARIABLES LIKE ? mysql * 678 0 0 607825330000 3277779000 896497000 58289000000 678 1 389172 574 0 0 678 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.794602 2024-07-30 15:48:04.402265
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1272 600 0 595316914000 43397788000 468016000 154558000000 5544 4 37128 29 0 0 1512 0 10080 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.856991 2024-07-30 15:48:04.257824
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 737 318 0 584144361000 4153629000 792597000 167563000000 20879 28 106940 145 0 0 409 0 20859 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.798478 2024-07-30 15:48:04.359255
SHOW SESSION VARIABLES LIKE ? performance_schema * 636 0 0 568179126000 7142740000 893363000 56673000000 636 1 365064 574 0 0 636 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-07-30 15:46:22.767319 2024-07-30 15:48:04.248443
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 1051 882 0 566733411000 6051194000 539232000 78022000000 169 0 69290 66 0 0 169 0 169 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.780826 2024-07-30 15:48:04.269637
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 2429 2074 0 548421970000 2589589000 225780000 76879000000 0 0 1065 0 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-07-30 15:46:22.774360 2024-07-30 15:48:04.270028
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 635 298 0 512174728000 5450163000 806574000 135120000000 21848 34 110251 174 0 0 337 0 21848 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-07-30 15:46:22.784214 2024-07-30 15:48:04.198235
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 812 606 0 507820143000 22004717000 625394000 96224000000 366 0 83998 103 0 0 201 0 366 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:22.928517 2024-07-30 15:48:04.423289
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 487 286 0 318394076000 88295518000 653786000 78384000000 402 1 13264 27 0 0 201 0 402 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.887076 2024-07-30 15:48:04.349156
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 379 37 0 238072315000 2120368000 628159000 83746000000 3358 9 22026 58 0 0 788 0 6240 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-07-30 15:46:22.955636 2024-07-30 15:48:01.712636
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 406 0 0 223337845000 7830798000 550093000 77679000000 406 1 1341 3 0 0 2842 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.080399 2024-07-30 15:48:04.424374
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 230 94 0 209267561000 3270359000 909858000 77161000000 3400 15 34119 148 0 0 40 0 3400 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-07-30 15:46:23.490633 2024-07-30 15:48:03.704351
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 467 298 0 202478082000 1706942000 433571000 59938000000 501 1 2849 6 0 0 169 0 501 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-07-30 15:46:22.785969 2024-07-30 15:48:04.189240
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... performance_schema * 318 0 0 162976431000 2049472000 512504000 58326000000 318 1 991 3 0 0 2226 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:22.892705 2024-07-30 15:48:04.270648
SHOW TABLES FROM `phpmyadmin` NULL 968 968 0 160619400000 931027000 165929000 64862000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-07-30 15:46:22.742646 2024-07-30 15:48:04.484014
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 881 0 0 137065829000 16921702000 155579000 75401000000 881 1 881 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2024-07-30 15:46:22.759702 2024-07-30 15:48:04.498700
GRANT USAGE ON * . * TO ? @? mysql 2 0 0 89657292000 56108769000 44828646000 773000000 0 0 0 0 0 0 0 0 0 0 c68f69cefc067439bf3eeb4cb1f6c9bdaf2950202005c8a2fd... 2024-07-30 15:46:42.768230 2024-07-30 15:47:20.095778
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 158 0 0 89044659000 1651709000 563573000 30439000000 158 1 567 4 0 0 1106 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-07-30 15:46:23.010450 2024-07-30 15:48:01.745847
SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema * 283 0 0 88989359000 9538470000 314450000 19744000000 283 1 0 0 0 0 0 0 0 0 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... 2024-07-30 15:46:22.781688 2024-07-30 15:48:03.755246
SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema * 283 0 0 88131315000 4050134000 311418000 19867000000 7075 25 7075 25 0 0 0 0 0 0 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... 2024-07-30 15:46:22.771102 2024-07-30 15:48:03.750304
SELECT @@`version` , @@`version_comment` NULL 968 0 0 82561394000 1070478000 85290000 0 968 1 968 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2024-07-30 15:46:22.741459 2024-07-30 15:48:04.483104
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql * 360 0 0 78430191000 1373461000 217861000 22634000000 360 1 48864 136 0 0 360 0 0 0 cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... 2024-07-30 15:46:23.085450 2024-07-30 15:48:04.424818
REVOKE ALL PRIVILEGES ON * . * FROM ? @? mysql 2 0 0 75186691000 39413051000 37593345000 1858000000 0 0 0 0 0 0 0 0 0 0 710e40ee98b6a9f7feb335f9f173c2fad284eb12b792072d9a... 2024-07-30 15:46:42.711378 2024-07-30 15:47:19.987649
Query results operations