Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.internal_ref AS internal_ref_7,
  t0.origin_id AS origin_id_8,
  t0.parent_origin_id AS parent_origin_id_9,
  t0.picto AS picto_10,
  t0.parent_id AS parent_id_11,
  t0.point_of_sale_id AS point_of_sale_id_12,
  t0.role_app_id AS role_app_id_13,
  t0.organisation_id AS organisation_id_14
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.roles AS roles_5, t0.password AS password_6, t0.internal_ref AS internal_ref_7, t0.origin_id AS origin_id_8, t0.parent_origin_id AS parent_origin_id_9, t0.picto AS picto_10, t0.parent_id AS parent_id_11, t0.point_of_sale_id AS point_of_sale_id_12, t0.role_app_id AS role_app_id_13, t0.organisation_id AS organisation_id_14 FROM user t0 WHERE t0.email = 'districom@nomad.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.operator_id AS operator_id_5
FROM
  etat_production t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.description AS description_4, t0.operator_id AS operator_id_5 FROM etat_production t0 WHERE t0.id = '3' LIMIT 1;

SELECT
  COUNT(p0_.id) AS sclr_0,
  MONTH(p0_.date_vente_valid_b) AS sclr_1,
  YEAR(p0_.date_vente_valid_b) AS sclr_2,
  MONTH(p0_.date_racc) AS sclr_3,
  YEAR(p0_.date_racc) AS sclr_4
FROM
  production p0_
  LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id
WHERE
  p0_.etat_id = ?
  AND p0_.point_of_sale_id = ?
  AND (
    (
      YEAR(p0_.date_vente_valid_b) = ?
      AND MONTH(p0_.date_vente_valid_b) = ?
    )
    OR (
      YEAR(p0_.date_vente_valid_b) = ?
      AND MONTH(p0_.date_vente_valid_b) = ?
    )
    OR (
      YEAR(p0_.date_vente_valid_b) = ?
      AND MONTH(p0_.date_vente_valid_b) = ?
    )
  )
GROUP BY
  sclr_1,
  sclr_3,
  p1_.id
ORDER BY
  DATE_FORMAT(p0_.date_racc, '%Y%m') DESC,
  DATE_FORMAT(p0_.date_vente_valid_b, '%Y%m') DESC

SELECT COUNT(p0_.id) AS sclr_0, MONTH(p0_.date_vente_valid_b) AS sclr_1, YEAR(p0_.date_vente_valid_b) AS sclr_2, MONTH(p0_.date_racc) AS sclr_3, YEAR(p0_.date_racc) AS sclr_4 FROM production p0_ LEFT JOIN point_of_sale p1_ ON p0_.point_of_sale_id = p1_.id WHERE p0_.etat_id = 3 AND p0_.point_of_sale_id = 10030 AND ((YEAR(p0_.date_vente_valid_b) = 2026 AND MONTH(p0_.date_vente_valid_b) = 4) OR (YEAR(p0_.date_vente_valid_b) = 2026 AND MONTH(p0_.date_vente_valid_b) = 3) OR (YEAR(p0_.date_vente_valid_b) = 2026 AND MONTH(p0_.date_vente_valid_b) = 2)) GROUP BY sclr_1, sclr_3, p1_.id ORDER BY DATE_FORMAT(p0_.date_racc, '%Y%m') DESC, DATE_FORMAT(p0_.date_vente_valid_b, '%Y%m') DESC;