Symfony Profiler

SELECT
  DISTINCT count(DISTINCT f0_.rut) AS sclr_0
FROM
  faculty f0_
  LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
  LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut
  LEFT JOIN department d3_ ON f2_.department_id = d3_.id
  LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut
  LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id
  LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
  LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id

SELECT DISTINCT count(DISTINCT f0_.rut) AS sclr_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id;

SELECT
  DISTINCT f0_.rut AS rut_0
FROM
  faculty f0_
  LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
  LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut
  LEFT JOIN department d3_ ON f2_.department_id = d3_.id
  LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut
  LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id
  LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
  LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id
LIMIT
  10
OFFSET
  200

SELECT DISTINCT f0_.rut AS rut_0 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f2_ ON f0_.rut = f2_.faculty_rut LEFT JOIN department d3_ ON f2_.department_id = d3_.id LEFT JOIN faculty_research_area f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN research_area r4_ ON r4_.id = f5_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r6_ ON r6_.id = f7_.research_line_id LIMIT 10 OFFSET 200;

SELECT
  DISTINCT 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,
  u1_.id AS id_6,
  u1_.email AS email_7,
  u1_.roles AS roles_8,
  u1_.password AS password_9,
  u1_.deactivated_notifications AS deactivated_notifications_10,
  u1_.sex AS sex_11,
  u1_.rut AS rut_12,
  u1_.name AS name_13,
  u1_.last_name AS last_name_14,
  u1_.phone AS phone_15,
  u1_.picture AS picture_16,
  u1_.reset_token AS reset_token_17,
  u1_.reset_token_expires_at AS reset_token_expires_at_18,
  d2_.id AS id_19,
  d2_.department AS department_20,
  d2_.english_name AS english_name_21,
  r3_.id AS id_22,
  r3_.area AS area_23,
  r3_.english_name AS english_name_24,
  r3_.cod_param_77_vig AS cod_param_77_vig_25,
  r4_.id AS id_26,
  r4_.line AS line_27,
  r4_.english_name AS english_name_28,
  r4_.description AS description_29,
  f0_.user_id AS user_id_30,
  f5_.faculty_rut AS faculty_rut_31,
  f5_.position_id AS position_id_32,
  f5_.department_id AS department_id_33,
  r3_.cod_curriculum AS cod_curriculum_34,
  r4_.area_id AS area_id_35,
  r4_.department_id AS department_id_36
FROM
  faculty f0_
  LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id
  LEFT JOIN faculty_assignment f5_ ON f0_.rut = f5_.faculty_rut
  LEFT JOIN department d2_ ON f5_.department_id = d2_.id
  LEFT JOIN faculty_research_area f6_ ON f0_.rut = f6_.faculty_rut
  LEFT JOIN research_area r3_ ON r3_.id = f6_.research_area_id
  LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut
  LEFT JOIN research_line r4_ ON r4_.id = f7_.research_line_id
WHERE
  f0_.rut IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT DISTINCT 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, u1_.id AS id_6, u1_.email AS email_7, u1_.roles AS roles_8, u1_.password AS password_9, u1_.deactivated_notifications AS deactivated_notifications_10, u1_.sex AS sex_11, u1_.rut AS rut_12, u1_.name AS name_13, u1_.last_name AS last_name_14, u1_.phone AS phone_15, u1_.picture AS picture_16, u1_.reset_token AS reset_token_17, u1_.reset_token_expires_at AS reset_token_expires_at_18, d2_.id AS id_19, d2_.department AS department_20, d2_.english_name AS english_name_21, r3_.id AS id_22, r3_.area AS area_23, r3_.english_name AS english_name_24, r3_.cod_param_77_vig AS cod_param_77_vig_25, r4_.id AS id_26, r4_.line AS line_27, r4_.english_name AS english_name_28, r4_.description AS description_29, f0_.user_id AS user_id_30, f5_.faculty_rut AS faculty_rut_31, f5_.position_id AS position_id_32, f5_.department_id AS department_id_33, r3_.cod_curriculum AS cod_curriculum_34, r4_.area_id AS area_id_35, r4_.department_id AS department_id_36 FROM faculty f0_ LEFT JOIN `user` u1_ ON f0_.user_id = u1_.id LEFT JOIN faculty_assignment f5_ ON f0_.rut = f5_.faculty_rut LEFT JOIN department d2_ ON f5_.department_id = d2_.id LEFT JOIN faculty_research_area f6_ ON f0_.rut = f6_.faculty_rut LEFT JOIN research_area r3_ ON r3_.id = f6_.research_area_id LEFT JOIN faculty_research_line f7_ ON f0_.rut = f7_.faculty_rut LEFT JOIN research_line r4_ ON r4_.id = f7_.research_line_id WHERE f0_.rut IN (15007098, 15019689, 15313062, 15366510, 15642779, 15731462, 15734832, 15779970, 15783974, 16006283);

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 280;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 281;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 282;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 283;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 284;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 285;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 286;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 287;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 288;

SELECT
  t0.id AS id_1,
  t0.career AS career_2,
  t0.curriculum AS curriculum_3,
  t0.other_university AS other_university_4,
  t0.user_id AS user_id_5,
  t0.cod_pais AS cod_pais_6,
  t0.cod_universidad AS cod_universidad_7
FROM
  applicant t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.career AS career_2, t0.curriculum AS curriculum_3, t0.other_university AS other_university_4, t0.user_id AS user_id_5, t0.cod_pais AS cod_pais_6, t0.cod_universidad AS cod_universidad_7 FROM applicant t0 WHERE t0.user_id = 289;

SELECT
  d0_.id AS id_0,
  d0_.department AS department_1,
  d0_.english_name AS english_name_2
FROM
  department d0_
ORDER BY
  d0_.department ASC

SELECT d0_.id AS id_0, d0_.department AS department_1, d0_.english_name AS english_name_2 FROM department d0_ ORDER BY d0_.department 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_.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
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 41401;

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40201;

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40301;

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 40401;

SELECT
  t0.codCurriculum AS codCurriculum_1,
  t0.nom_curriculum AS nom_curriculum_2
FROM
  cod_curriculum t0
WHERE
  t0.codCurriculum = ?

SELECT t0.codCurriculum AS codCurriculum_1, t0.nom_curriculum AS nom_curriculum_2 FROM cod_curriculum t0 WHERE t0.codCurriculum = 41301;

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
  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;