Query Metrics
94
Database Queries
10
Different statements
14.93 ms
Query time
2
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\Evaluacioncolegio | No errors. |
| App\Entity\MacroTipoAgenda | No errors. |
| App\Entity\Colegio |
|
| 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. |