Symfony Profiler

Query Metrics

67 Database Queries

34 Different statements

135.69 ms Query time

Grouped Statements

Show all queries

Time▼

Count

Info

78.98 ms
(58.21%)

SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?) AND `scop_platform_redirecter_redirect`.`enabled` = ? AND (`scop_platform_redirecter_redirect`.`salesChannelId` = ? OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?)) LIMIT 1

Parameters:

[
  "//navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "/navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "https://dev.cas-technik.de/navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "https://dev.cas-technik.de//navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "/navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "//navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  true
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `scop_platform_redirecter_redirect`.`id`
FROM
  `scop_platform_redirecter_redirect`
WHERE
  (
    `scop_platform_redirecter_redirect`.`sourceURL` IN (?, ?, ?, ?, ?, ?, ?)
    AND `scop_platform_redirecter_redirect`.`enabled` = ?
    AND (
      `scop_platform_redirecter_redirect`.`salesChannelId` = ?
      OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> ?
    )
  )
LIMIT
  1

SELECT `scop_platform_redirecter_redirect`.`id` FROM `scop_platform_redirecter_redirect` WHERE (`scop_platform_redirecter_redirect`.`sourceURL` IN ('//navigation/4e3d1a35ce0540df831efaa8dab1fe58', '/navigation/4e3d1a35ce0540df831efaa8dab1fe58', 'https://dev.cas-technik.de/navigation/4e3d1a35ce0540df831efaa8dab1fe58', 'https://dev.cas-technik.de//navigation/4e3d1a35ce0540df831efaa8dab1fe58', '/navigation/4e3d1a35ce0540df831efaa8dab1fe58', '//navigation/4e3d1a35ce0540df831efaa8dab1fe58', 'navigation/4e3d1a35ce0540df831efaa8dab1fe58') AND `scop_platform_redirecter_redirect`.`enabled` = 1 AND (`scop_platform_redirecter_redirect`.`salesChannelId` = 0x3455302FFEF548F797F73592361CE7A1 OR `scop_platform_redirecter_redirect`.`salesChannelId` <=> NULL)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 299)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 97)
9	Scop\PlatformRedirecter\Decorator\CanonicalRedirectServiceDecorator->getRedirect (line 62)
10	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
14	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
16	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
17	Shopware\Core\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 11)

19.85 ms
(14.63%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"""
    x+|KtŽE'´O\n
    é_R\x1F\
    """
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 40)
9	Shopware\Core\Framework\Adapter\Twig\Extension\MediaExtension->searchMedia (line 57)
10	__TwigTemplate_8030195934ad7f1139ee06a2c6b803b2->doDisplay (line 388)
11	Twig\Template->yield (line 104)
12	__TwigTemplate_add0725b3d4cfd99b55a56ec0448c799->block_component_product_box_include (line 432)
13	Twig\Template->yieldBlock (line 477)
14	Twig\Template->yieldParentBlock (line 205)
15	__TwigTemplate_156027a028d06d5ea2082f5927ef73e4->block_component_product_box_include (line 432)
16	Twig\Template->yieldBlock (line 477)
17	Twig\Template->yieldParentBlock (line 180)
18	__TwigTemplate_599af3097ccb46f9db809222154ebd35->block_component_product_box_include (line 432)
19	Twig\Template->yieldBlock (line 47)
20	__TwigTemplate_add0725b3d4cfd99b55a56ec0448c799->doDisplay (line 388)
21	Twig\Template->yield (line 57)
22	__TwigTemplate_156027a028d06d5ea2082f5927ef73e4->doDisplay (line 388)
23	Twig\Template->yield (line 54)
24	__TwigTemplate_599af3097ccb46f9db809222154ebd35->doDisplay (line 388)
25	Twig\Template->yield (line 470)
26	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->block_element_product_listing_box (line 432)
27	Twig\Template->yieldBlock (line 452)
28	Twig\Template->yieldBlock (line 452)
29	Twig\Template->yieldBlock (line 477)
30	Twig\Template->yieldParentBlock (line 190)
31	__TwigTemplate_49146d23c5d6524725d6b8c5d7918e79->block_element_product_listing_box (line 432)
32	Twig\Template->yieldBlock (line 429)
33	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->block_element_product_listing_col (line 432)
34	Twig\Template->yieldBlock (line 452)
35	Twig\Template->yieldBlock (line 477)
36	Twig\Template->yieldParentBlock (line 168)
37	__TwigTemplate_ccd04da654f35825138fbfa2287744bb->block_element_product_listing_col (line 432)
38	Twig\Template->yieldBlock (line 372)
39	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->block_element_product_listing_row (line 432)
40	Twig\Template->yieldBlock (line 477)
41	Twig\Template->yieldParentBlock (line 89)
42	__TwigTemplate_051896a0cf9dcadef6b5f174da07a707->block_element_product_listing_row (line 432)
43	Twig\Template->yieldBlock (line 188)
44	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->block_element_product_listing_wrapper_content (line 432)
45	Twig\Template->yieldBlock (line 149)
46	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->block_product_listing (line 432)
47	Twig\Template->yieldBlock (line 100)
48	__TwigTemplate_ad38a28dc0c0ed1029f654e340ba6c53->doDisplay (line 388)
49	Twig\Template->yield (line 55)
50	__TwigTemplate_051896a0cf9dcadef6b5f174da07a707->doDisplay (line 388)
51	Twig\Template->yield (line 66)
52	__TwigTemplate_ccd04da654f35825138fbfa2287744bb->doDisplay (line 388)
53	Twig\Template->yield (line 54)
54	__TwigTemplate_49146d23c5d6524725d6b8c5d7918e79->doDisplay (line 388)
55	Twig\Template->yield (line 151)
56	__TwigTemplate_540c8740190019526b15c7ee6176bec4->block_element_product_listing_wrapper (line 432)
57	Twig\Template->yieldBlock (line 477)
58	Twig\Template->yieldParentBlock (line 256)
59	__TwigTemplate_c067a8655e20410bca17e357f3135984->block_element_product_listing_wrapper (line 432)
60	Twig\Template->yieldBlock (line 477)
61	Twig\Template->yieldParentBlock (line 91)
62	__TwigTemplate_2a9a1abf63beb2c92481cecd5f995781->block_element_product_listing_wrapper (line 432)
63	Twig\Template->yieldBlock (line 127)
64	__TwigTemplate_540c8740190019526b15c7ee6176bec4->block_element_product_listing (line 432)
65	Twig\Template->yieldBlock (line 48)
66	__TwigTemplate_540c8740190019526b15c7ee6176bec4->doDisplay (line 388)
67	Twig\Template->yield (line 204)
68	__TwigTemplate_c067a8655e20410bca17e357f3135984->doDisplay (line 388)
69	Twig\Template->yield (line 54)
70	__TwigTemplate_2a9a1abf63beb2c92481cecd5f995781->doDisplay (line 388)
71	Twig\Template->yield (line 125)
72	__TwigTemplate_5c087257c403d5a4cef6ba585caf13f1->block_block_product_listing_inner (line 432)
73	Twig\Template->yieldBlock (line 83)
74	__TwigTemplate_5c087257c403d5a4cef6ba585caf13f1->block_block_product_listing (line 432)
75	Twig\Template->yieldBlock (line 48)
76	__TwigTemplate_5c087257c403d5a4cef6ba585caf13f1->doDisplay (line 388)
77	Twig\Template->yield (line 386)
78	__TwigTemplate_f955a86701a696d729530406f195650d->block_section_content_block_row (line 432)
79	Twig\Template->yieldBlock (line 452)
80	Twig\Template->yieldBlock (line 452)
81	Twig\Template->yieldBlock (line 477)
82	Twig\Template->yieldParentBlock (line 623)
83	__TwigTemplate_01cb84c13c1f6b2ccefe4229817ed3b9->block_section_content_block_row (line 432)
84	Twig\Template->yieldBlock (line 526)
85	__TwigTemplate_01cb84c13c1f6b2ccefe4229817ed3b9->block_section_content_block_container (line 432)
86	Twig\Template->yieldBlock (line 219)
87	__TwigTemplate_f955a86701a696d729530406f195650d->block_section_content_block (line 432)
88	Twig\Template->yieldBlock (line 477)
89	Twig\Template->yieldParentBlock (line 244)
90	__TwigTemplate_6ac22c049e8f7f6198b24d06c03faa9f->block_section_content_block (line 432)
91	Twig\Template->yieldBlock (line 477)
92	Twig\Template->yieldParentBlock (line 90)
93	__TwigTemplate_05d5212ee8ad18f25ecbb13b850097b8->block_section_content_block (line 432)
94	Twig\Template->yieldBlock (line 50)
95	__TwigTemplate_f955a86701a696d729530406f195650d->doDisplay (line 388)
96	Twig\Template->yield (line 58)
97	__TwigTemplate_6ac22c049e8f7f6198b24d06c03faa9f->doDisplay (line 388)
98	Twig\Template->yield (line 54)
99	__TwigTemplate_05d5212ee8ad18f25ecbb13b850097b8->doDisplay (line 388)
100	Twig\Template->yield (line 55)
101	__TwigTemplate_01cb84c13c1f6b2ccefe4229817ed3b9->doDisplay (line 388)
102	Twig\Template->yield (line 138)
103	__TwigTemplate_f671b28369fd09d1fe388df29070b83d->block_section_default_content_block (line 432)
104	Twig\Template->yieldBlock (line 452)
105	Twig\Template->yieldBlock (line 452)
106	Twig\Template->yieldBlock (line 477)
107	Twig\Template->yieldParentBlock (line 196)
108	__TwigTemplate_92e5f3069a578155dd3a6bb4f623d07e->block_section_default_content_block (line 432)
109	Twig\Template->yieldBlock (line 98)
110	__TwigTemplate_f671b28369fd09d1fe388df29070b83d->block_page_content_section_default (line 432)
111	Twig\Template->yieldBlock (line 452)
112	Twig\Template->yieldBlock (line 477)
113	Twig\Template->yieldParentBlock (line 79)
114	__TwigTemplate_dcc842083cb8804fdb40b243aa8fef96->block_page_content_section_default (line 432)
115	Twig\Template->yieldBlock (line 477)
116	Twig\Template->yieldParentBlock (line 101)
117	__TwigTemplate_92e5f3069a578155dd3a6bb4f623d07e->block_page_content_section_default (line 432)
118	Twig\Template->yieldBlock (line 48)
119	__TwigTemplate_f671b28369fd09d1fe388df29070b83d->doDisplay (line 388)
120	Twig\Template->yield (line 53)
121	__TwigTemplate_7e0f3d8806590046dbb87f674181150f->doDisplay (line 388)
122	Twig\Template->yield (line 54)
123	__TwigTemplate_dcc842083cb8804fdb40b243aa8fef96->doDisplay (line 388)
124	Twig\Template->yield (line 55)
125	__TwigTemplate_92e5f3069a578155dd3a6bb4f623d07e->doDisplay (line 388)
126	Twig\Template->yield (line 244)
127	__TwigTemplate_942ec77516a965e5e1597b70f400fd26->block_page_content_section (line 432)
128	Twig\Template->yieldBlock (line 477)
129	Twig\Template->yieldParentBlock (line 135)
130	__TwigTemplate_ca9120500e2569c7a6b3e8b05e819a29->block_page_content_section (line 432)
131	Twig\Template->yieldBlock (line 477)
132	Twig\Template->yieldParentBlock (line 710)
133	__TwigTemplate_f746e6748ea3aa42e1ede87584b6c08d->block_page_content_section (line 432)
134	Twig\Template->yieldBlock (line 452)
135	Twig\Template->yieldBlock (line 477)
136	Twig\Template->yieldParentBlock (line 480)
137	__TwigTemplate_b388365af1ee99d14512b783298ff7de->block_page_content_section (line 432)
138	Twig\Template->yieldBlock (line 178)
139	__TwigTemplate_942ec77516a965e5e1597b70f400fd26->block_page_content_sections_inner (line 432)
140	Twig\Template->yieldBlock (line 452)
141	Twig\Template->yieldBlock (line 477)
142	Twig\Template->yieldParentBlock (line 90)
143	__TwigTemplate_f746e6748ea3aa42e1ede87584b6c08d->block_page_content_sections_inner (line 432)
144	Twig\Template->yieldBlock (line 477)
145	Twig\Template->yieldParentBlock (line 77)
146	__TwigTemplate_03ace7df76fe9163a6b966112d4b2154->block_page_content_sections_inner (line 432)
147	Twig\Template->yieldBlock (line 51)
148	__TwigTemplate_942ec77516a965e5e1597b70f400fd26->doDisplay (line 388)
149	Twig\Template->yield (line 54)
150	__TwigTemplate_ca9120500e2569c7a6b3e8b05e819a29->doDisplay (line 388)
151	Twig\Template->yield (line 70)
152	__TwigTemplate_f746e6748ea3aa42e1ede87584b6c08d->doDisplay (line 388)
153	Twig\Template->yield (line 57)
154	__TwigTemplate_03ace7df76fe9163a6b966112d4b2154->doDisplay (line 388)
155	Twig\Template->yield (line 54)
156	__TwigTemplate_b388365af1ee99d14512b783298ff7de->doDisplay (line 388)
157	Twig\Template->yield (line 206)
158	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_page_content_blocks (line 432)
159	Twig\Template->yieldBlock (line 180)
160	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_cms_content (line 432)
161	Twig\Template->yieldBlock (line 477)
162	Twig\Template->yieldParentBlock (line 576)
163	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->block_cms_content (line 432)
164	Twig\Template->yieldBlock (line 111)
165	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_page_content (line 432)
166	Twig\Template->yieldBlock (line 80)
167	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_base_main_inner (line 432)
168	Twig\Template->yieldBlock (line 629)
169	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_main (line 432)
170	Twig\Template->yieldBlock (line 452)
171	Twig\Template->yieldBlock (line 452)
172	Twig\Template->yieldBlock (line 452)
173	Twig\Template->yieldBlock (line 452)
174	Twig\Template->yieldBlock (line 452)
175	Twig\Template->yieldBlock (line 452)
176	Twig\Template->yieldBlock (line 452)
177	Twig\Template->yieldBlock (line 477)
178	Twig\Template->yieldParentBlock (line 80)
179	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->block_base_main (line 432)
180	Twig\Template->yieldBlock (line 343)
181	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body_inner (line 432)
182	Twig\Template->yieldBlock (line 477)
183	Twig\Template->yieldParentBlock (line 589)
184	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->block_base_body_inner (line 432)
185	Twig\Template->yieldBlock (line 452)
186	Twig\Template->yieldBlock (line 477)
187	Twig\Template->yieldParentBlock (line 74)
188	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->block_base_body_inner (line 432)
189	Twig\Template->yieldBlock (line 202)
190	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body (line 432)
191	Twig\Template->yieldBlock (line 94)
192	__TwigTemplate_01486d21e512f6388bf2539f11500801->doDisplay (line 388)
193	Twig\Template->yield (line 385)
194	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->doDisplay (line 388)
195	Twig\Template->yield (line 55)
196	__TwigTemplate_1b03f8b7d4aaaeefe3dbf56339ad7779->doDisplay (line 388)
197	Twig\Template->yield (line 54)
198	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->doDisplay (line 388)
199	Twig\Template->yield (line 55)
200	__TwigTemplate_d4a6b218ed1b99d5146bb34d14d282bf->doDisplay (line 388)
201	Twig\Template->yield (line 54)
202	__TwigTemplate_96171cbcf515291a21a0ef312ddc0d34->doDisplay (line 388)
203	Twig\Template->yield (line 54)
204	__TwigTemplate_f2af3a677a521661034f0040610574f2->doDisplay (line 388)
205	Twig\Template->yield (line 57)
206	__TwigTemplate_c33f441578b1ba29fb8a4dc8e4d62880->doDisplay (line 388)
207	Twig\Template->yield (line 60)
208	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->doDisplay (line 388)
209	Twig\Template->yield (line 56)
210	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->doDisplay (line 388)
211	Twig\Template->yield (line 58)
212	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->doDisplay (line 388)
213	Twig\Template->yield (line 74)
214	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->doDisplay (line 388)
215	Twig\Template->yield (line 59)
216	__TwigTemplate_e1698d5184f224d57b6b58ae3da07874->doDisplay (line 388)
217	Twig\Template->yield (line 344)
218	Twig\Template->display (line 359)
219	Twig\Template->render (line 51)
220	Twig\TemplateWrapper->render (line 334)
221	Twig\Environment->render (line 24)
222	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
223	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
224	Shopware\Storefront\Controller\StorefrontController->render (line 91)
225	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
226	Shopware\Core\Profiling\Profiler::trace (line 91)
227	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
228	Shopware\Storefront\Controller\NavigationController->index (line 183)
229	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
230	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
231	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
232	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
233	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
234	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
235	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
236	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
237	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
238	Shopware\Core\Kernel->handle (line 35)
239	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
240	require_once (line 11)

