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_history`
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 1553082380000 1555013232000 1930852000 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
15944 1 1 statement/sql/show_tables init_net_server_extension.cc:95 696711121286000 696711259191000 137905000 59000000 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 229321
15944 2 2 statement/com/Init DB init_net_server_extension.cc:95 696711429763000 696711472742000 42979000 15000000 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 229322
15945 13 13 statement/sql/select init_net_server_extension.cc:95 696730400486000 696730437787000 37301000 0 SELECT @@lower_case_table_names 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` performance_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 229339
15945 14 15 statement/sql/select init_net_server_extension.cc:95 696730719969000 696731738641000 1018672000 413000000 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 142 0 1 0 0 0 0 1 0 0 1 1 0 0 NULL NULL 0 229340
15945 16 16 statement/sql/select init_net_server_extension.cc:95 696731996362000 696732636318000 639956000 36000000 SELECT COUNT(*) FROM `performance_schema`.`table_l... 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 229343
15945 17 17 statement/sql/show_warnings init_net_server_extension.cc:95 696732907500000 696732946969000 39469000 0 SHOW WARNINGS 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS performance_schema 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 229345
15945 18 19 statement/sql/select init_net_server_extension.cc:95 696733327799000 696733822888000 495089000 288000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 229347
15945 20 21 statement/sql/show_fields init_net_server_extension.cc:95 696734246318000 696735494279000 1247961000 480000000 SHOW  COLUMNS FROM `performance_schema`.`table_loc... 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 229349
15945 22 23 statement/sql/show_keys init_net_server_extension.cc:95 696736774019000 696737704058000 930039000 537000000 SHOW INDEXES FROM `performance_schema`.`table_lock... e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 3 17 0 1 0 0 0 0 1 0 0 3 1 0 0 NULL NULL 0 229351
15945 24 24 statement/sql/show_create_table init_net_server_extension.cc:95 696740092886000 696740459723000 366837000 0 SHOW CREATE TABLE `performance_schema`.`table_lock... bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... SHOW CREATE TABLE `performance_schema` . `table_lo... performance_schema 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 229353
15945 25 26 statement/sql/show_fields init_net_server_extension.cc:95 696745458852000 696747503595000 2044743000 598000000 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 229355
15945 11 12 statement/sql/select init_net_server_extension.cc:95 696729285853000 696729700132000 414279000 251000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 229337
15946 1 1 statement/sql/show_tables init_net_server_extension.cc:95 696760880486000 696761037650000 157164000 64000000 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 229366
15946 2 2 statement/com/Init DB init_net_server_extension.cc:95 696761160066000 696761218717000 58651000 22000000 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 229367
15947 1 1 statement/sql/show_tables init_net_server_extension.cc:95 696755622314000 696755782360000 160046000 65000000 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 229360
15947 2 2 statement/com/Init DB init_net_server_extension.cc:95 696755904667000 696755970458000 65791000 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 229361
15948 13 13 statement/sql/select init_net_server_extension.cc:95 696790908186000 696790966186000 58000000 0 SELECT @@lower_case_table_names 1da3a196185b678ecb9d76f22b1efe1ad4983d6b48955f1631... SELECT @@`lower_case_table_names` performance_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 229380
15948 14 15 statement/sql/select init_net_server_extension.cc:95 696791102311000 696792303345000 1201034000 540000000 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 142 0 1 0 0 0 0 1 0 0 1 1 0 0 NULL NULL 0 229381
15948 16 16 statement/sql/select init_net_server_extension.cc:95 696792549479000 696793159645000 610166000 35000000 SELECT COUNT(*) FROM `performance_schema`.`table_l... 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... SELECT COUNT ( * ) FROM `performance_schema` . `ta... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 229382
15948 17 17 statement/sql/show_warnings init_net_server_extension.cc:95 696793358329000 696793385588000 27259000 0 SHOW WARNINGS 118d653c380580e38366e6c2f770958c117ff4937f4a30ea3b... SHOW WARNINGS performance_schema 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 229383
15948 18 19 statement/sql/select init_net_server_extension.cc:95 696793653137000 696794044571000 391434000 219000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 0 0 0 0 0 1 0 0 0 0 0 0 NULL NULL 0 229384
15948 20 21 statement/sql/show_fields init_net_server_extension.cc:95 696794174890000 696795407817000 1232927000 455000000 SHOW  COLUMNS FROM `performance_schema`.`table_loc... 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 229385
15948 22 23 statement/sql/show_keys init_net_server_extension.cc:95 696795741649000 696796564955000 823306000 475000000 SHOW INDEXES FROM `performance_schema`.`table_lock... e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... performance_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 3 17 0 1 0 0 0 0 1 0 0 3 1 0 0 NULL NULL 0 229386
15948 24 24 statement/sql/show_create_table init_net_server_extension.cc:95 696798791481000 696799070572000 279091000 0 SHOW CREATE TABLE `performance_schema`.`table_lock... bbd9b634d307ea4ea2b4db12cc479b75b75d3cfdb9ab395083... SHOW CREATE TABLE `performance_schema` . `table_lo... performance_schema 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 229387
Query results operations