Symfony Profiler

Query Metrics

27 Database Queries

25 Different statements

37.50 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

7.01 ms
(18.70%)

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`.`context_gateway_url` as `app.contextGatewayUrl`, `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`.`requested_privileges` as `app.requestedPrivileges`, `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"
  "mailcShopware6MailchimpIntegration"
]

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`.`context_gateway_url` as `app.contextGatewayUrl`,
  `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`.`requested_privileges` as `app.requestedPrivileges`,
  `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`.`context_gateway_url` as `app.contextGatewayUrl`, `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`.`requested_privileges` as `app.requestedPrivileges`, `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` = 'mailcShopware6MailchimpIntegration');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
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 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
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 94)
11	Shopware\Storefront\Theme\StorefrontPluginRegistry->addAppConfigs (line 48)
12	Shopware\Storefront\Theme\StorefrontPluginRegistry->getConfigurations (line 241)
13	Shopware\Storefront\Theme\ThemeRuntimeConfigService->generateRuntimeConfigByName (line 65)
14	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getRuntimeConfigByName (line 87)
15	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addIconSetConfig (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
19	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
20	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
21	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
22	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 76)
24	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
25	Shopware\Storefront\Controller\NavigationController->header (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 86)
29	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
35	Shopware\Core\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 10)

5.35 ms
(14.27%)

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"\x01œ-º³2v„¸ø„’«Ä³ß"
  b"\t,¿}{¸EÏ‡\x1F‹ÃXG\x02\x1A"
  b",õ˜–¯fGX–ìŠ½\x03¬&¶"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"""
    <}’kjGþŽJâ\r\n
    ™4$
    """
  b"iàé\vÔMFY‰ˆyvu.ýü"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"é+6oàÎI{›^+L*,°ö"
  b"úŸë8R\eLPŠù\x1Aúüøžª"
  b"&×\x15wãeIÈ‹pK¹ç÷9\x18"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"SÓHPÜ9K×€mX\x18Ã\x01\x1A-"
  b"q\x01,<[öA=ƒ¹bAä{ÙÝ"
]

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 (0x019C2DBAB3327684B8F88492ABC4B3DF, 0x092CBF7D7BB845CF871F8BC35847021A, 0x2CF59896AF66475896EC8ABD03AC26B6, 0x3858957016644DE4AE48C0500BF3CCC8, 0x3C9D7D926B6A47FE8D4AE20D0A993424, 0x69E0E90BD44D465989887976752EFDFC, 0xE1378DB7808A478F919E0D740D5D6C1A, 0xE92B366FE0CE497B9B5E2B4C2A2CB0F6, 0xFA9FEB38521B4C508AF91AFAFCF89EAA, 0x26D71577E36549C88B704BB9E7F73918, 0x28CAAE75A5624F0D985ABD0EB32AA160, 0x53D34850DC394BD7806D5818C3011A2D, 0x71012C3C5BF6413D83B96241E47BD9DD);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
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 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 69)
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 36)
16	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
21	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
24	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
31	Shopware\Core\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 10)

5.12 ms
(13.65%)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)

Parameters:

[
  "/navigation/13a65f0962e64be9ab3210a371a2f790"
  "/navigation/17a3e1082a41422486b5cd8312b85338"
  "/navigation/ce8d2ea829eb4f068922ce8d9928aaf8"
  "/navigation/00000186a07e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003d0907e7e7e7e7e7e7e7e7e0001"
  "/navigation/000006ddd07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000493e07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000057e407e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000668a07e7e7e7e7e7e7e7e7e0001"
  "/navigation/4d689ea4e1ee4be7a7ff17c3d1c2a9fd"
  "/navigation/0d5c0178b61f43409317ecb7f0423217"
  "/navigation/9f316991c7b843988ba2d691af81e051"
  "/navigation/b5f029ae393e42019d3c84d1745747d9"
  "/navigation/87329892f04642a091cf97d76cf2e172"
  "/navigation/d0c3ec10ad7f43eab1566c1442929e7b"
  "/navigation/405d1cbfa9ac40988230b3550335457d"
  "/navigation/fc1ec1df1e6e4f1a8143c5ba27bf4971"
  "/navigation/73d86ffcbaf24d1ead280925070a92d7"
  "/navigation/830789a628d847209c38fd4dede151ef"
  "/navigation/604b2db8d0664366b6b22358d17f7a59"
  "/navigation/3effeb8dc90a440cade956cd15571d2e"
  "/navigation/6a9710cbd4ef455d882138cc36089aed"
  "/navigation/13f58cf7fb2d4fdc8090e2d111219483"
  "/navigation/413ab9571e424278a787f8a4381c0c9f"
  "/navigation/853c3c6b6ffe47e2866acbc815d7ef0d"
  "/navigation/37e42c1a596f44aaa610954f0a82095e"
  "/navigation/0a500eeb24b74c4eab8e1982232bf4f7"
  "/navigation/0799bf2edc454c3287d633d9afd8d680"
  "/navigation/92bb5f4d67e84697841c730082f2bbda"
  "/navigation/1756c757bedb444bbacec61fc6f0c159"
  "/navigation/eb040e19715440c08c9806233a73f42a"
  "/navigation/d5f98579fc6a4def8a173f3cd4eb0c1f"
  "/navigation/d67ef9c439bf46b9976fd4c577abecc9"
  "/navigation/9fc9bc9065d44af9984985664c242443"
  "/navigation/3b0c1d5504484565a8bdced3ab2d3665"
  "/navigation/b90f87fb1a1c4230af629184792d84e3"
  "/navigation/eb51729977f44659b74712aad3e7e7a3"
  "/navigation/e907e8f1668c4fb4afe752ffe417a63e"
  "/navigation/f1b52c4932dc4ad590c5ee6ff62c87b7"
  "/navigation/88435e53e98c4d08877d9e13a9607c2a"
  "/navigation/00000249f07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024be47e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024bee7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024bf87e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c027e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c0c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024c167e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024dd87e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024de27e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024dec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024df67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024fcc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000024fd67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251c07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251ca7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251d47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251de7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251e37e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251e87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251ed7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251f27e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000251fc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000252887e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000252927e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253b47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253be7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253c87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253d27e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253e67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253eb7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000253f07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000255a87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000255b27e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002579c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a17e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a37e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257a47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257b07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000257ba7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259907e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002599a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259a47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000259ae7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b847e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b8e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025b987e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025d787e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025d827e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025f6c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000025f767e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261607e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002616a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261747e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002617e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261887e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000261927e7e7e7e7e7e7e7e7e0001"
  "/navigation/000002619c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030d407e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f347e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f487e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f4d7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f4f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f527e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f537e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f547e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f577e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f5c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030f987e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fa27e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fa77e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fac7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030fb67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000030ffc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310067e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310107e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000310607e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003106a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311287e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311327e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003113c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311467e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311487e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311507e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003115a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000311647e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003131c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313267e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313307e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003133a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313447e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000313467e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000315107e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003151a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003151f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000315247e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000317047e7e7e7e7e7e7e7e7e0001"
  "/navigation/000003170e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000317227e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000318f87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319027e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319047e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000319077e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031aec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031af67e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031ce07e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cea7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cf47e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031cfe7e7e7e7e7e7e7e7e7e0001"
  "/navigation/0000031d087e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000320c87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000320d27e7e7e7e7e7e7e7e7e0001"
  "/navigation/000008b1807e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc047e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc0e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc187e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc227e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc687e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc727e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc7c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbc867e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbccc7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbcd67e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd307e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd3a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd3f7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd447e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd497e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd4e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd537e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd587e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd5d7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd627e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd947e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbd9e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbda87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbdf87e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe027e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe0c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe207e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe2a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe5c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe667e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbe707e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbec07e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbeca7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbed47e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbede7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf247e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf2e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf387e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf427e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf4c7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbf567e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dbfec7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0007e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0507e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc05a7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0647e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc06e7e7e7e7e7e7e7e7e7e0001"
  "/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
]

View formatted query View runnable query Explain query View query backtrace

# seo_url::replacement
SELECT
  seo_path_info,
  path_info,
  sales_channel_id
FROM
  seo_url
WHERE
  (seo_url.is_canonical = 1)
  AND (
    seo_url.path_info IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND (seo_url.language_id = ?)
  AND (
    seo_url.sales_channel_id = ?
    OR seo_url.sales_channel_id IS NULL
  )
  AND (seo_url.is_deleted = 0)

# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/13a65f0962e64be9ab3210a371a2f790', '/navigation/17a3e1082a41422486b5cd8312b85338', '/navigation/ce8d2ea829eb4f068922ce8d9928aaf8', '/navigation/00000186a07e7e7e7e7e7e7e7e7e0001', '/navigation/000003d0907e7e7e7e7e7e7e7e7e0001', '/navigation/000006ddd07e7e7e7e7e7e7e7e7e0001', '/navigation/00000493e07e7e7e7e7e7e7e7e7e0001', '/navigation/0000057e407e7e7e7e7e7e7e7e7e0001', '/navigation/00000668a07e7e7e7e7e7e7e7e7e0001', '/navigation/4d689ea4e1ee4be7a7ff17c3d1c2a9fd', '/navigation/0d5c0178b61f43409317ecb7f0423217', '/navigation/9f316991c7b843988ba2d691af81e051', '/navigation/b5f029ae393e42019d3c84d1745747d9', '/navigation/87329892f04642a091cf97d76cf2e172', '/navigation/d0c3ec10ad7f43eab1566c1442929e7b', '/navigation/405d1cbfa9ac40988230b3550335457d', '/navigation/fc1ec1df1e6e4f1a8143c5ba27bf4971', '/navigation/73d86ffcbaf24d1ead280925070a92d7', '/navigation/830789a628d847209c38fd4dede151ef', '/navigation/604b2db8d0664366b6b22358d17f7a59', '/navigation/3effeb8dc90a440cade956cd15571d2e', '/navigation/6a9710cbd4ef455d882138cc36089aed', '/navigation/13f58cf7fb2d4fdc8090e2d111219483', '/navigation/413ab9571e424278a787f8a4381c0c9f', '/navigation/853c3c6b6ffe47e2866acbc815d7ef0d', '/navigation/37e42c1a596f44aaa610954f0a82095e', '/navigation/0a500eeb24b74c4eab8e1982232bf4f7', '/navigation/0799bf2edc454c3287d633d9afd8d680', '/navigation/92bb5f4d67e84697841c730082f2bbda', '/navigation/1756c757bedb444bbacec61fc6f0c159', '/navigation/eb040e19715440c08c9806233a73f42a', '/navigation/d5f98579fc6a4def8a173f3cd4eb0c1f', '/navigation/d67ef9c439bf46b9976fd4c577abecc9', '/navigation/9fc9bc9065d44af9984985664c242443', '/navigation/3b0c1d5504484565a8bdced3ab2d3665', '/navigation/b90f87fb1a1c4230af629184792d84e3', '/navigation/eb51729977f44659b74712aad3e7e7a3', '/navigation/e907e8f1668c4fb4afe752ffe417a63e', '/navigation/f1b52c4932dc4ad590c5ee6ff62c87b7', '/navigation/88435e53e98c4d08877d9e13a9607c2a', '/navigation/00000249f07e7e7e7e7e7e7e7e7e0001', '/navigation/0000024be47e7e7e7e7e7e7e7e7e0001', '/navigation/0000024bee7e7e7e7e7e7e7e7e7e0001', '/navigation/0000024bf87e7e7e7e7e7e7e7e7e0001', '/navigation/0000024c027e7e7e7e7e7e7e7e7e0001', '/navigation/0000024c0c7e7e7e7e7e7e7e7e7e0001', '/navigation/0000024c167e7e7e7e7e7e7e7e7e0001', '/navigation/0000024dd87e7e7e7e7e7e7e7e7e0001', '/navigation/0000024de27e7e7e7e7e7e7e7e7e0001', '/navigation/0000024dec7e7e7e7e7e7e7e7e7e0001', '/navigation/0000024df67e7e7e7e7e7e7e7e7e0001', '/navigation/0000024fcc7e7e7e7e7e7e7e7e7e0001', '/navigation/0000024fd67e7e7e7e7e7e7e7e7e0001', '/navigation/00000251c07e7e7e7e7e7e7e7e7e0001', '/navigation/00000251ca7e7e7e7e7e7e7e7e7e0001', '/navigation/00000251d47e7e7e7e7e7e7e7e7e0001', '/navigation/00000251de7e7e7e7e7e7e7e7e7e0001', '/navigation/00000251e37e7e7e7e7e7e7e7e7e0001', '/navigation/00000251e87e7e7e7e7e7e7e7e7e0001', '/navigation/00000251ed7e7e7e7e7e7e7e7e7e0001', '/navigation/00000251f27e7e7e7e7e7e7e7e7e0001', '/navigation/00000251fc7e7e7e7e7e7e7e7e7e0001', '/navigation/00000252887e7e7e7e7e7e7e7e7e0001', '/navigation/00000252927e7e7e7e7e7e7e7e7e0001', '/navigation/00000253b47e7e7e7e7e7e7e7e7e0001', '/navigation/00000253be7e7e7e7e7e7e7e7e7e0001', '/navigation/00000253c87e7e7e7e7e7e7e7e7e0001', '/navigation/00000253d27e7e7e7e7e7e7e7e7e0001', '/navigation/00000253e67e7e7e7e7e7e7e7e7e0001', '/navigation/00000253eb7e7e7e7e7e7e7e7e7e0001', '/navigation/00000253f07e7e7e7e7e7e7e7e7e0001', '/navigation/00000255a87e7e7e7e7e7e7e7e7e0001', '/navigation/00000255b27e7e7e7e7e7e7e7e7e0001', '/navigation/000002579c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000257a17e7e7e7e7e7e7e7e7e0001', '/navigation/00000257a37e7e7e7e7e7e7e7e7e0001', '/navigation/00000257a47e7e7e7e7e7e7e7e7e0001', '/navigation/00000257b07e7e7e7e7e7e7e7e7e0001', '/navigation/00000257ba7e7e7e7e7e7e7e7e7e0001', '/navigation/00000259907e7e7e7e7e7e7e7e7e0001', '/navigation/000002599a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000259a47e7e7e7e7e7e7e7e7e0001', '/navigation/00000259ae7e7e7e7e7e7e7e7e7e0001', '/navigation/0000025b847e7e7e7e7e7e7e7e7e0001', '/navigation/0000025b8e7e7e7e7e7e7e7e7e7e0001', '/navigation/0000025b987e7e7e7e7e7e7e7e7e0001', '/navigation/0000025d787e7e7e7e7e7e7e7e7e0001', '/navigation/0000025d827e7e7e7e7e7e7e7e7e0001', '/navigation/0000025f6c7e7e7e7e7e7e7e7e7e0001', '/navigation/0000025f767e7e7e7e7e7e7e7e7e0001', '/navigation/00000261607e7e7e7e7e7e7e7e7e0001', '/navigation/000002616a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000261747e7e7e7e7e7e7e7e7e0001', '/navigation/000002617e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000261887e7e7e7e7e7e7e7e7e0001', '/navigation/00000261927e7e7e7e7e7e7e7e7e0001', '/navigation/000002619c7e7e7e7e7e7e7e7e7e0001', '/navigation/0000030d407e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f347e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f487e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f4d7e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f4f7e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f527e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f537e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f547e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f577e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f5c7e7e7e7e7e7e7e7e7e0001', '/navigation/0000030f987e7e7e7e7e7e7e7e7e0001', '/navigation/0000030fa27e7e7e7e7e7e7e7e7e0001', '/navigation/0000030fa77e7e7e7e7e7e7e7e7e0001', '/navigation/0000030fac7e7e7e7e7e7e7e7e7e0001', '/navigation/0000030fb67e7e7e7e7e7e7e7e7e0001', '/navigation/0000030ffc7e7e7e7e7e7e7e7e7e0001', '/navigation/00000310067e7e7e7e7e7e7e7e7e0001', '/navigation/00000310107e7e7e7e7e7e7e7e7e0001', '/navigation/00000310607e7e7e7e7e7e7e7e7e0001', '/navigation/000003106a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000311287e7e7e7e7e7e7e7e7e0001', '/navigation/00000311327e7e7e7e7e7e7e7e7e0001', '/navigation/000003113c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000311467e7e7e7e7e7e7e7e7e0001', '/navigation/00000311487e7e7e7e7e7e7e7e7e0001', '/navigation/00000311507e7e7e7e7e7e7e7e7e0001', '/navigation/000003115a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000311647e7e7e7e7e7e7e7e7e0001', '/navigation/000003131c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000313267e7e7e7e7e7e7e7e7e0001', '/navigation/00000313307e7e7e7e7e7e7e7e7e0001', '/navigation/000003133a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000313447e7e7e7e7e7e7e7e7e0001', '/navigation/00000313467e7e7e7e7e7e7e7e7e0001', '/navigation/00000315107e7e7e7e7e7e7e7e7e0001', '/navigation/000003151a7e7e7e7e7e7e7e7e7e0001', '/navigation/000003151f7e7e7e7e7e7e7e7e7e0001', '/navigation/00000315247e7e7e7e7e7e7e7e7e0001', '/navigation/00000317047e7e7e7e7e7e7e7e7e0001', '/navigation/000003170e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000317227e7e7e7e7e7e7e7e7e0001', '/navigation/00000318f87e7e7e7e7e7e7e7e7e0001', '/navigation/00000319027e7e7e7e7e7e7e7e7e0001', '/navigation/00000319047e7e7e7e7e7e7e7e7e0001', '/navigation/00000319077e7e7e7e7e7e7e7e7e0001', '/navigation/0000031aec7e7e7e7e7e7e7e7e7e0001', '/navigation/0000031af67e7e7e7e7e7e7e7e7e0001', '/navigation/0000031ce07e7e7e7e7e7e7e7e7e0001', '/navigation/0000031cea7e7e7e7e7e7e7e7e7e0001', '/navigation/0000031cf47e7e7e7e7e7e7e7e7e0001', '/navigation/0000031cfe7e7e7e7e7e7e7e7e7e0001', '/navigation/0000031d087e7e7e7e7e7e7e7e7e0001', '/navigation/00000320c87e7e7e7e7e7e7e7e7e0001', '/navigation/00000320d27e7e7e7e7e7e7e7e7e0001', '/navigation/000008b1807e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbba07e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc047e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc0e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc187e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc227e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc687e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc727e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc7c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbc867e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbccc7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbcd67e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd307e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd3a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd3f7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd447e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd497e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd4e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd537e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd587e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd5d7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd627e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd947e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbd9e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbda87e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbdf87e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe027e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe0c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe207e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe2a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe5c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe667e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbe707e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbec07e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbeca7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbed47e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbede7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf247e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf2e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf387e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf427e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf4c7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbf567e7e7e7e7e7e7e7e7e0001', '/navigation/00000dbfec7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc0007e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc0507e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc05a7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc0647e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc06e7e7e7e7e7e7e7e7e7e0001', '/navigation/00000dc0787e7e7e7e7e7e7e7e7e0001')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x55CCF05E55714E47A900FA5024C271EC OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 107)
3	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->createSeoMapping (line 52)
4	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->{closure:Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler::replace():47} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 47)
6	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->replace (line 100)
7	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
8	Shopware\Storefront\Controller\NavigationController->header (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
11	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 10)

3.46 ms
(9.23%)

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

Parameters:

[
  b"UÌð^UqNG©\x00úP$Âqì"
  "ZcP0f3e85zPupW4vVulnbkHQE6W1pwRO"
]

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 = 0x55CCF05E55714E47A900FA5024C271EC) AND (token = 'ZcP0f3e85zPupW4vVulnbkHQE6W1pwRO') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 79)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->{closure:Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get():76} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 76)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 73)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->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 36)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
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 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 10)

2.92 ms
(7.78%)

SELECT path FROM category WHERE id = ?

Parameters:

[
  b"|Ï—V\x050LÜ»l´+š“ì¤"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x7CCF975605304CDCBB6CB42B9A93ECA4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 108)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getNavigationPath (line 50)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 359)
5	Twig\ExtensionSet->getGlobals (line 900)
6	Twig\Environment->getGlobals (line 398)
7	Twig\Template->yield (line 386)
8	Twig\Template->render (line 51)
9	Twig\TemplateWrapper->render (line 333)
10	Twig\Environment->render (line 276)
11	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
12	Shopware\Storefront\Controller\StorefrontController->render (line 84)
13	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 84)
15	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
16	Shopware\Storefront\Controller\NavigationController->header (line 183)
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 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

2.54 ms
(6.77%)

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"UÌð^UqNG©\x00úP$Âqì"
  b"/NñAš(Bû©tûÓëE:{"
]

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` = 0x55CCF05E55714E47A900FA5024C271EC AND `sales_channel_country`.`country_id` = 0x2F4EF1419A2842FBA974FBD3EB453A7B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 301)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 112)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 59)
8	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 29)
9	Shopware\Core\Checkout\Cart\Validator->validate (line 63)
10	Shopware\Core\Checkout\Cart\Processor->{closure:Shopware\Core\Checkout\Cart\Processor::process():34} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 34)
12	Shopware\Core\Checkout\Cart\Processor->process (line 142)
13	Shopware\Core\Checkout\Cart\CartRuleLoader->_load (line 47)
14	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 102)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->{closure:Shopware\Core\Checkout\Cart\CartRuleLoader::load():90} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 90)
17	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 68)
18	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 126)
19	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->{closure:{closure:Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get():76}:126} (line 422)
20	Shopware\Core\System\SalesChannel\SalesChannelContext->withPermissions (line 124)
21	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->{closure:Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get():76} (line 67)
22	Shopware\Core\Profiling\Profiler::trace (line 76)
23	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 73)
24	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
25	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
26	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
30	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
31	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
32	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
33	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
37	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
38	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
39	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
40	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
41	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
42	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
43	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
44	Shopware\Core\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 10)

2.11 ms
(5.62%)

# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC

Parameters:

[
  b"UÌð^UqNG©\x00úP$Âqì"
  b"UÌð^UqNG©\x00úP$Âqì"
]

View formatted query View runnable query Explain query View query backtrace

# header::languages::search-ids
SELECT
  `language`.`id`
FROM
  `language`
  LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id`
  LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`
  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`
WHERE
  (
    `language.salesChannelDomains`.`sales_channel_id` = ?
    AND `language.salesChannels`.`id` = ?
  )
GROUP BY
  `language`.`id`
ORDER BY
  MIN(`language`.`name`) ASC

# header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = 0x55CCF05E55714E47A900FA5024C271EC AND `language.salesChannels`.`id` = 0x55CCF05E55714E47A900FA5024C271EC) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 194)
5	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->doSearch (line 102)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search (line 60)
7	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->{closure:Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository::search():60} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 60)
9	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 52)
10	Shopware\Core\System\Language\SalesChannel\LanguageRoute->load (line 91)
11	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->getLanguages (line 53)
12	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->load (line 124)
13	Shopware\Storefront\Controller\NavigationController->header (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 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

1.92 ms
(5.13%)

# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"SC(\rúÚO\x13¸~¦m5¶ü."
  b"ü¯™I#2NT£ÒO\x16ÿÝ0K"
  b"í¦!§~bE8–³ÄVØ§ý"
]

View formatted query View runnable query Explain query View query backtrace

# header::languages::read
SELECT
  `language`.`id` as `language.id`,
  `language`.`parent_id` as `language.parentId`,
  `language`.`locale_id` as `language.localeId`,
  `language`.`translation_code_id` as `language.translationCodeId`,
  `language`.`name` as `language.name`,
  `language`.`active` as `language.active`,
  `language`.`custom_fields` as `language.customFields`,
  `language`.`created_at` as `language.createdAt`,
  `language`.`updated_at` as `language.updatedAt`,
  `language.translationCode`.`id` as `language.translationCode.id`,
  `language.translationCode`.`code` as `language.translationCode.code`,
  `language.translationCode`.`created_at` as `language.translationCode.createdAt`,
  `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`,
  `language.translationCode.translation.name`,
  `language.translationCode.translation.name` as `language.translationCode.name`,
  `language.translationCode.translation.territory`,
  `language.translationCode.translation.territory` as `language.translationCode.territory`,
  `language.translationCode.translation.customFields`,
  `language.translationCode.translation.customFields` as `language.translationCode.customFields`
FROM
  `language`
  LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id`
  LEFT JOIN (
    SELECT
      `language.translationCode.translation`.`locale_id`,
      `language.translationCode.translation`.`name` as `language.translationCode.translation.name`,
      `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`,
      `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields`
    FROM
      `locale_translation` `language.translationCode.translation`
    WHERE
      `language.translationCode.translation`.`language_id` = ?
  ) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id`
WHERE
  `language`.`id` IN (?, ?, ?, ?)

# header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, 0x5343280DFADA4F13B87EA66D35B6FC2E, 0xFCAF994923324E54A3D24F16FFDD304B, 0xEDA621A77E62453896B3C456D8A79DFD);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
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 177)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read (line 113)
7	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search (line 60)
8	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->{closure:Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository::search():60} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 60)
10	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 52)
11	Shopware\Core\System\Language\SalesChannel\LanguageRoute->load (line 91)
12	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->getLanguages (line 53)
13	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->load (line 124)
14	Shopware\Storefront\Controller\NavigationController->header (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 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.93 ms
(2.49%)

# theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"Ëö\x19¢oK·¤;ãC‚ûÎ4"
  b"‰w³•¢+G+—“kÒ0&\x07"
  b"–g\x00è•/O8¶+Ãö\x05\x10d"
]

View formatted query View runnable query Explain query View query backtrace

# theme-service::resolve-media::read
SELECT
  `media`.`id` as `media.id`,
  `media`.`user_id` as `media.userId`,
  `media`.`media_folder_id` as `media.mediaFolderId`,
  `media`.`mime_type` as `media.mimeType`,
  `media`.`file_extension` as `media.fileExtension`,
  `media`.`uploaded_at` as `media.uploadedAt`,
  `media`.`file_name` as `media.fileName`,
  `media`.`file_size` as `media.fileSize`,
  `media`.`media_type` as `media.mediaTypeRaw`,
  `media`.`meta_data` as `media.metaData`,
  `media`.`config` as `media.config`,
  `media`.`path` as `media.path`,
  `media`.`private` as `media.private`,
  `media`.`thumbnails_ro` as `media.thumbnailsRo`,
  `media`.`file_hash` as `media.fileHash`,
  `media`.`created_at` as `media.createdAt`,
  `media`.`updated_at` as `media.updatedAt`,
  `media.translation.title`,
  `media.translation.title` as `media.title`,
  `media.translation.alt`,
  `media.translation.alt` as `media.alt`,
  `media.translation.customFields`,
  `media.translation.customFields` as `media.customFields`
FROM
  `media`
  LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id`
  LEFT JOIN (
    SELECT
      `media.translation`.`media_id`,
      `media.translation`.`alt` as `media.translation.alt`,
      `media.translation`.`title` as `media.translation.title`,
      `media.translation`.`custom_fields` as `media.translation.customFields`
    FROM
      `media_translation` `media.translation`
    WHERE
      `media.translation`.`language_id` = ?
  ) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id`
  LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id`
WHERE
  (
    (
      (
        `media`.`private` = ?
        OR (
          `media`.`private` = ?
          AND `media.mediaFolder.defaultFolder`.`entity` = ?
        )
      )
    )
  )
  AND (
    `media`.`id` IN (?, ?, ?)
  )

# theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = 0 OR (`media`.`private` = 1 AND `media.mediaFolder.defaultFolder`.`entity` = 'product_download')))) AND (`media`.`id` IN (0xCBF619A2AD6F4BB7A43BE34382FBCE34, 0x8977B395A22B472B97936BD230268107, 0x966700E8952F4F38B6812BC3F6051064));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
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 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 68)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 61)
11	Shopware\Storefront\Theme\ResolvedConfigLoader->load (line 76)
12	Shopware\Storefront\Theme\ThemeConfigValueAccessor->getThemeConfig (line 31)
13	Shopware\Storefront\Theme\ThemeConfigValueAccessor->get (line 43)
14	Shopware\Storefront\Framework\Twig\TemplateConfigAccessor->theme (line 49)
15	Shopware\Storefront\Framework\Twig\Extension\ConfigExtension->theme (line 186)
16	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_image_tablet (line 446)
17	Twig\Template->yieldBlock (line 148)
18	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_image (line 446)
19	Twig\Template->yieldBlock (line 118)
20	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_link (line 446)
21	Twig\Template->yieldBlock (line 80)
22	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_inner (line 446)
23	Twig\Template->yieldBlock (line 54)
24	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->doDisplay (line 402)
25	Twig\Template->yield (line 187)
26	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header_logo (line 446)
27	Twig\Template->yieldBlock (line 147)
28	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header_navigation (line 446)
29	Twig\Template->yieldBlock (line 93)
30	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header (line 446)
31	Twig\Template->yieldBlock (line 64)
32	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->doDisplay (line 402)
33	Twig\Template->yield (line 58)
34	__TwigTemplate_e26210b2277c05121fe0933f96b967b4->doDisplay (line 402)
35	Twig\Template->yield (line 55)
36	__TwigTemplate_da755ab38ef0537fbccb5af46634fa44->doDisplay (line 402)
37	Twig\Template->yield (line 150)
38	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header_inner (line 446)
39	Twig\Template->yieldBlock (line 491)
40	Twig\Template->yieldParentBlock (line 89)
41	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->block_base_header_inner (line 446)
42	Twig\Template->yieldBlock (line 120)
43	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header (line 446)
44	Twig\Template->yieldBlock (line 79)
45	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_header (line 446)
46	Twig\Template->yieldBlock (line 55)
47	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->doDisplay (line 402)
48	Twig\Template->yield (line 54)
49	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->doDisplay (line 402)
50	Twig\Template->yield (line 386)
51	Twig\Template->render (line 51)
52	Twig\TemplateWrapper->render (line 333)
53	Twig\Environment->render (line 276)
54	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
55	Shopware\Storefront\Controller\StorefrontController->render (line 84)
56	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
57	Shopware\Core\Profiling\Profiler::trace (line 84)
58	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
59	Shopware\Storefront\Controller\NavigationController->header (line 183)
60	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
61	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
62	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
63	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
64	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
65	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
66	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
67	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
68	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
69	Shopware\Core\Kernel->handle (line 35)
70	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
71	require_once (line 10)

