Symfony Profiler

# cache-id-loader
SELECT 
  `value` 
FROM 
  app_config 
WHERE 
  `key` = : key

# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = 'cache-id';

# dbal-plugin-loader
SELECT 
  `name`, 
  `base_class` AS baseClass, 
  IF(
    `active` = 1 
    AND `installed_at` IS NOT NULL, 
    1, 
    0
  ) AS active, 
  `path`, 
  `version`, 
  `autoload`, 
  `managed_by_composer` AS managedByComposer, 
  composer_name as composerName 
FROM 
  `plugin` 
ORDER BY 
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

SELECT 
  custom_entity.name, 
  custom_entity.fields 
FROM 
  custom_entity 
  LEFT JOIN app ON app.id = custom_entity.app_id 
WHERE 
  custom_entity.app_id IS NULL 
  OR app.active = 1

SELECT custom_entity.name, custom_entity.fields 
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE custom_entity.app_id IS NULL OR app.active = 1
            ;

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_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625583619_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650620993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655730949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657027979_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660814397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661759290_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661771388_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1734024000_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1734024001_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589269830_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589281912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603356522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604578601_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606394249_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620630192_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690180189_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690189187_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624512389_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624515124_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624516627_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1557926559_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1561379069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1562097986_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580996279_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625137302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625137302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637576753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638289341_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639050658_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666770470_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1686568861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1686568862_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600527479_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636736427_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636822268_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638026602_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639584421_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666904785_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675269069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676031371_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676669876_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629959675_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612967598_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600180419_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605561698_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607420606_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607594410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610545372_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610546810_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612348251_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612349225_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618477128_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618908395_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622727012_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627480654_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635833269_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635933836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641807793_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642672309_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642677128_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643793251_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643882897_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643967311_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643978336_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644390343_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1644417146_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649838631_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650617469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652793319_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655122661_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655820818_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657109285_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657551682_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657696369_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657894788_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658137202_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667808695_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1668686939_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669286069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669813114_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1670257605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672933403_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1674131867_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1674817916_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675187844_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1676380827_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678888534_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1680679403_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681477256_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690879180_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1696840505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1704460866_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1706090612_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1710142915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661973639_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681384784_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636035523_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638198234_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642069886_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648479594_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655465641_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657094602_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657194681_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660674250_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662982201_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664455177_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672738904_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1674728182_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1679060113_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1680008139_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1687164459_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1697826882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586273_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1578586333_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666208_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1585666268_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834145_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592834205_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591711027_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656139664_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656139665_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669562787_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669562788_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669562789_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669562790_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571303196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1575555505_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582193703_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1591277478_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1603289196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608533666_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614761861_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617969653_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645171819_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572516630_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608027541_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614589470_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621937029_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643985460_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654223780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659962090_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1666007247_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675941088_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1678198528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1679899712_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606161592_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631562038_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677008121_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572257501_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1606378923_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607952506_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1608034991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612945522_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620808652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631192197_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1677050041_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1682496975_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1684135126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1684309102_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1698047116_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1709034389_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_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1734024000_IS_ACTIVE = TRUE;SET @MIGRATION_1734024001_IS_ACTIVE = TRUE;SET @MIGRATION_1589269830_IS_ACTIVE = TRUE;SET @MIGRATION_1589281912_IS_ACTIVE = TRUE;SET @MIGRATION_1603356522_IS_ACTIVE = TRUE;SET @MIGRATION_1604578601_IS_ACTIVE = TRUE;SET @MIGRATION_1606394249_IS_ACTIVE = TRUE;SET @MIGRATION_1620630192_IS_ACTIVE = TRUE;SET @MIGRATION_1690180189_IS_ACTIVE = TRUE;SET @MIGRATION_1690189187_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1557926559_IS_ACTIVE = TRUE;SET @MIGRATION_1561379069_IS_ACTIVE = TRUE;SET @MIGRATION_1562097986_IS_ACTIVE = TRUE;SET @MIGRATION_1580996279_IS_ACTIVE = TRUE;SET @MIGRATION_1625137302_IS_ACTIVE = TRUE;SET @MIGRATION_1625137302_IS_ACTIVE = TRUE;SET @MIGRATION_1637576753_IS_ACTIVE = TRUE;SET @MIGRATION_1638289341_IS_ACTIVE = TRUE;SET @MIGRATION_1639050658_IS_ACTIVE = TRUE;SET @MIGRATION_1666770470_IS_ACTIVE = TRUE;SET @MIGRATION_1686568861_IS_ACTIVE = TRUE;SET @MIGRATION_1686568862_IS_ACTIVE = TRUE;SET @MIGRATION_1600527479_IS_ACTIVE = TRUE;SET @MIGRATION_1636736427_IS_ACTIVE = TRUE;SET @MIGRATION_1636822268_IS_ACTIVE = TRUE;SET @MIGRATION_1638026602_IS_ACTIVE = TRUE;SET @MIGRATION_1639584421_IS_ACTIVE = TRUE;SET @MIGRATION_1666904785_IS_ACTIVE = TRUE;SET @MIGRATION_1675269069_IS_ACTIVE = TRUE;SET @MIGRATION_1676031371_IS_ACTIVE = TRUE;SET @MIGRATION_1676669876_IS_ACTIVE = TRUE;SET @MIGRATION_1629959675_IS_ACTIVE = TRUE;SET @MIGRATION_1612967598_IS_ACTIVE = TRUE;SET @MIGRATION_1600180419_IS_ACTIVE = TRUE;SET @MIGRATION_1605561698_IS_ACTIVE = TRUE;SET @MIGRATION_1607420606_IS_ACTIVE = TRUE;SET @MIGRATION_1607594410_IS_ACTIVE = TRUE;SET @MIGRATION_1610545372_IS_ACTIVE = TRUE;SET @MIGRATION_1610546810_IS_ACTIVE = TRUE;SET @MIGRATION_1612348251_IS_ACTIVE = TRUE;SET @MIGRATION_1612349225_IS_ACTIVE = TRUE;SET @MIGRATION_1618477128_IS_ACTIVE = TRUE;SET @MIGRATION_1618908395_IS_ACTIVE = TRUE;SET @MIGRATION_1622727012_IS_ACTIVE = TRUE;SET @MIGRATION_1627480654_IS_ACTIVE = TRUE;SET @MIGRATION_1635833269_IS_ACTIVE = TRUE;SET @MIGRATION_1635933836_IS_ACTIVE = TRUE;SET @MIGRATION_1641807793_IS_ACTIVE = TRUE;SET @MIGRATION_1642672309_IS_ACTIVE = TRUE;SET @MIGRATION_1642677128_IS_ACTIVE = TRUE;SET @MIGRATION_1643793251_IS_ACTIVE = TRUE;SET @MIGRATION_1643882897_IS_ACTIVE = TRUE;SET @MIGRATION_1643967311_IS_ACTIVE = TRUE;SET @MIGRATION_1643978336_IS_ACTIVE = TRUE;SET @MIGRATION_1644390343_IS_ACTIVE = TRUE;SET @MIGRATION_1644417146_IS_ACTIVE = TRUE;SET @MIGRATION_1649838631_IS_ACTIVE = TRUE;SET @MIGRATION_1650617469_IS_ACTIVE = TRUE;SET @MIGRATION_1652793319_IS_ACTIVE = TRUE;SET @MIGRATION_1655122661_IS_ACTIVE = TRUE;SET @MIGRATION_1655820818_IS_ACTIVE = TRUE;SET @MIGRATION_1657109285_IS_ACTIVE = TRUE;SET @MIGRATION_1657551682_IS_ACTIVE = TRUE;SET @MIGRATION_1657696369_IS_ACTIVE = TRUE;SET @MIGRATION_1657894788_IS_ACTIVE = TRUE;SET @MIGRATION_1658137202_IS_ACTIVE = TRUE;SET @MIGRATION_1667808695_IS_ACTIVE = TRUE;SET @MIGRATION_1668686939_IS_ACTIVE = TRUE;SET @MIGRATION_1669286069_IS_ACTIVE = TRUE;SET @MIGRATION_1669813114_IS_ACTIVE = TRUE;SET @MIGRATION_1670257605_IS_ACTIVE = TRUE;SET @MIGRATION_1672933403_IS_ACTIVE = TRUE;SET @MIGRATION_1674131867_IS_ACTIVE = TRUE;SET @MIGRATION_1674817916_IS_ACTIVE = TRUE;SET @MIGRATION_1675187844_IS_ACTIVE = TRUE;SET @MIGRATION_1676380827_IS_ACTIVE = TRUE;SET @MIGRATION_1678888534_IS_ACTIVE = TRUE;SET @MIGRATION_1680679403_IS_ACTIVE = TRUE;SET @MIGRATION_1681477256_IS_ACTIVE = TRUE;SET @MIGRATION_1690879180_IS_ACTIVE = TRUE;SET @MIGRATION_1696840505_IS_ACTIVE = TRUE;SET @MIGRATION_1704460866_IS_ACTIVE = TRUE;SET @MIGRATION_1706090612_IS_ACTIVE = TRUE;SET @MIGRATION_1710142915_IS_ACTIVE = TRUE;SET @MIGRATION_1661973639_IS_ACTIVE = TRUE;SET @MIGRATION_1681384784_IS_ACTIVE = TRUE;SET @MIGRATION_1636035523_IS_ACTIVE = TRUE;SET @MIGRATION_1638198234_IS_ACTIVE = TRUE;SET @MIGRATION_1642069886_IS_ACTIVE = TRUE;SET @MIGRATION_1648479594_IS_ACTIVE = TRUE;SET @MIGRATION_1655465641_IS_ACTIVE = TRUE;SET @MIGRATION_1657094602_IS_ACTIVE = TRUE;SET @MIGRATION_1657194681_IS_ACTIVE = TRUE;SET @MIGRATION_1660674250_IS_ACTIVE = TRUE;SET @MIGRATION_1662982201_IS_ACTIVE = TRUE;SET @MIGRATION_1664455177_IS_ACTIVE = TRUE;SET @MIGRATION_1672738904_IS_ACTIVE = TRUE;SET @MIGRATION_1674728182_IS_ACTIVE = TRUE;SET @MIGRATION_1679060113_IS_ACTIVE = TRUE;SET @MIGRATION_1680008139_IS_ACTIVE = TRUE;SET @MIGRATION_1687164459_IS_ACTIVE = TRUE;SET @MIGRATION_1697826882_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1591711027_IS_ACTIVE = TRUE;SET @MIGRATION_1656139664_IS_ACTIVE = TRUE;SET @MIGRATION_1656139665_IS_ACTIVE = TRUE;SET @MIGRATION_1669562787_IS_ACTIVE = TRUE;SET @MIGRATION_1669562788_IS_ACTIVE = TRUE;SET @MIGRATION_1669562789_IS_ACTIVE = TRUE;SET @MIGRATION_1669562790_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1645171819_IS_ACTIVE = TRUE;SET @MIGRATION_1572516630_IS_ACTIVE = TRUE;SET @MIGRATION_1608027541_IS_ACTIVE = TRUE;SET @MIGRATION_1614589470_IS_ACTIVE = TRUE;SET @MIGRATION_1621937029_IS_ACTIVE = TRUE;SET @MIGRATION_1643985460_IS_ACTIVE = TRUE;SET @MIGRATION_1654223780_IS_ACTIVE = TRUE;SET @MIGRATION_1659962090_IS_ACTIVE = TRUE;SET @MIGRATION_1666007247_IS_ACTIVE = TRUE;SET @MIGRATION_1675941088_IS_ACTIVE = TRUE;SET @MIGRATION_1678198528_IS_ACTIVE = TRUE;SET @MIGRATION_1679899712_IS_ACTIVE = TRUE;SET @MIGRATION_1606161592_IS_ACTIVE = TRUE;SET @MIGRATION_1631562038_IS_ACTIVE = TRUE;SET @MIGRATION_1677008121_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1677050041_IS_ACTIVE = TRUE;SET @MIGRATION_1682496975_IS_ACTIVE = TRUE;SET @MIGRATION_1684135126_IS_ACTIVE = TRUE;SET @MIGRATION_1684309102_IS_ACTIVE = TRUE;SET @MIGRATION_1698047116_IS_ACTIVE = TRUE;SET @MIGRATION_1709034389_IS_ACTIVE = TRUE;

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

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

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

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x3F6D5D7233C4440F98E04C1A1C609CE0 OR sales_channel_id IS NULL)) AND (seo_path_info = 'p/bueffel-dry-aged-rib-eye/4000970') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, 
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, 
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, 
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, 
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, 
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, 
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, 
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, 
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, 
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, 
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, 
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, 
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, 
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, 
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, 
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, 
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, 
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, 
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` 
FROM 
  `dreisc_seo_redirect` 
WHERE 
  (
    (
      `dreisc_seo_redirect`.`active` = : param_6f9ffe95937a4c32878ca2da24dd08a5 
      AND `dreisc_seo_redirect`.`source_type` = : param_a3f4ef195ccf400489da4fd81182e73a 
      AND `dreisc_seo_redirect`.`source_product_id` = : param_73753e85b8034976879b723f32963431
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'product' AND `dreisc_seo_redirect`.`source_product_id` = 0x0B76FDCF8FA348EBB5E435A414C6CA34));

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`, 
  `product`.`product_manufacturer_id` as `product.manufacturerId`, 
  `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, 
  `product`.`unit_id` as `product.unitId`, 
  `product`.`tax_id` as `product.taxId`, 
  `product`.`product_media_id` as `product.coverId`, 
  `product`.`product_media_version_id` as `product.productMediaVersionId`, 
  `product`.`delivery_time_id` as `product.deliveryTimeId`, 
  `product`.`product_feature_set_id` as `product.featureSetId`, 
  `product`.`canonical_product_id` as `product.canonicalProductId`, 
  `product`.`cms_page_id` as `product.cmsPageId`, 
  `product`.`cms_page_version_id` as `product.cmsPageVersionId`, 
  `product`.`price` as `product.price`, 
  `product`.`product_number` as `product.productNumber`, 
  `product`.`stock` as `product.stock`, 
  `product`.`restock_time` as `product.restockTime`, 
  `product`.`auto_increment` as `product.autoIncrement`, 
  `product`.`active` as `product.active`, 
  `product`.`available_stock` as `product.availableStock`, 
  `product`.`available` as `product.available`, 
  `product`.`is_closeout` as `product.isCloseout`, 
  `product`.`display_group` as `product.displayGroup`, 
  `product`.`configurator_group_config` as `product.configuratorGroupConfig`, 
  `product`.`main_variant_id` as `product.mainVariantId`, 
  `product`.`display_parent` as `product.displayParent`, 
  `product`.`variant_listing_config` as `product.variantListingConfig`, 
  `product`.`variant_restrictions` as `product.variantRestrictions`, 
  `product`.`manufacturer_number` as `product.manufacturerNumber`, 
  `product`.`ean` as `product.ean`, 
  `product`.`purchase_steps` as `product.purchaseSteps`, 
  `product`.`max_purchase` as `product.maxPurchase`, 
  `product`.`min_purchase` as `product.minPurchase`, 
  `product`.`purchase_unit` as `product.purchaseUnit`, 
  `product`.`reference_unit` as `product.referenceUnit`, 
  `product`.`shipping_free` as `product.shippingFree`, 
  `product`.`purchase_prices` as `product.purchasePrices`, 
  `product`.`mark_as_topseller` as `product.markAsTopseller`, 
  `product`.`weight` as `product.weight`, 
  `product`.`width` as `product.width`, 
  `product`.`height` as `product.height`, 
  `product`.`length` as `product.length`, 
  `product`.`release_date` as `product.releaseDate`, 
  `product`.`rating_average` as `product.ratingAverage`, 
  `product`.`category_tree` as `product.categoryTree`, 
  `product`.`property_ids` as `product.propertyIds`, 
  `product`.`option_ids` as `product.optionIds`, 
  `product`.`stream_ids` as `product.streamIds`, 
  `product`.`tag_ids` as `product.tagIds`, 
  `product`.`category_ids` as `product.categoryIds`, 
  `product`.`child_count` as `product.childCount`, 
  `product`.`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`.`position` as `product.tax.position`, 
  `product.tax`.`custom_fields` as `product.tax.customFields`, 
  `product.tax`.`created_at` as `product.tax.createdAt`, 
  `product.tax`.`updated_at` as `product.tax.updatedAt`, 
  `product`.`cheapest_price` as `product.cheapestPrice`, 
  `product`.`created_at` as `product.createdAt`, 
  `product`.`updated_at` as `product.updatedAt`, 
  `product.netiEasyCouponProduct`.`id` as `product.netiEasyCouponProduct.id`, 
  `product.netiEasyCouponProduct`.`postal` as `product.netiEasyCouponProduct.postal`, 
  `product.netiEasyCouponProduct`.`value` as `product.netiEasyCouponProduct.value`, 
  `product.netiEasyCouponProduct`.`shipping_charge` as `product.netiEasyCouponProduct.shippingCharge`, 
  `product.netiEasyCouponProduct`.`exclude_from_shipping_costs` as `product.netiEasyCouponProduct.excludeFromShippingCosts`, 
  `product.netiEasyCouponProduct`.`no_delivery_charge` as `product.netiEasyCouponProduct.noDeliveryCharge`, 
  `product.netiEasyCouponProduct`.`customer_group_charge` as `product.netiEasyCouponProduct.customerGroupCharge`, 
  `product.netiEasyCouponProduct`.`comment` as `product.netiEasyCouponProduct.comment`, 
  `product.netiEasyCouponProduct`.`order_position_number` as `product.netiEasyCouponProduct.orderPositionNumber`, 
  `product.netiEasyCouponProduct`.`value_type` as `product.netiEasyCouponProduct.valueType`, 
  `product.netiEasyCouponProduct`.`combine_vouchers` as `product.netiEasyCouponProduct.combineVouchers`, 
  `product.netiEasyCouponProduct`.`validity_time` as `product.netiEasyCouponProduct.validityTime`, 
  `product.netiEasyCouponProduct`.`validity_by_end_of_year` as `product.netiEasyCouponProduct.validityByEndOfYear`, 
  `product.netiEasyCouponProduct`.`reduce_shipping_costs` as `product.netiEasyCouponProduct.reduceShippingCosts`, 
  `product.netiEasyCouponProduct`.`product_id` as `product.netiEasyCouponProduct.productId`, 
  `product.netiEasyCouponProduct`.`product_version_id` as `product.netiEasyCouponProduct.productVersionId`, 
  `product.netiEasyCouponProduct`.`tax_id` as `product.netiEasyCouponProduct.taxId`, 
  `product.netiEasyCouponProduct`.`recipient_input_enabled` as `product.netiEasyCouponProduct.recipientInputEnabled`, 
  `product.netiEasyCouponProduct`.`requested_delivery_enabled` as `product.netiEasyCouponProduct.requestedDeliveryEnabled`, 
  `product.netiEasyCouponProduct`.`delivery_message_enabled` as `product.netiEasyCouponProduct.deliveryMessageEnabled`, 
  `product.netiEasyCouponProduct`.`updated_at` as `product.netiEasyCouponProduct.updatedAt`, 
  `product.netiEasyCouponProduct`.`created_at` as `product.netiEasyCouponProduct.createdAt`, 
  `product.netiEasyCouponProduct.translation.title`, 
  COALESCE(
    `product.netiEasyCouponProduct.translation.title`, 
    `product.netiEasyCouponProduct.translation.title`
  ) as `product.netiEasyCouponProduct.title`, 
  `product.netiEasyCouponProduct.translation.updatedAt`, 
  `product.netiEasyCouponProduct.translation.createdAt`, 
  `product.netiEasyCouponProduct.translation.netiEasyCouponProductId`, 
  `product.netiEasyCouponProduct.translation.languageId`, 
  `product.translation.metaDescription`, 
  COALESCE(
    `product.translation.metaDescription`, 
    `product.translation.metaDescription`
  ) as `product.metaDescription`, 
  `product.translation.name`, 
  COALESCE(
    `product.translation.name`, `product.translation.name`
  ) as `product.name`, 
  `product.translation.keywords`, 
  COALESCE(
    `product.translation.keywords`, 
    `product.translation.keywords`
  ) as `product.keywords`, 
  `product.translation.description`, 
  COALESCE(
    `product.translation.description`, 
    `product.translation.description`
  ) as `product.description`, 
  `product.translation.metaTitle`, 
  COALESCE(
    `product.translation.metaTitle`, 
    `product.translation.metaTitle`
  ) as `product.metaTitle`, 
  `product.translation.packUnit`, 
  COALESCE(
    `product.translation.packUnit`, 
    `product.translation.packUnit`
  ) as `product.packUnit`, 
  `product.translation.packUnitPlural`, 
  COALESCE(
    `product.translation.packUnitPlural`, 
    `product.translation.packUnitPlural`
  ) as `product.packUnitPlural`, 
  `product.translation.customSearchKeywords`, 
  COALESCE(
    `product.translation.customSearchKeywords`, 
    `product.translation.customSearchKeywords`
  ) as `product.customSearchKeywords`, 
  `product.translation.slotConfig`, 
  COALESCE(
    `product.translation.slotConfig`, 
    `product.translation.slotConfig`
  ) as `product.slotConfig`, 
  `product.translation.customFields`, 
  COALESCE(
    `product.translation.customFields`, 
    `product.translation.customFields`
  ) as `product.customFields`, 
  `product.translation.createdAt`, 
  `product.translation.updatedAt`, 
  `product.translation.productId`, 
  `product.translation.languageId`, 
  `product.translation.productVersionId` 
FROM 
  `product` 
  LEFT JOIN (
    SELECT 
      `product.translation`.product_id, 
      `product.translation`.product_version_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`.slot_config as `product.translation.slotConfig`, 
      `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` 
  AND `product.product_translation`.product_version_id = `product`.version_id 
  LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` 
  LEFT JOIN `neti_easy_coupon_product` `product.netiEasyCouponProduct` ON `product`.`id` = `product.netiEasyCouponProduct`.`product_id` 
  LEFT JOIN (
    SELECT 
      `product.netiEasyCouponProduct.translation`.neti_easy_coupon_product_id, 
      `product.netiEasyCouponProduct.translation`.title as `product.netiEasyCouponProduct.translation.title`, 
      `product.netiEasyCouponProduct.translation`.updated_at as `product.netiEasyCouponProduct.translation.updatedAt`, 
      `product.netiEasyCouponProduct.translation`.created_at as `product.netiEasyCouponProduct.translation.createdAt`, 
      `product.netiEasyCouponProduct.translation`.neti_easy_coupon_product_id as `product.netiEasyCouponProduct.translation.netiEasyCouponProductId`, 
      `product.netiEasyCouponProduct.translation`.language_id as `product.netiEasyCouponProduct.translation.languageId` 
    FROM 
      `neti_easy_coupon_product_translation` `product.netiEasyCouponProduct.translation` 
    WHERE 
      `product.netiEasyCouponProduct.translation`.language_id = : languageId
  ) `product.netiEasyCouponProduct.neti_easy_coupon_product_translation` ON `product.netiEasyCouponProduct.neti_easy_coupon_product_translation`.`neti_easy_coupon_product_id` = `product.netiEasyCouponProduct`.`id` 
WHERE 
  (
    `product`.`version_id` = : version
  ) 
  AND (
    `product`.`id` IN (: ids)
  )

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`, `product`.`product_manufacturer_id` as `product.manufacturerId`, `product`.`product_manufacturer_version_id` as `product.productManufacturerVersionId`, `product`.`unit_id` as `product.unitId`, `product`.`tax_id` as `product.taxId`, `product`.`product_media_id` as `product.coverId`, `product`.`product_media_version_id` as `product.productMediaVersionId`, `product`.`delivery_time_id` as `product.deliveryTimeId`, `product`.`product_feature_set_id` as `product.featureSetId`, `product`.`canonical_product_id` as `product.canonicalProductId`, `product`.`cms_page_id` as `product.cmsPageId`, `product`.`cms_page_version_id` as `product.cmsPageVersionId`, `product`.`price` as `product.price`, `product`.`product_number` as `product.productNumber`, `product`.`stock` as `product.stock`, `product`.`restock_time` as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, `product`.`active` as `product.active`, `product`.`available_stock` as `product.availableStock`, `product`.`available` as `product.available`, `product`.`is_closeout` as `product.isCloseout`, `product`.`display_group` as `product.displayGroup`, `product`.`configurator_group_config` as `product.configuratorGroupConfig`, `product`.`main_variant_id` as `product.mainVariantId`, `product`.`display_parent` as `product.displayParent`, `product`.`variant_listing_config` as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, `product`.`manufacturer_number` as `product.manufacturerNumber`, `product`.`ean` as `product.ean`, `product`.`purchase_steps` as `product.purchaseSteps`, `product`.`max_purchase` as `product.maxPurchase`, `product`.`min_purchase` as `product.minPurchase`, `product`.`purchase_unit` as `product.purchaseUnit`, `product`.`reference_unit` as `product.referenceUnit`, `product`.`shipping_free` as `product.shippingFree`, `product`.`purchase_prices` as `product.purchasePrices`, `product`.`mark_as_topseller` as `product.markAsTopseller`, `product`.`weight` as `product.weight`, `product`.`width` as `product.width`, `product`.`height` as `product.height`, `product`.`length` as `product.length`, `product`.`release_date` as `product.releaseDate`, `product`.`rating_average` as `product.ratingAverage`, `product`.`category_tree` as `product.categoryTree`, `product`.`property_ids` as `product.propertyIds`, `product`.`option_ids` as `product.optionIds`, `product`.`stream_ids` as `product.streamIds`, `product`.`tag_ids` as `product.tagIds`, `product`.`category_ids` as `product.categoryIds`, `product`.`child_count` as `product.childCount`, `product`.`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`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`cheapest_price` as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.netiEasyCouponProduct`.`id` as `product.netiEasyCouponProduct.id`, `product.netiEasyCouponProduct`.`postal` as `product.netiEasyCouponProduct.postal`, `product.netiEasyCouponProduct`.`value` as `product.netiEasyCouponProduct.value`, `product.netiEasyCouponProduct`.`shipping_charge` as `product.netiEasyCouponProduct.shippingCharge`, `product.netiEasyCouponProduct`.`exclude_from_shipping_costs` as `product.netiEasyCouponProduct.excludeFromShippingCosts`, `product.netiEasyCouponProduct`.`no_delivery_charge` as `product.netiEasyCouponProduct.noDeliveryCharge`, `product.netiEasyCouponProduct`.`customer_group_charge` as `product.netiEasyCouponProduct.customerGroupCharge`, `product.netiEasyCouponProduct`.`comment` as `product.netiEasyCouponProduct.comment`, `product.netiEasyCouponProduct`.`order_position_number` as `product.netiEasyCouponProduct.orderPositionNumber`, `product.netiEasyCouponProduct`.`value_type` as `product.netiEasyCouponProduct.valueType`, `product.netiEasyCouponProduct`.`combine_vouchers` as `product.netiEasyCouponProduct.combineVouchers`, `product.netiEasyCouponProduct`.`validity_time` as `product.netiEasyCouponProduct.validityTime`, `product.netiEasyCouponProduct`.`validity_by_end_of_year` as `product.netiEasyCouponProduct.validityByEndOfYear`, `product.netiEasyCouponProduct`.`reduce_shipping_costs` as `product.netiEasyCouponProduct.reduceShippingCosts`, `product.netiEasyCouponProduct`.`product_id` as `product.netiEasyCouponProduct.productId`, `product.netiEasyCouponProduct`.`product_version_id` as `product.netiEasyCouponProduct.productVersionId`, `product.netiEasyCouponProduct`.`tax_id` as `product.netiEasyCouponProduct.taxId`, `product.netiEasyCouponProduct`.`recipient_input_enabled` as `product.netiEasyCouponProduct.recipientInputEnabled`, `product.netiEasyCouponProduct`.`requested_delivery_enabled` as `product.netiEasyCouponProduct.requestedDeliveryEnabled`, `product.netiEasyCouponProduct`.`delivery_message_enabled` as `product.netiEasyCouponProduct.deliveryMessageEnabled`, `product.netiEasyCouponProduct`.`updated_at` as `product.netiEasyCouponProduct.updatedAt`, `product.netiEasyCouponProduct`.`created_at` as `product.netiEasyCouponProduct.createdAt`, `product.netiEasyCouponProduct.translation.title`, COALESCE(`product.netiEasyCouponProduct.translation.title`,`product.netiEasyCouponProduct.translation.title`) as `product.netiEasyCouponProduct.title`, `product.netiEasyCouponProduct.translation.updatedAt`, `product.netiEasyCouponProduct.translation.createdAt`, `product.netiEasyCouponProduct.translation.netiEasyCouponProductId`, `product.netiEasyCouponProduct.translation.languageId`, `product.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, COALESCE(`product.translation.name`,`product.translation.name`) as `product.name`, `product.translation.keywords`, COALESCE(`product.translation.keywords`,`product.translation.keywords`) as `product.keywords`, `product.translation.description`, COALESCE(`product.translation.description`,`product.translation.description`) as `product.description`, `product.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, COALESCE(`product.translation.customFields`,`product.translation.customFields`) as `product.customFields`, `product.translation.createdAt`, `product.translation.updatedAt`, `product.translation.productId`, `product.translation.languageId`, `product.translation.productVersionId` FROM `product` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_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`.slot_config as `product.translation.slotConfig`, `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 = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax_id` = `product.tax`.`id` LEFT JOIN `neti_easy_coupon_product` `product.netiEasyCouponProduct` ON `product`.`id` = `product.netiEasyCouponProduct`.`product_id` LEFT JOIN (SELECT `product.netiEasyCouponProduct.translation`.neti_easy_coupon_product_id, `product.netiEasyCouponProduct.translation`.title as `product.netiEasyCouponProduct.translation.title`, `product.netiEasyCouponProduct.translation`.updated_at as `product.netiEasyCouponProduct.translation.updatedAt`, `product.netiEasyCouponProduct.translation`.created_at as `product.netiEasyCouponProduct.translation.createdAt`, `product.netiEasyCouponProduct.translation`.neti_easy_coupon_product_id as `product.netiEasyCouponProduct.translation.netiEasyCouponProductId`, `product.netiEasyCouponProduct.translation`.language_id as `product.netiEasyCouponProduct.translation.languageId` FROM `neti_easy_coupon_product_translation` `product.netiEasyCouponProduct.translation` WHERE `product.netiEasyCouponProduct.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product.netiEasyCouponProduct.neti_easy_coupon_product_translation` ON `product.netiEasyCouponProduct.neti_easy_coupon_product_translation`.`neti_easy_coupon_product_id` = `product.netiEasyCouponProduct`.`id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product`.`id` IN (0x0B76FDCF8FA348EBB5E435A414C6CA34));

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

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

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

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

SELECT 
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, 
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, 
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, 
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, 
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, 
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, 
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, 
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, 
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, 
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, 
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, 
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, 
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, 
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, 
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, 
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, 
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, 
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, 
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, 
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, 
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` 
FROM 
  `dreisc_seo_redirect` 
WHERE 
  (
    (
      `dreisc_seo_redirect`.`active` = : param_41a201ab17fa4aceb3aa3f0c24ecea46 
      AND `dreisc_seo_redirect`.`source_type` = : param_e1eaa623b6b64081b81b143b3f85ef40 
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = : param_7b3e584774cb4b81a6e7325084eb73df 
      AND `dreisc_seo_redirect`.`source_path` = : param_2c6ef29c825f472793106bc0cae6d7e7
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'url' AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = 0x8A84E9FF607541F3AA7BD85AAB00196D AND `dreisc_seo_redirect`.`source_path` = 'p/bueffel-dry-aged-rib-eye/4000970'));