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 * 103 0 0 725959713000 579813891000 7048152000 61698000000 1159 11 13860 135 0 0 75 0 1159 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-08 10:46:02.259502 2025-07-08 10:48:58.999051
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 266 0 0 380664526000 8976073000 1431069000 128917000000 3370 13 20776 78 0 0 636 0 6416 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-08 10:46:01.845260 2025-07-08 10:48:59.708077
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 28 0 0 373881230000 85451014000 13352901000 23936000000 28 1 98 4 0 0 14 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2025-07-08 10:46:25.591419 2025-07-08 10:48:59.028972
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 358 0 5 281904457000 4923903000 787442000 101087000000 3618 10 22138 62 0 0 786 0 5994 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-08 10:46:02.294741 2025-07-08 10:49:00.014498
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... table * 8 0 0 204709156000 197943358000 25588644000 3909000000 8 1 232 29 0 0 6 0 8 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-08 10:46:02.134123 2025-07-08 10:48:37.986959
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 61 0 0 198428707000 99159132000 3252929000 40094000000 193 3 3093 51 0 0 61 0 193 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-08 10:46:02.235509 2025-07-08 10:48:58.993505
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 130 0 0 171168508000 3915071000 1316680000 71651000000 3892 30 20043 154 0 0 121 0 3839 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-08 10:46:02.210226 2025-07-08 10:48:58.998062
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 158 0 0 160221829000 6096903000 1014062000 53230000000 158 1 632 4 0 0 1106 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-08 10:46:01.810606 2025-07-08 10:49:03.368954
SHOW SESSION VARIABLES LIKE ? mysql * 108 0 0 145803477000 7156361000 1350032000 12504000000 108 1 61992 574 0 0 108 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-08 10:46:02.207541 2025-07-08 10:48:59.989785
SHOW TABLES FROM `phpmyadmin` NULL 446 446 0 124532426000 1343846000 279220000 50108000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2025-07-08 10:46:01.794638 2025-07-08 10:49:04.145889
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 3 0 0 121086327000 117681977000 40362109000 721000000 3 1 509 170 0 0 12 0 7 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2025-07-08 10:46:02.046771 2025-07-08 10:46:02.117125
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql * 48 0 0 108101310000 4408093000 2252110000 14622000000 13056 272 15024 313 0 0 48 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2025-07-08 10:46:02.516673 2025-07-08 10:48:59.982262
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL * 62 0 0 104869700000 8875696000 1691446000 52277000000 0 0 5084 82 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2025-07-08 10:46:04.366967 2025-07-08 10:48:59.481013
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 192 0 0 101190432000 2155025000 527033000 56420000000 0 0 576 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-08 10:46:02.209368 2025-07-08 10:48:58.995013
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 5 0 0 99677370000 48992898000 19935474000 3762000000 10 2 127 25 0 0 5 0 10 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-08 10:46:04.788214 2025-07-08 10:46:04.888757
CREATE SCHEMA `ecolee` NULL 3 2 0 90063238000 56768041000 30021079000 33242000000 0 0 0 0 1 0 0 0 0 0 9c1805b54ff35ebebc09f51bbc32f32071a3141042aa0363c3... 2025-07-08 10:46:06.711197 2025-07-08 10:46:31.769301
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 48 0 0 86930890000 4393649000 1811060000 29175000000 2904 61 14664 306 0 0 48 0 2904 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-08 10:46:07.382106 2025-07-08 10:49:00.317909
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 99 0 0 69720403000 3008604000 704246000 22451000000 99 1 396 4 0 0 693 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-08 10:46:02.302141 2025-07-08 10:49:00.020702
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 37 0 0 67091559000 4257301000 1813285000 33607000000 996 27 6169 167 0 0 5 0 996 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-08 10:46:04.357428 2025-07-08 10:48:59.479525
SELECT @@`version` , @@`version_comment` NULL 446 0 0 64227851000 362711000 144008000 0 446 1 446 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2025-07-08 10:46:01.781137 2025-07-08 10:49:04.142877
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 109 0 0 58214670000 1255612000 534079000 30982000000 109 1 654 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-08 10:46:02.050961 2025-07-08 10:49:03.801393
SHOW SESSION VARIABLES LIKE ? performance_schema * 48 0 0 55307940000 2875184000 1152248000 5595000000 48 1 27552 574 0 0 48 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-08 10:46:07.368169 2025-07-08 10:49:00.414404
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 266 0 0 53523002000 3265101000 201214000 24209000000 266 1 266 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2025-07-08 10:46:01.802235 2025-07-08 10:49:04.159138
SET `lc_messages` = ? NULL 443 0 0 53086698000 6860739000 119834000 0 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2025-07-08 10:46:01.789577 2025-07-08 10:49:04.144238
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 96 0 0 44820895000 1388562000 466884000 16299000000 816 9 5496 57 0 0 216 0 1488 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-08 10:46:07.494386 2025-07-08 10:49:00.422467
Query results operations