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 2965953000 2965953000 2965953000 2965953000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:15:47.730921 2024-09-27 15:15:47.730921 3019951720 3019951720 3019951720 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-09-27 15:15:47.730921 2965953000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 1585 165619920000 26117000 104492000 544465000 0 0 0 0 1585 1585 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.222274 2024-09-27 15:19:59.016983 239883291 275422870 380189396 SELECT @@version, @@version_comment 2024-09-27 15:19:29.799252 544465000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 1585 96171295000 14125000 60675000 481560000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.222571 2024-09-27 15:19:59.017879 151356124 181970085 251188643 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-09-27 15:19:46.082179 187722000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 1456 118498715000 12556000 81386000 4657199000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.224803 2024-09-27 15:19:59.018701 144543977 229086765 4365158322 SET lc_messages = 'zh_CN' 2024-09-27 15:19:43.530345 185946000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 1587 325955327000 80194000 205390000 1547152000 132988000000 1587 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.225912 2024-09-27 15:19:59.020082 457088189 549540873 954992586 SHOW TABLES FROM `phpmyadmin` 2024-09-27 15:19:29.802081 562226000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 1585 102031236000 16257000 64373000 253719000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.227316 2024-09-27 15:19:59.023762 158489319 199526231 251188643 SET collation_connection = 'utf8mb4_unicode_ci' 2024-09-27 15:19:43.535806 247202000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1265 182654566000 48350000 144390000 1000509000 91097000000 0 0 0 1265 1265 0 0 0 0 0 0 1265 0 0 0 0 0 0 2024-09-27 15:16:01.243702 2024-09-27 15:19:59.060931 218776162 316227766 1000000000 SELECT 1 FROM mysql.user LIMIT 1 2024-09-27 15:19:45.540245 400871000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 986 43871582000 14967000 44494000 649453000 0 0 0 0 986 986 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.244913 2024-09-27 15:19:59.061473 66069344 100000000 660693448 SELECT DATABASE() 2024-09-27 15:19:19.487948 163622000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 723 657241582000 577909000 909047000 12984857000 69342000000 0 0 0 723 415002 0 723 0 0 0 0 1446 0 0 0 0 723 0 2024-09-27 15:16:01.252191 2024-09-27 15:19:56.425057 1380384264 2630267991 13182567385 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-09-27 15:19:09.531809 3355476000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 309 59948498000 115459000 194008000 711474000 19960000000 0 0 0 2781 2781 0 0 0 0 0 0 309 0 0 0 0 309 0 2024-09-27 15:16:01.252972 2024-09-27 15:19:56.362926 275422870 380189396 724435960 SELECT * FROM `user` LIMIT 0, 25 2024-09-27 15:19:39.021413 424245000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 341 10734435000 15587000 31479000 104017000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.253390 2024-09-27 15:19:56.363370 50118723 66069344 104712854 SHOW WARNINGS 2024-09-27 15:19:42.937353 49646000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 402 19815974000 22500000 49293000 148352000 0 0 0 0 402 402 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.253791 2024-09-27 15:19:56.363846 83176377 104712854 151356124 SELECT @@lower_case_table_names 2024-09-27 15:19:34.723651 102429000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1732 653138472000 213853000 377100000 3566720000 362806000000 0 0 0 0 5196 0 0 0 0 0 0 1732 0 0 0 0 0 0 2024-09-27 15:16:01.257576 2024-09-27 15:19:56.376019 602559586 1148153621 3019951720 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 15:19:55.604181 517316000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 893 939586780000 446897000 1052168000 6136074000 365087000000 0 0 0 36257 185124 0 809 0 0 0 0 893 0 0 35869 809 0 0 2024-09-27 15:16:01.264058 2024-09-27 15:19:56.378517 1905460717 2884031503 6309573444 SHOW  COLUMNS FROM `mysql`.`user` 2024-09-27 15:19:39.030039 3054020000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 473 777180500000 439408000 1643087000 89141904000 177252000000 0 0 0 945 25271 0 473 0 0 0 0 473 0 0 945 473 0 0 2024-09-27 15:16:01.313866 2024-09-27 15:19:56.366433 1096478196 50118723362 91201083935 SHOW INDEXES FROM `mysql`.`user` 2024-09-27 15:19:39.038497 1209562000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 338 69828130000 125385000 206592000 6796346000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.315907 2024-09-27 15:19:56.367836 275422870 346736850 6918309709 SHOW CREATE TABLE `mysql`.`user` 2024-09-27 15:19:40.062636 305226000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 403 673878083000 681170000 1672154000 47703404000 181522000000 0 0 0 467 136690 0 401 401 0 0 0 403 0 0 467 403 401 0 2024-09-27 15:16:01.349918 2024-09-27 15:19:56.377294 2187761623 23988329190 47863009232 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-09-27 15:19:52.234108 5137469000
mysql 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 442 27373056000 26349000 61929000 214324000 0 0 0 0 442 442 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.402909 2024-09-27 15:19:56.426186 100000000 109647819 218776162 SELECT CURRENT_USER() 2024-09-27 15:19:54.143199 95581000
mysql db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 1919 1144617156000 168764000 596465000 4426218000 423831000000 0 12 0 17632 111976 0 4022 2738 0 0 0 4159 0 0 30033 942 1822 0 2024-09-27 15:16:01.404513 2024-09-27 15:19:56.436401 1318256738 1819700858 3801893963 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-09-27 15:19:26.585426 2855906000
mysql 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 460 264868290000 370621000 575800000 1616035000 94783000000 0 0 0 460 1840 0 3220 0 0 0 0 3220 0 0 0 0 460 0 2024-09-27 15:16:01.428396 2024-09-27 15:19:56.448828 831763771 1380384264 1659586907 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-09-27 15:19:40.189348 1054763000
mysql cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... 401 97531022000 155333000 243219000 2706270000 23758000000 0 0 0 401 69373 0 401 0 0 0 0 401 0 0 0 0 401 0 2024-09-27 15:16:01.428968 2024-09-27 15:19:56.449358 398107170 912010839 2754228703 SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.... 2024-09-27 15:19:41.026355 457004000
NULL 75eefa1bcb67d11c00c66922236a0a3143f35b84347d81d8b1... SHOW FULL FIELDS FROM `dbdata` . `tbdata` 2 273026000 83591000 136513000 189435000 160000000 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.432456 2024-09-27 15:16:01.433031 190546071 190546071 190546071 SHOW FULL COLUMNS FROM `dbdata`.`tbdata` 2024-09-27 15:16:01.432456 189435000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 257 17024361000 23790000 66242000 274538000 0 0 0 0 257 257 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.432614 2024-09-27 15:19:50.528656 173780082 229086765 275422870 SELECT CURRENT_USER() 2024-09-27 15:19:50.528656 91706000
NULL 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 126 11648276000 45393000 92446000 267041000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.432815 2024-09-27 15:19:44.975768 239883291 275422870 275422870 SHOW GRANTS 2024-09-27 15:18:47.321912 265981000
NULL 36a8f739a944734f4e88e10d905102258a293cf30b182e4c68... SELECT * FROM `dbdata` . `tbdata` LIMIT ? 1 102422000 102422000 102422000 102422000 38000000 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:16:01.433208 2024-09-27 15:16:01.433208 104712854 104712854 104712854 SELECT * FROM `dbdata`.`tbdata` LIMIT 1 2024-09-27 15:16:01.433208 102422000
Query results operations