Symfony Profiler

Query Metrics

60 Database Queries

33 Different statements

102.28 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

16.74 ms
(16.37%)

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` 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`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 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` WHERE (`app`.`active` = ?)

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`,
  `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`,
  COALESCE(
    `app.translation.label`, `app.translation.label`
  ) as `app.label`,
  `app.translation.description`,
  COALESCE(
    `app.translation.description`, `app.translation.description`
  ) as `app.description`,
  `app.translation.privacyPolicyExtensions`,
  COALESCE(
    `app.translation.privacyPolicyExtensions`,
    `app.translation.privacyPolicyExtensions`
  ) as `app.privacyPolicyExtensions`,
  `app.translation.customFields`,
  COALESCE(
    `app.translation.customFields`,
    `app.translation.customFields`
  ) as `app.customFields`,
  `app.translation.createdAt`,
  `app.translation.updatedAt`,
  `app.translation.appId`,
  `app.translation.languageId`
FROM
  `app`
  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`,
      `app.translation`.created_at as `app.translation.createdAt`,
      `app.translation`.updated_at as `app.translation.updatedAt`,
      `app.translation`.app_id as `app.translation.appId`,
      `app.translation`.language_id as `app.translation.languageId`
    FROM
      `app_translation` `app.translation`
    WHERE
      `app.translation`.language_id = ?
  ) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id`
  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`
WHERE
  (`app`.`active` = ?)

# app-scripts::refresh::read
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`.`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`.`write_access` as `app.integration.writeAccess`, `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`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` 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`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` 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` WHERE (`app`.`active` = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 106)
11	Shopware\Core\Framework\App\Lifecycle\Persister\ScriptPersister->refresh (line 72)
12	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
13	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
14	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
15	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 34)
17	Shopware\Core\Checkout\Cart\Processor->process (line 105)
18	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 83)
20	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
21	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
22	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
23	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
24	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
25	Shopware\Core\Profiling\Profiler::trace (line 59)
26	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
27	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
28	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
29	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
33	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
34	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
35	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
36	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
39	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
40	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
41	Shopware\Core\Kernel->handle (line 146)
42	Shopware\Core\HttpKernel->doHandle (line 67)
43	Shopware\Core\HttpKernel->handle (line 71)
44	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 14)

9.73 ms
(9.51%)

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

Parameters:

[
  null
  "MolliePayments.config.%"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id IS NULL OR sales_channel_id = NULL) AND (configuration_key LIKE 'MolliePayments.config.%') ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 184)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 93)
4	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->getDomain (line 74)
5	Kiener\MolliePayments\Service\SettingsService->getSettings (line 62)
6	Kiener\MolliePayments\Service\Logger\MollieLoggerFactory->createLogger (line 60616)
7	ContainerVNA2ty6\Shopware_Core_KernelDevDebugContainer::getMolliePayments_LoggerService (line 43724)
8	ContainerVNA2ty6\Shopware_Core_KernelDevDebugContainer::getWebhookTimezoneSubscriberService (line 21903)
9	ContainerVNA2ty6\Shopware_Core_KernelDevDebugContainer::ContainerVNA2ty6\{closure} (line 235)
10	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 98)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getListeners (line 120)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->getListeners (line 64)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->getListeners (line 276)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
21	Shopware\Core\Kernel->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 71)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 14)

8.72 ms
(8.53%)

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 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 35)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 63)
4	Shopware\Core\System\System->boot (line 212)
5	Shopware\Core\Kernel->boot (line 119)
6	Shopware\Core\HttpKernel->doHandle (line 67)
7	Shopware\Core\HttpKernel->handle (line 71)
8	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 14)

7.01 ms
(6.86%)

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

Parameters:

[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "eobRvoB4vMyA52uPWSsn3KuzjLM3P1DA"
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 62)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 59)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
7	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
8	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
21	Shopware\Core\Kernel->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 71)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 14)

5.98 ms
(5.84%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS scriptName,
  `script`.`script` AS script,
  `script`.`hook` AS hook,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  `app`.`version` AS appVersion,
  `script`.`active` AS active
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` != 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   `app`.`version` AS appVersion,
                   `script`.`active` AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` != 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 76)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 34)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 83)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
13	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
14	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 59)
17	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
18	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
19	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
20	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
24	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
25	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
26	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
32	Shopware\Core\Kernel->handle (line 146)
33	Shopware\Core\HttpKernel->doHandle (line 67)
34	Shopware\Core\HttpKernel->handle (line 71)
35	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 14)

5.95 ms
(5.82%)

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SET
  @@group_concat_max_len = CAST(
    IF(
      @@group_concat_max_len > 320000, @@group_concat_max_len,
      320000
    ) AS UNSIGNED
  );

SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  )

SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 393)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 215)
3	Shopware\Core\Kernel->boot (line 119)
4	Shopware\Core\HttpKernel->doHandle (line 67)
5	Shopware\Core\HttpKernel->handle (line 71)
6	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 14)

5.40 ms
(5.28%)

# product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::manufacturer
SELECT
  LOWER(
    HEX(
      IFNULL(
        `product`.`product_manufacturer_id`,
        `product.parent`.`product_manufacturer_id`
      )
    )
  ) as `manufacturer`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
GROUP BY
  IFNULL(
    `product`.`product_manufacturer_id`,
    `product.parent`.`product_manufacturer_id`
  )

# product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

5.31 ms
(5.19%)

