Symfony Profiler

-- theme-service::resolve-media::read
SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`file_hash` as `media.fileHash`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.override_1.title`,
  `media.translation.title`,
  COALESCE(
    `media.translation.override_1.title`,
    `media.translation.title`
  ) as `media.title`,
  `media.translation.override_1.alt`,
  `media.translation.alt`,
  COALESCE(
    `media.translation.override_1.alt`,
    `media.translation.alt`
  ) as `media.alt`,
  `media.translation.override_1.customFields`,
  `media.translation.customFields`,
  COALESCE(
    `media.translation.override_1.customFields`,
    `media.translation.customFields`
  ) as `media.customFields`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.`media_id`,
      `media.translation`.`alt` as `media.translation.alt`,
      `media.translation.override_1`.`alt` as `media.translation.override_1.alt`,
      `media.translation`.`title` as `media.translation.title`,
      `media.translation.override_1`.`title` as `media.translation.override_1.title`,
      `media.translation`.`custom_fields` as `media.translation.customFields`,
      `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields`
    FROM
      `media_translation` `media.translation`
      LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id`
      AND `media.translation.override_1`.`language_id` = ?
    WHERE
      `media.translation`.`language_id` = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      (
        `media`.`private` = ?
        OR (
          `media`.`private` = ?
          AND `media.mediaFolder.defaultFolder`.`entity` = ?
        )
      )
    )
  )
  AND (
    `media`.`id` IN (?, ?)
  )

-- theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.customFields`,`media.translation.customFields`) as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = 0x91CE056A4E3443F19FB7F03FCC1719AD WHERE `media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')))) AND (`media`.`id` IN (0x56E196B6D3CF46EDBB6C3A40ACF57755, 0x54FDB1EB7B714CE687A362709C8750BF));

-- header::navigation::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.media`.`id` as `category.media.id`,
  `category.media`.`user_id` as `category.media.userId`,
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`,
  `category.media`.`mime_type` as `category.media.mimeType`,
  `category.media`.`file_extension` as `category.media.fileExtension`,
  `category.media`.`uploaded_at` as `category.media.uploadedAt`,
  `category.media`.`file_name` as `category.media.fileName`,
  `category.media`.`file_size` as `category.media.fileSize`,
  `category.media`.`media_type` as `category.media.mediaTypeRaw`,
  `category.media`.`meta_data` as `category.media.metaData`,
  `category.media`.`config` as `category.media.config`,
  `category.media`.`path` as `category.media.path`,
  `category.media`.`private` as `category.media.private`,
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`,
  `category.media`.`file_hash` as `category.media.fileHash`,
  `category.media`.`created_at` as `category.media.createdAt`,
  `category.media`.`updated_at` as `category.media.updatedAt`,
  `category.media.translation.override_1.title`,
  `category.media.translation.title`,
  COALESCE(
    `category.media.translation.override_1.title`,
    `category.media.translation.title`
  ) as `category.media.title`,
  `category.media.translation.override_1.alt`,
  `category.media.translation.alt`,
  COALESCE(
    `category.media.translation.override_1.alt`,
    `category.media.translation.alt`
  ) as `category.media.alt`,
  `category.media.translation.override_1.customFields`,
  `category.media.translation.customFields`,
  COALESCE(
    `category.media.translation.override_1.customFields`,
    `category.media.translation.customFields`
  ) as `category.media.customFields`,
  `category.translation.override_1.name`,
  `category.translation.name`,
  COALESCE(
    `category.translation.override_1.name`,
    `category.translation.name`
  ) as `category.name`,
  `category.translation.override_1.breadcrumb`,
  `category.translation.breadcrumb`,
  COALESCE(
    `category.translation.override_1.breadcrumb`,
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`,
  `category.translation.override_1.slotConfig`,
  `category.translation.slotConfig`,
  COALESCE(
    `category.translation.override_1.slotConfig`,
    `category.translation.slotConfig`
  ) as `category.slotConfig`,
  `category.translation.override_1.linkType`,
  `category.translation.linkType`,
  COALESCE(
    `category.translation.override_1.linkType`,
    `category.translation.linkType`
  ) as `category.linkType`,
  `category.translation.override_1.internalLink`,
  `category.translation.internalLink`,
  COALESCE(
    `category.translation.override_1.internalLink`,
    `category.translation.internalLink`
  ) as `category.internalLink`,
  `category.translation.override_1.externalLink`,
  `category.translation.externalLink`,
  COALESCE(
    `category.translation.override_1.externalLink`,
    `category.translation.externalLink`
  ) as `category.externalLink`,
  `category.translation.override_1.linkNewTab`,
  `category.translation.linkNewTab`,
  COALESCE(
    `category.translation.override_1.linkNewTab`,
    `category.translation.linkNewTab`
  ) as `category.linkNewTab`,
  `category.translation.override_1.description`,
  `category.translation.description`,
  COALESCE(
    `category.translation.override_1.description`,
    `category.translation.description`
  ) as `category.description`,
  `category.translation.override_1.metaTitle`,
  `category.translation.metaTitle`,
  COALESCE(
    `category.translation.override_1.metaTitle`,
    `category.translation.metaTitle`
  ) as `category.metaTitle`,
  `category.translation.override_1.metaDescription`,
  `category.translation.metaDescription`,
  COALESCE(
    `category.translation.override_1.metaDescription`,
    `category.translation.metaDescription`
  ) as `category.metaDescription`,
  `category.translation.override_1.keywords`,
  `category.translation.keywords`,
  COALESCE(
    `category.translation.override_1.keywords`,
    `category.translation.keywords`
  ) as `category.keywords`,
  `category.translation.override_1.customFields`,
  `category.translation.customFields`,
  COALESCE(
    `category.translation.override_1.customFields`,
    `category.translation.customFields`
  ) as `category.customFields`
FROM
  `category`
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation.override_1`.`name` as `category.translation.override_1.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation.override_1`.`description` as `category.translation.override_1.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`,
      `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords`
    FROM
      `category_translation` `category.translation`
      LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id`
      AND `category.translation.override_1`.`language_id` = ?
      AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
  LEFT JOIN (
    SELECT
      `category.media.translation`.`media_id`,
      `category.media.translation`.`alt` as `category.media.translation.alt`,
      `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`,
      `category.media.translation`.`title` as `category.media.translation.title`,
      `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`,
      `category.media.translation`.`custom_fields` as `category.media.translation.customFields`,
      `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields`
    FROM
      `media_translation` `category.media.translation`
      LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id`
      AND `category.media.translation.override_1`.`language_id` = ?
    WHERE
      `category.media.translation`.`language_id` = ?
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    (
      (
        `category`.`id` = ?
        OR (
          `category`.`path` LIKE ?
          AND (
            `category`.`level` > ?
            AND `category`.`level` <= ?
          )
        )
      )
    )
  )

-- header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.translation.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.customFields`,`category.translation.customFields`) as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = 0x91CE056A4E3443F19FB7F03FCC1719AD AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = 0x91CE056A4E3443F19FB7F03FCC1719AD WHERE `category.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`category`.`id` = 0xCFC54478359B478EA0E17B5C0D94A2AF OR (`category`.`path` LIKE '%|cfc54478359b478ea0e17b5c0d94a2af|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4)))));

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

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

#cart-persister::load
SELECT
  `cart`.`payload`,
  `cart`.`rule_ids`,
  `cart`.`compressed`
FROM
  cart
WHERE
  `token` = ?

#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = 'GnimdPZpkPPQPBAx8exEXz3nFNF8qu8X';

-- cart-rule-loader::load-rules::search-ids
SELECT
  `rule`.`id`
FROM
  `rule`
WHERE
  (`rule`.`invalid` = ?)
ORDER BY
  `rule`.`priority` DESC,
  `rule`.`id` ASC
LIMIT
  500

-- cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = 0) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500;

-- app-scripts::refresh::search-ids
SELECT
  `app`.`id`
FROM
  `app`
WHERE
  (
    `app`.`active` = ?
    AND `app`.`self_managed` = ?
  )

-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = 1 AND `app`.`self_managed` = 0);

-- acris_checkout_method_preselect_shipping_selection::read
SELECT
  `shipping_method`.`id` as `shipping_method.id`,
  `shipping_method`.`technical_name` as `shipping_method.technicalName`,
  `shipping_method`.`active` as `shipping_method.active`,
  `shipping_method`.`position` as `shipping_method.position`,
  `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`,
  `shipping_method`.`media_id` as `shipping_method.mediaId`,
  `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`,
  `shipping_method`.`tax_type` as `shipping_method.taxType`,
  `shipping_method`.`tax_id` as `shipping_method.taxId`,
  `shipping_method`.`created_at` as `shipping_method.createdAt`,
  `shipping_method`.`updated_at` as `shipping_method.updatedAt`,
  `shipping_method.media`.`id` as `shipping_method.media.id`,
  `shipping_method.media`.`user_id` as `shipping_method.media.userId`,
  `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`,
  `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`,
  `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`,
  `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`,
  `shipping_method.media`.`file_name` as `shipping_method.media.fileName`,
  `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`,
  `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`,
  `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`,
  `shipping_method.media`.`config` as `shipping_method.media.config`,
  `shipping_method.media`.`path` as `shipping_method.media.path`,
  `shipping_method.media`.`private` as `shipping_method.media.private`,
  `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`,
  `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`,
  `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`,
  `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`,
  `shipping_method.media.translation.override_1.title`,
  `shipping_method.media.translation.title`,
  COALESCE(
    `shipping_method.media.translation.override_1.title`,
    `shipping_method.media.translation.title`
  ) as `shipping_method.media.title`,
  `shipping_method.media.translation.override_1.alt`,
  `shipping_method.media.translation.alt`,
  COALESCE(
    `shipping_method.media.translation.override_1.alt`,
    `shipping_method.media.translation.alt`
  ) as `shipping_method.media.alt`,
  `shipping_method.media.translation.override_1.customFields`,
  `shipping_method.media.translation.customFields`,
  COALESCE(
    `shipping_method.media.translation.override_1.customFields`,
    `shipping_method.media.translation.customFields`
  ) as `shipping_method.media.customFields`,
  `shipping_method.translation.override_1.name`,
  `shipping_method.translation.name`,
  COALESCE(
    `shipping_method.translation.override_1.name`,
    `shipping_method.translation.name`
  ) as `shipping_method.name`,
  `shipping_method.translation.override_1.description`,
  `shipping_method.translation.description`,
  COALESCE(
    `shipping_method.translation.override_1.description`,
    `shipping_method.translation.description`
  ) as `shipping_method.description`,
  `shipping_method.translation.override_1.trackingUrl`,
  `shipping_method.translation.trackingUrl`,
  COALESCE(
    `shipping_method.translation.override_1.trackingUrl`,
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`,
  `shipping_method.translation.override_1.customFields`,
  `shipping_method.translation.customFields`,
  COALESCE(
    `shipping_method.translation.override_1.customFields`,
    `shipping_method.translation.customFields`
  ) as `shipping_method.customFields`
FROM
  `shipping_method`
  LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.translation`.`shipping_method_id`,
      `shipping_method.translation`.`name` as `shipping_method.translation.name`,
      `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`,
      `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`,
      `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`,
      `shipping_method.translation`.`description` as `shipping_method.translation.description`,
      `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`,
      `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`,
      `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl`
    FROM
      `shipping_method_translation` `shipping_method.translation`
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id`
      AND `shipping_method.translation.override_1`.`language_id` = ?
    WHERE
      `shipping_method.translation`.`language_id` = ?
  ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.media.translation`.`media_id`,
      `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`,
      `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`,
      `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`,
      `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`,
      `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`,
      `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields`
    FROM
      `media_translation` `shipping_method.media.translation`
      LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id`
      AND `shipping_method.media.translation.override_1`.`language_id` = ?
    WHERE
      `shipping_method.media.translation`.`language_id` = ?
  ) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id`
WHERE
  `shipping_method`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?)

-- acris_checkout_method_preselect_shipping_selection::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = 0x91CE056A4E3443F19FB7F03FCC1719AD WHERE `shipping_method.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = 0x91CE056A4E3443F19FB7F03FCC1719AD WHERE `shipping_method.media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (0xD18E12CB265F48DC87626D17AD3EDC6C, 0x4A2BBA6FA56E4990A2FD4E89587D5D88, 0x28ACDE2EE5C6455CA35EC8D36998D5BE, 0xCA90EC38B9A34840A97BE39E259EC4CE, 0xDEC56253995A44CEA5C9CE8E4201B720, 0xEABD793079874B7A8937B9E6E1E83255, 0x9CEF52648A2E418589562D765E31414D, 0x52DE89DA97324BCFAD5C0CA90638A99C, 0xA83913655705492CB625677DFB42597A);

-- acris_checkout_method_preselect_payment_selection::read
SELECT
  `payment_method`.`id` as `payment_method.id`,
  `payment_method`.`plugin_id` as `payment_method.pluginId`,
  `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`,
  `payment_method`.`position` as `payment_method.position`,
  `payment_method`.`active` as `payment_method.active`,
  `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`,
  `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`,
  `payment_method`.`media_id` as `payment_method.mediaId`,
  `payment_method`.`technical_name` as `payment_method.technicalName`,
  `payment_method`.`created_at` as `payment_method.createdAt`,
  `payment_method`.`updated_at` as `payment_method.updatedAt`,
  `payment_method.media`.`id` as `payment_method.media.id`,
  `payment_method.media`.`user_id` as `payment_method.media.userId`,
  `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`,
  `payment_method.media`.`mime_type` as `payment_method.media.mimeType`,
  `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`,
  `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`,
  `payment_method.media`.`file_name` as `payment_method.media.fileName`,
  `payment_method.media`.`file_size` as `payment_method.media.fileSize`,
  `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`,
  `payment_method.media`.`meta_data` as `payment_method.media.metaData`,
  `payment_method.media`.`config` as `payment_method.media.config`,
  `payment_method.media`.`path` as `payment_method.media.path`,
  `payment_method.media`.`private` as `payment_method.media.private`,
  `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`,
  `payment_method.media`.`file_hash` as `payment_method.media.fileHash`,
  `payment_method.media`.`created_at` as `payment_method.media.createdAt`,
  `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`,
  `payment_method.media.translation.override_1.title`,
  `payment_method.media.translation.title`,
  COALESCE(
    `payment_method.media.translation.override_1.title`,
    `payment_method.media.translation.title`
  ) as `payment_method.media.title`,
  `payment_method.media.translation.override_1.alt`,
  `payment_method.media.translation.alt`,
  COALESCE(
    `payment_method.media.translation.override_1.alt`,
    `payment_method.media.translation.alt`
  ) as `payment_method.media.alt`,
  `payment_method.media.translation.override_1.customFields`,
  `payment_method.media.translation.customFields`,
  COALESCE(
    `payment_method.media.translation.override_1.customFields`,
    `payment_method.media.translation.customFields`
  ) as `payment_method.media.customFields`,
  `payment_method.translation.override_1.name`,
  `payment_method.translation.name`,
  COALESCE(
    `payment_method.translation.override_1.name`,
    `payment_method.translation.name`
  ) as `payment_method.name`,
  `payment_method.translation.override_1.distinguishableName`,
  `payment_method.translation.distinguishableName`,
  COALESCE(
    `payment_method.translation.override_1.distinguishableName`,
    `payment_method.translation.distinguishableName`
  ) as `payment_method.distinguishableName`,
  `payment_method.translation.override_1.description`,
  `payment_method.translation.description`,
  COALESCE(
    `payment_method.translation.override_1.description`,
    `payment_method.translation.description`
  ) as `payment_method.description`,
  `payment_method.translation.override_1.customFields`,
  `payment_method.translation.customFields`,
  COALESCE(
    `payment_method.translation.override_1.customFields`,
    `payment_method.translation.customFields`
  ) as `payment_method.customFields`
FROM
  `payment_method`
  LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.translation`.`payment_method_id`,
      `payment_method.translation`.`name` as `payment_method.translation.name`,
      `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`,
      `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`,
      `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`,
      `payment_method.translation`.`description` as `payment_method.translation.description`,
      `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`,
      `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`,
      `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields`
    FROM
      `payment_method_translation` `payment_method.translation`
      LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id`
      AND `payment_method.translation.override_1`.`language_id` = ?
    WHERE
      `payment_method.translation`.`language_id` = ?
  ) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id`
  LEFT JOIN (
    SELECT
      `payment_method.media.translation`.`media_id`,
      `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`,
      `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`,
      `payment_method.media.translation`.`title` as `payment_method.media.translation.title`,
      `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`,
      `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`,
      `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields`
    FROM
      `media_translation` `payment_method.media.translation`
      LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id`
      AND `payment_method.media.translation.override_1`.`language_id` = ?
    WHERE
      `payment_method.media.translation`.`language_id` = ?
  ) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id`
WHERE
  `payment_method`.`id` IN (?, ?, ?, ?, ?, ?)