Query Metrics
4
Database Queries
4
Different statements
7.97 ms
Query time
3
Invalid entities
Queries
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 |
|
| App\Entity\Cliente\Acesso\Usuario |
|
| App\Entity\Cliente\Modelagem\Avaliado |
|
| 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.