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_1649858046_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651118773_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657173907_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658786605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659256999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257296_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257396_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664512574_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665064823_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667731399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667806582_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667983492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1668677456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669316067_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672164687_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672743034_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673001912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673966228_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675218708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675827655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765935_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765936_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765937_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765938_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538046469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538985581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1544535797_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1563456847_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564041870_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564053392_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587476616_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589448383_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593494859_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593508853_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615794849_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574344300_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588258673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589948636_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618237906_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635163959_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639122022_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648194406_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660282524_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1671547783_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673874594_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_1744008015_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571402521_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572513780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604584546_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630669686_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639399366_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652180224_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653941543_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659081754_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572516630_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608027541_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614589470_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621937029_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643985460_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654223780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659962090_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666007247_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675941088_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678198528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1679899712_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_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1588258673_IS_ACTIVE = TRUE;SET @MIGRATION_1589948636_IS_ACTIVE = TRUE;SET @MIGRATION_1618237906_IS_ACTIVE = TRUE;SET @MIGRATION_1635163959_IS_ACTIVE = TRUE;SET @MIGRATION_1639122022_IS_ACTIVE = TRUE;SET @MIGRATION_1648194406_IS_ACTIVE = TRUE;SET @MIGRATION_1660282524_IS_ACTIVE = TRUE;SET @MIGRATION_1671547783_IS_ACTIVE = TRUE;SET @MIGRATION_1673874594_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_1744008015_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1571402521_IS_ACTIVE = TRUE;SET @MIGRATION_1572513780_IS_ACTIVE = TRUE;SET @MIGRATION_1604584546_IS_ACTIVE = TRUE;SET @MIGRATION_1630669686_IS_ACTIVE = TRUE;SET @MIGRATION_1639399366_IS_ACTIVE = TRUE;SET @MIGRATION_1652180224_IS_ACTIVE = TRUE;SET @MIGRATION_1653941543_IS_ACTIVE = TRUE;SET @MIGRATION_1659081754_IS_ACTIVE = TRUE;SET @MIGRATION_1572516630_IS_ACTIVE = TRUE;SET @MIGRATION_1608027541_IS_ACTIVE = TRUE;SET @MIGRATION_1614589470_IS_ACTIVE = TRUE;SET @MIGRATION_1621937029_IS_ACTIVE = TRUE;SET @MIGRATION_1643985460_IS_ACTIVE = TRUE;SET @MIGRATION_1654223780_IS_ACTIVE = TRUE;SET @MIGRATION_1659962090_IS_ACTIVE = TRUE;SET @MIGRATION_1666007247_IS_ACTIVE = TRUE;SET @MIGRATION_1675941088_IS_ACTIVE = TRUE;SET @MIGRATION_1678198528_IS_ACTIVE = TRUE;SET @MIGRATION_1679899712_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 = 0xC7B7F9F6CC1D4E0B8705FD682434397E) AND (token = 'Cuo6QR7ZDPmPMHV6Ys5jtX2H5whX4MQj') LIMIT 1;

