Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.ordre AS ordre_1,
  p0_.ordre_general AS ordre_general_2,
  p0_.ordre_brouillon AS ordre_brouillon_3,
  p0_.visible AS visible_4,
  p0_.is_page AS is_page_5,
  p0_.created AS created_6,
  p0_.updated AS updated_7,
  p0_.published AS published_8,
  p0_.template AS template_9,
  p0_.titre AS titre_10,
  p0_.titre_brouillon AS titre_brouillon_11,
  p0_.slug AS slug_12,
  p0_.body_id AS body_id_13,
  p0_.meta_title AS meta_title_14,
  p0_.meta_keyword AS meta_keyword_15,
  p0_.meta_description AS meta_description_16,
  p0_.introduction AS introduction_17,
  p0_.contenu AS contenu_18,
  p0_.type AS type_19,
  p0_.url AS url_20,
  p0_.url_brouillon AS url_brouillon_21,
  p0_.image_name AS image_name_22,
  p0_.image_updated_at AS image_updated_at_23,
  p0_.image_name_brouillon AS image_name_brouillon_24,
  p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25,
  p0_.parent_id AS parent_id_26
FROM
  page p0_
WHERE
  p0_.visible = ?
  AND p0_.type = ?
ORDER BY
  p0_.titre ASC

SELECT p0_.id AS id_0, p0_.ordre AS ordre_1, p0_.ordre_general AS ordre_general_2, p0_.ordre_brouillon AS ordre_brouillon_3, p0_.visible AS visible_4, p0_.is_page AS is_page_5, p0_.created AS created_6, p0_.updated AS updated_7, p0_.published AS published_8, p0_.template AS template_9, p0_.titre AS titre_10, p0_.titre_brouillon AS titre_brouillon_11, p0_.slug AS slug_12, p0_.body_id AS body_id_13, p0_.meta_title AS meta_title_14, p0_.meta_keyword AS meta_keyword_15, p0_.meta_description AS meta_description_16, p0_.introduction AS introduction_17, p0_.contenu AS contenu_18, p0_.type AS type_19, p0_.url AS url_20, p0_.url_brouillon AS url_brouillon_21, p0_.image_name AS image_name_22, p0_.image_updated_at AS image_updated_at_23, p0_.image_name_brouillon AS image_name_brouillon_24, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_25, p0_.parent_id AS parent_id_26 FROM page p0_ WHERE p0_.visible = 1 AND p0_.type = 'page' ORDER BY p0_.titre ASC;

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.valeur AS valeur_3,
  t0.format AS format_4,
  t0.commentaire AS commentaire_5
FROM
  parametre t0

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.valeur AS valeur_3, t0.format AS format_4, t0.commentaire AS commentaire_5 FROM parametre t0;

SELECT
  l0_.image_updated_at AS image_updated_at_0,
  l0_.image2_updated_at AS image2_updated_at_1,
  l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2,
  l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3,
  l0_.id AS id_4,
  l0_.visible AS visible_5,
  l0_.archive AS archive_6,
  l0_.banniere AS banniere_7,
  l0_.created AS created_8,
  l0_.updated AS updated_9,
  l0_.color AS color_10,
  l0_.redirection AS redirection_11,
  l0_.titre AS titre_12,
  l0_.introduction AS introduction_13,
  l0_.contenu AS contenu_14,
  l0_.slug AS slug_15,
  l0_.banniere_titre AS banniere_titre_16,
  l0_.banniere_soustitre AS banniere_soustitre_17,
  l0_.banniere_color AS banniere_color_18,
  l0_.banniere_color_bouton AS banniere_color_bouton_19,
  l0_.banniere_text_bouton AS banniere_text_bouton_20,
  l0_.meta_title AS meta_title_21,
  l0_.meta_keyword AS meta_keyword_22,
  l0_.meta_description AS meta_description_23,
  l0_.image_name AS image_name_24,
  l0_.image_alt AS image_alt_25,
  l0_.image2_name AS image2_name_26,
  l0_.image_banniere_name AS image_banniere_name_27,
  l0_.image_banniere_illu_name AS image_banniere_illu_name_28
FROM
  listing l0_
WHERE
  l0_.visible = ?
ORDER BY
  l0_.titre ASC

SELECT l0_.image_updated_at AS image_updated_at_0, l0_.image2_updated_at AS image2_updated_at_1, l0_.image_bannniere_updated_at AS image_bannniere_updated_at_2, l0_.image_bannniere_illu_updated_at AS image_bannniere_illu_updated_at_3, l0_.id AS id_4, l0_.visible AS visible_5, l0_.archive AS archive_6, l0_.banniere AS banniere_7, l0_.created AS created_8, l0_.updated AS updated_9, l0_.color AS color_10, l0_.redirection AS redirection_11, l0_.titre AS titre_12, l0_.introduction AS introduction_13, l0_.contenu AS contenu_14, l0_.slug AS slug_15, l0_.banniere_titre AS banniere_titre_16, l0_.banniere_soustitre AS banniere_soustitre_17, l0_.banniere_color AS banniere_color_18, l0_.banniere_color_bouton AS banniere_color_bouton_19, l0_.banniere_text_bouton AS banniere_text_bouton_20, l0_.meta_title AS meta_title_21, l0_.meta_keyword AS meta_keyword_22, l0_.meta_description AS meta_description_23, l0_.image_name AS image_name_24, l0_.image_alt AS image_alt_25, l0_.image2_name AS image2_name_26, l0_.image_banniere_name AS image_banniere_name_27, l0_.image_banniere_illu_name AS image_banniere_illu_name_28 FROM listing l0_ WHERE l0_.visible = 1 ORDER BY l0_.titre ASC;

