Symfony Profiler

SELECT
  COALESCE(
    SUM(p0_.somme_payee),
    0
  ) AS sclr_0
FROM
  paiement_recette p0_
  INNER JOIN recette r1_ ON p0_.recette_id = r1_.id
  INNER JOIN type_paiement t2_ ON p0_.type_paiement_id = t2_.id
WHERE
  r1_.date >= ?
  AND r1_.date <= ?
  AND t2_.nom = ?

SELECT COALESCE(SUM(p0_.somme_payee), 0) AS sclr_0 FROM paiement_recette p0_ INNER JOIN recette r1_ ON p0_.recette_id = r1_.id INNER JOIN type_paiement t2_ ON p0_.type_paiement_id = t2_.id WHERE r1_.date >= '2025-04-01 00:00:00' AND r1_.date <= '2025-04-30 00:00:00' AND t2_.nom = 'Carte Bancaire';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.slug AS slug_8,
  t0.birthdate AS birthdate_9,
  t10.id AS id_11,
  t10.qr_code_image AS qr_code_image_12,
  t10.points AS points_13,
  t10.apple_wallet_token AS apple_wallet_token_14,
  t10.apple_wallet_push_token AS apple_wallet_push_token_15,
  t10.device_library_identifier AS device_library_identifier_16,
  t10.updated_at AS updated_at_17,
  t10.last_notification AS last_notification_18,
  t10.user_id AS user_id_19
FROM
  user t0
  LEFT JOIN card t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.roles AS roles_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.slug AS slug_8, t0.birthdate AS birthdate_9, t10.id AS id_11, t10.qr_code_image AS qr_code_image_12, t10.points AS points_13, t10.apple_wallet_token AS apple_wallet_token_14, t10.apple_wallet_push_token AS apple_wallet_push_token_15, t10.device_library_identifier AS device_library_identifier_16, t10.updated_at AS updated_at_17, t10.last_notification AS last_notification_18, t10.user_id AS user_id_19 FROM user t0 LEFT JOIN card t10 ON t10.user_id = t0.id WHERE t0.id = 1;

SELECT
  SUM(r0_.total) AS sclr_0
FROM
  recette r0_
WHERE
  r0_.date >= ?
  AND r0_.date <= ?

SELECT SUM(r0_.total) AS sclr_0 FROM recette r0_ WHERE r0_.date >= '2025-01-01 00:00:00' AND r0_.date <= '2025-12-31 00:00:00';

SELECT
  DAYOFWEEK(date) AS jour_semaine,
  COUNT(*) AS nombre_recettes,
  SUM(total) AS total_ca,
  AVG(total) AS moyenne_jour,
  COUNT(DISTINCT date) AS nombre_jours_ouvres
FROM
  recette
WHERE
  EXTRACT(
    YEAR
    FROM
      date
  ) = :year
  AND EXTRACT(
    MONTH
    FROM
      date
  ) = :month
GROUP BY
  DAYOFWEEK(date)
HAVING
  nombre_recettes > 0
ORDER BY
  moyenne_jour DESC

SELECT 
            DAYOFWEEK(date) AS jour_semaine,
            COUNT(*) AS nombre_recettes,
            SUM(total) AS total_ca,
            AVG(total) AS moyenne_jour,
            COUNT(DISTINCT date) AS nombre_jours_ouvres
        FROM recette
        WHERE EXTRACT(YEAR FROM date) = 2025 
        AND EXTRACT(MONTH FROM date) = 4
        GROUP BY DAYOFWEEK(date)
        HAVING nombre_recettes > 0
        ORDER BY moyenne_jour DESC
    ;

SELECT
  EXTRACT(
    MONTH
    FROM
      date
  ) AS mois,
  SUM(total) AS total
FROM
  recette
WHERE
  EXTRACT(
    YEAR
    FROM
      date
  ) = :year
GROUP BY
  EXTRACT(
    MONTH
    FROM
      date
  )
ORDER BY
  mois ASC

SELECT 
                EXTRACT(MONTH FROM date) AS mois,
                SUM(total) AS total
            FROM recette
            WHERE EXTRACT(YEAR FROM date) = 2025
            GROUP BY EXTRACT(MONTH FROM date)
            ORDER BY mois ASC
        ;

SELECT
  t0.id AS id_1,
  t0.is_winning AS is_winning_2,
  t0.is_scratched AS is_scratched_3,
  t0.created_at AS created_at_4,
  t0.scratched_at AS scratched_at_5,
  t0.slug AS slug_6,
  t0.qr_code_path AS qr_code_path_7,
  t0.active AS active_8,
  t0.date_used AS date_used_9,
  t0.user_id AS user_id_10,
  t0.offre_id AS offre_id_11
