Symfony Profiler

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_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582718994_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345021_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586345063_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587126585_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625566312_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606378923_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607952506_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608034991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612945522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620808652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631192197_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1566896378_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1579597261_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580742497_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584020367_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584615734_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588138609_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597841941_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603726376_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620989898_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621518771_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634193548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652779309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574344300_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572944593_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573045796_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573135374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573139562_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573140186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573209317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573209481_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574072727_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576497438_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576497500_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576503670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576505995_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1577972394_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578049087_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578066584_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584096712_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585054485_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585055462_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587976714_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587988241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592301104_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602233999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602832962_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607683101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611068135_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614764106_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625817765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630049295_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636367162_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642147726_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646304817_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648797644_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649245702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652692175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653310700_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653661469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1680157673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1688639650_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1689061373_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1701076963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1718713101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1718877324_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1722868766_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666208_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666268_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1590657517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651494367_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575569953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598204175_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1713775973_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607423732_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603810036_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616412445_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616413078_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622039002_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629280389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642507826_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1685001455_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 @@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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;SET @MIGRATION_1625566312_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1566896378_IS_ACTIVE = TRUE;SET @MIGRATION_1579597261_IS_ACTIVE = TRUE;SET @MIGRATION_1580742497_IS_ACTIVE = TRUE;SET @MIGRATION_1584020367_IS_ACTIVE = TRUE;SET @MIGRATION_1584615734_IS_ACTIVE = TRUE;SET @MIGRATION_1588138609_IS_ACTIVE = TRUE;SET @MIGRATION_1597841941_IS_ACTIVE = TRUE;SET @MIGRATION_1603726376_IS_ACTIVE = TRUE;SET @MIGRATION_1620989898_IS_ACTIVE = TRUE;SET @MIGRATION_1621518771_IS_ACTIVE = TRUE;SET @MIGRATION_1634193548_IS_ACTIVE = TRUE;SET @MIGRATION_1652779309_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1572944593_IS_ACTIVE = TRUE;SET @MIGRATION_1573045796_IS_ACTIVE = TRUE;SET @MIGRATION_1573135374_IS_ACTIVE = TRUE;SET @MIGRATION_1573139562_IS_ACTIVE = TRUE;SET @MIGRATION_1573140186_IS_ACTIVE = TRUE;SET @MIGRATION_1573209317_IS_ACTIVE = TRUE;SET @MIGRATION_1573209481_IS_ACTIVE = TRUE;SET @MIGRATION_1574072727_IS_ACTIVE = TRUE;SET @MIGRATION_1576497438_IS_ACTIVE = TRUE;SET @MIGRATION_1576497500_IS_ACTIVE = TRUE;SET @MIGRATION_1576503670_IS_ACTIVE = TRUE;SET @MIGRATION_1576505995_IS_ACTIVE = TRUE;SET @MIGRATION_1577972394_IS_ACTIVE = TRUE;SET @MIGRATION_1578049087_IS_ACTIVE = TRUE;SET @MIGRATION_1578066584_IS_ACTIVE = TRUE;SET @MIGRATION_1584096712_IS_ACTIVE = TRUE;SET @MIGRATION_1585054485_IS_ACTIVE = TRUE;SET @MIGRATION_1585055462_IS_ACTIVE = TRUE;SET @MIGRATION_1587976714_IS_ACTIVE = TRUE;SET @MIGRATION_1587988241_IS_ACTIVE = TRUE;SET @MIGRATION_1592301104_IS_ACTIVE = TRUE;SET @MIGRATION_1602233999_IS_ACTIVE = TRUE;SET @MIGRATION_1602832962_IS_ACTIVE = TRUE;SET @MIGRATION_1607683101_IS_ACTIVE = TRUE;SET @MIGRATION_1611068135_IS_ACTIVE = TRUE;SET @MIGRATION_1614764106_IS_ACTIVE = TRUE;SET @MIGRATION_1625817765_IS_ACTIVE = TRUE;SET @MIGRATION_1630049295_IS_ACTIVE = TRUE;SET @MIGRATION_1636367162_IS_ACTIVE = TRUE;SET @MIGRATION_1642147726_IS_ACTIVE = TRUE;SET @MIGRATION_1646304817_IS_ACTIVE = TRUE;SET @MIGRATION_1648797644_IS_ACTIVE = TRUE;SET @MIGRATION_1649245702_IS_ACTIVE = TRUE;SET @MIGRATION_1652692175_IS_ACTIVE = TRUE;SET @MIGRATION_1653310700_IS_ACTIVE = TRUE;SET @MIGRATION_1653661469_IS_ACTIVE = TRUE;SET @MIGRATION_1680157673_IS_ACTIVE = TRUE;SET @MIGRATION_1688639650_IS_ACTIVE = TRUE;SET @MIGRATION_1689061373_IS_ACTIVE = TRUE;SET @MIGRATION_1701076963_IS_ACTIVE = TRUE;SET @MIGRATION_1718713101_IS_ACTIVE = TRUE;SET @MIGRATION_1718877324_IS_ACTIVE = TRUE;SET @MIGRATION_1722868766_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1713775973_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;SET @MIGRATION_1685001455_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;

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

SELECT 
  configuration_value 
FROM 
  system_config 
WHERE 
  (
    configuration_key = : configurationKey
  ) 
  AND (
    (
      sales_channel_id = : salesChannelId 
      OR sales_channel_id IS NULL
    )
  ) 
ORDER BY 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

SELECT configuration_value FROM system_config WHERE (configuration_key = 'NetiNextStoreLocator.config.seoUrl') AND ((sales_channel_id = 0xBCD1F8C7116049609B5C76B472A00703 OR sales_channel_id IS NULL)) ORDER BY sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, 
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, 
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, 
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, 
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, 
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, 
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, 
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, 
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, 
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, 
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, 
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, 
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, 
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, 
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, 
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, 
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, 
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, 
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` 
FROM 
  `dreisc_seo_redirect` 
WHERE 
  (
    (
      `dreisc_seo_redirect`.`active` = : param_a8984a48faca4c46bf0ac26f2e0863f9 
      AND `dreisc_seo_redirect`.`source_type` = : param_895eb9abf8964c898e9bc2803fddc4cc 
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = : param_fd6905b2079346d3b57968eeb7eadd9b 
      AND `dreisc_seo_redirect`.`source_path` = : param_5fc3fa53e24b470da0e62eeaf833447b
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'url' AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = 0xFB6D18C98CEF4B6E84A8B8D045F00DA6 AND `dreisc_seo_redirect`.`source_path` = 'Filialfinder'));

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 = : salesChannelId 
  OR system_config.sales_channel_id IS NULL 
ORDER BY 
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = 0xBCD1F8C7116049609B5C76B472A00703 OR system_config.sales_channel_id IS NULL 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 = 0xBCD1F8C7116049609B5C76B472A00703) AND (token = 'Lo0op7ZzR92pSSVrgVCyarctjvQMvH91') 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 (0xFB6D18C98CEF4B6E84A8B8D045F00DA6);

SELECT 
  `name`, 
  `type` 
FROM 
  `custom_field` 
WHERE 
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 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` 
FROM 
  `sales_channel_domain` 
WHERE 
  (
    `sales_channel_domain`.`sales_channel_id` IN (
      : param_0a080170ee334c2f95799d041f8abdfb
    )
  )

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

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_11563c32d86a44fcb20889e3853f53dd 
      AND `acris_switch_rule.domains`.`active` = : param_8d388c0147e14d73914cf7415336cc8b
    ) 
    AND `acris_switch_rule`.`active` = : param_9862c0ee699c4f308275447188239ba9
  ) 
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` = 0xFB6D18C98CEF4B6E84A8B8D045F00DA6 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 (0x59611D5CF90C4AA1BC55F45D334FBB63);

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

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