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
29 1 1 statement/sql/select srv_session.cc:1107 1686814283000 1687648778000 834495000 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
20094 196 197 statement/sql/select init_net_server_extension.cc:95 956432253851000 956432418621000 164770000 85000000 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 543005
20095 31 32 statement/sql/select init_net_server_extension.cc:95 956426333602000 956426925606000 592004000 242000000 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 5 26 0 3 3 0 0 0 3 0 0 10 2 1 0 NULL NULL 0 543000
20098 166 167 statement/sql/select init_net_server_extension.cc:95 956435383116000 956435563848000 180732000 100000000 SELECT CONCAT(`db_name`, '.', `table_name`, '.', `... 1e5c3c5b862adc139113587fbc1dff8a3453c453610cd7909a... SELECT `CONCAT` ( `db_name` , ? , `table_name` , ?... 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 543008
20099 26 27 statement/sql/show_fields init_net_server_extension.cc:95 956179982601000 956181191449000 1208848000 368000000 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 542687
20100 90 91 statement/sql/select init_net_server_extension.cc:95 956432327942000 956432423782000 95840000 39000000 /*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 543006
20101 25 26 statement/sql/show_fields init_net_server_extension.cc:95 956319853630000 956321367835000 1514205000 541000000 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 542857
20102 90 91 statement/sql/select init_net_server_extension.cc:95 956432124369000 956432438291000 313922000 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 543004
20103 25 26 statement/sql/show_fields init_net_server_extension.cc:95 956424722449000 956425971613000 1249164000 418000000 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 542999
20104 68 69 statement/sql/select init_net_server_extension.cc:95 956438349012000 956438477814000 128802000 54000000 /*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 543018
20105 10 NULL statement/sql/select init_net_server_extension.cc:95 956438659198000 956438829860000 170662000 53000000 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 543019
Query results operations
Bookmark this SQL query Bookmark this SQL query