Symfony Profiler

Query Metrics

34 Database Queries

31 Different statements

129.53 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

19.74 ms
(15.24%)

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 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 186)
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 26)
12	DreiscSeoPro\Core\CustomSetting\CustomSettingLoader->load (line 26)
13	DreiscSeoPro\Decorator\Storefront\Framework\Twig\TemplateDataExtensionDecorator->getGlobals (line 365)
14	Twig\ExtensionSet->getGlobals (line 908)
15	Twig\Environment->getGlobals (line 398)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 24)
21	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 288)
22	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
23	Shopware\Storefront\Controller\StorefrontController->render (line 87)
24	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
25	Shopware\Core\Profiling\Profiler::trace (line 87)
26	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
27	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
30	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
31	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
36	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
37	Shopware\Core\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
39	require_once (line 11)

17.45 ms
(13.47%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  false
  true
  "product_download"
  b"R\x11È"J`A·¡BöáwhK{"
  b"\x7FLÕc:\x04JW¯¸|fŠÅo©"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 68)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 61)
11	Shopware\Storefront\Theme\ResolvedConfigLoader->load (line 82)
12	Shopware\Storefront\Theme\ThemeConfigValueAccessor->getThemeConfig (line 32)
13	Shopware\Storefront\Theme\ThemeConfigValueAccessor->get (line 43)
14	Shopware\Storefront\Framework\Twig\TemplateConfigAccessor->theme (line 49)
15	Shopware\Storefront\Framework\Twig\Extension\ConfigExtension->theme (line 571)
16	__TwigTemplate_187e4df9534101f7c46a7e6fe50ca602->block_layout_head_meta_tags_image_og (line 446)
17	Twig\Template->yieldBlock (line 466)
18	Twig\Template->yieldBlock (line 466)
19	Twig\Template->yieldBlock (line 491)
20	Twig\Template->yieldParentBlock (line 120)
21	Twig\Template->displayParentBlock (line 163)
22	Twig\Template->renderParentBlock (line 92)
23	__TwigTemplate_b32b40f5cff011d059316017c2765a25->block_layout_head_meta_tags_image_og (line 446)
24	Twig\Template->yieldBlock (line 405)
25	__TwigTemplate_187e4df9534101f7c46a7e6fe50ca602->block_layout_head_meta_tags_opengraph (line 446)
26	Twig\Template->yieldBlock (line 122)
27	__TwigTemplate_187e4df9534101f7c46a7e6fe50ca602->block_layout_head_meta_tags (line 446)
28	Twig\Template->yieldBlock (line 466)
29	Twig\Template->yieldBlock (line 466)
30	Twig\Template->yieldBlock (line 466)
31	Twig\Template->yieldBlock (line 491)
32	Twig\Template->yieldParentBlock (line 85)
33	__TwigTemplate_ef218343e014264a907ce51bbbd8ce7e->block_layout_head_meta_tags (line 446)
34	Twig\Template->yieldBlock (line 466)
35	Twig\Template->yieldBlock (line 491)
36	Twig\Template->yieldParentBlock (line 81)
37	__TwigTemplate_f18a50f9c6e9e2e1822413cb9b26c86c->block_layout_head_meta_tags (line 446)
38	Twig\Template->yieldBlock (line 153)
39	__TwigTemplate_e495277b5ee9da2eea3e9da196a8d4ae->block_layout_head_inner (line 446)
40	Twig\Template->yieldBlock (line 100)
41	__TwigTemplate_e495277b5ee9da2eea3e9da196a8d4ae->doDisplay (line 402)
42	Twig\Template->yield (line 57)
43	__TwigTemplate_242847c2865689827fc143d0ada83561->doDisplay (line 402)
44	Twig\Template->yield (line 79)
45	__TwigTemplate_aed7c8aa0b59fbac1714a803812d9e9e->doDisplay (line 402)
46	Twig\Template->yield (line 84)
47	__TwigTemplate_187e4df9534101f7c46a7e6fe50ca602->doDisplay (line 402)
48	Twig\Template->yield (line 57)
49	__TwigTemplate_a8e94ff803aede5029ff2ab776152d7f->doDisplay (line 402)
50	Twig\Template->yield (line 57)
51	__TwigTemplate_16356f9bfc8330130f50180b091034d2->doDisplay (line 402)
52	Twig\Template->yield (line 70)
53	__TwigTemplate_b32b40f5cff011d059316017c2765a25->doDisplay (line 402)
54	Twig\Template->yield (line 58)
55	__TwigTemplate_ef218343e014264a907ce51bbbd8ce7e->doDisplay (line 402)
56	Twig\Template->yield (line 58)
57	__TwigTemplate_679e972f8ed1109e3d95498bc530a1bb->doDisplay (line 402)
58	Twig\Template->yield (line 57)
59	__TwigTemplate_f18a50f9c6e9e2e1822413cb9b26c86c->doDisplay (line 402)
60	Twig\Template->yield (line 57)
61	__TwigTemplate_e7286d3c7eb0b9a864408904db58014d->doDisplay (line 402)
62	Twig\Template->yield (line 58)
63	__TwigTemplate_f7be2c67ce44e37e73f084d20e01cd5c->doDisplay (line 402)
64	Twig\Template->yield (line 171)
65	__TwigTemplate_138b6448eeacf2b45062d3ca3e7b6ecf->block_base_head (line 446)
66	Twig\Template->yieldBlock (line 87)
67	__TwigTemplate_13a0af7d34ae9bc1ef7d2a3898cdcf66->doDisplay (line 402)
68	Twig\Template->yield (line 57)
69	__TwigTemplate_b788d486283a299a074f92e9490ea2d1->doDisplay (line 402)
70	Twig\Template->yield (line 57)
71	__TwigTemplate_b1f75e43f7cddbdaa3b57628344879c9->doDisplay (line 402)
72	Twig\Template->yield (line 57)
73	__TwigTemplate_1cbff788ec0a28c51040f9056000771d->doDisplay (line 402)
74	Twig\Template->yield (line 57)
75	__TwigTemplate_017dce951f22b22a7f3d2b7b75f94aad->doDisplay (line 402)
76	Twig\Template->yield (line 57)
77	__TwigTemplate_f3e87256ba0ff348025eb5dfb32afb40->doDisplay (line 402)
78	Twig\Template->yield (line 57)
79	__TwigTemplate_9a10c3c32b4693d13fdb84595d61546e->doDisplay (line 402)
80	Twig\Template->yield (line 58)
81	__TwigTemplate_374f86783593f118e2426349e3f27a8f->doDisplay (line 402)
82	Twig\Template->yield (line 57)
83	__TwigTemplate_ab5dff078501256a7953fb9d114b95e6->doDisplay (line 402)
84	Twig\Template->yield (line 83)
85	__TwigTemplate_138b6448eeacf2b45062d3ca3e7b6ecf->doDisplay (line 402)
86	Twig\Template->yield (line 358)
87	Twig\Template->display (line 373)
88	Twig\Template->render (line 51)
89	Twig\TemplateWrapper->render (line 333)
90	Twig\Environment->render (line 24)
91	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 288)
92	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
93	Shopware\Storefront\Controller\StorefrontController->render (line 87)
94	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
95	Shopware\Core\Profiling\Profiler::trace (line 87)
96	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
97	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
98	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
99	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
100	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
101	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
102	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
103	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
104	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
105	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
106	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
107	Shopware\Core\Kernel->handle (line 35)
108	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
109	require_once (line 11)

13.22 ms
(10.20%)

-- Lexicon getCmsPage::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND ((`cms_page`.`id` = ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x01Šd#cÌsy¿MÞ}v?HK"
]

View formatted query View runnable query Explain query View query backtrace

-- Lexicon getCmsPage::read
SELECT
  `cms_page`.`id` as `cms_page.id`,
  `cms_page`.`version_id` as `cms_page.versionId`,
  `cms_page`.`type` as `cms_page.type`,
  `cms_page`.`entity` as `cms_page.entity`,
  `cms_page`.`css_class` as `cms_page.cssClass`,
  `cms_page`.`config` as `cms_page.config`,
  `cms_page`.`preview_media_id` as `cms_page.previewMediaId`,
  `cms_page`.`locked` as `cms_page.locked`,
  `cms_page`.`created_at` as `cms_page.createdAt`,
  `cms_page`.`updated_at` as `cms_page.updatedAt`,
  `cms_page.translation.name`,
  `cms_page.translation.name` as `cms_page.name`,
  `cms_page.translation.customFields`,
  `cms_page.translation.customFields` as `cms_page.customFields`
FROM
  `cms_page`
  LEFT JOIN (
    SELECT
      `cms_page.translation`.`cms_page_id`,
      `cms_page.translation`.`cms_page_version_id`,
      `cms_page.translation`.`name` as `cms_page.translation.name`,
      `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields`
    FROM
      `cms_page_translation` `cms_page.translation`
    WHERE
      `cms_page.translation`.`language_id` = ?
  ) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id`
  AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id`
WHERE
  (`cms_page`.`version_id` = ?)
  AND (
    (`cms_page`.`id` = ?)
  )

-- Lexicon getCmsPage::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND ((`cms_page`.`id` = 0x018A642363CC7379BF4DDE7D763F484B));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 68)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 42)
11	Cbax\ModulLexicon\Components\LexiconCMSHelper->getCmsPage (line 153)
12	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
15	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
16	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
21	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
22	Shopware\Core\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
24	require_once (line 11)

10.63 ms
(8.21%)

-- Lexicon getCmsPage::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?, ?))))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x01Šd#cÌsy¿MÞ}vñ\x0E"
  b"\x01Šd#cÌsy¿MÞ}wT“U"
]

View formatted query View runnable query Explain query View query backtrace

-- Lexicon getCmsPage::association::sections::association::blocks::read
SELECT
  `cms_block`.`id` as `cms_block.id`,
  `cms_block`.`version_id` as `cms_block.versionId`,
  `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`,
  `cms_block`.`position` as `cms_block.position`,
  `cms_block`.`type` as `cms_block.type`,
  `cms_block`.`locked` as `cms_block.locked`,
  `cms_block`.`name` as `cms_block.name`,
  `cms_block`.`section_position` as `cms_block.sectionPosition`,
  `cms_block`.`margin_top` as `cms_block.marginTop`,
  `cms_block`.`margin_bottom` as `cms_block.marginBottom`,
  `cms_block`.`margin_left` as `cms_block.marginLeft`,
  `cms_block`.`margin_right` as `cms_block.marginRight`,
  `cms_block`.`background_color` as `cms_block.backgroundColor`,
  `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`,
  `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`,
  `cms_block`.`css_class` as `cms_block.cssClass`,
  `cms_block`.`visibility` as `cms_block.visibility`,
  `cms_block`.`cms_section_id` as `cms_block.sectionId`,
  `cms_block`.`custom_fields` as `cms_block.customFields`,
  `cms_block`.`created_at` as `cms_block.createdAt`,
  `cms_block`.`updated_at` as `cms_block.updatedAt`,
  `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`,
  `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`,
  `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`,
  `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`,
  `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`,
  `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`,
  `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`,
  `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`,
  `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`,
  `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`,
  `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`,
  `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`,
  `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`,
  `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`,
  `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`,
  `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`,
  `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`,
  `cms_block.backgroundMedia.translation.title`,
  `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`,
  `cms_block.backgroundMedia.translation.alt`,
  `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`,
  `cms_block.backgroundMedia.translation.customFields`,
  `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields`
FROM
  `cms_block`
  LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id`
  LEFT JOIN (
    SELECT
      `cms_block.backgroundMedia.translation`.`media_id`,
      `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`,
      `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`,
      `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields`
    FROM
      `media_translation` `cms_block.backgroundMedia.translation`
    WHERE
      `cms_block.backgroundMedia.translation`.`language_id` = ?
  ) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id`
WHERE
  (`cms_block`.`version_id` = ?)
  AND (
    (
      (
        `cms_block`.`cms_section_id` IN (?, ?)
      )
    )
  )

-- Lexicon getCmsPage::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`cms_block`.`cms_section_id` IN (0x018A642363CC7379BF4DDE7D768FF10E, 0x018A642363CC7379BF4DDE7D77549355))));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
16	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
17	Shopware\Core\Profiling\Profiler::trace (line 68)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 42)
19	Cbax\ModulLexicon\Components\LexiconCMSHelper->getCmsPage (line 153)
20	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
32	require_once (line 11)

7.61 ms
(5.87%)

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"k:ßè\r+Iå®öÂ\x7Fˆ°×"
  "lexikon/p"
]

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` = 0x6B3ADFE80D2B49E5AE9DF6C27F88B0D7 AND `dreisc_seo_redirect`.`source_path` = 'lexikon/p'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 186)
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 48)
14	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
15	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
23	require_once (line 11)

7.09 ms
(5.47%)

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

Parameters:

[
  b"i„öTY#Hêh€Ã_MPÂ"
  "3HPWGWqZSHZ5D88u9A398VLiFuvWnc2N"
]

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 = 0x6984F654592348EAAD6880C35F4D50C2) AND (token = '3HPWGWqZSHZ5D88u9A398VLiFuvWnc2N') LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 80)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->{closure:Shopware\Core\System\SalesChannel\Context\SalesChannelContextService::get():77} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 77)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 69)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
8	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
12	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
13	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
14	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
27	require_once (line 11)

6.55 ms
(5.06%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 655)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 78)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 50)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 27)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 143)
6	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
7	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 285)
8	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
9	Shopware\Storefront\Controller\StorefrontController->render (line 87)
10	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 87)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
13	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
16	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
17	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
25	require_once (line 11)

6.38 ms
(4.92%)

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

Parameters:

[
  b"\x01Á:Wc|¸—º\x02\x19ª<Oé"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 68)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 36)
11	Shopware\Storefront\System\SalesChannel\SalesChannelAnalyticsLoader->loadAnalytics (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 79)
19	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
20	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
32	require_once (line 11)

5.65 ms
(4.36%)

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

Parameters:

[
  b"\x0FÅ˜D¦{BÉ¼fËo\v;N‡"
  b"\x0FÅ˜D¦{BÉ¼fËo\v;N‡"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 158)
3	Shopware\Core\Content\Category\SalesChannel\NavigationRoute->getCategoryMetaInfo (line 83)
4	Shopware\Core\Content\Category\SalesChannel\NavigationRoute->load (line 47)
5	Shopware\Core\Content\Category\SalesChannel\TreeBuildingNavigationRoute->load (line 49)
6	Shopware\Core\Content\Category\Service\NavigationLoader->load (line 52)
7	Shopware\Core\Content\Category\Cms\CategoryNavigationCmsElementResolver->enrich (line 136)
8	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots (line 47)
9	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 67)
10	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve (line 47)
11	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 82)
12	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve (line 45)
13	Sas\BlogModule\Content\Cms\DataResolver\SasCmsSlotsDataResolver->resolve (line 78)
14	Cbax\ModulLexicon\Components\LexiconCMSHelper->loadSlotData (line 172)
15	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
18	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
24	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
25	Shopware\Core\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
27	require_once (line 11)

5.59 ms
(4.31%)

-- Lexicon getCmsPage::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` 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` 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` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?))))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x01Šd#cÌsy¿MÞ}v´fH"
  b"\x01Šd#cÍq–’\x12¹³x\e˜O"
  b"\x01Šd#cÍq–’\x12¹³y%Iê"
  b"\x01Šd#cÍq–’\x12¹³{\x0F´U"
]

View formatted query View runnable query Explain query View query backtrace

-- Lexicon getCmsPage::association::sections::association::blocks::association::slots::read
SELECT
  `cms_slot`.`id` as `cms_slot.id`,
  `cms_slot`.`version_id` as `cms_slot.versionId`,
  `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`,
  `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`.`created_at` as `cms_slot.createdAt`,
  `cms_slot`.`updated_at` as `cms_slot.updatedAt`,
  `cms_slot.translation.config`,
  `cms_slot.translation.config` as `cms_slot.config`,
  `cms_slot.translation.customFields`,
  `cms_slot.translation.customFields` as `cms_slot.customFields`
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`
    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`
WHERE
  (`cms_slot`.`version_id` = ?)
  AND (
    (
      (
        `cms_slot`.`cms_block_id` IN (?, ?, ?, ?)
      )
    )
  )

-- Lexicon getCmsPage::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `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`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` 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` 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` WHERE (`cms_slot`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`cms_slot`.`cms_block_id` IN (0x018A642363CC7379BF4DDE7D76B46648, 0x018A642363CD71969212B9B3781B984F, 0x018A642363CD71969212B9B3792549EA, 0x018A642363CD71969212B9B37B0FB455))));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
13	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
14	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
15	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
16	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
17	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
18	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
19	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
20	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
21	Shopware\Core\Profiling\Profiler::trace (line 68)
22	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 42)
23	Cbax\ModulLexicon\Components\LexiconCMSHelper->getCmsPage (line 153)
24	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
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 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
36	require_once (line 11)

