Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.creation_date AS creation_date_4
FROM
  shop t0

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.creation_date AS creation_date_4 FROM shop t0;

select
  count(distinct s.ID)
from
  sales s
where
  s.deleted != 1
  and date_format(s.`date`, '%Y') = 2026

select count(distinct s.ID)
                    from sales s
                    where  s.deleted != 1 and date_format(s.`date` , '%Y') = 2026;

select
  count(distinct s.ID)
from
  sales s
where
  date_format(s.`date`, '%Y') = 2026
  and date_format(s.`date`, '%U') = 15

select count(distinct s.ID)
                    from sales s
                    where  date_format(s.`date` , '%Y') =  2026 and date_format(s.`date` , '%U') = 15;

select
  date_format(s.`date`, '%m') as mois,
  COALESCE(
    SUM(si.amount),
    0
  ) + COALESCE(
    SUM(sp.amount),
    0
  ) AS ca,
  COALESCE(
    SUM(si.benef),
    0
  ) + COALESCE(
    SUM(sp.benef),
    0
  ) AS benef
from
  sales s
  left join sale_items si on s.id = si.sale_id
  left join sale_packs sp on s.id = sp.sale_id
where
  s.deleted != 1
  and date_format(s.`date`, '%Y') = 2026
group by
  mois
ORDER BY
  mois asc;

select 
               date_format(s.`date` ,'%m') as mois 
               ,COALESCE(SUM(si.amount), 0) + COALESCE(SUM(sp.amount), 0) AS ca
               , COALESCE(SUM(si.benef), 0) + COALESCE(SUM(sp.benef), 0) AS benef
               	from sales s
               	left join sale_items si on s.id = si.sale_id 
               	left join sale_packs sp on s.id = sp.sale_id 
               	where s.deleted != 1
               	and date_format(s.`date` , '%Y') = 2026
               group by mois 
                ORDER BY mois asc;
                ;

select
  date_format(s.`date`, '%w') as day,
  COALESCE(
    SUM(si.amount),
    0
  ) + COALESCE(
    SUM(sp.amount),
    0
  ) AS ca,
  COALESCE(
    SUM(si.benef),
    0
  ) + COALESCE(
    SUM(sp.benef),
    0
  ) AS benef
from
  sales s
  left join sale_items si on s.id = si.sale_id
  left join sale_packs sp on s.id = sp.sale_id
where
  s.deleted != 1
  and date_format(s.`date`, '%Y') = 2026
  and date_format(s.`date`, '%U') = 15
group by
  day

select 
                               date_format(s.`date` ,'%w') as day 
                                , COALESCE(SUM(si.amount), 0) + COALESCE(SUM(sp.amount), 0) AS ca
                                , COALESCE(SUM(si.benef), 0) + COALESCE(SUM(sp.benef), 0) AS benef
                                from sales s
                                left join sale_items si on s.id = si.sale_id 
                                left join sale_packs sp on s.id = sp.sale_id 
                                where s.deleted != 1
                                and date_format(s.`date` , '%Y') = 2026 and  date_format(s.`date` , '%U') = 15
                               group by day
                ;

select
  ifnull(c.label, 'Inconnue') as cat,
  COALESCE(
    SUM(si.amount),
    0
  ) + COALESCE(
    SUM(sp.amount),
    0
  ) AS nb_vente
from
  sales s
  left join sale_items si on s.id = si.sale_id
  left join sale_packs sp on s.id = sp.sale_id
  left join product p on p.id = si.product_id
  left join category c on c.id = p.category_id
where
  s.deleted != 1 -- and si.costs is not null 

  -- and si.count < 5000

  and date_format(s.`date`, '%Y') = 2026
group by
  c.id

select 
               ifnull( c.label , 'Inconnue')  as cat 
               ,COALESCE(SUM(si.amount), 0) + COALESCE(SUM(sp.amount), 0) AS nb_vente
               	from sales s
               	left join sale_items si on s.id = si.sale_id 
               	left join sale_packs sp on s.id = sp.sale_id 
               	left join product p on p.id = si.product_id 
               	left join category c on c.id = p.category_id 
               	where s.deleted != 1 
               	-- and si.costs is not null 

               	-- and si.count < 5000

               	and date_format(s.`date` , '%Y') = 2026
               group by c.id
                ;