Symfony Profiler

select
  req.day,
  sum(req.cat1) as 8_12,
  sum(req.cat2) as 12_16,
  sum(req.cat3) as 16_20,
  sum(req.cat4) as 20_00
from
  (
    select
      s.id as vente,
      DAYOFWEEK(s.date) as day,
      s.shop_id as shop,
      if (
        date_format(s.`date`, '%H') >= 8
        and date_format(s.`date`, '%H') < 12,
        1,
        0
      ) as cat1,
      if (
        date_format(s.`date`, '%H') >= 12
        and date_format(s.`date`, '%H') < 16,
        1,
        0
      ) as cat2,
      if (
        date_format(s.`date`, '%H') >= 16
        and date_format(s.`date`, '%H') < 20,
        1,
        0
      ) as cat3,
      if (
        date_format(s.`date`, '%H') >= 20
        and date_format(s.`date`, '%H') <= 23,
        1,
        0
      ) as cat4
    from
      sales s
    where
      s.deleted != 1
      and date_format(s.`date`, '%m') = 04
  ) req
group by
  day;

select 
                    req.day,
                    sum(req.cat1) as 8_12, 
                    sum(req.cat2) as 12_16, 
                    sum(req.cat3) as 16_20, 
                    sum(req.cat4) as 20_00
                    from(
                        select s.id as vente, DAYOFWEEK(s.date) as day, s.shop_id as shop,
                        if (date_format(s.`date`, '%H') >= 8 and date_format(s.`date`, '%H') < 12 , 1 , 0 ) as cat1,
                        if (date_format(s.`date`, '%H') >= 12 and date_format(s.`date`, '%H') < 16 , 1 , 0 ) as cat2,
                        if (date_format(s.`date`, '%H') >= 16 and date_format(s.`date`, '%H') < 20 , 1 , 0 ) as cat3,
                        if (date_format(s.`date`, '%H') >= 20 and date_format(s.`date`, '%H') <= 23 , 1 , 0 ) as cat4
                        from sales s
                        where s.deleted != 1 and date_format(s.`date` , '%m') = 04
                    )req
                group by day;
                ;

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;