Symfony Profiler

SELECT
  p0_.date_creation AS date_creation_0,
  p0_.date_maj AS date_maj_1,
  p0_.id AS id_2,
  p0_.nom AS nom_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.prix_unitaire AS prix_unitaire_6,
  p0_.prix_kg_l AS prix_kg_l_7,
  p0_.poids AS poids_8,
  p0_.display AS display_9,
  p0_.is_poids AS is_poids_10,
  p0_.photo AS photo_11,
  p0_.unite_mesure AS unite_mesure_12,
  p0_.nb_personne AS nb_personne_13,
  p0_.categorie_id AS categorie_id_14,
  p0_.type_id AS type_id_15,
  p0_.origine_id AS origine_id_16,
  p0_.lait_id AS lait_id_17,
  p0_.lait_traitement_id AS lait_traitement_id_18,
  p0_.theme_id AS theme_id_19
FROM
  produit p0_
WHERE
  p0_.display = 1
GROUP BY
  p0_.nb_personne
ORDER BY
  p0_.nb_personne ASC

SELECT p0_.date_creation AS date_creation_0, p0_.date_maj AS date_maj_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.prix_unitaire AS prix_unitaire_6, p0_.prix_kg_l AS prix_kg_l_7, p0_.poids AS poids_8, p0_.display AS display_9, p0_.is_poids AS is_poids_10, p0_.photo AS photo_11, p0_.unite_mesure AS unite_mesure_12, p0_.nb_personne AS nb_personne_13, p0_.categorie_id AS categorie_id_14, p0_.type_id AS type_id_15, p0_.origine_id AS origine_id_16, p0_.lait_id AS lait_id_17, p0_.lait_traitement_id AS lait_traitement_id_18, p0_.theme_id AS theme_id_19 FROM produit p0_ WHERE p0_.display = 1 GROUP BY p0_.nb_personne ORDER BY p0_.nb_personne ASC;

SELECT
  p0_.date_creation AS date_creation_0,
  p0_.date_maj AS date_maj_1,
  p0_.id AS id_2,
  p0_.nom AS nom_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.prix_unitaire AS prix_unitaire_6,
  p0_.prix_kg_l AS prix_kg_l_7,
  p0_.poids AS poids_8,
  p0_.display AS display_9,
  p0_.is_poids AS is_poids_10,
  p0_.photo AS photo_11,
  p0_.unite_mesure AS unite_mesure_12,
  p0_.nb_personne AS nb_personne_13,
  p0_.categorie_id AS categorie_id_14,
  p0_.type_id AS type_id_15,
  p0_.origine_id AS origine_id_16,
  p0_.lait_id AS lait_id_17,
  p0_.lait_traitement_id AS lait_traitement_id_18,
  p0_.theme_id AS theme_id_19
FROM
  produit p0_
WHERE
  p0_.nb_personne IS NOT NULL
  AND p0_.display = 1
GROUP BY
  p0_.nb_personne
ORDER BY
  p0_.nb_personne ASC

SELECT p0_.date_creation AS date_creation_0, p0_.date_maj AS date_maj_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.prix_unitaire AS prix_unitaire_6, p0_.prix_kg_l AS prix_kg_l_7, p0_.poids AS poids_8, p0_.display AS display_9, p0_.is_poids AS is_poids_10, p0_.photo AS photo_11, p0_.unite_mesure AS unite_mesure_12, p0_.nb_personne AS nb_personne_13, p0_.categorie_id AS categorie_id_14, p0_.type_id AS type_id_15, p0_.origine_id AS origine_id_16, p0_.lait_id AS lait_id_17, p0_.lait_traitement_id AS lait_traitement_id_18, p0_.theme_id AS theme_id_19 FROM produit p0_ WHERE p0_.nb_personne IS NOT NULL AND p0_.display = 1 GROUP BY p0_.nb_personne ORDER BY p0_.nb_personne ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Fromages' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Crémerie' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Cidres' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Plateaux' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.display AS display_2
FROM
  categorie c0_
WHERE
  c0_.display = 1

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.display AS display_2 FROM categorie c0_ WHERE c0_.display = 1;

SELECT
  o0_.id AS id_0,
  o0_.nom AS nom_1,
  o0_.display AS display_2
FROM
  origine o0_
WHERE
  o0_.display = 1

SELECT o0_.id AS id_0, o0_.nom AS nom_1, o0_.display AS display_2 FROM origine o0_ WHERE o0_.display = 1;

SELECT
  l0_.id AS id_0,
  l0_.nom AS nom_1,
  l0_.display AS display_2
