http://analytics.2im.com.br/visao-gestor/redirect/avaliado/676

Query Metrics

4 Database Queries
4 Different statements
7.97 ms Query time
3 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.34 ms
SELECT t0.id_usuario AS id_usuario_1, t0.nome AS nome_2, t0.email AS email_3, t0.login AS login_4, t0.id_avaliado AS id_avaliado_5, t0.senha AS senha_6, t0.ativo AS ativo_7, t0.data_add AS data_add_8, t0.data_upd AS data_upd_9, t0.force_update AS force_update_10, t0.senha_update AS senha_update_11, t0.data_limite_acesso AS data_limite_acesso_12, t0.onboard AS onboard_13, t0.foto AS foto_14, t0.googleAuthenticatorSecret AS googleauthenticatorsecret_15, t0.passwordless_token AS passwordless_token_16, t0.id_perfil AS id_perfil_17 FROM analytics.usuario t0 WHERE t0.id_usuario = ?
Parameters:
[
  8694
]
2 0.65 ms
SELECT t0.id_perfil AS id_perfil_1, t0.titulo AS titulo_2, t0.data_add AS data_add_3, t0.data_upd AS data_upd_4, t0.rota_default AS rota_default_5, t0.role AS role_6, t0.permissao AS permissao_7 FROM analytics.perfil t0 WHERE t0.id_perfil = ?
Parameters:
[
  3
]
3 0.67 ms
SELECT t0.id_usuario_cliente AS id_usuario_cliente_1, t0.id_cliente AS id_cliente_2, t0.id_usuario AS id_usuario_3, t0.nome AS nome_4, t0.permissao AS permissao_5, t0.data_add AS data_add_6, t0.data_aceite_termo AS data_aceite_termo_7 FROM analytics.usuario_cliente t0 WHERE t0.id_usuario = ? AND t0.id_cliente = ? LIMIT 1
Parameters:
[
  8694
  223
]

cliente connection

# Time Info
1 5.30 ms
SELECT
                 Concat(periodo->>'ano',periodo->>'periodo')::integer periodo
                ,id_avaliado
                ,nome_avaliado
                ,id_grupo
                ,nome_grupo
                ,id_modelagem
                ,nome_modelagem
                ,id_programa
                ,nome_programa
                ,COALESCE(valor, 0) AS valor
                ,COALESCE(performance_qualidade, 0) AS performance_qualidade
                ,COALESCE(performance_custo, 0) AS performance_custo
            FROM
                dados.evs
            WHERE
                (periodo->>'ano')::integer = :ano
                AND id_avaliado = :id_avaliado
                AND id_grupo = :id_grupo
                AND id_programa = :id_programa
                AND id_modelagem = :id_modelagem
            ORDER BY
                1 DESC
Parameters:
[
  ":ano" => 2026
  ":id_avaliado" => 676
  ":id_programa" => 1
  ":id_modelagem" => 1
  ":id_grupo" => "28"
]

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\SSO No errors.
App\Entity\Painel\Passwordless No errors.
App\Entity\Painel\Usuario No errors.
App\Entity\Painel\Visao No errors.
App\Entity\Painel\Cliente No errors.
App\Entity\Painel\Perfil No errors.
App\Entity\Painel\UsuarioAcesso 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\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.
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\Modelagem No errors.
App\Entity\Cliente\Modelagem\Programa No errors.
App\Entity\Cliente\Dados\Evs No errors.
App\Entity\Cliente\Periodo\Periodo No errors.
App\Entity\Cliente\Dados\Calculo No errors.
App\Entity\Cliente\Fornecidos\DadosEnviados No errors.
App\Entity\Cliente\Fornecidos\Solicitacao No errors.

benchmark entity manager

No loaded entities.