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 231164 0 0 62903172747000 11986400000 272114000 34039093000000 230925 1 1386270 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-23 04:30:50.786302 2024-06-23 04:39:33.810774
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 9070 0 0 10132461997000 11448829000 1117140000 1111865000000 12257 1 379412 42 0 0 8955 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-23 04:30:51.077368 2024-06-23 04:39:34.363874
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 212 0 31 5226972332000 132304552000 24655529000 94079000000 1418 7 2534 12 0 0 568 0 13103 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-23 04:30:50.784495 2024-06-23 04:39:33.291410
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 64 0 0 4753791188000 304037816000 74277987000 22011000000 524 8 17522 274 0 0 2 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-23 04:31:38.423246 2024-06-23 04:39:25.285959
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 8981 0 0 3257759191000 7688974000 362739000 1427790000000 39950 4 247610 28 0 0 8063 0 61424 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:30:51.145333 2024-06-23 04:39:34.343087
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema * 34 0 0 2399079268000 1033113910000 70561154000 2449000000 850 25 850 25 0 0 34 34 0 0 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c... 2024-06-23 04:31:12.190754 2024-06-23 04:39:13.442231
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 3477 0 0 2369663074000 344261268000 681525000 1227302000000 364 0 17419 5 0 0 3435 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-23 04:30:51.091116 2024-06-23 04:39:34.235206
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 3301 0 0 2217995690000 4292597000 671916000 1160562000000 44205 13 209877 64 0 0 1745 0 33433 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-23 04:30:51.090246 2024-06-23 04:39:34.383894
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 3700 0 0 2066113149000 10273907000 558408000 744695000000 32167 9 217561 59 0 0 8325 0 58784 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:30:49.457831 2024-06-23 04:39:34.869262
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 1846 0 0 2023326695000 4659686000 1096059000 697128000000 109719 59 554127 300 0 0 1845 0 109716 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-23 04:30:49.308794 2024-06-23 04:39:34.808520
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 807 0 0 1723366103000 118805728000 2135521000 305750000000 1439 2 25528 32 0 0 807 0 1439 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-23 04:30:50.961060 2024-06-23 04:39:34.248617
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 30 0 0 1695180902000 499304700000 56506030000 14046000000 260 9 186724 6224 0 0 170 20 11954 20 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-23 04:31:15.218779 2024-06-23 04:39:21.397311
SHOW SESSION VARIABLES LIKE ? performance_schema * 1840 0 0 1542910024000 10158425000 838538000 160662000000 1840 1 1056160 574 0 0 1840 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-23 04:30:49.294185 2024-06-23 04:39:34.805483
SHOW SESSION VARIABLES LIKE ? information_schema * 1822 0 0 1534731250000 3136043000 842333000 154029000000 1822 1 1045828 574 0 0 1822 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-23 04:30:51.075099 2024-06-23 04:39:34.308544
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 2250 0 2 1178167241000 3365382000 523629000 441154000000 22131 10 131954 59 0 0 4273 0 33482 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-23 04:30:51.041289 2024-06-23 04:39:34.336421
SELECT `cs` . `name` AS `CHARACTER_SET_NAME` , `co... information_schema * 7855 0 0 1158618774000 1503329000 147500000 709343000000 9097 1 10501 1 0 0 0 0 0 0 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... 2024-06-23 04:30:51.104495 2024-06-23 04:39:34.285460
SELECT `performance_schema` . `events_statements_s... sys * 27 0 0 1120322762000 1060033338000 41493435000 3887000000 234 9 9557 354 0 0 0 0 234 0 8b22b06fe671437418edb1a3633c0f481cc712f261f1eb7654... 2024-06-23 04:31:50.235376 2024-06-23 04:38:22.596800
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 1193 0 0 1006219222000 4807511000 843436000 454244000000 27368 23 140306 118 0 0 917 0 26072 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-23 04:30:50.929640 2024-06-23 04:39:34.260681
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 926 0 0 945896678000 3539012000 1021486000 425356000000 926 1 128505 139 0 0 926 0 926 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:30:49.305166 2024-06-23 04:39:34.809986
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 566 0 0 747116353000 12824694000 1319993000 370964000000 29981 53 76302 135 0 0 32 0 29981 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:30:52.237604 2024-06-23 04:39:34.205314
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 1990 0 0 735066384000 2659182000 369380000 411529000000 0 0 5970 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-23 04:30:49.300902 2024-06-23 04:39:34.803399
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 1774 0 0 730466232000 2686824000 411762000 407066000000 286 0 6675 4 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-23 04:30:51.082109 2024-06-23 04:39:34.356359
SHOW TABLES FROM `phpmyadmin` NULL 2837 2837 0 658345589000 32672866000 232056000 281617000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-23 04:30:49.266607 2024-06-23 04:39:35.129599
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 925 0 0 607944296000 3082972000 657237000 326888000000 2733 3 15563 17 0 0 925 0 2733 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-23 04:30:49.310244 2024-06-23 04:39:34.802156
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 486 0 0 603501255000 77184402000 1241772000 214448000000 1092 2 51442 106 0 0 465 0 1059 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-23 04:30:50.987820 2024-06-23 04:39:34.259484
Query results operations