Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = '/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'facebook' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'facebook' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'twitter' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'linkedin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'linkedin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'instagram' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'instagram' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'mailto' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'mailto' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'youtube' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'youtube' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'espace_pro' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = '/' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.text AS text_1,
  m0_.link AS link_2,
  m0_.image AS image_3,
  m0_.resume AS resume_4,
  m0_.texte_complet AS texte_complet_5,
  m0_.colonne AS colonne_6,
  m0_.position AS position_7,
  m0_.type AS type_8,
  m0_.link_type AS link_type_9,
  m0_.display_title AS display_title_10,
  m0_.is_only_for_subscriber AS is_only_for_subscriber_11,
  m0_.is_only_for_admin AS is_only_for_admin_12,
  m1_.id AS id_13,
  m1_.text AS text_14,
  m1_.link AS link_15,
  m1_.image AS image_16,
  m1_.resume AS resume_17,
  m1_.texte_complet AS texte_complet_18,
  m1_.colonne AS colonne_19,
  m1_.position AS position_20,
  m1_.type AS type_21,
  m1_.link_type AS link_type_22,
  m1_.display_title AS display_title_23,
  m1_.is_only_for_subscriber AS is_only_for_subscriber_24,
  m1_.is_only_for_admin AS is_only_for_admin_25,
  m2_.id AS id_26,
  m2_.text AS text_27,
  m2_.link AS link_28,
  m2_.image AS image_29,
  m2_.resume AS resume_30,
  m2_.texte_complet AS texte_complet_31,
  m2_.colonne AS colonne_32,
  m2_.position AS position_33,
  m2_.type AS type_34,
  m2_.link_type AS link_type_35,
  m2_.display_title AS display_title_36,
  m2_.is_only_for_subscriber AS is_only_for_subscriber_37,
  m2_.is_only_for_admin AS is_only_for_admin_38,
  m0_.parent_id AS parent_id_39,
  m1_.parent_id AS parent_id_40,
  m2_.parent_id AS parent_id_41
FROM
  menu m0_
  LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id
  LEFT JOIN menu m2_ ON m1_.id = m2_.parent_id
WHERE
  m0_.parent_id IS NULL
ORDER BY
  m0_.position ASC,
  m0_.text ASC,
  m1_.colonne ASC,
  m1_.position ASC,
  m2_.colonne ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.link AS link_2, m0_.image AS image_3, m0_.resume AS resume_4, m0_.texte_complet AS texte_complet_5, m0_.colonne AS colonne_6, m0_.position AS position_7, m0_.type AS type_8, m0_.link_type AS link_type_9, m0_.display_title AS display_title_10, m0_.is_only_for_subscriber AS is_only_for_subscriber_11, m0_.is_only_for_admin AS is_only_for_admin_12, m1_.id AS id_13, m1_.text AS text_14, m1_.link AS link_15, m1_.image AS image_16, m1_.resume AS resume_17, m1_.texte_complet AS texte_complet_18, m1_.colonne AS colonne_19, m1_.position AS position_20, m1_.type AS type_21, m1_.link_type AS link_type_22, m1_.display_title AS display_title_23, m1_.is_only_for_subscriber AS is_only_for_subscriber_24, m1_.is_only_for_admin AS is_only_for_admin_25, m2_.id AS id_26, m2_.text AS text_27, m2_.link AS link_28, m2_.image AS image_29, m2_.resume AS resume_30, m2_.texte_complet AS texte_complet_31, m2_.colonne AS colonne_32, m2_.position AS position_33, m2_.type AS type_34, m2_.link_type AS link_type_35, m2_.display_title AS display_title_36, m2_.is_only_for_subscriber AS is_only_for_subscriber_37, m2_.is_only_for_admin AS is_only_for_admin_38, m0_.parent_id AS parent_id_39, m1_.parent_id AS parent_id_40, m2_.parent_id AS parent_id_41 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m1_.id = m2_.parent_id WHERE m0_.parent_id IS NULL ORDER BY m0_.position ASC, m0_.text ASC, m1_.colonne ASC, m1_.position ASC, m2_.colonne ASC, m2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  t0.colonne ASC,
  t0.position ASC

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.parent_id IN (91, 124, 125, 81, 82, 83, 84, 85, 86, 87, 126, 88, 89, 92, 110, 49, 94, 106, 95, 113, 96, 97, 98, 99, 105, 104, 114, 100, 101, 102, 103, 115, 116, 117, 118, 119, 108, 109, 121, 122, 123, 41, 42, 43, 44, 45, 62, 63, 64, 76) ORDER BY t0.colonne ASC, t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.resume AS resume_3,
  t0.article AS article_4,
  t0.photo AS photo_5,
  t0.legende AS legende_6,
  t0.linkto AS linkto_7,
  t0.libellefile1 AS libellefile1_8,
  t0.urlfile1 AS urlfile1_9,
  t0.libellefile2 AS libellefile2_10,
  t0.urlfile2 AS urlfile2_11,
  t0.keywords AS keywords_12,
  t0.filename AS filename_13,
  t0.slug AS slug_14,
  t0.type AS type_15,
  t0.count AS count_16,
  t0.vignette AS vignette_17,
  t0.archived AS archived_18,
  t0.emailcontact AS emailcontact_19,
  t0.date AS date_20,
  t0.mise_en_avant AS mise_en_avant_21,
  t0.enabled AS enabled_22,
  t0.blocked AS blocked_23,
  t0.external_link AS external_link_24,
  t0.programmation_date AS programmation_date_25,
  t0.use_youtube_thumb AS use_youtube_thumb_26,
  t0.is_only_for_subscriber AS is_only_for_subscriber_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.category_id AS category_id_30
FROM
  article t0
WHERE
  t0.mise_en_avant = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.resume AS resume_3, t0.article AS article_4, t0.photo AS photo_5, t0.legende AS legende_6, t0.linkto AS linkto_7, t0.libellefile1 AS libellefile1_8, t0.urlfile1 AS urlfile1_9, t0.libellefile2 AS libellefile2_10, t0.urlfile2 AS urlfile2_11, t0.keywords AS keywords_12, t0.filename AS filename_13, t0.slug AS slug_14, t0.type AS type_15, t0.count AS count_16, t0.vignette AS vignette_17, t0.archived AS archived_18, t0.emailcontact AS emailcontact_19, t0.date AS date_20, t0.mise_en_avant AS mise_en_avant_21, t0.enabled AS enabled_22, t0.blocked AS blocked_23, t0.external_link AS external_link_24, t0.programmation_date AS programmation_date_25, t0.use_youtube_thumb AS use_youtube_thumb_26, t0.is_only_for_subscriber AS is_only_for_subscriber_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.category_id AS category_id_30 FROM article t0 WHERE t0.mise_en_avant = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
  LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id
  LEFT JOIN category c1_ ON c1_.id = a2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN category c4_ ON c3_.parent_id = c4_.id
WHERE
  (
    c1_.slug = ?
    OR c3_.slug = ?
    OR c4_.slug = ?
  )
  AND (
    a0_.mise_en_avant = 0
    OR a0_.mise_en_avant IS NULL
  )
  AND (
    (
      a0_.programmation_date IS NULL
      OR a0_.programmation_date <= ?
    )
  )
  AND a0_.enabled = 1
GROUP BY
  a0_.id

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN category c1_ ON c1_.id = a2_.category_id LEFT JOIN category c3_ ON c1_.parent_id = c3_.id LEFT JOIN category c4_ ON c3_.parent_id = c4_.id WHERE (c1_.slug = 'actualites' OR c3_.slug = 'actualites' OR c4_.slug = 'actualites') AND (a0_.mise_en_avant = 0 OR a0_.mise_en_avant IS NULL) AND ((a0_.programmation_date IS NULL OR a0_.programmation_date <= '2025-10-18 04:09:09')) AND a0_.enabled = 1 GROUP BY a0_.id;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.blocked AS blocked_1,
  a0_.date AS date_2,
  a0_.created_at AS created_at_3
FROM
  article a0_
  LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id
  LEFT JOIN category c1_ ON c1_.id = a2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN category c4_ ON c3_.parent_id = c4_.id
WHERE
  (
    c1_.slug = ?
    OR c3_.slug = ?
    OR c4_.slug = ?
  )
  AND (
    a0_.mise_en_avant = 0
    OR a0_.mise_en_avant IS NULL
  )
  AND (
    (
      a0_.programmation_date IS NULL
      OR a0_.programmation_date <= ?
    )
  )
  AND a0_.enabled = 1
GROUP BY
  a0_.id
ORDER BY
  a0_.blocked DESC,
  a0_.date DESC,
  a0_.created_at DESC
LIMIT
  3

SELECT DISTINCT a0_.id AS id_0, a0_.blocked AS blocked_1, a0_.date AS date_2, a0_.created_at AS created_at_3 FROM article a0_ LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN category c1_ ON c1_.id = a2_.category_id LEFT JOIN category c3_ ON c1_.parent_id = c3_.id LEFT JOIN category c4_ ON c3_.parent_id = c4_.id WHERE (c1_.slug = 'actualites' OR c3_.slug = 'actualites' OR c4_.slug = 'actualites') AND (a0_.mise_en_avant = 0 OR a0_.mise_en_avant IS NULL) AND ((a0_.programmation_date IS NULL OR a0_.programmation_date <= '2025-10-18 04:09:09')) AND a0_.enabled = 1 GROUP BY a0_.id ORDER BY a0_.blocked DESC, a0_.date DESC, a0_.created_at DESC LIMIT 3;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.resume AS resume_2,
  a0_.article AS article_3,
  a0_.photo AS photo_4,
  a0_.legende AS legende_5,
  a0_.linkto AS linkto_6,
  a0_.libellefile1 AS libellefile1_7,
  a0_.urlfile1 AS urlfile1_8,
  a0_.libellefile2 AS libellefile2_9,
  a0_.urlfile2 AS urlfile2_10,
  a0_.keywords AS keywords_11,
  a0_.filename AS filename_12,
  a0_.slug AS slug_13,
  a0_.type AS type_14,
  a0_.count AS count_15,
  a0_.vignette AS vignette_16,
  a0_.archived AS archived_17,
  a0_.emailcontact AS emailcontact_18,
  a0_.date AS date_19,
  a0_.mise_en_avant AS mise_en_avant_20,
  a0_.enabled AS enabled_21,
  a0_.blocked AS blocked_22,
  a0_.external_link AS external_link_23,
  a0_.programmation_date AS programmation_date_24,
  a0_.use_youtube_thumb AS use_youtube_thumb_25,
  a0_.is_only_for_subscriber AS is_only_for_subscriber_26,
  a0_.created_at AS created_at_27,
  a0_.updated_at AS updated_at_28,
  a0_.category_id AS category_id_29
FROM
  article a0_
  LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id
  LEFT JOIN category c1_ ON c1_.id = a2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN category c4_ ON c3_.parent_id = c4_.id
WHERE
  (
    c1_.slug = ?
    OR c3_.slug = ?
    OR c4_.slug = ?
  )
  AND (
    a0_.mise_en_avant = 0
    OR a0_.mise_en_avant IS NULL
  )
  AND (
    (
      a0_.programmation_date IS NULL
      OR a0_.programmation_date <= ?
    )
  )
  AND a0_.enabled = 1
  AND a0_.id IN (?, ?, ?)
GROUP BY
  a0_.id
ORDER BY
  a0_.blocked DESC,
  a0_.date DESC,
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.resume AS resume_2, a0_.article AS article_3, a0_.photo AS photo_4, a0_.legende AS legende_5, a0_.linkto AS linkto_6, a0_.libellefile1 AS libellefile1_7, a0_.urlfile1 AS urlfile1_8, a0_.libellefile2 AS libellefile2_9, a0_.urlfile2 AS urlfile2_10, a0_.keywords AS keywords_11, a0_.filename AS filename_12, a0_.slug AS slug_13, a0_.type AS type_14, a0_.count AS count_15, a0_.vignette AS vignette_16, a0_.archived AS archived_17, a0_.emailcontact AS emailcontact_18, a0_.date AS date_19, a0_.mise_en_avant AS mise_en_avant_20, a0_.enabled AS enabled_21, a0_.blocked AS blocked_22, a0_.external_link AS external_link_23, a0_.programmation_date AS programmation_date_24, a0_.use_youtube_thumb AS use_youtube_thumb_25, a0_.is_only_for_subscriber AS is_only_for_subscriber_26, a0_.created_at AS created_at_27, a0_.updated_at AS updated_at_28, a0_.category_id AS category_id_29 FROM article a0_ LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN category c1_ ON c1_.id = a2_.category_id LEFT JOIN category c3_ ON c1_.parent_id = c3_.id LEFT JOIN category c4_ ON c3_.parent_id = c4_.id WHERE (c1_.slug = 'actualites' OR c3_.slug = 'actualites' OR c4_.slug = 'actualites') AND (a0_.mise_en_avant = 0 OR a0_.mise_en_avant IS NULL) AND ((a0_.programmation_date IS NULL OR a0_.programmation_date <= '2025-10-18 04:09:09')) AND a0_.enabled = 1 AND a0_.id IN (2615, 2659, 2658) GROUP BY a0_.id ORDER BY a0_.blocked DESC, a0_.date DESC, a0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.resume AS resume_2,
  a0_.article AS article_3,
  a0_.photo AS photo_4,
  a0_.legende AS legende_5,
  a0_.linkto AS linkto_6,
  a0_.libellefile1 AS libellefile1_7,
  a0_.urlfile1 AS urlfile1_8,
  a0_.libellefile2 AS libellefile2_9,
  a0_.urlfile2 AS urlfile2_10,
  a0_.keywords AS keywords_11,
  a0_.filename AS filename_12,
  a0_.slug AS slug_13,
  a0_.type AS type_14,
  a0_.count AS count_15,
  a0_.vignette AS vignette_16,
  a0_.archived AS archived_17,
  a0_.emailcontact AS emailcontact_18,
  a0_.date AS date_19,
  a0_.mise_en_avant AS mise_en_avant_20,
  a0_.enabled AS enabled_21,
  a0_.blocked AS blocked_22,
  a0_.external_link AS external_link_23,
  a0_.programmation_date AS programmation_date_24,
  a0_.use_youtube_thumb AS use_youtube_thumb_25,
  a0_.is_only_for_subscriber AS is_only_for_subscriber_26,
  a0_.created_at AS created_at_27,
  a0_.updated_at AS updated_at_28,
  a0_.category_id AS category_id_29
FROM
  article a0_
  LEFT JOIN article_category a2_ ON a0_.id = a2_.article_id
  LEFT JOIN category c1_ ON c1_.id = a2_.category_id
  LEFT JOIN category c3_ ON c1_.parent_id = c3_.id
  LEFT JOIN category c4_ ON c3_.parent_id = c4_.id
WHERE
  (
    c1_.slug = ?
    OR c3_.slug = ?
    OR c4_.slug = ?
  )
  AND (
    a0_.mise_en_avant = 0
    OR a0_.mise_en_avant IS NULL
  )
  AND (
    (
      a0_.programmation_date IS NULL
      OR a0_.programmation_date <= ?
    )
  )
  AND a0_.enabled = 1
  AND (
    (
      a0_.is_only_for_subscriber = 0
      OR a0_.is_only_for_subscriber IS NULL
    )
  )
GROUP BY
  a0_.id
ORDER BY
  a0_.blocked DESC,
  a0_.date DESC,
  a0_.created_at DESC