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 WHERE o0_.hidden = 0 AND o0_.public = 1 AND ((o0_.use_published_deadline = 0 OR o0_.published_deadline > ?)) AND o0_.last_activity_date >= ? GROUP BY o0_.id HAVING o0_.vacants - sclr_17 > 0

[
  "2025-12-06 00:55:44"
  "2023-12-06 00:55:44"
]

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_.public = 1
  AND (
    (
      o0_.use_published_deadline = 0
      OR o0_.published_deadline > ?
    )
  )
  AND o0_.last_activity_date >= ?
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_.public = 1 AND ((o0_.use_published_deadline = 0 OR o0_.published_deadline > '2025-12-06 00:55:44')) AND o0_.last_activity_date >= '2023-12-06 00:55:44' 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.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;