Symfony Profiler

Query Metrics

Database Queries

Different statements

100.68 ms Query time

Queries

Group similar statements

#▲

Time

Info

47.26 ms

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT `key`, `value` FROM `app_config`

SELECT `key`, `value` FROM `app_config`;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Connection->fetchAllKeyValue (line )
	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line )
	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line )
	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line )
	Shopware\Core\Framework\Adapter\Kernel\KernelFactory::create (line )
	{closure} (line )
	Symfony\Component\Runtime\Resolver\DebugClosureResolver::Symfony\Component\Runtime\Resolver\{closure} (line )
	require_once (line )

11.52 ms

# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF( `active` = 1 AND `installed_at` IS NOT NULL, 1, 0 ) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;

# dbal-plugin-loader SELECT `name`, `base_class` AS baseClass, IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active, `path`, `version`, `autoload`, `managed_by_composer` AS managedByComposer, composer_name as composerName FROM `plugin` ORDER BY `installed_at`;;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line )
	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line )
	Shopware\Core\Kernel->boot (line )
	Shopware\Core\Kernel->handle (line )
	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line )
	require_once (line )

1.29 ms

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT `key`, `value` FROM `app_config`

SELECT `key`, `value` FROM `app_config`;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Connection->fetchAllKeyValue (line )
	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line )
	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line )
	Shopware\Core\Framework\Feature\FeatureFlagRegistry->register (line )
	Shopware\Core\Framework\Framework->boot (line )
	Shopware\Core\Kernel->boot (line )
	Shopware\Core\Kernel->handle (line )
	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line )
	require_once (line )

25.61 ms

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE ( custom_entity.app_id IS NULL OR app.active = 1 ) AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags FROM custom_entity LEFT JOIN app ON app.id = custom_entity.app_id WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL; ;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Connection->fetchAllAssociative (line )
	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line )
	Shopware\Core\System\System->boot (line )
	Shopware\Core\Kernel->boot (line )
	Shopware\Core\Kernel->handle (line )
	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line )
	require_once (line )

0.62 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',''))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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',''));

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line )
	Shopware\Core\Kernel->boot (line )
	Shopware\Core\Kernel->handle (line )
	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line )
	require_once (line )

14.38 ms

SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line )
	Shopware\Core\System\SystemConfig\SystemConfigLoader->load (line )
	Frosh\Tools\Components\SystemConfig\ConfigSystemConfigLoader->load (line )
	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->Shopware\Core\System\SystemConfig\{closure} (line )
	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line )
	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line )
	Shopware\Core\System\SystemConfig\CachedSystemConfigLoader->load (line )
	Shopware\Core\System\SystemConfig\ConfiguredSystemConfigLoader->load (line )
	Shopware\Core\System\SystemConfig\MemoizedSystemConfigLoader->load (line )
	Shopware\Core\System\SystemConfig\SystemConfigService->get (line )
	Shopware\Core\Framework\Routing\CanonicalRedirectService->getRedirect (line )
	Scop\PlatformRedirecter\Decorator\CanonicalRedirectServiceDecorator->getRedirect (line )
	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line )
	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line )
	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line )
	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line )
	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line )
	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line )
	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line )
	Shopware\Core\Kernel->handle (line )
	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line )
	require_once (line )

Symfony Profiler

GET https://rel.test.acid21.dev/_profiler

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Symfony Profiler

GET https://rel.test.acid21.dev/_profiler

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache