Query Metrics
66
Database Queries
48
Different statements
229.32 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
70.18 ms (30.60%) |
1 |
-- category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND (((`cms_section`.`cms_page_id` IN (?))))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Ž¢Äoÿq$¬Gç!Fv¿u" ] |
||||||||||||||||||||||||
|
56.47 ms (24.62%) |
1 |
SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`index_sales_channel_id` as `sas_blog_entries.indexSalesChannelId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`file_hash` as `sas_blog_entries.media.fileHash`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.title` as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.alt` as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.customFields` as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.translation.title`, `sas_blog_entries.translation.title` as `sas_blog_entries.title`, `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.slug` as `sas_blog_entries.slug`, `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.teaser` as `sas_blog_entries.teaser`, `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.metaTitle` as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.metaDescription` as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.metaKeywords` as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.content`, `sas_blog_entries.translation.content` as `sas_blog_entries.content`, `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.customFields` as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields` FROM `media_translation` `sas_blog_entries.media.translation` WHERE `sas_blog_entries.media.translation`.`language_id` = ?) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` WHERE ((COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?) AND (`sas_blog_entries`.`author_id` IN (?)))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" "%019cfb6d02787e978a41db540f96f09a%" null b"dôÆ\x01”cA(¹¸]’™y|E" ] |
||||||||||||||||||||||||
|
15.29 ms (6.67%) |
1 |
SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`index_sales_channel_id` as `sas_blog_entries.indexSalesChannelId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`file_hash` as `sas_blog_entries.media.fileHash`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.title` as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.alt` as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.customFields` as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`, `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`, `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`, `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`, `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`, `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`, `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`, `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`, `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`, `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`, `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`, `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`, `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`, `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`, `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`, `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`, `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`, `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`, `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`, `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`, `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`, `sas_blog_entries.blogAuthor.media`.`file_hash` as `sas_blog_entries.blogAuthor.media.fileHash`, `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`, `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`, `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation.title` as `sas_blog_entries.blogAuthor.media.title`, `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation.alt` as `sas_blog_entries.blogAuthor.media.alt`, `sas_blog_entries.blogAuthor.media.translation.customFields`, `sas_blog_entries.blogAuthor.media.translation.customFields` as `sas_blog_entries.blogAuthor.media.customFields`, `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`, `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`, `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation.description` as `sas_blog_entries.blogAuthor.description`, `sas_blog_entries.blogAuthor.translation.customFields`, `sas_blog_entries.blogAuthor.translation.customFields` as `sas_blog_entries.blogAuthor.customFields`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`) SEPARATOR '||') FROM `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping` WHERE `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.blogCategories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.tags.mapping`.`sas_tag_id`) SEPARATOR '||') FROM `sas_blog_tag` `sas_blog_entries.tags.mapping` WHERE `sas_blog_entries.tags.mapping`.`sas_blog_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.tags.id_mapping`, `sas_blog_entries.translation.title`, `sas_blog_entries.translation.title` as `sas_blog_entries.title`, `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.slug` as `sas_blog_entries.slug`, `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.teaser` as `sas_blog_entries.teaser`, `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.metaTitle` as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.metaDescription` as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.metaKeywords` as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.content`, `sas_blog_entries.translation.content` as `sas_blog_entries.content`, `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.customFields` as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields` FROM `media_translation` `sas_blog_entries.media.translation` WHERE `sas_blog_entries.media.translation`.`language_id` = ?) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`, `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields` FROM `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation` WHERE `sas_blog_entries.blogAuthor.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.media.translation`.`media_id`, `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields` FROM `media_translation` `sas_blog_entries.blogAuthor.media.translation` WHERE `sas_blog_entries.blogAuthor.media.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` WHERE `sas_blog_entries`.`id` IN (?, ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01‹´4óïrA¸ëw"§Á0Ÿ" b":\x17œ£¢‚O-·´/ð]Ô\x16?" ] |
||||||||||||||||||||||||
|
13.19 ms (5.75%) |
1 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)) AND (`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"\x01’)3™\x1E~!·_úŠx©ýo" b"\x01‹fŽ©Ë|/‘ƒ·)òbÜ]" b"\x01‹fŽ©Ë|/‘ƒ·)òbÜ]" b"@ºE&-lD}‡ï£bŸ\x00$i" b"du!-FgDê—q«\vî$<j" ] |
||||||||||||||||||||||||
|
12.28 ms (5.36%) |
2 |
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)) AND (`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"\x00²7<aPA,†Í’]5ç¯s" ] |
||||||||||||||||||||||||
|
7.29 ms (3.18%) |
1 |
-- authors-aggregation::read SELECT `sas_blog_author`.`id` as `sas_blog_author.id`, `sas_blog_author`.`media_id` as `sas_blog_author.mediaId`, `sas_blog_author`.`salutation_id` as `sas_blog_author.salutationId`, `sas_blog_author`.`first_name` as `sas_blog_author.firstName`, `sas_blog_author`.`last_name` as `sas_blog_author.lastName`, `sas_blog_author`.`email` as `sas_blog_author.email`, `sas_blog_author`.`display_name` as `sas_blog_author.displayName`, `sas_blog_author.media`.`id` as `sas_blog_author.media.id`, `sas_blog_author.media`.`user_id` as `sas_blog_author.media.userId`, `sas_blog_author.media`.`media_folder_id` as `sas_blog_author.media.mediaFolderId`, `sas_blog_author.media`.`mime_type` as `sas_blog_author.media.mimeType`, `sas_blog_author.media`.`file_extension` as `sas_blog_author.media.fileExtension`, `sas_blog_author.media`.`uploaded_at` as `sas_blog_author.media.uploadedAt`, `sas_blog_author.media`.`file_name` as `sas_blog_author.media.fileName`, `sas_blog_author.media`.`file_size` as `sas_blog_author.media.fileSize`, `sas_blog_author.media`.`media_type` as `sas_blog_author.media.mediaTypeRaw`, `sas_blog_author.media`.`meta_data` as `sas_blog_author.media.metaData`, `sas_blog_author.media`.`config` as `sas_blog_author.media.config`, `sas_blog_author.media`.`path` as `sas_blog_author.media.path`, `sas_blog_author.media`.`private` as `sas_blog_author.media.private`, `sas_blog_author.media`.`thumbnails_ro` as `sas_blog_author.media.thumbnailsRo`, `sas_blog_author.media`.`file_hash` as `sas_blog_author.media.fileHash`, `sas_blog_author.media`.`created_at` as `sas_blog_author.media.createdAt`, `sas_blog_author.media`.`updated_at` as `sas_blog_author.media.updatedAt`, `sas_blog_author.media.translation.title`, `sas_blog_author.media.translation.title` as `sas_blog_author.media.title`, `sas_blog_author.media.translation.alt`, `sas_blog_author.media.translation.alt` as `sas_blog_author.media.alt`, `sas_blog_author.media.translation.customFields`, `sas_blog_author.media.translation.customFields` as `sas_blog_author.media.customFields`, `sas_blog_author`.`created_at` as `sas_blog_author.createdAt`, `sas_blog_author`.`updated_at` as `sas_blog_author.updatedAt`, `sas_blog_author.translation.description`, `sas_blog_author.translation.description` as `sas_blog_author.description`, `sas_blog_author.translation.customFields`, `sas_blog_author.translation.customFields` as `sas_blog_author.customFields` FROM `sas_blog_author` LEFT JOIN `media` `sas_blog_author.media` ON `sas_blog_author`.`media_id` = `sas_blog_author.media`.`id` LEFT JOIN (SELECT `sas_blog_author.translation`.`sas_blog_author_id`, `sas_blog_author.translation`.`description` as `sas_blog_author.translation.description`, `sas_blog_author.translation`.`custom_fields` as `sas_blog_author.translation.customFields` FROM `sas_blog_author_translation` `sas_blog_author.translation` WHERE `sas_blog_author.translation`.`language_id` = ?) `sas_blog_author.sas_blog_author_translation` ON `sas_blog_author.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_author`.`id` LEFT JOIN (SELECT `sas_blog_author.media.translation`.`media_id`, `sas_blog_author.media.translation`.`alt` as `sas_blog_author.media.translation.alt`, `sas_blog_author.media.translation`.`title` as `sas_blog_author.media.translation.title`, `sas_blog_author.media.translation`.`custom_fields` as `sas_blog_author.media.translation.customFields` FROM `media_translation` `sas_blog_author.media.translation` WHERE `sas_blog_author.media.translation`.`language_id` = ?) `sas_blog_author.media.media_translation` ON `sas_blog_author.media.media_translation`.`media_id` = `sas_blog_author.media`.`id` WHERE `sas_blog_author`.`id` IN (?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"dôÆ\x01”cA(¹¸]’™y|E" ] |
||||||||||||||||||||||||
|
5.14 ms (2.24%) |
3 |
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.override_1.name`, `category.translation.name`, COALESCE(`category.translation.override_1.name`,`category.translation.name`) as `category.name`, `category.translation.override_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.override_1.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.override_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.override_1.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.override_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.override_1.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.override_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.override_1.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.override_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.override_1.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.override_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.override_1.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.override_1.description`, `category.translation.description`, COALESCE(`category.translation.override_1.description`,`category.translation.description`) as `category.description`, `category.translation.override_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.override_1.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.override_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.override_1.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.override_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.override_1.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.override_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.override_1.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.override_1`.`breadcrumb` as `category.translation.override_1.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation.override_1`.`name` as `category.translation.override_1.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation.override_1`.`custom_fields` as `category.translation.override_1.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation.override_1`.`slot_config` as `category.translation.override_1.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation.override_1`.`link_type` as `category.translation.override_1.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation.override_1`.`internal_link` as `category.translation.override_1.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation.override_1`.`external_link` as `category.translation.override_1.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation.override_1`.`link_new_tab` as `category.translation.override_1.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation.override_1`.`description` as `category.translation.override_1.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation.override_1`.`meta_title` as `category.translation.override_1.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation.override_1`.`meta_description` as `category.translation.override_1.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords`, `category.translation.override_1`.`keywords` as `category.translation.override_1.keywords` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.override_1` ON `category.translation`.`category_id` = `category.translation.override_1`.`category_id` AND `category.translation.override_1`.`language_id` = ? AND `category.translation`.`category_version_id` = `category.translation.override_1`.`category_version_id` 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"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
5.02 ms (2.19%) |
5 |
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` <=> ? AND `seo_url`.`route_name` = ? AND `seo_url`.`foreign_key` = ? AND `seo_url`.`is_canonical` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" null "frontend.navigation.page" b"ð<²þ\x00G@³D\x01A\x17Ñp" true ] |
||||||||||||||||||||||||
|
4.84 ms (2.11%) |
1 |
-- 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/f03cb2fe004740b3904490014117d170" "/navigation/4912bdd9d4c042098b5e9e7478cd9dd6" "/navigation/c80366c5226f45ac82449e3a3f0b8554" "/navigation/018a986c0c4a723b83d5960ccff667f5" "/navigation/5823b6e8cb914633acc74170f3c77f02" "/navigation/dd140f7d0b994c06b023ee7cde2201a4" "/navigation/76b109f7f2d44034a0c0447f671a4503" "/navigation/3bddd8e8619e40cf91ff1518c797d4bf" "/navigation/dc41fb6b09814c76b08c03e40fe5eb0a" "/navigation/5c48d65e3c4e4e27b4df712e66aed602" "/navigation/1ac4c3cf38f44ae39135cd3e4567d36a" "/navigation/385ba29df28849b088bb29f6d9dce9c5" "/navigation/444fabf3549f413ba0fdf72cc4b885c9" "/navigation/4b854ba426344e1b9ff3da51fa8ecf23" "/navigation/7dd915fb41ee4ff2a21378afb1b6ce37" "/navigation/cb9ff02bc6e14c4c989c21af04a3786a" "/navigation/61fe82c5fb5b4e2cb5299f1e987d20d4" "/navigation/cf8b7678f7854fcdbb9d97123f07e8dd" "/navigation/d3e0eb6222134422b7281c6751c1fc6c" "/navigation/b82de77f91e74a0c98811854bc0b3a7c" "/navigation/ee45615539294876a9c21bdbd866c7f4" "/navigation/dd6902bc5e0245899ab4837358e372d3" "/navigation/019cae10fe3c7485baa1c77e9db41fde" "/navigation/0077b6e61bb34418affe5490289418ab" "/navigation/01931f4d0e4e762a9e2371e1d626d12c" "/navigation/019897dd94a27c8ea23dff42540848c8" "/navigation/04e5f5b673f847a089cbed532321dfc4" "/navigation/086b89f81e8c4a05a59b1068210db735" "/navigation/13fc36da34a1482f87f736af8cc0ef60" "/navigation/25171e8aa3114ccf8f010554b0386ee5" "/navigation/26e7ffd6ef8244ba90a8555f68683eb5" "/navigation/2c3253cb458b4dd9916196a5891b4dd9" "/navigation/32956a3d7fe040349e0589460051bb2a" "/navigation/338d19185ae342f3acdfec0f23ebb4fb" "/navigation/4af44b3637fe437087030cf990ce693d" "/navigation/ad3da067904c461baba07391c0f023e5" "/navigation/ca4dbd63d30c4ffcb1ea5d633f597978" "/navigation/cc931fdc54534d9aba33b7529a7d30a0" "/navigation/e541a725803d41708f7dc129d567739f" "/navigation/e56ce6de4c1b44e38c56a9c59d0ca812" "/navigation/f89c121dd216458a81922f507aa24edf" "/navigation/fd0eb548ccda4b46b25c0a17e1b2696f" "/navigation/62cfdd15304b46d9ae9c9ddac4a24536" "/navigation/018d1bebfedc7b65a267aa983ff97e69" "/navigation/3e15316a11a94370a995f2cd5d906449" "/navigation/6f1984108a3c4d939aa38fb4985f6844" "/navigation/61497408e8d2444ea1e756bcf10f19f1" "/navigation/018b5c1848fb7eb584c55d0d9e9fc96f" "/navigation/0196aae9606a7de49157ac37aeadc4b0" "/navigation/0196aae9b4ce7b5dbd1a833d5295318c" "/navigation/02e9b55b435045949d3849cfcdc5b316" "/navigation/122090eb5ba3469d8858204a6a2998c1" "/navigation/e374de9754e647d7973a7b36d0057814" "/navigation/5e1e94f100ea4a44b82b49cf0c9ee9cc" "/navigation/d97162e581be45f29254cbcf0d86b3a4" "/navigation/0191313c8ec57587b0a40b74c992c61f" "/navigation/dfbea89f5a7d4503a32b24d1457dfd3e" "/navigation/0198c7ccf1eb784986c8aac35e3b4de0" "/navigation/ef83486861004b3e98f011cb75a2c524" "/sas_blog/018bb434f3ef7241b8eb7722a7c1309f" "/sas_blog/3a179ca3a2824f2db7b42ff05dd4163f" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01œûm\x02x~—ŠAÛT\x0F–ðš" ] |
||||||||||||||||||||||||
|
4.33 ms (1.89%) |
5 |
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` <=> ?)
Parameters:
[
null
]
|
||||||||||||||||||||||||
|
2.16 ms (0.94%) |
3 |
SELECT `dreisc_seo_setting`.`id` as `dreisc_seo_setting.id`, `dreisc_seo_setting`.`key` as `dreisc_seo_setting.key`, `dreisc_seo_setting`.`value` as `dreisc_seo_setting.value`, `dreisc_seo_setting`.`sales_channel_id` as `dreisc_seo_setting.salesChannelId`, `dreisc_seo_setting`.`created_at` as `dreisc_seo_setting.createdAt`, `dreisc_seo_setting`.`updated_at` as `dreisc_seo_setting.updatedAt` FROM `dreisc_seo_setting` WHERE (`dreisc_seo_setting`.`sales_channel_id` = ?)
Parameters:
[
b"\x01œûm\x02x~—ŠAÛT\x0F–ðš"
]
|
||||||||||||||||||||||||
|
2.07 ms (0.90%) |
1 |
-- category::data::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.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` 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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
2.07 ms (0.90%) |
2 |
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"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
2.05 ms (0.89%) |
3 |
SELECT LOWER(HEX(parent_id)) FROM language WHERE id = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
||||||||||||||||||||||||
|
1.77 ms (0.77%) |
1 |
SELECT LOWER(HEX(`sas_blog_entries.blogCategories`.`id`)) as `blogCategories` FROM `sas_blog_entries` LEFT JOIN `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping` ON `sas_blog_entries`.`id` = `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN `sas_blog_category` `sas_blog_entries.blogCategories` ON `sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id` = `sas_blog_entries.blogCategories`.`id` AND `sas_blog_entries.blogCategories`.`version_id` = `sas_blog_entries.blogCategories.mapping`.`sas_blog_category_version_id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?) AND `sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?)) GROUP BY `sas_blog_entries.blogCategories`.`id`
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true "2026-04-02T17:36:38+00:00" "%019cfb6d02787e978a41db540f96f09a%" null true "2026-04-02T17:36:38+00:00" ] |
||||||||||||||||||||||||
|
1.66 ms (0.73%) |
1 |
SELECT LOWER(HEX(`sas_blog_entries`.`author_id`)) as `authors` FROM `sas_blog_entries` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?) AND `sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?)) GROUP BY `sas_blog_entries`.`author_id`
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true "2026-04-02T17:36:38+00:00" "%019cfb6d02787e978a41db540f96f09a%" null true "2026-04-02T17:36:38+00:00" ] |
||||||||||||||||||||||||
|
1.34 ms (0.59%) |
2 |
-- 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"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
1.13 ms (0.49%) |
1 |
-- category::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Ž¢Äoÿq$¬Gç!Fv¿u" ] |
||||||||||||||||||||||||
|
1.13 ms (0.49%) |
1 |
SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.name`, `sas_blog_category.translation.name` as `sas_blog_category.name`, `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation.metaTitle` as `sas_blog_category.metaTitle`, `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation.metaDescription` as `sas_blog_category.metaDescription`, `sas_blog_category.translation.keywords`, `sas_blog_category.translation.keywords` as `sas_blog_category.keywords`, `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.breadcrumb` as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.customFields`, `sas_blog_category.translation.customFields` as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation`.`meta_title` as `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation`.`meta_description` as `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation`.`keywords` as `sas_blog_category.translation.keywords`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` WHERE `sas_blog_category.translation`.`language_id` = ?) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = ?) AND (`sas_blog_category`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01‹lk+–~྄ö|w+ºÂ" b"\x01‹lk\‡w:›\x1FP1$ÍÀ¯" b"H;’\x17_\x0F@‚Ö„êÙÛ£ª" b"çê(ˆø1EÄž½W‚\x108šÚ" ] |
||||||||||||||||||||||||
|
1.10 ms (0.48%) |
1 |
-- blogCategories-aggregation::read SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.name`, `sas_blog_category.translation.name` as `sas_blog_category.name`, `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation.metaTitle` as `sas_blog_category.metaTitle`, `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation.metaDescription` as `sas_blog_category.metaDescription`, `sas_blog_category.translation.keywords`, `sas_blog_category.translation.keywords` as `sas_blog_category.keywords`, `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.breadcrumb` as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.customFields`, `sas_blog_category.translation.customFields` as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation`.`meta_title` as `sas_blog_category.translation.metaTitle`, `sas_blog_category.translation`.`meta_description` as `sas_blog_category.translation.metaDescription`, `sas_blog_category.translation`.`keywords` as `sas_blog_category.translation.keywords`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` WHERE `sas_blog_category.translation`.`language_id` = ?) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = ?) AND (`sas_blog_category`.`id` IN (?, ?, ?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01‹lk+–~྄ö|w+ºÂ" b"\x01‹lk\‡w:›\x1FP1$ÍÀ¯" b"H;’\x17_\x0F@‚Ö„êÙÛ£ª" b"çê(ˆø1EÄž½W‚\x108šÚ" ] |
||||||||||||||||||||||||
|
1.04 ms (0.46%) |
1 |
-- 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"\x01œûm\x02x~—ŠAÛT\x0F–ðš" "Referenzen" "Referenzen/" ] |
||||||||||||||||||||||||
|
1.04 ms (0.45%) |
1 |
SELECT `seo_url`.`id` as `seo_url.id`, `seo_url`.`sales_channel_id` as `seo_url.salesChannelId`, `seo_url`.`language_id` as `seo_url.languageId`, `seo_url`.`foreign_key` as `seo_url.foreignKey`, `seo_url`.`route_name` as `seo_url.routeName`, `seo_url`.`path_info` as `seo_url.pathInfo`, `seo_url`.`seo_path_info` as `seo_url.seoPathInfo`, `seo_url`.`is_canonical` as `seo_url.isCanonical`, `seo_url`.`is_modified` as `seo_url.isModified`, `seo_url`.`is_deleted` as `seo_url.isDeleted`, `seo_url`.`custom_fields` as `seo_url.customFields`, `seo_url`.`created_at` as `seo_url.createdAt`, `seo_url`.`updated_at` as `seo_url.updatedAt` FROM `seo_url` WHERE (`seo_url`.`language_id` = ? AND `seo_url`.`sales_channel_id` = ? AND `seo_url`.`route_name` = ? AND `seo_url`.`foreign_key` = ? AND `seo_url`.`is_canonical` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x01œûm\x02x~—ŠAÛT\x0F–ðš" "frontend.navigation.page" b"ð<²þ\x00G@³D\x01A\x17Ñp" true ] |
||||||||||||||||||||||||
|
1.03 ms (0.45%) |
1 |
-- theme-service::resolve-media::read SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)) AND (`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" false true "product_download" b"R\x11È"J`A·¡BöáwhK{" b"\x7FLÕc:\x04JW¯¸|fŠÅo©" ] |
||||||||||||||||||||||||
|
1.00 ms (0.44%) |
1 |
SELECT `sas_blog_entries`.`id` FROM `sas_blog_entries` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?) AND `sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?)) ORDER BY `sas_blog_entries`.`published_at` DESC LIMIT 2
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true "2026-04-02T17:36:38+00:00" "%019cfb6d02787e978a41db540f96f09a%" null true "2026-04-02T17:36:38+00:00" ] |
||||||||||||||||||||||||
|
1.00 ms (0.43%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||||||
|
0.91 ms (0.40%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.88 ms (0.39%) |
1 |
-- category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?, ?, ?, ?))))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01Ž¢Äp\x16q¡¶\ç[3\x7Fà#" b"\x01Ž¢Ü\x01Ïxš›Z\x7F„;E\x08Ñ" b"\x01Ž¢Ü‰ïq þ‘\x04×# Ò" b"\x01œ‰\x17Šëxá Tº\x18Æ\x0E]" ] |
||||||||||||||||||||||||
|
0.86 ms (0.37%) |
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
Parameters:
[] |
||||||||||||||||||||||||
|
0.82 ms (0.36%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE (sales_channel_id = ?) AND (configuration_key LIKE ?) ORDER BY sales_channel_id ASC
Parameters:
[ b"\x01œûm\x02x~—ŠAÛT\x0F–ðš" "Sendinblue.%" ] |
||||||||||||||||||||||||
|
0.70 ms (0.31%) |
1 |
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_category_id` = ?))
Parameters:
[ true "category" b"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
0.70 ms (0.30%) |
1 |
-- category::data::association::translations::read SELECT `category_translation`.`name` as `category_translation.name`, `category_translation`.`breadcrumb` as `category_translation.breadcrumb`, `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`, `category_translation`.`custom_fields` as `category_translation.customFields`, `category_translation`.`created_at` as `category_translation.createdAt`, `category_translation`.`updated_at` as `category_translation.updatedAt`, `category_translation`.`category_id` as `category_translation.categoryId`, `category_translation`.`language_id` as `category_translation.languageId`, `category_translation`.`category_version_id` as `category_translation.categoryVersionId` FROM `category_translation` WHERE (`category_translation`.`category_version_id` = ?) AND (((`category_translation`.`category_id` IN (?))))
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" b"ð<²þ\x00G@³D\x01A\x17Ñp" ] |
||||||||||||||||||||||||
|
0.68 ms (0.30%) |
1 |
SELECT HEX(id) as id, name FROM language
Parameters:
[] |
||||||||||||||||||||||||
|
0.66 ms (0.29%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01œûm\x02x~—ŠAÛT\x0F–ðš" "uL8cyG6Lz3fOPACrpR7xjBxsPPOJ6xc9" ] |
||||||||||||||||||||||||
|
0.66 ms (0.29%) |
1 |
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"\x01œûm\x02x~—ŠAÛT\x0F–ðš" b"É:ò\x000gL“Ì'QÖÏØ" ] |
||||||||||||||||||||||||
|
0.62 ms (0.27%) |
1 |
# 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:
[]
|
||||||||||||||||||||||||
|
0.62 ms (0.27%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"ð<²þ\x00G@³D\x01A\x17Ñp"
]
|
||||||||||||||||||||||||
|
0.61 ms (0.27%) |
1 |
-- category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?))))
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01œ‰zŽ½pÏ©MŽ¯„_%\f" b"\x01œ‰ n§z,¸Í\x1EÍ\x08t~h" b"\x01Ž¢ÝF?v¾‹ÕPi\x13ˆò" b"\x01œ‰\x17®P}‘¥Y\x0EaŽÔp" ] |
||||||||||||||||||||||||
|
0.59 ms (0.26%) |
1 |
SELECT COUNT(*) FROM (SELECT `sas_blog_entries`.`id` FROM `sas_blog_entries` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?) AND `sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?))) total
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true "2026-04-02T17:36:38+00:00" "%019cfb6d02787e978a41db540f96f09a%" null true "2026-04-02T17:36:38+00:00" ] |
||||||||||||||||||||||||
|
0.52 ms (0.22%) |
2 |
SELECT url FROM sales_channel_domain
Parameters:
[] |
||||||||||||||||||||||||
|
0.50 ms (0.22%) |
1 |
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þˆo¨r°°7\x03f6NîR"
]
|
||||||||||||||||||||||||
|
0.50 ms (0.22%) |
1 |
SELECT `dreisc_seo_redirect`.`id` as `dreisc_seo_redirect.id`, `dreisc_seo_redirect`.`active` as `dreisc_seo_redirect.active`, `dreisc_seo_redirect`.`redirect_http_status_code` as `dreisc_seo_redirect.redirectHttpStatusCode`, `dreisc_seo_redirect`.`source_type` as `dreisc_seo_redirect.sourceType`, `dreisc_seo_redirect`.`has_source_sales_channel_domain_restriction` as `dreisc_seo_redirect.hasSourceSalesChannelDomainRestriction`, `dreisc_seo_redirect`.`source_sales_channel_domain_restriction_ids` as `dreisc_seo_redirect.sourceSalesChannelDomainRestrictionIds`, `dreisc_seo_redirect`.`source_sales_channel_domain_id` as `dreisc_seo_redirect.sourceSalesChannelDomainId`, `dreisc_seo_redirect`.`source_path` as `dreisc_seo_redirect.sourcePath`, `dreisc_seo_redirect`.`source_product_id` as `dreisc_seo_redirect.sourceProductId`, `dreisc_seo_redirect`.`source_product_version_id` as `dreisc_seo_redirect.sourceProductVersionId`, `dreisc_seo_redirect`.`source_category_id` as `dreisc_seo_redirect.sourceCategoryId`, `dreisc_seo_redirect`.`source_category_version_id` as `dreisc_seo_redirect.sourceCategoryVersionId`, `dreisc_seo_redirect`.`redirect_type` as `dreisc_seo_redirect.redirectType`, `dreisc_seo_redirect`.`redirect_url` as `dreisc_seo_redirect.redirectUrl`, `dreisc_seo_redirect`.`redirect_sales_channel_domain_id` as `dreisc_seo_redirect.redirectSalesChannelDomainId`, `dreisc_seo_redirect`.`redirect_path` as `dreisc_seo_redirect.redirectPath`, `dreisc_seo_redirect`.`redirect_product_id` as `dreisc_seo_redirect.redirectProductId`, `dreisc_seo_redirect`.`redirect_product_version_id` as `dreisc_seo_redirect.redirectProductVersionId`, `dreisc_seo_redirect`.`redirect_category_id` as `dreisc_seo_redirect.redirectCategoryId`, `dreisc_seo_redirect`.`redirect_category_version_id` as `dreisc_seo_redirect.redirectCategoryVersionId`, `dreisc_seo_redirect`.`has_deviating_redirect_sales_channel_domain` as `dreisc_seo_redirect.hasDeviatingRedirectSalesChannelDomain`, `dreisc_seo_redirect`.`deviating_redirect_sales_channel_domain_id` as `dreisc_seo_redirect.deviatingRedirectSalesChannelDomainId`, `dreisc_seo_redirect`.`parameter_forwarding` as `dreisc_seo_redirect.parameterForwarding`, `dreisc_seo_redirect`.`created_at` as `dreisc_seo_redirect.createdAt`, `dreisc_seo_redirect`.`updated_at` as `dreisc_seo_redirect.updatedAt` FROM `dreisc_seo_redirect` WHERE ((`dreisc_seo_redirect`.`active` = ? AND `dreisc_seo_redirect`.`source_type` = ? AND `dreisc_seo_redirect`.`source_sales_channel_domain_id` = ? AND `dreisc_seo_redirect`.`source_path` = ?))
Parameters:
[ true "url" b"\x01œûs¨¯q$½ž¡+\x14Ð7&" "Referenzen" ] |
||||||||||||||||||||||||
|
0.50 ms (0.22%) |
1 |
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:
[]
|
||||||||||||||||||||||||
|
0.45 ms (0.20%) |
1 |
SELECT `theme_id`, `technical_name`, `resolved_config`, `view_inheritance`, `script_files`, `icon_sets`, `updated_at` FROM `theme_runtime_config` WHERE `technical_name` = ?
Parameters:
[
"NetzhautMPlusM"
]
|
||||||||||||||||||||||||
|
0.44 ms (0.19%) |
1 |
SELECT DISTINCT `technical_name` FROM `theme_runtime_config` WHERE `technical_name` IS NOT NULL
Parameters:
[] |
||||||||||||||||||||||||
|
0.44 ms (0.19%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||||||
|
0.41 ms (0.18%) |
1 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `id` = ?
Parameters:
[ b"\x0FŘD¦{BɼfËo\v;N‡" b"\x0FŘD¦{BɼfËo\v;N‡" ] |
||||||||||||||||||||||||
|
0.39 ms (0.17%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||||||
|
0.20 ms (0.09%) |
1 |
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters:
[
b"/»_ââšMpªXTÎ|ãâ\v"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.