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
WHERE
  o0_.hidden = 0
  AND (
    (
      o0_.use_published_deadline = 0
      OR o0_.published_deadline > ?
    )
  )
  AND o0_.last_activity_date >= ?
  AND (
    EXISTS (
      SELECT
        1 AS sclr_20
      FROM
        oportunity_research o3_
        INNER JOIN oportunity_research_mentor o5_ ON o3_.id = o5_.oportunity_research_id
        INNER JOIN mentor m4_ ON m4_.id = o5_.mentor_id
        INNER JOIN affiliation a6_ ON m4_.affiliation_id = a6_.id
        INNER JOIN department_mentor d8_ ON m4_.id = d8_.mentor_id
        INNER JOIN department d7_ ON d7_.id = d8_.department_id
      WHERE
        o3_.id = o0_.id
        AND a6_.id = ?
        AND LOWER(d7_.initials_code) = 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 WHERE o0_.hidden = 0 AND ((o0_.use_published_deadline = 0 OR o0_.published_deadline > '2026-10-27 02:52:00')) AND o0_.last_activity_date >= '2024-10-27 02:52:00' AND (EXISTS (SELECT 1 AS sclr_20 FROM oportunity_research o3_ INNER JOIN oportunity_research_mentor o5_ ON o3_.id = o5_.oportunity_research_id INNER JOIN mentor m4_ ON m4_.id = o5_.mentor_id INNER JOIN affiliation a6_ ON m4_.affiliation_id = a6_.id INNER JOIN department_mentor d8_ ON m4_.id = d8_.mentor_id INNER JOIN department d7_ ON d7_.id = d8_.department_id WHERE o3_.id = o0_.id AND a6_.id = 1 AND LOWER(d7_.initials_code) = LOWER('ICH'))) GROUP BY o0_.id HAVING o0_.vacants - sclr_17 > 0;

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

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

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 = 0 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);

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

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

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 = 0 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);

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

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

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 = 0 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);

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

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 = 0 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);

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

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

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 = 0 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);

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

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