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_history`
THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT LOCK_TIME SQL_TEXT DIGEST DIGEST_TEXT CURRENT_SCHEMA OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME OBJECT_INSTANCE_BEGIN MYSQL_ERRNO RETURNED_SQLSTATE MESSAGE_TEXT ERRORS WARNINGS ROWS_AFFECTED ROWS_SENT ROWS_EXAMINED CREATED_TMP_DISK_TABLES CREATED_TMP_TABLES SELECT_FULL_JOIN SELECT_FULL_RANGE_JOIN SELECT_RANGE SELECT_RANGE_CHECK SELECT_SCAN SORT_MERGE_PASSES SORT_RANGE SORT_ROWS SORT_SCAN NO_INDEX_USED NO_GOOD_INDEX_USED NESTING_EVENT_ID NESTING_EVENT_TYPE NESTING_EVENT_LEVEL STATEMENT_ID
29 1 1 statement/sql/select srv_session.cc:1107 1954188592000 1955433599000 1245007000 0 SELECT @@skip_networking, @@skip_name_resolve, @@h... 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... SELECT @@`skip_networking` , @@`skip_name_resolve`... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 2
4787 1 1 statement/sql/show_tables init_net_server_extension.cc:95 607433589927000 607433887468000 297541000 145000000 SHOW TABLES FROM `phpmyadmin` f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336774
4787 2 2 statement/com/Init DB init_net_server_extension.cc:95 607434204192000 607434314875000 110683000 40000000 NULL NULL NULL NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336776
4788 1 1 statement/sql/show_tables init_net_server_extension.cc:95 607434863675000 607435077945000 214270000 84000000 SHOW TABLES FROM `phpmyadmin` f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336777
4788 2 2 statement/com/Init DB init_net_server_extension.cc:95 607435746581000 607435897679000 151098000 67000000 NULL NULL NULL NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336778
4789 1 1 statement/sql/select init_net_server_extension.cc:95 607431988866000 607432123077000 134211000 0 SELECT @@version, @@version_comment a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336769
4789 2 2 statement/sql/set_option init_net_server_extension.cc:95 607432416955000 607432499976000 83021000 0 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336770
4789 3 3 statement/sql/set_option init_net_server_extension.cc:95 607432865107000 607432937997000 72890000 0 SET lc_messages = 'en_US' 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336773
4789 4 4 statement/sql/set_option init_net_server_extension.cc:95 607436405966000 607436460437000 54471000 0 SET collation_connection = 'utf8mb4_unicode_ci' d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336779
4789 5 5 statement/com/Init DB init_net_server_extension.cc:95 607437850509000 607437911747000 61238000 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336782
4789 6 6 statement/sql/select init_net_server_extension.cc:95 607438249471000 607441448849000 3199378000 327000000 SELECT 1 FROM `sys`.`x$user_summary_by_statement_l... 7b69698fb330ffe8d6147fda49c0f15b1c7a2c948d2593ec48... SELECT IF ( ( `performance_schema` . `events_state... sys NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 2 0 0 0 0 2 0 0 3 1 1 0 NULL NULL 0 336783
4789 7 8 statement/sql/show_fields init_net_server_extension.cc:95 607441842927000 607442939270000 1096343000 604000000 SHOW FULL COLUMNS FROM `sys`.`x$user_summary_by_st... 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys NULL NULL NULL NULL 0 NULL NULL 0 0 0 9 48 0 1 0 0 0 0 1 0 0 9 1 0 0 NULL NULL 0 336785
4789 9 10 statement/sql/show_keys init_net_server_extension.cc:95 607443302221000 607444195366000 893145000 466000000 SHOW INDEXES FROM `sys`.`x$user_summary_by_stateme... e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... sys NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 1 0 0 0 0 1 0 0 0 1 0 0 NULL NULL 0 336790
4789 11 11 statement/sql/select init_net_server_extension.cc:95 607444496102000 607444565550000 69448000 0 SELECT @@character_set_connection 8a4675bb5f23844991a9f25bd418d7919fbf8025fb9e3f0f0e... SELECT @@`character_set_connection` sys NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336795
4790 1 1 statement/sql/select init_net_server_extension.cc:95 607432433786000 607432543209000 109423000 0 SELECT @@version, @@version_comment a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336771
4790 2 2 statement/sql/set_option init_net_server_extension.cc:95 607432853208000 607432924232000 71024000 0 SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci' 52eaff6a7819ec096aa8c71501acd23ef138f2a775fc2827cc... SET NAMES ? COLLATE ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336772
4790 3 3 statement/sql/set_option init_net_server_extension.cc:95 607433913733000 607433964993000 51260000 0 SET lc_messages = 'en_US' 67915ea6a14edd3032a0638d83d09c9966d5db926c1ce4edec... SET `lc_messages` = ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336775
4790 4 4 statement/sql/set_option init_net_server_extension.cc:95 607437079825000 607437142520000 62695000 0 SET collation_connection = 'utf8mb4_unicode_ci' d19d8b57dd28aea9deadc6222a76498766306a49d23a503f10... SET `collation_connection` = ? NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336780
4790 5 6 statement/sql/select init_net_server_extension.cc:95 607442701982000 607442797823000 95841000 43000000 SELECT 1 FROM mysql.user LIMIT 1 caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... SELECT ? FROM `mysql` . `user` LIMIT ? NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 336788
4790 7 7 statement/sql/select init_net_server_extension.cc:95 607443373979000 607443423456000 49477000 0 SELECT DATABASE() ce04eda080d3f5605113e1d0d47c2f20e23b091e2487ba586f... SELECT SCHEMA ( ) NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336791
4790 8 8 statement/com/Init DB init_net_server_extension.cc:95 607443624662000 607443675802000 51140000 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 00000 NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336792
4790 9 9 statement/sql/show_variables init_net_server_extension.cc:95 607443794396000 607445001742000 1207346000 84000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 574 0 1 0 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 336793
4791 1 1 statement/sql/show_tables init_net_server_extension.cc:95 607442501725000 607442671715000 169990000 64000000 SHOW TABLES FROM `phpmyadmin` f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... SHOW TABLES FROM `phpmyadmin` NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336787
4791 2 2 statement/com/Init DB init_net_server_extension.cc:95 607442978514000 607443060284000 81770000 32000000 NULL NULL NULL NULL NULL NULL NULL NULL 1049 42000 Unknown database 'phpmyadmin' 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336789
4792 1 1 statement/sql/select init_net_server_extension.cc:95 607437414262000 607437520700000 106438000 0 SELECT @@version, @@version_comment a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... SELECT @@`version` , @@`version_comment` NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 336781
Query results operations