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_1692268099_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1704708027_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1704723642_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1704884956_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1705135925_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1705385916_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1705490341_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_1584635124_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654529559_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663348079_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664148561_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1674735643_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676971558_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644753635_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652444730_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669117848_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669796049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672671475_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678106061_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1695822535_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1711618833_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657777956_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1713775973_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_1692268099_IS_ACTIVE = TRUE;SET @MIGRATION_1704708027_IS_ACTIVE = TRUE;SET @MIGRATION_1704723642_IS_ACTIVE = TRUE;SET @MIGRATION_1704884956_IS_ACTIVE = TRUE;SET @MIGRATION_1705135925_IS_ACTIVE = TRUE;SET @MIGRATION_1705385916_IS_ACTIVE = TRUE;SET @MIGRATION_1705490341_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_1584635124_IS_ACTIVE = TRUE;SET @MIGRATION_1654529559_IS_ACTIVE = TRUE;SET @MIGRATION_1663348079_IS_ACTIVE = TRUE;SET @MIGRATION_1664148561_IS_ACTIVE = TRUE;SET @MIGRATION_1674735643_IS_ACTIVE = TRUE;SET @MIGRATION_1676971558_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1672671475_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_IS_ACTIVE = TRUE;SET @MIGRATION_1695822535_IS_ACTIVE = TRUE;SET @MIGRATION_1711618833_IS_ACTIVE = TRUE;SET @MIGRATION_1657777956_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1713775973_IS_ACTIVE = TRUE;

SELECT 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) `key`, 
  CONCAT(
    TRIM(
      TRAILING '/' 
      FROM 
        domain.url
    ), 
    '/'
  ) url, 
  LOWER(
    HEX(domain.id)
  ) id, 
  LOWER(
    HEX(sales_channel.id)
  ) salesChannelId, 
  LOWER(
    HEX(sales_channel.type_id)
  ) typeId, 
  LOWER(
    HEX(domain.snippet_set_id)
  ) snippetSetId, 
  LOWER(
    HEX(domain.currency_id)
  ) currencyId, 
  LOWER(
    HEX(domain.language_id)
  ) languageId, 
  LOWER(
    HEX(theme.id)
  ) themeId, 
  sales_channel.maintenance maintenance, 
  sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, 
  snippet_set.iso as locale, 
  theme.technical_name as themeName, 
  parentTheme.technical_name as parentThemeName 
FROM 
  sales_channel 
  INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id 
  LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id 
  INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id 
  LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id 
  LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id 
WHERE 
  (
    sales_channel.type_id = UNHEX(: typeId)
  ) 
  AND (sales_channel.active)

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX('8a243080f92e4c719546314b577cf82b')) AND (sales_channel.active);

# 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 = 0x2395B36C8750417C8003FAFEC3C8DAD2 OR sales_channel_id IS NULL)) AND (seo_path_info = 'account/login') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  path_info pathInfo, 
  seo_path_info seoPathInfo 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    sales_channel_id = : sales_channel_id
  ) 
  AND (id != : id) 
  AND (path_info = : pathInfo) 
  AND (is_canonical = 1) 
LIMIT 
  1

SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x2395B36C8750417C8003FAFEC3C8DAD2) AND (id != '') AND (path_info = '/account/login') AND (is_canonical = 1) LIMIT 1;

SELECT 
  configuration_key, 
  configuration_value 
FROM 
  system_config 
WHERE 
  sales_channel_id IS NULL 
ORDER BY 
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC;

SELECT 
  configuration_key, 
  configuration_value 
FROM 
  system_config 
WHERE 
  (
    sales_channel_id IS NULL 
    OR sales_channel_id = : salesChannelId
  ) 
  AND (configuration_key LIKE : prefix) 
ORDER BY 
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY sales_channel_id ASC;

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 = 0x2395B36C8750417C8003FAFEC3C8DAD2) AND (token = '3J0cNFDGFr0RVgYIhcKGV3Jb6cLcCoEU') LIMIT 1;

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

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

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

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = '3J0cNFDGFr0RVgYIhcKGV3Jb6cLcCoEU';

# 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_db64b82c28db43a583a76c353dc86f13 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_5cad5311fc99468f90979a439aa85064 
      AND (
        (
          `promotion`.`valid_from` <=> : param_6c656954157a42a19e98c24ef7fa2bb8 
          AND `promotion`.`valid_until` <=> : param_fc4d7fd8326d4465a61cbe8c45affa3f
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_41b1bfae5ccb4f908b469f12c02195d0 
          AND (
            `promotion`.`valid_until` > : param_d53834bcc887465bb5f7089063925146
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_1f99d47fe01b4af98cc87ee9148f3fc3
          ) 
          AND `promotion`.`valid_until` <=> : param_b4fa03cf678f49648d2192b8cead1d6c
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_6f93462f7e244c6bb65b8516756df7dc
          ) 
          AND (
            `promotion`.`valid_until` > : param_566828d46b734f37bd884146ab388d75
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_fe3cbdc9446c4c949be7210f6b4ad927
    )
  ) 
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` = 0x2395B36C8750417C8003FAFEC3C8DAD2 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2026-08-10 10:26:09')) OR ((`promotion`.`valid_from` <= '2026-08-10 10:26:09') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2026-08-10 10:26:09') AND (`promotion`.`valid_until` > '2026-08-10 10:26:09'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

SELECT 
  `payment_method`.`id` 
FROM 
  `payment_method` 
WHERE 
  (
    `payment_method`.`handler_identifier` = : param_b096068f3b244440a64e15f87de301ee
  )

SELECT `payment_method`.`id` FROM `payment_method` WHERE (`payment_method`.`handler_identifier` = 'Kiener\\MolliePayments\\Handler\\Method\\VoucherPayment');

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

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

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

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

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

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_ee15fb036d7c49b18aa6d5c014f9822d
    )
  )

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