0.79 ms
(2.10%)

SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `theme_id` = ?

Parameters:

[
  b"5™\x11í›\eDHÔºñÝÄ¨ç"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `theme_id`,
  `technical_name`,
  `resolved_config`,
  `view_inheritance`,
  `script_files`,
  `icon_sets`,
  `updated_at`
FROM
  `theme_runtime_config`
WHERE
  `theme_id` = ?

SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `theme_id` = 0x359911ED9B1B444890D4BAF1DDC4A8E7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 300)
2	Doctrine\DBAL\Connection->fetchAssociative (line 51)
3	Shopware\Storefront\Theme\ThemeRuntimeConfigStorage->getById (line 82)
4	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getRuntimeConfig (line 35)
5	Shopware\Storefront\Theme\ResolvedConfigLoader->load (line 76)
6	Shopware\Storefront\Theme\ThemeConfigValueAccessor->getThemeConfig (line 31)
7	Shopware\Storefront\Theme\ThemeConfigValueAccessor->get (line 43)
8	Shopware\Storefront\Framework\Twig\TemplateConfigAccessor->theme (line 49)
9	Shopware\Storefront\Framework\Twig\Extension\ConfigExtension->theme (line 186)
10	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_image_tablet (line 446)
11	Twig\Template->yieldBlock (line 148)
12	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_image (line 446)
13	Twig\Template->yieldBlock (line 118)
14	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_link (line 446)
15	Twig\Template->yieldBlock (line 80)
16	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->block_layout_header_logo_inner (line 446)
17	Twig\Template->yieldBlock (line 54)
18	__TwigTemplate_426f02973fde6fe1d39ced162e14982b->doDisplay (line 402)
19	Twig\Template->yield (line 187)
20	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header_logo (line 446)
21	Twig\Template->yieldBlock (line 147)
22	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header_navigation (line 446)
23	Twig\Template->yieldBlock (line 93)
24	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header (line 446)
25	Twig\Template->yieldBlock (line 64)
26	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->doDisplay (line 402)
27	Twig\Template->yield (line 58)
28	__TwigTemplate_e26210b2277c05121fe0933f96b967b4->doDisplay (line 402)
29	Twig\Template->yield (line 55)
30	__TwigTemplate_da755ab38ef0537fbccb5af46634fa44->doDisplay (line 402)
31	Twig\Template->yield (line 150)
32	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header_inner (line 446)
33	Twig\Template->yieldBlock (line 491)
34	Twig\Template->yieldParentBlock (line 89)
35	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->block_base_header_inner (line 446)
36	Twig\Template->yieldBlock (line 120)
37	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header (line 446)
38	Twig\Template->yieldBlock (line 79)
39	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_header (line 446)
40	Twig\Template->yieldBlock (line 55)
41	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->doDisplay (line 402)
42	Twig\Template->yield (line 54)
43	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->doDisplay (line 402)
44	Twig\Template->yield (line 386)
45	Twig\Template->render (line 51)
46	Twig\TemplateWrapper->render (line 333)
47	Twig\Environment->render (line 276)
48	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
49	Shopware\Storefront\Controller\StorefrontController->render (line 84)
50	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
51	Shopware\Core\Profiling\Profiler::trace (line 84)
52	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
53	Shopware\Storefront\Controller\NavigationController->header (line 183)
54	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
55	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
56	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
57	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
58	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
59	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
60	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
61	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
62	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
63	Shopware\Core\Kernel->handle (line 35)
64	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
65	require_once (line 10)

