Symfony Profiler

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
  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
  m0_.id AS id_0,
  m0_.date_debut AS date_debut_1,
  m0_.date_fin AS date_fin_2,
  m0_.visible AS visible_3,
  m0_.hide_desktop AS hide_desktop_4,
  m0_.hide_tablet AS hide_tablet_5,
  m0_.hide_mobile AS hide_mobile_6,
  m0_.created AS created_7,
  m0_.updated AS updated_8,
  m0_.type AS type_9,
  m0_.class_name AS class_name_10,
  m0_.univer AS univer_11,
  m0_.nom AS nom_12,
  m0_.titre AS titre_13,
  m0_.soustitre AS soustitre_14,
  m0_.url AS url_15,
  m0_.color AS color_16,
  m0_.ancre AS ancre_17,
  m0_.contenu AS contenu_18,
  m0_.image_name AS image_name_19,
  m0_.image_updated_at AS image_updated_at_20,
  m0_.image_alt AS image_alt_21,
  m0_.ordre AS ordre_22,
  m0_.version AS version_23,
  m0_.page_id AS page_id_24,
  m0_.produit_id AS produit_id_25,
  m0_.module_page_id AS module_page_id_26,
  m0_.module_categorie_id AS module_categorie_id_27,
  m0_.module_produit_id AS module_produit_id_28,
  m0_.module_caracteristique_id AS module_caracteristique_id_29,
  m0_.module_attribut_id AS module_attribut_id_30
FROM
  module m0_
WHERE
  m0_.page_id = ?
  AND m0_.version = ?
ORDER BY
  m0_.ordre ASC,
  m0_.titre ASC

SELECT m0_.id AS id_0, m0_.date_debut AS date_debut_1, m0_.date_fin AS date_fin_2, m0_.visible AS visible_3, m0_.hide_desktop AS hide_desktop_4, m0_.hide_tablet AS hide_tablet_5, m0_.hide_mobile AS hide_mobile_6, m0_.created AS created_7, m0_.updated AS updated_8, m0_.type AS type_9, m0_.class_name AS class_name_10, m0_.univer AS univer_11, m0_.nom AS nom_12, m0_.titre AS titre_13, m0_.soustitre AS soustitre_14, m0_.url AS url_15, m0_.color AS color_16, m0_.ancre AS ancre_17, m0_.contenu AS contenu_18, m0_.image_name AS image_name_19, m0_.image_updated_at AS image_updated_at_20, m0_.image_alt AS image_alt_21, m0_.ordre AS ordre_22, m0_.version AS version_23, m0_.page_id AS page_id_24, m0_.produit_id AS produit_id_25, m0_.module_page_id AS module_page_id_26, m0_.module_categorie_id AS module_categorie_id_27, m0_.module_produit_id AS module_produit_id_28, m0_.module_caracteristique_id AS module_caracteristique_id_29, m0_.module_attribut_id AS module_attribut_id_30 FROM module m0_ WHERE m0_.page_id = 25 AND m0_.version = 'production' ORDER BY m0_.ordre ASC, m0_.titre ASC;

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
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.visible AS visible_4,
  t0.hide_desktop AS hide_desktop_5,
  t0.hide_tablet AS hide_tablet_6,
  t0.hide_mobile AS hide_mobile_7,
  t0.created AS created_8,
  t0.updated AS updated_9,
  t0.type AS type_10,
  t0.class_name AS class_name_11,
  t0.univer AS univer_12,
  t0.nom AS nom_13,
  t0.titre AS titre_14,
  t0.soustitre AS soustitre_15,
  t0.url AS url_16,
  t0.color AS color_17,
  t0.ancre AS ancre_18,
  t0.contenu AS contenu_19,
  t0.image_name AS image_name_20,
  t0.image_updated_at AS image_updated_at_21,
  t0.image_alt AS image_alt_22,
  t0.ordre AS ordre_23,
  t0.version AS version_24,
  t0.page_id AS page_id_25,
  t0.produit_id AS produit_id_26,
  t0.module_page_id AS module_page_id_27,
  t0.module_categorie_id AS module_categorie_id_28,
  t0.module_produit_id AS module_produit_id_29,
  t0.module_caracteristique_id AS module_caracteristique_id_30,
  t0.module_attribut_id AS module_attribut_id_31
FROM
  module t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.visible AS visible_4, t0.hide_desktop AS hide_desktop_5, t0.hide_tablet AS hide_tablet_6, t0.hide_mobile AS hide_mobile_7, t0.created AS created_8, t0.updated AS updated_9, t0.type AS type_10, t0.class_name AS class_name_11, t0.univer AS univer_12, t0.nom AS nom_13, t0.titre AS titre_14, t0.soustitre AS soustitre_15, t0.url AS url_16, t0.color AS color_17, t0.ancre AS ancre_18, t0.contenu AS contenu_19, t0.image_name AS image_name_20, t0.image_updated_at AS image_updated_at_21, t0.image_alt AS image_alt_22, t0.ordre AS ordre_23, t0.version AS version_24, t0.page_id AS page_id_25, t0.produit_id AS produit_id_26, t0.module_page_id AS module_page_id_27, t0.module_categorie_id AS module_categorie_id_28, t0.module_produit_id AS module_produit_id_29, t0.module_caracteristique_id AS module_caracteristique_id_30, t0.module_attribut_id AS module_attribut_id_31 FROM module t0 WHERE t0.page_id = 25 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.ordre_general AS ordre_general_3,
  t0.ordre_brouillon AS ordre_brouillon_4,
  t0.visible AS visible_5,
  t0.is_page AS is_page_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.published AS published_9,
  t0.template AS template_10,
  t0.titre AS titre_11,
  t0.titre_brouillon AS titre_brouillon_12,
  t0.slug AS slug_13,
  t0.body_id AS body_id_14,
  t0.meta_title AS meta_title_15,
  t0.meta_keyword AS meta_keyword_16,
  t0.meta_description AS meta_description_17,
  t0.introduction AS introduction_18,
  t0.contenu AS contenu_19,
  t0.type AS type_20,
  t0.url AS url_21,
  t0.url_brouillon AS url_brouillon_22,
  t0.image_name AS image_name_23,
  t0.image_updated_at AS image_updated_at_24,
  t0.image_name_brouillon AS image_name_brouillon_25,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_26,
  t0.parent_id AS parent_id_27
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.ordre_general AS ordre_general_3, t0.ordre_brouillon AS ordre_brouillon_4, t0.visible AS visible_5, t0.is_page AS is_page_6, t0.created AS created_7, t0.updated AS updated_8, t0.published AS published_9, t0.template AS template_10, t0.titre AS titre_11, t0.titre_brouillon AS titre_brouillon_12, t0.slug AS slug_13, t0.body_id AS body_id_14, t0.meta_title AS meta_title_15, t0.meta_keyword AS meta_keyword_16, t0.meta_description AS meta_description_17, t0.introduction AS introduction_18, t0.contenu AS contenu_19, t0.type AS type_20, t0.url AS url_21, t0.url_brouillon AS url_brouillon_22, t0.image_name AS image_name_23, t0.image_updated_at AS image_updated_at_24, t0.image_name_brouillon AS image_name_brouillon_25, t0.image_updated_at_brouillon AS image_updated_at_brouillon_26, t0.parent_id AS parent_id_27 FROM page t0 WHERE t0.slug = 'mentions-legales' 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 = ?
  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 17:03:01' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:03:01' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

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
  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
  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
WHERE
  t0.variable = ?
LIMIT
  1

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 WHERE t0.variable = 'twitter-compte' LIMIT 1;