Symfony Profiler

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

-- seo-url::resolve
SELECT
  id,
  path_info pathInfo,
  is_canonical isCanonical,
  sales_channel_id salesChannelId
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (
    (
      seo_path_info = ?
      OR seo_path_info = ?
    )
  )

-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x019CFB6D02787E978A41DB540F96F09A OR sales_channel_id IS NULL)) AND ((seo_path_info = 'blog/nachhaltiger-mehrweg-coffee-to-go-thermobecher.-schoen-zu-bedrucken.' OR seo_path_info = 'blog/nachhaltiger-mehrweg-coffee-to-go-thermobecher.-schoen-zu-bedrucken./'));

SELECT
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`,
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`,
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`,
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`,
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`,
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`,
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`,
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`,
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`,
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`,
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`,
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`,
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`,
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`,
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`,
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`,
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`,
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`,
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`,
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`,
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt`
FROM
  `dreisc_seo_redirect`
WHERE
  (
    (
      `dreisc_seo_redirect`.`active` = ?
      AND `dreisc_seo_redirect`.`source_type` = ?
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ?
      AND `dreisc_seo_redirect`.`source_path` = ?
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'url' AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = 0x019CFB73A8AF7124BD9EA12B14D03726 AND `dreisc_seo_redirect`.`source_path` = 'blog/nachhaltiger-mehrweg-coffee-to-go-thermobecher.-schoen-zu-bedrucken.'));

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x019CFB6D02787E978A41DB540F96F09A) AND (token = 'y7fWQtzmXJM6jw6QceGDtcR2aW6WSdEF') LIMIT 1;

SELECT
  `sales_channel_country`.`sales_channel_id`,
  `sales_channel_country`.`country_id`
FROM
  `sales_channel_country`
WHERE
  (
    `sales_channel_country`.`sales_channel_id` = ?
    AND `sales_channel_country`.`country_id` = ?
  )

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = 0x019CFB6D02787E978A41DB540F96F09A AND `sales_channel_country`.`country_id` = 0xC93AF20030674C939DCC278F51D6CFD8);

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

SELECT
  `sas_blog_entries`.`id` as `sas_blog_entries.id`,
  `sas_blog_entries`.`active` as `sas_blog_entries.active`,
  `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`,
  `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`,
  `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`,
  `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`,
  `sas_blog_entries`.`index_sales_channel_id` as `sas_blog_entries.indexSalesChannelId`,
  `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`,
  `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`,
  `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`,
  `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`,
  `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`,
  `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`,
  `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`,
  `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`,
  `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`,
  `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`,
  `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`,
  `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`,
  `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`,
  `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`,
  `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`,
  `sas_blog_entries.media`.`file_hash` as `sas_blog_entries.media.fileHash`,
  `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`,
  `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`,
  `sas_blog_entries.media.translation.title`,
  `sas_blog_entries.media.translation.title` as `sas_blog_entries.media.title`,
  `sas_blog_entries.media.translation.alt`,
  `sas_blog_entries.media.translation.alt` as `sas_blog_entries.media.alt`,
  `sas_blog_entries.media.translation.customFields`,
  `sas_blog_entries.media.translation.customFields` as `sas_blog_entries.media.customFields`,
  `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`,
  `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`,
  `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`,
  `sas_blog_entries.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`,
  `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`,
  `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`,
  `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`,
  `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`,
  `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`,
  `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`,
  `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`,
  `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`,
  `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`,
  `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`,
  `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`,
  `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`,
  `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`,
  `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`,
  `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`,
  `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`,
  `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`,
  `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`,
  `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`,
  `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`,
  `sas_blog_entries.blogAuthor.media`.`file_hash` as `sas_blog_entries.blogAuthor.media.fileHash`,
  `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`,
  `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`,
  `sas_blog_entries.blogAuthor.media.translation.title`,
  `sas_blog_entries.blogAuthor.media.translation.title` as `sas_blog_entries.blogAuthor.media.title`,
  `sas_blog_entries.blogAuthor.media.translation.alt`,
  `sas_blog_entries.blogAuthor.media.translation.alt` as `sas_blog_entries.blogAuthor.media.alt`,
  `sas_blog_entries.blogAuthor.media.translation.customFields`,
  `sas_blog_entries.blogAuthor.media.translation.customFields` as `sas_blog_entries.blogAuthor.media.customFields`,
  `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`,
  `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`,
  `sas_blog_entries.blogAuthor.salutation`.`id` as `sas_blog_entries.blogAuthor.salutation.id`,
  `sas_blog_entries.blogAuthor.salutation`.`salutation_key` as `sas_blog_entries.blogAuthor.salutation.salutationKey`,
  `sas_blog_entries.blogAuthor.salutation`.`created_at` as `sas_blog_entries.blogAuthor.salutation.createdAt`,
  `sas_blog_entries.blogAuthor.salutation`.`updated_at` as `sas_blog_entries.blogAuthor.salutation.updatedAt`,
  `sas_blog_entries.blogAuthor.salutation.translation.displayName`,
  `sas_blog_entries.blogAuthor.salutation.translation.displayName` as `sas_blog_entries.blogAuthor.salutation.displayName`,
  `sas_blog_entries.blogAuthor.salutation.translation.letterName`,
  `sas_blog_entries.blogAuthor.salutation.translation.letterName` as `sas_blog_entries.blogAuthor.salutation.letterName`,
  `sas_blog_entries.blogAuthor.salutation.translation.customFields`,
  `sas_blog_entries.blogAuthor.salutation.translation.customFields` as `sas_blog_entries.blogAuthor.salutation.customFields`,
  `sas_blog_entries.blogAuthor.translation.description`,
  `sas_blog_entries.blogAuthor.translation.description` as `sas_blog_entries.blogAuthor.description`,
  `sas_blog_entries.blogAuthor.translation.customFields`,
  `sas_blog_entries.blogAuthor.translation.customFields` as `sas_blog_entries.blogAuthor.customFields`,
  (
    SELECT
      GROUP_CONCAT(
        HEX(
          `sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`
        ) SEPARATOR '||'
      )
    FROM
      `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping`
    WHERE
      `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id`
  ) as `sas_blog_entries.blogCategories.id_mapping`,
  `sas_blog_entries.translation.title`,
  `sas_blog_entries.translation.title` as `sas_blog_entries.title`,
  `sas_blog_entries.translation.slug`,
  `sas_blog_entries.translation.slug` as `sas_blog_entries.slug`,
  `sas_blog_entries.translation.teaser`,
  `sas_blog_entries.translation.teaser` as `sas_blog_entries.teaser`,
  `sas_blog_entries.translation.metaTitle`,
  `sas_blog_entries.translation.metaTitle` as `sas_blog_entries.metaTitle`,
  `sas_blog_entries.translation.metaDescription`,
  `sas_blog_entries.translation.metaDescription` as `sas_blog_entries.metaDescription`,
  `sas_blog_entries.translation.metaKeywords`,
  `sas_blog_entries.translation.metaKeywords` as `sas_blog_entries.metaKeywords`,
  `sas_blog_entries.translation.content`,
  `sas_blog_entries.translation.content` as `sas_blog_entries.content`,
  `sas_blog_entries.translation.customFields`,
  `sas_blog_entries.translation.customFields` as `sas_blog_entries.customFields`
FROM
  `sas_blog_entries`
  LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id`
  LEFT JOIN `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`id`
  LEFT JOIN (
    SELECT
      `sas_blog_entries.translation`.`sas_blog_entries_id`,
      `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields`,
      `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`,
      `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`,
      `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`,
      `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`,
      `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`,
      `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`,
      `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content`
    FROM
      `sas_blog_entries_translation` `sas_blog_entries.translation`
    WHERE
      `sas_blog_entries.translation`.`language_id` = ?
  ) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id`
  LEFT JOIN (
    SELECT
      `sas_blog_entries.media.translation`.`media_id`,
      `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`,
      `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`,
      `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields`
    FROM
      `media_translation` `sas_blog_entries.media.translation`
    WHERE
      `sas_blog_entries.media.translation`.`language_id` = ?
  ) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id`
  LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id`
  LEFT JOIN `salutation` `sas_blog_entries.blogAuthor.salutation` ON `sas_blog_entries.blogAuthor`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id`
  LEFT JOIN (
    SELECT
      `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`,
      `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`,
      `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields`
    FROM
      `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation`
    WHERE
      `sas_blog_entries.blogAuthor.translation`.`language_id` = ?
  ) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id`
  LEFT JOIN (
    SELECT
      `sas_blog_entries.blogAuthor.media.translation`.`media_id`,
      `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`,
      `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`,
      `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields`
    FROM
      `media_translation` `sas_blog_entries.blogAuthor.media.translation`
    WHERE
      `sas_blog_entries.blogAuthor.media.translation`.`language_id` = ?
  ) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id`
  LEFT JOIN (
    SELECT
      `sas_blog_entries.blogAuthor.salutation.translation`.`salutation_id`,
      `sas_blog_entries.blogAuthor.salutation.translation`.`display_name` as `sas_blog_entries.blogAuthor.salutation.translation.displayName`,
      `sas_blog_entries.blogAuthor.salutation.translation`.`letter_name` as `sas_blog_entries.blogAuthor.salutation.translation.letterName`,
      `sas_blog_entries.blogAuthor.salutation.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.salutation.translation.customFields`
    FROM
      `salutation_translation` `sas_blog_entries.blogAuthor.salutation.translation`
    WHERE
      `sas_blog_entries.blogAuthor.salutation.translation`.`language_id` = ?
  ) `sas_blog_entries.blogAuthor.salutation.salutation_translation` ON `sas_blog_entries.blogAuthor.salutation.salutation_translation`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id`
