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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Restore default values
Collapse Expand Requery Edit Explain Profiling Bookmark 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
30 1 1 statement/sql/select srv_session.cc:1107 2167972813000 2168665209000 692396000 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 21
2738 142 143 statement/sql/select init_net_server_extension.cc:95 118989098852000 118989198081000 99229000 49000000 /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... phpmyadmin 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 141298
2739 25 26 statement/sql/show_fields init_net_server_extension.cc:95 118818422071000 118819607979000 1185908000 348000000 SHOW FULL COLUMNS FROM `performance_schema`.`table... 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 68 343 0 1 0 0 0 0 1 0 0 68 1 0 0 NULL NULL 0 141110
2740 138 139 statement/sql/select init_net_server_extension.cc:95 118993360455000 118993480351000 119896000 44000000 /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... phpmyadmin 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 141303
2741 25 26 statement/sql/show_fields init_net_server_extension.cc:95 118811422640000 118813210144000 1787504000 487000000 SHOW FULL COLUMNS FROM `performance_schema`.`table... 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 68 343 0 1 0 0 0 0 1 0 0 68 1 0 0 NULL NULL 0 141099
2742 138 139 statement/sql/select init_net_server_extension.cc:95 118988965730000 118989087007000 121277000 56000000 /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... phpmyadmin 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 141295
2743 25 26 statement/sql/show_fields init_net_server_extension.cc:95 118830726030000 118832009592000 1283562000 471000000 SHOW FULL COLUMNS FROM `performance_schema`.`table... 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 68 343 0 1 0 0 0 0 1 0 0 68 1 0 0 NULL NULL 0 141129
2744 50 51 statement/sql/select init_net_server_extension.cc:95 118946474056000 118946608516000 134460000 47000000 SELECT `db_name`, COUNT(*) AS `count` FROM `phpmya... 595fa5f44cab387088f4ce1d5e1956603c30de7da2bfd0fc64... SELECT `db_name` , COUNT ( * ) AS `count` FROM `ph... phpmyadmin NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 141230
2745 21 22 statement/sql/select init_net_server_extension.cc:95 118990934124000 118991532526000 598402000 180000000 SELECT 1 FROM (SELECT `GRANTEE`, `IS_GRANTABLE` FR... 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 4 0 7 0 0 0 0 7 0 0 0 0 1 0 NULL NULL 0 141300
2746 64 65 statement/sql/select init_net_server_extension.cc:95 118995324748000 118995428938000 104190000 42000000 /*NOTRACK*/ SELECT 1 FROM `phpmyadmin`.`pma__track... 603da55acfc576f0f0ddb63f3abfb2b341607f72dfe9c3a956... SELECT ? FROM `phpmyadmin` . `pma__tracking` WHERE... phpmyadmin 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 141309
2747 10 NULL statement/sql/select init_net_server_extension.cc:95 118995552020000 118995695466000 143446000 38000000 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 10 0 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 141310
Query results operations
Bookmark this SQL query Bookmark this SQL query