Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

11 Database Queries

Different statements

11.36 ms Query time

Invalid entities

Queries

Group similar statements


# cache-id-loader
                SELECT `value` FROM app_config WHERE `key` = :key
# 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`;
SELECT `creation_timestamp`
            FROM `migration`
            WHERE `update` IS NOT NULL AND `update_destructive` IS NULL
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_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1623059999_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1590425608_IS_ACTIVE = TRUE;SET @MIGRATION_1618323278_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1643902985_IS_ACTIVE = TRUE;SET @MIGRATION_1643907023_IS_ACTIVE = TRUE;SET @MIGRATION_1643908626_IS_ACTIVE = TRUE;SET @MIGRATION_1647443705_IS_ACTIVE = TRUE;SET @MIGRATION_1647613235_IS_ACTIVE = TRUE;SET @MIGRATION_1648564206_IS_ACTIVE = TRUE;SET @MIGRATION_1650965928_IS_ACTIVE = TRUE;SET @MIGRATION_1685702879_IS_ACTIVE = TRUE;SET @MIGRATION_1690142324_IS_ACTIVE = TRUE;SET @MIGRATION_1696164933_IS_ACTIVE = TRUE;SET @MIGRATION_1698748783_IS_ACTIVE = TRUE;SET @MIGRATION_1701279517_IS_ACTIVE = TRUE
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(:typeId)) AND (sales_channel.active)
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_5a69e24501f3404187fe347a74ef6fd5) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500
# system-config::load::read
SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (:ids)
# system-config::load::search-ids
SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_3fa8b591be5f45e5a49a81376bc009ce) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500
SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_31aadf6ea19047608646d747284838f9)

#▲	Time	Info
1	0.40 ms	# cache-id-loader SELECT `value` FROM app_config WHERE `key` = :key View formatted query View runnable query View query stack # cache-id-loader SELECT `value` FROM app_config WHERE `key` = : key # cache-id-loader SELECT `value` FROM app_config WHERE `key` = 'cache-id'; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 664)" 2 => "Doctrine\DBAL\Connection::fetchColumn (line 34)" 3 => "Shopware\Core\Framework\Adapter\Cache\CacheIdLoader::load (line 212)" 4 => "Shopware\Core\HttpKernel::createKernel (line 153)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 48)"`]
2	0.08 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`; View formatted query View runnable query View query stack # 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`;; array:7 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 39)" 2 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader::loadPluginInfos (line 110)" 3 => "Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader::initializePlugins (line 183)" 4 => "Shopware\Core\Kernel::boot (line 154)" 5 => "Shopware\Core\HttpKernel::doHandle (line 81)" 6 => "Shopware\Core\HttpKernel::handle (line 48)"`]
3	0.17 ms	SELECT `creation_timestamp` FROM `migration` WHERE `update` IS NOT NULL AND `update_destructive` IS NULL View formatted query View runnable query View query stack 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:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 379)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 201)" 3 => "Shopware\Core\Kernel::boot (line 154)" 4 => "Shopware\Core\HttpKernel::doHandle (line 81)" 5 => "Shopware\Core\HttpKernel::handle (line 48)"`]
4	0.76 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_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1623059999_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1590425608_IS_ACTIVE = TRUE;SET @MIGRATION_1618323278_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1643902985_IS_ACTIVE = TRUE;SET @MIGRATION_1643907023_IS_ACTIVE = TRUE;SET @MIGRATION_1643908626_IS_ACTIVE = TRUE;SET @MIGRATION_1647443705_IS_ACTIVE = TRUE;SET @MIGRATION_1647613235_IS_ACTIVE = TRUE;SET @MIGRATION_1648564206_IS_ACTIVE = TRUE;SET @MIGRATION_1650965928_IS_ACTIVE = TRUE;SET @MIGRATION_1685702879_IS_ACTIVE = TRUE;SET @MIGRATION_1690142324_IS_ACTIVE = TRUE;SET @MIGRATION_1696164933_IS_ACTIVE = TRUE;SET @MIGRATION_1698748783_IS_ACTIVE = TRUE;SET @MIGRATION_1701279517_IS_ACTIVE = TRUE View formatted query View runnable query View query stack 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_1631625055_IS_ACTIVE = TRUE; SET @MIGRATION_1631703921_IS_ACTIVE = TRUE; SET @MIGRATION_1631790054_IS_ACTIVE = TRUE; SET @MIGRATION_1632215760_IS_ACTIVE = TRUE; SET @MIGRATION_1632721037_IS_ACTIVE = TRUE; SET @MIGRATION_1633347511_IS_ACTIVE = TRUE; SET @MIGRATION_1633358879_IS_ACTIVE = TRUE; SET @MIGRATION_1633422057_IS_ACTIVE = TRUE; SET @MIGRATION_1634735841_IS_ACTIVE = TRUE; SET @MIGRATION_1635147952_IS_ACTIVE = TRUE; SET @MIGRATION_1635230747_IS_ACTIVE = TRUE; SET @MIGRATION_1635237551_IS_ACTIVE = TRUE; SET @MIGRATION_1635388654_IS_ACTIVE = TRUE; SET @MIGRATION_1635936029_IS_ACTIVE = TRUE; SET @MIGRATION_1636018970_IS_ACTIVE = TRUE; SET @MIGRATION_1636362839_IS_ACTIVE = TRUE; SET @MIGRATION_1636449347_IS_ACTIVE = TRUE; SET @MIGRATION_1636971615_IS_ACTIVE = TRUE; SET @MIGRATION_1636121186_IS_ACTIVE = TRUE; SET @MIGRATION_1580205548_IS_ACTIVE = TRUE; SET @MIGRATION_1580205549_IS_ACTIVE = TRUE; SET @MIGRATION_1580205550_IS_ACTIVE = TRUE; SET @MIGRATION_1580205549_IS_ACTIVE = TRUE; SET @MIGRATION_1623059999_IS_ACTIVE = TRUE; SET @MIGRATION_1584005462_IS_ACTIVE = TRUE; SET @MIGRATION_1589800641_IS_ACTIVE = TRUE; SET @MIGRATION_1589800704_IS_ACTIVE = TRUE; SET @MIGRATION_1589882802_IS_ACTIVE = TRUE; SET @MIGRATION_1589905764_IS_ACTIVE = TRUE; SET @MIGRATION_1591365484_IS_ACTIVE = TRUE; SET @MIGRATION_1626082072_IS_ACTIVE = TRUE; SET @MIGRATION_1590425608_IS_ACTIVE = TRUE; SET @MIGRATION_1618323278_IS_ACTIVE = TRUE; SET @MIGRATION_1575569953_IS_ACTIVE = TRUE; SET @MIGRATION_1598204175_IS_ACTIVE = TRUE; SET @MIGRATION_1643902985_IS_ACTIVE = TRUE; SET @MIGRATION_1643907023_IS_ACTIVE = TRUE; SET @MIGRATION_1643908626_IS_ACTIVE = TRUE; SET @MIGRATION_1647443705_IS_ACTIVE = TRUE; SET @MIGRATION_1647613235_IS_ACTIVE = TRUE; SET @MIGRATION_1648564206_IS_ACTIVE = TRUE; SET @MIGRATION_1650965928_IS_ACTIVE = TRUE; SET @MIGRATION_1685702879_IS_ACTIVE = TRUE; SET @MIGRATION_1690142324_IS_ACTIVE = TRUE; SET @MIGRATION_1696164933_IS_ACTIVE = TRUE; SET @MIGRATION_1698748783_IS_ACTIVE = TRUE; SET @MIGRATION_1701279517_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_1631625055_IS_ACTIVE = TRUE;SET @MIGRATION_1631703921_IS_ACTIVE = TRUE;SET @MIGRATION_1631790054_IS_ACTIVE = TRUE;SET @MIGRATION_1632215760_IS_ACTIVE = TRUE;SET @MIGRATION_1632721037_IS_ACTIVE = TRUE;SET @MIGRATION_1633347511_IS_ACTIVE = TRUE;SET @MIGRATION_1633358879_IS_ACTIVE = TRUE;SET @MIGRATION_1633422057_IS_ACTIVE = TRUE;SET @MIGRATION_1634735841_IS_ACTIVE = TRUE;SET @MIGRATION_1635147952_IS_ACTIVE = TRUE;SET @MIGRATION_1635230747_IS_ACTIVE = TRUE;SET @MIGRATION_1635237551_IS_ACTIVE = TRUE;SET @MIGRATION_1635388654_IS_ACTIVE = TRUE;SET @MIGRATION_1635936029_IS_ACTIVE = TRUE;SET @MIGRATION_1636018970_IS_ACTIVE = TRUE;SET @MIGRATION_1636362839_IS_ACTIVE = TRUE;SET @MIGRATION_1636449347_IS_ACTIVE = TRUE;SET @MIGRATION_1636971615_IS_ACTIVE = TRUE;SET @MIGRATION_1636121186_IS_ACTIVE = TRUE;SET @MIGRATION_1580205548_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1580205550_IS_ACTIVE = TRUE;SET @MIGRATION_1580205549_IS_ACTIVE = TRUE;SET @MIGRATION_1623059999_IS_ACTIVE = TRUE;SET @MIGRATION_1584005462_IS_ACTIVE = TRUE;SET @MIGRATION_1589800641_IS_ACTIVE = TRUE;SET @MIGRATION_1589800704_IS_ACTIVE = TRUE;SET @MIGRATION_1589882802_IS_ACTIVE = TRUE;SET @MIGRATION_1589905764_IS_ACTIVE = TRUE;SET @MIGRATION_1591365484_IS_ACTIVE = TRUE;SET @MIGRATION_1626082072_IS_ACTIVE = TRUE;SET @MIGRATION_1590425608_IS_ACTIVE = TRUE;SET @MIGRATION_1618323278_IS_ACTIVE = TRUE;SET @MIGRATION_1575569953_IS_ACTIVE = TRUE;SET @MIGRATION_1598204175_IS_ACTIVE = TRUE;SET @MIGRATION_1643902985_IS_ACTIVE = TRUE;SET @MIGRATION_1643907023_IS_ACTIVE = TRUE;SET @MIGRATION_1643908626_IS_ACTIVE = TRUE;SET @MIGRATION_1647443705_IS_ACTIVE = TRUE;SET @MIGRATION_1647613235_IS_ACTIVE = TRUE;SET @MIGRATION_1648564206_IS_ACTIVE = TRUE;SET @MIGRATION_1650965928_IS_ACTIVE = TRUE;SET @MIGRATION_1685702879_IS_ACTIVE = TRUE;SET @MIGRATION_1690142324_IS_ACTIVE = TRUE;SET @MIGRATION_1696164933_IS_ACTIVE = TRUE;SET @MIGRATION_1698748783_IS_ACTIVE = TRUE;SET @MIGRATION_1701279517_IS_ACTIVE = TRUE; array:6 [`0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 412)" 2 => "Shopware\Core\Kernel::initializeDatabaseConnectionVariables (line 201)" 3 => "Shopware\Core\Kernel::boot (line 154)" 4 => "Shopware\Core\HttpKernel::doHandle (line 81)" 5 => "Shopware\Core\HttpKernel::handle (line 48)"`]
5	0.32 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(:typeId)) AND (sales_channel.active) View formatted query View runnable query View query stack 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(: typeId) ) 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); array:9 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 58)" 3 => "Shopware\Storefront\Framework\Routing\DomainLoader::load (line 47)" 4 => "Shopware\Storefront\Framework\Routing\CachedDomainLoader::load (line 277)" 5 => "Shopware\Storefront\Framework\Routing\RequestTransformer::findSalesChannel (line 130)" 6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 161)" 7 => "Shopware\Core\HttpKernel::doHandle (line 81)" 8 => "Shopware\Core\HttpKernel::handle (line 48)"]
6	0.07 ms	# seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = :language_id) AND ((sales_channel_id = :sales_channel_id OR sales_channel_id IS NULL)) AND (seo_path_info = :seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1 View formatted query View runnable query View query stack # seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = : language_id) AND ( ( sales_channel_id = : sales_channel_id OR sales_channel_id IS NULL ) ) AND (seo_path_info = : seoPath) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1 # seo-url::resolve SELECT id, path_info pathInfo, is_canonical isCanonical FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0xA17F9C7CADF0464AB456D80CDF43E103 OR sales_channel_id IS NULL)) AND (seo_path_info = 'robots.txt') ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1; array:10 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 46)" 3 => "Shopware\Core\Content\Seo\SeoResolver::resolve (line 53)" 4 => "Shopware\Core\Content\Seo\CachedSeoResolver::resolve (line 29)" 5 => "Shopware\Core\Content\Seo\EmptyPathInfoResolver::resolve (line 336)" 6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::resolveSeoUrl (line 144)" 7 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 161)" 8 => "Shopware\Core\HttpKernel::doHandle (line 81)" 9 => "Shopware\Core\HttpKernel::handle (line 48)"]
7	0.06 ms	SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = :language_id) AND (sales_channel_id = :sales_channel_id) AND (id != :id) AND (path_info = :pathInfo) AND (is_canonical = 1) LIMIT 1 View formatted query View runnable query View query stack SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = : language_id) AND ( sales_channel_id = : sales_channel_id ) AND (id != : id) AND (path_info = : pathInfo) AND (is_canonical = 1) LIMIT 1 SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0xA17F9C7CADF0464AB456D80CDF43E103) AND (id != '') AND (path_info = '/robots.txt') AND (is_canonical = 1) LIMIT 1; array:10 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 67)" 3 => "Shopware\Core\Content\Seo\SeoResolver::resolve (line 53)" 4 => "Shopware\Core\Content\Seo\CachedSeoResolver::resolve (line 29)" 5 => "Shopware\Core\Content\Seo\EmptyPathInfoResolver::resolve (line 336)" 6 => "Shopware\Storefront\Framework\Routing\RequestTransformer::resolveSeoUrl (line 144)" 7 => "Shopware\Storefront\Framework\Routing\RequestTransformer::transform (line 161)" 8 => "Shopware\Core\HttpKernel::doHandle (line 81)" 9 => "Shopware\Core\HttpKernel::handle (line 48)"]
8	0.22 ms	# system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_5a69e24501f3404187fe347a74ef6fd5) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 View formatted query View runnable query View query stack # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE ( `system_config`.`sales_channel_id` <=> : param_5a69e24501f3404187fe347a74ef6fd5 ) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500; array:16 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 91)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 57)" 4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 36)" 5 => "Shopware\Core\Profiling\Entity\EntitySearcherProfiler::search (line 179)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 120)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)" 10 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 372)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 13 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 165)" 14 => "Shopware\Core\HttpKernel::doHandle (line 81)" 15 => "Shopware\Core\HttpKernel::handle (line 48)"]
9	0.26 ms	# system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (:ids) View formatted query View runnable query View query stack # system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (: ids) # system-config::load::read SELECT `system_config`.`id` as `system_config.id`, `system_config`.`configuration_key` as `system_config.configurationKey`, `system_config`.`configuration_value` as `system_config.configurationValue`, `system_config`.`sales_channel_id` as `system_config.salesChannelId`, `system_config`.`created_at` as `system_config.createdAt`, `system_config`.`updated_at` as `system_config.updatedAt` FROM `system_config` WHERE `system_config`.`id` IN (0x00ED19E6D4DC4E62933EC0CBBADBE0FD, 0x083B80A976674755BFD0FADBCC0C5FF7, 0x09ABAF267B76434083FFA325A75DBED0, 0x0BDCB64E1282424AB4D4A402364D03A3, 0x0C0B7D625CE64A498CE75C0AFF6CC899, 0x0D7951D8D7204CA48A4252E4B2B7369A, 0x0D801FE2522F46D182E0E7B0F2F6487C, 0x0DB485E47FEF4E4A96E19C3E90B8D381, 0x11B01C0E4B2444FFA6474A161C089F42, 0x14FB6A246A254940B65DB1A9F3E3EF25, 0x167C8FF71DDB41DEB7EDEF11F4FC61A6, 0x17A4AF5CC81C46CB944AFDC3B94DA514, 0x19E79407D9F94946B891269452147734, 0x1A4C32B1704640D489103BF3F329D2BD, 0x1A949F01FB8941558737B4D8B73B9E8C, 0x1CEB515D17DD467EAEB9BA663DBA006A, 0x210B33AE25A04D8FB8F796475E35D9FD, 0x2392C09ED5754AD7805CDE7C0D3D29BB, 0x25D686DBAD9E42068A51C579A557713A, 0x28977059A53D42489A577A9E44704482, 0x2DBFDEB829AC48AABA1F3A6145740130, 0x30553D36BF5C4EC881F749F6C15A838A, 0x3203F030983942DAA6DD99452469B6B7, 0x3B0E0CE9A50748F5A1611C53B3D92E1E, 0x3C262459407340858279B1CDF312EE94, 0x3CDE13CA46484BAFB0AAA4456A580D05, 0x3EFED5665A684472A7FB7505E2E787BD, 0x410D32A939D14D848AA0BCD55C54DAAC, 0x421E887211974E58AAD378ADDEB89CC6, 0x44D8B8A77E044D86BD6350A7A52CCD65, 0x47E3833E55134715959BA0B68E102AFC, 0x48ABC38D5B3745A28F754C0F6F3E7BC6, 0x493DC6E5FF624CF585C9F61880034D3D, 0x49FE354668184C76BFE3A74E17064839, 0x4ADC696CEA3E458CA66B0ED63001F840, 0x4B1F8BC391DE46E09EF6CD48C7FC5F4B, 0x4B70342F55A04114B1DC16A2698BB576, 0x4D4B92E0FDFC4895B8F02346CA3BE298, 0x517AA4A21842458B94D7A336732014F1, 0x51B05931BF704375BA9425F7FC080FE4, 0x52F61A4E15264F068B2525A3FABFB742, 0x54758416BB6846F89C94BBC3DFCE75B9, 0x56E0424BCB7F448CAEF399EB9E893E67, 0x5A404329D6844D6B9A5647E7DBBB06C4, 0x5B271D43BA914D9BB69963ECEF93F60C, 0x5C9712CB22CD414B8675B01A39903195, 0x61BC74F28A5D440F92BFEB99C25B81B5, 0x622897F926064A1BA3875CCAC06CF48E, 0x6292056ED4E144B3B73D240CC230D7B4, 0x63045320CB4B4662BC10D67E4FD3445C, 0x63C12BA5BB954B9A81692D073F40E2D0, 0x6A7666E954524398A00B3E2AE2AF1D78, 0x6AA63BB663724EB5AE2089FAA517E455, 0x6EB7ACBB8C014668BDDAE4B5B35EA26E, 0x7017B0CB299A493E87F7369ED1C60DB0, 0x734AAEB200B54683AB0E13A6186F146D, 0x79A69E67FFB048A194A1245355C27667, 0x79F82BC2E9404C61A5C83F72FC741603, 0x7CD30C3E606F44D5B208902C516334FD, 0x7D78446CAD4C4B9E95504CDE3C19E3A2, 0x7E24D2C23E7E421F9E104362825BD65A, 0x824BA5C5D96843C89F31CC29E4163CC4, 0x82CD8E47E6D349EE99B4A53A2584F1AA, 0x85030AB302784038A2C000990EA42362, 0x870C609331D248A78F5E14C1567288D5, 0x8710303428B24D3B937FD8BBC3A977A4, 0x8726B61638D04149BC8FA4E767251E21, 0x890AD666C141454885A6B931D2C0FCDB, 0x8C7DEA669B504F3BBC8DD47151A08495, 0x8E7C54F724434D2F942D5FD0F568127A, 0x8F82FB5CB14A4605802163102AF16173, 0x91407A3DAA424BC988DB57B397B6299A, 0x9B837CA0491A408C8FC5E5EC51A23649, 0x9DDD608F8FC74FCF861026B4E4A3D542, 0x9EBB4C0BF4224EFEA74A3803DC3A51E4, 0xA3E78090628E490BBA0E9E935D75BDF1, 0xA8AB9D2D40E848A99B47D1E6A57752E8, 0xA8EFFC116E4C4462984350C7F679318A, 0xAB6B0300757A4C779B264C8DA7E96990, 0xABA4CAC513D74C8BA43EDDC333E2F04F, 0xB0921EBF60F54E01ACC379653E158375, 0xB107991FC2474C8EA16D0E0136B8A79F, 0xB4EC6987546B4DE6AD4AA17B5FBE9A01, 0xB5A1DE90E50D487B9CE27522EC9AD544, 0xBDC68BEAC1164F19BE9EB0F25CB3718D, 0xC26291584398470584D05882BA748747, 0xC67117A71DA042969C5F8006BF6EFFB5, 0xC9FA70477A434260B1243DEFCA76895C, 0xCAED05B4CEB54A72BC7DE49392608345, 0xCDF7D318DF424B91BC47890D382E7156, 0xCEF3629A42544E8996630D76180891DB, 0xD2D8F7C09DEE46E48B53740FB42E6ABB, 0xD43270A37C0D492D8A889ECDBD33B610, 0xD5F7DA0488244096B937C156A5500DBB, 0xD676A13D475D4EE58F028C8E813490C5, 0xD71F101CF74C4A4685FC42EEC4238FF8, 0xD7CA543DC474412A955697AD3301D457, 0xDB21A9C5E7064B7FBA4218ACED3D5AB7, 0xDC9D11B0431448F299ED36555BB52109, 0xDD00D5863316471B9DBECD83BD4B5225, 0xDE59E6D82B50478285BAFBA285382C62, 0xDEC8BBD38B034027970B2B41383DD63B, 0xDECD3DD369A849D4BBB32DDFB4BC891B, 0xDF9EF97750B84119B3079BF88FE55C94, 0xE021CCD74B594CB98A0D136F2A5785C9, 0xE16D6F4A27DD4382B446379D97DC111D, 0xE2E0AC99488C42AF9D57156A30407F13, 0xE2FE453715284C3BBFDEEABE63457898, 0xE3C2005B9B014181BE261B2924D3BDAE, 0xE79C10BCF0EC4536A102AFA0BAD39B81, 0xE9A207607E2D4EB8B3EA4E2391A21718, 0xEBCE8D49AC1B4FE2A79CE28C7536B84F, 0xEF867ABA28E5445398FE6C098C8AC19E, 0xF09DFE7727BA4EE6ACEAC51B2E76EF17, 0xF1C8C827850E4E5D9064AAC68D2C956F, 0xF2342302723D45F9A097C658CB71CD8A, 0xFB16CFE71A3341B9A9EF178723854936, 0xFC48FA1C51D84B1EA3FAF1B20E8F4CEC, 0xFE992D2557A4408BAB183806128EEF0C, 0xFF085324C4B444AB8A08607F292D4D78); array:17 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 262)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 109)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 79)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 36)" 6 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 270)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 130)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)" 9 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)" 11 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 372)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)" 13 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 14 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 165)" 15 => "Shopware\Core\HttpKernel::doHandle (line 81)" 16 => "Shopware\Core\HttpKernel::handle (line 48)"]
10	0.15 ms	# system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> :param_3fa8b591be5f45e5a49a81376bc009ce) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500 View formatted query View runnable query View query stack # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE ( `system_config`.`sales_channel_id` <=> : param_3fa8b591be5f45e5a49a81376bc009ce ) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500 # system-config::load::search-ids SELECT `system_config`.`id` FROM `system_config` WHERE (`system_config`.`sales_channel_id` <=> NULL) ORDER BY `system_config`.`sales_channel_id` ASC, `system_config`.`id` ASC LIMIT 500 OFFSET 500; array:16 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 91)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher::search (line 57)" 4 => "Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher::search (line 36)" 5 => "Shopware\Core\Profiling\Entity\EntitySearcherProfiler::search (line 179)" 6 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::searchIds (line 120)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 72)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator::fetch (line 67)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)" 10 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 372)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 13 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 165)" 14 => "Shopware\Core\HttpKernel::doHandle (line 81)" 15 => "Shopware\Core\HttpKernel::handle (line 48)"]
11	8.87 ms	SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = :languageId) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = :param_31aadf6ea19047608646d747284838f9) View formatted query View runnable query View query stack SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE( `plugin.translation.label`, `plugin.translation.label` ) as `plugin.label`, `plugin.translation.description`, COALESCE( `plugin.translation.description`, `plugin.translation.description` ) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE( `plugin.translation.manufacturerLink`, `plugin.translation.manufacturerLink` ) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE( `plugin.translation.supportLink`, `plugin.translation.supportLink` ) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE( `plugin.translation.changelog`, `plugin.translation.changelog` ) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE( `plugin.translation.customFields`, `plugin.translation.customFields` ) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN ( SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = : languageId ) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE ( `plugin`.`active` = : param_31aadf6ea19047608646d747284838f9 ) SELECT `plugin`.`id` as `plugin.id`, `plugin`.`base_class` as `plugin.baseClass`, `plugin`.`name` as `plugin.name`, `plugin`.`composer_name` as `plugin.composerName`, `plugin`.`autoload` as `plugin.autoload`, `plugin`.`active` as `plugin.active`, `plugin`.`managed_by_composer` as `plugin.managedByComposer`, `plugin`.`path` as `plugin.path`, `plugin`.`author` as `plugin.author`, `plugin`.`copyright` as `plugin.copyright`, `plugin`.`license` as `plugin.license`, `plugin`.`version` as `plugin.version`, `plugin`.`upgrade_version` as `plugin.upgradeVersion`, `plugin`.`installed_at` as `plugin.installedAt`, `plugin`.`upgraded_at` as `plugin.upgradedAt`, `plugin`.`icon` as `plugin.iconRaw`, `plugin`.`created_at` as `plugin.createdAt`, `plugin`.`updated_at` as `plugin.updatedAt`, `plugin.translation.label`, COALESCE(`plugin.translation.label`,`plugin.translation.label`) as `plugin.label`, `plugin.translation.description`, COALESCE(`plugin.translation.description`,`plugin.translation.description`) as `plugin.description`, `plugin.translation.manufacturerLink`, COALESCE(`plugin.translation.manufacturerLink`,`plugin.translation.manufacturerLink`) as `plugin.manufacturerLink`, `plugin.translation.supportLink`, COALESCE(`plugin.translation.supportLink`,`plugin.translation.supportLink`) as `plugin.supportLink`, `plugin.translation.changelog`, COALESCE(`plugin.translation.changelog`,`plugin.translation.changelog`) as `plugin.changelog`, `plugin.translation.customFields`, COALESCE(`plugin.translation.customFields`,`plugin.translation.customFields`) as `plugin.customFields`, `plugin.translation.createdAt`, `plugin.translation.updatedAt`, `plugin.translation.pluginId`, `plugin.translation.languageId` FROM `plugin` LEFT JOIN (SELECT `plugin.translation`.plugin_id, `plugin.translation`.label as `plugin.translation.label`, `plugin.translation`.description as `plugin.translation.description`, `plugin.translation`.manufacturer_link as `plugin.translation.manufacturerLink`, `plugin.translation`.support_link as `plugin.translation.supportLink`, `plugin.translation`.changelog as `plugin.translation.changelog`, `plugin.translation`.custom_fields as `plugin.translation.customFields`, `plugin.translation`.created_at as `plugin.translation.createdAt`, `plugin.translation`.updated_at as `plugin.translation.updatedAt`, `plugin.translation`.plugin_id as `plugin.translation.pluginId`, `plugin.translation`.language_id as `plugin.translation.languageId` FROM `plugin_translation` `plugin.translation` WHERE `plugin.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `plugin.plugin_translation` ON `plugin.plugin_translation`.`plugin_id` = `plugin`.`id` WHERE (`plugin`.`active` = 0); array:19 [0 => "Shopware\Core\Profiling\Doctrine\DebugStack::stopQuery (line 1322)" 1 => "Doctrine\DBAL\Connection::executeQuery (line 212)" 2 => "Doctrine\DBAL\Query\QueryBuilder::execute (line 262)" 3 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::fetch (line 109)" 4 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::_read (line 79)" 5 => "Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader::read (line 36)" 6 => "Shopware\Core\Profiling\Entity\EntityReaderProfiler::read (line 270)" 7 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::read (line 115)" 8 => "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search (line 129)" 9 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::getNotActivatedPlugins (line 109)" 10 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::filterNotActivatedPlugins (line 84)" 11 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::buildSystemConfigArray (line 71)" 12 => "Shopware\Core\System\SystemConfig\SystemConfigLoader::load (line 49)" 13 => "Shopware\Core\System\SystemConfig\CachedSystemConfigLoader::load (line 372)" 14 => "Shopware\Core\System\SystemConfig\SystemConfigService::load (line 95)" 15 => "Shopware\Core\System\SystemConfig\SystemConfigService::get (line 33)" 16 => "Shopware\Core\Framework\Routing\CanonicalRedirectService::getRedirect (line 165)" 17 => "Shopware\Core\HttpKernel::doHandle (line 81)" 18 => "Shopware\Core\HttpKernel::handle (line 48)"]

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.

Symfony Profiler

https://shop.kaylolife.com/robots.txt

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

Symfony Profiler

https://shop.kaylolife.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping