Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.origen AS origen_2,
  t0.puntaje AS puntaje_3,
  t0.porcentaje AS porcentaje_4,
  t0.examen_resultado_id AS examen_resultado_id_5,
  t0.topico_id AS topico_id_6,
  t0.instancia_topico_guardado_id AS instancia_topico_guardado_id_7
FROM
  examen_resultado_topico t0
WHERE
  t0.examen_resultado_id = ?

SELECT t0.id AS id_1, t0.origen AS origen_2, t0.puntaje AS puntaje_3, t0.porcentaje AS porcentaje_4, t0.examen_resultado_id AS examen_resultado_id_5, t0.topico_id AS topico_id_6, t0.instancia_topico_guardado_id AS instancia_topico_guardado_id_7 FROM examen_resultado_topico t0 WHERE t0.examen_resultado_id = 3;

SELECT
  t0.id AS id_1,
  t0.origen AS origen_2,
  t0.puntaje AS puntaje_3,
  t0.porcentaje AS porcentaje_4,
  t0.examen_resultado_id AS examen_resultado_id_5,
  t0.modulo_id AS modulo_id_6,
  t0.instancia_modulo_guardado_id AS instancia_modulo_guardado_id_7
FROM
  examen_resultado_modulo t0
WHERE
  t0.examen_resultado_id = ?

SELECT t0.id AS id_1, t0.origen AS origen_2, t0.puntaje AS puntaje_3, t0.porcentaje AS porcentaje_4, t0.examen_resultado_id AS examen_resultado_id_5, t0.modulo_id AS modulo_id_6, t0.instancia_modulo_guardado_id AS instancia_modulo_guardado_id_7 FROM examen_resultado_modulo t0 WHERE t0.examen_resultado_id = 3;

SELECT
  e0_.id AS id_0,
  e0_.puntaje AS puntaje_1,
  e0_.porcentaje AS porcentaje_2,
  e0_.nota_numerica AS nota_numerica_3,
  e0_.nota_alfa AS nota_alfa_4,
  e0_.tipo_resultado AS tipo_resultado_5,
  e0_.vigente AS vigente_6,
  e0_.ts_registro AS ts_registro_7,
  e1_.id AS id_8,
  e1_.tipo_examen AS tipo_examen_9,
  e1_.ts_inscripcion AS ts_inscripcion_10,
  e1_.estado_inscripcion AS estado_inscripcion_11,
  e1_.ts_cambio AS ts_cambio_12,
  e1_.cod_curriculum_al_inscribir AS cod_curriculum_al_inscribir_13,
  e1_.ppa_al_inscribir AS ppa_al_inscribir_14,
  e1_.observacion_estado AS observacion_estado_15,
  e1_.aceptacion_condicional AS aceptacion_condicional_16,
  e1_.fecha_impresion AS fecha_impresion_17,
  e1_.num_inscripcion AS num_inscripcion_18,
  e2_.id AS id_19,
  e2_.rut AS rut_20,
  e2_.nombre AS nombre_21,
  e2_.apellido_pat AS apellido_pat_22,
  e2_.apellido_mat AS apellido_mat_23,
  e2_.nro_alumno AS nro_alumno_24,
  e2_.sexo AS sexo_25,
  e2_.fecha_nacimiento AS fecha_nacimiento_26,
  e2_.login AS login_27,
  e2_.situacion_academica AS situacion_academica_28,
  e2_.dv AS dv_29,
  e2_.is_piane AS is_piane_30,
  e3_.id AS id_31,
  e3_.nombre_legible AS nombre_legible_32,
  e3_.porcentaje_min_aprobacion AS porcentaje_min_aprobacion_33,
  e3_.porcentaje_min_distincion AS porcentaje_min_distincion_34,
  e3_.formato_nota_final AS formato_nota_final_35,
  e0_.examen_inscripcion_id AS examen_inscripcion_id_36,
  e1_.instancia_variante_id AS instancia_variante_id_37,
  e1_.estudiante_id AS estudiante_id_38,
  e1_.asiento_id AS asiento_id_39,
  e3_.instancia_examen_id AS instancia_examen_id_40,
  e3_.variante_id AS variante_id_41
FROM
  examen_resultado e0_
  INNER JOIN examen_inscripcion e1_ ON e0_.examen_inscripcion_id = e1_.id
  INNER JOIN estudiante e2_ ON e1_.estudiante_id = e2_.id
  INNER JOIN examen_config_instancia_variante e3_ ON e1_.instancia_variante_id = e3_.id
  INNER JOIN examen_config_instancia_examen e4_ ON e3_.instancia_examen_id = e4_.id
WHERE
  e4_.id = ?
  AND e0_.vigente = ?
  AND e0_.tipo_resultado = ?
ORDER BY
  e2_.rut ASC,
  e1_.num_inscripcion ASC

