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_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 @@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_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;

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

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

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

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_42717009718e48c2ae31854ba6b0d1d1
  ) 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500;

# system-config::load::read
SELECT 
  `system_config`.`id` as `system_config.id`, 
  `system_config`.`configuration_key` as `system_config.configurationKey`, 
  `system_config`.`configuration_value` as `system_config.configurationValue`, 
  `system_config`.`sales_channel_id` as `system_config.salesChannelId`, 
  `system_config`.`created_at` as `system_config.createdAt`, 
  `system_config`.`updated_at` as `system_config.updatedAt` 
FROM 
  `system_config` 
WHERE 
  `system_config`.`id` IN (: ids)

# system-config::load::read
SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (0x03E536C5931B473795C2CBFE8AF2F907, 0x041133ADB27748B6A4B3FEBAC3D66F31, 0x04DD0A6715934E62B399EF5D128561D8, 0x0D4ED48B80F74B819D8AB3F8FEBCF996, 0x0D83DF985EB8482DAE59C33A1E3E9761, 0x190A700477AF48A1ADC0ADDF5D171418, 0x1AC621E394CA40049C09BDEFE900FBD9, 0x1C62A900F42E44B2AE72A0065CCB98DF, 0x288ACD05FD914E8BA4909DC6E313BC44, 0x2CE8E030138548409ECD0725033DC0D4, 0x2D48B8FDAA7E4939BB617E315036A45E, 0x300D581083094959BC2AB355FD3A5D90, 0x3AFD0A673F7F451284844C949C532A75, 0x3BEF1F38347F4E06B30A0A9A87557692, 0x479BD8AEB4584811B1D256902CF73E48, 0x5D7140569D3D4CC49B591416E8C250D1, 0x5F86EB19C0434A558895E2BB191EC44B, 0x60DEE06D47A7409B8C7D3C08B06682F5, 0x69B724069AAB4A838BAE205942D1698F, 0x6BDCD439B4FB4ABAA04ED01A7E77276A, 0x6DA0C116EC3749B0B5CC07F234AF7A86, 0x72CBDA0BCE2041E68B1DD1567A6BCF94, 0x7DD3BC1DAB7F44D8B26CAC8A54FC286D, 0x7E3CAA5D8F8D4EDF9A56D80A8AD41EE0, 0x84F74E2312EB4420BA0B425E0BD17F72, 0x87C1B7C621274C8987F7A783775A7C62, 0x8A54ED16231E4132822D0F3C343D953C, 0x900DEA0AD7454B7585BD473A85113004, 0x936A2FA43C374EA3BE9BDB46AF8DBECA, 0x937FCF51FBD64782BB8F847D248BC58B, 0x95614BAF45324C3F91641D0B89835EA6, 0x991E42C8C57B45E48C42D8AFB58449DD, 0x9EA0F7FEF5AA4812A13043A982B04AEF, 0xA1B9091B90C7492DA4B8192E624C1751, 0xA1CDD1A1EC8848C4A03F01924E2018AE, 0xA94BB66394FE49C8B0F9ED85A98D38B9, 0xB3CAF94B32804DC7A3EE0E62683AA43C, 0xB4675736996E42A9B73E046CD81F557E, 0xB5F2D399FD86488CBE1A3F13ABA3D91E, 0xB5F937246A384AD1AD79E2EC061FCF68, 0xB862C1BC7C554DFAA3081B8922FAF9E5, 0xB96AE36AEB1E484D9EF7724219D1E6EE, 0xBD8ACEA24B2B4EBBB5049561A96770F6, 0xC6B52484630F42259AFECD4BDCA827F8, 0xCAF45FB0904046C6BC3ED3D00FDEBB5A, 0xCB9C4834FEF04681A7BE0B7A2636AE67, 0xD56526AD66D94775863E35F61D974B93, 0xDD23E3C9140C4E5A881831B4053E4873, 0xDD977C7C5A2242AF8A800FF572325949, 0xE09DCBA665254618A5602A323966CAC5, 0xE92D892B8104426BA0FEDF0DE6C8A3F9, 0xF00C086BE597491390C8E26515355C66, 0xF0F86E1080D34F79AD5A0F556953D693, 0xFA139E8785F8482E8CB254C0FA8A89F5, 0xFD05DF3E77E741348180487792BA1B57, 0xFD5980506ED94326AD01A8CCBC0424E6, 0xFE40DBFC5D454C53B53EFC543FB6EE49, 0xFF86C579BD814AA5B907D7015189C516);

