Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.content_type AS content_type_1,
  p0_.status AS status_2,
  p0_.created_at AS created_at_3,
  p0_.modified_at AS modified_at_4,
  p0_.published_at AS published_at_5,
  p0_.depublished_at AS depublished_at_6,
  p0_.author_id AS author_id_7
FROM
  p_content p0_
  INNER JOIN p_field p1_ ON p0_.id = p1_.content_id
  AND p1_.type IN (
    'generic', 'select', 'email', 'file',
    'filelist', 'text', 'date', 'embed',
    'block', 'html', 'templateselect',
    'collection', 'data', 'set', 'number',
    'imagelist', 'markdown', 'textarea',
    'hidden', 'slug', 'image', 'checkbox',
    'article', 'seo', 'redactor'
  )
  INNER JOIN p_field p2_ ON (p1_.id = p2_.id)
  AND p2_.type IN ('slug')
  INNER JOIN p_field_translation p3_ ON p1_.id = p3_.translatable_id
WHERE
  CAST(
    JSON_UNQUOTE(
      JSON_EXTRACT(p3_.value, '$[0]')
    ) AS CHAR
  ) = ?
  AND p0_.content_type = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.content_type AS content_type_1, p0_.status AS status_2, p0_.created_at AS created_at_3, p0_.modified_at AS modified_at_4, p0_.published_at AS published_at_5, p0_.depublished_at AS depublished_at_6, p0_.author_id AS author_id_7 FROM p_content p0_ INNER JOIN p_field p1_ ON p0_.id = p1_.content_id AND p1_.type IN ('generic', 'select', 'email', 'file', 'filelist', 'text', 'date', 'embed', 'block', 'html', 'templateselect', 'collection', 'data', 'set', 'number', 'imagelist', 'markdown', 'textarea', 'hidden', 'slug', 'image', 'checkbox', 'article', 'seo', 'redactor') INNER JOIN p_field p2_ ON (p1_.id = p2_.id) AND p2_.type IN ('slug') INNER JOIN p_field_translation p3_ ON p1_.id = p3_.translatable_id WHERE CAST(JSON_UNQUOTE(JSON_EXTRACT(p3_.value, '$[0]')) AS CHAR) = '404-not-found' AND p0_.content_type = 'blocks' LIMIT 1;

update
  p_content
SET
  status = 'published',
  published_at = :now
WHERE
  status = 'timed'
  AND published_at < :now

update p_content SET status = 'published', published_at = :now  WHERE status = 'timed' AND published_at < :now;

update
  p_content
SET
  status = 'held',
  depublished_at = :now
WHERE
  status = 'published'
  AND depublished_at < :now

update p_content SET status = 'held', depublished_at = :now WHERE status = 'published' AND depublished_at < :now;