Symfony Profiler

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
  c0_.id AS id_0
FROM
  categorie c0_
WHERE
  c0_.show_in_search = ?
  AND c0_.system = ?
  AND c0_.auto = ?

SELECT c0_.id AS id_0 FROM categorie c0_ WHERE c0_.show_in_search = 1 AND c0_.system = 0 AND c0_.auto = 0;

SELECT
  DISTINCT c0_.id AS id_0
FROM
  listing l1_
  INNER JOIN module_listing_link m2_ ON (m2_.listing_id = l1_.id)
  INNER JOIN module m3_ ON m2_.module_id = m3_.id
  INNER JOIN listing_categorie l4_ ON l1_.id = l4_.listing_id
  INNER JOIN categorie c0_ ON c0_.id = l4_.categorie_id
WHERE
  m3_.id = ?
  AND l1_.visible = ?
  AND c0_.system = ?
  AND c0_.auto = ?

SELECT DISTINCT c0_.id AS id_0 FROM listing l1_ INNER JOIN module_listing_link m2_ ON (m2_.listing_id = l1_.id) INNER JOIN module m3_ ON m2_.module_id = m3_.id INNER JOIN listing_categorie l4_ ON l1_.id = l4_.listing_id INNER JOIN categorie c0_ ON c0_.id = l4_.categorie_id WHERE m3_.id = 1191 AND l1_.visible = 1 AND c0_.system = 0 AND c0_.auto = 0;

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.id IN (?)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id IN (578);

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.id IN (?)

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id IN (110);

SELECT
  t0.created AS created_1,
  t0.updated AS updated_2,
  t0.id AS id_3,
  t0.visible AS visible_4,
  t0.archive AS archive_5,
  t0.exclude_columbus AS exclude_columbus_6,
  t0.nouveau AS nouveau_7,
  t0.precommande AS precommande_8,
  t0.precommande_date AS precommande_date_9,
  t0.offre_speciale AS offre_speciale_10,
  t0.cadeau AS cadeau_11,
  t0.goodie AS goodie_12,
  t0.declinaison AS declinaison_13,
  t0.declinaison_principale AS declinaison_principale_14,
  t0.reference AS reference_15,
  t0.titre AS titre_16,
  t0.titre_brouillon AS titre_brouillon_17,
  t0.contenu AS contenu_18,
  t0.contenu_brouillon AS contenu_brouillon_19,
  t0.contenu2 AS contenu2_20,
  t0.contenu2_brouillon AS contenu2_brouillon_21,
  t0.slug AS slug_22,
  t0.prix_achat_ht AS prix_achat_ht_23,
  t0.montantHT AS montantHT_24,
  t0.montantTTC AS montantTTC_25,
  t0.montantActuelTTC AS montantActuelTTC_26,
  t0.tva AS tva_27,
  t0.stock AS stock_28,
  t0.alerte_stock AS alerte_stock_29,
  t0.stock_emaplacement AS stock_emaplacement_30,
  t0.poids AS poids_31,
  t0.recherche_keyword AS recherche_keyword_32,
  t0.recherche_slug AS recherche_slug_33,
  t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34,
  t0.produits_associes AS produits_associes_35,
  t0.meta_title AS meta_title_36,
  t0.meta_keyword AS meta_keyword_37,
  t0.meta_description AS meta_description_38,
  t0.note_avis AS note_avis_39,
  t0.nb_avis AS nb_avis_40,
  t0.image_panorama_name AS image_panorama_name_41,
  t0.image_panorama_updated_at AS image_panorama_updated_at_42,
  t0.image_portrait_name AS image_portrait_name_43,
  t0.image_portrait_updated_at AS image_portrait_updated_at_44,
  t0.image_name AS image_name_45,
  t0.image_updated_at AS image_updated_at_46,
  t0.image_alt AS image_alt_47,
  t0.image_name_brouillon AS image_name_brouillon_48,
  t0.image_updated_at_brouillon AS image_updated_at_brouillon_49,
  t0.total_ca AS total_ca_50,
  t0.count_commande AS count_commande_51,
  t0.is_customizable AS is_customizable_52,
  t0.parent_id AS parent_id_53
