Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 113
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.branch AS branch_7, t0.is_sso AS is_sso_8, t0.societe AS societe_9, t0.code_branche AS code_branche_10, t0.code_regate AS code_regate_11, t0.poste_vlpuser AS poste_vlpuser_12, t0.poste_vlp_site AS poste_vlp_site_13, t0.deleted_at AS deleted_at_14, t0.reset_token AS reset_token_15, t0.password_requested_at AS password_requested_at_16, t0.code AS code_17, t0.push_notification_enabled AS push_notification_enabled_18, t0.email_notification_enabled AS email_notification_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.status_id AS status_id_22, t0.default_site_id AS default_site_id_23 FROM user t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.branch AS branch_7,
  t0.is_sso AS is_sso_8,
  t0.societe AS societe_9,
  t0.code_branche AS code_branche_10,
  t0.code_regate AS code_regate_11,
  t0.poste_vlpuser AS poste_vlpuser_12,
  t0.poste_vlp_site AS poste_vlp_site_13,
  t0.deleted_at AS deleted_at_14,
  t0.reset_token AS reset_token_15,
  t0.password_requested_at AS password_requested_at_16,
  t0.code AS code_17,
  t0.push_notification_enabled AS push_notification_enabled_18,
  t0.email_notification_enabled AS email_notification_enabled_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.status_id AS status_id_22,
  t0.default_site_id AS default_site_id_23
FROM
  user t0
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.branch AS branch_7, t0.is_sso AS is_sso_8, t0.societe AS societe_9, t0.code_branche AS code_branche_10, t0.code_regate AS code_regate_11, t0.poste_vlpuser AS poste_vlpuser_12, t0.poste_vlp_site AS poste_vlp_site_13, t0.deleted_at AS deleted_at_14, t0.reset_token AS reset_token_15, t0.password_requested_at AS password_requested_at_16, t0.code AS code_17, t0.push_notification_enabled AS push_notification_enabled_18, t0.email_notification_enabled AS email_notification_enabled_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.status_id AS status_id_22, t0.default_site_id AS default_site_id_23 FROM user t0 WHERE t0.id = 3;

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.value AS value_2, u0_.text_color AS text_color_3, u0_.bg_color AS bg_color_4, u0_.priority AS priority_5, u0_.deleted_at AS deleted_at_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8 FROM user_status u0_ WHERE u0_.deleted_at IS NULL

[]

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.value AS value_2,
  u0_.text_color AS text_color_3,
  u0_.bg_color AS bg_color_4,
  u0_.priority AS priority_5,
  u0_.deleted_at AS deleted_at_6,
  u0_.created_at AS created_at_7,
  u0_.updated_at AS updated_at_8
FROM
  user_status u0_
WHERE
  u0_.deleted_at IS NULL

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.value AS value_2, u0_.text_color AS text_color_3, u0_.bg_color AS bg_color_4, u0_.priority AS priority_5, u0_.deleted_at AS deleted_at_6, u0_.created_at AS created_at_7, u0_.updated_at AS updated_at_8 FROM user_status u0_ WHERE u0_.deleted_at IS NULL;

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL

[]

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id
WHERE
  u0_.deleted_at IS NULL

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL;

SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL ORDER BY u0_.id DESC LIMIT 20

[]

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.id AS id_1
FROM
  user u0_
  LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id
WHERE
  u0_.deleted_at IS NULL
ORDER BY
  u0_.id DESC
LIMIT
  20

SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL ORDER BY u0_.id DESC LIMIT 20;

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u1_.name AS name_5, u1_.bg_color AS bg_color_6, u1_.text_color AS text_color_7 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC

[
  35
  32
  31
  30
  29
  26
  25
  24
  23
  22
  21
  20
  19
  18
  17
  16
  15
  14
  13
  12
]

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.email AS email_3,
  u0_.roles AS roles_4,
  u1_.name AS name_5,
  u1_.bg_color AS bg_color_6,
  u1_.text_color AS text_color_7
FROM
  user u0_
  LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id
WHERE
  u0_.deleted_at IS NULL
  AND u0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  u0_.id DESC

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.email AS email_3, u0_.roles AS roles_4, u1_.name AS name_5, u1_.bg_color AS bg_color_6, u1_.text_color AS text_color_7 FROM user u0_ LEFT JOIN user_status u1_ ON u0_.status_id = u1_.id WHERE u0_.deleted_at IS NULL AND u0_.id IN (35, 32, 31, 30, 29, 26, 25, 24, 23, 22, 21, 20, 19, 18, 17, 16, 15, 14, 13, 12) ORDER BY u0_.id DESC;

SELECT MIN(YEAR(e0_.date_to)) AS sclr_0, YEAR(CURRENT_DATE) AS sclr_1 FROM event e0_

[]

SELECT
  MIN(
    YEAR(e0_.date_to)
  ) AS sclr_0,
  YEAR(CURRENT_DATE) AS sclr_1
FROM
  event e0_

SELECT MIN(YEAR(e0_.date_to)) AS sclr_0, YEAR(CURRENT_DATE) AS sclr_1 FROM event e0_;

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, MONTH(e0_.date_to) AS sclr_4, YEAR(e0_.date_to) AS sclr_5 FROM event e0_ LEFT JOIN event_type e1_ ON e0_.event_type_id = e1_.id LEFT JOIN category c2_ ON e0_.category_id = c2_.id WHERE e0_.deleted_at IS NULL AND e0_.date_to < ? ORDER BY e0_.date_to ASC

[
  "2026-11-03 18:37:13"
]

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.date_from AS date_from_2,
  e0_.date_to AS date_to_3,
  MONTH(e0_.date_to) AS sclr_4,
  YEAR(e0_.date_to) AS sclr_5
FROM
  event e0_
  LEFT JOIN event_type e1_ ON e0_.event_type_id = e1_.id
  LEFT JOIN category c2_ ON e0_.category_id = c2_.id
WHERE
  e0_.deleted_at IS NULL
  AND e0_.date_to < ?
ORDER BY
  e0_.date_to ASC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.date_from AS date_from_2, e0_.date_to AS date_to_3, MONTH(e0_.date_to) AS sclr_4, YEAR(e0_.date_to) AS sclr_5 FROM event e0_ LEFT JOIN event_type e1_ ON e0_.event_type_id = e1_.id LEFT JOIN category c2_ ON e0_.category_id = c2_.id WHERE e0_.deleted_at IS NULL AND e0_.date_to < '2026-11-03 18:37:13' ORDER BY e0_.date_to ASC;