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_current`
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
10098 43 NULL statement/sql/select init_net_server_extension.cc:95 495049190565000 495054223236000 5032671000 0 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql 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 156458
30 1 1 statement/sql/select srv_session.cc:1107 1681051648000 1682039792000 988144000 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
10099 2 3 statement/sql/show_tables init_net_server_extension.cc:95 494868182416000 494869060740000 878324000 431000000 SHOW TABLES FROM `mysql` ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 33 197 0 0 0 0 0 0 1 0 0 33 1 0 0 NULL NULL 0 156383
10100 2 2 statement/com/Init DB init_net_server_extension.cc:95 494886727685000 494886795127000 67442000 26000000 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 156391
10101 32 33 statement/sql/show_fields init_net_server_extension.cc:95 494948348368000 494950002600000 1654232000 642000000 SHOW FULL COLUMNS FROM `mysql`.`user` 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 51 260 0 1 0 0 0 0 1 0 0 51 1 0 0 NULL NULL 0 156433
10102 2 2 statement/com/Init DB init_net_server_extension.cc:95 494998700636000 494998788443000 87807000 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 156441
10103 12 13 statement/sql/show_keys init_net_server_extension.cc:95 495052097919000 495054123235000 2025316000 1662000000 SHOW INDEXES FROM `mysql`.`user` e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 2 66 0 1 0 0 0 0 1 0 0 2 1 0 0 NULL NULL 0 156463
10104 2 2 statement/com/Init DB init_net_server_extension.cc:95 495020190081000 495020266817000 76736000 29000000 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 156448
10105 10 NULL statement/sql/select init_net_server_extension.cc:95 495054145072000 495054294426000 149354000 52000000 SELECT * FROM `events_statements_current` LIMIT 0,... 48a66f51b70d4dbcfae28baea5e7e549cd3303a632540a0923... SELECT * FROM `events_statements_current` LIMIT ?,... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 8 0 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 156465
10094 2 2 statement/com/Init DB init_net_server_extension.cc:95 494722814204000 494722880819000 66615000 23000000 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 156330
10095 10 10 statement/sql/select init_net_server_extension.cc:95 494761453478000 494762130358000 676880000 287000000 SELECT * FROM `table_lock_waits_summary_by_table` ... 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... SELECT * FROM `table_lock_waits_summary_by_table` ... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 25 25 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 156345
Query results operations