Symfony Profiler

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 = ?

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 = 29;

SELECT
  *
FROM
  vw_abm_cliente
WHERE
  id_cliente_pk = 193

SELECT * FROM vw_abm_cliente WHERE id_cliente_pk = 193;

SELECT
  *
FROM
  vw_abm_pais

SELECT * FROM vw_abm_pais;

SELECT
  *
FROM
  vw_abm_agente
WHERE
  flag_activo = 1

SELECT * FROM vw_abm_agente WHERE flag_activo = 1;

SELECT
  *
FROM
  vw_abm_usuario

SELECT * FROM vw_abm_usuario;

SELECT
  *
FROM
  vw_abm_tipo_documento_fiscal

SELECT * FROM vw_abm_tipo_documento_fiscal;

SELECT
  *
FROM
  vw_abm_tipo_modalidad_facturacion

SELECT * FROM vw_abm_tipo_modalidad_facturacion;

SELECT
  *
FROM
  vw_abm_tipo_proceso_facturacion

SELECT * FROM vw_abm_tipo_proceso_facturacion;

SELECT
  *
FROM
  vw_abm_contacto
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_contacto WHERE id_cliente = 193;

SELECT
  *
FROM
  vw_abm_servicio
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_servicio WHERE id_cliente = 193;

SELECT
  *
FROM
  vw_abm_tipo_estado_hito

SELECT * FROM vw_abm_tipo_estado_hito;

SELECT
  *
FROM
  vw_abm_tipo_estado_cliente
WHERE
  flag_cliente = 1

SELECT * FROM vw_abm_tipo_estado_cliente WHERE flag_cliente = 1;

SELECT
  *
FROM
  vw_abm_nota
WHERE
  id_cliente = 193
ORDER BY
  cr_timestamp DESC

SELECT * FROM vw_abm_nota WHERE id_cliente = 193 ORDER BY cr_timestamp DESC;

SELECT
  *
FROM
  vw_grd_instance_client_mapping
WHERE
  id_local_service = 54

SELECT * FROM vw_grd_instance_client_mapping WHERE id_local_service = 54;

SELECT
  *
FROM
  vw_abm_usuario
WHERE
  id_agente = 1

SELECT * FROM vw_abm_usuario WHERE id_agente = 1;

SELECT
  *
FROM
  vw_abm_contacto
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_contacto WHERE id_cliente = 193;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

SELECT
  *
FROM
  vw_grd_instance_client_mapping
WHERE
  id_local_service = 171

SELECT * FROM vw_grd_instance_client_mapping WHERE id_local_service = 171;

SELECT
  *
FROM
  vw_abm_usuario
WHERE
  id_agente = 1

SELECT * FROM vw_abm_usuario WHERE id_agente = 1;

SELECT
  *
FROM
  vw_abm_contacto
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_contacto WHERE id_cliente = 193;

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

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;

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

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;

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

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;

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

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;

SELECT
  *
FROM
  vw_abm_tarea
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_tarea WHERE id_cliente = 193;

SELECT
  *
FROM
  vw_abm_hito
WHERE
  id_cliente = 193

SELECT * FROM vw_abm_hito WHERE id_cliente = 193;

SELECT
  *
FROM
  vw_abm_moneda

SELECT * FROM vw_abm_moneda;

SELECT
  *
FROM
  sis_tipo_tarea_dependencia

SELECT * FROM sis_tipo_tarea_dependencia;

SELECT
  *
FROM
  sis_tipo_estado_tarea

SELECT * FROM sis_tipo_estado_tarea;

SELECT
  *
FROM
  vw_abm_tipo_modo_servicio

SELECT * FROM vw_abm_tipo_modo_servicio;

SELECT
  *
FROM
  vw_abm_clase_servicio

SELECT * FROM vw_abm_clase_servicio;

SELECT
  *
FROM
  vw_abm_plan_grupo

SELECT * FROM vw_abm_plan_grupo;

SELECT
  *
FROM
  vw_abm_plan_servicio

SELECT * FROM vw_abm_plan_servicio;

SELECT
  *
FROM
  vw_abm_instancia_server

SELECT * FROM vw_abm_instancia_server;

SELECT
  *
FROM
  vw_abm_tipo_documento
ORDER BY
  orden_presentacion ASC

SELECT * FROM vw_abm_tipo_documento ORDER BY orden_presentacion ASC;

SELECT
  *
FROM
  vw_abm_usuario
WHERE
  id_usuario_pk = 29

SELECT * FROM vw_abm_usuario WHERE id_usuario_pk = 29;

SELECT
  *
FROM
  vw_abm_area_empresa
WHERE
  id_area_empresa_pk in (1)

SELECT * FROM vw_abm_area_empresa WHERE id_area_empresa_pk in (1);

SELECT
  *
FROM
  vw_abm_documento_entidad
WHERE
  id_entidad = 193
  AND id_area_empresa in (1)
  AND cod_tipo_entidad = 'C'

SELECT * FROM vw_abm_documento_entidad WHERE id_entidad = 193 AND id_area_empresa in (1) AND cod_tipo_entidad = 'C';

SELECT
  *
FROM
  vw_abm_tipo_medio_pago

SELECT * FROM vw_abm_tipo_medio_pago;

SELECT
  *
FROM
  vw_abm_cuenta_bancaria_pago

SELECT * FROM vw_abm_cuenta_bancaria_pago;

SELECT
  *
FROM
  vw_abm_servicio_conector
WHERE
  id_cliente = :id_cliente

SELECT * FROM vw_abm_servicio_conector WHERE id_cliente = :id_cliente;