FROM
  produit t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.created AS created_1, t0.updated AS updated_2, t0.id AS id_3, t0.visible AS visible_4, t0.archive AS archive_5, t0.exclude_columbus AS exclude_columbus_6, t0.nouveau AS nouveau_7, t0.precommande AS precommande_8, t0.precommande_date AS precommande_date_9, t0.offre_speciale AS offre_speciale_10, t0.cadeau AS cadeau_11, t0.goodie AS goodie_12, t0.declinaison AS declinaison_13, t0.declinaison_principale AS declinaison_principale_14, t0.reference AS reference_15, t0.titre AS titre_16, t0.titre_brouillon AS titre_brouillon_17, t0.contenu AS contenu_18, t0.contenu_brouillon AS contenu_brouillon_19, t0.contenu2 AS contenu2_20, t0.contenu2_brouillon AS contenu2_brouillon_21, t0.slug AS slug_22, t0.prix_achat_ht AS prix_achat_ht_23, t0.montantHT AS montantHT_24, t0.montantTTC AS montantTTC_25, t0.montantActuelTTC AS montantActuelTTC_26, t0.tva AS tva_27, t0.stock AS stock_28, t0.alerte_stock AS alerte_stock_29, t0.stock_emaplacement AS stock_emaplacement_30, t0.poids AS poids_31, t0.recherche_keyword AS recherche_keyword_32, t0.recherche_slug AS recherche_slug_33, t0.recherche_carac_attr_slug AS recherche_carac_attr_slug_34, t0.produits_associes AS produits_associes_35, t0.meta_title AS meta_title_36, t0.meta_keyword AS meta_keyword_37, t0.meta_description AS meta_description_38, t0.note_avis AS note_avis_39, t0.nb_avis AS nb_avis_40, t0.image_panorama_name AS image_panorama_name_41, t0.image_panorama_updated_at AS image_panorama_updated_at_42, t0.image_portrait_name AS image_portrait_name_43, t0.image_portrait_updated_at AS image_portrait_updated_at_44, t0.image_name AS image_name_45, t0.image_updated_at AS image_updated_at_46, t0.image_alt AS image_alt_47, t0.image_name_brouillon AS image_name_brouillon_48, t0.image_updated_at_brouillon AS image_updated_at_brouillon_49, t0.total_ca AS total_ca_50, t0.count_commande AS count_commande_51, t0.is_customizable AS is_customizable_52, t0.parent_id AS parent_id_53 FROM produit t0 WHERE t0.id IN (106, 110, 575, 578, 579, 71, 72, 81, 82, 83, 101, 386, 793, 794, 795, 796, 797, 798, 799, 800, 801, 802, 803, 804);

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

SELECT
  t0.id AS id_1,
  t0.visible AS visible_2,
  t0.created AS created_3,
  t0.updated AS updated_4,
  t0.titre AS titre_5,
  t0.ancre AS ancre_6,
  t0.url AS url_7,
  t0.image_name AS image_name_8,
  t0.image_updated_at AS image_updated_at_9,
  t0.image_alt AS image_alt_10
FROM
  benefice t0
WHERE
  t0.id IN (?, ?, ?)

SELECT t0.id AS id_1, t0.visible AS visible_2, t0.created AS created_3, t0.updated AS updated_4, t0.titre AS titre_5, t0.ancre AS ancre_6, t0.url AS url_7, t0.image_name AS image_name_8, t0.image_updated_at AS image_updated_at_9, t0.image_alt AS image_alt_10 FROM benefice t0 WHERE t0.id IN (1, 2, 3);

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.ordre AS ordre_3,
  t0.color AS color_4,
  t0.image_name AS image_name_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.caracteristique_id AS caracteristique_id_7
FROM
  caracteristique_valeur t0
WHERE
  t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.ordre AS ordre_3, t0.color AS color_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.caracteristique_id AS caracteristique_id_7 FROM caracteristique_valeur t0 WHERE t0.id IN (11, 26, 6, 109, 110, 111, 112, 113, 114, 134, 135, 140);

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.groupe AS groupe_3,
  t0.ordre AS ordre_4,
  t0.image_name AS image_name_5,
  t0.image_updated_at AS image_updated_at_6,
  t0.attribut_id AS attribut_id_7
FROM
  attribut_valeur t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.groupe AS groupe_3, t0.ordre AS ordre_4, t0.image_name AS image_name_5, t0.image_updated_at AS image_updated_at_6, t0.attribut_id AS attribut_id_7 FROM attribut_valeur t0 WHERE t0.id IN (1, 15, 17, 20, 22, 23, 24, 25, 29, 3, 31, 32, 34, 35, 40, 41, 5, 52, 54, 56, 6, 7, 8, 46, 47, 48, 49);