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 `events_statements_summary_by_digest`
SCHEMA_NAME DIGEST DIGEST_TEXT COUNT_STAR SUM_TIMER_WAIT MIN_TIMER_WAIT AVG_TIMER_WAIT MAX_TIMER_WAIT SUM_LOCK_TIME SUM_ERRORS SUM_WARNINGS SUM_ROWS_AFFECTED SUM_ROWS_SENT SUM_ROWS_EXAMINED SUM_CREATED_TMP_DISK_TABLES SUM_CREATED_TMP_TABLES SUM_SELECT_FULL_JOIN SUM_SELECT_FULL_RANGE_JOIN SUM_SELECT_RANGE SUM_SELECT_RANGE_CHECK SUM_SELECT_SCAN SUM_SORT_MERGE_PASSES SUM_SORT_RANGE SUM_SORT_ROWS SUM_SORT_SCAN SUM_NO_INDEX_USED SUM_NO_GOOD_INDEX_USED FIRST_SEEN LAST_SEEN QUANTILE_95 QUANTILE_99 QUANTILE_999 QUERY_SAMPLE_TEXT QUERY_SAMPLE_SEEN QUERY_SAMPLE_TIMER_WAIT
NULL 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... SELECT @@`skip_networking` , @@`skip_name_resolve`... 1 1031108000 1031108000 1031108000 1031108000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:45:47.588927 2024-06-29 01:45:47.588927 1047128548 1047128548 1047128548 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-06-29 01:45:47.588927 1031108000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 4576 472396464000 24056000 103233000 1583192000 0 0 0 0 4576 4576 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.835972 2024-06-29 01:58:00.812600 229086765 275422870 346736850 SELECT @@version, @@version_comment 2024-06-29 01:57:49.447182 393501000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 4576 274123068000 15038000 59904000 1046246000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.836131 2024-06-29 01:58:00.812711 144543977 181970085 229086765 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-06-29 01:57:58.535006 235996000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 4574 278945401000 12511000 60985000 5755309000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.836305 2024-06-29 01:58:00.812804 144543977 181970085 3801893963 SET lc_messages = 'en_US' 2024-06-29 01:57:44.817080 198900000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 4687 950219341000 52264000 202735000 3957591000 389417000000 4687 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.837821 2024-06-29 01:58:00.813051 457088189 524807460 1202264434 SHOW TABLES FROM `phpmyadmin` 2024-06-29 01:57:57.827053 609925000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 4575 289409527000 17829000 63258000 279932000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.838923 2024-06-29 01:58:00.813625 158489319 190546071 239883291 SET collation_connection = 'utf8mb4_unicode_ci' 2024-06-29 01:57:51.538937 204339000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 3703 541015920000 51213000 146102000 844300000 268817000000 0 0 0 3703 3703 0 0 0 0 0 0 3703 0 0 0 0 0 0 2024-06-29 01:46:00.865198 2024-06-29 01:58:00.823245 208929613 239883291 416869383 SELECT 1 FROM mysql.user LIMIT 1 2024-06-29 01:57:26.206315 356358000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 3500 153226922000 13327000 43779000 389263000 0 0 0 0 3500 3500 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.865924 2024-06-29 01:58:00.823573 66069344 83176377 109647819 SELECT DATABASE() 2024-06-29 01:57:57.856514 93952000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 2473 2087947251000 615327000 844297000 13726815000 219821000000 0 0 0 2473 1419502 0 2473 0 0 0 0 4946 0 0 0 0 2473 0 2024-06-29 01:46:00.871771 2024-06-29 01:58:00.279852 1202264434 1513561248 5754399373 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-06-29 01:58:00.279852 1244733000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 1145 211973344000 114940000 185129000 612270000 72156000000 0 0 0 10305 10305 0 0 0 0 0 0 1145 0 0 0 0 1145 0 2024-06-29 01:46:00.872370 2024-06-29 01:58:00.214304 275422870 316227766 398107170 SELECT * FROM `user` LIMIT 0, 25 2024-06-29 01:57:12.458338 279895000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 1202 36961004000 13011000 30749000 276369000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.874713 2024-06-29 01:58:00.214849 45708818 60255958 120226443 SHOW WARNINGS 2024-06-29 01:57:41.898270 64382000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 1676 86276548000 26754000 51477000 200949000 0 0 0 0 1676 1676 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.875255 2024-06-29 01:58:00.476712 87096358 120226443 151356124 SELECT @@lower_case_table_names 2024-06-29 01:57:38.191859 92250000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 6447 2257121177000 200279000 350104000 8170747000 1262274000000 0 0 0 0 19341 0 0 0 0 0 0 6447 0 0 0 0 0 0 2024-06-29 01:46:00.883460 2024-06-29 01:58:00.527823 549540873 691830970 2089296130 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-06-29 01:57:55.710764 575763000
NULL ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1489 1940610507000 424099000 1303297000 8482532000 998879000000 0 0 0 73307 231223 0 7 7 0 0 0 1489 0 0 73297 1479 7 0 2024-06-29 01:46:00.884002 2024-06-29 01:58:00.445390 3019951720 3981071705 5754399373 SHOW TABLES FROM `information_schema` 2024-06-29 01:57:49.461564 8482532000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 3611 3753528884000 428580000 1039470000 5334853000 1356595000000 0 0 0 162155 826755 0 3418 0 0 0 0 3611 0 0 161193 3418 0 0 2024-06-29 01:46:00.887152 2024-06-29 01:58:00.468579 1737800828 2290867652 3467368504 SHOW FULL COLUMNS FROM `mysql`.`slave_master_info` 2024-06-29 01:57:57.662572 2964456000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1941 2607928243000 440340000 1343600000 89971084000 715194000000 0 1 0 3810 110116 0 1941 0 0 0 0 1941 0 0 3810 1941 0 0 2024-06-29 01:46:00.891999 2024-06-29 01:58:00.467465 1148153621 34673685045 87096358995 SHOW INDEXES FROM `mysql`.`role_edges` 2024-06-29 01:57:57.567922 89971084000
mysql 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 614 28387623000 30260000 46233000 152482000 0 0 614 0 614 614 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.893388 2024-06-29 01:58:00.218955 69183097 91201083 158489319 SELECT @@have_profiling 2024-06-29 01:57:49.722036 90531000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 1542 279111165000 98965000 181005000 2013919000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:00.893875 2024-06-29 01:58:00.468981 263026799 331131121 1659586907 SHOW CREATE TABLE `mysql`.`user` 2024-06-29 01:57:23.004385 329057000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1711 1762857167000 649364000 1030308000 52748121000 702873000000 0 0 0 1775 173001 0 1709 1709 0 0 0 1711 0 0 1775 1711 1709 0 2024-06-29 01:46:00.955905 2024-06-29 01:58:00.528843 1318256738 3311311214 28840315031 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-06-29 01:57:57.936409 21258419000
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 1745 110362954000 23230000 63245000 729063000 0 0 0 0 1745 1745 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:01.016064 2024-06-29 01:58:00.505507 100000000 114815362 363078054 SELECT CURRENT_USER() 2024-06-29 01:57:55.627216 83638000
mysql 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 775 56611541000 45901000 73047000 272166000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-29 01:46:01.016316 2024-06-29 01:58:00.505752 104712854 125892541 275422870 SHOW GRANTS 2024-06-29 01:57:38.222989 113845000
mysql db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 7219 3856238432000 150695000 534179000 5786346000 1438418000000 0 0 0 61021 395859 0 15560 10511 0 0 0 15872 0 0 106440 3548 7019 0 2024-06-29 01:46:01.018794 2024-06-29 01:58:00.515070 1047128548 1584893192 2290867652 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-06-29 01:57:55.289865 1751448000
mysql 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 1745 931951135000 355495000 534069000 2907705000 325085000000 0 0 0 1745 6980 0 12215 0 0 0 0 12215 0 0 0 0 1745 0 2024-06-29 01:46:01.053351 2024-06-29 01:58:00.529845 758577575 1202264434 2398832919 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-06-29 01:57:46.338672 1422953000
mysql cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... 1677 358354903000 148000000 213688000 3243056000 90152000000 0 0 0 1677 290121 0 1677 0 0 0 0 1677 0 0 0 0 1677 0 2024-06-29 01:46:01.058210 2024-06-29 01:58:00.530171 301995172 478630092 2398832919 SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.... 2024-06-29 01:57:46.339395 505316000
mysql caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 2413 309813477000 49128000 128393000 1107780000 152244000000 0 0 0 2413 2413 0 0 0 0 0 0 2413 0 0 0 0 0 0 2024-06-29 01:46:01.081131 2024-06-29 01:58:00.548610 190546071 218776162 331131121 SELECT 1 FROM `mysql`.`user` LIMIT 1 2024-06-29 01:58:00.548610 207485000
Query results operations