Symfony Profiler

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
  count(DISTINCT e0_.id) AS sclr_0
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
  LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id
  LEFT JOIN site s3_ ON s3_.id = e4_.site_id
  LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id
  LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id
  LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id
WHERE
  e0_.deleted_at IS NULL
  AND YEAR(e0_.date_to) = ?
  AND e0_.date_to >= ?
  AND (
    MONTH(e0_.date_from) >= ?
    AND MONTH(e0_.date_from) <= ?
  )
GROUP BY
  e0_.id

SELECT count(DISTINCT e0_.id) AS sclr_0 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 LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id LEFT JOIN site s3_ ON s3_.id = e4_.site_id LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id WHERE e0_.deleted_at IS NULL AND YEAR(e0_.date_to) = '2026' AND e0_.date_to >= '2026-11-03 18:41:12' AND (MONTH(e0_.date_from) >= '11' AND MONTH(e0_.date_from) <= '11') GROUP BY e0_.id;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.id AS id_1
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
  LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id
  LEFT JOIN site s3_ ON s3_.id = e4_.site_id
  LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id
  LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id
  LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id
WHERE
  e0_.deleted_at IS NULL
  AND YEAR(e0_.date_to) = ?
  AND e0_.date_to >= ?
  AND (
    MONTH(e0_.date_from) >= ?
    AND MONTH(e0_.date_from) <= ?
  )
GROUP BY
  e0_.id
ORDER BY
  e0_.id DESC
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 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 LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id LEFT JOIN site s3_ ON s3_.id = e4_.site_id LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id WHERE e0_.deleted_at IS NULL AND YEAR(e0_.date_to) = '2026' AND e0_.date_to >= '2026-11-03 18:41:12' AND (MONTH(e0_.date_from) >= '11' AND MONTH(e0_.date_from) <= '11') GROUP BY e0_.id ORDER BY e0_.id DESC LIMIT 20;

SELECT
  e0_.id AS id_0,
  e0_.title AS title_1,
  e0_.description AS description_2,
  e0_.is_publish AS is_publish_3,
  e1_.name AS name_4,
  c2_.name AS name_5,
  e0_.date_from AS date_from_6,
  e0_.date_to AS date_to_7,
  GROUP_CONCAT(DISTINCT s3_.name) AS sclr_8,
  GROUP_CONCAT(DISTINCT p4_.name) AS sclr_9,
  u5_.id AS id_10
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
  LEFT JOIN event_site e6_ ON e0_.id = e6_.event_id
  LEFT JOIN site s3_ ON s3_.id = e6_.site_id
  LEFT JOIN event_profile e7_ ON e0_.id = e7_.event_id
  LEFT JOIN profile p4_ ON p4_.id = e7_.profile_id
  LEFT JOIN user u5_ ON e0_.created_by_id = u5_.id
WHERE
  e0_.deleted_at IS NULL
  AND YEAR(e0_.date_to) = ?
  AND e0_.date_to >= ?
  AND (
    MONTH(e0_.date_from) >= ?
    AND MONTH(e0_.date_from) <= ?
  )
  AND e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  e0_.id
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.is_publish AS is_publish_3, e1_.name AS name_4, c2_.name AS name_5, e0_.date_from AS date_from_6, e0_.date_to AS date_to_7, GROUP_CONCAT(DISTINCT s3_.name) AS sclr_8, GROUP_CONCAT(DISTINCT p4_.name) AS sclr_9, u5_.id AS id_10 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 LEFT JOIN event_site e6_ ON e0_.id = e6_.event_id LEFT JOIN site s3_ ON s3_.id = e6_.site_id LEFT JOIN event_profile e7_ ON e0_.id = e7_.event_id LEFT JOIN profile p4_ ON p4_.id = e7_.profile_id LEFT JOIN user u5_ ON e0_.created_by_id = u5_.id WHERE e0_.deleted_at IS NULL AND YEAR(e0_.date_to) = '2026' AND e0_.date_to >= '2026-11-03 18:41:12' AND (MONTH(e0_.date_from) >= '11' AND MONTH(e0_.date_from) <= '11') AND e0_.id IN (62, 61, 60, 59, 58, 57, 56, 55, 54, 53) GROUP BY e0_.id ORDER BY e0_.id DESC;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
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
  LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id
  LEFT JOIN site s3_ ON s3_.id = e4_.site_id
  LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id
  LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id
  LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id
WHERE
  e0_.deleted_at IS NULL
  AND YEAR(e0_.date_to) = ?
  AND (
    MONTH(e0_.date_from) >= ?
    AND MONTH(e0_.date_from) <= ?
  )
GROUP BY
  e0_.id

SELECT count(DISTINCT e0_.id) AS sclr_0 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 LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id LEFT JOIN site s3_ ON s3_.id = e4_.site_id LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id WHERE e0_.deleted_at IS NULL AND YEAR(e0_.date_to) = '2026' AND (MONTH(e0_.date_from) >= '12' AND MONTH(e0_.date_from) <= '12') GROUP BY e0_.id;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.id AS id_1
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
  LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id
  LEFT JOIN site s3_ ON s3_.id = e4_.site_id
  LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id
  LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id
  LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id
WHERE
  e0_.deleted_at IS NULL
  AND YEAR(e0_.date_to) = ?
  AND (
    MONTH(e0_.date_from) >= ?
    AND MONTH(e0_.date_from) <= ?
  )
GROUP BY
  e0_.id
ORDER BY
  e0_.id DESC
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0, e0_.id AS id_1 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 LEFT JOIN event_site e4_ ON e0_.id = e4_.event_id LEFT JOIN site s3_ ON s3_.id = e4_.site_id LEFT JOIN event_profile e6_ ON e0_.id = e6_.event_id LEFT JOIN profile p5_ ON p5_.id = e6_.profile_id LEFT JOIN user u7_ ON e0_.created_by_id = u7_.id WHERE e0_.deleted_at IS NULL AND YEAR(e0_.date_to) = '2026' AND (MONTH(e0_.date_from) >= '12' AND MONTH(e0_.date_from) <= '12') GROUP BY e0_.id ORDER BY e0_.id DESC LIMIT 20;

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

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:41:12' ORDER BY e0_.date_to ASC;