0.15 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
;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 360)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 198)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
2.97 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_1587111506_IS_ACTIVE = TRUE;SET @MIGRATION_1588143272_IS_ACTIVE = TRUE;SET @MIGRATION_1588144801_IS_ACTIVE = TRUE;SET @MIGRATION_1588153272_IS_ACTIVE = TRUE;SET @MIGRATION_1589178550_IS_ACTIVE = TRUE;SET @MIGRATION_1589357321_IS_ACTIVE = TRUE;SET @MIGRATION_1589359936_IS_ACTIVE = TRUE;SET @MIGRATION_1589379060_IS_ACTIVE = TRUE;SET @MIGRATION_1589447332_IS_ACTIVE = TRUE;SET @MIGRATION_1589458026_IS_ACTIVE = TRUE;SET @MIGRATION_1590408550_IS_ACTIVE = TRUE;SET @MIGRATION_1590409548_IS_ACTIVE = TRUE;SET @MIGRATION_1590566018_IS_ACTIVE = TRUE;SET @MIGRATION_1590566405_IS_ACTIVE = TRUE;SET @MIGRATION_1590579986_IS_ACTIVE = TRUE;SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591052278_IS_ACTIVE = TRUE;SET @MIGRATION_1591167126_IS_ACTIVE = TRUE;SET @MIGRATION_1591253089_IS_ACTIVE = TRUE;SET @MIGRATION_1591259559_IS_ACTIVE = TRUE;SET @MIGRATION_1591272594_IS_ACTIVE = TRUE;SET @MIGRATION_1591361320_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1591817370_IS_ACTIVE = TRUE;SET @MIGRATION_1592466717_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1592978289_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1594650256_IS_ACTIVE = TRUE;SET @MIGRATION_1594885630_IS_ACTIVE = TRUE;SET @MIGRATION_1594886106_IS_ACTIVE = TRUE;SET @MIGRATION_1594886773_IS_ACTIVE = TRUE;SET @MIGRATION_1594886895_IS_ACTIVE = TRUE;SET @MIGRATION_1594887027_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595480600_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595499689_IS_ACTIVE = TRUE;SET @MIGRATION_1595553089_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_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_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1589199909_IS_ACTIVE = TRUE;SET @MIGRATION_1649838053_IS_ACTIVE = TRUE;SET @MIGRATION_1570025268_IS_ACTIVE = TRUE;SET @MIGRATION_1596438247_IS_ACTIVE = TRUE;SET @MIGRATION_1635756230_IS_ACTIVE = TRUE;SET @MIGRATION_1635757867_IS_ACTIVE = TRUE;SET @MIGRATION_1635849633_IS_ACTIVE = TRUE;SET @MIGRATION_1635849637_IS_ACTIVE = TRUE;SET @MIGRATION_1644313669_IS_ACTIVE = TRUE;SET @MIGRATION_1646119820_IS_ACTIVE = TRUE;SET @MIGRATION_1601622132_IS_ACTIVE = TRUE;SET @MIGRATION_1602761577_IS_ACTIVE = TRUE;SET @MIGRATION_1606987075_IS_ACTIVE = TRUE;SET @MIGRATION_1609856970_IS_ACTIVE = TRUE;SET @MIGRATION_1609929616_IS_ACTIVE = TRUE;SET @MIGRATION_1610107035_IS_ACTIVE = TRUE;SET @MIGRATION_1611047410_IS_ACTIVE = TRUE;SET @MIGRATION_1611309499_IS_ACTIVE = TRUE;SET @MIGRATION_1611655657_IS_ACTIVE = TRUE;SET @MIGRATION_1611749679_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1585052822_IS_ACTIVE = TRUE;SET @MIGRATION_1651059763_IS_ACTIVE = TRUE;SET @MIGRATION_1661102992_IS_ACTIVE = TRUE;SET @MIGRATION_1661103992_IS_ACTIVE = TRUE;SET @MIGRATION_1609921248_IS_ACTIVE = TRUE;SET @MIGRATION_1609939597_IS_ACTIVE = TRUE;SET @MIGRATION_1613038572_IS_ACTIVE = TRUE;SET @MIGRATION_1606731597_IS_ACTIVE = TRUE;SET @MIGRATION_1607003943_IS_ACTIVE = TRUE;SET @MIGRATION_1607602993_IS_ACTIVE = TRUE;SET @MIGRATION_1610977013_IS_ACTIVE = TRUE;SET @MIGRATION_1612101832_IS_ACTIVE = TRUE;SET @MIGRATION_1613385682_IS_ACTIVE = TRUE;SET @MIGRATION_1616678164_IS_ACTIVE = TRUE;SET @MIGRATION_1620389895_IS_ACTIVE = TRUE;SET @MIGRATION_1642753264_IS_ACTIVE = TRUE;SET @MIGRATION_1617014641_IS_ACTIVE = TRUE;SET @MIGRATION_1625059909_IS_ACTIVE = TRUE;SET @MIGRATION_1626340031_IS_ACTIVE = TRUE;SET @MIGRATION_1626855189_IS_ACTIVE = TRUE;SET @MIGRATION_1626908569_IS_ACTIVE = TRUE;SET @MIGRATION_1637910884_IS_ACTIVE = TRUE;SET @MIGRATION_1649771353_IS_ACTIVE = TRUE;SET @MIGRATION_1606722461_IS_ACTIVE = TRUE;SET @MIGRATION_1606743724_IS_ACTIVE = TRUE;SET @MIGRATION_1608123054_IS_ACTIVE = TRUE;SET @MIGRATION_1608301193_IS_ACTIVE = TRUE;SET @MIGRATION_1608301201_IS_ACTIVE = TRUE;SET @MIGRATION_1608301204_IS_ACTIVE = TRUE;SET @MIGRATION_1610024634_IS_ACTIVE = TRUE;SET @MIGRATION_1644908809_IS_ACTIVE = TRUE;SET @MIGRATION_1624447994_IS_ACTIVE = TRUE;SET @MIGRATION_1656082538_IS_ACTIVE = TRUE;SET @MIGRATION_1625645868_IS_ACTIVE = TRUE;SET @MIGRATION_1626259853_IS_ACTIVE = TRUE;SET @MIGRATION_1580730959_IS_ACTIVE = TRUE;SET @MIGRATION_1623051960_IS_ACTIVE = TRUE;SET @MIGRATION_1624023259_IS_ACTIVE = TRUE;SET @MIGRATION_1558500331_IS_ACTIVE = TRUE;SET @MIGRATION_1615911875_IS_ACTIVE = TRUE;SET @MIGRATION_1646211291_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1583481305_IS_ACTIVE = TRUE;SET @MIGRATION_1583481306_IS_ACTIVE = TRUE;SET @MIGRATION_1625729418_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1699006548_IS_ACTIVE = TRUE;SET @MIGRATION_1710492785_IS_ACTIVE = TRUE;SET @MIGRATION_1724409931_IS_ACTIVE = TRUE;SET @MIGRATION_1724228341_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_1587111506_IS_ACTIVE = TRUE;SET @MIGRATION_1588143272_IS_ACTIVE = TRUE;SET @MIGRATION_1588144801_IS_ACTIVE = TRUE;SET @MIGRATION_1588153272_IS_ACTIVE = TRUE;SET @MIGRATION_1589178550_IS_ACTIVE = TRUE;SET @MIGRATION_1589357321_IS_ACTIVE = TRUE;SET @MIGRATION_1589359936_IS_ACTIVE = TRUE;SET @MIGRATION_1589379060_IS_ACTIVE = TRUE;SET @MIGRATION_1589447332_IS_ACTIVE = TRUE;SET @MIGRATION_1589458026_IS_ACTIVE = TRUE;SET @MIGRATION_1590408550_IS_ACTIVE = TRUE;SET @MIGRATION_1590409548_IS_ACTIVE = TRUE;SET @MIGRATION_1590566018_IS_ACTIVE = TRUE;SET @MIGRATION_1590566405_IS_ACTIVE = TRUE;SET @MIGRATION_1590579986_IS_ACTIVE = TRUE;SET @MIGRATION_1590758953_IS_ACTIVE = TRUE;SET @MIGRATION_1591052278_IS_ACTIVE = TRUE;SET @MIGRATION_1591167126_IS_ACTIVE = TRUE;SET @MIGRATION_1591253089_IS_ACTIVE = TRUE;SET @MIGRATION_1591259559_IS_ACTIVE = TRUE;SET @MIGRATION_1591272594_IS_ACTIVE = TRUE;SET @MIGRATION_1591361320_IS_ACTIVE = TRUE;SET @MIGRATION_1591683158_IS_ACTIVE = TRUE;SET @MIGRATION_1591817370_IS_ACTIVE = TRUE;SET @MIGRATION_1592466717_IS_ACTIVE = TRUE;SET @MIGRATION_1592837424_IS_ACTIVE = TRUE;SET @MIGRATION_1592978289_IS_ACTIVE = TRUE;SET @MIGRATION_1593698606_IS_ACTIVE = TRUE;SET @MIGRATION_1594650256_IS_ACTIVE = TRUE;SET @MIGRATION_1594885630_IS_ACTIVE = TRUE;SET @MIGRATION_1594886106_IS_ACTIVE = TRUE;SET @MIGRATION_1594886773_IS_ACTIVE = TRUE;SET @MIGRATION_1594886895_IS_ACTIVE = TRUE;SET @MIGRATION_1594887027_IS_ACTIVE = TRUE;SET @MIGRATION_1595160327_IS_ACTIVE = TRUE;SET @MIGRATION_1595321666_IS_ACTIVE = TRUE;SET @MIGRATION_1595422169_IS_ACTIVE = TRUE;SET @MIGRATION_1595480600_IS_ACTIVE = TRUE;SET @MIGRATION_1595489705_IS_ACTIVE = TRUE;SET @MIGRATION_1595492052_IS_ACTIVE = TRUE;SET @MIGRATION_1595492053_IS_ACTIVE = TRUE;SET @MIGRATION_1595499689_IS_ACTIVE = TRUE;SET @MIGRATION_1595553089_IS_ACTIVE = TRUE;SET @MIGRATION_1595578253_IS_ACTIVE = TRUE;SET @MIGRATION_1595919251_IS_ACTIVE = TRUE;SET @MIGRATION_1596091744_IS_ACTIVE = TRUE;SET @MIGRATION_1596441551_IS_ACTIVE = TRUE;SET @MIGRATION_1597391970_IS_ACTIVE = TRUE;SET @MIGRATION_1597394241_IS_ACTIVE = TRUE;SET @MIGRATION_1597657689_IS_ACTIVE = TRUE;SET @MIGRATION_1597762808_IS_ACTIVE = TRUE;SET @MIGRATION_1597830237_IS_ACTIVE = TRUE;SET @MIGRATION_1597930227_IS_ACTIVE = TRUE;SET @MIGRATION_1598280548_IS_ACTIVE = TRUE;SET @MIGRATION_1598520424_IS_ACTIVE = TRUE;SET @MIGRATION_1598885384_IS_ACTIVE = TRUE;SET @MIGRATION_1599112309_IS_ACTIVE = TRUE;SET @MIGRATION_1599134496_IS_ACTIVE = TRUE;SET @MIGRATION_1599463278_IS_ACTIVE = TRUE;SET @MIGRATION_1599570560_IS_ACTIVE = TRUE;SET @MIGRATION_1599720163_IS_ACTIVE = TRUE;SET @MIGRATION_1599806584_IS_ACTIVE = TRUE;SET @MIGRATION_1599806595_IS_ACTIVE = TRUE;SET @MIGRATION_1599822061_IS_ACTIVE = TRUE;SET @MIGRATION_1600072779_IS_ACTIVE = TRUE;SET @MIGRATION_1600156989_IS_ACTIVE = TRUE;SET @MIGRATION_1600253602_IS_ACTIVE = TRUE;SET @MIGRATION_1600330846_IS_ACTIVE = TRUE;SET @MIGRATION_1600338271_IS_ACTIVE = TRUE;SET @MIGRATION_1600349343_IS_ACTIVE = TRUE;SET @MIGRATION_1600676671_IS_ACTIVE = TRUE;SET @MIGRATION_1600769357_IS_ACTIVE = TRUE;SET @MIGRATION_1600778848_IS_ACTIVE = TRUE;SET @MIGRATION_1601388975_IS_ACTIVE = TRUE;SET @MIGRATION_1601451838_IS_ACTIVE = TRUE;SET @MIGRATION_1601539530_IS_ACTIVE = TRUE;SET @MIGRATION_1601543829_IS_ACTIVE = TRUE;SET @MIGRATION_1601891339_IS_ACTIVE = TRUE;SET @MIGRATION_1602062376_IS_ACTIVE = TRUE;SET @MIGRATION_1602146868_IS_ACTIVE = TRUE;SET @MIGRATION_1602153572_IS_ACTIVE = TRUE;SET @MIGRATION_1602494493_IS_ACTIVE = TRUE;SET @MIGRATION_1602494495_IS_ACTIVE = TRUE;SET @MIGRATION_1602745374_IS_ACTIVE = TRUE;SET @MIGRATION_1602822727_IS_ACTIVE = TRUE;SET @MIGRATION_1603179023_IS_ACTIVE = TRUE;SET @MIGRATION_1603293043_IS_ACTIVE = TRUE;SET @MIGRATION_1603970276_IS_ACTIVE = TRUE;SET @MIGRATION_1604056363_IS_ACTIVE = TRUE;SET @MIGRATION_1604056421_IS_ACTIVE = TRUE;SET @MIGRATION_1604475913_IS_ACTIVE = TRUE;SET @MIGRATION_1604499476_IS_ACTIVE = TRUE;SET @MIGRATION_1604568928_IS_ACTIVE = TRUE;SET @MIGRATION_1604669773_IS_ACTIVE = TRUE;SET @MIGRATION_1605103533_IS_ACTIVE = TRUE;SET @MIGRATION_1605530777_IS_ACTIVE = TRUE;SET @MIGRATION_1605609309_IS_ACTIVE = TRUE;SET @MIGRATION_1605609477_IS_ACTIVE = TRUE;SET @MIGRATION_1605861407_IS_ACTIVE = TRUE;SET @MIGRATION_1606310257_IS_ACTIVE = TRUE;SET @MIGRATION_1607415095_IS_ACTIVE = TRUE;SET @MIGRATION_1607500561_IS_ACTIVE = TRUE;SET @MIGRATION_1607514878_IS_ACTIVE = TRUE;SET @MIGRATION_1607581275_IS_ACTIVE = TRUE;SET @MIGRATION_1607581276_IS_ACTIVE = TRUE;SET @MIGRATION_1608624028_IS_ACTIVE = TRUE;SET @MIGRATION_1609125144_IS_ACTIVE = TRUE;SET @MIGRATION_1609857999_IS_ACTIVE = TRUE;SET @MIGRATION_1610531188_IS_ACTIVE = TRUE;SET @MIGRATION_1610965670_IS_ACTIVE = TRUE;SET @MIGRATION_1610974673_IS_ACTIVE = TRUE;SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1614240671_IS_ACTIVE = TRUE;SET @MIGRATION_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1594104496_IS_ACTIVE = TRUE;SET @MIGRATION_1604585230_IS_ACTIVE = TRUE;SET @MIGRATION_1609140710_IS_ACTIVE = TRUE;SET @MIGRATION_1610337444_IS_ACTIVE = TRUE;SET @MIGRATION_1610439375_IS_ACTIVE = TRUE;SET @MIGRATION_1610448012_IS_ACTIVE = TRUE;SET @MIGRATION_1610523204_IS_ACTIVE = TRUE;SET @MIGRATION_1610523548_IS_ACTIVE = TRUE;SET @MIGRATION_1610616655_IS_ACTIVE = TRUE;SET @MIGRATION_1610621999_IS_ACTIVE = TRUE;SET @MIGRATION_1610625925_IS_ACTIVE = TRUE;SET @MIGRATION_1610634383_IS_ACTIVE = TRUE;SET @MIGRATION_1610904608_IS_ACTIVE = TRUE;SET @MIGRATION_1611732852_IS_ACTIVE = TRUE;SET @MIGRATION_1611817467_IS_ACTIVE = TRUE;SET @MIGRATION_1612184092_IS_ACTIVE = TRUE;SET @MIGRATION_1612442685_IS_ACTIVE = TRUE;SET @MIGRATION_1612442686_IS_ACTIVE = TRUE;SET @MIGRATION_1612442786_IS_ACTIVE = TRUE;SET @MIGRATION_1612851765_IS_ACTIVE = TRUE;SET @MIGRATION_1612865237_IS_ACTIVE = TRUE;SET @MIGRATION_1612970642_IS_ACTIVE = TRUE;SET @MIGRATION_1612980753_IS_ACTIVE = TRUE;SET @MIGRATION_1613665555_IS_ACTIVE = TRUE;SET @MIGRATION_1614249488_IS_ACTIVE = TRUE;SET @MIGRATION_1614691876_IS_ACTIVE = TRUE;SET @MIGRATION_1614765170_IS_ACTIVE = TRUE;SET @MIGRATION_1614765785_IS_ACTIVE = TRUE;SET @MIGRATION_1615359964_IS_ACTIVE = TRUE;SET @MIGRATION_1615366708_IS_ACTIVE = TRUE;SET @MIGRATION_1615452749_IS_ACTIVE = TRUE;SET @MIGRATION_1615802866_IS_ACTIVE = TRUE;SET @MIGRATION_1615819992_IS_ACTIVE = TRUE;SET @MIGRATION_1616076922_IS_ACTIVE = TRUE;SET @MIGRATION_1616496610_IS_ACTIVE = TRUE;SET @MIGRATION_1616555956_IS_ACTIVE = TRUE;SET @MIGRATION_1617000878_IS_ACTIVE = TRUE;SET @MIGRATION_1617356092_IS_ACTIVE = TRUE;SET @MIGRATION_1617784658_IS_ACTIVE = TRUE;SET @MIGRATION_1617864895_IS_ACTIVE = TRUE;SET @MIGRATION_1617868381_IS_ACTIVE = TRUE;SET @MIGRATION_1617877887_IS_ACTIVE = TRUE;SET @MIGRATION_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1617935350_IS_ACTIVE = TRUE;SET @MIGRATION_1617953690_IS_ACTIVE = TRUE;SET @MIGRATION_1617960456_IS_ACTIVE = TRUE;SET @MIGRATION_1617974402_IS_ACTIVE = TRUE;SET @MIGRATION_1618218491_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1618476427_IS_ACTIVE = TRUE;SET @MIGRATION_1618569201_IS_ACTIVE = TRUE;SET @MIGRATION_1618900427_IS_ACTIVE = TRUE;SET @MIGRATION_1618989442_IS_ACTIVE = TRUE;SET @MIGRATION_1619070236_IS_ACTIVE = TRUE;SET @MIGRATION_1619428555_IS_ACTIVE = TRUE;SET @MIGRATION_1619604605_IS_ACTIVE = TRUE;SET @MIGRATION_1619703075_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620201616_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620632460_IS_ACTIVE = TRUE;SET @MIGRATION_1620634856_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620820321_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_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_1595492054_IS_ACTIVE = TRUE;SET @MIGRATION_1604502151_IS_ACTIVE = TRUE;SET @MIGRATION_1589199909_IS_ACTIVE = TRUE;SET @MIGRATION_1649838053_IS_ACTIVE = TRUE;SET @MIGRATION_1570025268_IS_ACTIVE = TRUE;SET @MIGRATION_1596438247_IS_ACTIVE = TRUE;SET @MIGRATION_1635756230_IS_ACTIVE = TRUE;SET @MIGRATION_1635757867_IS_ACTIVE = TRUE;SET @MIGRATION_1635849633_IS_ACTIVE = TRUE;SET @MIGRATION_1635849637_IS_ACTIVE = TRUE;SET @MIGRATION_1644313669_IS_ACTIVE = TRUE;SET @MIGRATION_1646119820_IS_ACTIVE = TRUE;SET @MIGRATION_1601622132_IS_ACTIVE = TRUE;SET @MIGRATION_1602761577_IS_ACTIVE = TRUE;SET @MIGRATION_1606987075_IS_ACTIVE = TRUE;SET @MIGRATION_1609856970_IS_ACTIVE = TRUE;SET @MIGRATION_1609929616_IS_ACTIVE = TRUE;SET @MIGRATION_1610107035_IS_ACTIVE = TRUE;SET @MIGRATION_1611047410_IS_ACTIVE = TRUE;SET @MIGRATION_1611309499_IS_ACTIVE = TRUE;SET @MIGRATION_1611655657_IS_ACTIVE = TRUE;SET @MIGRATION_1611749679_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1585052822_IS_ACTIVE = TRUE;SET @MIGRATION_1651059763_IS_ACTIVE = TRUE;SET @MIGRATION_1661102992_IS_ACTIVE = TRUE;SET @MIGRATION_1661103992_IS_ACTIVE = TRUE;SET @MIGRATION_1609921248_IS_ACTIVE = TRUE;SET @MIGRATION_1609939597_IS_ACTIVE = TRUE;SET @MIGRATION_1613038572_IS_ACTIVE = TRUE;SET @MIGRATION_1606731597_IS_ACTIVE = TRUE;SET @MIGRATION_1607003943_IS_ACTIVE = TRUE;SET @MIGRATION_1607602993_IS_ACTIVE = TRUE;SET @MIGRATION_1610977013_IS_ACTIVE = TRUE;SET @MIGRATION_1612101832_IS_ACTIVE = TRUE;SET @MIGRATION_1613385682_IS_ACTIVE = TRUE;SET @MIGRATION_1616678164_IS_ACTIVE = TRUE;SET @MIGRATION_1620389895_IS_ACTIVE = TRUE;SET @MIGRATION_1642753264_IS_ACTIVE = TRUE;SET @MIGRATION_1617014641_IS_ACTIVE = TRUE;SET @MIGRATION_1625059909_IS_ACTIVE = TRUE;SET @MIGRATION_1626340031_IS_ACTIVE = TRUE;SET @MIGRATION_1626855189_IS_ACTIVE = TRUE;SET @MIGRATION_1626908569_IS_ACTIVE = TRUE;SET @MIGRATION_1637910884_IS_ACTIVE = TRUE;SET @MIGRATION_1649771353_IS_ACTIVE = TRUE;SET @MIGRATION_1606722461_IS_ACTIVE = TRUE;SET @MIGRATION_1606743724_IS_ACTIVE = TRUE;SET @MIGRATION_1608123054_IS_ACTIVE = TRUE;SET @MIGRATION_1608301193_IS_ACTIVE = TRUE;SET @MIGRATION_1608301201_IS_ACTIVE = TRUE;SET @MIGRATION_1608301204_IS_ACTIVE = TRUE;SET @MIGRATION_1610024634_IS_ACTIVE = TRUE;SET @MIGRATION_1644908809_IS_ACTIVE = TRUE;SET @MIGRATION_1624447994_IS_ACTIVE = TRUE;SET @MIGRATION_1656082538_IS_ACTIVE = TRUE;SET @MIGRATION_1625645868_IS_ACTIVE = TRUE;SET @MIGRATION_1626259853_IS_ACTIVE = TRUE;SET @MIGRATION_1580730959_IS_ACTIVE = TRUE;SET @MIGRATION_1623051960_IS_ACTIVE = TRUE;SET @MIGRATION_1624023259_IS_ACTIVE = TRUE;SET @MIGRATION_1558500331_IS_ACTIVE = TRUE;SET @MIGRATION_1615911875_IS_ACTIVE = TRUE;SET @MIGRATION_1646211291_IS_ACTIVE = TRUE;SET @MIGRATION_1624512389_IS_ACTIVE = TRUE;SET @MIGRATION_1624515124_IS_ACTIVE = TRUE;SET @MIGRATION_1624516627_IS_ACTIVE = TRUE;SET @MIGRATION_1583481305_IS_ACTIVE = TRUE;SET @MIGRATION_1583481306_IS_ACTIVE = TRUE;SET @MIGRATION_1625729418_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1699006548_IS_ACTIVE = TRUE;SET @MIGRATION_1710492785_IS_ACTIVE = TRUE;SET @MIGRATION_1724409931_IS_ACTIVE = TRUE;SET @MIGRATION_1724228341_IS_ACTIVE = TRUE;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 393)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 198)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.16 ms (0.00%)
|
|
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, :url0 REGEXP `old_url_regex` as regex0, :url2 REGEXP `old_url_regex` as regex2, :url3 REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = :active AND ((NOT (`search_url_by` = :searchByUrlRegex) AND ((`old_url` = :url0 OR `old_url` = :url2 OR `old_url` = :url3))) OR (`search_url_by` = :searchByUrlRegex AND ((:url0 REGEXP `old_url_regex` OR :url2 REGEXP `old_url_regex` OR :url3 REGEXP `old_url_regex`)))) LIMIT 6;
SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, '/Wishlist' REGEXP `old_url_regex` as regex0, 'https://sw08.sw.dev.aidup.io/Wishlist' REGEXP `old_url_regex` as regex2, 'sw08.sw.dev.aidup.io/Wishlist' REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex') AND ((`old_url` = '/Wishlist' OR `old_url` = 'https://sw08.sw.dev.aidup.io/Wishlist' OR `old_url` = 'sw08.sw.dev.aidup.io/Wishlist'))) OR (`search_url_by` = 'regex' AND (('/Wishlist' REGEXP `old_url_regex` OR 'https://sw08.sw.dev.aidup.io/Wishlist' REGEXP `old_url_regex` OR 'sw08.sw.dev.aidup.io/Wishlist' REGEXP `old_url_regex`)))) LIMIT 6;;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 239)"
2 => "Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer::searchRedirect (line 88)"
3 => "Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer::checkRedirect (line 57)"
4 => "Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer::transform (line 133)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
7.00 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 = 0xFEA4C70D25004476BA9DEB2DD3A1D1B6) AND (token = 'AUSox8S8uwaTQpGxKKHMGUN2MYIbLs1F') LIMIT 1;
array:27 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 159)"
3 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister::load (line 69)"
4 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
5 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
6 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
25 => "Shopware\Core\HttpKernel::doHandle (line 79)"
26 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.70 ms (0.00%)
|
|
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE :column
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';
array:30 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 734)"
2 => "Doctrine\DBAL\Connection::fetchOne (line 50)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::columnExists (line 163)"
4 => "Shopware\Core\Checkout\Cart\CartPersister::payloadExists (line 50)"
5 => "Shopware\Core\Checkout\Cart\CartPersister::load (line 76)"
6 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
7 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
8 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
9 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
10 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
11 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
12 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
14 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
15 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
16 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
17 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
18 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
19 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
22 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
23 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
28 => "Shopware\Core\HttpKernel::doHandle (line 79)"
29 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.08 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` = 'AUSox8S8uwaTQpGxKKHMGUN2MYIbLs1F';
array:28 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 684)"
2 => "Doctrine\DBAL\Connection::fetchAssociative (line 60)"
3 => "Shopware\Core\Checkout\Cart\CartPersister::load (line 76)"
4 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
5 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
6 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
7 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
8 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
9 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
10 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
11 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
13 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
14 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
15 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
16 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
17 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
20 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
21 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
26 => "Shopware\Core\HttpKernel::doHandle (line 79)"
27 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.19 ms (0.00%)
|
|
SELECT `country_translation`.`country_id`, `country_translation`.`language_id` FROM `country_translation` WHERE (`country_translation`.`name` = :param_2a2006a672b84373be29637a1d2a6d10)
SELECT `country_translation`.`country_id`, `country_translation`.`language_id` FROM `country_translation` WHERE (`country_translation`.`name` = 'United States');
array:42 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 122)"
7 => "Wexo\FreeShipping\Subscriber\GeoLocationInCart::getCountryId (line 73)"
8 => "Wexo\FreeShipping\Subscriber\GeoLocationInCart::addCartGeoLocationExtension (line 53)"
9 => "Wexo\FreeShipping\Subscriber\GeoLocationInCart::setGeoLocationOnCartCreated (line 117)"
10 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
11 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
13 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
14 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
15 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
16 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
17 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 81)"
18 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
19 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
20 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
21 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
22 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
23 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
24 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
25 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
26 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
27 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
28 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
29 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
30 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
31 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
32 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
33 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
34 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
35 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
40 => "Shopware\Core\HttpKernel::doHandle (line 79)"
41 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.89 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_3bd8c48acea442208c35dfc257259a0b AND `promotion.salesChannels`.`sales_channel_id` = :param_b161371df2a649beab50305a21f91d38 AND ((`promotion`.`valid_from` <=> :param_2175e942b86c484c85842f63340a8815 AND `promotion`.`valid_until` <=> :param_a14d6e012778455ca9d989f7f82449cd) OR (`promotion`.`valid_from` <=> :param_1ca729eb2b4a4f66ba11e422c41f477b AND (`promotion`.`valid_until` > :param_2197e6a293d145dba9527a9f3e7c3efe)) OR ((`promotion`.`valid_from` <= :param_6a707120adbe4e54868139450792e7b3) AND `promotion`.`valid_until` <=> :param_0ac52c818954419c995261f5e20490c1) OR ((`promotion`.`valid_from` <= :param_242f8c35112a4dfdad0c3b3f26b931ab) AND (`promotion`.`valid_until` > :param_1c7de581fa2d4c1585dfb28b2a7f3f50))) AND `promotion`.`use_codes` = :param_399a4b7ff0ae4bb9a12b19686123705f)) 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` = 0xFEA4C70D25004476BA9DEB2DD3A1D1B6 AND ((`promotion`.`valid_from` <=> NULL AND `promotion`.`valid_until` <=> NULL) OR (`promotion`.`valid_from` <=> NULL AND (`promotion`.`valid_until` > '2024-10-22 13:30:26')) OR ((`promotion`.`valid_from` <= '2024-10-22 13:30:26') AND `promotion`.`valid_until` <=> NULL) OR ((`promotion`.`valid_from` <= '2024-10-22 13:30:26') AND (`promotion`.`valid_until` > '2024-10-22 13:30:26'))) AND `promotion`.`use_codes` = 0)) GROUP BY `promotion`.`id` ORDER BY MAX(`promotion`.`priority`) DESC;
array:47 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 259)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 37)"
11 => "Shopware\Core\Checkout\Promotion\Gateway\PromotionGateway::get (line 182)"
12 => "Shopware\Core\Checkout\Promotion\Cart\PromotionCollector::searchPromotionsAuto (line 108)"
13 => "Shopware\Core\Checkout\Promotion\Cart\PromotionCollector::Shopware\Core\Checkout\Promotion\Cart\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 159)"
15 => "Shopware\Core\Checkout\Promotion\Cart\PromotionCollector::collect (line 101)"
16 => "Shopware\Core\Checkout\Cart\Processor::runProcessors (line 65)"
17 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
18 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
19 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
20 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
21 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
22 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
23 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
24 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
25 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
26 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
27 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
28 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
29 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
30 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
31 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
32 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
33 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
34 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
35 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
36 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
37 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
38 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
39 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
40 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
41 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
42 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
43 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
44 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
45 => "Shopware\Core\HttpKernel::doHandle (line 79)"
46 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
2.76 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.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.shippingMethodType`.`id` as `shipping_method.shippingMethodType.id`, `shipping_method.shippingMethodType`.`shipping_method_id` as `shipping_method.shippingMethodType.shippingMethodId`, `shipping_method.shippingMethodType`.`type_key` as `shipping_method.shippingMethodType.typeKey`, `shipping_method.shippingMethodType`.`penalties` as `shipping_method.shippingMethodType.penalties`, `shipping_method.shippingMethodType`.`created_at` as `shipping_method.shippingMethodType.createdAt`, `shipping_method.shippingMethodType`.`updated_at` as `shipping_method.shippingMethodType.updatedAt`, `shipping_method.shippingMethodDeadline`.`id` as `shipping_method.shippingMethodDeadline.id`, `shipping_method.shippingMethodDeadline`.`shipping_method_id` as `shipping_method.shippingMethodDeadline.shippingMethodId`, `shipping_method.shippingMethodDeadline`.`deadlines` as `shipping_method.shippingMethodDeadline.deadlines`, `shipping_method.shippingMethodDeadline`.`excluded_dates` as `shipping_method.shippingMethodDeadline.excludedDates`, `shipping_method.shippingMethodDeadline`.`created_at` as `shipping_method.shippingMethodDeadline.createdAt`, `shipping_method.shippingMethodDeadline`.`updated_at` as `shipping_method.shippingMethodDeadline.updatedAt`, `shipping_method.shippingMethodConfig`.`id` as `shipping_method.shippingMethodConfig.id`, `shipping_method.shippingMethodConfig`.`shipping_method_id` as `shipping_method.shippingMethodConfig.shippingMethodId`, `shipping_method.shippingMethodConfig`.`shipping_comment_required` as `shipping_method.shippingMethodConfig.shippingCommentRequired`, `shipping_method.shippingMethodConfig`.`created_at` as `shipping_method.shippingMethodConfig.createdAt`, `shipping_method.shippingMethodConfig`.`updated_at` as `shipping_method.shippingMethodConfig.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = :languageId) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `wexo_shipping_method_type` `shipping_method.shippingMethodType` ON `shipping_method`.`id` = `shipping_method.shippingMethodType`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_deadline` `shipping_method.shippingMethodDeadline` ON `shipping_method`.`id` = `shipping_method.shippingMethodDeadline`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_config` `shipping_method.shippingMethodConfig` ON `shipping_method`.`id` = `shipping_method.shippingMethodConfig`.`shipping_method_id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = :languageId) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (:ids)
SELECT
`shipping_method`.`id` as `shipping_method.id`,
`shipping_method`.`active` as `shipping_method.active`,
`shipping_method`.`position` as `shipping_method.position`,
`shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`,
`shipping_method`.`media_id` as `shipping_method.mediaId`,
`shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`,
`shipping_method`.`tax_type` as `shipping_method.taxType`,
`shipping_method`.`tax_id` as `shipping_method.taxId`,
`shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`,
`shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`,
`shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`,
`shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`,
`shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`,
`shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`,
`shipping_method.deliveryTime.translation.name`,
COALESCE(
`shipping_method.deliveryTime.translation.name`,
`shipping_method.deliveryTime.translation.name`
) as `shipping_method.deliveryTime.name`,
`shipping_method.deliveryTime.translation.customFields`,
COALESCE(
`shipping_method.deliveryTime.translation.customFields`,
`shipping_method.deliveryTime.translation.customFields`
) as `shipping_method.deliveryTime.customFields`,
`shipping_method.deliveryTime.translation.createdAt`,
`shipping_method.deliveryTime.translation.updatedAt`,
`shipping_method.deliveryTime.translation.deliveryTimeId`,
`shipping_method.deliveryTime.translation.languageId`,
`shipping_method`.`created_at` as `shipping_method.createdAt`,
`shipping_method`.`updated_at` as `shipping_method.updatedAt`,
`shipping_method.shippingMethodType`.`id` as `shipping_method.shippingMethodType.id`,
`shipping_method.shippingMethodType`.`shipping_method_id` as `shipping_method.shippingMethodType.shippingMethodId`,
`shipping_method.shippingMethodType`.`type_key` as `shipping_method.shippingMethodType.typeKey`,
`shipping_method.shippingMethodType`.`penalties` as `shipping_method.shippingMethodType.penalties`,
`shipping_method.shippingMethodType`.`created_at` as `shipping_method.shippingMethodType.createdAt`,
`shipping_method.shippingMethodType`.`updated_at` as `shipping_method.shippingMethodType.updatedAt`,
`shipping_method.shippingMethodDeadline`.`id` as `shipping_method.shippingMethodDeadline.id`,
`shipping_method.shippingMethodDeadline`.`shipping_method_id` as `shipping_method.shippingMethodDeadline.shippingMethodId`,
`shipping_method.shippingMethodDeadline`.`deadlines` as `shipping_method.shippingMethodDeadline.deadlines`,
`shipping_method.shippingMethodDeadline`.`excluded_dates` as `shipping_method.shippingMethodDeadline.excludedDates`,
`shipping_method.shippingMethodDeadline`.`created_at` as `shipping_method.shippingMethodDeadline.createdAt`,
`shipping_method.shippingMethodDeadline`.`updated_at` as `shipping_method.shippingMethodDeadline.updatedAt`,
`shipping_method.shippingMethodConfig`.`id` as `shipping_method.shippingMethodConfig.id`,
`shipping_method.shippingMethodConfig`.`shipping_method_id` as `shipping_method.shippingMethodConfig.shippingMethodId`,
`shipping_method.shippingMethodConfig`.`shipping_comment_required` as `shipping_method.shippingMethodConfig.shippingCommentRequired`,
`shipping_method.shippingMethodConfig`.`created_at` as `shipping_method.shippingMethodConfig.createdAt`,
`shipping_method.shippingMethodConfig`.`updated_at` as `shipping_method.shippingMethodConfig.updatedAt`,
`shipping_method.tax`.`id` as `shipping_method.tax.id`,
`shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`,
`shipping_method.tax`.`name` as `shipping_method.tax.name`,
`shipping_method.tax`.`position` as `shipping_method.tax.position`,
`shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`,
`shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`,
`shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`,
`shipping_method.translation.name`,
COALESCE(
`shipping_method.translation.name`,
`shipping_method.translation.name`
) as `shipping_method.name`,
`shipping_method.translation.description`,
COALESCE(
`shipping_method.translation.description`,
`shipping_method.translation.description`
) as `shipping_method.description`,
`shipping_method.translation.trackingUrl`,
COALESCE(
`shipping_method.translation.trackingUrl`,
`shipping_method.translation.trackingUrl`
) as `shipping_method.trackingUrl`,
`shipping_method.translation.customFields`,
COALESCE(
`shipping_method.translation.customFields`,
`shipping_method.translation.customFields`
) as `shipping_method.customFields`,
`shipping_method.translation.createdAt`,
`shipping_method.translation.updatedAt`,
`shipping_method.translation.shippingMethodId`,
`shipping_method.translation.languageId`
FROM
`shipping_method`
LEFT JOIN (
SELECT
`shipping_method.translation`.shipping_method_id,
`shipping_method.translation`.name as `shipping_method.translation.name`,
`shipping_method.translation`.description as `shipping_method.translation.description`,
`shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`,
`shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`,
`shipping_method.translation`.created_at as `shipping_method.translation.createdAt`,
`shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`,
`shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`,
`shipping_method.translation`.language_id as `shipping_method.translation.languageId`
FROM
`shipping_method_translation` `shipping_method.translation`
WHERE
`shipping_method.translation`.language_id = : languageId
) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id`
LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
LEFT JOIN `wexo_shipping_method_type` `shipping_method.shippingMethodType` ON `shipping_method`.`id` = `shipping_method.shippingMethodType`.`shipping_method_id`
LEFT JOIN `wexo_shipping_method_deadline` `shipping_method.shippingMethodDeadline` ON `shipping_method`.`id` = `shipping_method.shippingMethodDeadline`.`shipping_method_id`
LEFT JOIN `wexo_shipping_method_config` `shipping_method.shippingMethodConfig` ON `shipping_method`.`id` = `shipping_method.shippingMethodConfig`.`shipping_method_id`
LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id`
LEFT JOIN (
SELECT
`shipping_method.deliveryTime.translation`.delivery_time_id,
`shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`,
`shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`,
`shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`,
`shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`,
`shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`,
`shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId`
FROM
`delivery_time_translation` `shipping_method.deliveryTime.translation`
WHERE
`shipping_method.deliveryTime.translation`.language_id = : languageId
) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id`
WHERE
`shipping_method`.`id` IN (: ids)
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.languageId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.shippingMethodType`.`id` as `shipping_method.shippingMethodType.id`, `shipping_method.shippingMethodType`.`shipping_method_id` as `shipping_method.shippingMethodType.shippingMethodId`, `shipping_method.shippingMethodType`.`type_key` as `shipping_method.shippingMethodType.typeKey`, `shipping_method.shippingMethodType`.`penalties` as `shipping_method.shippingMethodType.penalties`, `shipping_method.shippingMethodType`.`created_at` as `shipping_method.shippingMethodType.createdAt`, `shipping_method.shippingMethodType`.`updated_at` as `shipping_method.shippingMethodType.updatedAt`, `shipping_method.shippingMethodDeadline`.`id` as `shipping_method.shippingMethodDeadline.id`, `shipping_method.shippingMethodDeadline`.`shipping_method_id` as `shipping_method.shippingMethodDeadline.shippingMethodId`, `shipping_method.shippingMethodDeadline`.`deadlines` as `shipping_method.shippingMethodDeadline.deadlines`, `shipping_method.shippingMethodDeadline`.`excluded_dates` as `shipping_method.shippingMethodDeadline.excludedDates`, `shipping_method.shippingMethodDeadline`.`created_at` as `shipping_method.shippingMethodDeadline.createdAt`, `shipping_method.shippingMethodDeadline`.`updated_at` as `shipping_method.shippingMethodDeadline.updatedAt`, `shipping_method.shippingMethodConfig`.`id` as `shipping_method.shippingMethodConfig.id`, `shipping_method.shippingMethodConfig`.`shipping_method_id` as `shipping_method.shippingMethodConfig.shippingMethodId`, `shipping_method.shippingMethodConfig`.`shipping_comment_required` as `shipping_method.shippingMethodConfig.shippingCommentRequired`, `shipping_method.shippingMethodConfig`.`created_at` as `shipping_method.shippingMethodConfig.createdAt`, `shipping_method.shippingMethodConfig`.`updated_at` as `shipping_method.shippingMethodConfig.updatedAt`, `shipping_method.tax`.`id` as `shipping_method.tax.id`, `shipping_method.tax`.`tax_rate` as `shipping_method.tax.taxRate`, `shipping_method.tax`.`name` as `shipping_method.tax.name`, `shipping_method.tax`.`position` as `shipping_method.tax.position`, `shipping_method.tax`.`custom_fields` as `shipping_method.tax.customFields`, `shipping_method.tax`.`created_at` as `shipping_method.tax.createdAt`, `shipping_method.tax`.`updated_at` as `shipping_method.tax.updatedAt`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `wexo_shipping_method_type` `shipping_method.shippingMethodType` ON `shipping_method`.`id` = `shipping_method.shippingMethodType`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_deadline` `shipping_method.shippingMethodDeadline` ON `shipping_method`.`id` = `shipping_method.shippingMethodDeadline`.`shipping_method_id` LEFT JOIN `wexo_shipping_method_config` `shipping_method.shippingMethodConfig` ON `shipping_method`.`id` = `shipping_method.shippingMethodConfig`.`shipping_method_id` LEFT JOIN `tax` `shipping_method.tax` ON `shipping_method`.`tax_id` = `shipping_method.tax`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` WHERE `shipping_method.deliveryTime.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` WHERE `shipping_method`.`id` IN (0x8A9896CD7347453694B7DE23E5B9FDD7);
array:45 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 84)"
11 => "Shopware\Core\Checkout\Cart\Delivery\DeliveryProcessor::Shopware\Core\Checkout\Cart\Delivery\{closure} (line 57)"
12 => "Shopware\Core\Profiling\Profiler::trace (line 95)"
13 => "Shopware\Core\Checkout\Cart\Delivery\DeliveryProcessor::collect (line 101)"
14 => "Shopware\Core\Checkout\Cart\Processor::runProcessors (line 65)"
15 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
16 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
17 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
18 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
19 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
20 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
21 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
22 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
23 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
24 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
25 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
26 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
27 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
28 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
29 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
30 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
31 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
32 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
33 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
34 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
35 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
36 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
37 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
38 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
40 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
41 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
42 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
43 => "Shopware\Core\HttpKernel::doHandle (line 79)"
44 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.25 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_79775e8aff7c4e42af86a6cb3940292f))
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 (0x8A9896CD7347453694B7DE23E5B9FDD7));
array:49 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 468)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 409)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1153)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 138)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
13 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 84)"
15 => "Shopware\Core\Checkout\Cart\Delivery\DeliveryProcessor::Shopware\Core\Checkout\Cart\Delivery\{closure} (line 57)"
16 => "Shopware\Core\Profiling\Profiler::trace (line 95)"
17 => "Shopware\Core\Checkout\Cart\Delivery\DeliveryProcessor::collect (line 101)"
18 => "Shopware\Core\Checkout\Cart\Processor::runProcessors (line 65)"
19 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
20 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
21 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
22 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
23 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
24 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
25 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
26 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
27 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
28 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
29 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
30 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
31 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
32 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
33 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
34 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
35 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
36 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
37 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
38 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
39 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
40 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
41 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
42 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
43 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
44 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
45 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
46 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
47 => "Shopware\Core\HttpKernel::doHandle (line 79)"
48 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
1.30 ms (0.00%)
|
|
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_896d3306e1a14901ba8e6d12c186245f)
SELECT
`app`.`id` as `app.id`,
`app`.`name` as `app.name`,
`app`.`path` as `app.path`,
`app`.`author` as `app.author`,
`app`.`copyright` as `app.copyright`,
`app`.`license` as `app.license`,
`app`.`active` as `app.active`,
`app`.`configurable` as `app.configurable`,
`app`.`privacy` as `app.privacy`,
`app`.`version` as `app.version`,
`app`.`icon` as `app.iconRaw`,
`app`.`app_secret` as `app.appSecret`,
`app`.`modules` as `app.modules`,
`app`.`main_module` as `app.mainModule`,
`app`.`cookies` as `app.cookies`,
`app`.`allow_disable` as `app.allowDisable`,
`app`.`base_app_url` as `app.baseAppUrl`,
`app`.`allowed_hosts` as `app.allowedHosts`,
`app`.`template_load_priority` as `app.templateLoadPriority`,
`app`.`integration_id` as `app.integrationId`,
`app.integration`.`id` as `app.integration.id`,
`app.integration`.`label` as `app.integration.label`,
`app.integration`.`access_key` as `app.integration.accessKey`,
`app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
`app.integration`.`write_access` as `app.integration.writeAccess`,
`app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
`app.integration`.`admin` as `app.integration.admin`,
`app.integration`.`custom_fields` as `app.integration.customFields`,
`app.integration`.`deleted_at` as `app.integration.deletedAt`,
`app.integration`.`created_at` as `app.integration.createdAt`,
`app.integration`.`updated_at` as `app.integration.updatedAt`,
`app`.`acl_role_id` as `app.aclRoleId`,
`app.aclRole`.`id` as `app.aclRole.id`,
`app.aclRole`.`name` as `app.aclRole.name`,
`app.aclRole`.`description` as `app.aclRole.description`,
`app.aclRole`.`privileges` as `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` as `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
`app`.`created_at` as `app.createdAt`,
`app`.`updated_at` as `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) as `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) as `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) as `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label as `app.translation.label`,
`app.translation`.description as `app.translation.description`,
`app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields as `app.translation.customFields`,
`app.translation`.created_at as `app.translation.createdAt`,
`app.translation`.updated_at as `app.translation.updatedAt`,
`app.translation`.app_id as `app.translation.appId`,
`app.translation`.language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = : languageId
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
(
`app`.`active` = : param_896d3306e1a14901ba8e6d12c186245f
)
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);
array:45 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 117)"
11 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 71)"
12 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
14 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
15 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
16 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
17 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
18 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
19 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
20 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
21 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
22 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
23 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
24 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
25 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
26 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
27 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
28 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
29 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
30 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
31 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
32 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
33 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
34 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
35 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
36 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
37 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
38 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
40 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
41 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
42 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
43 => "Shopware\Core\HttpKernel::doHandle (line 79)"
44 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.15 ms (0.00%)
|
|
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 74)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
6 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
7 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
8 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
10 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
11 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
12 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
13 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
15 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
16 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
17 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
18 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
19 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
20 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
21 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
22 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
23 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
24 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
25 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.11 ms (0.00%)
|
|
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 90)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
6 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
7 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
8 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
10 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
11 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
12 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
13 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
15 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
16 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
17 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
18 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
19 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
20 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
21 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
22 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
23 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
24 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
25 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.19 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_2d593b4febfe43de80655032380af19c)) 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` = 0xFEA4C70D25004476BA9DEB2DD3A1D1B6)) AND (`country`.`id` IN (0xF4D11F62703344FBA4E4193FB909A35E)) GROUP BY `country`.`id`;
array:40 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 99)"
7 => "Shopware\Core\Checkout\Cart\Address\AddressValidator::isSalesChannelCountry (line 53)"
8 => "Shopware\Core\Checkout\Cart\Address\AddressValidator::validate (line 27)"
9 => "Shopware\Core\Checkout\Cart\Validator::validate (line 74)"
10 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
11 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
12 => "Shopware\Core\Checkout\Cart\Processor::process (line 127)"
13 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
15 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
16 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
17 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
18 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
19 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
20 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
21 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
22 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
23 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
24 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
25 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
26 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
27 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
28 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
29 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
30 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
31 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
32 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
33 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
34 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
38 => "Shopware\Core\HttpKernel::doHandle (line 79)"
39 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
1.21 ms (0.00%)
|
|
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_3f0aad240cad406ab5e67347408f3aaf)
SELECT
`app`.`id` as `app.id`,
`app`.`name` as `app.name`,
`app`.`path` as `app.path`,
`app`.`author` as `app.author`,
`app`.`copyright` as `app.copyright`,
`app`.`license` as `app.license`,
`app`.`active` as `app.active`,
`app`.`configurable` as `app.configurable`,
`app`.`privacy` as `app.privacy`,
`app`.`version` as `app.version`,
`app`.`icon` as `app.iconRaw`,
`app`.`app_secret` as `app.appSecret`,
`app`.`modules` as `app.modules`,
`app`.`main_module` as `app.mainModule`,
`app`.`cookies` as `app.cookies`,
`app`.`allow_disable` as `app.allowDisable`,
`app`.`base_app_url` as `app.baseAppUrl`,
`app`.`allowed_hosts` as `app.allowedHosts`,
`app`.`template_load_priority` as `app.templateLoadPriority`,
`app`.`integration_id` as `app.integrationId`,
`app.integration`.`id` as `app.integration.id`,
`app.integration`.`label` as `app.integration.label`,
`app.integration`.`access_key` as `app.integration.accessKey`,
`app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
`app.integration`.`write_access` as `app.integration.writeAccess`,
`app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
`app.integration`.`admin` as `app.integration.admin`,
`app.integration`.`custom_fields` as `app.integration.customFields`,
`app.integration`.`deleted_at` as `app.integration.deletedAt`,
`app.integration`.`created_at` as `app.integration.createdAt`,
`app.integration`.`updated_at` as `app.integration.updatedAt`,
`app`.`acl_role_id` as `app.aclRoleId`,
`app.aclRole`.`id` as `app.aclRole.id`,
`app.aclRole`.`name` as `app.aclRole.name`,
`app.aclRole`.`description` as `app.aclRole.description`,
`app.aclRole`.`privileges` as `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` as `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
`app`.`created_at` as `app.createdAt`,
`app`.`updated_at` as `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) as `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) as `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) as `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label as `app.translation.label`,
`app.translation`.description as `app.translation.description`,
`app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields as `app.translation.customFields`,
`app.translation`.created_at as `app.translation.createdAt`,
`app.translation`.updated_at as `app.translation.updatedAt`,
`app.translation`.app_id as `app.translation.appId`,
`app.translation`.language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = : languageId
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
(
`app`.`active` = : param_3f0aad240cad406ab5e67347408f3aaf
)
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);
array:45 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 117)"
11 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 71)"
12 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
14 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
15 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
16 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
17 => "Shopware\Core\Checkout\Cart\Processor::process (line 143)"
18 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
19 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
20 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
21 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
22 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
23 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
24 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
25 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
26 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
27 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
28 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
29 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
30 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
31 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
32 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
33 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
34 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
35 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
36 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
37 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
38 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
40 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
41 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
42 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
43 => "Shopware\Core\HttpKernel::doHandle (line 79)"
44 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.11 ms (0.00%)
|
|
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 74)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
6 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
7 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
8 => "Shopware\Core\Checkout\Cart\Processor::process (line 143)"
9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
10 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
11 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
12 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
13 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
15 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
16 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
17 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
18 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
19 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
20 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
21 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
22 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
23 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
24 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
25 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.09 ms (0.00%)
|
|
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 90)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 84)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 68)"
6 => "Shopware\Core\Checkout\Cart\Processor::Shopware\Core\Checkout\Cart\{closure} (line 57)"
7 => "Shopware\Core\Profiling\Profiler::trace (line 84)"
8 => "Shopware\Core\Checkout\Cart\Processor::process (line 143)"
9 => "Shopware\Core\Checkout\Cart\CartRuleLoader::Shopware\Core\Checkout\Cart\{closure} (line 57)"
10 => "Shopware\Core\Profiling\Profiler::trace (line 177)"
11 => "Shopware\Core\Checkout\Cart\CartRuleLoader::load (line 83)"
12 => "Shopware\Core\Checkout\Cart\CartRuleLoader::loadByToken (line 97)"
13 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::Shopware\Core\System\SalesChannel\Context\{closure} (line 57)"
14 => "Shopware\Core\Profiling\Profiler::trace (line 102)"
15 => "Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get (line 103)"
16 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
17 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
18 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
19 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
20 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
21 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
22 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
23 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
24 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
25 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.20 ms (0.00%)
|
|
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_633d46f7e29f4a1f81c445cad6b91b45 AND `script_manager`.`location` = :param_cab4b92c9f14421f8a8a58eed8d2aac1) ORDER BY `script_manager`.`priority` DESC
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = 1 AND `script_manager`.`location` = 'Header') ORDER BY `script_manager`.`priority` DESC;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 259)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 61)"
9 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::getCriteria (line 36)"
10 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::scriptManagerHeader (line 117)"
11 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
14 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 90)"
19 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 95)"
20 => "Shopware\Storefront\Page\GenericPageLoader::Shopware\Storefront\Page\{closure} (line 57)"
21 => "Shopware\Core\Profiling\Profiler::trace (line 138)"
22 => "Shopware\Storefront\Page\GenericPageLoader::load (line 140)"
23 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
24 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
25 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.16 ms (0.00%)
|
|
SELECT `script_manager`.`id` as `script_manager.id`, `script_manager`.`name` as `script_manager.name`, `script_manager`.`location` as `script_manager.location`, `script_manager`.`priority` as `script_manager.priority`, `script_manager`.`sales_channel` as `script_manager.salesChannel`, `script_manager`.`script` as `script_manager.script`, `script_manager`.`active` as `script_manager.active`, `script_manager`.`created_at` as `script_manager.createdAt`, `script_manager`.`updated_at` as `script_manager.updatedAt` FROM `script_manager` WHERE `script_manager`.`id` IN (:ids)
SELECT `script_manager`.`id` as `script_manager.id`, `script_manager`.`name` as `script_manager.name`, `script_manager`.`location` as `script_manager.location`, `script_manager`.`priority` as `script_manager.priority`, `script_manager`.`sales_channel` as `script_manager.salesChannel`, `script_manager`.`script` as `script_manager.script`, `script_manager`.`active` as `script_manager.active`, `script_manager`.`created_at` as `script_manager.createdAt`, `script_manager`.`updated_at` as `script_manager.updatedAt` FROM `script_manager` WHERE `script_manager`.`id` IN (0x3E4B35C784F34BABB3A4EEB2048AA396, 0x3F15BBEC2F364960A4B8436F010EE373, 0x93244D22965041788D688A20831BF42C);
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 61)"
9 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::getCriteria (line 36)"
10 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::scriptManagerHeader (line 117)"
11 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
14 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 90)"
19 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 95)"
20 => "Shopware\Storefront\Page\GenericPageLoader::Shopware\Storefront\Page\{closure} (line 57)"
21 => "Shopware\Core\Profiling\Profiler::trace (line 138)"
22 => "Shopware\Storefront\Page\GenericPageLoader::load (line 140)"
23 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
24 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
25 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.24 ms (0.00%)
|
|
SELECT `top_banner`.`id` as `top_banner.id`, `top_banner`.`active` as `top_banner.active`, `top_banner`.`sales_channel_ids` as `top_banner.salesChannelIds`, `top_banner`.`banner_name` as `top_banner.bannerName`, `top_banner`.`banner_background_color` as `top_banner.bannerBackgroundColor`, `top_banner`.`banner_text_color` as `top_banner.bannerTextColor`, `top_banner`.`banner_text` as `top_banner.bannerText`, `top_banner`.`banner_link` as `top_banner.bannerLink`, `top_banner`.`banner_position` as `top_banner.bannerPosition`, `top_banner`.`banner_class` as `top_banner.bannerClass`, `top_banner`.`banner_start_Date` as `top_banner.bannerStartDate`, `top_banner`.`banner_end_Date` as `top_banner.bannerEndDate`, `top_banner`.`created_at` as `top_banner.createdAt`, `top_banner`.`updated_at` as `top_banner.updatedAt` FROM `top_banner` WHERE (`top_banner`.`active` = :param_7304b74f0ae04bc0846e366b22fd2221 AND `top_banner`.`sales_channel_ids` LIKE :param_0a963f1bcf394d07b232847025ccb960 AND (((`top_banner`.`banner_start_Date` <= :param_94d947cf55c24e839be8f3b466be795c) OR `top_banner`.`banner_start_Date` <=> :param_ea656ec702654d86ae8fb80eb596ffbf) AND ((`top_banner`.`banner_end_Date` >= :param_6d3ec6cdd0f04860967e80d2fc99c174) OR `top_banner`.`banner_end_Date` <=> :param_b0c7ce91597445049760c04802886afb)))
SELECT `top_banner`.`id` as `top_banner.id`, `top_banner`.`active` as `top_banner.active`, `top_banner`.`sales_channel_ids` as `top_banner.salesChannelIds`, `top_banner`.`banner_name` as `top_banner.bannerName`, `top_banner`.`banner_background_color` as `top_banner.bannerBackgroundColor`, `top_banner`.`banner_text_color` as `top_banner.bannerTextColor`, `top_banner`.`banner_text` as `top_banner.bannerText`, `top_banner`.`banner_link` as `top_banner.bannerLink`, `top_banner`.`banner_position` as `top_banner.bannerPosition`, `top_banner`.`banner_class` as `top_banner.bannerClass`, `top_banner`.`banner_start_Date` as `top_banner.bannerStartDate`, `top_banner`.`banner_end_Date` as `top_banner.bannerEndDate`, `top_banner`.`created_at` as `top_banner.createdAt`, `top_banner`.`updated_at` as `top_banner.updatedAt` FROM `top_banner` WHERE (`top_banner`.`active` = 1 AND `top_banner`.`sales_channel_ids` LIKE '%fea4c70d25004476ba9deb2dd3a1d1b6%' AND (((`top_banner`.`banner_start_Date` <= '2024-10-22') OR `top_banner`.`banner_start_Date` <=> NULL) AND ((`top_banner`.`banner_end_Date` >= '2024-10-22') OR `top_banner`.`banner_end_Date` <=> NULL)));
array:35 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 79)"
9 => "Wexo\TopBanner\Subscriber\TopBannerSubscriber::onHeaderPageletLoaded (line 117)"
10 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
11 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
13 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
14 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
15 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
16 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
17 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 90)"
18 => "Shopware\Storefront\Pagelet\Header\HeaderPageletLoader::load (line 95)"
19 => "Shopware\Storefront\Page\GenericPageLoader::Shopware\Storefront\Page\{closure} (line 57)"
20 => "Shopware\Core\Profiling\Profiler::trace (line 138)"
21 => "Shopware\Storefront\Page\GenericPageLoader::load (line 140)"
22 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
23 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
24 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.14 ms (0.00%)
|
|
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = :param_7ef2e218e8df40d099df306473f818ff AND `script_manager`.`location` = :param_e9ff8535360c45df9cf0733b8f33b98c) ORDER BY `script_manager`.`priority` DESC
SELECT `script_manager`.`id` FROM `script_manager` WHERE (`script_manager`.`active` = 1 AND `script_manager`.`location` = 'Footer') ORDER BY `script_manager`.`priority` DESC;
array:36 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 259)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 61)"
9 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::getCriteria (line 44)"
10 => "Wexo\ScriptManager\Subscriber\scriptManagerSubscriber::scriptManagerFooter (line 117)"
11 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
14 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 51)"
19 => "Shopware\Storefront\Pagelet\Footer\FooterPageletLoader::load (line 99)"
20 => "Shopware\Storefront\Page\GenericPageLoader::Shopware\Storefront\Page\{closure} (line 57)"
21 => "Shopware\Core\Profiling\Profiler::trace (line 138)"
22 => "Shopware\Storefront\Page\GenericPageLoader::load (line 140)"
23 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
24 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
25 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
28 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
29 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
34 => "Shopware\Core\HttpKernel::doHandle (line 79)"
35 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.57 ms (0.00%)
|
|
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`session_id` = :param_97ac77c8728c4df9ba473dab69076a43) ORDER BY `coe_wishlist`.`created_at` DESC
SELECT `coe_wishlist`.`id` FROM `coe_wishlist` WHERE (`coe_wishlist`.`session_id` = 'b54nrmnnmasrukei4otsc5b41b') ORDER BY `coe_wishlist`.`created_at` DESC;
array:23 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 259)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 242)"
9 => "CoeWishlistSw6\Core\Content\Wishlist\Service\WishlistService::loadLists (line 144)"
10 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
11 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
12 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
21 => "Shopware\Core\HttpKernel::doHandle (line 79)"
22 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
1.79 ms (0.00%)
|
|
SELECT `coe_wishlist`.`id` as `coe_wishlist.id`, `coe_wishlist`.`name` as `coe_wishlist.name`, `coe_wishlist`.`default` as `coe_wishlist.default`, `coe_wishlist`.`customer_id` as `coe_wishlist.customerId`, `coe_wishlist`.`session_id` as `coe_wishlist.sessionId`, `coe_wishlist`.`public` as `coe_wishlist.public`, `coe_wishlist`.`custom_fields` as `coe_wishlist.customFields`, `coe_wishlist.customer`.`id` as `coe_wishlist.customer.id`, `coe_wishlist.customer`.`customer_group_id` as `coe_wishlist.customer.groupId`, `coe_wishlist.customer`.`default_payment_method_id` as `coe_wishlist.customer.defaultPaymentMethodId`, `coe_wishlist.customer`.`sales_channel_id` as `coe_wishlist.customer.salesChannelId`, `coe_wishlist.customer`.`language_id` as `coe_wishlist.customer.languageId`, `coe_wishlist.customer`.`last_payment_method_id` as `coe_wishlist.customer.lastPaymentMethodId`, `coe_wishlist.customer`.`default_billing_address_id` as `coe_wishlist.customer.defaultBillingAddressId`, `coe_wishlist.customer`.`default_shipping_address_id` as `coe_wishlist.customer.defaultShippingAddressId`, `coe_wishlist.customer`.`auto_increment` as `coe_wishlist.customer.autoIncrement`, `coe_wishlist.customer`.`customer_number` as `coe_wishlist.customer.customerNumber`, `coe_wishlist.customer`.`salutation_id` as `coe_wishlist.customer.salutationId`, `coe_wishlist.customer`.`first_name` as `coe_wishlist.customer.firstName`, `coe_wishlist.customer`.`last_name` as `coe_wishlist.customer.lastName`, `coe_wishlist.customer`.`company` as `coe_wishlist.customer.company`, `coe_wishlist.customer`.`password` as `coe_wishlist.customer.password`, `coe_wishlist.customer`.`email` as `coe_wishlist.customer.email`, `coe_wishlist.customer`.`title` as `coe_wishlist.customer.title`, `coe_wishlist.customer`.`vat_ids` as `coe_wishlist.customer.vatIds`, `coe_wishlist.customer`.`affiliate_code` as `coe_wishlist.customer.affiliateCode`, `coe_wishlist.customer`.`campaign_code` as `coe_wishlist.customer.campaignCode`, `coe_wishlist.customer`.`active` as `coe_wishlist.customer.active`, `coe_wishlist.customer`.`double_opt_in_registration` as `coe_wishlist.customer.doubleOptInRegistration`, `coe_wishlist.customer`.`double_opt_in_email_sent_date` as `coe_wishlist.customer.doubleOptInEmailSentDate`, `coe_wishlist.customer`.`double_opt_in_confirm_date` as `coe_wishlist.customer.doubleOptInConfirmDate`, `coe_wishlist.customer`.`hash` as `coe_wishlist.customer.hash`, `coe_wishlist.customer`.`guest` as `coe_wishlist.customer.guest`, `coe_wishlist.customer`.`first_login` as `coe_wishlist.customer.firstLogin`, `coe_wishlist.customer`.`last_login` as `coe_wishlist.customer.lastLogin`, `coe_wishlist.customer`.`newsletter_sales_channel_ids` as `coe_wishlist.customer.newsletterSalesChannelIds`, `coe_wishlist.customer`.`newsletter` as `coe_wishlist.customer.newsletter`, `coe_wishlist.customer`.`birthday` as `coe_wishlist.customer.birthday`, `coe_wishlist.customer`.`last_order_date` as `coe_wishlist.customer.lastOrderDate`, `coe_wishlist.customer`.`order_count` as `coe_wishlist.customer.orderCount`, `coe_wishlist.customer`.`order_total_amount` as `coe_wishlist.customer.orderTotalAmount`, `coe_wishlist.customer`.`custom_fields` as `coe_wishlist.customer.customFields`, `coe_wishlist.customer`.`legacy_password` as `coe_wishlist.customer.legacyPassword`, `coe_wishlist.customer`.`legacy_encoder` as `coe_wishlist.customer.legacyEncoder`, `coe_wishlist.customer`.`remote_address` as `coe_wishlist.customer.remoteAddress`, `coe_wishlist.customer`.`tag_ids` as `coe_wishlist.customer.tagIds`, `coe_wishlist.customer`.`requested_customer_group_id` as `coe_wishlist.customer.requestedGroupId`, `coe_wishlist.customer`.`bound_sales_channel_id` as `coe_wishlist.customer.boundSalesChannelId`, `coe_wishlist.customer`.`created_at` as `coe_wishlist.customer.createdAt`, `coe_wishlist.customer`.`updated_at` as `coe_wishlist.customer.updatedAt`, `coe_wishlist.customer.customerUser`.`id` as `coe_wishlist.customer.customerUser.id`, `coe_wishlist.customer.customerUser`.`customer_id` as `coe_wishlist.customer.customerUser.customerId`, `coe_wishlist.customer.customerUser`.`group_id` as `coe_wishlist.customer.customerUser.groupId`, `coe_wishlist.customer.customerUser`.`parent_customer_id` as `coe_wishlist.customer.customerUser.parentCustomerId`, `coe_wishlist.customer.customerUser`.`role` as `coe_wishlist.customer.customerUser.role`, `coe_wishlist.customer.customerUser`.`created_at` as `coe_wishlist.customer.customerUser.createdAt`, `coe_wishlist.customer.customerUser`.`updated_at` as `coe_wishlist.customer.customerUser.updatedAt`, `coe_wishlist`.`created_at` as `coe_wishlist.createdAt`, `coe_wishlist`.`updated_at` as `coe_wishlist.updatedAt` FROM `coe_wishlist` LEFT JOIN `customer` `coe_wishlist.customer` ON `coe_wishlist`.`customer_id` = `coe_wishlist.customer`.`id` LEFT JOIN `templaid_customer_user` `coe_wishlist.customer.customerUser` ON `coe_wishlist.customer`.`id` = `coe_wishlist.customer.customerUser`.`customer_id` WHERE `coe_wishlist`.`id` IN (:ids)
SELECT
`coe_wishlist`.`id` as `coe_wishlist.id`,
`coe_wishlist`.`name` as `coe_wishlist.name`,
`coe_wishlist`.`default` as `coe_wishlist.default`,
`coe_wishlist`.`customer_id` as `coe_wishlist.customerId`,
`coe_wishlist`.`session_id` as `coe_wishlist.sessionId`,
`coe_wishlist`.`public` as `coe_wishlist.public`,
`coe_wishlist`.`custom_fields` as `coe_wishlist.customFields`,
`coe_wishlist.customer`.`id` as `coe_wishlist.customer.id`,
`coe_wishlist.customer`.`customer_group_id` as `coe_wishlist.customer.groupId`,
`coe_wishlist.customer`.`default_payment_method_id` as `coe_wishlist.customer.defaultPaymentMethodId`,
`coe_wishlist.customer`.`sales_channel_id` as `coe_wishlist.customer.salesChannelId`,
`coe_wishlist.customer`.`language_id` as `coe_wishlist.customer.languageId`,
`coe_wishlist.customer`.`last_payment_method_id` as `coe_wishlist.customer.lastPaymentMethodId`,
`coe_wishlist.customer`.`default_billing_address_id` as `coe_wishlist.customer.defaultBillingAddressId`,
`coe_wishlist.customer`.`default_shipping_address_id` as `coe_wishlist.customer.defaultShippingAddressId`,
`coe_wishlist.customer`.`auto_increment` as `coe_wishlist.customer.autoIncrement`,
`coe_wishlist.customer`.`customer_number` as `coe_wishlist.customer.customerNumber`,
`coe_wishlist.customer`.`salutation_id` as `coe_wishlist.customer.salutationId`,
`coe_wishlist.customer`.`first_name` as `coe_wishlist.customer.firstName`,
`coe_wishlist.customer`.`last_name` as `coe_wishlist.customer.lastName`,
`coe_wishlist.customer`.`company` as `coe_wishlist.customer.company`,
`coe_wishlist.customer`.`password` as `coe_wishlist.customer.password`,
`coe_wishlist.customer`.`email` as `coe_wishlist.customer.email`,
`coe_wishlist.customer`.`title` as `coe_wishlist.customer.title`,
`coe_wishlist.customer`.`vat_ids` as `coe_wishlist.customer.vatIds`,
`coe_wishlist.customer`.`affiliate_code` as `coe_wishlist.customer.affiliateCode`,
`coe_wishlist.customer`.`campaign_code` as `coe_wishlist.customer.campaignCode`,
`coe_wishlist.customer`.`active` as `coe_wishlist.customer.active`,
`coe_wishlist.customer`.`double_opt_in_registration` as `coe_wishlist.customer.doubleOptInRegistration`,
`coe_wishlist.customer`.`double_opt_in_email_sent_date` as `coe_wishlist.customer.doubleOptInEmailSentDate`,
`coe_wishlist.customer`.`double_opt_in_confirm_date` as `coe_wishlist.customer.doubleOptInConfirmDate`,
`coe_wishlist.customer`.`hash` as `coe_wishlist.customer.hash`,
`coe_wishlist.customer`.`guest` as `coe_wishlist.customer.guest`,
`coe_wishlist.customer`.`first_login` as `coe_wishlist.customer.firstLogin`,
`coe_wishlist.customer`.`last_login` as `coe_wishlist.customer.lastLogin`,
`coe_wishlist.customer`.`newsletter_sales_channel_ids` as `coe_wishlist.customer.newsletterSalesChannelIds`,
`coe_wishlist.customer`.`newsletter` as `coe_wishlist.customer.newsletter`,
`coe_wishlist.customer`.`birthday` as `coe_wishlist.customer.birthday`,
`coe_wishlist.customer`.`last_order_date` as `coe_wishlist.customer.lastOrderDate`,
`coe_wishlist.customer`.`order_count` as `coe_wishlist.customer.orderCount`,
`coe_wishlist.customer`.`order_total_amount` as `coe_wishlist.customer.orderTotalAmount`,
`coe_wishlist.customer`.`custom_fields` as `coe_wishlist.customer.customFields`,
`coe_wishlist.customer`.`legacy_password` as `coe_wishlist.customer.legacyPassword`,
`coe_wishlist.customer`.`legacy_encoder` as `coe_wishlist.customer.legacyEncoder`,
`coe_wishlist.customer`.`remote_address` as `coe_wishlist.customer.remoteAddress`,
`coe_wishlist.customer`.`tag_ids` as `coe_wishlist.customer.tagIds`,
`coe_wishlist.customer`.`requested_customer_group_id` as `coe_wishlist.customer.requestedGroupId`,
`coe_wishlist.customer`.`bound_sales_channel_id` as `coe_wishlist.customer.boundSalesChannelId`,
`coe_wishlist.customer`.`created_at` as `coe_wishlist.customer.createdAt`,
`coe_wishlist.customer`.`updated_at` as `coe_wishlist.customer.updatedAt`,
`coe_wishlist.customer.customerUser`.`id` as `coe_wishlist.customer.customerUser.id`,
`coe_wishlist.customer.customerUser`.`customer_id` as `coe_wishlist.customer.customerUser.customerId`,
`coe_wishlist.customer.customerUser`.`group_id` as `coe_wishlist.customer.customerUser.groupId`,
`coe_wishlist.customer.customerUser`.`parent_customer_id` as `coe_wishlist.customer.customerUser.parentCustomerId`,
`coe_wishlist.customer.customerUser`.`role` as `coe_wishlist.customer.customerUser.role`,
`coe_wishlist.customer.customerUser`.`created_at` as `coe_wishlist.customer.customerUser.createdAt`,
`coe_wishlist.customer.customerUser`.`updated_at` as `coe_wishlist.customer.customerUser.updatedAt`,
`coe_wishlist`.`created_at` as `coe_wishlist.createdAt`,
`coe_wishlist`.`updated_at` as `coe_wishlist.updatedAt`
FROM
`coe_wishlist`
LEFT JOIN `customer` `coe_wishlist.customer` ON `coe_wishlist`.`customer_id` = `coe_wishlist.customer`.`id`
LEFT JOIN `templaid_customer_user` `coe_wishlist.customer.customerUser` ON `coe_wishlist.customer`.`id` = `coe_wishlist.customer.customerUser`.`customer_id`
WHERE
`coe_wishlist`.`id` IN (: ids)
SELECT `coe_wishlist`.`id` as `coe_wishlist.id`, `coe_wishlist`.`name` as `coe_wishlist.name`, `coe_wishlist`.`default` as `coe_wishlist.default`, `coe_wishlist`.`customer_id` as `coe_wishlist.customerId`, `coe_wishlist`.`session_id` as `coe_wishlist.sessionId`, `coe_wishlist`.`public` as `coe_wishlist.public`, `coe_wishlist`.`custom_fields` as `coe_wishlist.customFields`, `coe_wishlist.customer`.`id` as `coe_wishlist.customer.id`, `coe_wishlist.customer`.`customer_group_id` as `coe_wishlist.customer.groupId`, `coe_wishlist.customer`.`default_payment_method_id` as `coe_wishlist.customer.defaultPaymentMethodId`, `coe_wishlist.customer`.`sales_channel_id` as `coe_wishlist.customer.salesChannelId`, `coe_wishlist.customer`.`language_id` as `coe_wishlist.customer.languageId`, `coe_wishlist.customer`.`last_payment_method_id` as `coe_wishlist.customer.lastPaymentMethodId`, `coe_wishlist.customer`.`default_billing_address_id` as `coe_wishlist.customer.defaultBillingAddressId`, `coe_wishlist.customer`.`default_shipping_address_id` as `coe_wishlist.customer.defaultShippingAddressId`, `coe_wishlist.customer`.`auto_increment` as `coe_wishlist.customer.autoIncrement`, `coe_wishlist.customer`.`customer_number` as `coe_wishlist.customer.customerNumber`, `coe_wishlist.customer`.`salutation_id` as `coe_wishlist.customer.salutationId`, `coe_wishlist.customer`.`first_name` as `coe_wishlist.customer.firstName`, `coe_wishlist.customer`.`last_name` as `coe_wishlist.customer.lastName`, `coe_wishlist.customer`.`company` as `coe_wishlist.customer.company`, `coe_wishlist.customer`.`password` as `coe_wishlist.customer.password`, `coe_wishlist.customer`.`email` as `coe_wishlist.customer.email`, `coe_wishlist.customer`.`title` as `coe_wishlist.customer.title`, `coe_wishlist.customer`.`vat_ids` as `coe_wishlist.customer.vatIds`, `coe_wishlist.customer`.`affiliate_code` as `coe_wishlist.customer.affiliateCode`, `coe_wishlist.customer`.`campaign_code` as `coe_wishlist.customer.campaignCode`, `coe_wishlist.customer`.`active` as `coe_wishlist.customer.active`, `coe_wishlist.customer`.`double_opt_in_registration` as `coe_wishlist.customer.doubleOptInRegistration`, `coe_wishlist.customer`.`double_opt_in_email_sent_date` as `coe_wishlist.customer.doubleOptInEmailSentDate`, `coe_wishlist.customer`.`double_opt_in_confirm_date` as `coe_wishlist.customer.doubleOptInConfirmDate`, `coe_wishlist.customer`.`hash` as `coe_wishlist.customer.hash`, `coe_wishlist.customer`.`guest` as `coe_wishlist.customer.guest`, `coe_wishlist.customer`.`first_login` as `coe_wishlist.customer.firstLogin`, `coe_wishlist.customer`.`last_login` as `coe_wishlist.customer.lastLogin`, `coe_wishlist.customer`.`newsletter_sales_channel_ids` as `coe_wishlist.customer.newsletterSalesChannelIds`, `coe_wishlist.customer`.`newsletter` as `coe_wishlist.customer.newsletter`, `coe_wishlist.customer`.`birthday` as `coe_wishlist.customer.birthday`, `coe_wishlist.customer`.`last_order_date` as `coe_wishlist.customer.lastOrderDate`, `coe_wishlist.customer`.`order_count` as `coe_wishlist.customer.orderCount`, `coe_wishlist.customer`.`order_total_amount` as `coe_wishlist.customer.orderTotalAmount`, `coe_wishlist.customer`.`custom_fields` as `coe_wishlist.customer.customFields`, `coe_wishlist.customer`.`legacy_password` as `coe_wishlist.customer.legacyPassword`, `coe_wishlist.customer`.`legacy_encoder` as `coe_wishlist.customer.legacyEncoder`, `coe_wishlist.customer`.`remote_address` as `coe_wishlist.customer.remoteAddress`, `coe_wishlist.customer`.`tag_ids` as `coe_wishlist.customer.tagIds`, `coe_wishlist.customer`.`requested_customer_group_id` as `coe_wishlist.customer.requestedGroupId`, `coe_wishlist.customer`.`bound_sales_channel_id` as `coe_wishlist.customer.boundSalesChannelId`, `coe_wishlist.customer`.`created_at` as `coe_wishlist.customer.createdAt`, `coe_wishlist.customer`.`updated_at` as `coe_wishlist.customer.updatedAt`, `coe_wishlist.customer.customerUser`.`id` as `coe_wishlist.customer.customerUser.id`, `coe_wishlist.customer.customerUser`.`customer_id` as `coe_wishlist.customer.customerUser.customerId`, `coe_wishlist.customer.customerUser`.`group_id` as `coe_wishlist.customer.customerUser.groupId`, `coe_wishlist.customer.customerUser`.`parent_customer_id` as `coe_wishlist.customer.customerUser.parentCustomerId`, `coe_wishlist.customer.customerUser`.`role` as `coe_wishlist.customer.customerUser.role`, `coe_wishlist.customer.customerUser`.`created_at` as `coe_wishlist.customer.customerUser.createdAt`, `coe_wishlist.customer.customerUser`.`updated_at` as `coe_wishlist.customer.customerUser.updatedAt`, `coe_wishlist`.`created_at` as `coe_wishlist.createdAt`, `coe_wishlist`.`updated_at` as `coe_wishlist.updatedAt` FROM `coe_wishlist` LEFT JOIN `customer` `coe_wishlist.customer` ON `coe_wishlist`.`customer_id` = `coe_wishlist.customer`.`id` LEFT JOIN `templaid_customer_user` `coe_wishlist.customer.customerUser` ON `coe_wishlist.customer`.`id` = `coe_wishlist.customer.customerUser`.`customer_id` WHERE `coe_wishlist`.`id` IN (0xC22F0E9263674E99842DD700D7571128);
array:23 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 242)"
9 => "CoeWishlistSw6\Core\Content\Wishlist\Service\WishlistService::loadLists (line 144)"
10 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
11 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
12 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
21 => "Shopware\Core\HttpKernel::doHandle (line 79)"
22 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
14.22 ms (0.00%)
|
|
SELECT `coe_wishlist_note`.`id` as `coe_wishlist_note.id`, `coe_wishlist_note`.`wishlist_id` as `coe_wishlist_note.wishlistId`, `coe_wishlist_note`.`product_id` as `coe_wishlist_note.productId`, `coe_wishlist_note`.`quantity` as `coe_wishlist_note.quantity`, `coe_wishlist_note`.`custom_fields` as `coe_wishlist_note.customFields`, `coe_wishlist_note`.`created_at` as `coe_wishlist_note.createdAt`, `coe_wishlist_note`.`updated_at` as `coe_wishlist_note.updatedAt`, `coe_wishlist_note.product`.`id` as `coe_wishlist_note.product.id`, `coe_wishlist_note.product`.`version_id` as `coe_wishlist_note.product.versionId`, `coe_wishlist_note.product`.`parent_id` as `coe_wishlist_note.product.parentId`, `coe_wishlist_note.product`.`parent_version_id` as `coe_wishlist_note.product.parentVersionId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_id`) as `coe_wishlist_note.product.manufacturerId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_version_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_version_id`) as `coe_wishlist_note.product.productManufacturerVersionId`, COALESCE(`coe_wishlist_note.product`.`unit_id`, `coe_wishlist_note.product.parent`.`unit_id`) as `coe_wishlist_note.product.unitId`, COALESCE(`coe_wishlist_note.product`.`tax_id`, `coe_wishlist_note.product.parent`.`tax_id`) as `coe_wishlist_note.product.taxId`, COALESCE(`coe_wishlist_note.product`.`product_media_id`, `coe_wishlist_note.product.parent`.`product_media_id`) as `coe_wishlist_note.product.coverId`, COALESCE(`coe_wishlist_note.product`.`product_media_version_id`, `coe_wishlist_note.product.parent`.`product_media_version_id`) as `coe_wishlist_note.product.productMediaVersionId`, COALESCE(`coe_wishlist_note.product`.`delivery_time_id`, `coe_wishlist_note.product.parent`.`delivery_time_id`) as `coe_wishlist_note.product.deliveryTimeId`, COALESCE(`coe_wishlist_note.product`.`product_feature_set_id`, `coe_wishlist_note.product.parent`.`product_feature_set_id`) as `coe_wishlist_note.product.featureSetId`, COALESCE(`coe_wishlist_note.product`.`canonical_product_id`, `coe_wishlist_note.product.parent`.`canonical_product_id`) as `coe_wishlist_note.product.canonicalProductId`, COALESCE(`coe_wishlist_note.product`.`cms_page_id`, `coe_wishlist_note.product.parent`.`cms_page_id`) as `coe_wishlist_note.product.cmsPageId`, COALESCE(`coe_wishlist_note.product`.`cms_page_version_id`, `coe_wishlist_note.product.parent`.`cms_page_version_id`) as `coe_wishlist_note.product.cmsPageVersionId`, `coe_wishlist_note.product.parent`.`price` as `coe_wishlist_note.product.price.inherited`, COALESCE(`coe_wishlist_note.product`.`price`, `coe_wishlist_note.product.parent`.`price`) as `coe_wishlist_note.product.price`, `coe_wishlist_note.product`.`product_number` as `coe_wishlist_note.product.productNumber`, `coe_wishlist_note.product`.`stock` as `coe_wishlist_note.product.stock`, COALESCE(`coe_wishlist_note.product`.`restock_time`, `coe_wishlist_note.product.parent`.`restock_time`) as `coe_wishlist_note.product.restockTime`, `coe_wishlist_note.product`.`auto_increment` as `coe_wishlist_note.product.autoIncrement`, COALESCE(`coe_wishlist_note.product`.`active`, `coe_wishlist_note.product.parent`.`active`) as `coe_wishlist_note.product.active`, `coe_wishlist_note.product`.`available_stock` as `coe_wishlist_note.product.availableStock`, `coe_wishlist_note.product`.`available` as `coe_wishlist_note.product.available`, COALESCE(`coe_wishlist_note.product`.`is_closeout`, `coe_wishlist_note.product.parent`.`is_closeout`) as `coe_wishlist_note.product.isCloseout`, `coe_wishlist_note.product`.`display_group` as `coe_wishlist_note.product.displayGroup`, `coe_wishlist_note.product.parent`.`configurator_group_config` as `coe_wishlist_note.product.configuratorGroupConfig.inherited`, COALESCE(`coe_wishlist_note.product`.`configurator_group_config`, `coe_wishlist_note.product.parent`.`configurator_group_config`) as `coe_wishlist_note.product.configuratorGroupConfig`, COALESCE(`coe_wishlist_note.product`.`main_variant_id`, `coe_wishlist_note.product.parent`.`main_variant_id`) as `coe_wishlist_note.product.mainVariantId`, `coe_wishlist_note.product`.`variant_restrictions` as `coe_wishlist_note.product.variantRestrictions`, COALESCE(`coe_wishlist_note.product`.`manufacturer_number`, `coe_wishlist_note.product.parent`.`manufacturer_number`) as `coe_wishlist_note.product.manufacturerNumber`, COALESCE(`coe_wishlist_note.product`.`ean`, `coe_wishlist_note.product.parent`.`ean`) as `coe_wishlist_note.product.ean`, COALESCE(`coe_wishlist_note.product`.`purchase_steps`, `coe_wishlist_note.product.parent`.`purchase_steps`) as `coe_wishlist_note.product.purchaseSteps`, COALESCE(`coe_wishlist_note.product`.`max_purchase`, `coe_wishlist_note.product.parent`.`max_purchase`) as `coe_wishlist_note.product.maxPurchase`, COALESCE(`coe_wishlist_note.product`.`min_purchase`, `coe_wishlist_note.product.parent`.`min_purchase`) as `coe_wishlist_note.product.minPurchase`, COALESCE(`coe_wishlist_note.product`.`purchase_unit`, `coe_wishlist_note.product.parent`.`purchase_unit`) as `coe_wishlist_note.product.purchaseUnit`, COALESCE(`coe_wishlist_note.product`.`reference_unit`, `coe_wishlist_note.product.parent`.`reference_unit`) as `coe_wishlist_note.product.referenceUnit`, COALESCE(`coe_wishlist_note.product`.`shipping_free`, `coe_wishlist_note.product.parent`.`shipping_free`) as `coe_wishlist_note.product.shippingFree`, `coe_wishlist_note.product.parent`.`purchase_prices` as `coe_wishlist_note.product.purchasePrices.inherited`, COALESCE(`coe_wishlist_note.product`.`purchase_prices`, `coe_wishlist_note.product.parent`.`purchase_prices`) as `coe_wishlist_note.product.purchasePrices`, COALESCE(`coe_wishlist_note.product`.`mark_as_topseller`, `coe_wishlist_note.product.parent`.`mark_as_topseller`) as `coe_wishlist_note.product.markAsTopseller`, COALESCE(`coe_wishlist_note.product`.`weight`, `coe_wishlist_note.product.parent`.`weight`) as `coe_wishlist_note.product.weight`, COALESCE(`coe_wishlist_note.product`.`width`, `coe_wishlist_note.product.parent`.`width`) as `coe_wishlist_note.product.width`, COALESCE(`coe_wishlist_note.product`.`height`, `coe_wishlist_note.product.parent`.`height`) as `coe_wishlist_note.product.height`, COALESCE(`coe_wishlist_note.product`.`length`, `coe_wishlist_note.product.parent`.`length`) as `coe_wishlist_note.product.length`, COALESCE(`coe_wishlist_note.product`.`release_date`, `coe_wishlist_note.product.parent`.`release_date`) as `coe_wishlist_note.product.releaseDate`, COALESCE(`coe_wishlist_note.product`.`rating_average`, `coe_wishlist_note.product.parent`.`rating_average`) as `coe_wishlist_note.product.ratingAverage`, `coe_wishlist_note.product.parent`.`category_tree` as `coe_wishlist_note.product.categoryTree.inherited`, COALESCE(`coe_wishlist_note.product`.`category_tree`, `coe_wishlist_note.product.parent`.`category_tree`) as `coe_wishlist_note.product.categoryTree`, `coe_wishlist_note.product.parent`.`property_ids` as `coe_wishlist_note.product.propertyIds.inherited`, COALESCE(`coe_wishlist_note.product`.`property_ids`, `coe_wishlist_note.product.parent`.`property_ids`) as `coe_wishlist_note.product.propertyIds`, `coe_wishlist_note.product.parent`.`option_ids` as `coe_wishlist_note.product.optionIds.inherited`, COALESCE(`coe_wishlist_note.product`.`option_ids`, `coe_wishlist_note.product.parent`.`option_ids`) as `coe_wishlist_note.product.optionIds`, `coe_wishlist_note.product.parent`.`stream_ids` as `coe_wishlist_note.product.streamIds.inherited`, COALESCE(`coe_wishlist_note.product`.`stream_ids`, `coe_wishlist_note.product.parent`.`stream_ids`) as `coe_wishlist_note.product.streamIds`, `coe_wishlist_note.product.parent`.`tag_ids` as `coe_wishlist_note.product.tagIds.inherited`, COALESCE(`coe_wishlist_note.product`.`tag_ids`, `coe_wishlist_note.product.parent`.`tag_ids`) as `coe_wishlist_note.product.tagIds`, `coe_wishlist_note.product.parent`.`category_ids` as `coe_wishlist_note.product.categoryIds.inherited`, COALESCE(`coe_wishlist_note.product`.`category_ids`, `coe_wishlist_note.product.parent`.`category_ids`) as `coe_wishlist_note.product.categoryIds`, `coe_wishlist_note.product`.`child_count` as `coe_wishlist_note.product.childCount`, COALESCE(`coe_wishlist_note.product`.`custom_field_set_selection_active`, `coe_wishlist_note.product.parent`.`custom_field_set_selection_active`) as `coe_wishlist_note.product.customFieldSetSelectionActive`, `coe_wishlist_note.product`.`sales` as `coe_wishlist_note.product.sales`, `coe_wishlist_note.product.tax`.`id` as `coe_wishlist_note.product.tax.id`, `coe_wishlist_note.product.tax`.`tax_rate` as `coe_wishlist_note.product.tax.taxRate`, `coe_wishlist_note.product.tax`.`name` as `coe_wishlist_note.product.tax.name`, `coe_wishlist_note.product.tax`.`position` as `coe_wishlist_note.product.tax.position`, `coe_wishlist_note.product.tax`.`custom_fields` as `coe_wishlist_note.product.tax.customFields`, `coe_wishlist_note.product.tax`.`created_at` as `coe_wishlist_note.product.tax.createdAt`, `coe_wishlist_note.product.tax`.`updated_at` as `coe_wishlist_note.product.tax.updatedAt`, `coe_wishlist_note.product.parent`.`cheapest_price` as `coe_wishlist_note.product.cheapestPrice.inherited`, COALESCE(`coe_wishlist_note.product`.`cheapest_price`, `coe_wishlist_note.product.parent`.`cheapest_price`) as `coe_wishlist_note.product.cheapestPrice`, `coe_wishlist_note.product`.`created_at` as `coe_wishlist_note.product.createdAt`, `coe_wishlist_note.product`.`updated_at` as `coe_wishlist_note.product.updatedAt`, `coe_wishlist_note.product.additionalProductInfo`.`id` as `coe_wishlist_note.product.additionalProductInfo.id`, `coe_wishlist_note.product.additionalProductInfo`.`product_id` as `coe_wishlist_note.product.additionalProductInfo.productId`, `coe_wishlist_note.product.additionalProductInfo`.`created_at` as `coe_wishlist_note.product.additionalProductInfo.createdAt`, `coe_wishlist_note.product.additionalProductInfo`.`updated_at` as `coe_wishlist_note.product.additionalProductInfo.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`) as `coe_wishlist_note.product.additionalProductInfo.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,`coe_wishlist_note.product.additionalProductInfo.translation.customField1`) as `coe_wishlist_note.product.additionalProductInfo.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,`coe_wishlist_note.product.additionalProductInfo.translation.customField2`) as `coe_wishlist_note.product.additionalProductInfo.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,`coe_wishlist_note.product.additionalProductInfo.translation.customField3`) as `coe_wishlist_note.product.additionalProductInfo.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,`coe_wishlist_note.product.additionalProductInfo.translation.customField4`) as `coe_wishlist_note.product.additionalProductInfo.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation.languageId`, `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.parent.translation.metaDescription`, COALESCE(`coe_wishlist_note.product.translation.metaDescription`,`coe_wishlist_note.product.parent.translation.metaDescription`,`coe_wishlist_note.product.translation.metaDescription`) as `coe_wishlist_note.product.metaDescription`, `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.parent.translation.name`, COALESCE(`coe_wishlist_note.product.translation.name`,`coe_wishlist_note.product.parent.translation.name`,`coe_wishlist_note.product.translation.name`) as `coe_wishlist_note.product.name`, `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.parent.translation.keywords`, COALESCE(`coe_wishlist_note.product.translation.keywords`,`coe_wishlist_note.product.parent.translation.keywords`,`coe_wishlist_note.product.translation.keywords`) as `coe_wishlist_note.product.keywords`, `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.parent.translation.description`, COALESCE(`coe_wishlist_note.product.translation.description`,`coe_wishlist_note.product.parent.translation.description`,`coe_wishlist_note.product.translation.description`) as `coe_wishlist_note.product.description`, `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.parent.translation.metaTitle`, COALESCE(`coe_wishlist_note.product.translation.metaTitle`,`coe_wishlist_note.product.parent.translation.metaTitle`,`coe_wishlist_note.product.translation.metaTitle`) as `coe_wishlist_note.product.metaTitle`, `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.parent.translation.packUnit`, COALESCE(`coe_wishlist_note.product.translation.packUnit`,`coe_wishlist_note.product.parent.translation.packUnit`,`coe_wishlist_note.product.translation.packUnit`) as `coe_wishlist_note.product.packUnit`, `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation.packUnitPlural`, COALESCE(`coe_wishlist_note.product.translation.packUnitPlural`,`coe_wishlist_note.product.parent.translation.packUnitPlural`,`coe_wishlist_note.product.translation.packUnitPlural`) as `coe_wishlist_note.product.packUnitPlural`, `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation.customSearchKeywords`, COALESCE(`coe_wishlist_note.product.translation.customSearchKeywords`,`coe_wishlist_note.product.parent.translation.customSearchKeywords`,`coe_wishlist_note.product.translation.customSearchKeywords`) as `coe_wishlist_note.product.customSearchKeywords`, `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.parent.translation.slotConfig`, COALESCE(`coe_wishlist_note.product.translation.slotConfig`,`coe_wishlist_note.product.parent.translation.slotConfig`,`coe_wishlist_note.product.translation.slotConfig`) as `coe_wishlist_note.product.slotConfig`, `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.parent.translation.customFields`, COALESCE(`coe_wishlist_note.product.translation.customFields`,`coe_wishlist_note.product.parent.translation.customFields`,`coe_wishlist_note.product.translation.customFields`) as `coe_wishlist_note.product.customFields`, `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.translation.productVersionId`, `coe_wishlist_note.product.parent.translation.productVersionId` FROM `coe_wishlist_note` LEFT JOIN `product` `coe_wishlist_note.product` ON `coe_wishlist_note`.`product_id` = `coe_wishlist_note.product`.`id` LEFT JOIN `product` `coe_wishlist_note.product.parent` ON `coe_wishlist_note.product`.`parent_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product`.`version_id` = `coe_wishlist_note.product.parent`.`version_id` LEFT JOIN (SELECT `coe_wishlist_note.product.translation`.product_id, `coe_wishlist_note.product.translation`.product_version_id, `coe_wishlist_note.product.translation`.meta_description as `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.translation`.name as `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.translation`.keywords as `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.translation`.description as `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.translation`.meta_title as `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.translation`.pack_unit as `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.translation`.pack_unit_plural as `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.translation`.custom_search_keywords as `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.translation`.slot_config as `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.translation`.custom_fields as `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.translation`.created_at as `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.translation`.updated_at as `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.translation`.product_id as `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.translation`.language_id as `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.translation`.product_version_id as `coe_wishlist_note.product.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.translation` WHERE `coe_wishlist_note.product.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation` ON `coe_wishlist_note.product.product_translation`.`product_id` = `coe_wishlist_note.product`.`id` AND `coe_wishlist_note.product.product_translation`.product_version_id = `coe_wishlist_note.product`.version_id LEFT JOIN (SELECT `coe_wishlist_note.product.parent.translation`.product_id, `coe_wishlist_note.product.parent.translation`.product_version_id, `coe_wishlist_note.product.parent.translation`.meta_description as `coe_wishlist_note.product.parent.translation.metaDescription`, `coe_wishlist_note.product.parent.translation`.name as `coe_wishlist_note.product.parent.translation.name`, `coe_wishlist_note.product.parent.translation`.keywords as `coe_wishlist_note.product.parent.translation.keywords`, `coe_wishlist_note.product.parent.translation`.description as `coe_wishlist_note.product.parent.translation.description`, `coe_wishlist_note.product.parent.translation`.meta_title as `coe_wishlist_note.product.parent.translation.metaTitle`, `coe_wishlist_note.product.parent.translation`.pack_unit as `coe_wishlist_note.product.parent.translation.packUnit`, `coe_wishlist_note.product.parent.translation`.pack_unit_plural as `coe_wishlist_note.product.parent.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation`.custom_search_keywords as `coe_wishlist_note.product.parent.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation`.slot_config as `coe_wishlist_note.product.parent.translation.slotConfig`, `coe_wishlist_note.product.parent.translation`.custom_fields as `coe_wishlist_note.product.parent.translation.customFields`, `coe_wishlist_note.product.parent.translation`.created_at as `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.parent.translation`.updated_at as `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.parent.translation`.product_id as `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.parent.translation`.language_id as `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.parent.translation`.product_version_id as `coe_wishlist_note.product.parent.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.parent.translation` WHERE `coe_wishlist_note.product.parent.translation`.language_id = :languageId) `coe_wishlist_note.product.product_translation.parent` ON `coe_wishlist_note.product.product_translation.parent`.`product_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product.product_translation.parent`.product_version_id = `coe_wishlist_note.product.parent`.version_id LEFT JOIN `tax` `coe_wishlist_note.product.tax` ON `coe_wishlist_note.product`.`tax` = `coe_wishlist_note.product.tax`.`id` LEFT JOIN `additional_product_info` `coe_wishlist_note.product.additionalProductInfo` ON `coe_wishlist_note.product`.`id` = `coe_wishlist_note.product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id, `coe_wishlist_note.product.additionalProductInfo.translation`.alternative_name as `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_1 as `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_2 as `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_3 as `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_4 as `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation`.created_at as `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.updated_at as `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id as `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation`.language_id as `coe_wishlist_note.product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `coe_wishlist_note.product.additionalProductInfo.translation` WHERE `coe_wishlist_note.product.additionalProductInfo.translation`.language_id = :languageId) `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation` ON `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `coe_wishlist_note.product.additionalProductInfo`.`id` WHERE (`coe_wishlist_note`.`wishlist_id` IN (:param_f3f16ab0a2b849c0ad7b7b36f351f0de))
SELECT
`coe_wishlist_note`.`id` as `coe_wishlist_note.id`,
`coe_wishlist_note`.`wishlist_id` as `coe_wishlist_note.wishlistId`,
`coe_wishlist_note`.`product_id` as `coe_wishlist_note.productId`,
`coe_wishlist_note`.`quantity` as `coe_wishlist_note.quantity`,
`coe_wishlist_note`.`custom_fields` as `coe_wishlist_note.customFields`,
`coe_wishlist_note`.`created_at` as `coe_wishlist_note.createdAt`,
`coe_wishlist_note`.`updated_at` as `coe_wishlist_note.updatedAt`,
`coe_wishlist_note.product`.`id` as `coe_wishlist_note.product.id`,
`coe_wishlist_note.product`.`version_id` as `coe_wishlist_note.product.versionId`,
`coe_wishlist_note.product`.`parent_id` as `coe_wishlist_note.product.parentId`,
`coe_wishlist_note.product`.`parent_version_id` as `coe_wishlist_note.product.parentVersionId`,
COALESCE(
`coe_wishlist_note.product`.`product_manufacturer_id`,
`coe_wishlist_note.product.parent`.`product_manufacturer_id`
) as `coe_wishlist_note.product.manufacturerId`,
COALESCE(
`coe_wishlist_note.product`.`product_manufacturer_version_id`,
`coe_wishlist_note.product.parent`.`product_manufacturer_version_id`
) as `coe_wishlist_note.product.productManufacturerVersionId`,
COALESCE(
`coe_wishlist_note.product`.`unit_id`,
`coe_wishlist_note.product.parent`.`unit_id`
) as `coe_wishlist_note.product.unitId`,
COALESCE(
`coe_wishlist_note.product`.`tax_id`,
`coe_wishlist_note.product.parent`.`tax_id`
) as `coe_wishlist_note.product.taxId`,
COALESCE(
`coe_wishlist_note.product`.`product_media_id`,
`coe_wishlist_note.product.parent`.`product_media_id`
) as `coe_wishlist_note.product.coverId`,
COALESCE(
`coe_wishlist_note.product`.`product_media_version_id`,
`coe_wishlist_note.product.parent`.`product_media_version_id`
) as `coe_wishlist_note.product.productMediaVersionId`,
COALESCE(
`coe_wishlist_note.product`.`delivery_time_id`,
`coe_wishlist_note.product.parent`.`delivery_time_id`
) as `coe_wishlist_note.product.deliveryTimeId`,
COALESCE(
`coe_wishlist_note.product`.`product_feature_set_id`,
`coe_wishlist_note.product.parent`.`product_feature_set_id`
) as `coe_wishlist_note.product.featureSetId`,
COALESCE(
`coe_wishlist_note.product`.`canonical_product_id`,
`coe_wishlist_note.product.parent`.`canonical_product_id`
) as `coe_wishlist_note.product.canonicalProductId`,
COALESCE(
`coe_wishlist_note.product`.`cms_page_id`,
`coe_wishlist_note.product.parent`.`cms_page_id`
) as `coe_wishlist_note.product.cmsPageId`,
COALESCE(
`coe_wishlist_note.product`.`cms_page_version_id`,
`coe_wishlist_note.product.parent`.`cms_page_version_id`
) as `coe_wishlist_note.product.cmsPageVersionId`,
`coe_wishlist_note.product.parent`.`price` as `coe_wishlist_note.product.price.inherited`,
COALESCE(
`coe_wishlist_note.product`.`price`,
`coe_wishlist_note.product.parent`.`price`
) as `coe_wishlist_note.product.price`,
`coe_wishlist_note.product`.`product_number` as `coe_wishlist_note.product.productNumber`,
`coe_wishlist_note.product`.`stock` as `coe_wishlist_note.product.stock`,
COALESCE(
`coe_wishlist_note.product`.`restock_time`,
`coe_wishlist_note.product.parent`.`restock_time`
) as `coe_wishlist_note.product.restockTime`,
`coe_wishlist_note.product`.`auto_increment` as `coe_wishlist_note.product.autoIncrement`,
COALESCE(
`coe_wishlist_note.product`.`active`,
`coe_wishlist_note.product.parent`.`active`
) as `coe_wishlist_note.product.active`,
`coe_wishlist_note.product`.`available_stock` as `coe_wishlist_note.product.availableStock`,
`coe_wishlist_note.product`.`available` as `coe_wishlist_note.product.available`,
COALESCE(
`coe_wishlist_note.product`.`is_closeout`,
`coe_wishlist_note.product.parent`.`is_closeout`
) as `coe_wishlist_note.product.isCloseout`,
`coe_wishlist_note.product`.`display_group` as `coe_wishlist_note.product.displayGroup`,
`coe_wishlist_note.product.parent`.`configurator_group_config` as `coe_wishlist_note.product.configuratorGroupConfig.inherited`,
COALESCE(
`coe_wishlist_note.product`.`configurator_group_config`,
`coe_wishlist_note.product.parent`.`configurator_group_config`
) as `coe_wishlist_note.product.configuratorGroupConfig`,
COALESCE(
`coe_wishlist_note.product`.`main_variant_id`,
`coe_wishlist_note.product.parent`.`main_variant_id`
) as `coe_wishlist_note.product.mainVariantId`,
`coe_wishlist_note.product`.`variant_restrictions` as `coe_wishlist_note.product.variantRestrictions`,
COALESCE(
`coe_wishlist_note.product`.`manufacturer_number`,
`coe_wishlist_note.product.parent`.`manufacturer_number`
) as `coe_wishlist_note.product.manufacturerNumber`,
COALESCE(
`coe_wishlist_note.product`.`ean`,
`coe_wishlist_note.product.parent`.`ean`
) as `coe_wishlist_note.product.ean`,
COALESCE(
`coe_wishlist_note.product`.`purchase_steps`,
`coe_wishlist_note.product.parent`.`purchase_steps`
) as `coe_wishlist_note.product.purchaseSteps`,
COALESCE(
`coe_wishlist_note.product`.`max_purchase`,
`coe_wishlist_note.product.parent`.`max_purchase`
) as `coe_wishlist_note.product.maxPurchase`,
COALESCE(
`coe_wishlist_note.product`.`min_purchase`,
`coe_wishlist_note.product.parent`.`min_purchase`
) as `coe_wishlist_note.product.minPurchase`,
COALESCE(
`coe_wishlist_note.product`.`purchase_unit`,
`coe_wishlist_note.product.parent`.`purchase_unit`
) as `coe_wishlist_note.product.purchaseUnit`,
COALESCE(
`coe_wishlist_note.product`.`reference_unit`,
`coe_wishlist_note.product.parent`.`reference_unit`
) as `coe_wishlist_note.product.referenceUnit`,
COALESCE(
`coe_wishlist_note.product`.`shipping_free`,
`coe_wishlist_note.product.parent`.`shipping_free`
) as `coe_wishlist_note.product.shippingFree`,
`coe_wishlist_note.product.parent`.`purchase_prices` as `coe_wishlist_note.product.purchasePrices.inherited`,
COALESCE(
`coe_wishlist_note.product`.`purchase_prices`,
`coe_wishlist_note.product.parent`.`purchase_prices`
) as `coe_wishlist_note.product.purchasePrices`,
COALESCE(
`coe_wishlist_note.product`.`mark_as_topseller`,
`coe_wishlist_note.product.parent`.`mark_as_topseller`
) as `coe_wishlist_note.product.markAsTopseller`,
COALESCE(
`coe_wishlist_note.product`.`weight`,
`coe_wishlist_note.product.parent`.`weight`
) as `coe_wishlist_note.product.weight`,
COALESCE(
`coe_wishlist_note.product`.`width`,
`coe_wishlist_note.product.parent`.`width`
) as `coe_wishlist_note.product.width`,
COALESCE(
`coe_wishlist_note.product`.`height`,
`coe_wishlist_note.product.parent`.`height`
) as `coe_wishlist_note.product.height`,
COALESCE(
`coe_wishlist_note.product`.`length`,
`coe_wishlist_note.product.parent`.`length`
) as `coe_wishlist_note.product.length`,
COALESCE(
`coe_wishlist_note.product`.`release_date`,
`coe_wishlist_note.product.parent`.`release_date`
) as `coe_wishlist_note.product.releaseDate`,
COALESCE(
`coe_wishlist_note.product`.`rating_average`,
`coe_wishlist_note.product.parent`.`rating_average`
) as `coe_wishlist_note.product.ratingAverage`,
`coe_wishlist_note.product.parent`.`category_tree` as `coe_wishlist_note.product.categoryTree.inherited`,
COALESCE(
`coe_wishlist_note.product`.`category_tree`,
`coe_wishlist_note.product.parent`.`category_tree`
) as `coe_wishlist_note.product.categoryTree`,
`coe_wishlist_note.product.parent`.`property_ids` as `coe_wishlist_note.product.propertyIds.inherited`,
COALESCE(
`coe_wishlist_note.product`.`property_ids`,
`coe_wishlist_note.product.parent`.`property_ids`
) as `coe_wishlist_note.product.propertyIds`,
`coe_wishlist_note.product.parent`.`option_ids` as `coe_wishlist_note.product.optionIds.inherited`,
COALESCE(
`coe_wishlist_note.product`.`option_ids`,
`coe_wishlist_note.product.parent`.`option_ids`
) as `coe_wishlist_note.product.optionIds`,
`coe_wishlist_note.product.parent`.`stream_ids` as `coe_wishlist_note.product.streamIds.inherited`,
COALESCE(
`coe_wishlist_note.product`.`stream_ids`,
`coe_wishlist_note.product.parent`.`stream_ids`
) as `coe_wishlist_note.product.streamIds`,
`coe_wishlist_note.product.parent`.`tag_ids` as `coe_wishlist_note.product.tagIds.inherited`,
COALESCE(
`coe_wishlist_note.product`.`tag_ids`,
`coe_wishlist_note.product.parent`.`tag_ids`
) as `coe_wishlist_note.product.tagIds`,
`coe_wishlist_note.product.parent`.`category_ids` as `coe_wishlist_note.product.categoryIds.inherited`,
COALESCE(
`coe_wishlist_note.product`.`category_ids`,
`coe_wishlist_note.product.parent`.`category_ids`
) as `coe_wishlist_note.product.categoryIds`,
`coe_wishlist_note.product`.`child_count` as `coe_wishlist_note.product.childCount`,
COALESCE(
`coe_wishlist_note.product`.`custom_field_set_selection_active`,
`coe_wishlist_note.product.parent`.`custom_field_set_selection_active`
) as `coe_wishlist_note.product.customFieldSetSelectionActive`,
`coe_wishlist_note.product`.`sales` as `coe_wishlist_note.product.sales`,
`coe_wishlist_note.product.tax`.`id` as `coe_wishlist_note.product.tax.id`,
`coe_wishlist_note.product.tax`.`tax_rate` as `coe_wishlist_note.product.tax.taxRate`,
`coe_wishlist_note.product.tax`.`name` as `coe_wishlist_note.product.tax.name`,
`coe_wishlist_note.product.tax`.`position` as `coe_wishlist_note.product.tax.position`,
`coe_wishlist_note.product.tax`.`custom_fields` as `coe_wishlist_note.product.tax.customFields`,
`coe_wishlist_note.product.tax`.`created_at` as `coe_wishlist_note.product.tax.createdAt`,
`coe_wishlist_note.product.tax`.`updated_at` as `coe_wishlist_note.product.tax.updatedAt`,
`coe_wishlist_note.product.parent`.`cheapest_price` as `coe_wishlist_note.product.cheapestPrice.inherited`,
COALESCE(
`coe_wishlist_note.product`.`cheapest_price`,
`coe_wishlist_note.product.parent`.`cheapest_price`
) as `coe_wishlist_note.product.cheapestPrice`,
`coe_wishlist_note.product`.`created_at` as `coe_wishlist_note.product.createdAt`,
`coe_wishlist_note.product`.`updated_at` as `coe_wishlist_note.product.updatedAt`,
`coe_wishlist_note.product.additionalProductInfo`.`id` as `coe_wishlist_note.product.additionalProductInfo.id`,
`coe_wishlist_note.product.additionalProductInfo`.`product_id` as `coe_wishlist_note.product.additionalProductInfo.productId`,
`coe_wishlist_note.product.additionalProductInfo`.`created_at` as `coe_wishlist_note.product.additionalProductInfo.createdAt`,
`coe_wishlist_note.product.additionalProductInfo`.`updated_at` as `coe_wishlist_note.product.additionalProductInfo.updatedAt`,
`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,
COALESCE(
`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,
`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`
) as `coe_wishlist_note.product.additionalProductInfo.alternativeName`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,
COALESCE(
`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField1`
) as `coe_wishlist_note.product.additionalProductInfo.customField1`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,
COALESCE(
`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField2`
) as `coe_wishlist_note.product.additionalProductInfo.customField2`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,
COALESCE(
`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField3`
) as `coe_wishlist_note.product.additionalProductInfo.customField3`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,
COALESCE(
`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,
`coe_wishlist_note.product.additionalProductInfo.translation.customField4`
) as `coe_wishlist_note.product.additionalProductInfo.customField4`,
`coe_wishlist_note.product.additionalProductInfo.translation.createdAt`,
`coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`,
`coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`,
`coe_wishlist_note.product.additionalProductInfo.translation.languageId`,
`coe_wishlist_note.product.translation.metaDescription`,
`coe_wishlist_note.product.parent.translation.metaDescription`,
COALESCE(
`coe_wishlist_note.product.translation.metaDescription`,
`coe_wishlist_note.product.parent.translation.metaDescription`,
`coe_wishlist_note.product.translation.metaDescription`
) as `coe_wishlist_note.product.metaDescription`,
`coe_wishlist_note.product.translation.name`,
`coe_wishlist_note.product.parent.translation.name`,
COALESCE(
`coe_wishlist_note.product.translation.name`,
`coe_wishlist_note.product.parent.translation.name`,
`coe_wishlist_note.product.translation.name`
) as `coe_wishlist_note.product.name`,
`coe_wishlist_note.product.translation.keywords`,
`coe_wishlist_note.product.parent.translation.keywords`,
COALESCE(
`coe_wishlist_note.product.translation.keywords`,
`coe_wishlist_note.product.parent.translation.keywords`,
`coe_wishlist_note.product.translation.keywords`
) as `coe_wishlist_note.product.keywords`,
`coe_wishlist_note.product.translation.description`,
`coe_wishlist_note.product.parent.translation.description`,
COALESCE(
`coe_wishlist_note.product.translation.description`,
`coe_wishlist_note.product.parent.translation.description`,
`coe_wishlist_note.product.translation.description`
) as `coe_wishlist_note.product.description`,
`coe_wishlist_note.product.translation.metaTitle`,
`coe_wishlist_note.product.parent.translation.metaTitle`,
COALESCE(
`coe_wishlist_note.product.translation.metaTitle`,
`coe_wishlist_note.product.parent.translation.metaTitle`,
`coe_wishlist_note.product.translation.metaTitle`
) as `coe_wishlist_note.product.metaTitle`,
`coe_wishlist_note.product.translation.packUnit`,
`coe_wishlist_note.product.parent.translation.packUnit`,
COALESCE(
`coe_wishlist_note.product.translation.packUnit`,
`coe_wishlist_note.product.parent.translation.packUnit`,
`coe_wishlist_note.product.translation.packUnit`
) as `coe_wishlist_note.product.packUnit`,
`coe_wishlist_note.product.translation.packUnitPlural`,
`coe_wishlist_note.product.parent.translation.packUnitPlural`,
COALESCE(
`coe_wishlist_note.product.translation.packUnitPlural`,
`coe_wishlist_note.product.parent.translation.packUnitPlural`,
`coe_wishlist_note.product.translation.packUnitPlural`
) as `coe_wishlist_note.product.packUnitPlural`,
`coe_wishlist_note.product.translation.customSearchKeywords`,
`coe_wishlist_note.product.parent.translation.customSearchKeywords`,
COALESCE(
`coe_wishlist_note.product.translation.customSearchKeywords`,
`coe_wishlist_note.product.parent.translation.customSearchKeywords`,
`coe_wishlist_note.product.translation.customSearchKeywords`
) as `coe_wishlist_note.product.customSearchKeywords`,
`coe_wishlist_note.product.translation.slotConfig`,
`coe_wishlist_note.product.parent.translation.slotConfig`,
COALESCE(
`coe_wishlist_note.product.translation.slotConfig`,
`coe_wishlist_note.product.parent.translation.slotConfig`,
`coe_wishlist_note.product.translation.slotConfig`
) as `coe_wishlist_note.product.slotConfig`,
`coe_wishlist_note.product.translation.customFields`,
`coe_wishlist_note.product.parent.translation.customFields`,
COALESCE(
`coe_wishlist_note.product.translation.customFields`,
`coe_wishlist_note.product.parent.translation.customFields`,
`coe_wishlist_note.product.translation.customFields`
) as `coe_wishlist_note.product.customFields`,
`coe_wishlist_note.product.translation.createdAt`,
`coe_wishlist_note.product.parent.translation.createdAt`,
`coe_wishlist_note.product.translation.updatedAt`,
`coe_wishlist_note.product.parent.translation.updatedAt`,
`coe_wishlist_note.product.translation.productId`,
`coe_wishlist_note.product.parent.translation.productId`,
`coe_wishlist_note.product.translation.languageId`,
`coe_wishlist_note.product.parent.translation.languageId`,
`coe_wishlist_note.product.translation.productVersionId`,
`coe_wishlist_note.product.parent.translation.productVersionId`
FROM
`coe_wishlist_note`
LEFT JOIN `product` `coe_wishlist_note.product` ON `coe_wishlist_note`.`product_id` = `coe_wishlist_note.product`.`id`
LEFT JOIN `product` `coe_wishlist_note.product.parent` ON `coe_wishlist_note.product`.`parent_id` = `coe_wishlist_note.product.parent`.`id`
AND `coe_wishlist_note.product`.`version_id` = `coe_wishlist_note.product.parent`.`version_id`
LEFT JOIN (
SELECT
`coe_wishlist_note.product.translation`.product_id,
`coe_wishlist_note.product.translation`.product_version_id,
`coe_wishlist_note.product.translation`.meta_description as `coe_wishlist_note.product.translation.metaDescription`,
`coe_wishlist_note.product.translation`.name as `coe_wishlist_note.product.translation.name`,
`coe_wishlist_note.product.translation`.keywords as `coe_wishlist_note.product.translation.keywords`,
`coe_wishlist_note.product.translation`.description as `coe_wishlist_note.product.translation.description`,
`coe_wishlist_note.product.translation`.meta_title as `coe_wishlist_note.product.translation.metaTitle`,
`coe_wishlist_note.product.translation`.pack_unit as `coe_wishlist_note.product.translation.packUnit`,
`coe_wishlist_note.product.translation`.pack_unit_plural as `coe_wishlist_note.product.translation.packUnitPlural`,
`coe_wishlist_note.product.translation`.custom_search_keywords as `coe_wishlist_note.product.translation.customSearchKeywords`,
`coe_wishlist_note.product.translation`.slot_config as `coe_wishlist_note.product.translation.slotConfig`,
`coe_wishlist_note.product.translation`.custom_fields as `coe_wishlist_note.product.translation.customFields`,
`coe_wishlist_note.product.translation`.created_at as `coe_wishlist_note.product.translation.createdAt`,
`coe_wishlist_note.product.translation`.updated_at as `coe_wishlist_note.product.translation.updatedAt`,
`coe_wishlist_note.product.translation`.product_id as `coe_wishlist_note.product.translation.productId`,
`coe_wishlist_note.product.translation`.language_id as `coe_wishlist_note.product.translation.languageId`,
`coe_wishlist_note.product.translation`.product_version_id as `coe_wishlist_note.product.translation.productVersionId`
FROM
`product_translation` `coe_wishlist_note.product.translation`
WHERE
`coe_wishlist_note.product.translation`.language_id = : languageId
) `coe_wishlist_note.product.product_translation` ON `coe_wishlist_note.product.product_translation`.`product_id` = `coe_wishlist_note.product`.`id`
AND `coe_wishlist_note.product.product_translation`.product_version_id = `coe_wishlist_note.product`.version_id
LEFT JOIN (
SELECT
`coe_wishlist_note.product.parent.translation`.product_id,
`coe_wishlist_note.product.parent.translation`.product_version_id,
`coe_wishlist_note.product.parent.translation`.meta_description as `coe_wishlist_note.product.parent.translation.metaDescription`,
`coe_wishlist_note.product.parent.translation`.name as `coe_wishlist_note.product.parent.translation.name`,
`coe_wishlist_note.product.parent.translation`.keywords as `coe_wishlist_note.product.parent.translation.keywords`,
`coe_wishlist_note.product.parent.translation`.description as `coe_wishlist_note.product.parent.translation.description`,
`coe_wishlist_note.product.parent.translation`.meta_title as `coe_wishlist_note.product.parent.translation.metaTitle`,
`coe_wishlist_note.product.parent.translation`.pack_unit as `coe_wishlist_note.product.parent.translation.packUnit`,
`coe_wishlist_note.product.parent.translation`.pack_unit_plural as `coe_wishlist_note.product.parent.translation.packUnitPlural`,
`coe_wishlist_note.product.parent.translation`.custom_search_keywords as `coe_wishlist_note.product.parent.translation.customSearchKeywords`,
`coe_wishlist_note.product.parent.translation`.slot_config as `coe_wishlist_note.product.parent.translation.slotConfig`,
`coe_wishlist_note.product.parent.translation`.custom_fields as `coe_wishlist_note.product.parent.translation.customFields`,
`coe_wishlist_note.product.parent.translation`.created_at as `coe_wishlist_note.product.parent.translation.createdAt`,
`coe_wishlist_note.product.parent.translation`.updated_at as `coe_wishlist_note.product.parent.translation.updatedAt`,
`coe_wishlist_note.product.parent.translation`.product_id as `coe_wishlist_note.product.parent.translation.productId`,
`coe_wishlist_note.product.parent.translation`.language_id as `coe_wishlist_note.product.parent.translation.languageId`,
`coe_wishlist_note.product.parent.translation`.product_version_id as `coe_wishlist_note.product.parent.translation.productVersionId`
FROM
`product_translation` `coe_wishlist_note.product.parent.translation`
WHERE
`coe_wishlist_note.product.parent.translation`.language_id = : languageId
) `coe_wishlist_note.product.product_translation.parent` ON `coe_wishlist_note.product.product_translation.parent`.`product_id` = `coe_wishlist_note.product.parent`.`id`
AND `coe_wishlist_note.product.product_translation.parent`.product_version_id = `coe_wishlist_note.product.parent`.version_id
LEFT JOIN `tax` `coe_wishlist_note.product.tax` ON `coe_wishlist_note.product`.`tax` = `coe_wishlist_note.product.tax`.`id`
LEFT JOIN `additional_product_info` `coe_wishlist_note.product.additionalProductInfo` ON `coe_wishlist_note.product`.`id` = `coe_wishlist_note.product.additionalProductInfo`.`product_id`
LEFT JOIN (
SELECT
`coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id,
`coe_wishlist_note.product.additionalProductInfo.translation`.alternative_name as `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,
`coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_1 as `coe_wishlist_note.product.additionalProductInfo.translation.customField1`,
`coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_2 as `coe_wishlist_note.product.additionalProductInfo.translation.customField2`,
`coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_3 as `coe_wishlist_note.product.additionalProductInfo.translation.customField3`,
`coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_4 as `coe_wishlist_note.product.additionalProductInfo.translation.customField4`,
`coe_wishlist_note.product.additionalProductInfo.translation`.created_at as `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`,
`coe_wishlist_note.product.additionalProductInfo.translation`.updated_at as `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`,
`coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id as `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`,
`coe_wishlist_note.product.additionalProductInfo.translation`.language_id as `coe_wishlist_note.product.additionalProductInfo.translation.languageId`
FROM
`additional_product_info_translation` `coe_wishlist_note.product.additionalProductInfo.translation`
WHERE
`coe_wishlist_note.product.additionalProductInfo.translation`.language_id = : languageId
) `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation` ON `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `coe_wishlist_note.product.additionalProductInfo`.`id`
WHERE
(
`coe_wishlist_note`.`wishlist_id` IN (
: param_f3f16ab0a2b849c0ad7b7b36f351f0de
)
)
SELECT `coe_wishlist_note`.`id` as `coe_wishlist_note.id`, `coe_wishlist_note`.`wishlist_id` as `coe_wishlist_note.wishlistId`, `coe_wishlist_note`.`product_id` as `coe_wishlist_note.productId`, `coe_wishlist_note`.`quantity` as `coe_wishlist_note.quantity`, `coe_wishlist_note`.`custom_fields` as `coe_wishlist_note.customFields`, `coe_wishlist_note`.`created_at` as `coe_wishlist_note.createdAt`, `coe_wishlist_note`.`updated_at` as `coe_wishlist_note.updatedAt`, `coe_wishlist_note.product`.`id` as `coe_wishlist_note.product.id`, `coe_wishlist_note.product`.`version_id` as `coe_wishlist_note.product.versionId`, `coe_wishlist_note.product`.`parent_id` as `coe_wishlist_note.product.parentId`, `coe_wishlist_note.product`.`parent_version_id` as `coe_wishlist_note.product.parentVersionId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_id`) as `coe_wishlist_note.product.manufacturerId`, COALESCE(`coe_wishlist_note.product`.`product_manufacturer_version_id`, `coe_wishlist_note.product.parent`.`product_manufacturer_version_id`) as `coe_wishlist_note.product.productManufacturerVersionId`, COALESCE(`coe_wishlist_note.product`.`unit_id`, `coe_wishlist_note.product.parent`.`unit_id`) as `coe_wishlist_note.product.unitId`, COALESCE(`coe_wishlist_note.product`.`tax_id`, `coe_wishlist_note.product.parent`.`tax_id`) as `coe_wishlist_note.product.taxId`, COALESCE(`coe_wishlist_note.product`.`product_media_id`, `coe_wishlist_note.product.parent`.`product_media_id`) as `coe_wishlist_note.product.coverId`, COALESCE(`coe_wishlist_note.product`.`product_media_version_id`, `coe_wishlist_note.product.parent`.`product_media_version_id`) as `coe_wishlist_note.product.productMediaVersionId`, COALESCE(`coe_wishlist_note.product`.`delivery_time_id`, `coe_wishlist_note.product.parent`.`delivery_time_id`) as `coe_wishlist_note.product.deliveryTimeId`, COALESCE(`coe_wishlist_note.product`.`product_feature_set_id`, `coe_wishlist_note.product.parent`.`product_feature_set_id`) as `coe_wishlist_note.product.featureSetId`, COALESCE(`coe_wishlist_note.product`.`canonical_product_id`, `coe_wishlist_note.product.parent`.`canonical_product_id`) as `coe_wishlist_note.product.canonicalProductId`, COALESCE(`coe_wishlist_note.product`.`cms_page_id`, `coe_wishlist_note.product.parent`.`cms_page_id`) as `coe_wishlist_note.product.cmsPageId`, COALESCE(`coe_wishlist_note.product`.`cms_page_version_id`, `coe_wishlist_note.product.parent`.`cms_page_version_id`) as `coe_wishlist_note.product.cmsPageVersionId`, `coe_wishlist_note.product.parent`.`price` as `coe_wishlist_note.product.price.inherited`, COALESCE(`coe_wishlist_note.product`.`price`, `coe_wishlist_note.product.parent`.`price`) as `coe_wishlist_note.product.price`, `coe_wishlist_note.product`.`product_number` as `coe_wishlist_note.product.productNumber`, `coe_wishlist_note.product`.`stock` as `coe_wishlist_note.product.stock`, COALESCE(`coe_wishlist_note.product`.`restock_time`, `coe_wishlist_note.product.parent`.`restock_time`) as `coe_wishlist_note.product.restockTime`, `coe_wishlist_note.product`.`auto_increment` as `coe_wishlist_note.product.autoIncrement`, COALESCE(`coe_wishlist_note.product`.`active`, `coe_wishlist_note.product.parent`.`active`) as `coe_wishlist_note.product.active`, `coe_wishlist_note.product`.`available_stock` as `coe_wishlist_note.product.availableStock`, `coe_wishlist_note.product`.`available` as `coe_wishlist_note.product.available`, COALESCE(`coe_wishlist_note.product`.`is_closeout`, `coe_wishlist_note.product.parent`.`is_closeout`) as `coe_wishlist_note.product.isCloseout`, `coe_wishlist_note.product`.`display_group` as `coe_wishlist_note.product.displayGroup`, `coe_wishlist_note.product.parent`.`configurator_group_config` as `coe_wishlist_note.product.configuratorGroupConfig.inherited`, COALESCE(`coe_wishlist_note.product`.`configurator_group_config`, `coe_wishlist_note.product.parent`.`configurator_group_config`) as `coe_wishlist_note.product.configuratorGroupConfig`, COALESCE(`coe_wishlist_note.product`.`main_variant_id`, `coe_wishlist_note.product.parent`.`main_variant_id`) as `coe_wishlist_note.product.mainVariantId`, `coe_wishlist_note.product`.`variant_restrictions` as `coe_wishlist_note.product.variantRestrictions`, COALESCE(`coe_wishlist_note.product`.`manufacturer_number`, `coe_wishlist_note.product.parent`.`manufacturer_number`) as `coe_wishlist_note.product.manufacturerNumber`, COALESCE(`coe_wishlist_note.product`.`ean`, `coe_wishlist_note.product.parent`.`ean`) as `coe_wishlist_note.product.ean`, COALESCE(`coe_wishlist_note.product`.`purchase_steps`, `coe_wishlist_note.product.parent`.`purchase_steps`) as `coe_wishlist_note.product.purchaseSteps`, COALESCE(`coe_wishlist_note.product`.`max_purchase`, `coe_wishlist_note.product.parent`.`max_purchase`) as `coe_wishlist_note.product.maxPurchase`, COALESCE(`coe_wishlist_note.product`.`min_purchase`, `coe_wishlist_note.product.parent`.`min_purchase`) as `coe_wishlist_note.product.minPurchase`, COALESCE(`coe_wishlist_note.product`.`purchase_unit`, `coe_wishlist_note.product.parent`.`purchase_unit`) as `coe_wishlist_note.product.purchaseUnit`, COALESCE(`coe_wishlist_note.product`.`reference_unit`, `coe_wishlist_note.product.parent`.`reference_unit`) as `coe_wishlist_note.product.referenceUnit`, COALESCE(`coe_wishlist_note.product`.`shipping_free`, `coe_wishlist_note.product.parent`.`shipping_free`) as `coe_wishlist_note.product.shippingFree`, `coe_wishlist_note.product.parent`.`purchase_prices` as `coe_wishlist_note.product.purchasePrices.inherited`, COALESCE(`coe_wishlist_note.product`.`purchase_prices`, `coe_wishlist_note.product.parent`.`purchase_prices`) as `coe_wishlist_note.product.purchasePrices`, COALESCE(`coe_wishlist_note.product`.`mark_as_topseller`, `coe_wishlist_note.product.parent`.`mark_as_topseller`) as `coe_wishlist_note.product.markAsTopseller`, COALESCE(`coe_wishlist_note.product`.`weight`, `coe_wishlist_note.product.parent`.`weight`) as `coe_wishlist_note.product.weight`, COALESCE(`coe_wishlist_note.product`.`width`, `coe_wishlist_note.product.parent`.`width`) as `coe_wishlist_note.product.width`, COALESCE(`coe_wishlist_note.product`.`height`, `coe_wishlist_note.product.parent`.`height`) as `coe_wishlist_note.product.height`, COALESCE(`coe_wishlist_note.product`.`length`, `coe_wishlist_note.product.parent`.`length`) as `coe_wishlist_note.product.length`, COALESCE(`coe_wishlist_note.product`.`release_date`, `coe_wishlist_note.product.parent`.`release_date`) as `coe_wishlist_note.product.releaseDate`, COALESCE(`coe_wishlist_note.product`.`rating_average`, `coe_wishlist_note.product.parent`.`rating_average`) as `coe_wishlist_note.product.ratingAverage`, `coe_wishlist_note.product.parent`.`category_tree` as `coe_wishlist_note.product.categoryTree.inherited`, COALESCE(`coe_wishlist_note.product`.`category_tree`, `coe_wishlist_note.product.parent`.`category_tree`) as `coe_wishlist_note.product.categoryTree`, `coe_wishlist_note.product.parent`.`property_ids` as `coe_wishlist_note.product.propertyIds.inherited`, COALESCE(`coe_wishlist_note.product`.`property_ids`, `coe_wishlist_note.product.parent`.`property_ids`) as `coe_wishlist_note.product.propertyIds`, `coe_wishlist_note.product.parent`.`option_ids` as `coe_wishlist_note.product.optionIds.inherited`, COALESCE(`coe_wishlist_note.product`.`option_ids`, `coe_wishlist_note.product.parent`.`option_ids`) as `coe_wishlist_note.product.optionIds`, `coe_wishlist_note.product.parent`.`stream_ids` as `coe_wishlist_note.product.streamIds.inherited`, COALESCE(`coe_wishlist_note.product`.`stream_ids`, `coe_wishlist_note.product.parent`.`stream_ids`) as `coe_wishlist_note.product.streamIds`, `coe_wishlist_note.product.parent`.`tag_ids` as `coe_wishlist_note.product.tagIds.inherited`, COALESCE(`coe_wishlist_note.product`.`tag_ids`, `coe_wishlist_note.product.parent`.`tag_ids`) as `coe_wishlist_note.product.tagIds`, `coe_wishlist_note.product.parent`.`category_ids` as `coe_wishlist_note.product.categoryIds.inherited`, COALESCE(`coe_wishlist_note.product`.`category_ids`, `coe_wishlist_note.product.parent`.`category_ids`) as `coe_wishlist_note.product.categoryIds`, `coe_wishlist_note.product`.`child_count` as `coe_wishlist_note.product.childCount`, COALESCE(`coe_wishlist_note.product`.`custom_field_set_selection_active`, `coe_wishlist_note.product.parent`.`custom_field_set_selection_active`) as `coe_wishlist_note.product.customFieldSetSelectionActive`, `coe_wishlist_note.product`.`sales` as `coe_wishlist_note.product.sales`, `coe_wishlist_note.product.tax`.`id` as `coe_wishlist_note.product.tax.id`, `coe_wishlist_note.product.tax`.`tax_rate` as `coe_wishlist_note.product.tax.taxRate`, `coe_wishlist_note.product.tax`.`name` as `coe_wishlist_note.product.tax.name`, `coe_wishlist_note.product.tax`.`position` as `coe_wishlist_note.product.tax.position`, `coe_wishlist_note.product.tax`.`custom_fields` as `coe_wishlist_note.product.tax.customFields`, `coe_wishlist_note.product.tax`.`created_at` as `coe_wishlist_note.product.tax.createdAt`, `coe_wishlist_note.product.tax`.`updated_at` as `coe_wishlist_note.product.tax.updatedAt`, `coe_wishlist_note.product.parent`.`cheapest_price` as `coe_wishlist_note.product.cheapestPrice.inherited`, COALESCE(`coe_wishlist_note.product`.`cheapest_price`, `coe_wishlist_note.product.parent`.`cheapest_price`) as `coe_wishlist_note.product.cheapestPrice`, `coe_wishlist_note.product`.`created_at` as `coe_wishlist_note.product.createdAt`, `coe_wishlist_note.product`.`updated_at` as `coe_wishlist_note.product.updatedAt`, `coe_wishlist_note.product.additionalProductInfo`.`id` as `coe_wishlist_note.product.additionalProductInfo.id`, `coe_wishlist_note.product.additionalProductInfo`.`product_id` as `coe_wishlist_note.product.additionalProductInfo.productId`, `coe_wishlist_note.product.additionalProductInfo`.`created_at` as `coe_wishlist_note.product.additionalProductInfo.createdAt`, `coe_wishlist_note.product.additionalProductInfo`.`updated_at` as `coe_wishlist_note.product.additionalProductInfo.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`,`coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`) as `coe_wishlist_note.product.additionalProductInfo.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField1`,`coe_wishlist_note.product.additionalProductInfo.translation.customField1`) as `coe_wishlist_note.product.additionalProductInfo.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField2`,`coe_wishlist_note.product.additionalProductInfo.translation.customField2`) as `coe_wishlist_note.product.additionalProductInfo.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField3`,`coe_wishlist_note.product.additionalProductInfo.translation.customField3`) as `coe_wishlist_note.product.additionalProductInfo.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, COALESCE(`coe_wishlist_note.product.additionalProductInfo.translation.customField4`,`coe_wishlist_note.product.additionalProductInfo.translation.customField4`) as `coe_wishlist_note.product.additionalProductInfo.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation.languageId`, `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.parent.translation.metaDescription`, COALESCE(`coe_wishlist_note.product.translation.metaDescription`,`coe_wishlist_note.product.parent.translation.metaDescription`,`coe_wishlist_note.product.translation.metaDescription`) as `coe_wishlist_note.product.metaDescription`, `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.parent.translation.name`, COALESCE(`coe_wishlist_note.product.translation.name`,`coe_wishlist_note.product.parent.translation.name`,`coe_wishlist_note.product.translation.name`) as `coe_wishlist_note.product.name`, `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.parent.translation.keywords`, COALESCE(`coe_wishlist_note.product.translation.keywords`,`coe_wishlist_note.product.parent.translation.keywords`,`coe_wishlist_note.product.translation.keywords`) as `coe_wishlist_note.product.keywords`, `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.parent.translation.description`, COALESCE(`coe_wishlist_note.product.translation.description`,`coe_wishlist_note.product.parent.translation.description`,`coe_wishlist_note.product.translation.description`) as `coe_wishlist_note.product.description`, `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.parent.translation.metaTitle`, COALESCE(`coe_wishlist_note.product.translation.metaTitle`,`coe_wishlist_note.product.parent.translation.metaTitle`,`coe_wishlist_note.product.translation.metaTitle`) as `coe_wishlist_note.product.metaTitle`, `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.parent.translation.packUnit`, COALESCE(`coe_wishlist_note.product.translation.packUnit`,`coe_wishlist_note.product.parent.translation.packUnit`,`coe_wishlist_note.product.translation.packUnit`) as `coe_wishlist_note.product.packUnit`, `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation.packUnitPlural`, COALESCE(`coe_wishlist_note.product.translation.packUnitPlural`,`coe_wishlist_note.product.parent.translation.packUnitPlural`,`coe_wishlist_note.product.translation.packUnitPlural`) as `coe_wishlist_note.product.packUnitPlural`, `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation.customSearchKeywords`, COALESCE(`coe_wishlist_note.product.translation.customSearchKeywords`,`coe_wishlist_note.product.parent.translation.customSearchKeywords`,`coe_wishlist_note.product.translation.customSearchKeywords`) as `coe_wishlist_note.product.customSearchKeywords`, `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.parent.translation.slotConfig`, COALESCE(`coe_wishlist_note.product.translation.slotConfig`,`coe_wishlist_note.product.parent.translation.slotConfig`,`coe_wishlist_note.product.translation.slotConfig`) as `coe_wishlist_note.product.slotConfig`, `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.parent.translation.customFields`, COALESCE(`coe_wishlist_note.product.translation.customFields`,`coe_wishlist_note.product.parent.translation.customFields`,`coe_wishlist_note.product.translation.customFields`) as `coe_wishlist_note.product.customFields`, `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.translation.productVersionId`, `coe_wishlist_note.product.parent.translation.productVersionId` FROM `coe_wishlist_note` LEFT JOIN `product` `coe_wishlist_note.product` ON `coe_wishlist_note`.`product_id` = `coe_wishlist_note.product`.`id` LEFT JOIN `product` `coe_wishlist_note.product.parent` ON `coe_wishlist_note.product`.`parent_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product`.`version_id` = `coe_wishlist_note.product.parent`.`version_id` LEFT JOIN (SELECT `coe_wishlist_note.product.translation`.product_id, `coe_wishlist_note.product.translation`.product_version_id, `coe_wishlist_note.product.translation`.meta_description as `coe_wishlist_note.product.translation.metaDescription`, `coe_wishlist_note.product.translation`.name as `coe_wishlist_note.product.translation.name`, `coe_wishlist_note.product.translation`.keywords as `coe_wishlist_note.product.translation.keywords`, `coe_wishlist_note.product.translation`.description as `coe_wishlist_note.product.translation.description`, `coe_wishlist_note.product.translation`.meta_title as `coe_wishlist_note.product.translation.metaTitle`, `coe_wishlist_note.product.translation`.pack_unit as `coe_wishlist_note.product.translation.packUnit`, `coe_wishlist_note.product.translation`.pack_unit_plural as `coe_wishlist_note.product.translation.packUnitPlural`, `coe_wishlist_note.product.translation`.custom_search_keywords as `coe_wishlist_note.product.translation.customSearchKeywords`, `coe_wishlist_note.product.translation`.slot_config as `coe_wishlist_note.product.translation.slotConfig`, `coe_wishlist_note.product.translation`.custom_fields as `coe_wishlist_note.product.translation.customFields`, `coe_wishlist_note.product.translation`.created_at as `coe_wishlist_note.product.translation.createdAt`, `coe_wishlist_note.product.translation`.updated_at as `coe_wishlist_note.product.translation.updatedAt`, `coe_wishlist_note.product.translation`.product_id as `coe_wishlist_note.product.translation.productId`, `coe_wishlist_note.product.translation`.language_id as `coe_wishlist_note.product.translation.languageId`, `coe_wishlist_note.product.translation`.product_version_id as `coe_wishlist_note.product.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.translation` WHERE `coe_wishlist_note.product.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `coe_wishlist_note.product.product_translation` ON `coe_wishlist_note.product.product_translation`.`product_id` = `coe_wishlist_note.product`.`id` AND `coe_wishlist_note.product.product_translation`.product_version_id = `coe_wishlist_note.product`.version_id LEFT JOIN (SELECT `coe_wishlist_note.product.parent.translation`.product_id, `coe_wishlist_note.product.parent.translation`.product_version_id, `coe_wishlist_note.product.parent.translation`.meta_description as `coe_wishlist_note.product.parent.translation.metaDescription`, `coe_wishlist_note.product.parent.translation`.name as `coe_wishlist_note.product.parent.translation.name`, `coe_wishlist_note.product.parent.translation`.keywords as `coe_wishlist_note.product.parent.translation.keywords`, `coe_wishlist_note.product.parent.translation`.description as `coe_wishlist_note.product.parent.translation.description`, `coe_wishlist_note.product.parent.translation`.meta_title as `coe_wishlist_note.product.parent.translation.metaTitle`, `coe_wishlist_note.product.parent.translation`.pack_unit as `coe_wishlist_note.product.parent.translation.packUnit`, `coe_wishlist_note.product.parent.translation`.pack_unit_plural as `coe_wishlist_note.product.parent.translation.packUnitPlural`, `coe_wishlist_note.product.parent.translation`.custom_search_keywords as `coe_wishlist_note.product.parent.translation.customSearchKeywords`, `coe_wishlist_note.product.parent.translation`.slot_config as `coe_wishlist_note.product.parent.translation.slotConfig`, `coe_wishlist_note.product.parent.translation`.custom_fields as `coe_wishlist_note.product.parent.translation.customFields`, `coe_wishlist_note.product.parent.translation`.created_at as `coe_wishlist_note.product.parent.translation.createdAt`, `coe_wishlist_note.product.parent.translation`.updated_at as `coe_wishlist_note.product.parent.translation.updatedAt`, `coe_wishlist_note.product.parent.translation`.product_id as `coe_wishlist_note.product.parent.translation.productId`, `coe_wishlist_note.product.parent.translation`.language_id as `coe_wishlist_note.product.parent.translation.languageId`, `coe_wishlist_note.product.parent.translation`.product_version_id as `coe_wishlist_note.product.parent.translation.productVersionId` FROM `product_translation` `coe_wishlist_note.product.parent.translation` WHERE `coe_wishlist_note.product.parent.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `coe_wishlist_note.product.product_translation.parent` ON `coe_wishlist_note.product.product_translation.parent`.`product_id` = `coe_wishlist_note.product.parent`.`id` AND `coe_wishlist_note.product.product_translation.parent`.product_version_id = `coe_wishlist_note.product.parent`.version_id LEFT JOIN `tax` `coe_wishlist_note.product.tax` ON `coe_wishlist_note.product`.`tax` = `coe_wishlist_note.product.tax`.`id` LEFT JOIN `additional_product_info` `coe_wishlist_note.product.additionalProductInfo` ON `coe_wishlist_note.product`.`id` = `coe_wishlist_note.product.additionalProductInfo`.`product_id` LEFT JOIN (SELECT `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id, `coe_wishlist_note.product.additionalProductInfo.translation`.alternative_name as `coe_wishlist_note.product.additionalProductInfo.translation.alternativeName`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_1 as `coe_wishlist_note.product.additionalProductInfo.translation.customField1`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_2 as `coe_wishlist_note.product.additionalProductInfo.translation.customField2`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_3 as `coe_wishlist_note.product.additionalProductInfo.translation.customField3`, `coe_wishlist_note.product.additionalProductInfo.translation`.custom_field_4 as `coe_wishlist_note.product.additionalProductInfo.translation.customField4`, `coe_wishlist_note.product.additionalProductInfo.translation`.created_at as `coe_wishlist_note.product.additionalProductInfo.translation.createdAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.updated_at as `coe_wishlist_note.product.additionalProductInfo.translation.updatedAt`, `coe_wishlist_note.product.additionalProductInfo.translation`.additional_product_info_id as `coe_wishlist_note.product.additionalProductInfo.translation.additionalProductInfoId`, `coe_wishlist_note.product.additionalProductInfo.translation`.language_id as `coe_wishlist_note.product.additionalProductInfo.translation.languageId` FROM `additional_product_info_translation` `coe_wishlist_note.product.additionalProductInfo.translation` WHERE `coe_wishlist_note.product.additionalProductInfo.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation` ON `coe_wishlist_note.product.additionalProductInfo.additional_product_info_translation`.`additional_product_info_id` = `coe_wishlist_note.product.additionalProductInfo`.`id` WHERE (`coe_wishlist_note`.`wishlist_id` IN (0xC22F0E9263674E99842DD700D7571128));
array:27 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 468)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 409)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1153)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 138)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 242)"
13 => "CoeWishlistSw6\Core\Content\Wishlist\Service\WishlistService::loadLists (line 144)"
14 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::loadPrivateList (line 116)"
15 => "CoeWishlistSw6\Storefront\Page\Wishlist\WishlistPageLoader::load (line 112)"
16 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
25 => "Shopware\Core\HttpKernel::doHandle (line 79)"
26 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.13 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;
array:20 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1093)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociativeIndexed (line 66)"
3 => "Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder::getAppTemplateNamespaces (line 45)"
4 => "Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder::buildNamespaceHierarchy (line 33)"
5 => "Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder::buildHierarchy (line 139)"
6 => "Shopware\Core\Framework\Adapter\Twig\TemplateFinder::getNamespaceHierarchy (line 63)"
7 => "Shopware\Core\Framework\Adapter\Twig\TemplateFinder::find (line 56)"
8 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
9 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
10 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
11 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
12 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
13 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
14 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
15 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
18 => "Shopware\Core\HttpKernel::doHandle (line 79)"
19 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.17 ms (0.00%)
|
|
SELECT `name`, `path`, `author`
FROM `app`
WHERE `active` = 1
SELECT `name`, `path`, `author`
FROM `app`
WHERE `active` = 1
;
array:25 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 44)"
3 => "Shopware\Core\Framework\App\ActiveAppsLoader::loadApps (line 30)"
4 => "Shopware\Core\Framework\App\ActiveAppsLoader::getActiveApps (line 75)"
5 => "Shopware\Storefront\Theme\StorefrontPluginRegistry::addAppConfigs (line 50)"
6 => "Shopware\Storefront\Theme\StorefrontPluginRegistry::getConfigurations (line 80)"
7 => "Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder::getThemeInheritance (line 29)"
8 => "Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder::build (line 50)"
9 => "Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder::buildNamespaceHierarchy (line 33)"
10 => "Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder::buildHierarchy (line 139)"
11 => "Shopware\Core\Framework\Adapter\Twig\TemplateFinder::getNamespaceHierarchy (line 63)"
12 => "Shopware\Core\Framework\Adapter\Twig\TemplateFinder::find (line 56)"
13 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
14 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
23 => "Shopware\Core\HttpKernel::doHandle (line 79)"
24 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.21 ms (0.00%)
|
|
SELECT `rhiem_ar_group`.`id` FROM `rhiem_ar_group` WHERE (`rhiem_ar_group`.`active` = :param_d30d3e3b6e3e4c0088512d2c265410ed AND (`rhiem_ar_group`.`channel_ids` = :param_33bbf946b4a74a4da8c88290d2e9e59e OR `rhiem_ar_group`.`channel_ids` <=> :param_63475dbf38634cc38f0bf528f87c7681 OR `rhiem_ar_group`.`channel_ids` LIKE :param_c4ba7ff4a8a249529bdb6c87b7cfdf72)) 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 '%fea4c70d25004476ba9deb2dd3a1d1b6%')) ORDER BY `rhiem_ar_group`.`position` ASC;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 105)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 60)"
4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 44)"
5 => "Wexo\RelewiseSearch\Core\Framework\DataAbstractionLayer\Dbal\RelewiseEntitySearcher::search (line 129)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 259)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 58)"
9 => "RhiemExtendedRegistration\Components\Services\RegistrationGroupService::getRegistrationGroups (line 55)"
10 => "RhiemExtendedRegistration\Subscriber\Frontend\GroupsToPage::onStorefrontRenderEvent (line 117)"
11 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
14 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 60)"
19 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
20 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.36 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.label`, COALESCE(`rhiem_ar_group.translation.label`,`rhiem_ar_group.translation.label`) as `rhiem_ar_group.label`, `rhiem_ar_group.translation.description`, COALESCE(`rhiem_ar_group.translation.description`,`rhiem_ar_group.translation.description`) as `rhiem_ar_group.description`, `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation.rhiemArGroupId`, `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` FROM `rhiem_ar_group_translation` `rhiem_ar_group.translation` 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.label`, COALESCE(`rhiem_ar_group.translation.label`,`rhiem_ar_group.translation.label`) as `rhiem_ar_group.label`, `rhiem_ar_group.translation.description`, COALESCE(`rhiem_ar_group.translation.description`,`rhiem_ar_group.translation.description`) as `rhiem_ar_group.description`, `rhiem_ar_group.translation.createdAt`, `rhiem_ar_group.translation.updatedAt`, `rhiem_ar_group.translation.rhiemArGroupId`, `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` FROM `rhiem_ar_group_translation` `rhiem_ar_group.translation` 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 (0xA492A821AD7F48469C223DD56C4EBA65);
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 58)"
9 => "RhiemExtendedRegistration\Components\Services\RegistrationGroupService::getRegistrationGroups (line 55)"
10 => "RhiemExtendedRegistration\Subscriber\Frontend\GroupsToPage::onStorefrontRenderEvent (line 117)"
11 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
12 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
13 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
14 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
15 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
16 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
17 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
18 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 60)"
19 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
20 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.81 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.label`, COALESCE(`rhiem_ar_attribute.translation.label`,`rhiem_ar_attribute.translation.label`) as `rhiem_ar_attribute.label`, `rhiem_ar_attribute.translation.description`, COALESCE(`rhiem_ar_attribute.translation.description`,`rhiem_ar_attribute.translation.description`) as `rhiem_ar_attribute.description`, `rhiem_ar_attribute.translation.errorMsg`, COALESCE(`rhiem_ar_attribute.translation.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`) as `rhiem_ar_attribute.errorMsg`, `rhiem_ar_attribute.translation.errorMsgMin`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`) as `rhiem_ar_attribute.errorMsgMin`, `rhiem_ar_attribute.translation.errorMsgMax`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`) as `rhiem_ar_attribute.errorMsgMax`, `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation.rhiemArAttributeId`, `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` FROM `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation` 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_49df434ce87245fb8c1e91333b4643f6 AND (`rhiem_ar_attribute`.`channel_ids` = :param_53277ac553b84f1d965b0831e229841b OR `rhiem_ar_attribute`.`channel_ids` <=> :param_4756d799fa2e420e831e78c6fb6c6716 OR `rhiem_ar_attribute`.`channel_ids` LIKE :param_e193c4ab51c64562bb2a9463aebdcde1) AND `rhiem_ar_attribute`.`group_id` IN (:param_7c7d0c5be2dc4ddcbf8b3567f5a3b433)) 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.label`,
COALESCE(
`rhiem_ar_attribute.translation.label`,
`rhiem_ar_attribute.translation.label`
) as `rhiem_ar_attribute.label`,
`rhiem_ar_attribute.translation.description`,
COALESCE(
`rhiem_ar_attribute.translation.description`,
`rhiem_ar_attribute.translation.description`
) as `rhiem_ar_attribute.description`,
`rhiem_ar_attribute.translation.errorMsg`,
COALESCE(
`rhiem_ar_attribute.translation.errorMsg`,
`rhiem_ar_attribute.translation.errorMsg`
) as `rhiem_ar_attribute.errorMsg`,
`rhiem_ar_attribute.translation.errorMsgMin`,
COALESCE(
`rhiem_ar_attribute.translation.errorMsgMin`,
`rhiem_ar_attribute.translation.errorMsgMin`
) as `rhiem_ar_attribute.errorMsgMin`,
`rhiem_ar_attribute.translation.errorMsgMax`,
COALESCE(
`rhiem_ar_attribute.translation.errorMsgMax`,
`rhiem_ar_attribute.translation.errorMsgMax`
) as `rhiem_ar_attribute.errorMsgMax`,
`rhiem_ar_attribute.translation.createdAt`,
`rhiem_ar_attribute.translation.updatedAt`,
`rhiem_ar_attribute.translation.rhiemArAttributeId`,
`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`
FROM
`rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation`
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_49df434ce87245fb8c1e91333b4643f6
AND (
`rhiem_ar_attribute`.`channel_ids` = : param_53277ac553b84f1d965b0831e229841b
OR `rhiem_ar_attribute`.`channel_ids` <=> : param_4756d799fa2e420e831e78c6fb6c6716
OR `rhiem_ar_attribute`.`channel_ids` LIKE : param_e193c4ab51c64562bb2a9463aebdcde1
)
AND `rhiem_ar_attribute`.`group_id` IN (
: param_7c7d0c5be2dc4ddcbf8b3567f5a3b433
)
)
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.label`, COALESCE(`rhiem_ar_attribute.translation.label`,`rhiem_ar_attribute.translation.label`) as `rhiem_ar_attribute.label`, `rhiem_ar_attribute.translation.description`, COALESCE(`rhiem_ar_attribute.translation.description`,`rhiem_ar_attribute.translation.description`) as `rhiem_ar_attribute.description`, `rhiem_ar_attribute.translation.errorMsg`, COALESCE(`rhiem_ar_attribute.translation.errorMsg`,`rhiem_ar_attribute.translation.errorMsg`) as `rhiem_ar_attribute.errorMsg`, `rhiem_ar_attribute.translation.errorMsgMin`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMin`,`rhiem_ar_attribute.translation.errorMsgMin`) as `rhiem_ar_attribute.errorMsgMin`, `rhiem_ar_attribute.translation.errorMsgMax`, COALESCE(`rhiem_ar_attribute.translation.errorMsgMax`,`rhiem_ar_attribute.translation.errorMsgMax`) as `rhiem_ar_attribute.errorMsgMax`, `rhiem_ar_attribute.translation.createdAt`, `rhiem_ar_attribute.translation.updatedAt`, `rhiem_ar_attribute.translation.rhiemArAttributeId`, `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` FROM `rhiem_ar_attribute_translation` `rhiem_ar_attribute.translation` 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 '%fea4c70d25004476ba9deb2dd3a1d1b6%') AND `rhiem_ar_attribute`.`group_id` IN (0xA492A821AD7F48469C223DD56C4EBA65)) ORDER BY `rhiem_ar_attribute`.`position` ASC;
array:35 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 468)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 409)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1153)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 138)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 58)"
13 => "RhiemExtendedRegistration\Components\Services\RegistrationGroupService::getRegistrationGroups (line 55)"
14 => "RhiemExtendedRegistration\Subscriber\Frontend\GroupsToPage::onStorefrontRenderEvent (line 117)"
15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
16 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
17 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
18 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 60)"
23 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
24 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
0.31 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.label`, COALESCE(`rhiem_ar_so.translation.label`,`rhiem_ar_so.translation.label`) as `rhiem_ar_so.label`, `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation.rhiemArSoId`, `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` FROM `rhiem_ar_so_translation` `rhiem_ar_so.translation` 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_ffba03305aef4243bfafef825b9978a7)) 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.label`, COALESCE(`rhiem_ar_so.translation.label`,`rhiem_ar_so.translation.label`) as `rhiem_ar_so.label`, `rhiem_ar_so.translation.createdAt`, `rhiem_ar_so.translation.updatedAt`, `rhiem_ar_so.translation.rhiemArSoId`, `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` FROM `rhiem_ar_so_translation` `rhiem_ar_so.translation` 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 (0x14F8725DFBEC42949B1047681DE0E461, 0x563147EEA2D14F64B05723BBC9A25DBF, 0x756CA558C9714E1D8701002717743437)) ORDER BY `rhiem_ar_so`.`position` ASC;
array:39 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 468)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 409)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1153)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 138)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 468)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToManyWithoutPagination (line 409)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::loadOneToMany (line 1153)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetchAssociations (line 138)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
13 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
14 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 269)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
16 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 58)"
17 => "RhiemExtendedRegistration\Components\Services\RegistrationGroupService::getRegistrationGroups (line 55)"
18 => "RhiemExtendedRegistration\Subscriber\Frontend\GroupsToPage::onStorefrontRenderEvent (line 117)"
19 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
20 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
21 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
22 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
23 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
24 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
25 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
26 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 60)"
27 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
28 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
29 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
30 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
31 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
32 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
33 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
34 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
37 => "Shopware\Core\HttpKernel::doHandle (line 79)"
38 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|
2.48 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 ('/navigation/99beba32c0ad4ada9d807d7ba8b88dff', '/navigation/a01eab718e6343a6a01ab59fb33a27ac', '/navigation/f8de33efc89d4b5a88d8085eb9571a5c', '/navigation/24c6ef2f59ee458eac10d25658655bad', '/navigation/2bddb5aefbd8409d9f41d74102904f60', '/navigation/359e426345d34ffb92d77765931098fb', '/navigation/396e900b22b24c79bc1bebba7f3f4ed3', '/navigation/52730dd99b9347e99a6848e559b7c635', '/navigation/58ab7deb031e4065b08cc00d845f5321', '/navigation/6ea5e8f8aa8642c3bd37030ef45fae13', '/navigation/762d8e1b5f584e03b132ec1112d57dda', '/navigation/7b11ad59d1344f239d5a4a92e058b86b', '/navigation/fbeced1401bf4b3abd24591867959f19', '/navigation/ba98b256335946ee90ec78f8e1e01628', '/navigation/827abeb4b0f44b27aed20b08a8f420aa', '/navigation/a6ce4bc1b28d4c42bbf16e1d0ce5e530', '/navigation/a84e81a4ccb84c3287153c55cf9a3dc5', '/navigation/af3fd3adfaa54a7583f9de6b9a5416cd', '/navigation/b0914b2592404b36aa466ecabfc012f7', '/navigation/a695295fbe9a4b1f9db34086af53249f', '/navigation/eb9468dc0b874ff7a300d972eac3daba', '/navigation/fec86105cac243cf9b90dcc75a5ece26', '/navigation/ad6be72b39e24d3bbbdd5e56411c9855', '/note/c22f0e9263674e99842dd700d7571128', '/navigation/d1ca5568bbda4a10b308e0f5fd4c442d', '/navigation/9e602bba2fc14b2b8dd34daac075f0bf', '/navigation/d34721148943423da18b7b0a8f16a8af', '/navigation/2a6aeda856084c0a9f2b432697d61293', '/navigation/5d0bfc9e979340dc94afb02b29406173', '/navigation/2595b77e92cd4225814e6696307f639a', '/navigation/25e0fb8abe29487d80d8a2302bde7cb2')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0xFEA4C70D25004476BA9DEB2DD3A1D1B6 OR seo_url.sales_channel_id IS NULL) AND (is_deleted = 0) ORDER BY seo_url.sales_channel_id ASC;
array:19 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 101)"
3 => "Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler::createSeoMapping (line 57)"
4 => "Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler::Shopware\Core\Content\Seo\{closure} (line 57)"
5 => "Shopware\Core\Profiling\Profiler::trace (line 68)"
6 => "Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler::replace (line 88)"
7 => "Shopware\Storefront\Controller\StorefrontController::renderStorefront (line 121)"
8 => "CoeWishlistSw6\Storefront\Controller\WishlistController::index (line 153)"
9 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
10 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
11 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
12 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
13 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 452)"
14 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::fetch (line 346)"
15 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::lookup (line 224)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
17 => "Shopware\Core\HttpKernel::doHandle (line 79)"
18 => "Shopware\Core\HttpKernel::handle (line 78)"
]
|