WHERE
  (
    (
      (
        COALESCE(
          IF(
            JSON_TYPE(
              JSON_EXTRACT(
                `sas_blog_entries.translation.customFields`,
                '$.salesChannelIds'
              )
            ) != "NULL",
            CONVERT(
              JSON_UNQUOTE(
                JSON_EXTRACT(
                  `sas_blog_entries.translation.customFields`,
                  '$.salesChannelIds'
                )
              ) USING "utf8mb4"
            ) COLLATE utf8mb4_unicode_ci,
            NULL
          )
        ) LIKE ?
        OR COALESCE(
          IF(
            JSON_TYPE(
              JSON_EXTRACT(
                `sas_blog_entries.translation.customFields`,
                '$.salesChannelIds'
              )
            ) != "NULL",
            CONVERT(
              JSON_UNQUOTE(
                JSON_EXTRACT(
                  `sas_blog_entries.translation.customFields`,
                  '$.salesChannelIds'
                )
              ) USING "utf8mb4"
            ) COLLATE utf8mb4_unicode_ci,
            NULL
          )
        ) <=> ?
      )
    )
  )
  AND (
    `sas_blog_entries`.`id` IN (?)
  )

SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`index_sales_channel_id` as `sas_blog_entries.indexSalesChannelId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`file_hash` as `sas_blog_entries.media.fileHash`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.title` as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.alt` as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.customFields` as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`, `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`, `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`, `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`, `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`, `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`, `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`, `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`, `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`, `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`, `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`, `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`, `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`, `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`, `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`, `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`, `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`, `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`, `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`, `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`, `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`, `sas_blog_entries.blogAuthor.media`.`file_hash` as `sas_blog_entries.blogAuthor.media.fileHash`, `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`, `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`, `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation.title` as `sas_blog_entries.blogAuthor.media.title`, `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation.alt` as `sas_blog_entries.blogAuthor.media.alt`, `sas_blog_entries.blogAuthor.media.translation.customFields`, `sas_blog_entries.blogAuthor.media.translation.customFields` as `sas_blog_entries.blogAuthor.media.customFields`, `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`, `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`, `sas_blog_entries.blogAuthor.salutation`.`id` as `sas_blog_entries.blogAuthor.salutation.id`, `sas_blog_entries.blogAuthor.salutation`.`salutation_key` as `sas_blog_entries.blogAuthor.salutation.salutationKey`, `sas_blog_entries.blogAuthor.salutation`.`created_at` as `sas_blog_entries.blogAuthor.salutation.createdAt`, `sas_blog_entries.blogAuthor.salutation`.`updated_at` as `sas_blog_entries.blogAuthor.salutation.updatedAt`, `sas_blog_entries.blogAuthor.salutation.translation.displayName`, `sas_blog_entries.blogAuthor.salutation.translation.displayName` as `sas_blog_entries.blogAuthor.salutation.displayName`, `sas_blog_entries.blogAuthor.salutation.translation.letterName`, `sas_blog_entries.blogAuthor.salutation.translation.letterName` as `sas_blog_entries.blogAuthor.salutation.letterName`, `sas_blog_entries.blogAuthor.salutation.translation.customFields`, `sas_blog_entries.blogAuthor.salutation.translation.customFields` as `sas_blog_entries.blogAuthor.salutation.customFields`, `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation.description` as `sas_blog_entries.blogAuthor.description`, `sas_blog_entries.blogAuthor.translation.customFields`, `sas_blog_entries.blogAuthor.translation.customFields` as `sas_blog_entries.blogAuthor.customFields`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`) SEPARATOR '||')
                  FROM `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping`
                  WHERE `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.blogCategories.id_mapping`, `sas_blog_entries.translation.title`, `sas_blog_entries.translation.title` as `sas_blog_entries.title`, `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.slug` as `sas_blog_entries.slug`, `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.teaser` as `sas_blog_entries.teaser`, `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.metaTitle` as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.metaDescription` as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.metaKeywords` as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.content`, `sas_blog_entries.translation.content` as `sas_blog_entries.content`, `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.customFields` as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields` FROM `media_translation` `sas_blog_entries.media.translation` WHERE `sas_blog_entries.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN `salutation` `sas_blog_entries.blogAuthor.salutation` ON `sas_blog_entries.blogAuthor`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`, `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields` FROM `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation` WHERE `sas_blog_entries.blogAuthor.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.media.translation`.`media_id`, `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields` FROM `media_translation` `sas_blog_entries.blogAuthor.media.translation` WHERE `sas_blog_entries.blogAuthor.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.salutation.translation`.`salutation_id`, `sas_blog_entries.blogAuthor.salutation.translation`.`display_name` as `sas_blog_entries.blogAuthor.salutation.translation.displayName`, `sas_blog_entries.blogAuthor.salutation.translation`.`letter_name` as `sas_blog_entries.blogAuthor.salutation.translation.letterName`, `sas_blog_entries.blogAuthor.salutation.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.salutation.translation.customFields` FROM `salutation_translation` `sas_blog_entries.blogAuthor.salutation.translation` WHERE `sas_blog_entries.blogAuthor.salutation.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_entries.blogAuthor.salutation.salutation_translation` ON `sas_blog_entries.blogAuthor.salutation.salutation_translation`.`salutation_id` = `sas_blog_entries.blogAuthor.salutation`.`id` WHERE (((COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE '%019cfb6d02787e978a41db540f96f09a%' OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> NULL))) AND (`sas_blog_entries`.`id` IN (0x3A179CA3A2824F2DB7B42FF05DD4163F));