4.16 ms
(3.21%)

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

Parameters:

[
  "/navigation/4912bdd9d4c042098b5e9e7478cd9dd6"
  "/navigation/c80366c5226f45ac82449e3a3f0b8554"
  "/navigation/018a986c0c4a723b83d5960ccff667f5"
  "/navigation/5823b6e8cb914633acc74170f3c77f02"
  "/navigation/dd140f7d0b994c06b023ee7cde2201a4"
  "/navigation/76b109f7f2d44034a0c0447f671a4503"
  "/navigation/3bddd8e8619e40cf91ff1518c797d4bf"
  "/navigation/dc41fb6b09814c76b08c03e40fe5eb0a"
  "/navigation/5c48d65e3c4e4e27b4df712e66aed602"
  "/navigation/1ac4c3cf38f44ae39135cd3e4567d36a"
  "/navigation/385ba29df28849b088bb29f6d9dce9c5"
  "/navigation/444fabf3549f413ba0fdf72cc4b885c9"
  "/navigation/4b854ba426344e1b9ff3da51fa8ecf23"
  "/navigation/7dd915fb41ee4ff2a21378afb1b6ce37"
  "/navigation/cb9ff02bc6e14c4c989c21af04a3786a"
  "/navigation/61fe82c5fb5b4e2cb5299f1e987d20d4"
  "/navigation/cf8b7678f7854fcdbb9d97123f07e8dd"
  "/navigation/d3e0eb6222134422b7281c6751c1fc6c"
  "/navigation/b82de77f91e74a0c98811854bc0b3a7c"
  "/navigation/ee45615539294876a9c21bdbd866c7f4"
  "/navigation/dd6902bc5e0245899ab4837358e372d3"
  "/navigation/019cae10fe3c7485baa1c77e9db41fde"
  "/navigation/0077b6e61bb34418affe5490289418ab"
  "/navigation/01931f4d0e4e762a9e2371e1d626d12c"
  "/navigation/019897dd94a27c8ea23dff42540848c8"
  "/navigation/04e5f5b673f847a089cbed532321dfc4"
  "/navigation/086b89f81e8c4a05a59b1068210db735"
  "/navigation/13fc36da34a1482f87f736af8cc0ef60"
  "/navigation/25171e8aa3114ccf8f010554b0386ee5"
  "/navigation/26e7ffd6ef8244ba90a8555f68683eb5"
  "/navigation/2c3253cb458b4dd9916196a5891b4dd9"
  "/navigation/32956a3d7fe040349e0589460051bb2a"
  "/navigation/338d19185ae342f3acdfec0f23ebb4fb"
  "/navigation/4af44b3637fe437087030cf990ce693d"
  "/navigation/ad3da067904c461baba07391c0f023e5"
  "/navigation/ca4dbd63d30c4ffcb1ea5d633f597978"
  "/navigation/cc931fdc54534d9aba33b7529a7d30a0"
  "/navigation/e541a725803d41708f7dc129d567739f"
  "/navigation/e56ce6de4c1b44e38c56a9c59d0ca812"
  "/navigation/f89c121dd216458a81922f507aa24edf"
  "/navigation/fd0eb548ccda4b46b25c0a17e1b2696f"
  "/navigation/62cfdd15304b46d9ae9c9ddac4a24536"
  "/navigation/018d1bebfedc7b65a267aa983ff97e69"
  "/navigation/3e15316a11a94370a995f2cd5d906449"
  "/navigation/6f1984108a3c4d939aa38fb4985f6844"
  "/navigation/61497408e8d2444ea1e756bcf10f19f1"
  "/navigation/018b5c1848fb7eb584c55d0d9e9fc96f"
  "/navigation/0196aae9606a7de49157ac37aeadc4b0"
  "/navigation/0196aae9b4ce7b5dbd1a833d5295318c"
  "/navigation/02e9b55b435045949d3849cfcdc5b316"
  "/navigation/122090eb5ba3469d8858204a6a2998c1"
  "/navigation/e374de9754e647d7973a7b36d0057814"
  "/navigation/5e1e94f100ea4a44b82b49cf0c9ee9cc"
  "/navigation/d97162e581be45f29254cbcf0d86b3a4"
  "/navigation/0191313c8ec57587b0a40b74c992c61f"
  "/navigation/dfbea89f5a7d4503a32b24d1457dfd3e"
  "/navigation/0198c7ccf1eb784986c8aac35e3b4de0"
  "/navigation/ef83486861004b3e98f011cb75a2c524"
  "/navigation/f03cb2fe004740b3904490014117d170"
  "/navigation/767aacbdc90f4830a0574960a2a84489"
  "/navigation/bb0722914ec8479fb167336e7275ba5e"
  "/navigation/75ee129fd62e4356a518e6b6b73aa89f"
  "/cbax/lexicon/listing/A"
  "/cbax/lexicon/listing/B"
  "/cbax/lexicon/listing/C"
  "/cbax/lexicon/listing/D"
  "/cbax/lexicon/listing/E"
  "/cbax/lexicon/listing/F"
  "/cbax/lexicon/listing/G"
  "/cbax/lexicon/listing/I"
  "/cbax/lexicon/listing/L"
  "/cbax/lexicon/listing/M"
  "/cbax/lexicon/listing/O"
  "/cbax/lexicon/listing/P"
  "/cbax/lexicon/listing/R"
  "/cbax/lexicon/listing/S"
  "/cbax/lexicon/listing/T"
  "/cbax/lexicon/listing/V"
  "/cbax/lexicon/listing/W"
  "/cbax/lexicon/index"
  "/cbax/lexicon/content"
  "/cbax/lexicon/detail/df3603dd34ad4e23b507846a19be6363"
  "/cbax/lexicon/detail/d7b6257378f74f73bc4cd954b9c596e5"
  "/cbax/lexicon/detail/9d18fb42b30a4e5286bc84ac40731715"
  "/cbax/lexicon/detail/0585f9f9189a40ebae69f58ab5c580d1"
  "/cbax/lexicon/detail/ea791bcfc40047c6a4f89075b57e02f4"
  "/cbax/lexicon/detail/59b79c5d3b674f9c9acc7a35ba3e24d8"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hêh€Ã_MPÂ"
]

View formatted query View runnable query Explain query View query backtrace

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

-- seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN ('/navigation/4912bdd9d4c042098b5e9e7478cd9dd6', '/navigation/c80366c5226f45ac82449e3a3f0b8554', '/navigation/018a986c0c4a723b83d5960ccff667f5', '/navigation/5823b6e8cb914633acc74170f3c77f02', '/navigation/dd140f7d0b994c06b023ee7cde2201a4', '/navigation/76b109f7f2d44034a0c0447f671a4503', '/navigation/3bddd8e8619e40cf91ff1518c797d4bf', '/navigation/dc41fb6b09814c76b08c03e40fe5eb0a', '/navigation/5c48d65e3c4e4e27b4df712e66aed602', '/navigation/1ac4c3cf38f44ae39135cd3e4567d36a', '/navigation/385ba29df28849b088bb29f6d9dce9c5', '/navigation/444fabf3549f413ba0fdf72cc4b885c9', '/navigation/4b854ba426344e1b9ff3da51fa8ecf23', '/navigation/7dd915fb41ee4ff2a21378afb1b6ce37', '/navigation/cb9ff02bc6e14c4c989c21af04a3786a', '/navigation/61fe82c5fb5b4e2cb5299f1e987d20d4', '/navigation/cf8b7678f7854fcdbb9d97123f07e8dd', '/navigation/d3e0eb6222134422b7281c6751c1fc6c', '/navigation/b82de77f91e74a0c98811854bc0b3a7c', '/navigation/ee45615539294876a9c21bdbd866c7f4', '/navigation/dd6902bc5e0245899ab4837358e372d3', '/navigation/019cae10fe3c7485baa1c77e9db41fde', '/navigation/0077b6e61bb34418affe5490289418ab', '/navigation/01931f4d0e4e762a9e2371e1d626d12c', '/navigation/019897dd94a27c8ea23dff42540848c8', '/navigation/04e5f5b673f847a089cbed532321dfc4', '/navigation/086b89f81e8c4a05a59b1068210db735', '/navigation/13fc36da34a1482f87f736af8cc0ef60', '/navigation/25171e8aa3114ccf8f010554b0386ee5', '/navigation/26e7ffd6ef8244ba90a8555f68683eb5', '/navigation/2c3253cb458b4dd9916196a5891b4dd9', '/navigation/32956a3d7fe040349e0589460051bb2a', '/navigation/338d19185ae342f3acdfec0f23ebb4fb', '/navigation/4af44b3637fe437087030cf990ce693d', '/navigation/ad3da067904c461baba07391c0f023e5', '/navigation/ca4dbd63d30c4ffcb1ea5d633f597978', '/navigation/cc931fdc54534d9aba33b7529a7d30a0', '/navigation/e541a725803d41708f7dc129d567739f', '/navigation/e56ce6de4c1b44e38c56a9c59d0ca812', '/navigation/f89c121dd216458a81922f507aa24edf', '/navigation/fd0eb548ccda4b46b25c0a17e1b2696f', '/navigation/62cfdd15304b46d9ae9c9ddac4a24536', '/navigation/018d1bebfedc7b65a267aa983ff97e69', '/navigation/3e15316a11a94370a995f2cd5d906449', '/navigation/6f1984108a3c4d939aa38fb4985f6844', '/navigation/61497408e8d2444ea1e756bcf10f19f1', '/navigation/018b5c1848fb7eb584c55d0d9e9fc96f', '/navigation/0196aae9606a7de49157ac37aeadc4b0', '/navigation/0196aae9b4ce7b5dbd1a833d5295318c', '/navigation/02e9b55b435045949d3849cfcdc5b316', '/navigation/122090eb5ba3469d8858204a6a2998c1', '/navigation/e374de9754e647d7973a7b36d0057814', '/navigation/5e1e94f100ea4a44b82b49cf0c9ee9cc', '/navigation/d97162e581be45f29254cbcf0d86b3a4', '/navigation/0191313c8ec57587b0a40b74c992c61f', '/navigation/dfbea89f5a7d4503a32b24d1457dfd3e', '/navigation/0198c7ccf1eb784986c8aac35e3b4de0', '/navigation/ef83486861004b3e98f011cb75a2c524', '/navigation/f03cb2fe004740b3904490014117d170', '/navigation/767aacbdc90f4830a0574960a2a84489', '/navigation/bb0722914ec8479fb167336e7275ba5e', '/navigation/75ee129fd62e4356a518e6b6b73aa89f', '/cbax/lexicon/listing/A', '/cbax/lexicon/listing/B', '/cbax/lexicon/listing/C', '/cbax/lexicon/listing/D', '/cbax/lexicon/listing/E', '/cbax/lexicon/listing/F', '/cbax/lexicon/listing/G', '/cbax/lexicon/listing/I', '/cbax/lexicon/listing/L', '/cbax/lexicon/listing/M', '/cbax/lexicon/listing/O', '/cbax/lexicon/listing/P', '/cbax/lexicon/listing/R', '/cbax/lexicon/listing/S', '/cbax/lexicon/listing/T', '/cbax/lexicon/listing/V', '/cbax/lexicon/listing/W', '/cbax/lexicon/index', '/cbax/lexicon/content', '/cbax/lexicon/detail/df3603dd34ad4e23b507846a19be6363', '/cbax/lexicon/detail/d7b6257378f74f73bc4cd954b9c596e5', '/cbax/lexicon/detail/9d18fb42b30a4e5286bc84ac40731715', '/cbax/lexicon/detail/0585f9f9189a40ebae69f58ab5c580d1', '/cbax/lexicon/detail/ea791bcfc40047c6a4f89075b57e02f4', '/cbax/lexicon/detail/59b79c5d3b674f9c9acc7a35ba3e24d8')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x6984F654592348EAAD6880C35F4D50C2 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

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

3.01 ms
(2.33%)

SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE ((`cbax_lexicon_entry`.`date` <= ?) AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ? AND (COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ? OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE ?)) GROUP BY `cbax_lexicon_entry`.`id` ORDER BY MIN(COALESCE(`cbax_lexicon_entry.translation.title`)) ASC

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "2026-04-02 22:32:49"
  b"i„öTY#Hêh€Ã_MPÂ"
  "P%"
  "&P%"
  "#P%"
  "+P%"
  "-P%"
  "@P%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cbax_lexicon_entry`.`id`
FROM
  `cbax_lexicon_entry`
  LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id`
  LEFT JOIN (
    SELECT
      `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`,
      `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`
    FROM
      `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation`
    WHERE
      `cbax_lexicon_entry.translation`.`language_id` = ?
  ) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id`
WHERE
  (
    (`cbax_lexicon_entry`.`date` <= ?)
    AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ?
    AND (
      COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
      OR COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
      OR COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
      OR COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
      OR COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
      OR COALESCE(
        `cbax_lexicon_entry.translation.title`
      ) LIKE ?
    )
  )
GROUP BY
  `cbax_lexicon_entry`.`id`
ORDER BY
  MIN(
    COALESCE(
      `cbax_lexicon_entry.translation.title`
    )
  ) ASC

SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE ((`cbax_lexicon_entry`.`date` <= '2026-04-02 22:32:49') AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = 0x6984F654592348EAAD6880C35F4D50C2 AND (COALESCE(`cbax_lexicon_entry.translation.title`) LIKE 'P%' OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE '&P%' OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE '#P%' OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE '+P%' OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE '-P%' OR COALESCE(`cbax_lexicon_entry.translation.title`) LIKE '@P%')) GROUP BY `cbax_lexicon_entry`.`id` ORDER BY MIN(COALESCE(`cbax_lexicon_entry.translation.title`)) ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 53)
5	Swpa\SwpaSort\Service\Decorating\Core\Framework\DataAbstractionLayer\Search\DecoratorEntitySearcher->search (line 309)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 90)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 248)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 108)
10	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconLetterEntriesCmsElementResolver->getLetterLexiconEntries (line 62)
11	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconLetterEntriesCmsElementResolver->enrich (line 136)
12	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots (line 47)
13	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 67)
14	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve (line 47)
15	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 82)
16	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve (line 45)
17	Sas\BlogModule\Content\Cms\DataResolver\SasCmsSlotsDataResolver->resolve (line 78)
18	Cbax\ModulLexicon\Components\LexiconCMSHelper->loadSlotData (line 172)
19	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 11)

2.99 ms
(2.31%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

2.58 ms
(1.99%)

-- Lexicon getCmsPage::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND (((`cms_section`.`cms_page_id` IN (?))))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"\x01Šd#cÌsy¿MÞ}v?HK"
]

View formatted query View runnable query Explain query View query backtrace

-- Lexicon getCmsPage::association::sections::read
SELECT
  `cms_section`.`id` as `cms_section.id`,
  `cms_section`.`version_id` as `cms_section.versionId`,
  `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`,
  `cms_section`.`position` as `cms_section.position`,
  `cms_section`.`type` as `cms_section.type`,
  `cms_section`.`locked` as `cms_section.locked`,
  `cms_section`.`name` as `cms_section.name`,
  `cms_section`.`sizing_mode` as `cms_section.sizingMode`,
  `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`,
  `cms_section`.`background_color` as `cms_section.backgroundColor`,
  `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`,
  `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`,
  `cms_section`.`css_class` as `cms_section.cssClass`,
  `cms_section`.`cms_page_id` as `cms_section.pageId`,
  `cms_section`.`visibility` as `cms_section.visibility`,
  `cms_section`.`custom_fields` as `cms_section.customFields`,
  `cms_section`.`created_at` as `cms_section.createdAt`,
  `cms_section`.`updated_at` as `cms_section.updatedAt`,
  `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`,
  `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`,
  `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`,
  `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`,
  `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`,
  `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`,
  `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`,
  `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`,
  `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`,
  `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`,
  `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`,
  `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`,
  `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`,
  `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`,
  `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`,
  `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`,
  `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`,
  `cms_section.backgroundMedia.translation.title`,
  `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`,
  `cms_section.backgroundMedia.translation.alt`,
  `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`,
  `cms_section.backgroundMedia.translation.customFields`,
  `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields`
FROM
  `cms_section`
  LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id`
  LEFT JOIN (
    SELECT
      `cms_section.backgroundMedia.translation`.`media_id`,
      `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`,
      `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`,
      `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields`
    FROM
      `media_translation` `cms_section.backgroundMedia.translation`
    WHERE
      `cms_section.backgroundMedia.translation`.`language_id` = ?
  ) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id`
WHERE
  (`cms_section`.`version_id` = ?)
  AND (
    (
      (
        `cms_section`.`cms_page_id` IN (?)
      )
    )
  )

-- Lexicon getCmsPage::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (((`cms_section`.`cms_page_id` IN (0x018A642363CC7379BF4DDE7D763F484B))));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 603)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToManyWithoutPagination (line 524)
6	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->loadOneToMany (line 1418)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetchAssociations (line 151)
8	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
11	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
12	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->{closure:Shopware\Core\Framework\DataAbstractionLayer\EntityRepository::search():68} (line 67)
13	Shopware\Core\Profiling\Profiler::trace (line 68)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 42)
15	Cbax\ModulLexicon\Components\LexiconCMSHelper->getCmsPage (line 153)
16	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 11)

2.31 ms
(1.78%)

SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` WHERE ((`cbax_lexicon_entry`.`date` <= ?) AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ?) GROUP BY `cbax_lexicon_entry`.`id`

Parameters:

[
  "2026-04-02 22:32:49"
  b"i„öTY#Hêh€Ã_MPÂ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cbax_lexicon_entry`.`id`
FROM
  `cbax_lexicon_entry`
  LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id`
WHERE
  (
    (`cbax_lexicon_entry`.`date` <= ?)
    AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = ?
  )
GROUP BY
  `cbax_lexicon_entry`.`id`

SELECT `cbax_lexicon_entry`.`id` FROM `cbax_lexicon_entry` LEFT JOIN `cbax_lexicon_sales_channel` `cbax_lexicon_entry.saleschannels` ON `cbax_lexicon_entry`.`id` = `cbax_lexicon_entry.saleschannels`.`cbax_lexicon_entry_id` WHERE ((`cbax_lexicon_entry`.`date` <= '2026-04-02 22:32:49') AND `cbax_lexicon_entry.saleschannels`.`sales_channel_id` = 0x6984F654592348EAAD6880C35F4D50C2) GROUP BY `cbax_lexicon_entry`.`id`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 52)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 53)
5	Swpa\SwpaSort\Service\Decorating\Core\Framework\DataAbstractionLayer\Search\DecoratorEntitySearcher->search (line 309)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 90)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 248)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
9	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 68)
10	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconNavigationCmsElementResolver->getNavigationData (line 56)
11	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconNavigationCmsElementResolver->enrich (line 136)
12	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots (line 47)
13	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 67)
14	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve (line 47)
15	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 82)
16	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve (line 45)
17	Sas\BlogModule\Content\Cms\DataResolver\SasCmsSlotsDataResolver->resolve (line 78)
18	Cbax\ModulLexicon\Components\LexiconCMSHelper->loadSlotData (line 172)
19	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 11)

2.21 ms
(1.71%)

SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‹³Êž\x06qµšdže\x1A"¸"
  b"\x01Ž~»òEpÀ¬ß\x0E@*hý"
  b"\x01Ž\x0E•_Âpòˆš0!\fá\x15\r"
  b"\x01Ž\\x1C\x15]pÊ»¦°iÅÒ]Ù"
  b"\x01\x0E×¯ÏtÆ§ºTàfé_Ý"
  b"±JÈe{tO{»{ç¿²CD""
  b"\x01\x11¡[CpX—Ž&\x18\x1AEŽ"
  b"\x01’\x05\x04\x12ŠrÂŸ\x05Ä'ð†:£"
  b"\x01“º[½q¯‚»\x0FZÅ:0\x7F"
  b"\x01”Ö{DQp\f†3\x1FÑ½%ê~"
  b"\x01•7\x7F(êsLöÚpDÒš"
  b"\x01–{ \x0EvÑ«‡pŽ(#òx"
  b"\x01–©·³!pˆ¹\x13\x1F3Œí""
  b"\x01–ÎI,wp]½…ÕÛÐö¨A"
  b"5|\tÒñjN\x02«â·Œ‚ã\x0F—"
  b"\x01˜ƒÇ° s;‡ œÅo\x0Ew"
  b"1…¹{~\x1DFOž§\fù¶tÿï"
  b"¢¡k±ø\x07Jõ¨‰ú¡ƒÏ–´"
  b"\x18=LÎ\e\rKºª\x7Fu¾é\x05 "
  b"lƒ+&¿\x02C+±^\x15‚F\x03D8"
  b"—Qµ[èhF\x05®°ÿdJì"
  b"""
    \x01™”kKíp\n
    ¸Xñ…þŽÝ\x01
    """
  b"¡\x19nWûÛLí¥¨‰\x19Ú\x0E–%"
  b"\x01ŽcJ\x14\x15sŠ£a˜Ã_s "
  b"8Ï=C™˜M\x1E¹‰\x7FÁX}\f‚"
  b"êy\eÏÄ\x00GÆ¤øuµ~\x02ô"
  b"ß¶\x05ÀãŒBˆ®D\x15sP|Ã["
  b"*†ÐÑLdDm»ÛbU\x06YŽÔ"
  b"¦O\x03™cuKB†\x7FÔª¢Ùºr"
  b"j“Ž#V\eM\x18…imVv"\x1C\x06"
  b"×¶%sx÷Os¼LÙT¹Å–å"
  b"""
    [ j²'\vLè‘}°Mø\n
    Û<
    """
  b"ËuÔ™‰÷AlŽYFÌVSk"
  b"""
    Ôß\n
    ‡›"HC°ÑG&\f@T&
    """
  b"æéO70+I\x06§´\x1AÚT\x16“"
  b"9OÓF™@v¾\x07²\x128¯õ·"
  b"ÿ#D\x14Ê}FÍ·¬p‹‹¦¢\x1D"
  b"F»}û€ÜNW»ø´¹îoâ+"
  b"""
    \x18ûB³\n
    NR†¼„¬@s\x17\x15
    """
  b"\tíDZ\x01VFõœ@4b\x04€Žj"
  b"´1à\x02COAŽŸ:»Ž-V6¬"
  b"è\x1D8Kð\fH\x12#£¼KVU¬"
  b"·\v[Ü\rñE\x04Sî4Â]gM"
  b"@ ¼tØ\rAÒƒÔ'èä?C"
  b"ªz|î,ñF™<\x012¦`Ñ¦"
  b"†áÚ…-ŒEÀ ŽçÕ]Û;V"
  b"$>\H–ÃCÜ·Üí\x11¶4¿·"
  b"ï\x11\x1F=|FE#€”ÒZ=C9ú"
  b"é\vë¼ú"C¿Ž¨ÃÔ»Ê\x0Fì"
  b"\x16Ëñ\x10ü8Aµ´\x1AS\x12(Ñè»"
  b"-üÇ\x0F>BJ\x1F‹>F©"Ûåê"
  b"\x02Â×r3OD)Ž\x1FÛù1ß¯·"
  b"ß6\x03Ý4N#µ\x07„j\x19¾cc"
  b"\x05…ùù\x18š@ë®iõŠµÅ€Ñ"
  b"OÒ=Ží†G0’ý¾-þ-t·"
  b"šDƒ‚§N+¬›‰\x00Øk—4"
  b"tãÏ*ï\vD†\x00Ú®"Á²K"
  b"íÑÉP\x0FÖA\x16¢õPTe·\x1A\x17"
  b"\x7F`_MIòN\x13º›§-\x05õ—"
  b"Y·œ];gOœšÌz5º>$Ø"
  b"ÔE…=\x1CwK‚ƒ;þ\x10¬¤ðS"
  b"KŠZ²“\x10A±…œ\x1D3ñO\x19‹"
  b"Õ»W×qíI¾Bêô\x18L–\r"
  b"¨\x1C\x7Fn~ÇM{²\x03íW™9)"
  b"¨…\x14\x08v’LŒ€²1¹Lë›"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`,
  `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`,
  `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`,
  `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`,
  `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`,
  `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`,
  `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`,
  `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`,
  `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`,
  `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`,
  `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`,
  `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`,
  `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`,
  `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`,
  `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`,
  `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`,
  `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`,
  `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`,
  `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`,
  `cbax_lexicon_entry.translation.title`,
  `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`,
  `cbax_lexicon_entry.translation.keyword`,
  `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`,
  `cbax_lexicon_entry.translation.description`,
  `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`,
  `cbax_lexicon_entry.translation.descriptionLong`,
  `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`,
  `cbax_lexicon_entry.translation.linkDescription`,
  `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`,
  `cbax_lexicon_entry.translation.altCmsPageLexicon`,
  `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`,
  `cbax_lexicon_entry.translation.metaTitle`,
  `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`,
  `cbax_lexicon_entry.translation.metaKeywords`,
  `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`,
  `cbax_lexicon_entry.translation.metaDescription`,
  `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`,
  `cbax_lexicon_entry.translation.headline`,
  `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`,
  `cbax_lexicon_entry.translation.attribute1`,
  `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`,
  `cbax_lexicon_entry.translation.attribute4`,
  `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`,
  `cbax_lexicon_entry.translation.attribute5`,
  `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`,
  `cbax_lexicon_entry.translation.attribute6`,
  `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6`
FROM
  `cbax_lexicon_entry`
  LEFT JOIN (
    SELECT
      `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`,
      `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`,
      `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`,
      `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`,
      `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`,
      `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`,
      `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`,
      `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`,
      `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`,
      `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`,
      `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`,
      `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`,
      `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`,
      `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`,
      `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6`
    FROM
      `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation`
    WHERE
      `cbax_lexicon_entry.translation`.`language_id` = ?
  ) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id`
