Solte os arquivos aqui

SQL upload ( 0 ) x-

Servidor: localhost:3306 »Banco de dados: performance_schema »Tabela: events_statements_history
Configurações da páginaClique na barra para rolar até o topo da página
Pressione Ctrl+Enter para executar consulta Pressione Enter para executar consulta
ascendente
descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Recolher Expandir Mostrar rastro Ocultar rastro Contagem Tempo gasto
Favoritos
Atualizar
Adicionar
Sem marcador(es)
Adicionar marcador
Opções
Definir padrão





Recolher Expandir Repetir consulta Editar Demonstrar SQL Perfil Marcadores Falha na consulta Banco de dados : Tempo de execução da consulta :

Modo de navegação

Personalizar modo de navegação.

Documentação Usar apenas ícones, apenas texto ou ambos.
Documentação Usar apenas ícones, apenas texto ou ambos.
Documentação Se exibe ao usuário o botão "exibir tudo(linhas)".
Documentação Número de linhas exibidas na visualização do resultado encontrado. Se o resultado conter mais linhas, os links 'Anterior' e 'Próximo' serão apresentados.
Documentação SMART - i.e. ordem decrescente para colunas do tipo TIME, DATE, DATETIME e TIMESTAMP, caso contrário, ordem ascendente.
Documentação Destacar linha apontada pelo cursor do mouse.
Documentação Destacar linhas selecionadas.
Documentação
Documentação
Documentação Repetir cabeçalhos a cada X células, 0 desativa esta funcionalidade.
Documentação Número máximo de caracteres apresentados em qualquer coluna não-numérica em modo de navegação.
Documentação Estes são os links de Editar, Copiar e Apagar.
Documentação Se os links de linha devem ser mostrados mesmo na ausência de chave única.
Documentação Ordenação predeterminada para tabelas com uma chave primária.
Documentação Quando navegar por tabelas, a organização de cada tabela será lembrada.
Documentação Para exibir as Opções
A seleção atual não contém uma única coluna. As funções edição em grade, checkbox, editar, copiar e apagar não estão disponíveis. Documentação
Mostrando registros 0 - 24 (88 no total, Consulta levou 0.0542 segundos.)
SELECT * FROM `events_statements_history`
[Editar em linha] [ Editar ] [ Demonstrar SQL ] [ Criar código PHP ] [ Atualizar]
|
|
|
|
Número de linhas:
Filtrar linhas:
Ordenar pela chave:
THREAD_IDEVENT_IDEND_EVENT_IDEVENT_NAMESOURCETIMER_STARTTIMER_ENDTIMER_WAITLOCK_TIMESQL_TEXTDIGESTDIGEST_TEXTCURRENT_SCHEMAOBJECT_TYPEOBJECT_SCHEMAOBJECT_NAMEOBJECT_INSTANCE_BEGINMYSQL_ERRNORETURNED_SQLSTATEMESSAGE_TEXTERRORSWARNINGSROWS_AFFECTEDROWS_SENTROWS_EXAMINEDCREATED_TMP_DISK_TABLESCREATED_TMP_TABLESSELECT_FULL_JOINSELECT_FULL_RANGE_JOINSELECT_RANGESELECT_RANGE_CHECKSELECT_SCANSORT_MERGE_PASSESSORT_RANGESORT_ROWSSORT_SCANNO_INDEX_USEDNO_GOOD_INDEX_USEDNESTING_EVENT_IDNESTING_EVENT_TYPENESTING_EVENT_LEVELSTATEMENT_IDCPU_TIMEMAX_CONTROLLED_MEMORYMAX_TOTAL_MEMORYEXECUTION_ENGINE
25563 60 61 statement/sql/select init_net_server_extension.cc:103 418429456641003000 418429459837470000 3196467000 7000000 SELECT `tables` FROM `phpmyadmin`.`pma__favorite` ... 89b75c15af01bcb8673462fd746b3de302afc6e9ab7372db4a... SELECT `tables` FROM `phpmyadmin` . `pma__favorite... phpmyadmin 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 462287 0 1087664 1123723 PRIMARY
25563 42 43 statement/sql/select init_net_server_extension.cc:103 418428780839240000 418428786933233000 6093993000 10000000 SELECT NULL FROM pma__export_templates LIMIT 0 1ad94f06fd0f023c3f651adedc7688f4a18b16fe8f24e04d91... SELECT ? FROM `pma__export_templates` LIMIT ? 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 462034 0 1067088 1084627 PRIMARY
25563 44 45 statement/sql/select init_net_server_extension.cc:103 418428787186488000 418428787510835000 324347000 5000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 462038 0 1094784 1129283 PRIMARY
25563 46 47 statement/sql/select init_net_server_extension.cc:103 418428788751131000 418428789157501000 406370000 5000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 462039 0 1087664 1122227 PRIMARY
25563 48 49 statement/sql/select init_net_server_extension.cc:103 418428874140397000 418428874598187000 457790000 5000000 SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE d... 850ba1adcdfe05c492ecc917cc3a849723cf1327942b4fdf39... SELECT * FROM `phpmyadmin` . `pma__bookmark` WHERE... phpmyadmin NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 NULL NULL 0 462065 0 1094784 1112787 PRIMARY
25563 50 51 statement/sql/select init_net_server_extension.cc:103 418428907732879000 418428908068482000 335603000 5000000 SELECT `prefs` FROM `phpmyadmin`.`pma__table_uipre... 64b66d84611096a7bc89f9c876760d73bbcd18ef195e9b7f11... SELECT `prefs` FROM `phpmyadmin` . `pma__table_uip... 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 462074 0 1087664 1105643 PRIMARY
25563 52 53 statement/sql/select init_net_server_extension.cc:103 418429127682223000 418429129107329000 1425106000 6000000 SELECT `master_field`,
                   `foreig...		 91390b756760171a3b464bfc0a7884a29c82adb5375b21d8eb... SELECT `master_field` , `foreign_db` , `foreign_ta... 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 462165 0 1098928 1117283 PRIMARY
25563 54 55 statement/sql/select init_net_server_extension.cc:103 418429234439383000 418429241532352000 7092969000 5000000 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 462213 0 1119504 1137859 PRIMARY
25563 56 57 statement/sql/select init_net_server_extension.cc:103 418429416221210000 418429416683895000 462685000 5000000 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 462263 0 1091808 1110259 PRIMARY
25563 58 59 statement/sql/select init_net_server_extension.cc:103 418429429966729000 418429430367059000 400330000 5000000 SELECT `tables` FROM `phpmyadmin`.`pma__recent` WH... d69835e5fe5fb0226d6c68d185457f2ea0b6121c7475eaeaeb... SELECT `tables` FROM `phpmyadmin` . `pma__recent` ... phpmyadmin 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 462266 0 1094784 1130779 PRIMARY
25564 27 28 statement/sql/show_fields init_net_server_extension.cc:103 418429146711494000 418429157400730000 10689236000 11000000 SHOW FULL COLUMNS FROM `information_schema`.`INNOD... 82db80fe354d4a638416bfc11dc78f7ae03b791e6cb01a6a5c... SHOW FULL FIELDS FROM `information_schema` . `INNO... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 6 27 0 1 0 0 0 0 1 0 0 6 1 0 0 NULL NULL 0 462170 0 1477488 1529787 PRIMARY
25564 29 30 statement/sql/show_keys init_net_server_extension.cc:103 418429158624498000 418429169738305000 11113807000 6000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... 1867ac3a6944aa68de9a07ed54f885113b62eb640d8024a771... SHOW INDEXES FROM `information_schema` . `INNODB_C... 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 462176 0 1456656 1488355 PRIMARY
25564 31 31 statement/sql/show_variables init_net_server_extension.cc:103 418429296002739000 418429302075302000 6072563000 3000000 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 1 0 1 0 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 462230 0 1119504 1138315 PRIMARY
25564 32 33 statement/sql/select init_net_server_extension.cc:103 418429338060789000 418429339411703000 1350914000 9000000 SELECT (COUNT(DB_first_level) DIV 100) * 100 from ... e8b67e76bb58f62c704e6904b349719537675fef0a968c067b... SELECT ( COUNT ( `DB_first_level` ) DIV ? ) * ? FR... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 1 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 462249 0 1483424 1503507 PRIMARY
25564 34 35 statement/sql/select init_net_server_extension.cc:103 418429379619778000 418429410974956000 31355178000 10000000 SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SC... 61adfaeec8fa0f1da6a7d00bf8a62af8b695f6b6f0f4ac4b4e... SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA` . `... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 7 36 0 3 3 0 0 0 3 0 0 14 2 1 0 NULL NULL 0 462255 0 2603352 2623491 PRIMARY
25564 36 37 statement/sql/select init_net_server_extension.cc:103 418429461078693000 418429462245352000 1166659000 31000000 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... 5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33... SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 7 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 462290 0 1483424 1503523 PRIMARY
25564 38 39 statement/sql/select init_net_server_extension.cc:103 418429464035905000 418429465055562000 1019657000 7000000 SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_I... 5e6fed45d04ce52917f34d65501f4571ec9b7b01cc2cd5da33... SELECT COUNT ( * ) FROM ( SELECT DISTINCTROW `SUBS... information_schema NULL NULL NULL NULL 0 NULL NULL 0 0 0 1 7 0 2 1 0 0 0 2 0 0 0 0 1 0 NULL NULL 0 462292 0 1483424 1503523 PRIMARY
25564 23 23 statement/sql/select init_net_server_extension.cc:103 418429005298897000 418429029964275000 24665378000 0 SELECT @@have_profiling 1b421971f1e5100e314a2aa8d36d394d0f1918c2420214e923... SELECT @@`have_profiling` information_schema 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 462113 0 1069184 1086723 PRIMARY
25564 24 25 statement/sql/show_keys init_net_server_extension.cc:103 418429040133654000 418429120208566000 80074912000 10000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... 1867ac3a6944aa68de9a07ed54f885113b62eb640d8024a771... SHOW INDEXES FROM `information_schema` . `INNODB_C... 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 462127 0 1448416 1478691 PRIMARY
25564 26 26 statement/sql/show_create_table init_net_server_extension.cc:103 418429129839661000 418429136409814000 6570153000 0 SHOW CREATE TABLE `information_schema`.`INNODB_CMP... 1dadb9f3f58b75b150c86e7528c5598440e0d47d1671bb6a3a... SHOW CREATE TABLE `information_schema` . `INNODB_C... 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 462168 0 1069184 1089258 PRIMARY
25565 60 61 statement/sql/select init_net_server_extension.cc:103 418429385527024000 418429385884056000 357032000 7000000 SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE (... 0f5bb6bc2f89a5a54cbecee183b9a505c1fe334318944c36ba... SELECT * FROM `phpmyadmin` . `pma__bookmark` WHERE... phpmyadmin NULL NULL NULL NULL 0 NULL NULL 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 0 NULL NULL 0 462258 0 1088000 1107451 PRIMARY
25565 62 63 statement/sql/replace init_net_server_extension.cc:103 418429452863041000 418429484228386000 31365345000 4000000 REPLACE INTO `phpmyadmin`.`pma__recent` (`username... 729ee27719969e843a2799d0c0d45fe10f59a0fb0c3ef3c000... REPLACE INTO `phpmyadmin` . `pma__recent` ( `usern... phpmyadmin NULL NULL NULL NULL 0 00000 NULL 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL 0 462285 0 1067088 1114827 PRIMARY
25565 44 45 statement/sql/select init_net_server_extension.cc:103 418428815423420000 418428815729411000 305991000 3000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 462057 0 1094784 1129283 PRIMARY
25565 46 47 statement/sql/select init_net_server_extension.cc:103 418428816282849000 418428816476896000 194047000 4000000 SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ... cea77d989ffed6525e639d27a1f58807f348871ba2c48f718a... SELECT `config_data` , `UNIX_TIMESTAMP` ( `timeval... phpmyadmin 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 462058 0 1087664 1122227 PRIMARY
25565 48 49 statement/sql/select init_net_server_extension.cc:103 418428900337338000 418428900683634000 346296000 5000000 SELECT `master_field`,
                   `foreig...		 91390b756760171a3b464bfc0a7884a29c82adb5375b21d8eb... SELECT `master_field` , `foreign_db` , `foreign_ta... 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 462071 0 1098928 1117283 PRIMARY

|
|
|
|
Número de linhas:
Filtrar linhas:
Ordenar pela chave:
Operações resultantes das consultasImprimir ImprimirCopiar para a área de transferência Copiar para a área de transferênciaExportar Exportar Exibir gráfico Exibir gráfico Criar view Criar view

Marcar essa consulta SQL Marcar essa consulta SQL