http://analytics.2im.com.br/api/privilegio/avaliado/1032

Method
GET
HTTP Status
200
IP
172.31.19.198
Profiled on
Token
6e1d81

Query Metrics

7 Database Queries
6 Different statements
14.98 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 1.30 ms 
SELECT t0.id_api AS id_api_1, t0.credencial AS credencial_2, t0.token AS token_3, t0.id_cliente AS id_cliente_4, t0.ativo AS ativo_5, t0.data_add AS data_add_6, t0.data_upd AS data_upd_7 FROM acesso.api t0 WHERE t0.credencial = ? AND t0.token = ? LIMIT 1
Parameters: 
[
  "rSgoBAdqSLSC5orF"
  "f8FkOTiCMeCORcHvfwUZ0fjzMKgSeYqJ"
]
View formatted query    View runnable query    Explain query
2 0.43 ms 
SELECT t0.id_api AS id_api_1, t0.credencial AS credencial_2, t0.token AS token_3, t0.id_cliente AS id_cliente_4, t0.ativo AS ativo_5, t0.data_add AS data_add_6, t0.data_upd AS data_upd_7 FROM acesso.api t0 WHERE t0.credencial = ? AND t0.token = ? LIMIT 1
Parameters: 
[
  "rSgoBAdqSLSC5orF"
  "f8FkOTiCMeCORcHvfwUZ0fjzMKgSeYqJ"
]
View formatted query    View runnable query    Explain query
3 1.41 ms 
SELECT t0.id_cliente AS id_cliente_1, t0.dbname AS dbname_2, t0.nome AS nome_3, t0.ativo AS ativo_4, t0.id_tipo AS id_tipo_5, t0.config AS config_6, t0.host AS host_7, t0.logo AS logo_8, t0.termo_aceite AS termo_aceite_9, t0.id_tipo AS id_tipo_10, t11.id_tipo AS id_tipo_12, t11.nome AS nome_13, t11.ativo AS ativo_14 FROM public.cliente t0 LEFT JOIN public.tipo t11 ON t0.id_tipo = t11.id_tipo WHERE t0.id_cliente = ?
Parameters: 
[
  116
]
View formatted query    View runnable query    Explain query

cliente connection

#▲ Time Info
1 1.72 ms 
SELECT t0.id_avaliado AS id_avaliado_1, t0.nome AS nome_2, t0.ativo AS ativo_3, t0.data_add AS data_add_4, t0.data_upd AS data_upd_5, t0.cod_lattes AS cod_lattes_6, t0.email AS email_7, t0.telefone AS telefone_8, t0.id_avaliado_tipo AS id_avaliado_tipo_9, t10.id_avaliado_tipo AS id_avaliado_tipo_11, t10.nome AS nome_12, t10.ativo AS ativo_13, t10.data_add AS data_add_14, t10.data_upd AS data_upd_15 FROM modelagem.avaliado t0 LEFT JOIN modelagem.avaliado_tipo t10 ON t0.id_avaliado_tipo = t10.id_avaliado_tipo WHERE t0.id_avaliado = ?
Parameters: 
[
  1032
]
View formatted query    View runnable query    Explain query
2 4.75 ms 
SELECT t0.id_avaliado AS id_avaliado_1, t0.nome AS nome_2, t0.ativo AS ativo_3, t0.data_add AS data_add_4, t0.data_upd AS data_upd_5, t0.cod_lattes AS cod_lattes_6, t0.email AS email_7, t0.telefone AS telefone_8, t0.id_avaliado_tipo AS id_avaliado_tipo_9, t10.id_avaliado_tipo AS id_avaliado_tipo_11, t10.nome AS nome_12, t10.ativo AS ativo_13, t10.data_add AS data_add_14, t10.data_upd AS data_upd_15 FROM modelagem.avaliado t0 LEFT JOIN modelagem.avaliado_tipo t10 ON t0.id_avaliado_tipo = t10.id_avaliado_tipo WHERE t0.id_avaliado_tipo = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 3.31 ms 
SELECT DISTINCT
                    ma.id_avaliado AS cod_avaliado,
                    ma.nome AS avaliado,
                    g.titulo AS especialidade,
                    --COALESCE(pav.indicadores->0->'indicadores'||pav.indicadores_adicionais, pm.indicadores->0->'indicadores') AS privilegios
                    COALESCE(pav.indicadores_adicionais, pm.indicadores->0->'indicadores') AS privilegios
                FROM modelagem.avaliado ma
                JOIN modelagem.avaliacao mav ON (ma.id_avaliado = mav.id_avaliado)
                JOIN modelagem.grupo g ON (g.id_grupo = mav.id_grupo)
                JOIN privilegios.modelagem_bkp pm ON (pm.id_modelagem = mav.id_grupo)
                LEFT JOIN privilegios.avaliacao pav ON (ma.id_avaliado = pav.id_avaliado)
                WHERE
                    ma.id_avaliado = 1032
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 2.06 ms 
SELECT
                    TO_CHAR(data_log,'DD/MM/YYYY HH24:MI:SS') AS ultima_alteracao,
                    u.nome AS ultimo_avaliador,
                    COUNT(1) OVER() qtd_alteracoes
                FROM privilegios.avaliacao_log pl
                JOIN acesso.usuario u ON (id_usuario_avaliador = id_usuario)
                WHERE pl.id_avaliado = 1032
                ORDER BY data_log DESC
                LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query

benchmark connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
cliente doctrine.dbal.cliente_connection
benchmark doctrine.dbal.benchmark_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
cliente doctrine.orm.cliente_entity_manager
benchmark doctrine.orm.benchmark_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Painel\UsuarioLog No errors.
App\Entity\Painel\ClienteUsuario No errors.
App\Entity\Painel\Cliente No errors.
App\Entity\Painel\Api No errors.
App\Entity\Painel\Tipo No errors.

cliente entity manager

Class Mapping errors
App\Entity\Cliente\Acesso\UsuarioLog
  • The association App\Entity\Cliente\Acesso\UsuarioLog#usuario refers to the inverse side field App\Entity\Cliente\Acesso\Usuario#usuarioLog which does not exist.
App\Entity\Cliente\Privilegios\Avaliacao No errors.
App\Entity\Cliente\Modelagem\Avaliado
  • The mappings App\Entity\Cliente\Modelagem\Avaliado#login and App\Entity\Cliente\Acesso\Usuario#avaliado are inconsistent with each other.
App\Entity\Cliente\Modelagem\AvaliadoTipo No errors.
App\Entity\Cliente\Modelagem\Avaliacao No errors.
App\Entity\Cliente\Acesso\Usuario
  • The association App\Entity\Cliente\Acesso\Usuario#avaliado refers to the inverse side field App\Entity\Cliente\Modelagem\Avaliado#avaliado which does not exist.

benchmark entity manager

No loaded entities.