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
  b0_.id AS id_0,
  b0_.created AS created_1,
  b0_.tc_codename AS tc_codename_2,
  b0_.period_from AS period_from_3,
  b0_.period_to AS period_to_4,
  b0_.filename AS filename_5
FROM
  bolt_tcarchive b0_
WHERE
  (
    (
      b0_.period_from >= ?
      AND b0_.period_to <= ?
    )
    OR (
      b0_.period_from <= ?
      AND (
        b0_.period_to >= ?
        AND b0_.period_to <= ?
      )
    )
    OR (
      (
        b0_.period_from >= ?
        AND b0_.period_from <= ?
      )
      AND b0_.period_to >= ?
    )
  )
  AND b0_.tc_codename = ?
ORDER BY
  b0_.created DESC

SELECT b0_.id AS id_0, b0_.created AS created_1, b0_.tc_codename AS tc_codename_2, b0_.period_from AS period_from_3, b0_.period_to AS period_to_4, b0_.filename AS filename_5 FROM bolt_tcarchive b0_ WHERE ((b0_.period_from >= '2025-07-01 00:00:00' AND b0_.period_to <= '2025-07-31 00:00:00') OR (b0_.period_from <= '2025-07-01 00:00:00' AND (b0_.period_to >= '2025-07-01 00:00:00' AND b0_.period_to <= '2025-07-31 00:00:00')) OR ((b0_.period_from >= '2025-07-01 00:00:00' AND b0_.period_from <= '2025-07-31 00:00:00') AND b0_.period_to >= '2025-07-31 00:00:00')) AND b0_.tc_codename = 'tc-nancy' ORDER BY b0_.created DESC;