SELECT e0_.id AS id_0, e0_.puntaje AS puntaje_1, e0_.porcentaje AS porcentaje_2, e0_.nota_numerica AS nota_numerica_3, e0_.nota_alfa AS nota_alfa_4, e0_.tipo_resultado AS tipo_resultado_5, e0_.vigente AS vigente_6, e0_.ts_registro AS ts_registro_7, e1_.id AS id_8, e1_.tipo_examen AS tipo_examen_9, e1_.ts_inscripcion AS ts_inscripcion_10, e1_.estado_inscripcion AS estado_inscripcion_11, e1_.ts_cambio AS ts_cambio_12, e1_.cod_curriculum_al_inscribir AS cod_curriculum_al_inscribir_13, e1_.ppa_al_inscribir AS ppa_al_inscribir_14, e1_.observacion_estado AS observacion_estado_15, e1_.aceptacion_condicional AS aceptacion_condicional_16, e1_.fecha_impresion AS fecha_impresion_17, e1_.num_inscripcion AS num_inscripcion_18, e2_.id AS id_19, e2_.rut AS rut_20, e2_.nombre AS nombre_21, e2_.apellido_pat AS apellido_pat_22, e2_.apellido_mat AS apellido_mat_23, e2_.nro_alumno AS nro_alumno_24, e2_.sexo AS sexo_25, e2_.fecha_nacimiento AS fecha_nacimiento_26, e2_.login AS login_27, e2_.situacion_academica AS situacion_academica_28, e2_.dv AS dv_29, e2_.is_piane AS is_piane_30, e3_.id AS id_31, e3_.nombre_legible AS nombre_legible_32, e3_.porcentaje_min_aprobacion AS porcentaje_min_aprobacion_33, e3_.porcentaje_min_distincion AS porcentaje_min_distincion_34, e3_.formato_nota_final AS formato_nota_final_35, e0_.examen_inscripcion_id AS examen_inscripcion_id_36, e1_.instancia_variante_id AS instancia_variante_id_37, e1_.estudiante_id AS estudiante_id_38, e1_.asiento_id AS asiento_id_39, e3_.instancia_examen_id AS instancia_examen_id_40, e3_.variante_id AS variante_id_41 FROM examen_resultado e0_ INNER JOIN examen_inscripcion e1_ ON e0_.examen_inscripcion_id = e1_.id INNER JOIN estudiante e2_ ON e1_.estudiante_id = e2_.id INNER JOIN examen_config_instancia_variante e3_ ON e1_.instancia_variante_id = e3_.id INNER JOIN examen_config_instancia_examen e4_ ON e3_.instancia_examen_id = e4_.id WHERE e4_.id = 1 AND e0_.vigente = 1 AND e0_.tipo_resultado = 'final' ORDER BY e2_.rut ASC, e1_.num_inscripcion ASC;

SELECT
  t0.id AS id_1,
  t0.nombre_indicador AS nombre_indicador_2,
  t0.comentario AS comentario_3,
  t0.orden AS orden_4,
  t0.topico_id AS topico_id_5
FROM
  indicador t0
WHERE
  t0.topico_id = ?

SELECT t0.id AS id_1, t0.nombre_indicador AS nombre_indicador_2, t0.comentario AS comentario_3, t0.orden AS orden_4, t0.topico_id AS topico_id_5 FROM indicador t0 WHERE t0.topico_id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre_modulo AS nombre_modulo_2,
  t0.fecha_creacion AS fecha_creacion_3,
  t0.orden AS orden_4
FROM
  modulo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_modulo AS nombre_modulo_2, t0.fecha_creacion AS fecha_creacion_3, t0.orden AS orden_4 FROM modulo t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre_topico AS nombre_topico_2,
  t0.fecha_creacion AS fecha_creacion_3,
  t0.comentario AS comentario_4,
  t0.orden AS orden_5,
  t0.curso AS curso_6,
  t0.modulo_id AS modulo_id_7
FROM
  topico t0
  INNER JOIN examen_config_instancia_variante_topico ON t0.id = examen_config_instancia_variante_topico.topico_id
WHERE
  examen_config_instancia_variante_topico.examen_config_instancia_variante_id = ?

SELECT t0.id AS id_1, t0.nombre_topico AS nombre_topico_2, t0.fecha_creacion AS fecha_creacion_3, t0.comentario AS comentario_4, t0.orden AS orden_5, t0.curso AS curso_6, t0.modulo_id AS modulo_id_7 FROM topico t0 INNER JOIN examen_config_instancia_variante_topico ON t0.id = examen_config_instancia_variante_topico.topico_id WHERE examen_config_instancia_variante_topico.examen_config_instancia_variante_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.deactivated_notifications AS deactivated_notifications_5,
  t0.sex AS sex_6,
  t0.rut AS rut_7,
  t0.name AS name_8,
  t0.last_name AS last_name_9,
  t0.phone AS phone_10,
  t0.picture AS picture_11
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.deactivated_notifications AS deactivated_notifications_5, t0.sex AS sex_6, t0.rut AS rut_7, t0.name AS name_8, t0.last_name AS last_name_9, t0.phone AS phone_10, t0.picture AS picture_11 FROM `user` t0 WHERE t0.id = 32;