# product-listing-route::loading::aggregation::properties
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::properties
SELECT
  LOWER(
    HEX(`product.properties`.`id`)
  ) as `properties.key`,
  COUNT(`product`.`id`) as `properties.count`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`
  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
  LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
GROUP BY
  `product.properties`.`id`

# product-listing-route::loading::aggregation::properties
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) GROUP BY `product.properties`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

4.56 ms
(4.46%)

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"Rmi0±ÝIÕºwö)¦¤w÷"
  b"Çò‚X¶Oš¨wÒ7³@ˆ®"
  b"ÅL|g\x0E'EL¶\x13ÉÖÑéç‹"
  b"l›î.G\x08OàžßP\x01€Èéº"
  b"""
    ~/ëàÕd@- ë\n
    \x0FB]ü¸
    """
  b"¥¶6o\x10+A÷’LÚ¯+‹¿."
  b"®ÇÐj÷sFu¡®\rÔ˜£N="
  b"Êƒ$Ã\tUCö¦Ÿ’0PxfW"
  b"Þ$U¿Œ¢Kš„|ž9~@ri"
  b"ã:╔\x06▀AÉÉ³\x07x\x01E¦k"
  b"\x01ÅQ▄-Ïuvè.ýqkB\x00\x00"
  b"\x01ÅQÔ¶Øs\x19░A\x05È¨═ V"
  b"È\f¨É\vðIPïô│Ú╚Ç°÷"
]

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 (0x526D6930B1DD49D5BA77F629A6A477F7, 0xADC7F28258B64F9AA877D237B34088AE, 0xC54C7C670E27454CB613C9D6D1E9E78B, 0x6C9BEE2E47084FE09EDF500180C8E9BA, 0x7E2FEBE0D564402DA0EB0A0F425DFCB8, 0xA5B6366F102B41F7924CDAAF2B8BBF2E, 0xAEC7D06AF7734675A1AE0DD498A34E3D, 0xCA8324C3095543F6A69F923050786657, 0xDE2455BF8CA24B9A847C9E397E407269, 0xF0C63AC906DF419090FC07780145DD6B, 0x018F51DC2DD875768A2EEC716B420000, 0x018F51E2F49D7319B04105D4F9CDFF56, 0xD40CF9900BD049508B93B3E9C880F8F6);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 66)
10	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->collect (line 169)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 108)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 214)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 202)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
25	Shopware\Core\Kernel->handle (line 146)
26	Shopware\Core\HttpKernel->doHandle (line 67)
27	Shopware\Core\HttpKernel->handle (line 71)
28	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 14)

4.43 ms
(4.33%)

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?

Parameters:

[
  "eobRvoB4vMyA52uPWSsn3KuzjLM3P1DA"
]

View formatted query View runnable query Explain query View query backtrace

#cart-persister::load
SELECT
  `cart`.`payload`,
  `cart`.`rule_ids`,
  `cart`.`compressed`
FROM
  cart
WHERE
  `token` = ?

#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = 'eobRvoB4vMyA52uPWSsn3KuzjLM3P1DA';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 44)
3	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
4	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
5	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
6	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
7	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 59)
9	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
10	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
11	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
12	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
24	Shopware\Core\Kernel->handle (line 146)
25	Shopware\Core\HttpKernel->doHandle (line 67)
26	Shopware\Core\HttpKernel->handle (line 71)
27	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 14)

4.23 ms
(4.14%)

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?

Parameters:

[
  "payload"
]

View formatted query View runnable query Explain query View query backtrace

SHOW COLUMNS
FROM
  `cart`
WHERE
  `Field` LIKE ?

SHOW COLUMNS FROM `cart` WHERE `Field` LIKE 'payload';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 51)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityDefinitionQueryHelper::columnExists (line 161)
4	Shopware\Core\Checkout\Cart\CartPersister->payloadExists (line 43)
5	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
6	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
7	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
8	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
9	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 59)
11	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
12	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
13	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
14	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
18	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
19	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
20	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
24	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
26	Shopware\Core\Kernel->handle (line 146)
27	Shopware\Core\HttpKernel->doHandle (line 67)
28	Shopware\Core\HttpKernel->handle (line 71)
29	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 14)

4.03 ms
(3.94%)

# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC

Parameters:

[
  true
]

View formatted query View runnable query Explain query View query backtrace

# product-listing::load-sortings::search-ids
SELECT
  `product_sorting`.`id`
FROM
  `product_sorting`
WHERE
  (`product_sorting`.`active` = ?)
ORDER BY
  `product_sorting`.`priority` DESC

# product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = 1) ORDER BY `product_sorting`.`priority` DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 107)
10	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\SortingListingProcessor->getAvailableSortings (line 46)
11	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\SortingListingProcessor->prepare (line 32)
12	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\CompositeListingProcessor->prepare (line 43)
13	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
14	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
15	Shopware\Storefront\Controller\CmsController->filter (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
20	Shopware\Core\Kernel->handle (line 146)
21	Shopware\Core\HttpKernel->doHandle (line 67)
22	Shopware\Core\HttpKernel->handle (line 71)
23	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 14)

3.62 ms
(3.54%)

# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::category-loading::search-ids
SELECT
  `category`.`id`,
  `category`.`auto_increment`
FROM
  `category`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?)
  )
LIMIT
  1

# product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x81145EC808CD4E3DBFD9550BA1EBE0D7)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 53)
10	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
11	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
12	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
13	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
15	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
17	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
18	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
20	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
21	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
22	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
23	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
24	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
25	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
26	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
27	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
28	Shopware\Storefront\Controller\CmsController->filter (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
31	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
32	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
33	Shopware\Core\Kernel->handle (line 146)
34	Shopware\Core\HttpKernel->doHandle (line 67)
35	Shopware\Core\HttpKernel->handle (line 71)
36	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 14)

2.57 ms
(2.51%)

# product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::category-loading::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`product_stream_id` as `category.productStreamId`
FROM
  `category`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?)
  )

# product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x81145EC808CD4E3DBFD9550BA1EBE0D7));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 256)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 53)
11	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
12	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
13	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
14	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
15	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
16	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
17	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
18	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
19	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
20	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
21	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
22	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
24	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
25	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
26	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
27	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
28	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
29	Shopware\Storefront\Controller\CmsController->filter (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
32	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
34	Shopware\Core\Kernel->handle (line 146)
35	Shopware\Core\HttpKernel->doHandle (line 67)
36	Shopware\Core\HttpKernel->handle (line 71)
37	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 14)

2.28 ms
(2.23%)

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?)))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::price
SELECT
  MIN(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) as `price.min`,
  MAX(
    IFNULL(
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      ),
      COALESCE(
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        ),
        (
          ROUND(
            (
              ROUND(
                CAST(
                  (
                    JSON_UNQUOTE(
                      JSON_EXTRACT(
                        `product.parent`.`cheapest_price_accessor`,
                        "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross"
                      )
                    ) * 1
                  ) as DECIMAL(30, 20)
                ),
                2
              )
            ) * 100,
            0
          ) / 100
        )
      )
    )
  ) as `price.max`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )

# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule526d6930b1dd49d5ba77f629a6a477f7.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleadc7f28258b64f9aa877d237b34088ae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulec54c7c670e27454cb613c9d6d1e9e78b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule6c9bee2e47084fe09edf500180c8e9ba.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule7e2febe0d564402da0eb0a0f425dfcb8.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulea5b6366f102b41f7924cdaaf2b8bbf2e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleaec7d06af7734675a1ae0dd498a34e3d.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleca8324c3095543f6a69f923050786657.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulede2455bf8ca24b9a847c9e397e407269.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rulef0c63ac906df419090fc07780145dd6b.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51dc2dd875768a2eec716b420000.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule018f51e2f49d7319b04105d4f9cdff56.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruled40cf9900bd049508b93b3e9c880f8f6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)))) as `price.max` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

1.62 ms
(1.58%)

SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.title`,`cms_slot.swagCmsExtensionsForm.translation.title`) as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.successMessage`,`cms_slot.swagCmsExtensionsForm.translation.successMessage`) as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.receivers`,`cms_slot.swagCmsExtensionsForm.translation.receivers`) as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation.languageId`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id, `cms_slot.swagCmsExtensionsForm.translation`.title as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.success_message as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.receivers as `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation`.created_at as `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation`.updated_at as `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id as `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation`.language_id as `cms_slot.swagCmsExtensionsForm.translation.languageId` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.language_id = ?) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\fP‘íÍ|J\x05¸qóÐfÒ²Ç"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cms_slot`.`id` as `cms_slot.id`,
  `cms_slot`.`version_id` as `cms_slot.versionId`,
  `cms_slot`.`type` as `cms_slot.type`,
  `cms_slot`.`slot` as `cms_slot.slot`,
  `cms_slot`.`locked` as `cms_slot.locked`,
  `cms_slot`.`cms_block_id` as `cms_slot.blockId`,
  `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`,
  `cms_slot`.`created_at` as `cms_slot.createdAt`,
  `cms_slot`.`updated_at` as `cms_slot.updatedAt`,
  `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`,
  `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`,
  `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`,
  `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`,
  `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`,
  `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`,
  `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`,
  `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`,
  `cms_slot.swagCmsExtensionsForm.translation.title`,
  COALESCE(
    `cms_slot.swagCmsExtensionsForm.translation.title`,
    `cms_slot.swagCmsExtensionsForm.translation.title`
  ) as `cms_slot.swagCmsExtensionsForm.title`,
  `cms_slot.swagCmsExtensionsForm.translation.successMessage`,
  COALESCE(
    `cms_slot.swagCmsExtensionsForm.translation.successMessage`,
    `cms_slot.swagCmsExtensionsForm.translation.successMessage`
  ) as `cms_slot.swagCmsExtensionsForm.successMessage`,
  `cms_slot.swagCmsExtensionsForm.translation.receivers`,
  COALESCE(
    `cms_slot.swagCmsExtensionsForm.translation.receivers`,
    `cms_slot.swagCmsExtensionsForm.translation.receivers`
  ) as `cms_slot.swagCmsExtensionsForm.receivers`,
  `cms_slot.swagCmsExtensionsForm.translation.createdAt`,
  `cms_slot.swagCmsExtensionsForm.translation.updatedAt`,
  `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`,
  `cms_slot.swagCmsExtensionsForm.translation.languageId`,
  `cms_slot.translation.config`,
  COALESCE(
    `cms_slot.translation.config`, `cms_slot.translation.config`
  ) as `cms_slot.config`,
  `cms_slot.translation.customFields`,
  COALESCE(
    `cms_slot.translation.customFields`,
    `cms_slot.translation.customFields`
  ) as `cms_slot.customFields`,
  `cms_slot.translation.createdAt`,
  `cms_slot.translation.updatedAt`,
  `cms_slot.translation.cmsSlotId`,
  `cms_slot.translation.languageId`,
  `cms_slot.translation.cmsSlotVersionId`
