https://newadmin.damap.cloud/clients/editClient/193?nocache=1776181998103

Query Metrics

46 Database Queries
34 Different statements
739.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.