Symfony Profiler

SELECT 
  `creation_timestamp` 
FROM 
  `migration` 
WHERE 
  `update` IS NOT NULL 
  AND `update_destructive` IS NULL

SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
        ;

SET 
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len, 
      320000
    ) AS UNSIGNED
  ); 
SET 
  sql_mode =(
    SELECT 
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY', 
        ''
      )
  ); 
SET 
  @MIGRATION_1611155140_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617896006_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845357_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621845370_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623305620_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_1650249241_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650444800_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650548599_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650872291_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1650981517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652166447_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652345915_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1652864153_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641476963_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1632281097_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636121186_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605167857_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572594721_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584438271_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595341699_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595341767_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595405748_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595405770_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597309435_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630407150_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1673356465_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1689245968_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690892790_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620640853_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059645_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059646_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059647_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059648_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059650_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1564059651_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1565933910_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640060_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640070_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1568640076_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580300846_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582119202_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1582281362_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583477457_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583486534_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489755_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583489757_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1588252518_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594288127_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594373672_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594727519_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1583737095_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602060888_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602675838_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1609233961_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1571402521_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572513780_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1604584546_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1630669686_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1639399366_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_1585513405_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593768099_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574344300_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580223350_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621830472_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1580730959_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1623051960_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1624023259_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586326495_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1556014423_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1556014424_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1556118797_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1584965609_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586186442_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1586202227_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1589893337_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592244872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1592991551_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1593514482_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1594822086_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1595323759_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596645397_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596646072_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1597838146_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1599039841_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600096104_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1600420898_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1601043196_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607589490_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607589491_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1607589492_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1610376590_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614587720_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1614587720_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1616419772_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617018765_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1618321583_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620829074_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621333785_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1621419761_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1625556996_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626766063_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636977354_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1637931476_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638897517_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1640181713_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1641313633_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1642690994_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643377802_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645103528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645190845_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648127351_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1648127352_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649086118_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649759025_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620306767_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1620308350_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657615865_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1660643832_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619094000_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619094846_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1619101148_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1626965594_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1636624220_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1638791749_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1645190844_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1649086115_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662473035_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1617713528_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_160198215_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1634025013_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572012839_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572012863_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572012872_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1572172912_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1573059308_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1574260096_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1596724410_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1602017170_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605280710_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605280720_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605280730_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1605280740_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643837044_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1643837100_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1657532635_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1671734011_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1672309655_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1674116991_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1694071413_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1698671219_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1613699220_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1659520454_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1682338916_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1684220998_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631874314_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1631875136_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662967343_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1663616279_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1670598161_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1662967343_IS_ACTIVE = TRUE; 
