Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  p_field_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM p_field_translation t0 WHERE t0.translatable_id = 32;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.sortorder AS sortorder_2,
  p0_.version AS version_3,
  p0_.type AS type_4,
  p0_.content_id AS content_id_5,
  p0_.parent_id AS parent_id_6
FROM
  p_field p0_
WHERE
  (p0_.parent_id = ?)
  AND p0_.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'
  )
ORDER BY
  p0_.sortorder ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.sortorder AS sortorder_2, p0_.version AS version_3, p0_.type AS type_4, p0_.content_id AS content_id_5, p0_.parent_id AS parent_id_6 FROM p_field p0_ WHERE (p0_.parent_id = 46) AND p0_.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') ORDER BY p0_.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sortorder AS sortorder_3,
  t0.version AS version_4,
  t0.content_id AS content_id_5,
  t7.id AS id_6,
  t7.content_type AS content_type_8,
  t7.status AS status_9,
  t7.created_at AS created_at_10,
  t7.modified_at AS modified_at_11,
  t7.published_at AS published_at_12,
  t7.depublished_at AS depublished_at_13,
  t7.author_id AS author_id_14,
  t0.parent_id AS parent_id_15,
  t0.type
FROM
  p_field t0
  INNER JOIN p_content t7 ON t0.content_id = t7.id
WHERE
  t0.id = ?
  AND t0.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'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM p_field t0 INNER JOIN p_content t7 ON t0.content_id = t7.id WHERE t0.id = 38285 AND t0.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');

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
  ) = ?
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) = 'bilancio-sostenibilita' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sortorder AS sortorder_3,
  t0.version AS version_4,
  t0.content_id AS content_id_5,
  t7.id AS id_6,
  t7.content_type AS content_type_8,
  t7.status AS status_9,
  t7.created_at AS created_at_10,
  t7.modified_at AS modified_at_11,
  t7.published_at AS published_at_12,
  t7.depublished_at AS depublished_at_13,
  t7.author_id AS author_id_14,
  t0.parent_id AS parent_id_15,
  t0.type
FROM
  p_field t0
  INNER JOIN p_content t7 ON t0.content_id = t7.id
WHERE
  t0.content_id = ?
  AND t0.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'
  )
ORDER BY
  t0.sortorder ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.sortorder AS sortorder_3, t0.version AS version_4, t0.content_id AS content_id_5, t7.id AS id_6, t7.content_type AS content_type_8, t7.status AS status_9, t7.created_at AS created_at_10, t7.modified_at AS modified_at_11, t7.published_at AS published_at_12, t7.depublished_at AS depublished_at_13, t7.author_id AS author_id_14, t0.parent_id AS parent_id_15, t0.type FROM p_field t0 INNER JOIN p_content t7 ON t0.content_id = t7.id WHERE t0.content_id = 1 AND t0.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') ORDER BY t0.sortorder ASC;

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) = 'bilancio-sostenibilita' AND p0_.content_type = 'landing-sustainability' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.lastseen_at AS lastseen_at_7,
  t0.last_ip AS last_ip_8,
  t0.locale AS locale_9,
  t0.backend_theme AS backend_theme_10,
  t0.status AS status_11,
  t0.avatar AS avatar_12,
  t13.id AS id_14,
  t13.useragent AS useragent_15,
  t13.validity AS validity_16,
  t13.user_id AS user_id_17
FROM
  p_user t0
  LEFT JOIN p_user_auth_token t13 ON t13.user_id = t0.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.lastseen_at AS lastseen_at_7, t0.last_ip AS last_ip_8, t0.locale AS locale_9, t0.backend_theme AS backend_theme_10, t0.status AS status_11, t0.avatar AS avatar_12, t13.id AS id_14, t13.useragent AS useragent_15, t13.validity AS validity_16, t13.user_id AS user_id_17 FROM p_user t0 LEFT JOIN p_user_auth_token t13 ON t13.user_id = t0.id WHERE t0.id IN (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;