Symfony Profiler

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.author_id AS author_id_8,
  t9.id AS id_10,
  t9.display_name AS display_name_11,
  t9.username AS username_12,
  t9.email AS email_13,
  t9.password AS password_14,
  t9.roles AS roles_15,
  t9.lastseen_at AS lastseen_at_16,
  t9.last_ip AS last_ip_17,
  t9.locale AS locale_18,
  t9.backend_theme AS backend_theme_19,
  t9.status AS status_20,
  t9.avatar AS avatar_21
FROM
  bolt_content t0
  LEFT JOIN bolt_user t9 ON t0.author_id = t9.id
WHERE
  t0.id = ?

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.author_id AS author_id_8, t9.id AS id_10, t9.display_name AS display_name_11, t9.username AS username_12, t9.email AS email_13, t9.password AS password_14, t9.roles AS roles_15, t9.lastseen_at AS lastseen_at_16, t9.last_ip AS last_ip_17, t9.locale AS locale_18, t9.backend_theme AS backend_theme_19, t9.status AS status_20, t9.avatar AS avatar_21 FROM bolt_content t0 LEFT JOIN bolt_user t9 ON t0.author_id = t9.id WHERE t0.id = 2;

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;