SELECT
  t0.id AS id_1,
  t0.cuerpo_pregunta AS cuerpo_pregunta_2,
  t0.dificultad_esperada AS dificultad_esperada_3,
  t0.tiempo_estimado_desarrollo AS tiempo_estimado_desarrollo_4,
  t0.informacion_adicional AS informacion_adicional_5,
  t0.estado AS estado_6,
  t0.codigo_creacion AS codigo_creacion_7,
  t0.fecha_creacion AS fecha_creacion_8,
  t0.orden AS orden_9,
  t0.archivo_id AS archivo_id_10,
  t11.id AS id_12,
  t11.dificultad_solicitada AS dificultad_solicitada_13,
  t11.tiempo_estimado_solicitado AS tiempo_estimado_solicitado_14,
  t11.informacion_adicional AS informacion_adicional_15,
  t11.ts_estado AS ts_estado_16,
  t11.estado_actual AS estado_actual_17,
  t11.pregunta_creada_id AS pregunta_creada_id_18,
  t11.constructor_asignado_id AS constructor_asignado_id_19,
  t11.indicador_id AS indicador_id_20,
  t0.indicador_id AS indicador_id_21,
  t0.instancia_examen_id AS instancia_examen_id_22
FROM
  pregunta t0
  LEFT JOIN pregunta_elaboracion t11 ON t11.pregunta_creada_id = t0.id
WHERE
  t0.instancia_examen_id = ?

SELECT t0.id AS id_1, t0.cuerpo_pregunta AS cuerpo_pregunta_2, t0.dificultad_esperada AS dificultad_esperada_3, t0.tiempo_estimado_desarrollo AS tiempo_estimado_desarrollo_4, t0.informacion_adicional AS informacion_adicional_5, t0.estado AS estado_6, t0.codigo_creacion AS codigo_creacion_7, t0.fecha_creacion AS fecha_creacion_8, t0.orden AS orden_9, t0.archivo_id AS archivo_id_10, t11.id AS id_12, t11.dificultad_solicitada AS dificultad_solicitada_13, t11.tiempo_estimado_solicitado AS tiempo_estimado_solicitado_14, t11.informacion_adicional AS informacion_adicional_15, t11.ts_estado AS ts_estado_16, t11.estado_actual AS estado_actual_17, t11.pregunta_creada_id AS pregunta_creada_id_18, t11.constructor_asignado_id AS constructor_asignado_id_19, t11.indicador_id AS indicador_id_20, t0.indicador_id AS indicador_id_21, t0.instancia_examen_id AS instancia_examen_id_22 FROM pregunta t0 LEFT JOIN pregunta_elaboracion t11 ON t11.pregunta_creada_id = t0.id WHERE t0.instancia_examen_id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre_legible AS nombre_legible_2,
  t0.porcentaje_min_aprobacion AS porcentaje_min_aprobacion_3,
  t0.porcentaje_min_distincion AS porcentaje_min_distincion_4,
  t0.formato_nota_final AS formato_nota_final_5,
  t0.instancia_examen_id AS instancia_examen_id_6,
  t0.variante_id AS variante_id_7
FROM
  examen_config_instancia_variante t0
WHERE
  t0.instancia_examen_id = ?

SELECT t0.id AS id_1, t0.nombre_legible AS nombre_legible_2, t0.porcentaje_min_aprobacion AS porcentaje_min_aprobacion_3, t0.porcentaje_min_distincion AS porcentaje_min_distincion_4, t0.formato_nota_final AS formato_nota_final_5, t0.instancia_examen_id AS instancia_examen_id_6, t0.variante_id AS variante_id_7 FROM examen_config_instancia_variante t0 WHERE t0.instancia_examen_id = 1;

SELECT
  t0.id AS id_1,
  t0.id_instrumento AS id_instrumento_2,
  t0.periodo AS periodo_3,
  t0.cardinalidad AS cardinalidad_4,
  t0.nombre_legible AS nombre_legible_5,
  t0.permite_apelacion AS permite_apelacion_6
FROM
  examen_config_instancia_examen t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_instrumento AS id_instrumento_2, t0.periodo AS periodo_3, t0.cardinalidad AS cardinalidad_4, t0.nombre_legible AS nombre_legible_5, t0.permite_apelacion AS permite_apelacion_6 FROM examen_config_instancia_examen t0 WHERE t0.id = '1';