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;

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_.status = ?
        ORDER BY
          b0_.id ASC
      ) 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 = 'pages' AND b0_.status = 'published' ORDER BY b0_.id ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
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_.status = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 ASC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 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 = 'pages' AND b0_.status = 'published') dctrn_result_inner ORDER BY id_0 ASC) dctrn_result LIMIT 6;