FROM
  lait l0_
WHERE
  l0_.display = 1

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.display AS display_2 FROM lait l0_ WHERE l0_.display = 1;

SELECT
  l0_.id AS id_0,
  l0_.nom AS nom_1,
  l0_.display AS display_2
FROM
  lait_traitement l0_
WHERE
  l0_.display = 1

SELECT l0_.id AS id_0, l0_.nom AS nom_1, l0_.display AS display_2 FROM lait_traitement l0_ WHERE l0_.display = 1;

SELECT
  p0_.date_creation AS date_creation_0,
  p0_.date_maj AS date_maj_1,
  p0_.id AS id_2,
  p0_.nom AS nom_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.prix_unitaire AS prix_unitaire_6,
  p0_.prix_kg_l AS prix_kg_l_7,
  p0_.poids AS poids_8,
  p0_.display AS display_9,
  p0_.is_poids AS is_poids_10,
  p0_.photo AS photo_11,
  p0_.unite_mesure AS unite_mesure_12,
  p0_.nb_personne AS nb_personne_13,
  COALESCE(
    SUM(p1_.nb_produit),
    0
  ) AS sclr_14,
  p0_.categorie_id AS categorie_id_15,
  p0_.type_id AS type_id_16,
  p0_.origine_id AS origine_id_17,
  p0_.lait_id AS lait_id_18,
  p0_.lait_traitement_id AS lait_traitement_id_19,
  p0_.theme_id AS theme_id_20
FROM
  produit p0_
  LEFT JOIN categorie c2_ ON p0_.categorie_id = c2_.id
  LEFT JOIN type t3_ ON p0_.type_id = t3_.id
  LEFT JOIN origine o4_ ON p0_.origine_id = o4_.id
  LEFT JOIN lait l5_ ON p0_.lait_id = l5_.id
  LEFT JOIN lait_traitement l6_ ON p0_.lait_traitement_id = l6_.id
  LEFT JOIN theme_plateau t7_ ON p0_.theme_id = t7_.id
  LEFT JOIN panier_produits p1_ ON p0_.id = p1_.id_produit_id
  LEFT JOIN panier p8_ ON p1_.id_panier_id = p8_.id
WHERE
  p0_.display = 1
GROUP BY
  p0_.nom
ORDER BY
  sclr_14 DESC,
  p0_.nom ASC
LIMIT
  12 OFFSET 12

SELECT p0_.date_creation AS date_creation_0, p0_.date_maj AS date_maj_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.prix_unitaire AS prix_unitaire_6, p0_.prix_kg_l AS prix_kg_l_7, p0_.poids AS poids_8, p0_.display AS display_9, p0_.is_poids AS is_poids_10, p0_.photo AS photo_11, p0_.unite_mesure AS unite_mesure_12, p0_.nb_personne AS nb_personne_13, COALESCE(SUM(p1_.nb_produit), 0) AS sclr_14, p0_.categorie_id AS categorie_id_15, p0_.type_id AS type_id_16, p0_.origine_id AS origine_id_17, p0_.lait_id AS lait_id_18, p0_.lait_traitement_id AS lait_traitement_id_19, p0_.theme_id AS theme_id_20 FROM produit p0_ LEFT JOIN categorie c2_ ON p0_.categorie_id = c2_.id LEFT JOIN type t3_ ON p0_.type_id = t3_.id LEFT JOIN origine o4_ ON p0_.origine_id = o4_.id LEFT JOIN lait l5_ ON p0_.lait_id = l5_.id LEFT JOIN lait_traitement l6_ ON p0_.lait_traitement_id = l6_.id LEFT JOIN theme_plateau t7_ ON p0_.theme_id = t7_.id LEFT JOIN panier_produits p1_ ON p0_.id = p1_.id_produit_id LEFT JOIN panier p8_ ON p1_.id_panier_id = p8_.id WHERE p0_.display = 1 GROUP BY p0_.nom ORDER BY sclr_14 DESC, p0_.nom ASC LIMIT 12 OFFSET 12;

SELECT
  t0.id AS id_1,
  t0.active AS active_2,
  t0.content AS content_3
FROM
  drive t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.active AS active_2, t0.content AS content_3 FROM drive t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Fromages' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Crémerie' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Cidres' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.display AS display_3
FROM
  categorie t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM categorie t0 WHERE t0.nom = 'Plateaux' LIMIT 1;