FROM
  ticket_gratter t0
WHERE
  t0.user_id = ?
  AND t0.is_scratched = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_winning AS is_winning_2, t0.is_scratched AS is_scratched_3, t0.created_at AS created_at_4, t0.scratched_at AS scratched_at_5, t0.slug AS slug_6, t0.qr_code_path AS qr_code_path_7, t0.active AS active_8, t0.date_used AS date_used_9, t0.user_id AS user_id_10, t0.offre_id AS offre_id_11 FROM ticket_gratter t0 WHERE t0.user_id = 1 AND t0.is_scratched = 0 LIMIT 1;

WITH
  DateActuelle AS (
    SELECT
      EXTRACT(
        YEAR
        FROM
          CURRENT_DATE
      ) AS annee,
      EXTRACT(
        MONTH
        FROM
          CURRENT_DATE
      ) AS mois,
      EXTRACT(
        DAY
        FROM
          CURRENT_DATE
      ) AS jour
  )
SELECT
  COALESCE(
    SUM(
      CASE WHEN EXTRACT(
        YEAR
        FROM
          date
      ) = d.annee
      AND EXTRACT(
        MONTH
        FROM
          date
      ) = d.mois
      AND EXTRACT(
        DAY
        FROM
          date
      ) <= d.jour THEN total END
    ),
    0
  ) AS mois_actuel,
  COALESCE(
    SUM(
      CASE WHEN EXTRACT(
        YEAR
        FROM
          date
      ) = CASE WHEN d.mois = 1 THEN d.annee - 1 ELSE d.annee END
      AND EXTRACT(
        MONTH
        FROM
          date
      ) = CASE WHEN d.mois = 1 THEN 12 ELSE d.mois - 1 END
      AND EXTRACT(
        DAY
        FROM
          date
      ) <= d.jour THEN total END
    ),
    0
  ) AS mois_precedent
FROM
  recette,
  DateActuelle d

WITH DateActuelle AS (
            SELECT 
                EXTRACT(YEAR FROM CURRENT_DATE) AS annee,
                EXTRACT(MONTH FROM CURRENT_DATE) AS mois,
                EXTRACT(DAY FROM CURRENT_DATE) AS jour
        )
        SELECT 
            COALESCE(SUM(CASE 
                WHEN EXTRACT(YEAR FROM date) = d.annee 
                AND EXTRACT(MONTH FROM date) = d.mois 
                AND EXTRACT(DAY FROM date) <= d.jour
                THEN total END), 0) AS mois_actuel,
            COALESCE(SUM(CASE 
                WHEN EXTRACT(YEAR FROM date) = CASE 
                    WHEN d.mois = 1 THEN d.annee - 1 
                    ELSE d.annee END
                AND EXTRACT(MONTH FROM date) = CASE 
                    WHEN d.mois = 1 THEN 12 
                    ELSE d.mois - 1 END
                AND EXTRACT(DAY FROM date) <= d.jour
                THEN total END), 0) AS mois_precedent
        FROM recette, DateActuelle d
    ;

SELECT
  DATE(date) AS jour,
  COUNT(*) AS nombre_recettes,
  SUM(total) AS total_ca
FROM
  recette
WHERE
  EXTRACT(
    YEAR
    FROM
      date
  ) = :year
  AND EXTRACT(
    MONTH
    FROM
      date
  ) = :month
GROUP BY
  DATE(date)
ORDER BY
  total_ca DESC
LIMIT
  1

SELECT 
            DATE(date) AS jour,
            COUNT(*) AS nombre_recettes,
            SUM(total) AS total_ca
        FROM recette
        WHERE EXTRACT(YEAR FROM date) = 2025 
        AND EXTRACT(MONTH FROM date) = 4
        GROUP BY DATE(date)
        ORDER BY total_ca DESC
        LIMIT 1
    ;

SELECT
  COALESCE(
    SUM(r0_.acompte),
    0
  ) AS sclr_0
FROM
  recette r0_
WHERE
  r0_.date >= ?
  AND r0_.date <= ?
  AND r0_.acompte > 0

SELECT COALESCE(SUM(r0_.acompte), 0) AS sclr_0 FROM recette r0_ WHERE r0_.date >= '2025-04-01 00:00:00' AND r0_.date <= '2025-04-30 00:00:00' AND r0_.acompte > 0;