Query Metrics
5
Database Queries
5
Different statements
11.58 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.14 ms (44.35%) |
1 |
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.ip = ? LIMIT 1
Parameters:
[
"100.117.135.68"
]
|
|
2.89 ms (24.99%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.74 ms (15.01%) |
1 |
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.rut = ? LIMIT 1
Parameters:
[
"17794956"
]
|
|
1.57 ms (13.55%) |
1 |
INSERT INTO evento (fecha, entrada, autorizado, qr, id_interno, fecha_bnovus, respuesta_bnovus, is_jornada, eliminado, persona_id, equipo_id, turno_id, grupo_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "2024-12-25 14:18:55" 2 => 0 3 => 1 4 => "17794956" 5 => 17794956 6 => null 7 => null 8 => null 9 => null 10 => 74 11 => 2 12 => null 13 => null ] |
|
0.24 ms (2.11%) |
1 |
"START TRANSACTION"
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\Equipo | No errors. |
| App\Entity\Portico | No errors. |
| App\Entity\Persona | No errors. |
| App\Entity\Grupo | No errors. |
| App\Entity\Grupomenu | No errors. |
| App\Entity\Turno | No errors. |
| App\Entity\Linea | No errors. |
| App\Entity\Evento |
|
| App\Entity\Justificacion | No errors. |
| App\Entity\RegistroCasino |
|