Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 14
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Workflow
• Notifications
• Serializer
• Vite
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.duration AS duration_5, s0_.program AS program_6, s0_.goal AS goal_7, s0_.status AS status_8, s0_.admin_comment AS admin_comment_9, s0_.created_at AS created_at_10, s0_.type AS type_11, s0_.nac_skills AS nac_skills_12, s0_.processed_at AS processed_at_13, s0_.grid_id AS grid_id_14, s0_.requested_by_id AS requested_by_id_15 FROM situation_request s0_ WHERE s0_.status = ? AND s0_.type = ? ORDER BY s0_.created_at DESC

[
  "pending"
  "situation"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.start_date AS start_date_3,
  s0_.end_date AS end_date_4,
  s0_.duration AS duration_5,
  s0_.program AS program_6,
  s0_.goal AS goal_7,
  s0_.status AS status_8,
  s0_.admin_comment AS admin_comment_9,
  s0_.created_at AS created_at_10,
  s0_.type AS type_11,
  s0_.nac_skills AS nac_skills_12,
  s0_.processed_at AS processed_at_13,
  s0_.grid_id AS grid_id_14,
  s0_.requested_by_id AS requested_by_id_15
FROM
  situation_request s0_
WHERE
  s0_.status = ?
  AND s0_.type = ?
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.duration AS duration_5, s0_.program AS program_6, s0_.goal AS goal_7, s0_.status AS status_8, s0_.admin_comment AS admin_comment_9, s0_.created_at AS created_at_10, s0_.type AS type_11, s0_.nac_skills AS nac_skills_12, s0_.processed_at AS processed_at_13, s0_.grid_id AS grid_id_14, s0_.requested_by_id AS requested_by_id_15 FROM situation_request s0_ WHERE s0_.status = 'pending' AND s0_.type = 'situation' ORDER BY s0_.created_at DESC;

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.duration AS duration_5, s0_.program AS program_6, s0_.goal AS goal_7, s0_.status AS status_8, s0_.admin_comment AS admin_comment_9, s0_.created_at AS created_at_10, s0_.type AS type_11, s0_.nac_skills AS nac_skills_12, s0_.processed_at AS processed_at_13, s0_.grid_id AS grid_id_14, s0_.requested_by_id AS requested_by_id_15 FROM situation_request s0_ WHERE s0_.status <> ? AND s0_.type = ? ORDER BY s0_.processed_at DESC LIMIT 50

[
  "pending"
  "situation"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.description AS description_2,
  s0_.start_date AS start_date_3,
  s0_.end_date AS end_date_4,
  s0_.duration AS duration_5,
  s0_.program AS program_6,
  s0_.goal AS goal_7,
  s0_.status AS status_8,
  s0_.admin_comment AS admin_comment_9,
  s0_.created_at AS created_at_10,
  s0_.type AS type_11,
  s0_.nac_skills AS nac_skills_12,
  s0_.processed_at AS processed_at_13,
  s0_.grid_id AS grid_id_14,
  s0_.requested_by_id AS requested_by_id_15
FROM
  situation_request s0_
WHERE
  s0_.status <> ?
  AND s0_.type = ?
ORDER BY
  s0_.processed_at DESC
LIMIT
  50

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.start_date AS start_date_3, s0_.end_date AS end_date_4, s0_.duration AS duration_5, s0_.program AS program_6, s0_.goal AS goal_7, s0_.status AS status_8, s0_.admin_comment AS admin_comment_9, s0_.created_at AS created_at_10, s0_.type AS type_11, s0_.nac_skills AS nac_skills_12, s0_.processed_at AS processed_at_13, s0_.grid_id AS grid_id_14, s0_.requested_by_id AS requested_by_id_15 FROM situation_request s0_ WHERE s0_.status <> 'pending' AND s0_.type = 'situation' ORDER BY s0_.processed_at DESC LIMIT 50;

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1

[
  "admin_situation_request_index"
  1
]

SELECT
  t0.id AS id_1,
  t0.route_name AS route_name_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  page_help t0
WHERE
  t0.route_name = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = 'admin_situation_request_index' AND t0.enabled = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.referential_id AS referential_id_3, t0.promotion_id AS promotion_id_4 FROM grid t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.referential_id AS referential_id_3,
  t0.promotion_id AS promotion_id_4
FROM
  grid t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.referential_id AS referential_id_3, t0.promotion_id AS promotion_id_4 FROM grid t0 WHERE t0.id = 5;

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM professor t0 WHERE t0.id = ?

[
  13
]

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.user_id AS user_id_4
FROM
  professor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM professor t0 WHERE t0.id = 13;

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM professor t0 WHERE t0.id = ?

[
  14
]

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.user_id AS user_id_4
FROM
  professor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.user_id AS user_id_4 FROM professor t0 WHERE t0.id = 14;