Symfony Profiler

Query Metrics

Database Queries

Different statements

154.11 ms Query time

Queries

Group similar statements

#▲

Time

Info

11.31 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 )

18.19 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.00 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 )

27.96 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 )

1.70 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 )

53.51 ms

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)

Parameters:

[ "8a243080f92e4c719546314b577cf82b" ]

View formatted query View runnable query Explain query View query backtrace

SELECT CONCAT( TRIM( TRAILING '/' FROM domain.url ), '/' ) `key`, CONCAT( TRIM( TRAILING '/' FROM domain.url ), '/' ) url, LOWER( HEX(domain.id) ) id, LOWER( HEX(sales_channel.id) ) salesChannelId, LOWER( HEX(sales_channel.type_id) ) typeId, LOWER( HEX(domain.snippet_set_id) ) snippetSetId, LOWER( HEX(domain.currency_id) ) currencyId, LOWER( HEX(domain.language_id) ) languageId, LOWER( HEX(theme.id) ) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE ( sales_channel.type_id = UNHEX(?) ) AND (sales_channel.active)

SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX('8a243080f92e4c719546314b577cf82b')) AND (sales_channel.active);

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line )
	Shopware\Storefront\Framework\Routing\DomainLoader->load (line )
	Shopware\Storefront\Framework\Routing\CachedDomainLoader->Shopware\Storefront\Framework\Routing\{closure} (line )
	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line )
	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line )
	Shopware\Storefront\Framework\Routing\CachedDomainLoader->load (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->findSalesChannel (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (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 )

19.42 ms

# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))

Parameters:

[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x7F=P.‚ýEÊª\x16Û\x06ÛÚ`‘" ".git/config" ".git/config/" ]

View formatted query View runnable query Explain query View query backtrace

# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ( ( sales_channel_id = ? OR sales_channel_id IS NULL ) ) AND ( ( seo_path_info = ? OR seo_path_info = ? ) )

# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x7F3D502E82FD45CAAA16DB06DBDA6091 OR sales_channel_id IS NULL)) AND ((seo_path_info = '.git/config' OR seo_path_info = '.git/config/'));

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line )
	Shopware\Core\Content\Seo\SeoResolver->resolve (line )
	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (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 )

0.87 ms

# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1

Parameters:

[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x7F=P.‚ýEÊª\x16Û\x06ÛÚ`‘" "/.git/config" ]

View formatted query View runnable query Explain query View query backtrace

# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1

# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x7F3D502E82FD45CAAA16DB06DBDA6091) AND (path_info = '/.git/config') AND (is_canonical = 1) LIMIT 1;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line )
	Shopware\Core\Content\Seo\SeoResolver->resolve (line )
	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line )
	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (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 )

8.10 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\System\SystemConfig\SystemConfigService->getBool (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 )

12.05 ms

SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1

Parameters:

[ "//.git/config" "/.git/config" "https://rel.test.acid21.dev/.git/config" "https://rel.test.acid21.dev//.git/config" "/.git/config" "//.git/config" ".git/config" true b"\x7F=P.‚ýEÊª\x16Û\x06ÛÚ`‘" null ]

View formatted query View runnable query Explain query View query backtrace

SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE ( `scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND ( `scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ? ) ) LIMIT 1

SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN ('//.git/config', '/.git/config', 'https://rel.test.acid21.dev/.git/config', 'https://rel.test.acid21.dev//.git/config', '/.git/config', '//.git/config', '.git/config') AND `scop_platform_redirecter_redirect`.`enabled` = 1 AND (`scop_platform_redirecter_redirect`.`salesChannelId` = 0x7F3D502E82FD45CAAA16DB06DBDA6091 OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> NULL)) LIMIT 1;

#	File/Call
	Doctrine\DBAL\Connection->executeQuery (line )
	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line )
	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line )
	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line )
	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line )
	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line )
	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line )
	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (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/.git/config

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Symfony Profiler

GET https://rel.test.acid21.dev/.git/config

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache