Query Metrics
46
Database Queries
5
Different statements
136.08 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
105.16 ms (77.28%) |
1 |
SELECT e0_.id AS id_0, e0_.fecha AS fecha_1, e0_.entrada AS entrada_2, e0_.autorizado AS autorizado_3, e0_.qr AS qr_4, e0_.id_interno AS id_interno_5, e0_.fecha_bnovus AS fecha_bnovus_6, e0_.respuesta_bnovus AS respuesta_bnovus_7, e0_.is_jornada AS is_jornada_8, e0_.eliminado AS eliminado_9, e0_.persona_id AS persona_id_10, e0_.equipo_id AS equipo_id_11, e0_.turno_id AS turno_id_12, e0_.grupo_id AS grupo_id_13 FROM evento e0_ WHERE e0_.fecha > ? AND e0_.fecha < ? AND e0_.autorizado = 1 ORDER BY e0_.id DESC
Parameters:
[ "2026-10-20 00:00:00" "2026-10-21 00:00:00" ] |
|
19.07 ms (14.01%) |
32 |
SELECT t0.id AS id_1, t0.rut AS rut_2, t0.dv AS dv_3, t0.documento AS documento_4, t0.nombre AS nombre_5, t0.paterno AS paterno_6, t0.materno AS materno_7, t0.activo AS activo_8, t0.updated_at AS updated_at_9, t0.foto_updated_at AS foto_updated_at_10, t0.pin AS pin_11, t0.foto AS foto_12, t0.situacion AS situacion_13, t0.sexo AS sexo_14, t0.fecha_nacimiento AS fecha_nacimiento_15, t0.estado_civil AS estado_civil_16, t0.numero_telefono1 AS numero_telefono1_17, t0.numero_telefono2 AS numero_telefono2_18, t0.email_institucional AS email_institucional_19, t0.email_personal AS email_personal_20, t0.nivel_estudio AS nivel_estudio_21, t0.profesion AS profesion_22, t0.licencia_conducir AS licencia_conducir_23, t0.direccion AS direccion_24, t0.ciudad_id AS ciudad_id_25, t0.region_id AS region_id_26, t0.nacion_id AS nacion_id_27, t0.tipo_entidad AS tipo_entidad_28, t0.banco_id AS banco_id_29, t0.cuenta_banco AS cuenta_banco_30, t0.forma_pago_id AS forma_pago_id_31, t0.afp_id AS afp_id_32, t0.estado_jubilacion AS estado_jubilacion_33, t0.expatriado AS expatriado_34, t0.sistema_pensiones AS sistema_pensiones_35, t0.intitucion_salud_id AS intitucion_salud_id_36, t0.monto_cotizado_isapre AS monto_cotizado_isapre_37, t0.tramo_asignacion_familiar AS tramo_asignacion_familiar_38, t0.numero_contrato AS numero_contrato_39, t0.tipo_contrato AS tipo_contrato_40, t0.fecha_inicio_contrato AS fecha_inicio_contrato_41, t0.fecha_fin_contrato AS fecha_fin_contrato_42, t0.sueldo_base AS sueldo_base_43, t0.cargo AS cargo_44, t0.horas_trabajo_semanales AS horas_trabajo_semanales_45, t0.distribucion_jornada AS distribucion_jornada_46, t0.cotiza_seguro_cesantia AS cotiza_seguro_cesantia_47, t0.area AS area_48, t0.descansa_domingos AS descansa_domingos_49, t0.cotiza_prevision_ysalud AS cotiza_prevision_ysalud_50, t0.bloqueo AS bloqueo_51, t0.marca_asistencia AS marca_asistencia_52, t0.id_bnovus AS id_bnovus_53, t0.localizacion AS localizacion_54, t0.horario AS horario_55, t0.ultimo_evento_fecha AS ultimo_evento_fecha_56, t0.grupo_id AS grupo_id_57, t0.grupomenu_id AS grupomenu_id_58, t0.turno_id AS turno_id_59, t0.linea_id AS linea_id_60, t0.ultimo_evento_id AS ultimo_evento_id_61 FROM persona t0 WHERE t0.id = ?
Parameters:
[
557
]
|
|
6.57 ms (4.83%) |
5 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.visitas AS visitas_3, t0.deshabilitacion_automatica AS deshabilitacion_automatica_4 FROM grupo t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
3.48 ms (2.55%) |
7 |
SELECT t0.id AS id_1, t0.serial AS serial_2, t0.nombre AS nombre_3, t0.ip AS ip_4, t0.sentido AS sentido_5, t0.nombre_bnovus AS nombre_bnovus_6, t0.portico_id AS portico_id_7 FROM equipo t0 WHERE t0.id = ?
Parameters:
[
9
]
|
|
1.81 ms (1.33%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
7
]
|
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\User | No errors. |
| App\Entity\Evento |
|
| App\Entity\Persona | No errors. |
| App\Entity\Equipo | No errors. |
| App\Entity\Turno | No errors. |
| App\Entity\Grupo | No errors. |
| App\Entity\Grupomenu | No errors. |
| App\Entity\Linea | No errors. |
| App\Entity\Justificacion | No errors. |
| App\Entity\RegistroCasino |
|
| App\Entity\Portico | No errors. |