SET 
  @MIGRATION_1690376147_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_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_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_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1572594721_IS_ACTIVE = TRUE;SET @MIGRATION_1584438271_IS_ACTIVE = TRUE;SET @MIGRATION_1595341699_IS_ACTIVE = TRUE;SET @MIGRATION_1595341767_IS_ACTIVE = TRUE;SET @MIGRATION_1595405748_IS_ACTIVE = TRUE;SET @MIGRATION_1595405770_IS_ACTIVE = TRUE;SET @MIGRATION_1597309435_IS_ACTIVE = TRUE;SET @MIGRATION_1630407150_IS_ACTIVE = TRUE;SET @MIGRATION_1673356465_IS_ACTIVE = TRUE;SET @MIGRATION_1689245968_IS_ACTIVE = TRUE;SET @MIGRATION_1690892790_IS_ACTIVE = TRUE;SET @MIGRATION_1620640853_IS_ACTIVE = TRUE;SET @MIGRATION_1564059645_IS_ACTIVE = TRUE;SET @MIGRATION_1564059646_IS_ACTIVE = TRUE;SET @MIGRATION_1564059647_IS_ACTIVE = TRUE;SET @MIGRATION_1564059648_IS_ACTIVE = TRUE;SET @MIGRATION_1564059650_IS_ACTIVE = TRUE;SET @MIGRATION_1564059651_IS_ACTIVE = TRUE;SET @MIGRATION_1565933910_IS_ACTIVE = TRUE;SET @MIGRATION_1568640060_IS_ACTIVE = TRUE;SET @MIGRATION_1568640070_IS_ACTIVE = TRUE;SET @MIGRATION_1568640076_IS_ACTIVE = TRUE;SET @MIGRATION_1580300846_IS_ACTIVE = TRUE;SET @MIGRATION_1582119202_IS_ACTIVE = TRUE;SET @MIGRATION_1582281362_IS_ACTIVE = TRUE;SET @MIGRATION_1583477457_IS_ACTIVE = TRUE;SET @MIGRATION_1583486528_IS_ACTIVE = TRUE;SET @MIGRATION_1583486534_IS_ACTIVE = TRUE;SET @MIGRATION_1583489755_IS_ACTIVE = TRUE;SET @MIGRATION_1583489757_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1588252518_IS_ACTIVE = TRUE;SET @MIGRATION_1594288127_IS_ACTIVE = TRUE;SET @MIGRATION_1594373672_IS_ACTIVE = TRUE;SET @MIGRATION_1594727519_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1602060888_IS_ACTIVE = TRUE;SET @MIGRATION_1602675838_IS_ACTIVE = TRUE;SET @MIGRATION_1609233961_IS_ACTIVE = TRUE;SET @MIGRATION_1571402521_IS_ACTIVE = TRUE;SET @MIGRATION_1572513780_IS_ACTIVE = TRUE;SET @MIGRATION_1604584546_IS_ACTIVE = TRUE;SET @MIGRATION_1630669686_IS_ACTIVE = TRUE;SET @MIGRATION_1639399366_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_1585513405_IS_ACTIVE = TRUE;SET @MIGRATION_1593768099_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1580223350_IS_ACTIVE = TRUE;SET @MIGRATION_1621830472_IS_ACTIVE = TRUE;SET @MIGRATION_1580730959_IS_ACTIVE = TRUE;SET @MIGRATION_1623051960_IS_ACTIVE = TRUE;SET @MIGRATION_1624023259_IS_ACTIVE = TRUE;SET @MIGRATION_1586326495_IS_ACTIVE = TRUE;SET @MIGRATION_1556014423_IS_ACTIVE = TRUE;SET @MIGRATION_1556014424_IS_ACTIVE = TRUE;SET @MIGRATION_1556118797_IS_ACTIVE = TRUE;SET @MIGRATION_1584965609_IS_ACTIVE = TRUE;SET @MIGRATION_1586186442_IS_ACTIVE = TRUE;SET @MIGRATION_1586202227_IS_ACTIVE = TRUE;SET @MIGRATION_1589893337_IS_ACTIVE = TRUE;SET @MIGRATION_1592244872_IS_ACTIVE = TRUE;SET @MIGRATION_1592991551_IS_ACTIVE = TRUE;SET @MIGRATION_1593514482_IS_ACTIVE = TRUE;SET @MIGRATION_1594822086_IS_ACTIVE = TRUE;SET @MIGRATION_1595323759_IS_ACTIVE = TRUE;SET @MIGRATION_1596645397_IS_ACTIVE = TRUE;SET @MIGRATION_1596646072_IS_ACTIVE = TRUE;SET @MIGRATION_1597838146_IS_ACTIVE = TRUE;SET @MIGRATION_1599039841_IS_ACTIVE = TRUE;SET @MIGRATION_1600096104_IS_ACTIVE = TRUE;SET @MIGRATION_1600420898_IS_ACTIVE = TRUE;SET @MIGRATION_1601043196_IS_ACTIVE = TRUE;SET @MIGRATION_1607589490_IS_ACTIVE = TRUE;SET @MIGRATION_1607589491_IS_ACTIVE = TRUE;SET @MIGRATION_1607589492_IS_ACTIVE = TRUE;SET @MIGRATION_1610376590_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1616419772_IS_ACTIVE = TRUE;SET @MIGRATION_1617018765_IS_ACTIVE = TRUE;SET @MIGRATION_1618321583_IS_ACTIVE = TRUE;SET @MIGRATION_1620829074_IS_ACTIVE = TRUE;SET @MIGRATION_1621333785_IS_ACTIVE = TRUE;SET @MIGRATION_1621419761_IS_ACTIVE = TRUE;SET @MIGRATION_1625556996_IS_ACTIVE = TRUE;SET @MIGRATION_1626766063_IS_ACTIVE = TRUE;SET @MIGRATION_1636977354_IS_ACTIVE = TRUE;SET @MIGRATION_1637931476_IS_ACTIVE = TRUE;SET @MIGRATION_1638897517_IS_ACTIVE = TRUE;SET @MIGRATION_1640181713_IS_ACTIVE = TRUE;SET @MIGRATION_1641313633_IS_ACTIVE = TRUE;SET @MIGRATION_1642690994_IS_ACTIVE = TRUE;SET @MIGRATION_1643377802_IS_ACTIVE = TRUE;SET @MIGRATION_1645103528_IS_ACTIVE = TRUE;SET @MIGRATION_1645190845_IS_ACTIVE = TRUE;SET @MIGRATION_1648127351_IS_ACTIVE = TRUE;SET @MIGRATION_1648127352_IS_ACTIVE = TRUE;SET @MIGRATION_1649086118_IS_ACTIVE = TRUE;SET @MIGRATION_1649759025_IS_ACTIVE = TRUE;SET @MIGRATION_1620306767_IS_ACTIVE = TRUE;SET @MIGRATION_1620308350_IS_ACTIVE = TRUE;SET @MIGRATION_1657615865_IS_ACTIVE = TRUE;SET @MIGRATION_1660643832_IS_ACTIVE = TRUE;SET @MIGRATION_1619094000_IS_ACTIVE = TRUE;SET @MIGRATION_1619094846_IS_ACTIVE = TRUE;SET @MIGRATION_1619101148_IS_ACTIVE = TRUE;SET @MIGRATION_1626965594_IS_ACTIVE = TRUE;SET @MIGRATION_1636624220_IS_ACTIVE = TRUE;SET @MIGRATION_1638791749_IS_ACTIVE = TRUE;SET @MIGRATION_1645190844_IS_ACTIVE = TRUE;SET @MIGRATION_1649086115_IS_ACTIVE = TRUE;SET @MIGRATION_1662473035_IS_ACTIVE = TRUE;SET @MIGRATION_1617713528_IS_ACTIVE = TRUE;SET @MIGRATION_160198215_IS_ACTIVE = TRUE;SET @MIGRATION_1634025013_IS_ACTIVE = TRUE;SET @MIGRATION_1572012839_IS_ACTIVE = TRUE;SET @MIGRATION_1572012863_IS_ACTIVE = TRUE;SET @MIGRATION_1572012872_IS_ACTIVE = TRUE;SET @MIGRATION_1572172912_IS_ACTIVE = TRUE;SET @MIGRATION_1573059308_IS_ACTIVE = TRUE;SET @MIGRATION_1574260096_IS_ACTIVE = TRUE;SET @MIGRATION_1596724410_IS_ACTIVE = TRUE;SET @MIGRATION_1602017170_IS_ACTIVE = TRUE;SET @MIGRATION_1605280710_IS_ACTIVE = TRUE;SET @MIGRATION_1605280720_IS_ACTIVE = TRUE;SET @MIGRATION_1605280730_IS_ACTIVE = TRUE;SET @MIGRATION_1605280740_IS_ACTIVE = TRUE;SET @MIGRATION_1643837044_IS_ACTIVE = TRUE;SET @MIGRATION_1643837100_IS_ACTIVE = TRUE;SET @MIGRATION_1657532635_IS_ACTIVE = TRUE;SET @MIGRATION_1671734011_IS_ACTIVE = TRUE;SET @MIGRATION_1672309655_IS_ACTIVE = TRUE;SET @MIGRATION_1674116991_IS_ACTIVE = TRUE;SET @MIGRATION_1694071413_IS_ACTIVE = TRUE;SET @MIGRATION_1698671219_IS_ACTIVE = TRUE;SET @MIGRATION_1613699220_IS_ACTIVE = TRUE;SET @MIGRATION_1659520454_IS_ACTIVE = TRUE;SET @MIGRATION_1682338916_IS_ACTIVE = TRUE;SET @MIGRATION_1684220998_IS_ACTIVE = TRUE;SET @MIGRATION_1631874314_IS_ACTIVE = TRUE;SET @MIGRATION_1631875136_IS_ACTIVE = TRUE;SET @MIGRATION_1662967343_IS_ACTIVE = TRUE;SET @MIGRATION_1663616279_IS_ACTIVE = TRUE;SET @MIGRATION_1670598161_IS_ACTIVE = TRUE;SET @MIGRATION_1662967343_IS_ACTIVE = TRUE;SET @MIGRATION_1690376147_IS_ACTIVE = TRUE;

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

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73) AND ((sales_channel_id = 0x27F88DD40BD740F0A51EB58270C3C347 OR sales_channel_id IS NULL)) AND (seo_path_info = 'maintenance/singlepage/8db99f7667924c7a9ccefe0521bd2f37') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

