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]') = '184' AND b0_.content_type = 'pages' 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
  t0.id AS id_1,
  t0.content_type AS content_type_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.modified_at AS modified_at_5,
  t0.published_at AS published_at_6,
  t0.depublished_at AS depublished_at_7,
  t0.title AS title_8,
  t0.list_format AS list_format_9,
  t0.author_id AS author_id_10,
  t11.id AS id_12,
  t11.display_name AS display_name_13,
  t11.username AS username_14,
  t11.email AS email_15,
  t11.password AS password_16,
  t11.roles AS roles_17,
  t11.lastseen_at AS lastseen_at_18,
  t11.last_ip AS last_ip_19,
  t11.locale AS locale_20,
  t11.backend_theme AS backend_theme_21,
  t11.status AS status_22,
  t11.avatar AS avatar_23,
  t11.about AS about_24
FROM
  bolt_content t0
  LEFT JOIN bolt_user t11 ON t0.author_id = t11.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.content_type AS content_type_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.modified_at AS modified_at_5, t0.published_at AS published_at_6, t0.depublished_at AS depublished_at_7, t0.title AS title_8, t0.list_format AS list_format_9, t0.author_id AS author_id_10, t11.id AS id_12, t11.display_name AS display_name_13, t11.username AS username_14, t11.email AS email_15, t11.password AS password_16, t11.roles AS roles_17, t11.lastseen_at AS lastseen_at_18, t11.last_ip AS last_ip_19, t11.locale AS locale_20, t11.backend_theme AS backend_theme_21, t11.status AS status_22, t11.avatar AS avatar_23, t11.about AS about_24 FROM bolt_content t0 LEFT JOIN bolt_user t11 ON t0.author_id = t11.id WHERE t0.id = 184 LIMIT 1;

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;