https://cerberus.eurekatech.io/admin?crudAction=index&crudId=4e17ad8

Query Metrics

9 Database Queries
5 Different statements
32.87 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

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
  • The association App\Entity\Evento#personas refers to the owning side field App\Entity\Persona#ultimo_evento which does not exist.
App\Entity\Justificacion No errors.
App\Entity\RegistroCasino
  • The mappings App\Entity\RegistroCasino#persona and App\Entity\Persona#registrosCasino are inconsistent with each other.
App\Entity\Portico No errors.