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_1558505525_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601388975_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602745374_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602822727_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605609309_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_1609857999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610531188_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610965670_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610974673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614240671_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594104496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604585230_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609140710_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610337444_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610439375_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610448012_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610523204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610523548_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610616655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610621999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610625925_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610634383_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610904608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611732852_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1611817467_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612184092_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442685_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442686_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612442786_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612851765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612865237_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612970642_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1612980753_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613665555_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614249488_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614691876_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614765170_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614765785_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615359964_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615366708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615452749_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615802866_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1615819992_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616076922_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616496610_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616555956_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617000878_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617356092_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617784658_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617864895_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617868381_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617877887_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617896006_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617935350_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617953690_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617960456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617974402_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618218491_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618389817_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618476427_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618569201_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618900427_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618989442_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619070236_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619428555_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619604605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619703075_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620146632_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620147234_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620201616_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620215586_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620374229_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620376945_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620632460_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620634856_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620733405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620733405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620820321_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845370_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622010069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622104463_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1622782058_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623305620_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623391399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623828962_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624262862_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624884801_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624967118_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625304609_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625465756_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625505190_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625554302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625569667_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625583596_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625583619_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625816310_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625819412_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625831469_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626241110_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626442868_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626696809_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626785125_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627292049_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627540693_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627541488_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627562945_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627650101_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627929168_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627983652_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1628519513_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1628749113_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629204538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629700169_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1629877210_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630074081_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630485317_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631625055_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631703921_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631790054_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631863869_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632111590_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632215760_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632721037_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633347511_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633358879_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1633422057_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634735841_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635147952_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635230747_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635237551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635388654_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1635936029_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636014089_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636018970_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636362839_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636449347_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636964297_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636971615_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638195971_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638365464_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638514913_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638993987_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639122665_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639139581_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639992771_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641289204_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642517958_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642732351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642757286_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643366069_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643386819_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643724178_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643878976_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643892702_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645019769_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645453538_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646125417_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646397836_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646817331_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647260673_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647443222_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1647511158_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031611_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648031636_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648543185_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648709176_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648803451_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649040981_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649315608_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649858046_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650620993_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1651118773_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652441129_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653376989_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1653385302_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1654839361_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655730949_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656397126_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1656928097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657011337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657027979_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657173907_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1658786605_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659256999_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257296_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257396_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659257496_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660814397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661759290_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1661771388_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663238480_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664512574_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664541794_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1664894872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665064823_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1665267882_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667731399_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667806582_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1667983492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1668677456_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1669316067_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672164687_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672743034_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673001912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673966228_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675218708_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1675827655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641476963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660813696_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1576854000_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_1605793526_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626962811_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627042648_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1627457596_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641983339_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645086521_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1646129638_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1681559664_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1689204620_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1696709868_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1696809868_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1696909868_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_1604664434_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574344300_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660101311_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572516630_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1655472211_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1598866591_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1692350475_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588594510_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 @@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_1558505525_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_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_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1576854000_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_1605793526_IS_ACTIVE = TRUE;SET @MIGRATION_1626962811_IS_ACTIVE = TRUE;SET @MIGRATION_1627042648_IS_ACTIVE = TRUE;SET @MIGRATION_1627457596_IS_ACTIVE = TRUE;SET @MIGRATION_1641983339_IS_ACTIVE = TRUE;SET @MIGRATION_1645086521_IS_ACTIVE = TRUE;SET @MIGRATION_1646129638_IS_ACTIVE = TRUE;SET @MIGRATION_1681559664_IS_ACTIVE = TRUE;SET @MIGRATION_1689204620_IS_ACTIVE = TRUE;SET @MIGRATION_1696709868_IS_ACTIVE = TRUE;SET @MIGRATION_1696809868_IS_ACTIVE = TRUE;SET @MIGRATION_1696909868_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_1604664434_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1660101311_IS_ACTIVE = TRUE;SET @MIGRATION_1572516630_IS_ACTIVE = TRUE;SET @MIGRATION_1655472211_IS_ACTIVE = TRUE;SET @MIGRATION_1598866591_IS_ACTIVE = TRUE;SET @MIGRATION_1692350475_IS_ACTIVE = TRUE;SET @MIGRATION_1588594510_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;

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_e5b74994445940ddaf012ff638613591 
      AND `dreisc_seo_redirect`.`source_type` = : param_2ebb3a3bc69643f5ab431e72faddf3f5 
      AND `dreisc_seo_redirect`.`source_category_id` = : param_ff2fa4e336494cee9c40dedef8417438
    )
  )

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` = 'category' AND `dreisc_seo_redirect`.`source_category_id` = 0xD669299602DB4BAF8B236EEAE082FD7A));

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_ea78fb2feb1a445d93b2f6cb52cc7daa 
      AND `dreisc_seo_redirect`.`source_type` = : param_aa83a6bf2b21498dae67af3928e0dbfa 
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = : param_9eddaf154d9241fd9bf425f6abeeab77 
      AND `dreisc_seo_redirect`.`source_path` = : param_de379e3b7d5740e1b13dc406be689397
    )
  )

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` = 0xDB78CF3395EE41CAA1682E8913D8B549 AND `dreisc_seo_redirect`.`source_path` = 'angebote/'));

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

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY 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 = 0x95CD7B3609E442B391DD45859898D3BD) AND (token = 'gluRkONzZrOnljgaQ5mO6AOwaD1NHkmc') LIMIT 1;

SHOW COLUMNS 
FROM 
  `cart` 
WHERE 
  `Field` LIKE : column

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

