Query Metrics
5
Database Queries
5
Different statements
272.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
268.82 ms (98.52%) |
1 |
SELECT * FROM sis_ticket_comentario WHERE id_ticket = :id_ticket
Parameters:
[ "id_ticket" => "691" ] |
|
1.14 ms (0.42%) |
1 |
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 ] |
|
1.09 ms (0.40%) |
1 |
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 ] |
|
0.94 ms (0.34%) |
1 |
SELECT * FROM vw_abm_tickets WHERE id_ticket_pk = :id LIMIT 1
Parameters:
[ "id" => "691" ] |
|
0.88 ms (0.32%) |
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:
[
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. |