10.80 ms
(7.96%)

# 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/4e3d1a35ce0540df831efaa8dab1fe58"
  "/navigation/088cce47075247e08e3a872d5916d8b5"
  "/navigation/6146db238319420ca6ea5301e64aeab9"
  "/navigation/fda06120bc4d4a9895503a850a4bbc2c"
  "/navigation/d3e6454efa2f4989afd0d1dce8c23d3f"
  "/navigation/82294566c4064694a25d801ce8c4cf89"
  "/navigation/2adfa32a66574a40b6f721e2e5489a32"
  "/navigation/f85ebb51b0834eec8880888fe17570e1"
  "/navigation/d0b7686808c34439a974f217eae792aa"
  "/navigation/85ed4b988f1b499eb869a5fc03b5d36f"
  "/navigation/39e90e2776d4401dad8e83ed0cbcac3a"
  "/navigation/e3760ec9b03e4181aebc48a799eadeda"
  "/navigation/0e8d5f3598004c47888eef56f76c268a"
  "/navigation/f8c558b68e804990b91b6f71242b5f15"
  "/navigation/7cc0d0f72de24f089aafa2343e8cc1ea"
  "/navigation/9a0c19c9e21749709c8b7f2dbe833ef7"
  "/navigation/92a0905322144e7b9f56e1bfccad3ff9"
  "/navigation/788ed152e8b349889bb94e773c9683ac"
  "/navigation/222017e254114dad9cc8902ebedc295e"
  "/navigation/37deff31f6594da5a91d95e572eb3579"
  "/navigation/cf33e089be3f45a182da22417e0ae177"
  "/navigation/b508f3c54230428fbbd2177df060e408"
  "/navigation/f105f3c43c934df1bcee839bcb830777"
  "/navigation/782dd780c4ff42ff883f4c632448ccba"
  "/navigation/0fe8b77df58b46779275294c947bd905"
  "/navigation/b383e1d650f646cda0d10f523762a8c5"
  "/navigation/3f646aca9f284851b7cd74c811dabf9d"
  "/navigation/db61e315195b457cbedca5787f203ada"
  "/navigation/469391a875a5492fa5b63c5f1ee61d69"
  "/navigation/7a1709a514064f3684b7c5d50c42c3ad"
  "/navigation/425505f74c5c49a48bf55fe0b36f6efa"
  "/navigation/75a4d83adc9c4761b558ef79e16e83d9"
  "/navigation/cb2c63b1273145be9e3380d1a3e505f7"
  "/navigation/f7ee2e72e77f464983f9cf727bef6d32"
  "/navigation/47cfd1b5825742769946ec6179ec906f"
  "/navigation/3f4c23c1903541e199cacdde0159e768"
  "/navigation/09c96cbea6694721a641557e3899f793"
  "/navigation/af025bc2d1464b98b4869434b37bded9"
  "/navigation/e2a5facc79e44d169f8906b0f08c7c86"
  "/navigation/c59c194ab1514f10b10bfcf705e727be"
  "/navigation/ceee4a8debab47529cca2c7f0209d4e1"
  "/navigation/0b38c87530e648a089d3e4d8bb1adcf0"
  "/navigation/c5ab2a1861d74a9981261d7e5d43922b"
  "/navigation/696637456b3e497993ca7eadbfca5ddd"
  "/navigation/0975e541afe0417d9509ba869616d5c6"
  "/navigation/0d0a2d21bfc1496fbe4139eaaa6def23"
  "/navigation/be0a563d3c5c48a2a88556dc2cf6919e"
  "/navigation/67fd433bda244bf8b4af59d4190e03c7"
  "/navigation/c26fe1dcd7e54fd0ab7d58f0ad513239"
  "/navigation/ccdbc5e4b8c7408daf4c410159b8d4dc"
  "/navigation/f42a467083b04e38a38e0372b6900f62"
  "/navigation/52a13a086e634ce18f6f72b637e3f7e7"
  "/navigation/d67377796c8f4a3cb60b1b950c9f9968"
  "/navigation/afe1cb74876647e1a90db46c70bccebd"
  "/navigation/eda38c72035d4089a07c8c7201e9f65d"
  "/navigation/062f14f9c9a0487db02eae5a3e9adb11"
  "/navigation/bb5f7881fa724731bc790b6584dc01e2"
  "/navigation/5a6c761d8c164263ae56c5c605788f1f"
  "/navigation/c556325d1dc54036acd3d1a0c19b0734"
  "/navigation/1719dabe0e6347acb3219a77f5c9bdef"
  "/navigation/1a0d277741964e2bb69537fe7c9fff8d"
  "/navigation/52946dabdeb34e4faa80bc43b8754e48"
  "/navigation/24d27889234f4f95888b48e7f94953bc"
  "/navigation/74ec89fc157143b8b1e54404e6927a0b"
  "/navigation/f8400603f7f34ab1b16afe1e55f9bd89"
  "/navigation/fe16ab5555ca4b5bb56b4c3c7cf43487"
  "/navigation/075ee8e3fef6445e94a3471140baa5fe"
  "/navigation/8bd5623be4cf4805b79b1dc61b73f4a9"
  "/navigation/256506a01f184cc6879e658b483d48cc"
  "/navigation/d5be655976be4259b7d6a6c88436090b"
  "/navigation/52edf1c9d90e4907a30d3d9c121358eb"
  "/navigation/e252159a06e6408ab9d546d5b0b375ed"
  "/navigation/3a5c913adb774d99ab0245a1735f0a97"
  "/navigation/998a2987292f4040a20e495a584dc033"
  "/navigation/90a0c113abcf42c08b0588b40bbebb6e"
  "/navigation/ea795d635cc4409baafc3c091e50d55d"
  "/navigation/db7c411e11044d64b8fe4491836d1498"
  "/navigation/60d8b4a0293a498a99576b1864e05aa8"
  "/navigation/fb94d9f77b1648a599ecfce531b61579"
  "/navigation/9c24edcd5f9d4defafe656b3bb87eab4"
  "/navigation/4fac7ef61f48411ba03fe3749d90c071"
  "/navigation/eed6fce7b4a346c3b778ccdded7325ba"
  "/navigation/538934efa9804fcaa043a17b1cdaa3d8"
  "/navigation/57705ed93cc140bcb5417f2892c19499"
  "/navigation/8d38a5ff1e9243a186bd2115ff9eadc2"
  "/navigation/c32fa5d21dea40529095be5925262783"
  "/navigation/67f198396c94456190f14358f931c26a"
  "/navigation/025cbb13c47f42968331904c0259de0e"
  "/navigation/b72d96e714ad474eb1f1a4766cdd3aa7"
  "/navigation/c3e7a0014e394592ad0a18a8cfaf3372"
  "/navigation/8380c2c0292e4c2b995f17ac96fc221a"
  "/navigation/8ed7c5c8ce2042b3aa14428457c2a6d2"
  "/navigation/2ffd9e9d00f64b7ca75bbe1e2c061f9c"
  "/navigation/018a1991bbce4cc3a0b36881e0609858"
  "/navigation/80275fec53cc4418b13757780d0a391a"
  "/navigation/7d831bc424f94acbaded4c192b90ab00"
  "/navigation/c13385ceea66432ebf9c90b5241245fa"
  "/navigation/c21ad6b9a2674c9bbc7fc887a8f4baf8"
  "/navigation/1bfc9663a98d43ee976a5d72a1f6f952"
  "/navigation/d0b5244b803e4d8689f0cf29d1783d69"
  "/navigation/7d696320009349f59d8b4d4ae689fa0e"
  "/navigation/e162efe6834c4c18a37d89df24a85ee9"
  "/navigation/6b17b411b0894416bbec2e6152923c55"
  "/navigation/788233ee30fd4dd5bccdf1cc78307e71"
  "/navigation/68058afef9e146cfa6ac22b9ddc9b259"
  "/navigation/b34c881b75064164b353bc1dec6ac68e"
  "/navigation/c7785ee97b314f3db03edee3d9737975"
  "/navigation/93402c7a97f949a096f24dfb66d62f12"
  "/navigation/705c5df17ecd4d4e8b66cb875c4ac4a4"
  "/navigation/95e119c707fb4f108af00dabc98c1b59"
  "/navigation/517d5b4be04e48ccba78dc027a40488f"
  "/navigation/8298961aeeeb4684acbb6dbd68f4f6fa"
  "/navigation/abe4e14d48e6413d9388df40cbe44f08"
  "/navigation/a3a47692c1f14c2c8db71eecce611eca"
  "/navigation/61deb88a56e04e1c928430569113bfba"
  "/navigation/10c26629e81346f194fe697b7a75e294"
  "/navigation/9e5251b3eb3f4a268bcae8a4a30ff7f2"
  "/navigation/b589d61a2f434726a18b59767a95b99e"
  "/navigation/4400d71f465e4cd7b4242b941296f472"
  "/navigation/b732f1a97a4e44c2be17c49db554a84d"
  "/navigation/4cf6563db8b14e28b849ce9332d755ec"
  "/navigation/6e95e7e6d0f84c22ba20dfd7981594cb"
  "/navigation/ff333e1dabef4c5983af1122ed798d3e"
  "/navigation/4d22db93233d4086bfee36ef3b1f35f6"
  "/navigation/4d02dbf4122e4058bf2080900a44455a"
  "/navigation/119ae3d12644495fa6f3618364cbb727"
  "/navigation/e46870e430b747ecb2d349c455263141"
  "/navigation/be23eb58dd78417f8787ee0c6ebe330c"
  "/navigation/466647936cab40d3904d2d31ca2cf3e6"
  "/navigation/f4a44516f22b4cc8954b3cb231002411"
  "/navigation/7df08da7978d4247900f9270108bb595"
  "/navigation/d59c6fa53fc64f14ae6ee401298ee9ec"
  "/navigation/3647c4d5b9864b9797613bd740285d81"
  "/navigation/11aa8af2e5914337b80147fb3b417f01"
  "/navigation/c35da5cb62394401bb4b8a27e9e9e4ba"
  "/navigation/482b53ae8e0342b0959994dcfd22ebef"
  "/navigation/e0b14a92d05640fe9aaa7f5838123bed"
  "/navigation/2cc6f0ad58cc41f7a1e0fee5a8d69afd"
  "/navigation/522abd10811146118388dd8d252c644a"
  "/navigation/f16e91784bf44ba98025bf6d4b960eff"
  "/navigation/09e908767248492d933a52cb3f9f117b"
  "/navigation/5a365c2907fc4b92ad6865ca0dce12d4"
  "/navigation/50590070321b4992b1815c059ad59ca4"
  "/navigation/99a15c90b32244f29da88b4ab4ee3239"
  "/navigation/c2f3b04dff2648469829fa9e2f5705f9"
  "/navigation/935166103a3e490095790d4ccc314086"
  "/navigation/a25c08ee2a204af59f5efa21e30090f4"
  "/navigation/361443a7216249de96928e3d5004f452"
  "/navigation/e5b8cb522b544f1c99362ac233994e00"
  "/navigation/afc70d4cc4704282906ced99404f7a72"
  "/navigation/82b3c25a888a4ebeb5fb661ec00b8abb"
  "/navigation/cd6a8dabe66241b5ab003a60e73670fe"
  "/navigation/d84d88b1caa34b40ae32fc89a82632aa"
  "/navigation/1832298afded43d0bafb4f9adffb7f7b"
  "/navigation/47d9feac11ec4dd4aa2ca28ef647487d"
  "/navigation/11e80a654d334dae8b0a865222914898"
  "/navigation/6b1f36d3c3c74106a1e79c36f4213bc7"
  "/navigation/f4b7603bafc44414ab117c8b38cfd878"
  "/navigation/e5ce80e45abd415f8d0895ab89e06f77"
  "/navigation/cef44518aa174c05973fcdc34d5422c6"
  "/navigation/60bb56d041354f1e939e88f666a9cd65"
  "/navigation/94b5cd34662b47de98a5ca08a153d540"
  "/navigation/ee22b10674724db0b93bbefb3a53b000"
  "/navigation/051fa87536b24ad5888de4352eb66dcd"
  "/navigation/a3325dcd976744a9b7f2990703246ef7"
  "/navigation/2b60a69d4a5a47e0a3fdbf9f6d58f7e8"
  "/navigation/cfc787d6fdfa46a989f2f9ac405eb28c"
  "/navigation/4cac06891e084b4ab42034389be686a6"
  "/navigation/592dc6a003174c72939f9c9206bb9fc8"
  "/navigation/f1ebd70a55c3423d87cfc3e3b6c47a3a"
  "/navigation/97dca773c7e64a0a9382c62cbb3c3092"
  "/navigation/0d45ecb6ed3d4fd685bc2fbbc1203ecc"
  "/navigation/907f84eb71d047498c4d4a61c44c4978"
  "/navigation/742aa3c20c5f4e36977fd1158c36916a"
  "/navigation/16ad571d128444849fd08837180a1ef0"
  "/navigation/8544509a798e4615af5b534b5a35f5b5"
  "/navigation/c2c220b6478248989238c07e245fca35"
  "/navigation/a3c71aa0afd94c9aa1fe66ecd777206b"
  "/navigation/e7b72d5fccc1493c971eccb526f6d12d"
  "/navigation/7dddc7d8d1d74ef28f9c12e2e8aac677"
  "/navigation/b03a2c463c93486eacc93f4f742ea1f2"
  "/navigation/21bfb02687734332811066e98085ba11"
  "/navigation/fbbc83de22664f7994df395b2a340613"
  "/navigation/563f957f228a48fb9ef95efbe8f1ad83"
  "/navigation/15d9c5b6e04d4646a3050fc3fc2f84df"
  "/navigation/02455587dbe7441cb30b620bd222ac3b"
  "/navigation/460ad71b0a9d4b96aed25472735f4777"
  "/navigation/c0140d331b1d4802a60de10691fc3d5f"
  "/navigation/4d01fc191f9740149fdc6102711c6823"
  "/navigation/92fb2b306b8842d6a71b326857b5cbb5"
  "/navigation/40a3b520ae5d4017b6eefe15e75e1980"
  "/navigation/1392601f332c428abd4cc7398f071259"
  "/navigation/e8c6a616d32c4892998f7a8b86fba4ef"
  "/navigation/105fc3f5c83d46778ded9b38355ddb5e"
  "/navigation/abd9631fe49b40e6ac10a17cc6181df7"
  "/navigation/825c3e44198b41f48e881e722033fb9b"
  "/navigation/be585685fec1422fabf9556c5b1d4955"
  "/navigation/ee446ee6cc7b40f2903bd25891a18890"
  "/navigation/2be391b2a29a4bfeb14b1b990081ce28"
  "/navigation/614fba7efeaa40808b12f5dc90501757"
  "/navigation/ee1fb9bf87f14ec086eb23f3e27b84d0"
  "/navigation/5ec40e618a4d4e56a4f9302f29258d39"
  "/navigation/c056c12aacce442987daca041ac61028"
  "/navigation/0e837b0d82d54343bf02a58c3012111c"
  "/navigation/7ed8bb18171341e1b1cd7f0a31de5cc0"
  "/navigation/d276ad2d62db43f9bca54b5a5c8d5baf"
  "/navigation/1be5d8d2204a4fc1b589197b9c5a9db4"
  "/navigation/9b106747cfe141409c036310400259e4"
  "/navigation/6d1782600e1546f7aefc9fbde46336fe"
  "/navigation/d3584a9491e44ee5bf068f19ee855a6c"
  "/navigation/3bb178ff44ab4ecbbd4f4f6fbc99ac7b"
  "/navigation/9a7c6dfbf50a4b52927d9585366175a8"
  "/navigation/783ed40d9f7146cbb006b2ab470d691f"
  "/detail/0190ba56f5777182bda1ff110a8e22c0"
  "/detail/0190ba56f819708baf101cd19079039e"
  "/detail/0190ba570a7d732e918158eadcc1e64a"
  "/detail/0190ba5718e073379fb19b79ae897a23"
  "/detail/0190ba56fa1a705885d07fb8c1292dc5"
  "/detail/0190ba571a93734ea86a28bd03f02235"
  "/detail/0190ba570828703f8719a4bf8539de03"
  "/detail/0190ba56f68e7286a6b8a1ad124fa6b0"
  "/detail/0190ba56f6317129a0667549b2ffa84f"
  "/detail/0190ba56f64b7349bbae892a46a0f78e"
  "/detail/0190ba5727667323867b55e23777c3b4"
  "/detail/0190ba56fd6e727b897f707d056a2cc1"
  "/detail/0190ba56f9a6714084304d19f1218acb"
  "/detail/0190ba570624705fac68a496b026b763"
  "/detail/0190ba570d3771219ee76afd60802484"
  "/detail/0190ba5703fd7174a397b045a810b236"
  "/detail/0190ba56fc1d7338913eec618e92df6f"
  "/detail/0190ba57261572b49b591ddfea910594"
  "/detail/0190ba56eaf071af9f89e2bfeeb11cfa"
  "/detail/0190ba571ecb7057a7612a6defbd5c2e"
  "/detail/0190ba56f5bd71fd9f42d5daa63c53c4"
  "/detail/0190ba570b29731da9d9e145574e94e3"
  "/detail/0190ba56ea8e700d8ba247ca04e2ea4a"
  "/detail/0190ba57085d7244babede749f639b18"
  "/navigation/16d6820611844818b21f02db155f5571"
  "/navigation/a803fe72ddfd4c7a963fc7aef88d2982"
  "/navigation/9407783af883403f9ae466523d9ba969"
  "/navigation/6b3e2cceaff847288ce982185d3eb159"
  "/navigation/14411d2ca159444f8c88440374da98ce"
  "/navigation/d02b90bca7924fde90435125dbfd115f"
  "/navigation/c4bb4c0d23994ba3b1ccae2515ca72ab"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]

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/4e3d1a35ce0540df831efaa8dab1fe58', '/navigation/088cce47075247e08e3a872d5916d8b5', '/navigation/6146db238319420ca6ea5301e64aeab9', '/navigation/fda06120bc4d4a9895503a850a4bbc2c', '/navigation/d3e6454efa2f4989afd0d1dce8c23d3f', '/navigation/82294566c4064694a25d801ce8c4cf89', '/navigation/2adfa32a66574a40b6f721e2e5489a32', '/navigation/f85ebb51b0834eec8880888fe17570e1', '/navigation/d0b7686808c34439a974f217eae792aa', '/navigation/85ed4b988f1b499eb869a5fc03b5d36f', '/navigation/39e90e2776d4401dad8e83ed0cbcac3a', '/navigation/e3760ec9b03e4181aebc48a799eadeda', '/navigation/0e8d5f3598004c47888eef56f76c268a', '/navigation/f8c558b68e804990b91b6f71242b5f15', '/navigation/7cc0d0f72de24f089aafa2343e8cc1ea', '/navigation/9a0c19c9e21749709c8b7f2dbe833ef7', '/navigation/92a0905322144e7b9f56e1bfccad3ff9', '/navigation/788ed152e8b349889bb94e773c9683ac', '/navigation/222017e254114dad9cc8902ebedc295e', '/navigation/37deff31f6594da5a91d95e572eb3579', '/navigation/cf33e089be3f45a182da22417e0ae177', '/navigation/b508f3c54230428fbbd2177df060e408', '/navigation/f105f3c43c934df1bcee839bcb830777', '/navigation/782dd780c4ff42ff883f4c632448ccba', '/navigation/0fe8b77df58b46779275294c947bd905', '/navigation/b383e1d650f646cda0d10f523762a8c5', '/navigation/3f646aca9f284851b7cd74c811dabf9d', '/navigation/db61e315195b457cbedca5787f203ada', '/navigation/469391a875a5492fa5b63c5f1ee61d69', '/navigation/7a1709a514064f3684b7c5d50c42c3ad', '/navigation/425505f74c5c49a48bf55fe0b36f6efa', '/navigation/75a4d83adc9c4761b558ef79e16e83d9', '/navigation/cb2c63b1273145be9e3380d1a3e505f7', '/navigation/f7ee2e72e77f464983f9cf727bef6d32', '/navigation/47cfd1b5825742769946ec6179ec906f', '/navigation/3f4c23c1903541e199cacdde0159e768', '/navigation/09c96cbea6694721a641557e3899f793', '/navigation/af025bc2d1464b98b4869434b37bded9', '/navigation/e2a5facc79e44d169f8906b0f08c7c86', '/navigation/c59c194ab1514f10b10bfcf705e727be', '/navigation/ceee4a8debab47529cca2c7f0209d4e1', '/navigation/0b38c87530e648a089d3e4d8bb1adcf0', '/navigation/c5ab2a1861d74a9981261d7e5d43922b', '/navigation/696637456b3e497993ca7eadbfca5ddd', '/navigation/0975e541afe0417d9509ba869616d5c6', '/navigation/0d0a2d21bfc1496fbe4139eaaa6def23', '/navigation/be0a563d3c5c48a2a88556dc2cf6919e', '/navigation/67fd433bda244bf8b4af59d4190e03c7', '/navigation/c26fe1dcd7e54fd0ab7d58f0ad513239', '/navigation/ccdbc5e4b8c7408daf4c410159b8d4dc', '/navigation/f42a467083b04e38a38e0372b6900f62', '/navigation/52a13a086e634ce18f6f72b637e3f7e7', '/navigation/d67377796c8f4a3cb60b1b950c9f9968', '/navigation/afe1cb74876647e1a90db46c70bccebd', '/navigation/eda38c72035d4089a07c8c7201e9f65d', '/navigation/062f14f9c9a0487db02eae5a3e9adb11', '/navigation/bb5f7881fa724731bc790b6584dc01e2', '/navigation/5a6c761d8c164263ae56c5c605788f1f', '/navigation/c556325d1dc54036acd3d1a0c19b0734', '/navigation/1719dabe0e6347acb3219a77f5c9bdef', '/navigation/1a0d277741964e2bb69537fe7c9fff8d', '/navigation/52946dabdeb34e4faa80bc43b8754e48', '/navigation/24d27889234f4f95888b48e7f94953bc', '/navigation/74ec89fc157143b8b1e54404e6927a0b', '/navigation/f8400603f7f34ab1b16afe1e55f9bd89', '/navigation/fe16ab5555ca4b5bb56b4c3c7cf43487', '/navigation/075ee8e3fef6445e94a3471140baa5fe', '/navigation/8bd5623be4cf4805b79b1dc61b73f4a9', '/navigation/256506a01f184cc6879e658b483d48cc', '/navigation/d5be655976be4259b7d6a6c88436090b', '/navigation/52edf1c9d90e4907a30d3d9c121358eb', '/navigation/e252159a06e6408ab9d546d5b0b375ed', '/navigation/3a5c913adb774d99ab0245a1735f0a97', '/navigation/998a2987292f4040a20e495a584dc033', '/navigation/90a0c113abcf42c08b0588b40bbebb6e', '/navigation/ea795d635cc4409baafc3c091e50d55d', '/navigation/db7c411e11044d64b8fe4491836d1498', '/navigation/60d8b4a0293a498a99576b1864e05aa8', '/navigation/fb94d9f77b1648a599ecfce531b61579', '/navigation/9c24edcd5f9d4defafe656b3bb87eab4', '/navigation/4fac7ef61f48411ba03fe3749d90c071', '/navigation/eed6fce7b4a346c3b778ccdded7325ba', '/navigation/538934efa9804fcaa043a17b1cdaa3d8', '/navigation/57705ed93cc140bcb5417f2892c19499', '/navigation/8d38a5ff1e9243a186bd2115ff9eadc2', '/navigation/c32fa5d21dea40529095be5925262783', '/navigation/67f198396c94456190f14358f931c26a', '/navigation/025cbb13c47f42968331904c0259de0e', '/navigation/b72d96e714ad474eb1f1a4766cdd3aa7', '/navigation/c3e7a0014e394592ad0a18a8cfaf3372', '/navigation/8380c2c0292e4c2b995f17ac96fc221a', '/navigation/8ed7c5c8ce2042b3aa14428457c2a6d2', '/navigation/2ffd9e9d00f64b7ca75bbe1e2c061f9c', '/navigation/018a1991bbce4cc3a0b36881e0609858', '/navigation/80275fec53cc4418b13757780d0a391a', '/navigation/7d831bc424f94acbaded4c192b90ab00', '/navigation/c13385ceea66432ebf9c90b5241245fa', '/navigation/c21ad6b9a2674c9bbc7fc887a8f4baf8', '/navigation/1bfc9663a98d43ee976a5d72a1f6f952', '/navigation/d0b5244b803e4d8689f0cf29d1783d69', '/navigation/7d696320009349f59d8b4d4ae689fa0e', '/navigation/e162efe6834c4c18a37d89df24a85ee9', '/navigation/6b17b411b0894416bbec2e6152923c55', '/navigation/788233ee30fd4dd5bccdf1cc78307e71', '/navigation/68058afef9e146cfa6ac22b9ddc9b259', '/navigation/b34c881b75064164b353bc1dec6ac68e', '/navigation/c7785ee97b314f3db03edee3d9737975', '/navigation/93402c7a97f949a096f24dfb66d62f12', '/navigation/705c5df17ecd4d4e8b66cb875c4ac4a4', '/navigation/95e119c707fb4f108af00dabc98c1b59', '/navigation/517d5b4be04e48ccba78dc027a40488f', '/navigation/8298961aeeeb4684acbb6dbd68f4f6fa', '/navigation/abe4e14d48e6413d9388df40cbe44f08', '/navigation/a3a47692c1f14c2c8db71eecce611eca', '/navigation/61deb88a56e04e1c928430569113bfba', '/navigation/10c26629e81346f194fe697b7a75e294', '/navigation/9e5251b3eb3f4a268bcae8a4a30ff7f2', '/navigation/b589d61a2f434726a18b59767a95b99e', '/navigation/4400d71f465e4cd7b4242b941296f472', '/navigation/b732f1a97a4e44c2be17c49db554a84d', '/navigation/4cf6563db8b14e28b849ce9332d755ec', '/navigation/6e95e7e6d0f84c22ba20dfd7981594cb', '/navigation/ff333e1dabef4c5983af1122ed798d3e', '/navigation/4d22db93233d4086bfee36ef3b1f35f6', '/navigation/4d02dbf4122e4058bf2080900a44455a', '/navigation/119ae3d12644495fa6f3618364cbb727', '/navigation/e46870e430b747ecb2d349c455263141', '/navigation/be23eb58dd78417f8787ee0c6ebe330c', '/navigation/466647936cab40d3904d2d31ca2cf3e6', '/navigation/f4a44516f22b4cc8954b3cb231002411', '/navigation/7df08da7978d4247900f9270108bb595', '/navigation/d59c6fa53fc64f14ae6ee401298ee9ec', '/navigation/3647c4d5b9864b9797613bd740285d81', '/navigation/11aa8af2e5914337b80147fb3b417f01', '/navigation/c35da5cb62394401bb4b8a27e9e9e4ba', '/navigation/482b53ae8e0342b0959994dcfd22ebef', '/navigation/e0b14a92d05640fe9aaa7f5838123bed', '/navigation/2cc6f0ad58cc41f7a1e0fee5a8d69afd', '/navigation/522abd10811146118388dd8d252c644a', '/navigation/f16e91784bf44ba98025bf6d4b960eff', '/navigation/09e908767248492d933a52cb3f9f117b', '/navigation/5a365c2907fc4b92ad6865ca0dce12d4', '/navigation/50590070321b4992b1815c059ad59ca4', '/navigation/99a15c90b32244f29da88b4ab4ee3239', '/navigation/c2f3b04dff2648469829fa9e2f5705f9', '/navigation/935166103a3e490095790d4ccc314086', '/navigation/a25c08ee2a204af59f5efa21e30090f4', '/navigation/361443a7216249de96928e3d5004f452', '/navigation/e5b8cb522b544f1c99362ac233994e00', '/navigation/afc70d4cc4704282906ced99404f7a72', '/navigation/82b3c25a888a4ebeb5fb661ec00b8abb', '/navigation/cd6a8dabe66241b5ab003a60e73670fe', '/navigation/d84d88b1caa34b40ae32fc89a82632aa', '/navigation/1832298afded43d0bafb4f9adffb7f7b', '/navigation/47d9feac11ec4dd4aa2ca28ef647487d', '/navigation/11e80a654d334dae8b0a865222914898', '/navigation/6b1f36d3c3c74106a1e79c36f4213bc7', '/navigation/f4b7603bafc44414ab117c8b38cfd878', '/navigation/e5ce80e45abd415f8d0895ab89e06f77', '/navigation/cef44518aa174c05973fcdc34d5422c6', '/navigation/60bb56d041354f1e939e88f666a9cd65', '/navigation/94b5cd34662b47de98a5ca08a153d540', '/navigation/ee22b10674724db0b93bbefb3a53b000', '/navigation/051fa87536b24ad5888de4352eb66dcd', '/navigation/a3325dcd976744a9b7f2990703246ef7', '/navigation/2b60a69d4a5a47e0a3fdbf9f6d58f7e8', '/navigation/cfc787d6fdfa46a989f2f9ac405eb28c', '/navigation/4cac06891e084b4ab42034389be686a6', '/navigation/592dc6a003174c72939f9c9206bb9fc8', '/navigation/f1ebd70a55c3423d87cfc3e3b6c47a3a', '/navigation/97dca773c7e64a0a9382c62cbb3c3092', '/navigation/0d45ecb6ed3d4fd685bc2fbbc1203ecc', '/navigation/907f84eb71d047498c4d4a61c44c4978', '/navigation/742aa3c20c5f4e36977fd1158c36916a', '/navigation/16ad571d128444849fd08837180a1ef0', '/navigation/8544509a798e4615af5b534b5a35f5b5', '/navigation/c2c220b6478248989238c07e245fca35', '/navigation/a3c71aa0afd94c9aa1fe66ecd777206b', '/navigation/e7b72d5fccc1493c971eccb526f6d12d', '/navigation/7dddc7d8d1d74ef28f9c12e2e8aac677', '/navigation/b03a2c463c93486eacc93f4f742ea1f2', '/navigation/21bfb02687734332811066e98085ba11', '/navigation/fbbc83de22664f7994df395b2a340613', '/navigation/563f957f228a48fb9ef95efbe8f1ad83', '/navigation/15d9c5b6e04d4646a3050fc3fc2f84df', '/navigation/02455587dbe7441cb30b620bd222ac3b', '/navigation/460ad71b0a9d4b96aed25472735f4777', '/navigation/c0140d331b1d4802a60de10691fc3d5f', '/navigation/4d01fc191f9740149fdc6102711c6823', '/navigation/92fb2b306b8842d6a71b326857b5cbb5', '/navigation/40a3b520ae5d4017b6eefe15e75e1980', '/navigation/1392601f332c428abd4cc7398f071259', '/navigation/e8c6a616d32c4892998f7a8b86fba4ef', '/navigation/105fc3f5c83d46778ded9b38355ddb5e', '/navigation/abd9631fe49b40e6ac10a17cc6181df7', '/navigation/825c3e44198b41f48e881e722033fb9b', '/navigation/be585685fec1422fabf9556c5b1d4955', '/navigation/ee446ee6cc7b40f2903bd25891a18890', '/navigation/2be391b2a29a4bfeb14b1b990081ce28', '/navigation/614fba7efeaa40808b12f5dc90501757', '/navigation/ee1fb9bf87f14ec086eb23f3e27b84d0', '/navigation/5ec40e618a4d4e56a4f9302f29258d39', '/navigation/c056c12aacce442987daca041ac61028', '/navigation/0e837b0d82d54343bf02a58c3012111c', '/navigation/7ed8bb18171341e1b1cd7f0a31de5cc0', '/navigation/d276ad2d62db43f9bca54b5a5c8d5baf', '/navigation/1be5d8d2204a4fc1b589197b9c5a9db4', '/navigation/9b106747cfe141409c036310400259e4', '/navigation/6d1782600e1546f7aefc9fbde46336fe', '/navigation/d3584a9491e44ee5bf068f19ee855a6c', '/navigation/3bb178ff44ab4ecbbd4f4f6fbc99ac7b', '/navigation/9a7c6dfbf50a4b52927d9585366175a8', '/navigation/783ed40d9f7146cbb006b2ab470d691f', '/detail/0190ba56f5777182bda1ff110a8e22c0', '/detail/0190ba56f819708baf101cd19079039e', '/detail/0190ba570a7d732e918158eadcc1e64a', '/detail/0190ba5718e073379fb19b79ae897a23', '/detail/0190ba56fa1a705885d07fb8c1292dc5', '/detail/0190ba571a93734ea86a28bd03f02235', '/detail/0190ba570828703f8719a4bf8539de03', '/detail/0190ba56f68e7286a6b8a1ad124fa6b0', '/detail/0190ba56f6317129a0667549b2ffa84f', '/detail/0190ba56f64b7349bbae892a46a0f78e', '/detail/0190ba5727667323867b55e23777c3b4', '/detail/0190ba56fd6e727b897f707d056a2cc1', '/detail/0190ba56f9a6714084304d19f1218acb', '/detail/0190ba570624705fac68a496b026b763', '/detail/0190ba570d3771219ee76afd60802484', '/detail/0190ba5703fd7174a397b045a810b236', '/detail/0190ba56fc1d7338913eec618e92df6f', '/detail/0190ba57261572b49b591ddfea910594', '/detail/0190ba56eaf071af9f89e2bfeeb11cfa', '/detail/0190ba571ecb7057a7612a6defbd5c2e', '/detail/0190ba56f5bd71fd9f42d5daa63c53c4', '/detail/0190ba570b29731da9d9e145574e94e3', '/detail/0190ba56ea8e700d8ba247ca04e2ea4a', '/detail/0190ba57085d7244babede749f639b18', '/navigation/16d6820611844818b21f02db155f5571', '/navigation/a803fe72ddfd4c7a963fc7aef88d2982', '/navigation/9407783af883403f9ae466523d9ba969', '/navigation/6b3e2cceaff847288ce982185d3eb159', '/navigation/14411d2ca159444f8c88440374da98ce', '/navigation/d02b90bca7924fde90435125dbfd115f', '/navigation/c4bb4c0d23994ba3b1ccae2515ca72ab')) AND (seo_url.language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (seo_url.sales_channel_id = 0x3455302FFEF548F797F73592361CE7A1 OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 107)
3	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->createSeoMapping (line 52)
4	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->Shopware\Core\Content\Seo\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 47)
6	Shopware\Core\Content\Seo\SeoUrlPlaceholderHandler->replace (line 107)
7	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
8	Shopware\Storefront\Controller\NavigationController->index (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 65)
17	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
18	Shopware\Core\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 11)

