Symfony Profiler

https://geuther.426.agency/api/_action/paypal/webhook/execute?sw-token=uHzSjykQ4O3IDiL7cXUi7zPuQQZJJGKf

Method: POST
HTTP Status: 400
IP: 66.211.170.66
Profiled on: Tue, 29 Oct 2024 20:13:22 +0000
Token: 32c1d2

Last 10 Latest Search

Settings

Query Metrics

9 Database Queries

Different statements

10.49 ms Query time

Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.39 ms (0.00%)		# cache-id-loader SELECT `value` FROM app_config WHERE `key` = :key View formatted query View runnable query View query stack # cache-id-loader SELECT `value` FROM app_config WHERE `key` = : key # cache-id-loader SELECT `value` FROM app_config WHERE `key` = 'cache-id'; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 734)" 2 => "Doctrine\DBAL\Connection::fetchOne (line 40)" 3 => "Shopware\Core\Framework\Adapter\Cache\CacheIdLoader::load (line 185)" 4 => "Shopware\Core\HttpKernel::createKernel (line 126)" 5 => "Shopware\Core\HttpKernel::doHandle (line 79)" 6 => "Shopware\Core\HttpKernel::handle (line 85)"`]
0.48 ms (0.00%)		# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`; View formatted query View runnable query View query stack # dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF( `active` = 1 AND `installed_at` IS NOT NULL, 1, 0 ) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`; # dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 42)" 2 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader::loadPluginInfos (line 101)" 3 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader::initializePlugins (line 180)" 4 => "Shopware\Core\Kernel::boot (line 127)" 5 => "Shopware\Core\HttpKernel::doHandle (line 79)" 6 => "Shopware\Core\HttpKernel::handle (line 85)"`]
0.50 ms (0.00%)		SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 View formatted query View runnable query View query stack SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 SELECT custom_entity.name, custom_entity.fields FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE custom_entity.app_id IS NULL OR app.active = 1 ; array:8 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)" 2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 38)" 3 => "Shopware\Core\System\CustomEntity\CustomEntityRegistrar::register (line 57)" 4 => "Shopware\Core\System\System::boot (line 195)" 5 => "Shopware\Core\Kernel::boot (line 127)" 6 => "Shopware\Core\HttpKernel::doHandle (line 79)" 7 => "Shopware\Core\HttpKernel::handle (line 85)"`]
0.56 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:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 378)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 198)" 3 => "Shopware\Core\Kernel::boot (line 127)" 4 => "Shopware\Core\HttpKernel::doHandle (line 79)" 5 => "Shopware\Core\HttpKernel::handle (line 85)"`]
0.15 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_1605167857_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_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1675155788_IS_ACTIVE = TRUE;SET @MIGRATION_1684315483_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205551_IS_ACTIVE = TRUE;SET @MIGRATION_1580205552_IS_ACTIVE = TRUE;SET @MIGRATION_1603787192_IS_ACTIVE = TRUE;SET @MIGRATION_1603787193_IS_ACTIVE = TRUE;SET @MIGRATION_1608909056_IS_ACTIVE = TRUE;SET @MIGRATION_1608909057_IS_ACTIVE = TRUE;SET @MIGRATION_1608909058_IS_ACTIVE = TRUE;SET @MIGRATION_1609840337_IS_ACTIVE = TRUE;SET @MIGRATION_1609840338_IS_ACTIVE = TRUE;SET @MIGRATION_1610290148_IS_ACTIVE = TRUE;SET @MIGRATION_1615974752_IS_ACTIVE = TRUE;SET @MIGRATION_1615974753_IS_ACTIVE = TRUE;SET @MIGRATION_1615974754_IS_ACTIVE = TRUE;SET @MIGRATION_1616854566_IS_ACTIVE = TRUE;SET @MIGRATION_1641641753_IS_ACTIVE = TRUE;SET @MIGRATION_1652087759_IS_ACTIVE = TRUE;SET @MIGRATION_1652087760_IS_ACTIVE = TRUE;SET @MIGRATION_1556014423_IS_ACTIVE = TRUE;SET @MIGRATION_1556014424_IS_ACTIVE = TRUE;SET @MIGRATION_1556118797_IS_ACTIVE = TRUE;SET @MIGRATION_1584965609_IS_ACTIVE = TRUE;SET @MIGRATION_1586186442_IS_ACTIVE = TRUE;SET @MIGRATION_1586202227_IS_ACTIVE = TRUE;SET @MIGRATION_1589893337_IS_ACTIVE = TRUE;SET @MIGRATION_1592244872_IS_ACTIVE = TRUE;SET @MIGRATION_1592991551_IS_ACTIVE = TRUE;SET @MIGRATION_1593514482_IS_ACTIVE = TRUE;SET @MIGRATION_1594822086_IS_ACTIVE = TRUE;SET @MIGRATION_1595323759_IS_ACTIVE = TRUE;SET @MIGRATION_1596645397_IS_ACTIVE = TRUE;SET @MIGRATION_1596646072_IS_ACTIVE = TRUE;SET @MIGRATION_1597838146_IS_ACTIVE = TRUE;SET @MIGRATION_1599039841_IS_ACTIVE = TRUE;SET @MIGRATION_1600096104_IS_ACTIVE = TRUE;SET @MIGRATION_1600420898_IS_ACTIVE = TRUE;SET @MIGRATION_1601043196_IS_ACTIVE = TRUE;SET @MIGRATION_1607589490_IS_ACTIVE = TRUE;SET @MIGRATION_1607589491_IS_ACTIVE = TRUE;SET @MIGRATION_1607589492_IS_ACTIVE = TRUE;SET @MIGRATION_1610376590_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1616419772_IS_ACTIVE = TRUE;SET @MIGRATION_1617018765_IS_ACTIVE = TRUE;SET @MIGRATION_1618321583_IS_ACTIVE = TRUE;SET @MIGRATION_1620829074_IS_ACTIVE = TRUE;SET @MIGRATION_1621333785_IS_ACTIVE = TRUE;SET @MIGRATION_1621419761_IS_ACTIVE = TRUE;SET @MIGRATION_1625556996_IS_ACTIVE = TRUE;SET @MIGRATION_1626766063_IS_ACTIVE = TRUE;SET @MIGRATION_1636977354_IS_ACTIVE = TRUE;SET @MIGRATION_1637931476_IS_ACTIVE = TRUE;SET @MIGRATION_1638897517_IS_ACTIVE = TRUE;SET @MIGRATION_1640181713_IS_ACTIVE = TRUE;SET @MIGRATION_1641313633_IS_ACTIVE = TRUE;SET @MIGRATION_1642690994_IS_ACTIVE = TRUE;SET @MIGRATION_1643377802_IS_ACTIVE = TRUE;SET @MIGRATION_1645103528_IS_ACTIVE = TRUE;SET @MIGRATION_1645190845_IS_ACTIVE = TRUE;SET @MIGRATION_1648127351_IS_ACTIVE = TRUE;SET @MIGRATION_1648127352_IS_ACTIVE = TRUE;SET @MIGRATION_1649086118_IS_ACTIVE = TRUE;SET @MIGRATION_1649314350_IS_ACTIVE = TRUE;SET @MIGRATION_1649752132_IS_ACTIVE = TRUE;SET @MIGRATION_1649759025_IS_ACTIVE = TRUE;SET @MIGRATION_1657525411_IS_ACTIVE = TRUE;SET @MIGRATION_1658755075_IS_ACTIVE = TRUE;SET @MIGRATION_1660641567_IS_ACTIVE = TRUE;SET @MIGRATION_1662459808_IS_ACTIVE = TRUE;SET @MIGRATION_1663933707_IS_ACTIVE = TRUE;SET @MIGRATION_1666603279_IS_ACTIVE = TRUE;SET @MIGRATION_1668172778_IS_ACTIVE = TRUE;SET @MIGRATION_1668172779_IS_ACTIVE = TRUE;SET @MIGRATION_1668172780_IS_ACTIVE = TRUE;SET @MIGRATION_1675861056_IS_ACTIVE = TRUE;SET @MIGRATION_1677675478_IS_ACTIVE = TRUE;SET @MIGRATION_1677675479_IS_ACTIVE = TRUE;SET @MIGRATION_1679315873_IS_ACTIVE = TRUE;SET @MIGRATION_1679328661_IS_ACTIVE = TRUE;SET @MIGRATION_1679922535_IS_ACTIVE = TRUE;SET @MIGRATION_1680795351_IS_ACTIVE = TRUE;SET @MIGRATION_1681833563_IS_ACTIVE = TRUE;SET @MIGRATION_1682341260_IS_ACTIVE = TRUE;SET @MIGRATION_1683099227_IS_ACTIVE = TRUE;SET @MIGRATION_1683626781_IS_ACTIVE = TRUE;SET @MIGRATION_1688386008_IS_ACTIVE = TRUE;SET @MIGRATION_1689036093_IS_ACTIVE = TRUE;SET @MIGRATION_1620306767_IS_ACTIVE = TRUE;SET @MIGRATION_1620308350_IS_ACTIVE = TRUE;SET @MIGRATION_1657615865_IS_ACTIVE = TRUE;SET @MIGRATION_1660643832_IS_ACTIVE = TRUE;SET @MIGRATION_1613492839_IS_ACTIVE = TRUE;SET @MIGRATION_1613493472_IS_ACTIVE = TRUE;SET @MIGRATION_1613496348_IS_ACTIVE = TRUE;SET @MIGRATION_1621510875_IS_ACTIVE = TRUE;SET @MIGRATION_1622207125_IS_ACTIVE = TRUE;SET @MIGRATION_1631691913_IS_ACTIVE = TRUE;SET @MIGRATION_1633948279_IS_ACTIVE = TRUE;SET @MIGRATION_1637145145_IS_ACTIVE = TRUE;SET @MIGRATION_1667481867_IS_ACTIVE = TRUE;SET @MIGRATION_1677064840_IS_ACTIVE = TRUE;SET @MIGRATION_1677078498_IS_ACTIVE = TRUE;SET @MIGRATION_1679046988_IS_ACTIVE = TRUE;SET @MIGRATION_1649747949_IS_ACTIVE = TRUE;SET @MIGRATION_1664282874_IS_ACTIVE = TRUE;SET @MIGRATION_1669191282_IS_ACTIVE = TRUE;SET @MIGRATION_1669802571_IS_ACTIVE = TRUE;SET @MIGRATION_1672940274_IS_ACTIVE = TRUE;SET @MIGRATION_1676300213_IS_ACTIVE = TRUE;SET @MIGRATION_1680541382_IS_ACTIVE = TRUE;SET @MIGRATION_1681403103_IS_ACTIVE = TRUE;SET @MIGRATION_1681832217_IS_ACTIVE = TRUE;SET @MIGRATION_1686823602_IS_ACTIVE = TRUE;SET @MIGRATION_1688034601_IS_ACTIVE = TRUE;SET @MIGRATION_1617713528_IS_ACTIVE = TRUE;SET @MIGRATION_1554708925_IS_ACTIVE = TRUE;SET @MIGRATION_1710809734_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1589963718_IS_ACTIVE = TRUE;SET @MIGRATION_1619069101_IS_ACTIVE = TRUE;SET @MIGRATION_1623656945_IS_ACTIVE = TRUE;SET @MIGRATION_1623820553_IS_ACTIVE = TRUE;SET @MIGRATION_1624275180_IS_ACTIVE = TRUE;SET @MIGRATION_1633436214_IS_ACTIVE = TRUE;SET @MIGRATION_1598965635_IS_ACTIVE = TRUE;SET @MIGRATION_1606140637_IS_ACTIVE = TRUE;SET @MIGRATION_1626945611_IS_ACTIVE = TRUE;SET @MIGRATION_1663996974_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1562148231_IS_ACTIVE = TRUE;SET @MIGRATION_1562148246_IS_ACTIVE = TRUE;SET @MIGRATION_1563203721_IS_ACTIVE = TRUE;SET @MIGRATION_1570473516_IS_ACTIVE = TRUE;SET @MIGRATION_1570559540_IS_ACTIVE = TRUE;SET @MIGRATION_1570636494_IS_ACTIVE = TRUE;SET @MIGRATION_1571066783_IS_ACTIVE = TRUE;SET @MIGRATION_1572361168_IS_ACTIVE = TRUE;SET @MIGRATION_1574261053_IS_ACTIVE = TRUE;SET @MIGRATION_1575643478_IS_ACTIVE = TRUE;SET @MIGRATION_1579791730_IS_ACTIVE = TRUE;SET @MIGRATION_1582633686_IS_ACTIVE = TRUE;SET @MIGRATION_1603880098_IS_ACTIVE = TRUE;SET @MIGRATION_1604519974_IS_ACTIVE = TRUE;SET @MIGRATION_1607955053_IS_ACTIVE = TRUE;SET @MIGRATION_1613475319_IS_ACTIVE = TRUE;SET @MIGRATION_1614099957_IS_ACTIVE = TRUE;SET @MIGRATION_1632302999_IS_ACTIVE = TRUE;SET @MIGRATION_1638435166_IS_ACTIVE = TRUE;SET @MIGRATION_1642079844_IS_ACTIVE = TRUE;SET @MIGRATION_1708070947_IS_ACTIVE = TRUE;SET @MIGRATION_1572012839_IS_ACTIVE = TRUE;SET @MIGRATION_1572012863_IS_ACTIVE = TRUE;SET @MIGRATION_1572012872_IS_ACTIVE = TRUE;SET @MIGRATION_1572172912_IS_ACTIVE = TRUE;SET @MIGRATION_1573059308_IS_ACTIVE = TRUE;SET @MIGRATION_1574260096_IS_ACTIVE = TRUE;SET @MIGRATION_1596724410_IS_ACTIVE = TRUE;SET @MIGRATION_1602017170_IS_ACTIVE = TRUE 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_1605167857_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_1675420139_IS_ACTIVE = TRUE; SET @MIGRATION_1675155788_IS_ACTIVE = TRUE; SET @MIGRATION_1684315483_IS_ACTIVE = TRUE; SET @MIGRATION_1580205548_IS_ACTIVE = TRUE; SET @MIGRATION_1580205550_IS_ACTIVE = TRUE; SET @MIGRATION_1580205551_IS_ACTIVE = TRUE; SET @MIGRATION_1580205552_IS_ACTIVE = TRUE; SET @MIGRATION_1603787192_IS_ACTIVE = TRUE; SET @MIGRATION_1603787193_IS_ACTIVE = TRUE; SET @MIGRATION_1608909056_IS_ACTIVE = TRUE; SET @MIGRATION_1608909057_IS_ACTIVE = TRUE; SET @MIGRATION_1608909058_IS_ACTIVE = TRUE; SET @MIGRATION_1609840337_IS_ACTIVE = TRUE; SET @MIGRATION_1609840338_IS_ACTIVE = TRUE; SET @MIGRATION_1610290148_IS_ACTIVE = TRUE; SET @MIGRATION_1615974752_IS_ACTIVE = TRUE; SET @MIGRATION_1615974753_IS_ACTIVE = TRUE; SET @MIGRATION_1615974754_IS_ACTIVE = TRUE; SET @MIGRATION_1616854566_IS_ACTIVE = TRUE; SET @MIGRATION_1641641753_IS_ACTIVE = TRUE; SET @MIGRATION_1652087759_IS_ACTIVE = TRUE; SET @MIGRATION_1652087760_IS_ACTIVE = TRUE; SET @MIGRATION_1556014423_IS_ACTIVE = TRUE; SET @MIGRATION_1556014424_IS_ACTIVE = TRUE; SET @MIGRATION_1556118797_IS_ACTIVE = TRUE; SET @MIGRATION_1584965609_IS_ACTIVE = TRUE; SET @MIGRATION_1586186442_IS_ACTIVE = TRUE; SET @MIGRATION_1586202227_IS_ACTIVE = TRUE; SET @MIGRATION_1589893337_IS_ACTIVE = TRUE; SET @MIGRATION_1592244872_IS_ACTIVE = TRUE; SET @MIGRATION_1592991551_IS_ACTIVE = TRUE; SET @MIGRATION_1593514482_IS_ACTIVE = TRUE; SET @MIGRATION_1594822086_IS_ACTIVE = TRUE; SET @MIGRATION_1595323759_IS_ACTIVE = TRUE; SET @MIGRATION_1596645397_IS_ACTIVE = TRUE; SET @MIGRATION_1596646072_IS_ACTIVE = TRUE; SET @MIGRATION_1597838146_IS_ACTIVE = TRUE; SET @MIGRATION_1599039841_IS_ACTIVE = TRUE; SET @MIGRATION_1600096104_IS_ACTIVE = TRUE; SET @MIGRATION_1600420898_IS_ACTIVE = TRUE; SET @MIGRATION_1601043196_IS_ACTIVE = TRUE; SET @MIGRATION_1607589490_IS_ACTIVE = TRUE; SET @MIGRATION_1607589491_IS_ACTIVE = TRUE; SET @MIGRATION_1607589492_IS_ACTIVE = TRUE; SET @MIGRATION_1610376590_IS_ACTIVE = TRUE; SET @MIGRATION_1614587720_IS_ACTIVE = TRUE; SET @MIGRATION_1614587720_IS_ACTIVE = TRUE; SET @MIGRATION_1616419772_IS_ACTIVE = TRUE; SET @MIGRATION_1617018765_IS_ACTIVE = TRUE; SET @MIGRATION_1618321583_IS_ACTIVE = TRUE; SET @MIGRATION_1620829074_IS_ACTIVE = TRUE; SET @MIGRATION_1621333785_IS_ACTIVE = TRUE; SET @MIGRATION_1621419761_IS_ACTIVE = TRUE; SET @MIGRATION_1625556996_IS_ACTIVE = TRUE; SET @MIGRATION_1626766063_IS_ACTIVE = TRUE; SET @MIGRATION_1636977354_IS_ACTIVE = TRUE; SET @MIGRATION_1637931476_IS_ACTIVE = TRUE; SET @MIGRATION_1638897517_IS_ACTIVE = TRUE; SET @MIGRATION_1640181713_IS_ACTIVE = TRUE; SET @MIGRATION_1641313633_IS_ACTIVE = TRUE; SET @MIGRATION_1642690994_IS_ACTIVE = TRUE; SET @MIGRATION_1643377802_IS_ACTIVE = TRUE; SET @MIGRATION_1645103528_IS_ACTIVE = TRUE; SET @MIGRATION_1645190845_IS_ACTIVE = TRUE; SET @MIGRATION_1648127351_IS_ACTIVE = TRUE; SET @MIGRATION_1648127352_IS_ACTIVE = TRUE; SET @MIGRATION_1649086118_IS_ACTIVE = TRUE; SET @MIGRATION_1649314350_IS_ACTIVE = TRUE; SET @MIGRATION_1649752132_IS_ACTIVE = TRUE; SET @MIGRATION_1649759025_IS_ACTIVE = TRUE; SET @MIGRATION_1657525411_IS_ACTIVE = TRUE; SET @MIGRATION_1658755075_IS_ACTIVE = TRUE; SET @MIGRATION_1660641567_IS_ACTIVE = TRUE; SET @MIGRATION_1662459808_IS_ACTIVE = TRUE; SET @MIGRATION_1663933707_IS_ACTIVE = TRUE; SET @MIGRATION_1666603279_IS_ACTIVE = TRUE; SET @MIGRATION_1668172778_IS_ACTIVE = TRUE; SET @MIGRATION_1668172779_IS_ACTIVE = TRUE; SET @MIGRATION_1668172780_IS_ACTIVE = TRUE; SET @MIGRATION_1675861056_IS_ACTIVE = TRUE; SET @MIGRATION_1677675478_IS_ACTIVE = TRUE; SET @MIGRATION_1677675479_IS_ACTIVE = TRUE; SET @MIGRATION_1679315873_IS_ACTIVE = TRUE; SET @MIGRATION_1679328661_IS_ACTIVE = TRUE; SET @MIGRATION_1679922535_IS_ACTIVE = TRUE; SET @MIGRATION_1680795351_IS_ACTIVE = TRUE; SET @MIGRATION_1681833563_IS_ACTIVE = TRUE; SET @MIGRATION_1682341260_IS_ACTIVE = TRUE; SET @MIGRATION_1683099227_IS_ACTIVE = TRUE; SET @MIGRATION_1683626781_IS_ACTIVE = TRUE; SET @MIGRATION_1688386008_IS_ACTIVE = TRUE; SET @MIGRATION_1689036093_IS_ACTIVE = TRUE; SET @MIGRATION_1620306767_IS_ACTIVE = TRUE; SET @MIGRATION_1620308350_IS_ACTIVE = TRUE; SET @MIGRATION_1657615865_IS_ACTIVE = TRUE; SET @MIGRATION_1660643832_IS_ACTIVE = TRUE; SET @MIGRATION_1613492839_IS_ACTIVE = TRUE; SET @MIGRATION_1613493472_IS_ACTIVE = TRUE; SET @MIGRATION_1613496348_IS_ACTIVE = TRUE; SET @MIGRATION_1621510875_IS_ACTIVE = TRUE; SET @MIGRATION_1622207125_IS_ACTIVE = TRUE; SET @MIGRATION_1631691913_IS_ACTIVE = TRUE; SET @MIGRATION_1633948279_IS_ACTIVE = TRUE; SET @MIGRATION_1637145145_IS_ACTIVE = TRUE; SET @MIGRATION_1667481867_IS_ACTIVE = TRUE; SET @MIGRATION_1677064840_IS_ACTIVE = TRUE; SET @MIGRATION_1677078498_IS_ACTIVE = TRUE; SET @MIGRATION_1679046988_IS_ACTIVE = TRUE; SET @MIGRATION_1649747949_IS_ACTIVE = TRUE; SET @MIGRATION_1664282874_IS_ACTIVE = TRUE; SET @MIGRATION_1669191282_IS_ACTIVE = TRUE; SET @MIGRATION_1669802571_IS_ACTIVE = TRUE; SET @MIGRATION_1672940274_IS_ACTIVE = TRUE; SET @MIGRATION_1676300213_IS_ACTIVE = TRUE; SET @MIGRATION_1680541382_IS_ACTIVE = TRUE; SET @MIGRATION_1681403103_IS_ACTIVE = TRUE; SET @MIGRATION_1681832217_IS_ACTIVE = TRUE; SET @MIGRATION_1686823602_IS_ACTIVE = TRUE; SET @MIGRATION_1688034601_IS_ACTIVE = TRUE; SET @MIGRATION_1617713528_IS_ACTIVE = TRUE; SET @MIGRATION_1554708925_IS_ACTIVE = TRUE; SET @MIGRATION_1710809734_IS_ACTIVE = TRUE; SET @MIGRATION_1628172267_IS_ACTIVE = TRUE; SET @MIGRATION_1644922949_IS_ACTIVE = TRUE; SET @MIGRATION_1688378836_IS_ACTIVE = TRUE; SET @MIGRATION_1589963718_IS_ACTIVE = TRUE; SET @MIGRATION_1619069101_IS_ACTIVE = TRUE; SET @MIGRATION_1623656945_IS_ACTIVE = TRUE; SET @MIGRATION_1623820553_IS_ACTIVE = TRUE; SET @MIGRATION_1624275180_IS_ACTIVE = TRUE; SET @MIGRATION_1633436214_IS_ACTIVE = TRUE; SET @MIGRATION_1598965635_IS_ACTIVE = TRUE; SET @MIGRATION_1606140637_IS_ACTIVE = TRUE; SET @MIGRATION_1626945611_IS_ACTIVE = TRUE; SET @MIGRATION_1663996974_IS_ACTIVE = TRUE; SET @MIGRATION_1571303196_IS_ACTIVE = TRUE; SET @MIGRATION_1575555505_IS_ACTIVE = TRUE; SET @MIGRATION_1582193703_IS_ACTIVE = TRUE; SET @MIGRATION_1591277478_IS_ACTIVE = TRUE; SET @MIGRATION_1603289196_IS_ACTIVE = TRUE; SET @MIGRATION_1608533666_IS_ACTIVE = TRUE; SET @MIGRATION_1614761861_IS_ACTIVE = TRUE; SET @MIGRATION_1617969653_IS_ACTIVE = TRUE; SET @MIGRATION_1562148231_IS_ACTIVE = TRUE; SET @MIGRATION_1562148246_IS_ACTIVE = TRUE; SET @MIGRATION_1563203721_IS_ACTIVE = TRUE; SET @MIGRATION_1570473516_IS_ACTIVE = TRUE; SET @MIGRATION_1570559540_IS_ACTIVE = TRUE; SET @MIGRATION_1570636494_IS_ACTIVE = TRUE; SET @MIGRATION_1571066783_IS_ACTIVE = TRUE; SET @MIGRATION_1572361168_IS_ACTIVE = TRUE; SET @MIGRATION_1574261053_IS_ACTIVE = TRUE; SET @MIGRATION_1575643478_IS_ACTIVE = TRUE; SET @MIGRATION_1579791730_IS_ACTIVE = TRUE; SET @MIGRATION_1582633686_IS_ACTIVE = TRUE; SET @MIGRATION_1603880098_IS_ACTIVE = TRUE; SET @MIGRATION_1604519974_IS_ACTIVE = TRUE; SET @MIGRATION_1607955053_IS_ACTIVE = TRUE; SET @MIGRATION_1613475319_IS_ACTIVE = TRUE; SET @MIGRATION_1614099957_IS_ACTIVE = TRUE; SET @MIGRATION_1632302999_IS_ACTIVE = TRUE; SET @MIGRATION_1638435166_IS_ACTIVE = TRUE; SET @MIGRATION_1642079844_IS_ACTIVE = TRUE; SET @MIGRATION_1708070947_IS_ACTIVE = TRUE; SET @MIGRATION_1572012839_IS_ACTIVE = TRUE; SET @MIGRATION_1572012863_IS_ACTIVE = TRUE; SET @MIGRATION_1572012872_IS_ACTIVE = TRUE; SET @MIGRATION_1572172912_IS_ACTIVE = TRUE; SET @MIGRATION_1573059308_IS_ACTIVE = TRUE; SET @MIGRATION_1574260096_IS_ACTIVE = TRUE; SET @MIGRATION_1596724410_IS_ACTIVE = TRUE; SET @MIGRATION_1602017170_IS_ACTIVE = TRUE SET @@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_1605167857_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_1675420139_IS_ACTIVE = TRUE;SET @MIGRATION_1675155788_IS_ACTIVE = TRUE;SET @MIGRATION_1684315483_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205551_IS_ACTIVE = TRUE;SET @MIGRATION_1580205552_IS_ACTIVE = TRUE;SET @MIGRATION_1603787192_IS_ACTIVE = TRUE;SET @MIGRATION_1603787193_IS_ACTIVE = TRUE;SET @MIGRATION_1608909056_IS_ACTIVE = TRUE;SET @MIGRATION_1608909057_IS_ACTIVE = TRUE;SET @MIGRATION_1608909058_IS_ACTIVE = TRUE;SET @MIGRATION_1609840337_IS_ACTIVE = TRUE;SET @MIGRATION_1609840338_IS_ACTIVE = TRUE;SET @MIGRATION_1610290148_IS_ACTIVE = TRUE;SET @MIGRATION_1615974752_IS_ACTIVE = TRUE;SET @MIGRATION_1615974753_IS_ACTIVE = TRUE;SET @MIGRATION_1615974754_IS_ACTIVE = TRUE;SET @MIGRATION_1616854566_IS_ACTIVE = TRUE;SET @MIGRATION_1641641753_IS_ACTIVE = TRUE;SET @MIGRATION_1652087759_IS_ACTIVE = TRUE;SET @MIGRATION_1652087760_IS_ACTIVE = TRUE;SET @MIGRATION_1556014423_IS_ACTIVE = TRUE;SET @MIGRATION_1556014424_IS_ACTIVE = TRUE;SET @MIGRATION_1556118797_IS_ACTIVE = TRUE;SET @MIGRATION_1584965609_IS_ACTIVE = TRUE;SET @MIGRATION_1586186442_IS_ACTIVE = TRUE;SET @MIGRATION_1586202227_IS_ACTIVE = TRUE;SET @MIGRATION_1589893337_IS_ACTIVE = TRUE;SET @MIGRATION_1592244872_IS_ACTIVE = TRUE;SET @MIGRATION_1592991551_IS_ACTIVE = TRUE;SET @MIGRATION_1593514482_IS_ACTIVE = TRUE;SET @MIGRATION_1594822086_IS_ACTIVE = TRUE;SET @MIGRATION_1595323759_IS_ACTIVE = TRUE;SET @MIGRATION_1596645397_IS_ACTIVE = TRUE;SET @MIGRATION_1596646072_IS_ACTIVE = TRUE;SET @MIGRATION_1597838146_IS_ACTIVE = TRUE;SET @MIGRATION_1599039841_IS_ACTIVE = TRUE;SET @MIGRATION_1600096104_IS_ACTIVE = TRUE;SET @MIGRATION_1600420898_IS_ACTIVE = TRUE;SET @MIGRATION_1601043196_IS_ACTIVE = TRUE;SET @MIGRATION_1607589490_IS_ACTIVE = TRUE;SET @MIGRATION_1607589491_IS_ACTIVE = TRUE;SET @MIGRATION_1607589492_IS_ACTIVE = TRUE;SET @MIGRATION_1610376590_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1614587720_IS_ACTIVE = TRUE;SET @MIGRATION_1616419772_IS_ACTIVE = TRUE;SET @MIGRATION_1617018765_IS_ACTIVE = TRUE;SET @MIGRATION_1618321583_IS_ACTIVE = TRUE;SET @MIGRATION_1620829074_IS_ACTIVE = TRUE;SET @MIGRATION_1621333785_IS_ACTIVE = TRUE;SET @MIGRATION_1621419761_IS_ACTIVE = TRUE;SET @MIGRATION_1625556996_IS_ACTIVE = TRUE;SET @MIGRATION_1626766063_IS_ACTIVE = TRUE;SET @MIGRATION_1636977354_IS_ACTIVE = TRUE;SET @MIGRATION_1637931476_IS_ACTIVE = TRUE;SET @MIGRATION_1638897517_IS_ACTIVE = TRUE;SET @MIGRATION_1640181713_IS_ACTIVE = TRUE;SET @MIGRATION_1641313633_IS_ACTIVE = TRUE;SET @MIGRATION_1642690994_IS_ACTIVE = TRUE;SET @MIGRATION_1643377802_IS_ACTIVE = TRUE;SET @MIGRATION_1645103528_IS_ACTIVE = TRUE;SET @MIGRATION_1645190845_IS_ACTIVE = TRUE;SET @MIGRATION_1648127351_IS_ACTIVE = TRUE;SET @MIGRATION_1648127352_IS_ACTIVE = TRUE;SET @MIGRATION_1649086118_IS_ACTIVE = TRUE;SET @MIGRATION_1649314350_IS_ACTIVE = TRUE;SET @MIGRATION_1649752132_IS_ACTIVE = TRUE;SET @MIGRATION_1649759025_IS_ACTIVE = TRUE;SET @MIGRATION_1657525411_IS_ACTIVE = TRUE;SET @MIGRATION_1658755075_IS_ACTIVE = TRUE;SET @MIGRATION_1660641567_IS_ACTIVE = TRUE;SET @MIGRATION_1662459808_IS_ACTIVE = TRUE;SET @MIGRATION_1663933707_IS_ACTIVE = TRUE;SET @MIGRATION_1666603279_IS_ACTIVE = TRUE;SET @MIGRATION_1668172778_IS_ACTIVE = TRUE;SET @MIGRATION_1668172779_IS_ACTIVE = TRUE;SET @MIGRATION_1668172780_IS_ACTIVE = TRUE;SET @MIGRATION_1675861056_IS_ACTIVE = TRUE;SET @MIGRATION_1677675478_IS_ACTIVE = TRUE;SET @MIGRATION_1677675479_IS_ACTIVE = TRUE;SET @MIGRATION_1679315873_IS_ACTIVE = TRUE;SET @MIGRATION_1679328661_IS_ACTIVE = TRUE;SET @MIGRATION_1679922535_IS_ACTIVE = TRUE;SET @MIGRATION_1680795351_IS_ACTIVE = TRUE;SET @MIGRATION_1681833563_IS_ACTIVE = TRUE;SET @MIGRATION_1682341260_IS_ACTIVE = TRUE;SET @MIGRATION_1683099227_IS_ACTIVE = TRUE;SET @MIGRATION_1683626781_IS_ACTIVE = TRUE;SET @MIGRATION_1688386008_IS_ACTIVE = TRUE;SET @MIGRATION_1689036093_IS_ACTIVE = TRUE;SET @MIGRATION_1620306767_IS_ACTIVE = TRUE;SET @MIGRATION_1620308350_IS_ACTIVE = TRUE;SET @MIGRATION_1657615865_IS_ACTIVE = TRUE;SET @MIGRATION_1660643832_IS_ACTIVE = TRUE;SET @MIGRATION_1613492839_IS_ACTIVE = TRUE;SET @MIGRATION_1613493472_IS_ACTIVE = TRUE;SET @MIGRATION_1613496348_IS_ACTIVE = TRUE;SET @MIGRATION_1621510875_IS_ACTIVE = TRUE;SET @MIGRATION_1622207125_IS_ACTIVE = TRUE;SET @MIGRATION_1631691913_IS_ACTIVE = TRUE;SET @MIGRATION_1633948279_IS_ACTIVE = TRUE;SET @MIGRATION_1637145145_IS_ACTIVE = TRUE;SET @MIGRATION_1667481867_IS_ACTIVE = TRUE;SET @MIGRATION_1677064840_IS_ACTIVE = TRUE;SET @MIGRATION_1677078498_IS_ACTIVE = TRUE;SET @MIGRATION_1679046988_IS_ACTIVE = TRUE;SET @MIGRATION_1649747949_IS_ACTIVE = TRUE;SET @MIGRATION_1664282874_IS_ACTIVE = TRUE;SET @MIGRATION_1669191282_IS_ACTIVE = TRUE;SET @MIGRATION_1669802571_IS_ACTIVE = TRUE;SET @MIGRATION_1672940274_IS_ACTIVE = TRUE;SET @MIGRATION_1676300213_IS_ACTIVE = TRUE;SET @MIGRATION_1680541382_IS_ACTIVE = TRUE;SET @MIGRATION_1681403103_IS_ACTIVE = TRUE;SET @MIGRATION_1681832217_IS_ACTIVE = TRUE;SET @MIGRATION_1686823602_IS_ACTIVE = TRUE;SET @MIGRATION_1688034601_IS_ACTIVE = TRUE;SET @MIGRATION_1617713528_IS_ACTIVE = TRUE;SET @MIGRATION_1554708925_IS_ACTIVE = TRUE;SET @MIGRATION_1710809734_IS_ACTIVE = TRUE;SET @MIGRATION_1628172267_IS_ACTIVE = TRUE;SET @MIGRATION_1644922949_IS_ACTIVE = TRUE;SET @MIGRATION_1688378836_IS_ACTIVE = TRUE;SET @MIGRATION_1589963718_IS_ACTIVE = TRUE;SET @MIGRATION_1619069101_IS_ACTIVE = TRUE;SET @MIGRATION_1623656945_IS_ACTIVE = TRUE;SET @MIGRATION_1623820553_IS_ACTIVE = TRUE;SET @MIGRATION_1624275180_IS_ACTIVE = TRUE;SET @MIGRATION_1633436214_IS_ACTIVE = TRUE;SET @MIGRATION_1598965635_IS_ACTIVE = TRUE;SET @MIGRATION_1606140637_IS_ACTIVE = TRUE;SET @MIGRATION_1626945611_IS_ACTIVE = TRUE;SET @MIGRATION_1663996974_IS_ACTIVE = TRUE;SET @MIGRATION_1571303196_IS_ACTIVE = TRUE;SET @MIGRATION_1575555505_IS_ACTIVE = TRUE;SET @MIGRATION_1582193703_IS_ACTIVE = TRUE;SET @MIGRATION_1591277478_IS_ACTIVE = TRUE;SET @MIGRATION_1603289196_IS_ACTIVE = TRUE;SET @MIGRATION_1608533666_IS_ACTIVE = TRUE;SET @MIGRATION_1614761861_IS_ACTIVE = TRUE;SET @MIGRATION_1617969653_IS_ACTIVE = TRUE;SET @MIGRATION_1562148231_IS_ACTIVE = TRUE;SET @MIGRATION_1562148246_IS_ACTIVE = TRUE;SET @MIGRATION_1563203721_IS_ACTIVE = TRUE;SET @MIGRATION_1570473516_IS_ACTIVE = TRUE;SET @MIGRATION_1570559540_IS_ACTIVE = TRUE;SET @MIGRATION_1570636494_IS_ACTIVE = TRUE;SET @MIGRATION_1571066783_IS_ACTIVE = TRUE;SET @MIGRATION_1572361168_IS_ACTIVE = TRUE;SET @MIGRATION_1574261053_IS_ACTIVE = TRUE;SET @MIGRATION_1575643478_IS_ACTIVE = TRUE;SET @MIGRATION_1579791730_IS_ACTIVE = TRUE;SET @MIGRATION_1582633686_IS_ACTIVE = TRUE;SET @MIGRATION_1603880098_IS_ACTIVE = TRUE;SET @MIGRATION_1604519974_IS_ACTIVE = TRUE;SET @MIGRATION_1607955053_IS_ACTIVE = TRUE;SET @MIGRATION_1613475319_IS_ACTIVE = TRUE;SET @MIGRATION_1614099957_IS_ACTIVE = TRUE;SET @MIGRATION_1632302999_IS_ACTIVE = TRUE;SET @MIGRATION_1638435166_IS_ACTIVE = TRUE;SET @MIGRATION_1642079844_IS_ACTIVE = TRUE;SET @MIGRATION_1708070947_IS_ACTIVE = TRUE;SET @MIGRATION_1572012839_IS_ACTIVE = TRUE;SET @MIGRATION_1572012863_IS_ACTIVE = TRUE;SET @MIGRATION_1572012872_IS_ACTIVE = TRUE;SET @MIGRATION_1572172912_IS_ACTIVE = TRUE;SET @MIGRATION_1573059308_IS_ACTIVE = TRUE;SET @MIGRATION_1574260096_IS_ACTIVE = TRUE;SET @MIGRATION_1596724410_IS_ACTIVE = TRUE;SET @MIGRATION_1602017170_IS_ACTIVE = TRUE; array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 399)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 198)" 3 => "Shopware\Core\Kernel::boot (line 127)" 4 => "Shopware\Core\HttpKernel::doHandle (line 79)" 5 => "Shopware\Core\HttpKernel::handle (line 85)"`]
0.85 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:14 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 52)" 3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 36)" 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 41)" 7 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 37)" 8 => "Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader::load (line 81)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 60)" 10 => "Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator::get (line 39)" 11 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 138)" 12 => "Shopware\Core\HttpKernel::doHandle (line 79)" 13 => "Shopware\Core\HttpKernel::handle (line 85)"]
0.52 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:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 684)" 2 => "Doctrine\DBAL\Connection::fetchAssociative (line 330)" 3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 57)" 4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 71)" 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 54)" 10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 99)" 11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)" 12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 38)" 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 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 23 => "Shopware\Core\HttpKernel::doHandle (line 79)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]
1.11 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_01bd24c8ffd94532a5deab6eb368da38) 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_01bd24c8ffd94532a5deab6eb368da38 ) 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) = 'uHzSjykQ4O3IDiL7cXUi7zPuQQZJJGKf'); array:22 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 314)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 146)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 91)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 256)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 285)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)" 9 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 178)" 10 => "Swag\PayPal\Webhook\WebhookController::validateShopwareToken (line 101)" 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 86)" 15 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 20 => "Shopware\Core\HttpKernel::doHandle (line 79)" 21 => "Shopware\Core\HttpKernel::handle (line 85)"]
5.93 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 (`order_transaction`.`id` IN (:ids)) 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 ( `order_transaction`.`id` IN (: ids) ) 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 (`order_transaction`.`id` IN (0x0192D9E0999C71A7AD4166B4D273C8DF)); array:25 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 252)" 2 => "Doctrine\DBAL\Query\QueryBuilder::executeQuery (line 314)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 146)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 91)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 256)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 285)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 105)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 44)" 9 => "Swag\PayPal\Util\Compatibility\EntityRepositoryDecorator::search (line 100)" 10 => "Swag\PayPal\Webhook\Handler\AbstractWebhookHandler::getOrderTransactionV2 (line 51)" 11 => "Swag\PayPal\Webhook\Handler\CaptureCompleted::invoke (line 111)" 12 => "Swag\PayPal\Webhook\WebhookService::executeWebhook (line 142)" 13 => "Swag\PayPal\Webhook\WebhookController::tryToExecuteWebhook (line 104)" 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 86)" 18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)" 19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)" 20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)" 21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)" 22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 154)" 23 => "Shopware\Core\HttpKernel::doHandle (line 79)" 24 => "Shopware\Core\HttpKernel::handle (line 85)"]

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