https://difusionuc.eurekatech.io/agenda/estudiantes

Query Metrics

94 Database Queries
10 Different statements
14.93 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.43 ms
(43.06%)
26
SELECT t0.id AS id_1, t0.observacion AS observacion_2, t0.horas AS horas_3, t0.valor_total AS valor_total_4, t0.pagado AS pagado_5, t0.estado AS estado_6, t0.tipo AS tipo_7, t0.cuerpo AS cuerpo_8, t0.enviado AS enviado_9, t0.monto AS monto_10, t0.fecha AS fecha_11, t0.correo AS correo_12, t0.rol AS rol_13, t0.codigo_qr AS codigo_qr_14, t0.estado_confirmacion AS estado_confirmacion_15, t0.fecha_confirmacion AS fecha_confirmacion_16, t0.embajadores_id AS embajadores_id_17, t0.agenda_id AS agenda_id_18, t0.nomina_id AS nomina_id_19 FROM embajador_participante t0 WHERE t0.agenda_id = ?
Parameters:
[
  2352
]
2.94 ms
(19.67%)
24
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.comuna AS comuna_3, t0.nombre_director AS nombre_director_4, t0.correo_director AS correo_director_5, t0.nombre_orientador AS nombre_orientador_6, t0.correo_orientador AS correo_orientador_7, t0.codigo_uc AS codigo_uc_8, t0.rbd AS rbd_9, t0.prompsu AS prompsu_10, t0.ive AS ive_11, t0.pace AS pace_12, t0.programa2018 AS programa2018_13, t0.programa2019 AS programa2019_14, t0.acceso_inclusivo AS acceso_inclusivo_15, t0.telefono AS telefono_16, t0.base_origen AS base_origen_17, t0.local_educacional AS local_educacional_18, t0.ranking AS ranking_19, t0.direccion AS direccion_20, t0.cantidadagendas AS cantidadagendas_21, t0.foto AS foto_22, t0.programa AS programa_23, t0.tp AS tp_24, t0.tecnico AS tecnico_25, t0.provincia AS provincia_26, t0.regionstring AS regionstring_27, t0.regionn AS regionn_28, t0.dependencia_id AS dependencia_id_29, t0.regimen_id AS regimen_id_30, t0.region_id AS region_id_31 FROM colegio t0 WHERE t0.id = ?
Parameters:
[
  20364
]
2.85 ms
(19.12%)
26
SELECT t0.id AS id_1, t0.observacion AS observacion_2, t0.asiste AS asiste_3, t0.colegio_id AS colegio_id_4, t0.agenda_id AS agenda_id_5 FROM colegio_participante t0 WHERE t0.agenda_id = ?
Parameters:
[
  2352
]
1.19 ms
(8.00%)
9
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.cuerpo AS cuerpo_3, t0.macro_tipo_agenda_id AS macro_tipo_agenda_id_4 FROM tipo_agenda t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.40 ms
(2.69%)
4
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.grupo AS grupo_3 FROM dependencia t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.32 ms
(2.16%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  21453870
]
0.24 ms
(1.61%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.color AS color_3, t0.embajador_id AS embajador_id_4 FROM tagembajador t0 INNER JOIN embajadores_tagembajador ON t0.id = embajadores_tagembajador.tagembajador_id WHERE embajadores_tagembajador.embajadores_id = ?
Parameters:
[
  21453870
]
0.20 ms
(1.31%)
1
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.n_alumnos AS n_alumnos_3, t0.n_encuestas AS n_encuestas_4, t0.curso AS curso_5, t0.observacion AS observacion_6, t0.taxi AS taxi_7, t0.horariotaxi AS horariotaxi_8, t0.lugar AS lugar_9, t0.comentario_final AS comentario_final_10, t0.direccion AS direccion_11, t0.hasta AS hasta_12, t0.archivada AS archivada_13, t0.comuna AS comuna_14, t0.encargado AS encargado_15, t0.telefonoencargado AS telefonoencargado_16, t0.abiertopostulacion AS abiertopostulacion_17, t0.monto AS monto_18, t0.bus AS bus_19, t0.roles AS roles_20, t0.temporales AS temporales_21, t0.encuestaenviada AS encuestaenviada_22, t0.permita_unidad_academica AS permita_unidad_academica_23, t0.capacidad_maxima AS capacidad_maxima_24, t0.inscritos_confirmados AS inscritos_confirmados_25, t0.categoria_evento AS categoria_evento_26, t0.requiere_confirmacion AS requiere_confirmacion_27, t0.estado_agenda_id AS estado_agenda_id_28, t0.tipo_agenda_id AS tipo_agenda_id_29, t0.solicitud_id AS solicitud_id_30, t0.plantilla_colegio_id AS plantilla_colegio_id_31, t0.plantilla_embajador_id AS plantilla_embajador_id_32 FROM agenda t0 WHERE t0.estado_agenda_id IN (?) AND t0.abiertopostulacion = ?
Parameters:
[
  1
  1
]
0.19 ms
(1.25%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.correo AS correo_3, t0.carrera AS carrera_4, t0.rut AS rut_5, t0.dase AS dase_6, t0.inclusion AS inclusion_7, t0.difusion AS difusion_8, t0.talla_polera AS talla_polera_9, t0.observacion_medica AS observacion_medica_10, t0.telefono_emergencia AS telefono_emergencia_11, t0.contacto_emergencia AS contacto_emergencia_12, t0.parentesco_emergencia AS parentesco_emergencia_13, t0.prevision_salud AS prevision_salud_14, t0.centro_hospitalario AS centro_hospitalario_15, t0.centrohospitalario AS centrohospitalario_16, t0.viaingreso AS viaingreso_17, t0.situacion AS situacion_18, t0.anio AS anio_19, t0.categoria AS categoria_20, t0.nproveedor AS nproveedor_21, t0.fnacimiento AS fnacimiento_22, t0.aniodifusion AS aniodifusion_23, t0.celular AS celular_24, t0.region AS region_25, t0.comuna AS comuna_26, t0.domicilio AS domicilio_27, t0.comunactual AS comunactual_28, t0.colegio AS colegio_29, t0.regioncolegio AS regioncolegio_30, t0.tienebanco AS tienebanco_31, t0.banco AS banco_32, t0.tipocuenta AS tipocuenta_33, t0.ncuenta AS ncuenta_34, t0.actualiza AS actualiza_35, t0.fechaactualiza AS fechaactualiza_36, t0.resultadocanvas AS resultadocanvas_37, t0.estado AS estado_38, t0.carnet AS carnet_39, t0.nacionalidad AS nacionalidad_40, t0.carreralist_id AS carreralist_id_41 FROM embajadores t0 WHERE t0.correo = ? LIMIT 1
Parameters:
[
  "jbduboth@uc.cl"
]
0.17 ms
(1.13%)
1
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM estado_agenda t0 WHERE t0.nombre IN (?)
Parameters:
[
  "agendada"
]

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\Accion No errors.
App\Entity\Pago No errors.
App\Entity\Agenda No errors.
App\Entity\EstadoAgenda No errors.
App\Entity\Embajadores No errors.
App\Entity\Carrera No errors.
App\Entity\AsistenteCharla No errors.
App\Entity\EmbajadorParticipante No errors.
App\Entity\Tagembajador No errors.
App\Entity\Nominapago No errors.
App\Entity\Evaluacionembajador No errors.
App\Entity\TipoAgenda No errors.
App\Entity\Solicitud No errors.
App\Entity\EncuestaPlantilla No errors.
App\Entity\Encuesta No errors.
App\Entity\ColegioParticipante No errors.
App\Entity\Uaparticipante No errors.
App\Entity\UsoMaterial No errors.
App\Entity\Lead
  • The mappings App\Entity\Lead#colegio and App\Entity\Colegio#leads are inconsistent with each other.
App\Entity\Evaluacioncolegio No errors.
App\Entity\MacroTipoAgenda No errors.
App\Entity\Colegio
  • The association App\Entity\Colegio#leads refers to the owning side field App\Entity\Lead#cpolegio which does not exist.
App\Entity\Dependencia No errors.
App\Entity\Regimen No errors.
App\Entity\Region No errors.
App\Entity\TagColegio No errors.
App\Entity\Colegiodetalle No errors.
App\Entity\Inscripcionensayo No errors.
App\Entity\Datoscolegio No errors.
App\Entity\PreInscripcionExpo No errors.
App\Entity\Prospecto No errors.
App\Entity\Inscripcionexpo No errors.
App\Entity\Contacto No errors.