| 1 |
0.52 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 361)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 200)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 2 |
0.61 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 @@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',''));
array:7 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 394)"
2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 42)"
3 => "Shopware\Production\Kernel::initializeDatabaseConnectionVariables (line 200)"
4 => "Shopware\Core\Kernel::boot (line 126)"
5 => "Shopware\Core\HttpKernel::doHandle (line 79)"
6 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 3 |
0.60 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 49)"
3 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 33)"
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 38)"
7 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 34)"
8 => "Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader::load (line 71)"
9 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)"
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.47 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 318)"
3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getCashRounding (line 58)"
4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 65)"
5 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 33)"
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 52)"
12 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 32)"
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.55 ms |
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = 'SWIARFD4RVH4QTNWM0ZGUXHXQQ';
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 97)"
3 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getIntegrationByAccessKey (line 66)"
4 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getByAccessKey (line 48)"
5 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getClientEntity (line 235)"
6 => "League\OAuth2\Server\Grant\AbstractGrant::getClientEntityOrFail (line 36)"
7 => "League\OAuth2\Server\Grant\ClientCredentialsGrant::respondToAccessTokenRequest (line 204)"
8 => "League\OAuth2\Server\AuthorizationServer::respondToAccessTokenRequest (line 110)"
9 => "Shopware\Core\Framework\Api\Controller\AuthController::token (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)"
]
|
| 6 |
0.39 ms |
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = 'SWIARFD4RVH4QTNWM0ZGUXHXQQ';
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 97)"
3 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getIntegrationByAccessKey (line 66)"
4 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getByAccessKey (line 29)"
5 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::validateClient (line 196)"
6 => "League\OAuth2\Server\Grant\AbstractGrant::validateClient (line 45)"
7 => "League\OAuth2\Server\Grant\ClientCredentialsGrant::respondToAccessTokenRequest (line 204)"
8 => "League\OAuth2\Server\AuthorizationServer::respondToAccessTokenRequest (line 110)"
9 => "Shopware\Core\Framework\Api\Controller\AuthController::token (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 |
1.75 ms |
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = :accessKey
SELECT integration.id AS id, label, secret_access_key, app.active as active FROM integration LEFT JOIN app app ON app.integration_id = integration.id WHERE access_key = 'SWIARFD4RVH4QTNWM0ZGUXHXQQ';
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 97)"
3 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getIntegrationByAccessKey (line 66)"
4 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getByAccessKey (line 48)"
5 => "Shopware\Core\Framework\Api\OAuth\ClientRepository::getClientEntity (line 235)"
6 => "League\OAuth2\Server\Grant\AbstractGrant::getClientEntityOrFail (line 202)"
7 => "League\OAuth2\Server\Grant\AbstractGrant::validateClient (line 45)"
8 => "League\OAuth2\Server\Grant\ClientCredentialsGrant::respondToAccessTokenRequest (line 204)"
9 => "League\OAuth2\Server\AuthorizationServer::respondToAccessTokenRequest (line 110)"
10 => "Shopware\Core\Framework\Api\Controller\AuthController::token (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)"
]
|
| 8 |
0.26 ms |
SELECT admin FROM user WHERE id = UNHEX(:accessKey) LIMIT 1
SELECT admin FROM user WHERE id = UNHEX(NULL) 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 85)"
3 => "Shopware\Core\Framework\Api\OAuth\ScopeRepository::finalizeScopes (line 50)"
4 => "League\OAuth2\Server\Grant\ClientCredentialsGrant::respondToAccessTokenRequest (line 204)"
5 => "League\OAuth2\Server\AuthorizationServer::respondToAccessTokenRequest (line 110)"
6 => "Shopware\Core\Framework\Api\Controller\AuthController::token (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)"
]
|