Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.prix_ttc AS prix_ttc_2,
  t0.taux_tva AS taux_tva_3,
  t0.supplement_tarif_ttc AS supplement_tarif_ttc_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.sortable AS sortable_9,
  t0.produit_id AS produit_id_10,
  t0.menu_lot_id AS menu_lot_id_11
FROM
  menu_lot_produit t0
WHERE
  t0.menu_lot_id = ?

SELECT t0.id AS id_1, t0.prix_ttc AS prix_ttc_2, t0.taux_tva AS taux_tva_3, t0.supplement_tarif_ttc AS supplement_tarif_ttc_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.sortable AS sortable_9, t0.produit_id AS produit_id_10, t0.menu_lot_id AS menu_lot_id_11 FROM menu_lot_produit t0 WHERE t0.menu_lot_id = 3;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_complement AS libelle_complement_3,
  t0.description AS description_4,
  t0.prix_ttc AS prix_ttc_5,
  t0.taux_tva AS taux_tva_6,
  t0.commandable_seul AS commandable_seul_7,
  t0.disponible AS disponible_8,
  t0.affichable AS affichable_9,
  t0.ordre_impression_cuisine AS ordre_impression_cuisine_10,
  t0.path AS path_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.sortable AS sortable_16,
  t0.produit_categorie_id AS produit_categorie_id_17
FROM
  produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_complement AS libelle_complement_3, t0.description AS description_4, t0.prix_ttc AS prix_ttc_5, t0.taux_tva AS taux_tva_6, t0.commandable_seul AS commandable_seul_7, t0.disponible AS disponible_8, t0.affichable AS affichable_9, t0.ordre_impression_cuisine AS ordre_impression_cuisine_10, t0.path AS path_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.sortable AS sortable_16, t0.produit_categorie_id AS produit_categorie_id_17 FROM produit t0 WHERE t0.id = 56;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.sortable AS sortable_9,
  t0.menu_id AS menu_id_10,
  t11.id AS id_12,
  t11.libelle AS libelle_13,
  t11.description AS description_14,
  t11.disponible AS disponible_15,
  t11.affichable AS affichable_16,
  t11.cuisine_details AS cuisine_details_17,
  t11.path AS path_18,
  t11.created_at AS created_at_19,
  t11.updated_at AS updated_at_20,
  t11.created_by AS created_by_21,
  t11.updated_by AS updated_by_22,
  t11.sortable AS sortable_23,
  t11.produit_categorie_id AS produit_categorie_id_24
FROM
  menu_lot t0
  INNER JOIN menu t11 ON t0.menu_id = t11.id
WHERE
  t0.menu_id = ?
ORDER BY
  t0.sortable ASC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.sortable AS sortable_9, t0.menu_id AS menu_id_10, t11.id AS id_12, t11.libelle AS libelle_13, t11.description AS description_14, t11.disponible AS disponible_15, t11.affichable AS affichable_16, t11.cuisine_details AS cuisine_details_17, t11.path AS path_18, t11.created_at AS created_at_19, t11.updated_at AS updated_at_20, t11.created_by AS created_by_21, t11.updated_by AS updated_by_22, t11.sortable AS sortable_23, t11.produit_categorie_id AS produit_categorie_id_24 FROM menu_lot t0 INNER JOIN menu t11 ON t0.menu_id = t11.id WHERE t0.menu_id = 2 ORDER BY t0.sortable ASC;

SELECT
  p0_.id AS id_0,
  p0_.date_debut AS date_debut_1,
  p0_.date_fin AS date_fin_2,
  p0_.service AS service_3,
  p0_.reservable_en_ligne AS reservable_en_ligne_4,
  p0_.created_at AS created_at_5,
  p0_.updated_at AS updated_at_6,
  p0_.created_by AS created_by_7,
  p0_.updated_by AS updated_by_8,
  p0_.camion_id AS camion_id_9,
  p0_.emplacement_id AS emplacement_id_10
FROM
  planning p0_
  INNER JOIN camion c1_ ON p0_.camion_id = c1_.id
WHERE
  p0_.date_debut >= ?
  AND p0_.date_fin <= ?
  AND p0_.reservable_en_ligne = 1
ORDER BY
  p0_.date_debut ASC

SELECT p0_.id AS id_0, p0_.date_debut AS date_debut_1, p0_.date_fin AS date_fin_2, p0_.service AS service_3, p0_.reservable_en_ligne AS reservable_en_ligne_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.created_by AS created_by_7, p0_.updated_by AS updated_by_8, p0_.camion_id AS camion_id_9, p0_.emplacement_id AS emplacement_id_10 FROM planning p0_ INNER JOIN camion c1_ ON p0_.camion_id = c1_.id WHERE p0_.date_debut >= '2025-12-10 00:00' AND p0_.date_fin <= '2025-12-12 23:59' AND p0_.reservable_en_ligne = 1 ORDER BY p0_.date_debut ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.libelle AS libelle_3,
  t0.valeur AS valeur_4,
  t0.type AS type_5
FROM
  parametre t0
WHERE
  t0.label = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.libelle AS libelle_3, t0.valeur AS valeur_4, t0.type AS type_5 FROM parametre t0 WHERE t0.label = 'nom_site' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_complement AS libelle_complement_3,
  t0.description AS description_4,
  t0.prix_ttc AS prix_ttc_5,
  t0.taux_tva AS taux_tva_6,
  t0.commandable_seul AS commandable_seul_7,
  t0.disponible AS disponible_8,
  t0.affichable AS affichable_9,
  t0.ordre_impression_cuisine AS ordre_impression_cuisine_10,
  t0.path AS path_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.sortable AS sortable_16,
  t0.produit_categorie_id AS produit_categorie_id_17
FROM
  produit t0
WHERE
  t0.produit_categorie_id = ?
ORDER BY
  t0.sortable ASC,
  t0.affichable DESC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_complement AS libelle_complement_3, t0.description AS description_4, t0.prix_ttc AS prix_ttc_5, t0.taux_tva AS taux_tva_6, t0.commandable_seul AS commandable_seul_7, t0.disponible AS disponible_8, t0.affichable AS affichable_9, t0.ordre_impression_cuisine AS ordre_impression_cuisine_10, t0.path AS path_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.sortable AS sortable_16, t0.produit_categorie_id AS produit_categorie_id_17 FROM produit t0 WHERE t0.produit_categorie_id = 1 ORDER BY t0.sortable ASC, t0.affichable DESC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.disponible AS disponible_4,
  t0.affichable AS affichable_5,
  t0.cuisine_details AS cuisine_details_6,
  t0.path AS path_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.sortable AS sortable_12,
  t0.produit_categorie_id AS produit_categorie_id_13
FROM
  menu t0
WHERE
  t0.produit_categorie_id = ?
ORDER BY
  t0.sortable ASC,
  t0.affichable DESC

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.disponible AS disponible_4, t0.affichable AS affichable_5, t0.cuisine_details AS cuisine_details_6, t0.path AS path_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.sortable AS sortable_12, t0.produit_categorie_id AS produit_categorie_id_13 FROM menu t0 WHERE t0.produit_categorie_id = 1 ORDER BY t0.sortable ASC, t0.affichable DESC;

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.pourcentage AS pourcentage_2,
  c0_.date_validite AS date_validite_3,
  c0_.active AS active_4,
  c0_.activation_automatique AS activation_automatique_5,
  c0_.maximum_reduction AS maximum_reduction_6,
  c0_.maximum_utilisation AS maximum_utilisation_7,
  c0_.created_by AS created_by_8,
  c0_.updated_by AS updated_by_9,
  c0_.commande_generatrice_id AS commande_generatrice_id_10
FROM
  code_promo c0_
WHERE
  c0_.date_validite >= ?
  AND c0_.active = ?
  AND c0_.activation_automatique = ?
ORDER BY
  c0_.id ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.pourcentage AS pourcentage_2, c0_.date_validite AS date_validite_3, c0_.active AS active_4, c0_.activation_automatique AS activation_automatique_5, c0_.maximum_reduction AS maximum_reduction_6, c0_.maximum_utilisation AS maximum_utilisation_7, c0_.created_by AS created_by_8, c0_.updated_by AS updated_by_9, c0_.commande_generatrice_id AS commande_generatrice_id_10 FROM code_promo c0_ WHERE c0_.date_validite >= '2025-12-10 11:29:05' AND c0_.active = 1 AND c0_.activation_automatique = 1 ORDER BY c0_.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.service AS service_4,
  t0.reservable_en_ligne AS reservable_en_ligne_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.camion_id AS camion_id_10,
  t0.emplacement_id AS emplacement_id_11,
  t12.id AS id_13,
  t12.adresse AS adresse_14,
  t12.libelle AS libelle_15,
  t12.lat AS lat_16,
  t12.lng AS lng_17,
  t12.code_postal AS code_postal_18,
  t12.ville AS ville_19,
  t12.introduction AS introduction_20,
  t12.created_at AS created_at_21,
  t12.updated_at AS updated_at_22,
  t12.created_by AS created_by_23,
  t12.updated_by AS updated_by_24
FROM
  planning t0
  INNER JOIN emplacement t12 ON t0.emplacement_id = t12.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.service AS service_4, t0.reservable_en_ligne AS reservable_en_ligne_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.camion_id AS camion_id_10, t0.emplacement_id AS emplacement_id_11, t12.id AS id_13, t12.adresse AS adresse_14, t12.libelle AS libelle_15, t12.lat AS lat_16, t12.lng AS lng_17, t12.code_postal AS code_postal_18, t12.ville AS ville_19, t12.introduction AS introduction_20, t12.created_at AS created_at_21, t12.updated_at AS updated_at_22, t12.created_by AS created_by_23, t12.updated_by AS updated_by_24 FROM planning t0 INNER JOIN emplacement t12 ON t0.emplacement_id = t12.id WHERE t0.id = '2629';

SELECT
  t0.id AS id_1,
  t0.adresse AS adresse_2,
  t0.libelle AS libelle_3,
  t0.lat AS lat_4,
  t0.lng AS lng_5,
  t0.code_postal AS code_postal_6,
  t0.ville AS ville_7,
  t0.introduction AS introduction_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12
FROM
  emplacement t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.libelle AS libelle_3, t0.lat AS lat_4, t0.lng AS lng_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.introduction AS introduction_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM emplacement t0 WHERE t0.id IN (2, 15, 11, 3, 4, 12, 22);

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.libelle_complement AS libelle_complement_3,
  t0.description AS description_4,
  t0.prix_ttc AS prix_ttc_5,
  t0.taux_tva AS taux_tva_6,
  t0.commandable_seul AS commandable_seul_7,
  t0.disponible AS disponible_8,
  t0.affichable AS affichable_9,
  t0.ordre_impression_cuisine AS ordre_impression_cuisine_10,
  t0.path AS path_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.sortable AS sortable_16,
  t0.produit_categorie_id AS produit_categorie_id_17
FROM
  produit t0
  INNER JOIN produit_planning ON t0.id = produit_planning.produit_id
WHERE
  produit_planning.planning_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.libelle_complement AS libelle_complement_3, t0.description AS description_4, t0.prix_ttc AS prix_ttc_5, t0.taux_tva AS taux_tva_6, t0.commandable_seul AS commandable_seul_7, t0.disponible AS disponible_8, t0.affichable AS affichable_9, t0.ordre_impression_cuisine AS ordre_impression_cuisine_10, t0.path AS path_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.sortable AS sortable_16, t0.produit_categorie_id AS produit_categorie_id_17 FROM produit t0 INNER JOIN produit_planning ON t0.id = produit_planning.produit_id WHERE produit_planning.planning_id = 2629;

SELECT
  p0_.id AS id_0,
  p0_.libelle AS libelle_1,
  p0_.description AS description_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.sortable AS sortable_7,
  p0_.camion_id AS camion_id_8
FROM
  produit_categorie p0_
WHERE
  p0_.camion_id = ?
ORDER BY
  p0_.sortable ASC

SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.description AS description_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.sortable AS sortable_7, p0_.camion_id AS camion_id_8 FROM produit_categorie p0_ WHERE p0_.camion_id = 1 ORDER BY p0_.sortable ASC;