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 `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 `TABL ...  , ( `tbl` . `h... information_schema * 42 0 0 3.25 s 276.20 ms 77.44 ms 12.68 ms 364 9 12272 292 0 0 0 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-09-27 13:46:04.110833 2024-09-27 13:47:50.892238
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 4966 0 0 1.36 s 3.26 ms 272.88 us 730.70 ms 4959 1 29775 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-09-27 13:46:23.548173 2024-09-27 13:47:47.272116
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 1191 0 0 1.32 s 4.78 ms 1.11 ms 148.11 ms 2216 2 50186 42 0 0 1170 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-09-27 13:46:04.264201 2024-09-27 13:47:51.947628
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 192 0 0 697.32 ms 476.23 ms 3.63 ms 84.17 ms 288 2 20070 105 0 0 190 0 288 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-09-27 13:46:02.936360 2024-09-27 13:47:56.829486
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 1860 0 0 620.26 ms 4.10 ms 333.47 us 281.91 ms 7061 4 42670 23 0 0 1332 0 10266 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-09-27 13:46:03.382517 2024-09-27 13:47:57.101621
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 769 0 0 522.64 ms 5.23 ms 679.64 us 188.33 ms 7412 10 49857 65 0 0 1756 0 13722 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-09-27 13:46:02.368743 2024-09-27 13:47:56.300909
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 895 0 4 494.35 ms 4.10 ms 552.35 us 185.22 ms 8236 9 52095 58 0 0 1883 0 14023 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-09-27 13:46:03.031549 2024-09-27 13:47:56.815834
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 232 0 0 466.40 ms 58.11 ms 2.01 ms 86.89 ms 445 2 11829 51 0 0 232 0 445 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-09-27 13:46:02.937541 2024-09-27 13:47:56.762921
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema * 610 0 0 462.29 ms 79.56 ms 757.85 us 220.70 ms 208 0 10510 17 0 0 586 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-09-27 13:46:03.355007 2024-09-27 13:47:57.024489
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema 599 0 0 421.03 ms 3.15 ms 702.89 us 218.78 ms 8305 14 39123 65 0 0 294 0 6196 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-09-27 13:46:03.357250 2024-09-27 13:47:57.023770
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 417 0 0 419.13 ms 3.35 ms 1.01 ms 159.47 ms 16760 40 85577 205 0 0 375 0 16569 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-09-27 13:46:02.895999 2024-09-27 13:47:56.765272
SELECT `mt` . `THREAD_ID` AS ` ... ST_USER` , ? , ... sys * 3 0 1 351.30 ms 315.42 ms 117.10 ms 340.00 us 26 9 26 9 0 0 4 0 98 0 842d82531694141e52c01891300ae7148cdbee8aa87a39eb0b... 2024-09-27 13:46:59.147959 2024-09-27 13:46:59.441946
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 314 0 0 349.10 ms 12.75 ms 1.11 ms 180.92 ms 11456 36 34352 109 0 0 101 0 11456 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-09-27 13:46:02.393280 2024-09-27 13:47:56.957295
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 564 0 0 317.64 ms 2.20 ms 563.19 us 116.10 ms 4911 9 32971 58 0 0 1269 0 8976 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-09-27 13:46:05.317197 2024-09-27 13:47:56.115438
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 282 0 0 306.07 ms 2.68 ms 1.09 ms 106.82 ms 16086 57 81276 288 0 0 282 0 16086 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-09-27 13:46:05.266842 2024-09-27 13:47:56.036308
SHOW SESSION VARIABLES LIKE ? information_schema * 316 0 0 271.58 ms 2.41 ms 859.44 us 27.23 ms 316 1 181384 574 0 0 316 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-09-27 13:46:03.352014 2024-09-27 13:47:57.090645
SHOW SESSION VARIABLES LIKE ? mysql * 313 0 0 270.91 ms 2.84 ms 865.54 us 27.38 ms 313 1 179662 574 0 0 313 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-09-27 13:46:02.889925 2024-09-27 13:47:55.614176
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... mysql 743 0 0 261.75 ms 1.90 ms 352.29 us 147.04 ms 0 0 2229 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-09-27 13:46:02.892424 2024-09-27 13:47:56.828431
SHOW SESSION VARIABLES LIKE ? performance_schema * 282 0 0 242.78 ms 2.72 ms 860.92 us 25.52 ms 282 1 161868 574 0 0 282 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-09-27 13:46:05.260619 2024-09-27 13:47:56.103892
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... information_schema * 1199 0 0 187.83 ms 1.38 ms 156.66 us 114.94 ms 1429 1 1689 1 0 0 0 0 0 0 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... 2024-09-27 13:46:04.279117 2024-09-27 13:47:51.945148
CREATE TABLE `st6610871` . `st ... E NOT NULL ) EN... st6610871 1 0 0 184.94 ms 184.94 ms 184.94 ms 102.00 us 0 0 0 0 0 0 0 0 0 0 ef55c059db9a4d2310ab789006b4dd5ccd260fb5e25a956611... 2024-09-27 13:46:46.175359 2024-09-27 13:46:46.175359
SHOW TABLES FROM `phpmyadmin` NULL 895 895 0 172.38 ms 644.74 us 192.61 us 70.82 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-09-27 13:46:02.319638 2024-09-27 13:47:57.142212
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 141 0 0 142.79 ms 1.73 ms 1.01 ms 64.55 ms 141 1 19574 139 0 0 141 0 141 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-09-27 13:46:05.274899 2024-09-27 13:47:56.026541
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... NULL * 260 0 0 134.96 ms 1.87 ms 519.08 us 43.96 ms 260 1 1040 4 0 0 1820 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-09-27 13:46:02.394940 2024-09-27 13:47:56.321272
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... information_schema 294 0 0 124.92 ms 1.23 ms 424.89 us 69.79 ms 0 0 882 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-09-27 13:46:03.400855 2024-09-27 13:47:57.113872
Query results operations