Symfony Profiler

# cache-id-loader
SELECT 
  `value` 
FROM 
  app_config 
WHERE 
  `key` = : key

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

# 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 
  custom_entity.name, 
  custom_entity.fields 
FROM 
  custom_entity 
  LEFT JOIN app ON app.id = custom_entity.app_id 
WHERE 
  custom_entity.app_id IS NULL 
  OR app.active = 1

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

SELECT 
  `creation_timestamp` 
FROM 
  `migration` 
WHERE 
  `update` IS NOT NULL 
  AND `update_destructive` IS NULL

SELECT `creation_timestamp`
                FROM `migration`
                WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
            ;

SET 
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len, 
      320000
    ) AS UNSIGNED
  ); 
SET 
  sql_mode =(
    SELECT 
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY', 
        ''
      )
  ); 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639122665_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642517958_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645453538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647260673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647443222_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031611_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031636_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648803451_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649040981_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649315608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649858046_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650620993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651118773_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655730949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657027979_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657173907_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658786605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659256999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257296_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257396_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660814397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661759290_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661771388_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663238480_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664512574_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664541794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664894872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665064823_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665267882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667731399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667806582_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667983492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1668677456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669316067_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672164687_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672743034_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673001912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673966228_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675218708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675827655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1579528195_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596557182_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599558860_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601799488_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603055209_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609925155_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612341396_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617005993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618322963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625654055_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631093748_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632238456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1640185442_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646643551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651236472_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652880057_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653126356_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653128194_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656085043_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669388954_IS_ACTIVE = TRUE

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1579528195_IS_ACTIVE = TRUE;SET @MIGRATION_1596557182_IS_ACTIVE = TRUE;SET @MIGRATION_1599558860_IS_ACTIVE = TRUE;SET @MIGRATION_1601799488_IS_ACTIVE = TRUE;SET @MIGRATION_1603055209_IS_ACTIVE = TRUE;SET @MIGRATION_1609925155_IS_ACTIVE = TRUE;SET @MIGRATION_1612341396_IS_ACTIVE = TRUE;SET @MIGRATION_1617005993_IS_ACTIVE = TRUE;SET @MIGRATION_1618322963_IS_ACTIVE = TRUE;SET @MIGRATION_1625654055_IS_ACTIVE = TRUE;SET @MIGRATION_1631093748_IS_ACTIVE = TRUE;SET @MIGRATION_1632238456_IS_ACTIVE = TRUE;SET @MIGRATION_1640185442_IS_ACTIVE = TRUE;SET @MIGRATION_1646643551_IS_ACTIVE = TRUE;SET @MIGRATION_1651236472_IS_ACTIVE = TRUE;SET @MIGRATION_1652880057_IS_ACTIVE = TRUE;SET @MIGRATION_1653126356_IS_ACTIVE = TRUE;SET @MIGRATION_1653128194_IS_ACTIVE = TRUE;SET @MIGRATION_1656085043_IS_ACTIVE = TRUE;SET @MIGRATION_1669388954_IS_ACTIVE = TRUE;

# seo-url::resolve
SELECT 
  id, 
  path_info pathInfo, 
  is_canonical isCanonical 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    (
      sales_channel_id = : sales_channel_id 
      OR sales_channel_id IS NULL
    )
  ) 
  AND (seo_path_info = : seoPath) 
ORDER BY 
  seo_path_info ASC, 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x1952DB739A714D9C98A4DC7B538F93F1 OR sales_channel_id IS NULL)) AND (seo_path_info = 'badezimmer-haengeschrank-hochglanz-weiss-wenge-nina.html') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

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

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

SHOW COLUMNS 
FROM 
  `cart` 
WHERE 
  `Field` LIKE : column

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

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

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

# cart::promotion::search-ids
SELECT 
  `promotion`.`id` 
FROM 
  `promotion` 
  LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` 
WHERE 
  (
    (
      `promotion`.`active` = : param_d76bf8ee863a4dd09ec589b5d8ef44d7 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_c0dcdcfe88bf4830b2d0f0c9dbdee77e 
      AND (
        (
          `promotion`.`valid_from` <=> : param_dc331ed240554ae8b36b2b2de61ecd4d 
          AND `promotion`.`valid_until` <=> : param_1ef67f5646d6445a8aa74c0a2d90b7f8
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_8f59f52debc94922b2c25a63f04010d5 
          AND (
            `promotion`.`valid_until` > : param_a6685dfdbdee478cafce2d6928b61f19
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_5f556c38824a4dd4ad00d5783d2b2bf1
          ) 
          AND `promotion`.`valid_until` <=> : param_21ed48f7030e4bc8b44423a5f893289c
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_866bb25107ce4767b74412f9fbe8e972
          ) 
          AND (
            `promotion`.`valid_until` > : param_fcb40223aa6c43968d259970c69124af
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_fca2c306b1504f1a8565991f697c3a84
    )
  ) 
GROUP BY 
  `promotion`.`id` 
ORDER BY 
  MAX(`promotion`.`priority`) DESC

# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = 1 AND `promotion.salesChannels`.`sales_channel_id` = 0x1952DB739A714D9C98A4DC7B538F93F1 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2025-01-10 10:48:43')) OR ((`promotion`.`valid_from` <= '2025-01-10 10:48:43') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-01-10 10:48:43') AND (`promotion`.`valid_until` > '2025-01-10 10:48:43'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

# cart::promotion::read
SELECT 
  `promotion`.`id` as `promotion.id`, 
  `promotion`.`active` as `promotion.active`, 
  `promotion`.`valid_from` as `promotion.validFrom`, 
  `promotion`.`valid_until` as `promotion.validUntil`, 
  `promotion`.`max_redemptions_global` as `promotion.maxRedemptionsGlobal`, 
  `promotion`.`max_redemptions_per_customer` as `promotion.maxRedemptionsPerCustomer`, 
  `promotion`.`priority` as `promotion.priority`, 
  `promotion`.`exclusive` as `promotion.exclusive`, 
  `promotion`.`code` as `promotion.code`, 
  `promotion`.`use_codes` as `promotion.useCodes`, 
  `promotion`.`use_individual_codes` as `promotion.useIndividualCodes`, 
  `promotion`.`individual_code_pattern` as `promotion.individualCodePattern`, 
  `promotion`.`use_setgroups` as `promotion.useSetGroups`, 
  `promotion`.`customer_restriction` as `promotion.customerRestriction`, 
  `promotion`.`prevent_combination` as `promotion.preventCombination`, 
  `promotion`.`order_count` as `promotion.orderCount`, 
  `promotion`.`orders_per_customer_count` as `promotion.ordersPerCustomerCount`, 
  `promotion`.`exclusion_ids` as `promotion.exclusionIds`, 
  `promotion`.`created_at` as `promotion.createdAt`, 
  `promotion`.`updated_at` as `promotion.updatedAt`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion.personaRules.mapping`.`rule_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_persona_rule` `promotion.personaRules.mapping` 
    WHERE 
      `promotion.personaRules.mapping`.`promotion_id` = `promotion`.`id`
  ) as `promotion.personaRules.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion.personaCustomers.mapping`.`customer_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_persona_customer` `promotion.personaCustomers.mapping` 
    WHERE 
      `promotion.personaCustomers.mapping`.`promotion_id` = `promotion`.`id`
  ) as `promotion.personaCustomers.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion.cartRules.mapping`.`rule_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_cart_rule` `promotion.cartRules.mapping` 
    WHERE 
      `promotion.cartRules.mapping`.`promotion_id` = `promotion`.`id`
  ) as `promotion.cartRules.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion.orderRules.mapping`.`rule_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_order_rule` `promotion.orderRules.mapping` 
    WHERE 
      `promotion.orderRules.mapping`.`promotion_id` = `promotion`.`id`
  ) as `promotion.orderRules.id_mapping`, 
  `promotion.translation.name`, 
  COALESCE(
    `promotion.translation.name`, `promotion.translation.name`
  ) as `promotion.name`, 
  `promotion.translation.customFields`, 
  COALESCE(
    `promotion.translation.customFields`, 
    `promotion.translation.customFields`
  ) as `promotion.customFields`, 
  `promotion.translation.createdAt`, 
  `promotion.translation.updatedAt`, 
  `promotion.translation.promotionId`, 
  `promotion.translation.languageId` 
FROM 
  `promotion` 
  LEFT JOIN (
    SELECT 
      `promotion.translation`.promotion_id, 
      `promotion.translation`.name as `promotion.translation.name`, 
      `promotion.translation`.custom_fields as `promotion.translation.customFields`, 
      `promotion.translation`.created_at as `promotion.translation.createdAt`, 
      `promotion.translation`.updated_at as `promotion.translation.updatedAt`, 
      `promotion.translation`.promotion_id as `promotion.translation.promotionId`, 
      `promotion.translation`.language_id as `promotion.translation.languageId` 
    FROM 
      `promotion_translation` `promotion.translation` 
    WHERE 
      `promotion.translation`.language_id = : languageId
  ) `promotion.promotion_translation` ON `promotion.promotion_translation`.`promotion_id` = `promotion`.`id` 
WHERE 
  `promotion`.`id` IN (: ids)

# cart::promotion::read
SELECT `promotion`.`id` as `promotion.id`, `promotion`.`active` as `promotion.active`, `promotion`.`valid_from` as `promotion.validFrom`, `promotion`.`valid_until` as `promotion.validUntil`, `promotion`.`max_redemptions_global` as `promotion.maxRedemptionsGlobal`, `promotion`.`max_redemptions_per_customer` as `promotion.maxRedemptionsPerCustomer`, `promotion`.`priority` as `promotion.priority`, `promotion`.`exclusive` as `promotion.exclusive`, `promotion`.`code` as `promotion.code`, `promotion`.`use_codes` as `promotion.useCodes`, `promotion`.`use_individual_codes` as `promotion.useIndividualCodes`, `promotion`.`individual_code_pattern` as `promotion.individualCodePattern`, `promotion`.`use_setgroups` as `promotion.useSetGroups`, `promotion`.`customer_restriction` as `promotion.customerRestriction`, `promotion`.`prevent_combination` as `promotion.preventCombination`, `promotion`.`order_count` as `promotion.orderCount`, `promotion`.`orders_per_customer_count` as `promotion.ordersPerCustomerCount`, `promotion`.`exclusion_ids` as `promotion.exclusionIds`, `promotion`.`created_at` as `promotion.createdAt`, `promotion`.`updated_at` as `promotion.updatedAt`, (SELECT GROUP_CONCAT(HEX(`promotion.personaRules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `promotion_persona_rule` `promotion.personaRules.mapping`
                  WHERE `promotion.personaRules.mapping`.`promotion_id` = `promotion`.`id` ) as `promotion.personaRules.id_mapping`, (SELECT GROUP_CONCAT(HEX(`promotion.personaCustomers.mapping`.`customer_id`) SEPARATOR '||')
                  FROM `promotion_persona_customer` `promotion.personaCustomers.mapping`
                  WHERE `promotion.personaCustomers.mapping`.`promotion_id` = `promotion`.`id` ) as `promotion.personaCustomers.id_mapping`, (SELECT GROUP_CONCAT(HEX(`promotion.cartRules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `promotion_cart_rule` `promotion.cartRules.mapping`
                  WHERE `promotion.cartRules.mapping`.`promotion_id` = `promotion`.`id` ) as `promotion.cartRules.id_mapping`, (SELECT GROUP_CONCAT(HEX(`promotion.orderRules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `promotion_order_rule` `promotion.orderRules.mapping`
                  WHERE `promotion.orderRules.mapping`.`promotion_id` = `promotion`.`id` ) as `promotion.orderRules.id_mapping`, `promotion.translation.name`, COALESCE(`promotion.translation.name`,`promotion.translation.name`) as `promotion.name`, `promotion.translation.customFields`, COALESCE(`promotion.translation.customFields`,`promotion.translation.customFields`) as `promotion.customFields`, `promotion.translation.createdAt`, `promotion.translation.updatedAt`, `promotion.translation.promotionId`, `promotion.translation.languageId` FROM `promotion` LEFT JOIN (SELECT `promotion.translation`.promotion_id, `promotion.translation`.name as `promotion.translation.name`, `promotion.translation`.custom_fields as `promotion.translation.customFields`, `promotion.translation`.created_at as `promotion.translation.createdAt`, `promotion.translation`.updated_at as `promotion.translation.updatedAt`, `promotion.translation`.promotion_id as `promotion.translation.promotionId`, `promotion.translation`.language_id as `promotion.translation.languageId` FROM `promotion_translation` `promotion.translation` WHERE `promotion.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `promotion.promotion_translation` ON `promotion.promotion_translation`.`promotion_id` = `promotion`.`id` WHERE `promotion`.`id` IN (0x96A81265F3FC4E78A37DE79D0C5EB365);

# cart::promotion::association::cartRules::read
SELECT 
  `rule`.`id` as `rule.id`, 
  `rule`.`name` as `rule.name`, 
  `rule`.`priority` as `rule.priority`, 
  `rule`.`description` as `rule.description`, 
  `rule`.`payload` as `rule.payload`, 
  `rule`.`invalid` as `rule.invalid`, 
  `rule`.`areas` as `rule.areas`, 
  `rule`.`custom_fields` as `rule.customFields`, 
  `rule`.`module_types` as `rule.moduleTypes`, 
  `rule`.`created_at` as `rule.createdAt`, 
  `rule`.`updated_at` as `rule.updatedAt` 
FROM 
  `rule` 
WHERE 
  `rule`.`id` IN (: ids)

# cart::promotion::association::cartRules::read
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x3E272B46AC9041A099869A430EA056F6);

# cart::promotion::association::discounts::read
SELECT 
  `promotion_discount`.`id` as `promotion_discount.id`, 
  `promotion_discount`.`promotion_id` as `promotion_discount.promotionId`, 
  `promotion_discount`.`scope` as `promotion_discount.scope`, 
  `promotion_discount`.`type` as `promotion_discount.type`, 
  `promotion_discount`.`value` as `promotion_discount.value`, 
  `promotion_discount`.`consider_advanced_rules` as `promotion_discount.considerAdvancedRules`, 
  `promotion_discount`.`max_value` as `promotion_discount.maxValue`, 
  `promotion_discount`.`sorter_key` as `promotion_discount.sorterKey`, 
  `promotion_discount`.`applier_key` as `promotion_discount.applierKey`, 
  `promotion_discount`.`usage_key` as `promotion_discount.usageKey`, 
  `promotion_discount`.`picker_key` as `promotion_discount.pickerKey`, 
  `promotion_discount`.`created_at` as `promotion_discount.createdAt`, 
  `promotion_discount`.`updated_at` as `promotion_discount.updatedAt`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion_discount.discountRules.mapping`.`rule_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_discount_rule` `promotion_discount.discountRules.mapping` 
    WHERE 
      `promotion_discount.discountRules.mapping`.`discount_id` = `promotion_discount`.`id`
  ) as `promotion_discount.discountRules.id_mapping` 
FROM 
  `promotion_discount` 
WHERE 
  (
    `promotion_discount`.`promotion_id` IN (
      : param_c7ca56ec62be41dc9f87805714939678
    )
  )

# cart::promotion::association::discounts::read
SELECT `promotion_discount`.`id` as `promotion_discount.id`, `promotion_discount`.`promotion_id` as `promotion_discount.promotionId`, `promotion_discount`.`scope` as `promotion_discount.scope`, `promotion_discount`.`type` as `promotion_discount.type`, `promotion_discount`.`value` as `promotion_discount.value`, `promotion_discount`.`consider_advanced_rules` as `promotion_discount.considerAdvancedRules`, `promotion_discount`.`max_value` as `promotion_discount.maxValue`, `promotion_discount`.`sorter_key` as `promotion_discount.sorterKey`, `promotion_discount`.`applier_key` as `promotion_discount.applierKey`, `promotion_discount`.`usage_key` as `promotion_discount.usageKey`, `promotion_discount`.`picker_key` as `promotion_discount.pickerKey`, `promotion_discount`.`created_at` as `promotion_discount.createdAt`, `promotion_discount`.`updated_at` as `promotion_discount.updatedAt`, (SELECT GROUP_CONCAT(HEX(`promotion_discount.discountRules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `promotion_discount_rule` `promotion_discount.discountRules.mapping`
                  WHERE `promotion_discount.discountRules.mapping`.`discount_id` = `promotion_discount`.`id` ) as `promotion_discount.discountRules.id_mapping` FROM `promotion_discount` WHERE (`promotion_discount`.`promotion_id` IN (0x96A81265F3FC4E78A37DE79D0C5EB365));

# cart::promotion::association::discounts::association::promotionDiscountPrices::read
SELECT 
  `promotion_discount_prices`.`id` as `promotion_discount_prices.id`, 
  `promotion_discount_prices`.`discount_id` as `promotion_discount_prices.discountId`, 
  `promotion_discount_prices`.`currency_id` as `promotion_discount_prices.currencyId`, 
  `promotion_discount_prices`.`price` as `promotion_discount_prices.price`, 
  `promotion_discount_prices`.`created_at` as `promotion_discount_prices.createdAt`, 
  `promotion_discount_prices`.`updated_at` as `promotion_discount_prices.updatedAt` 
FROM 
  `promotion_discount_prices` 
WHERE 
  (
    `promotion_discount_prices`.`discount_id` IN (
      : param_8f84bf523e2d4a04a33e6cd18b158645
    )
  )

# cart::promotion::association::discounts::association::promotionDiscountPrices::read
SELECT `promotion_discount_prices`.`id` as `promotion_discount_prices.id`, `promotion_discount_prices`.`discount_id` as `promotion_discount_prices.discountId`, `promotion_discount_prices`.`currency_id` as `promotion_discount_prices.currencyId`, `promotion_discount_prices`.`price` as `promotion_discount_prices.price`, `promotion_discount_prices`.`created_at` as `promotion_discount_prices.createdAt`, `promotion_discount_prices`.`updated_at` as `promotion_discount_prices.updatedAt` FROM `promotion_discount_prices` WHERE (`promotion_discount_prices`.`discount_id` IN (0xF5148C00E72C428EA93BE4779A9F7B61));

# cart::promotion::association::setgroups::read
SELECT 
  `promotion_setgroup`.`id` as `promotion_setgroup.id`, 
  `promotion_setgroup`.`promotion_id` as `promotion_setgroup.promotionId`, 
  `promotion_setgroup`.`packager_key` as `promotion_setgroup.packagerKey`, 
  `promotion_setgroup`.`sorter_key` as `promotion_setgroup.sorterKey`, 
  `promotion_setgroup`.`value` as `promotion_setgroup.value`, 
  `promotion_setgroup`.`created_at` as `promotion_setgroup.createdAt`, 
  `promotion_setgroup`.`updated_at` as `promotion_setgroup.updatedAt`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `promotion_setgroup.setGroupRules.mapping`.`rule_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `promotion_setgroup_rule` `promotion_setgroup.setGroupRules.mapping` 
    WHERE 
      `promotion_setgroup.setGroupRules.mapping`.`setgroup_id` = `promotion_setgroup`.`id`
  ) as `promotion_setgroup.setGroupRules.id_mapping` 
FROM 
  `promotion_setgroup` 
WHERE 
  (
    `promotion_setgroup`.`promotion_id` IN (
      : param_3a4252c44a964c739b7708971c0d45e2
    )
  )

# cart::promotion::association::setgroups::read
SELECT `promotion_setgroup`.`id` as `promotion_setgroup.id`, `promotion_setgroup`.`promotion_id` as `promotion_setgroup.promotionId`, `promotion_setgroup`.`packager_key` as `promotion_setgroup.packagerKey`, `promotion_setgroup`.`sorter_key` as `promotion_setgroup.sorterKey`, `promotion_setgroup`.`value` as `promotion_setgroup.value`, `promotion_setgroup`.`created_at` as `promotion_setgroup.createdAt`, `promotion_setgroup`.`updated_at` as `promotion_setgroup.updatedAt`, (SELECT GROUP_CONCAT(HEX(`promotion_setgroup.setGroupRules.mapping`.`rule_id`) SEPARATOR '||')
                  FROM `promotion_setgroup_rule` `promotion_setgroup.setGroupRules.mapping`
                  WHERE `promotion_setgroup.setGroupRules.mapping`.`setgroup_id` = `promotion_setgroup`.`id` ) as `promotion_setgroup.setGroupRules.id_mapping` FROM `promotion_setgroup` WHERE (`promotion_setgroup`.`promotion_id` IN (0x96A81265F3FC4E78A37DE79D0C5EB365));

# cart::shipping-methods::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.name`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.name`, 
    `shipping_method.deliveryTime.translation.name`
  ) as `shipping_method.deliveryTime.name`, 
  `shipping_method.deliveryTime.translation.customFields`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`
  ) as `shipping_method.deliveryTime.customFields`, 
  `shipping_method.deliveryTime.translation.createdAt`, 
  `shipping_method.deliveryTime.translation.updatedAt`, 
  `shipping_method.deliveryTime.translation.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.languageId`, 
  `shipping_method`.`created_at` as `shipping_method.createdAt`, 
  `shipping_method`.`updated_at` as `shipping_method.updatedAt`, 
  `shipping_method.tax`.`id` as `shipping_method.tax.id`, 
  `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, 
  `shipping_method.tax`.`name` as `shipping_method.tax.name`, 
  `shipping_method.tax`.`position` as `shipping_method.tax.position`, 
  `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, 
  `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, 
  `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, 
  `shipping_method.translation.name`, 
  COALESCE(
    `shipping_method.translation.name`, 
    `shipping_method.translation.name`
  ) as `shipping_method.name`, 
  `shipping_method.translation.description`, 
  COALESCE(
    `shipping_method.translation.description`, 
    `shipping_method.translation.description`
  ) as `shipping_method.description`, 
  `shipping_method.translation.trackingUrl`, 
  COALESCE(
    `shipping_method.translation.trackingUrl`, 
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`, 
  `shipping_method.translation.customFields`, 
  COALESCE(
    `shipping_method.translation.customFields`, 
    `shipping_method.translation.customFields`
  ) as `shipping_method.customFields`, 
  `shipping_method.translation.createdAt`, 
  `shipping_method.translation.updatedAt`, 
  `shipping_method.translation.shippingMethodId`, 
  `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` 
    FROM 
      `shipping_method_translation` `shipping_method.translation` 
    WHERE 
      `shipping_method.translation`.language_id = : languageId
  ) `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 `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`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` 
    FROM 
      `delivery_time_translation` `shipping_method.deliveryTime.translation` 
    WHERE 
      `shipping_method.deliveryTime.translation`.language_id = : languageId
  ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` 
WHERE 
  `shipping_method`.`id` IN (: ids)

# cart::shipping-methods::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.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `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` FROM `shipping_method_translation` `shipping_method.translation` 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 `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`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` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (0x36358693C4604A4595A0528F232A0ED3);

# cart::shipping-methods::association::prices::read
SELECT 
  `shipping_method_price`.`id` as `shipping_method_price.id`, 
  `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, 
  `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, 
  `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, 
  `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, 
  `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, 
  `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, 
  `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, 
  `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, 
  `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, 
  `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` 
FROM 
  `shipping_method_price` 
WHERE 
  (
    `shipping_method_price`.`shipping_method_id` IN (
      : param_9ae7cd4945854789932d811c870d71d4
    )
  )

# cart::shipping-methods::association::prices::read
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (0x36358693C4604A4595A0528F232A0ED3));

# 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`.`write_access` as `app.integration.writeAccess`, 
  `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`.`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 = : languageId
  ) `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` = : param_4b5c515f85594492aab86a5ac0a347b3
  )

# 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`.`write_access` as `app.integration.writeAccess`, `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`.`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);