Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

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

[
  "2026-10-27 12:10:37"
  "2024-10-27 12:10:37"
  "%roads%"
]

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 12:10:37')) AND o0_.last_activity_date >= '2024-10-27 12:10:37' AND LOWER(k3_.keyword) LIKE LOWER('%roads%') 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

[]

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 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.course_number AS course_number_2 FROM prerequisite 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.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.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.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.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.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.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.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.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.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;