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_1590758953_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591683158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592837424_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593698606_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595160327_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595321666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595422169_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595489705_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595492052_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595492053_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595578253_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595919251_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596091744_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596441551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597391970_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597394241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597657689_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597762808_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597830237_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597930227_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598280548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598520424_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598885384_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599112309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599134496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599463278_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599570560_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599720163_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599806584_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599806595_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599822061_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600072779_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600156989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600253602_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600330846_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600338271_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600349343_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600676671_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600769357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600778848_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601451838_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601539530_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601543829_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601891339_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602062376_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602146868_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602153572_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602494493_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602494495_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602745374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602822727_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603179023_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603293043_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603970276_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604056363_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604056421_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604475913_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604499476_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604568928_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604669773_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605103533_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605530777_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605609309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605609477_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605861407_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606310257_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607415095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607500561_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607514878_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607581275_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607581276_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608624028_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609125144_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609140710_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609857999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610439375_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610448012_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610523204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610531188_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610904608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595492054_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604502151_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595492054_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604502151_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765935_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765936_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765937_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1536765938_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538046469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1538985581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1544535797_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1563456847_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564041870_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564053392_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568882317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1587476616_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589448383_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593494859_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593508853_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615794849_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644753635_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652444730_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669117848_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669796049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678106061_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1559416986_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602739765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604519670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604520733_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605031477_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612160298_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_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1678106061_IS_ACTIVE = TRUE;SET @MIGRATION_1559416986_IS_ACTIVE = TRUE;SET @MIGRATION_1602739765_IS_ACTIVE = TRUE;SET @MIGRATION_1604519670_IS_ACTIVE = TRUE;SET @MIGRATION_1604520733_IS_ACTIVE = TRUE;SET @MIGRATION_1605031477_IS_ACTIVE = TRUE;SET @MIGRATION_1612160298_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 = 0x0A197278A7514B78A06EA27EF27E9EF8 OR sales_channel_id IS NULL)) AND (seo_path_info = 'detail/fc39fae6444a42c68cbbc5f54e9901a4') 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 = 0x0A197278A7514B78A06EA27EF27E9EF8) AND (id != '') AND (path_info = '/detail/fc39fae6444a42c68cbbc5f54e9901a4') AND (is_canonical = 1) LIMIT 1;

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

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 
  LOWER(
    HEX(id)
  ) 
FROM 
  system_config 
WHERE 
  (
    sales_channel_id IS NULL 
    OR sales_channel_id = : salesChannelId
  ) 
  AND (configuration_key LIKE : prefix) 
ORDER BY 
  configuration_key ASC, 
  sales_channel_id ASC

SELECT LOWER(HEX(id)) FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY configuration_key ASC, 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 = :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, 
  currency.decimal_precision as sales_channel_currency_decimal_precision, 
  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,
          currency.decimal_precision as sales_channel_currency_decimal_precision,
          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 = 0x0A197278A7514B78A06EA27EF27E9EF8
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor;

# 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`.`decimal_precision` as `currency.decimalPrecision`, 
  `currency`.`position` as `currency.position`, 
  `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`.`decimal_precision` as `currency.decimalPrecision`, `currency`.`position` as `currency.position`, `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 (0xB6C3DEC937764317B087CAE72F3CFAE2);

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

#cart-persister::load
SELECT 
  `cart`.`cart` 
FROM 
  cart 
WHERE 
  `token` = : token

#cart-persister::load
            SELECT `cart`.`cart` FROM cart WHERE `token` = 'XNH1xj6biwPHYaxDSCm8oxQbRW2H6N3G';

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

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

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

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

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

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

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

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

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

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

# header::languages::search-ids
SELECT 
  `language`.`id` 
FROM 
  `language` 
  LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` 
  LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id` 
  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id` 
WHERE 
  (
    `language.salesChannelDomains`.`sales_channel_id` = : param_c7a5473a57bd45cfa077d4baa9f8ffec 
    AND `language.salesChannels`.`id` = : param_e94f1125e0ab498fb17a7e2f86519ed2
  ) 
GROUP BY 
  `language`.`id`

# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = 0x0A197278A7514B78A06EA27EF27E9EF8 AND `language.salesChannels`.`id` = 0x0A197278A7514B78A06EA27EF27E9EF8) GROUP BY `language`.`id`;

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

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

# navigation-route::meta-information
SELECT 
  LOWER(
    HEX(`id`)
  ), 
  `path`, 
  `level` 
FROM 
  `category` 
WHERE 
  `id` = : activeId 
  OR `parent_id` = : activeId 
  OR `id` = : rootId

# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = 0xA59628EC24EC4FBB992D74F4E5EB48E0 OR `parent_id` = 0xA59628EC24EC4FBB992D74F4E5EB48E0 OR `id` = 0xA59628EC24EC4FBB992D74F4E5EB48E0
        ;

