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 
  `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_9695960adf1a436f8aa61706470ed9f2
  )

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` = '53NrVpCWn6hocquN2E9hCJZ0IEyKv3M0';

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;

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

# 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` = 0xC4122D9E221E4EFA8576F3DCFE12D60C OR `parent_id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C OR `id` = 0xC4122D9E221E4EFA8576F3DCFE12D60C
        ;

# 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` = 0xC4122D9E221E4EFA8576F3DCFE12D60C
        ;

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

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

# product-listing-loader::resolve-previews
SELECT 
  parent.configurator_group_config, 
  LOWER(
    HEX(parent.main_variant_id)
  ) as mainVariantId, 
  LOWER(
    HEX(child.id)
  ) as id 
FROM 
  product as child 
  INNER JOIN product as parent ON parent.id = child.parent_id 
  AND parent.version_id = child.version_id 
WHERE 
  child.version_id = : version 
  AND child.id IN (: ids)

# product-listing-loader::resolve-previews
            SELECT parent.configurator_group_config,
                        LOWER(HEX(parent.main_variant_id)) as mainVariantId,
                        LOWER(HEX(child.id)) as id
             FROM product as child
                INNER JOIN product as parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425
             AND child.id IN (0x328D2EFA0B8541A2B53DE621789D1D99);

# cms::product-listing::read
SELECT 
  `product`.`id` as `product.id`, 
  `product`.`version_id` as `product.versionId`, 
  `product`.`parent_id` as `product.parentId`, 
  `product`.`parent_version_id` as `product.parentVersionId`, 
  COALESCE(
    `product`.`product_manufacturer_id`, 
    `product.parent`.`product_manufacturer_id`
  ) as `product.manufacturerId`, 
  COALESCE(
    `product`.`product_manufacturer_version_id`, 
    `product.parent`.`product_manufacturer_version_id`
  ) as `product.productManufacturerVersionId`, 
  COALESCE(
    `product`.`unit_id`, `product.parent`.`unit_id`
  ) as `product.unitId`, 
  COALESCE(
    `product`.`tax_id`, `product.parent`.`tax_id`
  ) as `product.taxId`, 
  COALESCE(
    `product`.`product_media_id`, `product.parent`.`product_media_id`
  ) as `product.coverId`, 
  COALESCE(
    `product`.`product_media_version_id`, 
    `product.parent`.`product_media_version_id`
  ) as `product.productMediaVersionId`, 
  COALESCE(
    `product`.`delivery_time_id`, `product.parent`.`delivery_time_id`
  ) as `product.deliveryTimeId`, 
  `product.parent`.`price` as `product.price.inherited`, 
  COALESCE(
    `product`.`price`, `product.parent`.`price`
  ) as `product.price`, 
  `product`.`product_number` as `product.productNumber`, 
  `product`.`stock` as `product.stock`, 
  COALESCE(
    `product`.`restock_time`, `product.parent`.`restock_time`
  ) as `product.restockTime`, 
  `product`.`auto_increment` as `product.autoIncrement`, 
  COALESCE(
    `product`.`active`, `product.parent`.`active`
  ) as `product.active`, 
  `product`.`available_stock` as `product.availableStock`, 
  `product`.`available` as `product.available`, 
  COALESCE(
    `product`.`is_closeout`, `product.parent`.`is_closeout`
  ) as `product.isCloseout`, 
  `product`.`display_group` as `product.displayGroup`, 
  `product.parent`.`configurator_group_config` as `product.configuratorGroupConfig.inherited`, 
  COALESCE(
    `product`.`configurator_group_config`, 
    `product.parent`.`configurator_group_config`
  ) as `product.configuratorGroupConfig`, 
  COALESCE(
    `product`.`main_variant_id`, `product.parent`.`main_variant_id`
  ) as `product.mainVariantId`, 
  `product`.`variant_restrictions` as `product.variantRestrictions`, 
  COALESCE(
    `product`.`manufacturer_number`, 
    `product.parent`.`manufacturer_number`
  ) as `product.manufacturerNumber`, 
  COALESCE(
    `product`.`ean`, `product.parent`.`ean`
  ) as `product.ean`, 
  COALESCE(
    `product`.`purchase_steps`, `product.parent`.`purchase_steps`
  ) as `product.purchaseSteps`, 
  COALESCE(
    `product`.`max_purchase`, `product.parent`.`max_purchase`
  ) as `product.maxPurchase`, 
  COALESCE(
    `product`.`min_purchase`, `product.parent`.`min_purchase`
  ) as `product.minPurchase`, 
  COALESCE(
    `product`.`purchase_unit`, `product.parent`.`purchase_unit`
  ) as `product.purchaseUnit`, 
  COALESCE(
    `product`.`reference_unit`, `product.parent`.`reference_unit`
  ) as `product.referenceUnit`, 
  COALESCE(
    `product`.`shipping_free`, `product.parent`.`shipping_free`
  ) as `product.shippingFree`, 
  COALESCE(
    `product`.`purchase_price`, `product.parent`.`purchase_price`
  ) as `product.purchasePrice`, 
  COALESCE(
    `product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`
  ) as `product.markAsTopseller`, 
  COALESCE(
    `product`.`weight`, `product.parent`.`weight`
  ) as `product.weight`, 
  COALESCE(
    `product`.`width`, `product.parent`.`width`
  ) as `product.width`, 
  COALESCE(
    `product`.`height`, `product.parent`.`height`
  ) as `product.height`, 
  COALESCE(
    `product`.`length`, `product.parent`.`length`
  ) as `product.length`, 
  COALESCE(
    `product`.`release_date`, `product.parent`.`release_date`
  ) as `product.releaseDate`, 
  COALESCE(
    `product`.`rating_average`, `product.parent`.`rating_average`
  ) as `product.ratingAverage`, 
  `product.parent`.`category_tree` as `product.categoryTree.inherited`, 
  COALESCE(
    `product`.`category_tree`, `product.parent`.`category_tree`
  ) as `product.categoryTree`, 
  `product.parent`.`property_ids` as `product.propertyIds.inherited`, 
  COALESCE(
    `product`.`property_ids`, `product.parent`.`property_ids`
  ) as `product.propertyIds`, 
  `product.parent`.`option_ids` as `product.optionIds.inherited`, 
  COALESCE(
    `product`.`option_ids`, `product.parent`.`option_ids`
  ) as `product.optionIds`, 
  `product.parent`.`tag_ids` as `product.tagIds.inherited`, 
  COALESCE(
    `product`.`tag_ids`, `product.parent`.`tag_ids`
  ) as `product.tagIds`, 
  `product.parent`.`listing_prices` as `product.listingPrices.inherited`, 
  COALESCE(
    `product`.`listing_prices`, `product.parent`.`listing_prices`
  ) as `product.listingPrices`, 
  `product`.`child_count` as `product.childCount`, 
  `product.parent`.`blacklist_ids` as `product.blacklistIds.inherited`, 
  COALESCE(
    `product`.`blacklist_ids`, `product.parent`.`blacklist_ids`
  ) as `product.blacklistIds`, 
  `product.parent`.`whitelist_ids` as `product.whitelistIds.inherited`, 
  COALESCE(
    `product`.`whitelist_ids`, `product.parent`.`whitelist_ids`
  ) as `product.whitelistIds`, 
  COALESCE(
    `product`.`custom_field_set_selection_active`, 
    `product.parent`.`custom_field_set_selection_active`
  ) as `product.customFieldSetSelectionActive`, 
  `product`.`sales` as `product.sales`, 
  `product.tax`.`id` as `product.tax.id`, 
  `product.tax`.`tax_rate` as `product.tax.taxRate`, 
  `product.tax`.`name` as `product.tax.name`, 
  `product.tax`.`custom_fields` as `product.tax.customFields`, 
  `product.tax`.`created_at` as `product.tax.createdAt`, 
  `product.tax`.`updated_at` as `product.tax.updatedAt`, 
  COALESCE(
    `product`.`product_feature_set_id`, 
    `product.parent`.`product_feature_set_id`
  ) as `product.featureSetId`, 
  `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, 
  COALESCE(
    `product`.`purchase_prices`, `product.parent`.`purchase_prices`
  ) as `product.purchasePrices`, 
  COALESCE(
    `product`.`canonical_product_id`, 
    `product.parent`.`canonical_product_id`
  ) as `product.canonicalProductId`, 
  `product`.`created_at` as `product.createdAt`, 
  `product`.`updated_at` as `product.updatedAt`, 
  (
    SELECT 
      GROUP_CONCAT(
        HEX(
          `product.options.mapping`.`property_group_option_id`
        ) SEPARATOR '||'
      ) 
    FROM 
      `product_option` `product.options.mapping` 
    WHERE 
      `product.options.mapping`.`product_id` = `product`.`id`
  ) as `product.options.id_mapping`, 
  `product.manufacturer`.`id` as `product.manufacturer.id`, 
  `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, 
  `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, 
  `product.manufacturer`.`link` as `product.manufacturer.link`, 
  `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, 
  `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, 
  `product.manufacturer.product_manufacturer_translation`.*, 
  COALESCE(
    `product.manufacturer.translation.name`, 
    `product.manufacturer.translation.name`
  ) as `product.manufacturer.name`, 
  COALESCE(
    `product.manufacturer.translation.description`, 
    `product.manufacturer.translation.description`
  ) as `product.manufacturer.description`, 
  COALESCE(
    `product.manufacturer.translation.customFields`, 
    `product.manufacturer.translation.customFields`
  ) as `product.manufacturer.customFields`, 
  `product.unit`.`id` as `product.unit.id`, 
  `product.unit`.`created_at` as `product.unit.createdAt`, 
  `product.unit`.`updated_at` as `product.unit.updatedAt`, 
  `product.unit.unit_translation`.*, 
  COALESCE(
    `product.unit.translation.shortCode`, 
    `product.unit.translation.shortCode`
  ) as `product.unit.shortCode`, 
  COALESCE(
    `product.unit.translation.name`, 
    `product.unit.translation.name`
  ) as `product.unit.name`, 
  COALESCE(
    `product.unit.translation.customFields`, 
    `product.unit.translation.customFields`
  ) as `product.unit.customFields`, 
  `product.deliveryTime`.`id` as `product.deliveryTime.id`, 
  `product.deliveryTime`.`min` as `product.deliveryTime.min`, 
  `product.deliveryTime`.`max` as `product.deliveryTime.max`, 
  `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, 
  `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, 
  `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, 
  `product.deliveryTime.delivery_time_translation`.*, 
  COALESCE(
    `product.deliveryTime.translation.name`, 
    `product.deliveryTime.translation.name`
  ) as `product.deliveryTime.name`, 
  COALESCE(
    `product.deliveryTime.translation.customFields`, 
    `product.deliveryTime.translation.customFields`
  ) as `product.deliveryTime.customFields`, 
  `product.cover`.`id` as `product.cover.id`, 
  `product.cover`.`version_id` as `product.cover.versionId`, 
  `product.cover`.`product_id` as `product.cover.productId`, 
  `product.cover`.`product_version_id` as `product.cover.productVersionId`, 
  `product.cover`.`media_id` as `product.cover.mediaId`, 
  `product.cover`.`position` as `product.cover.position`, 
  `product.cover.media`.`id` as `product.cover.media.id`, 
  `product.cover.media`.`user_id` as `product.cover.media.userId`, 
  `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, 
  `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, 
  `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, 
  `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, 
  `product.cover.media`.`file_name` as `product.cover.media.fileName`, 
  `product.cover.media`.`file_size` as `product.cover.media.fileSize`, 
  `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, 
  `product.cover.media`.`meta_data` as `product.cover.media.metaData`, 
  `product.cover.media`.`private` as `product.cover.media.private`, 
  `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, 
  `product.cover.media`.`created_at` as `product.cover.media.createdAt`, 
  `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, 
  `product.cover.media.media_translation`.*, 
  COALESCE(
    `product.cover.media.translation.title`, 
    `product.cover.media.translation.title`
  ) as `product.cover.media.title`, 
  COALESCE(
    `product.cover.media.translation.alt`, 
    `product.cover.media.translation.alt`
  ) as `product.cover.media.alt`, 
  COALESCE(
    `product.cover.media.translation.customFields`, 
    `product.cover.media.translation.customFields`
  ) as `product.cover.media.customFields`, 
  `product.cover`.`custom_fields` as `product.cover.customFields`, 
  `product.cover`.`created_at` as `product.cover.createdAt`, 
  `product.cover`.`updated_at` as `product.cover.updatedAt`, 
  `product.product_translation`.*, 
  `product.product_translation.parent`.*, 
  COALESCE(
    `product.translation.metaDescription`, 
    `product.parent.translation.metaDescription`, 
    `product.translation.metaDescription`
  ) as `product.metaDescription`, 
  COALESCE(
    `product.translation.name`, `product.parent.translation.name`, 
    `product.translation.name`
  ) as `product.name`, 
  COALESCE(
    `product.translation.keywords`, 
    `product.parent.translation.keywords`, 
    `product.translation.keywords`
  ) as `product.keywords`, 
  COALESCE(
    `product.translation.description`, 
    `product.parent.translation.description`, 
    `product.translation.description`
  ) as `product.description`, 
  COALESCE(
    `product.translation.metaTitle`, 
    `product.parent.translation.metaTitle`, 
    `product.translation.metaTitle`
  ) as `product.metaTitle`, 
  COALESCE(
    `product.translation.packUnit`, 
    `product.parent.translation.packUnit`, 
    `product.translation.packUnit`
  ) as `product.packUnit`, 
  COALESCE(
    `product.translation.packUnitPlural`, 
    `product.parent.translation.packUnitPlural`, 
    `product.translation.packUnitPlural`
  ) as `product.packUnitPlural`, 
  COALESCE(
    `product.translation.customSearchKeywords`, 
    `product.parent.translation.customSearchKeywords`, 
    `product.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`, 
  COALESCE(
    `product.translation.customFields`, 
    `product.parent.translation.customFields`, 
    `product.translation.customFields`
  ) as `product.customFields` 
FROM 
  `product` 
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` 
  AND `product`.`version_id` = `product.parent`.`version_id` 
  LEFT JOIN (
    SELECT 
      `product.translation`.product_id, 
      `product.translation`.meta_description as `product.translation.metaDescription`, 
      `product.translation`.name as `product.translation.name`, 
      `product.translation`.keywords as `product.translation.keywords`, 
      `product.translation`.description as `product.translation.description`, 
      `product.translation`.meta_title as `product.translation.metaTitle`, 
      `product.translation`.pack_unit as `product.translation.packUnit`, 
      `product.translation`.pack_unit_plural as `product.translation.packUnitPlural`, 
      `product.translation`.custom_search_keywords as `product.translation.customSearchKeywords`, 
      `product.translation`.custom_fields as `product.translation.customFields`, 
      `product.translation`.created_at as `product.translation.createdAt`, 
      `product.translation`.updated_at as `product.translation.updatedAt`, 
      `product.translation`.product_id as `product.translation.productId`, 
      `product.translation`.language_id as `product.translation.languageId`, 
      `product.translation`.product_version_id as `product.translation.productVersionId` 
    FROM 
      `product_translation` `product.translation` 
    WHERE 
      `product.translation`.language_id = : languageId
  ) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` 
  LEFT JOIN (
    SELECT 
      `product.parent.translation`.product_id, 
      `product.parent.translation`.meta_description as `product.parent.translation.metaDescription`, 
      `product.parent.translation`.name as `product.parent.translation.name`, 
      `product.parent.translation`.keywords as `product.parent.translation.keywords`, 
      `product.parent.translation`.description as `product.parent.translation.description`, 
      `product.parent.translation`.meta_title as `product.parent.translation.metaTitle`, 
      `product.parent.translation`.pack_unit as `product.parent.translation.packUnit`, 
      `product.parent.translation`.pack_unit_plural as `product.parent.translation.packUnitPlural`, 
      `product.parent.translation`.custom_search_keywords as `product.parent.translation.customSearchKeywords`, 
      `product.parent.translation`.custom_fields as `product.parent.translation.customFields`, 
      `product.parent.translation`.created_at as `product.parent.translation.createdAt`, 
      `product.parent.translation`.updated_at as `product.parent.translation.updatedAt`, 
      `product.parent.translation`.product_id as `product.parent.translation.productId`, 
      `product.parent.translation`.language_id as `product.parent.translation.languageId`, 
      `product.parent.translation`.product_version_id as `product.parent.translation.productVersionId` 
    FROM 
      `product_translation` `product.parent.translation` 
    WHERE 
      `product.parent.translation`.language_id = : languageId
  ) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` 
  LEFT JOIN `tax` `product.tax` ON IFNULL(
    `product`.`tax_id`, `product.parent`.`tax_id`
  ) = `product.tax`.`id` 
  LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` 
  AND `product`.`version_id` = `product.manufacturer`.`version_id` 
  LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` 
  LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` 
  LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` 
  AND `product`.`version_id` = `product.cover`.`version_id` 
  LEFT JOIN (
    SELECT 
      `product.manufacturer.translation`.product_manufacturer_id, 
      `product.manufacturer.translation`.name as `product.manufacturer.translation.name`, 
      `product.manufacturer.translation`.description as `product.manufacturer.translation.description`, 
      `product.manufacturer.translation`.custom_fields as `product.manufacturer.translation.customFields`, 
      `product.manufacturer.translation`.created_at as `product.manufacturer.translation.createdAt`, 
      `product.manufacturer.translation`.updated_at as `product.manufacturer.translation.updatedAt`, 
      `product.manufacturer.translation`.product_manufacturer_id as `product.manufacturer.translation.productManufacturerId`, 
      `product.manufacturer.translation`.language_id as `product.manufacturer.translation.languageId`, 
      `product.manufacturer.translation`.product_manufacturer_version_id as `product.manufacturer.translation.productManufacturerVersionId` 
    FROM 
      `product_manufacturer_translation` `product.manufacturer.translation` 
    WHERE 
      `product.manufacturer.translation`.language_id = : languageId
  ) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` 
  LEFT JOIN (
    SELECT 
      `product.unit.translation`.unit_id, 
      `product.unit.translation`.short_code as `product.unit.translation.shortCode`, 
      `product.unit.translation`.name as `product.unit.translation.name`, 
      `product.unit.translation`.custom_fields as `product.unit.translation.customFields`, 
      `product.unit.translation`.created_at as `product.unit.translation.createdAt`, 
      `product.unit.translation`.updated_at as `product.unit.translation.updatedAt`, 
      `product.unit.translation`.unit_id as `product.unit.translation.unitId`, 
      `product.unit.translation`.language_id as `product.unit.translation.languageId` 
    FROM 
      `unit_translation` `product.unit.translation` 
    WHERE 
      `product.unit.translation`.language_id = : languageId
  ) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` 
  LEFT JOIN (
    SELECT 
      `product.deliveryTime.translation`.delivery_time_id, 
      `product.deliveryTime.translation`.name as `product.deliveryTime.translation.name`, 
      `product.deliveryTime.translation`.custom_fields as `product.deliveryTime.translation.customFields`, 
      `product.deliveryTime.translation`.created_at as `product.deliveryTime.translation.createdAt`, 
      `product.deliveryTime.translation`.updated_at as `product.deliveryTime.translation.updatedAt`, 
      `product.deliveryTime.translation`.delivery_time_id as `product.deliveryTime.translation.deliveryTimeId`, 
      `product.deliveryTime.translation`.language_id as `product.deliveryTime.translation.languageId` 
    FROM 
      `delivery_time_translation` `product.deliveryTime.translation` 
    WHERE 
      `product.deliveryTime.translation`.language_id = : languageId
  ) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` 
  LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` 
  LEFT JOIN (
    SELECT 
      `product.cover.media.translation`.media_id, 
      `product.cover.media.translation`.title as `product.cover.media.translation.title`, 
      `product.cover.media.translation`.alt as `product.cover.media.translation.alt`, 
      `product.cover.media.translation`.custom_fields as `product.cover.media.translation.customFields`, 
      `product.cover.media.translation`.created_at as `product.cover.media.translation.createdAt`, 
      `product.cover.media.translation`.updated_at as `product.cover.media.translation.updatedAt`, 
      `product.cover.media.translation`.media_id as `product.cover.media.translation.mediaId`, 
      `product.cover.media.translation`.language_id as `product.cover.media.translation.languageId` 
    FROM 
      `media_translation` `product.cover.media.translation` 
    WHERE 
      `product.cover.media.translation`.language_id = : languageId
  ) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` 
WHERE 
  (
    `product`.`version_id` = : version
  ) 
  AND (
    NOT IFNULL(
      `product`.`blacklist_ids`, `product.parent`.`blacklist_ids`
    ) REGEXP : rules 
    OR IFNULL(
      `product`.`blacklist_ids`, `product.parent`.`blacklist_ids`
    ) IS NULL
  ) 
  AND (
    IFNULL(
      `product`.`whitelist_ids`, `product.parent`.`whitelist_ids`
    ) REGEXP : rules 
    OR IFNULL(
      `product`.`whitelist_ids`, `product.parent`.`whitelist_ids`
    ) IS NULL
  ) 
  AND (
    `product`.`id` IN (: ids)
  )