5.22 ms
(3.85%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 76)
9	Shopware\Core\Framework\App\Source\SourceResolver->filesystemForAppName (line 60)
10	Shopware\Storefront\Theme\StorefrontPluginConfiguration\StorefrontPluginConfigurationFactory->createFromApp (line 94)
11	Shopware\Storefront\Theme\StorefrontPluginRegistry->addAppConfigs (line 48)
12	Shopware\Storefront\Theme\StorefrontPluginRegistry->getConfigurations (line 98)
13	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->getThemeInheritance (line 36)
14	Shopware\Storefront\Theme\Twig\ThemeInheritanceBuilder->build (line 87)
15	Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder->buildNamespaceHierarchy (line 24)
16	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 137)
17	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
18	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 272)
19	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
20	Shopware\Storefront\Controller\StorefrontController->render (line 91)
21	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
22	Shopware\Core\Profiling\Profiler::trace (line 91)
23	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
24	Shopware\Storefront\Controller\NavigationController->index (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 65)
33	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
34	Shopware\Core\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 11)

1.45 ms
(1.07%)

# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"’ S"\x14N{ŸVá¿Ì?ù"
  b"x>Ô\rŸqFË°\x06²«G\ri\x1F"
  b"N=\x1A5Î\x05@ßƒ\x1Eú¨Ú±þX"
]