# system-config::load::search-ids
SELECT 
  `system_config`.`id` 
FROM 
  `system_config` 
WHERE 
  (
    `system_config`.`sales_channel_id` <=> : param_543d1ebf63f94678a2376fe27c9233fd
  ) 
ORDER BY 
  `system_config`.`sales_channel_id` ASC, 
  `system_config`.`id` ASC 
LIMIT 
  500 OFFSET 500

# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500;

SELECT 
  `plugin`.`id` as `plugin.id`, 
  `plugin`.`base_class` as `plugin.baseClass`, 
  `plugin`.`name` as `plugin.name`, 
  `plugin`.`composer_name` as `plugin.composerName`, 
  `plugin`.`autoload` as `plugin.autoload`, 
  `plugin`.`active` as `plugin.active`, 
  `plugin`.`managed_by_composer` as `plugin.managedByComposer`, 
  `plugin`.`path` as `plugin.path`, 
  `plugin`.`author` as `plugin.author`, 
  `plugin`.`copyright` as `plugin.copyright`, 
  `plugin`.`license` as `plugin.license`, 
  `plugin`.`version` as `plugin.version`, 
  `plugin`.`upgrade_version` as `plugin.upgradeVersion`, 
  `plugin`.`installed_at` as `plugin.installedAt`, 
  `plugin`.`upgraded_at` as `plugin.upgradedAt`, 
  `plugin`.`icon` as `plugin.iconRaw`, 
  `plugin`.`created_at` as `plugin.createdAt`, 
  `plugin`.`updated_at` as `plugin.updatedAt`, 
  `plugin.plugin_translation`.*, 
  COALESCE(
    `plugin.translation.label`, `plugin.translation.label`
  ) as `plugin.label`, 
  COALESCE(
    `plugin.translation.description`, 
    `plugin.translation.description`
  ) as `plugin.description`, 
  COALESCE(
    `plugin.translation.manufacturerLink`, 
    `plugin.translation.manufacturerLink`
  ) as `plugin.manufacturerLink`, 
  COALESCE(
    `plugin.translation.supportLink`, 
    `plugin.translation.supportLink`
  ) as `plugin.supportLink`, 
  COALESCE(
    `plugin.translation.changelog`, 
    `plugin.translation.changelog`
  ) as `plugin.changelog`, 
  COALESCE(
    `plugin.translation.customFields`, 
    `plugin.translation.customFields`
  ) as `plugin.customFields` 
FROM 
  `plugin` 
  LEFT JOIN (
    SELECT 
      `plugin.translation`.plugin_id, 
      `plugin.translation`.label as `plugin.translation.label`, 
      `plugin.translation`.description as `plugin.translation.description`, 
      `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, 
      `plugin.translation`.support_link as `plugin.translation.supportLink`, 
      `plugin.translation`.changelog as `plugin.translation.changelog`, 
      `plugin.translation`.custom_fields as `plugin.translation.customFields`, 
      `plugin.translation`.created_at as `plugin.translation.createdAt`, 
      `plugin.translation`.updated_at as `plugin.translation.updatedAt`, 
      `plugin.translation`.plugin_id as `plugin.translation.pluginId`, 
      `plugin.translation`.language_id as `plugin.translation.languageId` 
    FROM 
      `plugin_translation` `plugin.translation` 
    WHERE 
      `plugin.translation`.language_id = : languageId
  ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` 
WHERE 
  (
    `plugin`.`active` <=> : param_4496a2bb907e4a9b89028f70fcce4525
  )

SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.plugin_translation`.*, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` <=> 0);

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 = :salesChannelId) AND (token = :token) 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 = 0xDD0A402C343F4561A6A2100CD5D17F74
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor;

