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 CPU_TIME MAX_CONTROLLED_MEMORY MAX_TOTAL_MEMORY EXECUTION_ENGINE
12862 15 16 statement/sql/show_fields init_net_server_extension.cc:105 2034354911316918690 2034354913760803710 2443885020 22000000 SHOW  COLUMNS FROM `information_schema`.`TRIGGERS` 7b6a27cec443cf672b632a0c1ba1da9dfdd1dd962b259e96c0... SHOW FIELDS FROM `information_schema` . `TRIGGERS` information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 22 91 0 1 0 0 0 0 1 0 0 22 1 0 0 NULL NULL 0 197632 0 1485856 1602088 PRIMARY
12862 17 18 statement/sql/show_keys init_net_server_extension.cc:105 2034354914134035350 2034354916702237795 2568202445 22000000 SHOW INDEXES FROM `information_schema`.`TRIGGERS` 942c3b4069508fded0a1da46c0478a13ea6d1a099976260ca1... SHOW INDEXES FROM `information_schema` . `TRIGGERS... information_schema 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 197633 0 1452880 1566482 PRIMARY
12862 19 19 statement/sql/select init_net_server_extension.cc:105 2034354925368698825 2034354925592190825 223492000 0 SELECT CURRENT_USER() 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) information_schema 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 197634 0 1069184 1137518 PRIMARY
12862 20 21 statement/sql/select init_net_server_extension.cc:105 2034354925790260610 2034354927766209255 1975948645 22000000 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... e8b67e76bb58f62c704e6904b349719537675fef0a968c067b... SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 0 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 197635 0 1475184 1538010 PRIMARY
12862 5 6 statement/sql/show_fields init_net_server_extension.cc:105 2034354859465098500 2034354862611307130 3146208630 19000000 SHOW FULL COLUMNS FROM `information_schema`.`TRIGG... fe30bff7cfba4696eed654059e0852dd6e81cfad676de77a91... SHOW FULL FIELDS FROM `information_schema` . `TRIG... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 22 91 0 1 0 0 0 0 1 0 0 22 1 0 0 NULL NULL 0 197621 0 1485856 1585839 PRIMARY
12862 7 8 statement/sql/show_keys init_net_server_extension.cc:105 2034354863906443270 2034354866147229935 2240786665 20000000 SHOW INDEXES FROM `information_schema`.`TRIGGERS` 942c3b4069508fded0a1da46c0478a13ea6d1a099976260ca1... SHOW INDEXES FROM `information_schema` . `TRIGGERS... NULL 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 197625 0 1452880 1561324 PRIMARY
12862 9 9 statement/sql/show_create_table init_net_server_extension.cc:105 2034354871544282370 2034354873106212085 1561929715 0 SHOW CREATE TABLE `information_schema`.`TRIGGERS` bdb6210497fc91e61ec392258d0b273444602ba27a01701151... SHOW CREATE TABLE `information_schema` . `TRIGGERS... 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 197626 0 1219136 1305912 PRIMARY
12862 10 10 statement/com/Init DB init_net_server_extension.cc:105 2034354892287133620 2034354892444136750 157003130 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 197629 0 1056848 1120411 PRIMARY
12862 11 12 statement/sql/show_tables init_net_server_extension.cc:105 2034354892617622415 2034354895399259720 2781637305 23000000 SHOW TABLES LIKE 'TRIGGERS' a72b965922848d2b5f697f9c499411910581b77921bbc4deaa... SHOW TABLES LIKE ? information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 83 0 0 0 0 0 0 1 0 0 1 1 0 0 NULL NULL 0 197630 0 1695648 1770210 PRIMARY
12862 13 14 statement/sql/select init_net_server_extension.cc:105 2034354896619246675 2034354899243880850 2624634175 28000000 SELECT *, `COLUMN_NAME`       AS `Field`, `COLUMN_... 4e0fb71b62bce44b712d8aac8ca20075147c352f06f2107da9... SELECT * , `COLUMN_NAME` AS `Field` , `COLUMN_TYPE... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 22 69 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 197631 0 1452512 1568904 PRIMARY
12863 1 1 statement/sql/show_tables init_net_server_extension.cc:105 2034354826530479285 2034354827140333080 609853795 8000000 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 197608 0 47296 78128 PRIMARY
12863 2 3 statement/sql/show_tables init_net_server_extension.cc:105 2034354827280853675 2034354831295608090 4014754415 40000000 SHOW TABLES FROM `information_schema` 86c2a9842a6a9c016917bf355da07c1c82ffd6c49346e396da... SHOW TABLES FROM `information_schema` NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 79 161 0 0 0 0 0 0 1 0 0 79 1 0 0 NULL NULL 0 197609 0 647040 690576 PRIMARY
12863 4 4 statement/sql/show_tables init_net_server_extension.cc:105 2034354848162269965 2034354848489127015 326857050 8000000 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 197617 0 39056 71872 PRIMARY
12863 5 6 statement/sql/show_tables init_net_server_extension.cc:105 2034354848626295230 2034354851208465925 2582170695 19000000 SHOW TABLES FROM `information_schema` 86c2a9842a6a9c016917bf355da07c1c82ffd6c49346e396da... SHOW TABLES FROM `information_schema` NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 79 161 0 0 0 0 0 0 1 0 0 79 1 0 0 NULL NULL 0 197618 0 626464 670080 PRIMARY
12864 1 1 statement/sql/select init_net_server_extension.cc:105 2034354824240245015 2034354824511229065 270984050 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 197606 0 16480 25240 PRIMARY
12864 2 2 statement/sql/set_option init_net_server_extension.cc:105 2034354827823659870 2034354828013628070 189968200 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 197610 0 8240 17000 PRIMARY
12864 3 3 statement/sql/set_option init_net_server_extension.cc:105 2034354828100789950 2034354828280701010 179911060 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 197611 0 8240 17000 PRIMARY
12864 4 4 statement/sql/set_option init_net_server_extension.cc:105 2034354861425682070 2034354861616488365 190806295 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 197622 0 8240 17000 PRIMARY
12864 5 5 statement/sql/select init_net_server_extension.cc:105 2034354881322895465 2034354881570412855 247517390 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 197627 0 20576 29336 PRIMARY
12864 6 7 statement/sql/select init_net_server_extension.cc:105 2034354928448139220 2034354928820532765 372393545 50000000 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 197636 0 30816 39792 PRIMARY
12864 8 8 statement/sql/show_variables init_net_server_extension.cc:105 2034354929706119815 2034354936154422745 6448302930 10000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 1 0 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 197637 0 1136304 1161760 PRIMARY
12864 9 9 statement/sql/select init_net_server_extension.cc:105 2034354949624844315 2034354949858393455 233549140 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 197638 0 1069184 1094808 PRIMARY
12864 10 10 statement/com/Init DB init_net_server_extension.cc:105 2034354950045568005 2034354950270736195 225168190 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 197639 0 1060944 1095411 PRIMARY
12865 1 1 statement/sql/select init_net_server_extension.cc:105 2034354825382289135 2034354825563038290 180749155 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 197607 0 16480 25240 PRIMARY
12865 2 2 statement/sql/set_option init_net_server_extension.cc:105 2034354832807810835 2034354832974871105 167060270 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 197612 0 8240 17000 PRIMARY
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view