Symfony Profiler

# app-scripts::refresh::read
SELECT
  `app`.`id` AS `app.id`,
  `app`.`name` AS `app.name`,
  `app`.`path` AS `app.path`,
  `app`.`author` AS `app.author`,
  `app`.`copyright` AS `app.copyright`,
  `app`.`license` AS `app.license`,
  `app`.`active` AS `app.active`,
  `app`.`configurable` AS `app.configurable`,
  `app`.`privacy` AS `app.privacy`,
  `app`.`version` AS `app.version`,
  `app`.`icon` AS `app.iconRaw`,
  `app`.`app_secret` AS `app.appSecret`,
  `app`.`modules` AS `app.modules`,
  `app`.`main_module` AS `app.mainModule`,
  `app`.`cookies` AS `app.cookies`,
  `app`.`allow_disable` AS `app.allowDisable`,
  `app`.`base_app_url` AS `app.baseAppUrl`,
  `app`.`allowed_hosts` AS `app.allowedHosts`,
  `app`.`template_load_priority` AS `app.templateLoadPriority`,
  `app`.`integration_id` AS `app.integrationId`,
  `app.integration`.`id` AS `app.integration.id`,
  `app.integration`.`label` AS `app.integration.label`,
  `app.integration`.`access_key` AS `app.integration.accessKey`,
  `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`,
  `app.integration`.`admin` AS `app.integration.admin`,
  `app.integration`.`custom_fields` AS `app.integration.customFields`,
  `app.integration`.`deleted_at` AS `app.integration.deletedAt`,
  `app.integration`.`write_access` AS `app.integration.writeAccess`,
  `app.integration`.`created_at` AS `app.integration.createdAt`,
  `app.integration`.`updated_at` AS `app.integration.updatedAt`,
  `app`.`acl_role_id` AS `app.aclRoleId`,
  `app.aclRole`.`id` AS `app.aclRole.id`,
  `app.aclRole`.`name` AS `app.aclRole.name`,
  `app.aclRole`.`description` AS `app.aclRole.description`,
  `app.aclRole`.`privileges` AS `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` AS `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`,
  `app`.`created_at` AS `app.createdAt`,
  `app`.`updated_at` AS `app.updatedAt`,
  `app.translation.label`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) AS `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) AS `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) AS `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) AS `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  LEFT JOIN (
    SELECT
      `app.translation`.app_id,
      `app.translation`.label AS `app.translation.label`,
      `app.translation`.description AS `app.translation.description`,
      `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`,
      `app.translation`.custom_fields AS `app.translation.customFields`,
      `app.translation`.created_at AS `app.translation.createdAt`,
      `app.translation`.updated_at AS `app.translation.updatedAt`,
      `app.translation`.app_id AS `app.translation.appId`,
      `app.translation`.language_id AS `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
SELECT `app`.`id` AS `app.id`, `app`.`name` AS `app.name`, `app`.`path` AS `app.path`, `app`.`author` AS `app.author`, `app`.`copyright` AS `app.copyright`, `app`.`license` AS `app.license`, `app`.`active` AS `app.active`, `app`.`configurable` AS `app.configurable`, `app`.`privacy` AS `app.privacy`, `app`.`version` AS `app.version`, `app`.`icon` AS `app.iconRaw`, `app`.`app_secret` AS `app.appSecret`, `app`.`modules` AS `app.modules`, `app`.`main_module` AS `app.mainModule`, `app`.`cookies` AS `app.cookies`, `app`.`allow_disable` AS `app.allowDisable`, `app`.`base_app_url` AS `app.baseAppUrl`, `app`.`allowed_hosts` AS `app.allowedHosts`, `app`.`template_load_priority` AS `app.templateLoadPriority`, `app`.`integration_id` AS `app.integrationId`, `app.integration`.`id` AS `app.integration.id`, `app.integration`.`label` AS `app.integration.label`, `app.integration`.`access_key` AS `app.integration.accessKey`, `app.integration`.`secret_access_key` AS `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` AS `app.integration.lastUsageAt`, `app.integration`.`admin` AS `app.integration.admin`, `app.integration`.`custom_fields` AS `app.integration.customFields`, `app.integration`.`deleted_at` AS `app.integration.deletedAt`, `app.integration`.`write_access` AS `app.integration.writeAccess`, `app.integration`.`created_at` AS `app.integration.createdAt`, `app.integration`.`updated_at` AS `app.integration.updatedAt`, `app`.`acl_role_id` AS `app.aclRoleId`, `app.aclRole`.`id` AS `app.aclRole.id`, `app.aclRole`.`name` AS `app.aclRole.name`, `app.aclRole`.`description` AS `app.aclRole.description`, `app.aclRole`.`privileges` AS `app.aclRole.privileges`, `app.aclRole`.`deleted_at` AS `app.aclRole.deletedAt`, `app.aclRole`.`created_at` AS `app.aclRole.createdAt`, `app.aclRole`.`updated_at` AS `app.aclRole.updatedAt`, `app`.`created_at` AS `app.createdAt`, `app`.`updated_at` AS `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) AS `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) AS `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) AS `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) AS `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label AS `app.translation.label`, `app.translation`.description AS `app.translation.description`, `app.translation`.privacy_policy_extensions AS `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields AS `app.translation.customFields`, `app.translation`.created_at AS `app.translation.createdAt`, `app.translation`.updated_at AS `app.translation.updatedAt`, `app.translation`.app_id AS `app.translation.appId`, `app.translation`.language_id AS `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);

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

# base-context-factory::country::read
SELECT
  `country`.`id` AS `country.id`,
  `country`.`iso` AS `country.iso`,
  `country`.`position` AS `country.position`,
  `country`.`active` AS `country.active`,
  `country`.`shipping_available` AS `country.shippingAvailable`,
  `country`.`iso3` AS `country.iso3`,
  `country`.`display_state_in_registration` AS `country.displayStateInRegistration`,
  `country`.`force_state_in_registration` AS `country.forceStateInRegistration`,
  `country`.`check_vat_id_pattern` AS `country.checkVatIdPattern`,
  `country`.`vat_id_required` AS `country.vatIdRequired`,
  `country`.`vat_id_pattern` AS `country.vatIdPattern`,
  `country`.`customer_tax` AS `country.customerTax`,
  `country`.`company_tax` AS `country.companyTax`,
  `country`.`postal_code_required` AS `country.postalCodeRequired`,
  `country`.`check_postal_code_pattern` AS `country.checkPostalCodePattern`,
  `country`.`check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern`,
  `country`.`advanced_postal_code_pattern` AS `country.advancedPostalCodePattern`,
  `country`.`default_postal_code_pattern` AS `country.defaultPostalCodePattern`,
  `country`.`created_at` AS `country.createdAt`,
  `country`.`updated_at` AS `country.updatedAt`,
  `country.translation.name`,
  COALESCE(
    `country.translation.name`, `country.translation.name`
  ) AS `country.name`,
  `country.translation.addressFormat`,
  COALESCE(
    `country.translation.addressFormat`,
    `country.translation.addressFormat`
  ) AS `country.addressFormat`,
  `country.translation.customFields`,
  COALESCE(
    `country.translation.customFields`,
    `country.translation.customFields`
  ) AS `country.customFields`,
  `country.translation.createdAt`,
  `country.translation.updatedAt`,
  `country.translation.countryId`,
  `country.translation.languageId`
FROM
  `country`
  LEFT JOIN (
    SELECT
      `country.translation`.country_id,
      `country.translation`.name AS `country.translation.name`,
      `country.translation`.address_format AS `country.translation.addressFormat`,
      `country.translation`.custom_fields AS `country.translation.customFields`,
      `country.translation`.created_at AS `country.translation.createdAt`,
      `country.translation`.updated_at AS `country.translation.updatedAt`,
      `country.translation`.country_id AS `country.translation.countryId`,
      `country.translation`.language_id AS `country.translation.languageId`
    FROM
      `country_translation` `country.translation`
    WHERE
      `country.translation`.language_id = ?
  ) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id`
WHERE
  `country`.`id` IN (?)

# base-context-factory::country::read
SELECT `country`.`id` AS `country.id`, `country`.`iso` AS `country.iso`, `country`.`position` AS `country.position`, `country`.`active` AS `country.active`, `country`.`shipping_available` AS `country.shippingAvailable`, `country`.`iso3` AS `country.iso3`, `country`.`display_state_in_registration` AS `country.displayStateInRegistration`, `country`.`force_state_in_registration` AS `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` AS `country.checkVatIdPattern`, `country`.`vat_id_required` AS `country.vatIdRequired`, `country`.`vat_id_pattern` AS `country.vatIdPattern`, `country`.`customer_tax` AS `country.customerTax`, `country`.`company_tax` AS `country.companyTax`, `country`.`postal_code_required` AS `country.postalCodeRequired`, `country`.`check_postal_code_pattern` AS `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` AS `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` AS `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` AS `country.defaultPostalCodePattern`, `country`.`created_at` AS `country.createdAt`, `country`.`updated_at` AS `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) AS `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) AS `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) AS `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name AS `country.translation.name`, `country.translation`.address_format AS `country.translation.addressFormat`, `country.translation`.custom_fields AS `country.translation.customFields`, `country.translation`.created_at AS `country.translation.createdAt`, `country.translation`.updated_at AS `country.translation.updatedAt`, `country.translation`.country_id AS `country.translation.countryId`, `country.translation`.language_id AS `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (0xC5442494591A4D2D9E5D1E02B1098087);

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

#cart-persister::load
                SELECT `cart`.`cart` AS payload, `cart`.`rule_ids`, 0 AS `compressed` FROM cart WHERE `token` = '0193f2bea9c8709b9aa5ec1d67d1eb47';

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) AS `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) AS `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

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

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0x98432DEF39FC4624B33213A56B8C944D) AND (token = '0193f2bea9c8709b9aa5ec1d67d1eb47') LIMIT 1;

# context-factory::customer::read
SELECT
  `customer`.`id` AS `customer.id`,
  `customer`.`customer_group_id` AS `customer.groupId`,
  `customer`.`default_payment_method_id` AS `customer.defaultPaymentMethodId`,
  `customer`.`sales_channel_id` AS `customer.salesChannelId`,
  `customer`.`language_id` AS `customer.languageId`,
  `customer`.`last_payment_method_id` AS `customer.lastPaymentMethodId`,
  `customer`.`default_billing_address_id` AS `customer.defaultBillingAddressId`,
  `customer`.`default_shipping_address_id` AS `customer.defaultShippingAddressId`,
  `customer`.`auto_increment` AS `customer.autoIncrement`,
  `customer`.`customer_number` AS `customer.customerNumber`,
  `customer`.`salutation_id` AS `customer.salutationId`,
  `customer`.`first_name` AS `customer.firstName`,
  `customer`.`last_name` AS `customer.lastName`,
  `customer`.`company` AS `customer.company`,
  `customer`.`password` AS `customer.password`,
  `customer`.`email` AS `customer.email`,
  `customer`.`title` AS `customer.title`,
  `customer`.`vat_ids` AS `customer.vatIds`,
  `customer`.`affiliate_code` AS `customer.affiliateCode`,
  `customer`.`campaign_code` AS `customer.campaignCode`,
  `customer`.`active` AS `customer.active`,
  `customer`.`double_opt_in_registration` AS `customer.doubleOptInRegistration`,
  `customer`.`double_opt_in_email_sent_date` AS `customer.doubleOptInEmailSentDate`,
  `customer`.`double_opt_in_confirm_date` AS `customer.doubleOptInConfirmDate`,
  `customer`.`hash` AS `customer.hash`,
  `customer`.`guest` AS `customer.guest`,
  `customer`.`first_login` AS `customer.firstLogin`,
  `customer`.`last_login` AS `customer.lastLogin`,
  `customer`.`newsletter_sales_channel_ids` AS `customer.newsletterSalesChannelIds`,
  `customer`.`birthday` AS `customer.birthday`,
  `customer`.`last_order_date` AS `customer.lastOrderDate`,
  `customer`.`order_count` AS `customer.orderCount`,
  `customer`.`order_total_amount` AS `customer.orderTotalAmount`,
  `customer`.`review_count` AS `customer.reviewCount`,
  `customer`.`custom_fields` AS `customer.customFields`,
  `customer`.`legacy_password` AS `customer.legacyPassword`,
  `customer`.`legacy_encoder` AS `customer.legacyEncoder`,
  `customer`.`remote_address` AS `customer.remoteAddress`,
  `customer`.`tag_ids` AS `customer.tagIds`,
  `customer`.`requested_customer_group_id` AS `customer.requestedGroupId`,
  `customer`.`bound_sales_channel_id` AS `customer.boundSalesChannelId`,
  `customer`.`account_type` AS `customer.accountType`,
  `customer`.`created_by_id` AS `customer.createdById`,
  `customer`.`updated_by_id` AS `customer.updatedById`,
  `customer`.`created_at` AS `customer.createdAt`,
  `customer`.`updated_at` AS `customer.updatedAt`,
  `customer.salutation`.`id` AS `customer.salutation.id`,
  `customer.salutation`.`salutation_key` AS `customer.salutation.salutationKey`,
  `customer.salutation`.`created_at` AS `customer.salutation.createdAt`,
  `customer.salutation`.`updated_at` AS `customer.salutation.updatedAt`,
  `customer.salutation.translation.fallback_1.displayName`,
  `customer.salutation.translation.displayName`,
  COALESCE(
    `customer.salutation.translation.fallback_1.displayName`,
    `customer.salutation.translation.displayName`,
    `customer.salutation.translation.displayName`
  ) AS `customer.salutation.displayName`,
  `customer.salutation.translation.fallback_1.letterName`,
  `customer.salutation.translation.letterName`,
  COALESCE(
    `customer.salutation.translation.fallback_1.letterName`,
    `customer.salutation.translation.letterName`,
    `customer.salutation.translation.letterName`
  ) AS `customer.salutation.letterName`,
  `customer.salutation.translation.fallback_1.customFields`,
  `customer.salutation.translation.customFields`,
  COALESCE(
    `customer.salutation.translation.fallback_1.customFields`,
    `customer.salutation.translation.customFields`,
    `customer.salutation.translation.customFields`
  ) AS `customer.salutation.customFields`,
  `customer.salutation.translation.fallback_1.createdAt`,
  `customer.salutation.translation.createdAt`,
  `customer.salutation.translation.fallback_1.updatedAt`,
  `customer.salutation.translation.updatedAt`,
  `customer.salutation.translation.fallback_1.salutationId`,
  `customer.salutation.translation.salutationId`,
  `customer.salutation.translation.fallback_1.languageId`,
  `customer.salutation.translation.languageId`,
  `customer.defaultPaymentMethod`.`id` AS `customer.defaultPaymentMethod.id`,
  `customer.defaultPaymentMethod`.`plugin_id` AS `customer.defaultPaymentMethod.pluginId`,
  `customer.defaultPaymentMethod`.`handler_identifier` AS `customer.defaultPaymentMethod.handlerIdentifier`,
  `customer.defaultPaymentMethod`.`position` AS `customer.defaultPaymentMethod.position`,
  `customer.defaultPaymentMethod`.`active` AS `customer.defaultPaymentMethod.active`,
  `customer.defaultPaymentMethod`.`after_order_enabled` AS `customer.defaultPaymentMethod.afterOrderEnabled`,
  `customer.defaultPaymentMethod`.`availability_rule_id` AS `customer.defaultPaymentMethod.availabilityRuleId`,
  `customer.defaultPaymentMethod`.`media_id` AS `customer.defaultPaymentMethod.mediaId`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`id` AS `customer.defaultPaymentMethod.appPaymentMethod.id`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`app_name` AS `customer.defaultPaymentMethod.appPaymentMethod.appName`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`identifier` AS `customer.defaultPaymentMethod.appPaymentMethod.identifier`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`pay_url` AS `customer.defaultPaymentMethod.appPaymentMethod.payUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`finalize_url` AS `customer.defaultPaymentMethod.appPaymentMethod.finalizeUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`validate_url` AS `customer.defaultPaymentMethod.appPaymentMethod.validateUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`capture_url` AS `customer.defaultPaymentMethod.appPaymentMethod.captureUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`refund_url` AS `customer.defaultPaymentMethod.appPaymentMethod.refundUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`recurring_url` AS `customer.defaultPaymentMethod.appPaymentMethod.recurringUrl`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`app_id` AS `customer.defaultPaymentMethod.appPaymentMethod.appId`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`original_media_id` AS `customer.defaultPaymentMethod.appPaymentMethod.originalMediaId`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` AS `customer.defaultPaymentMethod.appPaymentMethod.paymentMethodId`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`created_at` AS `customer.defaultPaymentMethod.appPaymentMethod.createdAt`,
  `customer.defaultPaymentMethod.appPaymentMethod`.`updated_at` AS `customer.defaultPaymentMethod.appPaymentMethod.updatedAt`,
  `customer.defaultPaymentMethod`.`technical_name` AS `customer.defaultPaymentMethod.technicalName`,
  `customer.defaultPaymentMethod`.`created_at` AS `customer.defaultPaymentMethod.createdAt`,
  `customer.defaultPaymentMethod`.`updated_at` AS `customer.defaultPaymentMethod.updatedAt`,
  `customer.defaultPaymentMethod.translation.fallback_1.name`,
  `customer.defaultPaymentMethod.translation.name`,
  COALESCE(
    `customer.defaultPaymentMethod.translation.fallback_1.name`,
    `customer.defaultPaymentMethod.translation.name`,
    `customer.defaultPaymentMethod.translation.name`
  ) AS `customer.defaultPaymentMethod.name`,
  `customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`,
  `customer.defaultPaymentMethod.translation.distinguishableName`,
  COALESCE(
    `customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`,
    `customer.defaultPaymentMethod.translation.distinguishableName`,
    `customer.defaultPaymentMethod.translation.distinguishableName`
  ) AS `customer.defaultPaymentMethod.distinguishableName`,
  `customer.defaultPaymentMethod.translation.fallback_1.description`,
  `customer.defaultPaymentMethod.translation.description`,
  COALESCE(
    `customer.defaultPaymentMethod.translation.fallback_1.description`,
    `customer.defaultPaymentMethod.translation.description`,
    `customer.defaultPaymentMethod.translation.description`
  ) AS `customer.defaultPaymentMethod.description`,
  `customer.defaultPaymentMethod.translation.fallback_1.customFields`,
  `customer.defaultPaymentMethod.translation.customFields`,
  COALESCE(
    `customer.defaultPaymentMethod.translation.fallback_1.customFields`,
    `customer.defaultPaymentMethod.translation.customFields`,
    `customer.defaultPaymentMethod.translation.customFields`
  ) AS `customer.defaultPaymentMethod.customFields`,
  `customer.defaultPaymentMethod.translation.fallback_1.createdAt`,
  `customer.defaultPaymentMethod.translation.createdAt`,
  `customer.defaultPaymentMethod.translation.fallback_1.updatedAt`,
  `customer.defaultPaymentMethod.translation.updatedAt`,
  `customer.defaultPaymentMethod.translation.fallback_1.paymentMethodId`,
  `customer.defaultPaymentMethod.translation.paymentMethodId`,
  `customer.defaultPaymentMethod.translation.fallback_1.languageId`,
  `customer.defaultPaymentMethod.translation.languageId`
FROM
  `customer`
  LEFT JOIN `salutation` `customer.salutation` ON `customer`.`salutation_id` = `customer.salutation`.`id`
  LEFT JOIN `payment_method` `customer.defaultPaymentMethod` ON `customer`.`default_payment_method_id` = `customer.defaultPaymentMethod`.`id`
  LEFT JOIN (
    SELECT
      `customer.salutation.translation`.salutation_id,
      `customer.salutation.translation`.display_name AS `customer.salutation.translation.displayName`,
      `customer.salutation.translation`.letter_name AS `customer.salutation.translation.letterName`,
      `customer.salutation.translation`.custom_fields AS `customer.salutation.translation.customFields`,
      `customer.salutation.translation`.created_at AS `customer.salutation.translation.createdAt`,
      `customer.salutation.translation`.updated_at AS `customer.salutation.translation.updatedAt`,
      `customer.salutation.translation`.salutation_id AS `customer.salutation.translation.salutationId`,
      `customer.salutation.translation`.language_id AS `customer.salutation.translation.languageId`,
      `customer.salutation.translation.fallback_1`.display_name AS `customer.salutation.translation.fallback_1.displayName`,
      `customer.salutation.translation.fallback_1`.letter_name AS `customer.salutation.translation.fallback_1.letterName`,
      `customer.salutation.translation.fallback_1`.custom_fields AS `customer.salutation.translation.fallback_1.customFields`,
      `customer.salutation.translation.fallback_1`.created_at AS `customer.salutation.translation.fallback_1.createdAt`,
      `customer.salutation.translation.fallback_1`.updated_at AS `customer.salutation.translation.fallback_1.updatedAt`,
      `customer.salutation.translation.fallback_1`.salutation_id AS `customer.salutation.translation.fallback_1.salutationId`,
      `customer.salutation.translation.fallback_1`.language_id AS `customer.salutation.translation.fallback_1.languageId`
    FROM
      `salutation_translation` `customer.salutation.translation`
      LEFT JOIN `salutation_translation` `customer.salutation.translation.fallback_1` ON `customer.salutation.translation`.`salutation_id` = `customer.salutation.translation.fallback_1`.`salutation_id`
      AND `customer.salutation.translation.fallback_1`.language_id = ?
    WHERE
      `customer.salutation.translation`.language_id = ?
  ) `customer.salutation.salutation_translation` ON `customer.salutation.salutation_translation`.`salutation_id` = `customer.salutation`.`id`
  LEFT JOIN (
    SELECT
      `customer.defaultPaymentMethod.translation`.payment_method_id,
      `customer.defaultPaymentMethod.translation`.name AS `customer.defaultPaymentMethod.translation.name`,
      `customer.defaultPaymentMethod.translation`.distinguishable_name AS `customer.defaultPaymentMethod.translation.distinguishableName`,
      `customer.defaultPaymentMethod.translation`.description AS `customer.defaultPaymentMethod.translation.description`,
      `customer.defaultPaymentMethod.translation`.custom_fields AS `customer.defaultPaymentMethod.translation.customFields`,
      `customer.defaultPaymentMethod.translation`.created_at AS `customer.defaultPaymentMethod.translation.createdAt`,
      `customer.defaultPaymentMethod.translation`.updated_at AS `customer.defaultPaymentMethod.translation.updatedAt`,
      `customer.defaultPaymentMethod.translation`.payment_method_id AS `customer.defaultPaymentMethod.translation.paymentMethodId`,
      `customer.defaultPaymentMethod.translation`.language_id AS `customer.defaultPaymentMethod.translation.languageId`,
      `customer.defaultPaymentMethod.translation.fallback_1`.name AS `customer.defaultPaymentMethod.translation.fallback_1.name`,
      `customer.defaultPaymentMethod.translation.fallback_1`.distinguishable_name AS `customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`,
      `customer.defaultPaymentMethod.translation.fallback_1`.description AS `customer.defaultPaymentMethod.translation.fallback_1.description`,
      `customer.defaultPaymentMethod.translation.fallback_1`.custom_fields AS `customer.defaultPaymentMethod.translation.fallback_1.customFields`,
      `customer.defaultPaymentMethod.translation.fallback_1`.created_at AS `customer.defaultPaymentMethod.translation.fallback_1.createdAt`,
      `customer.defaultPaymentMethod.translation.fallback_1`.updated_at AS `customer.defaultPaymentMethod.translation.fallback_1.updatedAt`,
      `customer.defaultPaymentMethod.translation.fallback_1`.payment_method_id AS `customer.defaultPaymentMethod.translation.fallback_1.paymentMethodId`,
      `customer.defaultPaymentMethod.translation.fallback_1`.language_id AS `customer.defaultPaymentMethod.translation.fallback_1.languageId`
    FROM
      `payment_method_translation` `customer.defaultPaymentMethod.translation`
      LEFT JOIN `payment_method_translation` `customer.defaultPaymentMethod.translation.fallback_1` ON `customer.defaultPaymentMethod.translation`.`payment_method_id` = `customer.defaultPaymentMethod.translation.fallback_1`.`payment_method_id`
      AND `customer.defaultPaymentMethod.translation.fallback_1`.language_id = ?
    WHERE
      `customer.defaultPaymentMethod.translation`.language_id = ?
  ) `customer.defaultPaymentMethod.payment_method_translation` ON `customer.defaultPaymentMethod.payment_method_translation`.`payment_method_id` = `customer.defaultPaymentMethod`.`id`
  LEFT JOIN `app_payment_method` `customer.defaultPaymentMethod.appPaymentMethod` ON `customer.defaultPaymentMethod`.`id` = `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id`
WHERE
  (
    (
      (
        `customer`.`bound_sales_channel_id` <=> ?
        OR `customer`.`bound_sales_channel_id` = ?
      )
    )
  )
  AND (
    `customer`.`id` IN (?)
  )

# context-factory::customer::read
SELECT `customer`.`id` AS `customer.id`, `customer`.`customer_group_id` AS `customer.groupId`, `customer`.`default_payment_method_id` AS `customer.defaultPaymentMethodId`, `customer`.`sales_channel_id` AS `customer.salesChannelId`, `customer`.`language_id` AS `customer.languageId`, `customer`.`last_payment_method_id` AS `customer.lastPaymentMethodId`, `customer`.`default_billing_address_id` AS `customer.defaultBillingAddressId`, `customer`.`default_shipping_address_id` AS `customer.defaultShippingAddressId`, `customer`.`auto_increment` AS `customer.autoIncrement`, `customer`.`customer_number` AS `customer.customerNumber`, `customer`.`salutation_id` AS `customer.salutationId`, `customer`.`first_name` AS `customer.firstName`, `customer`.`last_name` AS `customer.lastName`, `customer`.`company` AS `customer.company`, `customer`.`password` AS `customer.password`, `customer`.`email` AS `customer.email`, `customer`.`title` AS `customer.title`, `customer`.`vat_ids` AS `customer.vatIds`, `customer`.`affiliate_code` AS `customer.affiliateCode`, `customer`.`campaign_code` AS `customer.campaignCode`, `customer`.`active` AS `customer.active`, `customer`.`double_opt_in_registration` AS `customer.doubleOptInRegistration`, `customer`.`double_opt_in_email_sent_date` AS `customer.doubleOptInEmailSentDate`, `customer`.`double_opt_in_confirm_date` AS `customer.doubleOptInConfirmDate`, `customer`.`hash` AS `customer.hash`, `customer`.`guest` AS `customer.guest`, `customer`.`first_login` AS `customer.firstLogin`, `customer`.`last_login` AS `customer.lastLogin`, `customer`.`newsletter_sales_channel_ids` AS `customer.newsletterSalesChannelIds`, `customer`.`birthday` AS `customer.birthday`, `customer`.`last_order_date` AS `customer.lastOrderDate`, `customer`.`order_count` AS `customer.orderCount`, `customer`.`order_total_amount` AS `customer.orderTotalAmount`, `customer`.`review_count` AS `customer.reviewCount`, `customer`.`custom_fields` AS `customer.customFields`, `customer`.`legacy_password` AS `customer.legacyPassword`, `customer`.`legacy_encoder` AS `customer.legacyEncoder`, `customer`.`remote_address` AS `customer.remoteAddress`, `customer`.`tag_ids` AS `customer.tagIds`, `customer`.`requested_customer_group_id` AS `customer.requestedGroupId`, `customer`.`bound_sales_channel_id` AS `customer.boundSalesChannelId`, `customer`.`account_type` AS `customer.accountType`, `customer`.`created_by_id` AS `customer.createdById`, `customer`.`updated_by_id` AS `customer.updatedById`, `customer`.`created_at` AS `customer.createdAt`, `customer`.`updated_at` AS `customer.updatedAt`, `customer.salutation`.`id` AS `customer.salutation.id`, `customer.salutation`.`salutation_key` AS `customer.salutation.salutationKey`, `customer.salutation`.`created_at` AS `customer.salutation.createdAt`, `customer.salutation`.`updated_at` AS `customer.salutation.updatedAt`, `customer.salutation.translation.fallback_1.displayName`, `customer.salutation.translation.displayName`, COALESCE(`customer.salutation.translation.fallback_1.displayName`,`customer.salutation.translation.displayName`,`customer.salutation.translation.displayName`) AS `customer.salutation.displayName`, `customer.salutation.translation.fallback_1.letterName`, `customer.salutation.translation.letterName`, COALESCE(`customer.salutation.translation.fallback_1.letterName`,`customer.salutation.translation.letterName`,`customer.salutation.translation.letterName`) AS `customer.salutation.letterName`, `customer.salutation.translation.fallback_1.customFields`, `customer.salutation.translation.customFields`, COALESCE(`customer.salutation.translation.fallback_1.customFields`,`customer.salutation.translation.customFields`,`customer.salutation.translation.customFields`) AS `customer.salutation.customFields`, `customer.salutation.translation.fallback_1.createdAt`, `customer.salutation.translation.createdAt`, `customer.salutation.translation.fallback_1.updatedAt`, `customer.salutation.translation.updatedAt`, `customer.salutation.translation.fallback_1.salutationId`, `customer.salutation.translation.salutationId`, `customer.salutation.translation.fallback_1.languageId`, `customer.salutation.translation.languageId`, `customer.defaultPaymentMethod`.`id` AS `customer.defaultPaymentMethod.id`, `customer.defaultPaymentMethod`.`plugin_id` AS `customer.defaultPaymentMethod.pluginId`, `customer.defaultPaymentMethod`.`handler_identifier` AS `customer.defaultPaymentMethod.handlerIdentifier`, `customer.defaultPaymentMethod`.`position` AS `customer.defaultPaymentMethod.position`, `customer.defaultPaymentMethod`.`active` AS `customer.defaultPaymentMethod.active`, `customer.defaultPaymentMethod`.`after_order_enabled` AS `customer.defaultPaymentMethod.afterOrderEnabled`, `customer.defaultPaymentMethod`.`availability_rule_id` AS `customer.defaultPaymentMethod.availabilityRuleId`, `customer.defaultPaymentMethod`.`media_id` AS `customer.defaultPaymentMethod.mediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`id` AS `customer.defaultPaymentMethod.appPaymentMethod.id`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_name` AS `customer.defaultPaymentMethod.appPaymentMethod.appName`, `customer.defaultPaymentMethod.appPaymentMethod`.`identifier` AS `customer.defaultPaymentMethod.appPaymentMethod.identifier`, `customer.defaultPaymentMethod.appPaymentMethod`.`pay_url` AS `customer.defaultPaymentMethod.appPaymentMethod.payUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`finalize_url` AS `customer.defaultPaymentMethod.appPaymentMethod.finalizeUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`validate_url` AS `customer.defaultPaymentMethod.appPaymentMethod.validateUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`capture_url` AS `customer.defaultPaymentMethod.appPaymentMethod.captureUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`refund_url` AS `customer.defaultPaymentMethod.appPaymentMethod.refundUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`recurring_url` AS `customer.defaultPaymentMethod.appPaymentMethod.recurringUrl`, `customer.defaultPaymentMethod.appPaymentMethod`.`app_id` AS `customer.defaultPaymentMethod.appPaymentMethod.appId`, `customer.defaultPaymentMethod.appPaymentMethod`.`original_media_id` AS `customer.defaultPaymentMethod.appPaymentMethod.originalMediaId`, `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` AS `customer.defaultPaymentMethod.appPaymentMethod.paymentMethodId`, `customer.defaultPaymentMethod.appPaymentMethod`.`created_at` AS `customer.defaultPaymentMethod.appPaymentMethod.createdAt`, `customer.defaultPaymentMethod.appPaymentMethod`.`updated_at` AS `customer.defaultPaymentMethod.appPaymentMethod.updatedAt`, `customer.defaultPaymentMethod`.`technical_name` AS `customer.defaultPaymentMethod.technicalName`, `customer.defaultPaymentMethod`.`created_at` AS `customer.defaultPaymentMethod.createdAt`, `customer.defaultPaymentMethod`.`updated_at` AS `customer.defaultPaymentMethod.updatedAt`, `customer.defaultPaymentMethod.translation.fallback_1.name`, `customer.defaultPaymentMethod.translation.name`, COALESCE(`customer.defaultPaymentMethod.translation.fallback_1.name`,`customer.defaultPaymentMethod.translation.name`,`customer.defaultPaymentMethod.translation.name`) AS `customer.defaultPaymentMethod.name`, `customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`, `customer.defaultPaymentMethod.translation.distinguishableName`, COALESCE(`customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`,`customer.defaultPaymentMethod.translation.distinguishableName`,`customer.defaultPaymentMethod.translation.distinguishableName`) AS `customer.defaultPaymentMethod.distinguishableName`, `customer.defaultPaymentMethod.translation.fallback_1.description`, `customer.defaultPaymentMethod.translation.description`, COALESCE(`customer.defaultPaymentMethod.translation.fallback_1.description`,`customer.defaultPaymentMethod.translation.description`,`customer.defaultPaymentMethod.translation.description`) AS `customer.defaultPaymentMethod.description`, `customer.defaultPaymentMethod.translation.fallback_1.customFields`, `customer.defaultPaymentMethod.translation.customFields`, COALESCE(`customer.defaultPaymentMethod.translation.fallback_1.customFields`,`customer.defaultPaymentMethod.translation.customFields`,`customer.defaultPaymentMethod.translation.customFields`) AS `customer.defaultPaymentMethod.customFields`, `customer.defaultPaymentMethod.translation.fallback_1.createdAt`, `customer.defaultPaymentMethod.translation.createdAt`, `customer.defaultPaymentMethod.translation.fallback_1.updatedAt`, `customer.defaultPaymentMethod.translation.updatedAt`, `customer.defaultPaymentMethod.translation.fallback_1.paymentMethodId`, `customer.defaultPaymentMethod.translation.paymentMethodId`, `customer.defaultPaymentMethod.translation.fallback_1.languageId`, `customer.defaultPaymentMethod.translation.languageId` FROM `customer` LEFT JOIN `salutation` `customer.salutation` ON `customer`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN `payment_method` `customer.defaultPaymentMethod` ON `customer`.`default_payment_method_id` = `customer.defaultPaymentMethod`.`id` LEFT JOIN (SELECT `customer.salutation.translation`.salutation_id, `customer.salutation.translation`.display_name AS `customer.salutation.translation.displayName`, `customer.salutation.translation`.letter_name AS `customer.salutation.translation.letterName`, `customer.salutation.translation`.custom_fields AS `customer.salutation.translation.customFields`, `customer.salutation.translation`.created_at AS `customer.salutation.translation.createdAt`, `customer.salutation.translation`.updated_at AS `customer.salutation.translation.updatedAt`, `customer.salutation.translation`.salutation_id AS `customer.salutation.translation.salutationId`, `customer.salutation.translation`.language_id AS `customer.salutation.translation.languageId`, `customer.salutation.translation.fallback_1`.display_name AS `customer.salutation.translation.fallback_1.displayName`, `customer.salutation.translation.fallback_1`.letter_name AS `customer.salutation.translation.fallback_1.letterName`, `customer.salutation.translation.fallback_1`.custom_fields AS `customer.salutation.translation.fallback_1.customFields`, `customer.salutation.translation.fallback_1`.created_at AS `customer.salutation.translation.fallback_1.createdAt`, `customer.salutation.translation.fallback_1`.updated_at AS `customer.salutation.translation.fallback_1.updatedAt`, `customer.salutation.translation.fallback_1`.salutation_id AS `customer.salutation.translation.fallback_1.salutationId`, `customer.salutation.translation.fallback_1`.language_id AS `customer.salutation.translation.fallback_1.languageId` FROM `salutation_translation` `customer.salutation.translation` LEFT JOIN `salutation_translation` `customer.salutation.translation.fallback_1` ON `customer.salutation.translation`.`salutation_id` = `customer.salutation.translation.fallback_1`.`salutation_id` AND `customer.salutation.translation.fallback_1`.language_id = 0xCE76118FCB9E4D85949BA0F669A05357 WHERE `customer.salutation.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `customer.salutation.salutation_translation` ON `customer.salutation.salutation_translation`.`salutation_id` = `customer.salutation`.`id` LEFT JOIN (SELECT `customer.defaultPaymentMethod.translation`.payment_method_id, `customer.defaultPaymentMethod.translation`.name AS `customer.defaultPaymentMethod.translation.name`, `customer.defaultPaymentMethod.translation`.distinguishable_name AS `customer.defaultPaymentMethod.translation.distinguishableName`, `customer.defaultPaymentMethod.translation`.description AS `customer.defaultPaymentMethod.translation.description`, `customer.defaultPaymentMethod.translation`.custom_fields AS `customer.defaultPaymentMethod.translation.customFields`, `customer.defaultPaymentMethod.translation`.created_at AS `customer.defaultPaymentMethod.translation.createdAt`, `customer.defaultPaymentMethod.translation`.updated_at AS `customer.defaultPaymentMethod.translation.updatedAt`, `customer.defaultPaymentMethod.translation`.payment_method_id AS `customer.defaultPaymentMethod.translation.paymentMethodId`, `customer.defaultPaymentMethod.translation`.language_id AS `customer.defaultPaymentMethod.translation.languageId`, `customer.defaultPaymentMethod.translation.fallback_1`.name AS `customer.defaultPaymentMethod.translation.fallback_1.name`, `customer.defaultPaymentMethod.translation.fallback_1`.distinguishable_name AS `customer.defaultPaymentMethod.translation.fallback_1.distinguishableName`, `customer.defaultPaymentMethod.translation.fallback_1`.description AS `customer.defaultPaymentMethod.translation.fallback_1.description`, `customer.defaultPaymentMethod.translation.fallback_1`.custom_fields AS `customer.defaultPaymentMethod.translation.fallback_1.customFields`, `customer.defaultPaymentMethod.translation.fallback_1`.created_at AS `customer.defaultPaymentMethod.translation.fallback_1.createdAt`, `customer.defaultPaymentMethod.translation.fallback_1`.updated_at AS `customer.defaultPaymentMethod.translation.fallback_1.updatedAt`, `customer.defaultPaymentMethod.translation.fallback_1`.payment_method_id AS `customer.defaultPaymentMethod.translation.fallback_1.paymentMethodId`, `customer.defaultPaymentMethod.translation.fallback_1`.language_id AS `customer.defaultPaymentMethod.translation.fallback_1.languageId` FROM `payment_method_translation` `customer.defaultPaymentMethod.translation` LEFT JOIN `payment_method_translation` `customer.defaultPaymentMethod.translation.fallback_1` ON `customer.defaultPaymentMethod.translation`.`payment_method_id` = `customer.defaultPaymentMethod.translation.fallback_1`.`payment_method_id` AND `customer.defaultPaymentMethod.translation.fallback_1`.language_id = 0xCE76118FCB9E4D85949BA0F669A05357 WHERE `customer.defaultPaymentMethod.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `customer.defaultPaymentMethod.payment_method_translation` ON `customer.defaultPaymentMethod.payment_method_translation`.`payment_method_id` = `customer.defaultPaymentMethod`.`id` LEFT JOIN `app_payment_method` `customer.defaultPaymentMethod.appPaymentMethod` ON `customer.defaultPaymentMethod`.`id` = `customer.defaultPaymentMethod.appPaymentMethod`.`payment_method_id` WHERE (((`customer`.`bound_sales_channel_id` <=> NULL OR `customer`.`bound_sales_channel_id` = 0xC688A533F6BF4D6094F13EF532190DEF))) AND (`customer`.`id` IN (0x0E6B022E0F294160B7672EB0830D3395));

# base-context-factory::shipping-method::read
SELECT
  `shipping_method`.`id` AS `shipping_method.id`,
  `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.deliveryTime`.`id` AS `shipping_method.deliveryTime.id`,
  `shipping_method.deliveryTime`.`min` AS `shipping_method.deliveryTime.min`,
  `shipping_method.deliveryTime`.`max` AS `shipping_method.deliveryTime.max`,
  `shipping_method.deliveryTime`.`unit` AS `shipping_method.deliveryTime.unit`,
  `shipping_method.deliveryTime`.`created_at` AS `shipping_method.deliveryTime.createdAt`,
  `shipping_method.deliveryTime`.`updated_at` AS `shipping_method.deliveryTime.updatedAt`,
  `shipping_method.deliveryTime.translation.fallback_1.name`,
  `shipping_method.deliveryTime.translation.name`,
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.name`,
    `shipping_method.deliveryTime.translation.name`,
    `shipping_method.deliveryTime.translation.name`
  ) AS `shipping_method.deliveryTime.name`,
  `shipping_method.deliveryTime.translation.fallback_1.customFields`,
  `shipping_method.deliveryTime.translation.customFields`,
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.customFields`,
    `shipping_method.deliveryTime.translation.customFields`,
    `shipping_method.deliveryTime.translation.customFields`
  ) AS `shipping_method.deliveryTime.customFields`,
  `shipping_method.deliveryTime.translation.fallback_1.createdAt`,
  `shipping_method.deliveryTime.translation.createdAt`,
  `shipping_method.deliveryTime.translation.fallback_1.updatedAt`,
  `shipping_method.deliveryTime.translation.updatedAt`,
  `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`,
  `shipping_method.deliveryTime.translation.deliveryTimeId`,
  `shipping_method.deliveryTime.translation.fallback_1.languageId`,
  `shipping_method.deliveryTime.translation.languageId`,
  `shipping_method.appShippingMethod`.`id` AS `shipping_method.appShippingMethod.id`,
  `shipping_method.appShippingMethod`.`app_name` AS `shipping_method.appShippingMethod.appName`,
  `shipping_method.appShippingMethod`.`identifier` AS `shipping_method.appShippingMethod.identifier`,
  `shipping_method.appShippingMethod`.`app_id` AS `shipping_method.appShippingMethod.appId`,
  `shipping_method.appShippingMethod`.`shipping_method_id` AS `shipping_method.appShippingMethod.shippingMethodId`,
  `shipping_method.appShippingMethod`.`original_media_id` AS `shipping_method.appShippingMethod.originalMediaId`,
  `shipping_method.appShippingMethod`.`created_at` AS `shipping_method.appShippingMethod.createdAt`,
  `shipping_method.appShippingMethod`.`updated_at` AS `shipping_method.appShippingMethod.updatedAt`,
  `shipping_method`.`technical_name` AS `shipping_method.technicalName`,
  `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`.`created_at` AS `shipping_method.media.createdAt`,
  `shipping_method.media`.`updated_at` AS `shipping_method.media.updatedAt`,
  `shipping_method.media.translation.fallback_1.title`,
  `shipping_method.media.translation.title`,
  COALESCE(
    `shipping_method.media.translation.fallback_1.title`,
    `shipping_method.media.translation.title`,
    `shipping_method.media.translation.title`
  ) AS `shipping_method.media.title`,
  `shipping_method.media.translation.fallback_1.alt`,
  `shipping_method.media.translation.alt`,
  COALESCE(
    `shipping_method.media.translation.fallback_1.alt`,
    `shipping_method.media.translation.alt`,
    `shipping_method.media.translation.alt`
  ) AS `shipping_method.media.alt`,
  `shipping_method.media.translation.fallback_1.customFields`,
  `shipping_method.media.translation.customFields`,
  COALESCE(
    `shipping_method.media.translation.fallback_1.customFields`,
    `shipping_method.media.translation.customFields`,
    `shipping_method.media.translation.customFields`
  ) AS `shipping_method.media.customFields`,
  `shipping_method.media.translation.fallback_1.createdAt`,
  `shipping_method.media.translation.createdAt`,
  `shipping_method.media.translation.fallback_1.updatedAt`,
  `shipping_method.media.translation.updatedAt`,
  `shipping_method.media.translation.fallback_1.mediaId`,
  `shipping_method.media.translation.mediaId`,
  `shipping_method.media.translation.fallback_1.languageId`,
  `shipping_method.media.translation.languageId`,
  `shipping_method.translation.fallback_1.name`,
  `shipping_method.translation.name`,
  COALESCE(
    `shipping_method.translation.fallback_1.name`,
    `shipping_method.translation.name`,
    `shipping_method.translation.name`
  ) AS `shipping_method.name`,
  `shipping_method.translation.fallback_1.description`,
  `shipping_method.translation.description`,
  COALESCE(
    `shipping_method.translation.fallback_1.description`,
    `shipping_method.translation.description`,
    `shipping_method.translation.description`
  ) AS `shipping_method.description`,
  `shipping_method.translation.fallback_1.trackingUrl`,
  `shipping_method.translation.trackingUrl`,
  COALESCE(
    `shipping_method.translation.fallback_1.trackingUrl`,
    `shipping_method.translation.trackingUrl`,
    `shipping_method.translation.trackingUrl`
  ) AS `shipping_method.trackingUrl`,
  `shipping_method.translation.fallback_1.customFields`,
  `shipping_method.translation.customFields`,
  COALESCE(
    `shipping_method.translation.fallback_1.customFields`,
    `shipping_method.translation.customFields`,
    `shipping_method.translation.customFields`
  ) AS `shipping_method.customFields`,
  `shipping_method.translation.fallback_1.createdAt`,
  `shipping_method.translation.createdAt`,
  `shipping_method.translation.fallback_1.updatedAt`,
  `shipping_method.translation.updatedAt`,
  `shipping_method.translation.fallback_1.shippingMethodId`,
  `shipping_method.translation.shippingMethodId`,
  `shipping_method.translation.fallback_1.languageId`,
  `shipping_method.translation.languageId`
FROM
  `shipping_method`
  LEFT JOIN (
    SELECT
      `shipping_method.translation`.shipping_method_id,
      `shipping_method.translation`.name AS `shipping_method.translation.name`,
      `shipping_method.translation`.description AS `shipping_method.translation.description`,
      `shipping_method.translation`.tracking_url AS `shipping_method.translation.trackingUrl`,
      `shipping_method.translation`.custom_fields AS `shipping_method.translation.customFields`,
      `shipping_method.translation`.created_at AS `shipping_method.translation.createdAt`,
      `shipping_method.translation`.updated_at AS `shipping_method.translation.updatedAt`,
      `shipping_method.translation`.shipping_method_id AS `shipping_method.translation.shippingMethodId`,
      `shipping_method.translation`.language_id AS `shipping_method.translation.languageId`,
      `shipping_method.translation.fallback_1`.name AS `shipping_method.translation.fallback_1.name`,
      `shipping_method.translation.fallback_1`.description AS `shipping_method.translation.fallback_1.description`,
      `shipping_method.translation.fallback_1`.tracking_url AS `shipping_method.translation.fallback_1.trackingUrl`,
      `shipping_method.translation.fallback_1`.custom_fields AS `shipping_method.translation.fallback_1.customFields`,
      `shipping_method.translation.fallback_1`.created_at AS `shipping_method.translation.fallback_1.createdAt`,
      `shipping_method.translation.fallback_1`.updated_at AS `shipping_method.translation.fallback_1.updatedAt`,
      `shipping_method.translation.fallback_1`.shipping_method_id AS `shipping_method.translation.fallback_1.shippingMethodId`,
      `shipping_method.translation.fallback_1`.language_id AS `shipping_method.translation.fallback_1.languageId`
    FROM
      `shipping_method_translation` `shipping_method.translation`
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id`
      AND `shipping_method.translation.fallback_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 `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
  LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id`
  LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.deliveryTime.translation`.delivery_time_id,
      `shipping_method.deliveryTime.translation`.name AS `shipping_method.deliveryTime.translation.name`,
      `shipping_method.deliveryTime.translation`.custom_fields AS `shipping_method.deliveryTime.translation.customFields`,
      `shipping_method.deliveryTime.translation`.created_at AS `shipping_method.deliveryTime.translation.createdAt`,
      `shipping_method.deliveryTime.translation`.updated_at AS `shipping_method.deliveryTime.translation.updatedAt`,
      `shipping_method.deliveryTime.translation`.delivery_time_id AS `shipping_method.deliveryTime.translation.deliveryTimeId`,
      `shipping_method.deliveryTime.translation`.language_id AS `shipping_method.deliveryTime.translation.languageId`,
      `shipping_method.deliveryTime.translation.fallback_1`.name AS `shipping_method.deliveryTime.translation.fallback_1.name`,
      `shipping_method.deliveryTime.translation.fallback_1`.custom_fields AS `shipping_method.deliveryTime.translation.fallback_1.customFields`,
      `shipping_method.deliveryTime.translation.fallback_1`.created_at AS `shipping_method.deliveryTime.translation.fallback_1.createdAt`,
      `shipping_method.deliveryTime.translation.fallback_1`.updated_at AS `shipping_method.deliveryTime.translation.fallback_1.updatedAt`,
      `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id AS `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`,
      `shipping_method.deliveryTime.translation.fallback_1`.language_id AS `shipping_method.deliveryTime.translation.fallback_1.languageId`
    FROM
      `delivery_time_translation` `shipping_method.deliveryTime.translation`
      LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id`
      AND `shipping_method.deliveryTime.translation.fallback_1`.language_id = ?
    WHERE
      `shipping_method.deliveryTime.translation`.language_id = ?
  ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
  LEFT JOIN (
    SELECT
      `shipping_method.media.translation`.media_id,
      `shipping_method.media.translation`.title AS `shipping_method.media.translation.title`,
      `shipping_method.media.translation`.alt AS `shipping_method.media.translation.alt`,
      `shipping_method.media.translation`.custom_fields AS `shipping_method.media.translation.customFields`,
      `shipping_method.media.translation`.created_at AS `shipping_method.media.translation.createdAt`,
      `shipping_method.media.translation`.updated_at AS `shipping_method.media.translation.updatedAt`,
      `shipping_method.media.translation`.media_id AS `shipping_method.media.translation.mediaId`,
      `shipping_method.media.translation`.language_id AS `shipping_method.media.translation.languageId`,
      `shipping_method.media.translation.fallback_1`.title AS `shipping_method.media.translation.fallback_1.title`,
      `shipping_method.media.translation.fallback_1`.alt AS `shipping_method.media.translation.fallback_1.alt`,
      `shipping_method.media.translation.fallback_1`.custom_fields AS `shipping_method.media.translation.fallback_1.customFields`,
      `shipping_method.media.translation.fallback_1`.created_at AS `shipping_method.media.translation.fallback_1.createdAt`,
      `shipping_method.media.translation.fallback_1`.updated_at AS `shipping_method.media.translation.fallback_1.updatedAt`,
      `shipping_method.media.translation.fallback_1`.media_id AS `shipping_method.media.translation.fallback_1.mediaId`,
      `shipping_method.media.translation.fallback_1`.language_id AS `shipping_method.media.translation.fallback_1.languageId`
    FROM
      `media_translation` `shipping_method.media.translation`
      LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.fallback_1`.`media_id`
      AND `shipping_method.media.translation.fallback_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 (?)