# 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`.`created_at` as `sales_channel.currency.createdAt`, 
  `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, 
  `sales_channel.currency.currency_translation`.*, 
  COALESCE(
    `sales_channel.currency.translation.shortName`, 
    `sales_channel.currency.translation.shortName`
  ) as `sales_channel.currency.shortName`, 
  COALESCE(
    `sales_channel.currency.translation.name`, 
    `sales_channel.currency.translation.name`
  ) as `sales_channel.currency.name`, 
  COALESCE(
    `sales_channel.currency.translation.customFields`, 
    `sales_channel.currency.translation.customFields`
  ) as `sales_channel.currency.customFields`, 
  `sales_channel.sales_channel_translation`.*, 
  COALESCE(
    `sales_channel.translation.name`, 
    `sales_channel.translation.name`
  ) as `sales_channel.name`, 
  COALESCE(
    `sales_channel.translation.homeSlotConfig`, 
    `sales_channel.translation.homeSlotConfig`
  ) as `sales_channel.homeSlotConfig`, 
  COALESCE(
    `sales_channel.translation.homeEnabled`, 
    `sales_channel.translation.homeEnabled`
  ) as `sales_channel.homeEnabled`, 
  COALESCE(
    `sales_channel.translation.homeName`, 
    `sales_channel.translation.homeName`
  ) as `sales_channel.homeName`, 
  COALESCE(
    `sales_channel.translation.homeMetaTitle`, 
    `sales_channel.translation.homeMetaTitle`
  ) as `sales_channel.homeMetaTitle`, 
  COALESCE(
    `sales_channel.translation.homeMetaDescription`, 
    `sales_channel.translation.homeMetaDescription`
  ) as `sales_channel.homeMetaDescription`, 
  COALESCE(
    `sales_channel.translation.homeKeywords`, 
    `sales_channel.translation.homeKeywords`
  ) as `sales_channel.homeKeywords`, 
  COALESCE(
    `sales_channel.translation.customFields`, 
    `sales_channel.translation.customFields`
  ) as `sales_channel.customFields` 
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)

# 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`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.currency_translation`.*, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.sales_channel_translation`.*, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields` 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 (0xDD0A402C343F4561A6A2100CD5D17F74);

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

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

# 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`.`created_at` as `currency.createdAt`, 
  `currency`.`updated_at` as `currency.updatedAt`, 
  `currency.currency_translation`.*, 
  COALESCE(
    `currency.translation.shortName`, 
    `currency.translation.shortName`
  ) as `currency.shortName`, 
  COALESCE(
    `currency.translation.name`, `currency.translation.name`
  ) as `currency.name`, 
  COALESCE(
    `currency.translation.customFields`, 
    `currency.translation.customFields`
  ) as `currency.customFields` 
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)

# 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`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.currency_translation`.*, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, COALESCE(`currency.translation.name`,`currency.translation.name`) as `currency.name`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields` 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);

# context-factory::country::read
SELECT 
  `country`.`id` as `country.id`, 
  `country`.`iso` as `country.iso`, 
  `country`.`position` as `country.position`, 
  `country`.`tax_free` as `country.taxFree`, 
  `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_pattern` as `country.vatIdPattern`, 
  `country`.`created_at` as `country.createdAt`, 
  `country`.`updated_at` as `country.updatedAt`, 
  `country.country_translation`.*, 
  COALESCE(
    `country.translation.name`, `country.translation.name`
  ) as `country.name`, 
  COALESCE(
    `country.translation.customFields`, 
    `country.translation.customFields`
  ) as `country.customFields` 
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)

# context-factory::country::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`tax_free` as `country.taxFree`, `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_pattern` as `country.vatIdPattern`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.country_translation`.*, COALESCE(`country.translation.name`,`country.translation.name`) as `country.name`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) as `country.customFields` 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 (0x169AE87C8A5645529ACDCE8BA1AA8B9A);

# 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.customer_group_translation`.*, 
  COALESCE(
    `customer_group.translation.name`, 
    `customer_group.translation.name`
  ) as `customer_group.name`, 
  COALESCE(
    `customer_group.translation.registrationTitle`, 
    `customer_group.translation.registrationTitle`
  ) as `customer_group.registrationTitle`, 
  COALESCE(
    `customer_group.translation.registrationIntroduction`, 
    `customer_group.translation.registrationIntroduction`
  ) as `customer_group.registrationIntroduction`, 
  COALESCE(
    `customer_group.translation.registrationOnlyCompanyRegistration`, 
    `customer_group.translation.registrationOnlyCompanyRegistration`
  ) as `customer_group.registrationOnlyCompanyRegistration`, 
  COALESCE(
    `customer_group.translation.registrationSeoMetaDescription`, 
    `customer_group.translation.registrationSeoMetaDescription`
  ) as `customer_group.registrationSeoMetaDescription`, 
  COALESCE(
    `customer_group.translation.customFields`, 
    `customer_group.translation.customFields`
  ) as `customer_group.customFields` 
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)

# 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.customer_group_translation`.*, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields` 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);

# context-factory::taxes::search-ids
SELECT 
  `tax`.`id` 
FROM 
  `tax`

# context-factory::taxes::search-ids
SELECT `tax`.`id` FROM `tax`;

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

# 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` WHERE `tax`.`id` IN (0x85DC5806AA094E8AAEA9EEF9349841F8, 0x166379E52EED4DA6B505C5063EA1D2EA, 0x840CB49D20FC4FCC96EF8ADE7046667B);

# context-factory::taxes::association::rules::read
SELECT 
  `tax_rule`.`id` as `tax_rule.id`, 
  `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, 
  `tax_rule`.`country_id` as `tax_rule.countryId`, 
  `tax_rule`.`tax_rate` as `tax_rule.taxRate`, 
  `tax_rule`.`data` as `tax_rule.data`, 
  `tax_rule`.`tax_id` as `tax_rule.taxId`, 
  `tax_rule.type`.`id` as `tax_rule.type.id`, 
  `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, 
  `tax_rule.type`.`position` as `tax_rule.type.position`, 
  `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, 
  `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, 
  `tax_rule.type.tax_rule_type_translation`.*, 
  COALESCE(
    `tax_rule.type.translation.typeName`, 
    `tax_rule.type.translation.typeName`
  ) as `tax_rule.type.typeName`, 
  `tax_rule`.`created_at` as `tax_rule.createdAt`, 
  `tax_rule`.`updated_at` as `tax_rule.updatedAt` 
FROM 
  `tax_rule` 
  LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` 
  LEFT JOIN (
    SELECT 
      `tax_rule.type.translation`.tax_rule_type_id, 
      `tax_rule.type.translation`.type_name as `tax_rule.type.translation.typeName`, 
      `tax_rule.type.translation`.created_at as `tax_rule.type.translation.createdAt`, 
      `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, 
      `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, 
      `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId` 
    FROM 
      `tax_rule_type_translation` `tax_rule.type.translation` 
    WHERE 
      `tax_rule.type.translation`.language_id = : languageId
  ) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` 
WHERE 
  (
    `tax_rule`.`tax_id` IN (
      : param_d9a5359880bf4566a6b63b7680fcd58c
    )
  )

# context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.tax_rule_type_translation`.*, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.tax_rule_type_id, `tax_rule.type.translation`.type_name as `tax_rule.type.translation.typeName`, `tax_rule.type.translation`.created_at as `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (0x166379E52EED4DA6B505C5063EA1D2EA, 0x840CB49D20FC4FCC96EF8ADE7046667B, 0x85DC5806AA094E8AAEA9EEF9349841F8));