#cart-persister::load
SELECT 
  `cart`.`cart` as payload, 
  `cart`.`rule_ids`, 
  0 as `compressed` 
FROM 
  cart 
WHERE 
  `token` = : token

#cart-persister::load
                SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = 'gluRkONzZrOnljgaQ5mO6AOwaD1NHkmc';

# cart::promotion::search-ids
SELECT 
  `promotion`.`id` 
FROM 
  `promotion` 
  LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` 
WHERE 
  (
    (
      `promotion`.`active` = : param_05d83435dd614e93b4a0d3b8f5c9025d 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_ff4eddcbd7d74ea8908e0417382af930 
      AND (
        (
          `promotion`.`valid_from` <=> : param_fcc181fe096b41a7b81251e46d18d24f 
          AND `promotion`.`valid_until` <=> : param_78585cd41edc421aa763a384205dfd7c
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_524a8f11d34c4f92a63afafc20dc6c15 
          AND (
            `promotion`.`valid_until` > : param_a21ed5e3253d46c89b43347dcd8d38a1
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_4992b15897ed4e4e9f6069b1beae233d
          ) 
          AND `promotion`.`valid_until` <=> : param_ca251c67575547d1a86f08fb43d7bf43
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_546c509328ab4617927e88fedc7a4fa1
          ) 
          AND (
            `promotion`.`valid_until` > : param_12abf6e14a6e4c00b8d916ed6d958919
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_4a98d2af0c064e67935e0ee3827b0604
    )
  ) 
GROUP BY 
  `promotion`.`id` 
ORDER BY 
  MAX(`promotion`.`priority`) DESC

# cart::promotion::search-ids
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = 1 AND `promotion.salesChannels`.`sales_channel_id` = 0x95CD7B3609E442B391DD45859898D3BD AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2025-04-26 07:25:45')) OR ((`promotion`.`valid_from` <= '2025-04-26 07:25:45') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-04-26 07:25:45') AND (`promotion`.`valid_until` > '2025-04-26 07:25:45'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

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

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

# cart::shipping-methods::read
SELECT 
  `shipping_method`.`id` as `shipping_method.id`, 
  `shipping_method`.`active` as `shipping_method.active`, 
  `shipping_method`.`position` as `shipping_method.position`, 
  `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, 
  `shipping_method`.`media_id` as `shipping_method.mediaId`, 
  `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, 
  `shipping_method`.`tax_type` as `shipping_method.taxType`, 
  `shipping_method`.`tax_id` as `shipping_method.taxId`, 
  `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, 
  `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, 
  `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, 
  `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, 
  `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, 
  `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, 
  `shipping_method.deliveryTime.translation.name`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.name`, 
    `shipping_method.deliveryTime.translation.name`
  ) as `shipping_method.deliveryTime.name`, 
  `shipping_method.deliveryTime.translation.customFields`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`
  ) as `shipping_method.deliveryTime.customFields`, 
  `shipping_method.deliveryTime.translation.createdAt`, 
  `shipping_method.deliveryTime.translation.updatedAt`, 
  `shipping_method.deliveryTime.translation.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.languageId`, 
  `shipping_method`.`created_at` as `shipping_method.createdAt`, 
  `shipping_method`.`updated_at` as `shipping_method.updatedAt`, 
  `shipping_method.tax`.`id` as `shipping_method.tax.id`, 
  `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, 
  `shipping_method.tax`.`name` as `shipping_method.tax.name`, 
  `shipping_method.tax`.`position` as `shipping_method.tax.position`, 
  `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, 
  `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, 
  `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, 
  `shipping_method.translation.name`, 
  COALESCE(
    `shipping_method.translation.name`, 
    `shipping_method.translation.name`
  ) as `shipping_method.name`, 
  `shipping_method.translation.description`, 
  COALESCE(
    `shipping_method.translation.description`, 
    `shipping_method.translation.description`
  ) as `shipping_method.description`, 
  `shipping_method.translation.trackingUrl`, 
  COALESCE(
    `shipping_method.translation.trackingUrl`, 
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`, 
  `shipping_method.translation.customFields`, 
  COALESCE(
    `shipping_method.translation.customFields`, 
    `shipping_method.translation.customFields`
  ) as `shipping_method.customFields`, 
  `shipping_method.translation.createdAt`, 
  `shipping_method.translation.updatedAt`, 
  `shipping_method.translation.shippingMethodId`, 
  `shipping_method.translation.languageId` 
FROM 
  `shipping_method` 
  LEFT JOIN (
    SELECT 
      `shipping_method.translation`.shipping_method_id, 
      `shipping_method.translation`.name as `shipping_method.translation.name`, 
      `shipping_method.translation`.description as `shipping_method.translation.description`, 
      `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, 
      `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, 
      `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, 
      `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, 
      `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, 
      `shipping_method.translation`.language_id as `shipping_method.translation.languageId` 
    FROM 
      `shipping_method_translation` `shipping_method.translation` 
    WHERE 
      `shipping_method.translation`.language_id = : languageId
  ) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` 
  LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` 
  LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` 
  LEFT JOIN (
    SELECT 
      `shipping_method.deliveryTime.translation`.delivery_time_id, 
      `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, 
      `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, 
      `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, 
      `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, 
      `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, 
      `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` 
    FROM 
      `delivery_time_translation` `shipping_method.deliveryTime.translation` 
    WHERE 
      `shipping_method.deliveryTime.translation`.language_id = : languageId
  ) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` 
WHERE 
  `shipping_method`.`id` IN (: ids)

# cart::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (0xAEC4A9977A6B430FB574F609A372F86E);