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

SELECT
  `dvsn_quick_cart`.`id`
FROM
  `dvsn_quick_cart`
WHERE
  (
    `dvsn_quick_cart`.`seo_url` = ?
    AND `dvsn_quick_cart`.`active` = ?
  )

SELECT `dvsn_quick_cart`.`id` FROM `dvsn_quick_cart` WHERE (`dvsn_quick_cart`.`seo_url` = 'haengelampen' AND `dvsn_quick_cart`.`active` = 1);

# 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 = 0x45BE4EF5BC5541119CC81BAC1AED1CEF) AND ((sales_channel_id = 0xE85BABB2BD37438182BC2D7094175BD3 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'haengelampen' OR seo_path_info = 'haengelampen/'));

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_category_id` = ?
    )
  )

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` = 'category' AND `dreisc_seo_redirect`.`source_category_id` = 0xA86C73B791BD45DC917EF51A3F0D37F7));

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` = 0x9B755BC820FA4B74A5D37766E802CD1B AND `dreisc_seo_redirect`.`source_path` = 'haengelampen'));

SELECT
  `name`,
  `path`,
  `author`,
  `self_managed`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
            ;

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

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xE85BABB2BD37438182BC2D7094175BD3) AND (token = 'Xy6P1hf4xaYzgjSXDlfzWrfwRClSkaj5') 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` = 'Xy6P1hf4xaYzgjSXDlfzWrfwRClSkaj5';

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` = 0xE85BABB2BD37438182BC2D7094175BD3 AND `sales_channel_country`.`country_id` = 0x03AF9428D3614193BC3A7EA53940E11B);

DELETE FROM
  `cart`
WHERE
  `token` = :token

DELETE FROM `cart` WHERE `token` = 'Xy6P1hf4xaYzgjSXDlfzWrfwRClSkaj5';

# acris_checkout_method_preselect_shipping_selection::search-ids
SELECT
  `shipping_method`.`id`
FROM
  `shipping_method`
  LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_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.override_2`.`name` as `shipping_method.translation.override_2.name`
    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` = ?
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_2` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_2`.`shipping_method_id`
      AND `shipping_method.translation.override_2`.`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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`
WHERE
  (
    `shipping_method`.`active` = ?
    AND `shipping_method.salesChannels`.`id` = ?
  )
GROUP BY
  `shipping_method`.`id`
ORDER BY
  MIN(`shipping_method`.`position`) ASC,
  MIN(
    COALESCE(
      `shipping_method.translation.override_2.name`,
      `shipping_method.translation.override_1.name`,
      `shipping_method.translation.name`
    )
  ) ASC

# acris_checkout_method_preselect_shipping_selection::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_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.override_2`.`name` as `shipping_method.translation.override_2.name` 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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_2` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_2`.`shipping_method_id` AND `shipping_method.translation.override_2`.`language_id` = 0x45BE4EF5BC5541119CC81BAC1AED1CEF 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 `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = 1 AND `shipping_method.salesChannels`.`id` = 0xE85BABB2BD37438182BC2D7094175BD3) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.override_2.name`,`shipping_method.translation.override_1.name`,`shipping_method.translation.name`)) ASC;

# 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_2.title`,
  `shipping_method.media.translation.override_1.title`,
  `shipping_method.media.translation.title`,
  COALESCE(
    `shipping_method.media.translation.override_2.title`,
    `shipping_method.media.translation.override_1.title`,
    `shipping_method.media.translation.title`
  ) as `shipping_method.media.title`,
  `shipping_method.media.translation.override_2.alt`,
  `shipping_method.media.translation.override_1.alt`,
  `shipping_method.media.translation.alt`,
  COALESCE(
    `shipping_method.media.translation.override_2.alt`,
    `shipping_method.media.translation.override_1.alt`,
    `shipping_method.media.translation.alt`
  ) as `shipping_method.media.alt`,
  `shipping_method.media.translation.override_2.customFields`,
  `shipping_method.media.translation.override_1.customFields`,
  `shipping_method.media.translation.customFields`,
  COALESCE(
    `shipping_method.media.translation.override_2.customFields`,
    `shipping_method.media.translation.override_1.customFields`,
    `shipping_method.media.translation.customFields`
  ) as `shipping_method.media.customFields`,
  `shipping_method.translation.override_2.name`,
  `shipping_method.translation.override_1.name`,
  `shipping_method.translation.name`,
  COALESCE(
    `shipping_method.translation.override_2.name`,
    `shipping_method.translation.override_1.name`,
    `shipping_method.translation.name`
  ) as `shipping_method.name`,
  `shipping_method.translation.override_2.description`,
  `shipping_method.translation.override_1.description`,
  `shipping_method.translation.description`,
  COALESCE(
    `shipping_method.translation.override_2.description`,
    `shipping_method.translation.override_1.description`,
    `shipping_method.translation.description`
  ) as `shipping_method.description`,
  `shipping_method.translation.override_2.trackingUrl`,
  `shipping_method.translation.override_1.trackingUrl`,
  `shipping_method.translation.trackingUrl`,
  COALESCE(
    `shipping_method.translation.override_2.trackingUrl`,
    `shipping_method.translation.override_1.trackingUrl`,
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`,
  `shipping_method.translation.override_2.customFields`,
  `shipping_method.translation.override_1.customFields`,
  `shipping_method.translation.customFields`,
  COALESCE(
    `shipping_method.translation.override_2.customFields`,
    `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.override_2`.`name` as `shipping_method.translation.override_2.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.override_2`.`custom_fields` as `shipping_method.translation.override_2.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.override_2`.`description` as `shipping_method.translation.override_2.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`,
      `shipping_method.translation.override_2`.`tracking_url` as `shipping_method.translation.override_2.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` = ?
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_2` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_2`.`shipping_method_id`
      AND `shipping_method.translation.override_2`.`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.override_2`.`alt` as `shipping_method.media.translation.override_2.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.override_2`.`title` as `shipping_method.media.translation.override_2.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`,
      `shipping_method.media.translation.override_2`.`custom_fields` as `shipping_method.media.translation.override_2.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` = ?
      LEFT JOIN `media_translation` `shipping_method.media.translation.override_2` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_2`.`media_id`
      AND `shipping_method.media.translation.override_2`.`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_2.title`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_2.title`,`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_2.alt`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_2.alt`,`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_2.customFields`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_2.customFields`,`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_2.name`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_2.name`,`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_2.description`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_2.description`,`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_2.trackingUrl`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_2.trackingUrl`,`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_2.customFields`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_2.customFields`,`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.override_2`.`name` as `shipping_method.translation.override_2.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.override_2`.`custom_fields` as `shipping_method.translation.override_2.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.override_2`.`description` as `shipping_method.translation.override_2.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`, `shipping_method.translation.override_2`.`tracking_url` as `shipping_method.translation.override_2.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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_2` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_2`.`shipping_method_id` AND `shipping_method.translation.override_2`.`language_id` = 0x45BE4EF5BC5541119CC81BAC1AED1CEF 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.override_2`.`alt` as `shipping_method.media.translation.override_2.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.override_2`.`title` as `shipping_method.media.translation.override_2.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`, `shipping_method.media.translation.override_2`.`custom_fields` as `shipping_method.media.translation.override_2.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` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B LEFT JOIN `media_translation` `shipping_method.media.translation.override_2` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_2`.`media_id` AND `shipping_method.media.translation.override_2`.`language_id` = 0x45BE4EF5BC5541119CC81BAC1AED1CEF 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 (0x1854B99B3B384D13BD772259FC3EB59B, 0xD63A21062C6547568251C3658E5C5594, 0x2C11D7B098764450B944630B1CD95CAD, 0x5B6C87283AAF4EDBB38C3D1B9FF2E53F, 0xC42D4DD8724B415587DF1578C4251F56, 0xC52200F1805A41EAB4F66BDE1058E8B6, 0xC327D5AB71314C8B86EADAA722704173, 0x80F818FB14C34B969D112F1A15D29A31, 0x46BB6858987F417B8EC89D13DBB90000, 0x716ECCA1068D4C2E946C280426858402, 0x645ED23D955F40179E850DC2CB208263, 0x470F08E37C4846FDA21505A59E48BC27, 0x17582406101A45779F6F5BBBB06DA251, 0xF55F41AED6B549218ECE799BE3C4D387);

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

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

# acris_checkout_method_preselect_payment_selection::search-ids
SELECT
  `payment_method`.`id`
FROM
  `payment_method`
  LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`
  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`
WHERE
  (
    `payment_method`.`active` = ?
    AND `payment_method.salesChannels`.`id` = ?
  )
GROUP BY
  `payment_method`.`id`
ORDER BY
  MIN(`payment_method`.`position`) ASC

# acris_checkout_method_preselect_payment_selection::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = 1 AND `payment_method.salesChannels`.`id` = 0xE85BABB2BD37438182BC2D7094175BD3) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC;