Query Metrics
46
Database Queries
34
Different statements
739.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
174.33 ms (23.57%) |
10 |
UPDATE sis_contacto SET flag_admin_servicio = :flag_admin_servicio, flag_admin_seguridad = :flag_admin_seguridad, id_contacto_nodo = :id_contacto, flag_creado_en_nodo = 1 WHERE id_contacto_pk = :id
Parameters:
[ ":flag_admin_servicio" => 0 ":flag_admin_seguridad" => 0 ":id_contacto" => 183 ":id" => 266 ] |
|
101.97 ms (13.78%) |
1 |
SELECT * FROM vw_abm_documento_entidad WHERE id_entidad = 193 AND id_area_empresa in (1) AND cod_tipo_entidad = 'C'
Parameters:
[] |
|
65.34 ms (8.83%) |
3 |
SELECT * FROM vw_abm_contacto WHERE id_cliente = 193
Parameters:
[] |
|
28.25 ms (3.82%) |
2 |
SELECT * FROM vw_abm_usuario WHERE id_agente = 1
Parameters:
[] |
|
22.08 ms (2.99%) |
1 |
SELECT * FROM vw_abm_clase_servicio
Parameters:
[] |
|
22.08 ms (2.98%) |
1 |
SELECT * FROM vw_abm_usuario WHERE id_usuario_pk = 29
Parameters:
[] |
|
21.96 ms (2.97%) |
1 |
SELECT * FROM vw_abm_moneda
Parameters:
[] |
|
20.16 ms (2.72%) |
1 |
SELECT * FROM vw_abm_hito WHERE id_cliente = 193
Parameters:
[] |
|
19.92 ms (2.69%) |
1 |
SELECT * FROM vw_abm_plan_servicio
Parameters:
[] |
|
19.88 ms (2.69%) |
1 |
SELECT * FROM sis_tipo_estado_tarea
Parameters:
[] |
|
19.82 ms (2.68%) |
1 |
SELECT * FROM vw_abm_plan_grupo
Parameters:
[] |
|
19.76 ms (2.67%) |
1 |
SELECT * FROM vw_abm_tarea WHERE id_cliente = 193
Parameters:
[] |
|
18.24 ms (2.47%) |
1 |
SELECT * FROM vw_grd_instance_client_mapping WHERE id_local_service = 54
Parameters:
[] |
|
18.03 ms (2.44%) |
1 |
SELECT * FROM vw_abm_tipo_modo_servicio
Parameters:
[] |
|
17.97 ms (2.43%) |
1 |
SELECT * FROM sis_tipo_tarea_dependencia
Parameters:
[] |
|
17.96 ms (2.43%) |
1 |
SELECT * FROM vw_abm_instancia_server
Parameters:
[] |
|
17.79 ms (2.40%) |
1 |
SELECT * FROM vw_abm_tipo_estado_hito
Parameters:
[] |
|
14.12 ms (1.91%) |
1 |
SELECT * FROM vw_abm_tipo_estado_cliente WHERE flag_cliente = 1
Parameters:
[] |
|
14.04 ms (1.90%) |
1 |
SELECT * FROM vw_grd_instance_client_mapping WHERE id_local_service = 171
Parameters:
[] |
|
13.97 ms (1.89%) |
1 |
SELECT * FROM vw_abm_nota WHERE id_cliente = 193 ORDER BY cr_timestamp DESC
Parameters:
[] |
|
13.89 ms (1.88%) |
1 |
SELECT t0.id_usuario_pk AS id_usuario_pk_1, t0.id_agente AS id_agente_2, t0.desc_nombre AS desc_nombre_3, t0.desc_apellido AS desc_apellido_4, t0.documento_identidad AS documento_identidad_5, t0.dir_correo AS dir_correo_6, t0.flag_dir_correo_validada AS flag_dir_correo_validada_7, t0.telefono AS telefono_8, t0.direccion_residencia AS direccion_residencia_9, t0.fecha_nacimiento AS fecha_nacimiento_10, t0.sexo AS sexo_11, t0.nickname AS nickname_12, t0.password AS password_13, t0.firstLogin2FA AS firstLogin2FA_14, t0.2fa_key AS 2fa_key_15, t0.2fa_outKey AS 2fa_outKey_16, t0.json_roles AS json_roles_17, t0.num_jerarquia_roles AS num_jerarquia_roles_18, t0.flag_eliminar_registros_habilitado AS flag_eliminar_registros_habilitado_19, t0.flag_habilitado AS flag_habilitado_20, t0.flag_registro_eliminado AS flag_registro_eliminado_21, t0.cr_fingerprint AS cr_fingerprint_22, t0.cr_id_user AS cr_id_user_23, t0.cr_timestamp AS cr_timestamp_24, t0.del_flag_deleted AS del_flag_deleted_25, t0.del_id_user AS del_id_user_26, t0.del_timestamp AS del_timestamp_27, t0.roles AS roles_28 FROM sis_usuario t0 WHERE t0.id_usuario_pk = ?
Parameters:
[
29
]
|
|
12.24 ms (1.65%) |
1 |
SELECT * FROM vw_abm_cuenta_bancaria_pago
Parameters:
[] |
|
11.93 ms (1.61%) |
1 |
SELECT * FROM vw_abm_tipo_documento ORDER BY orden_presentacion ASC
Parameters:
[] |
|
9.42 ms (1.27%) |
1 |
SELECT * FROM vw_abm_pais
Parameters:
[] |
|
6.19 ms (0.84%) |
1 |
SELECT * FROM vw_abm_servicio WHERE id_cliente = 193
Parameters:
[] |
|
3.87 ms (0.52%) |
1 |
SELECT * FROM vw_abm_area_empresa WHERE id_area_empresa_pk in (1)
Parameters:
[] |
|
3.68 ms (0.50%) |
1 |
SELECT * FROM vw_abm_servicio_conector WHERE id_cliente = :id_cliente
Parameters:
[ ":id_cliente" => "193" ] |
|
2.42 ms (0.33%) |
1 |
SELECT * FROM vw_abm_agente WHERE flag_activo = 1
Parameters:
[] |
|
2.26 ms (0.31%) |
1 |
SELECT * FROM vw_abm_cliente WHERE id_cliente_pk = 193
Parameters:
[] |
|
1.97 ms (0.27%) |
1 |
SELECT * FROM vw_abm_tipo_medio_pago
Parameters:
[] |
|
1.96 ms (0.26%) |
1 |
SELECT * FROM vw_abm_usuario
Parameters:
[] |
|
1.19 ms (0.16%) |
1 |
SELECT * FROM vw_abm_tipo_documento_fiscal
Parameters:
[] |
|
0.54 ms (0.07%) |
1 |
SELECT * FROM vw_abm_tipo_modalidad_facturacion
Parameters:
[] |
|
0.52 ms (0.07%) |
1 |
SELECT * FROM vw_abm_tipo_proceso_facturacion
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SisUsuario | No errors. |