SELECT
  `sas_blog_category`.`id` as `sas_blog_category.id`,
  `sas_blog_category`.`version_id` as `sas_blog_category.versionId`,
  `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`,
  `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`,
  `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`,
  `sas_blog_category`.`level` as `sas_blog_category.level`,
  `sas_blog_category`.`path` as `sas_blog_category.path`,
  `sas_blog_category`.`child_count` as `sas_blog_category.childCount`,
  `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`,
  `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`,
  `sas_blog_category.translation.name`,
  `sas_blog_category.translation.name` as `sas_blog_category.name`,
  `sas_blog_category.translation.metaTitle`,
  `sas_blog_category.translation.metaTitle` as `sas_blog_category.metaTitle`,
  `sas_blog_category.translation.metaDescription`,
  `sas_blog_category.translation.metaDescription` as `sas_blog_category.metaDescription`,
  `sas_blog_category.translation.keywords`,
  `sas_blog_category.translation.keywords` as `sas_blog_category.keywords`,
  `sas_blog_category.translation.breadcrumb`,
  `sas_blog_category.translation.breadcrumb` as `sas_blog_category.breadcrumb`,
  `sas_blog_category.translation.customFields`,
  `sas_blog_category.translation.customFields` as `sas_blog_category.customFields`
FROM
  `sas_blog_category`
  LEFT JOIN (
    SELECT
      `sas_blog_category.translation`.`sas_blog_category_id`,
      `sas_blog_category.translation`.`sas_blog_category_version_id`,
      `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`,
      `sas_blog_category.translation`.`meta_title` as `sas_blog_category.translation.metaTitle`,
      `sas_blog_category.translation`.`meta_description` as `sas_blog_category.translation.metaDescription`,
      `sas_blog_category.translation`.`keywords` as `sas_blog_category.translation.keywords`,
      `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`,
      `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb`
    FROM
      `sas_blog_category_translation` `sas_blog_category.translation`
    WHERE
      `sas_blog_category.translation`.`language_id` = ?
  ) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id`
  AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id`
