Query Metrics
76
Database Queries
70
Different statements
17.31 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
7.83 ms (45.22%) |
2 |
-- header::navigation::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.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `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 `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.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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = ? 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`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|0190feb2240073348d61ad6849851fcc|%" 1 4 ] |
||||||||||||||||||||
|
1.52 ms (8.80%) |
2 |
-- theme-service::load-config::read SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.override_1.description`, `theme.translation.description`, COALESCE(`theme.translation.override_1.description`,`theme.translation.description`) as `theme.description`, `theme.translation.override_1.labels`, `theme.translation.labels`, COALESCE(`theme.translation.override_1.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.override_1.helpTexts`, `theme.translation.helpTexts`, COALESCE(`theme.translation.override_1.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.override_1.customFields`, `theme.translation.customFields`, COALESCE(`theme.translation.override_1.customFields`,`theme.translation.customFields`) as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation.override_1`.`description` as `theme.translation.override_1.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation.override_1`.`labels` as `theme.translation.override_1.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation.override_1`.`help_texts` as `theme.translation.override_1.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields`, `theme.translation.override_1`.`custom_fields` as `theme.translation.override_1.customFields` FROM `theme_translation` `theme.translation` LEFT JOIN `theme_translation` `theme.translation.override_1` ON `theme.translation`.`theme_id` = `theme.translation.override_1`.`theme_id` AND `theme.translation.override_1`.`language_id` = ? WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
0.48 ms (2.78%) |
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.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.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.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? 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"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01–¯^‚]t –‡\x0E^à¹I7" b"\x01–¯^‚]t –‡\x0E^à¹I7" b"\x01–¯^‚]t –‡\x0E^à¹I7" b"\x01œu&(!yz¢dü·Äö{¢" b"\x01œu%}Æwf•³'3Øñ#" b"\x01–¯`\x159u±¡Üie2wÐO" ] |
||||||||||||||||||||
|
0.43 ms (2.50%) |
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.override_1.title`, `media.translation.title`, COALESCE(`media.translation.override_1.title`,`media.translation.title`) as `media.title`, `media.translation.override_1.alt`, `media.translation.alt`, COALESCE(`media.translation.override_1.alt`,`media.translation.alt`) as `media.alt`, `media.translation.override_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.override_1.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.override_1`.`alt` as `media.translation.override_1.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation.override_1`.`title` as `media.translation.override_1.title`, `media.translation`.`custom_fields` as `media.translation.customFields`, `media.translation.override_1`.`custom_fields` as `media.translation.override_1.customFields` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.override_1` ON `media.translation`.`media_id` = `media.translation.override_1`.`media_id` AND `media.translation.override_1`.`language_id` = ? 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"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"\x01–¯^‚]t –‡\x0E^à¹I7" b"\x01œu&(!yz¢dü·Äö{¢" b"\x01œu%}Æwf•³'3Øñ#" b"\x01–¯`\x159u±¡Üie2wÐO" ] |
||||||||||||||||||||
|
0.41 ms (2.35%) |
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/94c7bb58efc3b337800875b5d382a072" "/navigation/060ad92489947d410d897474079c1477" "/navigation/5ec91aac30eae62f4140325d09b9afd0" "/navigation/c81e728d9d4c2f636f067f89cc14862c" "/navigation/ede7e2b6d13a41ddf9f4bdef84fdc737" "/navigation/83fa5a432ae55c253d0e60dbfa716723" "/navigation/4ca82b2a861f70cd15d83085b000dbde" "/navigation/c4ca4238a0b923820dcc509a6f75849b" "/navigation/4ffce04d92a4d6cb21c1494cdfcd6dc1" "/navigation/d3696cfb815ab692407d9362e6f06c28" "/navigation/b6a8cdd64382383f29fac327a8292096" "/navigation/10ffbba2ec9025b945acc154f3403aec" "/navigation/2e855f9489df0712b4bd8ea9e2848c5a" "/navigation/4a64d913220fca4c33c140c6952688a8" "/navigation/a6e8ad49045f0bef72fb92d7c4a97fed" "/navigation/c731077c04035ac9e92a3706288db18f" "/navigation/cc06a6150b92e17dd3076a0f0f9d2af4" "/navigation/2838023a778dfaecdc212708f721b788" "/navigation/4b0091f82f50ff7095647fe893580d60" "/navigation/85422afb467e9456013a2a51d4dff702" "/navigation/23685a2431acad7789c1e3d43ea1522c" "/navigation/4edb2dc80889b1aec708ec4730f22387" "/navigation/caaa29eab72b231b0af62fbdff89bfce" "/navigation/e0f120eefd76be864f36ffa8d1a1505a" "/navigation/20f79a5fa90c0796d2cfdbe8763dfb67" "/navigation/4ac778418206cc85ac960d5b9134bf74" "/navigation/64de166633d61c8326232568b42beef1" "/navigation/052335232b11864986bb2fa20fa38748" "/navigation/44e76e99b5e194377e955b13fb12f630" "/navigation/1abf005ea3f957c5cb79941ab7707c11" "/navigation/676b58765ad419a5b7af6a959d4de341" "/navigation/7d0a9bd083154d3d7f429550f7e8fd57" "/navigation/0a0a0c8aaa00ade50f74a3f0ca981ed7" "/navigation/3948ead63a9f2944218de038d8934305" "/navigation/81e5f81db77c596492e6f1a5a792ed53" "/navigation/88c040adb393832c87914347cc2afc3f" "/navigation/51a472c08e21aef54ed749806e3e6490" "/navigation/30d4e6422cd65c7913bc9ce62e078b79" "/navigation/ccb1d45fb76f7c5a0bf619f979c6cf36" "/navigation/77d2afcb31f6493e350fca61764efb9a" "/navigation/d87c68a56bc8eb803b44f25abb627786" "/navigation/a41b3bb3e6b050b6c9067c67f663b915" "/navigation/076a8133735eb5d7552dc195b125a454" "/navigation/99f0e91e4f90ecc1c3bdee598eadca30" "/navigation/bea6cfd50b4f5e3c735a972cf0eb8450" "/navigation/35bf98501edec1431e0c2fabe948da66" "/navigation/b7da6669894867f04b8727876a69ffc0" "/navigation/0a93091da5efb0d9d5649e7f6b2ad9d7" "/navigation/a73d2d60ed472454a0360027aa039bdb" "/navigation/fe2b421b8b5f0e7c355ace66a9fe0206" "/navigation/60cb558c40e4f18479664069d9642d5a" "/navigation/e5e580bb7e6f5e01ecf1be2c21a834e7" "/navigation/854f1fb6f65734d9e49f708d6cd84ad6" "/navigation/b16574c54c98b9512edbecb8fa4f47f2" "/navigation/260c2432a0eecc28ce03c10dadc078a4" "/navigation/a98a009d68cad18ae7b1d3576bb01924" "/navigation/e7a561a2f218bf9cc0e697598320ec59" "/navigation/cfe8504bda37b575c70ee1a8276f3486" "/navigation/ad62cfd33e3870262d6bf5331c1f13b0" "/navigation/9c16f6606460d1543759fc966b9bb797" "/navigation/6a130f1dc6f0c829f874e92e5458dced" "/navigation/25caef3a545a1fff2ff4055484f0e758" "/navigation/c6102b3727b2a7d8b1bb6981147081ef" "/navigation/06fb3cba82080bf8f3721739019d6792" "/navigation/338635ee18f8b0f626818a216642c9a4" "/navigation/575afbdca5a101e3088b2b6554398b0c" "/navigation/b543376b5721da011b230ba7ae9dd619" "/navigation/11f38f8ecd71867b42433548d1078e38" "/navigation/04b001a2057812f735cbcab76fd44e11" "/navigation/4c525a48acc0084b077750ac333c67c1" "/navigation/c7c46d4baf816bfb07c7f3bf96d88544" "/navigation/933596b8ed665b3c5c6ed32079b2d20e" "/navigation/7f3fcfed9109f27a4b9e4abd169d6e43" "/navigation/d4df7b6239c425d8cc897411ef11abe7" "/navigation/bf4d73f316737b26f1e860da0ea63ec8" "/navigation/019e1c530913733b861d9a23eafe3d8e" "/navigation/dc91d6e23d859879bbaf0a9d7f27fb77" "/navigation/019e1c52f54079d2b2b1abcea24905c6" "/navigation/c9bc734c0663a142b7bec265098f8dbf" "/navigation/f7fa6aca028e7ff4ef62d75ed025fe76" "/navigation/9cd013fe250ebffc853b386569ab18c0" "/navigation/de4d0312514a1d471f10ea909a589a32" "/navigation/310366dd6f1a67639b870efe6ca3613d" "/navigation/341cd40532980c4909c8c647f2138c03" "/navigation/2e4fb1ddb61e8e45740ed0415f2b28b0" "/navigation/0dd6049f5fa537d41753be6d37859430" "/navigation/83decbc20d665926df9335a0a3be7e3b" "/navigation/4e38d30e656da5ae9d3a425109ce9e04" "/navigation/11704817e347269b7254e744b5e22dac" "/navigation/e2a7555f7cabd6e31aef45cb8cda4999" "/navigation/e6be4c22a5963ab00dfe8f3b695b5332" "/navigation/572201a4497b0b9f02d4f279b09ec30d" "/navigation/575425a3f433138553be468c9d1ecba7" "/navigation/e77910ebb93b511588557806310f78f1" "/navigation/58b4095fb5335282cc3fde57c643da38" "/navigation/95f2b84de5660ddf45c8a34933a2e66f" "/navigation/b4d6f2b565ca0eef1f9245403aac366a" "/navigation/2ec0274c1774841e6820ad9339b81dbf" "/navigation/d128a9569b806e3a93c91293aed3f40b" "/navigation/4d0505284ac5049b4167eb7ebfe0791b" "/navigation/19d47109e3c9e2c1423eac228aff27d1" "/navigation/398024cb5e21d749d728926a28b19d00" "/navigation/c1bb2ec7a913e32a2d05cacf3b83cd1b" "/navigation/22cdb13a83f73ccd1f79ffaf607b0621" "/navigation/b14573b9273c38ba0f89bb63abc87973" "/navigation/eea5d933e9dce59c7dd0f6532f9ea81b" "/navigation/de8aa43e5d5fa8536cf23e54244476fa" "/navigation/7caf5e22ea3eb8175ab518429c8589a4" "/navigation/94739e5a5164b4d2396e253a11d57044" "/navigation/5c341d10c5596a0fd920fda9f33bcb06" "/navigation/229aeb9e2ae66f2fac1149e5240b2fdd" "/navigation/a667f4e7b0c8a3babe331569d3eac6bd" "/navigation/2c89109d42178de8a367c0228f169bf8" "/navigation/626fbe83f8c7f2670b90a773b6dbf17c" "/navigation/ff42b03a06a1bed4e936f0e04958e168" "/navigation/28a74b8d7de3373b4bed858fc10b6bf5" "/navigation/0e16366727185813f59d4a9467878901" "/navigation/27d52bcb3580724eb4cbe9f2718a9365" "/navigation/3e98410c45ea98addec555019bbae8eb" "/navigation/00482b9bed15a272730fcb590ffebddd" "/navigation/bc3c4a6331a8a9950945a1aa8c95ab8a" "/navigation/d9fbed9da256e344c1fa46bb46c34c5f" "/navigation/4f00921114932db3f8662a41b44ee68f" "/navigation/74627b65e6e6a4c21e06809b8e02114a" "/navigation/12f73080e04ce0d8e95defb577ebc3f4" "/navigation/75a7c30fc0063c4952d7eb044a3c0897" "/navigation/e5abba84b1901e99f9c45845f488843e" "/navigation/4fa04fbc0b0ce68711f7550ce6113720" "/navigation/bcff3f632fd16ff099a49c2f0932b47a" "/navigation/6cb5da3513bd26085ee3fad631ebb37a" "/navigation/019e6dbab4aa7d9388879a879c77adb4" "/navigation/019e68115cc971ce92005faa5d80b921" "/navigation/019e6dc7aa467af483c4890421c0a2c4" "/navigation/019e6e4cb6dd7d25adf349d7a384d18c" "/navigation/019e731a5bb47693848b0d8b512d93e5" "/navigation/019e7326ae477f4fa4d729722b58f96e" "/navigation/5a0c828364dbf6dd406139dab7b25398" "/navigation/96e07156db854ca7b00b5df21716b0c6" "/navigation/8eefcfdf5990e441f0fb6f3fad709e21" "/navigation/fe60c129a74980578dc8fb0f8fe39b39" "/navigation/4e246a381baf2ce038b3b0f82c7d6fb4" "/navigation/be26abe76fb5c8a4921cf9d3e865b454" "/navigation/6869efe03b7fbef3b001dc15804bc826" "/navigation/0fcbc61acd0479dc77e3cccc0f5ffca7" "/navigation/34f98c7c5d7063181da890ea8d25265a" "/navigation/9a1158154dfa42caddbd0694a4e9bdc8" "/navigation/6069cecf34adb1d6db60007da39e2ee8" "/navigation/312f1ba2a72318edaaa995a67835fad5" "/navigation/26901debb30ea03f0aa833c9de6b81e9" "/navigation/479f499df3bbc0deda265b92316d362f" "/navigation/340b706fb4f5035f33fcfa07fbbaf411" "/navigation/66f041e16a60928b05a7e228a89c3799" "/navigation/35f4a8d465e6e1edc05f3d8ab658c551" "/navigation/42dab56861d81108ee356d037190c315" "/navigation/588fdfa645b7f3c260188494bcafa149" "/navigation/02052c0f4599c2aa6bead905338f1214" "/navigation/68264bdb65b97eeae6788aa3348e553c" "/navigation/019d2e764a047035a3c759855b18661b" "/navigation/1e7875cf32d306989d80c14308f3a099" "/navigation/019d2e7daf2876399ec6e5b920f0f4c5" "/navigation/019d2e86558e7d72b5e93d7bb8dea550" "/navigation/019d2e80ea27767fb8d8cb85421e6f25" "/navigation/019d2e537b277047bd1126931c524d99" "/navigation/019d2e82aefe7a54a23f46d64768f0b4" "/navigation/f490d0af974fedf90cb0f1edce8e3dd5" "/navigation/019d2e7b5eb071a9be2a815707ff7e52" "/navigation/afa299a4d1d8c52e75dd8a24c3ce534f" "/navigation/455cb2657aaa59e32fad80cb0b65b9dc" "/navigation/7bb16972da003e87724f048d76b7e0e1" "/navigation/94ef7214c4a90790186e255304f8fd1f" "/navigation/efb3d8be0319721ef751da0b05d9f6a5" "/navigation/77bb14f6132ea06dea456584b7d5581e" "/navigation/febb7aafcbde43930cdedf8c5153c867" "/navigation/8b0d268963dd0cfb808aac48a549829f" "/navigation/bb6b07f0fd4afe38c61f232bbb693fd7" "/navigation/83e8ef518174e1eb6be4a0778d050c9d" "/navigation/019e6870d7407a24a225b064b4d07cd0" "/navigation/092cb13c22d51c22b9035a2b4fe76b00" "/navigation/ad9d4d2bc5365e856dcb6d78fb0c7cb5" "/navigation/b670dfc593340027581047db105f3347" "/navigation/df9028fcb6b065e000ffe8a4f03eeb38" "/navigation/659b7b42e9c002ce0075077cd55a1623" "/navigation/12e1b435e5e53888e787d22c1e8d262d" "/navigation/e93f31bd97b60ca8a84677546051539c" "/navigation/39e98420b5e98bfbdc8a619bef7b8f61" "/navigation/f0a5944c6a815b7bb44323d783eede4d" "/navigation/1f8f69b53d86cf2a952bf95d87a59b0c" "/navigation/7ef2f13f0e9d3478d7c36f6483d38a86" "/navigation/db8419f41d890df802dca330e6284952" "/navigation/be315e7f05e9f13629031915fe87ad44" "/navigation/29fdff891569187da8e5ed4f7a6ea4c8" "/navigation/96a4d89ba25627b2966703bae2947543" "/navigation/4c07fe24771249c343e70c32289c1192" "/navigation/c54d2118d6a3a2b06f07e9eeb240d741" "/navigation/0fcee95cc7b4f2067da8ba1e330de18e" "/navigation/62d081df1f0040acd58bcfd3c3040fc1" "/navigation/df1a336b7e0b0cb186de6e66800c43a9" "/navigation/95c3f1a8b262ec7a929a8739e21142d7" "/navigation/7fd4db88d31ab524e0afe153c4f9465a" "/navigation/0502a70eae9d62bed6cd32d7e1a0cb45" "/navigation/beb3c650aaae598375f60df2c6063269" "/navigation/df7ee89b6f8ec5827a19ecbaff5d4cd2" "/navigation/fa636c3d216834a2e0db24cc157ab5f0" "/navigation/77b917da760ab9aeca583fd0bb0e1c67" "/navigation/e37d015e5d80348a275284efacdb6db5" "/navigation/ac8a9143597891fc2fc2ded41a9a9ec7" "/navigation/a1d4c20b182ad7137ab3606f0e3fc8a4" "/navigation/95cc7ef498e141173576365264fc5fba" "/navigation/ebb87faa733d9a04ebb40f422b135fb0" "/navigation/55b34fd73727d9b19698835c7d5302ae" "/navigation/e0a0a422a9069a4cb2b91211a451da4b" "/navigation/2b6d65b9a9445c4271ab9076ead5605a" "/navigation/6e96be832cf8bc6b35a956e8fb66c76a" "/navigation/ecb9fe2fbb99c31f567e9823e884dbec" "/navigation/478d04447429f265a85d7568b0a602b5" "/navigation/2ba2520186ee376e835ce7bf1554ef7b" "/navigation/2751fae77b24c37382cf6464173d145e" "/navigation/161882dd2d19c716819081aee2c08b98" "/navigation/fc5dda17bef960b7c200e7d8063142ec" "/navigation/f26ecc6e3bc7f5e9c8cf23a7c7a315dd" "/navigation/34ad9bc83e3c72c62281cb2c744ac966" "/navigation/31a6b5568bbb9c350c1b296d9086acf0" "/navigation/94c4dd41f9dddce696557d3717d98d82" "/navigation/c55430fdfdac11fc3771a9b94e2bb854" "/navigation/55ed523b2ca4371a31d7dbd7a2877bea" "/navigation/a957aa96221d0b7cb99ab072eaed7bf9" "/navigation/831c2f88a604a07ca94314b56a4921b8" "/navigation/2f52dc78dbbc843b19cf2f260b04812f" "/navigation/bf5cd8b2509011b9502a72296edc14a0" "/navigation/baf4f1a5938b8d520b328c13b51ccf11" "/navigation/0a552abf945aad2831a917bd58bbdc70" "/navigation/a6292668b36ef412fa3c4102d1311a62" "/navigation/b555f4a2901228cc826327079761e696" "/navigation/019d385eb67632a7e958e23f24bd07d7" "/navigation/69c7e73fea7ad35e9000ce41e1622036" "/navigation/5317b6799188715d5e00a638a4278901" "/navigation/5f6ecc9686eb1bff304bbda038c60c54" "/navigation/a322852ce0df73e204b7e67cbbef0d0a" "/navigation/4f7b884f2445ef08da9bbc77b028722c" "/navigation/2a8a8bde56a1a353f4e5fdd641f0b199" "/navigation/525b8410cc8612283c9ecaf9a319f8ed" "/navigation/83da7c539e1ab4e759623c38d8737e9e" "/navigation/176bf6219855a6eb1f3a30903e34b6fb" "/navigation/65ded5353c5ee48d0b7d48c591b8f430" "/navigation/28ce9bc954876829eeb56ff46da8e1ab" "/navigation/5637f327937ff2beb7d0a499a0b99d3c" "/navigation/f33ba15effa5c10e873bf3842afb46a6" "/navigation/74961657ae02e93fc17be9d9fc864620" "/navigation/287e041302f34b11ddfb57afc8048cd8" "/navigation/803a82dee7e3fbb3438a149508484250" "/navigation/41e7637e7b6a9f27a98b84d3a185c7c0" "/navigation/29e11dc359bad383e1243f730bdbe032" "/navigation/ac73001b1d44f4925449ce09d9f5d5ca" "/navigation/0496604c1d80f66fbeb963c12e570a26" "/navigation/174b39525e01b7542b3ee27ac7251d2c" "/navigation/791d3a0048b9c200dceca07f99ddd178" "/navigation/46384036044a604b6b3316fc167fc15f" "/navigation/4b2944dfea61be814911110c21ddd974" "/navigation/6e187996e9cc9d93c5f4452695768290" "/navigation/299dc35e747eb77177d9cea10a802da2" "/navigation/65184321c340b4d56581ee59b58d9d56" "/navigation/62161512d8b1b5db826778917e974b21" "/navigation/451ae86722d26a608c2e174b2b2773f1" "/navigation/2051bd70fc110a2208bdbd4a743e7f79" "/navigation/b45232282ea62bfccffbd5350317e7e2" "/navigation/16bb35ba24bac33d95ee9f1f65a41b53" "/navigation/427357dfbc5cc1967afeef00b8e6ec80" "/navigation/45ab12afa05e563bb484781693dffc87" "/navigation/a5bfc9e07964f8dddeb95fc584cd965d" "/navigation/606555cf42a6719782a952aa33cfa2cb" "/navigation/8767bccb1ff4231a9962e3914f4f1f8f" "/navigation/32bbf7b2bc4ed14eb1e9c2580056a989" "/navigation/a569398d13eb87b14276380d2921ddbc" "/navigation/ed77eab0b8ff85d0a6a8365df1846978" "/navigation/ab9ebd57177b5106ad7879f0896685d4" "/navigation/708be71b9ab6e0a84252760579ade9f1" "/navigation/4d702022947b6fed64518d0d7cfc692d" "/navigation/8b2dfbe0c1d43f9537dae01e96458ff1" "/navigation/1e4268fd66e5999df71142c71a4e212f" "/navigation/76383b34503afb0508f8364787c55800" "/navigation/15756c350dae3457b2718a29dc0018cb" "/navigation/5e9fb672ee46be628a141b594d7c6f3e" "/navigation/f1de5100906f31712aaa5166689bfdf4" "/navigation/f1b8b7b3ceb65c188dcdc0851634cadf" "/navigation/53edebc543333dfbf7c5933af792c9c4" "/navigation/9cd78264cf2cd821ba651485c111a29a" "/navigation/8a1276c25f5efe85f0fc4020fbf5b4f8" "/navigation/15f28fbc8c6e099a1e98b8a555d72374" "/navigation/e474e8520850a6f3d13f268666736f33" "/navigation/83715fd4755b33f9c3958e1a9ee221e1" "/navigation/7ea25c95b0792ca4ce01ea18bbda2d44" "/navigation/abdf6bdb7570e8f9d4338f84bd169130" "/navigation/876e8108f87eb61877c6263228b67256" "/navigation/5d50d22735a7469266aab23fd8aeb536" "/navigation/82c2559140b95ccda9c6ca4a8b981f1e" "/navigation/f19ec2b84181033bf4753a5a51d5d608" "/navigation/e32cc80bf07915058ce90722ee17bb71" "/navigation/8471bda5e6201d30893c3582ee131d4d" "/navigation/d4ea5dacfff2d8a35c0952291779290d" "/navigation/191f8f858acda435ae0daf994e2a72c2" "/navigation/9c805dcddc7db4e825949f20601fc73b" "/navigation/84b64e537f08e81b8dea8cce972a28b2" "/navigation/5d7009220a974e94404889274d3a9553" "/navigation/2172fde49301047270b2897085e4319d" "/navigation/0db2e204010400f5c506620adcd1ae68" "/navigation/9c779f56f336b3c812343434f57b6a0e" "/navigation/b20706935de35bbe643733f856d9e5d6" "/navigation/a58616464d14208b2677a084f5d7456f" "/navigation/4d0b954f0bef437c29dfa73fafdf3fa5" "/navigation/325995af77a0e8b06d1204a171010b3a" "/navigation/ba038e2a20ded4a1d146841e6ed42f22" "/navigation/9b89bedda1fc8a2d88c448e361194f02" "/navigation/349f36aa789af083b8e26839bd498af9" "/navigation/a992995ef4f0439b258f2360dbb85511" "/navigation/4324e8d0d37b110ee1a4f1633ac52df5" "/navigation/8bd2c3f7fd5b165b470beb1cc83071ab" "/navigation/1cbcaa5abbb6b70f378a3a03d0c26386" "/navigation/9fa83fec3cf3810e5680ed45f7124dce" "/navigation/7edcfb2d8f6a659ef4cd1e6c9b6d7079" "/navigation/555183669058fb273008595a9393d628" "/navigation/7d771e0e8f3633ab54856925ecdefc5d" "/navigation/ae502204564aafbffb712be630e3910b" "/navigation/23ef5cf238a3b88085d95adf94c24a25" "/navigation/77143919d1234297079f075357988f3b" "/navigation/52130c418d4f02c74f74a5bc1f8020b2" "/navigation/14b7367a28377d4d513a4d3349861d2f" "/navigation/a33f5792b2a9a51ddd0111b3ac6e0e76" "/navigation/af94ed0d6f5acc95f97170e3685f16c0" "/navigation/154ff8944e6eac05d0675c95b5b8889d" "/navigation/6120d42c7249acb7b2cfcf020bf7ab75" "/navigation/e7532dbeff7ef901f2e70daacb3f452d" "/navigation/1454ca2270599546dfcd2a3700e4d2f1" "/navigation/95b431e51fc53692913da5263c214162" "/navigation/e2a08f2ebe0d5593fdb22010cd00c7c2" "/navigation/79f69230354b71206fb723c571cce58b" "/navigation/63c17d596f401acb520efe4a2a7a01ee" "/navigation/bd380c81db012b113b6ab112b847e52b" "/navigation/7a6a74cbe87bc60030a4bd041dd47b78" "/navigation/77c67132097f9b1ff028aed0eca8d21b" "/navigation/8b9e7ab295e87570551db122a04c6f7c" "/navigation/52fc2aee802efbad698503d28ebd3a1f" "/navigation/fb0650ff38f84d526883336ff5119dc0" "/navigation/048e2f1447691907b18b2a37e7ed2322" "/navigation/d2cd33e9c0236a8c2d8bd3fa91ad3acf" "/navigation/fc528592c3858f90196fbfacc814f235" "/navigation/07f75d9144912970de5a09f5a305e10c" "/navigation/39cd7b469beae7c617c73e0d008195ef" "/navigation/297fa7777981f402dbba17e9f29e292d" "/navigation/cef1b938860dd6718de5eaae697b60e5" "/navigation/77b830096c1888016b4d7a730bbe9731" "/navigation/74c407e263578d03d02c1123aa730b52" "/navigation/9fe77ac7060e716f2d42631d156825c0" "/navigation/def7924e3199be5e18060bb3e1d547a7" "/navigation/97108695bd93b6be52fa0334874c8722" "/navigation/1301962d8b7bd03fffaa27119aa7fc2b" "/navigation/f7b027d45fd7484f6d0833823b98907e" "/navigation/bb921944c8c4531826da3fa99b494c1a" "/navigation/33b879e7ab79f56af1e88359f9314a10" "/navigation/96c974552b3f2839fcc751e7f12679ce" "/navigation/30d411fdc0e6daf092a74354094359bb" "/navigation/a4814fbe4abdad91842ef1795dcd465b" "/navigation/0cd6a652ed1f7811192db1f700c8f0e7" "/navigation/50f3f8c42b998a48057e9d33f4144b8b" "/navigation/159c1ffe5b61b41b3c4d8f4c2150f6c4" "/navigation/e3ea33961a7c5b1ec04d6c97aa3b5379" "/navigation/69d658d0b2859e32cd4dc3b970c8496c" "/navigation/e6051b3bfe716cc4a38c2f39ec199873" "/navigation/dcacff2565700c8f88f59cf4a16f9dfc" "/navigation/50adecfc746426ca10973a067421d0bf" "/navigation/365d17770080c807a0e47ae9118d8641" "/navigation/82161242827b703e6acf9c726942a1e4" "/navigation/991327d63593b0ba2c45618bf81f6a64" "/navigation/1597d21403f63da1bb0539592597a525" "/navigation/250dd56814ad7c50971ee4020519c6f5" "/navigation/98cac9d33aad44bb31800130e8c50b5f" "/navigation/165a59f7cf3b5c4396ba65953d679f17" "/navigation/ef48e3ef07e359006f7869b04fa07f5e" "/navigation/02f657d55eaf1c4840ce8d66fcdaf90c" "/navigation/f60bb6bb4c96d4df93c51bd69dcc15a0" "/navigation/c5bbd980e5ab2c17413ec02bd757a9e5" "/navigation/1fb36c4ccf88f7e67ead155496f02338" "/navigation/0987b8b338d6c90bbedd8631bc499221" "/navigation/a981f2b708044d6fb4a71a1463242520" "/navigation/de7f47e09c8e05e6021ababdf6bc58e7" "/navigation/962e56a8a0b0420d87272a682bfd1e53" "/navigation/0e7e05fa1026b0c5459267608ae320b8" "/navigation/cb16b8498f74ba6b6a6873518624168c" "/navigation/13e36f06c66134ad65f532e90d898545" "/navigation/298f587406c914fad5373bb689300433" "/navigation/13d63838ef1fb6f34ca2dc6821c60e49" "/navigation/7fc63ff01769c4fa7d9279e97e307829" "/navigation/9edda0fd4d983bf975935cfd492fd50b" "/navigation/348a38cd25abeab0e440f37510e9b1fa" "/navigation/70fc5f043205720a49d973d280eb83e7" "/navigation/d1dc3a8270a6f9394f88847d7f0050cf" "/navigation/56503192b14190d3826780d47c0d3bf3" "/navigation/7e8d7e5ccbddfd9576be61e3ab86aa73" "/navigation/d8c24ca8f23c562a5600876ca2a550ce" "/navigation/c56a022b15250525f8b9bdfc41a13152" "/navigation/e36286b94d3c219f414e0427e5f73aa5" "/navigation/703957b6dd9e3a7980e040bee50ded65" "/navigation/d2dc6368837861b42020ee72b0896182" "/navigation/03e4d3f831100d4355663f3d425d716b" "/navigation/cd6b73b67c77edeaff94e24b961119dd" "/navigation/0424d20160a6a558e5bf86a7bc9b67f0" "/navigation/670c26185a3783678135b4697f7dbd1a" "/navigation/ecd1b059424d5e0056f579a391d1ead9" "/navigation/022898bbc7110244fd24b3e410597047" "/navigation/ec04e8ebba7e132043e5b4832e54f070" "/navigation/02d72b702eed900577b953ef7a9c1182" "/navigation/82f5e54d8e425cf93af25e86b4be04f8" "/navigation/4a308d84cdd04aa2015bbe13622d5d7c" "/navigation/8e5231f0eadafd174b670e838e42d97d" "/navigation/586ee5cb5f17541372cdd7d54b6414d7" "/navigation/460b491b917d4185ed1f5be97229721a" "/navigation/d6525aa8638c1d8d4da535fbb1a5fc80" "/navigation/db98dc0dbafde48e8f74c0de001d35e4" "/navigation/71a58e8cb75904f24cde464161c3e766" "/navigation/664dd858db942cad06f24ff25df56716" "/navigation/4462bf0ddbe0d0da40e1e828ebebeb11" "/navigation/46d3f6029f6170ebccb28945964d09bf" "/navigation/ec36e2ba64f11c9e910e0353e0836d81" "/navigation/aba53da2f6340a8b89dc96d09d0d0430" "/navigation/679d8bbd776e0bbf3b044306c5be94ae" "/navigation/c7af0926b294e47e52e46cfebe173f20" "/navigation/48c8c3963853fff20bd9e8bee9bd4c07" "/navigation/6e17a5fd135fcaf4b49f2860c2474c7c" "/navigation/d3802b1dc0d80d8a3c8ccc6ccc068e7c" "/navigation/8d9766a69b764fefc12f56739424d136" "/navigation/859b00aec8885efc83d1541b52a1220d" "/navigation/a36b598abb934e4528412e5a2127b931" "/navigation/8a1ee9f2b7abe6e88d1a479ab6a42c5e" "/navigation/82b0639a82d0cc70b8f5830fd2b06868" "/navigation/f356355c1634839cf42769e7f30905a3" "/navigation/66121d1f782d29b62a286909165517bc" "/navigation/672cf3025399742b1a047c8dc6b1e992" "/navigation/cd8d5260c8131ca7aeea5d41796d1a0a" "/navigation/fa1e9c965314ccd7810fb5ea838303e5" "/navigation/b49fdab097253cac48e3dc628a49da5e" "/navigation/d736bb10d83a904aefc1d6ce93dc54b8" "/navigation/42d6c7d61481d1c21bd1635f59edae05" "/navigation/81c2f886f91e18fe16d6f4e865877cb6" "/navigation/9f36407ead0629fc166f14dde7970f68" "/navigation/825f9cd5f0390bc77c1fed3c94885c87" "/navigation/12b1e42dc0746f22cf361267de07073f" "/navigation/ca0daec69b5adc880fb464895726dbdf" "/navigation/d8bf84be3800d12f74d8b05e9b89836f" "/navigation/d51b416788b6ee70eb0c381c06efc9f1" "/navigation/bb1662b7c5f22a0f905fd59e718ca05e" "/navigation/f565bb9efccaf6986443db0bf01018bc" "/navigation/06c284d3f757b15c02f47f3ff06dc275" "/navigation/30f8f6b940d1073d8b6a5eebc46dd6e5" "/navigation/169779d3852b32ce8b1a1724dbf5217d" "/navigation/b440509a0106086a67bc2ea9df0a1dab" "/navigation/109d2dd3608f669ca17920c511c2a41e" "/navigation/3a1dd98341fafc1dfe9bcf36360e6b84" "/navigation/b6e32320fa6bc5a588b90183b95dc028" "/navigation/1a3f91fead97497b1a96d6104ad339f6" "/navigation/8c00dee24c9878fea090ed070b44f1ab" "/navigation/cdf1e288ca02272e717c9d5e4cb180bd" "/navigation/dbd90a665ea6f292f36ebdb3d442826d" "/navigation/635440afdfc39fe37995fed127d7df4f" "/navigation/04048aeca2c0f5d84639358008ed2ae7" "/navigation/ddd9dda6bfaf0bb1525a8a27c3ee6131" "/navigation/71f07bf95f0113eefab12552181dd832" "/navigation/573eec40e4ef4f2089531dd5cbf629f8" "/navigation/c0f971d8cd24364f2029fcb9ac7b71f5" "/navigation/cf011ff8d8380280133bce806e0f7bb1" "/navigation/f6185f0ef02dcaec414a3171cd01c697" "/navigation/dc2b690516158a874dd8aabe1365c6a0" "/navigation/030e65da2b1c944090548d36b244b28d" "/navigation/110eec23201d80e40d0c4a48954e2ff5" "/navigation/9dc372713683fd865d366d5d9ee810ba" "/navigation/dbbf603ff0e99629dda5d75b6f75f966" "/navigation/01b6397888c09d84f3dc89d807aa1004" "/navigation/b38e5ff5f816ac6e4169bce9314b2996" "/navigation/52aaa62e71f829d41d74892a18a11d59" "/navigation/321cf86b4c9f5ddd04881a44067c2a5a" "/navigation/8dc5983b8c4ef1d8fcd5f325f9a65511" "/navigation/1175defd049d3301e047ce50d93e9c7a" "/navigation/14ea0d5b0cf49525d1866cb1e95ada5d" "/navigation/6aed000af86a084f9cb0264161e29dd3" "/navigation/30d454f09b771b9f65e3eaf6e00fa7bd" "/navigation/466accbac9a66b805ba50e42ad715740" "/navigation/75e33da9b103b7b91dcd8da0abe1354b" "/navigation/339a18def9898dd60a634b2ad8fbbd58" "/navigation/a3d06db1f8c85b2837b4603a51834425" "/navigation/c4f796afbc6267501964b46427b3f6ba" "/navigation/eddb904a6db773755d2857aacadb1cb0" "/navigation/64a08e5f1e6c39faeb90108c430eb120" "/navigation/1006ff12c465532f8c574aeaa4461b16" "/navigation/fb4ab556bc42d6f0ee0f9e24ec4d1af0" "/navigation/f12ee9734e1edf70ed02d9829018b3d9" "/navigation/2056d8c1dec3d12cbce646b348d189d1" "/navigation/1e44fdf9c44d7328fecc02d677ed704d" "/navigation/161c5c5ad51fcc884157890511b3c8b0" "/navigation/760abe2f7ea403a5c8ac329f72e4d42e" "/navigation/2c29d89cc56cdb191c60db2f0bae796b" "/navigation/bb836c01cdc9120a9c984c525e4b1a4a" "/navigation/b665bf733325cebbccee5935b1272616" "/navigation/a45a1d12ee0fb7f1f872ab91da18f899" "/navigation/7cb1f2f2baf6ab2ae929ad8cb88d6210" "/navigation/6e3b0bf8b7d5956ae572b15cd7ddb0e1" "/navigation/7ed2d3454c5eea71148b11d0c25104ff" "/navigation/28dd2c7955ce926456240b2ff0100bde" "/navigation/5648d7fb4f1ea9a69fd10fccacd7d007" "/navigation/0aca829c00e4fe15c9523e665f681643" "/navigation/a02ffd91ece5e7efeb46db8f10a74059" "/navigation/50285433069b9faf53c900cd2642fa9d" "/navigation/c92383002f757cddd52df84e68894b5e" "/navigation/abebb7c39f4b5e46bbcfab2b565ef32b" "/navigation/3a37abdeefe1dab1b30f7c5c7e581b93" "/navigation/9b1c93a6864c39e48417ee486b83c387" "/navigation/d0cffa36e832b65fe145a6e9360bda83" "/navigation/ef1f4d925a67ffc924862f69f6bb120b" "/navigation/db5f9f42a7157abe65bb145000b5871a" "/navigation/03fcd68e5673f08be96d2b6bb5be8261" "/navigation/bd3ef5c19067fe179f71c8b86ea4b39b" "/navigation/46c7cb50b373877fb2f8d5c4517bb969" "/navigation/0da54aa0b1ee702d0c45af548b1a54c7" "/navigation/f3be5eb7ff15f2013a3b65fbca4bf864" "/navigation/07d2c6fd5472b9796184e152bd92a535" "/navigation/de5eeca522e12fd5c9ff9077408dcf17" "/navigation/f065d878ccfb4cc4f4265a4ff8bafa9a" "/navigation/0fd600c953cde8121262e322ef09f70e" "/navigation/3dcaf04c357c577a857f3ffadc555f9b" "/navigation/cbf4d310ea68b3933521ba359d33ed5e" "/navigation/18de4beb01f6a17b6e1dfb9813ba6045" "/navigation/ba3c5fe1d6d6708b5bffaeb6942b7e04" "/navigation/2b52541089a553056a5558611365cc6a" "/navigation/36dcd524971019336af02550264b8a08" "/navigation/03793ef7d06ffd63d34ade9d091f1ced" "/navigation/6c90885b28e58d1f44856d787da2078f" "/navigation/81448138f5f163ccdba4acc69819f280" "/navigation/c6862d63b17d713ee14f3a405d9fde77" "/navigation/9f16b57bdd4400066a83cd8eaa151c41" "/navigation/5a570102ff1655264e06f782078b5af0" "/navigation/7792a0500b5aabb4b072d113a160d200" "/navigation/d20f6cbf98b2efd688d5e33c2920b586" "/navigation/2e6d9c6052e99fcdfa61d9b9da273ca2" "/navigation/45c48cce2e2d7fbdea1afc51c7c6ad26" "/navigation/3416a75f4cea9109507cacd8e2f2aefc" "/navigation/eba237eccc24353ccaa4d62013556ac6" "/navigation/f0f254331b4693742ea6cc1379b84e73" "/navigation/d19a006fd6d25d23c93d3bf4e48eb25f" "/navigation/30c8e1ca872524fbf7ea5c519ca397ee" "/navigation/21c3134ee5edcb618c4f9aae358d73a7" "/navigation/b5507f51b88a3ae4a99ba87e4877ab57" "/navigation/62ac9cd1eac1b6b1d204d458ee016173" "/navigation/9fe8593a8a330607d76796b35c64c600" "/navigation/169be908d18ff83896292dd6de0df58c" "/navigation/1963bd5135521d623f6c29e6b1174975" "/navigation/743c41a921516b04afde48bb48e28ce6" "/navigation/0c95054981de037de06e544a52eb3613" "/navigation/7e185cc0ad0a719c730af5354d7142c1" "/navigation/0c5534f554a26f7aeb7c780e12bb1525" "/navigation/8f14e45fceea167a5a36dedd4bea2543" "/navigation/ad554d8c3b06d6b97ee76a2448bd7913" "/navigation/1b90614883e606d5621b45c14f4f2963" "/navigation/b7ab1aac36b6428d3b7a3860a0d7a74f" "/navigation/ad067202f83b4b1483f05bf382c22c1e" "/navigation/bf1b2f4b901c21a1d8645018ea9aeb05" "/navigation/6a783b626a6d892a132dc195e5504272" "/navigation/5726daf2c9ee0f955eca58291c26d2f3" "/navigation/dffbb6efd376d8dbb22cdf491e481edc" "/navigation/50982fb2f2cfa186d335310461dfa2be" "/navigation/59587bffec1c7846f3e34230141556ae" "/navigation/0b7e926154c1274e8b602ff0d7c133d7" "/navigation/602443a3d6907117d8b4a308844e963e" "/navigation/38faae069a1371784081ea9ad9b279d0" "/navigation/1e8a19426224ca89e83cef47f1e7f53b" "/navigation/f29e2360ef277f77595dfae0aab78138" "/navigation/de58bfe3d33dada41a9398c30e21eeed" "/navigation/e42ad93f7491f2a38ba2ec1416ef6f55" "/navigation/c9f0f895fb98ab9159f51fd0297e236d" "/navigation/5300ef422e613b74fbf759d293aaab6a" "/navigation/ad185a320a9c8af2e25d53ef7cbacd4f" "/navigation/185c29dc24325934ee377cfda20e414c" "/navigation/3546ab441e56fa333f8b44b610d95691" "/navigation/da0dba87d95286d836e37ca60ab1e734" "/navigation/4a1c2f4dcf2bf76b6b278ae40875d536" "/navigation/ba0a4d6ecea3e9e126dd3b6d77291c97" "/navigation/b6f97e6f0fd175613910d613d574d0cb" "/navigation/bd7db7397f7d83052f829816ecc7f004" "/navigation/5c3a3b139a11689e0bc55abd95e20e39" "/navigation/92b70a527191ca64ca2df1cc32142646" "/navigation/d8e1344e27a5b08cdfd5d027d9b8d6de" "/navigation/937936029af671cf479fa893db91cbdd" "/navigation/b73dfe25b4b8714c029b37a6ad3006fa" "/navigation/83a100ec3c2c30751156cea2d60aacbe" "/navigation/8fe04df45a22b63156ebabbb064fcd5e" "/navigation/85fc37b18c57097425b52fc7afbb6969" "/navigation/f845cbb24a82dabdee971c6f7719f89d" "/navigation/abd815286ba1007abfbb8415b83ae2cf" "/navigation/9823c9091899dc6f227f9133ba2dfd30" "/navigation/84cb17743002b4cfb81b0153cee648fc" "/navigation/0ec04cb3912c4f08874dd03716f80df1" "/navigation/a0ba2648acd23dc7a5829968ce531a7d" "/navigation/14da15db887a4b50efe5c1bc66537089" "/navigation/ad8d3a0a0f0a084a97fad357c649438c" "/navigation/11e2ad6bf99300cd3808bb105b55d4b8" "/navigation/c3f4db3a634aa769c0f1161219272d03" "/navigation/f78688fb6a5507413ade54a230355acd" "/navigation/a18ad9f9bcd4e260979d102a260fc262" "/navigation/ad5ab36761669d6eadbaee691c4a1d22" "/navigation/1387a00f03b4b423e63127b08c261bdc" "/navigation/2f014b914ea5e7c04fc6cbde68d02141" "/navigation/2b763288faedb7707c0748abe015ab6c" "/navigation/d863d5ec458b0dc3b46cba96d9d49ac3" "/navigation/d139db6a236200b21cc7f752979132d0" "/navigation/0e915db6326b6fb6a3c56546980a8c93" "/navigation/b16e8712b35e498857df08af3944b127" "/navigation/ab73f542b6d60c4de151800b8abc0a6c" "/navigation/c1cdd433a18e3949d6e64b68564a7c0d" "/navigation/c96e651946818e0787d6296f69549fe1" "/navigation/41f860e3b7f548abc1f8b812059137bf" "/navigation/a2802cade04644083dcde1c8c483ed9a" "/navigation/37588c655ca22f7ca1664a2b211188ff" "/navigation/609e9d4bcc8157c00808993f612f1acd" "/navigation/8e50baf642bd6685e593bf238aa27051" "/navigation/d7e77c835af3d2a803c1cf28d60575bc" "/navigation/c4c42505a03f2e969b4c0a97ee9b34e7" "/navigation/9f810ebd27f4dbcf1ccc9302e5125f08" "/navigation/7c05147f3029c97ce26c0cb0b2469fca" "/navigation/a0d3973ad100ad83a64c304bb58677dd" "/navigation/8e19a39c36b8e5e3afd2a3b2692aea96" "/navigation/986648642d1a68a3178f6869689cc260" "/navigation/019cdde83c8b71d2bfb42c96037c1891" "/navigation/7a53928fa4dd31e82c6ef826f341daec" "/navigation/abd987257ff0eddc2bc6602538cb3c43" "/navigation/464d828b85b0bed98e80ade0a5c43b0f" "/navigation/87784eca6b0dea1dff92478fb786b401" "/navigation/b5d3ad899f70013367f24e0b1fa75944" "/navigation/fd2c5e4680d9a01dba3aada5ece22270" "/navigation/85f007f8c50dd25f5a45fca73cad64bd" "/navigation/f80bf05527157a8c2a7bb63b22f49aaa" "/navigation/448d5eda79895153938a8431919f4c9f" "/navigation/080c993fb3b58e26c1d2265bf9da0af3" "/navigation/d28d76b4592325c3bafc1840d4bb2957" "/navigation/fec87a37cdeec1c6ecf8181c0aa2d3bf" "/navigation/e025b6279c1b88d3ec0eca6fcb6e6280" "/navigation/10fe8dc69a0964edc16fed1a1bd55716" "/navigation/4738a8f6fab937d899ae9631beab116f" "/navigation/7c220a2091c26a7f5e9f1cfb099511e3" "/navigation/7b41bfa5085806dfa24b8c9de0ce567f" "/navigation/c4bfbf68f5d8d0f8b9a0752ca08ea01d" "/navigation/a4fa7175d4757e45eac71a8487751f63" "/navigation/c6ae9174774e254650073722e5b92a8f" "/navigation/6c97cd07663b099253bc569fe8d342bb" "/navigation/87ae6fb631f7c8a627e8e28785d9992d" "/navigation/5c3b99e8f92532e5ad1556e53ceea00c" "/navigation/e9ed9cad56c92652263953755852bedb" "/navigation/1fdc0ee9d95c71d73df82ac8f0721459" "/navigation/3de2334a314a7a72721f1f74a6cb4cee" "/navigation/aa495e18c7e3a21a4e48923b92048a61" "/navigation/19f6a8886908b80b8b6e9f212dbeea09" "/navigation/1feb4cdda5aafe2a48cbe27544cd8e4b" "/navigation/4f6312fa44a894eab0d022fce42592bf" "/navigation/56f0b515214a7ec9f08a4bbf9a56f7ba" "/navigation/08f0efebb1c51aada9430a089a2050cc" "/navigation/a894b83c9b7a00dba6c52cecf7a31fbb" "/navigation/bc6fe82635b1429d3e886eec0fc34f49" "/navigation/7576182d0a84b1ba2207f8f061d48bc9" "/navigation/1e4d36177d71bbb3558e43af9577d70e" "/navigation/4ea83d951990d8bf07a68ec3e50f9156" "/navigation/810dfbbebb17302018ae903e9cb7a483" "/navigation/fd9042c9b077fe393b18ae78feb58279" "/navigation/c5ef831f5d34faafc22a23a602cf6e40" "/navigation/06964dce9addb1c5cb5d6e3d9838f733" "/navigation/008bd5ad93b754d500338c253d9c1770" "/navigation/281683d0650eb208fa2138978a675665" "/navigation/29301521774ff3cbd26652b2d5c95996" "/navigation/4ccb2d64b8159636a44b29fe2e62a841" "/navigation/c8067ad1937f728f51288b3eb986afaa" "/navigation/571e0f7e2d992e738adff8b1bd43a521" "/navigation/4c8c76b39d294759a9000cbda3a6571a" "/navigation/df4fe8a8bcd5c95cdb640aa9793bb32b" "/navigation/f8037f94e53f17a2cc301033ca86d278" "/navigation/eaae339c4d89fc102edd9dbdb6a28915" "/navigation/7876acb66640bad41f1e1371ef30c180" "/navigation/cee8d6b7ce52554fd70354e37bbf44a2" "/navigation/868b7df964b1af24c8c0a9e43a330c6a" "/navigation/93129bca9fb2d3cb3470e2b9cfde7f63" "/navigation/39d6530ef19d55fc98e82cb3907519fa" "/navigation/6ffcc0d3641930e3d8980ec43343ccc5" "/navigation/798cebccb32617ad94123450fd137104" "/navigation/86e78499eeb33fb9cac16b7555b50767" "/navigation/61bdf049525b7d4c2cf79257ec7c2c56" "/navigation/d98c1545b7619bd99b817cb3169cdfde" "/navigation/251bd0442dfcc53b5a761e050f8022b8" "/navigation/d54e99a6c03704e95e6965532dec148b" "/navigation/6aca97005c68f1206823815f66102863" "/navigation/019cdded4b1577a3afc95cd412cd1231" "/navigation/019cddeb7a04720c9e4b028e7463e7e0" "/navigation/b7d35509ab19d0cd2256a219de0fe0ff" "/navigation/c5c64c10cfd77b16a03aa81f09499f25" "/navigation/3501672ebc68a5524629080e3ef60aef" "/navigation/215a71a12769b056c3c32e7299f1c5ed" "/navigation/e21e4e58ad9ab56e8a4634046da90113" "/navigation/33235e3d066bad95b6eea457826f7507" "/navigation/71969a804c28c0961383008958497b1b" "/navigation/f5a14d4963acf488e3a24780a84ac96c" "/navigation/0bf727e907c5fc9d5356f11e4c45d613" "/navigation/69783ee76a92567d446143b811519068" "/navigation/019cddf8471f728e959878b8aa863f19" "/navigation/ca851e9f71b25d2d588b7e0d4de3d627" "/navigation/73fed7fd472e502d8908794430511f4d" "/navigation/2f10c1578a0706e06b6d7db6f0b4a6af" "/navigation/ab4f2b5fd96ca65349119909c1eada2d" "/navigation/4eff0720836a198b6174eecf02cbfdbf" "/navigation/dfeb9598fbfb97cc6bbcc0aff2c785d6" "/navigation/735143e9ff8c47def504f1ba0442df98" "/navigation/173f0f6bb0ee97cf5098f73ee94029d4" "/navigation/2974788b53f73e7950e8aa49f3a306db" "/navigation/7a0c1035bcb33b6d86942ecbedb37267" "/navigation/b3b4d2dbedc99fe843fd3dedb02f086f" "/navigation/b2eeb7362ef83deff5c7813a67e14f0a" "/navigation/b710915795b9e9c02cf10d6d2bdb688c" "/navigation/b645e524a1512ce68947d3b9c948aa46" "/navigation/ee14c41e92ec5c97b54cf9b74e25bd99" "/navigation/9df81829c4ebc9c427b9afe0438dce5a" "/navigation/7a2b33c672ce223b2aa5789171ddde2f" "/navigation/82138b11a724b94d18df2e083d8b7b55" "/navigation/57c0531e13f40b91b3b0f1a30b529a1d" "/navigation/61b4a64be663682e8cb037d9719ad8cd" "/navigation/08c5433a60135c32e34f46a71175850c" "/navigation/73640de25b7d656733ce2f808a330f18" "/navigation/1a260649dac0ddb2290f609a13f4b814" "/navigation/019e1fd99485798d89164d9302ff5698" "/navigation/414e773d5b7e5c06d564f594bf6384d0" "/navigation/ccc81a97c1535f9a631b9db584a264e4" "/navigation/b7c0c7d6ce233d0fe18625ea3cd5bdb1" "/navigation/5a2b8fee6a50b5594ecc5041eed53650" "/navigation/2eace51d8f796d04991c831a07059758" "/navigation/885cb47f87718a2cd8641ae79113eeea" "/navigation/d1d5923fc822531bbfd9d87d4760914b" "/navigation/51fd081fb2f037078fc8a4e037daabe4" "/navigation/65b0df23fd2d449ae1e4b2d27151d73b" "/navigation/c80d9ba4852b67046bee487bcd9802c0" "/navigation/5bd529d5b07b647a8863cf71e98d651a" "/navigation/2a2107d1bcb556a30424faede85797a2" "/navigation/c73071b4520a9a82990741a84a2144eb" "/navigation/fc79250f8c5b804390e8da280b4cf06e" "/navigation/4d19b37a2c399deace9082d464930022" "/navigation/3a077e8acfc4a2b463c47f2125fdfac5" "/navigation/fb508ef074ee78a0e58c68be06d8a2eb" "/navigation/0197b2220cf870b1bc71746b875eeb41" "/navigation/08f90c1a417155361a5c4b8d297e0d78" "/navigation/c09f9caf5e08836d4673ccdd69bb041e" "/navigation/a591024321c5e2bdbd23ed35f0574dde" "/navigation/ea5a486c712a91e48443cd802642223d" "/navigation/8038da89e49ac5eabb489cfc6cea9fc1" "/navigation/b8b4b727d6f5d1b61fff7be687f7970f" "/navigation/d0fb963ff976f9c37fc81fe03c21ea7b" "/navigation/5ffaa9f5182c2a36843f438bb1fdbdea" "/navigation/ea3aed2bce2d893088e71e188ebca823" "/navigation/f1981e4bd8a0d6d8462016d2fc6276b3" "/navigation/0f7b2bb5d0c7e6209ecff113108f64cf" "/navigation/d7a84628c025d30f7b2c52c958767e76" "/navigation/6b1a864b240fc77e3a901e3470b243f9" "/navigation/3435c378bb76d4357324dd7e69f3cd18" "/account/recover" "/navigation/019d1a3df99871da903442c352009bed" "/navigation/01968130746a71c8b1a99ef4fdec8c82" "/navigation/01968133f2ff706aa2f1960b9b6e4e27" "/navigation/01968138220475b5a805cef8b6076925" "/navigation/0196813ac15c7ca39b56617e1fa995fe" "/navigation/0196813bb95571e0a8d43fa759436f12" "/navigation/0196813d6b5f72a28df3f7ca15a26f9f" "/navigation/0196813e1aaa7c0185d84d0a45994677" "/navigation/0196813edba07639833dfed8e2c246e2" "/navigation/019c70327d1c7b0cb11ebc5e57d88dc6" "/navigation/0196813f9e9b722f872fab279bb95ae5" "/navigation/019d245781b77ce481fe7a264db4b27c" "/navigation/0196b48cfccb74b6abbd88be8c6ddfdc" "/detail/bdc31e3996f71d8f34782dda5ea48511" "/navigation/0196b490b9357882b41f060af7b5e2e8" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.30 ms (1.76%) |
2 |
-- header::navigation::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.override_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.override_1.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.override_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.override_1.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.override_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.override_1.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `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 `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.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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation.override_1`.`alt` as `category.media.translation.override_1.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation.override_1`.`title` as `category.media.translation.override_1.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields`, `category.media.translation.override_1`.`custom_fields` as `category.media.translation.override_1.customFields` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.override_1` ON `category.media.translation`.`media_id` = `category.media.translation.override_1`.`media_id` AND `category.media.translation.override_1`.`language_id` = ? 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"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01þ²$\x00s4ŽahI…\x1FÌ" ] |
||||||||||||||||||||
|
0.29 ms (1.69%) |
2 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
|
0.25 ms (1.44%) |
2 |
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters:
[ b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|0190feb2240073348d61ad6849851fcc|%" 4 true true ] |
||||||||||||||||||||
|
0.21 ms (1.20%) |
1 |
-- base-context-factory::sales-channel::read SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.override_1.shortName`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.override_1.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.override_1.name`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.override_1.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.override_1.customFields`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.override_1.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.translation.override_1.name`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.override_1.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.override_1.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.override_1.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.override_1.homeName`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.override_1.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.override_1.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.override_1.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.override_1.homeKeywords`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.override_1.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.override_1.customFields`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.override_1.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation.override_1`.`name` as `sales_channel.translation.override_1.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation.override_1`.`custom_fields` as `sales_channel.translation.override_1.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.override_1`.`home_slot_config` as `sales_channel.translation.override_1.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation.override_1`.`home_enabled` as `sales_channel.translation.override_1.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation.override_1`.`home_name` as `sales_channel.translation.override_1.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.override_1`.`home_meta_title` as `sales_channel.translation.override_1.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.override_1`.`home_meta_description` as `sales_channel.translation.override_1.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords`, `sales_channel.translation.override_1`.`home_keywords` as `sales_channel.translation.override_1.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.override_1` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.override_1`.`sales_channel_id` AND `sales_channel.translation.override_1`.`language_id` = ? WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.override_1`.`short_name` as `sales_channel.currency.translation.override_1.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation.override_1`.`name` as `sales_channel.currency.translation.override_1.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.override_1`.`custom_fields` as `sales_channel.currency.translation.override_1.customFields` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.override_1` ON `sales_channel.currency.translation`.`currency_id` = `sales_channel.currency.translation.override_1`.`currency_id` AND `sales_channel.currency.translation.override_1`.`language_id` = ? WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.17 ms (0.96%) |
1 |
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"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\x01þ²$\x00s4ŽahI…\x1FÌ" ] |
||||||||||||||||||||
|
0.16 ms (0.95%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"\x01þögMxvŽKWíió–L" "Z3qHPD8gdSVZxsQTDOwuaDqCPKaqNTsa" ] |
||||||||||||||||||||
|
0.16 ms (0.93%) |
1 |
-- cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[
false
]
|
||||||||||||||||||||
|
0.16 ms (0.90%) |
1 |
SELECT `salutation`.`id` as `salutation.id`, `salutation`.`salutation_key` as `salutation.salutationKey`, `salutation`.`created_at` as `salutation.createdAt`, `salutation`.`updated_at` as `salutation.updatedAt`, `salutation.translation.override_1.displayName`, `salutation.translation.displayName`, COALESCE(`salutation.translation.override_1.displayName`,`salutation.translation.displayName`) as `salutation.displayName`, `salutation.translation.override_1.letterName`, `salutation.translation.letterName`, COALESCE(`salutation.translation.override_1.letterName`,`salutation.translation.letterName`) as `salutation.letterName`, `salutation.translation.override_1.customFields`, `salutation.translation.customFields`, COALESCE(`salutation.translation.override_1.customFields`,`salutation.translation.customFields`) as `salutation.customFields` FROM `salutation` LEFT JOIN (SELECT `salutation.translation`.`salutation_id`, `salutation.translation`.`display_name` as `salutation.translation.displayName`, `salutation.translation.override_1`.`display_name` as `salutation.translation.override_1.displayName`, `salutation.translation`.`letter_name` as `salutation.translation.letterName`, `salutation.translation.override_1`.`letter_name` as `salutation.translation.override_1.letterName`, `salutation.translation`.`custom_fields` as `salutation.translation.customFields`, `salutation.translation.override_1`.`custom_fields` as `salutation.translation.override_1.customFields` FROM `salutation_translation` `salutation.translation` LEFT JOIN `salutation_translation` `salutation.translation.override_1` ON `salutation.translation`.`salutation_id` = `salutation.translation.override_1`.`salutation_id` AND `salutation.translation.override_1`.`language_id` = ? WHERE `salutation.translation`.`language_id` = ?) `salutation.salutation_translation` ON `salutation.salutation_translation`.`salutation_id` = `salutation`.`id`
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
0.15 ms (0.87%) |
1 |
SELECT `name`, `path`, `author`, `self_managed` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.14 ms (0.82%) |
1 |
-- footer-pagelet::shipping-methods::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.override_1.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.override_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.override_1.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.override_1`.`name` as `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.override_1`.`custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.override_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1`.`language_id` = ? WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = ? WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²#ßr÷¸&}™ÐC›û" ] |
||||||||||||||||||||
|
0.14 ms (0.81%) |
1 |
-- header::languages::search-ids SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id` LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id` WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters:
[ b"\x01þögMxvŽKWíió–L" b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.14 ms (0.80%) |
1 |
-- footer-pagelet::payment-methods::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.override_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.override_1.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.override_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.override_1.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.override_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.override_1.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.translation.override_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.override_1.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.override_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.override_1.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.override_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.override_1.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.override_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.override_1.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`, `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id` AND `payment_method.translation.override_1`.`language_id` = ? WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`, `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id` AND `payment_method.media.translation.override_1`.`language_id` = ? WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²#´s;§*H´\x04ÅlL" b"\x01þ²#”qá\x04Õo~¥#;" ] |
||||||||||||||||||||
|
0.13 ms (0.77%) |
2 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"\x01þ²$\x00s4ŽahI…\x1FÌ" b"\x01þ²$\x00s4ŽahI…\x1FÌ" b"\x01þ²$\x00s4ŽahI…\x1FÌ" ] |
||||||||||||||||||||
|
0.13 ms (0.76%) |
1 |
-- header::languages::read 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.productSearchConfig`.`id` as `language.productSearchConfig.id`, `language.productSearchConfig`.`language_id` as `language.productSearchConfig.languageId`, `language.productSearchConfig`.`and_logic` as `language.productSearchConfig.andLogic`, `language.productSearchConfig`.`min_search_length` as `language.productSearchConfig.minSearchLength`, `language.productSearchConfig`.`excluded_terms` as `language.productSearchConfig.excludedTerms`, `language.productSearchConfig`.`created_at` as `language.productSearchConfig.createdAt`, `language.productSearchConfig`.`updated_at` as `language.productSearchConfig.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.override_1.name`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.override_1.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.override_1.territory`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.override_1.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.override_1.customFields`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.override_1.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields` FROM `language` LEFT JOIN `product_search_config` `language.productSearchConfig` ON `language`.`id` = `language.productSearchConfig`.`language_id` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation.override_1`.`name` as `language.translationCode.translation.override_1.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation.override_1`.`territory` as `language.translationCode.translation.override_1.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields`, `language.translationCode.translation.override_1`.`custom_fields` as `language.translationCode.translation.override_1.customFields` FROM `locale_translation` `language.translationCode.translation` LEFT JOIN `locale_translation` `language.translationCode.translation.override_1` ON `language.translationCode.translation`.`locale_id` = `language.translationCode.translation.override_1`.`locale_id` AND `language.translationCode.translation.override_1`.`language_id` = ? WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" ] |
||||||||||||||||||||
|
0.13 ms (0.75%) |
1 |
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:
[]
|
||||||||||||||||||||
|
0.13 ms (0.75%) |
1 |
SELECT LOWER(HEX(language.parent_id)) FROM language WHERE language.id = ?
Parameters:
[
b"\x01þ²\x1AæpÔ¿˜–_Þx"
]
|
||||||||||||||||||||
|
0.13 ms (0.73%) |
1 |
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þ²#\pÛ¤¿„°süqœ" b"\x01þ²#ßr÷¸&}™Ñ™Á^" b"\x01þ²gìs¤”"(=¶_P’" b"\x01– j¥\x11xê¯ÝÒÈÓaü\x1C" b"\x01%–,V{f™ëæÒ\x12cv" b"\x01ª©7™r“£zÉÝÕ\x13¼ƒ" b"\x01÷Ý¢Ft„ª\tV-ÿ" b"\x01þ²$ºpbºcM²iQ\x11Ø" ] |
||||||||||||||||||||
|
0.12 ms (0.72%) |
1 |
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.override_1.name`, `customer_group.translation.name`, COALESCE(`customer_group.translation.override_1.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.override_1.registrationTitle`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.override_1.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.override_1.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.override_1.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.override_1.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.override_1.customFields`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.override_1.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation.override_1`.`name` as `customer_group.translation.override_1.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation.override_1`.`custom_fields` as `customer_group.translation.override_1.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation.override_1`.`registration_title` as `customer_group.translation.override_1.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation.override_1`.`registration_introduction` as `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1`.`registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.override_1`.`registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation`.`customer_group_id` = `customer_group.translation.override_1`.`customer_group_id` AND `customer_group.translation.override_1`.`language_id` = ? WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE (`customer_group`.`registration_active` = ?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" true ] |
||||||||||||||||||||
|
0.12 ms (0.71%) |
1 |
# context-factory::base-context SELECT sales_channel.id as sales_channel_id, sales_channel.language_id as sales_channel_default_language_id, sales_channel.currency_id as sales_channel_currency_id, currency.factor as sales_channel_currency_factor, GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids FROM sales_channel INNER JOIN currency ON sales_channel.currency_id = currency.id LEFT JOIN sales_channel_language ON sales_channel_language.sales_channel_id = sales_channel.id WHERE sales_channel.id = ? GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters:
[
b"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.12 ms (0.71%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||
|
0.12 ms (0.70%) |
1 |
SELECT `customer_group_translation`.`name` as `customer_group_translation.name`, `customer_group_translation`.`registration_title` as `customer_group_translation.registrationTitle`, `customer_group_translation`.`registration_introduction` as `customer_group_translation.registrationIntroduction`, `customer_group_translation`.`registration_only_company_registration` as `customer_group_translation.registrationOnlyCompanyRegistration`, `customer_group_translation`.`registration_seo_meta_description` as `customer_group_translation.registrationSeoMetaDescription`, `customer_group_translation`.`custom_fields` as `customer_group_translation.customFields`, `customer_group_translation`.`created_at` as `customer_group_translation.createdAt`, `customer_group_translation`.`updated_at` as `customer_group_translation.updatedAt`, `customer_group_translation`.`customer_group_id` as `customer_group_translation.customerGroupId`, `customer_group_translation`.`language_id` as `customer_group_translation.languageId` FROM `customer_group_translation` WHERE (`customer_group_translation`.`customer_group_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters:
[ b"\x01–{\ÁçsQ«å\x02Rt¯ˆ" b"\x01–{]K·|£G\x1E\x02é\x00¹³" b"\x01–{]¸ô}\x7Fœî^ÑXQ<á" b"\x01–{]è`t\x1C£ï¢w\x1DýàÔ" b"\x01–{^E%w#ŒœïìÁ\À" b"\x01–{^ovzܦ\x07Š®ä¬\x17û" b"\x01–{^¤¹|nšìÖ«\x0E\x01q]" b"\x01–{^Ý%}„†‡ÂÀ\x12\x15>\n" b"\x01–{_\x02\x05wͤ”áï¾…È®" b"\x01–{_u\x1Et\x00Œˆ+‚ö¤}~" b"\x01–{_§K~I¢\x04³É_¿\f‚" b"\x01–{_ô¥ql½,Äì{¥ó“" b"\x01–{`'+u\x13ƒŠ=׈^z\x17" b"\x01–{aE\x1D}M¾½Ì\f𯱛" b"\x01–{a±¨|2º¦ý#Ö¡Æ\" b"\x01œ.Ç)Lx\x18® ¢µ¯ã\x16Ž" ] |
||||||||||||||||||||
|
0.12 ms (0.70%) |
1 |
-- base-context-factory::payment-method::read SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.override_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.override_1.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.override_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.override_1.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.override_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.override_1.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.translation.override_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.override_1.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.override_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.override_1.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.override_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.override_1.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.override_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.override_1.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields` FROM `payment_method` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation.override_1`.`name` as `payment_method.translation.override_1.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation.override_1`.`distinguishable_name` as `payment_method.translation.override_1.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation.override_1`.`description` as `payment_method.translation.override_1.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields`, `payment_method.translation.override_1`.`custom_fields` as `payment_method.translation.override_1.customFields` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.override_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.override_1`.`payment_method_id` AND `payment_method.translation.override_1`.`language_id` = ? WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation.override_1`.`alt` as `payment_method.media.translation.override_1.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation.override_1`.`title` as `payment_method.media.translation.override_1.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields`, `payment_method.media.translation.override_1`.`custom_fields` as `payment_method.media.translation.override_1.customFields` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.override_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.override_1`.`media_id` AND `payment_method.media.translation.override_1`.`language_id` = ? WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þö2és\x0F„„Ñt›\x16*'" ] |
||||||||||||||||||||
|
0.12 ms (0.68%) |
1 |
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.override_1.description`, `theme.translation.description`, COALESCE(`theme.translation.override_1.description`,`theme.translation.description`) as `theme.description`, `theme.translation.override_1.labels`, `theme.translation.labels`, COALESCE(`theme.translation.override_1.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.override_1.helpTexts`, `theme.translation.helpTexts`, COALESCE(`theme.translation.override_1.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.override_1.customFields`, `theme.translation.customFields`, COALESCE(`theme.translation.override_1.customFields`,`theme.translation.customFields`) as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation.override_1`.`description` as `theme.translation.override_1.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation.override_1`.`labels` as `theme.translation.override_1.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation.override_1`.`help_texts` as `theme.translation.override_1.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields`, `theme.translation.override_1`.`custom_fields` as `theme.translation.override_1.customFields` FROM `theme_translation` `theme.translation` LEFT JOIN `theme_translation` `theme.translation.override_1` ON `theme.translation`.`theme_id` = `theme.translation.override_1`.`theme_id` AND `theme.translation.override_1`.`language_id` = ? WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id` WHERE `theme`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01–]%Ç;s§¶«\eÌéæ“Ì" ] |
||||||||||||||||||||
|
0.12 ms (0.68%) |
1 |
-- base-context-factory::customer-group::read SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.override_1.name`, `customer_group.translation.name`, COALESCE(`customer_group.translation.override_1.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.override_1.registrationTitle`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.override_1.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.override_1.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.override_1.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.override_1.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.override_1.customFields`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.override_1.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation.override_1`.`name` as `customer_group.translation.override_1.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation.override_1`.`custom_fields` as `customer_group.translation.override_1.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation.override_1`.`registration_title` as `customer_group.translation.override_1.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation.override_1`.`registration_introduction` as `customer_group.translation.override_1.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.override_1`.`registration_only_company_registration` as `customer_group.translation.override_1.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.override_1`.`registration_seo_meta_description` as `customer_group.translation.override_1.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.override_1` ON `customer_group.translation`.`customer_group_id` = `customer_group.translation.override_1`.`customer_group_id` AND `customer_group.translation.override_1`.`language_id` = ? WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"ϽP\x18ÓŽAØÊ\x10ÙOȽÖ" ] |
||||||||||||||||||||
|
0.12 ms (0.68%) |
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.11 ms (0.66%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"\x01þ²$‰ró¤Kþù³\x1A3ø"
]
|
||||||||||||||||||||
|
0.11 ms (0.65%) |
1 |
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters:
[
"8a243080f92e4c719546314b577cf82b"
]
|
||||||||||||||||||||
|
0.11 ms (0.65%) |
1 |
-- base-context-factory::sales-channel::association::domains::read SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE (`sales_channel_domain`.`sales_channel_id` IN (?))
Parameters:
[
b"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.11 ms (0.65%) |
1 |
-- country-route::association::states::read SELECT `country_state`.`id` as `country_state.id`, `country_state`.`country_id` as `country_state.countryId`, `country_state`.`short_code` as `country_state.shortCode`, `country_state`.`position` as `country_state.position`, `country_state`.`active` as `country_state.active`, `country_state`.`created_at` as `country_state.createdAt`, `country_state`.`updated_at` as `country_state.updatedAt`, `country_state.translation.override_1.name`, `country_state.translation.name`, COALESCE(`country_state.translation.override_1.name`,`country_state.translation.name`) as `country_state.name`, `country_state.translation.override_1.customFields`, `country_state.translation.customFields`, COALESCE(`country_state.translation.override_1.customFields`,`country_state.translation.customFields`) as `country_state.customFields` FROM `country_state` LEFT JOIN `country` `country_state.country` ON `country_state`.`country_id` = `country_state.country`.`id` LEFT JOIN (SELECT `country_state.translation`.`country_state_id`, `country_state.translation`.`name` as `country_state.translation.name`, `country_state.translation.override_1`.`name` as `country_state.translation.override_1.name`, `country_state.translation`.`custom_fields` as `country_state.translation.customFields`, `country_state.translation.override_1`.`custom_fields` as `country_state.translation.override_1.customFields` FROM `country_state_translation` `country_state.translation` LEFT JOIN `country_state_translation` `country_state.translation.override_1` ON `country_state.translation`.`country_state_id` = `country_state.translation.override_1`.`country_state_id` AND `country_state.translation.override_1`.`language_id` = ? WHERE `country_state.translation`.`language_id` = ?) `country_state.country_state_translation` ON `country_state.country_state_translation`.`country_state_id` = `country_state`.`id` LEFT JOIN `sales_channel_country` `country_state.country.salesChannels.mapping` ON `country_state.country`.`id` = `country_state.country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country_state.country.salesChannels` ON `country_state.country.salesChannels.mapping`.`sales_channel_id` = `country_state.country.salesChannels`.`id` WHERE (`country_state.country.salesChannels`.`id` = ? AND `country_state`.`country_id` IN (?, ?, ?)) GROUP BY `country_state`.`id` ORDER BY MIN(`country_state`.`position`) ASC, MIN(COALESCE(`country_state.translation.override_1.name`,`country_state.translation.name`)) ASC
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þögMxvŽKWíió–L" b"\x01þ²\eƒpiªIqm¾P•" b"\x01þ²"(sÚ‹f¬´@Yq\x08" b"\x01þ²"8qÔš®5\eo\x0E\x13" ] |
||||||||||||||||||||
|
0.11 ms (0.65%) |
1 |
-- footer-pagelet::shipping-methods::search-ids SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id` WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`)) ASC
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" true b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.11 ms (0.63%) |
1 |
-- base-context-factory::country::read SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.override_1.name`, `country.translation.name`, COALESCE(`country.translation.override_1.name`,`country.translation.name`) as `country.name`, `country.translation.override_1.addressFormat`, `country.translation.addressFormat`, COALESCE(`country.translation.override_1.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.override_1.customFields`, `country.translation.customFields`, COALESCE(`country.translation.override_1.customFields`,`country.translation.customFields`) as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation.override_1`.`name` as `country.translation.override_1.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation.override_1`.`custom_fields` as `country.translation.override_1.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat`, `country.translation.override_1`.`address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation`.`country_id` = `country.translation.override_1`.`country_id` AND `country.translation.override_1`.`language_id` = ? WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\eƒpiªIqm¾P•" ] |
||||||||||||||||||||
|
0.11 ms (0.63%) |
1 |
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters:
[] |
||||||||||||||||||||
|
0.11 ms (0.62%) |
1 |
-- country-route::search-ids SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation.override_1`.`name` as `country.translation.override_1.name` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation`.`country_id` = `country.translation.override_1`.`country_id` AND `country.translation.override_1`.`language_id` = ? WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE (`country`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id` ORDER BY MIN(`country`.`position`) ASC, MIN(COALESCE(`country.translation.override_1.name`,`country.translation.name`)) ASC
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" true b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.11 ms (0.61%) |
1 |
SELECT path FROM category WHERE id = ?
Parameters:
[
b"\x01þ²$\x00s4ŽahI…\x1FÌ"
]
|
||||||||||||||||||||
|
0.11 ms (0.61%) |
1 |
-- footer-pagelet::payment-methods::search-ids SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id` LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id` WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters:
[ true b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.10 ms (0.61%) |
1 |
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"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.10 ms (0.60%) |
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.10 ms (0.59%) |
1 |
-- header::currencies::search-ids SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id` LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id` WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters:
[
b"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.10 ms (0.58%) |
1 |
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:
[ "/account/login" b"\x01þögMxvŽKWíió–L" b"\x01þ²\x1AæpÔ¿˜–_Þx" ] |
||||||||||||||||||||
|
0.10 ms (0.57%) |
1 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||
|
0.09 ms (0.52%) |
1 |
-- base-context-factory::shipping-method::read SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method.deliveryTime`.`id` as `shipping_method.deliveryTime.id`, `shipping_method.deliveryTime`.`min` as `shipping_method.deliveryTime.min`, `shipping_method.deliveryTime`.`max` as `shipping_method.deliveryTime.max`, `shipping_method.deliveryTime`.`unit` as `shipping_method.deliveryTime.unit`, `shipping_method.deliveryTime`.`created_at` as `shipping_method.deliveryTime.createdAt`, `shipping_method.deliveryTime`.`updated_at` as `shipping_method.deliveryTime.updatedAt`, `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.override_1.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.override_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.override_1.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.appShippingMethod`.`id` as `shipping_method.appShippingMethod.id`, `shipping_method.appShippingMethod`.`app_name` as `shipping_method.appShippingMethod.appName`, `shipping_method.appShippingMethod`.`identifier` as `shipping_method.appShippingMethod.identifier`, `shipping_method.appShippingMethod`.`app_id` as `shipping_method.appShippingMethod.appId`, `shipping_method.appShippingMethod`.`shipping_method_id` as `shipping_method.appShippingMethod.shippingMethodId`, `shipping_method.appShippingMethod`.`original_media_id` as `shipping_method.appShippingMethod.originalMediaId`, `shipping_method.appShippingMethod`.`created_at` as `shipping_method.appShippingMethod.createdAt`, `shipping_method.appShippingMethod`.`updated_at` as `shipping_method.appShippingMethod.updatedAt`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.override_1.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.override_1.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.override_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.override_1.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.translation.override_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.override_1.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.override_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.override_1.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.override_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.override_1.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.override_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.override_1.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `delivery_time` `shipping_method.deliveryTime` ON `shipping_method`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN `app_shipping_method` `shipping_method.appShippingMethod` ON `shipping_method`.`id` = `shipping_method.appShippingMethod`.`shipping_method_id` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation.override_1`.`name` as `shipping_method.translation.override_1.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation.override_1`.`custom_fields` as `shipping_method.translation.override_1.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation.override_1`.`description` as `shipping_method.translation.override_1.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl`, `shipping_method.translation.override_1`.`tracking_url` as `shipping_method.translation.override_1.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.override_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.override_1`.`shipping_method_id` AND `shipping_method.translation.override_1`.`language_id` = ? WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.deliveryTime.translation`.`delivery_time_id`, `shipping_method.deliveryTime.translation`.`name` as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation.override_1`.`name` as `shipping_method.deliveryTime.translation.override_1.name`, `shipping_method.deliveryTime.translation`.`custom_fields` as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation.override_1`.`custom_fields` as `shipping_method.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.override_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.override_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.override_1`.`language_id` = ? WHERE `shipping_method.deliveryTime.translation`.`language_id` = ?) `shipping_method.deliveryTime.delivery_time_translation` ON `shipping_method.deliveryTime.delivery_time_translation`.`delivery_time_id` = `shipping_method.deliveryTime`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation.override_1`.`alt` as `shipping_method.media.translation.override_1.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation.override_1`.`title` as `shipping_method.media.translation.override_1.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields`, `shipping_method.media.translation.override_1`.`custom_fields` as `shipping_method.media.translation.override_1.customFields` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.override_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.override_1`.`media_id` AND `shipping_method.media.translation.override_1`.`language_id` = ? WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²#ßr÷¸&}™ÐC›û" ] |
||||||||||||||||||||
|
0.08 ms (0.46%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName, LOWER(HEX(parentTheme.parent_theme_id)) as grandParentThemeId FROM sales_channel LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id WHERE sales_channel.id = ?
Parameters:
[
b"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.08 ms (0.44%) |
1 |
-- country-route::read SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.override_1.name`, `country.translation.name`, COALESCE(`country.translation.override_1.name`,`country.translation.name`) as `country.name`, `country.translation.override_1.addressFormat`, `country.translation.addressFormat`, COALESCE(`country.translation.override_1.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.override_1.customFields`, `country.translation.customFields`, COALESCE(`country.translation.override_1.customFields`,`country.translation.customFields`) as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation.override_1`.`name` as `country.translation.override_1.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation.override_1`.`custom_fields` as `country.translation.override_1.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat`, `country.translation.override_1`.`address_format` as `country.translation.override_1.addressFormat` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.override_1` ON `country.translation`.`country_id` = `country.translation.override_1`.`country_id` AND `country.translation.override_1`.`language_id` = ? WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?, ?, ?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\eƒpiªIqm¾P•" b"\x01þ²"(sÚ‹f¬´@Yq\x08" b"\x01þ²"8qÔš®5\eo\x0E\x13" ] |
||||||||||||||||||||
|
0.07 ms (0.42%) |
1 |
DELETE FROM `cart` WHERE `token` = :token
Parameters:
[ "token" => "Z3qHPD8gdSVZxsQTDOwuaDqCPKaqNTsa" ] |
||||||||||||||||||||
|
0.07 ms (0.42%) |
1 |
-- base-context-factory::sales-channel::association::languages::read 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.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.override_1.name`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.override_1.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.override_1.territory`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.override_1.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.override_1.customFields`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.override_1.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields`, `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.override_1.name`, `language.locale.translation.name`, COALESCE(`language.locale.translation.override_1.name`,`language.locale.translation.name`) as `language.locale.name`, `language.locale.translation.override_1.territory`, `language.locale.translation.territory`, COALESCE(`language.locale.translation.override_1.territory`,`language.locale.translation.territory`) as `language.locale.territory`, `language.locale.translation.override_1.customFields`, `language.locale.translation.customFields`, COALESCE(`language.locale.translation.override_1.customFields`,`language.locale.translation.customFields`) as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation.override_1`.`name` as `language.translationCode.translation.override_1.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation.override_1`.`territory` as `language.translationCode.translation.override_1.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields`, `language.translationCode.translation.override_1`.`custom_fields` as `language.translationCode.translation.override_1.customFields` FROM `locale_translation` `language.translationCode.translation` LEFT JOIN `locale_translation` `language.translationCode.translation.override_1` ON `language.translationCode.translation`.`locale_id` = `language.translationCode.translation.override_1`.`locale_id` AND `language.translationCode.translation.override_1`.`language_id` = ? WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation.override_1`.`name` as `language.locale.translation.override_1.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation.override_1`.`territory` as `language.locale.translation.override_1.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields`, `language.locale.translation.override_1`.`custom_fields` as `language.locale.translation.override_1.customFields` FROM `locale_translation` `language.locale.translation` LEFT JOIN `locale_translation` `language.locale.translation.override_1` ON `language.locale.translation`.`locale_id` = `language.locale.translation.override_1`.`locale_id` AND `language.locale.translation.override_1`.`language_id` = ? WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE ((`language`.`id` = ?)) AND (`language`.`id` IN (?))
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²\x1AæpÔ¿˜–_Þx" b"\x01þ²\x1AæpÔ¿˜–_Þx" ] |
||||||||||||||||||||
|
0.07 ms (0.39%) |
1 |
-- base-context-factory::taxes::association::rules::read SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.override_1.typeName`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.override_1.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName`, `tax_rule.type.translation.override_1`.`type_name` as `tax_rule.type.translation.override_1.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.override_1` ON `tax_rule.type.translation`.`tax_rule_type_id` = `tax_rule.type.translation.override_1`.`tax_rule_type_id` AND `tax_rule.type.translation.override_1`.`language_id` = ? WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE (`tax_rule`.`tax_id` IN (?, ?, ?, ?, ?, ?))
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"\x01þ²#úrª©\x12°D^÷¾å" b"\x01þ²#úrª©\x12°D_0êX" b"\x01þ²}èræ¬î1ÈÍ¥\x08" b"\x01Ÿ\x17œ \x17v´¸\x17\eýõ(éê" b"ÄÊB8 ¹#‚\rÌPšou„›" b"È\x1ErŽL/co\x06\x7F‰Ì\x14†," ] |
||||||||||||||||||||
|
0.07 ms (0.39%) |
1 |
-- header::currencies::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.customFields`,`currency.translation.customFields`) as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.06 ms (0.36%) |
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"\x01þ²\x1AæpÔ¿˜–_Þx" b"\x01þögMxvŽKWíió–L" "account/login" "account/login/" ] |
||||||||||||||||||||
|
0.06 ms (0.35%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[
b"\x01þögMxvŽKWíió–L"
]
|
||||||||||||||||||||
|
0.06 ms (0.33%) |
1 |
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters:
[
b"\x01þ²\x1AæpÔ¿˜–_Þx"
]
|
||||||||||||||||||||
|
0.06 ms (0.32%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"\x01þ²$‰ró¤Kþù³\x1A3ø"
]
|
||||||||||||||||||||
|
0.05 ms (0.31%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.04 ms (0.25%) |
1 |
-- base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"\x01þ²\eƒpiªIqm¾P•" ] |
||||||||||||||||||||
|
0.04 ms (0.21%) |
1 |
-- cart-rule-loader::load-rules::read 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þ²#\pÛ¤¿„°süqœ" b"\x01þ²#ßr÷¸&}™Ñ™Á^" b"\x01þ²$¿s\x11•ò©Ý_5Á\x06" b"\x01þ²gìs¤”"(=¶_P’" b"\x01–€¿ò™zÕGGRKþÊ" b"\x01– j¥\x11xê¯ÝÒÈÓaü\x1C" b"\x01– mÀ™sÒµ\x12õ Ð>\eb" b"\x01– oy\x04|ôŠK\x11ÛAŽ\x01Q" b"\x01œ²§Âž\x7F³€ú\x17Ä;\x19Þ\x1D" b"\x01œç\x06#×|r§`9\x15ugÚò" b"\x01\x01\x14ï•vÓ`]d\x12\x0Ee•" b"\x01$ÇvÔt¥Jõá¸u\x08Y" b"\x01%–,V{f™ëæÒ\x12cv" b"\x01%—\x19‚x:ÃóÈgÞé\x19" b"\x01lu\x07Üs\x17š®ÖU\x11@" b"\x01…êQû\x7F—Œåã„/\x17ïÂ" b"\x01›/\x05 r\x02´\x01g¼\x13É\x11" b"\x01ªz߀uôŽ¤"?í\x00\x00Ô" b"\x01ª§‰Íqz¤\x7F<•ø…Îz" b"\x01ª©7™r“£zÉÝÕ\x13¼ƒ" b"\x01ª¹\x1C>sĵoªx̤\x1Eø" b"\x01´Q\t¶ss”uI`¦\x11J" b"\x01÷¿f–pò˜˜æ$è90w" b"\x01÷Ý¢Ft„ª\tV-ÿ" b"\x01ž\x02\x11\f±uv—°©@[¬\x08œ" b"\x01œ"gŠÕs\x0EŽŽ½\x04Ø$©È" b"\x01œ#\x11)p\e»\x0EsO\x06rCT" b"\x01œ#9\x0EÏs\x05£\x03N3ù\x18xÕ" b"\x01\x1F´}{z,ˆãî8¾¾?," b"\x01%}Jšv.™€xˆC—J5" b"\x01š\t´\x03~Å¥^üMV,.v" b"\x01š\x13øRpÏ\t¬ù\x14ÍWÞ" b"\x01›P8+sEŽþëS\x03‡—B" b"\x01´\x1E\x02<qš¶–yóuÞ3" b"\x01÷¾ýìq]ºÍ£½Ôéê" b"\x01ž\x02/IBp׉\x1A`;x\tn" b"\x01žø>#‚}Ö®#\x081³¯üº" b"\x01ž\x06ûõL}\x19ž"gn],!õ" b"\x01þ²$·r/ø\x15‚Ç[ÔÏ" b"\x01þ²$ºpbºcM²iQ\x11Ø" b"\x01þ³\x13©rµŽ›òŒÜáð" ] |
||||||||||||||||||||
|
0.04 ms (0.20%) |
1 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"Z3qHPD8gdSVZxsQTDOwuaDqCPKaqNTsa"
]
|
||||||||||||||||||||
|
0.03 ms (0.19%) |
1 |
-- base-context-factory::taxes::read SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters:
[] |
||||||||||||||||||||
|
0.03 ms (0.18%) |
1 |
-- app-scripts::refresh::search-ids SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters:
[ true false ] |
||||||||||||||||||||
|
0.03 ms (0.16%) |
1 |
-- base-context-factory::currency::read SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.override_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.override_1.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.override_1.name`, `currency.translation.name`, COALESCE(`currency.translation.override_1.name`,`currency.translation.name`) as `currency.name`, `currency.translation.override_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.override_1.customFields`,`currency.translation.customFields`) as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation.override_1`.`short_name` as `currency.translation.override_1.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation.override_1`.`name` as `currency.translation.override_1.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields`, `currency.translation.override_1`.`custom_fields` as `currency.translation.override_1.customFields` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.override_1` ON `currency.translation`.`currency_id` = `currency.translation.override_1`.`currency_id` AND `currency.translation.override_1`.`language_id` = ? WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.03 ms (0.16%) |
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.03 ms (0.15%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||
|
0.01 ms (0.08%) |
1 |
SELECT LOWER(HEX(`language.salesChannels.mapping`.`sales_channel_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`language.salesChannels.mapping`.`language_id`)) ) as `value` FROM `language` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language.salesChannels.mapping`.`language_id` = `language`.id WHERE ((`language`.`id` = ?)) AND (`language.salesChannels.mapping`.`sales_channel_id` IN (?)) GROUP BY `language.salesChannels.mapping`.`sales_channel_id`
Parameters:
[ b"\x01þ²\x1AæpÔ¿˜–_Þx" b"\x01þögMxvŽKWíió–L" ] |
||||||||||||||||||||
|
0.01 ms (0.08%) |
1 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS scriptName, `script`.`script` AS script, `script`.`hook` AS hook, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, `app`.`version` AS appVersion, `script`.`active` AS active FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` != 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
||||||||||||||||||||
|
0.01 ms (0.08%) |
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þögMxvŽKWíió–L" b"\x01þ²\eƒpiªIqm¾P•" ] |
||||||||||||||||||||
|
0.01 ms (0.06%) |
1 |
-- 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"\x01þ²\x1AæpÔ¿˜–_Þx" b"\x01þögMxvŽKWíió–L" "/account/login" ] |
||||||||||||||||||||
|
0.01 ms (0.05%) |
1 |
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`, `script`.`name` AS name, `script`.`script` AS script, `app`.`name` AS appName, LOWER(HEX(`app`.`integration_id`)) AS integrationId, IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified FROM `script` LEFT JOIN `app` ON `script`.`app_id` = `app`.`id` WHERE `script`.`hook` = 'include' ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.