FROM
  `cms_slot`
  LEFT JOIN (
    SELECT
      `cms_slot.translation`.cms_slot_id,
      `cms_slot.translation`.cms_slot_version_id,
      `cms_slot.translation`.config as `cms_slot.translation.config`,
      `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`,
      `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`,
      `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`,
      `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`,
      `cms_slot.translation`.language_id as `cms_slot.translation.languageId`,
      `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId`
    FROM
      `cms_slot_translation` `cms_slot.translation`
    WHERE
      `cms_slot.translation`.language_id = ?
  ) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id`
  AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id
  LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id`
  LEFT JOIN (
    SELECT
      `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id,
      `cms_slot.swagCmsExtensionsForm.translation`.title as `cms_slot.swagCmsExtensionsForm.translation.title`,
      `cms_slot.swagCmsExtensionsForm.translation`.success_message as `cms_slot.swagCmsExtensionsForm.translation.successMessage`,
      `cms_slot.swagCmsExtensionsForm.translation`.receivers as `cms_slot.swagCmsExtensionsForm.translation.receivers`,
      `cms_slot.swagCmsExtensionsForm.translation`.created_at as `cms_slot.swagCmsExtensionsForm.translation.createdAt`,
      `cms_slot.swagCmsExtensionsForm.translation`.updated_at as `cms_slot.swagCmsExtensionsForm.translation.updatedAt`,
      `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id as `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`,
      `cms_slot.swagCmsExtensionsForm.translation`.language_id as `cms_slot.swagCmsExtensionsForm.translation.languageId`
    FROM
      `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation`
    WHERE
      `cms_slot.swagCmsExtensionsForm.translation`.language_id = ?
  ) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id`
WHERE
  (`cms_slot`.`version_id` = ?)
  AND (
    `cms_slot`.`id` IN (?)
  )

SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.swagCmsExtensionsForm`.`id` as `cms_slot.swagCmsExtensionsForm.id`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotId`, `cms_slot.swagCmsExtensionsForm`.`cms_slot_version_id` as `cms_slot.swagCmsExtensionsForm.cmsSlotVersionId`, `cms_slot.swagCmsExtensionsForm`.`is_template` as `cms_slot.swagCmsExtensionsForm.isTemplate`, `cms_slot.swagCmsExtensionsForm`.`technical_name` as `cms_slot.swagCmsExtensionsForm.technicalName`, `cms_slot.swagCmsExtensionsForm`.`mail_template_id` as `cms_slot.swagCmsExtensionsForm.mailTemplateId`, `cms_slot.swagCmsExtensionsForm`.`created_at` as `cms_slot.swagCmsExtensionsForm.createdAt`, `cms_slot.swagCmsExtensionsForm`.`updated_at` as `cms_slot.swagCmsExtensionsForm.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.title`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.title`,`cms_slot.swagCmsExtensionsForm.translation.title`) as `cms_slot.swagCmsExtensionsForm.title`, `cms_slot.swagCmsExtensionsForm.translation.successMessage`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.successMessage`,`cms_slot.swagCmsExtensionsForm.translation.successMessage`) as `cms_slot.swagCmsExtensionsForm.successMessage`, `cms_slot.swagCmsExtensionsForm.translation.receivers`, COALESCE(`cms_slot.swagCmsExtensionsForm.translation.receivers`,`cms_slot.swagCmsExtensionsForm.translation.receivers`) as `cms_slot.swagCmsExtensionsForm.receivers`, `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation.languageId`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.createdAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.languageId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id LEFT JOIN `swag_cms_extensions_form` `cms_slot.swagCmsExtensionsForm` ON `cms_slot`.`id` = `cms_slot.swagCmsExtensionsForm`.`cms_slot_id` LEFT JOIN (SELECT `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id, `cms_slot.swagCmsExtensionsForm.translation`.title as `cms_slot.swagCmsExtensionsForm.translation.title`, `cms_slot.swagCmsExtensionsForm.translation`.success_message as `cms_slot.swagCmsExtensionsForm.translation.successMessage`, `cms_slot.swagCmsExtensionsForm.translation`.receivers as `cms_slot.swagCmsExtensionsForm.translation.receivers`, `cms_slot.swagCmsExtensionsForm.translation`.created_at as `cms_slot.swagCmsExtensionsForm.translation.createdAt`, `cms_slot.swagCmsExtensionsForm.translation`.updated_at as `cms_slot.swagCmsExtensionsForm.translation.updatedAt`, `cms_slot.swagCmsExtensionsForm.translation`.swag_cms_extensions_form_id as `cms_slot.swagCmsExtensionsForm.translation.swagCmsExtensionsFormId`, `cms_slot.swagCmsExtensionsForm.translation`.language_id as `cms_slot.swagCmsExtensionsForm.translation.languageId` FROM `swag_cms_extensions_form_translation` `cms_slot.swagCmsExtensionsForm.translation` WHERE `cms_slot.swagCmsExtensionsForm.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation` ON `cms_slot.swagCmsExtensionsForm.swag_cms_extensions_form_translation`.`swag_cms_extensions_form_id` = `cms_slot.swagCmsExtensionsForm`.`id` WHERE (`cms_slot`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`cms_slot`.`id` IN (0x0C5091EDCD7C4A05B871F3D066D2B2C7));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 256)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 60)
9	Pickware\PickwareErpStarter\OrderPickability\Decorator\EntityRepositoryDecorator->search (line 67)
10	MoorlFoundation\Core\Service\EntitySearchService->getEntityListing (line 29)
11	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
12	Shopware\Storefront\Controller\CmsController->filter (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
16	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
17	Shopware\Core\Kernel->handle (line 146)
18	Shopware\Core\HttpKernel->doHandle (line 67)
19	Shopware\Core\HttpKernel->handle (line 71)
20	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 14)

1.49 ms
(1.46%)

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(`script`.`app_id`)
  ) as `app_id`,
  `script`.`name` AS name,
  `script`.`script` AS script,
  `app`.`name` AS appName,
  LOWER(
    HEX(`app`.`integration_id`)
  ) AS integrationId,
  IFNULL(
    `script`.`updated_at`, `script`.`created_at`
  ) AS lastModified
FROM
  `script`
  LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
WHERE
  `script`.`hook` = 'include'
ORDER BY
  `app`.`created_at`,
  `app`.`id`,
  `script`.`name`

SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS name,
                   `script`.`script` AS script,
                   `app`.`name` AS appName,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            WHERE `script`.`hook` = 'include'
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 92)
3	Shopware\Core\Framework\Script\Execution\ScriptLoader->load (line 53)
4	Shopware\Core\Framework\Script\Execution\ScriptLoader->get (line 54)
5	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 56)
6	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 34)
8	Shopware\Core\Checkout\Cart\Processor->process (line 105)
9	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 83)
11	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
13	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
14	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
15	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 59)
17	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
18	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
19	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
20	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
24	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
25	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
26	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
32	Shopware\Core\Kernel->handle (line 146)
33	Shopware\Core\HttpKernel->doHandle (line 67)
34	Shopware\Core\HttpKernel->handle (line 71)
35	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 14)

1.09 ms
(1.07%)

# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = ?) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?, ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x00Ãk\x18Ýi@A•ÿ\x0F»÷iÆþ"
  b"çäbE„\x10D+”žfóí ¹õ"
  b":þ\x114Ž”H#»Y\rmeC&‚"
]

View formatted query View runnable query Explain query View query backtrace

# manufacturer-aggregation::read
SELECT
  `product_manufacturer`.`id` as `product_manufacturer.id`,
  `product_manufacturer`.`version_id` as `product_manufacturer.versionId`,
  `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`,
  `product_manufacturer`.`link` as `product_manufacturer.link`,
  `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`,
  `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`,
  `product_manufacturer.translation.name`,
  COALESCE(
    `product_manufacturer.translation.name`,
    `product_manufacturer.translation.name`
  ) as `product_manufacturer.name`,
  `product_manufacturer.translation.description`,
  COALESCE(
    `product_manufacturer.translation.description`,
    `product_manufacturer.translation.description`
  ) as `product_manufacturer.description`,
  `product_manufacturer.translation.customFields`,
  COALESCE(
    `product_manufacturer.translation.customFields`,
    `product_manufacturer.translation.customFields`
  ) as `product_manufacturer.customFields`,
  `product_manufacturer.translation.createdAt`,
  `product_manufacturer.translation.updatedAt`,
  `product_manufacturer.translation.productManufacturerId`,
  `product_manufacturer.translation.languageId`,
  `product_manufacturer.translation.productManufacturerVersionId`
