Symfony Profiler

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.sortorder AS sortorder_2,
  b0_.version AS version_3,
  b0_.type AS type_4,
  b0_.content_id AS content_id_5,
  b0_.parent_id AS parent_id_6
FROM
  bolt_field b0_
WHERE
  (b0_.parent_id = ?)
  AND b0_.type IN (
    'generic', 'select', 'filelist', 'file',
    'set', 'data', 'html', 'markdown',
    'text', 'number', 'date', 'collection',
    'block', 'email', 'textarea', 'imagelist',
    'checkbox', 'templateselect', 'slug',
    'embed', 'hidden', 'image', 'article',
    'seo', 'redactor'
  )
ORDER BY
  b0_.sortorder ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.sortorder AS sortorder_2, b0_.version AS version_3, b0_.type AS type_4, b0_.content_id AS content_id_5, b0_.parent_id AS parent_id_6 FROM bolt_field b0_ WHERE (b0_.parent_id = 1050) AND b0_.type IN ('generic', 'select', 'filelist', 'file', 'set', 'data', 'html', 'markdown', 'text', 'number', 'date', 'collection', 'block', 'email', 'textarea', 'imagelist', 'checkbox', 'templateselect', 'slug', 'embed', 'hidden', 'image', 'article', 'seo', 'redactor') ORDER BY b0_.sortorder ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  bolt_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 bolt_field_translation t0 WHERE t0.translatable_id = 703;

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.title AS title_14,
  t7.list_format AS list_format_15,
  t7.author_id AS author_id_16,
  t0.parent_id AS parent_id_17,
  t0.type
FROM
  bolt_field t0
  INNER JOIN bolt_content t7 ON t0.content_id = t7.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'generic', 'select', 'filelist', 'file',
    'set', 'data', 'html', 'markdown',
    'text', 'number', 'date', 'collection',
    'block', 'email', 'textarea', 'imagelist',
    'checkbox', 'templateselect', 'slug',
    'embed', 'hidden', 'image', '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.title AS title_14, t7.list_format AS list_format_15, t7.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.id = 1117 AND t0.type IN ('generic', 'select', 'filelist', 'file', 'set', 'data', 'html', 'markdown', 'text', 'number', 'date', 'collection', 'block', 'email', 'textarea', 'imagelist', 'checkbox', 'templateselect', 'slug', 'embed', 'hidden', 'image', '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.title AS title_14,
  t7.list_format AS list_format_15,
  t7.author_id AS author_id_16,
  t0.parent_id AS parent_id_17,
  t0.type
FROM
  bolt_field t0
  INNER JOIN bolt_content t7 ON t0.content_id = t7.id
