Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5,
  t0.created_at AS created_at_6,
  t0.telephone AS telephone_7,
  t0.adress AS adress_8,
  t9.id AS id_10,
  t9.user_id AS user_id_11,
  t0.boutique_id AS boutique_id_12
FROM
  user t0
  LEFT JOIN livreur t9 ON t9.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.created_at AS created_at_6, t0.telephone AS telephone_7, t0.adress AS adress_8, t9.id AS id_10, t9.user_id AS user_id_11, t0.boutique_id AS boutique_id_12 FROM user t0 LEFT JOIN livreur t9 ON t9.user_id = t0.id WHERE t0.id = 4;

SELECT
  SUM(
    CASE WHEN f0_.montant_total > 0 THEN (
      f0_.montant_paye * (
        f0_.montant_total + COALESCE(f0_.frais_transport, 0)
      ) / f0_.montant_total
    ) ELSE f0_.montant_paye END
  ) AS sclr_0
FROM
  vente v1_
  LEFT JOIN facture f0_ ON v1_.id = f0_.vente_id
WHERE
  f0_.statut_paiement = ?
  AND f0_.created_at >= ?

SELECT SUM(CASE WHEN f0_.montant_total > 0 THEN (f0_.montant_paye * (f0_.montant_total + COALESCE(f0_.frais_transport, 0)) / f0_.montant_total) ELSE f0_.montant_paye END) AS sclr_0 FROM vente v1_ LEFT JOIN facture f0_ ON v1_.id = f0_.vente_id WHERE f0_.statut_paiement = 'Payé' AND f0_.created_at >= '2025-09-10 00:00:00';

SELECT
  SUM(
    CASE WHEN f0_.montant_total > 0 THEN (
      e1_.amount * (
        f0_.montant_total + COALESCE(f0_.frais_transport, 0)
      ) / f0_.montant_total
    ) ELSE e1_.amount END
  ) AS sclr_0
FROM
  vente v2_
  LEFT JOIN facture f0_ ON v2_.id = f0_.vente_id
  LEFT JOIN echeance e1_ ON f0_.id = e1_.facture_id
WHERE
  e1_.is_paid = ?
  AND e1_.date >= ?

SELECT SUM(CASE WHEN f0_.montant_total > 0 THEN (e1_.amount * (f0_.montant_total + COALESCE(f0_.frais_transport, 0)) / f0_.montant_total) ELSE e1_.amount END) AS sclr_0 FROM vente v2_ LEFT JOIN facture f0_ ON v2_.id = f0_.vente_id LEFT JOIN echeance e1_ ON f0_.id = e1_.facture_id WHERE e1_.is_paid = 1 AND e1_.date >= '2025-09-10 00:00:00';

SELECT
  SUM(
    CASE WHEN f0_.montant_total > 0 THEN (
      f0_.montant_paye * (
        f0_.montant_total + COALESCE(f0_.frais_transport, 0)
      ) / f0_.montant_total
    ) ELSE f0_.montant_paye END
  ) AS sclr_0
FROM
  vente v1_
  LEFT JOIN facture f0_ ON v1_.id = f0_.vente_id
WHERE
  f0_.statut_paiement = ?
  AND f0_.created_at >= ?

SELECT SUM(CASE WHEN f0_.montant_total > 0 THEN (f0_.montant_paye * (f0_.montant_total + COALESCE(f0_.frais_transport, 0)) / f0_.montant_total) ELSE f0_.montant_paye END) AS sclr_0 FROM vente v1_ LEFT JOIN facture f0_ ON v1_.id = f0_.vente_id WHERE f0_.statut_paiement = 'Payé' AND f0_.created_at >= '2025-09-10 00:00:00';

SELECT
  SUM(
    CASE WHEN f0_.montant_total > 0 THEN (
      e1_.amount * (
        f0_.montant_total + COALESCE(f0_.frais_transport, 0)
      ) / f0_.montant_total
    ) ELSE e1_.amount END
  ) AS sclr_0
FROM
  vente v2_
  LEFT JOIN facture f0_ ON v2_.id = f0_.vente_id
  LEFT JOIN echeance e1_ ON f0_.id = e1_.facture_id
WHERE
  e1_.is_paid = ?
  AND e1_.date >= ?

SELECT SUM(CASE WHEN f0_.montant_total > 0 THEN (e1_.amount * (f0_.montant_total + COALESCE(f0_.frais_transport, 0)) / f0_.montant_total) ELSE e1_.amount END) AS sclr_0 FROM vente v2_ LEFT JOIN facture f0_ ON v2_.id = f0_.vente_id LEFT JOIN echeance e1_ ON f0_.id = e1_.facture_id WHERE e1_.is_paid = 1 AND e1_.date >= '2025-09-10 00:00:00';