Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.published_deadline AS published_deadline_1,
  o0_.use_published_deadline AS use_published_deadline_2,
  o0_.creation_date AS creation_date_3,
  o0_.name AS name_4,
  o0_.english_name AS english_name_5,
  o0_.description AS description_6,
  o0_.english_description AS english_description_7,
  o0_.phd_names AS phd_names_8,
  o0_.public AS public_9,
  o0_.credits AS credits_10,
  o0_.modality AS modality_11,
  o0_.vacants AS vacants_12,
  o0_.cmd AS cmd_13,
  o0_.hidden AS hidden_14,
  o0_.rcer AS rcer_15,
  o0_.last_activity_date AS last_activity_date_16,
  SUM(
    CASE WHEN a1_.vacancy_consuming IS NOT NULL
    AND a1_.vacancy_consuming = 1 THEN
      1
    ELSE
      0
    END
  ) AS sclr_17,
  o0_.responsible_mentor_id AS responsible_mentor_id_18,
  o0_.rcer_station_id AS rcer_station_id_19
FROM
  oportunity_research o0_
  LEFT JOIN application a2_ ON o0_.id = a2_.oportunity_research_id
  LEFT JOIN application_state a1_ ON a2_.state_id = a1_.id
  INNER JOIN oportunity_research_keyword o4_ ON o0_.id = o4_.oportunity_research_id
  INNER JOIN keyword k3_ ON k3_.id = o4_.keyword_id
WHERE
  o0_.hidden = 0
  AND o0_.public = 1
  AND (
    (
      o0_.use_published_deadline = 0
      OR o0_.published_deadline > ?
    )
  )
  AND o0_.last_activity_date >= ?
  AND LOWER(k3_.keyword) LIKE LOWER(?)
GROUP BY
  o0_.id
HAVING
  o0_.vacants - sclr_17 > 0

SELECT o0_.id AS id_0, o0_.published_deadline AS published_deadline_1, o0_.use_published_deadline AS use_published_deadline_2, o0_.creation_date AS creation_date_3, o0_.name AS name_4, o0_.english_name AS english_name_5, o0_.description AS description_6, o0_.english_description AS english_description_7, o0_.phd_names AS phd_names_8, o0_.public AS public_9, o0_.credits AS credits_10, o0_.modality AS modality_11, o0_.vacants AS vacants_12, o0_.cmd AS cmd_13, o0_.hidden AS hidden_14, o0_.rcer AS rcer_15, o0_.last_activity_date AS last_activity_date_16, SUM(CASE WHEN a1_.vacancy_consuming IS NOT NULL AND a1_.vacancy_consuming = 1 THEN 1 ELSE 0 END) AS sclr_17, o0_.responsible_mentor_id AS responsible_mentor_id_18, o0_.rcer_station_id AS rcer_station_id_19 FROM oportunity_research o0_ LEFT JOIN application a2_ ON o0_.id = a2_.oportunity_research_id LEFT JOIN application_state a1_ ON a2_.state_id = a1_.id INNER JOIN oportunity_research_keyword o4_ ON o0_.id = o4_.oportunity_research_id INNER JOIN keyword k3_ ON k3_.id = o4_.keyword_id WHERE o0_.hidden = 0 AND o0_.public = 1 AND ((o0_.use_published_deadline = 0 OR o0_.published_deadline > '2026-10-27 02:52:11')) AND o0_.last_activity_date >= '2024-10-27 02:52:11' AND LOWER(k3_.keyword) LIKE LOWER('%offsite construction%') GROUP BY o0_.id HAVING o0_.vacants - sclr_17 > 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.path AS path_4,
  t0.visible AS visible_5,
  t0.roles AS roles_6,
  t0.downloadable AS downloadable_7
FROM
  information_tab t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.path AS path_4, t0.visible AS visible_5, t0.roles AS roles_6, t0.downloadable AS downloadable_7 FROM information_tab t0;

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.enabled AS enabled_12,
  t13.id AS id_14,
  t13.description AS description_15,
  t13.user_id AS user_id_16,
  t13.affiliation_id AS affiliation_id_17,
  t18.id AS id_19,
  t18.user_id AS user_id_20,
  t18.external_academic_unit_id AS external_academic_unit_id_21,
  t18.enterprise_id AS enterprise_id_22,
  t18.faculty_id AS faculty_id_23,
  t18.affiliation_id AS affiliation_id_24,
  t25.id AS id_26,
  t25.prerequisites AS prerequisites_27,
  t25.user_id AS user_id_28,
  t25.external_academic_unit_id AS external_academic_unit_id_29,
  t25.enterprise_id AS enterprise_id_30,
  t25.faculty_id AS faculty_id_31,
  t25.affiliation_id AS affiliation_id_32,
  t25.major_id AS major_id_33,
  t34.id AS id_35,
  t34.time AS time_36,
  t34.auth AS auth_37,
  t34.user_id AS user_id_38