SELECT
  p0_.date_creation AS date_creation_0,
  p0_.date_maj AS date_maj_1,
  p0_.id AS id_2,
  p0_.nom AS nom_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.prix_unitaire AS prix_unitaire_6,
  p0_.prix_kg_l AS prix_kg_l_7,
  p0_.poids AS poids_8,
  p0_.display AS display_9,
  p0_.is_poids AS is_poids_10,
  p0_.photo AS photo_11,
  p0_.unite_mesure AS unite_mesure_12,
  p0_.nb_personne AS nb_personne_13,
  p0_.categorie_id AS categorie_id_14,
  p0_.type_id AS type_id_15,
  p0_.origine_id AS origine_id_16,
  p0_.lait_id AS lait_id_17,
  p0_.lait_traitement_id AS lait_traitement_id_18,
  p0_.theme_id AS theme_id_19
FROM
  produit p0_
WHERE
  p0_.nb_personne IS NOT NULL
  AND p0_.display = 1
GROUP BY
  p0_.nb_personne
ORDER BY
  p0_.nb_personne ASC

SELECT p0_.date_creation AS date_creation_0, p0_.date_maj AS date_maj_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.prix_unitaire AS prix_unitaire_6, p0_.prix_kg_l AS prix_kg_l_7, p0_.poids AS poids_8, p0_.display AS display_9, p0_.is_poids AS is_poids_10, p0_.photo AS photo_11, p0_.unite_mesure AS unite_mesure_12, p0_.nb_personne AS nb_personne_13, p0_.categorie_id AS categorie_id_14, p0_.type_id AS type_id_15, p0_.origine_id AS origine_id_16, p0_.lait_id AS lait_id_17, p0_.lait_traitement_id AS lait_traitement_id_18, p0_.theme_id AS theme_id_19 FROM produit p0_ WHERE p0_.nb_personne IS NOT NULL AND p0_.display = 1 GROUP BY p0_.nb_personne ORDER BY p0_.nb_personne ASC;

SELECT
  p0_.date_creation AS date_creation_0,
  p0_.date_maj AS date_maj_1,
  p0_.id AS id_2,
  p0_.nom AS nom_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.prix_unitaire AS prix_unitaire_6,
  p0_.prix_kg_l AS prix_kg_l_7,
  p0_.poids AS poids_8,
  p0_.display AS display_9,
  p0_.is_poids AS is_poids_10,
  p0_.photo AS photo_11,
  p0_.unite_mesure AS unite_mesure_12,
  p0_.nb_personne AS nb_personne_13,
  p0_.categorie_id AS categorie_id_14,
  p0_.type_id AS type_id_15,
  p0_.origine_id AS origine_id_16,
  p0_.lait_id AS lait_id_17,
  p0_.lait_traitement_id AS lait_traitement_id_18,
  p0_.theme_id AS theme_id_19
FROM
  produit p0_
  LEFT JOIN categorie c1_ ON p0_.categorie_id = c1_.id
  LEFT JOIN type t2_ ON p0_.type_id = t2_.id
  LEFT JOIN origine o3_ ON p0_.origine_id = o3_.id
  LEFT JOIN lait l4_ ON p0_.lait_id = l4_.id
  LEFT JOIN lait_traitement l5_ ON p0_.lait_traitement_id = l5_.id
  LEFT JOIN theme_plateau t6_ ON p0_.theme_id = t6_.id
WHERE
  p0_.display = 1

SELECT p0_.date_creation AS date_creation_0, p0_.date_maj AS date_maj_1, p0_.id AS id_2, p0_.nom AS nom_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.prix_unitaire AS prix_unitaire_6, p0_.prix_kg_l AS prix_kg_l_7, p0_.poids AS poids_8, p0_.display AS display_9, p0_.is_poids AS is_poids_10, p0_.photo AS photo_11, p0_.unite_mesure AS unite_mesure_12, p0_.nb_personne AS nb_personne_13, p0_.categorie_id AS categorie_id_14, p0_.type_id AS type_id_15, p0_.origine_id AS origine_id_16, p0_.lait_id AS lait_id_17, p0_.lait_traitement_id AS lait_traitement_id_18, p0_.theme_id AS theme_id_19 FROM produit p0_ LEFT JOIN categorie c1_ ON p0_.categorie_id = c1_.id LEFT JOIN type t2_ ON p0_.type_id = t2_.id LEFT JOIN origine o3_ ON p0_.origine_id = o3_.id LEFT JOIN lait l4_ ON p0_.lait_id = l4_.id LEFT JOIN lait_traitement l5_ ON p0_.lait_traitement_id = l5_.id LEFT JOIN theme_plateau t6_ ON p0_.theme_id = t6_.id WHERE p0_.display = 1;