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 17:35:45' OR p0_.date_fin IS NULL)) AND ((p0_.date_debut <= '2026-09-24 17:35:45' OR p0_.date_debut IS NULL)) ORDER BY p0_.date_debut DESC LIMIT 1;

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 = 1 ORDER BY t0.ordre ASC;

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_.visible = ?
  AND (
    (
      p0_.cadeau IS NULL
      OR p0_.cadeau = 0
    )
  )
  AND (
    (
      p0_.declinaison IS NULL
      OR p0_.declinaison = 0
    )
  )
  AND p0_.montantActuelTTC IS NOT NULL
ORDER BY
  p0_.montantActuelTTC ASC
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_.visible = 1 AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND p0_.montantActuelTTC IS NOT NULL ORDER BY p0_.montantActuelTTC ASC 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_.visible = ?
  AND (
    (
      p0_.cadeau IS NULL
      OR p0_.cadeau = 0
    )
  )
  AND (
    (
      p0_.declinaison IS NULL
      OR p0_.declinaison = 0
    )
  )
  AND p0_.montantActuelTTC IS NOT NULL
  AND p0_.montantActuelTTC <= 500
ORDER BY
  p0_.montantActuelTTC 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_.visible = 1 AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.declinaison IS NULL OR p0_.declinaison = 0)) AND p0_.montantActuelTTC IS NOT NULL AND p0_.montantActuelTTC <= 500 ORDER BY p0_.montantActuelTTC DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.created AS created_1,
  c0_.updated AS updated_2,
  c0_.color AS color_3,
  c0_.with_associated_page AS with_associated_page_4,
  c0_.system AS system_5,
  c0_.auto AS auto_6,
  c0_.show_in_search AS show_in_search_7,
  c0_.total_ca AS total_ca_8,
  c0_.count_commande AS count_commande_9,
  c0_.titre AS titre_10,
  c0_.slug AS slug_11
FROM
  categorie c0_
WHERE
  c0_.system = ?
  AND c0_.auto = ?
  AND c0_.show_in_search = ?
  AND c0_.slug NOT IN (?, ?, ?)
ORDER BY
  c0_.titre ASC

SELECT c0_.id AS id_0, c0_.created AS created_1, c0_.updated AS updated_2, c0_.color AS color_3, c0_.with_associated_page AS with_associated_page_4, c0_.system AS system_5, c0_.auto AS auto_6, c0_.show_in_search AS show_in_search_7, c0_.total_ca AS total_ca_8, c0_.count_commande AS count_commande_9, c0_.titre AS titre_10, c0_.slug AS slug_11 FROM categorie c0_ WHERE c0_.system = 0 AND c0_.auto = 0 AND c0_.show_in_search = 1 AND c0_.slug NOT IN ('interne', 'automatique', 'systeme') ORDER BY c0_.titre ASC;

SELECT
  c0_.id AS id_0,
  c0_.valeur AS valeur_1,
  c0_.ordre AS ordre_2,
  c0_.color AS color_3,
  c0_.image_name AS image_name_4,
  c0_.image_updated_at AS image_updated_at_5,
  c0_.caracteristique_id AS caracteristique_id_6
FROM
  caracteristique_valeur c0_
WHERE
  c0_.caracteristique_id = ?
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.valeur AS valeur_1, c0_.ordre AS ordre_2, c0_.color AS color_3, c0_.image_name AS image_name_4, c0_.image_updated_at AS image_updated_at_5, c0_.caracteristique_id AS caracteristique_id_6 FROM caracteristique_valeur c0_ WHERE c0_.caracteristique_id = 3 ORDER BY c0_.ordre ASC;

SELECT
  i0_.id AS id_0,
  i0_.created AS created_1,
  i0_.updated AS updated_2,
  i0_.visible AS visible_3,
  i0_.id_instagram AS id_instagram_4,
  i0_.url_instagram AS url_instagram_5,
  i0_.titre AS titre_6,
  i0_.slug AS slug_7,
  i0_.image_name AS image_name_8,
  i0_.image_updated_at AS image_updated_at_9,
  i0_.image_alt AS image_alt_10
FROM
  instashop i0_
WHERE
  i0_.visible = ?
ORDER BY
  i0_.created DESC
LIMIT
  8

SELECT i0_.id AS id_0, i0_.created AS created_1, i0_.updated AS updated_2, i0_.visible AS visible_3, i0_.id_instagram AS id_instagram_4, i0_.url_instagram AS url_instagram_5, i0_.titre AS titre_6, i0_.slug AS slug_7, i0_.image_name AS image_name_8, i0_.image_updated_at AS image_updated_at_9, i0_.image_alt AS image_alt_10 FROM instashop i0_ WHERE i0_.visible = 1 ORDER BY i0_.created DESC LIMIT 8;

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 = 1 AND m0_.version = 'production' ORDER BY m0_.ordre ASC, m0_.titre ASC;