Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6,
          b1_.id AS id_7,
          b1_.display_name AS display_name_8,
          b1_.username AS username_9,
          b1_.email AS email_10,
          b1_.password AS password_11,
          b1_.roles AS roles_12,
          b1_.lastseen_at AS lastseen_at_13,
          b1_.last_ip AS last_ip_14,
          b1_.locale AS locale_15,
          b1_.backend_theme AS backend_theme_16,
          b1_.status AS status_17,
          b1_.avatar AS avatar_18,
          b2_.id AS id_19,
          b2_.type AS type_20,
          b2_.slug AS slug_21,
          b2_.name AS name_22,
          b2_.sortorder AS sortorder_23
        FROM
          bolt_content b0_
          INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id
          INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id
          INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id
          INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id
          AND b4_.type IN (
            'generic', 'select', 'block', 'checkbox',
            'collection', 'data', 'date', 'email',
            'embed', 'file', 'filelist', 'hidden',
            'html', 'image', 'imagelist', 'markdown',
            'number', 'set', 'slug', 'templateselect',
            'text', 'textarea', 'article', 'redactor'
          )
          INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id
        WHERE
          b2_.type = ?
          AND b2_.slug = ?
          AND b5_.value ->> 0 IN (?)
          AND b4_.name = ?
          AND b0_.content_type = ?
          AND b0_.status = ?
        ORDER BY
          b0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id AND b4_.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id WHERE b2_.type = 'categories' AND b2_.slug = 'entreprises' AND b5_.value ->> 0 IN ('tl', 'gm') AND b4_.name = 'site_origin' AND b0_.content_type = 'articles' AND b0_.status = 'published' ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_24) AS dctrn_minrownum
FROM
  (
    SELECT
      b0_.id AS id_0,
      b0_.content_type AS content_type_1,
      b0_.status AS status_2,
      b0_.created_at AS created_at_3,
      b0_.modified_at AS modified_at_4,
      b0_.published_at AS published_at_5,
      b0_.depublished_at AS depublished_at_6,
      b1_.id AS id_7,
      b1_.display_name AS display_name_8,
      b1_.username AS username_9,
      b1_.email AS email_10,
      b1_.password AS password_11,
      b1_.roles AS roles_12,
      b1_.lastseen_at AS lastseen_at_13,
      b1_.last_ip AS last_ip_14,
      b1_.locale AS locale_15,
      b1_.backend_theme AS backend_theme_16,
      b1_.status AS status_17,
      b1_.avatar AS avatar_18,
      b2_.id AS id_19,
      b2_.type AS type_20,
      b2_.slug AS slug_21,
      b2_.name AS name_22,
      b2_.sortorder AS sortorder_23,
      ROW_NUMBER() OVER(
        ORDER BY
          b0_.published_at DESC
      ) AS sclr_24
    FROM
      bolt_content b0_
      INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id
      INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id
      INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id
      INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id
      AND b4_.type IN (
        'generic', 'select', 'block', 'checkbox',
        'collection', 'data', 'date', 'email',
        'embed', 'file', 'filelist', 'hidden',
        'html', 'image', 'imagelist', 'markdown',
        'number', 'set', 'slug', 'templateselect',
        'text', 'textarea', 'article', 'redactor'
      )
      INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id
    WHERE
      b2_.type = ?
      AND b2_.slug = ?
      AND b5_.value ->> 0 IN (?)
      AND b4_.name = ?
      AND b0_.content_type = ?
      AND b0_.status = ?
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  10 OFFSET 130

SELECT DISTINCT id_0, MIN(sclr_24) AS dctrn_minrownum FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23, ROW_NUMBER() OVER(ORDER BY b0_.published_at DESC) AS sclr_24 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id AND b4_.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id WHERE b2_.type = 'categories' AND b2_.slug = 'entreprises' AND b5_.value ->> 0 IN ('tl', 'gm') AND b4_.name = 'site_origin' AND b0_.content_type = 'articles' AND b0_.status = 'published') dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 10 OFFSET 130;

SELECT
  DISTINCT id_0,
  MIN(sclr_7) AS dctrn_minrownum
