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 4502 0 0 1052621182000 728779000 233811000 562386000000 4491 1 26979 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 01:31:22.265955 2024-06-16 01:43:47.572458
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 786 0 0 773542295000 3709280000 984150000 92605000000 1800 2 32878 42 0 0 758 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 01:31:03.806609 2024-06-16 01:44:20.819777
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 178 0 0 761382020000 131327762000 4277427000 67825000000 324 2 7077 40 0 0 178 0 324 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 01:31:08.496437 2024-06-16 01:44:11.454951
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 438 0 0 698019348000 436606159000 1593651000 156668000000 52 0 2302 5 0 0 432 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 01:31:01.459915 2024-06-16 01:44:20.778368
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 3 0 0 679411293000 638999324000 226470431000 571000000 25 8 6030 2010 0 0 12 0 73 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-16 01:43:47.474676 2024-06-16 01:43:47.629509
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 29 0 0 548911593000 520799961000 18927985000 10287000000 278 10 1272 44 0 0 1 0 68 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 01:31:22.410694 2024-06-16 01:44:07.408357
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1016 0 0 515267550000 3735376000 507153000 187485000000 8382 8 56134 55 0 0 2286 0 15240 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 01:30:49.128384 2024-06-16 01:44:21.990202
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 508 0 0 499613794000 3267614000 983491000 178566000000 27070 53 136874 269 0 0 508 0 27070 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 01:30:49.001776 2024-06-16 01:44:21.849342
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 459519959000 437395483000 153173319000 461000000 26 9 26 9 0 0 9 2 828 2 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-16 01:34:11.851337 2024-06-16 01:34:12.046463
SHOW SESSION VARIABLES LIKE ? performance_schema * 508 0 0 457419717000 34916321000 900432000 49054000000 508 1 291592 574 0 0 508 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 01:30:48.985816 2024-06-16 01:44:21.977013
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 837 0 0 451815670000 2270726000 539803000 165595000000 8110 10 51076 61 0 0 1804 0 13740 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 01:31:08.646555 2024-06-16 01:44:18.265966
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila * 25 0 0 336586142000 210119177000 13463445000 11310000000 179 7 1708 68 0 0 20 0 179 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 01:31:07.303124 2024-06-16 01:44:20.002310
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 22 0 0 336548912000 101249627000 15297677000 7994000000 45 2 511 23 0 0 22 0 45 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 01:31:07.285809 2024-06-16 01:44:20.006068
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 795 0 0 316531506000 2228131000 398152000 129588000000 4443 6 28213 35 0 0 1003 0 7410 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 01:31:01.489223 2024-06-16 01:44:20.845950
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 478 0 0 313995544000 4074983000 656894000 119945000000 4132 9 27392 57 0 0 1082 0 7560 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 01:30:48.472865 2024-06-16 01:44:09.925043
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 302 0 0 277257949000 3565339000 918072000 119319000000 9005 30 46179 153 0 0 257 0 8789 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 01:31:08.501119 2024-06-16 01:44:11.467086
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 254 0 0 249350081000 1817722000 981693000 111395000000 254 1 34798 137 0 0 254 0 254 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 01:30:48.995341 2024-06-16 01:44:21.837066
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 12 0 3 244617485000 43205154000 20384790000 4474000000 38 3 200 17 0 0 32 0 705 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 01:36:31.020345 2024-06-16 01:41:35.965222
SHOW SESSION VARIABLES LIKE ? mysql * 269 0 0 243247552000 2895403000 904265000 25397000000 269 1 154406 574 0 0 269 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 01:31:35.175157 2024-06-16 01:44:18.241344
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 341 0 0 232184845000 2667028000 680893000 121383000000 3808 11 18431 54 0 0 219 0 2992 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 01:31:01.463750 2024-06-16 01:44:20.777556
SHOW TABLES FROM `phpmyadmin` NULL 794 794 0 207436910000 2066118000 261255000 85141000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-16 01:30:48.400727 2024-06-16 01:44:24.022798
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 544 0 0 201550748000 871734000 370497000 113331000000 0 0 1632 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 01:30:48.992945 2024-06-16 01:44:21.838710
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 96 0 0 193000280000 36420746000 2010419000 62683000000 3203 33 12639 132 0 0 32 0 3203 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 01:30:48.543100 2024-06-16 01:44:08.674674
SHOW SESSION VARIABLES LIKE ? information_schema * 221 0 0 184924189000 1503561000 836761000 19928000000 221 1 126854 574 0 0 221 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 01:31:01.454208 2024-06-16 01:44:20.834397
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 133 0 0 174047592000 17427402000 1308628000 56525000000 165 1 13529 102 0 0 132 0 165 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 01:31:08.522263 2024-06-16 01:44:11.465968
Query results operations