SELECT 
  path_info pathInfo, 
  seo_path_info seoPathInfo 
FROM 
  seo_url 
WHERE 
  (language_id = : language_id) 
  AND (
    sales_channel_id = : sales_channel_id
  ) 
  AND (id != : id) 
  AND (path_info = : pathInfo) 
  AND (is_canonical = 1) 
LIMIT 
  1

SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73) AND (sales_channel_id = 0x27F88DD40BD740F0A51EB58270C3C347) AND (id != '') AND (path_info = '/maintenance/singlepage/8db99f7667924c7a9ccefe0521bd2f37') AND (is_canonical = 1) LIMIT 1;

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 'PaynlPaymentShopware6.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 = 0x27F88DD40BD740F0A51EB58270C3C347) AND (token = 'hb4VE45XBNDlrFOwZIQwnGf1d5Uchdfy') 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` = 'hb4VE45XBNDlrFOwZIQwnGf1d5Uchdfy';

# 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_495efda060464cd0a0a4a360e9628cb7 
      AND `promotion.salesChannels`.`sales_channel_id` = : param_63d6dd501be54a2eaf5bf0df22b36e82 
      AND (
        (
          `promotion`.`valid_from` <=> : param_7eb2cbbad30a43d5ac95453211a1fee4 
          AND `promotion`.`valid_until` <=> : param_bc231b0a9ca1456bab20f9bb1ec3c4af
        ) 
        OR (
          `promotion`.`valid_from` <=> : param_581ad38c5d95467eb72f9aeebbd09de6 
          AND (
            `promotion`.`valid_until` > : param_10044d3c85ec42f4bd08a5ad37549263
          )
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_eadf6e2372d44b1596f5fdf3529566cc
          ) 
          AND `promotion`.`valid_until` <=> : param_565a05a5a81945f4a33b5251a9dce4b1
        ) 
        OR (
          (
            `promotion`.`valid_from` <= : param_5ebded8c28bb49f79d7ced240e396bc8
          ) 
          AND (
            `promotion`.`valid_until` > : param_9cfc5dea2b484bfa89b2d91eee598acf
          )
        )
      ) 
      AND `promotion`.`use_codes` = : param_fc5644ee2903400d9f4c6918c086fc17
    )
  ) 
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` = 0x27F88DD40BD740F0A51EB58270C3C347 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2025-07-19 05:37:57')) OR ((`promotion`.`valid_from` <= '2025-07-19 05:37:57') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-07-19 05:37:57') AND (`promotion`.`valid_until` > '2025-07-19 05:37:57'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;

SELECT 
  `paynl_payment_surcharge`.`id` as `paynl_payment_surcharge.id`, 
  `paynl_payment_surcharge`.`payment_method_id` as `paynl_payment_surcharge.paymentMethodId`, 
  `paynl_payment_surcharge`.`amount` as `paynl_payment_surcharge.amount`, 
  `paynl_payment_surcharge`.`order_value_limit` as `paynl_payment_surcharge.orderValueLimit`, 
  `paynl_payment_surcharge`.`type` as `paynl_payment_surcharge.type`, 
  `paynl_payment_surcharge`.`created_at` as `paynl_payment_surcharge.createdAt`, 
  `paynl_payment_surcharge`.`updated_at` as `paynl_payment_surcharge.updatedAt`, 
  `paynl_payment_surcharge.paymentMethod`.`id` as `paynl_payment_surcharge.paymentMethod.id`, 
  `paynl_payment_surcharge.paymentMethod`.`plugin_id` as `paynl_payment_surcharge.paymentMethod.pluginId`, 
  `paynl_payment_surcharge.paymentMethod`.`handler_identifier` as `paynl_payment_surcharge.paymentMethod.handlerIdentifier`, 
  `paynl_payment_surcharge.paymentMethod`.`position` as `paynl_payment_surcharge.paymentMethod.position`, 
  `paynl_payment_surcharge.paymentMethod`.`active` as `paynl_payment_surcharge.paymentMethod.active`, 
  `paynl_payment_surcharge.paymentMethod`.`after_order_enabled` as `paynl_payment_surcharge.paymentMethod.afterOrderEnabled`, 
  `paynl_payment_surcharge.paymentMethod`.`availability_rule_id` as `paynl_payment_surcharge.paymentMethod.availabilityRuleId`, 
  `paynl_payment_surcharge.paymentMethod`.`media_id` as `paynl_payment_surcharge.paymentMethod.mediaId`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.id`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`app_name` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.appName`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`identifier` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.identifier`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`pay_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.payUrl`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`finalize_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.finalizeUrl`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`validate_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.validateUrl`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`capture_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.captureUrl`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`refund_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.refundUrl`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`app_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.appId`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`original_media_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.originalMediaId`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`payment_method_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.paymentMethodId`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`created_at` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.createdAt`, 
  `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`updated_at` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.updatedAt`, 
  `paynl_payment_surcharge.paymentMethod`.`created_at` as `paynl_payment_surcharge.paymentMethod.createdAt`, 
  `paynl_payment_surcharge.paymentMethod`.`updated_at` as `paynl_payment_surcharge.paymentMethod.updatedAt`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`, 
  `paynl_payment_surcharge.paymentMethod.translation.name`, 
  COALESCE(
    `paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`, 
    `paynl_payment_surcharge.paymentMethod.translation.name`, 
    `paynl_payment_surcharge.paymentMethod.translation.name`
  ) as `paynl_payment_surcharge.paymentMethod.name`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`, 
  `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`, 
  COALESCE(
    `paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`, 
    `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`, 
    `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`
  ) as `paynl_payment_surcharge.paymentMethod.distinguishableName`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`, 
  `paynl_payment_surcharge.paymentMethod.translation.description`, 
  COALESCE(
    `paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`, 
    `paynl_payment_surcharge.paymentMethod.translation.description`, 
    `paynl_payment_surcharge.paymentMethod.translation.description`
  ) as `paynl_payment_surcharge.paymentMethod.description`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`, 
  `paynl_payment_surcharge.paymentMethod.translation.customFields`, 
  COALESCE(
    `paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`, 
    `paynl_payment_surcharge.paymentMethod.translation.customFields`, 
    `paynl_payment_surcharge.paymentMethod.translation.customFields`
  ) as `paynl_payment_surcharge.paymentMethod.customFields`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.createdAt`, 
  `paynl_payment_surcharge.paymentMethod.translation.createdAt`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.updatedAt`, 
  `paynl_payment_surcharge.paymentMethod.translation.updatedAt`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.paymentMethodId`, 
  `paynl_payment_surcharge.paymentMethod.translation.paymentMethodId`, 
  `paynl_payment_surcharge.paymentMethod.translation.fallback_1.languageId`, 
  `paynl_payment_surcharge.paymentMethod.translation.languageId` 