FROM
  (
    SELECT
      b0_.id AS id_0,
      b0_.content_type AS content_type_1,
      b0_.status AS status_2,
      b0_.created_at AS created_at_3,
      b0_.modified_at AS modified_at_4,
      b0_.published_at AS published_at_5,
      b0_.depublished_at AS depublished_at_6,
      ROW_NUMBER() OVER(
        ORDER BY
          b0_.published_at DESC
      ) AS sclr_7
    FROM
      bolt_content b0_
    WHERE
      b0_.content_type = ?
      AND (
        b0_.published_at < ?
        AND b0_.status = ?
      )
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  5 OFFSET 65

SELECT DISTINCT id_0, MIN(sclr_7) AS dctrn_minrownum FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, ROW_NUMBER() OVER(ORDER BY b0_.published_at DESC) AS sclr_7 FROM bolt_content b0_ WHERE b0_.content_type = 'articles' AND (b0_.published_at < '2025-06-29T09:24:32+02:00' AND b0_.status = 'published')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 5 OFFSET 65;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.content_type AS content_type_1,
          b0_.status AS status_2,
          b0_.created_at AS created_at_3,
          b0_.modified_at AS modified_at_4,
          b0_.published_at AS published_at_5,
          b0_.depublished_at AS depublished_at_6
        FROM
          bolt_content b0_
        WHERE
          b0_.content_type = ?
          AND (
            b0_.published_at < ?
            AND b0_.status = ?
          )
        ORDER BY
          b0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6 FROM bolt_content b0_ WHERE b0_.content_type = 'articles' AND (b0_.published_at < '2025-06-29T09:24:32+02:00' AND b0_.status = 'published') ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

update
  bolt_content
SET
  status = 'held',
  depublished_at = :now
WHERE
  status = 'published'
  AND depublished_at < :now

update bolt_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  bolt_field_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_field_translation t0 WHERE t0.translatable_id = 1341886;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.author_id AS author_id_7
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'block', 'checkbox',
    'collection', 'data', 'date', 'email',
    'embed', 'file', 'filelist', 'hidden',
    'html', 'image', 'imagelist', 'markdown',
    'number', 'set', 'slug', 'templateselect',
    'text', 'textarea', 'article', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND (
    (
      LOWER(b2_.value ->> 0) = ?
      AND b1_.parent_id IS NULL
      AND b1_.name = ?
    )
    AND b0_.status = ?
  )
ORDER BY
  b0_.published_at DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.author_id AS author_id_7 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'espaces-publicitaires' AND ((LOWER(b2_.value ->> 0) = 'ad-block-0s' AND b1_.parent_id IS NULL AND b1_.name = 'slug') AND b0_.status = 'published') ORDER BY b0_.published_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sortorder AS sortorder_3,
  t0.version AS version_4,
  t0.content_id AS content_id_5,
  t7.id AS id_6,
  t7.content_type AS content_type_8,
  t7.status AS status_9,
  t7.created_at AS created_at_10,
  t7.modified_at AS modified_at_11,
  t7.published_at AS published_at_12,
  t7.depublished_at AS depublished_at_13,
  t7.author_id AS author_id_14,
  t0.parent_id AS parent_id_15,
  t0.type
FROM
  bolt_field t0
  INNER JOIN bolt_content t7 ON t0.content_id = t7.id
WHERE
  t0.content_id = ?
  AND t0.type IN (
    'generic', 'select', 'block', 'checkbox',
    'collection', 'data', 'date', 'email',
    'embed', 'file', 'filelist', 'hidden',
    'html', 'image', 'imagelist', 'markdown',
    'number', 'set', 'slug', 'templateselect',
    'text', 'textarea', 'article', 'redactor'
  )
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = 94690 AND t0.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') ORDER BY t0.sortorder ASC;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b1_.id AS id_7,
  b1_.display_name AS display_name_8,
  b1_.username AS username_9,
  b1_.email AS email_10,
  b1_.password AS password_11,
  b1_.roles AS roles_12,
  b1_.lastseen_at AS lastseen_at_13,
  b1_.last_ip AS last_ip_14,
  b1_.locale AS locale_15,
  b1_.backend_theme AS backend_theme_16,
  b1_.status AS status_17,
  b1_.avatar AS avatar_18,
  b2_.id AS id_19,
  b2_.type AS type_20,
  b2_.slug AS slug_21,
  b2_.name AS name_22,
  b2_.sortorder AS sortorder_23,
  b0_.author_id AS author_id_24
FROM
  bolt_content b0_
  INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id
  INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id
  INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id
  INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id
  AND b4_.type IN (
    'generic', 'select', 'block', 'checkbox',
    'collection', 'data', 'date', 'email',
    'embed', 'file', 'filelist', 'hidden',
    'html', 'image', 'imagelist', 'markdown',
    'number', 'set', 'slug', 'templateselect',
    'text', 'textarea', 'article', 'redactor'
  )
  INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id
WHERE
  b2_.type = ?
  AND b2_.slug = ?
  AND b5_.value ->> 0 IN (?)
  AND b4_.name = ?
  AND b0_.content_type = ?
  AND b0_.status = ?
  AND b0_.id IN (?)
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b1_.id AS id_7, b1_.display_name AS display_name_8, b1_.username AS username_9, b1_.email AS email_10, b1_.password AS password_11, b1_.roles AS roles_12, b1_.lastseen_at AS lastseen_at_13, b1_.last_ip AS last_ip_14, b1_.locale AS locale_15, b1_.backend_theme AS backend_theme_16, b1_.status AS status_17, b1_.avatar AS avatar_18, b2_.id AS id_19, b2_.type AS type_20, b2_.slug AS slug_21, b2_.name AS name_22, b2_.sortorder AS sortorder_23, b0_.author_id AS author_id_24 FROM bolt_content b0_ INNER JOIN bolt_user b1_ ON b0_.author_id = b1_.id INNER JOIN bolt_taxonomy_content b3_ ON b0_.id = b3_.content_id INNER JOIN bolt_taxonomy b2_ ON b2_.id = b3_.taxonomy_id INNER JOIN bolt_field b4_ ON b0_.id = b4_.content_id AND b4_.type IN ('generic', 'select', 'block', 'checkbox', 'collection', 'data', 'date', 'email', 'embed', 'file', 'filelist', 'hidden', 'html', 'image', 'imagelist', 'markdown', 'number', 'set', 'slug', 'templateselect', 'text', 'textarea', 'article', 'redactor') INNER JOIN bolt_field_translation b5_ ON b4_.id = b5_.translatable_id WHERE b2_.type = 'categories' AND b2_.slug = 'entreprises' AND b5_.value ->> 0 IN ('tl', 'gm') AND b4_.name = 'site_origin' AND b0_.content_type = 'articles' AND b0_.status = 'published' AND b0_.id IN (94690, 94756, 94630, 94631, 94552, 94295, 94521, 94289, 94284, 94256) ORDER BY b0_.published_at DESC;

update
  bolt_content
SET
  status = 'published',
  published_at = :now
WHERE
  status = 'timed'
  AND published_at < :now

update bolt_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.lastseen_at AS lastseen_at_7,
  t0.last_ip AS last_ip_8,
  t0.locale AS locale_9,
  t0.backend_theme AS backend_theme_10,
  t0.status AS status_11,
  t0.avatar AS avatar_12,
  t13.id AS id_14,
  t13.useragent AS useragent_15,
  t13.validity AS validity_16,
  t13.user_id AS user_id_17
FROM
  bolt_user t0
  LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM bolt_user t0 LEFT JOIN bolt_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (67);

SELECT
  t0.id AS id_1,
  t0.useragent AS useragent_2,
  t0.validity AS validity_3,
  t0.user_id AS user_id_4
FROM
  bolt_user_auth_token t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.useragent AS useragent_2, t0.validity AS validity_3, t0.user_id AS user_id_4 FROM bolt_user_auth_token t0 WHERE t0.user_id = 306;

SELECT
  b0_.id AS id_0,
  b0_.created AS created_1,
  b0_.num_parution AS num_parution_2,
  b0_.date_parution AS date_parution_3,
  b0_.edition AS edition_4,
  b0_.filename_al AS filename_al_5,
  b0_.filename_red AS filename_red_6,
  b0_.filename_single AS filename_single_7,
  b0_.filename_sup AS filename_sup_8,
  b0_.link_al AS link_al_9,
  b0_.link_red AS link_red_10,
  b0_.link_single AS link_single_11,
  b0_.link_sup AS link_sup_12,
  b0_.title_sup AS title_sup_13
FROM
  bolt_archive b0_
WHERE
  b0_.filename_single IS NOT NULL
  AND b0_.date_parution <= ?
ORDER BY
  b0_.date_parution DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.num_parution AS num_parution_2, b0_.date_parution AS date_parution_3, b0_.edition AS edition_4, b0_.filename_al AS filename_al_5, b0_.filename_red AS filename_red_6, b0_.filename_single AS filename_single_7, b0_.filename_sup AS filename_sup_8, b0_.link_al AS link_al_9, b0_.link_red AS link_red_10, b0_.link_single AS link_single_11, b0_.link_sup AS link_sup_12, b0_.title_sup AS title_sup_13 FROM bolt_archive b0_ WHERE b0_.filename_single IS NOT NULL AND b0_.date_parution <= '2025-06-29 09:24:32' ORDER BY b0_.date_parution DESC LIMIT 3;

SELECT
  b0_.id AS id_0,
  b0_.content_type AS content_type_1,
  b0_.status AS status_2,
  b0_.created_at AS created_at_3,
  b0_.modified_at AS modified_at_4,
  b0_.published_at AS published_at_5,
  b0_.depublished_at AS depublished_at_6,
  b0_.author_id AS author_id_7
FROM
  bolt_content b0_
WHERE
  b0_.content_type = ?
  AND (
    b0_.published_at < ?
    AND b0_.status = ?
  )
  AND b0_.id IN (?)
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, b0_.author_id AS author_id_7 FROM bolt_content b0_ WHERE b0_.content_type = 'articles' AND (b0_.published_at < '2025-06-29T09:24:32+02:00' AND b0_.status = 'published') AND b0_.id IN (99802, 99789, 99810, 99831, 99814) ORDER BY b0_.published_at DESC;