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,
  t14.rut AS rut_15,
  t14.status AS status_16,
  t14.post AS post_17,
  t14.biography AS biography_18,
  t14.interest_areas AS interest_areas_19,
  t14.english_interest_areas AS english_interest_areas_20,
  t14.user_id AS user_id_21,
  t22.id AS id_23,
  t22.career AS career_24,
  t22.curriculum AS curriculum_25,
  t22.other_university AS other_university_26,
  t22.user_id AS user_id_27,
  t22.cod_pais AS cod_pais_28,
  t22.cod_universidad AS cod_universidad_29
FROM
  `user` t0
  LEFT JOIN faculty t14 ON t14.user_id = t0.id
  LEFT JOIN applicant t22 ON t22.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, t14.rut AS rut_15, t14.status AS status_16, t14.post AS post_17, t14.biography AS biography_18, t14.interest_areas AS interest_areas_19, t14.english_interest_areas AS english_interest_areas_20, t14.user_id AS user_id_21, t22.id AS id_23, t22.career AS career_24, t22.curriculum AS curriculum_25, t22.other_university AS other_university_26, t22.user_id AS user_id_27, t22.cod_pais AS cod_pais_28, t22.cod_universidad AS cod_universidad_29 FROM `user` t0 LEFT JOIN faculty t14 ON t14.user_id = t0.id LEFT JOIN applicant t22 ON t22.user_id = t0.id WHERE t0.id = 254;

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_.user_id AS user_id_6
FROM
  faculty f0_
  INNER JOIN `user` u1_ ON f0_.user_id = u1_.id
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_.user_id AS user_id_6 FROM faculty f0_ INNER JOIN `user` u1_ ON f0_.user_id = u1_.id 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,
  r2_.id AS id_15,
  r2_.line AS line_16,
  r2_.english_name AS english_name_17,
  r2_.description AS description_18,
  r3_.id AS id_19,
  r3_.area AS area_20,
  r3_.english_name AS english_name_21,
  r3_.cod_param_77_vig AS cod_param_77_vig_22,
  c4_.codCurriculum AS codCurriculum_23,
  c4_.nom_curriculum AS nom_curriculum_24,
  k5_.id AS id_25,
  k5_.keyword AS keyword_26,
  s6_.id AS id_27,
  s6_.status AS status_28,
  o0_.faculty_rut AS faculty_rut_29,
  o0_.second_faculty_rut AS second_faculty_rut_30,
  o0_.status_id AS status_id_31,
  o0_.cod_curriculum_id AS cod_curriculum_id_32,
  o0_.created_by_admin_id AS created_by_admin_id_33,
  f1_.user_id AS user_id_34,
  r2_.area_id AS area_id_35,
  r2_.department_id AS department_id_36,
  r3_.cod_curriculum AS cod_curriculum_37
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, r2_.id AS id_15, r2_.line AS line_16, r2_.english_name AS english_name_17, r2_.description AS description_18, r3_.id AS id_19, r3_.area AS area_20, r3_.english_name AS english_name_21, r3_.cod_param_77_vig AS cod_param_77_vig_22, c4_.codCurriculum AS codCurriculum_23, c4_.nom_curriculum AS nom_curriculum_24, k5_.id AS id_25, k5_.keyword AS keyword_26, s6_.id AS id_27, s6_.status AS status_28, o0_.faculty_rut AS faculty_rut_29, o0_.second_faculty_rut AS second_faculty_rut_30, o0_.status_id AS status_id_31, o0_.cod_curriculum_id AS cod_curriculum_id_32, o0_.created_by_admin_id AS created_by_admin_id_33, f1_.user_id AS user_id_34, r2_.area_id AS area_id_35, r2_.department_id AS department_id_36, r3_.cod_curriculum AS cod_curriculum_37 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
  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_.cod_curriculum AS cod_curriculum_4
FROM
  research_area r0_
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_.cod_curriculum AS cod_curriculum_4 FROM research_area r0_ ORDER BY r0_.area 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_.area_id AS area_id_4,
  r0_.department_id AS department_id_5
FROM
  research_line r0_
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_.area_id AS area_id_4, r0_.department_id AS department_id_5 FROM research_line r0_ ORDER BY r0_.line ASC;

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
  c0_.codCurriculum AS codCurriculum_0,
  c0_.nom_curriculum AS nom_curriculum_1
FROM
  cod_curriculum c0_
ORDER BY
  c0_.nom_curriculum ASC

SELECT c0_.codCurriculum AS codCurriculum_0, c0_.nom_curriculum AS nom_curriculum_1 FROM cod_curriculum c0_ ORDER BY c0_.nom_curriculum ASC;

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
  t0.id AS id_1,
  t0.status AS status_2
FROM
  status t0
WHERE
  t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.status AS status_2 FROM status t0 WHERE t0.status = 'Abierta' LIMIT 1;