0.76 ms
(2.03%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
  "_esi/global/header"
  "_esi/global/header/"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 49)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 35)
4	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 317)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 116)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 18)
7	Shopware\B2B\StoreFrontAuthentication\BridgePlatform\RequestTransformerDecorator->transform (line 48)
8	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
14	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
15	Shopware\Core\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

0.57 ms
(1.53%)

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 638)
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 150)
6	Shopware\Core\Framework\Framework->boot (line 125)
7	Symfony\Component\HttpKernel\Kernel->boot (line 150)
8	Shopware\Core\Kernel->boot (line 126)
9	Shopware\Core\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 10)

0.47 ms
(1.26%)

# 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 114)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 142)
4	Shopware\Core\Kernel->boot (line 126)
5	Shopware\Core\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 10)

0.41 ms
(1.11%)

# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?

Parameters:

[
  b"|Ï—V\x050LÜ»l´+š“ì¤"
  b"|Ï—V\x050LÜ»l´+š“ì¤"
]

View formatted query View runnable query Explain query View query backtrace

# navigation-route::meta-information
SELECT
  LOWER(
    HEX(`id`)
  ),
  `path`,
  `level`
FROM
  `category`
WHERE
  `id` = ?
  OR `id` = ?

# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = 0x7CCF975605304CDCBB6CB42B9A93ECA4 OR `id` = 0x7CCF975605304CDCBB6CB42B9A93ECA4
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 151)
3	Shopware\Core\Content\Category\SalesChannel\NavigationRoute->getCategoryMetaInfo (line 76)
4	Shopware\Core\Content\Category\SalesChannel\NavigationRoute->load (line 123)
5	Swag\DynamicAccess\Core\Content\Category\SalesChannel\DecoratedNavigationRoute->load (line 52)
6	Shopware\Core\Content\Category\SalesChannel\TreeBuildingNavigationRoute->load (line 49)
7	Shopware\Core\Content\Category\Service\NavigationLoader->load (line 47)
8	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->load (line 124)
9	Shopware\Storefront\Controller\NavigationController->header (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
12	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
18	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
19	Shopware\Core\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 10)

