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 = 'crt@nomad.fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.code AS code_4,
  t0.operator_id AS operator_id_5,
  t0.organisation_id AS organisation_id_6
FROM
  point_of_sale t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.operator_id AS operator_id_5, t0.organisation_id AS organisation_id_6 FROM point_of_sale t0 WHERE t0.id = '5' LIMIT 1;

SELECT
  DAY(p.date_vente_valid_b) AS cle,
  COUNT(p.id) AS total_ventes
FROM
  production p
WHERE
  p.point_of_sale_id = :pointOfSale
  AND YEAR(p.date_vente_valid_b) = :annee
  AND MONTH(p.date_vente_valid_b) = :mois
  AND p.category_id IN (
    :category0, :category1, :category2
  )
GROUP BY
  DAY(p.date_vente_valid_b)
ORDER BY
  DAY(p.date_vente_valid_b) ASC

SELECT 
            DAY(p.date_vente_valid_b) AS cle,
            COUNT(p.id) AS total_ventes
        FROM production p
     WHERE p.point_of_sale_id = 5 AND YEAR(p.date_vente_valid_b) = '2026' AND MONTH(p.date_vente_valid_b) = '04' AND p.category_id IN (1,2,3)
            GROUP BY DAY(p.date_vente_valid_b)
            ORDER BY DAY(p.date_vente_valid_b) ASC
        ;

SELECT
  DAY(p.date_vente_valid_b) AS cle,
  COUNT(p.id) AS total_ventes
FROM
  production p
WHERE
  p.point_of_sale_id = :pointOfSale
  AND YEAR(p.date_vente_valid_b) = :annee
  AND MONTH(p.date_vente_valid_b) = :mois
  AND p.category_id IN (
    :category0, :category1, :category2
  )
GROUP BY
  DAY(p.date_vente_valid_b)
ORDER BY
  DAY(p.date_vente_valid_b) ASC

SELECT 
            DAY(p.date_vente_valid_b) AS cle,
            COUNT(p.id) AS total_ventes
        FROM production p
     WHERE p.point_of_sale_id = 5 AND YEAR(p.date_vente_valid_b) = '2026' AND MONTH(p.date_vente_valid_b) = 3 AND p.category_id IN (1,2,3)
            GROUP BY DAY(p.date_vente_valid_b)
            ORDER BY DAY(p.date_vente_valid_b) ASC
        ;