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 3182001000 3182001000 3182001000 3182001000 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:47.824535 2024-09-27 15:00:47.824535 3311311214 3311311214 3311311214 SELECT @@skip_networking, @@skip_name_resolve, @@h... 2024-09-27 15:00:47.824535 3182001000
NULL a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` 5475 604808785000 30170000 110467000 538424000 0 0 0 0 5475 5475 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.580508 2024-09-27 15:14:56.745941 239883291 288403150 346736850 SELECT @@version, @@version_comment 2024-09-27 15:14:11.128668 335744000
NULL 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? 5475 354383925000 16483000 64727000 251862000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.580663 2024-09-27 15:14:56.746055 151356124 181970085 229086765 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 2024-09-27 15:14:24.101522 198351000
NULL 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? 5326 384261690000 15264000 72148000 12640886000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.580752 2024-09-27 15:14:56.746126 151356124 181970085 5248074602 SET lc_messages = 'da_DK' 2024-09-27 15:14:49.456546 184615000
NULL f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` 5476 1171682122000 69539000 213966000 953482000 474787000000 5476 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.581614 2024-09-27 15:14:56.746385 457088189 549540873 691830970 SHOW TABLES FROM `phpmyadmin` 2024-09-27 15:14:22.498600 546094000
NULL d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? 5475 358164449000 17661000 65418000 1170711000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.582716 2024-09-27 15:14:56.747373 158489319 190546071 251188643 SET collation_connection = 'utf8mb4_unicode_ci' 2024-09-27 15:14:30.860174 470486000
NULL caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? 4728 667174329000 47131000 141111000 19341868000 328898000000 0 0 0 4728 4728 0 0 0 0 0 0 4728 0 0 0 0 0 0 2024-09-27 15:00:54.599207 2024-09-27 15:14:56.763646 208929613 316227766 549540873 SELECT 1 FROM mysql.user LIMIT 1 2024-09-27 15:14:25.004572 602951000
NULL ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) 2830 126106322000 13261000 44560000 473503000 0 0 0 0 2830 2830 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.600094 2024-09-27 15:14:56.764386 66069344 87096358 131825673 SELECT DATABASE() 2024-09-27 15:14:23.749387 101960000
mysql 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? 2097 1764936851000 624149000 841648000 5279970000 185308000000 0 0 0 2097 1203678 0 2097 0 0 0 0 4194 0 0 0 0 2097 0 2024-09-27 15:00:54.605777 2024-09-27 15:14:54.412224 1202264434 1737800828 2754228703 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 2024-09-27 15:14:16.674384 1729373000
mysql ecdec0fbdec49cd12d846dfeefc4ea36902225488125f17b13... SELECT * FROM `user` LIMIT ?, ... 929 167841590000 112826000 180669000 827347000 58439000000 0 0 0 6195 6195 0 0 0 0 0 0 929 0 0 0 0 929 0 2024-09-27 15:00:54.606407 2024-09-27 15:14:54.346917 263026799 331131121 831763771 SELECT * FROM `user` LIMIT 0, 25 2024-09-27 15:13:54.757483 443639000
mysql 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS 1010 31354811000 13230000 31044000 174144000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.606743 2024-09-27 15:14:54.347299 43651583 60255958 72443596 SHOW WARNINGS 2024-09-27 15:14:35.532082 61332000
mysql 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 1208 56602445000 21836000 46856000 142064000 0 0 0 0 1208 1208 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.607086 2024-09-27 15:14:55.588652 69183097 91201083 131825673 SELECT @@lower_case_table_names 2024-09-27 15:14:46.586803 142064000
mysql 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 10920 1765005429000 70521000 161630000 4748683000 239213000000 9759 0 0 0 3481 0 0 0 0 0 0 1161 0 0 0 0 0 0 2024-09-27 15:00:54.611935 2024-09-27 15:14:55.589800 363078054 524807460 1000000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 15:14:13.754900 702540000
mysql 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2640 1377567622000 161805000 521805000 4226564000 242946000000 2016 0 0 25853 132546 0 559 0 0 0 0 624 0 0 25585 559 0 0 2024-09-27 15:00:54.615807 2024-09-27 15:14:55.560057 1258925411 1737800828 3467368504 SHOW FULL COLUMNS FROM `mysql`.`user` 2024-09-27 15:14:22.554263 1051400000
NULL 6737a4df618b229813d6fbb82717cbe2f6df37f6b6c6694c53... SHOW TABLES FROM `fearzonedbs` 15 2434711000 91033000 162314000 686618000 1126000000 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.643007 2024-09-27 15:01:45.403390 691830970 691830970 691830970 SHOW TABLES FROM `fearzonedbs` 2024-09-27 15:00:54.643007 686618000
NULL 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 1724 117131880000 19087000 67941000 540129000 0 0 0 0 1724 1724 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.649973 2024-09-27 15:14:56.291670 173780082 199526231 288403150 SELECT CURRENT_USER() 2024-09-27 15:14:36.201924 183644000
NULL 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 917 92896495000 41444000 101304000 506163000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.650935 2024-09-27 15:14:56.291816 239883291 288403150 524807460 SHOW GRANTS 2024-09-27 15:14:52.029092 289564000
mysql e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1869 979065838000 152828000 523844000 90268222000 115051000000 1563 0 0 632 17330 0 306 0 0 0 0 306 0 0 632 306 0 0 2024-09-27 15:00:54.652287 2024-09-27 15:14:54.350724 794328234 1096478196 83176377110 SHOW INDEXES FROM `mysql`.`user` 2024-09-27 15:14:49.270408 1445513000
mysql 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 1028 330391889000 124085000 321392000 131159647000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.656094 2024-09-27 15:14:54.351041 263026799 398107170 12022644346 SHOW CREATE TABLE `mysql`.`user` 2024-09-27 15:14:02.824533 314499000
NULL db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... 4072 1194311060000 72816000 293298000 8310430000 247387000000 3095 0 0 9926 64477 0 2244 1345 0 0 0 2244 0 0 18478 580 977 0 2024-09-27 15:00:54.660103 2024-09-27 15:14:56.315308 954992586 1584893192 3801893963 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... 2024-09-27 15:14:39.705761 562334000
mysql ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 3789 1366013420000 190661000 360520000 37121886000 119931000000 3512 0 0 371 46352 0 274 226 0 0 0 277 0 0 371 277 226 0 2024-09-27 15:00:54.704862 2024-09-27 15:14:55.589504 794328234 1380384264 13803842646 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... 2024-09-27 15:14:16.797157 1725335000
NULL 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 1270 260934413000 82200000 205460000 1504092000 64222000000 980 0 0 0 318 0 0 0 0 0 0 290 0 0 0 0 0 0 2024-09-27 15:00:54.715869 2024-09-27 15:14:56.328175 457088189 575439937 870963589 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 2024-09-27 15:14:43.728531 245257000
NULL 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` 613 34750898000 28551000 56689000 255858000 0 0 0 0 613 613 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.716204 2024-09-27 15:14:56.326913 158489319 199526231 263026799 SELECT @@lower_case_table_names 2024-09-27 15:14:30.870684 163258000
NULL ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... 2067 1233682558000 188444000 596846000 18332015000 280224000000 1586 0 0 14870 51170 0 172 168 0 0 0 481 0 0 14870 481 168 0 2024-09-27 15:00:54.717354 2024-09-27 15:14:56.595428 1318256738 3019951720 15135612484 SHOW TABLES FROM `information_schema` 2024-09-27 15:14:29.985536 1482571000
NULL 359f6bd78d51dcc8b66e843aa1e1fe857dbeb83505a8f51958... SHOW TABLE STATUS FROM `fearzonedbs` WHERE `Name` ... 152 16944574000 70963000 111477000 666046000 9175000000 152 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2024-09-27 15:00:54.717802 2024-09-27 15:02:33.454266 151356124 229086765 691830970 SHOW TABLE STATUS FROM `fearzonedbs` WHERE `Name` ... 2024-09-27 15:02:33.454266 104585000
Query results operations