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 * 204 0 0 21.36 s 692.94 ms 104.70 ms 70.94 ms 1768 9 61136 300 0 0 0 0 0 0 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... 2024-06-26 01:31:30.442591 2024-06-26 01:42:04.478316
SELECT `col` . `name` AS `COLL ... er_set_id` = `c... information_schema * 13836 0 0 15.44 s 8.12 ms 1.12 ms 1.70 s 16573 1 578970 42 0 0 13717 0 0 0 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... 2024-06-26 01:31:03.146501 2024-06-26 01:42:19.334399
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... sys 31697 0 0 9.11 s 249.42 ms 287.50 us 5.03 s 31621 1 189954 6 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:36.428411 2024-06-26 01:42:20.463584
SELECT `cat` . `name` AS `CATA ... database` ( `sc... information_schema * 12649 0 0 4.33 s 7.43 ms 342.20 us 1.95 s 49986 4 304540 24 0 0 9001 0 73256 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:03.235591 2024-06-26 01:42:20.132046
SELECT `cat` . `name` AS `CATA ... database` ( `sc... mysql * 6190 0 3 3.32 s 3.60 ms 536.69 us 1.22 s 62312 10 378523 61 0 0 11924 0 97061 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:02.517913 2024-06-26 01:42:19.307558
SELECT `cat` . `name` AS `CATA ... database` ( `sc... performance_schema * 5249 0 0 3.06 s 6.91 ms 582.62 us 1.09 s 48103 9 325972 62 0 0 11811 0 88334 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:31:02.898266 2024-06-26 01:42:19.944472
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... performance_schema 2620 0 0 2.84 s 6.33 ms 1.08 ms 992.55 ms 147655 56 746097 285 0 0 2618 0 147636 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:02.758999 2024-06-26 01:42:19.821976
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... information_schema 4030 0 0 2.84 s 6.17 ms 704.76 us 1.47 s 54312 13 260577 65 0 0 2011 0 40247 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:03.130508 2024-06-26 01:42:20.059859
SELECT `cat` . `name` AS `TABL ... ASE `col` . `ty... mysql 3046 0 0 2.84 s 8.53 ms 931.24 us 1.14 s 101377 33 516707 170 0 0 2529 0 98827 0 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... 2024-06-26 01:31:02.364888 2024-06-26 01:42:20.459244
SELECT COUNT (?) AS `cnt` , `r ... y_by_digest` GR... sys * 39 0 0 2.83 s 149.24 ms 72.55 ms 11.48 ms 330 8 130849 3355 0 0 156 0 1451 0 92ff97b05a2a2e654025eae1e78fdeafead5be7e942f76f5dc... 2024-06-26 01:32:24.316448 2024-06-26 01:42:11.420092
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... information_schema * 4059 0 0 2.57 s 32.79 ms 633.24 us 1.49 s 598 0 37132 9 0 0 3990 0 0 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 01:31:03.131667 2024-06-26 01:42:20.060453
SELECT `a` . `actor_id` AS `ac ... irst_name` , `a... sakila * 13 0 0 2.34 s 316.99 ms 180.32 ms 2.32 ms 56 4 2582440 198649 0 0 24 0 1600 0 91c1850ed235cf0a034cf8492d2dec30e38a40c16f4dc5a7c6... 2024-06-26 01:31:04.722537 2024-06-26 01:34:07.073796
SHOW SESSION VARIABLES LIKE ? performance_schema * 2606 0 0 2.19 s 5.10 ms 840.52 us 226.33 ms 2606 1 1495844 574 0 0 2606 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:02.748209 2024-06-26 01:42:19.933634
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... NULL * 1671 0 0 2.16 s 24.80 ms 1.29 ms 1.09 s 80297 48 231988 139 0 0 108 0 80297 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.339929 2024-06-26 01:42:20.025117
SELECT `cat` . `name` AS `TABL ... D ) , ? ) ) AS ... mysql 1879 0 0 1.81 s 76.57 ms 964.77 us 687.23 ms 3304 2 76782 41 0 0 1879 0 3304 0 e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... 2024-06-26 01:31:02.440278 2024-06-26 01:42:20.457987
SHOW SESSION VARIABLES LIKE ? information_schema * 2106 0 0 1.78 s 3.77 ms 843.97 us 180.21 ms 2106 1 1208844 574 0 0 2106 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:03.126910 2024-06-26 01:42:20.120258
SELECT `cs` . `name` AS `CHARA ... ation_id` = `co... information_schema * 10649 0 0 1.62 s 2.24 ms 151.74 us 986.65 ms 13340 1 16382 2 0 0 0 0 0 0 878a52876e454b2a4b4e261c26a303c778101f142fd92d4e78... 2024-06-26 01:31:03.128360 2024-06-26 01:42:19.333201
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... mysql 4331 0 0 1.53 s 2.38 ms 354.24 us 857.64 ms 0 0 12993 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:02.363078 2024-06-26 01:42:19.235831
SHOW SESSION VARIABLES LIKE ? mysql * 1652 0 0 1.39 s 3.82 ms 843.05 us 143.28 ms 1652 1 948248 574 0 0 1652 0 0 0 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... 2024-06-26 01:31:02.360140 2024-06-26 01:42:19.295603
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... performance_schema * 1315 0 0 1.33 s 4.58 ms 1.02 ms 603.94 ms 1315 1 184932 141 0 0 1315 0 1315 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.755769 2024-06-26 01:42:19.809919
SELECT `cat` . `name` AS `TABL ... me` AS UNSIGNED... mysql * 1273 0 0 1.31 s 21.91 ms 1.03 ms 536.87 ms 1625 1 134231 105 0 0 1261 0 1625 0 ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... 2024-06-26 01:31:02.463224 2024-06-26 01:42:19.234180
SELECT `cat` . `name` AS `TABL ...  `client_coll` ... performance_schema 3331 0 0 1.23 s 3.00 ms 368.10 us 682.82 ms 0 0 9993 3 0 0 0 0 0 0 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... 2024-06-26 01:31:02.753718 2024-06-26 01:42:19.811354
SHOW TABLES FROM `phpmyadmin` NULL 5187 5187 0 1.02 s 1.65 ms 195.94 us 413.63 ms 0 0 0 0 0 0 0 0 0 0 f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... 2024-06-26 01:31:02.258579 2024-06-26 01:42:20.438189
SELECT IF ( ( `locate` ( ? , ` ... ` . `COMPRESSED... NULL * 1 0 1 994.74 ms 994.74 ms 994.74 ms 227.00 us 1 1 9658 9658 0 0 8 1 782 1 bf060aa9a5df456317f07a0159bcd8e91c9fd9a588a89d87d4... 2024-06-26 01:35:31.150692 2024-06-26 01:35:31.150692
SELECT `cat` . `name` AS `CATA ... database` ( `sc... potr * 1615 0 0 988.29 ms 9.20 ms 611.95 us 352.52 ms 15187 9 103038 64 0 0 3593 0 27966 0 db22765f86fdb091d2faced7479895f8497b40140b15fad577... 2024-06-26 01:32:53.958936 2024-06-26 01:42:19.707617
Query results operations