Symfony Profiler

SELECT
  c0_.id AS id_0,
  SUM(q1_.quantite * m2_.quantite) AS sclr_1
FROM
  mouvement_web m2_
  INNER JOIN produit p3_ ON (p3_.reference = m2_.ref)
  INNER JOIN association a4_ ON p3_.id = a4_.produit_id
  INNER JOIN qt q1_ ON a4_.id = q1_.association_id
  INNER JOIN composant c0_ ON q1_.composants_id = c0_.id
WHERE
  m2_.is_etat_one = ?
  AND m2_.is_accep = ?
  AND m2_.is_etat_end <> ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, SUM(q1_.quantite * m2_.quantite) AS sclr_1 FROM mouvement_web m2_ INNER JOIN produit p3_ ON (p3_.reference = m2_.ref) INNER JOIN association a4_ ON p3_.id = a4_.produit_id INNER JOIN qt q1_ ON a4_.id = q1_.association_id INNER JOIN composant c0_ ON q1_.composants_id = c0_.id WHERE m2_.is_etat_one = 1 AND m2_.is_accep = 1 AND m2_.is_etat_end <> 1 GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  SUM(q1_.quantite * m2_.quantite) AS sclr_1
FROM
  mouvement_web m2_
  INNER JOIN produit p3_ ON (p3_.reference = m2_.ref)
  INNER JOIN association a4_ ON p3_.id = a4_.produit_id
  INNER JOIN qt q1_ ON a4_.id = q1_.association_id
  INNER JOIN composant c0_ ON q1_.composants_id = c0_.id
WHERE
  m2_.date_delivery BETWEEN ?
  AND ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, SUM(q1_.quantite * m2_.quantite) AS sclr_1 FROM mouvement_web m2_ INNER JOIN produit p3_ ON (p3_.reference = m2_.ref) INNER JOIN association a4_ ON p3_.id = a4_.produit_id INNER JOIN qt q1_ ON a4_.id = q1_.association_id INNER JOIN composant c0_ ON q1_.composants_id = c0_.id WHERE m2_.date_delivery BETWEEN '2026-01-30 00:00:00' AND '2026-01-30 23:59:59' GROUP BY c0_.id;

SELECT
  c0_.id AS id_0,
  SUM(q1_.quantite) AS sclr_1
FROM
  commande c2_
  INNER JOIN qt_commande q1_ ON c2_.id = q1_.commande_id
  INNER JOIN composant c0_ ON q1_.composants_id = c0_.id
WHERE
  c2_.is_recu = ?
GROUP BY
  c0_.id

SELECT c0_.id AS id_0, SUM(q1_.quantite) AS sclr_1 FROM commande c2_ INNER JOIN qt_commande q1_ ON c2_.id = q1_.commande_id INNER JOIN composant c0_ ON q1_.composants_id = c0_.id WHERE c2_.is_recu = 0 GROUP BY c0_.id;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.quantite AS quantite_4,
  t0.alerte AS alerte_5,
  t0.categorie AS categorie_6,
  t0.nomenclature AS nomenclature_7,
  t0.ht AS ht_8,
  t0.taxe AS taxe_9,
  t0.dlc AS dlc_10,
  t0.is_france AS is_france_11,
  t0.qt_tempo AS qt_tempo_12,
  t0.qt_site AS qt_site_13,
  t0.qt_appro AS qt_appro_14,
  t0.is_bouquet AS is_bouquet_15,
  t0.qr_code_path AS qr_code_path_16,
  t0.reffj AS reffj_17,
  t0.is_surveillance AS is_surveillance_18,
  t0.is_active_produit AS is_active_produit_19,
  t0.is_coupure_produit AS is_coupure_produit_20,
  t0.is_in_active_produit AS is_in_active_produit_21,
  t0.date_debut AS date_debut_22,
  t0.date_fin AS date_fin_23,
  t0.fournisseurs_id AS fournisseurs_id_24,
  t0.qt_id AS qt_id_25,
  t0.commande_id AS commande_id_26,
  t0.association_id AS association_id_27
