Symfony Profiler

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;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.import_value AS import_value_3,
  t0.sort AS sort_4,
  t0.image_id AS image_id_5,
  t0.main_parent_id AS main_parent_id_6
FROM
  bolt_catalog_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.import_value AS import_value_3, t0.sort AS sort_4, t0.image_id AS image_id_5, t0.main_parent_id AS main_parent_id_6 FROM bolt_catalog_category t0 WHERE t0.slug = 'meble-socjalne' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.import_value AS import_value_3,
  t0.sort AS sort_4,
  t0.image_id AS image_id_5,
  t0.main_parent_id AS main_parent_id_6
FROM
  bolt_catalog_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.import_value AS import_value_3, t0.sort AS sort_4, t0.image_id AS image_id_5, t0.main_parent_id AS main_parent_id_6 FROM bolt_catalog_category t0 WHERE t0.slug = 'nadstawki' LIMIT 1;

SELECT
  b0_.id AS id_0,
  b0_.slug AS slug_1,
  b0_.import_value AS import_value_2,
  b0_.sort AS sort_3,
  b1_.id AS id_4,
  b1_.sort AS sort_5,
  b2_.id AS id_6,
  b2_.slug AS slug_7,
  b2_.import_value AS import_value_8,
  b0_.image_id AS image_id_9,
  b0_.main_parent_id AS main_parent_id_10,
  b1_.family_id AS family_id_11,
  b1_.category_id AS category_id_12,
  b2_.image_id AS image_id_13,
  b2_.main_category_id AS main_category_id_14,
  b2_.main_product_id AS main_product_id_15
FROM
  bolt_catalog_category b0_
  INNER JOIN bolt_catalog_category_category b3_ ON b0_.id = b3_.child_id
  INNER JOIN bolt_catalog_category b4_ ON b3_.parent_id = b4_.id
  INNER JOIN bolt_catalog_family_category b1_ ON b0_.id = b1_.category_id
  INNER JOIN bolt_catalog_family b2_ ON b1_.family_id = b2_.id
  INNER JOIN bolt_catalog_product b5_ ON b2_.id = b5_.family_id
  INNER JOIN bolt_catalog_colorable_element b6_ ON b5_.id = b6_.product_id
  INNER JOIN bolt_catalog_color_variant b7_ ON b6_.id = b7_.colorable_element_id
WHERE
  b4_.id = ?
  AND b5_.configurable = 1
GROUP BY
  b2_.id
ORDER BY
  b3_.sort ASC,
  b1_.sort ASC

SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.import_value AS import_value_2, b0_.sort AS sort_3, b1_.id AS id_4, b1_.sort AS sort_5, b2_.id AS id_6, b2_.slug AS slug_7, b2_.import_value AS import_value_8, b0_.image_id AS image_id_9, b0_.main_parent_id AS main_parent_id_10, b1_.family_id AS family_id_11, b1_.category_id AS category_id_12, b2_.image_id AS image_id_13, b2_.main_category_id AS main_category_id_14, b2_.main_product_id AS main_product_id_15 FROM bolt_catalog_category b0_ INNER JOIN bolt_catalog_category_category b3_ ON b0_.id = b3_.child_id INNER JOIN bolt_catalog_category b4_ ON b3_.parent_id = b4_.id INNER JOIN bolt_catalog_family_category b1_ ON b0_.id = b1_.category_id INNER JOIN bolt_catalog_family b2_ ON b1_.family_id = b2_.id INNER JOIN bolt_catalog_product b5_ ON b2_.id = b5_.family_id INNER JOIN bolt_catalog_colorable_element b6_ ON b5_.id = b6_.product_id INNER JOIN bolt_catalog_color_variant b7_ ON b6_.id = b7_.colorable_element_id WHERE b4_.id = 8 AND b5_.configurable = 1 GROUP BY b2_.id ORDER BY b3_.sort ASC, b1_.sort ASC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54934;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54931;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54933;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54935;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 55532;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 55995;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54940;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54937;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54939;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54938;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.bolt_media_id AS bolt_media_id_3
FROM
  bolt_app_storage_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.bolt_media_id AS bolt_media_id_3 FROM bolt_app_storage_media t0 WHERE t0.id = 54942;

SELECT
  b0_.id AS id_0,
  b0_.slug AS slug_1,
  b0_.import_value AS import_value_2,
  b0_.image_id AS image_id_3,
  b0_.main_category_id AS main_category_id_4,
  b0_.main_product_id AS main_product_id_5
FROM
  bolt_catalog_family b0_
  INNER JOIN bolt_catalog_family_category b1_ ON b0_.id = b1_.family_id
  INNER JOIN bolt_catalog_product b2_ ON b0_.id = b2_.family_id
  INNER JOIN bolt_catalog_colorable_element b3_ ON b2_.id = b3_.product_id
  INNER JOIN bolt_catalog_color_variant b4_ ON b3_.id = b4_.colorable_element_id
