https://newadmin.damap.cloud/administracion/tickets/691

Query Metrics

5 Database Queries
5 Different statements
272.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
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:
[
  49
]
2 1.09 ms
SELECT * FROM vw_abm_tickets WHERE id_ticket_pk = :id_ticket_pk AND id_usuario_responsable = :id_usuario_responsable
Parameters:
[
  "id_ticket_pk" => "691"
  "id_usuario_responsable" => 49
]
3 0.94 ms
SELECT * FROM vw_abm_tickets WHERE id_ticket_pk = :id LIMIT 1
Parameters:
[
  "id" => "691"
]
4 268.82 ms
SELECT * FROM sis_ticket_comentario WHERE id_ticket = :id_ticket
Parameters:
[
  "id_ticket" => "691"
]
5 1.14 ms
SELECT id_usuario_pk, CONCAT(desc_nombre, ' ', desc_apellido) AS name, nickname  FROM damap_bes_admin_v10.vw_abm_usuario WHERE id_agente IN (SELECT id_agente FROM damap_bes_admin_v10.vw_abm_usuario WHERE id_usuario_pk = :id_usuario_pk)
Parameters:
[
  "id_usuario_pk" => 49
]

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.