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 a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 1675 178534206000 29208000 106587000 975387000 0 0 0 0 1675 1675 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.247697 2024-09-27 16:05:16.562281 239883291 275422870 501187233 SELECT @@version, @@version_comment 2024-09-27 16:04:25.307894 366915000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 1675 104050962000 16019000 62119000 250412000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.247942 2024-09-27 16:05:16.563223 151356124 181970085 229086765 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-09-27 16:04:37.254793 250412000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 1386 106753813000 15887000 77022000 11178566000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.248077 2024-09-27 16:05:16.563924 151356124 208929613 4786300923 SET lc_messages = 'en_GB' 2024-09-27 16:05:11.913023 184468000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 1675 348280256000 78461000 207928000 1113014000 140799000000 1675 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.248991 2024-09-27 16:05:16.565101 457088189 575439937 758577575 SHOW TABLES FROM `phpmyadmin` 2024-09-27 16:05:09.949270 592246000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 1675 112705256000 18120000 67286000 2121108000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.250265 2024-09-27 16:05:16.568488 165958690 199526231 263026799 SET collation_connection = 'utf8mb4_unicode_ci' 2024-09-27 16:05:14.931106 189251000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 581 36535279000 21775000 62883000 439063000 0 0 0 0 581 581 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.251693 2024-09-27 16:05:14.493344 158489319 199526231 457088189 SELECT CURRENT_USER() 2024-09-27 16:04:44.005254 165917000
NULL 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 312 26291115000 50226000 84266000 267846000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.251917 2024-09-27 16:05:14.493516 158489319 239883291 275422870 SHOW GRANTS 2024-09-27 16:05:07.988865 228382000
NULL 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 331 17882640000 28190000 54026000 368156000 0 0 0 0 331 331 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.252108 2024-09-27 16:05:09.617642 125892541 181970085 380189396 SELECT @@lower_case_table_names 2024-09-27 16:04:23.801950 182123000
NULL db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 1553 920357504000 232192000 592632000 6501106000 375059000000 0 0 0 7995 50061 0 3549 2447 0 0 0 3551 0 0 13766 894 1553 0 2024-09-27 16:01:02.263793 2024-09-27 16:05:14.510644 1318256738 2290867652 6025595860 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-09-27 16:05:14.506242 711827000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1432 193914760000 45680000 135415000 402946000 95366000000 0 0 0 1432 1432 0 0 0 0 0 0 1432 0 0 0 0 0 0 2024-09-27 16:01:02.277952 2024-09-27 16:05:16.602941 218776162 331131121 398107170 SELECT 1 FROM mysql.user LIMIT 1 2024-09-27 16:04:49.373600 402946000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 879 38985850000 23225000 44352000 144713000 0 0 0 0 879 879 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.278374 2024-09-27 16:05:16.603495 66069344 95499258 151356124 SELECT DATABASE() 2024-09-27 16:04:49.591700 68848000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 690 608503555000 517710000 881889000 5529823000 62045000000 0 0 0 690 396060 0 690 0 0 0 0 1380 0 0 0 0 690 0 2024-09-27 16:01:02.284223 2024-09-27 16:05:14.499700 1318256738 2187761623 5754399373 SHOW SESSION VARIABLES LIKE 'character_set_server' 2024-09-27 16:04:42.633761 2554783000
mysql 7a6011c78476e0609fdb16af6419dfae48d91839db6bf50244... SELECT * FROM `innodb_index_stats` LIMIT ?, ... 1 845265000 845265000 845265000 845265000 187000000 0 0 0 25 25 0 0 0 0 0 0 1 0 0 0 0 1 0 2024-09-27 16:01:02.291653 2024-09-27 16:01:02.291653 870963589 870963589 870963589 SELECT * FROM `innodb_index_stats` LIMIT 0, 25 2024-09-27 16:01:02.291653 845265000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1527 568402395000 207897000 372234000 3099540000 317468000000 0 0 0 0 4577 0 0 0 0 0 0 1527 0 0 0 0 0 0 2024-09-27 16:01:02.292775 2024-09-27 16:05:14.605846 602559586 1148153621 1737800828 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 16:04:21.471245 1708489000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 357 17987620000 27352000 50385000 325151000 0 0 0 0 357 357 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.293088 2024-09-27 16:05:14.548515 87096358 109647819 331131121 SELECT @@lower_case_table_names 2024-09-27 16:05:14.548515 63856000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 277 54131020000 125756000 195418000 1225083000 18448000000 0 0 0 2493 2493 0 0 0 0 0 0 277 0 0 0 0 277 0 2024-09-27 16:01:02.306089 2024-09-27 16:05:14.170445 275422870 331131121 1258925411 SELECT * FROM `user` LIMIT 0, 25 2024-09-27 16:04:18.657398 381557000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 298 9485765000 14870000 31831000 138977000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.306430 2024-09-27 16:05:14.170927 45708818 69183097 144543977 SHOW WARNINGS 2024-09-27 16:05:12.329895 42836000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 773 782641516000 451230000 1012472000 4595534000 298954000000 0 0 0 32036 163384 0 704 0 0 0 0 773 0 0 31720 704 0 0 2024-09-27 16:01:02.312426 2024-09-27 16:05:14.576106 1659586907 2398832919 4786300923 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-09-27 16:05:01.650224 1987692000
NULL 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 556 211462800000 203333000 380328000 2247361000 121426000000 0 0 0 1 567 0 0 0 0 0 0 556 0 0 0 0 0 0 2024-09-27 16:01:02.327604 2024-09-27 16:05:14.542617 575439937 954992586 2290867652 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 16:04:41.502088 700450000
NULL ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 636 780914185000 440781000 1227852000 19548455000 369700000000 0 0 0 17907 137707 0 278 278 0 0 0 636 0 0 17907 636 278 0 2024-09-27 16:01:02.347452 2024-09-27 16:05:15.936297 3019951720 4365158322 19952623149 SHOW TABLES FROM `information_schema` 2024-09-27 16:05:10.947778 3240580000
NULL 6f66a0abc899b42553e137b3b6a174e6f9f1e5eb90079a2290... SHOW TABLE STATUS FROM `sqlmta` WHERE `Name` LIKE ... 221 24925883000 78856000 112786000 474112000 12944000000 221 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.347952 2024-09-27 16:04:47.441112 165958690 263026799 478630092 SHOW TABLE STATUS FROM `sqlmta` WHERE `Name` LIKE ... 2024-09-27 16:04:26.417924 194826000
NULL 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 553 302596821000 368135000 547191000 3016242000 97218000000 0 0 0 553 2212 0 3871 0 0 0 0 3871 0 0 0 0 553 0 2024-09-27 16:01:02.349641 2024-09-27 16:05:14.543470 831763771 1819700858 3019951720 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-09-27 16:04:51.149542 1858848000
NULL cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... 387 81188645000 136882000 209789000 1406893000 18872000000 0 0 0 387 66951 0 387 0 0 0 0 387 0 0 0 0 387 0 2024-09-27 16:01:02.350169 2024-09-27 16:05:13.519757 331131121 549540873 1445439770 SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.... 2024-09-27 16:04:33.823755 332830000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 375 995614516000 620653000 2654972000 439738668000 182710000000 0 0 0 1027 114870 0 359 357 0 0 0 375 0 0 1027 375 357 0 2024-09-27 16:01:02.369895 2024-09-27 16:05:14.607077 2187761623 17378008287 457088189614 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-09-27 16:04:38.896642 1304999000
NULL 18632f8f87c3d1f2ade9cdbe2d650c1e76cba3ce5e77e54b33... SELECT ? FROM `sqlmta` . `items` LIMIT ? 6 951099000 117238000 158516000 227820000 413000000 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 16:01:02.372257 2024-09-27 16:02:26.479527 229086765 229086765 229086765 SELECT 1 FROM `sqlmta`.`items` LIMIT 1 2024-09-27 16:02:25.438413 158412000
Query results operations