SELECT 
  `sales_channel_domain`.`id` as `sales_channel_domain.id`, 
  `sales_channel_domain`.`url` as `sales_channel_domain.url`, 
  `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, 
  `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, 
  `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, 
  `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, 
  `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, 
  `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, 
  `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, 
  `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, 
  `sales_channel_domain.salesChannel`.`id` as `sales_channel_domain.salesChannel.id`, 
  `sales_channel_domain.salesChannel`.`type_id` as `sales_channel_domain.salesChannel.typeId`, 
  `sales_channel_domain.salesChannel`.`language_id` as `sales_channel_domain.salesChannel.languageId`, 
  `sales_channel_domain.salesChannel`.`customer_group_id` as `sales_channel_domain.salesChannel.customerGroupId`, 
  `sales_channel_domain.salesChannel`.`currency_id` as `sales_channel_domain.salesChannel.currencyId`, 
  `sales_channel_domain.salesChannel`.`payment_method_id` as `sales_channel_domain.salesChannel.paymentMethodId`, 
  `sales_channel_domain.salesChannel`.`shipping_method_id` as `sales_channel_domain.salesChannel.shippingMethodId`, 
  `sales_channel_domain.salesChannel`.`country_id` as `sales_channel_domain.salesChannel.countryId`, 
  `sales_channel_domain.salesChannel`.`analytics_id` as `sales_channel_domain.salesChannel.analyticsId`, 
  `sales_channel_domain.salesChannel`.`navigation_category_id` as `sales_channel_domain.salesChannel.navigationCategoryId`, 
  `sales_channel_domain.salesChannel`.`navigation_category_version_id` as `sales_channel_domain.salesChannel.navigationCategoryVersionId`, 
  `sales_channel_domain.salesChannel`.`navigation_category_depth` as `sales_channel_domain.salesChannel.navigationCategoryDepth`, 
  `sales_channel_domain.salesChannel`.`footer_category_id` as `sales_channel_domain.salesChannel.footerCategoryId`, 
  `sales_channel_domain.salesChannel`.`footer_category_version_id` as `sales_channel_domain.salesChannel.footerCategoryVersionId`, 
  `sales_channel_domain.salesChannel`.`service_category_id` as `sales_channel_domain.salesChannel.serviceCategoryId`, 
  `sales_channel_domain.salesChannel`.`service_category_version_id` as `sales_channel_domain.salesChannel.serviceCategoryVersionId`, 
  `sales_channel_domain.salesChannel`.`mail_header_footer_id` as `sales_channel_domain.salesChannel.mailHeaderFooterId`, 
  `sales_channel_domain.salesChannel`.`hreflang_default_domain_id` as `sales_channel_domain.salesChannel.hreflangDefaultDomainId`, 
  `sales_channel_domain.salesChannel`.`short_name` as `sales_channel_domain.salesChannel.shortName`, 
  `sales_channel_domain.salesChannel`.`tax_calculation_type` as `sales_channel_domain.salesChannel.taxCalculationType`, 
  `sales_channel_domain.salesChannel`.`access_key` as `sales_channel_domain.salesChannel.accessKey`, 
  `sales_channel_domain.salesChannel`.`configuration` as `sales_channel_domain.salesChannel.configuration`, 
  `sales_channel_domain.salesChannel`.`active` as `sales_channel_domain.salesChannel.active`, 
  `sales_channel_domain.salesChannel`.`hreflang_active` as `sales_channel_domain.salesChannel.hreflangActive`, 
  `sales_channel_domain.salesChannel`.`maintenance` as `sales_channel_domain.salesChannel.maintenance`, 
  `sales_channel_domain.salesChannel`.`maintenance_ip_whitelist` as `sales_channel_domain.salesChannel.maintenanceIpWhitelist`, 
  `sales_channel_domain.salesChannel`.`payment_method_ids` as `sales_channel_domain.salesChannel.paymentMethodIds`, 
  `sales_channel_domain.salesChannel`.`home_cms_page_id` as `sales_channel_domain.salesChannel.homeCmsPageId`, 
  `sales_channel_domain.salesChannel`.`home_cms_page_version_id` as `sales_channel_domain.salesChannel.homeCmsPageVersionId`, 
  `sales_channel_domain.salesChannel.analytics`.`id` as `sales_channel_domain.salesChannel.analytics.id`, 
  `sales_channel_domain.salesChannel.analytics`.`tracking_id` as `sales_channel_domain.salesChannel.analytics.trackingId`, 
  `sales_channel_domain.salesChannel.analytics`.`active` as `sales_channel_domain.salesChannel.analytics.active`, 
  `sales_channel_domain.salesChannel.analytics`.`track_orders` as `sales_channel_domain.salesChannel.analytics.trackOrders`, 
  `sales_channel_domain.salesChannel.analytics`.`anonymize_ip` as `sales_channel_domain.salesChannel.analytics.anonymizeIp`, 
  `sales_channel_domain.salesChannel.analytics`.`created_at` as `sales_channel_domain.salesChannel.analytics.createdAt`, 
  `sales_channel_domain.salesChannel.analytics`.`updated_at` as `sales_channel_domain.salesChannel.analytics.updatedAt`, 
  `sales_channel_domain.salesChannel`.`created_at` as `sales_channel_domain.salesChannel.createdAt`, 
  `sales_channel_domain.salesChannel`.`updated_at` as `sales_channel_domain.salesChannel.updatedAt`, 
  `sales_channel_domain.salesChannel.translation.name`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.name`, 
    `sales_channel_domain.salesChannel.translation.name`
  ) as `sales_channel_domain.salesChannel.name`, 
  `sales_channel_domain.salesChannel.translation.homeSlotConfig`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeSlotConfig`, 
    `sales_channel_domain.salesChannel.translation.homeSlotConfig`
  ) as `sales_channel_domain.salesChannel.homeSlotConfig`, 
  `sales_channel_domain.salesChannel.translation.homeEnabled`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeEnabled`, 
    `sales_channel_domain.salesChannel.translation.homeEnabled`
  ) as `sales_channel_domain.salesChannel.homeEnabled`, 
  `sales_channel_domain.salesChannel.translation.homeName`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeName`, 
    `sales_channel_domain.salesChannel.translation.homeName`
  ) as `sales_channel_domain.salesChannel.homeName`, 
  `sales_channel_domain.salesChannel.translation.homeMetaTitle`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeMetaTitle`, 
    `sales_channel_domain.salesChannel.translation.homeMetaTitle`
  ) as `sales_channel_domain.salesChannel.homeMetaTitle`, 
  `sales_channel_domain.salesChannel.translation.homeMetaDescription`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeMetaDescription`, 
    `sales_channel_domain.salesChannel.translation.homeMetaDescription`
  ) as `sales_channel_domain.salesChannel.homeMetaDescription`, 
  `sales_channel_domain.salesChannel.translation.homeKeywords`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.homeKeywords`, 
    `sales_channel_domain.salesChannel.translation.homeKeywords`
  ) as `sales_channel_domain.salesChannel.homeKeywords`, 
  `sales_channel_domain.salesChannel.translation.customFields`, 
  COALESCE(
    `sales_channel_domain.salesChannel.translation.customFields`, 
    `sales_channel_domain.salesChannel.translation.customFields`
  ) as `sales_channel_domain.salesChannel.customFields`, 
  `sales_channel_domain.salesChannel.translation.createdAt`, 
  `sales_channel_domain.salesChannel.translation.updatedAt`, 
  `sales_channel_domain.salesChannel.translation.salesChannelId`, 
  `sales_channel_domain.salesChannel.translation.languageId` 
FROM 
  `sales_channel_domain` 
  LEFT JOIN `sales_channel` `sales_channel_domain.salesChannel` ON `sales_channel_domain`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` 
  LEFT JOIN (
    SELECT 
      `sales_channel_domain.salesChannel.translation`.sales_channel_id, 
      `sales_channel_domain.salesChannel.translation`.name as `sales_channel_domain.salesChannel.translation.name`, 
      `sales_channel_domain.salesChannel.translation`.home_slot_config as `sales_channel_domain.salesChannel.translation.homeSlotConfig`, 
      `sales_channel_domain.salesChannel.translation`.home_enabled as `sales_channel_domain.salesChannel.translation.homeEnabled`, 
      `sales_channel_domain.salesChannel.translation`.home_name as `sales_channel_domain.salesChannel.translation.homeName`, 
      `sales_channel_domain.salesChannel.translation`.home_meta_title as `sales_channel_domain.salesChannel.translation.homeMetaTitle`, 
      `sales_channel_domain.salesChannel.translation`.home_meta_description as `sales_channel_domain.salesChannel.translation.homeMetaDescription`, 
      `sales_channel_domain.salesChannel.translation`.home_keywords as `sales_channel_domain.salesChannel.translation.homeKeywords`, 
      `sales_channel_domain.salesChannel.translation`.custom_fields as `sales_channel_domain.salesChannel.translation.customFields`, 
      `sales_channel_domain.salesChannel.translation`.created_at as `sales_channel_domain.salesChannel.translation.createdAt`, 
      `sales_channel_domain.salesChannel.translation`.updated_at as `sales_channel_domain.salesChannel.translation.updatedAt`, 
      `sales_channel_domain.salesChannel.translation`.sales_channel_id as `sales_channel_domain.salesChannel.translation.salesChannelId`, 
      `sales_channel_domain.salesChannel.translation`.language_id as `sales_channel_domain.salesChannel.translation.languageId` 
    FROM 
      `sales_channel_translation` `sales_channel_domain.salesChannel.translation` 
    WHERE 
      `sales_channel_domain.salesChannel.translation`.language_id = : languageId
  ) `sales_channel_domain.salesChannel.sales_channel_translation` ON `sales_channel_domain.salesChannel.sales_channel_translation`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` 
  LEFT JOIN `sales_channel_analytics` `sales_channel_domain.salesChannel.analytics` ON `sales_channel_domain.salesChannel`.`analytics_id` = `sales_channel_domain.salesChannel.analytics`.`id` 
WHERE 
  `sales_channel_domain`.`id` IN (: ids)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.salesChannel`.`id` as `sales_channel_domain.salesChannel.id`, `sales_channel_domain.salesChannel`.`type_id` as `sales_channel_domain.salesChannel.typeId`, `sales_channel_domain.salesChannel`.`language_id` as `sales_channel_domain.salesChannel.languageId`, `sales_channel_domain.salesChannel`.`customer_group_id` as `sales_channel_domain.salesChannel.customerGroupId`, `sales_channel_domain.salesChannel`.`currency_id` as `sales_channel_domain.salesChannel.currencyId`, `sales_channel_domain.salesChannel`.`payment_method_id` as `sales_channel_domain.salesChannel.paymentMethodId`, `sales_channel_domain.salesChannel`.`shipping_method_id` as `sales_channel_domain.salesChannel.shippingMethodId`, `sales_channel_domain.salesChannel`.`country_id` as `sales_channel_domain.salesChannel.countryId`, `sales_channel_domain.salesChannel`.`analytics_id` as `sales_channel_domain.salesChannel.analyticsId`, `sales_channel_domain.salesChannel`.`navigation_category_id` as `sales_channel_domain.salesChannel.navigationCategoryId`, `sales_channel_domain.salesChannel`.`navigation_category_version_id` as `sales_channel_domain.salesChannel.navigationCategoryVersionId`, `sales_channel_domain.salesChannel`.`navigation_category_depth` as `sales_channel_domain.salesChannel.navigationCategoryDepth`, `sales_channel_domain.salesChannel`.`footer_category_id` as `sales_channel_domain.salesChannel.footerCategoryId`, `sales_channel_domain.salesChannel`.`footer_category_version_id` as `sales_channel_domain.salesChannel.footerCategoryVersionId`, `sales_channel_domain.salesChannel`.`service_category_id` as `sales_channel_domain.salesChannel.serviceCategoryId`, `sales_channel_domain.salesChannel`.`service_category_version_id` as `sales_channel_domain.salesChannel.serviceCategoryVersionId`, `sales_channel_domain.salesChannel`.`mail_header_footer_id` as `sales_channel_domain.salesChannel.mailHeaderFooterId`, `sales_channel_domain.salesChannel`.`hreflang_default_domain_id` as `sales_channel_domain.salesChannel.hreflangDefaultDomainId`, `sales_channel_domain.salesChannel`.`short_name` as `sales_channel_domain.salesChannel.shortName`, `sales_channel_domain.salesChannel`.`tax_calculation_type` as `sales_channel_domain.salesChannel.taxCalculationType`, `sales_channel_domain.salesChannel`.`access_key` as `sales_channel_domain.salesChannel.accessKey`, `sales_channel_domain.salesChannel`.`configuration` as `sales_channel_domain.salesChannel.configuration`, `sales_channel_domain.salesChannel`.`active` as `sales_channel_domain.salesChannel.active`, `sales_channel_domain.salesChannel`.`hreflang_active` as `sales_channel_domain.salesChannel.hreflangActive`, `sales_channel_domain.salesChannel`.`maintenance` as `sales_channel_domain.salesChannel.maintenance`, `sales_channel_domain.salesChannel`.`maintenance_ip_whitelist` as `sales_channel_domain.salesChannel.maintenanceIpWhitelist`, `sales_channel_domain.salesChannel`.`payment_method_ids` as `sales_channel_domain.salesChannel.paymentMethodIds`, `sales_channel_domain.salesChannel`.`home_cms_page_id` as `sales_channel_domain.salesChannel.homeCmsPageId`, `sales_channel_domain.salesChannel`.`home_cms_page_version_id` as `sales_channel_domain.salesChannel.homeCmsPageVersionId`, `sales_channel_domain.salesChannel.analytics`.`id` as `sales_channel_domain.salesChannel.analytics.id`, `sales_channel_domain.salesChannel.analytics`.`tracking_id` as `sales_channel_domain.salesChannel.analytics.trackingId`, `sales_channel_domain.salesChannel.analytics`.`active` as `sales_channel_domain.salesChannel.analytics.active`, `sales_channel_domain.salesChannel.analytics`.`track_orders` as `sales_channel_domain.salesChannel.analytics.trackOrders`, `sales_channel_domain.salesChannel.analytics`.`anonymize_ip` as `sales_channel_domain.salesChannel.analytics.anonymizeIp`, `sales_channel_domain.salesChannel.analytics`.`created_at` as `sales_channel_domain.salesChannel.analytics.createdAt`, `sales_channel_domain.salesChannel.analytics`.`updated_at` as `sales_channel_domain.salesChannel.analytics.updatedAt`, `sales_channel_domain.salesChannel`.`created_at` as `sales_channel_domain.salesChannel.createdAt`, `sales_channel_domain.salesChannel`.`updated_at` as `sales_channel_domain.salesChannel.updatedAt`, `sales_channel_domain.salesChannel.translation.name`, COALESCE(`sales_channel_domain.salesChannel.translation.name`,`sales_channel_domain.salesChannel.translation.name`) as `sales_channel_domain.salesChannel.name`, `sales_channel_domain.salesChannel.translation.homeSlotConfig`, COALESCE(`sales_channel_domain.salesChannel.translation.homeSlotConfig`,`sales_channel_domain.salesChannel.translation.homeSlotConfig`) as `sales_channel_domain.salesChannel.homeSlotConfig`, `sales_channel_domain.salesChannel.translation.homeEnabled`, COALESCE(`sales_channel_domain.salesChannel.translation.homeEnabled`,`sales_channel_domain.salesChannel.translation.homeEnabled`) as `sales_channel_domain.salesChannel.homeEnabled`, `sales_channel_domain.salesChannel.translation.homeName`, COALESCE(`sales_channel_domain.salesChannel.translation.homeName`,`sales_channel_domain.salesChannel.translation.homeName`) as `sales_channel_domain.salesChannel.homeName`, `sales_channel_domain.salesChannel.translation.homeMetaTitle`, COALESCE(`sales_channel_domain.salesChannel.translation.homeMetaTitle`,`sales_channel_domain.salesChannel.translation.homeMetaTitle`) as `sales_channel_domain.salesChannel.homeMetaTitle`, `sales_channel_domain.salesChannel.translation.homeMetaDescription`, COALESCE(`sales_channel_domain.salesChannel.translation.homeMetaDescription`,`sales_channel_domain.salesChannel.translation.homeMetaDescription`) as `sales_channel_domain.salesChannel.homeMetaDescription`, `sales_channel_domain.salesChannel.translation.homeKeywords`, COALESCE(`sales_channel_domain.salesChannel.translation.homeKeywords`,`sales_channel_domain.salesChannel.translation.homeKeywords`) as `sales_channel_domain.salesChannel.homeKeywords`, `sales_channel_domain.salesChannel.translation.customFields`, COALESCE(`sales_channel_domain.salesChannel.translation.customFields`,`sales_channel_domain.salesChannel.translation.customFields`) as `sales_channel_domain.salesChannel.customFields`, `sales_channel_domain.salesChannel.translation.createdAt`, `sales_channel_domain.salesChannel.translation.updatedAt`, `sales_channel_domain.salesChannel.translation.salesChannelId`, `sales_channel_domain.salesChannel.translation.languageId` FROM `sales_channel_domain` LEFT JOIN `sales_channel` `sales_channel_domain.salesChannel` ON `sales_channel_domain`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` LEFT JOIN (SELECT `sales_channel_domain.salesChannel.translation`.sales_channel_id, `sales_channel_domain.salesChannel.translation`.name as `sales_channel_domain.salesChannel.translation.name`, `sales_channel_domain.salesChannel.translation`.home_slot_config as `sales_channel_domain.salesChannel.translation.homeSlotConfig`, `sales_channel_domain.salesChannel.translation`.home_enabled as `sales_channel_domain.salesChannel.translation.homeEnabled`, `sales_channel_domain.salesChannel.translation`.home_name as `sales_channel_domain.salesChannel.translation.homeName`, `sales_channel_domain.salesChannel.translation`.home_meta_title as `sales_channel_domain.salesChannel.translation.homeMetaTitle`, `sales_channel_domain.salesChannel.translation`.home_meta_description as `sales_channel_domain.salesChannel.translation.homeMetaDescription`, `sales_channel_domain.salesChannel.translation`.home_keywords as `sales_channel_domain.salesChannel.translation.homeKeywords`, `sales_channel_domain.salesChannel.translation`.custom_fields as `sales_channel_domain.salesChannel.translation.customFields`, `sales_channel_domain.salesChannel.translation`.created_at as `sales_channel_domain.salesChannel.translation.createdAt`, `sales_channel_domain.salesChannel.translation`.updated_at as `sales_channel_domain.salesChannel.translation.updatedAt`, `sales_channel_domain.salesChannel.translation`.sales_channel_id as `sales_channel_domain.salesChannel.translation.salesChannelId`, `sales_channel_domain.salesChannel.translation`.language_id as `sales_channel_domain.salesChannel.translation.languageId` FROM `sales_channel_translation` `sales_channel_domain.salesChannel.translation` WHERE `sales_channel_domain.salesChannel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel_domain.salesChannel.sales_channel_translation` ON `sales_channel_domain.salesChannel.sales_channel_translation`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel_domain.salesChannel.analytics` ON `sales_channel_domain.salesChannel`.`analytics_id` = `sales_channel_domain.salesChannel.analytics`.`id` WHERE `sales_channel_domain`.`id` IN (0x12B6C4CCE2A64D019EB9851C9CE25214);

