Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Set default
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`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
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
28 1 1 statement/sql/select srv_session.cc:1107 2551867080000 2552979788000 1112708000 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
620 1 1 statement/sql/show_tables init_net_server_extension.cc:95 710735969619000 710736400126000 430507000 161000000 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 9030
620 2 2 statement/com/Init DB init_net_server_extension.cc:95 710737333243000 710737562322000 229079000 76000000 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 9031
620 3 3 statement/sql/show_tables init_net_server_extension.cc:95 710740880698000 710741188151000 307453000 139000000 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 9033
620 4 4 statement/sql/show_tables init_net_server_extension.cc:95 710742063872000 710742297471000 233599000 0 SHOW TABLES FROM `performance_schema` c9d768b3113445f3bca2bb6f40efee9bd37dc33b4ef897c4fa... SHOW TABLES FROM `performance_schema` NULL NULL NULL NULL NULL 1044 42000 Access denied for user 'pma'@'192.168.30.%' to dat... 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 9034
621 1 1 statement/sql/select init_net_server_extension.cc:95 710732532689000 710732766814000 234125000 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 9027
621 2 2 statement/sql/set_option init_net_server_extension.cc:95 710733716120000 710733892659000 176539000 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 9028
621 3 3 statement/sql/set_option init_net_server_extension.cc:95 710734713716000 710734845588000 131872000 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 9029
621 4 4 statement/sql/set_option init_net_server_extension.cc:95 710739739647000 710739874432000 134785000 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 9032
621 5 5 statement/sql/select init_net_server_extension.cc:95 710743830943000 710743979241000 148298000 0 SELECT CURRENT_USER() 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) 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 9035
621 6 6 statement/sql/show_grants init_net_server_extension.cc:95 710744938281000 710745156477000 218196000 0 SHOW GRANTS 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 9036
621 7 8 statement/sql/select init_net_server_extension.cc:95 710756097494000 710756411690000 314196000 135000000 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 9037
621 9 9 statement/sql/show_variables init_net_server_extension.cc:95 710757462665000 710760065521000 2602856000 211000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? NULL 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 9038
621 10 10 statement/sql/select init_net_server_extension.cc:95 710761635007000 710761824093000 189086000 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 9039
621 11 11 statement/com/Init DB init_net_server_extension.cc:95 710762777420000 710762925162000 147742000 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 9040
Query results operations