FROM
  `product_manufacturer`
  LEFT JOIN (
    SELECT
      `product_manufacturer.translation`.product_manufacturer_id,
      `product_manufacturer.translation`.product_manufacturer_version_id,
      `product_manufacturer.translation`.name as `product_manufacturer.translation.name`,
      `product_manufacturer.translation`.description as `product_manufacturer.translation.description`,
      `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`,
      `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`,
      `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`,
      `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`,
      `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`,
      `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId`
    FROM
      `product_manufacturer_translation` `product_manufacturer.translation`
    WHERE
      `product_manufacturer.translation`.language_id = ?
  ) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id`
  AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id
WHERE
  (
    `product_manufacturer`.`version_id` = ?
  )
  AND (
    `product_manufacturer`.`id` IN (?, ?, ?)
  )

# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, COALESCE(`product_manufacturer.translation.name`,`product_manufacturer.translation.name`) as `product_manufacturer.name`, `product_manufacturer.translation.description`, COALESCE(`product_manufacturer.translation.description`,`product_manufacturer.translation.description`) as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, COALESCE(`product_manufacturer.translation.customFields`,`product_manufacturer.translation.customFields`) as `product_manufacturer.customFields`, `product_manufacturer.translation.createdAt`, `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation.languageId`, `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.product_manufacturer_id, `product_manufacturer.translation`.product_manufacturer_version_id, `product_manufacturer.translation`.name as `product_manufacturer.translation.name`, `product_manufacturer.translation`.description as `product_manufacturer.translation.description`, `product_manufacturer.translation`.custom_fields as `product_manufacturer.translation.customFields`, `product_manufacturer.translation`.created_at as `product_manufacturer.translation.createdAt`, `product_manufacturer.translation`.updated_at as `product_manufacturer.translation.updatedAt`, `product_manufacturer.translation`.product_manufacturer_id as `product_manufacturer.translation.productManufacturerId`, `product_manufacturer.translation`.language_id as `product_manufacturer.translation.languageId`, `product_manufacturer.translation`.product_manufacturer_version_id as `product_manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product_manufacturer.translation` WHERE `product_manufacturer.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_manufacturer.product_manufacturer_translation` ON `product_manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product_manufacturer`.`id` AND `product_manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product_manufacturer`.version_id WHERE (`product_manufacturer`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`product_manufacturer`.`id` IN (0x00C36B18DD69404195FF0FBBF769C6FE, 0xE7E462458410442B949E66F3ED20B9F5, 0x3AFE11348E944823BB590D6D65432682));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 60)
11	Pickware\PickwareErpStarter\OrderPickability\Decorator\EntityRepositoryDecorator->search (line 559)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->hydrateEntityAggregation (line 532)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->hydrateResult (line 492)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->hydrateResult (line 202)
15	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
16	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
17	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
18	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
19	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
20	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
21	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
22	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
23	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
24	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
25	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
26	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
27	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
28	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
29	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
30	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
31	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
32	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
33	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
34	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
35	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
36	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
37	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
38	Shopware\Storefront\Controller\CmsController->filter (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
41	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
42	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
43	Shopware\Core\Kernel->handle (line 146)
44	Shopware\Core\HttpKernel->doHandle (line 67)
45	Shopware\Core\HttpKernel->handle (line 71)
46	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
48	require_once (line 14)

1.03 ms
(1.01%)

# product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::options
SELECT
  LOWER(
    HEX(`product.options`.`id`)
  ) as `options.key`,
  COUNT(`product`.`id`) as `options.count`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`
  AND `product`.`version_id` = `product.options.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
  LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
GROUP BY
  `product.options`.`id`

# product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) GROUP BY `product.options`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

0.92 ms
(0.90%)

# product-listing-route::loading::aggregation::rating-exists
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
  0
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::rating-exists
SELECT
  MAX(
    IFNULL(
      `product`.`rating_average`, `product.parent`.`rating_average`
    )
  ) as `rating`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
  AND (
    (
      (
        IFNULL(
          `product`.`rating_average`, `product.parent`.`rating_average`
        ) >= ?
      )
    )
  )

# product-listing-route::loading::aggregation::rating-exists
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) AND (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= 0)));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

0.89 ms
(0.87%)

# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500

Parameters:

[
  true
  b"\x01‹B\x07B‰sÊšI|¿\x02:é\x0F"
  b"\x01‹B\x07Ìfw\x11»’ëÄÒ(>ü"
  b"¨u±\x16:ú@ŠS\x13¡txH\x07"
  b"¼ƒô‚W0J!µY\x04º92DÚ"
  b"èþVd|’CY«è^±ûø´a"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing::property-filter::search-ids
SELECT
  `property_group_option`.`id`
FROM
  `property_group_option`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
WHERE
  (
    (
      `property_group_option.group`.`filterable` = ?
    )
  )
  AND (
    `property_group_option`.`id` IN (?, ?, ?, ?, ?)
  )
ORDER BY
  `property_group_option`.`id` ASC
LIMIT
  500
OFFSET
  500

# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = 1)) AND (`property_group_option`.`id` IN (0x018B4207428973CA9A497CBF023AE90F, 0x018B4207CC667711BB92EBC4D2283EFC, 0xA875B1163AFA40AD8A5313A174784807, 0xBC83F48257304A21B55904BA393244DA, 0xE8FE56647C924359ABE85EB1FBF8B461)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 108)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator->fetch (line 78)
11	Shopware\Core\Content\Product\SalesChannel\Listing\Filter\PropertyListingFilterHandler->process (line 61)
12	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\AggregationListingProcessor->process (line 39)
13	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\CompositeListingProcessor->process (line 57)
14	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
15	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
16	Shopware\Storefront\Controller\CmsController->filter (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
21	Shopware\Core\Kernel->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 71)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 14)

0.75 ms
(0.74%)

# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¨u±\x16:ú@ŠS\x13¡txH\x07"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing::property-filter::read
SELECT
  `property_group_option`.`id` as `property_group_option.id`,
  `property_group_option`.`property_group_id` as `property_group_option.groupId`,
  `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`,
  `property_group_option`.`media_id` as `property_group_option.mediaId`,
  `property_group_option`.`created_at` as `property_group_option.createdAt`,
  `property_group_option`.`updated_at` as `property_group_option.updatedAt`,
  `property_group_option.group`.`id` as `property_group_option.group.id`,
  `property_group_option.group`.`display_type` as `property_group_option.group.displayType`,
  `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`,
  `property_group_option.group`.`filterable` as `property_group_option.group.filterable`,
  `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`,
  `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`,
  `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`,
  `property_group_option.group.translation.name`,
  COALESCE(
    `property_group_option.group.translation.name`,
    `property_group_option.group.translation.name`
  ) as `property_group_option.group.name`,
  `property_group_option.group.translation.description`,
  COALESCE(
    `property_group_option.group.translation.description`,
    `property_group_option.group.translation.description`
  ) as `property_group_option.group.description`,
  `property_group_option.group.translation.position`,
  COALESCE(
    `property_group_option.group.translation.position`,
    `property_group_option.group.translation.position`
  ) as `property_group_option.group.position`,
  `property_group_option.group.translation.customFields`,
  COALESCE(
    `property_group_option.group.translation.customFields`,
    `property_group_option.group.translation.customFields`
  ) as `property_group_option.group.customFields`,
  `property_group_option.group.translation.createdAt`,
  `property_group_option.group.translation.updatedAt`,
  `property_group_option.group.translation.propertyGroupId`,
  `property_group_option.group.translation.languageId`,
  `property_group_option.media`.`id` as `property_group_option.media.id`,
  `property_group_option.media`.`user_id` as `property_group_option.media.userId`,
  `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`,
  `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`,
  `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`,
  `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`,
  `property_group_option.media`.`file_name` as `property_group_option.media.fileName`,
  `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`,
  `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`,
  `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`,
  `property_group_option.media`.`config` as `property_group_option.media.config`,
  `property_group_option.media`.`path` as `property_group_option.media.path`,
  `property_group_option.media`.`private` as `property_group_option.media.private`,
  `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`,
  `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`,
  `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`,
  `property_group_option.media.translation.title`,
  COALESCE(
    `property_group_option.media.translation.title`,
    `property_group_option.media.translation.title`
  ) as `property_group_option.media.title`,
  `property_group_option.media.translation.alt`,
  COALESCE(
    `property_group_option.media.translation.alt`,
    `property_group_option.media.translation.alt`
  ) as `property_group_option.media.alt`,
  `property_group_option.media.translation.customFields`,
  COALESCE(
    `property_group_option.media.translation.customFields`,
    `property_group_option.media.translation.customFields`
  ) as `property_group_option.media.customFields`,
  `property_group_option.media.translation.createdAt`,
  `property_group_option.media.translation.updatedAt`,
  `property_group_option.media.translation.mediaId`,
  `property_group_option.media.translation.languageId`,
  `property_group_option.translation.name`,
  COALESCE(
    `property_group_option.translation.name`,
    `property_group_option.translation.name`
  ) as `property_group_option.name`,
  `property_group_option.translation.position`,
  COALESCE(
    `property_group_option.translation.position`,
    `property_group_option.translation.position`
  ) as `property_group_option.position`,
  `property_group_option.translation.customFields`,
  COALESCE(
    `property_group_option.translation.customFields`,
    `property_group_option.translation.customFields`
  ) as `property_group_option.customFields`,
  `property_group_option.translation.createdAt`,
  `property_group_option.translation.updatedAt`,
  `property_group_option.translation.propertyGroupOptionId`,
  `property_group_option.translation.languageId`
FROM
  `property_group_option`
  LEFT JOIN (
    SELECT
      `property_group_option.translation`.property_group_option_id,
      `property_group_option.translation`.name as `property_group_option.translation.name`,
      `property_group_option.translation`.position as `property_group_option.translation.position`,
      `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`,
      `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`,
      `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`,
      `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`,
      `property_group_option.translation`.language_id as `property_group_option.translation.languageId`
    FROM
      `property_group_option_translation` `property_group_option.translation`
    WHERE
      `property_group_option.translation`.language_id = ?
  ) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
  LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id`
  LEFT JOIN (
    SELECT
      `property_group_option.group.translation`.property_group_id,
      `property_group_option.group.translation`.name as `property_group_option.group.translation.name`,
      `property_group_option.group.translation`.description as `property_group_option.group.translation.description`,
      `property_group_option.group.translation`.position as `property_group_option.group.translation.position`,
      `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`,
      `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`,
      `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`,
      `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`,
      `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId`
    FROM
      `property_group_translation` `property_group_option.group.translation`
    WHERE
      `property_group_option.group.translation`.language_id = ?
  ) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id`
  LEFT JOIN (
    SELECT
      `property_group_option.media.translation`.media_id,
      `property_group_option.media.translation`.title as `property_group_option.media.translation.title`,
      `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`,
      `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`,
      `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`,
      `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`,
      `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`,
      `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId`
    FROM
      `media_translation` `property_group_option.media.translation`
    WHERE
      `property_group_option.media.translation`.language_id = ?
  ) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id`
WHERE
  `property_group_option`.`id` IN (?)

# product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) as `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) as `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) as `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, COALESCE(`property_group_option.media.translation.title`,`property_group_option.media.translation.title`) as `property_group_option.media.title`, `property_group_option.media.translation.alt`, COALESCE(`property_group_option.media.translation.alt`,`property_group_option.media.translation.alt`) as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, COALESCE(`property_group_option.media.translation.customFields`,`property_group_option.media.translation.customFields`) as `property_group_option.media.customFields`, `property_group_option.media.translation.createdAt`, `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation.mediaId`, `property_group_option.media.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) as `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) as `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) as `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name as `property_group_option.translation.name`, `property_group_option.translation`.position as `property_group_option.translation.position`, `property_group_option.translation`.custom_fields as `property_group_option.translation.customFields`, `property_group_option.translation`.created_at as `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at as `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id as `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id as `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name as `property_group_option.group.translation.name`, `property_group_option.group.translation`.description as `property_group_option.group.translation.description`, `property_group_option.group.translation`.position as `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields as `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at as `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at as `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id as `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id as `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.media_id, `property_group_option.media.translation`.title as `property_group_option.media.translation.title`, `property_group_option.media.translation`.alt as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.custom_fields as `property_group_option.media.translation.customFields`, `property_group_option.media.translation`.created_at as `property_group_option.media.translation.createdAt`, `property_group_option.media.translation`.updated_at as `property_group_option.media.translation.updatedAt`, `property_group_option.media.translation`.media_id as `property_group_option.media.translation.mediaId`, `property_group_option.media.translation`.language_id as `property_group_option.media.translation.languageId` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (0xA875B1163AFA40AD8A5313A174784807);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 256)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 108)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator->fetch (line 78)
12	Shopware\Core\Content\Product\SalesChannel\Listing\Filter\PropertyListingFilterHandler->process (line 61)
13	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\AggregationListingProcessor->process (line 39)
14	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\CompositeListingProcessor->process (line 57)
15	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
16	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
17	Shopware\Storefront\Controller\CmsController->filter (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
22	Shopware\Core\Kernel->handle (line 146)
23	Shopware\Core\HttpKernel->doHandle (line 67)
24	Shopware\Core\HttpKernel->handle (line 71)
25	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 14)

0.67 ms
(0.65%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter/"
  1
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT seo_path_info FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 OR sales_channel_id IS NULL)) AND (seo_path_info = 'widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter/') AND (is_canonical = 1) ORDER BY seo_path_info ASC, sales_channel_id IS NULL ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 384)
3	Doctrine\DBAL\Query\QueryBuilder->execute (line 108)
4	KielCodingPlatformTrailingSlash\TrailingSlash\SeoResolver->redirectTarget (line 43)
5	KielCodingPlatformTrailingSlash\TrailingSlash\SeoResolver->resolve (line 35)
6	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 122)
8	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 24)
9	KielCodingPlatformTrailingSlash\TrailingSlash\RequestTransformer->transform (line 126)
10	Shopware\Core\HttpKernel->doHandle (line 67)
11	Shopware\Core\HttpKernel->handle (line 71)
12	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 14)

0.57 ms
(0.55%)

# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"¸\¤\x12)ÅM\x10âÍ°þè¹s\x10"
  b"Ö4{š4?JÙ—A\x1Aó,\x0Eëã"
  b"•õ3XÌÏH$†‹þ«j\:¯"
  b"vÌ\x18—•\tI@‚åˆÖ‡8•O"
  b"S'‚wYëFß£\x01‘åå€îQ"
  b"ÅÜÍ▄ß┘EÀ¿vÇ╣U\v╚░"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing::load-sortings::read
SELECT
  `product_sorting`.`id` as `product_sorting.id`,
  `product_sorting`.`locked` as `product_sorting.locked`,
  `product_sorting`.`url_key` as `product_sorting.key`,
  `product_sorting`.`priority` as `product_sorting.priority`,
  `product_sorting`.`active` as `product_sorting.active`,
  `product_sorting`.`fields` as `product_sorting.fields`,
  `product_sorting`.`created_at` as `product_sorting.createdAt`,
  `product_sorting`.`updated_at` as `product_sorting.updatedAt`,
  `product_sorting.translation.label`,
  COALESCE(
    `product_sorting.translation.label`,
    `product_sorting.translation.label`
  ) as `product_sorting.label`,
  `product_sorting.translation.createdAt`,
  `product_sorting.translation.updatedAt`,
  `product_sorting.translation.productSortingId`,
  `product_sorting.translation.languageId`
