Symfony Profiler

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,
  t0.reset_token AS reset_token_12,
  t0.reset_token_expires_at AS reset_token_expires_at_13,
  t0.career AS career_14,
  t0.curriculum AS curriculum_15,
  t0.other_university AS other_university_16,
  t17.rut AS rut_18,
  t17.status AS status_19,
  t17.post AS post_20,
  t17.biography AS biography_21,
  t17.interest_areas AS interest_areas_22,
  t17.english_interest_areas AS english_interest_areas_23,
  t17.active AS active_24,
  t17.user_id AS user_id_25,
  t26.id AS id_27,
  t26.career AS career_28,
  t26.curriculum AS curriculum_29,
  t26.other_university AS other_university_30,
  t26.user_id AS user_id_31,
  t26.cod_pais AS cod_pais_32,
  t26.cod_universidad AS cod_universidad_33,
  t0.cod_pais AS cod_pais_34,
  t0.cod_universidad AS cod_universidad_35
FROM
  `user` t0
  LEFT JOIN faculty t17 ON t17.user_id = t0.id
  LEFT JOIN applicant t26 ON t26.user_id = t0.id
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, t0.reset_token AS reset_token_12, t0.reset_token_expires_at AS reset_token_expires_at_13, t0.career AS career_14, t0.curriculum AS curriculum_15, t0.other_university AS other_university_16, t17.rut AS rut_18, t17.status AS status_19, t17.post AS post_20, t17.biography AS biography_21, t17.interest_areas AS interest_areas_22, t17.english_interest_areas AS english_interest_areas_23, t17.active AS active_24, t17.user_id AS user_id_25, t26.id AS id_27, t26.career AS career_28, t26.curriculum AS curriculum_29, t26.other_university AS other_university_30, t26.user_id AS user_id_31, t26.cod_pais AS cod_pais_32, t26.cod_universidad AS cod_universidad_33, t0.cod_pais AS cod_pais_34, t0.cod_universidad AS cod_universidad_35 FROM `user` t0 LEFT JOIN faculty t17 ON t17.user_id = t0.id LEFT JOIN applicant t26 ON t26.user_id = t0.id WHERE t0.id = 254;

SELECT
  r0_.id AS id_0,
  r0_.line AS line_1,
  r0_.english_name AS english_name_2,
  r0_.description AS description_3,
  r0_.active AS active_4,
  r0_.area_id AS area_id_5,
  r0_.department_id AS department_id_6
FROM
  research_line r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.line ASC

SELECT r0_.id AS id_0, r0_.line AS line_1, r0_.english_name AS english_name_2, r0_.description AS description_3, r0_.active AS active_4, r0_.area_id AS area_id_5, r0_.department_id AS department_id_6 FROM research_line r0_ WHERE r0_.active = 1 ORDER BY r0_.line ASC;

SELECT
  f0_.rut AS rut_0,
  f0_.status AS status_1,
  f0_.post AS post_2,
  f0_.biography AS biography_3,
  f0_.interest_areas AS interest_areas_4,
  f0_.english_interest_areas AS english_interest_areas_5,
  f0_.active AS active_6,
  f0_.user_id AS user_id_7
FROM
  faculty f0_
  INNER JOIN `user` u1_ ON f0_.user_id = u1_.id
WHERE
  f0_.active = 1
ORDER BY
  u1_.name ASC

SELECT f0_.rut AS rut_0, f0_.status AS status_1, f0_.post AS post_2, f0_.biography AS biography_3, f0_.interest_areas AS interest_areas_4, f0_.english_interest_areas AS english_interest_areas_5, f0_.active AS active_6, f0_.user_id AS user_id_7 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id WHERE f0_.active = 1 ORDER BY u1_.name ASC;

SELECT
  o0_.id AS id_0,
  o0_.creation_date AS creation_date_1,
  o0_.title AS title_2,
  o0_.english_title AS english_title_3,
  o0_.description AS description_4,
  o0_.english_description AS english_description_5,
  o0_.total_slots AS total_slots_6,
  o0_.picture AS picture_7,
  o0_.published_deadline AS published_deadline_8,
  f1_.rut AS rut_9,
  f1_.status AS status_10,
  f1_.post AS post_11,
  f1_.biography AS biography_12,
  f1_.interest_areas AS interest_areas_13,
  f1_.english_interest_areas AS english_interest_areas_14,
  f1_.active AS active_15,
  r2_.id AS id_16,
  r2_.line AS line_17,
  r2_.english_name AS english_name_18,
  r2_.description AS description_19,
  r2_.active AS active_20,
  r3_.id AS id_21,
  r3_.area AS area_22,
  r3_.english_name AS english_name_23,
  r3_.cod_param_77_vig AS cod_param_77_vig_24,
  r3_.active AS active_25,
  c4_.codCurriculum AS codCurriculum_26,
  c4_.nom_curriculum AS nom_curriculum_27,
  c4_.active AS active_28,
  k5_.id AS id_29,
  k5_.keyword AS keyword_30,
  s6_.id AS id_31,
  s6_.status AS status_32,
  o0_.faculty_rut AS faculty_rut_33,
  o0_.second_faculty_rut AS second_faculty_rut_34,
  o0_.status_id AS status_id_35,
  o0_.cod_curriculum_id AS cod_curriculum_id_36,
  o0_.created_by_admin_id AS created_by_admin_id_37,
  f1_.user_id AS user_id_38,
  r2_.area_id AS area_id_39,
  r2_.department_id AS department_id_40,
  r3_.cod_curriculum AS cod_curriculum_41
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o7_.research_line_id
  LEFT JOIN research_area r3_ ON r2_.area_id = r3_.id
  LEFT JOIN cod_curriculum c4_ ON r3_.cod_curriculum = c4_.codCurriculum
  LEFT JOIN opportunity_keyword o8_ ON o0_.id = o8_.opportunity_id
  LEFT JOIN keyword k5_ ON k5_.id = o8_.keyword_id
  LEFT JOIN status s6_ ON o0_.status_id = s6_.id
