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;

# 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 = 'All/') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC 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_443b0eeda0fe4c9da1fc7696fae1917f
  )

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;

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

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

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 
  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_4fe346b9172945bba180509570e6ed9b 
    AND `language.salesChannels`.`id` = : param_fa1d002f65ac41b79f554565a768218a
  ) 
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` = 0x6E3EFF42952A4A2E82BCEBE949BE0D92 OR `parent_id` = 0x6E3EFF42952A4A2E82BCEBE949BE0D92 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_b3d0754872d24c6783da9664dc86de53 
      AND (
        `category`.`level` > : param_b56d7a3024704badbb78cfa8dd14ad82 
        AND `category`.`level` <= : param_41fff080e521459ebfb9948b1466dc46
      )
    )
  )

# 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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`category`.`path` LIKE '%|a59628ec24ec4fbb992d74f4e5eb48e0|%' AND (`category`.`level` > 1 AND `category`.`level` <= 4)));

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

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

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