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` .... mysql 147 0 0 1091314704000 102254805000 7423909000 64018000000 290 2 3789 26 0 0 147 0 290 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-15 23:31:02.123562 2024-06-15 23:33:02.327076
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 233 0 0 800223944000 528615762000 3434437000 105678000000 3017 13 31450 135 0 0 150 0 2456 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-15 23:31:01.968539 2024-06-15 23:33:02.338331
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 666 0 0 390775897000 5230557000 586750000 149128000000 6727 10 39770 60 0 0 1391 0 9960 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-15 23:31:01.980752 2024-06-15 23:33:11.741565
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 199 0 0 181192453000 2628891000 910514000 89132000000 3304 17 17189 86 0 0 160 0 3062 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-15 23:31:02.087252 2024-06-15 23:33:11.705867
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 20 0 0 154274370000 47352223000 7713718000 9603000000 32 2 374 19 0 0 20 0 32 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-15 23:32:48.735343 2024-06-15 23:33:12.820491
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 3 0 0 144304495000 126738745000 48101498000 772000000 2 1 3368 1123 0 0 12 0 26 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-15 23:31:55.834807 2024-06-15 23:31:55.914605
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 6 0 2 140600327000 50211963000 23433387000 2777000000 10 2 118 20 0 0 16 0 356 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-15 23:32:10.082213 2024-06-15 23:32:30.936367
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 134599645000 112288013000 44866548000 445000000 26 9 26 9 0 0 9 2 804 2 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-15 23:31:38.256028 2024-06-15 23:31:38.497249
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 87 0 0 126919095000 21629236000 1458840000 42962000000 1631 19 11833 136 0 0 42 0 1631 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-15 23:31:01.966419 2024-06-15 23:33:09.772587
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 240 0 0 121672747000 1773794000 506969000 45048000000 1980 8 13260 55 0 0 540 0 3600 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-15 23:31:02.123472 2024-06-15 23:33:08.243648
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 120 0 0 119265412000 3496630000 993878000 44059000000 6334 53 32030 267 0 0 120 0 6334 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-15 23:31:01.990112 2024-06-15 23:33:08.175160
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 199 0 0 112824042000 1698985000 566954000 42708000000 1649 8 11061 56 0 0 448 0 3000 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-15 23:31:02.183543 2024-06-15 23:33:12.906996
SHOW SESSION VARIABLES LIKE ? performance_schema * 120 0 0 106903681000 4867744000 890864000 12191000000 120 1 68880 574 0 0 120 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-15 23:31:01.980526 2024-06-15 23:33:08.231343
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 26 0 0 96902795000 21923506000 3727030000 16140000000 26 1 100 4 0 0 22 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-15 23:31:02.595657 2024-06-15 23:32:46.763083
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 272 0 0 96302859000 1269622000 354054000 51142000000 266 1 1614 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-15 23:31:38.257381 2024-06-15 23:32:52.071800
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 159 0 0 91396029000 5660149000 574817000 33308000000 159 1 636 4 0 0 1113 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-06-15 23:31:02.039298 2024-06-15 23:33:11.695083
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 85 0 0 88625556000 28959930000 1042653000 26780000000 26 0 1340 16 0 0 82 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-15 23:31:03.522840 2024-06-15 23:33:08.723379
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... table * 4 0 0 84194623000 81591976000 21048655000 2206000000 4 1 144 36 0 0 4 0 4 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-15 23:31:02.344417 2024-06-15 23:31:02.423194
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 88 0 0 80144102000 1159636000 910728000 9739000000 451 5 3895 44 0 0 84 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-15 23:31:03.520273 2024-06-15 23:32:16.110679
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 202 0 0 79690904000 1495851000 394509000 44593000000 0 0 606 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-15 23:31:02.011393 2024-06-15 23:33:02.337216
SHOW SESSION VARIABLES LIKE ? mysql * 73 0 0 78241974000 3244411000 1071807000 7139000000 73 1 41902 574 0 0 73 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-15 23:31:02.084505 2024-06-15 23:33:02.387145
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 * 18 0 0 76283461000 18314255000 4237970000 11965000000 24 1 729 41 0 0 17 0 17 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-15 23:32:48.753638 2024-06-15 23:33:12.814435
SHOW TABLES FROM `phpmyadmin` NULL 335 335 0 74628277000 1047038000 222770000 30197000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-15 23:31:01.955010 2024-06-15 23:33:13.128721
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 60 0 0 61051214000 2629860000 1017520000 26973000000 60 1 8220 137 0 0 60 0 60 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-15 23:31:01.987023 2024-06-15 23:33:08.165606
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... test19 5 0 0 57252755000 35314861000 11450551000 4846000000 5 1 18 4 0 0 3 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-15 23:32:48.802000 2024-06-15 23:33:12.849381
Query results operations