WHERE
  (
    `sas_blog_category`.`version_id` = ?
  )
  AND (
    `sas_blog_category`.`id` IN (?)
  )

SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.name`, `sas_blog_category.translation.name` as `sas_blog_category.name`, `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation.metaTitle` as `sas_blog_category.metaTitle`, `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation.metaDescription` as `sas_blog_category.metaDescription`, `sas_blog_category.translation.keywords`, `sas_blog_category.translation.keywords` as `sas_blog_category.keywords`, `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.breadcrumb` as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.customFields`, `sas_blog_category.translation.customFields` as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation`.`meta_title` as `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation`.`meta_description` as `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation`.`keywords` as `sas_blog_category.translation.keywords`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` WHERE `sas_blog_category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`sas_blog_category`.`id` IN (0xE7EA2888F83145C49EBD578210389ADA));

SELECT
  `cms_page`.`id` as `cms_page.id`,
  `cms_page`.`version_id` as `cms_page.versionId`,
  `cms_page`.`type` as `cms_page.type`,
  `cms_page`.`entity` as `cms_page.entity`,
  `cms_page`.`css_class` as `cms_page.cssClass`,
  `cms_page`.`config` as `cms_page.config`,
  `cms_page`.`preview_media_id` as `cms_page.previewMediaId`,
  `cms_page`.`locked` as `cms_page.locked`,
  `cms_page`.`created_at` as `cms_page.createdAt`,
  `cms_page`.`updated_at` as `cms_page.updatedAt`,
  `cms_page.translation.name`,
  `cms_page.translation.name` as `cms_page.name`,
  `cms_page.translation.customFields`,
  `cms_page.translation.customFields` as `cms_page.customFields`
FROM
  `cms_page`
  LEFT JOIN (
    SELECT
      `cms_page.translation`.`cms_page_id`,
      `cms_page.translation`.`cms_page_version_id`,
      `cms_page.translation`.`name` as `cms_page.translation.name`,
      `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields`
    FROM
      `cms_page_translation` `cms_page.translation`
    WHERE
      `cms_page.translation`.`language_id` = ?
  ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id`
  AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id`
WHERE
  (`cms_page`.`version_id` = ?)
  AND (
    `cms_page`.`id` IN (?)
  )

SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`cms_page`.`id` IN (0x018B1F32870072AB86B063CC07D7D820));

SELECT
  `cms_section`.`id` as `cms_section.id`,
  `cms_section`.`version_id` as `cms_section.versionId`,
  `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`,
  `cms_section`.`position` as `cms_section.position`,
  `cms_section`.`type` as `cms_section.type`,
  `cms_section`.`locked` as `cms_section.locked`,
  `cms_section`.`name` as `cms_section.name`,
  `cms_section`.`sizing_mode` as `cms_section.sizingMode`,
  `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`,
  `cms_section`.`background_color` as `cms_section.backgroundColor`,
  `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`,
  `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`,
  `cms_section`.`css_class` as `cms_section.cssClass`,
  `cms_section`.`cms_page_id` as `cms_section.pageId`,
  `cms_section`.`visibility` as `cms_section.visibility`,
  `cms_section`.`custom_fields` as `cms_section.customFields`,
  `cms_section`.`created_at` as `cms_section.createdAt`,
  `cms_section`.`updated_at` as `cms_section.updatedAt`,
  `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`,
  `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`,
  `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`,
  `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`,
  `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`,
  `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`,
  `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`,
  `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`,
  `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`,
  `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`,
  `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`,
  `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`,
  `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`,
  `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`,
  `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`,
  `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`,
  `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`,
  `cms_section.backgroundMedia.translation.title`,
  `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`,
  `cms_section.backgroundMedia.translation.alt`,
  `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`,
  `cms_section.backgroundMedia.translation.customFields`,
  `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
  `cms_section`
  LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id`
  LEFT JOIN (
    SELECT
      `cms_section.backgroundMedia.translation`.`media_id`,
      `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`,
      `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`,
      `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`
    FROM
      `media_translation` `cms_section.backgroundMedia.translation`
    WHERE
      `cms_section.backgroundMedia.translation`.`language_id` = ?
  ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id`
WHERE
  (`cms_section`.`version_id` = ?)
  AND (
    (
      (
        `cms_section`.`cms_page_id` IN (?)
      )
    )
  )

SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`cms_section`.`cms_page_id` IN (0x018B1F32870072AB86B063CC07D7D820))));