FROM 
  `paynl_payment_surcharge` 
  LEFT JOIN `payment_method` `paynl_payment_surcharge.paymentMethod` ON `paynl_payment_surcharge`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod`.`id` 
  LEFT JOIN (
    SELECT 
      `paynl_payment_surcharge.paymentMethod.translation`.payment_method_id, 
      `paynl_payment_surcharge.paymentMethod.translation`.name as `paynl_payment_surcharge.paymentMethod.translation.name`, 
      `paynl_payment_surcharge.paymentMethod.translation`.distinguishable_name as `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`, 
      `paynl_payment_surcharge.paymentMethod.translation`.description as `paynl_payment_surcharge.paymentMethod.translation.description`, 
      `paynl_payment_surcharge.paymentMethod.translation`.custom_fields as `paynl_payment_surcharge.paymentMethod.translation.customFields`, 
      `paynl_payment_surcharge.paymentMethod.translation`.created_at as `paynl_payment_surcharge.paymentMethod.translation.createdAt`, 
      `paynl_payment_surcharge.paymentMethod.translation`.updated_at as `paynl_payment_surcharge.paymentMethod.translation.updatedAt`, 
      `paynl_payment_surcharge.paymentMethod.translation`.payment_method_id as `paynl_payment_surcharge.paymentMethod.translation.paymentMethodId`, 
      `paynl_payment_surcharge.paymentMethod.translation`.language_id as `paynl_payment_surcharge.paymentMethod.translation.languageId`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.name as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.distinguishable_name as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.description as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.custom_fields as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.created_at as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.createdAt`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.updated_at as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.updatedAt`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.payment_method_id as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.paymentMethodId`, 
      `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.language_id as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.languageId` 
    FROM 
      `payment_method_translation` `paynl_payment_surcharge.paymentMethod.translation` 
      LEFT JOIN `payment_method_translation` `paynl_payment_surcharge.paymentMethod.translation.fallback_1` ON `paynl_payment_surcharge.paymentMethod.translation`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.`payment_method_id` 
      AND `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.language_id = : languageId1 
    WHERE 
      `paynl_payment_surcharge.paymentMethod.translation`.language_id = : languageId
  ) `paynl_payment_surcharge.paymentMethod.payment_method_translation` ON `paynl_payment_surcharge.paymentMethod.payment_method_translation`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod`.`id` 
  LEFT JOIN `app_payment_method` `paynl_payment_surcharge.paymentMethod.appPaymentMethod` ON `paynl_payment_surcharge.paymentMethod`.`id` = `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`payment_method_id` 
WHERE 
  (
    `paynl_payment_surcharge`.`payment_method_id` = : param_4740edc7a0f444c6a4d7c3dbe9d9df68
  )

SELECT `paynl_payment_surcharge`.`id` as `paynl_payment_surcharge.id`, `paynl_payment_surcharge`.`payment_method_id` as `paynl_payment_surcharge.paymentMethodId`, `paynl_payment_surcharge`.`amount` as `paynl_payment_surcharge.amount`, `paynl_payment_surcharge`.`order_value_limit` as `paynl_payment_surcharge.orderValueLimit`, `paynl_payment_surcharge`.`type` as `paynl_payment_surcharge.type`, `paynl_payment_surcharge`.`created_at` as `paynl_payment_surcharge.createdAt`, `paynl_payment_surcharge`.`updated_at` as `paynl_payment_surcharge.updatedAt`, `paynl_payment_surcharge.paymentMethod`.`id` as `paynl_payment_surcharge.paymentMethod.id`, `paynl_payment_surcharge.paymentMethod`.`plugin_id` as `paynl_payment_surcharge.paymentMethod.pluginId`, `paynl_payment_surcharge.paymentMethod`.`handler_identifier` as `paynl_payment_surcharge.paymentMethod.handlerIdentifier`, `paynl_payment_surcharge.paymentMethod`.`position` as `paynl_payment_surcharge.paymentMethod.position`, `paynl_payment_surcharge.paymentMethod`.`active` as `paynl_payment_surcharge.paymentMethod.active`, `paynl_payment_surcharge.paymentMethod`.`after_order_enabled` as `paynl_payment_surcharge.paymentMethod.afterOrderEnabled`, `paynl_payment_surcharge.paymentMethod`.`availability_rule_id` as `paynl_payment_surcharge.paymentMethod.availabilityRuleId`, `paynl_payment_surcharge.paymentMethod`.`media_id` as `paynl_payment_surcharge.paymentMethod.mediaId`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.id`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`app_name` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.appName`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`identifier` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.identifier`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`pay_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.payUrl`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`finalize_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.finalizeUrl`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`validate_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.validateUrl`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`capture_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.captureUrl`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`refund_url` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.refundUrl`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`app_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.appId`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`original_media_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.originalMediaId`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`payment_method_id` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.paymentMethodId`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`created_at` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.createdAt`, `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`updated_at` as `paynl_payment_surcharge.paymentMethod.appPaymentMethod.updatedAt`, `paynl_payment_surcharge.paymentMethod`.`created_at` as `paynl_payment_surcharge.paymentMethod.createdAt`, `paynl_payment_surcharge.paymentMethod`.`updated_at` as `paynl_payment_surcharge.paymentMethod.updatedAt`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`, `paynl_payment_surcharge.paymentMethod.translation.name`, COALESCE(`paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`,`paynl_payment_surcharge.paymentMethod.translation.name`,`paynl_payment_surcharge.paymentMethod.translation.name`) as `paynl_payment_surcharge.paymentMethod.name`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`, `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`, COALESCE(`paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`,`paynl_payment_surcharge.paymentMethod.translation.distinguishableName`,`paynl_payment_surcharge.paymentMethod.translation.distinguishableName`) as `paynl_payment_surcharge.paymentMethod.distinguishableName`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`, `paynl_payment_surcharge.paymentMethod.translation.description`, COALESCE(`paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`,`paynl_payment_surcharge.paymentMethod.translation.description`,`paynl_payment_surcharge.paymentMethod.translation.description`) as `paynl_payment_surcharge.paymentMethod.description`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`, `paynl_payment_surcharge.paymentMethod.translation.customFields`, COALESCE(`paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`,`paynl_payment_surcharge.paymentMethod.translation.customFields`,`paynl_payment_surcharge.paymentMethod.translation.customFields`) as `paynl_payment_surcharge.paymentMethod.customFields`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.createdAt`, `paynl_payment_surcharge.paymentMethod.translation.createdAt`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.updatedAt`, `paynl_payment_surcharge.paymentMethod.translation.updatedAt`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.paymentMethodId`, `paynl_payment_surcharge.paymentMethod.translation.paymentMethodId`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1.languageId`, `paynl_payment_surcharge.paymentMethod.translation.languageId` FROM `paynl_payment_surcharge` LEFT JOIN `payment_method` `paynl_payment_surcharge.paymentMethod` ON `paynl_payment_surcharge`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod`.`id` LEFT JOIN (SELECT `paynl_payment_surcharge.paymentMethod.translation`.payment_method_id, `paynl_payment_surcharge.paymentMethod.translation`.name as `paynl_payment_surcharge.paymentMethod.translation.name`, `paynl_payment_surcharge.paymentMethod.translation`.distinguishable_name as `paynl_payment_surcharge.paymentMethod.translation.distinguishableName`, `paynl_payment_surcharge.paymentMethod.translation`.description as `paynl_payment_surcharge.paymentMethod.translation.description`, `paynl_payment_surcharge.paymentMethod.translation`.custom_fields as `paynl_payment_surcharge.paymentMethod.translation.customFields`, `paynl_payment_surcharge.paymentMethod.translation`.created_at as `paynl_payment_surcharge.paymentMethod.translation.createdAt`, `paynl_payment_surcharge.paymentMethod.translation`.updated_at as `paynl_payment_surcharge.paymentMethod.translation.updatedAt`, `paynl_payment_surcharge.paymentMethod.translation`.payment_method_id as `paynl_payment_surcharge.paymentMethod.translation.paymentMethodId`, `paynl_payment_surcharge.paymentMethod.translation`.language_id as `paynl_payment_surcharge.paymentMethod.translation.languageId`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.name as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.name`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.distinguishable_name as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.distinguishableName`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.description as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.description`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.custom_fields as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.customFields`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.created_at as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.createdAt`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.updated_at as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.updatedAt`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.payment_method_id as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.paymentMethodId`, `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.language_id as `paynl_payment_surcharge.paymentMethod.translation.fallback_1.languageId` FROM `payment_method_translation` `paynl_payment_surcharge.paymentMethod.translation` LEFT JOIN `payment_method_translation` `paynl_payment_surcharge.paymentMethod.translation.fallback_1` ON `paynl_payment_surcharge.paymentMethod.translation`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.`payment_method_id` AND `paynl_payment_surcharge.paymentMethod.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 WHERE `paynl_payment_surcharge.paymentMethod.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `paynl_payment_surcharge.paymentMethod.payment_method_translation` ON `paynl_payment_surcharge.paymentMethod.payment_method_translation`.`payment_method_id` = `paynl_payment_surcharge.paymentMethod`.`id` LEFT JOIN `app_payment_method` `paynl_payment_surcharge.paymentMethod.appPaymentMethod` ON `paynl_payment_surcharge.paymentMethod`.`id` = `paynl_payment_surcharge.paymentMethod.appPaymentMethod`.`payment_method_id` WHERE (`paynl_payment_surcharge`.`payment_method_id` = 0xD3D9446802A44259755D38E6D163E820);

# 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.fallback_1.name`, 
  `shipping_method.deliveryTime.translation.name`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.name`, 
    `shipping_method.deliveryTime.translation.name`, 
    `shipping_method.deliveryTime.translation.name`
  ) as `shipping_method.deliveryTime.name`, 
  `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
  `shipping_method.deliveryTime.translation.customFields`, 
  COALESCE(
    `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`, 
    `shipping_method.deliveryTime.translation.customFields`
  ) as `shipping_method.deliveryTime.customFields`, 
  `shipping_method.deliveryTime.translation.fallback_1.createdAt`, 
  `shipping_method.deliveryTime.translation.createdAt`, 
  `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, 
  `shipping_method.deliveryTime.translation.updatedAt`, 
  `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.deliveryTimeId`, 
  `shipping_method.deliveryTime.translation.fallback_1.languageId`, 
  `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.fallback_1.name`, 
  `shipping_method.translation.name`, 
  COALESCE(
    `shipping_method.translation.fallback_1.name`, 
    `shipping_method.translation.name`, 
    `shipping_method.translation.name`
  ) as `shipping_method.name`, 
  `shipping_method.translation.fallback_1.description`, 
  `shipping_method.translation.description`, 
  COALESCE(
    `shipping_method.translation.fallback_1.description`, 
    `shipping_method.translation.description`, 
    `shipping_method.translation.description`
  ) as `shipping_method.description`, 
  `shipping_method.translation.fallback_1.trackingUrl`, 
  `shipping_method.translation.trackingUrl`, 
  COALESCE(
    `shipping_method.translation.fallback_1.trackingUrl`, 
    `shipping_method.translation.trackingUrl`, 
    `shipping_method.translation.trackingUrl`
  ) as `shipping_method.trackingUrl`, 
  `shipping_method.translation.fallback_1.customFields`, 
  `shipping_method.translation.customFields`, 
  COALESCE(
    `shipping_method.translation.fallback_1.customFields`, 
    `shipping_method.translation.customFields`, 
    `shipping_method.translation.customFields`
  ) as `shipping_method.customFields`, 
  `shipping_method.translation.fallback_1.createdAt`, 
  `shipping_method.translation.createdAt`, 
  `shipping_method.translation.fallback_1.updatedAt`, 
  `shipping_method.translation.updatedAt`, 
  `shipping_method.translation.fallback_1.shippingMethodId`, 
  `shipping_method.translation.shippingMethodId`, 
  `shipping_method.translation.fallback_1.languageId`, 
  `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`, 
      `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, 
      `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, 
      `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, 
      `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, 
      `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, 
      `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, 
      `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, 
      `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` 
    FROM 
      `shipping_method_translation` `shipping_method.translation` 
      LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` 
      AND `shipping_method.translation.fallback_1`.language_id = : languageId1 
    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`, 
      `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, 
      `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, 
      `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, 
      `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, 
      `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, 
      `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` 
    FROM 
      `delivery_time_translation` `shipping_method.deliveryTime.translation` 
      LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` 
      AND `shipping_method.deliveryTime.translation.fallback_1`.language_id = : languageId1 
    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.fallback_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.name`,`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.customFields`,`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1.languageId`, `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.fallback_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.fallback_1.name`,`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.fallback_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.fallback_1.description`,`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.fallback_1.trackingUrl`,`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.fallback_1.customFields`,`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.createdAt`, `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.fallback_1.languageId`, `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`, `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` AND `shipping_method.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 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`, `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 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 (0xEB3BD28661444BBC9873CF26D898DF18);