FROM
  `user` t0
  LEFT JOIN other t13 ON t13.user_id = t0.id
  LEFT JOIN mentor t18 ON t18.user_id = t0.id
  LEFT JOIN student t25 ON t25.user_id = t0.id
  LEFT JOIN restorer t34 ON t34.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.enabled AS enabled_12, t13.id AS id_14, t13.description AS description_15, t13.user_id AS user_id_16, t13.affiliation_id AS affiliation_id_17, t18.id AS id_19, t18.user_id AS user_id_20, t18.external_academic_unit_id AS external_academic_unit_id_21, t18.enterprise_id AS enterprise_id_22, t18.faculty_id AS faculty_id_23, t18.affiliation_id AS affiliation_id_24, t25.id AS id_26, t25.prerequisites AS prerequisites_27, t25.user_id AS user_id_28, t25.external_academic_unit_id AS external_academic_unit_id_29, t25.enterprise_id AS enterprise_id_30, t25.faculty_id AS faculty_id_31, t25.affiliation_id AS affiliation_id_32, t25.major_id AS major_id_33, t34.id AS id_35, t34.time AS time_36, t34.auth AS auth_37, t34.user_id AS user_id_38 FROM `user` t0 LEFT JOIN other t13 ON t13.user_id = t0.id LEFT JOIN mentor t18 ON t18.user_id = t0.id LEFT JOIN student t25 ON t25.user_id = t0.id LEFT JOIN restorer t34 ON t34.user_id = t0.id WHERE t0.id = 5398;

SELECT
  t0.id AS id_1,
  t0.step AS step_2,
  t0.text AS text_3,
  t0.next_step_description AS next_step_description_4,
  t0.deprecated AS deprecated_5,
  t0.vacancy_consuming AS vacancy_consuming_6
FROM
  application_state t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.step AS step_2, t0.text AS text_3, t0.next_step_description AS next_step_description_4, t0.deprecated AS deprecated_5, t0.vacancy_consuming AS vacancy_consuming_6 FROM application_state t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.application_date AS application_date_2,
  t0.last_update_date AS last_update_date_3,
  t0.authorized_by_letter AS authorized_by_letter_4,
  t0.banner_authorization_date AS banner_authorization_date_5,
  t0.comments AS comments_6,
  t0.numbers_code AS numbers_code_7,
  t0.initials_code AS initials_code_8,
  t0.class_name AS class_name_9,
  t0.motivation_letter AS motivation_letter_10,
  t0.student_year AS student_year_11,
  t0.student_id AS student_id_12,
  t0.oportunity_research_id AS oportunity_research_id_13,
  t14.id AS id_15,
  t14.initials_code AS initials_code_16,
  t14.numbers_code AS numbers_code_17,
  t14.semester AS semester_18,
  t14.academic_year AS academic_year_19,
  t14.class_name AS class_name_20,
  t14.section AS section_21,
  t14.creation_date AS creation_date_22,
  t14.creation_date_op AS creation_date_op_23,
  t14.name_op AS name_op_24,
  t14.cmd AS cmd_25,
  t14.credits AS credits_26,
  t14.description_op AS description_op_27,
  t14.modality_op AS modality_op_28,
  t14.phd_names AS phd_names_29,
  t14.nrc AS nrc_30,
  t14.alpha_score AS alpha_score_31,
  t14.numeric_score AS numeric_score_32,
  t14.grade_confirmed AS grade_confirmed_33,
  t14.special_authorization AS special_authorization_34,
  t14.special_authorization_date AS special_authorization_date_35,
  t14.application_id AS application_id_36,
  t14.student_id AS student_id_37,
  t14.oportunity_research_id AS oportunity_research_id_38,
  t14.report_id AS report_id_39,
  t14.responsible_mentor_id AS responsible_mentor_id_40,
  t14.rcer_submission_id AS rcer_submission_id_41,
  t0.state_id AS state_id_42
FROM
  application t0
  LEFT JOIN research t14 ON t14.application_id = t0.id