View formatted query View runnable query Explain query View query backtrace

# breadcrumb-extension::read
SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.translation.name`,
  `category.translation.name` as `category.name`,
  `category.translation.breadcrumb`,
  `category.translation.breadcrumb` as `category.breadcrumb`,
  `category.translation.slotConfig`,
  `category.translation.slotConfig` as `category.slotConfig`,
  `category.translation.linkType`,
  `category.translation.linkType` as `category.linkType`,
  `category.translation.internalLink`,
  `category.translation.internalLink` as `category.internalLink`,
  `category.translation.externalLink`,
  `category.translation.externalLink` as `category.externalLink`,
  `category.translation.linkNewTab`,
  `category.translation.linkNewTab` as `category.linkNewTab`,
  `category.translation.description`,
  `category.translation.description` as `category.description`,
  `category.translation.metaTitle`,
  `category.translation.metaTitle` as `category.metaTitle`,
  `category.translation.metaDescription`,
  `category.translation.metaDescription` as `category.metaDescription`,
  `category.translation.keywords`,
  `category.translation.keywords` as `category.keywords`,
  `category.translation.customFields`,
  `category.translation.customFields` as `category.customFields`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`
    FROM
      `category_translation` `category.translation`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?, ?, ?)
  )

# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x92A0905322144E7B9F56E1BFCCAD3FF9, 0x783ED40D9F7146CBB006B2AB470D691F, 0x4E3D1A35CE0540DF831EFAA8DAB1FE58));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 68)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->Shopware\Core\Framework\DataAbstractionLayer\{closure} (line 67)
9	Shopware\Core\Profiling\Profiler::trace (line 68)
10	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 62)
11	Shopware\Core\Framework\Adapter\Twig\Extension\BuildBreadcrumbExtension->getFullBreadcrumb (line 88)
12	Shopware\Core\Framework\Adapter\Twig\Extension\BuildBreadcrumbExtension->getFullBreadcrumbById (line 88)
13	__TwigTemplate_372023001f329d78a9819e7d55810d3f->block_layout_breadcrumb_inner (line 432)
14	Twig\Template->yieldBlock (line 53)
15	__TwigTemplate_372023001f329d78a9819e7d55810d3f->doDisplay (line 388)
16	Twig\Template->yield (line 65)
17	__TwigTemplate_fda7d01b38b8f849bb4f4f039c18a17c->doDisplay (line 388)
18	Twig\Template->yield (line 141)
19	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_cms_breadcrumb (line 432)
20	Twig\Template->yieldBlock (line 477)
21	Twig\Template->yieldParentBlock (line 251)
22	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->block_cms_breadcrumb (line 432)
23	Twig\Template->yieldBlock (line 106)
24	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_page_content (line 432)
25	Twig\Template->yieldBlock (line 80)
26	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_base_main_inner (line 432)
27	Twig\Template->yieldBlock (line 629)
28	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_main (line 432)
29	Twig\Template->yieldBlock (line 452)
30	Twig\Template->yieldBlock (line 452)
31	Twig\Template->yieldBlock (line 452)
32	Twig\Template->yieldBlock (line 452)
33	Twig\Template->yieldBlock (line 452)
34	Twig\Template->yieldBlock (line 452)
35	Twig\Template->yieldBlock (line 452)
36	Twig\Template->yieldBlock (line 477)
37	Twig\Template->yieldParentBlock (line 80)
38	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->block_base_main (line 432)
39	Twig\Template->yieldBlock (line 343)
40	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body_inner (line 432)
41	Twig\Template->yieldBlock (line 477)
42	Twig\Template->yieldParentBlock (line 589)
43	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->block_base_body_inner (line 432)
44	Twig\Template->yieldBlock (line 452)
45	Twig\Template->yieldBlock (line 477)
46	Twig\Template->yieldParentBlock (line 74)
47	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->block_base_body_inner (line 432)
48	Twig\Template->yieldBlock (line 202)
49	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body (line 432)
50	Twig\Template->yieldBlock (line 94)
51	__TwigTemplate_01486d21e512f6388bf2539f11500801->doDisplay (line 388)
52	Twig\Template->yield (line 385)
53	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->doDisplay (line 388)
54	Twig\Template->yield (line 55)
55	__TwigTemplate_1b03f8b7d4aaaeefe3dbf56339ad7779->doDisplay (line 388)
56	Twig\Template->yield (line 54)
57	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->doDisplay (line 388)
58	Twig\Template->yield (line 55)
59	__TwigTemplate_d4a6b218ed1b99d5146bb34d14d282bf->doDisplay (line 388)
60	Twig\Template->yield (line 54)
61	__TwigTemplate_96171cbcf515291a21a0ef312ddc0d34->doDisplay (line 388)
62	Twig\Template->yield (line 54)
63	__TwigTemplate_f2af3a677a521661034f0040610574f2->doDisplay (line 388)
64	Twig\Template->yield (line 57)
65	__TwigTemplate_c33f441578b1ba29fb8a4dc8e4d62880->doDisplay (line 388)
66	Twig\Template->yield (line 60)
67	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->doDisplay (line 388)
68	Twig\Template->yield (line 56)
69	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->doDisplay (line 388)
70	Twig\Template->yield (line 58)
71	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->doDisplay (line 388)
72	Twig\Template->yield (line 74)
73	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->doDisplay (line 388)
74	Twig\Template->yield (line 59)
75	__TwigTemplate_e1698d5184f224d57b6b58ae3da07874->doDisplay (line 388)
76	Twig\Template->yield (line 344)
77	Twig\Template->display (line 359)
78	Twig\Template->render (line 51)
79	Twig\TemplateWrapper->render (line 334)
80	Twig\Environment->render (line 24)
81	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
82	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
83	Shopware\Storefront\Controller\StorefrontController->render (line 91)
84	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
85	Shopware\Core\Profiling\Profiler::trace (line 91)
86	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
87	Shopware\Storefront\Controller\NavigationController->index (line 183)
88	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
89	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
90	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
91	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
92	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
93	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
94	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
95	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
96	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
97	Shopware\Core\Kernel->handle (line 35)
98	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
99	require_once (line 11)

