Query Metrics
6
Database Queries
Different statements
62.71 ms
Query time
Invalid entities
Queries
Group similar statements
| #▲ |
Time |
Info |
| 1 |
13.67 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 |
9.17 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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_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_1564059645_IS_ACTIVE = TRUE;SET @MIGRATION_1564059646_IS_ACTIVE = TRUE;SET @MIGRATION_1564059647_IS_ACTIVE = TRUE;SET @MIGRATION_1564059648_IS_ACTIVE = TRUE;SET @MIGRATION_1564059650_IS_ACTIVE = TRUE;SET @MIGRATION_1564059651_IS_ACTIVE = TRUE;SET @MIGRATION_1565933910_IS_ACTIVE = TRUE;SET @MIGRATION_1568640060_IS_ACTIVE = TRUE;SET @MIGRATION_1568640070_IS_ACTIVE = TRUE;SET @MIGRATION_1568640076_IS_ACTIVE = TRUE;SET @MIGRATION_1580300846_IS_ACTIVE = TRUE;SET @MIGRATION_1582119202_IS_ACTIVE = TRUE;SET @MIGRATION_1582281362_IS_ACTIVE = TRUE;SET @MIGRATION_1583477457_IS_ACTIVE = TRUE;SET @MIGRATION_1583486528_IS_ACTIVE = TRUE;SET @MIGRATION_1583486534_IS_ACTIVE = TRUE;SET @MIGRATION_1583489755_IS_ACTIVE = TRUE;SET @MIGRATION_1583489757_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1588252518_IS_ACTIVE = TRUE;SET @MIGRATION_1594288127_IS_ACTIVE = TRUE;SET @MIGRATION_1594373672_IS_ACTIVE = TRUE;SET @MIGRATION_1594727519_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1602060888_IS_ACTIVE = TRUE;SET @MIGRATION_1602675838_IS_ACTIVE = TRUE;SET @MIGRATION_1609233961_IS_ACTIVE = TRUE;SET @MIGRATION_1579114486_IS_ACTIVE = TRUE;SET @MIGRATION_1622461524_IS_ACTIVE = TRUE;SET @MIGRATION_1623052558_IS_ACTIVE = TRUE;SET @MIGRATION_1632158551_IS_ACTIVE = TRUE;SET @MIGRATION_1634759880_IS_ACTIVE = TRUE;SET @MIGRATION_1637341838_IS_ACTIVE = TRUE;SET @MIGRATION_1640548412_IS_ACTIVE = TRUE;SET @MIGRATION_1645557087_IS_ACTIVE = TRUE;SET @MIGRATION_1645882069_IS_ACTIVE = TRUE;SET @MIGRATION_1647778651_IS_ACTIVE = TRUE;SET @MIGRATION_1648822579_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1592415758_IS_ACTIVE = TRUE;SET @MIGRATION_1647181771_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_1652441129_IS_ACTIVE = TRUE;SET @MIGRATION_1653376989_IS_ACTIVE = TRUE;SET @MIGRATION_1653385302_IS_ACTIVE = TRUE;SET @MIGRATION_1656928097_IS_ACTIVE = TRUE;SET @MIGRATION_1657011337_IS_ACTIVE = TRUE;SET @MIGRATION_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_1564059645_IS_ACTIVE = TRUE;SET @MIGRATION_1564059646_IS_ACTIVE = TRUE;SET @MIGRATION_1564059647_IS_ACTIVE = TRUE;SET @MIGRATION_1564059648_IS_ACTIVE = TRUE;SET @MIGRATION_1564059650_IS_ACTIVE = TRUE;SET @MIGRATION_1564059651_IS_ACTIVE = TRUE;SET @MIGRATION_1565933910_IS_ACTIVE = TRUE;SET @MIGRATION_1568640060_IS_ACTIVE = TRUE;SET @MIGRATION_1568640070_IS_ACTIVE = TRUE;SET @MIGRATION_1568640076_IS_ACTIVE = TRUE;SET @MIGRATION_1580300846_IS_ACTIVE = TRUE;SET @MIGRATION_1582119202_IS_ACTIVE = TRUE;SET @MIGRATION_1582281362_IS_ACTIVE = TRUE;SET @MIGRATION_1583477457_IS_ACTIVE = TRUE;SET @MIGRATION_1583486528_IS_ACTIVE = TRUE;SET @MIGRATION_1583486534_IS_ACTIVE = TRUE;SET @MIGRATION_1583489755_IS_ACTIVE = TRUE;SET @MIGRATION_1583489757_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1588252518_IS_ACTIVE = TRUE;SET @MIGRATION_1594288127_IS_ACTIVE = TRUE;SET @MIGRATION_1594373672_IS_ACTIVE = TRUE;SET @MIGRATION_1594727519_IS_ACTIVE = TRUE;SET @MIGRATION_1583737095_IS_ACTIVE = TRUE;SET @MIGRATION_1602060888_IS_ACTIVE = TRUE;SET @MIGRATION_1602675838_IS_ACTIVE = TRUE;SET @MIGRATION_1609233961_IS_ACTIVE = TRUE;SET @MIGRATION_1579114486_IS_ACTIVE = TRUE;SET @MIGRATION_1622461524_IS_ACTIVE = TRUE;SET @MIGRATION_1623052558_IS_ACTIVE = TRUE;SET @MIGRATION_1632158551_IS_ACTIVE = TRUE;SET @MIGRATION_1634759880_IS_ACTIVE = TRUE;SET @MIGRATION_1637341838_IS_ACTIVE = TRUE;SET @MIGRATION_1640548412_IS_ACTIVE = TRUE;SET @MIGRATION_1645557087_IS_ACTIVE = TRUE;SET @MIGRATION_1645882069_IS_ACTIVE = TRUE;SET @MIGRATION_1647778651_IS_ACTIVE = TRUE;SET @MIGRATION_1648822579_IS_ACTIVE = TRUE;SET @MIGRATION_1572257501_IS_ACTIVE = TRUE;SET @MIGRATION_1616477404_IS_ACTIVE = TRUE;SET @MIGRATION_1592415758_IS_ACTIVE = TRUE;SET @MIGRATION_1647181771_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 |
22.14 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 |
12.59 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 141)"
15 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
16 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
17 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
18 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
19 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
23 => "Shopware\Core\HttpKernel::doHandle (line 79)"
24 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 5 |
2.49 ms |
SELECT id FROM integration WHERE access_key = :accessKey
SELECT id FROM integration WHERE access_key = 'SWIASJDVC25WOEXSTWHHZGK0SQ';
array:26 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 212)"
2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 245)"
3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getIntegrationIdByAccessKey (line 165)"
4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 64)"
5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 68)"
6 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
7 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
8 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
9 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
10 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
11 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
12 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
13 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
14 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
15 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
16 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
17 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
18 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
19 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
20 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
24 => "Shopware\Core\HttpKernel::doHandle (line 79)"
25 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
| 6 |
2.65 ms |
SELECT `acl_role`.`privileges`
FROM `acl_role`
INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE `app`.`integration_id` = :integrationId
SELECT `acl_role`.`privileges`
FROM `acl_role`
INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE `app`.`integration_id` = 0x9AAE38578B9B415CB4454D4647636403
;
array:27 [
0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1323)"
1 => "Doctrine\DBAL\Connection::executeQuery (line 665)"
2 => "Doctrine\DBAL\Connection::fetchColumn (line 347)"
3 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::fetchPermissionsIntegrationByApp (line 256)"
4 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::getAdminApiSource (line 167)"
5 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolveContextSource (line 64)"
6 => "Shopware\Core\Framework\Routing\ApiRequestContextResolver::resolve (line 68)"
7 => "Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver::resolve (line 36)"
8 => "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext (line 117)"
9 => "Symfony\Component\EventDispatcher\Debug\WrappedListener::__invoke (line 230)"
10 => "Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 59)"
11 => "Symfony\Component\EventDispatcher\EventDispatcher::dispatch (line 51)"
12 => "Shopware\Core\Content\Flow\Dispatching\FlowDispatcher::dispatch (line 96)"
13 => "Shopware\Core\Framework\Webhook\WebhookDispatcher::dispatch (line 53)"
14 => "Shopware\Core\Framework\Event\BusinessEventDispatcher::dispatch (line 35)"
15 => "Shopware\Core\Framework\Event\NestedEventDispatcher::dispatch (line 154)"
16 => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher::dispatch (line 141)"
17 => "Symfony\Component\HttpKernel\HttpKernel::handleRaw (line 75)"
18 => "Symfony\Component\HttpKernel\HttpKernel::handle (line 202)"
19 => "Symfony\Component\HttpKernel\Kernel::handle (line 86)"
20 => "Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 479)"
21 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::forward (line 269)"
22 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::pass (line 285)"
23 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::invalidate (line 213)"
24 => "Symfony\Component\HttpKernel\HttpCache\HttpCache::handle (line 153)"
25 => "Shopware\Core\HttpKernel::doHandle (line 79)"
26 => "Shopware\Core\HttpKernel::handle (line 74)"
]
|
Database Connections
There are no configured database connections.
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping