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 87592 0 0 24457321346000 15233165000 279218000 13157526000000 87478 1 525210 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-22 12:16:02.991226 2024-06-22 12:21:13.708046
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 113 0 19 3072507930000 80008240000 27190335000 50898000000 588 5 1561 14 0 0 296 0 6938 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-22 12:16:03.542936 2024-06-22 12:21:13.762524
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 29 0 0 1557133093000 595974409000 53694244000 10292000000 236 8 172902 5962 0 0 161 20 15076 20 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-22 12:16:59.861929 2024-06-22 12:21:04.317146
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 970 0 0 1117777877000 2917305000 1152348000 126083000000 1880 2 40994 42 0 0 954 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-22 12:16:08.979199 2024-06-22 12:21:14.610175
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL 33 0 0 956597041000 106404196000 28987789000 21502000000 95 3 783 24 0 0 33 0 95 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:16:05.422441 2024-06-22 12:19:52.159102
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 1576 0 0 928137498000 6115176000 588919000 336447000000 13558 9 91305 58 0 0 3546 0 24752 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:16:02.852810 2024-06-22 12:21:14.603525
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 786 0 0 889223204000 16574145000 1131327000 304789000000 43772 56 221114 281 0 0 782 0 43720 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:16:02.816286 2024-06-22 12:21:14.455823
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... NULL * 1 0 0 824746392000 824746392000 824746392000 216000000 1 1 1 1 0 0 4 1 305 1 c552f840b97cf2c164de85ef343eae0b410364ed59846f9192... 2024-06-22 12:16:24.709953 2024-06-22 12:16:24.709953
SHOW SESSION VARIABLES LIKE ? performance_schema * 777 0 0 677996307000 4258568000 872582000 69741000000 777 1 445998 574 0 0 777 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-22 12:16:03.038542 2024-06-22 12:21:14.668096
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 290 0 0 655601096000 39517410000 2260693000 148830000000 5038 17 76070 262 0 0 150 0 5038 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:16:03.945750 2024-06-22 12:21:13.453657
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 1485 0 0 644860419000 3114123000 434249000 263621000000 8789 6 56006 38 0 0 1937 0 14610 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:16:06.584447 2024-06-22 12:21:14.540357
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... NULL * 1 0 1 613670294000 613670294000 613670294000 178000000 1 1 9385 9385 0 0 8 1 649 1 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-22 12:17:31.351561 2024-06-22 12:17:31.351561
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 875 0 0 599620407000 3811453000 685280000 218415000000 8417 10 54395 62 0 0 2004 0 15592 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:16:03.907576 2024-06-22 12:21:10.932420
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 1087 0 5 582811916000 2139099000 536165000 216566000000 10347 10 63171 58 0 0 2167 0 16635 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-22 12:16:03.826920 2024-06-22 12:21:13.580318
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 837 0 0 580437215000 2696330000 693473000 295493000000 11835 14 59608 71 0 0 423 0 8896 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:16:06.551100 2024-06-22 12:21:14.443285
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 395 0 0 510889411000 6866394000 1293390000 192430000000 395 1 162006 410 0 0 395 0 395 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-22 12:16:02.918886 2024-06-22 12:21:14.673702
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 840 0 0 500672595000 2337815000 596038000 305542000000 0 0 2520 3 0 0 840 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:16:06.549191 2024-06-22 12:21:14.444589
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 301 0 0 445735297000 76944737000 1480848000 111410000000 572 2 11479 38 0 0 301 0 572 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:16:03.749659 2024-06-22 12:21:13.503358
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 506 0 0 436446250000 2852108000 862541000 191710000000 14089 28 72255 143 0 0 406 0 13619 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-22 12:16:03.713212 2024-06-22 12:21:13.509598
SHOW SESSION VARIABLES LIKE ? information_schema * 446 0 0 379994110000 8086265000 852004000 40703000000 446 1 256004 574 0 0 446 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-22 12:16:06.546598 2024-06-22 12:21:14.508355
SELECT ? FROM `information_schema` . `INNODB_BUFFE... NULL * 1 0 0 346177787000 346177787000 346177787000 352000000 1 1 1 1 0 0 1 1 0 0 5367402c4b2a77c0167e6f11480845120ee5d11a0ef54ddc76... 2024-06-22 12:16:06.706088 2024-06-22 12:16:06.706088
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 8 0 0 329131908000 114147835000 41141488000 4484000000 24 3 247 31 0 0 8 0 24 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-22 12:17:16.811835 2024-06-22 12:21:10.338422
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 11 0 0 323404699000 80114821000 29400427000 2727000000 54 5 17430 1585 0 0 40 0 188 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-22 12:16:03.469427 2024-06-22 12:19:53.764228
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 804 0 0 309269568000 2802728000 384663000 173338000000 0 0 2412 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-22 12:16:02.911284 2024-06-22 12:21:14.670740
SHOW TABLES FROM `phpmyadmin` NULL 1459 1459 0 299774080000 3685911000 205465000 122616000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-22 12:16:02.782038 2024-06-22 12:21:14.641299
Query results operations