1.41 ms
(1.04%)

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

Parameters:

[
  null
  "IntediaDoofinderSW6.config.%"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 193)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 188)
4	Intedia\Doofinder\Doofinder\Api\Search->getConfig (line 72)
5	Intedia\Doofinder\Doofinder\Api\Search->initConfig (line 56)
6	Intedia\Doofinder\Doofinder\Api\Search->__construct (line 41818)
7	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getSearchService (line 41833)
8	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getSearchSubscriberService (line 22846)
9	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::ContainerGw7GY9p\{closure} (line 243)
10	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
17	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
18	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 39)
20	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
21	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
22	Shopware\Storefront\Controller\NavigationController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 11)

1.37 ms
(1.01%)

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

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

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

SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 251)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 58)
9	Swag\PayPal\Util\LocaleCodeProvider->getLocaleCodeFromContext (line 54)
10	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getButtonLanguage (line 40)
11	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getBaseData (line 84)
12	Swag\PayPal\Installment\Banner\Service\BannerDataService->getInstallmentBannerData (line 148)
13	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 246)
14	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
17	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
18	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
19	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
20	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
21	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
22	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 39)
24	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
25	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
26	Shopware\Storefront\Controller\NavigationController->index (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
35	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
36	Shopware\Core\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 11)

1.32 ms
(0.97%)

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

Parameters:

[
  "/navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"–Hó8]aLU½|ÔÜhÓ\x01Ì"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = '/navigation/4e3d1a35ce0540df831efaa8dab1fe58' AND `is_canonical` = 1 AND
                  `sales_channel_id` = 0x3455302FFEF548F797F73592361CE7A1 AND `language_id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B, 0x9648F3385D614C55BD7CD4DC68D301CC);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 169)
3	Shopware\Core\Content\Seo\HreflangLoader->fetchSeoUrls (line 42)
4	Shopware\Core\Content\Seo\HreflangLoader->load (line 55)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addHreflang (line 246)
6	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 83)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
14	Shopware\Storefront\Controller\NavigationController->index (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 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 11)

1.32 ms
(0.97%)

SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = ?

Parameters:

[
  b"\x01™•^/q¦”—\t¹×c6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `acl_role`.`privileges` AS `privileges`
FROM
  `acl_role`
  INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
WHERE
  `app`.`id` = ?

SELECT `acl_role`.`privileges` AS `privileges`
            FROM `acl_role`
            INNER JOIN `app` ON `app`.`acl_role_id` = `acl_role`.`id`
            WHERE `app`.`id` = 0x0199955E812F71A6949709B9D763369D
        ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 65)
3	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->fetchPrivileges (line 55)
4	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->getAppContextSource (line 37)
5	Shopware\Core\Framework\DataAbstractionLayer\Facade\AppContextCreator->getAppContext (line 36)
6	Shopware\Core\Framework\DataAbstractionLayer\Facade\RepositoryFacadeHookFactory->factory (line 170)
7	Shopware\Core\Framework\Script\Execution\ScriptExecutor->initServices (line 88)
8	Shopware\Core\Framework\Script\Execution\ScriptExecutor->render (line 71)
9	Shopware\Core\Framework\Script\Execution\ScriptExecutor->execute (line 302)
10	Shopware\Storefront\Controller\StorefrontController->hook (line 63)
11	Shopware\Storefront\Controller\NavigationController->index (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
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 65)
20	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
21	Shopware\Core\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 11)

1.29 ms
(0.95%)

SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id`  LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id`  WHERE ((`sales_channel`.`id` = ? AND `sales_channel.paymentMethods`.`id` = ? AND `sales_channel.paymentMethods`.`active` = ?)) LIMIT 1

Parameters:

[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  b"÷¸ÉÀ\x10G\x02©ofM«þ&V"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel`.`id`
FROM
  `sales_channel`
  LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id`
  LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id`
WHERE
  (
    (
      `sales_channel`.`id` = ?
      AND `sales_channel.paymentMethods`.`id` = ?
      AND `sales_channel.paymentMethods`.`active` = ?
    )
  )
LIMIT
  1

SELECT `sales_channel`.`id` FROM `sales_channel` LEFT JOIN `sales_channel_payment_method` `sales_channel.paymentMethods.mapping` ON `sales_channel`.`id` = `sales_channel.paymentMethods.mapping`.`sales_channel_id`  LEFT JOIN `payment_method` `sales_channel.paymentMethods` ON `sales_channel.paymentMethods.mapping`.`payment_method_id` = `sales_channel.paymentMethods`.`id`  WHERE ((`sales_channel`.`id` = 0x3455302FFEF548F797F73592361CE7A1 AND `sales_channel.paymentMethods`.`id` = 0xF7B88FC9C0104702A96F664DABFE2656 AND `sales_channel.paymentMethods`.`active` = 1)) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 299)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 37)
7	Swag\AmazonPay\Util\Helper\AmazonPayPaymentMethodHelper->isAmazonPayActive (line 41)
8	Swag\AmazonPay\Storefront\Pagelet\Footer\FooterPageletLoadedEventSubscriber->onFooterPageletLoaded (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
12	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
13	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
14	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
15	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
16	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
17	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
18	Shopware\Core\Profiling\Profiler::trace (line 39)
19	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
20	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
21	Shopware\Storefront\Controller\NavigationController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
24	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
26	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
30	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
31	Shopware\Core\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 11)

1.03 ms
(0.76%)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`, `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`, `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`, `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`, `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`, `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`, `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`, `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`, `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`, `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`, `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`, `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`, `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation.name` as `sales_channel_domain.language.locale.name`, `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation.territory` as `sales_channel_domain.language.locale.territory`, `sales_channel_domain.language.locale.translation.customFields`, `sales_channel_domain.language.locale.translation.customFields` as `sales_channel_domain.language.locale.customFields`, `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`, `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`, `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`, `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`, `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`, `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`, `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`, `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`, `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`, `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`, `sales_channel_domain.currency.netiCurrency`.`id` as `sales_channel_domain.currency.netiCurrency.id`, `sales_channel_domain.currency.netiCurrency`.`currency_id` as `sales_channel_domain.currency.netiCurrency.currencyID`, `sales_channel_domain.currency.netiCurrency`.`active` as `sales_channel_domain.currency.netiCurrency.active`, `sales_channel_domain.currency.netiCurrency`.`buffer` as `sales_channel_domain.currency.netiCurrency.buffer`, `sales_channel_domain.currency.netiCurrency`.`last_factor` as `sales_channel_domain.currency.netiCurrency.lastFactor`, `sales_channel_domain.currency.netiCurrency`.`last_update` as `sales_channel_domain.currency.netiCurrency.lastUpdate`, `sales_channel_domain.currency.netiCurrency`.`created_at` as `sales_channel_domain.currency.netiCurrency.createdAt`, `sales_channel_domain.currency.netiCurrency`.`updated_at` as `sales_channel_domain.currency.netiCurrency.updatedAt`, `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation.shortName` as `sales_channel_domain.currency.shortName`, `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation.name` as `sales_channel_domain.currency.name`, `sales_channel_domain.currency.translation.customFields`, `sales_channel_domain.currency.translation.customFields` as `sales_channel_domain.currency.customFields` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation`.`locale_id`, `sales_channel_domain.language.locale.translation`.`name` as `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation`.`territory` as `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation`.`custom_fields` as `sales_channel_domain.language.locale.translation.customFields` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation`.`language_id` = ?) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN `neti_current_currencies_currency` `sales_channel_domain.currency.netiCurrency` ON `sales_channel_domain.currency`.`id` = `sales_channel_domain.currency.netiCurrency`.`currency_id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation`.`currency_id`, `sales_channel_domain.currency.translation`.`short_name` as `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation`.`name` as `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation`.`custom_fields` as `sales_channel_domain.currency.translation.customFields` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation`.`language_id` = ?) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id` WHERE `sales_channel_domain`.`id` IN (?)

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01X<lŒx»‹tFª£Gx "
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `sales_channel_domain`.`id` as `sales_channel_domain.id`,
  `sales_channel_domain`.`url` as `sales_channel_domain.url`,
  `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`,
  `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`,
  `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`,
  `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`,
  `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`,
  `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`,
  `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`,
  `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`,
  `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`,
  `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`,
  `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`,
  `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`,
  `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`,
  `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`,
  `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`,
  `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`,
  `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`,
  `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`,
  `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`,
  `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`,
  `sales_channel_domain.language.locale.translation.name`,
  `sales_channel_domain.language.locale.translation.name` as `sales_channel_domain.language.locale.name`,
  `sales_channel_domain.language.locale.translation.territory`,
  `sales_channel_domain.language.locale.translation.territory` as `sales_channel_domain.language.locale.territory`,
  `sales_channel_domain.language.locale.translation.customFields`,
  `sales_channel_domain.language.locale.translation.customFields` as `sales_channel_domain.language.locale.customFields`,
  `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`,
  `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`,
  `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`,
  `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`,
  `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`,
  `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`,
  `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`,
  `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`,
  `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`,
  `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`,
  `sales_channel_domain.currency.netiCurrency`.`id` as `sales_channel_domain.currency.netiCurrency.id`,
  `sales_channel_domain.currency.netiCurrency`.`currency_id` as `sales_channel_domain.currency.netiCurrency.currencyID`,
  `sales_channel_domain.currency.netiCurrency`.`active` as `sales_channel_domain.currency.netiCurrency.active`,
  `sales_channel_domain.currency.netiCurrency`.`buffer` as `sales_channel_domain.currency.netiCurrency.buffer`,
  `sales_channel_domain.currency.netiCurrency`.`last_factor` as `sales_channel_domain.currency.netiCurrency.lastFactor`,
  `sales_channel_domain.currency.netiCurrency`.`last_update` as `sales_channel_domain.currency.netiCurrency.lastUpdate`,
  `sales_channel_domain.currency.netiCurrency`.`created_at` as `sales_channel_domain.currency.netiCurrency.createdAt`,
  `sales_channel_domain.currency.netiCurrency`.`updated_at` as `sales_channel_domain.currency.netiCurrency.updatedAt`,
  `sales_channel_domain.currency.translation.shortName`,
  `sales_channel_domain.currency.translation.shortName` as `sales_channel_domain.currency.shortName`,
  `sales_channel_domain.currency.translation.name`,
  `sales_channel_domain.currency.translation.name` as `sales_channel_domain.currency.name`,
  `sales_channel_domain.currency.translation.customFields`,
  `sales_channel_domain.currency.translation.customFields` as `sales_channel_domain.currency.customFields`
FROM
  `sales_channel_domain`
  LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id`
  LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id`
  LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id`
  LEFT JOIN (
    SELECT
      `sales_channel_domain.language.locale.translation`.`locale_id`,
      `sales_channel_domain.language.locale.translation`.`name` as `sales_channel_domain.language.locale.translation.name`,
      `sales_channel_domain.language.locale.translation`.`territory` as `sales_channel_domain.language.locale.translation.territory`,
      `sales_channel_domain.language.locale.translation`.`custom_fields` as `sales_channel_domain.language.locale.translation.customFields`
    FROM
      `locale_translation` `sales_channel_domain.language.locale.translation`
    WHERE
      `sales_channel_domain.language.locale.translation`.`language_id` = ?
  ) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id`
  LEFT JOIN `neti_current_currencies_currency` `sales_channel_domain.currency.netiCurrency` ON `sales_channel_domain.currency`.`id` = `sales_channel_domain.currency.netiCurrency`.`currency_id`
  LEFT JOIN (
    SELECT
      `sales_channel_domain.currency.translation`.`currency_id`,
      `sales_channel_domain.currency.translation`.`short_name` as `sales_channel_domain.currency.translation.shortName`,
      `sales_channel_domain.currency.translation`.`name` as `sales_channel_domain.currency.translation.name`,
      `sales_channel_domain.currency.translation`.`custom_fields` as `sales_channel_domain.currency.translation.customFields`
    FROM
      `currency_translation` `sales_channel_domain.currency.translation`
    WHERE
      `sales_channel_domain.currency.translation`.`language_id` = ?
  ) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id`
WHERE
  `sales_channel_domain`.`id` IN (?)

SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt`, `sales_channel_domain.language`.`id` as `sales_channel_domain.language.id`, `sales_channel_domain.language`.`parent_id` as `sales_channel_domain.language.parentId`, `sales_channel_domain.language`.`locale_id` as `sales_channel_domain.language.localeId`, `sales_channel_domain.language`.`translation_code_id` as `sales_channel_domain.language.translationCodeId`, `sales_channel_domain.language`.`name` as `sales_channel_domain.language.name`, `sales_channel_domain.language`.`custom_fields` as `sales_channel_domain.language.customFields`, `sales_channel_domain.language`.`created_at` as `sales_channel_domain.language.createdAt`, `sales_channel_domain.language`.`updated_at` as `sales_channel_domain.language.updatedAt`, `sales_channel_domain.language.locale`.`id` as `sales_channel_domain.language.locale.id`, `sales_channel_domain.language.locale`.`code` as `sales_channel_domain.language.locale.code`, `sales_channel_domain.language.locale`.`created_at` as `sales_channel_domain.language.locale.createdAt`, `sales_channel_domain.language.locale`.`updated_at` as `sales_channel_domain.language.locale.updatedAt`, `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation.name` as `sales_channel_domain.language.locale.name`, `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation.territory` as `sales_channel_domain.language.locale.territory`, `sales_channel_domain.language.locale.translation.customFields`, `sales_channel_domain.language.locale.translation.customFields` as `sales_channel_domain.language.locale.customFields`, `sales_channel_domain.currency`.`id` as `sales_channel_domain.currency.id`, `sales_channel_domain.currency`.`factor` as `sales_channel_domain.currency.factor`, `sales_channel_domain.currency`.`symbol` as `sales_channel_domain.currency.symbol`, `sales_channel_domain.currency`.`iso_code` as `sales_channel_domain.currency.isoCode`, `sales_channel_domain.currency`.`position` as `sales_channel_domain.currency.position`, `sales_channel_domain.currency`.`tax_free_from` as `sales_channel_domain.currency.taxFreeFrom`, `sales_channel_domain.currency`.`item_rounding` as `sales_channel_domain.currency.itemRounding`, `sales_channel_domain.currency`.`total_rounding` as `sales_channel_domain.currency.totalRounding`, `sales_channel_domain.currency`.`created_at` as `sales_channel_domain.currency.createdAt`, `sales_channel_domain.currency`.`updated_at` as `sales_channel_domain.currency.updatedAt`, `sales_channel_domain.currency.netiCurrency`.`id` as `sales_channel_domain.currency.netiCurrency.id`, `sales_channel_domain.currency.netiCurrency`.`currency_id` as `sales_channel_domain.currency.netiCurrency.currencyID`, `sales_channel_domain.currency.netiCurrency`.`active` as `sales_channel_domain.currency.netiCurrency.active`, `sales_channel_domain.currency.netiCurrency`.`buffer` as `sales_channel_domain.currency.netiCurrency.buffer`, `sales_channel_domain.currency.netiCurrency`.`last_factor` as `sales_channel_domain.currency.netiCurrency.lastFactor`, `sales_channel_domain.currency.netiCurrency`.`last_update` as `sales_channel_domain.currency.netiCurrency.lastUpdate`, `sales_channel_domain.currency.netiCurrency`.`created_at` as `sales_channel_domain.currency.netiCurrency.createdAt`, `sales_channel_domain.currency.netiCurrency`.`updated_at` as `sales_channel_domain.currency.netiCurrency.updatedAt`, `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation.shortName` as `sales_channel_domain.currency.shortName`, `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation.name` as `sales_channel_domain.currency.name`, `sales_channel_domain.currency.translation.customFields`, `sales_channel_domain.currency.translation.customFields` as `sales_channel_domain.currency.customFields` FROM `sales_channel_domain` LEFT JOIN `language` `sales_channel_domain.language` ON `sales_channel_domain`.`language_id` = `sales_channel_domain.language`.`id` LEFT JOIN `currency` `sales_channel_domain.currency` ON `sales_channel_domain`.`currency_id` = `sales_channel_domain.currency`.`id` LEFT JOIN `locale` `sales_channel_domain.language.locale` ON `sales_channel_domain.language`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN (SELECT `sales_channel_domain.language.locale.translation`.`locale_id`, `sales_channel_domain.language.locale.translation`.`name` as `sales_channel_domain.language.locale.translation.name`, `sales_channel_domain.language.locale.translation`.`territory` as `sales_channel_domain.language.locale.translation.territory`, `sales_channel_domain.language.locale.translation`.`custom_fields` as `sales_channel_domain.language.locale.translation.customFields` FROM `locale_translation` `sales_channel_domain.language.locale.translation` WHERE `sales_channel_domain.language.locale.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel_domain.language.locale.locale_translation` ON `sales_channel_domain.language.locale.locale_translation`.`locale_id` = `sales_channel_domain.language.locale`.`id` LEFT JOIN `neti_current_currencies_currency` `sales_channel_domain.currency.netiCurrency` ON `sales_channel_domain.currency`.`id` = `sales_channel_domain.currency.netiCurrency`.`currency_id` LEFT JOIN (SELECT `sales_channel_domain.currency.translation`.`currency_id`, `sales_channel_domain.currency.translation`.`short_name` as `sales_channel_domain.currency.translation.shortName`, `sales_channel_domain.currency.translation`.`name` as `sales_channel_domain.currency.translation.name`, `sales_channel_domain.currency.translation`.`custom_fields` as `sales_channel_domain.currency.translation.customFields` FROM `currency_translation` `sales_channel_domain.currency.translation` WHERE `sales_channel_domain.currency.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `sales_channel_domain.currency.currency_translation` ON `sales_channel_domain.currency.currency_translation`.`currency_id` = `sales_channel_domain.currency`.`id` WHERE `sales_channel_domain`.`id` IN (0x018F583C6C8C78BB8B7446AAA3477820);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 109)
9	Intedia\Doofinder\Storefront\Subscriber\SearchSubscriber->generateCorrectDooFinderData (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
17	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
18	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 39)
20	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
21	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
22	Shopware\Storefront\Controller\NavigationController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
25	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
26	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
27	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
31	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
32	Shopware\Core\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 11)

0.91 ms
(0.67%)

SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjKÂ¾KÙÎu,4%"
  b"N=\x1A5Î\x05@ßƒ\x1Eú¨Ú±þX"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `category`.`id` as `category.id`,
  `category`.`version_id` as `category.versionId`,
  `category`.`parent_id` as `category.parentId`,
  `category`.`parent_version_id` as `category.parentVersionId`,
  `category`.`after_category_id` as `category.afterCategoryId`,
  `category`.`after_category_version_id` as `category.afterCategoryVersionId`,
  `category`.`media_id` as `category.mediaId`,
  `category`.`display_nested_products` as `category.displayNestedProducts`,
  `category`.`auto_increment` as `category.autoIncrement`,
  `category`.`level` as `category.level`,
  `category`.`path` as `category.path`,
  `category`.`child_count` as `category.childCount`,
  `category`.`type` as `category.type`,
  `category`.`product_assignment_type` as `category.productAssignmentType`,
  `category`.`visible` as `category.visible`,
  `category`.`active` as `category.active`,
  `category`.`cms_page_id` as `category.cmsPageId`,
  `category`.`cms_page_version_id` as `category.cmsPageVersionId`,
  `category`.`product_stream_id` as `category.productStreamId`,
  `category`.`custom_entity_type_id` as `category.customEntityTypeId`,
  `category`.`created_at` as `category.createdAt`,
  `category`.`updated_at` as `category.updatedAt`,
  `category.translation.name`,
  `category.translation.name` as `category.name`,
  `category.translation.breadcrumb`,
  `category.translation.breadcrumb` as `category.breadcrumb`,
  `category.translation.slotConfig`,
  `category.translation.slotConfig` as `category.slotConfig`,
  `category.translation.linkType`,
  `category.translation.linkType` as `category.linkType`,
  `category.translation.internalLink`,
  `category.translation.internalLink` as `category.internalLink`,
  `category.translation.externalLink`,
  `category.translation.externalLink` as `category.externalLink`,
  `category.translation.linkNewTab`,
  `category.translation.linkNewTab` as `category.linkNewTab`,
  `category.translation.description`,
  `category.translation.description` as `category.description`,
  `category.translation.metaTitle`,
  `category.translation.metaTitle` as `category.metaTitle`,
  `category.translation.metaDescription`,
  `category.translation.metaDescription` as `category.metaDescription`,
  `category.translation.keywords`,
  `category.translation.keywords` as `category.keywords`,
  `category.translation.customFields`,
  `category.translation.customFields` as `category.customFields`
FROM
  `category`
  LEFT JOIN (
    SELECT
      `category.translation`.`category_id`,
      `category.translation`.`category_version_id`,
      `category.translation`.`breadcrumb` as `category.translation.breadcrumb`,
      `category.translation`.`name` as `category.translation.name`,
      `category.translation`.`custom_fields` as `category.translation.customFields`,
      `category.translation`.`slot_config` as `category.translation.slotConfig`,
      `category.translation`.`link_type` as `category.translation.linkType`,
      `category.translation`.`internal_link` as `category.translation.internalLink`,
      `category.translation`.`external_link` as `category.translation.externalLink`,
      `category.translation`.`link_new_tab` as `category.translation.linkNewTab`,
      `category.translation`.`description` as `category.translation.description`,
      `category.translation`.`meta_title` as `category.translation.metaTitle`,
      `category.translation`.`meta_description` as `category.translation.metaDescription`,
      `category.translation`.`keywords` as `category.translation.keywords`
    FROM
      `category_translation` `category.translation`
    WHERE
      `category.translation`.`language_id` = ?
  ) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id`
  AND `category.category_translation`.`category_version_id` = `category`.`version_id`
WHERE
  (`category`.`version_id` = ?)
  AND (
    `category`.`id` IN (?)
  )

SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = 0x0FA91CE3E96A4BC2BE4BD9CE752C3425) AND (`category`.`id` IN (0x4E3D1A35CE0540DF831EFAA8DAB1FE58));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 83)
9	Shopware\Core\Framework\Adapter\Twig\Extension\BuildBreadcrumbExtension->getFullBreadcrumbById (line 88)
10	__TwigTemplate_372023001f329d78a9819e7d55810d3f->block_layout_breadcrumb_inner (line 432)
11	Twig\Template->yieldBlock (line 53)
12	__TwigTemplate_372023001f329d78a9819e7d55810d3f->doDisplay (line 388)
13	Twig\Template->yield (line 65)
14	__TwigTemplate_fda7d01b38b8f849bb4f4f039c18a17c->doDisplay (line 388)
15	Twig\Template->yield (line 141)
16	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_cms_breadcrumb (line 432)
17	Twig\Template->yieldBlock (line 477)
18	Twig\Template->yieldParentBlock (line 251)
19	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->block_cms_breadcrumb (line 432)
20	Twig\Template->yieldBlock (line 106)
21	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_page_content (line 432)
22	Twig\Template->yieldBlock (line 80)
23	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_base_main_inner (line 432)
24	Twig\Template->yieldBlock (line 629)
25	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_main (line 432)
26	Twig\Template->yieldBlock (line 452)
27	Twig\Template->yieldBlock (line 452)
28	Twig\Template->yieldBlock (line 452)
29	Twig\Template->yieldBlock (line 452)
30	Twig\Template->yieldBlock (line 452)
31	Twig\Template->yieldBlock (line 452)
32	Twig\Template->yieldBlock (line 452)
33	Twig\Template->yieldBlock (line 477)
34	Twig\Template->yieldParentBlock (line 80)
35	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->block_base_main (line 432)
36	Twig\Template->yieldBlock (line 343)
37	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body_inner (line 432)
38	Twig\Template->yieldBlock (line 477)
39	Twig\Template->yieldParentBlock (line 589)
40	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->block_base_body_inner (line 432)
41	Twig\Template->yieldBlock (line 452)
42	Twig\Template->yieldBlock (line 477)
43	Twig\Template->yieldParentBlock (line 74)
44	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->block_base_body_inner (line 432)
45	Twig\Template->yieldBlock (line 202)
46	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body (line 432)
47	Twig\Template->yieldBlock (line 94)
48	__TwigTemplate_01486d21e512f6388bf2539f11500801->doDisplay (line 388)
49	Twig\Template->yield (line 385)
50	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->doDisplay (line 388)
51	Twig\Template->yield (line 55)
52	__TwigTemplate_1b03f8b7d4aaaeefe3dbf56339ad7779->doDisplay (line 388)
53	Twig\Template->yield (line 54)
54	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->doDisplay (line 388)
55	Twig\Template->yield (line 55)
56	__TwigTemplate_d4a6b218ed1b99d5146bb34d14d282bf->doDisplay (line 388)
57	Twig\Template->yield (line 54)
58	__TwigTemplate_96171cbcf515291a21a0ef312ddc0d34->doDisplay (line 388)
59	Twig\Template->yield (line 54)
60	__TwigTemplate_f2af3a677a521661034f0040610574f2->doDisplay (line 388)
61	Twig\Template->yield (line 57)
62	__TwigTemplate_c33f441578b1ba29fb8a4dc8e4d62880->doDisplay (line 388)
63	Twig\Template->yield (line 60)
64	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->doDisplay (line 388)
65	Twig\Template->yield (line 56)
66	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->doDisplay (line 388)
67	Twig\Template->yield (line 58)
68	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->doDisplay (line 388)
69	Twig\Template->yield (line 74)
70	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->doDisplay (line 388)
71	Twig\Template->yield (line 59)
72	__TwigTemplate_e1698d5184f224d57b6b58ae3da07874->doDisplay (line 388)
73	Twig\Template->yield (line 344)
74	Twig\Template->display (line 359)
75	Twig\Template->render (line 51)
76	Twig\TemplateWrapper->render (line 334)
77	Twig\Environment->render (line 24)
78	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
79	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
80	Shopware\Storefront\Controller\StorefrontController->render (line 91)
81	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
82	Shopware\Core\Profiling\Profiler::trace (line 91)
83	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
84	Shopware\Storefront\Controller\NavigationController->index (line 183)
85	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
86	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
87	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
88	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
89	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
90	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
91	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
92	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
93	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
94	Shopware\Core\Kernel->handle (line 35)
95	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
96	require_once (line 11)

0.82 ms
(0.61%)

# 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"4U0/þõH÷—÷5’6\x1Cç¡"
  "navigation/4e3d1a35ce0540df831efaa8dab1fe58"
  "navigation/4e3d1a35ce0540df831efaa8dab1fe58/"
]

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 = 0x3455302FFEF548F797F73592361CE7A1 OR sales_channel_id IS NULL)) AND ((seo_path_info = 'navigation/4e3d1a35ce0540df831efaa8dab1fe58' OR seo_path_info = 'navigation/4e3d1a35ce0540df831efaa8dab1fe58/'));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
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 319)
5	Shopware\Storefront\Framework\Routing\RequestTransformer->resolveSeoUrl (line 118)
6	Shopware\Storefront\Framework\Routing\RequestTransformer->transform (line 18)
7	Shopware\B2B\StoreFrontAuthentication\BridgePlatform\RequestTransformerDecorator->transform (line 48)
8	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
10	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
11	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
12	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
14	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
15	Shopware\Core\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 11)

0.68 ms
(0.50%)

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

Parameters:

[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "g2Tz8PAaWsRh6pLatVg1OVQBcolmhWiD"
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 130)
3	Shopware\Core\System\SalesChannel\Context\SalesChannelContextPersister->load (line 64)
4	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
5	Shopware\Core\Profiling\Profiler::trace (line 61)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
7	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
8	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
9	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
13	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
14	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
15	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
16	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
19	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 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 65)
25	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
26	Shopware\Core\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 11)

0.68 ms
(0.50%)

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

Parameters:

[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "/navigation/4e3d1a35ce0540df831efaa8dab1fe58"
]

View formatted query View runnable query Explain query View query backtrace

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

# seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = 0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) AND (sales_channel_id = 0x3455302FFEF548F797F73592361CE7A1) AND (path_info = '/navigation/4e3d1a35ce0540df831efaa8dab1fe58') AND (is_canonical = 1) LIMIT 1;

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

0.63 ms
(0.46%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.63 ms
(0.46%)

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

Parameters:

[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 97)
3	Shopware\Core\Content\Seo\HreflangLoader->fetchSalesChannelDomains (line 33)
4	Shopware\Core\Content\Seo\HreflangLoader->load (line 55)
5	Shopware\Storefront\Framework\Routing\TemplateDataSubscriber->addHreflang (line 246)
6	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 83)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
14	Shopware\Storefront\Controller\NavigationController->index (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 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 11)

0.62 ms
(0.45%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 70)
3	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->load (line 36)
4	Shopware\Core\Framework\Adapter\Storage\MySQLKeyValueStorage->get (line 37)
5	Shopware\Core\Framework\Adapter\Cache\CacheIdLoader->load (line 67)
6	Shopware\Core\Framework\Adapter\Kernel\KernelFactory::create (line 50)
7	{closure} (line 24)
8	require_once (line 11)

0.56 ms
(0.41%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 130)
3	Shopware\Core\System\CustomField\CustomFieldService->getCustomFields (line 46)
4	Shopware\Core\System\CustomField\CustomFieldService->getCustomField (line 102)
5	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->getFields (line 87)
6	Shopware\Core\Framework\DataAbstractionLayer\FieldSerializer\CustomFieldsSerializer->decode (line 326)
7	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->translate (line 80)
8	Shopware\Core\Content\Category\CategoryHydrator->assign (line 589)
9	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrateEntity (line 97)
10	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityHydrator->hydrate (line 135)
11	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
12	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
13	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
14	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
15	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 83)
16	Shopware\Core\Framework\Adapter\Twig\Extension\BuildBreadcrumbExtension->getFullBreadcrumbById (line 88)
17	__TwigTemplate_372023001f329d78a9819e7d55810d3f->block_layout_breadcrumb_inner (line 432)
18	Twig\Template->yieldBlock (line 53)
19	__TwigTemplate_372023001f329d78a9819e7d55810d3f->doDisplay (line 388)
20	Twig\Template->yield (line 65)
21	__TwigTemplate_fda7d01b38b8f849bb4f4f039c18a17c->doDisplay (line 388)
22	Twig\Template->yield (line 141)
23	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_cms_breadcrumb (line 432)
24	Twig\Template->yieldBlock (line 477)
25	Twig\Template->yieldParentBlock (line 251)
26	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->block_cms_breadcrumb (line 432)
27	Twig\Template->yieldBlock (line 106)
28	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_page_content (line 432)
29	Twig\Template->yieldBlock (line 80)
30	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->block_base_main_inner (line 432)
31	Twig\Template->yieldBlock (line 629)
32	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_main (line 432)
33	Twig\Template->yieldBlock (line 452)
34	Twig\Template->yieldBlock (line 452)
35	Twig\Template->yieldBlock (line 452)
36	Twig\Template->yieldBlock (line 452)
37	Twig\Template->yieldBlock (line 452)
38	Twig\Template->yieldBlock (line 452)
39	Twig\Template->yieldBlock (line 452)
40	Twig\Template->yieldBlock (line 477)
41	Twig\Template->yieldParentBlock (line 80)
42	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->block_base_main (line 432)
43	Twig\Template->yieldBlock (line 343)
44	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body_inner (line 432)
45	Twig\Template->yieldBlock (line 477)
46	Twig\Template->yieldParentBlock (line 589)
47	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->block_base_body_inner (line 432)
48	Twig\Template->yieldBlock (line 452)
49	Twig\Template->yieldBlock (line 477)
50	Twig\Template->yieldParentBlock (line 74)
51	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->block_base_body_inner (line 432)
52	Twig\Template->yieldBlock (line 202)
53	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_body (line 432)
54	Twig\Template->yieldBlock (line 94)
55	__TwigTemplate_01486d21e512f6388bf2539f11500801->doDisplay (line 388)
56	Twig\Template->yield (line 385)
57	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->doDisplay (line 388)
58	Twig\Template->yield (line 55)
59	__TwigTemplate_1b03f8b7d4aaaeefe3dbf56339ad7779->doDisplay (line 388)
60	Twig\Template->yield (line 54)
61	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->doDisplay (line 388)
62	Twig\Template->yield (line 55)
63	__TwigTemplate_d4a6b218ed1b99d5146bb34d14d282bf->doDisplay (line 388)
64	Twig\Template->yield (line 54)
65	__TwigTemplate_96171cbcf515291a21a0ef312ddc0d34->doDisplay (line 388)
66	Twig\Template->yield (line 54)
67	__TwigTemplate_f2af3a677a521661034f0040610574f2->doDisplay (line 388)
68	Twig\Template->yield (line 57)
69	__TwigTemplate_c33f441578b1ba29fb8a4dc8e4d62880->doDisplay (line 388)
70	Twig\Template->yield (line 60)
71	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->doDisplay (line 388)
72	Twig\Template->yield (line 56)
73	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->doDisplay (line 388)
74	Twig\Template->yield (line 58)
75	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->doDisplay (line 388)
76	Twig\Template->yield (line 74)
77	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->doDisplay (line 388)
78	Twig\Template->yield (line 59)
79	__TwigTemplate_e1698d5184f224d57b6b58ae3da07874->doDisplay (line 388)
80	Twig\Template->yield (line 344)
81	Twig\Template->display (line 359)
82	Twig\Template->render (line 51)
83	Twig\TemplateWrapper->render (line 334)
84	Twig\Environment->render (line 24)
85	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
86	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
87	Shopware\Storefront\Controller\StorefrontController->render (line 91)
88	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
89	Shopware\Core\Profiling\Profiler::trace (line 91)
90	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
91	Shopware\Storefront\Controller\NavigationController->index (line 183)
92	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
93	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
94	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
95	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
96	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
97	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
98	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
99	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
100	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
101	Shopware\Core\Kernel->handle (line 35)
102	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
103	require_once (line 11)

0.53 ms
(0.39%)

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

Parameters:

[
  b"\x01Ž^ /\x08qW‚ö\x1E`ÝÄÞÀ"
  b"\x08d¯\x107\F\x04§tOVS\x158G"
  b"jME~ÙMËŒ#—\x12¸õÑ\f"
  b"õÆ“è)“Fv¢LïÑ³€\x1C"
  b"7žhªàrK^¡ÁÙ"È?“\x08"
  b"\x01Ž=ºõ`\x7FÄ±‚Ô½‹’Ïñ"
  b"\x01Q®~\x14p¢ ²1vÞÑ\x04"
  b"äNg‚ÆBG·–¸‘Ï%®8÷"
  b"""
    \n
    ¾oŽH‘BÊ±¾\x06[ý\x1D†Ž
    """
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (0x018E5E202F08715782F61E60DDC4DEC0, 0x0864AF10375C4604A7744F5653153847, 0x6A4D458F7ED94DCB8C239712B8F5D10C, 0xF5C693E829934676A24CEFD1B3801C81, 0x379E68AAE0724B5EA1C1D922C83F9308, 0x018E3DBAF5607FC4B182D4BD8B92CFF1, 0x018F51AE7E1470A2A0B23176DED18F04, 0xE44E6782C64247B796B891CF25AE38F7, 0x0ABE6F8D489142CAB1BE065BFD1D868D);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 90)
9	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->getMatchingRules (line 66)
10	Shopware\Core\Profiling\Subscriber\ActiveRulesDataCollectorSubscriber->collect (line 158)
11	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
12	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 246)
13	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
16	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 216)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
23	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 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 65)
29	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
30	Shopware\Core\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 11)

0.53 ms
(0.39%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

0.51 ms
(0.37%)

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 942)
2	Doctrine\DBAL\Connection->fetchAllAssociativeIndexed (line 72)
3	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->getAppTemplateNamespaces (line 44)
4	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\BundleHierarchyBuilder->buildNamespaceHierarchy (line 24)
5	Shopware\Core\Framework\Adapter\Twig\NamespaceHierarchy\NamespaceHierarchyBuilder->buildHierarchy (line 137)
6	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->getNamespaceHierarchy (line 58)
7	Shopware\Core\Framework\Adapter\Twig\TemplateFinder->find (line 272)
8	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
9	Shopware\Storefront\Controller\StorefrontController->render (line 91)
10	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 91)
12	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
13	Shopware\Storefront\Controller\NavigationController->index (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 65)
22	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
23	Shopware\Core\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 11)

0.49 ms
(0.36%)

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

Parameters:

[
  b"4U0/þõH÷—÷5’6\x1Cç¡"
  "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 = 0x3455302FFEF548F797F73592361CE7A1) AND (configuration_key LIKE 'Sendinblue.%') ORDER BY sales_channel_id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 193)
3	Shopware\Core\System\SystemConfig\SystemConfigService->getDomain (line 114)
4	NewsletterSendinblue\Service\ConfigService->setSalesChannelId (line 48)
5	NewsletterSendinblue\Subscriber\MarketingAutomationSubscriber->onStorefrontRenderEvent (line 246)
6	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
9	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
10	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
11	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
12	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 83)
13	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
14	Shopware\Storefront\Controller\NavigationController->index (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 65)
23	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
24	Shopware\Core\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 11)

0.47 ms
(0.35%)

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

Parameters:

[
  "g2Tz8PAaWsRh6pLatVg1OVQBcolmhWiD"
]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 593)
2	Doctrine\DBAL\Connection->fetchAssociative (line 39)
3	Shopware\Core\Checkout\Cart\CartPersister->load (line 55)
4	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 24)
5	Acris\TaxSwitch\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 97)
6	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
7	Shopware\Core\Profiling\Profiler::trace (line 61)
8	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
9	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
10	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
11	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
15	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
16	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
17	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
18	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
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 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 11)

0.47 ms
(0.35%)

SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `handler_identifier`,
  LOWER(
    HEX(`id`)
  )
FROM
  `payment_method`

SELECT `handler_identifier`, LOWER(HEX(`id`)) FROM `payment_method`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 924)
2	Doctrine\DBAL\Connection->fetchAllKeyValue (line 136)
3	Swag\PayPal\Util\PaymentMethodUtil->getPaymentMethodIdByHandler (line 55)
4	Swag\PayPal\Util\PaymentMethodUtil->getPayPalPaymentMethodId (line 63)
5	Swag\PayPal\Util\PaymentMethodUtil->isPaypalPaymentMethodInSalesChannel (line 130)
6	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 246)
7	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
10	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
11	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
12	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
13	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
14	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
15	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 39)
17	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
18	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
19	Shopware\Storefront\Controller\NavigationController->index (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 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 11)

0.43 ms
(0.31%)

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 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 61)
3	Shopware\Core\Framework\App\ActiveAppsLoader->loadApps (line 44)
4	Shopware\Core\Framework\App\ActiveAppsLoader->getActiveApps (line 25)
5	Shopware\Core\Framework\App\Source\NoDatabaseSourceResolver->__construct (line 55316)
6	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getSourceResolverService (line 55182)
7	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getScriptFileReaderService (line 55135)
8	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getScriptPersisterService (line 57343)
9	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getScriptLoaderService (line 13456)
10	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getScriptExecutorService (line 57114)
11	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::getCoreSubscriberService (line 22479)
12	ContainerGw7GY9p\Shopware_Core_KernelDevContainer::ContainerGw7GY9p\{closure} (line 243)
13	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
16	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
17	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
18	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
19	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 159)
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 65)
28	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
29	Shopware\Core\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 11)

0.41 ms
(0.30%)

SELECT `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`, `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`, `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`, `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`, `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`, `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`, `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`, `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`, `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`, `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`, `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`, `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`, `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer`.`domain_id` = ?)

Parameters:

[
  b"\x01X<lŒx»‹tFª£Gx "
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`,
  `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`,
  `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`,
  `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`,
  `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`,
  `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`,
  `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`,
  `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`,
  `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`,
  `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`,
  `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`,
  `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`,
  `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt`
FROM
  `intedia_doofinder_layer`
WHERE
  (
    `intedia_doofinder_layer`.`domain_id` = ?
  )

SELECT `intedia_doofinder_layer`.`id` as `intedia_doofinder_layer.id`, `intedia_doofinder_layer`.`doofinder_channel_id` as `intedia_doofinder_layer.doofinderChannelId`, `intedia_doofinder_layer`.`doofinder_hash_id` as `intedia_doofinder_layer.doofinderHashId`, `intedia_doofinder_layer`.`doofinder_store_id` as `intedia_doofinder_layer.doofinderStoreId`, `intedia_doofinder_layer`.`domain_id` as `intedia_doofinder_layer.domainId`, `intedia_doofinder_layer`.`trigger` as `intedia_doofinder_layer.trigger`, `intedia_doofinder_layer`.`name` as `intedia_doofinder_layer.name`, `intedia_doofinder_layer`.`status` as `intedia_doofinder_layer.status`, `intedia_doofinder_layer`.`status_message` as `intedia_doofinder_layer.statusMessage`, `intedia_doofinder_layer`.`status_date` as `intedia_doofinder_layer.statusDate`, `intedia_doofinder_layer`.`status_received_date` as `intedia_doofinder_layer.statusReceivedDate`, `intedia_doofinder_layer`.`created_at` as `intedia_doofinder_layer.createdAt`, `intedia_doofinder_layer`.`updated_at` as `intedia_doofinder_layer.updatedAt` FROM `intedia_doofinder_layer` WHERE (`intedia_doofinder_layer`.`domain_id` = 0x018F583C6C8C78BB8B7446AAA3477820);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 317)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch (line 133)
4	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read (line 76)
5	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read (line 207)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->read (line 235)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 166)
9	Intedia\Doofinder\Core\Content\Settings\Service\SettingsHandler->getDoofinderLayer (line 111)
10	Intedia\Doofinder\Storefront\Subscriber\SearchSubscriber->generateCorrectDooFinderData (line 246)
11	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
14	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
15	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
16	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
17	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
18	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
19	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
20	Shopware\Core\Profiling\Profiler::trace (line 39)
21	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
22	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
23	Shopware\Storefront\Controller\NavigationController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
26	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
27	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
28	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
29	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
30	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
32	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
33	Shopware\Core\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 11)

0.39 ms
(0.28%)

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"4U0/þõH÷—÷5’6\x1Cç¡"
  b"Pß|Š¡>L™€´+\x1F\x04ã¬ò"
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 299)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 108)
7	Shopware\Core\Checkout\Cart\Address\AddressValidator->isSalesChannelCountry (line 55)
8	Shopware\Core\Checkout\Cart\Address\AddressValidator->validate (line 25)
9	Shopware\Core\Checkout\Cart\Validator->validate (line 63)
10	Shopware\Core\Checkout\Cart\Processor->Shopware\Core\Checkout\Cart\{closure} (line 67)
11	Shopware\Core\Profiling\Profiler::trace (line 34)
12	Shopware\Core\Checkout\Cart\Processor->process (line 109)
13	Shopware\Core\Checkout\Cart\CartRuleLoader->Shopware\Core\Checkout\Cart\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 83)
15	Shopware\Core\Checkout\Cart\CartRuleLoader->load (line 61)
16	Shopware\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 24)
17	Acris\TaxSwitch\Core\Checkout\Cart\CartRuleLoader->loadByToken (line 97)
18	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->Shopware\Core\System\SalesChannel\Context\{closure} (line 67)
19	Shopware\Core\Profiling\Profiler::trace (line 61)
20	Shopware\Core\System\SalesChannel\Context\SalesChannelContextService->get (line 67)
21	Shopware\Core\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 39)
22	Shopware\Commercial\Subscription\Framework\Routing\SalesChannelRequestContextResolver->resolve (line 34)
23	Shopware\Core\Framework\Routing\ContextResolverListener->resolveContext (line 246)
24	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
27	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
28	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
29	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
30	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 171)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
33	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
34	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
36	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
37	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
38	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
39	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
40	Shopware\Core\Kernel->handle (line 35)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
42	require_once (line 11)

0.38 ms
(0.28%)

SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = ? AND
                    pm.`active` = 1

Parameters:

[
  b"²z*šNI!Ÿ½¿[ÖlÉE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  LOWER(
    HEX(assoc.`sales_channel_id`)
  )
FROM
  `sales_channel_payment_method` AS assoc
  LEFT JOIN `payment_method` AS pm ON pm.`id` = assoc.`payment_method_id`
WHERE
  assoc.`payment_method_id` = ?
  AND pm.`active` = 1

SELECT LOWER(HEX(assoc.`sales_channel_id`))
                FROM `sales_channel_payment_method` AS assoc
                    LEFT JOIN `payment_method` AS pm
                        ON pm.`id` = assoc.`payment_method_id`
                WHERE
                    assoc.`payment_method_id` = 0xB27A2A819A4E49219FBDBF5BD66CC945 AND
                    pm.`active` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 79)
3	Swag\PayPal\Util\PaymentMethodUtil->isPaypalPaymentMethodInSalesChannel (line 130)
4	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 246)
5	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
8	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
9	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
10	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
11	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
12	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
13	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
14	Shopware\Core\Profiling\Profiler::trace (line 39)
15	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
16	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
17	Shopware\Storefront\Controller\NavigationController->index (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
20	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
21	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
22	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
23	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
24	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
25	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
26	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
27	Shopware\Core\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 11)

0.38 ms
(0.28%)

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 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 267)
3	Shopware\Core\Framework\Adapter\Translation\Translator->getSnippetSetId (line 314)
4	Shopware\Core\Framework\Adapter\Translation\Translator->getCustomizedCatalog (line 139)
5	Shopware\Core\Framework\Adapter\Translation\Translator->getCatalogue (line 168)
6	Shopware\Core\Framework\Adapter\Translation\Translator->trans (line 38)
7	Symfony\Component\Translation\DataCollectorTranslator->trans (line 122)
8	Symfony\Bridge\Twig\Extension\TranslationExtension->trans (line 70)
9	__TwigTemplate_da9a7ff765fb36a4e9e9f861de55cdf0->block_form_validation_config (line 432)
10	Twig\Template->yieldBlock (line 47)
11	__TwigTemplate_da9a7ff765fb36a4e9e9f861de55cdf0->doDisplay (line 388)
12	Twig\Template->yield (line 1436)
13	__TwigTemplate_7273670567ca9421e5288b9ac27c4819->block_layout_head_form_validation_messages (line 432)
14	Twig\Template->yieldBlock (line 240)
15	__TwigTemplate_7273670567ca9421e5288b9ac27c4819->block_layout_head_inner (line 432)
16	Twig\Template->yieldBlock (line 98)
17	__TwigTemplate_7273670567ca9421e5288b9ac27c4819->doDisplay (line 388)
18	Twig\Template->yield (line 59)
19	__TwigTemplate_04dca6e1d182c1b34ceb1c310a96aa90->doDisplay (line 388)
20	Twig\Template->yield (line 54)
21	__TwigTemplate_c770528680aa2cf67145a7a62927ee0a->doDisplay (line 388)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_5d067f5255add405fafb61e3bde21d3d->doDisplay (line 388)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_b707be0934fced9df5ba621ce461e6ac->doDisplay (line 388)
26	Twig\Template->yield (line 59)
27	__TwigTemplate_dfc28c5124300e424ea403c925861724->doDisplay (line 388)
28	Twig\Template->yield (line 54)
29	__TwigTemplate_23cece68023a864581a82a55d2339c87->doDisplay (line 388)
30	Twig\Template->yield (line 55)
31	__TwigTemplate_d45979fa51c9cd4c7888d80826040190->doDisplay (line 388)
32	Twig\Template->yield (line 54)
33	__TwigTemplate_cb08f9e7e7a6ee85b1739a13f80d5413->doDisplay (line 388)
34	Twig\Template->yield (line 54)
35	__TwigTemplate_4a07def7726411c15740d22661eb8b61->doDisplay (line 388)
36	Twig\Template->yield (line 54)
37	__TwigTemplate_f9387c592dc96e7fa5335bbd05ac65b1->doDisplay (line 388)
38	Twig\Template->yield (line 169)
39	__TwigTemplate_01486d21e512f6388bf2539f11500801->block_base_head (line 432)
40	Twig\Template->yieldBlock (line 452)
41	Twig\Template->yieldBlock (line 452)
42	Twig\Template->yieldBlock (line 452)
43	Twig\Template->yieldBlock (line 452)
44	Twig\Template->yieldBlock (line 452)
45	Twig\Template->yieldBlock (line 452)
46	Twig\Template->yieldBlock (line 452)
47	Twig\Template->yieldBlock (line 452)
48	Twig\Template->yieldBlock (line 477)
49	Twig\Template->yieldParentBlock (line 78)
50	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->block_base_head (line 432)
51	Twig\Template->yieldBlock (line 89)
52	__TwigTemplate_01486d21e512f6388bf2539f11500801->doDisplay (line 388)
53	Twig\Template->yield (line 385)
54	__TwigTemplate_94e2283c06d5effda4c91da209b6dbdc->doDisplay (line 388)
55	Twig\Template->yield (line 55)
56	__TwigTemplate_1b03f8b7d4aaaeefe3dbf56339ad7779->doDisplay (line 388)
57	Twig\Template->yield (line 54)
58	__TwigTemplate_571ae13da2d6fd8415a6a64afe666039->doDisplay (line 388)
59	Twig\Template->yield (line 55)
60	__TwigTemplate_d4a6b218ed1b99d5146bb34d14d282bf->doDisplay (line 388)
61	Twig\Template->yield (line 54)
62	__TwigTemplate_96171cbcf515291a21a0ef312ddc0d34->doDisplay (line 388)
63	Twig\Template->yield (line 54)
64	__TwigTemplate_f2af3a677a521661034f0040610574f2->doDisplay (line 388)
65	Twig\Template->yield (line 57)
66	__TwigTemplate_c33f441578b1ba29fb8a4dc8e4d62880->doDisplay (line 388)
67	Twig\Template->yield (line 60)
68	__TwigTemplate_c06fce8a15b8d23ed105e277e89f7676->doDisplay (line 388)
69	Twig\Template->yield (line 56)
70	__TwigTemplate_5a1293e1c528925d4f944ac98db1d7bc->doDisplay (line 388)
71	Twig\Template->yield (line 58)
72	__TwigTemplate_80462a2af0b1ba4a8d6583d89ba1155f->doDisplay (line 388)
73	Twig\Template->yield (line 74)
74	__TwigTemplate_ae8122c502f9ce850fd412e9f0db11e7->doDisplay (line 388)
75	Twig\Template->yield (line 59)
76	__TwigTemplate_e1698d5184f224d57b6b58ae3da07874->doDisplay (line 388)
77	Twig\Template->yield (line 344)
78	Twig\Template->display (line 359)
79	Twig\Template->render (line 51)
80	Twig\TemplateWrapper->render (line 334)
81	Twig\Environment->render (line 24)
82	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
83	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
84	Shopware\Storefront\Controller\StorefrontController->render (line 91)
85	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
86	Shopware\Core\Profiling\Profiler::trace (line 91)
87	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
88	Shopware\Storefront\Controller\NavigationController->index (line 183)
89	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
90	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
91	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
92	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
93	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
94	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
95	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
96	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
97	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
98	Shopware\Core\Kernel->handle (line 35)
99	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
100	require_once (line 11)

0.34 ms
(0.25%)

SELECT path FROM category WHERE id = ?

Parameters:

[
  b"N=\x1A5Î\x05@ßƒ\x1Eú¨Ú±þX"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path
FROM
  category
WHERE
  id = ?

SELECT path FROM category WHERE id = 0x4E3D1A35CE0540DF831EFAA8DAB1FE58;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 627)
2	Doctrine\DBAL\Connection->fetchOne (line 125)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getNavigationPath (line 58)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 352)
5	Twig\ExtensionSet->getGlobals (line 901)
6	Twig\Environment->getGlobals (line 384)
7	Twig\Template->yield (line 344)
8	Twig\Template->display (line 359)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 334)
11	Twig\Environment->render (line 24)
12	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
13	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
14	Shopware\Storefront\Controller\StorefrontController->render (line 91)
15	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 91)
17	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
18	Shopware\Storefront\Controller\NavigationController->index (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 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 11)

0.32 ms
(0.23%)

SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (?) LIMIT 1

Parameters:

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

View formatted query View runnable query Explain query View query backtrace

SELECT
  `language`.`id`
FROM
  `language`
WHERE
  `language`.`id` IN (?)
LIMIT
  1

SELECT `language`.`id` FROM `language` WHERE `language`.`id` IN (0x2FBB5FE2E29A4D70AA5854CE7CE3E20B) LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 95)
3	Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntitySearcher->search (line 49)
4	Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher->search (line 299)
5	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_searchIds (line 83)
6	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->searchIds (line 240)
7	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->_search (line 65)
8	Shopware\Core\Framework\DataAbstractionLayer\EntityRepository->search (line 58)
9	Swag\PayPal\Util\LocaleCodeProvider->getLocaleCodeFromContext (line 54)
10	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getButtonLanguage (line 40)
11	Swag\PayPal\Storefront\Data\Service\AbstractScriptDataService->getBaseData (line 84)
12	Swag\PayPal\Installment\Banner\Service\BannerDataService->getInstallmentBannerData (line 148)
13	Swag\PayPal\Installment\Banner\InstallmentBannerSubscriber->addInstallmentBannerPagelet (line 246)
14	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 25)
17	Shopware\Commercial\Subscription\Framework\Event\SubscriptionEventDispatcher->dispatch (line 40)
18	Shopware\Core\Content\Flow\Dispatching\FlowDispatcher->dispatch (line 29)
19	Shopware\Core\Framework\Webhook\WebhookDispatcher->dispatch (line 31)
20	Shopware\Core\Framework\Event\NestedEventDispatcher->dispatch (line 53)
21	Shopware\Storefront\Pagelet\Footer\FooterPageletLoader->load (line 63)
22	Shopware\Storefront\Page\GenericPageLoader->Shopware\Storefront\Page\{closure} (line 67)
23	Shopware\Core\Profiling\Profiler::trace (line 39)
24	Shopware\Storefront\Page\GenericPageLoader->load (line 35)
25	Shopware\Storefront\Page\Navigation\NavigationPageLoader->load (line 61)
26	Shopware\Storefront\Controller\NavigationController->index (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 72)
29	Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 466)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 443)
32	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 341)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 216)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 65)
35	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
36	Shopware\Core\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 11)

0.27 ms
(0.20%)

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 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 115)
3	Shopware\Storefront\Framework\Twig\TemplateDataExtension->minSearchLength (line 68)
4	Shopware\Storefront\Framework\Twig\TemplateDataExtension->getGlobals (line 352)
5	Twig\ExtensionSet->getGlobals (line 901)
6	Twig\Environment->getGlobals (line 384)
7	Twig\Template->yield (line 344)
8	Twig\Template->display (line 359)
9	Twig\Template->render (line 51)
10	Twig\TemplateWrapper->render (line 334)
11	Twig\Environment->render (line 24)
12	Frosh\DevelopmentHelper\Component\Profiler\TwigDecorator->render (line 275)
13	Shopware\Storefront\Controller\StorefrontController->renderView (line 286)
14	Shopware\Storefront\Controller\StorefrontController->render (line 91)
15	Shopware\Storefront\Controller\StorefrontController->Shopware\Storefront\Controller\{closure} (line 67)
16	Shopware\Core\Profiling\Profiler::trace (line 91)
17	Shopware\Storefront\Controller\StorefrontController->renderStorefront (line 65)
18	Shopware\Storefront\Controller\NavigationController->index (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 65)
27	Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle (line 155)
28	Shopware\Core\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 11)

0.23 ms
(0.17%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 383)
2	Shopware\Core\Kernel->initializeDatabaseConnectionVariables (line 187)
3	Shopware\Core\Kernel->boot (line 152)
4	Shopware\Core\Kernel->handle (line 35)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
6	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://dev.cas-technik.de/navigation/4e3d1a35ce0540df831efaa8dab1fe58

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache