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 * 28 0 0 645085744000 579813891000 23038776000 23240000000 316 11 3831 137 0 0 21 0 316 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-08 10:46:02.259502 2025-07-08 10:47:22.447101
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... table * 4 0 0 202122317000 197943358000 50530579000 2425000000 4 1 146 37 0 0 4 0 4 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2025-07-08 10:46:02.134123 2025-07-08 10:47:21.295857
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 126 0 0 174909354000 8976073000 1388169000 59142000000 1520 12 9546 76 0 0 299 0 2882 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-08 10:46:01.845260 2025-07-08 10:47:30.398587
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 17 0 0 146232144000 99159132000 8601890000 12666000000 46 3 987 58 0 0 17 0 46 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2025-07-08 10:46:02.235509 2025-07-08 10:47:22.410443
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 `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 139 0 5 106827266000 4923903000 768541000 39656000000 1509 11 8593 62 0 0 300 0 2367 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2025-07-08 10:46:02.294741 2025-07-08 10:47:29.219702
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 ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... NULL * 76 0 0 77135817000 6096903000 1014944000 26284000000 76 1 304 4 0 0 532 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-08 10:46:01.810606 2025-07-08 10:47:30.480824
SHOW SESSION VARIABLES LIKE ? mysql * 42 0 0 70766513000 7156361000 1684916000 5452000000 42 1 24108 574 0 0 42 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-08 10:46:02.207541 2025-07-08 10:47:29.209615
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 36 0 0 62335207000 3724426000 1731533000 24641000000 1394 39 7122 198 0 0 34 0 1382 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-08 10:46:02.210226 2025-07-08 10:47:22.449373
SHOW TABLES FROM `phpmyadmin` NULL 212 212 0 59613961000 1343846000 281197000 24091000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2025-07-08 10:46:01.794638 2025-07-08 10:47:32.099821
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... mysql * 19 0 0 47295935000 4408093000 2489259000 6202000000 5168 272 5947 313 0 0 19 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2025-07-08 10:46:02.516673 2025-07-08 10:47:29.206941
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 69 0 0 44718593000 2155025000 648095000 25191000000 0 0 207 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-08 10:46:02.209368 2025-07-08 10:47:22.444954
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... NULL * 20 0 0 39882641000 8875696000 1994132000 17097000000 0 0 1640 82 0 0 0 0 0 0 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... 2025-07-08 10:46:04.366967 2025-07-08 10:47:26.657406
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 4 0 0 39090292000 19208888000 9772573000 4425000000 4 1 14 4 0 0 2 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2025-07-08 10:46:25.591419 2025-07-08 10:46:59.999570
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 20 0 0 38999185000 4393649000 1949959000 12576000000 1300 65 6560 328 0 0 20 0 1300 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2025-07-08 10:46:07.382106 2025-07-08 10:47:32.051035
SET `lc_messages` = ? NULL 212 0 0 33529065000 6860739000 158155000 0 0 0 0 0 0 0 0 0 0 0 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... 2025-07-08 10:46:01.789577 2025-07-08 10:47:32.099353
SELECT @@`version` , @@`version_comment` NULL 212 0 0 29558674000 326151000 139427000 0 212 1 212 1 0 0 0 0 0 0 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... 2025-07-08 10:46:01.781137 2025-07-08 10:47:32.099121
SELECT ? FROM `mysql` . `user` LIMIT ? NULL 123 0 0 26428183000 3265101000 214863000 11984000000 123 1 123 1 0 0 0 0 0 0 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... 2025-07-08 10:46:01.802235 2025-07-08 10:47:32.103442
SHOW SESSION VARIABLES LIKE ? NULL * 21 0 0 25833269000 2420149000 1230155000 2146000000 21 1 12054 574 0 0 21 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-08 10:46:06.643752 2025-07-08 10:47:22.503243
SELECT COUNT ( * ) FROM `mysql` . `help_topic` mysql 2 0 0 25638577000 23418648000 12819288000 691000000 2 1 0 0 0 0 0 0 0 0 59e0490cdbb62c7dcd2058e297833ec790847cc086d6d41342... 2025-07-08 10:46:06.141490 2025-07-08 10:46:35.332158
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql * 37 0 0 23598930000 1669744000 637808000 7524000000 37 1 148 4 0 0 259 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2025-07-08 10:46:02.302141 2025-07-08 10:47:29.222117
SHOW SESSION VARIABLES LIKE ? performance_schema * 19 0 0 22810668000 2575840000 1200561000 2185000000 19 1 10906 574 0 0 19 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2025-07-08 10:46:07.368169 2025-07-08 10:47:32.014301
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 29 0 0 20937445000 1255612000 721980000 11404000000 29 1 174 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2025-07-08 10:46:02.050961 2025-07-08 10:47:31.025485
Query results operations