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_.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_.date_parution >= ?
  AND b0_.date_parution <= ?
  AND b0_.date_parution <= ?
ORDER BY
  b0_.num_parution DESC

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_.date_parution >= '2025-07-01 00:00:00' AND b0_.date_parution <= '2025-07-31 00:00:00' AND b0_.date_parution <= '2025-07-01 01:11:44' ORDER BY b0_.num_parution DESC;