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 4011227000 4011227000 4011227000 4011227000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:30:47.596541 2024-06-17 17:30:47.596541 4168693834 4168693834 4168693834 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-06-17 17:30:47.596541 4011227000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 1650 210034474000 32124000 127293000 355550000 0 0 0 0 1650 1650 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.787516 2024-06-17 17:43:40.854225 251188643 288403150 346736850 SELECT @@version, @@version_comment 2024-06-17 17:42:58.367975 275645000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 1650 122117855000 19536000 74010000 273632000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.787700 2024-06-17 17:43:40.855224 151356124 181970085 229086765 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-06-17 17:43:39.538806 221226000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 1646 164411345000 17935000 99885000 11264522000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.787835 2024-06-17 17:43:40.856043 151356124 199526231 6918309709 SET lc_messages = 'sk_SK' 2024-06-17 17:42:42.566861 6883829000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 1650 397102288000 85537000 240668000 601686000 160561000000 1650 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.789233 2024-06-17 17:43:40.860379 457088189 549540873 602559586 SHOW TABLES FROM `phpmyadmin` 2024-06-17 17:43:40.250827 505847000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 1650 124446597000 17519000 75422000 375752000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.790304 2024-06-17 17:43:40.867599 165958690 199526231 380189396 SET collation_connection = 'utf8mb4_unicode_ci' 2024-06-17 17:42:51.472531 207946000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 994 151809515000 53915000 152725000 1182818000 70301000000 0 0 0 994 994 0 0 0 0 0 0 994 0 0 0 0 0 0 2024-06-17 17:31:00.806041 2024-06-17 17:43:40.926662 316227766 380189396 1202264434 SELECT 1 FROM mysql.user LIMIT 1 2024-06-17 17:42:42.983503 389540000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 186 8615065000 29225000 46317000 361555000 0 0 0 0 186 186 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:00.806917 2024-06-17 17:43:40.927228 60255958 151356124 363078054 SELECT DATABASE() 2024-06-17 17:43:15.536718 52335000
sys 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 4 10244076000 1192203000 2561019000 5306508000 735000000 0 0 0 4 2296 0 4 0 0 0 0 8 0 0 0 0 4 0 2024-06-17 17:31:00.813110 2024-06-17 17:31:02.708997 5495408738 5495408738 5495408738 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-06-17 17:31:00.813110 5306508000
sys ee72cacf10b2704fde362c8b42bdba0f6faba253127d7ddc77... SELECT IF ( ( `locate` ( ? , `ibp` . `TABLE_NAME` ... 3 489454739000 273096000 163151579000 468790184000 418000000 0 1 0 2 2 2 9 0 0 0 0 4 0 0 486 4 2 0 2024-06-17 17:31:01.282290 2024-06-17 17:31:01.518066 478630092322 478630092322 478630092322 SELECT * FROM `innodb_buffer_stats_by_schema` LIMI... 2024-06-17 17:31:01.282290 468790184000
sys 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 2 194518000 80613000 97259000 113905000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.282941 2024-06-17 17:31:02.667437 114815362 114815362 114815362 SHOW WARNINGS 2024-06-17 17:31:02.667437 113905000
sys 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 2 485583000 78420000 242791000 407163000 0 0 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.283670 2024-06-17 17:31:02.667987 416869383 416869383 416869383 SELECT @@lower_case_table_names 2024-06-17 17:31:02.667987 407163000
sys 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 42 42371918000 249223000 1008855000 22899502000 10709000000 0 0 0 37 237 0 0 0 0 0 0 42 0 0 0 0 0 0 2024-06-17 17:31:01.306788 2024-06-17 17:37:59.272431 1000000000 22908676527 22908676527 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-06-17 17:37:59.271341 382561000
sys 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 6 5635156000 714213000 939192000 1382239000 2522000000 0 0 0 33 183 0 6 0 0 0 0 6 0 0 33 6 0 0 2024-06-17 17:31:01.308340 2024-06-17 17:37:59.224533 1445439770 1445439770 1445439770 SHOW FULL COLUMNS FROM `sys`.`x$schema_index_stati... 2024-06-17 17:37:59.224533 730152000
sys e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 10 7715902000 523436000 771590000 1046751000 4327000000 0 0 0 0 30 0 10 0 0 0 0 10 0 0 0 10 0 0 2024-06-17 17:31:01.309545 2024-06-17 17:37:59.225379 1047128548 1047128548 1047128548 SHOW INDEXES FROM `sys`.`x$schema_index_statistics... 2024-06-17 17:37:59.225379 523436000
NULL 4003a7cc2a8e25e7779574bb3bb2c41ef9cbb74924d5cc2b5a... SELECT ? FROM `zalupa` . `users` LIMIT ? 6 1550725000 105791000 258454000 488506000 621000000 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.332279 2024-06-17 17:31:13.919790 501187233 501187233 501187233 SELECT 1 FROM `zalupa`.`users` LIMIT 1 2024-06-17 17:31:10.992756 488506000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 712 57853801000 22372000 81255000 248334000 0 0 0 0 712 712 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.364440 2024-06-17 17:43:39.593042 181970085 218776162 251188643 SELECT CURRENT_USER() 2024-06-17 17:42:56.094690 224473000
NULL 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 249 30556900000 48291000 122718000 1069304000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.364652 2024-06-17 17:43:36.401170 251188643 288403150 1096478196 SHOW GRANTS 2024-06-17 17:42:41.620037 225984000
mysql 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 311 197858357000 391158000 636200000 2316711000 69795000000 0 0 0 311 1244 0 2177 0 0 0 0 2177 0 0 0 0 311 0 2024-06-17 17:31:01.366511 2024-06-17 17:43:39.714261 1737800828 1819700858 2398832919 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-06-17 17:43:16.057986 748464000
mysql 2c1d854eee39224e5fcace996a044c9d7b1a5c62507f079689... SELECT ? FROM `INFORMATION_SCHEMA` . `USER_PRIVILE... 75 36938963000 191746000 492519000 1055715000 12196000000 0 0 0 75 10950 0 150 0 0 0 0 225 0 0 0 0 75 0 2024-06-17 17:31:01.367093 2024-06-17 17:43:21.492822 1047128548 1096478196 1096478196 SELECT 1 FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGE... 2024-06-17 17:43:21.492822 325122000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 219 243680071000 452081000 1112694000 6347996000 107230000000 0 0 0 6532 34305 0 199 0 0 0 0 219 0 0 6464 199 0 0 2024-06-17 17:31:01.368386 2024-06-17 17:43:39.611807 2630267991 3311311214 6606934480 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-06-17 17:43:37.530696 947036000
mysql c9871d1fb65a3d7607814b7e30013cad125215e23e190a170c... SELECT SYSTEM_USER ( ) 152 10009274000 26750000 65850000 200288000 0 0 0 0 152 152 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.368514 2024-06-17 17:43:36.898192 158489319 190546071 208929613 SELECT USER() 2024-06-17 17:43:18.306711 73478000
mysql 96f3f55029855ef698a413fe05164e171b4470740f42c110f3... SELECT @@`default_authentication_plugin` 10 478276000 26152000 47827000 162806000 0 0 0 0 10 10 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.368613 2024-06-17 17:41:38.754874 165958690 165958690 165958690 SELECT @@default_authentication_plugin 2024-06-17 17:41:38.754874 43684000
mysql da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a... SELECT `PLUGIN_NAME` , `PLUGIN_DESCRIPTION` FROM `... 12 18691207000 213158000 1557600000 13679847000 8454000000 0 0 0 48 540 12 12 0 0 0 0 12 0 0 0 0 12 0 2024-06-17 17:31:01.369511 2024-06-17 17:41:38.755474 13803842646 13803842646 13803842646 SELECT `PLUGIN_NAME`, `PLUGIN_DESCRIPTION` FROM `i... 2024-06-17 17:41:37.958221 369049000
sys 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 4 320409000 59169000 80102000 110784000 0 0 0 0 4 4 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-06-17 17:31:01.413737 2024-06-17 17:37:59.240212 114815362 114815362 114815362 SELECT CURRENT_USER() 2024-06-17 17:37:59.240212 89435000
Query results operations