WHERE
  b1_.category_id = ?
  AND b2_.configurable = 1

SELECT b0_.id AS id_0, b0_.slug AS slug_1, b0_.import_value AS import_value_2, b0_.image_id AS image_id_3, b0_.main_category_id AS main_category_id_4, b0_.main_product_id AS main_product_id_5 FROM bolt_catalog_family b0_ INNER JOIN bolt_catalog_family_category b1_ ON b0_.id = b1_.family_id INNER JOIN bolt_catalog_product b2_ ON b0_.id = b2_.family_id INNER JOIN bolt_catalog_colorable_element b3_ ON b2_.id = b3_.product_id INNER JOIN bolt_catalog_color_variant b4_ ON b3_.id = b4_.colorable_element_id WHERE b1_.category_id = 32 AND b2_.configurable = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  bolt_catalog_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM bolt_catalog_category_translation t0 WHERE t0.translatable_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  bolt_catalog_family_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM bolt_catalog_family_translation t0 WHERE t0.translatable_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  bolt_catalog_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM bolt_catalog_category_translation t0 WHERE t0.translatable_id = 32;

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
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'date', 'hidden',
            'html', 'image', 'number', 'email',
            'set', 'imagelist', 'templateselect',
            'embed', 'data', 'filelist', 'block',
            'slug', 'markdown', 'checkbox', 'text',
            'collection', 'file', 'textarea',
            'article', 'ckeditor', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              CAST(
                JSON_UNQUOTE(
                  JSON_EXTRACT(b2_.value, '$[0]')
                ) AS CHAR
              ) = ?
              AND b1_.parent_id IS NULL
              AND b1_.name = ?
            )
            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 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'blog' AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = 'true' AND b1_.parent_id IS NULL AND b1_.name = 'visible_pl') AND b0_.status = 'published') 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
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
          AND b1_.type IN (
            'generic', 'select', 'date', 'hidden',
            'html', 'image', 'number', 'email',
            'set', 'imagelist', 'templateselect',
            'embed', 'data', 'filelist', 'block',
            'slug', 'markdown', 'checkbox', 'text',
            'collection', 'file', 'textarea',
            'article', 'ckeditor', 'redactor'
          )
          LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              CAST(
                JSON_UNQUOTE(
                  JSON_EXTRACT(b2_.value, '$[0]')
                ) AS CHAR
              ) = ?
              AND b1_.parent_id IS NULL
              AND b1_.name = ?
            )
            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 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'aktualnosci' AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = 'true' AND b1_.parent_id IS NULL AND b1_.name = 'visible_pl') AND b0_.status = 'published') ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

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,
          b1_.id AS id_7,
          b1_.value AS value_8,
          b1_.locale AS locale_9,
          b2_.id AS id_10,
          b2_.name AS name_11,
          b2_.sortorder AS sortorder_12,
          b2_.version AS version_13,
          b2_.type AS type_14
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id
          AND b2_.type IN (
            'generic', 'select', 'date', 'hidden',
            'html', 'image', 'number', 'email',
            'set', 'imagelist', 'templateselect',
            'embed', 'data', 'filelist', 'block',
            'slug', 'markdown', 'checkbox', 'text',
            'collection', 'file', 'textarea',
            'article', 'ckeditor', 'redactor'
          )
          LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              CAST(
                JSON_UNQUOTE(
                  JSON_EXTRACT(b1_.value, '$[0]')
                ) AS CHAR
              ) = ?
              AND b2_.parent_id IS NULL
              AND b2_.name = ?
            )
            AND b0_.status = ?
          )
        ORDER BY
          b2_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  2

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, b1_.id AS id_7, b1_.value AS value_8, b1_.locale AS locale_9, b2_.id AS id_10, b2_.name AS name_11, b2_.sortorder AS sortorder_12, b2_.version AS version_13, b2_.type AS type_14 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = 'aktualnosci' AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b1_.value, '$[0]')) AS CHAR) = 'true' AND b2_.parent_id IS NULL AND b2_.name = 'visible_pl') AND b0_.status = 'published') ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result LIMIT 2;

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_.author_id AS author_id_7
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'date', 'hidden',
    'html', 'image', 'number', 'email',
    'set', 'imagelist', 'templateselect',
    'embed', 'data', 'filelist', 'block',
    'slug', 'markdown', 'checkbox', 'text',
    'collection', 'file', 'textarea',
    'article', 'ckeditor', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND (
    (
      CAST(
        JSON_UNQUOTE(
          JSON_EXTRACT(b2_.value, '$[0]')
        ) AS CHAR
      ) = ?
      AND b1_.parent_id IS NULL
      AND b1_.name = ?
    )
    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_.author_id AS author_id_7 FROM bolt_content b0_ LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id AND b1_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id WHERE b0_.content_type = 'aktualnosci' AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b2_.value, '$[0]')) AS CHAR) = 'true' AND b1_.parent_id IS NULL AND b1_.name = 'visible_pl') AND b0_.status = 'published') AND b0_.id IN (316, 315) ORDER BY b0_.published_at DESC;

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
  bolt_field t0
  INNER JOIN bolt_content t7 ON t0.content_id = t7.id
