| 1 |
1.12 ms |
SELECT `creation_timestamp`
FROM `migration`
WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
SELECT `creation_timestamp`
FROM `migration`
WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 360)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 198)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 2 |
0.73 ms |
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_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_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_1566896378_IS_ACTIVE = TRUE;SET @MIGRATION_1579597261_IS_ACTIVE = TRUE;SET @MIGRATION_1580742497_IS_ACTIVE = TRUE;SET @MIGRATION_1584020367_IS_ACTIVE = TRUE;SET @MIGRATION_1584615734_IS_ACTIVE = TRUE;SET @MIGRATION_1588138609_IS_ACTIVE = TRUE;SET @MIGRATION_1597841941_IS_ACTIVE = TRUE;SET @MIGRATION_1603726376_IS_ACTIVE = TRUE;SET @MIGRATION_1620989898_IS_ACTIVE = TRUE;SET @MIGRATION_1621518771_IS_ACTIVE = TRUE;SET @MIGRATION_1634193548_IS_ACTIVE = TRUE;SET @MIGRATION_1652779309_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1572944593_IS_ACTIVE = TRUE;SET @MIGRATION_1573045796_IS_ACTIVE = TRUE;SET @MIGRATION_1573135374_IS_ACTIVE = TRUE;SET @MIGRATION_1573139562_IS_ACTIVE = TRUE;SET @MIGRATION_1573140186_IS_ACTIVE = TRUE;SET @MIGRATION_1573209317_IS_ACTIVE = TRUE;SET @MIGRATION_1573209481_IS_ACTIVE = TRUE;SET @MIGRATION_1574072727_IS_ACTIVE = TRUE;SET @MIGRATION_1576497438_IS_ACTIVE = TRUE;SET @MIGRATION_1576497500_IS_ACTIVE = TRUE;SET @MIGRATION_1576503670_IS_ACTIVE = TRUE;SET @MIGRATION_1576505995_IS_ACTIVE = TRUE;SET @MIGRATION_1577972394_IS_ACTIVE = TRUE;SET @MIGRATION_1578049087_IS_ACTIVE = TRUE;SET @MIGRATION_1578066584_IS_ACTIVE = TRUE;SET @MIGRATION_1584096712_IS_ACTIVE = TRUE;SET @MIGRATION_1585054485_IS_ACTIVE = TRUE;SET @MIGRATION_1585055462_IS_ACTIVE = TRUE;SET @MIGRATION_1587976714_IS_ACTIVE = TRUE;SET @MIGRATION_1587988241_IS_ACTIVE = TRUE;SET @MIGRATION_1592301104_IS_ACTIVE = TRUE;SET @MIGRATION_1602233999_IS_ACTIVE = TRUE;SET @MIGRATION_1602832962_IS_ACTIVE = TRUE;SET @MIGRATION_1607683101_IS_ACTIVE = TRUE;SET @MIGRATION_1611068135_IS_ACTIVE = TRUE;SET @MIGRATION_1614764106_IS_ACTIVE = TRUE;SET @MIGRATION_1625817765_IS_ACTIVE = TRUE;SET @MIGRATION_1630049295_IS_ACTIVE = TRUE;SET @MIGRATION_1636367162_IS_ACTIVE = TRUE;SET @MIGRATION_1642147726_IS_ACTIVE = TRUE;SET @MIGRATION_1646304817_IS_ACTIVE = TRUE;SET @MIGRATION_1648797644_IS_ACTIVE = TRUE;SET @MIGRATION_1649245702_IS_ACTIVE = TRUE;SET @MIGRATION_1652692175_IS_ACTIVE = TRUE;SET @MIGRATION_1653310700_IS_ACTIVE = TRUE;SET @MIGRATION_1653661469_IS_ACTIVE = TRUE;SET @MIGRATION_1680157673_IS_ACTIVE = TRUE;SET @MIGRATION_1688639650_IS_ACTIVE = TRUE;SET @MIGRATION_1689061373_IS_ACTIVE = TRUE;SET @MIGRATION_1701076963_IS_ACTIVE = TRUE;SET @MIGRATION_1718713101_IS_ACTIVE = TRUE;SET @MIGRATION_1718877324_IS_ACTIVE = TRUE;SET @MIGRATION_1722868766_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_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1713775973_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_1685001455_IS_ACTIVE = TRUE;SET @MIGRATION_1588258673_IS_ACTIVE = TRUE;SET @MIGRATION_1589948636_IS_ACTIVE = TRUE;SET @MIGRATION_1618237906_IS_ACTIVE = TRUE;SET @MIGRATION_1635163959_IS_ACTIVE = TRUE;SET @MIGRATION_1639122022_IS_ACTIVE = TRUE;SET @MIGRATION_1648194406_IS_ACTIVE = TRUE;SET @MIGRATION_1660282524_IS_ACTIVE = TRUE;SET @MIGRATION_1671547783_IS_ACTIVE = TRUE;SET @MIGRATION_1673874594_IS_ACTIVE = TRUE
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET @MIGRATION_1611155140_IS_ACTIVE = TRUE;SET @MIGRATION_1638993987_IS_ACTIVE = TRUE;SET @MIGRATION_1642732351_IS_ACTIVE = TRUE;SET @MIGRATION_1643878976_IS_ACTIVE = TRUE;SET @MIGRATION_1643892702_IS_ACTIVE = TRUE;SET @MIGRATION_1646397836_IS_ACTIVE = TRUE;SET @MIGRATION_1647511158_IS_ACTIVE = TRUE;SET @MIGRATION_1648543185_IS_ACTIVE = TRUE;SET @MIGRATION_1648709176_IS_ACTIVE = TRUE;SET @MIGRATION_1650249241_IS_ACTIVE = TRUE;SET @MIGRATION_1650444800_IS_ACTIVE = TRUE;SET @MIGRATION_1650548599_IS_ACTIVE = TRUE;SET @MIGRATION_1650872291_IS_ACTIVE = TRUE;SET @MIGRATION_1650981517_IS_ACTIVE = TRUE;SET @MIGRATION_1652166447_IS_ACTIVE = TRUE;SET @MIGRATION_1652345915_IS_ACTIVE = TRUE;SET @MIGRATION_1652864153_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_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_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_1566896378_IS_ACTIVE = TRUE;SET @MIGRATION_1579597261_IS_ACTIVE = TRUE;SET @MIGRATION_1580742497_IS_ACTIVE = TRUE;SET @MIGRATION_1584020367_IS_ACTIVE = TRUE;SET @MIGRATION_1584615734_IS_ACTIVE = TRUE;SET @MIGRATION_1588138609_IS_ACTIVE = TRUE;SET @MIGRATION_1597841941_IS_ACTIVE = TRUE;SET @MIGRATION_1603726376_IS_ACTIVE = TRUE;SET @MIGRATION_1620989898_IS_ACTIVE = TRUE;SET @MIGRATION_1621518771_IS_ACTIVE = TRUE;SET @MIGRATION_1634193548_IS_ACTIVE = TRUE;SET @MIGRATION_1652779309_IS_ACTIVE = TRUE;SET @MIGRATION_1574344300_IS_ACTIVE = TRUE;SET @MIGRATION_1605167857_IS_ACTIVE = TRUE;SET @MIGRATION_1572944593_IS_ACTIVE = TRUE;SET @MIGRATION_1573045796_IS_ACTIVE = TRUE;SET @MIGRATION_1573135374_IS_ACTIVE = TRUE;SET @MIGRATION_1573139562_IS_ACTIVE = TRUE;SET @MIGRATION_1573140186_IS_ACTIVE = TRUE;SET @MIGRATION_1573209317_IS_ACTIVE = TRUE;SET @MIGRATION_1573209481_IS_ACTIVE = TRUE;SET @MIGRATION_1574072727_IS_ACTIVE = TRUE;SET @MIGRATION_1576497438_IS_ACTIVE = TRUE;SET @MIGRATION_1576497500_IS_ACTIVE = TRUE;SET @MIGRATION_1576503670_IS_ACTIVE = TRUE;SET @MIGRATION_1576505995_IS_ACTIVE = TRUE;SET @MIGRATION_1577972394_IS_ACTIVE = TRUE;SET @MIGRATION_1578049087_IS_ACTIVE = TRUE;SET @MIGRATION_1578066584_IS_ACTIVE = TRUE;SET @MIGRATION_1584096712_IS_ACTIVE = TRUE;SET @MIGRATION_1585054485_IS_ACTIVE = TRUE;SET @MIGRATION_1585055462_IS_ACTIVE = TRUE;SET @MIGRATION_1587976714_IS_ACTIVE = TRUE;SET @MIGRATION_1587988241_IS_ACTIVE = TRUE;SET @MIGRATION_1592301104_IS_ACTIVE = TRUE;SET @MIGRATION_1602233999_IS_ACTIVE = TRUE;SET @MIGRATION_1602832962_IS_ACTIVE = TRUE;SET @MIGRATION_1607683101_IS_ACTIVE = TRUE;SET @MIGRATION_1611068135_IS_ACTIVE = TRUE;SET @MIGRATION_1614764106_IS_ACTIVE = TRUE;SET @MIGRATION_1625817765_IS_ACTIVE = TRUE;SET @MIGRATION_1630049295_IS_ACTIVE = TRUE;SET @MIGRATION_1636367162_IS_ACTIVE = TRUE;SET @MIGRATION_1642147726_IS_ACTIVE = TRUE;SET @MIGRATION_1646304817_IS_ACTIVE = TRUE;SET @MIGRATION_1648797644_IS_ACTIVE = TRUE;SET @MIGRATION_1649245702_IS_ACTIVE = TRUE;SET @MIGRATION_1652692175_IS_ACTIVE = TRUE;SET @MIGRATION_1653310700_IS_ACTIVE = TRUE;SET @MIGRATION_1653661469_IS_ACTIVE = TRUE;SET @MIGRATION_1680157673_IS_ACTIVE = TRUE;SET @MIGRATION_1688639650_IS_ACTIVE = TRUE;SET @MIGRATION_1689061373_IS_ACTIVE = TRUE;SET @MIGRATION_1701076963_IS_ACTIVE = TRUE;SET @MIGRATION_1718713101_IS_ACTIVE = TRUE;SET @MIGRATION_1718877324_IS_ACTIVE = TRUE;SET @MIGRATION_1722868766_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_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586273_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1578586333_IS_ACTIVE = TRUE;SET @MIGRATION_1585666208_IS_ACTIVE = TRUE;SET @MIGRATION_1585666268_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834145_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1592834205_IS_ACTIVE = TRUE;SET @MIGRATION_1590657517_IS_ACTIVE = TRUE;SET @MIGRATION_1651494367_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1713775973_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_1685001455_IS_ACTIVE = TRUE;SET @MIGRATION_1588258673_IS_ACTIVE = TRUE;SET @MIGRATION_1589948636_IS_ACTIVE = TRUE;SET @MIGRATION_1618237906_IS_ACTIVE = TRUE;SET @MIGRATION_1635163959_IS_ACTIVE = TRUE;SET @MIGRATION_1639122022_IS_ACTIVE = TRUE;SET @MIGRATION_1648194406_IS_ACTIVE = TRUE;SET @MIGRATION_1660282524_IS_ACTIVE = TRUE;SET @MIGRATION_1671547783_IS_ACTIVE = TRUE;SET @MIGRATION_1673874594_IS_ACTIVE = TRUE;
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 393)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 198)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 3 |
1.43 ms |
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 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 52)"
3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 36)"
4 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::Shopware\Core\System\SystemConfig\{closure} (line 70)"
5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 33)"
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 74)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 36)"
10 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 137)"
11 => "Shopware\Core\HttpKernel::doHandle (line 79)"
12 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 4 |
0.86 ms |
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 616)"
2 => "Doctrine\DBAL\Connection::fetchAssoc (line 321)"
3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 61)"
4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 68)"
5 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
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 51)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 140)"
15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
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 153)"
23 => "Shopware\Core\HttpKernel::doHandle (line 79)"
24 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 5 |
0.99 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '3868264_6791cf37bab732.74077997') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Process') AND (p.index_1 = '3868264_6791cf37bab732.74077997') LIMIT 1;
array:17 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 100)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
6 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
7 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
8 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
9 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
10 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
11 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
12 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
13 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
14 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
15 => "Shopware\Core\HttpKernel::doHandle (line 79)"
16 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 6 |
0.82 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042) LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042) LIMIT 1;
array:20 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 388)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::find (line 162)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::fetchItem (line 95)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
9 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
10 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
11 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
12 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
13 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
14 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
15 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
18 => "Shopware\Core\HttpKernel::doHandle (line 79)"
19 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 7 |
0.43 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
array:30 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 127)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::isDefaultLoggerEnabled (line 75)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\LoggerConfiguration::isDefaultLoggerEnabled (line 133)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 94)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
13 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
19 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
22 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
23 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
28 => "Shopware\Core\HttpKernel::doHandle (line 79)"
29 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 8 |
0.43 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 131)"
8 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevelUser (line 121)"
9 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevel (line 45)"
10 => "Crsw\CleverReachOfficial\Service\Infrastructure\LoggerService::logMessage (line 138)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 94)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 9 |
0.40 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 151)"
8 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevelGlobal (line 121)"
9 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevel (line 45)"
10 => "Crsw\CleverReachOfficial\Service\Infrastructure\LoggerService::logMessage (line 138)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 94)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 10 |
0.62 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
array:32 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 344)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getHttpConfigurationOptions (line 254)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::getAdditionalOptions (line 394)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::adjustUrlIfNeeded (line 236)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::setCurlSessionUrlHeadersAndBody (line 193)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::setCurlSessionAndCommonRequestParts (line 71)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::sendHttpRequest (line 98)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
18 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
21 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
23 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
24 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
25 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
30 => "Shopware\Core\HttpKernel::doHandle (line 79)"
31 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 11 |
0.40 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'syncRequestTimeout') LIMIT 1;
array:29 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 448)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getSyncRequestTimeout (line 277)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::setCurlSessionOptionsForSynchronousRequest (line 72)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::sendHttpRequest (line 98)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
12 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
13 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
18 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
21 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
22 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
27 => "Shopware\Core\HttpKernel::doHandle (line 79)"
28 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 12 |
0.40 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'httpConfigurationOptions') LIMIT 1;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 344)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getHttpConfigurationOptions (line 254)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::getAdditionalOptions (line 308)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::setCurlSessionOptionsFromConfiguration (line 297)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::setCurlOptions (line 73)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\CurlHttpClient::sendHttpRequest (line 98)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 13 |
2.76 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'defaultLoggerEnabled') LIMIT 1;
array:30 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 127)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::isDefaultLoggerEnabled (line 75)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\LoggerConfiguration::isDefaultLoggerEnabled (line 133)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 107)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
13 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
19 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
22 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
23 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
28 => "Shopware\Core\HttpKernel::doHandle (line 79)"
29 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 14 |
6.51 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevel') LIMIT 1;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 131)"
8 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevelUser (line 121)"
9 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevel (line 45)"
10 => "Crsw\CleverReachOfficial\Service\Infrastructure\LoggerService::logMessage (line 138)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 107)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 15 |
0.46 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Configuration') AND (p.index_1 = 'minLogLevelGlobal') LIMIT 1;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 125)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigEntity (line 71)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\ConfigurationManager::getConfigValue (line 496)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\Configuration\Configuration::getConfigValue (line 151)"
8 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevelGlobal (line 121)"
9 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Configuration\Configuration::getMinLogLevel (line 45)"
10 => "Crsw\CleverReachOfficial\Service\Infrastructure\LoggerService::logMessage (line 138)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logMessage (line 109)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\Logger\Logger::logDebug (line 107)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\Http\HttpClient::request (line 169)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::call (line 67)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Http\Proxy::get (line 30)"
16 => "Crsw\CleverReachOfficial\Core\BusinessLogic\API\Http\Proxy::isAPIActive (line 125)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::validateExecutionRequirements (line 113)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 16 |
0.71 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042 AND p.index_1 = 'queued' AND p.index_7 IS NULL) LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042 AND p.index_1 = 'queued' AND p.index_7 IS NULL) LIMIT 1;
array:23 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 128)"
5 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
6 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
9 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
12 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
13 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
14 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
15 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
16 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
21 => "Shopware\Core\HttpKernel::doHandle (line 79)"
22 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 17 |
1.99 ms |
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = :param_0b52a0a86de245d6827fda73e49716df)
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = '397042');
array:28 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 153)"
9 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
10 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
15 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
17 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
20 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
21 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
26 => "Shopware\Core\HttpKernel::doHandle (line 79)"
27 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 18 |
0.62 ms |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id;
array:31 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 26)"
3 => "Shopware\Core\System\Language\LanguageLoader::loadLanguages (line 36)"
4 => "Shopware\Core\System\Language\CachedLanguageLoader::Shopware\Core\System\Language\{closure} (line 70)"
5 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::doGet (line 33)"
6 => "Shopware\Core\Framework\Adapter\Cache\CacheDecorator::get (line 37)"
7 => "Shopware\Core\System\Language\CachedLanguageLoader::loadLanguages (line 188)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
12 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
13 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
14 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
15 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
17 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
20 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
21 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
22 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
23 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
24 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
27 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
29 => "Shopware\Core\HttpKernel::doHandle (line 79)"
30 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 19 |
0.49 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (0x8BFD4889C6344A959C1954E40DA24709);
array:28 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 379)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetch (line 98)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetchExistences (line 193)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
9 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
10 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
14 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
15 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
17 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
20 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
21 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
26 => "Shopware\Core\HttpKernel::doHandle (line 79)"
27 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 20 |
0.37 ms |
"START TRANSACTION"
array:29 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1743)"
1 => "Doctrine\DBAL\Connection::beginTransaction (line 1668)"
2 => "Doctrine\DBAL\Connection::transactional (line 30)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
10 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
12 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
18 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
21 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
22 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
27 => "Shopware\Core\HttpKernel::doHandle (line 79)"
28 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 21 |
1.60 ms |
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `index_3` = ?, `index_4` = ?, `index_5` = ?, `index_6` = ?, `index_7` = ?, `index_8` = ?, `index_9` = ?, `data` = ? WHERE shopware_id = ?
UPDATE `cleverreach_entity` SET `type` = 'QueueItem', `index_1` = 'in_progress', `index_2` = 'ScheduleCheckTask', `index_3` = 'Schedule', `index_4` = NULL, `index_5` = '1737609014', `index_6` = '00000000000', `index_7` = '01737609016', `index_8` = '00000000100', `index_9` = '5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487', `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\TaskExecution\\\\QueueItem\",\"id\":\"397042\",\"status\":\"in_progress\",\"context\":\"\",\"serializedTask\":\"{\\\"class_name\\\":\\\"Crsw\\\\\\\\CleverReachOfficial\\\\\\\\Core\\\\\\\\BusinessLogic\\\\\\\\Scheduler\\\\\\\\ScheduleCheckTask\\\"}\",\"queueName\":\"Schedule\",\"lastExecutionProgressBasePoints\":0,\"progressBasePoints\":0,\"retries\":0,\"failureDescription\":\"\",\"createTime\":\"2025-01-23T05:10:14+00:00\",\"startTime\":\"2025-01-23T05:10:16+00:00\",\"finishTime\":null,\"failTime\":null,\"earliestStartTime\":null,\"queueTime\":\"2025-01-23T05:10:14+00:00\",\"lastUpdateTime\":\"2025-01-23T05:10:16+00:00\",\"priority\":100,\"equalityHash\":\"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487\"}' WHERE shopware_id = 0x8BFD4889C6344A959C1954E40DA24709;
array:35 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1546)"
1 => "Doctrine\DBAL\Connection::executeStatement (line 894)"
2 => "Doctrine\DBAL\Connection::update (line 233)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 81)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 63)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 235)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 134)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)"
8 => "Doctrine\DBAL\Connection::transactional (line 30)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
13 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
14 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
21 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
24 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 22 |
6.49 ms |
"COMMIT"
array:29 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1789)"
1 => "Doctrine\DBAL\Connection::commit (line 1671)"
2 => "Doctrine\DBAL\Connection::transactional (line 30)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
10 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
12 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
18 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
21 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
22 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
27 => "Shopware\Core\HttpKernel::doHandle (line 79)"
28 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 23 |
0.82 ms |
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> :param_098fc0f6843c43b4b982bd04ddd94930)
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> NULL);
array:43 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 216)"
9 => "DreiscSeoPro\Core\Foundation\Dal\EntityRepository::search (line 161)"
10 => "DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService::fetchCustomSettingsBySalesChannelId (line 115)"
11 => "DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService::load (line 43)"
12 => "DreiscSeoPro\Core\CustomSetting\CustomSettingLoader::load (line 97)"
13 => "DreiscSeoPro\Core\Content\Category\CategoryIndexer::update (line 117)"
14 => "Shopware\Core\Framework\DataAbstractionLayer\Indexing\EntityIndexerRegistry::refresh (line 117)"
15 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
16 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
17 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
18 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
19 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
20 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
21 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
22 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
23 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
24 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
25 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
26 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
27 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
29 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
30 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
31 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
32 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
33 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
34 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
35 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
36 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
40 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
41 => "Shopware\Core\HttpKernel::doHandle (line 79)"
42 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 24 |
1.95 ms |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_67a5242062c04008b37848851483eab2)
SELECT
`app`.`id` as `app.id`,
`app`.`name` as `app.name`,
`app`.`path` as `app.path`,
`app`.`author` as `app.author`,
`app`.`copyright` as `app.copyright`,
`app`.`license` as `app.license`,
`app`.`active` as `app.active`,
`app`.`configurable` as `app.configurable`,
`app`.`privacy` as `app.privacy`,
`app`.`version` as `app.version`,
`app`.`icon` as `app.iconRaw`,
`app`.`app_secret` as `app.appSecret`,
`app`.`modules` as `app.modules`,
`app`.`main_module` as `app.mainModule`,
`app`.`cookies` as `app.cookies`,
`app`.`allow_disable` as `app.allowDisable`,
`app`.`base_app_url` as `app.baseAppUrl`,
`app`.`allowed_hosts` as `app.allowedHosts`,
`app`.`template_load_priority` as `app.templateLoadPriority`,
`app`.`integration_id` as `app.integrationId`,
`app.integration`.`id` as `app.integration.id`,
`app.integration`.`label` as `app.integration.label`,
`app.integration`.`access_key` as `app.integration.accessKey`,
`app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
`app.integration`.`write_access` as `app.integration.writeAccess`,
`app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
`app.integration`.`admin` as `app.integration.admin`,
`app.integration`.`custom_fields` as `app.integration.customFields`,
`app.integration`.`deleted_at` as `app.integration.deletedAt`,
`app.integration`.`created_at` as `app.integration.createdAt`,
`app.integration`.`updated_at` as `app.integration.updatedAt`,
`app`.`acl_role_id` as `app.aclRoleId`,
`app.aclRole`.`id` as `app.aclRole.id`,
`app.aclRole`.`name` as `app.aclRole.name`,
`app.aclRole`.`description` as `app.aclRole.description`,
`app.aclRole`.`privileges` as `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` as `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
`app`.`created_at` as `app.createdAt`,
`app`.`updated_at` as `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) as `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) as `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) as `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label as `app.translation.label`,
`app.translation`.description as `app.translation.description`,
`app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields as `app.translation.customFields`,
`app.translation`.created_at as `app.translation.createdAt`,
`app.translation`.updated_at as `app.translation.updatedAt`,
`app.translation`.app_id as `app.translation.appId`,
`app.translation`.language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = : languageId
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
(
`app`.`active` = : param_67a5242062c04008b37848851483eab2
)
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);
array:44 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 117)"
11 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 71)"
12 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
14 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
15 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)"
16 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
19 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
20 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
21 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
22 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
23 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
24 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
25 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
26 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
27 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
29 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
30 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
31 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
32 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
33 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
34 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
35 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
36 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
37 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
39 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
40 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
41 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
42 => "Shopware\Core\HttpKernel::doHandle (line 79)"
43 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 25 |
8.03 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:35 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 74)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (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 51)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
21 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
24 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 26 |
0.62 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:35 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 90)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (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 51)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 153)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
21 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
24 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 27 |
0.87 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Schedule') AND (p.index_1 <= '1737609016' AND p.index_5 = '1') ORDER BY p.index_1 ASC LIMIT 1000
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'Schedule') AND (p.index_1 <= '1737609016' AND p.index_5 = '1') ORDER BY p.index_1 ASC LIMIT 1000;
array:22 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 73)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::select (line 114)"
5 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::getSchedules (line 54)"
6 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
8 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
10 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
11 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
12 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
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 153)"
20 => "Shopware\Core\HttpKernel::doHandle (line 79)"
21 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 28 |
0.41 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042 AND p.index_1 = 'in_progress' AND p.index_6 = '00000000000' AND p.index_7 = '01737609016') LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042 AND p.index_1 = 'in_progress' AND p.index_6 = '00000000000' AND p.index_7 = '01737609016') LIMIT 1;
array:27 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 128)"
5 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
6 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
11 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
13 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
15 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
18 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
19 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
20 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
21 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
22 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
25 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
26 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
27 => "Shopware\Core\HttpKernel::doHandle (line 79)"
28 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 29 |
0.62 ms |
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = :param_e6efd5556f414a01915292e743e5e6f6)
SELECT `cleverreach_entity`.`shopware_id` as `cleverreach_entity.shopware_id`, `cleverreach_entity`.`id` as `cleverreach_entity.id`, `cleverreach_entity`.`type` as `cleverreach_entity.type`, `cleverreach_entity`.`index_1` as `cleverreach_entity.index_1`, `cleverreach_entity`.`index_2` as `cleverreach_entity.index_2`, `cleverreach_entity`.`index_3` as `cleverreach_entity.index_3`, `cleverreach_entity`.`index_4` as `cleverreach_entity.index_4`, `cleverreach_entity`.`index_5` as `cleverreach_entity.index_5`, `cleverreach_entity`.`index_6` as `cleverreach_entity.index_6`, `cleverreach_entity`.`index_7` as `cleverreach_entity.index_7`, `cleverreach_entity`.`index_8` as `cleverreach_entity.index_8`, `cleverreach_entity`.`index_9` as `cleverreach_entity.index_9`, `cleverreach_entity`.`index_10` as `cleverreach_entity.index_10`, `cleverreach_entity`.`data` as `cleverreach_entity.data` FROM `cleverreach_entity` WHERE (`cleverreach_entity`.`id` = 397042);
array:32 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 103)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 153)"
9 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
10 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
18 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
20 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
21 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
23 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
24 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
26 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
27 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
32 => "Shopware\Core\HttpKernel::doHandle (line 79)"
33 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 30 |
0.43 ms |
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (?)
SELECT 1 as `exists`, `shopware_id` FROM `cleverreach_entity` WHERE `shopware_id` IN (0x8BFD4889C6344A959C1954E40DA24709);
array:32 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 379)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetch (line 98)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::prefetchExistences (line 193)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
9 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
10 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
12 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
16 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
18 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
20 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
21 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
23 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
24 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
26 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
27 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
28 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
32 => "Shopware\Core\HttpKernel::doHandle (line 79)"
33 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 31 |
0.29 ms |
"START TRANSACTION"
array:33 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1743)"
1 => "Doctrine\DBAL\Connection::beginTransaction (line 1668)"
2 => "Doctrine\DBAL\Connection::transactional (line 30)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
10 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
12 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
19 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
21 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
24 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 32 |
0.69 ms |
UPDATE `cleverreach_entity` SET `type` = ?, `index_1` = ?, `index_2` = ?, `index_3` = ?, `index_4` = ?, `index_5` = ?, `index_6` = ?, `index_7` = ?, `index_8` = ?, `index_9` = ?, `data` = ? WHERE shopware_id = ?
UPDATE `cleverreach_entity` SET `type` = 'QueueItem', `index_1` = 'in_progress', `index_2` = 'ScheduleCheckTask', `index_3` = 'Schedule', `index_4` = NULL, `index_5` = '1737609014', `index_6` = '00000000000', `index_7` = '01737609016', `index_8` = '00000000100', `index_9` = '5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487', `data` = '{\"class_name\":\"Crsw\\\\CleverReachOfficial\\\\Core\\\\Infrastructure\\\\TaskExecution\\\\QueueItem\",\"id\":397042,\"status\":\"in_progress\",\"context\":\"\",\"serializedTask\":\"{\\\"class_name\\\":\\\"Crsw\\\\\\\\CleverReachOfficial\\\\\\\\Core\\\\\\\\BusinessLogic\\\\\\\\Scheduler\\\\\\\\ScheduleCheckTask\\\"}\",\"queueName\":\"Schedule\",\"lastExecutionProgressBasePoints\":0,\"progressBasePoints\":10000,\"retries\":0,\"failureDescription\":\"\",\"createTime\":\"2025-01-23T05:10:14+00:00\",\"startTime\":\"2025-01-23T05:10:16+00:00\",\"finishTime\":null,\"failTime\":null,\"earliestStartTime\":null,\"queueTime\":\"2025-01-23T05:10:14+00:00\",\"lastUpdateTime\":\"2025-01-23T05:10:16+00:00\",\"priority\":100,\"equalityHash\":\"5a7a27b533259d629b45a83f59889a336f38c059e58aa445681b2a2bbe35c487\"}' WHERE shopware_id = 0x8BFD4889C6344A959C1954E40DA24709;
array:39 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1546)"
1 => "Doctrine\DBAL\Connection::executeStatement (line 894)"
2 => "Doctrine\DBAL\Connection::update (line 233)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 81)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retry (line 63)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableQuery::retryable (line 235)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::executeCommands (line 134)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::Shopware\Core\Framework\DataAbstractionLayer\Dbal\{closure} (line 1670)"
8 => "Doctrine\DBAL\Connection::transactional (line 30)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
11 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
12 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
13 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
14 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
24 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
25 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
26 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
27 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
29 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
30 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
31 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
32 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
33 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
34 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
39 => "Shopware\Core\HttpKernel::doHandle (line 79)"
40 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 33 |
8.63 ms |
"COMMIT"
array:33 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1789)"
1 => "Doctrine\DBAL\Connection::commit (line 1671)"
2 => "Doctrine\DBAL\Connection::transactional (line 30)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retry (line 19)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Doctrine\RetryableTransaction::retryable (line 135)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityWriteGateway::execute (line 207)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::write (line 148)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\Write\EntityWriter::update (line 127)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\VersionManager::update (line 139)"
9 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
10 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
11 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
12 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
13 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
14 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
17 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
18 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
19 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
21 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
22 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
24 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
25 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
26 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
27 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
28 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
29 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
30 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
31 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
32 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
33 => "Shopware\Core\HttpKernel::doHandle (line 79)"
34 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 34 |
2.07 ms |
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = :languageId) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = :param_14e1047e57d44812a30f21f37df3e2bd)
SELECT
`app`.`id` as `app.id`,
`app`.`name` as `app.name`,
`app`.`path` as `app.path`,
`app`.`author` as `app.author`,
`app`.`copyright` as `app.copyright`,
`app`.`license` as `app.license`,
`app`.`active` as `app.active`,
`app`.`configurable` as `app.configurable`,
`app`.`privacy` as `app.privacy`,
`app`.`version` as `app.version`,
`app`.`icon` as `app.iconRaw`,
`app`.`app_secret` as `app.appSecret`,
`app`.`modules` as `app.modules`,
`app`.`main_module` as `app.mainModule`,
`app`.`cookies` as `app.cookies`,
`app`.`allow_disable` as `app.allowDisable`,
`app`.`base_app_url` as `app.baseAppUrl`,
`app`.`allowed_hosts` as `app.allowedHosts`,
`app`.`template_load_priority` as `app.templateLoadPriority`,
`app`.`integration_id` as `app.integrationId`,
`app.integration`.`id` as `app.integration.id`,
`app.integration`.`label` as `app.integration.label`,
`app.integration`.`access_key` as `app.integration.accessKey`,
`app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
`app.integration`.`write_access` as `app.integration.writeAccess`,
`app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
`app.integration`.`admin` as `app.integration.admin`,
`app.integration`.`custom_fields` as `app.integration.customFields`,
`app.integration`.`deleted_at` as `app.integration.deletedAt`,
`app.integration`.`created_at` as `app.integration.createdAt`,
`app.integration`.`updated_at` as `app.integration.updatedAt`,
`app`.`acl_role_id` as `app.aclRoleId`,
`app.aclRole`.`id` as `app.aclRole.id`,
`app.aclRole`.`name` as `app.aclRole.name`,
`app.aclRole`.`description` as `app.aclRole.description`,
`app.aclRole`.`privileges` as `app.aclRole.privileges`,
`app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
`app.aclRole`.`created_at` as `app.aclRole.createdAt`,
`app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
`app`.`created_at` as `app.createdAt`,
`app`.`updated_at` as `app.updatedAt`,
`app.translation.label`,
COALESCE(
`app.translation.label`, `app.translation.label`
) as `app.label`,
`app.translation.description`,
COALESCE(
`app.translation.description`, `app.translation.description`
) as `app.description`,
`app.translation.privacyPolicyExtensions`,
COALESCE(
`app.translation.privacyPolicyExtensions`,
`app.translation.privacyPolicyExtensions`
) as `app.privacyPolicyExtensions`,
`app.translation.customFields`,
COALESCE(
`app.translation.customFields`,
`app.translation.customFields`
) as `app.customFields`,
`app.translation.createdAt`,
`app.translation.updatedAt`,
`app.translation.appId`,
`app.translation.languageId`
FROM
`app`
LEFT JOIN (
SELECT
`app.translation`.app_id,
`app.translation`.label as `app.translation.label`,
`app.translation`.description as `app.translation.description`,
`app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`,
`app.translation`.custom_fields as `app.translation.customFields`,
`app.translation`.created_at as `app.translation.createdAt`,
`app.translation`.updated_at as `app.translation.updatedAt`,
`app.translation`.app_id as `app.translation.appId`,
`app.translation`.language_id as `app.translation.languageId`
FROM
`app_translation` `app.translation`
WHERE
`app.translation`.language_id = : languageId
) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
WHERE
(
`app`.`active` = : param_14e1047e57d44812a30f21f37df3e2bd
)
SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = 1);
array:48 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 299)"
3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 134)"
4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 86)"
5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 225)"
6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 254)"
7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::_search (line 107)"
8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 57)"
9 => "Shopware\Core\Profiling\Profiler::trace (line 108)"
10 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 117)"
11 => "Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister::refresh (line 71)"
12 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
13 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
14 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
15 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (line 117)"
16 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
17 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
18 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
19 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
20 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
21 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
22 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
23 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
24 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
25 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
26 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
27 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
29 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
32 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
33 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
34 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
35 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
36 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
37 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
38 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
39 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
40 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
41 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
42 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
43 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
44 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
45 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
46 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
47 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
48 => "Shopware\Core\HttpKernel::doHandle (line 79)"
49 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 35 |
0.82 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS scriptName,
`script`.`script` AS script,
`script`.`hook` AS hook,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
`app`.`version` AS appVersion,
`script`.`active` AS active
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` != 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:39 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 74)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (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 51)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
24 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
25 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
26 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
27 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
29 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
30 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
31 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
32 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
33 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
34 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
39 => "Shopware\Core\HttpKernel::doHandle (line 79)"
40 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 36 |
0.59 ms |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
`script`.`name` AS name,
`script`.`script` AS script,
`app`.`name` AS appName,
LOWER(HEX(`app`.`integration_id`)) AS integrationId,
IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
FROM `script`
LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE `script`.`hook` = 'include'
ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
;
array:39 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 1042)"
2 => "Doctrine\DBAL\Connection::fetchAllAssociative (line 90)"
3 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::load (line 55)"
4 => "Shopware\Core\Framework\Script\Execution\ScriptLoader::get (line 68)"
5 => "Shopware\Core\Framework\Script\Execution\ScriptExecutor::execute (line 31)"
6 => "Shopware\Core\Framework\Adapter\Cache\Script\ScriptCacheInvalidationSubscriber::executeCacheInvalidationHook (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 51)"
10 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
11 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
13 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
14 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
15 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::update (line 159)"
16 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::update (line 133)"
17 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::updateQueueItem (line 72)"
18 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::saveWithCondition (line 586)"
19 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::save (line 345)"
20 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::updateProgress (line 874)"
23 => "Crsw\CleverReachOfficial\Core\Infrastructure\Utility\Events\EventEmitter::fire (line 127)"
24 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\Task::reportProgress (line 95)"
25 => "Crsw\CleverReachOfficial\Core\BusinessLogic\Scheduler\ScheduleCheckTask::execute (line 156)"
26 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::start (line 64)"
27 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::start (line 114)"
28 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
29 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
30 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
31 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
32 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
33 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
34 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
35 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
36 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
37 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
38 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
39 => "Shopware\Core\HttpKernel::doHandle (line 79)"
40 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 37 |
0.61 ms |
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042) LIMIT 1
SELECT p.* FROM cleverreach_entity p WHERE (p.type = 'QueueItem') AND (p.id=397042) LIMIT 1;
array:21 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 443)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::getResult (line 91)"
4 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::selectOne (line 96)"
5 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::removeQueueItem (line 179)"
6 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::finish (line 70)"
7 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::finish (line 115)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
9 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
10 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
11 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
12 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
13 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
14 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
15 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
18 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
19 => "Shopware\Core\HttpKernel::doHandle (line 79)"
20 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 38 |
6.24 ms |
DELETE FROM cleverreach_entity WHERE id=:id
DELETE FROM cleverreach_entity WHERE id=397042;
array:20 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1546)"
1 => "Doctrine\DBAL\Connection::executeStatement (line 1487)"
2 => "Doctrine\DBAL\Connection::executeUpdate (line 178)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::delete (line 101)"
4 => "Crsw\CleverReachOfficial\Entity\Queue\Repositories\QueueItemRepository::removeQueueItem (line 179)"
5 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueService::finish (line 70)"
6 => "Crsw\CleverReachOfficial\Core\BusinessLogic\TaskExecution\QueueService::finish (line 115)"
7 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\QueueItemStarter::run (line 102)"
8 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
9 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
10 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
11 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
12 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
13 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
14 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
15 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
16 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
17 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
18 => "Shopware\Core\HttpKernel::doHandle (line 79)"
19 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 39 |
6.87 ms |
DELETE FROM cleverreach_entity WHERE id=:id
DELETE FROM cleverreach_entity WHERE id='397044';
array:16 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1546)"
1 => "Doctrine\DBAL\Connection::executeStatement (line 1487)"
2 => "Doctrine\DBAL\Connection::executeUpdate (line 178)"
3 => "Crsw\CleverReachOfficial\Entity\Base\Repositories\BaseRepository::delete (line 103)"
4 => "Crsw\CleverReachOfficial\Core\Infrastructure\TaskExecution\AsyncProcessStarterService::runProcess (line 48)"
5 => "Crsw\CleverReachOfficial\Controller\Storefront\AsyncProcessController::run (line 152)"
6 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 74)"
7 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
8 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
9 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
10 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
11 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
12 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
13 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
14 => "Shopware\Core\HttpKernel::doHandle (line 79)"
15 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|