# header::navigation::read
SELECT 
  `category`.`id` as `category.id`, 
  `category`.`version_id` as `category.versionId`, 
  `category`.`parent_id` as `category.parentId`, 
  `category`.`parent_version_id` as `category.parentVersionId`, 
  `category`.`after_category_id` as `category.afterCategoryId`, 
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`, 
  `category`.`media_id` as `category.mediaId`, 
  `category`.`display_nested_products` as `category.displayNestedProducts`, 
  `category`.`auto_increment` as `category.autoIncrement`, 
  `category`.`level` as `category.level`, 
  `category`.`path` as `category.path`, 
  `category`.`child_count` as `category.childCount`, 
  `category`.`type` as `category.type`, 
  `category`.`product_assignment_type` as `category.productAssignmentType`, 
  `category`.`visible` as `category.visible`, 
  `category`.`active` as `category.active`, 
  `category`.`cms_page_id` as `category.cmsPageId`, 
  `category`.`product_stream_id` as `category.productStreamId`, 
  `category`.`created_at` as `category.createdAt`, 
  `category`.`updated_at` as `category.updatedAt`, 
  `category.media`.`id` as `category.media.id`, 
  `category.media`.`user_id` as `category.media.userId`, 
  `category.media`.`media_folder_id` as `category.media.mediaFolderId`, 
  `category.media`.`mime_type` as `category.media.mimeType`, 
  `category.media`.`file_extension` as `category.media.fileExtension`, 
  `category.media`.`uploaded_at` as `category.media.uploadedAt`, 
  `category.media`.`file_name` as `category.media.fileName`, 
  `category.media`.`file_size` as `category.media.fileSize`, 
  `category.media`.`media_type` as `category.media.mediaTypeRaw`, 
  `category.media`.`meta_data` as `category.media.metaData`, 
  `category.media`.`private` as `category.media.private`, 
  `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, 
  `category.media`.`created_at` as `category.media.createdAt`, 
  `category.media`.`updated_at` as `category.media.updatedAt`, 
  `category.media.media_translation`.*, 
  COALESCE(
    `category.media.translation.title`, 
    `category.media.translation.title`
  ) as `category.media.title`, 
  COALESCE(
    `category.media.translation.alt`, 
    `category.media.translation.alt`
  ) as `category.media.alt`, 
  COALESCE(
    `category.media.translation.customFields`, 
    `category.media.translation.customFields`
  ) as `category.media.customFields`, 
  `category.category_translation`.*, 
  COALESCE(
    `category.translation.name`, `category.translation.name`
  ) as `category.name`, 
  COALESCE(
    `category.translation.breadcrumb`, 
    `category.translation.breadcrumb`
  ) as `category.breadcrumb`, 
  COALESCE(
    `category.translation.slotConfig`, 
    `category.translation.slotConfig`
  ) as `category.slotConfig`, 
  COALESCE(
    `category.translation.externalLink`, 
    `category.translation.externalLink`
  ) as `category.externalLink`, 
  COALESCE(
    `category.translation.description`, 
    `category.translation.description`
  ) as `category.description`, 
  COALESCE(
    `category.translation.metaTitle`, 
    `category.translation.metaTitle`
  ) as `category.metaTitle`, 
  COALESCE(
    `category.translation.metaDescription`, 
    `category.translation.metaDescription`
  ) as `category.metaDescription`, 
  COALESCE(
    `category.translation.keywords`, 
    `category.translation.keywords`
  ) as `category.keywords`, 
  COALESCE(
    `category.translation.customFields`, 
    `category.translation.customFields`
  ) as `category.customFields` 
FROM 
  `category` 
  LEFT JOIN (
    SELECT 
      `category.translation`.category_id, 
      `category.translation`.name as `category.translation.name`, 
      `category.translation`.breadcrumb as `category.translation.breadcrumb`, 
      `category.translation`.slot_config as `category.translation.slotConfig`, 
      `category.translation`.external_link as `category.translation.externalLink`, 
      `category.translation`.description as `category.translation.description`, 
      `category.translation`.meta_title as `category.translation.metaTitle`, 
      `category.translation`.meta_description as `category.translation.metaDescription`, 
      `category.translation`.keywords as `category.translation.keywords`, 
      `category.translation`.custom_fields as `category.translation.customFields`, 
      `category.translation`.created_at as `category.translation.createdAt`, 
      `category.translation`.updated_at as `category.translation.updatedAt`, 
      `category.translation`.category_id as `category.translation.categoryId`, 
      `category.translation`.language_id as `category.translation.languageId`, 
      `category.translation`.category_version_id as `category.translation.categoryVersionId` 
    FROM 
      `category_translation` `category.translation` 
    WHERE 
      `category.translation`.language_id = : languageId
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` 
  LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` 
  LEFT JOIN (
    SELECT 
      `category.media.translation`.media_id, 
      `category.media.translation`.title as `category.media.translation.title`, 
      `category.media.translation`.alt as `category.media.translation.alt`, 
      `category.media.translation`.custom_fields as `category.media.translation.customFields`, 
      `category.media.translation`.created_at as `category.media.translation.createdAt`, 
      `category.media.translation`.updated_at as `category.media.translation.updatedAt`, 
      `category.media.translation`.media_id as `category.media.translation.mediaId`, 
      `category.media.translation`.language_id as `category.media.translation.languageId` 
    FROM 
      `media_translation` `category.media.translation` 
    WHERE 
      `category.media.translation`.language_id = : languageId
  ) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` 
WHERE 
  (
    `category`.`version_id` = : version
  ) 
  AND (
    (
      `category`.`path` LIKE : param_19f839d291e545e2ab839e94a4fecc5e 
      AND (
        `category`.`level` > : param_2c3e243a56ac4772a435a16f75c0273f 
        AND `category`.`level` <= : param_7adb700e819d44a494c3a7cfcc688812
      )
    )
  )