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_.call AS call_1,
  b0_.response AS response_2,
  b0_.date_call AS date_call_3,
  b0_.expire_at AS expire_at_4
FROM
  bolt_alis_cache b0_
WHERE
  b0_.call = ?
  AND b0_.expire_at > ?
ORDER BY
  b0_.date_call DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.call AS call_1, b0_.response AS response_2, b0_.date_call AS date_call_3, b0_.expire_at AS expire_at_4 FROM bolt_alis_cache b0_ WHERE b0_.call = '{\"reference\":null,\"typeannonce\":null,\"typeannonceRC\":null,\"departement\":null,\"from\":\"2025-05-12\",\"to\":\"2025-05-19\",\"range\":null,\"support\":null,\"findLasts\":null,\"page\":null,\"itemsPerPage\":30,\"cmd\":\"search\",\"societe\":\"ALL\"}' AND b0_.expire_at > '2025-05-19 13:29:24' ORDER BY b0_.date_call 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 = ?
  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 = 'blocs' AND ((LOWER(b2_.value ->> 0) = 'annonces-legales-sidebar' AND b1_.parent_id IS NULL AND b1_.name = 'slug') AND b0_.status = 'published') ORDER BY b0_.published_at DESC LIMIT 1;