WHERE
  t0.content_id = ?
  AND t0.type IN (
    'generic', 'select', 'date', 'hidden',
    'html', 'image', 'number', 'email',
    'set', 'imagelist', 'templateselect',
    'embed', 'data', 'filelist', 'block',
    'slug', 'markdown', 'checkbox', 'text',
    'collection', 'file', 'textarea',
    'article', 'ckeditor', '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 bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = 316 AND t0.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') ORDER BY t0.sortorder ASC;

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
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 FROM bolt_user t0 WHERE t0.id IN (3);

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 = 3;

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
  bolt_field t0
  INNER JOIN bolt_content t7 ON t0.content_id = t7.id
WHERE
  t0.content_id = ?
  AND t0.type IN (
    'generic', 'select', 'date', 'hidden',
    'html', 'image', 'number', 'email',
    'set', 'imagelist', 'templateselect',
    'embed', 'data', 'filelist', 'block',
    'slug', 'markdown', 'checkbox', 'text',
    'collection', 'file', 'textarea',
    'article', 'ckeditor', '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 bolt_field t0 INNER JOIN bolt_content t7 ON t0.content_id = t7.id WHERE t0.content_id = 315 AND t0.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') ORDER BY t0.sortorder ASC;

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,
          b1_.id AS id_7,
          b1_.value AS value_8,
          b1_.locale AS locale_9,
          b2_.id AS id_10,
          b2_.name AS name_11,
          b2_.sortorder AS sortorder_12,
          b2_.version AS version_13,
          b2_.type AS type_14
        FROM
          bolt_content b0_
          LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id
          AND b2_.type IN (
            'generic', 'select', 'date', 'hidden',
            'html', 'image', 'number', 'email',
            'set', 'imagelist', 'templateselect',
            'embed', 'data', 'filelist', 'block',
            'slug', 'markdown', 'checkbox', 'text',
            'collection', 'file', 'textarea',
            'article', 'ckeditor', 'redactor'
          )
          LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id
        WHERE
          b0_.content_type = ?
          AND (
            (
              CAST(
                JSON_UNQUOTE(
                  JSON_EXTRACT(b1_.value, '$[0]')
                ) AS CHAR
              ) = ?
              AND b2_.parent_id IS NULL
              AND b2_.name = ?
            )
            AND b0_.status = ?
          )
        ORDER BY
          b2_.sortorder ASC
      ) dctrn_result_inner
    ORDER BY
      published_at_5 DESC
  ) dctrn_result
LIMIT
  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, b1_.id AS id_7, b1_.value AS value_8, b1_.locale AS locale_9, b2_.id AS id_10, b2_.name AS name_11, b2_.sortorder AS sortorder_12, b2_.version AS version_13, b2_.type AS type_14 FROM bolt_content b0_ LEFT JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'date', 'hidden', 'html', 'image', 'number', 'email', 'set', 'imagelist', 'templateselect', 'embed', 'data', 'filelist', 'block', 'slug', 'markdown', 'checkbox', 'text', 'collection', 'file', 'textarea', 'article', 'ckeditor', 'redactor') LEFT JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.content_type = 'blog' AND ((CAST(JSON_UNQUOTE(JSON_EXTRACT(b1_.value, '$[0]')) AS CHAR) = 'true' AND b2_.parent_id IS NULL AND b2_.name = 'visible_pl') AND b0_.status = 'published') ORDER BY b2_.sortorder ASC) dctrn_result_inner ORDER BY published_at_5 DESC) dctrn_result 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_.author_id AS author_id_7
FROM
  bolt_content b0_
  LEFT JOIN bolt_field b1_ ON b0_.id = b1_.content_id
  AND b1_.type IN (
    'generic', 'select', 'date', 'hidden',
    'html', 'image', 'number', 'email',
    'set', 'imagelist', 'templateselect',
    'embed', 'data', 'filelist', 'block',
    'slug', 'markdown', 'checkbox', 'text',
    'collection', 'file', 'textarea',
    'article', 'ckeditor', 'redactor'
  )
  LEFT JOIN bolt_field_translation b2_ ON b1_.id = b2_.translatable_id
WHERE
  b0_.content_type = ?
  AND (
    (
      CAST(
        JSON_UNQUOTE(
          JSON_EXTRACT(b2_.value, '$[0]')
        ) AS CHAR
      ) = ?
      AND b1_.parent_id IS NULL
      AND b1_.name = ?
    )
    AND b0_.status = ?
  )
  AND b0_.id IN (?)
ORDER BY
  b0_.published_at DESC