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 2301831892000 2302917059000 1085167000 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
1545 47 47 statement/sql/select init_net_server_extension.cc:95 87809173925000 87809364612000 190687000 51000000 SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.... cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 173 0 1 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 21290
1545 32 33 statement/sql/show_fields init_net_server_extension.cc:95 87679081480000 87680808747000 1727267000 479000000 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 21209
1545 34 34 statement/sql/show_variables init_net_server_extension.cc:95 87750163597000 87751804729000 1641132000 67000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 574 0 1 0 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 21261
1545 35 35 statement/sql/select init_net_server_extension.cc:95 87752822898000 87752880552000 57654000 0 SELECT CURRENT_USER() 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) mysql 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 21265
1545 36 36 statement/sql/show_grants init_net_server_extension.cc:95 87753280091000 87753341660000 61569000 0 SHOW GRANTS 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS 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 21267
1545 37 38 statement/sql/select init_net_server_extension.cc:95 87753973313000 87754327787000 354474000 165000000 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 9 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 21269
1545 39 40 statement/sql/select init_net_server_extension.cc:95 87764808969000 87765611923000 802954000 217000000 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 31 156 0 3 3 0 0 0 3 0 0 62 2 1 0 NULL NULL 0 21275
1545 41 42 statement/sql/select init_net_server_extension.cc:95 87770936736000 87771291046000 354310000 144000000 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 1 31 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 21281
1545 43 44 statement/sql/select init_net_server_extension.cc:95 87777085495000 87777473974000 388479000 158000000 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 1 31 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 21282
1545 45 46 statement/sql/select init_net_server_extension.cc:95 87808440435000 87808972498000 532063000 211000000 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 21289
1546 1 1 statement/sql/show_tables init_net_server_extension.cc:95 87604320045000 87604433167000 113122000 39000000 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 21172
1546 2 3 statement/sql/show_tables init_net_server_extension.cc:95 87604508075000 87605497328000 989253000 532000000 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 21173
1547 31 32 statement/sql/show_fields init_net_server_extension.cc:95 87763199459000 87764146568000 947109000 289000000 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 21274
1547 14 15 statement/sql/select init_net_server_extension.cc:95 87747693004000 87748316206000 623202000 355000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 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 21254
1547 16 17 statement/sql/show_fields init_net_server_extension.cc:95 87748414424000 87749294510000 880086000 418000000 SHOW  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 21258
1547 18 19 statement/sql/show_keys init_net_server_extension.cc:95 87749535639000 87750170880000 635241000 375000000 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 21260
1547 20 21 statement/sql/select init_net_server_extension.cc:95 87750758934000 87751119431000 360497000 214000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 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 21262
1547 22 22 statement/sql/show_create_table init_net_server_extension.cc:95 87751612867000 87751887103000 274236000 0 SHOW CREATE TABLE `mysql`.`user` 9706c2519d896332cde7f9c2739cb31c6a6ebba321f22f8dd2... SHOW CREATE TABLE `mysql` . `user` 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 21264
1547 23 24 statement/sql/select init_net_server_extension.cc:95 87761210336000 87761530591000 320255000 179000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 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 21270
1547 25 26 statement/sql/select init_net_server_extension.cc:95 87761657512000 87761903169000 245657000 130000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 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 21271
1547 27 28 statement/sql/select init_net_server_extension.cc:95 87761984986000 87762208465000 223479000 123000000 SELECT 1 FROM information_schema.VIEWS WHERE TABLE... 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql 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 21272
1547 29 30 statement/sql/select init_net_server_extension.cc:95 87762298072000 87763009251000 711179000 325000000 SELECT *, `TABLE_SCHEMA`       AS `Db`, `TABLE_NAM... ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... mysql NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 102 0 1 1 0 0 0 1 0 0 1 1 1 0 NULL NULL 0 21273
1548 1 1 statement/sql/show_tables init_net_server_extension.cc:95 87686566335000 87686733122000 166787000 68000000 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 21219
1548 2 3 statement/sql/show_tables init_net_server_extension.cc:95 87686835910000 87687633459000 797549000 428000000 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 21220
Query results operations