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` 3498 390652011000 24842000 111678000 1463139000 0 0 0 0 3498 3498 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.201685 2024-09-27 14:56:46.530461 239883291 275422870 549540873 SELECT @@version, @@version_comment 2024-09-27 14:56:45.660868 219933000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 3498 226622594000 14648000 64786000 1036891000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.201883 2024-09-27 14:56:46.530862 151356124 181970085 288403150 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-09-27 14:56:31.351554 245390000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 3356 251890259000 14606000 75056000 6591929000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.201986 2024-09-27 14:56:46.531180 151356124 190546071 5011872336 SET lc_messages = 'en_US' 2024-09-27 14:56:01.187939 187738000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 3571 771111644000 59140000 215937000 2000507000 312501000000 3571 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.203193 2024-09-27 14:56:46.531881 457088189 549540873 870963589 SHOW TABLES FROM `phpmyadmin` 2024-09-27 14:56:46.527873 359913000
NULL ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1068 1411848157000 411381000 1321955000 14016407000 696944000000 0 0 0 41661 188694 0 204 204 0 0 0 1068 0 0 41657 1064 204 0 2024-09-27 14:46:30.209397 2024-09-27 14:56:44.871523 3019951720 4168693834 13182567385 SHOW TABLES FROM `mysql` 2024-09-27 14:55:46.184106 4627690000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 3497 234210446000 15396000 66974000 1195762000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.210605 2024-09-27 14:56:46.534147 158489319 190546071 263026799 SET collation_connection = 'utf8mb4_unicode_ci' 2024-09-27 14:56:17.995582 187124000
NULL 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... SELECT @@`skip_networking` , @@`skip_name_resolve`... 1 107933000 107933000 107933000 107933000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.234387 2024-09-27 14:46:30.234387 109647819 109647819 109647819 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-09-27 14:46:30.234387 107933000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 2768 389518089000 47830000 140721000 425118000 191463000000 0 0 0 2768 2768 0 0 0 0 0 0 2768 0 0 0 0 0 0 2024-09-27 14:46:30.242034 2024-09-27 14:56:46.562491 218776162 316227766 416869383 SELECT 1 FROM mysql.user LIMIT 1 2024-09-27 14:56:09.511849 419561000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 1904 85682231000 13195000 45001000 981869000 0 0 0 0 1904 1904 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.245039 2024-09-27 14:56:46.563013 63095734 79432823 724435960 SELECT DATABASE() 2024-09-27 14:56:14.559364 121288000
information_schema 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 1114 949627566000 617709000 852448000 9723823000 98117000000 0 0 0 1114 639436 0 1114 0 0 0 0 2228 0 0 0 0 1114 0 2024-09-27 14:46:30.255425 2024-09-27 14:56:44.935965 1202264434 1737800828 9549925860 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-09-27 14:56:09.686777 1467766000
information_schema c91b05f96eab9ded75917f26179e25a3cabd429adea74f1287... SELECT * FROM `TABLESPACES` LIMIT ?, ... 46 4719362000 75603000 102594000 178449000 2934000000 0 0 0 0 0 0 46 0 0 0 0 46 0 0 0 0 46 0 2024-09-27 14:46:30.255839 2024-09-27 14:56:44.411794 144543977 181970085 181970085 SELECT * FROM `TABLESPACES` LIMIT 0, 25 2024-09-27 14:56:21.063598 147302000
information_schema 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 556 18716774000 9788000 33663000 156819000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.256430 2024-09-27 14:56:44.891231 54954087 125892541 158489319 SHOW WARNINGS 2024-09-27 14:56:42.076456 37160000
information_schema 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` 234 12450935000 34457000 53209000 187612000 0 0 234 0 234 234 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.256798 2024-09-27 14:56:43.602346 87096358 114815362 190546071 SELECT @@have_profiling 2024-09-27 14:55:46.249045 86069000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 1320 1115548589000 613388000 845112000 4081819000 118732000000 0 0 0 1320 757680 0 1320 0 0 0 0 2640 0 0 0 0 1320 0 2024-09-27 14:46:30.257345 2024-09-27 14:56:45.691666 1258925411 1905460717 3311311214 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-09-27 14:56:01.219627 3265802000
information_schema 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 557 26315945000 20501000 47245000 256946000 0 0 0 0 557 557 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.257834 2024-09-27 14:56:44.891526 69183097 173780082 263026799 SELECT @@lower_case_table_names 2024-09-27 14:56:42.076831 46244000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 534 98797750000 113976000 185014000 624487000 33231000000 0 0 0 4820 4820 0 0 0 0 0 0 534 0 0 0 0 534 0 2024-09-27 14:46:30.258005 2024-09-27 14:56:44.130308 263026799 316227766 630957344 SELECT * FROM `user` LIMIT 0, 25 2024-09-27 14:56:42.292158 274635000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 593 18493151000 12706000 31185000 92401000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.258285 2024-09-27 14:56:44.803568 47863009 75857757 95499258 SHOW WARNINGS 2024-09-27 14:56:29.897203 49562000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 729 35211536000 21490000 48301000 167710000 0 0 0 0 729 729 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.258581 2024-09-27 14:56:44.803950 79432823 100000000 173780082 SELECT @@lower_case_table_names 2024-09-27 14:56:14.998935 167710000
mysql 388a47c21e57ff94b264c6499629cd2cb3f420247ed7507029... SELECT ? FROM `mysql` . `help_topic` LIMIT ? 28 31559469000 77307000 1127123000 27394370000 2754000000 0 0 0 28 28 0 0 0 0 0 0 28 0 0 0 0 0 0 2024-09-27 14:46:30.277203 2024-09-27 14:56:31.508616 251188643 27542287033 27542287033 SELECT 1 FROM `mysql`.`help_topic` LIMIT 1 2024-09-27 14:56:31.508616 165937000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 3036 1066425851000 209193000 351260000 19652659000 605601000000 0 0 0 0 9106 0 0 0 0 0 0 3036 0 0 0 0 0 0 2024-09-27 14:46:30.278398 2024-09-27 14:56:44.810155 524807460 724435960 1995262314 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 14:56:36.423935 947350000
mysql 45a1e2d24be37faad9b0bea028d930d6fba8d206e1c8d03e40... SELECT * FROM `mysql` . `help_topic` LIMIT ? 12 1060493000 69258000 88374000 115477000 454000000 0 0 0 12 12 0 0 0 0 0 0 12 0 0 0 0 12 0 2024-09-27 14:46:30.278492 2024-09-27 14:56:31.408068 120226443 120226443 120226443 SELECT * FROM `mysql`.`help_topic` LIMIT 1 2024-09-27 14:56:31.408068 91965000
information_schema e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2196 1733861461000 251050000 789554000 285349253000 794940000000 0 0 0 468 18753 0 2142 18 0 0 0 2178 0 0 0 2142 18 0 2024-09-27 14:46:30.278929 2024-09-27 14:56:44.898163 954992586 2187761623 20892961308 SHOW INDEXES FROM `information_schema`.`STATISTICS... 2024-09-27 14:56:08.049965 1394093000
information_schema 85fcf4c6bfd4b3011d24e945d53864428e24dd2378b77d4432... SELECT `col` . `name` AS `COLLATION_NAME` , `cs` .... 6657 7044592533000 100331000 1058223000 24545474000 795142000000 0 0 0 9021 278227 0 6566 0 0 0 0 6749 0 0 0 0 183 0 2024-09-27 14:46:30.280402 2024-09-27 14:56:44.978590 1737800828 2290867652 3981071705 SELECT `COLLATION_NAME` FROM `information_schema`.... 2024-09-27 14:56:39.566347 3153305000
information_schema c5055e3518189598a3704568878c673216db014689b92ee25f... SHOW CREATE TABLE `information_schema` . `TABLESPA... 46 3175042000 47992000 69022000 108634000 0 0 0 0 0 0 0 46 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 14:46:30.280537 2024-09-27 14:56:44.414064 91201083 109647819 109647819 SHOW CREATE TABLE `information_schema`.`TABLESPACE... 2024-09-27 14:56:04.804575 82194000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1724 1660603705000 443747000 963227000 4799933000 654615000000 0 0 0 65267 335374 0 1498 0 0 0 0 1724 0 0 64349 1498 0 0 2024-09-27 14:46:30.281573 2024-09-27 14:56:44.812174 1737800828 2187761623 3630780547 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-09-27 14:56:29.915021 2061126000
Query results operations