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 ...  `client_coll` ... sys 39464 0 0 9.88 s 6.51 ms 250.23 us 5.34 s 39369 1 236499 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 14:31:44.907297 2024-06-16 14:44:30.631423
SELECT `cat` . `name` AS `TABL ...  , ( `tbl` . `h... information_schema * 22 0 0 1.54 s 296.02 ms 70.10 ms 8.05 ms 160 7 5254 239 0 0 2 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-16 14:31:17.400231 2024-06-16 14:42:57.947116
SELECT `t` . `THREAD_ID` AS `t ... T_NUMBER_OF_BYT... sys * 56 0 11 1.29 s 49.66 ms 23.05 ms 24.37 ms 282 5 461 8 0 0 164 0 3644 0 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... 2024-06-16 14:31:52.087564 2024-06-16 14:44:30.146501
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 576 0 0 1.26 s 86.19 ms 2.19 ms 200.10 ms 1038 2 20342 35 0 0 576 0 1038 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 14:30:57.630055 2024-06-16 14:44:33.177048
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 2366 0 4 1.19 s 3.66 ms 504.56 us 438.68 ms 23253 10 140973 60 0 0 4862 0 36786 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 14:30:57.011464 2024-06-16 14:44:33.469090
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 531 0 0 1.00 s 302.61 ms 1.89 ms 217.98 ms 3219 6 62120 117 0 0 454 0 3186 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 14:30:57.709617 2024-06-16 14:44:33.194806
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 1793 0 0 908.35 ms 3.20 ms 506.61 us 331.44 ms 15069 8 100994 56 0 0 4030 0 27448 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 14:30:56.768581 2024-06-16 14:44:32.948372
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 885 0 0 875.44 ms 7.33 ms 989.20 us 317.17 ms 48445 55 244880 277 0 0 885 0 48445 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 14:30:56.647331 2024-06-16 14:44:32.872309
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... sakila * 5 0 0 845.72 ms 292.11 ms 169.14 ms 959.00 us 27 5 968421 193684 0 0 9 0 600 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2024-06-16 14:30:58.165717 2024-06-16 14:30:59.249953
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 905 0 0 741.18 ms 3.41 ms 818.98 us 322.09 ms 25083 28 128756 142 0 0 760 0 24329 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-16 14:30:57.594572 2024-06-16 14:44:33.196270
SHOW SESSION VARIABLES LIKE ? performance_schema * 879 0 0 729.39 ms 3.35 ms 829.79 us 82.29 ms 879 1 504546 574 0 0 879 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 14:30:56.633377 2024-06-16 14:44:32.930081
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 687 0 0 670.15 ms 2.85 ms 975.47 us 78.60 ms 1822 3 29415 43 0 0 673 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-16 14:30:55.773095 2024-06-16 14:43:56.096387
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... sakila 96 0 0 649.67 ms 144.21 ms 6.77 ms 35.56 ms 177 2 2059 21 0 0 96 0 177 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 14:30:56.050929 2024-06-16 14:44:15.168596
SHOW SESSION VARIABLES LIKE ? mysql * 714 0 0 629.02 ms 2.80 ms 880.98 us 62.72 ms 714 1 409836 574 0 0 714 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-16 14:30:56.991344 2024-06-16 14:44:33.251188
SELECT `cat` . `name` AS `CATA ... database` ( `sc... NULL * 889 0 0 593.50 ms 8.50 ms 667.60 us 226.23 ms 7954 9 53118 60 0 0 2016 0 14606 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 14:30:56.364243 2024-06-16 14:44:29.198967
SELECT `sys` . `format_stateme ... ncy` , `sys` . ... sys * 3 0 0 522.66 ms 515.40 ms 174.22 ms 447.00 us 26 9 2462 821 0 0 0 0 26 0 4762b230873d55f6aff0188d5acbda058b9eb045b5153225eb... 2024-06-16 14:42:13.478790 2024-06-16 14:42:13.675476
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 456 0 0 505.77 ms 49.07 ms 1.11 ms 202.42 ms 1578 3 64933 142 0 0 447 0 1578 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 14:30:56.643987 2024-06-16 14:44:32.863261
SHOW TABLES FROM `phpmyadmin` NULL 2006 2006 0 468.50 ms 632.42 us 233.55 us 191.86 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-16 14:30:55.720792 2024-06-16 14:44:34.430962
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... mysql 1378 0 0 463.16 ms 1.45 ms 336.11 us 258.32 ms 0 0 4134 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 14:30:57.696129 2024-06-16 14:44:33.193763
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 318 0 0 406.33 ms 18.00 ms 1.28 ms 198.47 ms 7101 22 30507 96 0 0 91 0 7101 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 14:30:55.726615 2024-06-16 14:44:27.873780
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... sakila * 126 0 0 398.11 ms 135.01 ms 3.16 ms 56.54 ms 1249 10 8665 69 0 0 83 0 1201 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-16 14:30:55.973298 2024-06-16 14:44:15.165250
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... performance_schema 938 0 0 341.47 ms 1.02 ms 364.04 us 190.31 ms 0 0 2814 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-16 14:30:56.642549 2024-06-16 14:44:32.865283
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 987 0 0 313.24 ms 1.83 ms 317.37 us 139.31 ms 3917 4 23788 24 0 0 790 0 5772 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-16 14:30:55.751076 2024-06-16 14:44:06.550880
SELECT ? FROM ( SELECT `GRANTE ... ser` AND ? LIKE... mysql * 572 0 0 289.04 ms 1.94 ms 505.32 us 101.78 ms 572 1 2288 4 0 0 4004 0 0 0 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... 2024-06-16 14:30:57.028420 2024-06-16 14:44:33.478714
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... performance_schema 446 0 0 280.70 ms 1.89 ms 629.36 us 148.76 ms 1302 3 7442 17 0 0 446 0 1302 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-16 14:30:56.648519 2024-06-16 14:44:32.866843
Query results operations