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 3145113000 3145113000 3145113000 3145113000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:47.579235 2024-06-26 14:45:47.579235 3162277660 3162277660 3162277660 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-06-26 14:45:47.579235 3145113000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 2762 344932175000 25491000 124884000 1093157000 0 0 0 0 2762 2762 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.894516 2024-06-26 14:59:20.741758 239883291 288403150 478630092 SELECT @@version, @@version_comment 2024-06-26 14:58:26.495461 332286000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 2762 204339777000 18812000 73982000 279327000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.894746 2024-06-26 14:59:20.741872 158489319 190546071 239883291 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-06-26 14:59:06.387979 237360000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 2452 216944268000 17375000 88476000 7136319000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.894994 2024-06-26 14:59:20.741984 151356124 199526231 6025595860 SET lc_messages = 'en_US' 2024-06-26 14:59:07.637329 177039000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 2763 660037340000 76029000 238884000 672253000 264356000000 2763 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.895943 2024-06-26 14:59:20.742604 457088189 524807460 660693448 SHOW TABLES FROM `phpmyadmin` 2024-06-26 14:58:26.498008 562042000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 2761 209649336000 19149000 75932000 404465000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.897175 2024-06-26 14:59:20.744189 165958690 199526231 251188643 SET collation_connection = 'utf8mb4_unicode_ci' 2024-06-26 14:59:15.889171 183490000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 1920 276479740000 50166000 143999000 863769000 134176000000 0 0 0 1920 1920 0 0 0 0 0 0 1920 0 0 0 0 0 0 2024-06-26 14:45:54.912373 2024-06-26 14:59:20.758174 251188643 346736850 794328234 SELECT 1 FROM mysql.user LIMIT 1 2024-06-26 14:58:28.731373 764857000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 1169 53096394000 14528000 45420000 509671000 0 0 0 0 1169 1169 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:54.913317 2024-06-26 14:59:20.758672 63095734 75857757 199526231 SELECT DATABASE() 2024-06-26 14:58:28.731936 195683000
sys 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 69 69318827000 595214000 1004620000 5920971000 6159000000 0 0 0 69 39606 0 69 0 0 0 0 138 0 0 0 0 69 0 2024-06-26 14:45:54.918304 2024-06-26 14:59:16.343079 1659586907 6025595860 6025595860 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-06-26 14:58:28.738362 5920971000
sys 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... 8 289126548000 453127000 36140818000 77127099000 1354000000 0 1 0 31 254 0 26 0 0 0 0 20 0 0 586 13 7 0 2024-06-26 14:45:54.995849 2024-06-26 14:58:29.560050 79432823472 79432823472 79432823472 SELECT COUNT(*) AS `row_count` FROM `sys`.`session... 2024-06-26 14:58:28.776022 70715809000
sys 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 5819 1442701674000 205252000 247929000 4457099000 769108000000 0 0 0 5777 34788 0 0 0 0 0 0 5819 0 0 0 0 0 0 2024-06-26 14:45:55.000732 2024-06-26 14:59:16.367950 363078054 478630092 1380384264 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-06-26 14:58:26.599809 1468306000
sys 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 32 1151217000 19850000 35975000 119161000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:55.001538 2024-06-26 14:59:16.273882 66069344 120226443 120226443 SHOW WARNINGS 2024-06-26 14:58:28.756711 119161000
sys 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 38 2051389000 29377000 53983000 218693000 0 0 0 0 38 38 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:55.001785 2024-06-26 14:59:16.274192 144543977 218776162 218776162 SELECT @@lower_case_table_names 2024-06-26 14:58:28.757178 218693000
sys 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 81 75428967000 490547000 931221000 3938535000 40857000000 0 0 0 725 3868 0 81 0 0 0 0 81 0 0 725 81 0 0 2024-06-26 14:45:55.004030 2024-06-26 14:59:16.286297 2884031503 3981071705 3981071705 SHOW  COLUMNS FROM `sys`.`statements_with_errors_o... 2024-06-26 14:58:26.705323 3703194000
sys e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 156 134585272000 423312000 862726000 11949705000 58835000000 0 1 0 11 3739 0 177 11 0 0 0 166 0 0 1296 156 7 0 2024-06-26 14:45:55.005275 2024-06-26 14:59:16.287041 2630267991 7943282347 12022644346 SHOW INDEXES FROM `sys`.`statements_with_errors_or... 2024-06-26 14:58:26.720712 11949705000
sys 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 29 1527288000 35149000 52665000 234714000 0 0 29 0 29 29 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:55.008778 2024-06-26 14:59:16.279885 72443596 239883291 239883291 SELECT @@have_profiling 2024-06-26 14:58:26.563583 54495000
sys 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 52 3224582000 32287000 62011000 188667000 0 0 0 0 52 52 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:56.353400 2024-06-26 14:59:16.344178 109647819 190546071 190546071 SELECT CURRENT_USER() 2024-06-26 14:58:30.751503 97955000
sys 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 31 2145988000 54260000 69225000 111741000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:56.353725 2024-06-26 14:59:16.344388 95499258 114815362 114815362 SHOW GRANTS 2024-06-26 14:58:21.269165 92930000
sys db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 178 107630277000 269208000 604664000 5355922000 36099000000 0 0 0 1634 11354 0 394 266 0 0 0 398 0 0 3004 92 174 0 2024-06-26 14:45:56.359360 2024-06-26 14:59:16.354048 1258925411 2187761623 5495408738 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 2024-06-26 14:58:16.732366 1609756000
sys 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 52 25546243000 381418000 491273000 1001858000 8102000000 0 0 0 52 208 0 364 0 0 0 0 364 0 0 0 0 52 0 2024-06-26 14:45:56.383637 2024-06-26 14:59:16.368657 831763771 1047128548 1047128548 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-06-26 14:58:44.670121 1001858000
NULL 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 352 22850281000 27443000 64915000 285708000 0 0 0 0 352 352 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:56.447467 2024-06-26 14:59:19.946169 173780082 229086765 288403150 SELECT @@lower_case_table_names 2024-06-26 14:59:04.146539 161940000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 666 50504397000 22495000 75832000 1235842000 0 0 0 0 666 666 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-26 14:45:56.447754 2024-06-26 14:59:19.946469 173780082 208929613 1258925411 SELECT CURRENT_USER() 2024-06-26 14:59:17.248238 162575000
NULL 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 581 338290562000 374458000 582255000 4291380000 109766000000 0 0 0 581 2324 0 4067 0 0 0 0 4067 0 0 0 0 581 0 2024-06-26 14:45:56.448462 2024-06-26 14:59:19.947191 1258925411 1905460717 4365158322 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-06-26 14:58:43.448569 1974943000
NULL 2c1d854eee39224e5fcace996a044c9d7b1a5c62507f079689... SELECT ? FROM `INFORMATION_SCHEMA` . `USER_PRIVILE... 56 25370593000 195297000 453046000 1007721000 8321000000 0 0 0 56 8176 0 112 0 0 0 0 168 0 0 0 0 56 0 2024-06-26 14:45:56.448891 2024-06-26 14:59:19.947648 1000000000 1047128548 1047128548 SELECT 1 FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGE... 2024-06-26 14:59:04.151655 929716000
NULL d1a3131f33f7939484023b450706e7c8cd6c56644a0eab0775... ( SELECT `User` , `Host` , `Select_priv` , `Insert... 56 38240308000 289139000 682862000 1680198000 18705000000 0 0 0 224 1232 0 56 0 0 0 0 168 0 0 224 56 56 0 2024-06-26 14:45:56.450141 2024-06-26 14:59:19.948395 1445439770 1737800828 1737800828 (
               SELECT `User`, `Host`, `Select_p...
2024-06-26 14:59:04.154818 1289003000
Query results operations