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 13437 0 0 3612344311000 240979463000 268835000 1828859000000 13416 1 80559 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 04:01:02.308068 2024-06-16 04:07:43.477137
SELECT ? FROM `information_schema` . `INNODB_COLUM... information_schema * 10 0 0 1492080885000 187852792000 149208088000 1934000000 10 1 10 1 0 0 10 10 0 0 548c02dda47c1454923b30fc7f703a1ebf478276c85df39cd2... 2024-06-16 04:06:25.046007 2024-06-16 04:06:40.083404
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 1168 0 0 1325700684000 5361078000 1135017000 153594000000 12401 11 59346 51 0 0 1145 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 04:01:02.706660 2024-06-16 04:07:29.827848
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 2988 0 0 1206168187000 3210052000 403670000 501390000000 17492 6 106184 36 0 0 3702 0 26910 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:01:01.939182 2024-06-16 04:07:50.659663
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 1393 0 0 1001817652000 99303039000 719179000 533731000000 118 0 8818 6 0 0 1364 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:01:01.832912 2024-06-16 04:07:50.642507
SELECT * FROM `INNODB_BUFFER_PAGE` LIMIT ?, ... information_schema * 4 0 0 852968176000 692824048000 213242044000 314000000 100 25 100 25 0 0 4 4 0 0 9f21a2e72c3f64f108c2c54a2e19321ed9a3102dd006b5902c... 2024-06-16 04:02:04.503072 2024-06-16 04:07:18.668817
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 944 0 0 739203477000 9916099000 783054000 379764000000 10128 11 51640 55 0 0 679 0 8236 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 04:01:01.831865 2024-06-16 04:07:50.641564
SELECT * FROM `INNODB_COLUMNS` LIMIT ?, ... information_schema * 4 0 0 584038351000 162026380000 146009587000 618000000 100 25 100 25 0 0 4 4 0 0 1512ccbc467635564d751a38813be9534f3a3cf75c1a1f59a8... 2024-06-16 04:06:26.921410 2024-06-16 04:06:39.872679
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 17 0 0 582923098000 152259419000 34289594000 6631000000 46 3 520 31 0 0 17 0 46 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:01:03.364827 2024-06-16 04:07:04.356119
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 101 0 0 542249495000 93994704000 5368806000 35940000000 202 2 3503 35 0 0 101 0 202 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:01:04.321058 2024-06-16 04:07:47.987861
SHOW SESSION VARIABLES LIKE ? information_schema * 531 0 0 451802303000 4806778000 850851000 47337000000 531 1 304794 574 0 0 531 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 04:01:01.825163 2024-06-16 04:07:50.643639
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 13 0 3 407530393000 112609724000 31348491000 5389000000 82 6 133 10 0 0 40 0 914 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 04:01:03.494247 2024-06-16 04:04:22.305850
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 674 0 0 340146643000 1708269000 504668000 123292000000 5575 8 37323 55 0 0 1515 0 10140 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:01:02.042775 2024-06-16 04:07:49.733093
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 90 0 0 326302585000 32978655000 3625584000 40392000000 154 2 36614 407 0 0 88 0 88 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:01:04.223946 2024-06-16 04:07:48.018304
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 330 0 0 313856824000 2437232000 951081000 118418000000 14942 45 75694 229 0 0 329 0 14939 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 04:01:01.877578 2024-06-16 04:07:49.715321
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 710 0 0 302376171000 1685124000 425881000 118435000000 5131 7 31301 44 0 0 1071 0 8070 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:01:02.304187 2024-06-16 04:07:48.248822
SHOW SESSION VARIABLES LIKE ? performance_schema * 314 0 0 290924024000 32330328000 926509000 28079000000 314 1 180236 574 0 0 314 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 04:01:01.856495 2024-06-16 04:07:49.717164
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 281552398000 255126073000 93850799000 423000000 13 4 13 4 0 0 9 2 808 2 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... 2024-06-16 04:06:13.058654 2024-06-16 04:06:13.204640
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema 629 0 0 266910010000 2190743000 424340000 146677000000 30 0 2019 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 04:01:01.830378 2024-06-16 04:07:50.671754
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 174 0 0 265920906000 52196260000 1528281000 77313000000 480 3 71550 411 0 0 172 0 480 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:01:01.873312 2024-06-16 04:07:49.747633
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 58 0 0 255898680000 175340510000 4412046000 41618000000 1810 31 10212 176 0 0 10 0 1810 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:01:02.248594 2024-06-16 04:07:37.008003
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 248675043000 147318047000 82891681000 958000000 26 9 26 9 0 0 9 2 643 2 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-16 04:01:02.307125 2024-06-16 04:01:02.656098
SELECT COUNT (?) AS `cnt` , `round` ( ( `performan... sys * 3 0 0 233283840000 159358085000 77761280000 453000000 26 9 6695 2232 0 0 12 0 76 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-16 04:04:20.584258 2024-06-16 04:04:21.389152
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 87 0 0 215581383000 58474364000 2477946000 34510000000 176 2 10641 122 0 0 29 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-16 04:01:04.962412 2024-06-16 04:07:29.838804
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... information_schema * 432 0 0 203095913000 1823684000 470129000 65207000000 432 1 1728 4 0 0 3024 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-06-16 04:01:01.970043 2024-06-16 04:07:50.672670
Query results operations