Symfony Profiler

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

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

SELECT 
  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_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_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_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_1658786605_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_1664541794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664894872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665064823_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665267882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667806582_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675170041_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675170246_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676022402_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1695215476_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059645_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059646_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059647_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059648_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059650_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059651_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1565933910_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640060_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640070_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640076_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580300846_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582119202_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582281362_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583477457_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486534_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489755_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489757_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588252518_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594288127_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594373672_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594727519_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602060888_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602675838_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609233961_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616141231_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631631689_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636082647_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662306139_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662757955_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663039410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676830357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1565395385_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584635124_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588727980_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601730310_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603885123_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604593154_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605622963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607516170_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609325729_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610207656_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612728896_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631631689_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633446993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662306139_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663915604_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669119437_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609743530_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1725417563_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588000511_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589797640_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589797666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589797703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594624817_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594629843_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615495760_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615557659_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615557659_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620125819_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623059691_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658582199_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660032188_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678455662_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678455662_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663757062_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663853989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664181012_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587625591_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588055335_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624512389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624515124_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624516627_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629959675_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612967598_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621266530_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648999084_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_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_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_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_1658786605_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_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1675170041_IS_ACTIVE = TRUE;SET @MIGRATION_1675170246_IS_ACTIVE = TRUE;SET @MIGRATION_1676022402_IS_ACTIVE = TRUE;SET @MIGRATION_1695215476_IS_ACTIVE = TRUE;SET @MIGRATION_1564059645_IS_ACTIVE = TRUE;SET @MIGRATION_1564059646_IS_ACTIVE = TRUE;SET @MIGRATION_1564059647_IS_ACTIVE = TRUE;SET @MIGRATION_1564059648_IS_ACTIVE = TRUE;SET @MIGRATION_1564059650_IS_ACTIVE = TRUE;SET @MIGRATION_1564059651_IS_ACTIVE = TRUE;SET @MIGRATION_1565933910_IS_ACTIVE = TRUE;SET @MIGRATION_1568640060_IS_ACTIVE = TRUE;SET @MIGRATION_1568640070_IS_ACTIVE = TRUE;SET @MIGRATION_1568640076_IS_ACTIVE = TRUE;SET @MIGRATION_1580300846_IS_ACTIVE = TRUE;SET @MIGRATION_1582119202_IS_ACTIVE = TRUE;SET @MIGRATION_1582281362_IS_ACTIVE = TRUE;SET @MIGRATION_1583477457_IS_ACTIVE = TRUE;SET @MIGRATION_1583486528_IS_ACTIVE = TRUE;SET @MIGRATION_1583486534_IS_ACTIVE = TRUE;SET @MIGRATION_1583489755_IS_ACTIVE = TRUE;SET @MIGRATION_1583489757_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1588252518_IS_ACTIVE = TRUE;SET @MIGRATION_1594288127_IS_ACTIVE = TRUE;SET @MIGRATION_1594373672_IS_ACTIVE = TRUE;SET @MIGRATION_1594727519_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1602060888_IS_ACTIVE = TRUE;SET @MIGRATION_1602675838_IS_ACTIVE = TRUE;SET @MIGRATION_1609233961_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1565395385_IS_ACTIVE = TRUE;SET @MIGRATION_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1588727980_IS_ACTIVE = TRUE;SET @MIGRATION_1601730310_IS_ACTIVE = TRUE;SET @MIGRATION_1603885123_IS_ACTIVE = TRUE;SET @MIGRATION_1604593154_IS_ACTIVE = TRUE;SET @MIGRATION_1605622963_IS_ACTIVE = TRUE;SET @MIGRATION_1607516170_IS_ACTIVE = TRUE;SET @MIGRATION_1609325729_IS_ACTIVE = TRUE;SET @MIGRATION_1610207656_IS_ACTIVE = TRUE;SET @MIGRATION_1612728896_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1633446993_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1663915604_IS_ACTIVE = TRUE;SET @MIGRATION_1669119437_IS_ACTIVE = TRUE;SET @MIGRATION_1609743530_IS_ACTIVE = TRUE;SET @MIGRATION_1725417563_IS_ACTIVE = TRUE;SET @MIGRATION_1588000511_IS_ACTIVE = TRUE;SET @MIGRATION_1589797640_IS_ACTIVE = TRUE;SET @MIGRATION_1589797666_IS_ACTIVE = TRUE;SET @MIGRATION_1589797703_IS_ACTIVE = TRUE;SET @MIGRATION_1594624817_IS_ACTIVE = TRUE;SET @MIGRATION_1594629843_IS_ACTIVE = TRUE;SET @MIGRATION_1615495760_IS_ACTIVE = TRUE;SET @MIGRATION_1615557659_IS_ACTIVE = TRUE;SET @MIGRATION_1615557659_IS_ACTIVE = TRUE;SET @MIGRATION_1620125819_IS_ACTIVE = TRUE;SET @MIGRATION_1623059691_IS_ACTIVE = TRUE;SET @MIGRATION_1658582199_IS_ACTIVE = TRUE;SET @MIGRATION_1660032188_IS_ACTIVE = TRUE;SET @MIGRATION_1678455662_IS_ACTIVE = TRUE;SET @MIGRATION_1678455662_IS_ACTIVE = TRUE;SET @MIGRATION_1663757062_IS_ACTIVE = TRUE;SET @MIGRATION_1663853989_IS_ACTIVE = TRUE;SET @MIGRATION_1664181012_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1587625591_IS_ACTIVE = TRUE;SET @MIGRATION_1588055335_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1629959675_IS_ACTIVE = TRUE;SET @MIGRATION_1612967598_IS_ACTIVE = TRUE;SET @MIGRATION_1621266530_IS_ACTIVE = TRUE;SET @MIGRATION_1648999084_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 = 0x11AC6087B57C4415A973B940465E9818 OR sales_channel_id IS NULL)) AND (seo_path_info = 'Craft-White-Coupteller-oe-253-mm/STE-11550566') 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 = 0x11AC6087B57C4415A973B940465E9818) AND (token = '2kUJpe6Dyrjbme6vBPowlpLUBV6AJ5u4') 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` = '2kUJpe6Dyrjbme6vBPowlpLUBV6AJ5u4';

# 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_a0d63ba5ee294bcb964c47fc515d3b5b 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_1e53d1c9afc747668c471c0f8f765594 
      AND (
        (
          `promotion`.`valid_from` <=> : param_fed11009513a4870944743b4c9ec4e84 
          AND `promotion`.`valid_until` <=> : param_5fb25a4912cb4f5c98b07d189d53d4e3
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_c36e3c32c7e64e07b24170f09b8f598b 
          AND (
            `promotion`.`valid_until` > : param_497d69203fec41a1b1d7a1f0c4ed4b37
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_4e751f0607f6466d8b2e354d13001287
          ) 
          AND `promotion`.`valid_until` <=> : param_404411d9002d43b9a91c5eaedf145383
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_267d8bc5164e4beca62bf6932d11c035
          ) 
          AND (
            `promotion`.`valid_until` > : param_89c2b3ae206d4042a451a794797c2ade
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_caab5bbf1c1d4f9b89a57e4362335085
    )
  ) 
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` = 0x11AC6087B57C4415A973B940465E9818 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2026-10-03 04:12:12')) OR ((`promotion`.`valid_from` <= '2026-10-03 04:12:12') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2026-10-03 04:12:12') AND (`promotion`.`valid_until` > '2026-10-03 04:12:12'))) 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 (0x70AA8209C65B42A9A0AC936F2BBE495D, 0x439B235C22964DBAB2A14C18E1AFC10D);

# cart::promotion::association::personaRules::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::personaRules::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 (0x330D059960C8484189ED4CE7B1BB7504);

# 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 (0x41990322F53C4D71AEC144A34FBD89B9);

# cart::promotion::association::orderRules::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::orderRules::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 (0x05616F7342D8433E8528A22DE6F077EF);

# 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_7500e1fc1c454b55a4a9a783a0e0ae86
    )
  )

# 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 (0x439B235C22964DBAB2A14C18E1AFC10D, 0x70AA8209C65B42A9A0AC936F2BBE495D));

# 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_d8464eac9db6499b897ebd9b919a3321
    )
  )

# 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 (0xCF234828F7D1457F860FC8E326C6A3A4));

# 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_38258876e0034695aaef451de728f163
    )
  )

# 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 (0x439B235C22964DBAB2A14C18E1AFC10D, 0x70AA8209C65B42A9A0AC936F2BBE495D));

# 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 (0x80A6BDBA7AD14D8182844D07420B957B);