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 (27 no total, Consulta levou 0.2824 segundos.)
SELECT * FROM `events_statements_history`
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
49042 40 41 statement/sql/select init_net_server_extension.cc:103 3071675095973651000 3071675098732436000 2758785000 5000000 SELECT NULL FROM pma__designer_settings LIMIT 0 402aefb7e0bf1049b8b3e5482e5018a973467c0e8c85a78eaa... SELECT ? FROM `pma__designer_settings` 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 964891 0 1067088 1084627 PRIMARY
49042 42 43 statement/sql/select init_net_server_extension.cc:103 3071675099166091000 3071675109208569000 10042478000 5416000000 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 964894 0 1067088 1084627 PRIMARY
49042 44 45 statement/sql/select init_net_server_extension.cc:103 3071675110710955000 3071675111551902000 840947000 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 964900 0 1094784 1129283 PRIMARY
49042 46 47 statement/sql/select init_net_server_extension.cc:103 3071675111563711000 3071675113357513000 1793802000 2000000 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 964902 0 1087664 1122227 PRIMARY
49042 28 29 statement/sql/select init_net_server_extension.cc:103 3071675024698452000 3071675024919266000 220814000 4000000 SELECT NULL FROM pma__bookmark LIMIT 0 5626f9746741f9d0f8e5d420e56bbc91b6c4f3f11090d1d435... SELECT ? FROM `pma__bookmark` 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 964858 0 1067088 1084627 PRIMARY
49042 30 31 statement/sql/select init_net_server_extension.cc:103 3071675025001225000 3071675028861536000 3860311000 3681000000 SELECT NULL FROM pma__users LIMIT 0 57fe40466f82d3e93666377311ff5c7a902ca0037880e03c5b... SELECT ? FROM `pma__users` 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 964859 0 1067088 1084627 PRIMARY
49042 32 33 statement/sql/select init_net_server_extension.cc:103 3071675029148542000 3071675044513641000 15365099000 4000000 SELECT NULL FROM pma__usergroups LIMIT 0 cd0defa12017f3afde2e2cb66d959a43bc84b665820d3b2596... SELECT ? FROM `pma__usergroups` 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 964860 0 1067088 1084627 PRIMARY
49042 34 35 statement/sql/select init_net_server_extension.cc:103 3071675045850557000 3071675046015925000 165368000 3000000 SELECT NULL FROM pma__navigationhiding LIMIT 0 6ae169705affbba2249d09bda32c7ee1f38132df72e69b9dbb... SELECT ? FROM `pma__navigationhiding` 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 964863 0 1067088 1084627 PRIMARY
49042 36 37 statement/sql/select init_net_server_extension.cc:103 3071675046362775000 3071675060484259000 14121484000 9143000000 SELECT NULL FROM pma__savedsearches LIMIT 0 3f0298e522618f3af166092d84790c7f57e6e36ab46a84c62d... SELECT ? FROM `pma__savedsearches` 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 964865 0 1067088 1084627 PRIMARY
49042 38 39 statement/sql/select init_net_server_extension.cc:103 3071675060627375000 3071675095645703000 35018328000 5302000000 SELECT NULL FROM pma__central_columns LIMIT 0 9323ecd0217c50e2e47d0041b820031fca4c564b95fcded471... SELECT ? FROM `pma__central_columns` 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 964878 0 1067088 1084627 PRIMARY
49043 97 98 statement/sql/show_keys init_net_server_extension.cc:103 3071676966436899000 3071676968667109000 2230210000 9000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... b2fba9642b9e416b4eb29949b32c2c8b52e7c943c360979ebc... SHOW INDEXES FROM `information_schema` . `INNODB_C... NULL 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 965366 0 1456656 1647113 PRIMARY
49043 79 80 statement/sql/show_fields init_net_server_extension.cc:103 3071676635639329000 3071676684014912000 48375583000 17000000 SHOW  COLUMNS FROM `information_schema`.`INNODB_CM... 7bfdb4eca891f240756b93ef1f5776e7b4f83b93c859914534... SHOW FIELDS FROM `information_schema` . `INNODB_CM... NULL 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 965290 0 1485728 1675944 PRIMARY
49043 81 82 statement/sql/show_keys init_net_server_extension.cc:103 3071676688868223000 3071676690808349000 1940126000 6000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... 1fa990668ebb86a58c1640d34f359346a75b4aa40574e6bb85... SHOW INDEXES FROM `information_schema` . `INNODB_C... NULL 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 965300 0 1456656 1626368 PRIMARY
49043 83 84 statement/sql/show_fields init_net_server_extension.cc:103 3071676696623924000 3071676754021141000 57397217000 18000000 SHOW  COLUMNS FROM `information_schema`.`INNODB_CM... 10064134ba33e09820a2ad7f71c745e525a1f777e96ba77585... SHOW FIELDS FROM `information_schema` . `INNODB_CM... NULL 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 965302 0 1485728 1682256 PRIMARY
49043 85 86 statement/sql/show_keys init_net_server_extension.cc:103 3071676757975394000 3071676760220340000 2244946000 7000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... 1867ac3a6944aa68de9a07ed54f885113b62eb640d8024a771... SHOW INDEXES FROM `information_schema` . `INNODB_C... NULL 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 965305 0 1456656 1632680 PRIMARY
49043 87 88 statement/sql/show_fields init_net_server_extension.cc:103 3071676769334295000 3071676843890560000 74556265000 16000000 SHOW  COLUMNS FROM `information_schema`.`INNODB_CM... 772ce6ae6af8510ac4d828aa7d86ec2204d2d9db8de337bd0a... SHOW FIELDS FROM `information_schema` . `INNODB_CM... NULL 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 965306 0 1485728 1688680 PRIMARY
49043 89 90 statement/sql/show_keys init_net_server_extension.cc:103 3071676873682906000 3071676875782585000 2099679000 11000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... ff5ca7b10e74ee8981c48059d1e3f17f3d96b41edaf0bfe71e... SHOW INDEXES FROM `information_schema` . `INNODB_C... NULL 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 965347 0 1456656 1639104 PRIMARY
49043 91 92 statement/sql/show_fields init_net_server_extension.cc:103 3071676882825221000 3071676907264264000 24439043000 14000000 SHOW  COLUMNS FROM `information_schema`.`INNODB_CM... 0db977d471cf9c85c0260e1a77387408d43f4449cb6b6a2fde... SHOW FIELDS FROM `information_schema` . `INNODB_CM... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 8 35 0 1 0 0 0 0 1 0 0 8 1 0 0 NULL NULL 0 965349 0 1485744 1696697 PRIMARY
49043 93 94 statement/sql/show_keys init_net_server_extension.cc:103 3071676923503868000 3071676925576015000 2072147000 7000000 SHOW INDEXES FROM `information_schema`.`INNODB_CMP... 2cdded5b9e91e61be22a83aa0436fc5a3e87b894c3060508b7... SHOW INDEXES FROM `information_schema` . `INNODB_C... NULL 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 965364 0 1456656 1647105 PRIMARY
49043 95 96 statement/sql/show_fields init_net_server_extension.cc:103 3071676944553325000 3071676947084654000 2531329000 10000000 SHOW  COLUMNS FROM `information_schema`.`INNODB_CM... 94a89b58704d5cf34d379e0c6fb93bea16269e3a9cf1d908bb... SHOW FIELDS FROM `information_schema` . `INNODB_CM... NULL NULL NULL NULL NULL 0 NULL NULL 0 0 0 8 35 0 1 0 0 0 0 1 0 0 8 1 0 0 NULL NULL 0 965365 0 1485744 1696705 PRIMARY
49051 60 61 statement/sql/select init_net_server_extension.cc:103 3071676917536332000 3071676921195465000 3659133000 3000000 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 965360 0 1088240 1128432 PRIMARY
49051 42 43 statement/sql/select init_net_server_extension.cc:103 3071675277910723000 3071675333006321000 55095598000 10563000000 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 964945 0 1067328 1105744 PRIMARY
49051 44 45 statement/sql/select init_net_server_extension.cc:103 3071675334779540000 3071675335072037000 292497000 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 964955 0 1095024 1150400 PRIMARY
49051 46 47 statement/sql/select init_net_server_extension.cc:103 3071675337026185000 3071675337404527000 378342000 6000000 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 964956 0 1087904 1143344 PRIMARY
49051 48 49 statement/sql/select init_net_server_extension.cc:103 3071675410899980000 3071675411279230000 379250000 8000000 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 964974 0 1099168 1138400 PRIMARY