WHERE
  t0.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.application_date AS application_date_2, t0.last_update_date AS last_update_date_3, t0.authorized_by_letter AS authorized_by_letter_4, t0.banner_authorization_date AS banner_authorization_date_5, t0.comments AS comments_6, t0.numbers_code AS numbers_code_7, t0.initials_code AS initials_code_8, t0.class_name AS class_name_9, t0.motivation_letter AS motivation_letter_10, t0.student_year AS student_year_11, t0.student_id AS student_id_12, t0.oportunity_research_id AS oportunity_research_id_13, t14.id AS id_15, t14.initials_code AS initials_code_16, t14.numbers_code AS numbers_code_17, t14.semester AS semester_18, t14.academic_year AS academic_year_19, t14.class_name AS class_name_20, t14.section AS section_21, t14.creation_date AS creation_date_22, t14.creation_date_op AS creation_date_op_23, t14.name_op AS name_op_24, t14.cmd AS cmd_25, t14.credits AS credits_26, t14.description_op AS description_op_27, t14.modality_op AS modality_op_28, t14.phd_names AS phd_names_29, t14.nrc AS nrc_30, t14.alpha_score AS alpha_score_31, t14.numeric_score AS numeric_score_32, t14.grade_confirmed AS grade_confirmed_33, t14.special_authorization AS special_authorization_34, t14.special_authorization_date AS special_authorization_date_35, t14.application_id AS application_id_36, t14.student_id AS student_id_37, t14.oportunity_research_id AS oportunity_research_id_38, t14.report_id AS report_id_39, t14.responsible_mentor_id AS responsible_mentor_id_40, t14.rcer_submission_id AS rcer_submission_id_41, t0.state_id AS state_id_42 FROM application t0 LEFT JOIN research t14 ON t14.application_id = t0.id WHERE t0.oportunity_research_id = 1622;

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

SELECT t0.id AS id_1, t0.keyword AS keyword_2 FROM keyword t0 INNER JOIN oportunity_research_keyword ON t0.id = oportunity_research_keyword.keyword_id WHERE oportunity_research_keyword.oportunity_research_id = 1622;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.initials_code AS initials_code_3,
  t0.siding_code AS siding_code_4,
  t0.can_create_courses AS can_create_courses_5
FROM
  department t0
  INNER JOIN department_mentor ON t0.id = department_mentor.department_id
WHERE
  department_mentor.mentor_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.initials_code AS initials_code_3, t0.siding_code AS siding_code_4, t0.can_create_courses AS can_create_courses_5 FROM department t0 INNER JOIN department_mentor ON t0.id = department_mentor.department_id WHERE department_mentor.mentor_id = 338;

SELECT
  t0.id AS id_1,
  t0.course_number AS course_number_2
FROM
  prerequisite t0
  INNER JOIN oportunity_research_prerequisite ON t0.id = oportunity_research_prerequisite.prerequisite_id
WHERE
  oportunity_research_prerequisite.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.course_number AS course_number_2 FROM prerequisite t0 INNER JOIN oportunity_research_prerequisite ON t0.id = oportunity_research_prerequisite.prerequisite_id WHERE oportunity_research_prerequisite.oportunity_research_id = 1622;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.external_academic_unit_id AS external_academic_unit_id_3,
  t0.enterprise_id AS enterprise_id_4,
  t0.faculty_id AS faculty_id_5,
  t0.affiliation_id AS affiliation_id_6
FROM
  mentor t0
  INNER JOIN oportunity_research_mentor ON t0.id = oportunity_research_mentor.mentor_id
WHERE
  oportunity_research_mentor.oportunity_research_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.external_academic_unit_id AS external_academic_unit_id_3, t0.enterprise_id AS enterprise_id_4, t0.faculty_id AS faculty_id_5, t0.affiliation_id AS affiliation_id_6 FROM mentor t0 INNER JOIN oportunity_research_mentor ON t0.id = oportunity_research_mentor.mentor_id WHERE oportunity_research_mentor.oportunity_research_id = 1622;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.initials_code AS initials_code_3,
  t0.siding_code AS siding_code_4,
  t0.can_create_courses AS can_create_courses_5
FROM
  department t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.initials_code AS initials_code_3, t0.siding_code AS siding_code_4, t0.can_create_courses AS can_create_courses_5 FROM department t0;

SELECT
  t0.id AS id_1,
  t0.course_number AS course_number_2
