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` 8162 644664729000 24098000 78983000 2185864000 0 0 0 0 8162 8162 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.289825 2024-07-28 03:14:52.073502 125892541 229086765 549540873 SELECT @@version, @@version_comment 2024-07-28 03:14:27.314887 338657000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 8162 352473560000 13784000 43184000 1208787000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.290013 2024-07-28 03:14:52.073731 72443596 144543977 251188643 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-07-28 03:14:49.918754 217400000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 8048 328682628000 11807000 40840000 3003898000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.290124 2024-07-28 03:14:52.073834 66069344 144543977 2187761623 SET lc_messages = 'en_US' 2024-07-28 03:14:27.316580 188678000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 8162 1251493893000 66555000 153331000 1863602000 516570000000 8162 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.290769 2024-07-28 03:14:52.074152 218776162 436515832 870963589 SHOW TABLES FROM `phpmyadmin` 2024-07-28 03:14:13.425358 824325000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 8162 394733247000 15378000 48362000 1663590000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.291982 2024-07-28 03:14:52.075074 87096358 144543977 275422870 SET collation_connection = 'utf8mb4_unicode_ci' 2024-07-28 03:13:57.297125 246185000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 7510 1088698987000 47295000 144966000 3809959000 535312000000 0 0 0 7510 7510 0 0 0 0 0 0 7510 0 0 0 0 0 0 2024-07-28 03:01:04.299864 2024-07-28 03:14:52.073544 208929613 251188643 870963589 SELECT 1 FROM mysql.user LIMIT 1 2024-07-28 03:14:49.945134 689573000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 892 52070800000 23407000 58375000 332425000 0 0 0 0 892 892 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.300288 2024-07-28 03:14:52.026824 104712854 151356124 346736850 SELECT CURRENT_USER() 2024-07-28 03:14:45.398875 100565000
NULL 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... 815 481002403000 356593000 590186000 3691290000 157902000000 0 0 0 815 3190 0 5705 0 0 0 0 5705 0 0 0 0 815 0 2024-07-28 03:01:04.302416 2024-07-28 03:14:51.831995 831763771 1659586907 3801893963 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 2024-07-28 03:14:42.072303 805410000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 6556 369753399000 16516000 56399000 2292679000 0 0 0 0 6556 6556 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.338052 2024-07-28 03:14:52.074185 100000000 125892541 229086765 SELECT DATABASE() 2024-07-28 03:14:36.861362 123616000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 3642 3320490463000 609295000 911721000 8082834000 346949000000 0 0 0 3642 2090508 0 3642 0 0 0 0 7284 0 0 0 0 3642 0 2024-07-28 03:01:04.341753 2024-07-28 03:14:51.341016 1318256738 1995262314 3981071705 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-07-28 03:14:49.485917 2329252000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 1769 373730808000 106061000 211266000 1980941000 131136000000 0 0 0 15643 15643 0 0 0 0 0 0 1769 0 0 0 0 1769 0 2024-07-28 03:01:04.342244 2024-07-28 03:14:51.194488 288403150 380189396 1995262314 SELECT * FROM `user` LIMIT 0, 25 2024-07-28 03:14:18.477304 850178000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 1776 59537447000 13918000 33523000 1047540000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.342509 2024-07-28 03:14:51.194832 52480746 75857757 478630092 SHOW WARNINGS 2024-07-28 03:14:49.487377 477035000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 2128 112812819000 25771000 53013000 455581000 0 0 0 0 2128 2128 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.343042 2024-07-28 03:14:51.985062 95499258 131825673 190546071 SELECT @@lower_case_table_names 2024-07-28 03:14:43.424182 184760000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 10203 3737273245000 72900000 366291000 3240885000 1963657000000 1738 0 0 0 25395 0 0 0 0 0 0 8465 0 0 0 0 0 0 2024-07-28 03:01:04.345768 2024-07-28 03:14:51.986283 602559586 912010839 2511886431 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-07-28 03:14:49.488672 1055623000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 4254 4846795167000 231163000 1139350000 10749099000 1641771000000 339 0 0 197278 1006385 0 3903 0 0 0 0 3915 0 0 197245 3903 0 0 2024-07-28 03:01:04.347673 2024-07-28 03:14:51.943893 1819700858 2884031503 6309573444 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-07-28 03:14:50.939429 1502059000
performance_schema 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 9047 8131733112000 585829000 898832000 5286146000 846404000000 0 0 0 9047 5192978 0 9047 0 0 0 0 18094 0 0 0 0 9047 0 2024-07-28 03:01:04.359826 2024-07-28 03:14:52.075987 1258925411 1819700858 3630780547 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-07-28 03:14:45.949509 2815458000
performance_schema 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... SELECT * FROM `table_lock_waits_summary_by_table` ... 4118 1280028215000 166122000 310837000 4713099000 313413000000 0 0 0 102950 102950 0 0 0 0 0 0 4118 0 0 0 0 4118 0 2024-07-28 03:01:04.364797 2024-07-28 03:14:52.049858 457088189 630957344 2630267991 SELECT * FROM `table_lock_waits_summary_by_table` ... 2024-07-28 03:14:43.012153 553587000
performance_schema 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 14233 4524534821000 71817000 317890000 6982509000 2091210000000 5329 0 0 0 26709 0 0 0 0 0 0 8903 0 0 0 0 0 0 2024-07-28 03:01:04.365990 2024-07-28 03:14:52.080527 549540873 758577575 2290867652 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-07-28 03:14:29.847315 1261744000
performance_schema 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 4527 217559431000 22000000 48058000 1415432000 0 0 0 0 4527 4527 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.366294 2024-07-28 03:14:52.053724 72443596 104712854 316227766 SELECT @@lower_case_table_names 2024-07-28 03:14:45.777089 84535000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2213 2091091582000 153789000 944912000 189170775000 758104000000 280 0 0 3873 127173 0 1933 0 0 0 0 1933 0 0 3873 1933 0 0 2024-07-28 03:01:04.387822 2024-07-28 03:14:51.197516 1047128548 1905460717 91201083935 SHOW INDEXES FROM `mysql`.`user` 2024-07-28 03:13:57.934037 425571000
performance_schema ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 6404 6273098860000 182240000 979559000 22067540000 2066642000000 2260 0 0 4144 1739762 0 4144 4144 0 0 0 4144 0 0 4144 4144 4144 0 2024-07-28 03:01:04.388526 2024-07-28 03:14:52.078552 1737800828 2187761623 3981071705 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-07-28 03:14:42.877644 1499107000
performance_schema 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... SELECT COUNT ( * ) FROM `performance_schema` . `ta... 4118 1636928825000 207228000 397505000 5364849000 180167000000 0 0 0 4118 0 0 0 0 0 0 0 4118 0 0 0 0 4118 0 2024-07-28 03:01:04.389647 2024-07-28 03:14:52.054988 575439937 1047128548 2187761623 SELECT COUNT(*) FROM `performance_schema`.`table_l... 2024-07-28 03:14:08.814561 1042664000
mysql 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 959 48617164000 30402000 50695000 337613000 0 0 959 0 959 959 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.389718 2024-07-28 03:14:50.405661 75857757 104712854 346736850 SELECT @@have_profiling 2024-07-28 03:14:50.405661 83224000
performance_schema 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 4524 130474048000 12005000 28840000 470311000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.389806 2024-07-28 03:14:52.055334 45708818 66069344 165958690 SHOW WARNINGS 2024-07-28 03:14:25.630797 205208000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 2091 416810166000 106327000 199335000 2188638000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-07-28 03:01:04.390682 2024-07-28 03:14:51.944640 288403150 416869383 1905460717 SHOW CREATE TABLE `mysql`.`user` 2024-07-28 03:14:46.015361 515208000
Query results operations