Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.creation_date AS creation_date_2,
  t0.title AS title_3,
  t0.english_title AS english_title_4,
  t0.description AS description_5,
  t0.english_description AS english_description_6,
  t0.total_slots AS total_slots_7,
  t0.picture AS picture_8,
  t0.published_deadline AS published_deadline_9,
  t0.faculty_rut AS faculty_rut_10,
  t0.second_faculty_rut AS second_faculty_rut_11,
  t0.status_id AS status_id_12,
  t0.cod_curriculum_id AS cod_curriculum_id_13,
  t0.created_by_admin_id AS created_by_admin_id_14
FROM
  opportunity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.title AS title_3, t0.english_title AS english_title_4, t0.description AS description_5, t0.english_description AS english_description_6, t0.total_slots AS total_slots_7, t0.picture AS picture_8, t0.published_deadline AS published_deadline_9, t0.faculty_rut AS faculty_rut_10, t0.second_faculty_rut AS second_faculty_rut_11, t0.status_id AS status_id_12, t0.cod_curriculum_id AS cod_curriculum_id_13, t0.created_by_admin_id AS created_by_admin_id_14 FROM opportunity t0 WHERE t0.id = '7';

SELECT
  c0_.CodPais AS CodPais_0,
  c0_.country AS country_1,
  c0_.active AS active_2,
  c0_.cod_a2 AS cod_a2_3
FROM
  country c0_
ORDER BY
  c0_.country ASC

SELECT c0_.CodPais AS CodPais_0, c0_.country AS country_1, c0_.active AS active_2, c0_.cod_a2 AS cod_a2_3 FROM country c0_ ORDER BY c0_.country ASC;

SELECT
  t0.rut AS rut_1,
  t0.status AS status_2,
  t0.post AS post_3,
  t0.biography AS biography_4,
  t0.interest_areas AS interest_areas_5,
  t0.english_interest_areas AS english_interest_areas_6,
  t0.user_id AS user_id_7
FROM
  faculty t0
WHERE
  t0.rut = ?

SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.rut = 5122132;

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

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.rut AS rut_1,
  t0.status AS status_2,
  t0.post AS post_3,
  t0.biography AS biography_4,
  t0.interest_areas AS interest_areas_5,
  t0.english_interest_areas AS english_interest_areas_6,
  t0.user_id AS user_id_7
FROM
  faculty t0
WHERE
  t0.rut = ?

SELECT t0.rut AS rut_1, t0.status AS status_2, t0.post AS post_3, t0.biography AS biography_4, t0.interest_areas AS interest_areas_5, t0.english_interest_areas AS english_interest_areas_6, t0.user_id AS user_id_7 FROM faculty t0 WHERE t0.rut = 10113897;

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

SELECT
  t0.id AS id_1,
  t0.line AS line_2,
  t0.english_name AS english_name_3,
  t0.description AS description_4,
  t0.area_id AS area_id_5,
  t0.department_id AS department_id_6
FROM
  research_line t0
  INNER JOIN opportunity_research_line ON t0.id = opportunity_research_line.research_line_id
WHERE
  opportunity_research_line.opportunity_id = ?

SELECT t0.id AS id_1, t0.line AS line_2, t0.english_name AS english_name_3, t0.description AS description_4, t0.area_id AS area_id_5, t0.department_id AS department_id_6 FROM research_line t0 INNER JOIN opportunity_research_line ON t0.id = opportunity_research_line.research_line_id WHERE opportunity_research_line.opportunity_id = 7;

SELECT
  t0.id AS id_1,
  t0.area AS area_2,
  t0.english_name AS english_name_3,
  t0.cod_param_77_vig AS cod_param_77_vig_4,
  t0.cod_curriculum AS cod_curriculum_5
FROM
  research_area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.area AS area_2, t0.english_name AS english_name_3, t0.cod_param_77_vig AS cod_param_77_vig_4, t0.cod_curriculum AS cod_curriculum_5 FROM research_area t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.keyword AS keyword_2
FROM
  keyword t0
  INNER JOIN opportunity_keyword ON t0.id = opportunity_keyword.keyword_id
WHERE
  opportunity_keyword.opportunity_id = ?

SELECT t0.id AS id_1, t0.keyword AS keyword_2 FROM keyword t0 INNER JOIN opportunity_keyword ON t0.id = opportunity_keyword.keyword_id WHERE opportunity_keyword.opportunity_id = 7;

SELECT
  t0.id AS id_1,
  t0.status AS status_2
FROM
  status t0
WHERE
  t0.id = ?

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