FROM
  `product_sorting`
  LEFT JOIN (
    SELECT
      `product_sorting.translation`.product_sorting_id,
      `product_sorting.translation`.label as `product_sorting.translation.label`,
      `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`,
      `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`,
      `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`,
      `product_sorting.translation`.language_id as `product_sorting.translation.languageId`
    FROM
      `product_sorting_translation` `product_sorting.translation`
    WHERE
      `product_sorting.translation`.language_id = ?
  ) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id`
WHERE
  `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?)

# product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, COALESCE(`product_sorting.translation.label`,`product_sorting.translation.label`) as `product_sorting.label`, `product_sorting.translation.createdAt`, `product_sorting.translation.updatedAt`, `product_sorting.translation.productSortingId`, `product_sorting.translation.languageId` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.product_sorting_id, `product_sorting.translation`.label as `product_sorting.translation.label`, `product_sorting.translation`.created_at as `product_sorting.translation.createdAt`, `product_sorting.translation`.updated_at as `product_sorting.translation.updatedAt`, `product_sorting.translation`.product_sorting_id as `product_sorting.translation.productSortingId`, `product_sorting.translation`.language_id as `product_sorting.translation.languageId` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (0xF75CCF12298F4D1083D6F8E78AFB7310, 0xD6347B9A343F4AD997411AF32C0EEBE3, 0x95F53358CCCF4824868BFEAB6A5C3AAF, 0x76CC18979509494082E588D68738954F, 0x5327827759EB46DFA30191E5E580EE51, 0x8F9AD6DCE1D945B7A87680B9550BC8B0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 311)
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 212)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 256)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 65)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 107)
11	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\SortingListingProcessor->getAvailableSortings (line 46)
12	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\SortingListingProcessor->prepare (line 32)
13	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\CompositeListingProcessor->prepare (line 43)
14	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
15	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
16	Shopware\Storefront\Controller\CmsController->filter (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
21	Shopware\Core\Kernel->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 71)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 14)

0.54 ms
(0.53%)

# product-listing-route::loading::aggregation::shipping-free-filter
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  30
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  true
  b"ü\x14^╚\x08═N=┐┘U\víÙÓÎ"
  null
  true
  false
  true
]

View formatted query View runnable query Explain query View query backtrace

# product-listing-route::loading::aggregation::shipping-free-filter
SELECT
  MAX(
    IFNULL(
      `product`.`shipping_free`, `product.parent`.`shipping_free`
    )
  ) as `shipping-free`
FROM
  `product`
  LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id`
  AND `product`.`parent_version_id` = `product.parent`.`version_id`
  LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id`
  AND `product`.version_id = `product.visibilities`.product_version_id
  LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`
  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id`
  LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`
  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id`
WHERE
  (`product`.`version_id` = ?)
  AND (
    (
      (
        (
          `product.visibilities`.`visibility` >= ?
        )
        AND `product.visibilities`.`sales_channel_id` = ?
        AND IFNULL(
          `product`.`active`, `product.parent`.`active`
        ) = ?
      )
      AND `product.categoriesRo`.`id` = ?
      AND NOT (`product`.`display_group` <=> ?)
      AND NOT (
        IFNULL(
          `product`.`is_closeout`, `product.parent`.`is_closeout`
        ) <=> ?
        AND `product`.`available` <=> ?
      )
    )
  )
  AND (
    (
      IFNULL(
        `product`.`shipping_free`, `product.parent`.`shipping_free`
      ) = ?
    )
  )

# product-listing-route::loading::aggregation::shipping-free-filter
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((((`product.visibilities`.`visibility` >= 30) AND `product.visibilities`.`sales_channel_id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 AND IFNULL(`product`.`active`, `product.parent`.`active`) = 1) AND `product.categoriesRo`.`id` = 0x81145EC808CD4E3DBFD9550BA1EBE0D7 AND NOT (`product`.`display_group` <=> NULL) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> 1 AND `product`.`available` <=> 0))) AND ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = 1));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 200)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->fetchAggregation (line 83)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityAggregator->aggregate (line 40)
5	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator->aggregate (line 117)
6	Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->aggregate (line 59)
7	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load (line 60)
8	Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load (line 62)
9	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 416)
10	Shopware\Core\System\SystemConfig\SystemConfigService->trace (line 140)
11	Pickware\ShopwareExtensionsBundle\Mail\SystemConfigServiceDecorator->trace (line 33)
12	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 96)
13	Shopware\Core\Framework\Adapter\Translation\Translator->trace (line 33)
14	Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
15	Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace (line 33)
16	Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace (line 35)
17	Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure} (line 76)
18	Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace (line 35)
19	Shopware\Storefront\Framework\Cache\CacheTracer->trace (line 62)
20	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure} (line 70)
21	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet (line 33)
22	Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get (line 59)
23	Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load (line 53)
24	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
25	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
26	Shopware\Storefront\Controller\CmsController->filter (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
31	Shopware\Core\Kernel->handle (line 146)
32	Shopware\Core\HttpKernel->doHandle (line 67)
33	Shopware\Core\HttpKernel->handle (line 71)
34	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 14)

0.46 ms
(0.45%)

# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500

Parameters:

[
  true
  b"\x01‹B\x07B‰sÊšI|¿\x02:é\x0F"
  b"\x01‹B\x07Ìfw\x11»’ëÄÒ(>ü"
  b"¨u±\x16:ú@ŠS\x13¡txH\x07"
  b"¼ƒô‚W0J!µY\x04º92DÚ"
  b"èþVd|’CY«è^±ûø´a"
]

View formatted query View runnable query Explain query View query backtrace

# product-listing::property-filter::search-ids
SELECT
  `property_group_option`.`id`
FROM
  `property_group_option`
  LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id`
WHERE
  (
    (
      `property_group_option.group`.`filterable` = ?
    )
  )
  AND (
    `property_group_option`.`id` IN (?, ?, ?, ?, ?)
  )
ORDER BY
  `property_group_option`.`id` ASC
LIMIT
  500

# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = 1)) AND (`property_group_option`.`id` IN (0x018B4207428973CA9A497CBF023AE90F, 0x018B4207CC667711BB92EBC4D2283EFC, 0xA875B1163AFA40AD8A5313A174784807, 0xBC83F48257304A21B55904BA393244DA, 0xE8FE56647C924359ABE85EB1FBF8B461)) ORDER BY `property_group_option`.`id` ASC LIMIT 500;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
8	Shopware\Core\Profiling\Profiler::trace (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 108)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\Common\RepositoryIterator->fetch (line 78)
11	Shopware\Core\Content\Product\SalesChannel\Listing\Filter\PropertyListingFilterHandler->process (line 61)
12	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\AggregationListingProcessor->process (line 39)
13	Shopware\Core\Content\Product\SalesChannel\Listing\Processor\CompositeListingProcessor->process (line 57)
14	Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load (line 40)
15	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
16	Shopware\Storefront\Controller\CmsController->filter (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
21	Shopware\Core\Kernel->handle (line 146)
22	Shopware\Core\HttpKernel->doHandle (line 67)
23	Shopware\Core\HttpKernel->handle (line 71)
24	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 14)

0.35 ms
(0.35%)

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 924)
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 34)
5	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line 179)
6	Shopware\Core\HttpKernel->createKernel (line 118)
7	Shopware\Core\HttpKernel->doHandle (line 67)
8	Shopware\Core\HttpKernel->handle (line 71)
9	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 14)

0.34 ms
(0.33%)

# 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 37)
2	Shopware\Core\Framework\Plugin\KernelPluginLoader\DbalKernelPluginLoader->loadPluginInfos (line 109)
3	Shopware\Core\Framework\Plugin\KernelPluginLoader\KernelPluginLoader->initializePlugins (line 182)
4	Shopware\Core\Kernel->boot (line 119)
5	Shopware\Core\HttpKernel->doHandle (line 67)
6	Shopware\Core\HttpKernel->handle (line 71)
7	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 14)

0.27 ms
(0.26%)

# 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"b\x0E_]iåL½žH¾Z¾T÷³"
  "/widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter"
]

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 = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3) AND (path_info = '/widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter') AND (is_canonical = 1) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 92)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 45)
4	KielCodingPlatformTrailingSlash\TrailingSlash\SeoResolver->resolve (line 35)
5	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 122)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 24)
8	KielCodingPlatformTrailingSlash\TrailingSlash\RequestTransformer->transform (line 126)
9	Shopware\Core\HttpKernel->doHandle (line 67)
10	Shopware\Core\HttpKernel->handle (line 71)
11	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 14)

0.25 ms
(0.24%)

# 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 = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  "widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter"
]

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 = ?)

# 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 = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3 OR sales_channel_id IS NULL)) AND (seo_path_info = 'widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 48)
3	Shopware\Core\Content\Seo\SeoResolver->resolve (line 45)
4	KielCodingPlatformTrailingSlash\TrailingSlash\SeoResolver->resolve (line 35)
5	Shopware\Core\Content\Seo\EmptyPathInfoResolver->resolve (line 325)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 122)
7	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 24)
8	KielCodingPlatformTrailingSlash\TrailingSlash\RequestTransformer->transform (line 126)
9	Shopware\Core\HttpKernel->doHandle (line 67)
10	Shopware\Core\HttpKernel->handle (line 71)
11	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 14)

0.24 ms
(0.24%)

SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`

Parameters:

[
  b"b\x0E_]iåL½žH¾Z¾T÷³"
  b"CÕL P»L\x07Ÿ3|-'i’\x16"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `country`.`id`
FROM
  `country`
  LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`
  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`
WHERE
  (
    (`country.salesChannels`.`id` = ?)
  )
  AND (
    `country`.`id` IN (?)
  )
GROUP BY
  `country`.`id`

SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id`  LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id`  WHERE ((`country.salesChannels`.`id` = 0x620E5F5D69E54CBD9E48BE5ABE54F7B3)) AND (`country`.`id` IN (0x43D54C2050BB4C079F337C2D27699216)) GROUP BY `country`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 93)
6	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 53)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 25)
8	Shopware\Core\Checkout\Cart\Validator->validate (line 62)
9	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
10	Shopware\Core\Profiling\Profiler::trace (line 34)
11	Shopware\Core\Checkout\Cart\Processor->process (line 105)
12	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 83)
14	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 27)
16	Acris\Tax\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 26)
17	Acris\CheckoutMethodPreselect\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 91)
18	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 59)
20	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 26)
21	Acris\CheckoutMethodPreselect\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 63)
22	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
23	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
27	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
28	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
29	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
34	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
35	Shopware\Core\Kernel->handle (line 146)
36	Shopware\Core\HttpKernel->doHandle (line 67)
37	Shopware\Core\HttpKernel->handle (line 71)
38	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
40	require_once (line 14)

0.12 ms
(0.12%)

SELECT module.module, module.response FROM wbm_data_layer_modules module

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  module.module,
  module.response
FROM
  wbm_data_layer_modules module

SELECT module.module, module.response FROM wbm_data_layer_modules module;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 308)
3	Doctrine\DBAL\Query\QueryBuilder->fetchAllKeyValue (line 48)
4	Wbm\TagManagerAnalytics\Services\DataLayerModules->getModules (line 58)
5	Wbm\TagManagerAnalytics\Subscriber\KernelEventsSubscriber->getDataLayerForXmlHttpRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 47)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 70)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
16	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
17	Shopware\Core\Kernel->handle (line 146)
18	Shopware\Core\HttpKernel->doHandle (line 67)
19	Shopware\Core\HttpKernel->handle (line 71)
20	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 14)

0.12 ms
(0.12%)

SELECT `cms_slot`.`id` FROM `cms_slot` WHERE (`cms_slot`.`version_id` = ?) AND (`cms_slot`.`id` IN (?)) LIMIT 1

Parameters:

[
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\fP‘íÍ|J\x05¸qóÐfÒ²Ç"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cms_slot`.`id`
FROM
  `cms_slot`
WHERE
  (`cms_slot`.`version_id` = ?)
  AND (
    `cms_slot`.`id` IN (?)
  )
LIMIT
  1

SELECT `cms_slot`.`id` FROM `cms_slot` WHERE (`cms_slot`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`cms_slot`.`id` IN (0x0C5091EDCD7C4A05B871F3D066D2B2C7)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 47)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 86)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 245)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 60)
8	Pickware\PickwareErpStarter\OrderPickability\Decorator\EntityRepositoryDecorator->search (line 67)
9	MoorlFoundation\Core\Service\EntitySearchService->getEntityListing (line 29)
10	MoorlFoundation\Core\Content\Product\SalesChannel\Listing\FoundationProductListingRoute->load (line 101)
11	Shopware\Storefront\Controller\CmsController->filter (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 44)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
15	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 158)
16	Shopware\Core\Kernel->handle (line 146)
17	Shopware\Core\HttpKernel->doHandle (line 67)
18	Shopware\Core\HttpKernel->handle (line 71)
19	Symfony\Component\HttpKernel\HttpKernelInterface@anonymous/var/www/stag/shopware/releases/353/public/index.php:61$0->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 14)

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://been.tintrio.dev/widgets/cms/navigation/81145ec808cd4e3dbfd9550ba1ebe0d7/filter?only-aggregations=1&reduce-aggregations=1&slots=0c5091edcd7c4a05b871f3d0…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache