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_1647268900_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1683891166_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580205548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580205550_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580205551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580205552_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603787192_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603787193_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608909056_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608909057_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608909058_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609840337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609840338_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610290148_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615974752_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615974753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615974754_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616854566_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641641753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652087759_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652087760_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582062361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586956319_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957570_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957590_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957607_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957645_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957668_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957725_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957746_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957762_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586957783_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797135_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797152_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797161_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797169_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797179_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797187_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797195_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592797202_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779906_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779918_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779932_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779942_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779951_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593779960_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594966504_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594966515_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594966524_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597215729_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597215746_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597838417_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597986445_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600675898_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601120221_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601992835_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606376845_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607512379_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607884528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608040973_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612278132_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612791565_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627629902_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629801370_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629801404_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629801620_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629801640_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629801659_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632919956_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632920024_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632920033_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632920056_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635490045_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636446770_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636555359_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636555971_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636556484_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637133544_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637847901_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639648825_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641822051_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642155183_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642756964_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642756964_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642756964_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643292592_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645095343_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650358404_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652686136_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653461371_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654238191_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655197694_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655295083_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1569228273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1569229664_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1569229690_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603497807_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675865950_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1686048772_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1686294577_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1687766925_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_1647268900_IS_ACTIVE = TRUE;SET @MIGRATION_1683891166_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205551_IS_ACTIVE = TRUE;SET @MIGRATION_1580205552_IS_ACTIVE = TRUE;SET @MIGRATION_1603787192_IS_ACTIVE = TRUE;SET @MIGRATION_1603787193_IS_ACTIVE = TRUE;SET @MIGRATION_1608909056_IS_ACTIVE = TRUE;SET @MIGRATION_1608909057_IS_ACTIVE = TRUE;SET @MIGRATION_1608909058_IS_ACTIVE = TRUE;SET @MIGRATION_1609840337_IS_ACTIVE = TRUE;SET @MIGRATION_1609840338_IS_ACTIVE = TRUE;SET @MIGRATION_1610290148_IS_ACTIVE = TRUE;SET @MIGRATION_1615974752_IS_ACTIVE = TRUE;SET @MIGRATION_1615974753_IS_ACTIVE = TRUE;SET @MIGRATION_1615974754_IS_ACTIVE = TRUE;SET @MIGRATION_1616854566_IS_ACTIVE = TRUE;SET @MIGRATION_1641641753_IS_ACTIVE = TRUE;SET @MIGRATION_1652087759_IS_ACTIVE = TRUE;SET @MIGRATION_1652087760_IS_ACTIVE = TRUE;SET @MIGRATION_1582062361_IS_ACTIVE = TRUE;SET @MIGRATION_1586956319_IS_ACTIVE = TRUE;SET @MIGRATION_1586957570_IS_ACTIVE = TRUE;SET @MIGRATION_1586957590_IS_ACTIVE = TRUE;SET @MIGRATION_1586957607_IS_ACTIVE = TRUE;SET @MIGRATION_1586957645_IS_ACTIVE = TRUE;SET @MIGRATION_1586957668_IS_ACTIVE = TRUE;SET @MIGRATION_1586957708_IS_ACTIVE = TRUE;SET @MIGRATION_1586957725_IS_ACTIVE = TRUE;SET @MIGRATION_1586957746_IS_ACTIVE = TRUE;SET @MIGRATION_1586957762_IS_ACTIVE = TRUE;SET @MIGRATION_1586957783_IS_ACTIVE = TRUE;SET @MIGRATION_1592797135_IS_ACTIVE = TRUE;SET @MIGRATION_1592797152_IS_ACTIVE = TRUE;SET @MIGRATION_1592797161_IS_ACTIVE = TRUE;SET @MIGRATION_1592797169_IS_ACTIVE = TRUE;SET @MIGRATION_1592797179_IS_ACTIVE = TRUE;SET @MIGRATION_1592797187_IS_ACTIVE = TRUE;SET @MIGRATION_1592797195_IS_ACTIVE = TRUE;SET @MIGRATION_1592797202_IS_ACTIVE = TRUE;SET @MIGRATION_1593779906_IS_ACTIVE = TRUE;SET @MIGRATION_1593779918_IS_ACTIVE = TRUE;SET @MIGRATION_1593779932_IS_ACTIVE = TRUE;SET @MIGRATION_1593779942_IS_ACTIVE = TRUE;SET @MIGRATION_1593779951_IS_ACTIVE = TRUE;SET @MIGRATION_1593779960_IS_ACTIVE = TRUE;SET @MIGRATION_1594966504_IS_ACTIVE = TRUE;SET @MIGRATION_1594966515_IS_ACTIVE = TRUE;SET @MIGRATION_1594966524_IS_ACTIVE = TRUE;SET @MIGRATION_1597215729_IS_ACTIVE = TRUE;SET @MIGRATION_1597215746_IS_ACTIVE = TRUE;SET @MIGRATION_1597838417_IS_ACTIVE = TRUE;SET @MIGRATION_1597986445_IS_ACTIVE = TRUE;SET @MIGRATION_1600675898_IS_ACTIVE = TRUE;SET @MIGRATION_1601120221_IS_ACTIVE = TRUE;SET @MIGRATION_1601992835_IS_ACTIVE = TRUE;SET @MIGRATION_1606376845_IS_ACTIVE = TRUE;SET @MIGRATION_1607512379_IS_ACTIVE = TRUE;SET @MIGRATION_1607884528_IS_ACTIVE = TRUE;SET @MIGRATION_1608040973_IS_ACTIVE = TRUE;SET @MIGRATION_1612278132_IS_ACTIVE = TRUE;SET @MIGRATION_1612791565_IS_ACTIVE = TRUE;SET @MIGRATION_1627629902_IS_ACTIVE = TRUE;SET @MIGRATION_1629801370_IS_ACTIVE = TRUE;SET @MIGRATION_1629801404_IS_ACTIVE = TRUE;SET @MIGRATION_1629801620_IS_ACTIVE = TRUE;SET @MIGRATION_1629801640_IS_ACTIVE = TRUE;SET @MIGRATION_1629801659_IS_ACTIVE = TRUE;SET @MIGRATION_1632919956_IS_ACTIVE = TRUE;SET @MIGRATION_1632920024_IS_ACTIVE = TRUE;SET @MIGRATION_1632920033_IS_ACTIVE = TRUE;SET @MIGRATION_1632920056_IS_ACTIVE = TRUE;SET @MIGRATION_1635490045_IS_ACTIVE = TRUE;SET @MIGRATION_1636446770_IS_ACTIVE = TRUE;SET @MIGRATION_1636555359_IS_ACTIVE = TRUE;SET @MIGRATION_1636555971_IS_ACTIVE = TRUE;SET @MIGRATION_1636556484_IS_ACTIVE = TRUE;SET @MIGRATION_1637133544_IS_ACTIVE = TRUE;SET @MIGRATION_1637847901_IS_ACTIVE = TRUE;SET @MIGRATION_1639648825_IS_ACTIVE = TRUE;SET @MIGRATION_1641822051_IS_ACTIVE = TRUE;SET @MIGRATION_1642155183_IS_ACTIVE = TRUE;SET @MIGRATION_1642756964_IS_ACTIVE = TRUE;SET @MIGRATION_1642756964_IS_ACTIVE = TRUE;SET @MIGRATION_1642756964_IS_ACTIVE = TRUE;SET @MIGRATION_1643292592_IS_ACTIVE = TRUE;SET @MIGRATION_1645095343_IS_ACTIVE = TRUE;SET @MIGRATION_1650358404_IS_ACTIVE = TRUE;SET @MIGRATION_1652686136_IS_ACTIVE = TRUE;SET @MIGRATION_1653461371_IS_ACTIVE = TRUE;SET @MIGRATION_1654238191_IS_ACTIVE = TRUE;SET @MIGRATION_1655197694_IS_ACTIVE = TRUE;SET @MIGRATION_1655295083_IS_ACTIVE = TRUE;SET @MIGRATION_1569228273_IS_ACTIVE = TRUE;SET @MIGRATION_1569229664_IS_ACTIVE = TRUE;SET @MIGRATION_1569229690_IS_ACTIVE = TRUE;SET @MIGRATION_1603497807_IS_ACTIVE = TRUE;SET @MIGRATION_1675865950_IS_ACTIVE = TRUE;SET @MIGRATION_1686048772_IS_ACTIVE = TRUE;SET @MIGRATION_1686294577_IS_ACTIVE = TRUE;SET @MIGRATION_1687766925_IS_ACTIVE = TRUE;

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

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

# seo-url::resolve
SELECT 
  id, 
  path_info pathInfo, 
  is_canonical isCanonical 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    (
      sales_channel_id = : sales_channel_id 
      OR sales_channel_id IS NULL
    )
  ) 
  AND (seo_path_info = : seoPath) 
ORDER BY 
  seo_path_info ASC, 
  sales_channel_id IS NULL ASC 
LIMIT 
  1

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x151CD0AA73AC490B937692D0881F4449 OR sales_channel_id IS NULL)) AND (seo_path_info = 'Testprodukt4/SW10003') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

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

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

SELECT 
  * 
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 = 0x151CD0AA73AC490B937692D0881F4449) AND (token = 'oEZrvPAOS2ZgTaaOmc2vNYRb97uWFQQL') LIMIT 1;

# context-factory::base-context
SELECT 
  sales_channel.id as sales_channel_id, 
  sales_channel.language_id as sales_channel_default_language_id, 
  sales_channel.currency_id as sales_channel_currency_id, 
  currency.factor as sales_channel_currency_factor, 
  GROUP_CONCAT(
    LOWER(
      HEX(
        sales_channel_language.language_id
      )
    )
  ) as sales_channel_language_ids 
FROM 
  sales_channel 
  INNER JOIN currency ON sales_channel.currency_id = currency.id 
  LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id 
WHERE 
  sales_channel.id = : id 
GROUP BY 
  sales_channel.id, 
  sales_channel.language_id, 
  sales_channel.currency_id, 
  currency.factor

# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = 0x151CD0AA73AC490B937692D0881F4449
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor;

# base-context-factory::sales-channel::read
SELECT 
  `sales_channel`.`id` as `sales_channel.id`, 
  `sales_channel`.`type_id` as `sales_channel.typeId`, 
  `sales_channel`.`language_id` as `sales_channel.languageId`, 
  `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, 
  `sales_channel`.`currency_id` as `sales_channel.currencyId`, 
  `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, 
  `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, 
  `sales_channel`.`country_id` as `sales_channel.countryId`, 
  `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, 
  `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, 
  `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, 
  `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, 
  `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, 
  `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, 
  `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, 
  `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, 
  `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, 
  `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, 
  `sales_channel`.`short_name` as `sales_channel.shortName`, 
  `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, 
  `sales_channel`.`access_key` as `sales_channel.accessKey`, 
  `sales_channel`.`configuration` as `sales_channel.configuration`, 
  `sales_channel`.`active` as `sales_channel.active`, 
  `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, 
  `sales_channel`.`maintenance` as `sales_channel.maintenance`, 
  `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, 
  `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, 
  `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, 
  `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, 
  `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, 
  `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, 
  `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, 
  `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, 
  `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, 
  `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, 
  `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, 
  `sales_channel`.`created_at` as `sales_channel.createdAt`, 
  `sales_channel`.`updated_at` as `sales_channel.updatedAt`, 
  `sales_channel.currency`.`id` as `sales_channel.currency.id`, 
  `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, 
  `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, 
  `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, 
  `sales_channel.currency`.`position` as `sales_channel.currency.position`, 
  `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, 
  `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, 
  `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, 
  `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, 
  `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, 
  `sales_channel.currency.translation.shortName`, 
  COALESCE(
    `sales_channel.currency.translation.shortName`, 
    `sales_channel.currency.translation.shortName`
  ) as `sales_channel.currency.shortName`, 
  `sales_channel.currency.translation.name`, 
  COALESCE(
    `sales_channel.currency.translation.name`, 
    `sales_channel.currency.translation.name`
  ) as `sales_channel.currency.name`, 
  `sales_channel.currency.translation.customFields`, 
  COALESCE(
    `sales_channel.currency.translation.customFields`, 
    `sales_channel.currency.translation.customFields`
  ) as `sales_channel.currency.customFields`, 
  `sales_channel.currency.translation.createdAt`, 
  `sales_channel.currency.translation.updatedAt`, 
  `sales_channel.currency.translation.currencyId`, 
  `sales_channel.currency.translation.languageId`, 
  `sales_channel.translation.name`, 
  COALESCE(
    `sales_channel.translation.name`, 
    `sales_channel.translation.name`
  ) as `sales_channel.name`, 
  `sales_channel.translation.homeSlotConfig`, 
  COALESCE(
    `sales_channel.translation.homeSlotConfig`, 
    `sales_channel.translation.homeSlotConfig`
  ) as `sales_channel.homeSlotConfig`, 
  `sales_channel.translation.homeEnabled`, 
  COALESCE(
    `sales_channel.translation.homeEnabled`, 
    `sales_channel.translation.homeEnabled`
  ) as `sales_channel.homeEnabled`, 
  `sales_channel.translation.homeName`, 
  COALESCE(
    `sales_channel.translation.homeName`, 
    `sales_channel.translation.homeName`
  ) as `sales_channel.homeName`, 
  `sales_channel.translation.homeMetaTitle`, 
  COALESCE(
    `sales_channel.translation.homeMetaTitle`, 
    `sales_channel.translation.homeMetaTitle`
  ) as `sales_channel.homeMetaTitle`, 
  `sales_channel.translation.homeMetaDescription`, 
  COALESCE(
    `sales_channel.translation.homeMetaDescription`, 
    `sales_channel.translation.homeMetaDescription`
  ) as `sales_channel.homeMetaDescription`, 
  `sales_channel.translation.homeKeywords`, 
  COALESCE(
    `sales_channel.translation.homeKeywords`, 
    `sales_channel.translation.homeKeywords`
  ) as `sales_channel.homeKeywords`, 
  `sales_channel.translation.customFields`, 
  COALESCE(
    `sales_channel.translation.customFields`, 
    `sales_channel.translation.customFields`
  ) as `sales_channel.customFields`, 
  `sales_channel.translation.createdAt`, 
  `sales_channel.translation.updatedAt`, 
  `sales_channel.translation.salesChannelId`, 
  `sales_channel.translation.languageId` 
FROM 
  `sales_channel` 
  LEFT JOIN (
    SELECT 
      `sales_channel.translation`.sales_channel_id, 
      `sales_channel.translation`.name as `sales_channel.translation.name`, 
      `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, 
      `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, 
      `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, 
      `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, 
      `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, 
      `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, 
      `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, 
      `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, 
      `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, 
      `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, 
      `sales_channel.translation`.language_id as `sales_channel.translation.languageId` 
    FROM 
      `sales_channel_translation` `sales_channel.translation` 
    WHERE 
      `sales_channel.translation`.language_id = : languageId
  ) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` 
  LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` 
  LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` 
  LEFT JOIN (
    SELECT 
      `sales_channel.currency.translation`.currency_id, 
      `sales_channel.currency.translation`.short_name as `sales_channel.currency.translation.shortName`, 
      `sales_channel.currency.translation`.name as `sales_channel.currency.translation.name`, 
      `sales_channel.currency.translation`.custom_fields as `sales_channel.currency.translation.customFields`, 
      `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, 
      `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, 
      `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, 
      `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId` 
    FROM 
      `currency_translation` `sales_channel.currency.translation` 
    WHERE 
      `sales_channel.currency.translation`.language_id = : languageId
  ) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` 
WHERE 
  `sales_channel`.`id` IN (: ids)

# base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.currency_id, `sales_channel.currency.translation`.short_name as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.name as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (0x151CD0AA73AC490B937692D0881F4449);

# base-context-factory::sales-channel::association::domains::read
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_10ade17c64a44fc2949d234f884723c5
    )
  )

# base-context-factory::sales-channel::association::domains::read
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 (0x151CD0AA73AC490B937692D0881F4449));

# base-context-factory::currency::read
SELECT 
  `currency`.`id` as `currency.id`, 
  `currency`.`factor` as `currency.factor`, 
  `currency`.`symbol` as `currency.symbol`, 
  `currency`.`iso_code` as `currency.isoCode`, 
  `currency`.`position` as `currency.position`, 
  `currency`.`item_rounding` as `currency.itemRounding`, 
  `currency`.`total_rounding` as `currency.totalRounding`, 
  `currency`.`tax_free_from` as `currency.taxFreeFrom`, 
  `currency`.`created_at` as `currency.createdAt`, 
  `currency`.`updated_at` as `currency.updatedAt`, 
  `currency.translation.shortName`, 
  COALESCE(
    `currency.translation.shortName`, 
    `currency.translation.shortName`
  ) as `currency.shortName`, 
  `currency.translation.name`, 
  COALESCE(
    `currency.translation.name`, `currency.translation.name`
  ) as `currency.name`, 
  `currency.translation.customFields`, 
  COALESCE(
    `currency.translation.customFields`, 
    `currency.translation.customFields`
  ) as `currency.customFields`, 
  `currency.translation.createdAt`, 
  `currency.translation.updatedAt`, 
  `currency.translation.currencyId`, 
  `currency.translation.languageId` 
FROM 
  `currency` 
  LEFT JOIN (
    SELECT 
      `currency.translation`.currency_id, 
      `currency.translation`.short_name as `currency.translation.shortName`, 
      `currency.translation`.name as `currency.translation.name`, 
      `currency.translation`.custom_fields as `currency.translation.customFields`, 
      `currency.translation`.created_at as `currency.translation.createdAt`, 
      `currency.translation`.updated_at as `currency.translation.updatedAt`, 
      `currency.translation`.currency_id as `currency.translation.currencyId`, 
      `currency.translation`.language_id as `currency.translation.languageId` 
    FROM 
      `currency_translation` `currency.translation` 
    WHERE 
      `currency.translation`.language_id = : languageId
  ) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` 
WHERE 
  `currency`.`id` IN (: ids)

# base-context-factory::currency::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA);

# base-context-factory::country::read
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`.`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.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`.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)

# base-context-factory::country::read
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`.`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.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`.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 (0xCF6A7BBC8D1F438A9D644614D7AC6E93);

# base-context-factory::customer-group::read
SELECT 
  `customer_group`.`id` as `customer_group.id`, 
  `customer_group`.`display_gross` as `customer_group.displayGross`, 
  `customer_group`.`registration_active` as `customer_group.registrationActive`, 
  `customer_group`.`created_at` as `customer_group.createdAt`, 
  `customer_group`.`updated_at` as `customer_group.updatedAt`, 
  `customer_group.translation.name`, 
  COALESCE(
    `customer_group.translation.name`, 
    `customer_group.translation.name`
  ) as `customer_group.name`, 
  `customer_group.translation.registrationTitle`, 
  COALESCE(
    `customer_group.translation.registrationTitle`, 
    `customer_group.translation.registrationTitle`
  ) as `customer_group.registrationTitle`, 
  `customer_group.translation.registrationIntroduction`, 
  COALESCE(
    `customer_group.translation.registrationIntroduction`, 
    `customer_group.translation.registrationIntroduction`
  ) as `customer_group.registrationIntroduction`, 
  `customer_group.translation.registrationOnlyCompanyRegistration`, 
  COALESCE(
    `customer_group.translation.registrationOnlyCompanyRegistration`, 
    `customer_group.translation.registrationOnlyCompanyRegistration`
  ) as `customer_group.registrationOnlyCompanyRegistration`, 
  `customer_group.translation.registrationSeoMetaDescription`, 
  COALESCE(
    `customer_group.translation.registrationSeoMetaDescription`, 
    `customer_group.translation.registrationSeoMetaDescription`
  ) as `customer_group.registrationSeoMetaDescription`, 
  `customer_group.translation.customFields`, 
  COALESCE(
    `customer_group.translation.customFields`, 
    `customer_group.translation.customFields`
  ) as `customer_group.customFields`, 
  `customer_group.translation.createdAt`, 
  `customer_group.translation.updatedAt`, 
  `customer_group.translation.customerGroupId`, 
  `customer_group.translation.languageId` 
FROM 
  `customer_group` 
  LEFT JOIN (
    SELECT 
      `customer_group.translation`.customer_group_id, 
      `customer_group.translation`.name as `customer_group.translation.name`, 
      `customer_group.translation`.registration_title as `customer_group.translation.registrationTitle`, 
      `customer_group.translation`.registration_introduction as `customer_group.translation.registrationIntroduction`, 
      `customer_group.translation`.registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration`, 
      `customer_group.translation`.registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription`, 
      `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, 
      `customer_group.translation`.created_at as `customer_group.translation.createdAt`, 
      `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, 
      `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, 
      `customer_group.translation`.language_id as `customer_group.translation.languageId` 
    FROM 
      `customer_group_translation` `customer_group.translation` 
    WHERE 
      `customer_group.translation`.language_id = : languageId
  ) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` 
WHERE 
  `customer_group`.`id` IN (: ids)

# base-context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `customer_group.translation`.name as `customer_group.translation.name`, `customer_group.translation`.registration_title as `customer_group.translation.registrationTitle`, `customer_group.translation`.registration_introduction as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.registration_only_company_registration as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.registration_seo_meta_description as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation`.custom_fields as `customer_group.translation.customFields`, `customer_group.translation`.created_at as `customer_group.translation.createdAt`, `customer_group.translation`.updated_at as `customer_group.translation.updatedAt`, `customer_group.translation`.customer_group_id as `customer_group.translation.customerGroupId`, `customer_group.translation`.language_id as `customer_group.translation.languageId` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (0xCFBD5018D38D41D8ADCA10D94FC8BDD6);

# base-context-factory::taxes::read
SELECT 
  `tax`.`id` as `tax.id`, 
  `tax`.`tax_rate` as `tax.taxRate`, 
  `tax`.`name` as `tax.name`, 
  `tax`.`position` as `tax.position`, 
  `tax`.`custom_fields` as `tax.customFields`, 
  `tax`.`created_at` as `tax.createdAt`, 
  `tax`.`updated_at` as `tax.updatedAt` 
FROM 
  `tax`

# base-context-factory::taxes::read
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`;