Symfony Profiler

Query Metrics

32 Database Queries

26 Different statements

9.57 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

1.65 ms
(17.25%)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "CogiCookieBannerPopup"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `app`.`id` as `app.id`,
  `app`.`name` as `app.name`,
  `app`.`path` as `app.path`,
  `app`.`author` as `app.author`,
  `app`.`copyright` as `app.copyright`,
  `app`.`license` as `app.license`,
  `app`.`active` as `app.active`,
  `app`.`configurable` as `app.configurable`,
  `app`.`privacy` as `app.privacy`,
  `app`.`version` as `app.version`,
  `app`.`icon` as `app.iconRaw`,
  `app`.`app_secret` as `app.appSecret`,
  `app`.`modules` as `app.modules`,
  `app`.`main_module` as `app.mainModule`,
  `app`.`cookies` as `app.cookies`,
  `app`.`allow_disable` as `app.allowDisable`,
  `app`.`base_app_url` as `app.baseAppUrl`,
  `app`.`allowed_hosts` as `app.allowedHosts`,
  `app`.`template_load_priority` as `app.templateLoadPriority`,
  `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`,
  `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`,
  `app`.`source_type` as `app.sourceType`,
  `app`.`source_config` as `app.sourceConfig`,
  `app`.`self_managed` as `app.selfManaged`,
  `app`.`integration_id` as `app.integrationId`,
  `app.integration`.`id` as `app.integration.id`,
  `app.integration`.`label` as `app.integration.label`,
  `app.integration`.`access_key` as `app.integration.accessKey`,
  `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`,
  `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`,
  `app.integration`.`admin` as `app.integration.admin`,
  `app.integration`.`custom_fields` as `app.integration.customFields`,
  `app.integration`.`deleted_at` as `app.integration.deletedAt`,
  `app.integration`.`created_at` as `app.integration.createdAt`,
  `app.integration`.`updated_at` as `app.integration.updatedAt`,
  `app`.`acl_role_id` as `app.aclRoleId`,
  `app.aclRole`.`id` as `app.aclRole.id`,
  `app.aclRole`.`name` as `app.aclRole.name`,
  `app.aclRole`.`description` as `app.aclRole.description`,
  `app.aclRole`.`privileges` as `app.aclRole.privileges`,
  `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`,
  `app.aclRole`.`created_at` as `app.aclRole.createdAt`,
  `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`,
  `app`.`created_at` as `app.createdAt`,
  `app`.`updated_at` as `app.updatedAt`,
  `app.translation.label`,
  `app.translation.label` as `app.label`,
  `app.translation.description`,
  `app.translation.description` as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  `app.translation.customFields` as `app.customFields`
FROM
  `app`
  LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id`
  LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id`
  LEFT JOIN (
    SELECT
      `app.translation`.`app_id`,
      `app.translation`.`label` as `app.translation.label`,
      `app.translation`.`description` as `app.translation.description`,
      `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`,
      `app.translation`.`custom_fields` as `app.translation.customFields`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.`language_id` = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
WHERE
  (`app`.`name` = ?)

SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`checkout_gateway_url` as `app.checkoutGatewayUrl`, `app`.`in_app_purchases_gateway_url` as `app.inAppPurchasesGatewayUrl`, `app`.`source_type` as `app.sourceType`, `app`.`source_config` as `app.sourceConfig`, `app`.`self_managed` as `app.selfManaged`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, `app.translation.label` as `app.label`, `app.translation.description`, `app.translation.description` as `app.description`, `app.translation.privacyPolicyExtensions`, `app.translation.privacyPolicyExtensions` as `app.privacyPolicyExtensions`, `app.translation.customFields`, `app.translation.customFields` as `app.customFields` FROM `app` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` LEFT JOIN (SELECT `app.translation`.`app_id`, `app.translation`.`label` as `app.translation.label`, `app.translation`.`description` as `app.translation.description`, `app.translation`.`privacy_policy_extensions` as `app.translation.privacyPolicyExtensions`, `app.translation`.`custom_fields` as `app.translation.customFields` FROM `app_translation` `app.translation` WHERE `app.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` WHERE (`app`.`name` = 'CogiCookieBannerPopup');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 76)
9	Shopware\Core\Framework\App\Source\SourceResolver->filesystemForAppName (line 60)
10	Shopware\Storefront\Theme\StorefrontPluginConfiguration\StorefrontPluginConfigurationFactory->createFromApp (line 65)
11	Shopware\Storefront\Theme\StorefrontPluginRegistry->addAppConfigs (line 39)
12	Shopware\Storefront\Theme\StorefrontPluginRegistry->getConfigurations (line 290)
13	Shopware\Storefront\Framework\Routing\StorefrontSubscriber->addIconSetConfig (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
21	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
22	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

1.05 ms
(10.93%)

SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, ? REGEXP `old_url_regex` as regex0, ? REGEXP `old_url_regex` as regex2, ? REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = ? AND ((NOT (`search_url_by` = ?) AND ((`old_url` = ? OR `old_url` = ? OR `old_url` = ?))) OR (`search_url_by` = ? AND ((? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex` OR ? REGEXP `old_url_regex`)))) LIMIT 6;

Parameters:

[
  "/sitemap.xml"
  "https://stage.bar-tek.com/sitemap.xml"
  "stage.bar-tek.com/sitemap.xml"
  1
  "regex"
  "/sitemap.xml"
  "https://stage.bar-tek.com/sitemap.xml"
  "stage.bar-tek.com/sitemap.xml"
  "regex"
  "/sitemap.xml"
  "https://stage.bar-tek.com/sitemap.xml"
  "stage.bar-tek.com/sitemap.xml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `id`,
  `old_url`,
  `new_url`,
  `old_url_regex`,
  `search_url_by`,
  `temporary`,
  ? REGEXP `old_url_regex` as regex0,
  ? REGEXP `old_url_regex` as regex2,
  ? REGEXP `old_url_regex` as regex3
FROM
  `acris_seo_redirect`
WHERE
  `active` = ?
  AND (
    (
      NOT (`search_url_by` = ?)
      AND (
        (
          `old_url` = ?
          OR `old_url` = ?
          OR `old_url` = ?
        )
      )
    )
    OR (
      `search_url_by` = ?
      AND (
        (
          ? REGEXP `old_url_regex`
          OR ? REGEXP `old_url_regex`
          OR ? REGEXP `old_url_regex`
        )
      )
    )
  )
LIMIT
  6;

SELECT `id`, `old_url`, `new_url`, `old_url_regex`, `search_url_by` ,`temporary`, '/sitemap.xml' REGEXP `old_url_regex` as regex0, 'https://stage.bar-tek.com/sitemap.xml' REGEXP `old_url_regex` as regex2, 'stage.bar-tek.com/sitemap.xml' REGEXP `old_url_regex` as regex3 FROM `acris_seo_redirect` WHERE `active` = 1 AND ((NOT (`search_url_by` = 'regex') AND ((`old_url` = '/sitemap.xml' OR `old_url` = 'https://stage.bar-tek.com/sitemap.xml' OR `old_url` = 'stage.bar-tek.com/sitemap.xml'))) OR (`search_url_by` = 'regex' AND (('/sitemap.xml' REGEXP `old_url_regex` OR 'https://stage.bar-tek.com/sitemap.xml' REGEXP `old_url_regex` OR 'stage.bar-tek.com/sitemap.xml' REGEXP `old_url_regex`)))) LIMIT 6;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 245)
2	Acris\SeoRedirect\Components\RedirectService->searchRedirect (line 35)
3	Acris\SeoRedirect\Components\RedirectService->checkRedirect (line 54)
4	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
5	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
6	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
7	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
8	Shopware\Core\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

0.77 ms
(8.05%)

SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> ?)

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`,
  `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`,
  `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`,
  `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`,
  `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`,
  `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt`
FROM
  `dreisc_seo_setting`
WHERE
  (
    `dreisc_seo_setting`.`sales_channel_id` <=> ?
  )

SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 192)
9	DreiscSeoPro\Core\Foundation\Dal\EntityRepository->search (line 152)
10	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->fetchCustomSettingsBySalesChannelId (line 106)
11	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->load (line 32)
12	DreiscSeoPro\Core\CustomSetting\CustomSettingLoader->load (line 26)
13	DreiscSeoPro\Decorator\Storefront\Framework\Twig\TemplateDataExtensionDecorator->getGlobals (line 332)
14	Twig\ExtensionSet->getGlobals (line 824)
15	Twig\Environment->getGlobals (line 389)
16	Twig\Template->yield (line 377)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 306)
19	Twig\Environment->render (line 277)
20	Shopware\Storefront\Controller\StorefrontController->renderView (line 291)
21	Shopware\Storefront\Controller\StorefrontController->render (line 92)
22	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 92)
24	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
25	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
28	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 10)

0.54 ms
(5.60%)

SELECT seo_path_info FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?) AND (is_canonical = ?) AND (is_deleted = ?) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1

Parameters:

[
  b"ÞDW\x1DÜNM\x00•À\x1Aöî)“Q"
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  "sitemap.xml"
  1
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  seo_path_info
FROM
  seo_url
WHERE
  (language_id = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
  AND (seo_path_info = ?)
  AND (is_canonical = ?)
  AND (is_deleted = ?)
ORDER BY
  seo_path_info ASC,
  sales_channel_id IS NULL ASC
LIMIT
  1

SELECT seo_path_info FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351) AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL)) AND (seo_path_info = 'sitemap.xml') AND (is_canonical = 1) AND (is_deleted = 0) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 384)
3	Doctrine\DBAL\Query\QueryBuilder->execute (line 203)
4	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->getSeoPathByAltSeoPath (line 44)
5	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->resolve (line 40)
6	NetInventors\NetiNextStoreLocator\Core\Content\Seo\SeoResolverDecorator->resolve (line 35)
7	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 319)
8	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 118)
9	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 30)
10	DreiscSeoPro\Decorator\Shopware\Storefront\Routing\RequestTransformerDecorator->transform (line 33)
11	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
12	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
13	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
14	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
15	Shopware\Core\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

0.49 ms
(5.16%)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.salesChannel`.`id` as `sales_channel_domain.salesChannel.id`, `sales_channel_domain.salesChannel`.`type_id` as `sales_channel_domain.salesChannel.typeId`, `sales_channel_domain.salesChannel`.`language_id` as `sales_channel_domain.salesChannel.languageId`, `sales_channel_domain.salesChannel`.`customer_group_id` as `sales_channel_domain.salesChannel.customerGroupId`, `sales_channel_domain.salesChannel`.`currency_id` as `sales_channel_domain.salesChannel.currencyId`, `sales_channel_domain.salesChannel`.`payment_method_id` as `sales_channel_domain.salesChannel.paymentMethodId`, `sales_channel_domain.salesChannel`.`shipping_method_id` as `sales_channel_domain.salesChannel.shippingMethodId`, `sales_channel_domain.salesChannel`.`country_id` as `sales_channel_domain.salesChannel.countryId`, `sales_channel_domain.salesChannel`.`analytics_id` as `sales_channel_domain.salesChannel.analyticsId`, `sales_channel_domain.salesChannel`.`navigation_category_id` as `sales_channel_domain.salesChannel.navigationCategoryId`, `sales_channel_domain.salesChannel`.`navigation_category_version_id` as `sales_channel_domain.salesChannel.navigationCategoryVersionId`, `sales_channel_domain.salesChannel`.`navigation_category_depth` as `sales_channel_domain.salesChannel.navigationCategoryDepth`, `sales_channel_domain.salesChannel`.`footer_category_id` as `sales_channel_domain.salesChannel.footerCategoryId`, `sales_channel_domain.salesChannel`.`footer_category_version_id` as `sales_channel_domain.salesChannel.footerCategoryVersionId`, `sales_channel_domain.salesChannel`.`service_category_id` as `sales_channel_domain.salesChannel.serviceCategoryId`, `sales_channel_domain.salesChannel`.`service_category_version_id` as `sales_channel_domain.salesChannel.serviceCategoryVersionId`, `sales_channel_domain.salesChannel`.`mail_header_footer_id` as `sales_channel_domain.salesChannel.mailHeaderFooterId`, `sales_channel_domain.salesChannel`.`hreflang_default_domain_id` as `sales_channel_domain.salesChannel.hreflangDefaultDomainId`, `sales_channel_domain.salesChannel`.`short_name` as `sales_channel_domain.salesChannel.shortName`, `sales_channel_domain.salesChannel`.`tax_calculation_type` as `sales_channel_domain.salesChannel.taxCalculationType`, `sales_channel_domain.salesChannel`.`access_key` as `sales_channel_domain.salesChannel.accessKey`, `sales_channel_domain.salesChannel`.`configuration` as `sales_channel_domain.salesChannel.configuration`, `sales_channel_domain.salesChannel`.`active` as `sales_channel_domain.salesChannel.active`, `sales_channel_domain.salesChannel`.`hreflang_active` as `sales_channel_domain.salesChannel.hreflangActive`, `sales_channel_domain.salesChannel`.`maintenance` as `sales_channel_domain.salesChannel.maintenance`, `sales_channel_domain.salesChannel`.`maintenance_ip_whitelist` as `sales_channel_domain.salesChannel.maintenanceIpWhitelist`, `sales_channel_domain.salesChannel`.`payment_method_ids` as `sales_channel_domain.salesChannel.paymentMethodIds`, `sales_channel_domain.salesChannel`.`home_cms_page_id` as `sales_channel_domain.salesChannel.homeCmsPageId`, `sales_channel_domain.salesChannel`.`home_cms_page_version_id` as `sales_channel_domain.salesChannel.homeCmsPageVersionId`, `sales_channel_domain.salesChannel`.`created_at` as `sales_channel_domain.salesChannel.createdAt`, `sales_channel_domain.salesChannel`.`updated_at` as `sales_channel_domain.salesChannel.updatedAt`, `sales_channel_domain.salesChannel.translation.name`, `sales_channel_domain.salesChannel.translation.name` as `sales_channel_domain.salesChannel.name`, `sales_channel_domain.salesChannel.translation.homeSlotConfig`, `sales_channel_domain.salesChannel.translation.homeSlotConfig` as `sales_channel_domain.salesChannel.homeSlotConfig`, `sales_channel_domain.salesChannel.translation.homeEnabled`, `sales_channel_domain.salesChannel.translation.homeEnabled` as `sales_channel_domain.salesChannel.homeEnabled`, `sales_channel_domain.salesChannel.translation.homeName`, `sales_channel_domain.salesChannel.translation.homeName` as `sales_channel_domain.salesChannel.homeName`, `sales_channel_domain.salesChannel.translation.homeMetaTitle`, `sales_channel_domain.salesChannel.translation.homeMetaTitle` as `sales_channel_domain.salesChannel.homeMetaTitle`, `sales_channel_domain.salesChannel.translation.homeMetaDescription`, `sales_channel_domain.salesChannel.translation.homeMetaDescription` as `sales_channel_domain.salesChannel.homeMetaDescription`, `sales_channel_domain.salesChannel.translation.homeKeywords`, `sales_channel_domain.salesChannel.translation.homeKeywords` as `sales_channel_domain.salesChannel.homeKeywords`, `sales_channel_domain.salesChannel.translation.customFields`, `sales_channel_domain.salesChannel.translation.customFields` as `sales_channel_domain.salesChannel.customFields` FROM `sales_channel_domain` LEFT JOIN `sales_channel` `sales_channel_domain.salesChannel` ON `sales_channel_domain`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` LEFT JOIN (SELECT `sales_channel_domain.salesChannel.translation`.`sales_channel_id`, `sales_channel_domain.salesChannel.translation`.`name` as `sales_channel_domain.salesChannel.translation.name`, `sales_channel_domain.salesChannel.translation`.`custom_fields` as `sales_channel_domain.salesChannel.translation.customFields`, `sales_channel_domain.salesChannel.translation`.`home_slot_config` as `sales_channel_domain.salesChannel.translation.homeSlotConfig`, `sales_channel_domain.salesChannel.translation`.`home_enabled` as `sales_channel_domain.salesChannel.translation.homeEnabled`, `sales_channel_domain.salesChannel.translation`.`home_name` as `sales_channel_domain.salesChannel.translation.homeName`, `sales_channel_domain.salesChannel.translation`.`home_meta_title` as `sales_channel_domain.salesChannel.translation.homeMetaTitle`, `sales_channel_domain.salesChannel.translation`.`home_meta_description` as `sales_channel_domain.salesChannel.translation.homeMetaDescription`, `sales_channel_domain.salesChannel.translation`.`home_keywords` as `sales_channel_domain.salesChannel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel_domain.salesChannel.translation` WHERE `sales_channel_domain.salesChannel.translation`.`language_id` = ?) `sales_channel_domain.salesChannel.sales_channel_translation` ON `sales_channel_domain.salesChannel.sales_channel_translation`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` WHERE `sales_channel_domain`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"L\\x15Ö\x08\eIUØƒS\x0F╔Jsj"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel_domain`.`id` as `sales_channel_domain.id`,
  `sales_channel_domain`.`url` as `sales_channel_domain.url`,
  `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`,
  `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`,
  `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`,
  `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`,
  `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`,
  `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`,
  `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`,
  `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`,
  `sales_channel_domain.salesChannel`.`id` as `sales_channel_domain.salesChannel.id`,
  `sales_channel_domain.salesChannel`.`type_id` as `sales_channel_domain.salesChannel.typeId`,
  `sales_channel_domain.salesChannel`.`language_id` as `sales_channel_domain.salesChannel.languageId`,
  `sales_channel_domain.salesChannel`.`customer_group_id` as `sales_channel_domain.salesChannel.customerGroupId`,
  `sales_channel_domain.salesChannel`.`currency_id` as `sales_channel_domain.salesChannel.currencyId`,
  `sales_channel_domain.salesChannel`.`payment_method_id` as `sales_channel_domain.salesChannel.paymentMethodId`,
  `sales_channel_domain.salesChannel`.`shipping_method_id` as `sales_channel_domain.salesChannel.shippingMethodId`,
  `sales_channel_domain.salesChannel`.`country_id` as `sales_channel_domain.salesChannel.countryId`,
  `sales_channel_domain.salesChannel`.`analytics_id` as `sales_channel_domain.salesChannel.analyticsId`,
  `sales_channel_domain.salesChannel`.`navigation_category_id` as `sales_channel_domain.salesChannel.navigationCategoryId`,
  `sales_channel_domain.salesChannel`.`navigation_category_version_id` as `sales_channel_domain.salesChannel.navigationCategoryVersionId`,
  `sales_channel_domain.salesChannel`.`navigation_category_depth` as `sales_channel_domain.salesChannel.navigationCategoryDepth`,
  `sales_channel_domain.salesChannel`.`footer_category_id` as `sales_channel_domain.salesChannel.footerCategoryId`,
  `sales_channel_domain.salesChannel`.`footer_category_version_id` as `sales_channel_domain.salesChannel.footerCategoryVersionId`,
  `sales_channel_domain.salesChannel`.`service_category_id` as `sales_channel_domain.salesChannel.serviceCategoryId`,
  `sales_channel_domain.salesChannel`.`service_category_version_id` as `sales_channel_domain.salesChannel.serviceCategoryVersionId`,
  `sales_channel_domain.salesChannel`.`mail_header_footer_id` as `sales_channel_domain.salesChannel.mailHeaderFooterId`,
  `sales_channel_domain.salesChannel`.`hreflang_default_domain_id` as `sales_channel_domain.salesChannel.hreflangDefaultDomainId`,
  `sales_channel_domain.salesChannel`.`short_name` as `sales_channel_domain.salesChannel.shortName`,
  `sales_channel_domain.salesChannel`.`tax_calculation_type` as `sales_channel_domain.salesChannel.taxCalculationType`,
  `sales_channel_domain.salesChannel`.`access_key` as `sales_channel_domain.salesChannel.accessKey`,
  `sales_channel_domain.salesChannel`.`configuration` as `sales_channel_domain.salesChannel.configuration`,
  `sales_channel_domain.salesChannel`.`active` as `sales_channel_domain.salesChannel.active`,
  `sales_channel_domain.salesChannel`.`hreflang_active` as `sales_channel_domain.salesChannel.hreflangActive`,
  `sales_channel_domain.salesChannel`.`maintenance` as `sales_channel_domain.salesChannel.maintenance`,
  `sales_channel_domain.salesChannel`.`maintenance_ip_whitelist` as `sales_channel_domain.salesChannel.maintenanceIpWhitelist`,
  `sales_channel_domain.salesChannel`.`payment_method_ids` as `sales_channel_domain.salesChannel.paymentMethodIds`,
  `sales_channel_domain.salesChannel`.`home_cms_page_id` as `sales_channel_domain.salesChannel.homeCmsPageId`,
  `sales_channel_domain.salesChannel`.`home_cms_page_version_id` as `sales_channel_domain.salesChannel.homeCmsPageVersionId`,
  `sales_channel_domain.salesChannel`.`created_at` as `sales_channel_domain.salesChannel.createdAt`,
  `sales_channel_domain.salesChannel`.`updated_at` as `sales_channel_domain.salesChannel.updatedAt`,
  `sales_channel_domain.salesChannel.translation.name`,
  `sales_channel_domain.salesChannel.translation.name` as `sales_channel_domain.salesChannel.name`,
  `sales_channel_domain.salesChannel.translation.homeSlotConfig`,
  `sales_channel_domain.salesChannel.translation.homeSlotConfig` as `sales_channel_domain.salesChannel.homeSlotConfig`,
  `sales_channel_domain.salesChannel.translation.homeEnabled`,
  `sales_channel_domain.salesChannel.translation.homeEnabled` as `sales_channel_domain.salesChannel.homeEnabled`,
  `sales_channel_domain.salesChannel.translation.homeName`,
  `sales_channel_domain.salesChannel.translation.homeName` as `sales_channel_domain.salesChannel.homeName`,
  `sales_channel_domain.salesChannel.translation.homeMetaTitle`,
  `sales_channel_domain.salesChannel.translation.homeMetaTitle` as `sales_channel_domain.salesChannel.homeMetaTitle`,
  `sales_channel_domain.salesChannel.translation.homeMetaDescription`,
  `sales_channel_domain.salesChannel.translation.homeMetaDescription` as `sales_channel_domain.salesChannel.homeMetaDescription`,
  `sales_channel_domain.salesChannel.translation.homeKeywords`,
  `sales_channel_domain.salesChannel.translation.homeKeywords` as `sales_channel_domain.salesChannel.homeKeywords`,
  `sales_channel_domain.salesChannel.translation.customFields`,
  `sales_channel_domain.salesChannel.translation.customFields` as `sales_channel_domain.salesChannel.customFields`
FROM
  `sales_channel_domain`
  LEFT JOIN `sales_channel` `sales_channel_domain.salesChannel` ON `sales_channel_domain`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel_domain.salesChannel.translation`.`sales_channel_id`,
      `sales_channel_domain.salesChannel.translation`.`name` as `sales_channel_domain.salesChannel.translation.name`,
      `sales_channel_domain.salesChannel.translation`.`custom_fields` as `sales_channel_domain.salesChannel.translation.customFields`,
      `sales_channel_domain.salesChannel.translation`.`home_slot_config` as `sales_channel_domain.salesChannel.translation.homeSlotConfig`,
      `sales_channel_domain.salesChannel.translation`.`home_enabled` as `sales_channel_domain.salesChannel.translation.homeEnabled`,
      `sales_channel_domain.salesChannel.translation`.`home_name` as `sales_channel_domain.salesChannel.translation.homeName`,
      `sales_channel_domain.salesChannel.translation`.`home_meta_title` as `sales_channel_domain.salesChannel.translation.homeMetaTitle`,
      `sales_channel_domain.salesChannel.translation`.`home_meta_description` as `sales_channel_domain.salesChannel.translation.homeMetaDescription`,
      `sales_channel_domain.salesChannel.translation`.`home_keywords` as `sales_channel_domain.salesChannel.translation.homeKeywords`
    FROM
      `sales_channel_translation` `sales_channel_domain.salesChannel.translation`
    WHERE
      `sales_channel_domain.salesChannel.translation`.`language_id` = ?
  ) `sales_channel_domain.salesChannel.sales_channel_translation` ON `sales_channel_domain.salesChannel.sales_channel_translation`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id`
WHERE
  `sales_channel_domain`.`id` IN (?)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.salesChannel`.`id` as `sales_channel_domain.salesChannel.id`, `sales_channel_domain.salesChannel`.`type_id` as `sales_channel_domain.salesChannel.typeId`, `sales_channel_domain.salesChannel`.`language_id` as `sales_channel_domain.salesChannel.languageId`, `sales_channel_domain.salesChannel`.`customer_group_id` as `sales_channel_domain.salesChannel.customerGroupId`, `sales_channel_domain.salesChannel`.`currency_id` as `sales_channel_domain.salesChannel.currencyId`, `sales_channel_domain.salesChannel`.`payment_method_id` as `sales_channel_domain.salesChannel.paymentMethodId`, `sales_channel_domain.salesChannel`.`shipping_method_id` as `sales_channel_domain.salesChannel.shippingMethodId`, `sales_channel_domain.salesChannel`.`country_id` as `sales_channel_domain.salesChannel.countryId`, `sales_channel_domain.salesChannel`.`analytics_id` as `sales_channel_domain.salesChannel.analyticsId`, `sales_channel_domain.salesChannel`.`navigation_category_id` as `sales_channel_domain.salesChannel.navigationCategoryId`, `sales_channel_domain.salesChannel`.`navigation_category_version_id` as `sales_channel_domain.salesChannel.navigationCategoryVersionId`, `sales_channel_domain.salesChannel`.`navigation_category_depth` as `sales_channel_domain.salesChannel.navigationCategoryDepth`, `sales_channel_domain.salesChannel`.`footer_category_id` as `sales_channel_domain.salesChannel.footerCategoryId`, `sales_channel_domain.salesChannel`.`footer_category_version_id` as `sales_channel_domain.salesChannel.footerCategoryVersionId`, `sales_channel_domain.salesChannel`.`service_category_id` as `sales_channel_domain.salesChannel.serviceCategoryId`, `sales_channel_domain.salesChannel`.`service_category_version_id` as `sales_channel_domain.salesChannel.serviceCategoryVersionId`, `sales_channel_domain.salesChannel`.`mail_header_footer_id` as `sales_channel_domain.salesChannel.mailHeaderFooterId`, `sales_channel_domain.salesChannel`.`hreflang_default_domain_id` as `sales_channel_domain.salesChannel.hreflangDefaultDomainId`, `sales_channel_domain.salesChannel`.`short_name` as `sales_channel_domain.salesChannel.shortName`, `sales_channel_domain.salesChannel`.`tax_calculation_type` as `sales_channel_domain.salesChannel.taxCalculationType`, `sales_channel_domain.salesChannel`.`access_key` as `sales_channel_domain.salesChannel.accessKey`, `sales_channel_domain.salesChannel`.`configuration` as `sales_channel_domain.salesChannel.configuration`, `sales_channel_domain.salesChannel`.`active` as `sales_channel_domain.salesChannel.active`, `sales_channel_domain.salesChannel`.`hreflang_active` as `sales_channel_domain.salesChannel.hreflangActive`, `sales_channel_domain.salesChannel`.`maintenance` as `sales_channel_domain.salesChannel.maintenance`, `sales_channel_domain.salesChannel`.`maintenance_ip_whitelist` as `sales_channel_domain.salesChannel.maintenanceIpWhitelist`, `sales_channel_domain.salesChannel`.`payment_method_ids` as `sales_channel_domain.salesChannel.paymentMethodIds`, `sales_channel_domain.salesChannel`.`home_cms_page_id` as `sales_channel_domain.salesChannel.homeCmsPageId`, `sales_channel_domain.salesChannel`.`home_cms_page_version_id` as `sales_channel_domain.salesChannel.homeCmsPageVersionId`, `sales_channel_domain.salesChannel`.`created_at` as `sales_channel_domain.salesChannel.createdAt`, `sales_channel_domain.salesChannel`.`updated_at` as `sales_channel_domain.salesChannel.updatedAt`, `sales_channel_domain.salesChannel.translation.name`, `sales_channel_domain.salesChannel.translation.name` as `sales_channel_domain.salesChannel.name`, `sales_channel_domain.salesChannel.translation.homeSlotConfig`, `sales_channel_domain.salesChannel.translation.homeSlotConfig` as `sales_channel_domain.salesChannel.homeSlotConfig`, `sales_channel_domain.salesChannel.translation.homeEnabled`, `sales_channel_domain.salesChannel.translation.homeEnabled` as `sales_channel_domain.salesChannel.homeEnabled`, `sales_channel_domain.salesChannel.translation.homeName`, `sales_channel_domain.salesChannel.translation.homeName` as `sales_channel_domain.salesChannel.homeName`, `sales_channel_domain.salesChannel.translation.homeMetaTitle`, `sales_channel_domain.salesChannel.translation.homeMetaTitle` as `sales_channel_domain.salesChannel.homeMetaTitle`, `sales_channel_domain.salesChannel.translation.homeMetaDescription`, `sales_channel_domain.salesChannel.translation.homeMetaDescription` as `sales_channel_domain.salesChannel.homeMetaDescription`, `sales_channel_domain.salesChannel.translation.homeKeywords`, `sales_channel_domain.salesChannel.translation.homeKeywords` as `sales_channel_domain.salesChannel.homeKeywords`, `sales_channel_domain.salesChannel.translation.customFields`, `sales_channel_domain.salesChannel.translation.customFields` as `sales_channel_domain.salesChannel.customFields` FROM `sales_channel_domain` LEFT JOIN `sales_channel` `sales_channel_domain.salesChannel` ON `sales_channel_domain`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` LEFT JOIN (SELECT `sales_channel_domain.salesChannel.translation`.`sales_channel_id`, `sales_channel_domain.salesChannel.translation`.`name` as `sales_channel_domain.salesChannel.translation.name`, `sales_channel_domain.salesChannel.translation`.`custom_fields` as `sales_channel_domain.salesChannel.translation.customFields`, `sales_channel_domain.salesChannel.translation`.`home_slot_config` as `sales_channel_domain.salesChannel.translation.homeSlotConfig`, `sales_channel_domain.salesChannel.translation`.`home_enabled` as `sales_channel_domain.salesChannel.translation.homeEnabled`, `sales_channel_domain.salesChannel.translation`.`home_name` as `sales_channel_domain.salesChannel.translation.homeName`, `sales_channel_domain.salesChannel.translation`.`home_meta_title` as `sales_channel_domain.salesChannel.translation.homeMetaTitle`, `sales_channel_domain.salesChannel.translation`.`home_meta_description` as `sales_channel_domain.salesChannel.translation.homeMetaDescription`, `sales_channel_domain.salesChannel.translation`.`home_keywords` as `sales_channel_domain.salesChannel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel_domain.salesChannel.translation` WHERE `sales_channel_domain.salesChannel.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel_domain.salesChannel.sales_channel_translation` ON `sales_channel_domain.salesChannel.sales_channel_translation`.`sales_channel_id` = `sales_channel_domain.salesChannel`.`id` WHERE `sales_channel_domain`.`id` IN (0x4C5C1599081B49559D9F530FC94A736A);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 169)
9	Acris\ShopSwitch\Components\ShopSwitchHelperService->getDomainById (line 65)
10	Acris\ShopSwitch\Components\ShopSwitch\ShopSwitchRoute->load (line 93)
11	Acris\ShopSwitch\Core\System\SalesChannel\Context\SalesChannelContextFactory->create (line 94)
12	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 61)
14	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
15	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
16	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.48 ms
(4.98%)

SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?, ?, ?)

Parameters:

[
  "/sitemap.xml"
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  b"T”²K\tÔEë¬äq\x12ƒkDX"
  b"/7┐ð‗?H+¡Ø4á!ÖIø"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ÞDW\x1DÜNM\x00•À\x1Aöî)“Q"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `seo_path_info` AS seoPathInfo,
  `language_id` AS languageId
FROM
  `seo_url`
WHERE
  `path_info` = ?
  AND `is_canonical` = 1
  AND `sales_channel_id` = ?
  AND `language_id` IN (?, ?, ?, ?)

SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = '/sitemap.xml' AND `is_canonical` = 1 AND
                  `sales_channel_id` = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE AND `language_id` IN (0x5494B24B09D445EBACE47112836B4458, 0x2F37BFD0F23F482BAD9D34A02199499B, 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, 0xDE44571DDC4E4D0095C01AF6EE299351);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 169)
3	Shopware\Core\Content\Seo\HreflangLoader->fetchSeoUrls (line 42)
4	Shopware\Core\Content\Seo\HreflangLoader->load (line 256)
5	Shopware\Storefront\Framework\Routing\StorefrontSubscriber->addHreflang (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
14	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.43 ms
(4.50%)

# 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
1	Doctrine\DBAL\Connection->executeQuery (line 40)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 115)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 179)
4	Shopware\Core\Kernel->boot (line 152)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 10)

0.29 ms
(3.06%)

SELECT `acris_switch_rule`.`id` FROM `acris_switch_rule` LEFT JOIN `acris_switch_domain` `acris_switch_rule.domains` ON `acris_switch_rule`.`id` = `acris_switch_rule.domains`.`rule_id` WHERE ((`acris_switch_rule.domains`.`domain_id` = ? AND `acris_switch_rule.domains`.`active` = ?) AND `acris_switch_rule`.`active` = ?) GROUP BY `acris_switch_rule`.`id`

Parameters:

[
  b"L\\x15Ö\x08\eIUØƒS\x0F╔Jsj"
  true
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `acris_switch_rule`.`id`
FROM
  `acris_switch_rule`
  LEFT JOIN `acris_switch_domain` `acris_switch_rule.domains` ON `acris_switch_rule`.`id` = `acris_switch_rule.domains`.`rule_id`
WHERE
  (
    (
      `acris_switch_rule.domains`.`domain_id` = ?
      AND `acris_switch_rule.domains`.`active` = ?
    )
    AND `acris_switch_rule`.`active` = ?
  )
GROUP BY
  `acris_switch_rule`.`id`

SELECT `acris_switch_rule`.`id` FROM `acris_switch_rule` LEFT JOIN `acris_switch_domain` `acris_switch_rule.domains` ON `acris_switch_rule`.`id` = `acris_switch_rule.domains`.`rule_id` WHERE ((`acris_switch_rule.domains`.`domain_id` = 0x4C5C1599081B49559D9F530FC94A736A AND `acris_switch_rule.domains`.`active` = 1) AND `acris_switch_rule`.`active` = 1) GROUP BY `acris_switch_rule`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 294)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 80)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 237)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 20)
9	Acris\ShopSwitch\Components\ShopSwitchRuleGateway->getActiveRuleByDomain (line 83)
10	Acris\ShopSwitch\Components\ShopSwitch\ShopSwitchRoute->load (line 93)
11	Acris\ShopSwitch\Core\System\SalesChannel\Context\SalesChannelContextFactory->create (line 94)
12	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 61)
14	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
15	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
16	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
17	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
21	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
22	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
23	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
27	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 10)

0.29 ms
(3.03%)

SELECT configuration_value FROM system_config WHERE (configuration_key = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) ORDER BY sales_channel_id IS NULL ASC LIMIT 1

Parameters:

[
  "NetiNextStoreLocator.config.seoUrl"
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  configuration_value
FROM
  system_config
WHERE
  (configuration_key = ?)
  AND (
    (
      sales_channel_id = ?
      OR sales_channel_id IS NULL
    )
  )
ORDER BY
  sales_channel_id IS NULL ASC
LIMIT
  1

SELECT configuration_value FROM system_config WHERE (configuration_key = 'NetiNextStoreLocator.config.seoUrl') AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL)) ORDER BY sales_channel_id IS NULL ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 271)
3	Doctrine\DBAL\Query\QueryBuilder->fetchOne (line 61)
4	NetInventors\NetiNextStoreLocator\Core\Content\Seo\SeoResolverDecorator->getSeoUrl (line 27)
5	NetInventors\NetiNextStoreLocator\Core\Content\Seo\SeoResolverDecorator->resolve (line 35)
6	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 319)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 118)
8	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 30)
9	DreiscSeoPro\Decorator\Shopware\Storefront\Routing\RequestTransformerDecorator->transform (line 33)
10	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
11	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
13	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
14	Shopware\Core\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 10)

0.28 ms
(2.95%)

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `type`
FROM
  `custom_field`
WHERE
  `active` = 1

SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 919)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 130)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 46)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 102)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 87)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->decode (line 405)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->customFields (line 251)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateFields (line 178)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->assign (line 589)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 382)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->manyToOne (line 217)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateFields (line 178)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->assign (line 589)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 97)
15	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrate (line 135)
16	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
17	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
19	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
20	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 169)
21	Acris\ShopSwitch\Components\ShopSwitchHelperService->getDomainById (line 65)
22	Acris\ShopSwitch\Components\ShopSwitch\ShopSwitchRoute->load (line 93)
23	Acris\ShopSwitch\Core\System\SalesChannel\Context\SalesChannelContextFactory->create (line 94)
24	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
25	Shopware\Core\Profiling\Profiler::trace (line 61)
26	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
27	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
28	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
29	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
33	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
34	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
35	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
39	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
40	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
41	Shopware\Core\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 10)

0.27 ms
(2.80%)

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1

Parameters:

[
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  "hA0UqkIpKzCA1V3gF95nWsbRgPx61ukQ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  sales_channel_api_context
WHERE
  (sales_channel_id = ?)
  AND (token = ?)
LIMIT
  1

SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE) AND (token = 'hA0UqkIpKzCA1V3gF95nWsbRgPx61ukQ') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 64)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 61)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
8	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 10)

0.26 ms
(2.74%)

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
1	Doctrine\DBAL\Connection->executeQuery (line 919)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 70)
3	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line 36)
4	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line 47)
5	Shopware\Core\Framework\Feature\FeatureFlagRegistry->register (line 147)
6	Shopware\Core\Framework\Framework->boot (line 209)
7	Shopware\Core\Kernel->boot (line 152)
8	Shopware\Core\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 10)

0.25 ms
(2.63%)

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
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 35)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 209)
5	Shopware\Core\Kernel->boot (line 152)
6	Shopware\Core\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 10)

0.25 ms
(2.62%)

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"\x1CÂš©ø‰I2žlÖd·‡Õ\x16"
  b"eÿ▒ÒVÕD¼íAÉ6ƒT\x1A²"
  b"oÅPO‡hGó \x14\x1E"äÂjP"
  b"àı{\x12\x07_FóÉ\x02ä\x018sÊ¿"
  b"└A/├ú±C▓ìDïÀ\x15£\x00ô"
  b"═À5þË\x13D6©õÉ?ö\x0F░╚"
  b"ÜŠ¿êá!O‚“Ö\x1D`“yŒë"
  b"""
    $<R\x15-#K6‡ý\n
    D9ŸÑ‘
    """
  b"¿‗PìÉÅB®À|6Ã\x0E@Oã"
  b"±œ¢çç±HÎ“úS9ü×,\x06"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"8S^╚ÔäAØÀöòa\x1Cò\x02'"
  b"UHîÜtáD\vª§\(ž«îÆ"
  b"nõ¶Åv░I¸╝¶\x05+TÀV\x10"
  b"²!_þÎeJ#°\x02\fµ\x03Âó\x16"
  b"È|È‰ÿ§Dô«žvØŒr\x0FÃ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `rule`.`id` as `rule.id`,
  `rule`.`name` as `rule.name`,
  `rule`.`priority` as `rule.priority`,
  `rule`.`description` as `rule.description`,
  `rule`.`payload` as `rule.payload`,
  `rule`.`invalid` as `rule.invalid`,
  `rule`.`areas` as `rule.areas`,
  `rule`.`custom_fields` as `rule.customFields`,
  `rule`.`module_types` as `rule.moduleTypes`,
  `rule`.`created_at` as `rule.createdAt`,
  `rule`.`updated_at` as `rule.updatedAt`
FROM
  `rule`
WHERE
  `rule`.`id` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x1CC29AA9F88949329E6CD664B787D516, 0x6598B1E356E544ACA14190369F541AFD, 0x6FC5504F876847F3A0141E22E4C26A50, 0x85D57B12075F46A2900284013873D2A8, 0xC0412FC3A3F143B28D448BB7159C0093, 0xCDB735E7D3134436B8E4903F940FB0C8, 0xDC8ABFEAE1214F8293D61D6093798CEB, 0x243C52152D234B3687FD0A44399FD191, 0xA8F2508D908F42A9B77C36C70E404FC6, 0xB19CA2E7E7B148CE93FA5339FCD72C06, 0xE44E6782C64247B796B891CF25AE38F7, 0x38535EC8E284419DB79495611C950227, 0x5548EEDC74E1440BAAA75C289EABEEC6, 0x6EE4F48F76B049F7BCF4052B54B75610, 0xB2215FFECE654A23B0020CB503C2F316, 0xC87CC889FFA744F4AB9E76D88C720FC3);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 66)
10	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->collect (line 158)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.25 ms
(2.56%)

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId, is_deleted isDeleted 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"ÞDW\x1DÜNM\x00•À\x1Aöî)“Q"
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  "sitemap.xml"
  "sitemap.xml/"
]

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,
  is_deleted isDeleted
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, is_deleted isDeleted FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351) AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL)) AND ((seo_path_info = 'sitemap.xml' OR seo_path_info = 'sitemap.xml/'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 87)
3	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->handleDeletedSeoUrlsResolve (line 52)
4	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->resolve (line 40)
5	NetInventors\NetiNextStoreLocator\Core\Content\Seo\SeoResolverDecorator->resolve (line 35)
6	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 319)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 118)
8	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 30)
9	DreiscSeoPro\Decorator\Shopware\Storefront\Routing\RequestTransformerDecorator->transform (line 33)
10	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
11	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
13	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
14	Shopware\Core\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 10)

0.22 ms
(2.33%)

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC

Parameters:

[
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  "Sendinblue.%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  configuration_key,
  configuration_value
FROM
  system_config
WHERE
  (sales_channel_id = ?)
  AND (configuration_key LIKE ?)
ORDER BY
  sales_channel_id ASC

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE) AND (configuration_key LIKE 'Sendinblue.%') ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 193)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 93)
4	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->getDomain (line 102)
5	NewsletterSendinblue\Service\ConfigService->setSalesChannelId (line 48)
6	NewsletterSendinblue\Subscriber\MarketingAutomationSubscriber->onStorefrontRenderEvent (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
14	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
15	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
20	Shopware\Core\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 10)

0.22 ms
(2.25%)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))

Parameters:

[
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel_domain`.`id` as `sales_channel_domain.id`,
  `sales_channel_domain`.`url` as `sales_channel_domain.url`,
  `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`,
  `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`,
  `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`,
  `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`,
  `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`,
  `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`,
  `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`,
  `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`
FROM
  `sales_channel_domain`
WHERE
  (
    `sales_channel_domain`.`sales_channel_id` IN (?)
  )

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (0xBC03B12FCA6E446C9BBE735AE1F4D0CE));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 492)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 435)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1249)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 1187)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadToOne (line 1243)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 137)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 169)
15	Acris\ShopSwitch\Components\ShopSwitchHelperService->getDomainById (line 65)
16	Acris\ShopSwitch\Components\ShopSwitch\ShopSwitchRoute->load (line 93)
17	Acris\ShopSwitch\Core\System\SalesChannel\Context\SalesChannelContextFactory->create (line 94)
18	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 61)
20	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
21	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
22	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
23	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
27	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
28	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
29	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
35	Shopware\Core\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 10)

0.21 ms
(2.21%)

SELECT configuration_key, configuration_value FROM nosto_integration_config WHERE (sales_channel_id IS NULL) AND (language_id IS NULL) ORDER BY id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  configuration_key,
  configuration_value
FROM
  nosto_integration_config
WHERE
  (sales_channel_id IS NULL)
  AND (language_id IS NULL)
ORDER BY
  id ASC

SELECT configuration_key, configuration_value FROM nosto_integration_config WHERE (sales_channel_id IS NULL) AND (language_id IS NULL) ORDER BY id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 172)
3	Nosto\NostoIntegration\Model\Config\NostoConfigService->getConfig (line 330)
4	Nosto\NostoIntegration\Model\Config\NostoConfigService->load (line 110)
5	Nosto\NostoIntegration\Model\Config\NostoConfigService->get (line 149)
6	Nosto\NostoIntegration\Model\Config\NostoConfigService->getBool (line 223)
7	Nosto\NostoIntegration\Model\ConfigProvider->isEnabledIgnoreCookieConsent (line 66)
8	Nosto\NostoIntegration\Subscriber\FrontendSubscriber->migrateOverdoseCookie (line 58)
9	Nosto\NostoIntegration\Subscriber\FrontendSubscriber->onKernelResponse (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
17	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

0.21 ms
(2.16%)

SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?

Parameters:

[
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `domain`.`language_id` AS languageId,
  `domain`.`id` AS id,
  `domain`.`url` AS url,
  `domain`.`hreflang_use_only_locale` AS onlyLocale,
  `locale`.`code` AS locale
FROM
  `sales_channel_domain` AS `domain`
  INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
  INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
WHERE
  `domain`.`sales_channel_id` = ?

SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 97)
3	Shopware\Core\Content\Seo\HreflangLoader->fetchSalesChannelDomains (line 33)
4	Shopware\Core\Content\Seo\HreflangLoader->load (line 256)
5	Shopware\Storefront\Framework\Routing\StorefrontSubscriber->addHreflang (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
14	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.20 ms
(2.14%)

# sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)

Parameters:

[
  b",╔ì╦Ë'FçºÌ_ó\vâé°"
]

View formatted query View runnable query Explain query View query backtrace

# sales-channel::load-analytics::read
SELECT
  `sales_channel_analytics`.`id` as `sales_channel_analytics.id`,
  `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`,
  `sales_channel_analytics`.`active` as `sales_channel_analytics.active`,
  `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`,
  `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`,
  `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`,
  `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt`
FROM
  `sales_channel_analytics`
WHERE
  `sales_channel_analytics`.`id` IN (?)

# sales-channel::load-analytics::read
SELECT `sales_channel_analytics`.`id` as `sales_channel_analytics.id`, `sales_channel_analytics`.`tracking_id` as `sales_channel_analytics.trackingId`, `sales_channel_analytics`.`active` as `sales_channel_analytics.active`, `sales_channel_analytics`.`track_orders` as `sales_channel_analytics.trackOrders`, `sales_channel_analytics`.`anonymize_ip` as `sales_channel_analytics.anonymizeIp`, `sales_channel_analytics`.`created_at` as `sales_channel_analytics.createdAt`, `sales_channel_analytics`.`updated_at` as `sales_channel_analytics.updatedAt` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (0x2CC98DCBD3274687A7DE5FA20B8382F8);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 36)
11	Shopware\Core\System\SalesChannel\Subscriber\SalesChannelAnalyticsLoader->loadAnalytics (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
19	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
20	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.19 ms
(2.00%)

# 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"ÞDW\x1DÜNM\x00•À\x1Aöî)“Q"
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  "/sitemap.xml"
]

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 = 0xDE44571DDC4E4D0095C01AF6EE299351) AND (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE) AND (path_info = '/sitemap.xml') AND (is_canonical = 1) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 143)
3	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->handleDeletedSeoUrlsResolve (line 52)
4	FourtwosixRelaunchTheme\Decorator\Core\Content\Seo\SeoResolver->resolve (line 40)
5	NetInventors\NetiNextStoreLocator\Core\Content\Seo\SeoResolverDecorator->resolve (line 35)
6	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 319)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 118)
8	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 30)
9	DreiscSeoPro\Decorator\Shopware\Storefront\Routing\RequestTransformerDecorator->transform (line 33)
10	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
11	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
13	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
14	Shopware\Core\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 10)

0.19 ms
(1.98%)

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)

Parameters:

[
  b"¼\x03±/ÊnDl›¾sZáôÐÎ"
  b"_•ŸcÈ1MšƒË\x17‘’\x03‹Ý"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel_country`.`sales_channel_id`,
  `sales_channel_country`.`country_id`
FROM
  `sales_channel_country`
WHERE
  (
    `sales_channel_country`.`sales_channel_id` = ?
    AND `sales_channel_country`.`country_id` = ?
  )

SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE AND `sales_channel_country`.`country_id` = 0x5F959F63C8314D9A83CB179192038BDD);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 294)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 80)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 108)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 55)
8	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 25)
9	Shopware\Core\Checkout\Cart\Validator->validate (line 63)
10	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 34)
12	Shopware\Core\Checkout\Cart\Processor->process (line 109)
13	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 83)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
16	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 97)
17	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
18	Shopware\Core\Profiling\Profiler::trace (line 61)
19	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
20	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 32)
21	FourtwosixCustomAdminUrl\Core\Framework\Routing\ApiRequestContextResolver->resolve (line 34)
22	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
26	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
27	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
28	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
32	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 10)

0.18 ms
(1.91%)

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ? AND `dreisc_seo_redirect`.`source_path` = ?))

Parameters:

[
  true
  "url"
  b"L\\x15Ö\x08\eIUØƒS\x0F╔Jsj"
  "sitemap.xml"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`,
  `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`,
  `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`,
  `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`,
  `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`,
  `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`,
  `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`,
  `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`,
  `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`,
  `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`,
  `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`,
  `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`,
  `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`,
  `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`,
  `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`,
  `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`,
  `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`,
  `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`,
  `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`,
  `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`,
  `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`,
  `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`,
  `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt`
FROM
  `dreisc_seo_redirect`
WHERE
  (
    (
      `dreisc_seo_redirect`.`active` = ?
      AND `dreisc_seo_redirect`.`source_type` = ?
      AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ?
      AND `dreisc_seo_redirect`.`source_path` = ?
    )
  )

SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = 1 AND `dreisc_seo_redirect`.`source_type` = 'url' AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = 0x4C5C1599081B49559D9F530FC94A736A AND `dreisc_seo_redirect`.`source_path` = 'sitemap.xml'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 192)
9	DreiscSeoPro\Core\Foundation\Dal\EntityRepository->search (line 70)
10	DreiscSeoPro\Core\Content\DreiscSeoRedirect\DreiscSeoRedirectRepository->getSourceTypeUrlByDomainIdAndSourcePath (line 24)
11	DreiscSeoPro\Core\Routing\RedirectFinder->findBySourceUrl (line 46)
12	DreiscSeoPro\Core\Routing\RequestTransformer->transform (line 35)
13	DreiscSeoPro\Decorator\Shopware\Storefront\Routing\RequestTransformerDecorator->transform (line 33)
14	Acris\SeoRedirect\Storefront\Framework\Routing\RequestTransformer->transform (line 29)
15	FourtwosixCustomAdminUrl\Core\Framework\Routing\RequestTransformer->transform (line 48)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 10)

0.16 ms
(1.63%)

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `app`.`name`,
  `app`.`version`,
  `app`.`template_load_priority`
FROM
  `app`
  INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
WHERE
  `app`.`active` = 1
  AND `app_template`.`active` = 1

SELECT `app`.`name`, `app`.`version`, `app`.`template_load_priority`
             FROM `app`
             INNER JOIN `app_template` ON `app_template`.`app_id` = `app`.`id`
             WHERE `app`.`active` = 1 AND `app_template`.`active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 937)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 66)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 43)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 24)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 137)
6	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
7	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 273)
8	Shopware\Storefront\Controller\StorefrontController->renderView (line 291)
9	Shopware\Storefront\Controller\StorefrontController->render (line 92)
10	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 92)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
13	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 10)

0.13 ms
(1.32%)

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `name`,
  `path`,
  `author`
FROM
  `app`
WHERE
  `active` = 1

SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 43)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 25)
5	Shopware\Core\Framework\App\Source\NoDatabaseSourceResolver->__construct (line 68990)
6	Container5zdlvgf\Shopware_Core_KernelDevDebugContainer::getSourceResolverService (line 74913)
7	Container5zdlvgf\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginConfigurationFactoryService (line 20903)
8	Container5zdlvgf\Shopware_Core_KernelDevDebugContainer::getStorefrontPluginRegistryService (line 74413)
9	Container5zdlvgf\Shopware_Core_KernelDevDebugContainer::getStorefrontSubscriber3Service (line 26898)
10	Container5zdlvgf\Shopware_Core_KernelDevDebugContainer::Container5zdlvgf\{closure} (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
12	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 99)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getListeners (line 119)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->getListeners (line 64)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->getListeners (line 252)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 10)

0.11 ms
(1.20%)

SELECT `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`, `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`, `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`, `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN (?)

Parameters:

[
  "hA0UqkIpKzCA1V3gF95nWsbRgPx61ukQ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`,
  `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`,
  `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`,
  `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt`
FROM
  `pickware_shipping_sales_channel_api_context`
WHERE
  `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN (?)

SELECT `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` as `pickware_shipping_sales_channel_api_context.salesChannelContextToken`, `pickware_shipping_sales_channel_api_context`.`payload` as `pickware_shipping_sales_channel_api_context.payload`, `pickware_shipping_sales_channel_api_context`.`created_at` as `pickware_shipping_sales_channel_api_context.createdAt`, `pickware_shipping_sales_channel_api_context`.`updated_at` as `pickware_shipping_sales_channel_api_context.updatedAt` FROM `pickware_shipping_sales_channel_api_context` WHERE `pickware_shipping_sales_channel_api_context`.`sales_channel_context_token` IN ('hA0UqkIpKzCA1V3gF95nWsbRgPx61ukQ');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 110)
9	Pickware\DalBundle\EntityManager->findByPrimaryKey (line 127)
10	Pickware\ShippingBundle\SalesChannelContext\Subscriber\SynchronizeSalesChannelContextsSubscriber->onStorefrontPageRendered (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 50)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 84)
18	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 38)
19	Shopware\Storefront\Controller\SitemapController->sitemapXml (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

GET https://stage.bar-tek.com/sitemap.xml

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache