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 269 0 0 1175089120000 102128823000 4368361000 121967000000 575 2 7658 28 0 0 269 0 575 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 03:46:01.391479 2024-06-16 03:54:37.319880
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila 70 0 0 1154440281000 546787453000 16492004000 39835000000 122 2 1407 20 0 0 70 0 122 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 03:46:25.463452 2024-06-16 03:54:46.461896
SELECT `a` . `actor_id` AS `actor_id` , `a` . `fir... sakila * 4 0 0 899228052000 311483831000 224807013000 724000000 3 1 968397 242099 0 0 9 0 600 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2024-06-16 03:46:49.144763 2024-06-16 03:46:50.517726
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql * 307 0 0 817708634000 422501221000 2663546000 135397000000 2611 9 111208 362 0 0 244 0 2479 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 03:46:01.319237 2024-06-16 03:54:37.348621
SELECT ? FROM `sakila` . `customer` LIMIT ? NULL 2 0 0 751417030000 751291982000 375708515000 192000000 2 1 2 1 0 0 0 0 0 0 ae329f6379966880db2ada20ea2ee70f653c638937afabc41b... 2024-06-16 03:49:36.493229 2024-06-16 03:52:38.036383
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql * 1232 0 0 663115061000 2914854000 538242000 246222000000 11372 9 72178 59 0 0 2620 0 19166 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 03:46:01.427697 2024-06-16 03:54:37.606437
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... NULL * 912 0 0 608644950000 18077262000 667373000 232108000000 7716 8 51211 56 0 0 2056 0 14072 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 03:46:01.072236 2024-06-16 03:54:36.697976
SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... information_schema * 527 0 0 519803643000 7914528000 986344000 59198000000 1467 3 22541 43 0 0 514 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 03:46:01.619876 2024-06-16 03:54:40.788652
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL * 225 0 0 441477932000 30607883000 1962124000 126377000000 2826 13 67860 302 0 0 145 0 2826 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 03:46:01.110769 2024-06-16 03:54:40.700661
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 414 0 0 395649576000 3427405000 955675000 196626000000 6788 16 35893 87 0 0 327 0 6430 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 03:46:01.323906 2024-06-16 03:54:37.320836
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema * 754 0 0 385328715000 2304172000 511046000 141535000000 6304 8 42340 56 0 0 1692 0 11476 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 03:46:01.499068 2024-06-16 03:54:47.078742
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema 372 0 0 380689637000 2429515000 1023359000 133889000000 20702 56 104626 281 0 0 372 0 20702 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 03:46:01.392936 2024-06-16 03:54:47.011395
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 314873676000 293140805000 104957892000 355000000 26 9 26 9 0 0 9 2 850 2 aeea2abaaf8467e98115cf4189c284704e628bc976af695ca1... 2024-06-16 03:47:06.569976 2024-06-16 03:47:06.781124
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... sys * 6 0 0 308613386000 71016327000 51435564000 4373000000 6 1 54 9 0 0 24 0 564 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 03:46:04.804100 2024-06-16 03:53:18.098809
SHOW SESSION VARIABLES LIKE ? performance_schema * 372 0 0 305578353000 1858683000 821447000 33770000000 372 1 213528 574 0 0 372 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 03:46:01.384544 2024-06-16 03:54:47.067096
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sakila * 54 0 0 285892464000 203018519000 5294304000 28192000000 362 7 17695 328 0 0 46 0 362 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 03:46:24.874935 2024-06-16 03:54:46.455198
SHOW TABLES FROM `phpmyadmin` NULL 1133 1133 0 277431327000 847752000 244864000 112634000000 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-16 03:46:01.042594 2024-06-16 03:54:48.384599
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema * 622 0 0 246684697000 1751042000 396599000 102383000000 3415 5 21530 35 0 0 750 0 5586 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 03:46:01.678879 2024-06-16 03:54:44.608091
SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... sys * 3 0 1 226002224000 204466377000 75334074000 409000000 8 3 8 3 0 0 9 2 922 2 ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... 2024-06-16 03:47:40.854423 2024-06-16 03:47:40.991056
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema * 188 0 0 225046445000 2039675000 1197055000 83927000000 392 2 76882 409 0 0 186 0 392 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 03:46:01.390304 2024-06-16 03:54:47.001947
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 34 0 0 217040936000 25473065000 6383556000 21134000000 34 1 125 4 0 0 23 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-16 03:46:04.845578 2024-06-16 03:53:14.497748
SHOW SESSION VARIABLES LIKE ? mysql * 213 0 0 205619499000 5150305000 965349000 18979000000 213 1 122262 574 0 0 213 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 03:46:01.278612 2024-06-16 03:54:37.558728
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys 624 0 0 194575879000 1669876000 311820000 105412000000 582 1 3618 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 03:46:03.151372 2024-06-16 03:54:17.016790
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema * 304 0 0 184366227000 2833774000 606467000 108627000000 2 0 956 3 0 0 302 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 03:46:01.593325 2024-06-16 03:54:44.546229
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... Table_insertion * 70 0 0 165051843000 25763725000 2357883000 39989000000 112 2 26117 373 0 0 63 0 63 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 03:47:48.879724 2024-06-16 03:54:00.860322
Query results operations