SELECT 
  `sales_channel_domain`.`id` as `sales_channel_domain.id`, 
  `sales_channel_domain`.`url` as `sales_channel_domain.url`, 
  `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, 
  `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, 
  `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, 
  `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, 
  `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, 
  `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, 
  `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, 
  `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` 
FROM 
  `sales_channel_domain` 
WHERE 
  (
    `sales_channel_domain`.`sales_channel_id` IN (
      : param_f8166b6e52884a929998e33a5a03a402
    )
  )

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (0xC7B7F9F6CC1D4E0B8705FD682434397E));

SELECT 
  `acris_switch_rule`.`id` 
FROM 
  `acris_switch_rule` 
  LEFT JOIN `acris_switch_domain` `acris_switch_rule.domains` ON `acris_switch_rule`.`id` = `acris_switch_rule.domains`.`rule_id` 
WHERE 
  (
    (
      `acris_switch_rule.domains`.`domain_id` = : param_fe36739fadb84f02927e9959447a933d 
      AND `acris_switch_rule.domains`.`active` = : param_ca6b6db896764eadae38397e135cfb4b
    ) 
    AND `acris_switch_rule`.`active` = : param_3b9a32e81d72403790532edef4fe28db
  ) 
GROUP BY 
  `acris_switch_rule`.`id`

SELECT `acris_switch_rule`.`id` FROM `acris_switch_rule` LEFT JOIN `acris_switch_domain` `acris_switch_rule.domains` ON `acris_switch_rule`.`id` = `acris_switch_rule.domains`.`rule_id` WHERE ((`acris_switch_rule.domains`.`domain_id` = 0x12B6C4CCE2A64D019EB9851C9CE25214 AND `acris_switch_rule.domains`.`active` = 1) AND `acris_switch_rule`.`active` = 1) GROUP BY `acris_switch_rule`.`id`;

SELECT 
  `acris_switch_rule`.`id` as `acris_switch_rule.id`, 
  `acris_switch_rule`.`name` as `acris_switch_rule.name`, 
  `acris_switch_rule`.`active` as `acris_switch_rule.active`, 
  `acris_switch_rule`.`switch_type` as `acris_switch_rule.switchType`, 
  `acris_switch_rule`.`rule_definition_type` as `acris_switch_rule.ruleDefinitionType`, 
  `acris_switch_rule`.`header_country_select` as `acris_switch_rule.headerCountrySelect`, 
  `acris_switch_rule`.`modal_close_type` as `acris_switch_rule.modalCloseType`, 
  `acris_switch_rule`.`routing_type` as `acris_switch_rule.routingType`, 
  `acris_switch_rule`.`ask_if_match` as `acris_switch_rule.askIfMatch`, 
  `acris_switch_rule`.`debug_mode` as `acris_switch_rule.debugMode`, 
  `acris_switch_rule`.`reload_page` as `acris_switch_rule.reloadPage`, 
  `acris_switch_rule`.`product_routing_type` as `acris_switch_rule.productRoutingType`, 
  `acris_switch_rule`.`created_at` as `acris_switch_rule.createdAt`, 
  `acris_switch_rule`.`updated_at` as `acris_switch_rule.updatedAt`, 
  `acris_switch_rule.translation.textTop`, 
  COALESCE(
    `acris_switch_rule.translation.textTop`, 
    `acris_switch_rule.translation.textTop`
  ) as `acris_switch_rule.textTop`, 
  `acris_switch_rule.translation.textMiddle`, 
  COALESCE(
    `acris_switch_rule.translation.textMiddle`, 
    `acris_switch_rule.translation.textMiddle`
  ) as `acris_switch_rule.textMiddle`, 
  `acris_switch_rule.translation.textBottom`, 
  COALESCE(
    `acris_switch_rule.translation.textBottom`, 
    `acris_switch_rule.translation.textBottom`
  ) as `acris_switch_rule.textBottom`, 
  `acris_switch_rule.translation.textButton`, 
  COALESCE(
    `acris_switch_rule.translation.textButton`, 
    `acris_switch_rule.translation.textButton`
  ) as `acris_switch_rule.textButton`, 
  `acris_switch_rule.translation.labelCountry`, 
  COALESCE(
    `acris_switch_rule.translation.labelCountry`, 
    `acris_switch_rule.translation.labelCountry`
  ) as `acris_switch_rule.labelCountry`, 
  `acris_switch_rule.translation.labelLanguage`, 
  COALESCE(
    `acris_switch_rule.translation.labelLanguage`, 
    `acris_switch_rule.translation.labelLanguage`
  ) as `acris_switch_rule.labelLanguage`, 
  `acris_switch_rule.translation.createdAt`, 
  `acris_switch_rule.translation.updatedAt`, 
  `acris_switch_rule.translation.acrisSwitchRuleId`, 
  `acris_switch_rule.translation.languageId` 
FROM 
  `acris_switch_rule` 
  LEFT JOIN (
    SELECT 
      `acris_switch_rule.translation`.acris_switch_rule_id, 
      `acris_switch_rule.translation`.text_top as `acris_switch_rule.translation.textTop`, 
      `acris_switch_rule.translation`.text_middle as `acris_switch_rule.translation.textMiddle`, 
      `acris_switch_rule.translation`.text_bottom as `acris_switch_rule.translation.textBottom`, 
      `acris_switch_rule.translation`.text_button as `acris_switch_rule.translation.textButton`, 
      `acris_switch_rule.translation`.label_country as `acris_switch_rule.translation.labelCountry`, 
      `acris_switch_rule.translation`.label_language as `acris_switch_rule.translation.labelLanguage`, 
      `acris_switch_rule.translation`.created_at as `acris_switch_rule.translation.createdAt`, 
      `acris_switch_rule.translation`.updated_at as `acris_switch_rule.translation.updatedAt`, 
      `acris_switch_rule.translation`.acris_switch_rule_id as `acris_switch_rule.translation.acrisSwitchRuleId`, 
      `acris_switch_rule.translation`.language_id as `acris_switch_rule.translation.languageId` 
    FROM 
      `acris_switch_rule_translation` `acris_switch_rule.translation` 
    WHERE 
      `acris_switch_rule.translation`.language_id = : languageId
  ) `acris_switch_rule.acris_switch_rule_translation` ON `acris_switch_rule.acris_switch_rule_translation`.`acris_switch_rule_id` = `acris_switch_rule`.`id` 
WHERE 
  `acris_switch_rule`.`id` IN (: ids)

SELECT `acris_switch_rule`.`id` as `acris_switch_rule.id`, `acris_switch_rule`.`name` as `acris_switch_rule.name`, `acris_switch_rule`.`active` as `acris_switch_rule.active`, `acris_switch_rule`.`switch_type` as `acris_switch_rule.switchType`, `acris_switch_rule`.`rule_definition_type` as `acris_switch_rule.ruleDefinitionType`, `acris_switch_rule`.`header_country_select` as `acris_switch_rule.headerCountrySelect`, `acris_switch_rule`.`modal_close_type` as `acris_switch_rule.modalCloseType`, `acris_switch_rule`.`routing_type` as `acris_switch_rule.routingType`, `acris_switch_rule`.`ask_if_match` as `acris_switch_rule.askIfMatch`, `acris_switch_rule`.`debug_mode` as `acris_switch_rule.debugMode`, `acris_switch_rule`.`reload_page` as `acris_switch_rule.reloadPage`, `acris_switch_rule`.`product_routing_type` as `acris_switch_rule.productRoutingType`, `acris_switch_rule`.`created_at` as `acris_switch_rule.createdAt`, `acris_switch_rule`.`updated_at` as `acris_switch_rule.updatedAt`, `acris_switch_rule.translation.textTop`, COALESCE(`acris_switch_rule.translation.textTop`,`acris_switch_rule.translation.textTop`) as `acris_switch_rule.textTop`, `acris_switch_rule.translation.textMiddle`, COALESCE(`acris_switch_rule.translation.textMiddle`,`acris_switch_rule.translation.textMiddle`) as `acris_switch_rule.textMiddle`, `acris_switch_rule.translation.textBottom`, COALESCE(`acris_switch_rule.translation.textBottom`,`acris_switch_rule.translation.textBottom`) as `acris_switch_rule.textBottom`, `acris_switch_rule.translation.textButton`, COALESCE(`acris_switch_rule.translation.textButton`,`acris_switch_rule.translation.textButton`) as `acris_switch_rule.textButton`, `acris_switch_rule.translation.labelCountry`, COALESCE(`acris_switch_rule.translation.labelCountry`,`acris_switch_rule.translation.labelCountry`) as `acris_switch_rule.labelCountry`, `acris_switch_rule.translation.labelLanguage`, COALESCE(`acris_switch_rule.translation.labelLanguage`,`acris_switch_rule.translation.labelLanguage`) as `acris_switch_rule.labelLanguage`, `acris_switch_rule.translation.createdAt`, `acris_switch_rule.translation.updatedAt`, `acris_switch_rule.translation.acrisSwitchRuleId`, `acris_switch_rule.translation.languageId` FROM `acris_switch_rule` LEFT JOIN (SELECT `acris_switch_rule.translation`.acris_switch_rule_id, `acris_switch_rule.translation`.text_top as `acris_switch_rule.translation.textTop`, `acris_switch_rule.translation`.text_middle as `acris_switch_rule.translation.textMiddle`, `acris_switch_rule.translation`.text_bottom as `acris_switch_rule.translation.textBottom`, `acris_switch_rule.translation`.text_button as `acris_switch_rule.translation.textButton`, `acris_switch_rule.translation`.label_country as `acris_switch_rule.translation.labelCountry`, `acris_switch_rule.translation`.label_language as `acris_switch_rule.translation.labelLanguage`, `acris_switch_rule.translation`.created_at as `acris_switch_rule.translation.createdAt`, `acris_switch_rule.translation`.updated_at as `acris_switch_rule.translation.updatedAt`, `acris_switch_rule.translation`.acris_switch_rule_id as `acris_switch_rule.translation.acrisSwitchRuleId`, `acris_switch_rule.translation`.language_id as `acris_switch_rule.translation.languageId` FROM `acris_switch_rule_translation` `acris_switch_rule.translation` WHERE `acris_switch_rule.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `acris_switch_rule.acris_switch_rule_translation` ON `acris_switch_rule.acris_switch_rule_translation`.`acris_switch_rule_id` = `acris_switch_rule`.`id` WHERE `acris_switch_rule`.`id` IN (0x96BB70E8BB6D4205B8DC639855784779);

SELECT 
  `acris_switch_domain`.`id` as `acris_switch_domain.id`, 
  `acris_switch_domain`.`active` as `acris_switch_domain.active`, 
  `acris_switch_domain`.`redirect_to` as `acris_switch_domain.redirectTo`, 
  `acris_switch_domain`.`external_url` as `acris_switch_domain.externalUrl`, 
  `acris_switch_domain`.`rule_id` as `acris_switch_domain.ruleId`, 
  `acris_switch_domain`.`domain_id` as `acris_switch_domain.domainId`, 
  `acris_switch_domain`.`default_shipping_country_id` as `acris_switch_domain.defaultShippingCountryId`, 
  `acris_switch_domain`.`created_at` as `acris_switch_domain.createdAt`, 
  `acris_switch_domain`.`updated_at` as `acris_switch_domain.updatedAt`, 
  `acris_switch_domain.domain`.`id` as `acris_switch_domain.domain.id`, 
  `acris_switch_domain.domain`.`url` as `acris_switch_domain.domain.url`, 
  `acris_switch_domain.domain`.`sales_channel_id` as `acris_switch_domain.domain.salesChannelId`, 
  `acris_switch_domain.domain`.`language_id` as `acris_switch_domain.domain.languageId`, 
  `acris_switch_domain.domain`.`currency_id` as `acris_switch_domain.domain.currencyId`, 
  `acris_switch_domain.domain`.`snippet_set_id` as `acris_switch_domain.domain.snippetSetId`, 
  `acris_switch_domain.domain`.`hreflang_use_only_locale` as `acris_switch_domain.domain.hreflangUseOnlyLocale`, 
  `acris_switch_domain.domain`.`custom_fields` as `acris_switch_domain.domain.customFields`, 
  `acris_switch_domain.domain`.`created_at` as `acris_switch_domain.domain.createdAt`, 
  `acris_switch_domain.domain`.`updated_at` as `acris_switch_domain.domain.updatedAt`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `acris_switch_domain.countryWhitelist.mapping`.`country_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `acris_switch_domain_country_whitelist` `acris_switch_domain.countryWhitelist.mapping` 
    WHERE 
      `acris_switch_domain.countryWhitelist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id`
  ) as `acris_switch_domain.countryWhitelist.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `acris_switch_domain.countryBlacklist.mapping`.`country_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `acris_switch_domain_country_blacklist` `acris_switch_domain.countryBlacklist.mapping` 
    WHERE 
      `acris_switch_domain.countryBlacklist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id`
  ) as `acris_switch_domain.countryBlacklist.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `acris_switch_domain.languageWhitelist.mapping`.`language_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `acris_switch_domain_language_whitelist` `acris_switch_domain.languageWhitelist.mapping` 
    WHERE 
      `acris_switch_domain.languageWhitelist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id`
  ) as `acris_switch_domain.languageWhitelist.id_mapping`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `acris_switch_domain.languageBlacklist.mapping`.`language_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `acris_switch_domain_language_blacklist` `acris_switch_domain.languageBlacklist.mapping` 
    WHERE 
      `acris_switch_domain.languageBlacklist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id`
  ) as `acris_switch_domain.languageBlacklist.id_mapping`, 
  `acris_switch_domain.translation.name`, 
  COALESCE(
    `acris_switch_domain.translation.name`, 
    `acris_switch_domain.translation.name`
  ) as `acris_switch_domain.name`, 
  `acris_switch_domain.translation.createdAt`, 
  `acris_switch_domain.translation.updatedAt`, 
  `acris_switch_domain.translation.acrisSwitchDomainId`, 
  `acris_switch_domain.translation.languageId` 
