Symfony Profiler

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;

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;

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;

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
  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 = 'actualites' AND b5_.value ->> 0 IN ('gn', 'pg', 'go') AND b4_.name = 'site_origin' AND b0_.content_type = 'articles' AND b0_.status = 'published' ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

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;

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;

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;

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;