WHERE
  o0_.status_id IN (?, ?)
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.creation_date DESC

SELECT o0_.id AS id_0, o0_.creation_date AS creation_date_1, o0_.title AS title_2, o0_.english_title AS english_title_3, o0_.description AS description_4, o0_.english_description AS english_description_5, o0_.total_slots AS total_slots_6, o0_.picture AS picture_7, o0_.published_deadline AS published_deadline_8, f1_.rut AS rut_9, f1_.status AS status_10, f1_.post AS post_11, f1_.biography AS biography_12, f1_.interest_areas AS interest_areas_13, f1_.english_interest_areas AS english_interest_areas_14, f1_.active AS active_15, r2_.id AS id_16, r2_.line AS line_17, r2_.english_name AS english_name_18, r2_.description AS description_19, r2_.active AS active_20, r3_.id AS id_21, r3_.area AS area_22, r3_.english_name AS english_name_23, r3_.cod_param_77_vig AS cod_param_77_vig_24, r3_.active AS active_25, c4_.codCurriculum AS codCurriculum_26, c4_.nom_curriculum AS nom_curriculum_27, c4_.active AS active_28, k5_.id AS id_29, k5_.keyword AS keyword_30, s6_.id AS id_31, s6_.status AS status_32, o0_.faculty_rut AS faculty_rut_33, o0_.second_faculty_rut AS second_faculty_rut_34, o0_.status_id AS status_id_35, o0_.cod_curriculum_id AS cod_curriculum_id_36, o0_.created_by_admin_id AS created_by_admin_id_37, f1_.user_id AS user_id_38, r2_.area_id AS area_id_39, r2_.department_id AS department_id_40, r3_.cod_curriculum AS cod_curriculum_41 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o7_.research_line_id LEFT JOIN research_area r3_ ON r2_.area_id = r3_.id LEFT JOIN cod_curriculum c4_ ON r3_.cod_curriculum = c4_.codCurriculum LEFT JOIN opportunity_keyword o8_ ON o0_.id = o8_.opportunity_id LEFT JOIN keyword k5_ ON k5_.id = o8_.keyword_id LEFT JOIN status s6_ ON o0_.status_id = s6_.id WHERE o0_.status_id IN (1, 2) AND o0_.id IN (7, 6, 5, 4, 3, 2, 1) ORDER BY o0_.creation_date DESC;

SELECT
  count(DISTINCT o0_.id) AS sclr_0
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  o0_.status_id IN (?, ?)

SELECT count(DISTINCT o0_.id) AS sclr_0 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE o0_.status_id IN (1, 2);

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.creation_date AS creation_date_1
FROM
  opportunity o0_
  LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut
  LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id
  LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id
  LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id
  LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum
  LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id
  LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id
  LEFT JOIN status s8_ ON o0_.status_id = s8_.id
WHERE
  o0_.status_id IN (?, ?)
ORDER BY
  o0_.creation_date DESC
LIMIT
  9

SELECT DISTINCT o0_.id AS id_0, o0_.creation_date AS creation_date_1 FROM opportunity o0_ LEFT JOIN faculty f1_ ON o0_.faculty_rut = f1_.rut LEFT JOIN opportunity_research_line o3_ ON o0_.id = o3_.opportunity_id LEFT JOIN research_line r2_ ON r2_.id = o3_.research_line_id LEFT JOIN research_area r4_ ON r2_.area_id = r4_.id LEFT JOIN cod_curriculum c5_ ON r4_.cod_curriculum = c5_.codCurriculum LEFT JOIN opportunity_keyword o7_ ON o0_.id = o7_.opportunity_id LEFT JOIN keyword k6_ ON k6_.id = o7_.keyword_id LEFT JOIN status s8_ ON o0_.status_id = s8_.id WHERE o0_.status_id IN (1, 2) ORDER BY o0_.creation_date DESC LIMIT 9;

SELECT
  s0_.id AS id_0,
  s0_.status AS status_1
FROM
  status s0_
WHERE
  s0_.status IN (?, ?)
ORDER BY
  s0_.status ASC

SELECT s0_.id AS id_0, s0_.status AS status_1 FROM status s0_ WHERE s0_.status IN ('Abierta', 'Cerrada') ORDER BY s0_.status ASC;

SELECT
  r0_.id AS id_0,
  r0_.area AS area_1,
  r0_.english_name AS english_name_2,
  r0_.cod_param_77_vig AS cod_param_77_vig_3,
  r0_.active AS active_4,
  r0_.cod_curriculum AS cod_curriculum_5
FROM
  research_area r0_
WHERE
  r0_.active = 1
ORDER BY
  r0_.area ASC

SELECT r0_.id AS id_0, r0_.area AS area_1, r0_.english_name AS english_name_2, r0_.cod_param_77_vig AS cod_param_77_vig_3, r0_.active AS active_4, r0_.cod_curriculum AS cod_curriculum_5 FROM research_area r0_ WHERE r0_.active = 1 ORDER BY r0_.area ASC;

SELECT
  c0_.codCurriculum AS codCurriculum_0,
  c0_.nom_curriculum AS nom_curriculum_1,
  c0_.active AS active_2
FROM
  cod_curriculum c0_
WHERE
  c0_.active = 1
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1, c0_.active AS active_2 FROM cod_curriculum c0_ WHERE c0_.active = 1 ORDER BY c0_.nom_curriculum ASC;