WHERE
  `cbax_lexicon_entry`.`id` IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (0x018BB3CA9E0671B58F9A649E651A22B8, 0x018D7EBBF24570C0ACDF900E402A68FD, 0x018E0E955FC270F2889A30210CE1150D, 0x018E5C1C155D70CABBA6B069C5D25DD9, 0x018F0ED7AFCF74C6A7BA54E066E95FDD, 0xB14AC8657B744F7BBB7BE7BFB2434422, 0x019011A15B437058978E26181A458EAD, 0x01920504128A72C29F05C427F0863AA3, 0x0193BA5BBD9071AF82BB0F5AC53A307F, 0x0194D67B4451700C86331FD1BD25EA7E, 0x0195377F28EA734C81F6DA8F7044D29A, 0x0196817BA00E76D1AB87708E2823F278, 0x0196A9B7B3217088B9131F338F8CED22, 0x0196CE492C77705DBD85D5DBD0F6A841, 0x357C09D2F16A4E02ABE2B78C82E30F97, 0x019883C7B0A0733B87209CC5816F0E77, 0x3185B97B7E1D464F9EA70CF9B674FFEF, 0xA2A16BB1F8074AF5A889FAA183CF96B4, 0x183D4CCE1B0D4BBAAA7F7590BEE90520, 0x6C832B26BF02432BB15E158246034438, 0x9751B55BE86846058FAEB0FF644A90EC, 0x0199946B4BED700AB858F185FE8DDD01, 0xA1196E57FBDB4CEDA5A88919DA0E9625, 0x018E634A1415738AA36198C35F73A0AD, 0x38CF3D4399984D1EB9897FC1587D0C82, 0xEA791BCFC40047C6A4F89075B57E02F4, 0xDFB605C0E38C4288AE441573507CC35B, 0x2A86D0D14C64446DBBDB625506598ED4, 0xA64F039963754B42867FD4AAA2D9BA72, 0x6A938D23561B4D1885696D5676221C06, 0xD7B6257378F74F73BC4CD954B9C596E5, 0x5B206AB2270B4CE8917DB04DF80ADB3C, 0xCB75D49989F7416C8D5946CC8F56536B, 0xD4DF0A879B224843B0D147260C405426, 0xE6E94F37302B4906A7B41ADA81541693, 0x8F394FD346994076BE07B21238AFF5B7, 0xFF234414CA7D46CDB7AC708B8BA6A21D, 0x46BB7DFB80DC4E57BBF8B4B9EE6FE22B, 0x9D18FB42B30A4E5286BC84AC40731715, 0x09ED445A015646F59C40346204808D6A, 0xB431E002434F418E9F3ABB8E2D5636AC, 0xE81D384BF00C4812AD23A3BC4B5655AC, 0xB70B5BDC0DF14504AD53EE34C25D674D, 0x40A0BC74D80D41D283D427E8E43F439D, 0xAA7A7CEE2CF1468F993C0132A660D1A6, 0x86E1DA852D8C45C0A08DE7D55DDB3B56, 0x243E5C4896C343DCB7DCED11B634BFB7, 0xEF111F3D7C4645238094D25A3D4339FA, 0xE90BEBBCFA2243BF8EA8C3D4BBCA0FEC, 0x16CBF110FC3841B5B41A531228D1E8BB, 0x2DFCC70F3E424A1F8B3E46A922DBE5EA, 0x02C2D772334F44298E1FDBF931DFAFB7, 0xDF3603DD34AD4E23B507846A19BE6363, 0x0585F9F9189A40EBAE69F58AB5C580D1, 0x4FD23D8EED86473092FDBE2DFE2D74B7, 0x9A44838290A74E2BAC9B8900D86B9734, 0x74E3CF2AEF0B44AD8600DAAE22C1B24B, 0xEDD1C9500FD64116A2F5505465B71A17, 0x7F605F4D49F24E13BA9BA79D2D05F597, 0x59B79C5D3B674F9C9ACC7A35BA3E24D8, 0xD445853D1C774B82833BFE10ACA4F053, 0x4B8A5AB2931041B1859C1D33F14F198B, 0xD5BB57D771ED4990BE42EAF4184C960D, 0xA81C7F6E7EC74D7BB2AD03ED57993929, 0xA885140876924C908C80B231B94CEB9B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 259)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 68)
9	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconNavigationCmsElementResolver->getNavigationData (line 56)
10	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconNavigationCmsElementResolver->enrich (line 136)
11	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots (line 47)
12	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 67)
13	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve (line 47)
14	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 82)
15	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve (line 45)
16	Sas\BlogModule\Content\Cms\DataResolver\SasCmsSlotsDataResolver->resolve (line 78)
17	Cbax\ModulLexicon\Components\LexiconCMSHelper->loadSlotData (line 172)
18	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
30	require_once (line 11)

2.13 ms
(1.64%)

SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = ?) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (?, ?, ?, ?, ?, ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"ß6\x03Ý4N#µ\x07„j\x19¾cc"
  b"×¶%sx÷Os¼LÙT¹Å–å"
  b"""
    \x18ûB³\n
    NR†¼„¬@s\x17\x15
    """
  b"\x05…ùù\x18š@ë®iõŠµÅ€Ñ"
  b"êy\eÏÄ\x00GÆ¤øuµ~\x02ô"
  b"Y·œ];gOœšÌz5º>$Ø"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`,
  `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`,
  `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`,
  `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`,
  `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`,
  `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`,
  `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`,
  `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`,
  `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`,
  `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`,
  `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`,
  `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`,
  `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`,
  `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`,
  `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`,
  `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`,
  `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`,
  `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`,
  `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`,
  `cbax_lexicon_entry.translation.title`,
  `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`,
  `cbax_lexicon_entry.translation.keyword`,
  `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`,
  `cbax_lexicon_entry.translation.description`,
  `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`,
  `cbax_lexicon_entry.translation.descriptionLong`,
  `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`,
  `cbax_lexicon_entry.translation.linkDescription`,
  `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`,
  `cbax_lexicon_entry.translation.altCmsPageLexicon`,
  `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`,
  `cbax_lexicon_entry.translation.metaTitle`,
  `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`,
  `cbax_lexicon_entry.translation.metaKeywords`,
  `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`,
  `cbax_lexicon_entry.translation.metaDescription`,
  `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`,
  `cbax_lexicon_entry.translation.headline`,
  `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`,
  `cbax_lexicon_entry.translation.attribute1`,
  `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`,
  `cbax_lexicon_entry.translation.attribute4`,
  `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`,
  `cbax_lexicon_entry.translation.attribute5`,
  `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`,
  `cbax_lexicon_entry.translation.attribute6`,
  `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6`
FROM
  `cbax_lexicon_entry`
  LEFT JOIN (
    SELECT
      `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`,
      `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`,
      `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`,
      `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`,
      `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`,
      `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`,
      `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`,
      `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`,
      `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`,
      `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`,
      `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`,
      `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`,
      `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`,
      `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`,
      `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6`
    FROM
      `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation`
    WHERE
      `cbax_lexicon_entry.translation`.`language_id` = ?
  ) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id`
WHERE
  `cbax_lexicon_entry`.`id` IN (?, ?, ?, ?, ?, ?)

SELECT `cbax_lexicon_entry`.`id` as `cbax_lexicon_entry.id`, `cbax_lexicon_entry`.`import_id` as `cbax_lexicon_entry.importId`, `cbax_lexicon_entry`.`impressions` as `cbax_lexicon_entry.impressions`, `cbax_lexicon_entry`.`date` as `cbax_lexicon_entry.date`, `cbax_lexicon_entry`.`link` as `cbax_lexicon_entry.link`, `cbax_lexicon_entry`.`link_target` as `cbax_lexicon_entry.linkTarget`, `cbax_lexicon_entry`.`listing_type` as `cbax_lexicon_entry.listingType`, `cbax_lexicon_entry`.`product_stream_id` as `cbax_lexicon_entry.productStreamId`, `cbax_lexicon_entry`.`product_layout` as `cbax_lexicon_entry.productLayout`, `cbax_lexicon_entry`.`product_template` as `cbax_lexicon_entry.productTemplate`, `cbax_lexicon_entry`.`product_slider_width` as `cbax_lexicon_entry.productSliderWidth`, `cbax_lexicon_entry`.`product_sorting` as `cbax_lexicon_entry.productSorting`, `cbax_lexicon_entry`.`product_limit` as `cbax_lexicon_entry.productLimit`, `cbax_lexicon_entry`.`attribute2` as `cbax_lexicon_entry.attribute2`, `cbax_lexicon_entry`.`attribute3` as `cbax_lexicon_entry.attribute3`, `cbax_lexicon_entry`.`media2_id` as `cbax_lexicon_entry.media2Id`, `cbax_lexicon_entry`.`media3_id` as `cbax_lexicon_entry.media3Id`, `cbax_lexicon_entry`.`created_at` as `cbax_lexicon_entry.createdAt`, `cbax_lexicon_entry`.`updated_at` as `cbax_lexicon_entry.updatedAt`, `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation.title` as `cbax_lexicon_entry.title`, `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation.keyword` as `cbax_lexicon_entry.keyword`, `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation.description` as `cbax_lexicon_entry.description`, `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation.descriptionLong` as `cbax_lexicon_entry.descriptionLong`, `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation.linkDescription` as `cbax_lexicon_entry.linkDescription`, `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation.altCmsPageLexicon` as `cbax_lexicon_entry.altCmsPageLexicon`, `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation.metaTitle` as `cbax_lexicon_entry.metaTitle`, `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation.metaKeywords` as `cbax_lexicon_entry.metaKeywords`, `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation.metaDescription` as `cbax_lexicon_entry.metaDescription`, `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation.headline` as `cbax_lexicon_entry.headline`, `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation.attribute1` as `cbax_lexicon_entry.attribute1`, `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation.attribute4` as `cbax_lexicon_entry.attribute4`, `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation.attribute5` as `cbax_lexicon_entry.attribute5`, `cbax_lexicon_entry.translation.attribute6`, `cbax_lexicon_entry.translation.attribute6` as `cbax_lexicon_entry.attribute6` FROM `cbax_lexicon_entry` LEFT JOIN (SELECT `cbax_lexicon_entry.translation`.`cbax_lexicon_entry_id`, `cbax_lexicon_entry.translation`.`title` as `cbax_lexicon_entry.translation.title`, `cbax_lexicon_entry.translation`.`keyword` as `cbax_lexicon_entry.translation.keyword`, `cbax_lexicon_entry.translation`.`description` as `cbax_lexicon_entry.translation.description`, `cbax_lexicon_entry.translation`.`description_long` as `cbax_lexicon_entry.translation.descriptionLong`, `cbax_lexicon_entry.translation`.`link_description` as `cbax_lexicon_entry.translation.linkDescription`, `cbax_lexicon_entry.translation`.`alt_cms_page_lexicon` as `cbax_lexicon_entry.translation.altCmsPageLexicon`, `cbax_lexicon_entry.translation`.`meta_title` as `cbax_lexicon_entry.translation.metaTitle`, `cbax_lexicon_entry.translation`.`meta_keywords` as `cbax_lexicon_entry.translation.metaKeywords`, `cbax_lexicon_entry.translation`.`meta_description` as `cbax_lexicon_entry.translation.metaDescription`, `cbax_lexicon_entry.translation`.`headline` as `cbax_lexicon_entry.translation.headline`, `cbax_lexicon_entry.translation`.`attribute1` as `cbax_lexicon_entry.translation.attribute1`, `cbax_lexicon_entry.translation`.`attribute4` as `cbax_lexicon_entry.translation.attribute4`, `cbax_lexicon_entry.translation`.`attribute5` as `cbax_lexicon_entry.translation.attribute5`, `cbax_lexicon_entry.translation`.`attribute6` as `cbax_lexicon_entry.translation.attribute6` FROM `cbax_lexicon_entry_translation` `cbax_lexicon_entry.translation` WHERE `cbax_lexicon_entry.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `cbax_lexicon_entry.cbax_lexicon_entry_translation` ON `cbax_lexicon_entry.cbax_lexicon_entry_translation`.`cbax_lexicon_entry_id` = `cbax_lexicon_entry`.`id` WHERE `cbax_lexicon_entry`.`id` IN (0xDF3603DD34AD4E23B507846A19BE6363, 0xD7B6257378F74F73BC4CD954B9C596E5, 0x9D18FB42B30A4E5286BC84AC40731715, 0x0585F9F9189A40EBAE69F58AB5C580D1, 0xEA791BCFC40047C6A4F89075B57E02F4, 0x59B79C5D3B674F9C9ACC7A35BA3E24D8);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 259)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 108)
9	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconLetterEntriesCmsElementResolver->getLetterLexiconEntries (line 62)
10	Cbax\ModulLexicon\Core\Content\ShoppingWorlds\Cms\CbaxLexiconLetterEntriesCmsElementResolver->enrich (line 136)
11	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots (line 47)
12	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 67)
13	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve (line 47)
14	Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish (line 82)
15	Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve (line 45)
16	Sas\BlogModule\Content\Cms\DataResolver\SasCmsSlotsDataResolver->resolve (line 78)
17	Cbax\ModulLexicon\Components\LexiconCMSHelper->loadSlotData (line 172)
18	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
21	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
30	require_once (line 11)

1.95 ms
(1.51%)

SELECT HEX(id) as id, name FROM language

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  HEX(id) as id,
  name
FROM
  language

SELECT HEX(id) as id, name FROM language;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 151)
2	Kzph\Changelog\Subscriber\EntityWrittenSubscriber->getAllLanguages (line 39)
3	Kzph\Changelog\Subscriber\EntityWrittenSubscriber->__construct (line 34682)
4	ContainerRNH625p\Shopware_Core_KernelDevDebugContainer::getEntityWrittenSubscriberService (line 19773)
5	ContainerRNH625p\Shopware_Core_KernelDevDebugContainer::{closure:ContainerRNH625p\Shopware_Core_KernelDevDebugContainer::getEventDispatcherService():19773} (line 221)
6	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 78)
7	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 99)
8	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->getListeners (line 69)
9	Shopware\Core\Framework\Webhook\WebhookDispatcher->getListeners (line 64)
10	Shopware\Core\Framework\Event\NestedEventDispatcher->getListeners (line 82)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->getListeners (line 347)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->getListenersWithoutPriority (line 164)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->getNotCalledListeners (line 74)
14	Symfony\Component\HttpKernel\DataCollector\EventDataCollector->lateCollect (line 93)
15	Symfony\Component\HttpKernel\Profiler\Profiler->saveProfile (line 129)
16	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelTerminate (line 115)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
20	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
21	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
22	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 114)
24	Symfony\Component\HttpKernel\HttpKernel->terminate (line 255)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->terminate (line 147)
26	Symfony\Component\HttpKernel\Kernel->terminate (line 53)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 11)

1.65 ms
(1.27%)

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"i„öTY#Hêh€Ã_MPÂ"
  b"æwŒ™’SLŸ˜K£«%¿æ7"
]

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

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

1.46 ms
(1.13%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 110)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->minSearchLength (line 75)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 23)
5	DreiscSeoPro\Decorator\Storefront\Framework\Twig\TemplateDataExtensionDecorator->getGlobals (line 365)
6	Twig\ExtensionSet->getGlobals (line 908)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 24)
13	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 288)
14	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
15	Shopware\Storefront\Controller\StorefrontController->render (line 87)
16	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
17	Shopware\Core\Profiling\Profiler::trace (line 87)
18	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
19	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 11)

0.84 ms
(0.65%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hêh€Ã_MPÂ"
  "lexikon/p"
  "lexikon/p/"
]

View formatted query View runnable query Explain query View query backtrace

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

-- seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND ((sales_channel_id = 0x6984F654592348EAAD6880C35F4D50C2 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'lexikon/p' OR seo_path_info = 'lexikon/p/'));

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

0.73 ms
(0.56%)

SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` = ? AND `seo_url`.`route_name` = ? AND `seo_url`.`path_info` = ? AND `seo_url`.`is_deleted` = ? AND `seo_url`.`is_canonical` = ?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"i„öTY#Hêh€Ã_MPÂ"
  "frontend.cbax.lexicon.listing"
  "/cbax/lexicon/listing/P"
  0
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `seo_url`.`id` as `seo_url.id`,
  `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`,
  `seo_url`.`language_id` as `seo_url.languageId`,
  `seo_url`.`foreign_key` as `seo_url.foreignKey`,
  `seo_url`.`route_name` as `seo_url.routeName`,
  `seo_url`.`path_info` as `seo_url.pathInfo`,
  `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`,
  `seo_url`.`is_canonical` as `seo_url.isCanonical`,
  `seo_url`.`is_modified` as `seo_url.isModified`,
  `seo_url`.`is_deleted` as `seo_url.isDeleted`,
  `seo_url`.`custom_fields` as `seo_url.customFields`,
  `seo_url`.`created_at` as `seo_url.createdAt`,
  `seo_url`.`updated_at` as `seo_url.updatedAt`
FROM
  `seo_url`
WHERE
  (
    `seo_url`.`language_id` = ?
    AND `seo_url`.`sales_channel_id` = ?
    AND `seo_url`.`route_name` = ?
    AND `seo_url`.`path_info` = ?
    AND `seo_url`.`is_deleted` = ?
    AND `seo_url`.`is_canonical` = ?
  )

SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B AND `seo_url`.`sales_channel_id` = 0x6984F654592348EAAD6880C35F4D50C2 AND `seo_url`.`route_name` = 'frontend.cbax.lexicon.listing' AND `seo_url`.`path_info` = '/cbax/lexicon/listing/P' AND `seo_url`.`is_deleted` = 0 AND `seo_url`.`is_canonical` = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 381)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 139)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 78)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 215)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 243)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 111)
9	Cbax\ModulLexicon\Components\LexiconSeo->getSeoUrl (line 179)
10	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
13	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
14	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
18	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
19	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
20	Shopware\Core\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
22	require_once (line 11)

0.68 ms
(0.53%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 103)
3	Shopware\Storefront\Theme\ThemeRuntimeConfigStorage->getActiveThemeNames (line 186)
4	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getActiveThemeNames (line 152)
5	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->isTheme (line 48)
6	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->build (line 86)
7	Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder->buildNamespaceHierarchy (line 27)
8	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 143)
9	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
10	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 285)
11	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
12	Shopware\Storefront\Controller\StorefrontController->render (line 87)
13	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 87)
15	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
16	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 11)

0.57 ms
(0.44%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.44 ms
(0.34%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 34)
3	Shopware\Core\System\CustomEntity\CustomEntityRegistrar->register (line 69)
4	Shopware\Core\System\System->boot (line 127)
5	Symfony\Component\HttpKernel\Kernel->boot (line 149)
6	Shopware\Core\Kernel->boot (line 127)
7	Shopware\Core\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
9	require_once (line 11)

0.43 ms
(0.33%)

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

Parameters:

[
  "de-DE"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 260)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 307)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalogue (line 137)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 154)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 44)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 180)
8	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
11	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
20	require_once (line 11)

0.40 ms
(0.31%)

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

Parameters:

[
  b"i„öTY#Hêh€Ã_MPÂ"
  "Sendinblue.%"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 323)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 167)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 114)
4	NewsletterSendinblue\Service\ConfigService->setSalesChannelId (line 48)
5	NewsletterSendinblue\Subscriber\MarketingAutomationSubscriber->onStorefrontRenderEvent (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 79)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
14	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
26	require_once (line 11)

0.39 ms
(0.30%)

SELECT path FROM category WHERE id = ?

Parameters:

[
  b"\x0FÅ˜D¦{BÉ¼fËo\v;N‡"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x0FC59844A67B42C9BC66CB6F0B3B4E87;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 332)
2	Doctrine\DBAL\Connection->fetchOne (line 140)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getNavigationPath (line 65)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 23)
5	DreiscSeoPro\Decorator\Storefront\Framework\Twig\TemplateDataExtensionDecorator->getGlobals (line 365)
6	Twig\ExtensionSet->getGlobals (line 908)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 24)
13	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 288)
14	Shopware\Storefront\Controller\StorefrontController->renderView (line 299)
15	Shopware\Storefront\Controller\StorefrontController->render (line 87)
16	Shopware\Storefront\Controller\StorefrontController->{closure:Shopware\Storefront\Controller\StorefrontController::renderStorefront():87} (line 67)
17	Shopware\Core\Profiling\Profiler::trace (line 87)
18	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
19	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
22	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
31	require_once (line 11)

0.28 ms
(0.21%)

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

Parameters:

[
  "NetzhautMPlusM"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 300)
2	Doctrine\DBAL\Connection->fetchAssociative (line 26)
3	Shopware\Storefront\Theme\ThemeRuntimeConfigStorage->getByName (line 62)
4	Shopware\Storefront\Theme\ThemeRuntimeConfigService->getRuntimeConfigByName (line 87)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addIconSetConfig (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 79)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
14	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
26	require_once (line 11)

0.24 ms
(0.19%)

SELECT url FROM sales_channel_domain

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  url
FROM
  sales_channel_domain

SELECT url FROM sales_channel_domain;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 670)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 46)
3	Shopware\Core\Framework\App\ShopId\Fingerprint\SalesChannelDomainUrls->fetchSalesChannelDomainUrls (line 37)
4	Shopware\Core\Framework\App\ShopId\Fingerprint\SalesChannelDomainUrls->getStamp (line 60)
5	Shopware\Core\Framework\App\ShopId\FingerprintGenerator->matchFingerprints (line 47)
6	Shopware\Core\Framework\App\ShopId\ShopIdProvider->getShopId (line 64)
7	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addShopIdParameter (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 79)
15	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
16	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
20	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 11)

0.16 ms
(0.13%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 57)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 40)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 59)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addShopIdParameter (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 43)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 28)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 79)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 225)
14	Cbax\ModulLexicon\Controller\FrontendController->listing (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
17	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
18	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
19	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
20	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
21	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 61)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 129)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
26	require_once (line 11)

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://devel.mplusm.de/cbax/lexicon/listing/P

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache