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 42641 0 0 11086988014000 4296930000 260007000 5989434000000 42245 1 254658 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 04:31:05.555444 2024-06-16 04:40:35.440174
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 34 0 3 2023171605000 520995405000 59505047000 9176000000 240 7 112894 3320 0 0 154 24 12990 24 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-16 04:32:22.758744 2024-06-16 04:39:49.246197
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys * 1775 0 32 1355435383000 16092354000 763625000 664453000000 238 0 72098 41 0 0 1908 0 7394 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:31:05.556970 2024-06-16 04:40:35.385400
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... sys * 2315 0 0 1283997533000 10844140000 554642000 460696000000 19860 9 137591 59 0 0 5227 0 36300 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:31:05.606020 2024-06-16 04:40:35.427567
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 17 0 0 1207169158000 440467463000 71009950000 2393000000 28 2 28 2 0 0 53 12 4908 12 c552f840b97cf2c164de85ef343eae0b410364ed59846f9192... 2024-06-16 04:32:39.932612 2024-06-16 04:32:50.158628
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 182 0 0 892904743000 99686066000 4906070000 65520000000 347 2 6285 35 0 0 182 0 347 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:31:02.907638 2024-06-16 04:41:20.494902
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 1013 0 0 846922225000 26916886000 836053000 434943000000 9116 9 47943 47 0 0 978 0 8778 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 04:31:05.556314 2024-06-16 04:40:35.373592
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 156 0 0 714731222000 378303384000 4581610000 71332000000 862 6 59644 382 0 0 134 0 863 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:31:02.946432 2024-06-16 04:41:20.525350
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 19 0 7 698844928000 271693233000 36781312000 4663000000 110 6 110 6 0 0 61 14 7084 14 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-16 04:38:30.111847 2024-06-16 04:38:42.877146
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 585 0 0 591551785000 5707220000 1011199000 69974000000 1663 3 24869 43 0 0 566 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 04:31:04.198107 2024-06-16 04:40:57.593784
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys * 94 0 0 541865332000 378418086000 5764524000 44333000000 1385 15 53913 574 0 0 69 0 1385 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:31:05.844562 2024-06-16 04:40:35.375106
SHOW SESSION VARIABLES LIKE ? sys * 620 0 0 514703007000 17472923000 830166000 54126000000 620 1 355880 574 0 0 620 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 04:31:05.548789 2024-06-16 04:41:20.831424
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 19 0 7 463374011000 57368155000 24388105000 4182000000 42 2 42 2 0 0 61 14 6076 14 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... 2024-06-16 04:38:44.373801 2024-06-16 04:38:51.724818
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 859 0 1 429098643000 2096066000 499532000 159072000000 7668 9 47680 56 0 0 1674 0 12690 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:31:03.042420 2024-06-16 04:41:20.511841
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 25 0 0 421529796000 70938957000 16861191000 11644000000 66 3 754 30 0 0 25 0 66 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 04:32:05.656674 2024-06-16 04:41:16.688763
SELECT `extract_schema_from_file_name` ( `performa... sys * 57 0 12 408686271000 40430664000 7169934000 19409000000 258 5 258 5 0 0 114 0 3259 0 bd914fd84f93d2b27f3871dfcd403dfa26335a4f26eda232ed... 2024-06-16 04:31:07.027043 2024-06-16 04:36:16.382530
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 813 0 0 406948580000 1967359000 500551000 148881000000 6700 8 44867 55 0 0 1827 0 12180 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 04:31:03.890208 2024-06-16 04:41:18.405024
SELECT IF ( ( `performance_schema` . `events_stage... sys * 32 0 0 399923149000 374139856000 12497598000 382004000000 24 1 8592 269 0 0 0 0 24 0 bad3289f43f1634fa93234bacd46a811c23ae2fadc8b1ad357... 2024-06-16 04:34:16.734184 2024-06-16 04:34:38.117319
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 403 0 0 392571629000 2828094000 974123000 140482000000 21689 54 109654 272 0 0 403 0 21689 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 04:31:03.758231 2024-06-16 04:41:18.336337
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 17 0 1 350904712000 38399569000 20641453000 3596000000 110 6 164 10 0 0 36 0 804 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 04:31:42.524209 2024-06-16 04:37:43.650918
SHOW SESSION VARIABLES LIKE ? performance_schema * 402 0 0 333854456000 5166280000 830483000 37876000000 402 1 230748 574 0 0 402 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 04:31:03.744741 2024-06-16 04:41:18.392881
SHOW TABLES FROM `phpmyadmin` NULL 1318 1318 0 324862001000 1394186000 246481000 131083000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-16 04:31:02.828559 2024-06-16 04:41:20.802236
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 205 0 0 292644889000 51351888000 1427536000 92250000000 511 2 84260 411 0 0 203 0 511 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 04:31:03.754620 2024-06-16 04:41:18.326411
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... sys * 606 0 0 277988111000 1975238000 458726000 87043000000 606 1 2424 4 0 0 4242 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-06-16 04:31:05.643235 2024-06-16 04:40:35.441291
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 301 0 0 260236695000 5356685000 864573000 114311000000 7298 24 37612 125 0 0 255 0 7076 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 04:31:02.914026 2024-06-16 04:41:20.496239
Query results operations