Query Metrics
9
Database Queries
5
Different statements
32.87 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.64 ms (65.85%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM persona p0_ LIMIT 15
Parameters:
[] |
|
4.66 ms (14.18%) |
1 |
SELECT p0_.id AS id_0, p0_.rut AS rut_1, p0_.dv AS dv_2, p0_.documento AS documento_3, p0_.nombre AS nombre_4, p0_.paterno AS paterno_5, p0_.materno AS materno_6, p0_.activo AS activo_7, p0_.updated_at AS updated_at_8, p0_.foto_updated_at AS foto_updated_at_9, p0_.pin AS pin_10, p0_.foto AS foto_11, p0_.situacion AS situacion_12, p0_.sexo AS sexo_13, p0_.fecha_nacimiento AS fecha_nacimiento_14, p0_.estado_civil AS estado_civil_15, p0_.numero_telefono1 AS numero_telefono1_16, p0_.numero_telefono2 AS numero_telefono2_17, p0_.email_institucional AS email_institucional_18, p0_.email_personal AS email_personal_19, p0_.nivel_estudio AS nivel_estudio_20, p0_.profesion AS profesion_21, p0_.licencia_conducir AS licencia_conducir_22, p0_.direccion AS direccion_23, p0_.ciudad_id AS ciudad_id_24, p0_.region_id AS region_id_25, p0_.nacion_id AS nacion_id_26, p0_.tipo_entidad AS tipo_entidad_27, p0_.banco_id AS banco_id_28, p0_.cuenta_banco AS cuenta_banco_29, p0_.forma_pago_id AS forma_pago_id_30, p0_.afp_id AS afp_id_31, p0_.estado_jubilacion AS estado_jubilacion_32, p0_.expatriado AS expatriado_33, p0_.sistema_pensiones AS sistema_pensiones_34, p0_.intitucion_salud_id AS intitucion_salud_id_35, p0_.monto_cotizado_isapre AS monto_cotizado_isapre_36, p0_.tramo_asignacion_familiar AS tramo_asignacion_familiar_37, p0_.numero_contrato AS numero_contrato_38, p0_.tipo_contrato AS tipo_contrato_39, p0_.fecha_inicio_contrato AS fecha_inicio_contrato_40, p0_.fecha_fin_contrato AS fecha_fin_contrato_41, p0_.sueldo_base AS sueldo_base_42, p0_.cargo AS cargo_43, p0_.horas_trabajo_semanales AS horas_trabajo_semanales_44, p0_.distribucion_jornada AS distribucion_jornada_45, p0_.cotiza_seguro_cesantia AS cotiza_seguro_cesantia_46, p0_.area AS area_47, p0_.descansa_domingos AS descansa_domingos_48, p0_.cotiza_prevision_ysalud AS cotiza_prevision_ysalud_49, p0_.bloqueo AS bloqueo_50, p0_.marca_asistencia AS marca_asistencia_51, p0_.id_bnovus AS id_bnovus_52, p0_.localizacion AS localizacion_53, p0_.horario AS horario_54, p0_.ultimo_evento_fecha AS ultimo_evento_fecha_55, p0_.grupo_id AS grupo_id_56, p0_.grupomenu_id AS grupomenu_id_57, p0_.turno_id AS turno_id_58, p0_.linea_id AS linea_id_59, p0_.ultimo_evento_id AS ultimo_evento_id_60 FROM persona p0_ WHERE p0_.id IN (?)
Parameters:
[
[
68
176
523
27
396
276
521
534
456
338
458
229
530
67
10
]
]
|
|
3.85 ms (11.71%) |
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
]
|
|
1.65 ms (5.01%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM persona p0_
Parameters:
[] |
|
1.07 ms (3.26%) |
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:
[
3
]
|
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\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 |
|
| App\Entity\Portico | No errors. |