0.41 ms
(1.09%)

# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`

Parameters:

[
  b"UÌð^UqNG©\x00úP$Âqì"
]

View formatted query View runnable query Explain query View query backtrace

# header::currencies::search-ids
SELECT
  `currency`.`id`
FROM
  `currency`
  LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`
  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`
WHERE
  (
    `currency.salesChannels`.`id` = ?
  )
GROUP BY
  `currency`.`id`

# header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = 0x55CCF05E55714E47A900FA5024C271EC) GROUP BY `currency`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 194)
5	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->doSearch (line 102)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search (line 60)
7	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->{closure:Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository::search():60} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 60)
9	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 49)
10	Shopware\Core\System\Currency\SalesChannel\CurrencyRoute->load (line 102)
11	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->getCurrencies (line 58)
12	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->load (line 124)
13	Shopware\Storefront\Controller\NavigationController->header (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 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.39 ms
(1.04%)

# header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]

View formatted query View runnable query Explain query View query backtrace

# header::currencies::read
SELECT
  `currency`.`id` as `currency.id`,
  `currency`.`factor` as `currency.factor`,
  `currency`.`symbol` as `currency.symbol`,
  `currency`.`iso_code` as `currency.isoCode`,
  `currency`.`position` as `currency.position`,
  `currency`.`tax_free_from` as `currency.taxFreeFrom`,
  `currency`.`item_rounding` as `currency.itemRounding`,
  `currency`.`total_rounding` as `currency.totalRounding`,
  `currency`.`created_at` as `currency.createdAt`,
  `currency`.`updated_at` as `currency.updatedAt`,
  `currency.translation.shortName`,
  `currency.translation.shortName` as `currency.shortName`,
  `currency.translation.name`,
  `currency.translation.name` as `currency.name`,
  `currency.translation.customFields`,
  `currency.translation.customFields` as `currency.customFields`
FROM
  `currency`
  LEFT JOIN (
    SELECT
      `currency.translation`.`currency_id`,
      `currency.translation`.`short_name` as `currency.translation.shortName`,
      `currency.translation`.`name` as `currency.translation.name`,
      `currency.translation`.`custom_fields` as `currency.translation.customFields`
    FROM
      `currency_translation` `currency.translation`
    WHERE
      `currency.translation`.`language_id` = ?
  ) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id`
WHERE
  `currency`.`id` IN (?)

# header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (0xB7D2554B0CE847CD82F3AC9BD1C0DFCA);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
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 177)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read (line 113)
7	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search (line 60)
8	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->{closure:Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository::search():60} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 60)
10	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search (line 49)
11	Shopware\Core\System\Currency\SalesChannel\CurrencyRoute->load (line 102)
12	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->getCurrencies (line 58)
13	Shopware\Storefront\Pagelet\Header\HeaderPageletLoader->load (line 124)
14	Shopware\Storefront\Controller\NavigationController->header (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 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 10)

0.39 ms
(1.03%)

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 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 34)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 125)
5	Symfony\Component\HttpKernel\Kernel->boot (line 150)
6	Shopware\Core\Kernel->boot (line 126)
7	Shopware\Core\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 10)

0.37 ms
(0.98%)

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?

Parameters:

[
  "de-DE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(id)
  )
FROM
  snippet_set
WHERE
  iso = ?

SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = 'de-DE';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 260)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 307)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalogue (line 137)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 154)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 122)
8	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 113)
9	__TwigTemplate_1c59faa857d9fabd5cc98b9b6d517245->block_layout_header_top_bar_inner (line 446)
10	Twig\Template->yieldBlock (line 78)
11	__TwigTemplate_1c59faa857d9fabd5cc98b9b6d517245->block_layout_header_top_bar (line 446)
12	Twig\Template->yieldBlock (line 52)
13	__TwigTemplate_1c59faa857d9fabd5cc98b9b6d517245->doDisplay (line 402)
14	Twig\Template->yield (line 118)
15	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_top_bar (line 446)
16	Twig\Template->yieldBlock (line 88)
17	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->block_layout_header (line 446)
18	Twig\Template->yieldBlock (line 64)
19	__TwigTemplate_8abd86596839edb68a6b854fe81e863e->doDisplay (line 402)
20	Twig\Template->yield (line 58)
21	__TwigTemplate_e26210b2277c05121fe0933f96b967b4->doDisplay (line 402)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_da755ab38ef0537fbccb5af46634fa44->doDisplay (line 402)
24	Twig\Template->yield (line 150)
25	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header_inner (line 446)
26	Twig\Template->yieldBlock (line 491)
27	Twig\Template->yieldParentBlock (line 89)
28	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->block_base_header_inner (line 446)
29	Twig\Template->yieldBlock (line 120)
30	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_base_header (line 446)
31	Twig\Template->yieldBlock (line 79)
32	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->block_header (line 446)
33	Twig\Template->yieldBlock (line 55)
34	__TwigTemplate_2ffb631d0d8e7c50210c7ebe8fa343ad->doDisplay (line 402)
35	Twig\Template->yield (line 54)
36	__TwigTemplate_060806d47ec1bdb8dd0e2984899e11b2->doDisplay (line 402)
37	Twig\Template->yield (line 386)
38	Twig\Template->render (line 51)
39	Twig\TemplateWrapper->render (line 333)
40	Twig\Environment->render (line 276)
41	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
42	Shopware\Storefront\Controller\StorefrontController->render (line 84)
43	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
44	Shopware\Core\Profiling\Profiler::trace (line 84)
45	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
46	Shopware\Storefront\Controller\NavigationController->header (line 183)
47	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
48	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
49	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
50	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
51	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
52	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
53	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
54	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
55	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
56	Shopware\Core\Kernel->handle (line 35)
57	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
58	require_once (line 10)

0.36 ms
(0.97%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"UÌð^UqNG©\x00úP$Âqì"
  "/_esi/global/header"
]

View formatted query View runnable query Explain query View query backtrace

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

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x55CCF05E55714E47A900FA5024C271EC) AND (path_info = '/_esi/global/header') AND (is_canonical = 1) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 315)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 93)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 35)
4	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 317)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 116)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 18)
7	Shopware\B2B\StoreFrontAuthentication\BridgePlatform\RequestTransformerDecorator->transform (line 48)
8	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
14	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
15	Shopware\Core\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 10)

0.28 ms
(0.74%)

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 655)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 78)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 50)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 27)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 143)
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 287)
9	Shopware\Storefront\Controller\StorefrontController->render (line 84)
10	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 84)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
13	Shopware\Storefront\Controller\NavigationController->header (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 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

0.22 ms
(0.58%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 56)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 39)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 59)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addShopIdParameter (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 36)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 76)
14	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
15	Shopware\Storefront\Controller\NavigationController->header (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 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.20 ms
(0.54%)

SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT `technical_name`
FROM
  `theme_runtime_config`
WHERE
  `technical_name` IS NOT NULL

SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 95)
3	Shopware\Storefront\Theme\ThemeRuntimeConfigStorage->getActiveThemeNames (line 178)
4	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getActiveThemeNames (line 152)
5	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->isTheme (line 48)
6	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->build (line 87)
7	Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder->buildNamespaceHierarchy (line 27)
8	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 143)
9	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
10	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 273)
11	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
12	Shopware\Storefront\Controller\StorefrontController->render (line 84)
13	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 84)
15	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
16	Shopware\Storefront\Controller\NavigationController->header (line 183)
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 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.19 ms
(0.51%)

SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?

Parameters:

[
  "BehrTheme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `theme_id`,
  `technical_name`,
  `resolved_config`,
  `view_inheritance`,
  `script_files`,
  `icon_sets`,
  `updated_at`
FROM
  `theme_runtime_config`
WHERE
  `technical_name` = ?

SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = 'BehrTheme';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 300)
2	Doctrine\DBAL\Connection->fetchAssociative (line 26)
3	Shopware\Storefront\Theme\ThemeRuntimeConfigStorage->getByName (line 62)
4	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getRuntimeConfigByName (line 87)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addIconSetConfig (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 36)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 76)
14	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
15	Shopware\Storefront\Controller\NavigationController->header (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 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 10)

0.18 ms
(0.49%)

SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  `min_search_length`
FROM
  `product_search_config`
WHERE
  `language_id` = ?

SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 95)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->minSearchLength (line 60)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 359)
5	Twig\ExtensionSet->getGlobals (line 900)
6	Twig\Environment->getGlobals (line 398)
7	Twig\Template->yield (line 386)
8	Twig\Template->render (line 51)
9	Twig\TemplateWrapper->render (line 333)
10	Twig\Environment->render (line 276)
11	Shopware\Storefront\Controller\StorefrontController->renderView (line 287)
12	Shopware\Storefront\Controller\StorefrontController->render (line 84)
13	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():84} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 84)
15	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
16	Shopware\Storefront\Controller\NavigationController->header (line 183)
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 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 10)

0.14 ms
(0.39%)

SELECT url FROM sales_channel_domain

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  url
FROM
  sales_channel_domain

SELECT url FROM sales_channel_domain;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 46)
3	Shopware\Core\Framework\App\ShopId\Fingerprint\SalesChannelDomainUrls->fetchSalesChannelDomainUrls (line 37)
4	Shopware\Core\Framework\App\ShopId\Fingerprint\SalesChannelDomainUrls->getStamp (line 41)
5	Shopware\Core\Framework\App\ShopId\FingerprintGenerator->matchFingerprints (line 47)
6	Shopware\Core\Framework\App\ShopId\ShopIdProvider->getShopId (line 64)
7	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addShopIdParameter (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 36)
11	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 41)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 76)
16	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 128)
17	Shopware\Storefront\Controller\NavigationController->header (line 183)
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 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 128)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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://sw6staging.behr-labor.eu/_esi/global/header

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache