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;

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 = 0x52E9561628DB4BFFAFCB63F5CEAFC4A6) AND (token = 'yqWxnCdBpNjJsasyZ16Zf1mYvRVMjXVY') 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` = 'yqWxnCdBpNjJsasyZ16Zf1mYvRVMjXVY';

# 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_014135da72e643baa9449a4e935e3e5b 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_0b8d3019612849f5b2b562a85f87d312 
      AND (
        (
          `promotion`.`valid_from` <=> : param_e30d8cb9738e40508725dccee166f28f 
          AND `promotion`.`valid_until` <=> : param_54783e196293410a9ec502d3a054b71e
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_c76781c6bad44cbdac92c9c9d00529e7 
          AND (
            `promotion`.`valid_until` > : param_5681952b44f54a3d9f4ea4f1c059143f
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_330250d34d3640bf9c6f95dce854d88a
          ) 
          AND `promotion`.`valid_until` <=> : param_0bac31b733a74862b1ff73cc83f91f0c
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_763f8f8c930042cb85cf3b296b29d9df
          ) 
          AND (
            `promotion`.`valid_until` > : param_443a8dbc60df49de9e9677c70ea3e678
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_813db476c835453787894f3b9600bbde
    )
  ) 
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` = 0x52E9561628DB4BFFAFCB63F5CEAFC4A6 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2026-06-30 22:53:13')) OR ((`promotion`.`valid_from` <= '2026-06-30 22:53:13') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2026-06-30 22:53:13') AND (`promotion`.`valid_until` > '2026-06-30 22:53:13'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

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

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

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

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

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

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`.`id` IN (: ids)

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`.`id` IN (0xAD1ECAF7642247B48FA4C1C94E946057);

SELECT 
  `script`.`id` as `script.id`, 
  `script`.`script` as `script.script`, 
  `script`.`hook` as `script.hook`, 
  `script`.`name` as `script.name`, 
  `script`.`active` as `script.active`, 
  `script`.`app_id` as `script.appId`, 
  `script`.`created_at` as `script.createdAt`, 
  `script`.`updated_at` as `script.updatedAt` 
FROM 
  `script` 
WHERE 
  (
    `script`.`app_id` IN (
      : param_23d3d3b1eec741edb8a98e96be7ac6f1
    )
  )

SELECT `script`.`id` as `script.id`, `script`.`script` as `script.script`, `script`.`hook` as `script.hook`, `script`.`name` as `script.name`, `script`.`active` as `script.active`, `script`.`app_id` as `script.appId`, `script`.`created_at` as `script.createdAt`, `script`.`updated_at` as `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (0xAD1ECAF7642247B48FA4C1C94E946057));