WHERE
  t0.content_id = ?
  AND t0.type IN (
    'generic', 'select', 'filelist', 'file',
    'set', 'data', 'html', 'markdown',
    'text', 'number', 'date', 'collection',
    'block', 'email', 'textarea', 'imagelist',
    'checkbox', 'templateselect', 'slug',
    'embed', 'hidden', 'image', '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.title AS title_14, t7.list_format AS list_format_15, t7.author_id AS author_id_16, t0.parent_id AS parent_id_17, t0.type FROM bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = 124 AND t0.type IN ('generic', 'select', 'filelist', 'file', 'set', 'data', 'html', 'markdown', 'text', 'number', 'date', 'collection', 'block', 'email', 'textarea', 'imagelist', 'checkbox', 'templateselect', 'slug', 'embed', 'hidden', 'image', 'article', 'seo', 'redactor') ORDER BY t0.sortorder ASC;

SELECT
  b0_.id AS id_0,
  b0_.position AS position_1,
  b1_.id AS id_2,
  b1_.content_type AS content_type_3,
  b1_.status AS status_4,
  b1_.created_at AS created_at_5,
  b1_.modified_at AS modified_at_6,
  b1_.published_at AS published_at_7,
  b1_.depublished_at AS depublished_at_8,
  b1_.title AS title_9,
  b1_.list_format AS list_format_10,
  b2_.id AS id_11,
  b2_.content_type AS content_type_12,
  b2_.status AS status_13,
  b2_.created_at AS created_at_14,
  b2_.modified_at AS modified_at_15,
  b2_.published_at AS published_at_16,
  b2_.depublished_at AS depublished_at_17,
  b2_.title AS title_18,
  b2_.list_format AS list_format_19,
  b0_.from_content_id AS from_content_id_20,
  b0_.to_content_id AS to_content_id_21,
  b1_.author_id AS author_id_22,
  b2_.author_id AS author_id_23
FROM
  bolt_relation b0_
  INNER JOIN bolt_content b1_ ON b0_.from_content_id = b1_.id
  INNER JOIN bolt_content b2_ ON b0_.to_content_id = b2_.id
WHERE
  b2_.status = ?
  AND b1_.status = ?
  AND (
    b0_.from_content_id = ?
    OR b0_.to_content_id = ?
  )
ORDER BY
  b0_.position ASC

SELECT b0_.id AS id_0, b0_.position AS position_1, b1_.id AS id_2, b1_.content_type AS content_type_3, b1_.status AS status_4, b1_.created_at AS created_at_5, b1_.modified_at AS modified_at_6, b1_.published_at AS published_at_7, b1_.depublished_at AS depublished_at_8, b1_.title AS title_9, b1_.list_format AS list_format_10, b2_.id AS id_11, b2_.content_type AS content_type_12, b2_.status AS status_13, b2_.created_at AS created_at_14, b2_.modified_at AS modified_at_15, b2_.published_at AS published_at_16, b2_.depublished_at AS depublished_at_17, b2_.title AS title_18, b2_.list_format AS list_format_19, b0_.from_content_id AS from_content_id_20, b0_.to_content_id AS to_content_id_21, b1_.author_id AS author_id_22, b2_.author_id AS author_id_23 FROM bolt_relation b0_ INNER JOIN bolt_content b1_ ON b0_.from_content_id = b1_.id INNER JOIN bolt_content b2_ ON b0_.to_content_id = b2_.id WHERE b2_.status = 'published' AND b1_.status = 'published' AND (b0_.from_content_id = 124 OR b0_.to_content_id = 124) ORDER BY b0_.position ASC;

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', 'filelist', 'file',
    'set', 'data', 'html', 'markdown',
    'text', 'number', 'date', 'collection',
    'block', 'email', 'textarea', 'imagelist',
    'checkbox', 'templateselect', 'slug',
    'embed', 'hidden', 'image', 'article',
    'seo', '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
  CAST(
    JSON_UNQUOTE(
      JSON_EXTRACT(b3_.value, '$[0]')
    ) AS CHAR
  ) = ?
  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', 'filelist', 'file', 'set', 'data', 'html', 'markdown', 'text', 'number', 'date', 'collection', 'block', 'email', 'textarea', 'imagelist', 'checkbox', 'templateselect', 'slug', 'embed', 'hidden', 'image', 'article', 'seo', '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 CAST(JSON_UNQUOTE(JSON_EXTRACT(b3_.value, '$[0]')) AS CHAR) = 'cicatrich' AND b0_.content_type = 'productos' LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        FROM
          bolt_content b0_
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
        ORDER BY
          b0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM bolt_content b0_ WHERE b0_.content_type = 'productos' AND b0_.status = 'published' ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

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_
WHERE
  b0_.content_type = ?
  AND b0_.status = ?
  AND b0_.id IN (?)
ORDER BY
  b0_.published_at DESC

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_ WHERE b0_.content_type = 'productos' AND b0_.status = 'published' AND b0_.id IN (124, 123) ORDER BY b0_.published_at DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        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
        FROM
          bolt_content b0_
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (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 FROM bolt_content b0_ WHERE b0_.content_type = 'productos' AND b0_.status = 'published') dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 6;

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
  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_
WHERE
  b0_.content_type = ?
  AND b0_.status = ?
ORDER BY
  b0_.published_at DESC
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_ WHERE b0_.content_type = 'theme-novalty' AND b0_.status = 'published' ORDER BY b0_.published_at DESC LIMIT 1;

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;

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.content_type = ?
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.content_type = 'settings' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.useragent AS useragent_2,
  t0.validity AS validity_3,
  t0.user_id AS user_id_4
FROM
  bolt_user_auth_token t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.useragent AS useragent_2, t0.validity AS validity_3, t0.user_id AS user_id_4 FROM bolt_user_auth_token t0 WHERE t0.user_id = 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,
  t0.about AS about_13
FROM
  bolt_user t0
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, t0.about AS about_13 FROM bolt_user t0 WHERE t0.id IN (1);

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_5
    FROM
      (
        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
        FROM
          bolt_content b0_
        WHERE
          b0_.content_type = ?
          AND b0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_5 FROM (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 FROM bolt_content b0_ WHERE b0_.content_type = 'carousel' AND b0_.status = 'published') dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 20;