Query Metrics
3
Database Queries
Different statements
2.01 ms
Query time
Invalid entities
Queries
Group similar statements
| #▲ |
Time |
Info |
| 1 |
0.79 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.24 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_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1652347951_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_1636014089_IS_ACTIVE = TRUE;SET @MIGRATION_1639122665_IS_ACTIVE = TRUE;SET @MIGRATION_1642517958_IS_ACTIVE = TRUE;SET @MIGRATION_1642757286_IS_ACTIVE = TRUE;SET @MIGRATION_1643386819_IS_ACTIVE = TRUE;SET @MIGRATION_1643724178_IS_ACTIVE = TRUE;SET @MIGRATION_1645019769_IS_ACTIVE = TRUE;SET @MIGRATION_1645453538_IS_ACTIVE = TRUE;SET @MIGRATION_1646125417_IS_ACTIVE = TRUE;SET @MIGRATION_1646817331_IS_ACTIVE = TRUE;SET @MIGRATION_1647260673_IS_ACTIVE = TRUE;SET @MIGRATION_1647443222_IS_ACTIVE = TRUE;SET @MIGRATION_1648031611_IS_ACTIVE = TRUE;SET @MIGRATION_1648031636_IS_ACTIVE = TRUE;SET @MIGRATION_1648803451_IS_ACTIVE = TRUE;SET @MIGRATION_1649040981_IS_ACTIVE = TRUE;SET @MIGRATION_1649315608_IS_ACTIVE = TRUE;SET @MIGRATION_1641476963_IS_ACTIVE = TRUE;SET @MIGRATION_1652347951_IS_ACTIVE = TRUE;
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.98 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)"
]
|
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