Symfony Profiler

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_.title AS title_7,
  b0_.list_format AS list_format_8,
  b0_.author_id AS author_id_9
FROM
  bolt_content b0_
  INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'templateselect',
    'slug', 'text', 'hidden', 'number',
    'embed', 'imagelist', 'file', 'email',
    'checkbox', 'textarea', 'block',
    'date', 'image', 'set', 'filelist',
    'html', 'markdown', 'data', 'collection',
    'article', 'redactor'
  )
  INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id)
  AND b2_.type IN ('slug')
  INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id
WHERE
  JSON_EXTRACT(b3_.value, '$[0]') = ?
  AND b0_.content_type = ?
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_.title AS title_7, b0_.list_format AS list_format_8, b0_.author_id AS author_id_9 FROM bolt_content b0_ INNER JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'templateselect', 'slug', 'text', 'hidden', 'number', 'embed', 'imagelist', 'file', 'email', 'checkbox', 'textarea', 'block', 'date', 'image', 'set', 'filelist', 'html', 'markdown', 'data', 'collection', 'article', 'redactor') INNER JOIN bolt_field b2_ ON (b1_.id = b2_.id) AND b2_.type IN ('slug') INNER JOIN bolt_field_translation b3_ ON b1_.id = b3_.translatable_id WHERE JSON_EXTRACT(b3_.value, '$[0]') = 'international-conference-on-communication-and-media-studies%2525252525252525252526amp%252525252525252526amp%25252525252526amp%252525252526amp%2525252526amp%25252526amp&amp' AND b0_.content_type = 'events' LIMIT 1;

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;

SELECT
  JSON_EXTRACT(
    '{"jsonfunctionalitytest":["succes"]}',
    '$.jsonfunctionalitytest'
  ) AS value

SELECT JSON_EXTRACT('{"jsonfunctionalitytest":["succes"]}', '$.jsonfunctionalitytest') AS value;

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;