FROM
  prerequisite t0

SELECT t0.id AS id_1, t0.course_number AS course_number_2 FROM prerequisite t0;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.external_academic_unit_id AS external_academic_unit_id_3,
  t0.enterprise_id AS enterprise_id_4,
  t0.faculty_id AS faculty_id_5,
  t0.affiliation_id AS affiliation_id_6
FROM
  mentor t0

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.external_academic_unit_id AS external_academic_unit_id_3, t0.enterprise_id AS enterprise_id_4, t0.faculty_id AS faculty_id_5, t0.affiliation_id AS affiliation_id_6 FROM mentor t0;

SELECT
  c0_.id AS id_0,
  c0_.group_number AS group_number_1,
  c0_.initials_code AS initials_code_2,
  c0_.numbers_code AS numbers_code_3,
  c0_.credits AS credits_4,
  c0_.name AS name_5,
  c0_.has_more_than_one_mentor AS has_more_than_one_mentor_6,
  c0_.has_engineer_mentor AS has_engineer_mentor_7,
  c0_.has_uc_non_engineer_mentor AS has_uc_non_engineer_mentor_8,
  c0_.has_mixed_engineer_mentors AS has_mixed_engineer_mentors_9,
  c0_.has_non_uc_mentor AS has_non_uc_mentor_10,
  c0_.has_foreign_mentor AS has_foreign_mentor_11,
  c0_.has_enterprise_mentor AS has_enterprise_mentor_12,
  c0_.cmd AS cmd_13,
  c0_.time AS time_14
FROM
  class_code c0_
WHERE
  (
    c0_.has_more_than_one_mentor = ?
    OR c0_.has_more_than_one_mentor IS NULL
  )
  AND (
    c0_.has_engineer_mentor = ?
    OR c0_.has_engineer_mentor IS NULL
  )
  AND (
    c0_.has_uc_non_engineer_mentor = ?
    OR c0_.has_uc_non_engineer_mentor IS NULL
  )
  AND (
    c0_.has_mixed_engineer_mentors = ?
    OR c0_.has_mixed_engineer_mentors IS NULL
  )
  AND (
    c0_.has_non_uc_mentor = ?
    OR c0_.has_non_uc_mentor IS NULL
  )
  AND (
    c0_.has_foreign_mentor = ?
    OR c0_.has_foreign_mentor IS NULL
  )
  AND (
    c0_.has_enterprise_mentor = ?
    OR c0_.has_enterprise_mentor IS NULL
  )
  AND (
    c0_.cmd = ?
    OR c0_.cmd IS NULL
  )
  AND (
    c0_.credits = ?
    OR c0_.credits IS NULL
  )

SELECT c0_.id AS id_0, c0_.group_number AS group_number_1, c0_.initials_code AS initials_code_2, c0_.numbers_code AS numbers_code_3, c0_.credits AS credits_4, c0_.name AS name_5, c0_.has_more_than_one_mentor AS has_more_than_one_mentor_6, c0_.has_engineer_mentor AS has_engineer_mentor_7, c0_.has_uc_non_engineer_mentor AS has_uc_non_engineer_mentor_8, c0_.has_mixed_engineer_mentors AS has_mixed_engineer_mentors_9, c0_.has_non_uc_mentor AS has_non_uc_mentor_10, c0_.has_foreign_mentor AS has_foreign_mentor_11, c0_.has_enterprise_mentor AS has_enterprise_mentor_12, c0_.cmd AS cmd_13, c0_.time AS time_14 FROM class_code c0_ WHERE (c0_.has_more_than_one_mentor = 1 OR c0_.has_more_than_one_mentor IS NULL) AND (c0_.has_engineer_mentor = 1 OR c0_.has_engineer_mentor IS NULL) AND (c0_.has_uc_non_engineer_mentor = 0 OR c0_.has_uc_non_engineer_mentor IS NULL) AND (c0_.has_mixed_engineer_mentors = 0 OR c0_.has_mixed_engineer_mentors IS NULL) AND (c0_.has_non_uc_mentor = 0 OR c0_.has_non_uc_mentor IS NULL) AND (c0_.has_foreign_mentor = 0 OR c0_.has_foreign_mentor IS NULL) AND (c0_.has_enterprise_mentor = 0 OR c0_.has_enterprise_mentor IS NULL) AND (c0_.cmd = 0 OR c0_.cmd IS NULL) AND (c0_.credits = 10 OR c0_.credits IS NULL);