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 * 539 0 1 329586486000 6935726000 611477000 120287000000 5041 9 33307 62 0 0 1225 0 9216 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-05 18:45:48.807729 2025-07-05 18:54:54.632524
SHOW SESSION VARIABLES LIKE ? mysql * 224 0 0 276259893000 28686740000 1233303000 24179000000 224 1 128576 574 0 0 224 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-05 18:45:48.679981 2025-07-05 18:54:54.625143
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 183 0 0 259554250000 5322512000 1418329000 93052000000 9108 50 46545 254 0 0 181 0 9104 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-05 18:45:48.687625 2025-07-05 18:54:49.559066
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 542 0 0 247820663000 2253859000 457233000 132595000000 542 1 3252 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-05 18:45:57.149068 2025-07-05 18:55:00.442898
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 251 0 0 246775441000 5606073000 983169000 88542000000 2363 9 15509 62 0 0 573 0 4366 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-05 18:45:54.530816 2025-07-05 18:54:54.040852
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 165 0 0 230606460000 4640464000 1397614000 77479000000 10224 62 51615 313 0 0 165 0 10224 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-05 18:45:54.550060 2025-07-05 18:54:47.630326
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 430 0 0 204977559000 2793241000 476691000 112052000000 0 0 1290 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-05 18:45:48.685206 2025-07-05 18:54:49.556456
SELECT `performance_schema` . `events_statements_s... sys * 91 0 0 189862417000 14237972000 2086400000 17646000000 805 9 13262 146 0 0 0 0 805 0 8b22b06fe671437418edb1a3633c0f481cc712f261f1eb7654... 2025-07-05 18:45:57.148219 2025-07-05 18:55:00.441379
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 90 0 0 175528706000 43129769000 1950318000 49025000000 180 2 5890 65 0 0 90 0 180 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-05 18:45:48.731163 2025-07-05 18:54:49.539192
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 93 0 0 160856880000 22776853000 1729643000 48404000000 157 2 37569 404 0 0 90 0 157 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-05 18:45:48.766634 2025-07-05 18:54:49.557480
SHOW SESSION VARIABLES LIKE ? performance_schema * 166 0 0 160798217000 3621422000 968663000 17003000000 166 1 95284 574 0 0 166 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-05 18:45:54.536016 2025-07-05 18:54:47.719646
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 332 0 0 151063841000 1709142000 455011000 53388000000 2812 8 18927 57 0 0 747 0 5126 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-05 18:45:54.601778 2025-07-05 18:54:47.725724
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 83 0 0 131711208000 5226266000 1586882000 49924000000 83 1 34030 410 0 0 83 0 83 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-05 18:45:54.547326 2025-07-05 18:54:47.620128
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Table_insertion * 3 0 0 130699008000 128170218000 43566336000 1983000000 21 7 508 169 0 0 1 0 21 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-05 18:54:03.843138 2025-07-05 18:54:04.065937
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 136 0 0 122449498000 2493529000 900363000 71854000000 0 0 408 3 0 0 136 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-05 18:45:57.151682 2025-07-05 18:54:20.845595
SHOW TABLES FROM `phpmyadmin` NULL 395 395 0 104754722000 2368683000 265201000 43647000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2025-07-05 18:45:48.654101 2025-07-05 18:55:00.434147
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql * 55 0 0 99775845000 3872856000 1814106000 12984000000 14960 272 17215 313 0 0 55 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2025-07-05 18:45:53.269471 2025-07-05 18:54:54.623215
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 165 0 0 84677891000 2196743000 513199000 47496000000 0 0 495 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-05 18:45:54.543766 2025-07-05 18:54:47.621330
SHOW SESSION VARIABLES LIKE ? sys * 70 0 0 83932369000 4996959000 1199033000 7032000000 70 1 40180 574 0 0 70 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-05 18:45:57.133725 2025-07-05 18:55:00.442699
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 151 0 0 81831849000 1792823000 541932000 26406000000 151 1 604 4 0 0 1057 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-05 18:45:48.814497 2025-07-05 18:54:54.634777
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 68 0 0 81529780000 3083555000 1198967000 36354000000 1532 23 7864 116 0 0 68 0 1532 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-05 18:45:57.150885 2025-07-05 18:54:20.843944
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... StdMdDB * 3 0 0 79153588000 76242405000 26384529000 3366000000 12 4 463 154 0 0 1 0 12 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-05 18:48:45.321958 2025-07-05 18:48:45.459229
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 83 0 0 75112301000 2555717000 904967000 38916000000 249 3 1411 17 0 0 83 0 249 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-05 18:45:54.551622 2025-07-05 18:54:47.623692
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys * 136 0 0 72948325000 3546782000 536384000 25345000000 1150 8 8078 59 0 0 306 0 2096 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-05 18:45:57.191681 2025-07-05 18:54:20.897632
SET `lc_messages` = ? NULL 391 0 0 72257706000 8806645000 184802000 0 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2025-07-05 18:45:48.650185 2025-07-05 18:55:00.433701
Query results operations