SELECT
  a0_.id AS id_0,
  a0_.created AS created_1,
  a0_.review_id AS review_id_2,
  a0_.review_product_id AS review_product_id_3,
  a0_.review_date AS review_date_4,
  a0_.nom AS nom_5,
  a0_.prenom AS prenom_6,
  a0_.note AS note_7,
  a0_.commentaire AS commentaire_8,
  a0_.reponses AS reponses_9,
  a0_.produit_id AS produit_id_10,
  a0_.commande_id AS commande_id_11
FROM
  avis_verifies a0_
WHERE
  a0_.produit_id IS NULL
ORDER BY
  a0_.review_date DESC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.created AS created_1, a0_.review_id AS review_id_2, a0_.review_product_id AS review_product_id_3, a0_.review_date AS review_date_4, a0_.nom AS nom_5, a0_.prenom AS prenom_6, a0_.note AS note_7, a0_.commentaire AS commentaire_8, a0_.reponses AS reponses_9, a0_.produit_id AS produit_id_10, a0_.commande_id AS commande_id_11 FROM avis_verifies a0_ WHERE a0_.produit_id IS NULL ORDER BY a0_.review_date DESC LIMIT 20;

SELECT
  t0_.variable AS variable_0,
  t1_.variable AS variable_1,
  t1_.rubrique AS rubrique_2
FROM
  traduction_valeur t0_
  INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id
WHERE
  t0_.locale = ?

SELECT t0_.variable AS variable_0, t1_.variable AS variable_1, t1_.rubrique AS rubrique_2 FROM traduction_valeur t0_ INNER JOIN traduction t1_ ON t0_.traduction_id = t1_.id WHERE t0_.locale = 'fr';

SELECT
  p0_.id AS id_0,
  p0_.created AS created_1,
  p0_.visible AS visible_2,
  p0_.newsletter AS newsletter_3,
  p0_.date_debut AS date_debut_4,
  p0_.date_fin AS date_fin_5,
  p0_.url AS url_6,
  p0_.titre AS titre_7,
  p0_.contenu AS contenu_8
FROM
  popup p0_
WHERE
  p0_.visible = ?
  AND (
    (
      p0_.date_fin >= ?
      OR p0_.date_fin IS NULL
    )
  )
  AND (
    (
      p0_.date_debut <= ?
      OR p0_.date_debut IS NULL
    )
  )
ORDER BY
  p0_.date_debut DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.visible AS visible_2, p0_.newsletter AS newsletter_3, p0_.date_debut AS date_debut_4, p0_.date_fin AS date_fin_5, p0_.url AS url_6, p0_.titre AS titre_7, p0_.contenu AS contenu_8 FROM popup p0_ WHERE p0_.visible = 1 AND ((p0_.date_fin >= '2026-09-24 18:48:53' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 18:48:53' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

SELECT
  p0_.created AS created_0,
  p0_.updated AS updated_1,
  p0_.id AS id_2,
  p0_.visible AS visible_3,
  p0_.archive AS archive_4,
  p0_.exclude_columbus AS exclude_columbus_5,
  p0_.nouveau AS nouveau_6,
  p0_.precommande AS precommande_7,
  p0_.precommande_date AS precommande_date_8,
  p0_.offre_speciale AS offre_speciale_9,
  p0_.cadeau AS cadeau_10,
  p0_.goodie AS goodie_11,
  p0_.declinaison AS declinaison_12,
  p0_.declinaison_principale AS declinaison_principale_13,
  p0_.reference AS reference_14,
  p0_.titre AS titre_15,
  p0_.titre_brouillon AS titre_brouillon_16,
  p0_.contenu AS contenu_17,
  p0_.contenu_brouillon AS contenu_brouillon_18,
  p0_.contenu2 AS contenu2_19,
  p0_.contenu2_brouillon AS contenu2_brouillon_20,
  p0_.slug AS slug_21,
  p0_.prix_achat_ht AS prix_achat_ht_22,
  p0_.montantHT AS montantHT_23,
  p0_.montantTTC AS montantTTC_24,
  p0_.montantActuelTTC AS montantActuelTTC_25,
  p0_.tva AS tva_26,
  p0_.stock AS stock_27,
  p0_.alerte_stock AS alerte_stock_28,
  p0_.stock_emaplacement AS stock_emaplacement_29,
  p0_.poids AS poids_30,
  p0_.recherche_keyword AS recherche_keyword_31,
  p0_.recherche_slug AS recherche_slug_32,
  p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33,
  p0_.produits_associes AS produits_associes_34,
  p0_.meta_title AS meta_title_35,
  p0_.meta_keyword AS meta_keyword_36,
  p0_.meta_description AS meta_description_37,
  p0_.note_avis AS note_avis_38,
  p0_.nb_avis AS nb_avis_39,
  p0_.image_panorama_name AS image_panorama_name_40,
  p0_.image_panorama_updated_at AS image_panorama_updated_at_41,
  p0_.image_portrait_name AS image_portrait_name_42,
  p0_.image_portrait_updated_at AS image_portrait_updated_at_43,
  p0_.image_name AS image_name_44,
  p0_.image_updated_at AS image_updated_at_45,
  p0_.image_alt AS image_alt_46,
  p0_.image_name_brouillon AS image_name_brouillon_47,
  p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48,
  p0_.total_ca AS total_ca_49,
  p0_.count_commande AS count_commande_50,
  p0_.is_customizable AS is_customizable_51,
  p0_.parent_id AS parent_id_52
FROM
  produit p0_
WHERE
  p0_.slug = ?

SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, p0_.parent_id AS parent_id_52 FROM produit p0_ WHERE p0_.slug = 'boite-a-musique-bebe-chien-marron-et-vert-20-cm';