1.10 ms
(0.00%)
|
|
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
;
|
0.27 ms
(0.00%)
|
|
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;
|
0.91 ms
(0.00%)
|
|
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;
|
0.64 ms
(0.00%)
|
|
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 = 'vj3YqK3ErQzMkzPVdDLtMc8W8BuR7mRo') LIMIT 1;
|
1.44 ms
(0.00%)
|
|
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';
|
0.47 ms
(0.00%)
|
|
SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = :token
SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = 'vj3YqK3ErQzMkzPVdDLtMc8W8BuR7mRo';
|
1.77 ms
(0.00%)
|
|
SELECT `promotion`.`id` FROM `promotion` LEFT JOIN `promotion_sales_channel` `promotion.salesChannels` ON `promotion`.`id` = `promotion.salesChannels`.`promotion_id` WHERE ((`promotion`.`active` = :param_d8d95311a022443f94c4dd5840d87455 AND `promotion.salesChannels`.`sales_channel_id` = :param_852b5ae123854a479b9fb000143fe0b6 AND ((`promotion`.`valid_from` <=> :param_6c7b07502ce245958cee76675d206ecf AND `promotion`.`valid_until` <=> :param_21d6142e41974b9f8587c3df58f22720) OR (`promotion`.`valid_from` <=> :param_a8cb6f2f8adf4cbf9042f9c81e331849 AND (`promotion`.`valid_until` > :param_e2ecaf0d39b641f494f492b1080cb6f2)) OR ((`promotion`.`valid_from` <= :param_0c7e586f7f864885998727ad1f37ba23) AND `promotion`.`valid_until` <=> :param_7e59da92d8ae46349b7d82cc2a5d39cb) OR ((`promotion`.`valid_from` <= :param_0b201475a78747aa86d0629b96afeb57) AND (`promotion`.`valid_until` > :param_61ab2f96e9564975997fbaa3b9e87c99))) AND `promotion`.`use_codes` = :param_6203433dcf9447eca4704aca535a2769)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC
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-17 10:30:47')) OR ((`promotion`.`valid_from` <= '2025-07-17 10:30:47') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2025-07-17 10:30:47') AND (`promotion`.`valid_until` > '2025-07-17 10:30:47'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;
|
21.80 ms
(0.00%)
|
|
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_a99e64987b6644b4b492f57141f68b3a)
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_a99e64987b6644b4b492f57141f68b3a
)
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);
|
21.27 ms
(0.00%)
|
|
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)
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)
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);
|
1.23 ms
(0.00%)
|
|
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (:param_360043d12aa84602ba0f23749f9cd1a7))
SELECT `shipping_method_price`.`id` as `shipping_method_price.id`, `shipping_method_price`.`shipping_method_id` as `shipping_method_price.shippingMethodId`, `shipping_method_price`.`rule_id` as `shipping_method_price.ruleId`, `shipping_method_price`.`calculation` as `shipping_method_price.calculation`, `shipping_method_price`.`calculation_rule_id` as `shipping_method_price.calculationRuleId`, `shipping_method_price`.`quantity_start` as `shipping_method_price.quantityStart`, `shipping_method_price`.`quantity_end` as `shipping_method_price.quantityEnd`, `shipping_method_price`.`currency_price` as `shipping_method_price.currencyPrice`, `shipping_method_price`.`custom_fields` as `shipping_method_price.customFields`, `shipping_method_price`.`created_at` as `shipping_method_price.createdAt`, `shipping_method_price`.`updated_at` as `shipping_method_price.updatedAt` FROM `shipping_method_price` WHERE (`shipping_method_price`.`shipping_method_id` IN (0xEB3BD28661444BBC9873CF26D898DF18));
|
0.79 ms
(0.00%)
|
|
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 = 0x27F88DD40BD740F0A51EB58270C3C347) AND (configuration_key LIKE 'PaynlPaymentShopware6.config.%') ORDER BY sales_channel_id ASC;
|
0.76 ms
(0.00%)
|
|
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE ((`country.salesChannels`.`id` = :param_4ddd78a8a5524b7e8a5c83457d4e001c)) AND (`country`.`id` IN (:ids)) GROUP BY `country`.`id`
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE ((`country.salesChannels`.`id` = 0x27F88DD40BD740F0A51EB58270C3C347)) AND (`country`.`id` IN (0x4AC1E6FF53AF4EEBACAADFB5087669A5)) GROUP BY `country`.`id`;
|
21.04 ms
(0.00%)
|
|
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_393f752915cf432daeebdff848d6e023)
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_393f752915cf432daeebdff848d6e023
)
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);
|
0.69 ms
(0.00%)
|
|
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 = 0x27F88DD40BD740F0A51EB58270C3C347) AND (configuration_key LIKE 'PaynlPaymentShopware6.config.%') ORDER BY sales_channel_id ASC;
|
0.75 ms
(0.00%)
|
|
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE `app`.`active` = 1 AND `app_template`.`active` = 1
SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
FROM `app`
INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE `app`.`active` = 1 AND `app_template`.`active` = 1;
|
0.49 ms
(0.00%)
|
|
SELECT `name`, `path`, `author`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`
FROM `app`
WHERE `active` = 1
;
|
1.50 ms
(0.00%)
|
|
SELECT `jett_mce_setting`.`id` FROM `jett_mce_setting` LEFT JOIN `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping` ON `jett_mce_setting`.`id` = `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id` LEFT JOIN `jett_mce_setting_language` `jett_mce_setting.languages.mapping` ON `jett_mce_setting`.`id` = `jett_mce_setting.languages.mapping`.`jett_mce_setting_id` LEFT JOIN `sales_channel` `jett_mce_setting.salesChannels` ON `jett_mce_setting.salesChannels.mapping`.`sales_channel_id` = `jett_mce_setting.salesChannels`.`id` LEFT JOIN `language` `jett_mce_setting.languages` ON `jett_mce_setting.languages.mapping`.`language_id` = `jett_mce_setting.languages`.`id` WHERE ((`jett_mce_setting.salesChannels`.`id` = :param_4001ad74f6a74e11aefda818a42942b6 AND `jett_mce_setting.languages`.`id` = :param_cc4465b9e9d04fde8bcd441350f79ba8)) GROUP BY `jett_mce_setting`.`id`
SELECT `jett_mce_setting`.`id` FROM `jett_mce_setting` LEFT JOIN `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping` ON `jett_mce_setting`.`id` = `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id` LEFT JOIN `jett_mce_setting_language` `jett_mce_setting.languages.mapping` ON `jett_mce_setting`.`id` = `jett_mce_setting.languages.mapping`.`jett_mce_setting_id` LEFT JOIN `sales_channel` `jett_mce_setting.salesChannels` ON `jett_mce_setting.salesChannels.mapping`.`sales_channel_id` = `jett_mce_setting.salesChannels`.`id` LEFT JOIN `language` `jett_mce_setting.languages` ON `jett_mce_setting.languages.mapping`.`language_id` = `jett_mce_setting.languages`.`id` WHERE ((`jett_mce_setting.salesChannels`.`id` = 0x27F88DD40BD740F0A51EB58270C3C347 AND `jett_mce_setting.languages`.`id` = 0x474CBBBE6FF3467A9970FAB9CDCA2A73)) GROUP BY `jett_mce_setting`.`id`;
|
4.31 ms
(0.00%)
|
|
SELECT `jett_mce_setting`.`id` as `jett_mce_setting.id`, `jett_mce_setting`.`active` as `jett_mce_setting.active`, `jett_mce_setting`.`label` as `jett_mce_setting.label`, `jett_mce_setting`.`api_key` as `jett_mce_setting.apiKey`, `jett_mce_setting`.`list_id` as `jett_mce_setting.listId`, `jett_mce_setting`.`list_name` as `jett_mce_setting.listName`, `jett_mce_setting`.`store_id` as `jett_mce_setting.storeId`, `jett_mce_setting`.`store_name` as `jett_mce_setting.storeName`, `jett_mce_setting`.`store_domain_id` as `jett_mce_setting.storeDomainId`, `jett_mce_setting`.`store_currency_code` as `jett_mce_setting.storeCurrencyCode`, `jett_mce_setting`.`store_connected_site` as `jett_mce_setting.storeConnectedSite`, `jett_mce_setting`.`embed_connected_site` as `jett_mce_setting.embedConnectedSite`, `jett_mce_setting`.`customer_groups` as `jett_mce_setting.customerGroups`, `jett_mce_setting`.`subscriber_status` as `jett_mce_setting.subscriberStatus`, `jett_mce_setting`.`abandoned_carts` as `jett_mce_setting.abandonedCarts`, `jett_mce_setting`.`log_storage_period` as `jett_mce_setting.logStoragePeriod`, `jett_mce_setting`.`sync_limit` as `jett_mce_setting.syncLimit`, `jett_mce_setting`.`stats` as `jett_mce_setting.stats`, `jett_mce_setting`.`merge_fields` as `jett_mce_setting.mergeFields`, `jett_mce_setting`.`subscriber_sync_active` as `jett_mce_setting.subscriberSyncActive`, `jett_mce_setting`.`sync_all_languages` as `jett_mce_setting.syncAllLanguages`, `jett_mce_setting`.`stats_sync_date` as `jett_mce_setting.statsSyncDate`, `jett_mce_setting`.`last_sync_date_for_orders` as `jett_mce_setting.lastSyncDateForOrders`, `jett_mce_setting`.`last_sync_date_for_products` as `jett_mce_setting.lastSyncDateForProducts`, `jett_mce_setting`.`last_sync_date_for_customers` as `jett_mce_setting.lastSyncDateForCustomers`, `jett_mce_setting`.`last_sync_date_for_subscribers` as `jett_mce_setting.lastSyncDateForSubscribers`, `jett_mce_setting`.`created_at` as `jett_mce_setting.createdAt`, `jett_mce_setting`.`updated_at` as `jett_mce_setting.updatedAt`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
FROM `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping`
WHERE `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.salesChannels.id_mapping`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.languages.mapping`.`language_id`) SEPARATOR '||')
FROM `jett_mce_setting_language` `jett_mce_setting.languages.mapping`
WHERE `jett_mce_setting.languages.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.languages.id_mapping` FROM `jett_mce_setting` WHERE `jett_mce_setting`.`id` IN (:ids)
SELECT `jett_mce_setting`.`id` as `jett_mce_setting.id`, `jett_mce_setting`.`active` as `jett_mce_setting.active`, `jett_mce_setting`.`label` as `jett_mce_setting.label`, `jett_mce_setting`.`api_key` as `jett_mce_setting.apiKey`, `jett_mce_setting`.`list_id` as `jett_mce_setting.listId`, `jett_mce_setting`.`list_name` as `jett_mce_setting.listName`, `jett_mce_setting`.`store_id` as `jett_mce_setting.storeId`, `jett_mce_setting`.`store_name` as `jett_mce_setting.storeName`, `jett_mce_setting`.`store_domain_id` as `jett_mce_setting.storeDomainId`, `jett_mce_setting`.`store_currency_code` as `jett_mce_setting.storeCurrencyCode`, `jett_mce_setting`.`store_connected_site` as `jett_mce_setting.storeConnectedSite`, `jett_mce_setting`.`embed_connected_site` as `jett_mce_setting.embedConnectedSite`, `jett_mce_setting`.`customer_groups` as `jett_mce_setting.customerGroups`, `jett_mce_setting`.`subscriber_status` as `jett_mce_setting.subscriberStatus`, `jett_mce_setting`.`abandoned_carts` as `jett_mce_setting.abandonedCarts`, `jett_mce_setting`.`log_storage_period` as `jett_mce_setting.logStoragePeriod`, `jett_mce_setting`.`sync_limit` as `jett_mce_setting.syncLimit`, `jett_mce_setting`.`stats` as `jett_mce_setting.stats`, `jett_mce_setting`.`merge_fields` as `jett_mce_setting.mergeFields`, `jett_mce_setting`.`subscriber_sync_active` as `jett_mce_setting.subscriberSyncActive`, `jett_mce_setting`.`sync_all_languages` as `jett_mce_setting.syncAllLanguages`, `jett_mce_setting`.`stats_sync_date` as `jett_mce_setting.statsSyncDate`, `jett_mce_setting`.`last_sync_date_for_orders` as `jett_mce_setting.lastSyncDateForOrders`, `jett_mce_setting`.`last_sync_date_for_products` as `jett_mce_setting.lastSyncDateForProducts`, `jett_mce_setting`.`last_sync_date_for_customers` as `jett_mce_setting.lastSyncDateForCustomers`, `jett_mce_setting`.`last_sync_date_for_subscribers` as `jett_mce_setting.lastSyncDateForSubscribers`, `jett_mce_setting`.`created_at` as `jett_mce_setting.createdAt`, `jett_mce_setting`.`updated_at` as `jett_mce_setting.updatedAt`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
FROM `jett_mce_setting_sales_channel` `jett_mce_setting.salesChannels.mapping`
WHERE `jett_mce_setting.salesChannels.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.salesChannels.id_mapping`, (SELECT GROUP_CONCAT(HEX(`jett_mce_setting.languages.mapping`.`language_id`) SEPARATOR '||')
FROM `jett_mce_setting_language` `jett_mce_setting.languages.mapping`
WHERE `jett_mce_setting.languages.mapping`.`jett_mce_setting_id` = `jett_mce_setting`.`id` ) as `jett_mce_setting.languages.id_mapping` FROM `jett_mce_setting` WHERE `jett_mce_setting`.`id` IN (0xDD8A9B19E43842A6803D02A3C81177E0);
|
13.36 ms
(0.00%)
|
|
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = :languageId) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` WHERE `sales_channel`.`id` IN (:ids)
SELECT
`sales_channel`.`id` as `sales_channel.id`,
`sales_channel`.`type_id` as `sales_channel.typeId`,
`sales_channel`.`language_id` as `sales_channel.languageId`,
`sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`,
`sales_channel`.`currency_id` as `sales_channel.currencyId`,
`sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`,
`sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`,
`sales_channel`.`country_id` as `sales_channel.countryId`,
`sales_channel`.`analytics_id` as `sales_channel.analyticsId`,
`sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`,
`sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`,
`sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`,
`sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`,
`sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`,
`sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`,
`sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`,
`sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`,
`sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`,
`sales_channel`.`short_name` as `sales_channel.shortName`,
`sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`,
`sales_channel`.`access_key` as `sales_channel.accessKey`,
`sales_channel`.`configuration` as `sales_channel.configuration`,
`sales_channel`.`active` as `sales_channel.active`,
`sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`,
`sales_channel`.`maintenance` as `sales_channel.maintenance`,
`sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`,
`sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`,
`sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`,
`sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`,
`sales_channel.analytics`.`id` as `sales_channel.analytics.id`,
`sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`,
`sales_channel.analytics`.`active` as `sales_channel.analytics.active`,
`sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`,
`sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`,
`sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`,
`sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`,
`sales_channel`.`created_at` as `sales_channel.createdAt`,
`sales_channel`.`updated_at` as `sales_channel.updatedAt`,
`sales_channel.translation.name`,
COALESCE(
`sales_channel.translation.name`,
`sales_channel.translation.name`
) as `sales_channel.name`,
`sales_channel.translation.homeSlotConfig`,
COALESCE(
`sales_channel.translation.homeSlotConfig`,
`sales_channel.translation.homeSlotConfig`
) as `sales_channel.homeSlotConfig`,
`sales_channel.translation.homeEnabled`,
COALESCE(
`sales_channel.translation.homeEnabled`,
`sales_channel.translation.homeEnabled`
) as `sales_channel.homeEnabled`,
`sales_channel.translation.homeName`,
COALESCE(
`sales_channel.translation.homeName`,
`sales_channel.translation.homeName`
) as `sales_channel.homeName`,
`sales_channel.translation.homeMetaTitle`,
COALESCE(
`sales_channel.translation.homeMetaTitle`,
`sales_channel.translation.homeMetaTitle`
) as `sales_channel.homeMetaTitle`,
`sales_channel.translation.homeMetaDescription`,
COALESCE(
`sales_channel.translation.homeMetaDescription`,
`sales_channel.translation.homeMetaDescription`
) as `sales_channel.homeMetaDescription`,
`sales_channel.translation.homeKeywords`,
COALESCE(
`sales_channel.translation.homeKeywords`,
`sales_channel.translation.homeKeywords`
) as `sales_channel.homeKeywords`,
`sales_channel.translation.customFields`,
COALESCE(
`sales_channel.translation.customFields`,
`sales_channel.translation.customFields`
) as `sales_channel.customFields`,
`sales_channel.translation.createdAt`,
`sales_channel.translation.updatedAt`,
`sales_channel.translation.salesChannelId`,
`sales_channel.translation.languageId`
FROM
`sales_channel`
LEFT JOIN (
SELECT
`sales_channel.translation`.sales_channel_id,
`sales_channel.translation`.name as `sales_channel.translation.name`,
`sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`,
`sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`,
`sales_channel.translation`.home_name as `sales_channel.translation.homeName`,
`sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`,
`sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`,
`sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`,
`sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`,
`sales_channel.translation`.created_at as `sales_channel.translation.createdAt`,
`sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`,
`sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`,
`sales_channel.translation`.language_id as `sales_channel.translation.languageId`
FROM
`sales_channel_translation` `sales_channel.translation`
WHERE
`sales_channel.translation`.language_id = : languageId
) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id`
LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id`
WHERE
`sales_channel`.`id` IN (: ids)
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` WHERE `sales_channel`.`id` IN (0x27F88DD40BD740F0A51EB58270C3C347);
|
0.61 ms
(0.00%)
|
|
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language` WHERE `language`.`id` IN (:ids)
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt` FROM `language` WHERE `language`.`id` IN (0x474CBBBE6FF3467A9970FAB9CDCA2A73);
|
0.66 ms
(0.00%)
|
|
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = :param_d7a23b92bd264b25865b107a1b51dd5a AND (`rhiem_ar_group`.`channel_ids` = :param_6b057e8c5434460f9514099f410ef5f0 OR `rhiem_ar_group`.`channel_ids` <=> :param_2a57a5dd8d7e47398ab128bf50f20dd7 OR `rhiem_ar_group`.`channel_ids` LIKE :param_37f754d37da749c7987ed0e169f98bee)) ORDER BY `rhiem_ar_group`.`position` ASC
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = 1 AND (`rhiem_ar_group`.`channel_ids` = '[]' OR `rhiem_ar_group`.`channel_ids` <=> NULL OR `rhiem_ar_group`.`channel_ids` LIKE '%27f88dd40bd740f0a51eb58270c3c347%')) ORDER BY `rhiem_ar_group`.`position` ASC;
|
4.03 ms
(0.00%)
|
|
SELECT `rhiem_ar_group`.`id` as `rhiem_ar_group.id`, `rhiem_ar_group`.`name` as `rhiem_ar_group.name`, `rhiem_ar_group`.`active` as `rhiem_ar_group.active`, `rhiem_ar_group`.`position` as `rhiem_ar_group.position`, `rhiem_ar_group`.`channel_ids` as `rhiem_ar_group.channelIds`, `rhiem_ar_group`.`standard` as `rhiem_ar_group.standard`, `rhiem_ar_group`.`created_at` as `rhiem_ar_group.createdAt`, `rhiem_ar_group`.`updated_at` as `rhiem_ar_group.updatedAt`, `rhiem_ar_group.translation.fallback_1.label`, `rhiem_ar_group.translation.label`, COALESCE(`rhiem_ar_group.translation.fallback_1.label`,`rhiem_ar_group.translation.label`,`rhiem_ar_group.translation.label`) as `rhiem_ar_group.label`, `rhiem_ar_group.translation.fallback_1.description`, `rhiem_ar_group.translation.description`, COALESCE(`rhiem_ar_group.translation.fallback_1.description`,`rhiem_ar_group.translation.description`,`rhiem_ar_group.translation.description`) as `rhiem_ar_group.description`, `rhiem_ar_group.translation.fallback_1.createdAt`, `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation.fallback_1.updatedAt`, `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation.fallback_1.rhiemArGroupId`, `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation.fallback_1.languageId`, `rhiem_ar_group.translation.languageId` FROM `rhiem_ar_group` LEFT JOIN (SELECT `rhiem_ar_group.translation`.rhiem_ar_group_id, `rhiem_ar_group.translation`.label as `rhiem_ar_group.translation.label`, `rhiem_ar_group.translation`.description as `rhiem_ar_group.translation.description`, `rhiem_ar_group.translation`.created_at as `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation`.updated_at as `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation`.rhiem_ar_group_id as `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation`.language_id as `rhiem_ar_group.translation.languageId`, `rhiem_ar_group.translation.fallback_1`.label as `rhiem_ar_group.translation.fallback_1.label`, `rhiem_ar_group.translation.fallback_1`.description as `rhiem_ar_group.translation.fallback_1.description`, `rhiem_ar_group.translation.fallback_1`.created_at as `rhiem_ar_group.translation.fallback_1.createdAt`, `rhiem_ar_group.translation.fallback_1`.updated_at as `rhiem_ar_group.translation.fallback_1.updatedAt`, `rhiem_ar_group.translation.fallback_1`.rhiem_ar_group_id as `rhiem_ar_group.translation.fallback_1.rhiemArGroupId`, `rhiem_ar_group.translation.fallback_1`.language_id as `rhiem_ar_group.translation.fallback_1.languageId` FROM `rhiem_ar_group_translation` `rhiem_ar_group.translation` LEFT JOIN `rhiem_ar_group_translation` `rhiem_ar_group.translation.fallback_1` ON `rhiem_ar_group.translation`.`rhiem_ar_group_id` = `rhiem_ar_group.translation.fallback_1`.`rhiem_ar_group_id` AND `rhiem_ar_group.translation.fallback_1`.language_id = :languageId1 WHERE `rhiem_ar_group.translation`.language_id = :languageId) `rhiem_ar_group.rhiem_ar_group_translation` ON `rhiem_ar_group.rhiem_ar_group_translation`.`rhiem_ar_group_id` = `rhiem_ar_group`.`id` WHERE `rhiem_ar_group`.`id` IN (:ids)
SELECT `rhiem_ar_group`.`id` as `rhiem_ar_group.id`, `rhiem_ar_group`.`name` as `rhiem_ar_group.name`, `rhiem_ar_group`.`active` as `rhiem_ar_group.active`, `rhiem_ar_group`.`position` as `rhiem_ar_group.position`, `rhiem_ar_group`.`channel_ids` as `rhiem_ar_group.channelIds`, `rhiem_ar_group`.`standard` as `rhiem_ar_group.standard`, `rhiem_ar_group`.`created_at` as `rhiem_ar_group.createdAt`, `rhiem_ar_group`.`updated_at` as `rhiem_ar_group.updatedAt`, `rhiem_ar_group.translation.fallback_1.label`, `rhiem_ar_group.translation.label`, COALESCE(`rhiem_ar_group.translation.fallback_1.label`,`rhiem_ar_group.translation.label`,`rhiem_ar_group.translation.label`) as `rhiem_ar_group.label`, `rhiem_ar_group.translation.fallback_1.description`, `rhiem_ar_group.translation.description`, COALESCE(`rhiem_ar_group.translation.fallback_1.description`,`rhiem_ar_group.translation.description`,`rhiem_ar_group.translation.description`) as `rhiem_ar_group.description`, `rhiem_ar_group.translation.fallback_1.createdAt`, `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation.fallback_1.updatedAt`, `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation.fallback_1.rhiemArGroupId`, `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation.fallback_1.languageId`, `rhiem_ar_group.translation.languageId` FROM `rhiem_ar_group` LEFT JOIN (SELECT `rhiem_ar_group.translation`.rhiem_ar_group_id, `rhiem_ar_group.translation`.label as `rhiem_ar_group.translation.label`, `rhiem_ar_group.translation`.description as `rhiem_ar_group.translation.description`, `rhiem_ar_group.translation`.created_at as `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation`.updated_at as `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation`.rhiem_ar_group_id as `rhiem_ar_group.translation.rhiemArGroupId`, `rhiem_ar_group.translation`.language_id as `rhiem_ar_group.translation.languageId`, `rhiem_ar_group.translation.fallback_1`.label as `rhiem_ar_group.translation.fallback_1.label`, `rhiem_ar_group.translation.fallback_1`.description as `rhiem_ar_group.translation.fallback_1.description`, `rhiem_ar_group.translation.fallback_1`.created_at as `rhiem_ar_group.translation.fallback_1.createdAt`, `rhiem_ar_group.translation.fallback_1`.updated_at as `rhiem_ar_group.translation.fallback_1.updatedAt`, `rhiem_ar_group.translation.fallback_1`.rhiem_ar_group_id as `rhiem_ar_group.translation.fallback_1.rhiemArGroupId`, `rhiem_ar_group.translation.fallback_1`.language_id as `rhiem_ar_group.translation.fallback_1.languageId` FROM `rhiem_ar_group_translation` `rhiem_ar_group.translation` LEFT JOIN `rhiem_ar_group_translation` `rhiem_ar_group.translation.fallback_1` ON `rhiem_ar_group.translation`.`rhiem_ar_group_id` = `rhiem_ar_group.translation.fallback_1`.`rhiem_ar_group_id` AND `rhiem_ar_group.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 WHERE `rhiem_ar_group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `rhiem_ar_group.rhiem_ar_group_translation` ON `rhiem_ar_group.rhiem_ar_group_translation`.`rhiem_ar_group_id` = `rhiem_ar_group`.`id` WHERE `rhiem_ar_group`.`id` IN (0x5788BBCA474B4C12B802B218BA2860DC);
|
10.73 ms
(0.00%)
|
|
SELECT `rhiem_ar_attribute`.`id` as `rhiem_ar_attribute.id`, `rhiem_ar_attribute`.`group_id` as `rhiem_ar_attribute.groupId`, `rhiem_ar_attribute`.`type` as `rhiem_ar_attribute.type`, `rhiem_ar_attribute`.`name` as `rhiem_ar_attribute.name`, `rhiem_ar_attribute`.`required` as `rhiem_ar_attribute.required`, `rhiem_ar_attribute`.`value_min` as `rhiem_ar_attribute.valueMin`, `rhiem_ar_attribute`.`value_max` as `rhiem_ar_attribute.valueMax`, `rhiem_ar_attribute`.`min_max` as `rhiem_ar_attribute.minMax`, `rhiem_ar_attribute`.`active` as `rhiem_ar_attribute.active`, `rhiem_ar_attribute`.`position` as `rhiem_ar_attribute.position`, `rhiem_ar_attribute`.`standard` as `rhiem_ar_attribute.standard`, `rhiem_ar_attribute`.`channel_ids` as `rhiem_ar_attribute.channelIds`, `rhiem_ar_attribute`.`created_at` as `rhiem_ar_attribute.createdAt`, `rhiem_ar_attribute`.`updated_at` as `rhiem_ar_attribute.updatedAt`, `rhiem_ar_attribute.translation.fallback_1.label`, `rhiem_ar_attribute.translation.label`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.label`,`rhiem_ar_attribute.translation.label`,`rhiem_ar_attribute.translation.label`) as `rhiem_ar_attribute.label`, `rhiem_ar_attribute.translation.fallback_1.description`, `rhiem_ar_attribute.translation.description`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.description`,`rhiem_ar_attribute.translation.description`,`rhiem_ar_attribute.translation.description`) as `rhiem_ar_attribute.description`, `rhiem_ar_attribute.translation.fallback_1.errorMsg`, `rhiem_ar_attribute.translation.errorMsg`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`) as `rhiem_ar_attribute.errorMsg`, `rhiem_ar_attribute.translation.fallback_1.errorMsgMin`, `rhiem_ar_attribute.translation.errorMsgMin`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`) as `rhiem_ar_attribute.errorMsgMin`, `rhiem_ar_attribute.translation.fallback_1.errorMsgMax`, `rhiem_ar_attribute.translation.errorMsgMax`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`) as `rhiem_ar_attribute.errorMsgMax`, `rhiem_ar_attribute.translation.fallback_1.createdAt`, `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation.fallback_1.updatedAt`, `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`, `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation.fallback_1.languageId`, `rhiem_ar_attribute.translation.languageId` FROM `rhiem_ar_attribute` LEFT JOIN (SELECT `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id, `rhiem_ar_attribute.translation`.label as `rhiem_ar_attribute.translation.label`, `rhiem_ar_attribute.translation`.description as `rhiem_ar_attribute.translation.description`, `rhiem_ar_attribute.translation`.error_msg as `rhiem_ar_attribute.translation.errorMsg`, `rhiem_ar_attribute.translation`.error_msg_min as `rhiem_ar_attribute.translation.errorMsgMin`, `rhiem_ar_attribute.translation`.error_msg_max as `rhiem_ar_attribute.translation.errorMsgMax`, `rhiem_ar_attribute.translation`.created_at as `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation`.updated_at as `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation`.language_id as `rhiem_ar_attribute.translation.languageId`, `rhiem_ar_attribute.translation.fallback_1`.label as `rhiem_ar_attribute.translation.fallback_1.label`, `rhiem_ar_attribute.translation.fallback_1`.description as `rhiem_ar_attribute.translation.fallback_1.description`, `rhiem_ar_attribute.translation.fallback_1`.error_msg as `rhiem_ar_attribute.translation.fallback_1.errorMsg`, `rhiem_ar_attribute.translation.fallback_1`.error_msg_min as `rhiem_ar_attribute.translation.fallback_1.errorMsgMin`, `rhiem_ar_attribute.translation.fallback_1`.error_msg_max as `rhiem_ar_attribute.translation.fallback_1.errorMsgMax`, `rhiem_ar_attribute.translation.fallback_1`.created_at as `rhiem_ar_attribute.translation.fallback_1.createdAt`, `rhiem_ar_attribute.translation.fallback_1`.updated_at as `rhiem_ar_attribute.translation.fallback_1.updatedAt`, `rhiem_ar_attribute.translation.fallback_1`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`, `rhiem_ar_attribute.translation.fallback_1`.language_id as `rhiem_ar_attribute.translation.fallback_1.languageId` FROM `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation` LEFT JOIN `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation.fallback_1` ON `rhiem_ar_attribute.translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute.translation.fallback_1`.`rhiem_ar_attribute_id` AND `rhiem_ar_attribute.translation.fallback_1`.language_id = :languageId1 WHERE `rhiem_ar_attribute.translation`.language_id = :languageId) `rhiem_ar_attribute.rhiem_ar_attribute_translation` ON `rhiem_ar_attribute.rhiem_ar_attribute_translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute`.`id` WHERE (`rhiem_ar_attribute`.`active` = :param_419dfb28432540a98d87e080ebe38996 AND (`rhiem_ar_attribute`.`channel_ids` = :param_d65eb8f4f94d45388f22bb9c8ddce3a4 OR `rhiem_ar_attribute`.`channel_ids` <=> :param_cb2c6ddae6f14d6c850cb96a0e4613ed OR `rhiem_ar_attribute`.`channel_ids` LIKE :param_b2accb688b2f4e009fa13fe7e1f6c477) AND `rhiem_ar_attribute`.`group_id` IN (:param_6c49f720252247f3836859a842062beb)) ORDER BY `rhiem_ar_attribute`.`position` ASC
SELECT
`rhiem_ar_attribute`.`id` as `rhiem_ar_attribute.id`,
`rhiem_ar_attribute`.`group_id` as `rhiem_ar_attribute.groupId`,
`rhiem_ar_attribute`.`type` as `rhiem_ar_attribute.type`,
`rhiem_ar_attribute`.`name` as `rhiem_ar_attribute.name`,
`rhiem_ar_attribute`.`required` as `rhiem_ar_attribute.required`,
`rhiem_ar_attribute`.`value_min` as `rhiem_ar_attribute.valueMin`,
`rhiem_ar_attribute`.`value_max` as `rhiem_ar_attribute.valueMax`,
`rhiem_ar_attribute`.`min_max` as `rhiem_ar_attribute.minMax`,
`rhiem_ar_attribute`.`active` as `rhiem_ar_attribute.active`,
`rhiem_ar_attribute`.`position` as `rhiem_ar_attribute.position`,
`rhiem_ar_attribute`.`standard` as `rhiem_ar_attribute.standard`,
`rhiem_ar_attribute`.`channel_ids` as `rhiem_ar_attribute.channelIds`,
`rhiem_ar_attribute`.`created_at` as `rhiem_ar_attribute.createdAt`,
`rhiem_ar_attribute`.`updated_at` as `rhiem_ar_attribute.updatedAt`,
`rhiem_ar_attribute.translation.fallback_1.label`,
`rhiem_ar_attribute.translation.label`,
COALESCE(
`rhiem_ar_attribute.translation.fallback_1.label`,
`rhiem_ar_attribute.translation.label`,
`rhiem_ar_attribute.translation.label`
) as `rhiem_ar_attribute.label`,
`rhiem_ar_attribute.translation.fallback_1.description`,
`rhiem_ar_attribute.translation.description`,
COALESCE(
`rhiem_ar_attribute.translation.fallback_1.description`,
`rhiem_ar_attribute.translation.description`,
`rhiem_ar_attribute.translation.description`
) as `rhiem_ar_attribute.description`,
`rhiem_ar_attribute.translation.fallback_1.errorMsg`,
`rhiem_ar_attribute.translation.errorMsg`,
COALESCE(
`rhiem_ar_attribute.translation.fallback_1.errorMsg`,
`rhiem_ar_attribute.translation.errorMsg`,
`rhiem_ar_attribute.translation.errorMsg`
) as `rhiem_ar_attribute.errorMsg`,
`rhiem_ar_attribute.translation.fallback_1.errorMsgMin`,
`rhiem_ar_attribute.translation.errorMsgMin`,
COALESCE(
`rhiem_ar_attribute.translation.fallback_1.errorMsgMin`,
`rhiem_ar_attribute.translation.errorMsgMin`,
`rhiem_ar_attribute.translation.errorMsgMin`
) as `rhiem_ar_attribute.errorMsgMin`,
`rhiem_ar_attribute.translation.fallback_1.errorMsgMax`,
`rhiem_ar_attribute.translation.errorMsgMax`,
COALESCE(
`rhiem_ar_attribute.translation.fallback_1.errorMsgMax`,
`rhiem_ar_attribute.translation.errorMsgMax`,
`rhiem_ar_attribute.translation.errorMsgMax`
) as `rhiem_ar_attribute.errorMsgMax`,
`rhiem_ar_attribute.translation.fallback_1.createdAt`,
`rhiem_ar_attribute.translation.createdAt`,
`rhiem_ar_attribute.translation.fallback_1.updatedAt`,
`rhiem_ar_attribute.translation.updatedAt`,
`rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`,
`rhiem_ar_attribute.translation.rhiemArAttributeId`,
`rhiem_ar_attribute.translation.fallback_1.languageId`,
`rhiem_ar_attribute.translation.languageId`
FROM
`rhiem_ar_attribute`
LEFT JOIN (
SELECT
`rhiem_ar_attribute.translation`.rhiem_ar_attribute_id,
`rhiem_ar_attribute.translation`.label as `rhiem_ar_attribute.translation.label`,
`rhiem_ar_attribute.translation`.description as `rhiem_ar_attribute.translation.description`,
`rhiem_ar_attribute.translation`.error_msg as `rhiem_ar_attribute.translation.errorMsg`,
`rhiem_ar_attribute.translation`.error_msg_min as `rhiem_ar_attribute.translation.errorMsgMin`,
`rhiem_ar_attribute.translation`.error_msg_max as `rhiem_ar_attribute.translation.errorMsgMax`,
`rhiem_ar_attribute.translation`.created_at as `rhiem_ar_attribute.translation.createdAt`,
`rhiem_ar_attribute.translation`.updated_at as `rhiem_ar_attribute.translation.updatedAt`,
`rhiem_ar_attribute.translation`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.rhiemArAttributeId`,
`rhiem_ar_attribute.translation`.language_id as `rhiem_ar_attribute.translation.languageId`,
`rhiem_ar_attribute.translation.fallback_1`.label as `rhiem_ar_attribute.translation.fallback_1.label`,
`rhiem_ar_attribute.translation.fallback_1`.description as `rhiem_ar_attribute.translation.fallback_1.description`,
`rhiem_ar_attribute.translation.fallback_1`.error_msg as `rhiem_ar_attribute.translation.fallback_1.errorMsg`,
`rhiem_ar_attribute.translation.fallback_1`.error_msg_min as `rhiem_ar_attribute.translation.fallback_1.errorMsgMin`,
`rhiem_ar_attribute.translation.fallback_1`.error_msg_max as `rhiem_ar_attribute.translation.fallback_1.errorMsgMax`,
`rhiem_ar_attribute.translation.fallback_1`.created_at as `rhiem_ar_attribute.translation.fallback_1.createdAt`,
`rhiem_ar_attribute.translation.fallback_1`.updated_at as `rhiem_ar_attribute.translation.fallback_1.updatedAt`,
`rhiem_ar_attribute.translation.fallback_1`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`,
`rhiem_ar_attribute.translation.fallback_1`.language_id as `rhiem_ar_attribute.translation.fallback_1.languageId`
FROM
`rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation`
LEFT JOIN `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation.fallback_1` ON `rhiem_ar_attribute.translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute.translation.fallback_1`.`rhiem_ar_attribute_id`
AND `rhiem_ar_attribute.translation.fallback_1`.language_id = : languageId1
WHERE
`rhiem_ar_attribute.translation`.language_id = : languageId
) `rhiem_ar_attribute.rhiem_ar_attribute_translation` ON `rhiem_ar_attribute.rhiem_ar_attribute_translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute`.`id`
WHERE
(
`rhiem_ar_attribute`.`active` = : param_419dfb28432540a98d87e080ebe38996
AND (
`rhiem_ar_attribute`.`channel_ids` = : param_d65eb8f4f94d45388f22bb9c8ddce3a4
OR `rhiem_ar_attribute`.`channel_ids` <=> : param_cb2c6ddae6f14d6c850cb96a0e4613ed
OR `rhiem_ar_attribute`.`channel_ids` LIKE : param_b2accb688b2f4e009fa13fe7e1f6c477
)
AND `rhiem_ar_attribute`.`group_id` IN (
: param_6c49f720252247f3836859a842062beb
)
)
ORDER BY
`rhiem_ar_attribute`.`position` ASC
SELECT `rhiem_ar_attribute`.`id` as `rhiem_ar_attribute.id`, `rhiem_ar_attribute`.`group_id` as `rhiem_ar_attribute.groupId`, `rhiem_ar_attribute`.`type` as `rhiem_ar_attribute.type`, `rhiem_ar_attribute`.`name` as `rhiem_ar_attribute.name`, `rhiem_ar_attribute`.`required` as `rhiem_ar_attribute.required`, `rhiem_ar_attribute`.`value_min` as `rhiem_ar_attribute.valueMin`, `rhiem_ar_attribute`.`value_max` as `rhiem_ar_attribute.valueMax`, `rhiem_ar_attribute`.`min_max` as `rhiem_ar_attribute.minMax`, `rhiem_ar_attribute`.`active` as `rhiem_ar_attribute.active`, `rhiem_ar_attribute`.`position` as `rhiem_ar_attribute.position`, `rhiem_ar_attribute`.`standard` as `rhiem_ar_attribute.standard`, `rhiem_ar_attribute`.`channel_ids` as `rhiem_ar_attribute.channelIds`, `rhiem_ar_attribute`.`created_at` as `rhiem_ar_attribute.createdAt`, `rhiem_ar_attribute`.`updated_at` as `rhiem_ar_attribute.updatedAt`, `rhiem_ar_attribute.translation.fallback_1.label`, `rhiem_ar_attribute.translation.label`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.label`,`rhiem_ar_attribute.translation.label`,`rhiem_ar_attribute.translation.label`) as `rhiem_ar_attribute.label`, `rhiem_ar_attribute.translation.fallback_1.description`, `rhiem_ar_attribute.translation.description`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.description`,`rhiem_ar_attribute.translation.description`,`rhiem_ar_attribute.translation.description`) as `rhiem_ar_attribute.description`, `rhiem_ar_attribute.translation.fallback_1.errorMsg`, `rhiem_ar_attribute.translation.errorMsg`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`) as `rhiem_ar_attribute.errorMsg`, `rhiem_ar_attribute.translation.fallback_1.errorMsgMin`, `rhiem_ar_attribute.translation.errorMsgMin`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`) as `rhiem_ar_attribute.errorMsgMin`, `rhiem_ar_attribute.translation.fallback_1.errorMsgMax`, `rhiem_ar_attribute.translation.errorMsgMax`, COALESCE(`rhiem_ar_attribute.translation.fallback_1.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`) as `rhiem_ar_attribute.errorMsgMax`, `rhiem_ar_attribute.translation.fallback_1.createdAt`, `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation.fallback_1.updatedAt`, `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`, `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation.fallback_1.languageId`, `rhiem_ar_attribute.translation.languageId` FROM `rhiem_ar_attribute` LEFT JOIN (SELECT `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id, `rhiem_ar_attribute.translation`.label as `rhiem_ar_attribute.translation.label`, `rhiem_ar_attribute.translation`.description as `rhiem_ar_attribute.translation.description`, `rhiem_ar_attribute.translation`.error_msg as `rhiem_ar_attribute.translation.errorMsg`, `rhiem_ar_attribute.translation`.error_msg_min as `rhiem_ar_attribute.translation.errorMsgMin`, `rhiem_ar_attribute.translation`.error_msg_max as `rhiem_ar_attribute.translation.errorMsgMax`, `rhiem_ar_attribute.translation`.created_at as `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation`.updated_at as `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.rhiemArAttributeId`, `rhiem_ar_attribute.translation`.language_id as `rhiem_ar_attribute.translation.languageId`, `rhiem_ar_attribute.translation.fallback_1`.label as `rhiem_ar_attribute.translation.fallback_1.label`, `rhiem_ar_attribute.translation.fallback_1`.description as `rhiem_ar_attribute.translation.fallback_1.description`, `rhiem_ar_attribute.translation.fallback_1`.error_msg as `rhiem_ar_attribute.translation.fallback_1.errorMsg`, `rhiem_ar_attribute.translation.fallback_1`.error_msg_min as `rhiem_ar_attribute.translation.fallback_1.errorMsgMin`, `rhiem_ar_attribute.translation.fallback_1`.error_msg_max as `rhiem_ar_attribute.translation.fallback_1.errorMsgMax`, `rhiem_ar_attribute.translation.fallback_1`.created_at as `rhiem_ar_attribute.translation.fallback_1.createdAt`, `rhiem_ar_attribute.translation.fallback_1`.updated_at as `rhiem_ar_attribute.translation.fallback_1.updatedAt`, `rhiem_ar_attribute.translation.fallback_1`.rhiem_ar_attribute_id as `rhiem_ar_attribute.translation.fallback_1.rhiemArAttributeId`, `rhiem_ar_attribute.translation.fallback_1`.language_id as `rhiem_ar_attribute.translation.fallback_1.languageId` FROM `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation` LEFT JOIN `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation.fallback_1` ON `rhiem_ar_attribute.translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute.translation.fallback_1`.`rhiem_ar_attribute_id` AND `rhiem_ar_attribute.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 WHERE `rhiem_ar_attribute.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `rhiem_ar_attribute.rhiem_ar_attribute_translation` ON `rhiem_ar_attribute.rhiem_ar_attribute_translation`.`rhiem_ar_attribute_id` = `rhiem_ar_attribute`.`id` WHERE (`rhiem_ar_attribute`.`active` = 1 AND (`rhiem_ar_attribute`.`channel_ids` = '[]' OR `rhiem_ar_attribute`.`channel_ids` <=> NULL OR `rhiem_ar_attribute`.`channel_ids` LIKE '%27f88dd40bd740f0a51eb58270c3c347%') AND `rhiem_ar_attribute`.`group_id` IN (0x5788BBCA474B4C12B802B218BA2860DC)) ORDER BY `rhiem_ar_attribute`.`position` ASC;
|
3.18 ms
(0.00%)
|
|
SELECT `rhiem_ar_so`.`id` as `rhiem_ar_so.id`, `rhiem_ar_so`.`attribute_id` as `rhiem_ar_so.attributeId`, `rhiem_ar_so`.`value` as `rhiem_ar_so.value`, `rhiem_ar_so`.`position` as `rhiem_ar_so.position`, `rhiem_ar_so`.`created_at` as `rhiem_ar_so.createdAt`, `rhiem_ar_so`.`updated_at` as `rhiem_ar_so.updatedAt`, `rhiem_ar_so.translation.fallback_1.label`, `rhiem_ar_so.translation.label`, COALESCE(`rhiem_ar_so.translation.fallback_1.label`,`rhiem_ar_so.translation.label`,`rhiem_ar_so.translation.label`) as `rhiem_ar_so.label`, `rhiem_ar_so.translation.fallback_1.createdAt`, `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation.fallback_1.updatedAt`, `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation.fallback_1.rhiemArSoId`, `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation.fallback_1.languageId`, `rhiem_ar_so.translation.languageId` FROM `rhiem_ar_so` LEFT JOIN (SELECT `rhiem_ar_so.translation`.rhiem_ar_so_id, `rhiem_ar_so.translation`.label as `rhiem_ar_so.translation.label`, `rhiem_ar_so.translation`.created_at as `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation`.updated_at as `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation`.rhiem_ar_so_id as `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation`.language_id as `rhiem_ar_so.translation.languageId`, `rhiem_ar_so.translation.fallback_1`.label as `rhiem_ar_so.translation.fallback_1.label`, `rhiem_ar_so.translation.fallback_1`.created_at as `rhiem_ar_so.translation.fallback_1.createdAt`, `rhiem_ar_so.translation.fallback_1`.updated_at as `rhiem_ar_so.translation.fallback_1.updatedAt`, `rhiem_ar_so.translation.fallback_1`.rhiem_ar_so_id as `rhiem_ar_so.translation.fallback_1.rhiemArSoId`, `rhiem_ar_so.translation.fallback_1`.language_id as `rhiem_ar_so.translation.fallback_1.languageId` FROM `rhiem_ar_so_translation` `rhiem_ar_so.translation` LEFT JOIN `rhiem_ar_so_translation` `rhiem_ar_so.translation.fallback_1` ON `rhiem_ar_so.translation`.`rhiem_ar_so_id` = `rhiem_ar_so.translation.fallback_1`.`rhiem_ar_so_id` AND `rhiem_ar_so.translation.fallback_1`.language_id = :languageId1 WHERE `rhiem_ar_so.translation`.language_id = :languageId) `rhiem_ar_so.rhiem_ar_so_translation` ON `rhiem_ar_so.rhiem_ar_so_translation`.`rhiem_ar_so_id` = `rhiem_ar_so`.`id` WHERE (`rhiem_ar_so`.`attribute_id` IN (:param_632cbe65afa54f58b6a04d4e81e3bb17)) ORDER BY `rhiem_ar_so`.`position` ASC
SELECT `rhiem_ar_so`.`id` as `rhiem_ar_so.id`, `rhiem_ar_so`.`attribute_id` as `rhiem_ar_so.attributeId`, `rhiem_ar_so`.`value` as `rhiem_ar_so.value`, `rhiem_ar_so`.`position` as `rhiem_ar_so.position`, `rhiem_ar_so`.`created_at` as `rhiem_ar_so.createdAt`, `rhiem_ar_so`.`updated_at` as `rhiem_ar_so.updatedAt`, `rhiem_ar_so.translation.fallback_1.label`, `rhiem_ar_so.translation.label`, COALESCE(`rhiem_ar_so.translation.fallback_1.label`,`rhiem_ar_so.translation.label`,`rhiem_ar_so.translation.label`) as `rhiem_ar_so.label`, `rhiem_ar_so.translation.fallback_1.createdAt`, `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation.fallback_1.updatedAt`, `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation.fallback_1.rhiemArSoId`, `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation.fallback_1.languageId`, `rhiem_ar_so.translation.languageId` FROM `rhiem_ar_so` LEFT JOIN (SELECT `rhiem_ar_so.translation`.rhiem_ar_so_id, `rhiem_ar_so.translation`.label as `rhiem_ar_so.translation.label`, `rhiem_ar_so.translation`.created_at as `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation`.updated_at as `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation`.rhiem_ar_so_id as `rhiem_ar_so.translation.rhiemArSoId`, `rhiem_ar_so.translation`.language_id as `rhiem_ar_so.translation.languageId`, `rhiem_ar_so.translation.fallback_1`.label as `rhiem_ar_so.translation.fallback_1.label`, `rhiem_ar_so.translation.fallback_1`.created_at as `rhiem_ar_so.translation.fallback_1.createdAt`, `rhiem_ar_so.translation.fallback_1`.updated_at as `rhiem_ar_so.translation.fallback_1.updatedAt`, `rhiem_ar_so.translation.fallback_1`.rhiem_ar_so_id as `rhiem_ar_so.translation.fallback_1.rhiemArSoId`, `rhiem_ar_so.translation.fallback_1`.language_id as `rhiem_ar_so.translation.fallback_1.languageId` FROM `rhiem_ar_so_translation` `rhiem_ar_so.translation` LEFT JOIN `rhiem_ar_so_translation` `rhiem_ar_so.translation.fallback_1` ON `rhiem_ar_so.translation`.`rhiem_ar_so_id` = `rhiem_ar_so.translation.fallback_1`.`rhiem_ar_so_id` AND `rhiem_ar_so.translation.fallback_1`.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73 WHERE `rhiem_ar_so.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `rhiem_ar_so.rhiem_ar_so_translation` ON `rhiem_ar_so.rhiem_ar_so_translation`.`rhiem_ar_so_id` = `rhiem_ar_so`.`id` WHERE (`rhiem_ar_so`.`attribute_id` IN (0xEDEA1CE1386C478FA980C8F4C62E1AAB)) ORDER BY `rhiem_ar_so`.`position` ASC;
|
1.38 ms
(0.00%)
|
|
SELECT seo_path_info, path_info FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (:pathInfo)) AND (seo_url.language_id = :languageId) AND (seo_url.sales_channel_id = :salesChannelId OR seo_url.sales_channel_id IS NULL) AND (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC
SELECT seo_path_info, path_info FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/maintenance/singlepage/446cf0a66861458abecad2f1959a1c8d', '/maintenance/singlepage/8db99f7667924c7a9ccefe0521bd2f37')) AND (seo_url.language_id = 0x474CBBBE6FF3467A9970FAB9CDCA2A73) AND (seo_url.sales_channel_id = 0x27F88DD40BD740F0A51EB58270C3C347 OR seo_url.sales_channel_id IS NULL) AND (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC;
|