FROM
  composant t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.quantite AS quantite_4, t0.alerte AS alerte_5, t0.categorie AS categorie_6, t0.nomenclature AS nomenclature_7, t0.ht AS ht_8, t0.taxe AS taxe_9, t0.dlc AS dlc_10, t0.is_france AS is_france_11, t0.qt_tempo AS qt_tempo_12, t0.qt_site AS qt_site_13, t0.qt_appro AS qt_appro_14, t0.is_bouquet AS is_bouquet_15, t0.qr_code_path AS qr_code_path_16, t0.reffj AS reffj_17, t0.is_surveillance AS is_surveillance_18, t0.is_active_produit AS is_active_produit_19, t0.is_coupure_produit AS is_coupure_produit_20, t0.is_in_active_produit AS is_in_active_produit_21, t0.date_debut AS date_debut_22, t0.date_fin AS date_fin_23, t0.fournisseurs_id AS fournisseurs_id_24, t0.qt_id AS qt_id_25, t0.commande_id AS commande_id_26, t0.association_id AS association_id_27 FROM composant t0;

SELECT
  DISTINCT f0_.nom AS nom_0
FROM
  composant c1_
  INNER JOIN fournisseur f0_ ON c1_.fournisseurs_id = f0_.id
ORDER BY
  f0_.nom ASC

SELECT DISTINCT f0_.nom AS nom_0 FROM composant c1_ INNER JOIN fournisseur f0_ ON c1_.fournisseurs_id = f0_.id ORDER BY f0_.nom ASC;

SELECT
  DISTINCT c0_.categorie AS categorie_0
FROM
  composant c0_
ORDER BY
  c0_.categorie ASC

SELECT DISTINCT c0_.categorie AS categorie_0 FROM composant c0_ ORDER BY c0_.categorie ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.ref AS ref_4,
  t0.old_id_web AS old_id_web_5,
  t0.is_etat_end AS is_etat_end_6,
  t0.is_etat_one AS is_etat_one_7,
  t0.is_accep AS is_accep_8,
  t0.quantite AS quantite_9,
  t0.num_commande AS num_commande_10,
  t0.num_facture AS num_facture_11,
  t0.date AS date_12,
  t0.is_en_livraison AS is_en_livraison_13,
  t0.date_delivery AS date_delivery_14,
  t0.is_relivraison AS is_relivraison_15
FROM
  mouvement_web t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.ref AS ref_4,
  t0.old_id_web AS old_id_web_5,
  t0.is_etat_end AS is_etat_end_6,
  t0.is_etat_one AS is_etat_one_7,
  t0.is_accep AS is_accep_8,
  t0.quantite AS quantite_9,
  t0.num_commande AS num_commande_10,
  t0.num_facture AS num_facture_11,
  t0.date AS date_12,
  t0.is_en_livraison AS is_en_livraison_13,
  t0.date_delivery AS date_delivery_14,
  t0.is_relivraison AS is_relivraison_15
FROM
  mouvement_web t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.ean13 AS ean13_3,
  t0.ref AS ref_4,
  t0.old_id_web AS old_id_web_5,
  t0.is_etat_end AS is_etat_end_6,
  t0.is_etat_one AS is_etat_one_7,
  t0.is_accep AS is_accep_8,
  t0.quantite AS quantite_9,
  t0.num_commande AS num_commande_10,
  t0.num_facture AS num_facture_11,
  t0.date AS date_12,
  t0.is_en_livraison AS is_en_livraison_13,
  t0.date_delivery AS date_delivery_14,
  t0.is_relivraison AS is_relivraison_15
FROM
  mouvement_web t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.ean13 AS ean13_3, t0.ref AS ref_4, t0.old_id_web AS old_id_web_5, t0.is_etat_end AS is_etat_end_6, t0.is_etat_one AS is_etat_one_7, t0.is_accep AS is_accep_8, t0.quantite AS quantite_9, t0.num_commande AS num_commande_10, t0.num_facture AS num_facture_11, t0.date AS date_12, t0.is_en_livraison AS is_en_livraison_13, t0.date_delivery AS date_delivery_14, t0.is_relivraison AS is_relivraison_15 FROM mouvement_web t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 68;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 75;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 101;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 57;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 73;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 76;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 97;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 90;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contact AS contact_3, t0.email AS email_4, t0.telephone AS telephone_5, t0.adresse AS adresse_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.pays AS pays_9, t0.site_web AS site_web_10, t0.ref_fournisseur AS ref_fournisseur_11 FROM fournisseur t0 WHERE t0.id = 102;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.contact AS contact_3,
  t0.email AS email_4,
  t0.telephone AS telephone_5,
  t0.adresse AS adresse_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.pays AS pays_9,
  t0.site_web AS site_web_10,
  t0.ref_fournisseur AS ref_fournisseur_11
FROM
  fournisseur t0
WHERE
  t0.id = ?