Symfony Profiler

Query Metrics

21 Database Queries

20 Different statements

9.20 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

1.43 ms
(15.59%)

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

Parameters:

[
  "/robots.txt"
  "https://stage.bar-tek.com/robots.txt"
  "stage.bar-tek.com/robots.txt"
  1
  "regex"
  "/robots.txt"
  "https://stage.bar-tek.com/robots.txt"
  "stage.bar-tek.com/robots.txt"
  "regex"
  "/robots.txt"
  "https://stage.bar-tek.com/robots.txt"
  "stage.bar-tek.com/robots.txt"
]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.97 ms
(10.55%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.87 ms
(9.51%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.72 ms
(7.85%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.67 ms
(7.23%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.47 ms
(5.11%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.45 ms
(4.94%)

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

# dbal-plugin-loader
SELECT
  `name`,
  `base_class` AS baseClass,
  IF(
    `active` = 1
    AND `installed_at` IS NOT NULL,
    1,
    0
  ) AS active,
  `path`,
  `version`,
  `autoload`,
  `managed_by_composer` AS managedByComposer,
  composer_name as composerName
FROM
  `plugin`
ORDER BY
  `installed_at`;

# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;;

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

0.45 ms
(4.88%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 192)
9	DreiscSeoPro\Core\Foundation\Dal\EntityRepository->search (line 152)
10	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->fetchCustomSettingsBySalesChannelId (line 106)
11	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->load (line 32)
12	DreiscSeoPro\Core\CustomSetting\CustomSettingLoader->load (line 28)
13	DreiscSeoPro\Controller\RobotsTxtController->showRobots (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 10)

0.42 ms
(4.52%)

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

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 310)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 204)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 232)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 62)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 192)
9	DreiscSeoPro\Core\Foundation\Dal\EntityRepository->search (line 152)
10	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->fetchCustomSettingsBySalesChannelId (line 119)
11	DreiscSeoPro\Core\Foundation\CustomSettingEntity\CustomSettingEntityService->load (line 32)
12	DreiscSeoPro\Core\CustomSetting\CustomSettingLoader->load (line 28)
13	DreiscSeoPro\Controller\RobotsTxtController->showRobots (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 50)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 10)

0.33 ms
(3.63%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.32 ms
(3.49%)

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  custom_entity.name,
  custom_entity.fields,
  custom_entity.flags
FROM
  custom_entity
  LEFT JOIN app ON app.id = custom_entity.app_id
WHERE
  (
    custom_entity.app_id IS NULL
    OR app.active = 1
  )
  AND custom_entity.deleted_at IS NULL;

SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
            ;

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

0.30 ms
(3.32%)

SELECT `key`, `value` FROM `app_config`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `key`,
  `value`
FROM
  `app_config`

SELECT `key`, `value` FROM `app_config`;

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

0.27 ms
(2.98%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.27 ms
(2.91%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.24 ms
(2.57%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.22 ms
(2.42%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.22 ms
(2.41%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId, is_deleted isDeleted FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351) AND ((sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE OR sales_channel_id IS NULL)) AND ((seo_path_info = 'robots.txt' OR seo_path_info = 'robots.txt/'));

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

0.22 ms
(2.34%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.20 ms
(2.12%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0xDE44571DDC4E4D0095C01AF6EE299351) AND (sales_channel_id = 0xBC03B12FCA6E446C9BBE735AE1F4D0CE) AND (path_info = '/robots.txt') AND (is_canonical = 1) LIMIT 1;

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

0.15 ms
(1.62%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

Database Connections

Name	Service
0	default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Symfony Profiler

GET https://stage.bar-tek.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache