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 1481911701000 1482828203000 916502000 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
356 29 29 statement/sql/show_variables init_net_server_extension.cc:95 26853700701000 26854727141000 1026440000 105000000 SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS' 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... SHOW SESSION VARIABLES LIKE ? information_schema 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 9895
356 30 30 statement/sql/select init_net_server_extension.cc:95 26866280874000 26866332636000 51762000 0 SELECT CURRENT_USER() 3eff569d77bf7e2ccb14bd593a390e6187f054f1435d6bed2f... SELECT CURRENT_USER ( ) information_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 9903
356 31 31 statement/sql/show_grants init_net_server_extension.cc:95 26867717651000 26867810465000 92814000 0 SHOW GRANTS 357c2f9945785534854aa7e387a6a8c95121e3b10a0e9ab178... SHOW GRANTS information_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 9905
356 32 33 statement/sql/select init_net_server_extension.cc:95 26868060803000 26868613454000 552651000 251000000 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 8 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 9906
356 34 35 statement/sql/select init_net_server_extension.cc:95 26873036778000 26874284291000 1247513000 398000000 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 30 151 0 3 3 0 0 0 3 0 0 60 2 1 0 NULL NULL 0 9907
356 36 37 statement/sql/select init_net_server_extension.cc:95 26883341157000 26884117466000 776309000 319000000 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... db22765f86fdb091d2faced7479895f8497b40140b15fad577... SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 30 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 9913
356 22 23 statement/sql/show_keys init_net_server_extension.cc:95 26759829180000 26760618431000 789251000 503000000 SHOW INDEXES FROM `information_schema`.`INNODB_BUF... e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 1 0 0 0 0 1 0 0 0 1 0 0 NULL NULL 0 9840
356 24 24 statement/sql/show_create_table init_net_server_extension.cc:95 26760840520000 26760953989000 113469000 0 SHOW CREATE TABLE `information_schema`.`INNODB_BUF... f367dde03d11eb5b5e6fa6b05cda46f6d86ac45698abb72503... SHOW CREATE TABLE `information_schema` . `INNODB_B... information_schema 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 9841
356 25 26 statement/sql/show_fields init_net_server_extension.cc:95 26765194201000 26766366369000 1172168000 608000000 SHOW FULL COLUMNS FROM `information_schema`.`INNOD... 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 32 163 0 1 0 0 0 0 1 0 0 32 1 0 0 NULL NULL 0 9844
356 27 28 statement/sql/show_keys init_net_server_extension.cc:95 26768549763000 26769412405000 862642000 515000000 SHOW INDEXES FROM `information_schema`.`INNODB_BUF... e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 3 0 1 0 0 0 0 1 0 0 0 1 0 0 NULL NULL 0 9847
357 1 1 statement/sql/show_tables init_net_server_extension.cc:95 26728012592000 26728151344000 138752000 57000000 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 9817
357 2 2 statement/com/Init DB init_net_server_extension.cc:95 26728267009000 26728305903000 38894000 14000000 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 9818
358 1 1 statement/sql/show_tables init_net_server_extension.cc:95 26720199845000 26720361641000 161796000 67000000 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 9810
358 2 3 statement/sql/show_tables init_net_server_extension.cc:95 26720441211000 26721531324000 1090113000 521000000 SHOW TABLES FROM `information_schema` ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 67 137 0 0 0 0 0 0 1 0 0 67 1 0 0 NULL NULL 0 9812
359 30 31 statement/sql/select init_net_server_extension.cc:95 26800746245000 26802196539000 1450294000 518000000 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 413 0 1 1 0 0 0 1 0 0 1 1 1 0 NULL NULL 0 9870
359 32 33 statement/sql/show_fields init_net_server_extension.cc:95 26802489815000 26804129640000 1639825000 440000000 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 9871
359 16 17 statement/sql/show_fields init_net_server_extension.cc:95 26778923089000 26780160453000 1237364000 526000000 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 9860
359 18 19 statement/sql/show_keys init_net_server_extension.cc:95 26780411018000 26781276635000 865617000 462000000 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 9862
359 20 21 statement/sql/select init_net_server_extension.cc:95 26781649325000 26782010252000 360927000 208000000 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 9864
359 22 22 statement/sql/select init_net_server_extension.cc:95 26782290589000 26782335443000 44854000 0 SELECT @@have_profiling 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` mysql NULL NULL NULL NULL 0 NULL NULL 0 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 9865
359 23 23 statement/sql/show_create_table init_net_server_extension.cc:95 26782593828000 26782794267000 200439000 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 9866
359 24 25 statement/sql/select init_net_server_extension.cc:95 26798894010000 26799502381000 608371000 348000000 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 9867
359 26 27 statement/sql/select init_net_server_extension.cc:95 26799720989000 26800097428000 376439000 221000000 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 9868
359 28 29 statement/sql/select init_net_server_extension.cc:95 26800258038000 26800585391000 327353000 184000000 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 9869
Query results operations