FROM 
  `acris_switch_domain` 
  LEFT JOIN (
    SELECT 
      `acris_switch_domain.translation`.acris_switch_domain_id, 
      `acris_switch_domain.translation`.name as `acris_switch_domain.translation.name`, 
      `acris_switch_domain.translation`.created_at as `acris_switch_domain.translation.createdAt`, 
      `acris_switch_domain.translation`.updated_at as `acris_switch_domain.translation.updatedAt`, 
      `acris_switch_domain.translation`.acris_switch_domain_id as `acris_switch_domain.translation.acrisSwitchDomainId`, 
      `acris_switch_domain.translation`.language_id as `acris_switch_domain.translation.languageId` 
    FROM 
      `acris_switch_domain_translation` `acris_switch_domain.translation` 
    WHERE 
      `acris_switch_domain.translation`.language_id = : languageId
  ) `acris_switch_domain.acris_switch_domain_translation` ON `acris_switch_domain.acris_switch_domain_translation`.`acris_switch_domain_id` = `acris_switch_domain`.`id` 
  LEFT JOIN `sales_channel_domain` `acris_switch_domain.domain` ON `acris_switch_domain`.`domain_id` = `acris_switch_domain.domain`.`id` 
WHERE 
  (
    `acris_switch_domain`.`rule_id` IN (
      : param_c48d74d5e86a4a5e8f264bf4497502d2
    )
  )

SELECT `acris_switch_domain`.`id` as `acris_switch_domain.id`, `acris_switch_domain`.`active` as `acris_switch_domain.active`, `acris_switch_domain`.`redirect_to` as `acris_switch_domain.redirectTo`, `acris_switch_domain`.`external_url` as `acris_switch_domain.externalUrl`, `acris_switch_domain`.`rule_id` as `acris_switch_domain.ruleId`, `acris_switch_domain`.`domain_id` as `acris_switch_domain.domainId`, `acris_switch_domain`.`default_shipping_country_id` as `acris_switch_domain.defaultShippingCountryId`, `acris_switch_domain`.`created_at` as `acris_switch_domain.createdAt`, `acris_switch_domain`.`updated_at` as `acris_switch_domain.updatedAt`, `acris_switch_domain.domain`.`id` as `acris_switch_domain.domain.id`, `acris_switch_domain.domain`.`url` as `acris_switch_domain.domain.url`, `acris_switch_domain.domain`.`sales_channel_id` as `acris_switch_domain.domain.salesChannelId`, `acris_switch_domain.domain`.`language_id` as `acris_switch_domain.domain.languageId`, `acris_switch_domain.domain`.`currency_id` as `acris_switch_domain.domain.currencyId`, `acris_switch_domain.domain`.`snippet_set_id` as `acris_switch_domain.domain.snippetSetId`, `acris_switch_domain.domain`.`hreflang_use_only_locale` as `acris_switch_domain.domain.hreflangUseOnlyLocale`, `acris_switch_domain.domain`.`custom_fields` as `acris_switch_domain.domain.customFields`, `acris_switch_domain.domain`.`created_at` as `acris_switch_domain.domain.createdAt`, `acris_switch_domain.domain`.`updated_at` as `acris_switch_domain.domain.updatedAt`, (SELECT GROUP_CONCAT(HEX(`acris_switch_domain.countryWhitelist.mapping`.`country_id`) SEPARATOR '||')
                  FROM `acris_switch_domain_country_whitelist` `acris_switch_domain.countryWhitelist.mapping`
                  WHERE `acris_switch_domain.countryWhitelist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id` ) as `acris_switch_domain.countryWhitelist.id_mapping`, (SELECT GROUP_CONCAT(HEX(`acris_switch_domain.countryBlacklist.mapping`.`country_id`) SEPARATOR '||')
                  FROM `acris_switch_domain_country_blacklist` `acris_switch_domain.countryBlacklist.mapping`
                  WHERE `acris_switch_domain.countryBlacklist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id` ) as `acris_switch_domain.countryBlacklist.id_mapping`, (SELECT GROUP_CONCAT(HEX(`acris_switch_domain.languageWhitelist.mapping`.`language_id`) SEPARATOR '||')
                  FROM `acris_switch_domain_language_whitelist` `acris_switch_domain.languageWhitelist.mapping`
                  WHERE `acris_switch_domain.languageWhitelist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id` ) as `acris_switch_domain.languageWhitelist.id_mapping`, (SELECT GROUP_CONCAT(HEX(`acris_switch_domain.languageBlacklist.mapping`.`language_id`) SEPARATOR '||')
                  FROM `acris_switch_domain_language_blacklist` `acris_switch_domain.languageBlacklist.mapping`
                  WHERE `acris_switch_domain.languageBlacklist.mapping`.`rule_domain_id` = `acris_switch_domain`.`id` ) as `acris_switch_domain.languageBlacklist.id_mapping`, `acris_switch_domain.translation.name`, COALESCE(`acris_switch_domain.translation.name`,`acris_switch_domain.translation.name`) as `acris_switch_domain.name`, `acris_switch_domain.translation.createdAt`, `acris_switch_domain.translation.updatedAt`, `acris_switch_domain.translation.acrisSwitchDomainId`, `acris_switch_domain.translation.languageId` FROM `acris_switch_domain` LEFT JOIN (SELECT `acris_switch_domain.translation`.acris_switch_domain_id, `acris_switch_domain.translation`.name as `acris_switch_domain.translation.name`, `acris_switch_domain.translation`.created_at as `acris_switch_domain.translation.createdAt`, `acris_switch_domain.translation`.updated_at as `acris_switch_domain.translation.updatedAt`, `acris_switch_domain.translation`.acris_switch_domain_id as `acris_switch_domain.translation.acrisSwitchDomainId`, `acris_switch_domain.translation`.language_id as `acris_switch_domain.translation.languageId` FROM `acris_switch_domain_translation` `acris_switch_domain.translation` WHERE `acris_switch_domain.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `acris_switch_domain.acris_switch_domain_translation` ON `acris_switch_domain.acris_switch_domain_translation`.`acris_switch_domain_id` = `acris_switch_domain`.`id` LEFT JOIN `sales_channel_domain` `acris_switch_domain.domain` ON `acris_switch_domain`.`domain_id` = `acris_switch_domain.domain`.`id` WHERE (`acris_switch_domain`.`rule_id` IN (0x96BB70E8BB6D4205B8DC639855784779));

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

SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`company_tax_free` as `country.companyTaxFree`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`tax_free` as `country.taxFree`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (0x265D775B6B904556921F52C65B3386DB, 0x8BB8A7EE9A094B5B8A72C94DDAEA078B, 0x947321778EF1447191C8A853E1B44CC5, 0x265D775B6B904556921F52C65B3386DB, 0x8BB8A7EE9A094B5B8A72C94DDAEA078B, 0x947321778EF1447191C8A853E1B44CC5, 0x265D775B6B904556921F52C65B3386DB, 0x8BB8A7EE9A094B5B8A72C94DDAEA078B, 0x947321778EF1447191C8A853E1B44CC5);

SELECT 
  `language`.`id` as `language.id`, 
  `language`.`parent_id` as `language.parentId`, 
  `language`.`locale_id` as `language.localeId`, 
  `language`.`translation_code_id` as `language.translationCodeId`, 
  `language`.`name` as `language.name`, 
  `language`.`custom_fields` as `language.customFields`, 
  `language`.`created_at` as `language.createdAt`, 
  `language`.`updated_at` as `language.updatedAt`, 
  `language.locale`.`id` as `language.locale.id`, 
  `language.locale`.`code` as `language.locale.code`, 
  `language.locale`.`created_at` as `language.locale.createdAt`, 
  `language.locale`.`updated_at` as `language.locale.updatedAt`, 
  `language.locale.translation.name`, 
  COALESCE(
    `language.locale.translation.name`, 
    `language.locale.translation.name`
  ) as `language.locale.name`, 
  `language.locale.translation.territory`, 
  COALESCE(
    `language.locale.translation.territory`, 
    `language.locale.translation.territory`
  ) as `language.locale.territory`, 
  `language.locale.translation.customFields`, 
  COALESCE(
    `language.locale.translation.customFields`, 
    `language.locale.translation.customFields`
  ) as `language.locale.customFields`, 
  `language.locale.translation.createdAt`, 
  `language.locale.translation.updatedAt`, 
  `language.locale.translation.localeId`, 
  `language.locale.translation.languageId` 
FROM 
  `language` 
  LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` 
  LEFT JOIN (
    SELECT 
      `language.locale.translation`.locale_id, 
      `language.locale.translation`.name as `language.locale.translation.name`, 
      `language.locale.translation`.territory as `language.locale.translation.territory`, 
      `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, 
      `language.locale.translation`.created_at as `language.locale.translation.createdAt`, 
      `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, 
      `language.locale.translation`.locale_id as `language.locale.translation.localeId`, 
      `language.locale.translation`.language_id as `language.locale.translation.languageId` 
    FROM 
      `locale_translation` `language.locale.translation` 
    WHERE 
      `language.locale.translation`.language_id = : languageId
  ) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` 
WHERE 
  `language`.`id` IN (: ids)

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, COALESCE(`language.locale.translation.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields`, `language.locale.translation.createdAt`, `language.locale.translation.updatedAt`, `language.locale.translation.localeId`, `language.locale.translation.languageId` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.locale_id, `language.locale.translation`.name as `language.locale.translation.name`, `language.locale.translation`.territory as `language.locale.translation.territory`, `language.locale.translation`.custom_fields as `language.locale.translation.customFields`, `language.locale.translation`.created_at as `language.locale.translation.createdAt`, `language.locale.translation`.updated_at as `language.locale.translation.updatedAt`, `language.locale.translation`.locale_id as `language.locale.translation.localeId`, `language.locale.translation`.language_id as `language.locale.translation.languageId` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0xAB77473E644A460A902E78D34D868DDA, 0x8420B2038D9643CCBF3B26BCE353967D, 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

SELECT 
  `acris_switch_exclusion`.`id` 
FROM 
  `acris_switch_exclusion` 
WHERE 
  (
    `acris_switch_exclusion`.`active` = : param_6c5cc1e7362c47359a2b2b67179c54fc 
    AND `acris_switch_exclusion`.`type` = : param_2100c45fd8f44225921189d711886f9a 
    AND `acris_switch_exclusion`.`ip` = : param_f52bb7b8facd410a87b6d2c3e70daed6
  )

SELECT `acris_switch_exclusion`.`id` FROM `acris_switch_exclusion` WHERE (`acris_switch_exclusion`.`active` = 1 AND `acris_switch_exclusion`.`type` = 'ip' AND `acris_switch_exclusion`.`ip` = '13.59.235.245');