Symfony Profiler

https://www.sanetta-dev.kunden.loewenstark.de/api/_action/paypal/webhook/execute?sw-token=ss9vfzW5LfFnX0VLCKhUmCVxyV8VW7hq

Method: POST
HTTP Status: 400
IP: 173.0.81.65
Profiled on: Sun, 24 Nov 2024 16:56:47 +0000
Token: c0ad83

Last 10 Latest Search

Settings

Query Metrics

8 Database Queries

Different statements

2.98 ms Query time

Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.03 ms (0.00%)		SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL View formatted query View runnable query View query stack 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 377)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)" 3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 197)" 4 => "Shopware\Core\Kernel::boot (line 129)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 69)"`]
0.06 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_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1636033286_IS_ACTIVE = TRUE;SET @MIGRATION_1636033286_IS_ACTIVE = TRUE;SET @MIGRATION_1639738614_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;SET @MIGRATION_1625566312_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1624345671_IS_ACTIVE = TRUE;SET @MIGRATION_1637746246_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1598258819_IS_ACTIVE = TRUE;SET @MIGRATION_1601633334_IS_ACTIVE = TRUE;SET @MIGRATION_160198215_IS_ACTIVE = TRUE;SET @MIGRATION_1634025013_IS_ACTIVE = TRUE;SET @MIGRATION_1663601206_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1610539344_IS_ACTIVE = TRUE;SET @MIGRATION_1644729219_IS_ACTIVE = TRUE;SET @MIGRATION_1665413137_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1600180419_IS_ACTIVE = TRUE;SET @MIGRATION_1605561698_IS_ACTIVE = TRUE;SET @MIGRATION_1607420606_IS_ACTIVE = TRUE;SET @MIGRATION_1607594410_IS_ACTIVE = TRUE;SET @MIGRATION_1610545372_IS_ACTIVE = TRUE;SET @MIGRATION_1610546810_IS_ACTIVE = TRUE;SET @MIGRATION_1612348251_IS_ACTIVE = TRUE;SET @MIGRATION_1612349225_IS_ACTIVE = TRUE;SET @MIGRATION_1618477128_IS_ACTIVE = TRUE;SET @MIGRATION_1618908395_IS_ACTIVE = TRUE;SET @MIGRATION_1622727012_IS_ACTIVE = TRUE;SET @MIGRATION_1627480654_IS_ACTIVE = TRUE;SET @MIGRATION_1635833269_IS_ACTIVE = TRUE;SET @MIGRATION_1635933836_IS_ACTIVE = TRUE;SET @MIGRATION_1641807793_IS_ACTIVE = TRUE;SET @MIGRATION_1642672309_IS_ACTIVE = TRUE;SET @MIGRATION_1642677128_IS_ACTIVE = TRUE;SET @MIGRATION_1643793251_IS_ACTIVE = TRUE;SET @MIGRATION_1643882897_IS_ACTIVE = TRUE;SET @MIGRATION_1643967311_IS_ACTIVE = TRUE;SET @MIGRATION_1643978336_IS_ACTIVE = TRUE;SET @MIGRATION_1644390343_IS_ACTIVE = TRUE;SET @MIGRATION_1644417146_IS_ACTIVE = TRUE;SET @MIGRATION_1649838631_IS_ACTIVE = TRUE;SET @MIGRATION_1650617469_IS_ACTIVE = TRUE;SET @MIGRATION_1652793319_IS_ACTIVE = TRUE;SET @MIGRATION_1655122661_IS_ACTIVE = TRUE;SET @MIGRATION_1655820818_IS_ACTIVE = TRUE;SET @MIGRATION_1657109285_IS_ACTIVE = TRUE;SET @MIGRATION_1657551682_IS_ACTIVE = TRUE;SET @MIGRATION_1657696369_IS_ACTIVE = TRUE;SET @MIGRATION_1657894788_IS_ACTIVE = TRUE;SET @MIGRATION_1658137202_IS_ACTIVE = TRUE;SET @MIGRATION_1667808695_IS_ACTIVE = TRUE;SET @MIGRATION_1668686939_IS_ACTIVE = TRUE;SET @MIGRATION_1669286069_IS_ACTIVE = TRUE;SET @MIGRATION_1669813114_IS_ACTIVE = TRUE;SET @MIGRATION_1670257605_IS_ACTIVE = TRUE;SET @MIGRATION_1672933403_IS_ACTIVE = TRUE;SET @MIGRATION_1674131867_IS_ACTIVE = TRUE;SET @MIGRATION_1674817916_IS_ACTIVE = TRUE;SET @MIGRATION_1675187844_IS_ACTIVE = TRUE;SET @MIGRATION_1676380827_IS_ACTIVE = TRUE;SET @MIGRATION_1678888534_IS_ACTIVE = TRUE;SET @MIGRATION_1680679403_IS_ACTIVE = TRUE;SET @MIGRATION_1681477256_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1635807588_IS_ACTIVE = TRUE;SET @MIGRATION_1647868754_IS_ACTIVE = TRUE;SET @MIGRATION_1651153687_IS_ACTIVE = TRUE;SET @MIGRATION_1565395385_IS_ACTIVE = TRUE;SET @MIGRATION_1604593154_IS_ACTIVE = TRUE;SET @MIGRATION_1604593155_IS_ACTIVE = TRUE;SET @MIGRATION_1644661330_IS_ACTIVE = TRUE;SET @MIGRATION_1645888733_IS_ACTIVE = TRUE View formatted query View runnable query View query stack 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_1617896006_IS_ACTIVE = TRUE; SET @MIGRATION_1618389817_IS_ACTIVE = TRUE; SET @MIGRATION_1620146632_IS_ACTIVE = TRUE; SET @MIGRATION_1620147234_IS_ACTIVE = TRUE; SET @MIGRATION_1620215586_IS_ACTIVE = TRUE; SET @MIGRATION_1620374229_IS_ACTIVE = TRUE; SET @MIGRATION_1620376945_IS_ACTIVE = TRUE; SET @MIGRATION_1620733405_IS_ACTIVE = TRUE; SET @MIGRATION_1620733405_IS_ACTIVE = TRUE; SET @MIGRATION_1621845357_IS_ACTIVE = TRUE; SET @MIGRATION_1621845370_IS_ACTIVE = TRUE; SET @MIGRATION_1622010069_IS_ACTIVE = TRUE; SET @MIGRATION_1622104463_IS_ACTIVE = TRUE; SET @MIGRATION_1622782058_IS_ACTIVE = TRUE; SET @MIGRATION_1623305620_IS_ACTIVE = TRUE; SET @MIGRATION_1623391399_IS_ACTIVE = TRUE; SET @MIGRATION_1623828962_IS_ACTIVE = TRUE; SET @MIGRATION_1624262862_IS_ACTIVE = TRUE; SET @MIGRATION_1624884801_IS_ACTIVE = TRUE; SET @MIGRATION_1624967118_IS_ACTIVE = TRUE; SET @MIGRATION_1625304609_IS_ACTIVE = TRUE; SET @MIGRATION_1625465756_IS_ACTIVE = TRUE; SET @MIGRATION_1625505190_IS_ACTIVE = TRUE; SET @MIGRATION_1625554302_IS_ACTIVE = TRUE; SET @MIGRATION_1625569667_IS_ACTIVE = TRUE; SET @MIGRATION_1625583596_IS_ACTIVE = TRUE; SET @MIGRATION_1625583619_IS_ACTIVE = TRUE; SET @MIGRATION_1625816310_IS_ACTIVE = TRUE; SET @MIGRATION_1625819412_IS_ACTIVE = TRUE; SET @MIGRATION_1625831469_IS_ACTIVE = TRUE; SET @MIGRATION_1626241110_IS_ACTIVE = TRUE; SET @MIGRATION_1626442868_IS_ACTIVE = TRUE; SET @MIGRATION_1626696809_IS_ACTIVE = TRUE; SET @MIGRATION_1626785125_IS_ACTIVE = TRUE; SET @MIGRATION_1627292049_IS_ACTIVE = TRUE; SET @MIGRATION_1627540693_IS_ACTIVE = TRUE; SET @MIGRATION_1627541488_IS_ACTIVE = TRUE; SET @MIGRATION_1627562945_IS_ACTIVE = TRUE; SET @MIGRATION_1627650101_IS_ACTIVE = TRUE; SET @MIGRATION_1627929168_IS_ACTIVE = TRUE; SET @MIGRATION_1627983652_IS_ACTIVE = TRUE; SET @MIGRATION_1628519513_IS_ACTIVE = TRUE; SET @MIGRATION_1628749113_IS_ACTIVE = TRUE; SET @MIGRATION_1629204538_IS_ACTIVE = TRUE; SET @MIGRATION_1629700169_IS_ACTIVE = TRUE; SET @MIGRATION_1629877210_IS_ACTIVE = TRUE; SET @MIGRATION_1630074081_IS_ACTIVE = TRUE; SET @MIGRATION_1630485317_IS_ACTIVE = TRUE; SET @MIGRATION_1631625055_IS_ACTIVE = TRUE; SET @MIGRATION_1631703921_IS_ACTIVE = TRUE; SET @MIGRATION_1631790054_IS_ACTIVE = TRUE; SET @MIGRATION_1631863869_IS_ACTIVE = TRUE; SET @MIGRATION_1632111590_IS_ACTIVE = TRUE; SET @MIGRATION_1632215760_IS_ACTIVE = TRUE; SET @MIGRATION_1632721037_IS_ACTIVE = TRUE; SET @MIGRATION_1633347511_IS_ACTIVE = TRUE; SET @MIGRATION_1633358879_IS_ACTIVE = TRUE; SET @MIGRATION_1633422057_IS_ACTIVE = TRUE; SET @MIGRATION_1634735841_IS_ACTIVE = TRUE; SET @MIGRATION_1635147952_IS_ACTIVE = TRUE; SET @MIGRATION_1635230747_IS_ACTIVE = TRUE; SET @MIGRATION_1635237551_IS_ACTIVE = TRUE; SET @MIGRATION_1635388654_IS_ACTIVE = TRUE; SET @MIGRATION_1635936029_IS_ACTIVE = TRUE; SET @MIGRATION_1636014089_IS_ACTIVE = TRUE; SET @MIGRATION_1636018970_IS_ACTIVE = TRUE; SET @MIGRATION_1636362839_IS_ACTIVE = TRUE; SET @MIGRATION_1636449347_IS_ACTIVE = TRUE; SET @MIGRATION_1636964297_IS_ACTIVE = TRUE; SET @MIGRATION_1636971615_IS_ACTIVE = TRUE; SET @MIGRATION_1638195971_IS_ACTIVE = TRUE; SET @MIGRATION_1638365464_IS_ACTIVE = TRUE; SET @MIGRATION_1638514913_IS_ACTIVE = TRUE; SET @MIGRATION_1638993987_IS_ACTIVE = TRUE; SET @MIGRATION_1639122665_IS_ACTIVE = TRUE; SET @MIGRATION_1639139581_IS_ACTIVE = TRUE; SET @MIGRATION_1639992771_IS_ACTIVE = TRUE; SET @MIGRATION_1641289204_IS_ACTIVE = TRUE; SET @MIGRATION_1642517958_IS_ACTIVE = TRUE; SET @MIGRATION_1642732351_IS_ACTIVE = TRUE; SET @MIGRATION_1642757286_IS_ACTIVE = TRUE; SET @MIGRATION_1643366069_IS_ACTIVE = TRUE; SET @MIGRATION_1643386819_IS_ACTIVE = TRUE; SET @MIGRATION_1643724178_IS_ACTIVE = TRUE; SET @MIGRATION_1643878976_IS_ACTIVE = TRUE; SET @MIGRATION_1643892702_IS_ACTIVE = TRUE; SET @MIGRATION_1645019769_IS_ACTIVE = TRUE; SET @MIGRATION_1645453538_IS_ACTIVE = TRUE; SET @MIGRATION_1646125417_IS_ACTIVE = TRUE; SET @MIGRATION_1646397836_IS_ACTIVE = TRUE; SET @MIGRATION_1646817331_IS_ACTIVE = TRUE; SET @MIGRATION_1647260673_IS_ACTIVE = TRUE; SET @MIGRATION_1647443222_IS_ACTIVE = TRUE; SET @MIGRATION_1647511158_IS_ACTIVE = TRUE; SET @MIGRATION_1648031611_IS_ACTIVE = TRUE; SET @MIGRATION_1648031636_IS_ACTIVE = TRUE; SET @MIGRATION_1648543185_IS_ACTIVE = TRUE; SET @MIGRATION_1648709176_IS_ACTIVE = TRUE; SET @MIGRATION_1648803451_IS_ACTIVE = TRUE; SET @MIGRATION_1649040981_IS_ACTIVE = TRUE; SET @MIGRATION_1649315608_IS_ACTIVE = TRUE; SET @MIGRATION_1649858046_IS_ACTIVE = TRUE; SET @MIGRATION_1650249241_IS_ACTIVE = TRUE; SET @MIGRATION_1650444800_IS_ACTIVE = TRUE; SET @MIGRATION_1650548599_IS_ACTIVE = TRUE; SET @MIGRATION_1650620993_IS_ACTIVE = TRUE; SET @MIGRATION_1650872291_IS_ACTIVE = TRUE; SET @MIGRATION_1650981517_IS_ACTIVE = TRUE; SET @MIGRATION_1651118773_IS_ACTIVE = TRUE; SET @MIGRATION_1652166447_IS_ACTIVE = TRUE; SET @MIGRATION_1652345915_IS_ACTIVE = TRUE; SET @MIGRATION_1652441129_IS_ACTIVE = TRUE; SET @MIGRATION_1652864153_IS_ACTIVE = TRUE; SET @MIGRATION_1653376989_IS_ACTIVE = TRUE; SET @MIGRATION_1653385302_IS_ACTIVE = TRUE; SET @MIGRATION_1654839361_IS_ACTIVE = TRUE; SET @MIGRATION_1654839361_IS_ACTIVE = TRUE; SET @MIGRATION_1654839361_IS_ACTIVE = TRUE; SET @MIGRATION_1655730949_IS_ACTIVE = TRUE; SET @MIGRATION_1656397126_IS_ACTIVE = TRUE; SET @MIGRATION_1656928097_IS_ACTIVE = TRUE; SET @MIGRATION_1657011337_IS_ACTIVE = TRUE; SET @MIGRATION_1657027979_IS_ACTIVE = TRUE; SET @MIGRATION_1657173907_IS_ACTIVE = TRUE; SET @MIGRATION_1658786605_IS_ACTIVE = TRUE; SET @MIGRATION_1659256999_IS_ACTIVE = TRUE; SET @MIGRATION_1659257296_IS_ACTIVE = TRUE; SET @MIGRATION_1659257396_IS_ACTIVE = TRUE; SET @MIGRATION_1659257496_IS_ACTIVE = TRUE; SET @MIGRATION_1660814397_IS_ACTIVE = TRUE; SET @MIGRATION_1661759290_IS_ACTIVE = TRUE; SET @MIGRATION_1661771388_IS_ACTIVE = TRUE; SET @MIGRATION_1663238480_IS_ACTIVE = TRUE; SET @MIGRATION_1664512574_IS_ACTIVE = TRUE; SET @MIGRATION_1664541794_IS_ACTIVE = TRUE; SET @MIGRATION_1664894872_IS_ACTIVE = TRUE; SET @MIGRATION_1665064823_IS_ACTIVE = TRUE; SET @MIGRATION_1665267882_IS_ACTIVE = TRUE; SET @MIGRATION_1667731399_IS_ACTIVE = TRUE; SET @MIGRATION_1667806582_IS_ACTIVE = TRUE; SET @MIGRATION_1667983492_IS_ACTIVE = TRUE; SET @MIGRATION_1668677456_IS_ACTIVE = TRUE; SET @MIGRATION_1669316067_IS_ACTIVE = TRUE; SET @MIGRATION_1672164687_IS_ACTIVE = TRUE; SET @MIGRATION_1672743034_IS_ACTIVE = TRUE; SET @MIGRATION_1673001912_IS_ACTIVE = TRUE; SET @MIGRATION_1673966228_IS_ACTIVE = TRUE; SET @MIGRATION_1675218708_IS_ACTIVE = TRUE; SET @MIGRATION_1675827655_IS_ACTIVE = TRUE; SET @MIGRATION_1632281097_IS_ACTIVE = TRUE; SET @MIGRATION_1636121186_IS_ACTIVE = TRUE; SET @MIGRATION_1660813696_IS_ACTIVE = TRUE; SET @MIGRATION_1641476963_IS_ACTIVE = TRUE; SET @MIGRATION_1632281097_IS_ACTIVE = TRUE; SET @MIGRATION_1636121186_IS_ACTIVE = TRUE; SET @MIGRATION_1660813696_IS_ACTIVE = TRUE; SET @MIGRATION_1636033286_IS_ACTIVE = TRUE; SET @MIGRATION_1636033286_IS_ACTIVE = TRUE; SET @MIGRATION_1639738614_IS_ACTIVE = TRUE; SET @MIGRATION_1582718994_IS_ACTIVE = TRUE; SET @MIGRATION_1586345021_IS_ACTIVE = TRUE; SET @MIGRATION_1586345049_IS_ACTIVE = TRUE; SET @MIGRATION_1586345063_IS_ACTIVE = TRUE; SET @MIGRATION_1587126585_IS_ACTIVE = TRUE; SET @MIGRATION_1625566312_IS_ACTIVE = TRUE; SET @MIGRATION_1536765935_IS_ACTIVE = TRUE; SET @MIGRATION_1536765936_IS_ACTIVE = TRUE; SET @MIGRATION_1536765937_IS_ACTIVE = TRUE; SET @MIGRATION_1536765938_IS_ACTIVE = TRUE; SET @MIGRATION_1538046469_IS_ACTIVE = TRUE; SET @MIGRATION_1538985581_IS_ACTIVE = TRUE; SET @MIGRATION_1544535797_IS_ACTIVE = TRUE; SET @MIGRATION_1563456847_IS_ACTIVE = TRUE; SET @MIGRATION_1564041870_IS_ACTIVE = TRUE; SET @MIGRATION_1564053392_IS_ACTIVE = TRUE; SET @MIGRATION_1568882302_IS_ACTIVE = TRUE; SET @MIGRATION_1568882317_IS_ACTIVE = TRUE; SET @MIGRATION_1587476616_IS_ACTIVE = TRUE; SET @MIGRATION_1589448383_IS_ACTIVE = TRUE; SET @MIGRATION_1593494859_IS_ACTIVE = TRUE; SET @MIGRATION_1593508853_IS_ACTIVE = TRUE; SET @MIGRATION_1615794849_IS_ACTIVE = TRUE; SET @MIGRATION_1624345671_IS_ACTIVE = TRUE; SET @MIGRATION_1637746246_IS_ACTIVE = TRUE; SET @MIGRATION_1572257501_IS_ACTIVE = TRUE; SET @MIGRATION_1606378923_IS_ACTIVE = TRUE; SET @MIGRATION_1607952506_IS_ACTIVE = TRUE; SET @MIGRATION_1608034991_IS_ACTIVE = TRUE; SET @MIGRATION_1612945522_IS_ACTIVE = TRUE; SET @MIGRATION_1620808652_IS_ACTIVE = TRUE; SET @MIGRATION_1631192197_IS_ACTIVE = TRUE; SET @MIGRATION_1598258819_IS_ACTIVE = TRUE; SET @MIGRATION_1601633334_IS_ACTIVE = TRUE; SET @MIGRATION_160198215_IS_ACTIVE = TRUE; SET @MIGRATION_1634025013_IS_ACTIVE = TRUE; SET @MIGRATION_1663601206_IS_ACTIVE = TRUE; SET @MIGRATION_1574344300_IS_ACTIVE = TRUE; SET @MIGRATION_1584005462_IS_ACTIVE = TRUE; SET @MIGRATION_1589800641_IS_ACTIVE = TRUE; SET @MIGRATION_1589800704_IS_ACTIVE = TRUE; SET @MIGRATION_1589882802_IS_ACTIVE = TRUE; SET @MIGRATION_1589905764_IS_ACTIVE = TRUE; SET @MIGRATION_1591365484_IS_ACTIVE = TRUE; SET @MIGRATION_1626082072_IS_ACTIVE = TRUE; SET @MIGRATION_1610539344_IS_ACTIVE = TRUE; SET @MIGRATION_1644729219_IS_ACTIVE = TRUE; SET @MIGRATION_1665413137_IS_ACTIVE = TRUE; SET @MIGRATION_1603810036_IS_ACTIVE = TRUE; SET @MIGRATION_1607423732_IS_ACTIVE = TRUE; SET @MIGRATION_1603810036_IS_ACTIVE = TRUE; SET @MIGRATION_1616412445_IS_ACTIVE = TRUE; SET @MIGRATION_1616413078_IS_ACTIVE = TRUE; SET @MIGRATION_1622039002_IS_ACTIVE = TRUE; SET @MIGRATION_1629280389_IS_ACTIVE = TRUE; SET @MIGRATION_1642507826_IS_ACTIVE = TRUE; SET @MIGRATION_1644753635_IS_ACTIVE = TRUE; SET @MIGRATION_1652444730_IS_ACTIVE = TRUE; SET @MIGRATION_1669117848_IS_ACTIVE = TRUE; SET @MIGRATION_1669796049_IS_ACTIVE = TRUE; SET @MIGRATION_1600180419_IS_ACTIVE = TRUE; SET @MIGRATION_1605561698_IS_ACTIVE = TRUE; SET @MIGRATION_1607420606_IS_ACTIVE = TRUE; SET @MIGRATION_1607594410_IS_ACTIVE = TRUE; SET @MIGRATION_1610545372_IS_ACTIVE = TRUE; SET @MIGRATION_1610546810_IS_ACTIVE = TRUE; SET @MIGRATION_1612348251_IS_ACTIVE = TRUE; SET @MIGRATION_1612349225_IS_ACTIVE = TRUE; SET @MIGRATION_1618477128_IS_ACTIVE = TRUE; SET @MIGRATION_1618908395_IS_ACTIVE = TRUE; SET @MIGRATION_1622727012_IS_ACTIVE = TRUE; SET @MIGRATION_1627480654_IS_ACTIVE = TRUE; SET @MIGRATION_1635833269_IS_ACTIVE = TRUE; SET @MIGRATION_1635933836_IS_ACTIVE = TRUE; SET @MIGRATION_1641807793_IS_ACTIVE = TRUE; SET @MIGRATION_1642672309_IS_ACTIVE = TRUE; SET @MIGRATION_1642677128_IS_ACTIVE = TRUE; SET @MIGRATION_1643793251_IS_ACTIVE = TRUE; SET @MIGRATION_1643882897_IS_ACTIVE = TRUE; SET @MIGRATION_1643967311_IS_ACTIVE = TRUE; SET @MIGRATION_1643978336_IS_ACTIVE = TRUE; SET @MIGRATION_1644390343_IS_ACTIVE = TRUE; SET @MIGRATION_1644417146_IS_ACTIVE = TRUE; SET @MIGRATION_1649838631_IS_ACTIVE = TRUE; SET @MIGRATION_1650617469_IS_ACTIVE = TRUE; SET @MIGRATION_1652793319_IS_ACTIVE = TRUE; SET @MIGRATION_1655122661_IS_ACTIVE = TRUE; SET @MIGRATION_1655820818_IS_ACTIVE = TRUE; SET @MIGRATION_1657109285_IS_ACTIVE = TRUE; SET @MIGRATION_1657551682_IS_ACTIVE = TRUE; SET @MIGRATION_1657696369_IS_ACTIVE = TRUE; SET @MIGRATION_1657894788_IS_ACTIVE = TRUE; SET @MIGRATION_1658137202_IS_ACTIVE = TRUE; SET @MIGRATION_1667808695_IS_ACTIVE = TRUE; SET @MIGRATION_1668686939_IS_ACTIVE = TRUE; SET @MIGRATION_1669286069_IS_ACTIVE = TRUE; SET @MIGRATION_1669813114_IS_ACTIVE = TRUE; SET @MIGRATION_1670257605_IS_ACTIVE = TRUE; SET @MIGRATION_1672933403_IS_ACTIVE = TRUE; SET @MIGRATION_1674131867_IS_ACTIVE = TRUE; SET @MIGRATION_1674817916_IS_ACTIVE = TRUE; SET @MIGRATION_1675187844_IS_ACTIVE = TRUE; SET @MIGRATION_1676380827_IS_ACTIVE = TRUE; SET @MIGRATION_1678888534_IS_ACTIVE = TRUE; SET @MIGRATION_1680679403_IS_ACTIVE = TRUE; SET @MIGRATION_1681477256_IS_ACTIVE = TRUE; SET @MIGRATION_1628172267_IS_ACTIVE = TRUE; SET @MIGRATION_1644922949_IS_ACTIVE = TRUE; SET @MIGRATION_1616141231_IS_ACTIVE = TRUE; SET @MIGRATION_1631631689_IS_ACTIVE = TRUE; SET @MIGRATION_1636082647_IS_ACTIVE = TRUE; SET @MIGRATION_1662306139_IS_ACTIVE = TRUE; SET @MIGRATION_1662757955_IS_ACTIVE = TRUE; SET @MIGRATION_1663039410_IS_ACTIVE = TRUE; SET @MIGRATION_1676830357_IS_ACTIVE = TRUE; SET @MIGRATION_1616141231_IS_ACTIVE = TRUE; SET @MIGRATION_1635807588_IS_ACTIVE = TRUE; SET @MIGRATION_1647868754_IS_ACTIVE = TRUE; SET @MIGRATION_1651153687_IS_ACTIVE = TRUE; SET @MIGRATION_1565395385_IS_ACTIVE = TRUE; SET @MIGRATION_1604593154_IS_ACTIVE = TRUE; SET @MIGRATION_1604593155_IS_ACTIVE = TRUE; SET @MIGRATION_1644661330_IS_ACTIVE = TRUE; SET @MIGRATION_1645888733_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_1617896006_IS_ACTIVE = TRUE;SET @MIGRATION_1618389817_IS_ACTIVE = TRUE;SET @MIGRATION_1620146632_IS_ACTIVE = TRUE;SET @MIGRATION_1620147234_IS_ACTIVE = TRUE;SET @MIGRATION_1620215586_IS_ACTIVE = TRUE;SET @MIGRATION_1620374229_IS_ACTIVE = TRUE;SET @MIGRATION_1620376945_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1620733405_IS_ACTIVE = TRUE;SET @MIGRATION_1621845357_IS_ACTIVE = TRUE;SET @MIGRATION_1621845370_IS_ACTIVE = TRUE;SET @MIGRATION_1622010069_IS_ACTIVE = TRUE;SET @MIGRATION_1622104463_IS_ACTIVE = TRUE;SET @MIGRATION_1622782058_IS_ACTIVE = TRUE;SET @MIGRATION_1623305620_IS_ACTIVE = TRUE;SET @MIGRATION_1623391399_IS_ACTIVE = TRUE;SET @MIGRATION_1623828962_IS_ACTIVE = TRUE;SET @MIGRATION_1624262862_IS_ACTIVE = TRUE;SET @MIGRATION_1624884801_IS_ACTIVE = TRUE;SET @MIGRATION_1624967118_IS_ACTIVE = TRUE;SET @MIGRATION_1625304609_IS_ACTIVE = TRUE;SET @MIGRATION_1625465756_IS_ACTIVE = TRUE;SET @MIGRATION_1625505190_IS_ACTIVE = TRUE;SET @MIGRATION_1625554302_IS_ACTIVE = TRUE;SET @MIGRATION_1625569667_IS_ACTIVE = TRUE;SET @MIGRATION_1625583596_IS_ACTIVE = TRUE;SET @MIGRATION_1625583619_IS_ACTIVE = TRUE;SET @MIGRATION_1625816310_IS_ACTIVE = TRUE;SET @MIGRATION_1625819412_IS_ACTIVE = TRUE;SET @MIGRATION_1625831469_IS_ACTIVE = TRUE;SET @MIGRATION_1626241110_IS_ACTIVE = TRUE;SET @MIGRATION_1626442868_IS_ACTIVE = TRUE;SET @MIGRATION_1626696809_IS_ACTIVE = TRUE;SET @MIGRATION_1626785125_IS_ACTIVE = TRUE;SET @MIGRATION_1627292049_IS_ACTIVE = TRUE;SET @MIGRATION_1627540693_IS_ACTIVE = TRUE;SET @MIGRATION_1627541488_IS_ACTIVE = TRUE;SET @MIGRATION_1627562945_IS_ACTIVE = TRUE;SET @MIGRATION_1627650101_IS_ACTIVE = TRUE;SET @MIGRATION_1627929168_IS_ACTIVE = TRUE;SET @MIGRATION_1627983652_IS_ACTIVE = TRUE;SET @MIGRATION_1628519513_IS_ACTIVE = TRUE;SET @MIGRATION_1628749113_IS_ACTIVE = TRUE;SET @MIGRATION_1629204538_IS_ACTIVE = TRUE;SET @MIGRATION_1629700169_IS_ACTIVE = TRUE;SET @MIGRATION_1629877210_IS_ACTIVE = TRUE;SET @MIGRATION_1630074081_IS_ACTIVE = TRUE;SET @MIGRATION_1630485317_IS_ACTIVE = TRUE;SET @MIGRATION_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1631863869_IS_ACTIVE = TRUE;SET @MIGRATION_1632111590_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636964297_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1638195971_IS_ACTIVE = TRUE;SET @MIGRATION_1638365464_IS_ACTIVE = TRUE;SET @MIGRATION_1638514913_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1639139581_IS_ACTIVE = TRUE;SET @MIGRATION_1639992771_IS_ACTIVE = TRUE;SET @MIGRATION_1641289204_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643366069_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1649858046_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650620993_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1651118773_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1654839361_IS_ACTIVE = TRUE;SET @MIGRATION_1655730949_IS_ACTIVE = TRUE;SET @MIGRATION_1656397126_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_1657027979_IS_ACTIVE = TRUE;SET @MIGRATION_1657173907_IS_ACTIVE = TRUE;SET @MIGRATION_1658786605_IS_ACTIVE = TRUE;SET @MIGRATION_1659256999_IS_ACTIVE = TRUE;SET @MIGRATION_1659257296_IS_ACTIVE = TRUE;SET @MIGRATION_1659257396_IS_ACTIVE = TRUE;SET @MIGRATION_1659257496_IS_ACTIVE = TRUE;SET @MIGRATION_1660814397_IS_ACTIVE = TRUE;SET @MIGRATION_1661759290_IS_ACTIVE = TRUE;SET @MIGRATION_1661771388_IS_ACTIVE = TRUE;SET @MIGRATION_1663238480_IS_ACTIVE = TRUE;SET @MIGRATION_1664512574_IS_ACTIVE = TRUE;SET @MIGRATION_1664541794_IS_ACTIVE = TRUE;SET @MIGRATION_1664894872_IS_ACTIVE = TRUE;SET @MIGRATION_1665064823_IS_ACTIVE = TRUE;SET @MIGRATION_1665267882_IS_ACTIVE = TRUE;SET @MIGRATION_1667731399_IS_ACTIVE = TRUE;SET @MIGRATION_1667806582_IS_ACTIVE = TRUE;SET @MIGRATION_1667983492_IS_ACTIVE = TRUE;SET @MIGRATION_1668677456_IS_ACTIVE = TRUE;SET @MIGRATION_1669316067_IS_ACTIVE = TRUE;SET @MIGRATION_1672164687_IS_ACTIVE = TRUE;SET @MIGRATION_1672743034_IS_ACTIVE = TRUE;SET @MIGRATION_1673001912_IS_ACTIVE = TRUE;SET @MIGRATION_1673966228_IS_ACTIVE = TRUE;SET @MIGRATION_1675218708_IS_ACTIVE = TRUE;SET @MIGRATION_1675827655_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1632281097_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1660813696_IS_ACTIVE = TRUE;SET @MIGRATION_1636033286_IS_ACTIVE = TRUE;SET @MIGRATION_1636033286_IS_ACTIVE = TRUE;SET @MIGRATION_1639738614_IS_ACTIVE = TRUE;SET @MIGRATION_1582718994_IS_ACTIVE = TRUE;SET @MIGRATION_1586345021_IS_ACTIVE = TRUE;SET @MIGRATION_1586345049_IS_ACTIVE = TRUE;SET @MIGRATION_1586345063_IS_ACTIVE = TRUE;SET @MIGRATION_1587126585_IS_ACTIVE = TRUE;SET @MIGRATION_1625566312_IS_ACTIVE = TRUE;SET @MIGRATION_1536765935_IS_ACTIVE = TRUE;SET @MIGRATION_1536765936_IS_ACTIVE = TRUE;SET @MIGRATION_1536765937_IS_ACTIVE = TRUE;SET @MIGRATION_1536765938_IS_ACTIVE = TRUE;SET @MIGRATION_1538046469_IS_ACTIVE = TRUE;SET @MIGRATION_1538985581_IS_ACTIVE = TRUE;SET @MIGRATION_1544535797_IS_ACTIVE = TRUE;SET @MIGRATION_1563456847_IS_ACTIVE = TRUE;SET @MIGRATION_1564041870_IS_ACTIVE = TRUE;SET @MIGRATION_1564053392_IS_ACTIVE = TRUE;SET @MIGRATION_1568882302_IS_ACTIVE = TRUE;SET @MIGRATION_1568882317_IS_ACTIVE = TRUE;SET @MIGRATION_1587476616_IS_ACTIVE = TRUE;SET @MIGRATION_1589448383_IS_ACTIVE = TRUE;SET @MIGRATION_1593494859_IS_ACTIVE = TRUE;SET @MIGRATION_1593508853_IS_ACTIVE = TRUE;SET @MIGRATION_1615794849_IS_ACTIVE = TRUE;SET @MIGRATION_1624345671_IS_ACTIVE = TRUE;SET @MIGRATION_1637746246_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1606378923_IS_ACTIVE = TRUE;SET @MIGRATION_1607952506_IS_ACTIVE = TRUE;SET @MIGRATION_1608034991_IS_ACTIVE = TRUE;SET @MIGRATION_1612945522_IS_ACTIVE = TRUE;SET @MIGRATION_1620808652_IS_ACTIVE = TRUE;SET @MIGRATION_1631192197_IS_ACTIVE = TRUE;SET @MIGRATION_1598258819_IS_ACTIVE = TRUE;SET @MIGRATION_1601633334_IS_ACTIVE = TRUE;SET @MIGRATION_160198215_IS_ACTIVE = TRUE;SET @MIGRATION_1634025013_IS_ACTIVE = TRUE;SET @MIGRATION_1663601206_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1610539344_IS_ACTIVE = TRUE;SET @MIGRATION_1644729219_IS_ACTIVE = TRUE;SET @MIGRATION_1665413137_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1607423732_IS_ACTIVE = TRUE;SET @MIGRATION_1603810036_IS_ACTIVE = TRUE;SET @MIGRATION_1616412445_IS_ACTIVE = TRUE;SET @MIGRATION_1616413078_IS_ACTIVE = TRUE;SET @MIGRATION_1622039002_IS_ACTIVE = TRUE;SET @MIGRATION_1629280389_IS_ACTIVE = TRUE;SET @MIGRATION_1642507826_IS_ACTIVE = TRUE;SET @MIGRATION_1644753635_IS_ACTIVE = TRUE;SET @MIGRATION_1652444730_IS_ACTIVE = TRUE;SET @MIGRATION_1669117848_IS_ACTIVE = TRUE;SET @MIGRATION_1669796049_IS_ACTIVE = TRUE;SET @MIGRATION_1600180419_IS_ACTIVE = TRUE;SET @MIGRATION_1605561698_IS_ACTIVE = TRUE;SET @MIGRATION_1607420606_IS_ACTIVE = TRUE;SET @MIGRATION_1607594410_IS_ACTIVE = TRUE;SET @MIGRATION_1610545372_IS_ACTIVE = TRUE;SET @MIGRATION_1610546810_IS_ACTIVE = TRUE;SET @MIGRATION_1612348251_IS_ACTIVE = TRUE;SET @MIGRATION_1612349225_IS_ACTIVE = TRUE;SET @MIGRATION_1618477128_IS_ACTIVE = TRUE;SET @MIGRATION_1618908395_IS_ACTIVE = TRUE;SET @MIGRATION_1622727012_IS_ACTIVE = TRUE;SET @MIGRATION_1627480654_IS_ACTIVE = TRUE;SET @MIGRATION_1635833269_IS_ACTIVE = TRUE;SET @MIGRATION_1635933836_IS_ACTIVE = TRUE;SET @MIGRATION_1641807793_IS_ACTIVE = TRUE;SET @MIGRATION_1642672309_IS_ACTIVE = TRUE;SET @MIGRATION_1642677128_IS_ACTIVE = TRUE;SET @MIGRATION_1643793251_IS_ACTIVE = TRUE;SET @MIGRATION_1643882897_IS_ACTIVE = TRUE;SET @MIGRATION_1643967311_IS_ACTIVE = TRUE;SET @MIGRATION_1643978336_IS_ACTIVE = TRUE;SET @MIGRATION_1644390343_IS_ACTIVE = TRUE;SET @MIGRATION_1644417146_IS_ACTIVE = TRUE;SET @MIGRATION_1649838631_IS_ACTIVE = TRUE;SET @MIGRATION_1650617469_IS_ACTIVE = TRUE;SET @MIGRATION_1652793319_IS_ACTIVE = TRUE;SET @MIGRATION_1655122661_IS_ACTIVE = TRUE;SET @MIGRATION_1655820818_IS_ACTIVE = TRUE;SET @MIGRATION_1657109285_IS_ACTIVE = TRUE;SET @MIGRATION_1657551682_IS_ACTIVE = TRUE;SET @MIGRATION_1657696369_IS_ACTIVE = TRUE;SET @MIGRATION_1657894788_IS_ACTIVE = TRUE;SET @MIGRATION_1658137202_IS_ACTIVE = TRUE;SET @MIGRATION_1667808695_IS_ACTIVE = TRUE;SET @MIGRATION_1668686939_IS_ACTIVE = TRUE;SET @MIGRATION_1669286069_IS_ACTIVE = TRUE;SET @MIGRATION_1669813114_IS_ACTIVE = TRUE;SET @MIGRATION_1670257605_IS_ACTIVE = TRUE;SET @MIGRATION_1672933403_IS_ACTIVE = TRUE;SET @MIGRATION_1674131867_IS_ACTIVE = TRUE;SET @MIGRATION_1674817916_IS_ACTIVE = TRUE;SET @MIGRATION_1675187844_IS_ACTIVE = TRUE;SET @MIGRATION_1676380827_IS_ACTIVE = TRUE;SET @MIGRATION_1678888534_IS_ACTIVE = TRUE;SET @MIGRATION_1680679403_IS_ACTIVE = TRUE;SET @MIGRATION_1681477256_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1631631689_IS_ACTIVE = TRUE;SET @MIGRATION_1636082647_IS_ACTIVE = TRUE;SET @MIGRATION_1662306139_IS_ACTIVE = TRUE;SET @MIGRATION_1662757955_IS_ACTIVE = TRUE;SET @MIGRATION_1663039410_IS_ACTIVE = TRUE;SET @MIGRATION_1676830357_IS_ACTIVE = TRUE;SET @MIGRATION_1616141231_IS_ACTIVE = TRUE;SET @MIGRATION_1635807588_IS_ACTIVE = TRUE;SET @MIGRATION_1647868754_IS_ACTIVE = TRUE;SET @MIGRATION_1651153687_IS_ACTIVE = TRUE;SET @MIGRATION_1565395385_IS_ACTIVE = TRUE;SET @MIGRATION_1604593154_IS_ACTIVE = TRUE;SET @MIGRATION_1604593155_IS_ACTIVE = TRUE;SET @MIGRATION_1644661330_IS_ACTIVE = TRUE;SET @MIGRATION_1645888733_IS_ACTIVE = TRUE; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 398)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)" 3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 197)" 4 => "Shopware\Core\Kernel::boot (line 129)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 69)"`]
0.05 ms (0.00%)		SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC View formatted query View runnable query View query stack SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC; array:13 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 242)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 54)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 38)" 4 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::Shopware\Core\System\SystemConfig\{closure} (line 72)" 5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 35)" 6 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::get (line 43)" 7 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 39)" 8 => "Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader::load (line 83)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 38)" 10 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 140)" 11 => "Shopware\Core\HttpKernel::doHandle (line 81)" 12 => "Shopware\Core\HttpKernel::handle (line 69)"]
0.05 ms (0.00%)		SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = :salesChannelId) AND (configuration_key LIKE :prefix) ORDER BY sales_channel_id ASC View formatted query View runnable query View query stack SELECT configuration_key, configuration_value FROM system_config WHERE ( sales_channel_id IS NULL OR sales_channel_id = : salesChannelId ) AND (configuration_key LIKE : prefix) ORDER BY sales_channel_id ASC SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY sales_channel_id ASC; array:31 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 242)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 189)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigService::getDomain (line 74)" 4 => "Kiener\MolliePayments\Service\SettingsService::getSettings (line 56)" 5 => "Kiener\MolliePayments\Service\Logger\MollieLoggerFactory::createLogger (line 62557)" 6 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getMolliePayments_LoggerService (line 35538)" 7 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getApplePayPaymentService (line 423)" 8 => "Symfony\Component\DependencyInjection\Container::getService (line 42)" 9 => "Symfony\Component\DependencyInjection\Argument\ServiceLocator::get (line 42)" 10 => "Shopware\Core\Checkout\Payment\Cart\PaymentHandler\PaymentHandlerRegistry::__construct (line 40222)" 11 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getPaymentHandlerRegistryService (line 6790)" 12 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getCartOrderRouteService (line 6851)" 13 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getCartService2Service (line 47563)" 14 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getSalesChannelContextServiceService (line 48855)" 15 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getNotFoundSubscriberService (line 48896)" 16 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::getStorefrontSubscriber4Service (line 20318)" 17 => "ContainerTx9EvCp\Shopware_Production_KernelDevDebugContainer::ContainerTx9EvCp\{closure} (line 245)" 18 => "Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 76)" 19 => "Symfony\Component\EventDispatcher\EventDispatcher::getListeners (line 128)" 20 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::getListeners (line 160)" 21 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::getListeners (line 102)" 22 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::getListeners (line 68)" 23 => "Shopware\Core\Framework\Event\NestedEventDispatcher::getListeners (line 293)" 24 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::preProcess (line 148)" 25 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 139)" 26 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 27 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 28 => "Symfony\Component\HttpKernel\Kernel::handle (line 156)" 29 => "Shopware\Core\HttpKernel::doHandle (line 81)" 30 => "Shopware\Core\HttpKernel::handle (line 69)"]
0.15 ms (0.00%)		SELECT item_rounding FROM currency WHERE id = :id View formatted query View runnable query View query stack SELECT item_rounding FROM currency WHERE id = : id SELECT item_rounding FROM currency WHERE id = 0xB7D2554B0CE847CD82F3AC9BD1C0DFCA; array:20 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 684)" 2 => "Doctrine\DBAL\Connection::fetchAssociative (line 329)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 56)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 70)" 5 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 38)" 6 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)" 7 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)" 8 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)" 9 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 56)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 98)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 55)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 37)" 13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)" 14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 151)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 156)" 18 => "Shopware\Core\HttpKernel::doHandle (line 81)" 19 => "Shopware\Core\HttpKernel::handle (line 69)"]
0.63 ms (0.00%)		SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE (IF(JSON_TYPE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = :param_7ccf26ed3114417ba94333c6abe00ebb) View formatted query View runnable query View query stack SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE ( IF( JSON_TYPE( JSON_EXTRACT( `system_config`.`configuration_value`, '$._value' ) ) != "NULL", CONVERT( JSON_UNQUOTE( JSON_EXTRACT( `system_config`.`configuration_value`, '$._value' ) ) USING "utf8mb4" ) COLLATE utf8mb4_unicode_ci, NULL ) = : param_7ccf26ed3114417ba94333c6abe00ebb ) SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE (IF(JSON_TYPE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`system_config`.`configuration_value`, '$._value')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = 'ss9vfzW5LfFnX0VLCKhUmCVxyV8VW7hq'); array:17 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 242)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 106)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 51)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 174)" 10 => "Swag\PayPal\Webhook\WebhookController::validateShopwareToken (line 97)" 11 => "Swag\PayPal\Webhook\WebhookController::executeWebhook (line 163)" 12 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 13 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 14 => "Symfony\Component\HttpKernel\Kernel::handle (line 156)" 15 => "Shopware\Core\HttpKernel::doHandle (line 81)" 16 => "Shopware\Core\HttpKernel::handle (line 69)"]
0.15 ms (0.00%)		SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1 View formatted query View runnable query View query stack SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1 SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1; array:33 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1065)" 2 => "Doctrine\DBAL\Connection::fetchAllKeyValue (line 101)" 3 => "Shopware\Core\System\CustomField\CustomFieldService::getCustomFields (line 43)" 4 => "Shopware\Core\System\CustomField\CustomFieldService::getCustomField (line 56)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\FieldAccessorBuilder\CustomFieldsAccessorBuilder::buildAccessor (line 691)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::buildFieldSelector (line 673)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::buildInheritedAccessor (line 227)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::getFieldAccessor (line 259)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Search\Parser\SqlQueryParser::parseEqualsFilter (line 112)" 10 => "Shopware\Core\Framework\DataAbstractionLayer\Search\Parser\SqlQueryParser::parse (line 331)" 11 => "Shopware\Core\Framework\DataAbstractionLayer\Search\Parser\SqlQueryParser::iterateNested (line 295)" 12 => "Shopware\Core\Framework\DataAbstractionLayer\Search\Parser\SqlQueryParser::parseMultiFilter (line 126)" 13 => "Shopware\Core\Framework\DataAbstractionLayer\Search\Parser\SqlQueryParser::parse (line 124)" 14 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\CriteriaQueryBuilder::addFilter (line 105)" 15 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\CriteriaQueryBuilder::build (line 300)" 16 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 17 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 18 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 19 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 20 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 106)" 21 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 51)" 22 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 68)" 23 => "Swag\PayPal\Webhook\Handler\AbstractWebhookHandler::getOrderTransaction (line 43)" 24 => "Swag\PayPal\Webhook\Handler\SaleRefunded::invoke (line 108)" 25 => "Swag\PayPal\Webhook\WebhookService::executeWebhook (line 138)" 26 => "Swag\PayPal\Webhook\WebhookController::tryToExecuteWebhook (line 100)" 27 => "Swag\PayPal\Webhook\WebhookController::executeWebhook (line 163)" 28 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 29 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 30 => "Symfony\Component\HttpKernel\Kernel::handle (line 156)" 31 => "Shopware\Core\HttpKernel::doHandle (line 81)" 32 => "Shopware\Core\HttpKernel::handle (line 69)"]
1.87 ms (0.00%)		SELECT `order_transaction`.`id` as `order_transaction.id`, `order_transaction`.`version_id` as `order_transaction.versionId`, `order_transaction`.`order_id` as `order_transaction.orderId`, `order_transaction`.`order_version_id` as `order_transaction.orderVersionId`, `order_transaction`.`payment_method_id` as `order_transaction.paymentMethodId`, `order_transaction`.`amount` as `order_transaction.amount`, `order_transaction`.`state_id` as `order_transaction.stateId`, `order_transaction.stateMachineState`.`id` as `order_transaction.stateMachineState.id`, `order_transaction.stateMachineState`.`technical_name` as `order_transaction.stateMachineState.technicalName`, `order_transaction.stateMachineState`.`state_machine_id` as `order_transaction.stateMachineState.stateMachineId`, `order_transaction.stateMachineState`.`created_at` as `order_transaction.stateMachineState.createdAt`, `order_transaction.stateMachineState`.`updated_at` as `order_transaction.stateMachineState.updatedAt`, `order_transaction.stateMachineState.translation.name`, COALESCE(`order_transaction.stateMachineState.translation.name`,`order_transaction.stateMachineState.translation.name`) as `order_transaction.stateMachineState.name`, `order_transaction.stateMachineState.translation.customFields`, COALESCE(`order_transaction.stateMachineState.translation.customFields`,`order_transaction.stateMachineState.translation.customFields`) as `order_transaction.stateMachineState.customFields`, `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation.languageId`, `order_transaction`.`custom_fields` as `order_transaction.customFields`, `order_transaction`.`created_at` as `order_transaction.createdAt`, `order_transaction`.`updated_at` as `order_transaction.updatedAt`, `order_transaction.order`.`id` as `order_transaction.order.id`, `order_transaction.order`.`version_id` as `order_transaction.order.versionId`, `order_transaction.order`.`auto_increment` as `order_transaction.order.autoIncrement`, `order_transaction.order`.`order_number` as `order_transaction.order.orderNumber`, `order_transaction.order`.`billing_address_id` as `order_transaction.order.billingAddressId`, `order_transaction.order`.`billing_address_version_id` as `order_transaction.order.billingAddressVersionId`, `order_transaction.order`.`currency_id` as `order_transaction.order.currencyId`, `order_transaction.order`.`language_id` as `order_transaction.order.languageId`, `order_transaction.order`.`sales_channel_id` as `order_transaction.order.salesChannelId`, `order_transaction.order`.`order_date_time` as `order_transaction.order.orderDateTime`, `order_transaction.order`.`order_date` as `order_transaction.order.orderDate`, `order_transaction.order`.`price` as `order_transaction.order.price`, `order_transaction.order`.`amount_total` as `order_transaction.order.amountTotal`, `order_transaction.order`.`amount_net` as `order_transaction.order.amountNet`, `order_transaction.order`.`position_price` as `order_transaction.order.positionPrice`, `order_transaction.order`.`tax_status` as `order_transaction.order.taxStatus`, `order_transaction.order`.`shipping_costs` as `order_transaction.order.shippingCosts`, `order_transaction.order`.`shipping_total` as `order_transaction.order.shippingTotal`, `order_transaction.order`.`currency_factor` as `order_transaction.order.currencyFactor`, `order_transaction.order`.`deep_link_code` as `order_transaction.order.deepLinkCode`, `order_transaction.order`.`affiliate_code` as `order_transaction.order.affiliateCode`, `order_transaction.order`.`campaign_code` as `order_transaction.order.campaignCode`, `order_transaction.order`.`customer_comment` as `order_transaction.order.customerComment`, `order_transaction.order`.`state_id` as `order_transaction.order.stateId`, `order_transaction.order.stateMachineState`.`id` as `order_transaction.order.stateMachineState.id`, `order_transaction.order.stateMachineState`.`technical_name` as `order_transaction.order.stateMachineState.technicalName`, `order_transaction.order.stateMachineState`.`state_machine_id` as `order_transaction.order.stateMachineState.stateMachineId`, `order_transaction.order.stateMachineState`.`created_at` as `order_transaction.order.stateMachineState.createdAt`, `order_transaction.order.stateMachineState`.`updated_at` as `order_transaction.order.stateMachineState.updatedAt`, `order_transaction.order.stateMachineState.translation.name`, COALESCE(`order_transaction.order.stateMachineState.translation.name`,`order_transaction.order.stateMachineState.translation.name`) as `order_transaction.order.stateMachineState.name`, `order_transaction.order.stateMachineState.translation.customFields`, COALESCE(`order_transaction.order.stateMachineState.translation.customFields`,`order_transaction.order.stateMachineState.translation.customFields`) as `order_transaction.order.stateMachineState.customFields`, `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation.languageId`, `order_transaction.order`.`rule_ids` as `order_transaction.order.ruleIds`, `order_transaction.order`.`custom_fields` as `order_transaction.order.customFields`, `order_transaction.order`.`created_by_id` as `order_transaction.order.createdById`, `order_transaction.order`.`updated_by_id` as `order_transaction.order.updatedById`, `order_transaction.order.orderCustomer`.`id` as `order_transaction.order.orderCustomer.id`, `order_transaction.order.orderCustomer`.`version_id` as `order_transaction.order.orderCustomer.versionId`, `order_transaction.order.orderCustomer`.`customer_id` as `order_transaction.order.orderCustomer.customerId`, `order_transaction.order.orderCustomer`.`order_id` as `order_transaction.order.orderCustomer.orderId`, `order_transaction.order.orderCustomer`.`order_version_id` as `order_transaction.order.orderCustomer.orderVersionId`, `order_transaction.order.orderCustomer`.`email` as `order_transaction.order.orderCustomer.email`, `order_transaction.order.orderCustomer`.`salutation_id` as `order_transaction.order.orderCustomer.salutationId`, `order_transaction.order.orderCustomer`.`first_name` as `order_transaction.order.orderCustomer.firstName`, `order_transaction.order.orderCustomer`.`last_name` as `order_transaction.order.orderCustomer.lastName`, `order_transaction.order.orderCustomer`.`company` as `order_transaction.order.orderCustomer.company`, `order_transaction.order.orderCustomer`.`title` as `order_transaction.order.orderCustomer.title`, `order_transaction.order.orderCustomer`.`vat_ids` as `order_transaction.order.orderCustomer.vatIds`, `order_transaction.order.orderCustomer`.`customer_number` as `order_transaction.order.orderCustomer.customerNumber`, `order_transaction.order.orderCustomer`.`custom_fields` as `order_transaction.order.orderCustomer.customFields`, `order_transaction.order.orderCustomer`.`remote_address` as `order_transaction.order.orderCustomer.remoteAddress`, `order_transaction.order.orderCustomer`.`created_at` as `order_transaction.order.orderCustomer.createdAt`, `order_transaction.order.orderCustomer`.`updated_at` as `order_transaction.order.orderCustomer.updatedAt`, `order_transaction.order`.`item_rounding` as `order_transaction.order.itemRounding`, `order_transaction.order`.`total_rounding` as `order_transaction.order.totalRounding`, `order_transaction.order`.`created_at` as `order_transaction.order.createdAt`, `order_transaction.order`.`updated_at` as `order_transaction.order.updatedAt` FROM `order_transaction` LEFT JOIN `state_machine_state` `order_transaction.stateMachineState` ON `order_transaction`.`state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `order` `order_transaction.order` ON `order_transaction`.`order_id` = `order_transaction.order`.`id` AND `order_transaction`.`version_id` = `order_transaction.order`.`version_id` LEFT JOIN (SELECT `order_transaction.stateMachineState.translation`.state_machine_state_id, `order_transaction.stateMachineState.translation`.name as `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation`.custom_fields as `order_transaction.stateMachineState.translation.customFields`, `order_transaction.stateMachineState.translation`.created_at as `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation`.updated_at as `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation`.state_machine_state_id as `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation`.language_id as `order_transaction.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.stateMachineState.translation` WHERE `order_transaction.stateMachineState.translation`.language_id = :languageId) `order_transaction.stateMachineState.state_machine_state_translation` ON `order_transaction.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `state_machine_state` `order_transaction.order.stateMachineState` ON `order_transaction.order`.`state_id` = `order_transaction.order.stateMachineState`.`id` LEFT JOIN `order_customer` `order_transaction.order.orderCustomer` ON `order_transaction.order`.`id` = `order_transaction.order.orderCustomer`.`order_id` AND `order_transaction.order`.`version_id` = `order_transaction.order.orderCustomer`.`version_id` LEFT JOIN (SELECT `order_transaction.order.stateMachineState.translation`.state_machine_state_id, `order_transaction.order.stateMachineState.translation`.name as `order_transaction.order.stateMachineState.translation.name`, `order_transaction.order.stateMachineState.translation`.custom_fields as `order_transaction.order.stateMachineState.translation.customFields`, `order_transaction.order.stateMachineState.translation`.created_at as `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation`.updated_at as `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation`.state_machine_state_id as `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation`.language_id as `order_transaction.order.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.order.stateMachineState.translation` WHERE `order_transaction.order.stateMachineState.translation`.language_id = :languageId) `order_transaction.order.stateMachineState.state_machine_state_translation` ON `order_transaction.order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.order.stateMachineState`.`id` WHERE (`order_transaction`.`version_id` = :version) AND ((IF(JSON_TYPE(JSON_EXTRACT(`order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = :param_38e0f51fed35436c8c4aabdc549c0f2a)) View formatted query View runnable query View query stack SELECT `order_transaction`.`id` as `order_transaction.id`, `order_transaction`.`version_id` as `order_transaction.versionId`, `order_transaction`.`order_id` as `order_transaction.orderId`, `order_transaction`.`order_version_id` as `order_transaction.orderVersionId`, `order_transaction`.`payment_method_id` as `order_transaction.paymentMethodId`, `order_transaction`.`amount` as `order_transaction.amount`, `order_transaction`.`state_id` as `order_transaction.stateId`, `order_transaction.stateMachineState`.`id` as `order_transaction.stateMachineState.id`, `order_transaction.stateMachineState`.`technical_name` as `order_transaction.stateMachineState.technicalName`, `order_transaction.stateMachineState`.`state_machine_id` as `order_transaction.stateMachineState.stateMachineId`, `order_transaction.stateMachineState`.`created_at` as `order_transaction.stateMachineState.createdAt`, `order_transaction.stateMachineState`.`updated_at` as `order_transaction.stateMachineState.updatedAt`, `order_transaction.stateMachineState.translation.name`, COALESCE( `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation.name` ) as `order_transaction.stateMachineState.name`, `order_transaction.stateMachineState.translation.customFields`, COALESCE( `order_transaction.stateMachineState.translation.customFields`, `order_transaction.stateMachineState.translation.customFields` ) as `order_transaction.stateMachineState.customFields`, `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation.languageId`, `order_transaction`.`custom_fields` as `order_transaction.customFields`, `order_transaction`.`created_at` as `order_transaction.createdAt`, `order_transaction`.`updated_at` as `order_transaction.updatedAt`, `order_transaction.order`.`id` as `order_transaction.order.id`, `order_transaction.order`.`version_id` as `order_transaction.order.versionId`, `order_transaction.order`.`auto_increment` as `order_transaction.order.autoIncrement`, `order_transaction.order`.`order_number` as `order_transaction.order.orderNumber`, `order_transaction.order`.`billing_address_id` as `order_transaction.order.billingAddressId`, `order_transaction.order`.`billing_address_version_id` as `order_transaction.order.billingAddressVersionId`, `order_transaction.order`.`currency_id` as `order_transaction.order.currencyId`, `order_transaction.order`.`language_id` as `order_transaction.order.languageId`, `order_transaction.order`.`sales_channel_id` as `order_transaction.order.salesChannelId`, `order_transaction.order`.`order_date_time` as `order_transaction.order.orderDateTime`, `order_transaction.order`.`order_date` as `order_transaction.order.orderDate`, `order_transaction.order`.`price` as `order_transaction.order.price`, `order_transaction.order`.`amount_total` as `order_transaction.order.amountTotal`, `order_transaction.order`.`amount_net` as `order_transaction.order.amountNet`, `order_transaction.order`.`position_price` as `order_transaction.order.positionPrice`, `order_transaction.order`.`tax_status` as `order_transaction.order.taxStatus`, `order_transaction.order`.`shipping_costs` as `order_transaction.order.shippingCosts`, `order_transaction.order`.`shipping_total` as `order_transaction.order.shippingTotal`, `order_transaction.order`.`currency_factor` as `order_transaction.order.currencyFactor`, `order_transaction.order`.`deep_link_code` as `order_transaction.order.deepLinkCode`, `order_transaction.order`.`affiliate_code` as `order_transaction.order.affiliateCode`, `order_transaction.order`.`campaign_code` as `order_transaction.order.campaignCode`, `order_transaction.order`.`customer_comment` as `order_transaction.order.customerComment`, `order_transaction.order`.`state_id` as `order_transaction.order.stateId`, `order_transaction.order.stateMachineState`.`id` as `order_transaction.order.stateMachineState.id`, `order_transaction.order.stateMachineState`.`technical_name` as `order_transaction.order.stateMachineState.technicalName`, `order_transaction.order.stateMachineState`.`state_machine_id` as `order_transaction.order.stateMachineState.stateMachineId`, `order_transaction.order.stateMachineState`.`created_at` as `order_transaction.order.stateMachineState.createdAt`, `order_transaction.order.stateMachineState`.`updated_at` as `order_transaction.order.stateMachineState.updatedAt`, `order_transaction.order.stateMachineState.translation.name`, COALESCE( `order_transaction.order.stateMachineState.translation.name`, `order_transaction.order.stateMachineState.translation.name` ) as `order_transaction.order.stateMachineState.name`, `order_transaction.order.stateMachineState.translation.customFields`, COALESCE( `order_transaction.order.stateMachineState.translation.customFields`, `order_transaction.order.stateMachineState.translation.customFields` ) as `order_transaction.order.stateMachineState.customFields`, `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation.languageId`, `order_transaction.order`.`rule_ids` as `order_transaction.order.ruleIds`, `order_transaction.order`.`custom_fields` as `order_transaction.order.customFields`, `order_transaction.order`.`created_by_id` as `order_transaction.order.createdById`, `order_transaction.order`.`updated_by_id` as `order_transaction.order.updatedById`, `order_transaction.order.orderCustomer`.`id` as `order_transaction.order.orderCustomer.id`, `order_transaction.order.orderCustomer`.`version_id` as `order_transaction.order.orderCustomer.versionId`, `order_transaction.order.orderCustomer`.`customer_id` as `order_transaction.order.orderCustomer.customerId`, `order_transaction.order.orderCustomer`.`order_id` as `order_transaction.order.orderCustomer.orderId`, `order_transaction.order.orderCustomer`.`order_version_id` as `order_transaction.order.orderCustomer.orderVersionId`, `order_transaction.order.orderCustomer`.`email` as `order_transaction.order.orderCustomer.email`, `order_transaction.order.orderCustomer`.`salutation_id` as `order_transaction.order.orderCustomer.salutationId`, `order_transaction.order.orderCustomer`.`first_name` as `order_transaction.order.orderCustomer.firstName`, `order_transaction.order.orderCustomer`.`last_name` as `order_transaction.order.orderCustomer.lastName`, `order_transaction.order.orderCustomer`.`company` as `order_transaction.order.orderCustomer.company`, `order_transaction.order.orderCustomer`.`title` as `order_transaction.order.orderCustomer.title`, `order_transaction.order.orderCustomer`.`vat_ids` as `order_transaction.order.orderCustomer.vatIds`, `order_transaction.order.orderCustomer`.`customer_number` as `order_transaction.order.orderCustomer.customerNumber`, `order_transaction.order.orderCustomer`.`custom_fields` as `order_transaction.order.orderCustomer.customFields`, `order_transaction.order.orderCustomer`.`remote_address` as `order_transaction.order.orderCustomer.remoteAddress`, `order_transaction.order.orderCustomer`.`created_at` as `order_transaction.order.orderCustomer.createdAt`, `order_transaction.order.orderCustomer`.`updated_at` as `order_transaction.order.orderCustomer.updatedAt`, `order_transaction.order`.`item_rounding` as `order_transaction.order.itemRounding`, `order_transaction.order`.`total_rounding` as `order_transaction.order.totalRounding`, `order_transaction.order`.`created_at` as `order_transaction.order.createdAt`, `order_transaction.order`.`updated_at` as `order_transaction.order.updatedAt` FROM `order_transaction` LEFT JOIN `state_machine_state` `order_transaction.stateMachineState` ON `order_transaction`.`state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `order` `order_transaction.order` ON `order_transaction`.`order_id` = `order_transaction.order`.`id` AND `order_transaction`.`version_id` = `order_transaction.order`.`version_id` LEFT JOIN ( SELECT `order_transaction.stateMachineState.translation`.state_machine_state_id, `order_transaction.stateMachineState.translation`.name as `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation`.custom_fields as `order_transaction.stateMachineState.translation.customFields`, `order_transaction.stateMachineState.translation`.created_at as `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation`.updated_at as `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation`.state_machine_state_id as `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation`.language_id as `order_transaction.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.stateMachineState.translation` WHERE `order_transaction.stateMachineState.translation`.language_id = : languageId ) `order_transaction.stateMachineState.state_machine_state_translation` ON `order_transaction.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `state_machine_state` `order_transaction.order.stateMachineState` ON `order_transaction.order`.`state_id` = `order_transaction.order.stateMachineState`.`id` LEFT JOIN `order_customer` `order_transaction.order.orderCustomer` ON `order_transaction.order`.`id` = `order_transaction.order.orderCustomer`.`order_id` AND `order_transaction.order`.`version_id` = `order_transaction.order.orderCustomer`.`version_id` LEFT JOIN ( SELECT `order_transaction.order.stateMachineState.translation`.state_machine_state_id, `order_transaction.order.stateMachineState.translation`.name as `order_transaction.order.stateMachineState.translation.name`, `order_transaction.order.stateMachineState.translation`.custom_fields as `order_transaction.order.stateMachineState.translation.customFields`, `order_transaction.order.stateMachineState.translation`.created_at as `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation`.updated_at as `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation`.state_machine_state_id as `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation`.language_id as `order_transaction.order.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.order.stateMachineState.translation` WHERE `order_transaction.order.stateMachineState.translation`.language_id = : languageId ) `order_transaction.order.stateMachineState.state_machine_state_translation` ON `order_transaction.order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.order.stateMachineState`.`id` WHERE ( `order_transaction`.`version_id` = : version ) AND ( ( IF( JSON_TYPE( JSON_EXTRACT( `order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id' ) ) != "NULL", CONVERT( JSON_UNQUOTE( JSON_EXTRACT( `order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id' ) ) USING "utf8mb4" ) COLLATE utf8mb4_unicode_ci, NULL ) = : param_38e0f51fed35436c8c4aabdc549c0f2a ) ) SELECT `order_transaction`.`id` as `order_transaction.id`, `order_transaction`.`version_id` as `order_transaction.versionId`, `order_transaction`.`order_id` as `order_transaction.orderId`, `order_transaction`.`order_version_id` as `order_transaction.orderVersionId`, `order_transaction`.`payment_method_id` as `order_transaction.paymentMethodId`, `order_transaction`.`amount` as `order_transaction.amount`, `order_transaction`.`state_id` as `order_transaction.stateId`, `order_transaction.stateMachineState`.`id` as `order_transaction.stateMachineState.id`, `order_transaction.stateMachineState`.`technical_name` as `order_transaction.stateMachineState.technicalName`, `order_transaction.stateMachineState`.`state_machine_id` as `order_transaction.stateMachineState.stateMachineId`, `order_transaction.stateMachineState`.`created_at` as `order_transaction.stateMachineState.createdAt`, `order_transaction.stateMachineState`.`updated_at` as `order_transaction.stateMachineState.updatedAt`, `order_transaction.stateMachineState.translation.name`, COALESCE(`order_transaction.stateMachineState.translation.name`,`order_transaction.stateMachineState.translation.name`) as `order_transaction.stateMachineState.name`, `order_transaction.stateMachineState.translation.customFields`, COALESCE(`order_transaction.stateMachineState.translation.customFields`,`order_transaction.stateMachineState.translation.customFields`) as `order_transaction.stateMachineState.customFields`, `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation.languageId`, `order_transaction`.`custom_fields` as `order_transaction.customFields`, `order_transaction`.`created_at` as `order_transaction.createdAt`, `order_transaction`.`updated_at` as `order_transaction.updatedAt`, `order_transaction.order`.`id` as `order_transaction.order.id`, `order_transaction.order`.`version_id` as `order_transaction.order.versionId`, `order_transaction.order`.`auto_increment` as `order_transaction.order.autoIncrement`, `order_transaction.order`.`order_number` as `order_transaction.order.orderNumber`, `order_transaction.order`.`billing_address_id` as `order_transaction.order.billingAddressId`, `order_transaction.order`.`billing_address_version_id` as `order_transaction.order.billingAddressVersionId`, `order_transaction.order`.`currency_id` as `order_transaction.order.currencyId`, `order_transaction.order`.`language_id` as `order_transaction.order.languageId`, `order_transaction.order`.`sales_channel_id` as `order_transaction.order.salesChannelId`, `order_transaction.order`.`order_date_time` as `order_transaction.order.orderDateTime`, `order_transaction.order`.`order_date` as `order_transaction.order.orderDate`, `order_transaction.order`.`price` as `order_transaction.order.price`, `order_transaction.order`.`amount_total` as `order_transaction.order.amountTotal`, `order_transaction.order`.`amount_net` as `order_transaction.order.amountNet`, `order_transaction.order`.`position_price` as `order_transaction.order.positionPrice`, `order_transaction.order`.`tax_status` as `order_transaction.order.taxStatus`, `order_transaction.order`.`shipping_costs` as `order_transaction.order.shippingCosts`, `order_transaction.order`.`shipping_total` as `order_transaction.order.shippingTotal`, `order_transaction.order`.`currency_factor` as `order_transaction.order.currencyFactor`, `order_transaction.order`.`deep_link_code` as `order_transaction.order.deepLinkCode`, `order_transaction.order`.`affiliate_code` as `order_transaction.order.affiliateCode`, `order_transaction.order`.`campaign_code` as `order_transaction.order.campaignCode`, `order_transaction.order`.`customer_comment` as `order_transaction.order.customerComment`, `order_transaction.order`.`state_id` as `order_transaction.order.stateId`, `order_transaction.order.stateMachineState`.`id` as `order_transaction.order.stateMachineState.id`, `order_transaction.order.stateMachineState`.`technical_name` as `order_transaction.order.stateMachineState.technicalName`, `order_transaction.order.stateMachineState`.`state_machine_id` as `order_transaction.order.stateMachineState.stateMachineId`, `order_transaction.order.stateMachineState`.`created_at` as `order_transaction.order.stateMachineState.createdAt`, `order_transaction.order.stateMachineState`.`updated_at` as `order_transaction.order.stateMachineState.updatedAt`, `order_transaction.order.stateMachineState.translation.name`, COALESCE(`order_transaction.order.stateMachineState.translation.name`,`order_transaction.order.stateMachineState.translation.name`) as `order_transaction.order.stateMachineState.name`, `order_transaction.order.stateMachineState.translation.customFields`, COALESCE(`order_transaction.order.stateMachineState.translation.customFields`,`order_transaction.order.stateMachineState.translation.customFields`) as `order_transaction.order.stateMachineState.customFields`, `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation.languageId`, `order_transaction.order`.`rule_ids` as `order_transaction.order.ruleIds`, `order_transaction.order`.`custom_fields` as `order_transaction.order.customFields`, `order_transaction.order`.`created_by_id` as `order_transaction.order.createdById`, `order_transaction.order`.`updated_by_id` as `order_transaction.order.updatedById`, `order_transaction.order.orderCustomer`.`id` as `order_transaction.order.orderCustomer.id`, `order_transaction.order.orderCustomer`.`version_id` as `order_transaction.order.orderCustomer.versionId`, `order_transaction.order.orderCustomer`.`customer_id` as `order_transaction.order.orderCustomer.customerId`, `order_transaction.order.orderCustomer`.`order_id` as `order_transaction.order.orderCustomer.orderId`, `order_transaction.order.orderCustomer`.`order_version_id` as `order_transaction.order.orderCustomer.orderVersionId`, `order_transaction.order.orderCustomer`.`email` as `order_transaction.order.orderCustomer.email`, `order_transaction.order.orderCustomer`.`salutation_id` as `order_transaction.order.orderCustomer.salutationId`, `order_transaction.order.orderCustomer`.`first_name` as `order_transaction.order.orderCustomer.firstName`, `order_transaction.order.orderCustomer`.`last_name` as `order_transaction.order.orderCustomer.lastName`, `order_transaction.order.orderCustomer`.`company` as `order_transaction.order.orderCustomer.company`, `order_transaction.order.orderCustomer`.`title` as `order_transaction.order.orderCustomer.title`, `order_transaction.order.orderCustomer`.`vat_ids` as `order_transaction.order.orderCustomer.vatIds`, `order_transaction.order.orderCustomer`.`customer_number` as `order_transaction.order.orderCustomer.customerNumber`, `order_transaction.order.orderCustomer`.`custom_fields` as `order_transaction.order.orderCustomer.customFields`, `order_transaction.order.orderCustomer`.`remote_address` as `order_transaction.order.orderCustomer.remoteAddress`, `order_transaction.order.orderCustomer`.`created_at` as `order_transaction.order.orderCustomer.createdAt`, `order_transaction.order.orderCustomer`.`updated_at` as `order_transaction.order.orderCustomer.updatedAt`, `order_transaction.order`.`item_rounding` as `order_transaction.order.itemRounding`, `order_transaction.order`.`total_rounding` as `order_transaction.order.totalRounding`, `order_transaction.order`.`created_at` as `order_transaction.order.createdAt`, `order_transaction.order`.`updated_at` as `order_transaction.order.updatedAt` FROM `order_transaction` LEFT JOIN `state_machine_state` `order_transaction.stateMachineState` ON `order_transaction`.`state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `order` `order_transaction.order` ON `order_transaction`.`order_id` = `order_transaction.order`.`id` AND `order_transaction`.`version_id` = `order_transaction.order`.`version_id` LEFT JOIN (SELECT `order_transaction.stateMachineState.translation`.state_machine_state_id, `order_transaction.stateMachineState.translation`.name as `order_transaction.stateMachineState.translation.name`, `order_transaction.stateMachineState.translation`.custom_fields as `order_transaction.stateMachineState.translation.customFields`, `order_transaction.stateMachineState.translation`.created_at as `order_transaction.stateMachineState.translation.createdAt`, `order_transaction.stateMachineState.translation`.updated_at as `order_transaction.stateMachineState.translation.updatedAt`, `order_transaction.stateMachineState.translation`.state_machine_state_id as `order_transaction.stateMachineState.translation.stateMachineStateId`, `order_transaction.stateMachineState.translation`.language_id as `order_transaction.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.stateMachineState.translation` WHERE `order_transaction.stateMachineState.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_transaction.stateMachineState.state_machine_state_translation` ON `order_transaction.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.stateMachineState`.`id` LEFT JOIN `state_machine_state` `order_transaction.order.stateMachineState` ON `order_transaction.order`.`state_id` = `order_transaction.order.stateMachineState`.`id` LEFT JOIN `order_customer` `order_transaction.order.orderCustomer` ON `order_transaction.order`.`id` = `order_transaction.order.orderCustomer`.`order_id` AND `order_transaction.order`.`version_id` = `order_transaction.order.orderCustomer`.`version_id` LEFT JOIN (SELECT `order_transaction.order.stateMachineState.translation`.state_machine_state_id, `order_transaction.order.stateMachineState.translation`.name as `order_transaction.order.stateMachineState.translation.name`, `order_transaction.order.stateMachineState.translation`.custom_fields as `order_transaction.order.stateMachineState.translation.customFields`, `order_transaction.order.stateMachineState.translation`.created_at as `order_transaction.order.stateMachineState.translation.createdAt`, `order_transaction.order.stateMachineState.translation`.updated_at as `order_transaction.order.stateMachineState.translation.updatedAt`, `order_transaction.order.stateMachineState.translation`.state_machine_state_id as `order_transaction.order.stateMachineState.translation.stateMachineStateId`, `order_transaction.order.stateMachineState.translation`.language_id as `order_transaction.order.stateMachineState.translation.languageId` FROM `state_machine_state_translation` `order_transaction.order.stateMachineState.translation` WHERE `order_transaction.order.stateMachineState.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `order_transaction.order.stateMachineState.state_machine_state_translation` ON `order_transaction.order.stateMachineState.state_machine_state_translation`.`state_machine_state_id` = `order_transaction.order.stateMachineState`.`id` WHERE (`order_transaction`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((IF(JSON_TYPE(JSON_EXTRACT(`order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`order_transaction`.`custom_fields`, '$.swag_paypal_transaction_id')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL) = 'PAYID-M47XZSQ6JR28964644991448')); array:20 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 242)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 316)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 148)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 93)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 257)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 286)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 106)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 51)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepositoryForwardCompatibilityDecorator::search (line 68)" 10 => "Swag\PayPal\Webhook\Handler\AbstractWebhookHandler::getOrderTransaction (line 43)" 11 => "Swag\PayPal\Webhook\Handler\SaleRefunded::invoke (line 108)" 12 => "Swag\PayPal\Webhook\WebhookService::executeWebhook (line 138)" 13 => "Swag\PayPal\Webhook\WebhookController::tryToExecuteWebhook (line 100)" 14 => "Swag\PayPal\Webhook\WebhookController::executeWebhook (line 163)" 15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)" 16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)" 17 => "Symfony\Component\HttpKernel\Kernel::handle (line 156)" 18 => "Shopware\Core\HttpKernel::doHandle (line 81)" 19 => "Shopware\Core\HttpKernel::handle (line 69)"]

Database Connections

There are no configured database connections.

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping