Query Metrics
83
Database Queries
61
Different statements
192.95 ms
Query time
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
89.04 ms (46.15%) |
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`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId`, `category.translation.fallback_1`.name as `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb as `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config as `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type as `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link as `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link as `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab as `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description as `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title as `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description as `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords as `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields as `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at as `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at as `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id as `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id as `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id as `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId`, `category.media.translation.fallback_1`.title as `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt as `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields as `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at as `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at as `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id as `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id as `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" "%|3963b5d57dc34cb58630373d88a2ed9c|%" 1 6 ] |
||||||||||||||||||||
|
31.97 ms (16.57%) |
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/032e154676e64d09b8dfd49e3f5b9063" "/navigation/7846a272136444a9bfe332bcf214967c" "/navigation/77dc1dc7f52b4a7a86fa02f7ae84bafb" "/navigation/516248b1e3eb4521b304baec9be48b12" "/navigation/43ed1aa480974935af9e08823d2fe00f" "/navigation/1ee71eb6a7824ee3afd46817bc3edcfb" "/navigation/96f9f68ffe1945b8a3ebaa333572a847" "/navigation/1414784985d64f0fae5888e7ecf72879" "/navigation/53e415f5ec8143fa9b5746bc535d53ba" "/navigation/da05a3b9737c4ca08c750df69beb1b8b" "/navigation/8fa0cd7fbd3a4c98b97cb7b192e3b29c" "/navigation/9a2ffce76bcc492b9dcb25cda009ca14" "/navigation/db910c42fc7548eb99641a921222203b" "/navigation/5c217c38c30247809fd79a8b817f6075" "/navigation/eded0bba4c0348e3ae6117401fc05a6c" "/navigation/3a1b9d59cef940a7869b2104a3f23221" "/navigation/ef8144e30091463f93978eb1f57331c5" "/navigation/2402dd803db145998c18f3c97a2d6a76" "/navigation/85000cde136440089a7c13eed515270d" "/navigation/d979bc8205c14d2eaf1543311c7dda5f" "/navigation/c60bf4baef59453ea7550509c7364796" "/navigation/f25caef562e74eca9f6c7cfe5f05a161" "/navigation/6706cba55bbb4efaa4bab96e86acb15c" "/navigation/462eebdd0064427c9d964406350ea4af" "/navigation/45f73c745c2b4aa4a801ac0e018c1a2f" "/navigation/7b63f9065b1c4a98bdf06729f70aa47b" "/navigation/d446798978a24acfa748ff19a0f5ed0b" "/navigation/f9d3c1b6282a46918f36242f6c9267c1" "/navigation/227d8c7d40544e60b9de1d9daca27366" "/navigation/d5ab8893ae3f414b8722dedb33d02069" "/navigation/e182cbedebd347dfba886dacd1f57c50" "/navigation/5d98cff545254ca7804bc750025ad936" "/navigation/54de10b2afb44a9b9dfa20b5131b7931" "/navigation/97131637726340199e70b59cb95cab09" "/navigation/c0acf1cbc3b84bc6a74ba10d03d6d358" "/navigation/3f9fe451dff2456f8f0d53bb407ae8fa" "/navigation/085e4d64cb91497b86da5997c600d42f" "/navigation/41462c0a075942c6865c2338e9dbe60a" "/navigation/a22c75147a354dca8ed9d08765628ba1" "/navigation/1e302fff626b4ceda01678b02d5dbc14" "/navigation/01e8af85e2354f2ba2dc6e154fcdf69d" "/navigation/89fd7968095d46c6a3b1f90b7f0be3a1" "/navigation/4bbf2f90debd46af9113d75c306b06e4" "/navigation/b0b423b01a3346d29785d69b0165650d" "/navigation/e51407f0271b43769bc6d47e65bab455" "/navigation/36e2fe976ffc415d8c1b70f87058fd4e" "/navigation/ce25f57dce364ff4a83b49fa6323f47a" "/navigation/fce1e8c2338b42a89d5e6a3601234711" "/navigation/93cd82352e67479981378260a896ba48" "/navigation/73d6063b5a64467d9cae875e8149195f" "/navigation/bdc8e66b2c504a3abd4ced7954e81528" "/navigation/2b0edd2a121e4971906d55e06e90cf51" "/navigation/cbfdeac58e23431f88bfb4b197149be3" "/navigation/861b678fea3e4513be4ad0ad84911872" "/navigation/01d993a430ce4bffa6ceadefb8e5b4f4" "/navigation/2e91180865ea49c88e57d9b6362473ba" "/navigation/db705fdf47c94d739bcb9a06c35ed9a4" "/navigation/adfd8c8427e74e5798161fb99a6a629a" "/navigation/bfc56f6dd9e34c1881cce70ff6d625d8" "/navigation/2b390cde47d848a7a39b5326660a5ef3" "/navigation/242a477d6fce4e26adad060ea04ae547" "/navigation/612f7bc1b4d841f18fbefbc87fedb4dd" "/navigation/cbddef6bdc314273bc768ea5147e7062" "/navigation/84bca86626aa4f25a9559395d2e12532" "/navigation/996d06b2303e494ca36b830481a07514" "/navigation/bfe53d08b0e34da49c71e6a1bac3f83a" "/navigation/bda11d499eeb45aaafaffac7a04dd112" "/navigation/155120519aa04ef586da242b52584c84" "/navigation/a619714072c04ba9ad2568e36b987c7e" "/navigation/161736c104c34acc94b78231d98bc31b" "/navigation/89692412e0d944cf8e70512cf384368a" "/navigation/e48eccdb02fa4c21acfd7bacd815987f" "/navigation/42aca67918244816ad1f1c2a82424c99" "/navigation/6982c1ddb8044ccfb1195fb17c44e48a" "/navigation/c5a68b36676446f484ee633e6ebe21a9" "/navigation/cf4cd887e3d04d9ba632497f76c87e29" "/navigation/879df76666fb4a8eb4fcf3555e4b3b97" "/navigation/a96162f3511d433891db76fe5d9d4cf7" "/navigation/eca11876f80848bf83389bd2842411aa" "/navigation/d58295016dd944b9854625517c98d071" "/navigation/262ecf59b9e64013b0b3eaacf7a5df3a" "/navigation/3b68f75c40ae4a7985500f35da6c25a4" "/navigation/d8f910bdc0254a5799eb3f47c35d520e" "/navigation/baf399b96d024ee1aa21add1ba36ce4b" "/navigation/d0b1b2d9c3354cfc8acd8f4ca722665a" "/navigation/df68660a2cc049eea4a21d9e5c037983" "/navigation/71d46eba186843db9f0bac938fd1125f" "/navigation/0369b509766b40f9b630d9acd17b5aaf" "/navigation/e12c347818f4413bac543aabd1cd803d" "/navigation/321b36f3be9f4752948c9428964c087d" "/navigation/cdacac1d59674d00bece381c9d1c05b7" "/navigation/88bf1eba8a03451fa9e7d6332bd383be" "/navigation/cf1ea33f037747249cbcfa35dcc2229f" "/navigation/13526c4953ed466b987a97a36b671aac" "/navigation/0bc61fd4352447bf8daefcfa36da4a41" "/navigation/0a479e5c9ed34616bd0dca17dea58de6" "/navigation/cf474fa7943f46f7a32feaa9e5cde4cd" "/navigation/fe01b15ff88b48edac9c4a5df37e5ad8" "/navigation/01ba0e5db62e4c54b22be989e45f10d6" "/navigation/390b3b8483a64c99bcce4516dc5c6496" "/navigation/44821126e8d44146a51a68d100280580" "/navigation/5bc66db58f6945f38869f96e5f81f759" "/navigation/060716db16c74b8182731ca7762f855c" "/navigation/2e1d4a44f5b5479eb65b1984c1d5ac94" "/navigation/e1d8778b77dd45db980476c1fc19aeee" "/navigation/5873ba764628491da497fd98bc5556c4" "/navigation/cd3beded27ff4a499cfd595544e90bfb" "/navigation/52f1ff4559b0415d8c452e2b835aacf9" "/navigation/1e30d23dc802473fb1ea681a21db9f62" "/navigation/c9ffef2c2a06431ca6bff33c255a0764" "/navigation/de2162ad201d4895a3925d838731761c" "/navigation/924d86f19abb4455be44f8d1d23131c9" "/navigation/800203ad4587405d9b01b7b34be75dd0" "/navigation/d5e91684f4664905b40bdaf07c511e5d" "/navigation/6709ea682d614826b6c11bc6f0474734" "/navigation/8df0814b8ee749e7b143a0174a5ed2da" "/navigation/90fb0ded5a9e4530925f889a0bef5583" "/navigation/3f5b906114394b50a67e4eb5c5fc9628" "/navigation/c77d4ab261ed45a399daacf1016ff92c" "/navigation/0793e193a9154c1e91b5a01ac3fc83c9" "/navigation/d810264c30ea4992a47150c3ea35b620" "/navigation/98c7621e2826443c8b7bc1e5a936b4bb" "/navigation/b5d207d1fe8a4a72b83285f9b0274d34" "/navigation/ce34819322bb40bba43bb42a6b32259d" "/navigation/433dbdc36e3442ffa05a3eead448a913" "/navigation/d48f446a18ad4a6e91a765941f6b6aeb" "/navigation/97fa994f98a149e4a532c0a686b76bdd" "/navigation/a2130c6a4ea242e5becc28853e8f1596" "/navigation/302d6d5be1ea42ba8541e819845347a4" "/navigation/f691f7207b35409babf0de3d8342cb89" "/navigation/745897961bc74790b1174bb497df70a2" "/navigation/7994970bd4ab4f8eb8b66de31ec2c06b" "/navigation/f8bd7725588f42e5b012d47e8bf47994" "/navigation/373583830ca5463b9e48449e0931e352" "/navigation/c33725d219d9407db6a65c5bd2c5ec6d" "/navigation/ad51729293e0408c82de924aaf67b2f8" "/navigation/da0066c5d740403ca90470c60c0ca430" "/navigation/a359269faf0e44dc90c12c449f2561e3" "/navigation/9e25dd5f109d4874b785991820198d28" "/navigation/715efad6e4914e1eb520a451e7f365c5" "/navigation/c1ac685d8a874cda9fe1357a5c8a897d" "/navigation/1f70568793fa4291ae3ce3ed134b9c97" "/navigation/34bd98c17ba3482dbddf604516e49ba6" "/navigation/f59035d793f04b20b50c38d28e71d1df" "/navigation/897b14eb01e94eb3866532cf8804d106" "/navigation/c855b47d120c44b7ba34485bbc18c1f1" "/navigation/08bcddc4cd47474b87b26d70bacddb7b" "/navigation/4677e2360d84497a95dc6130a80d84d8" "/navigation/a18e290698d7430f86f10d74108c710e" "/navigation/3f33856228f2458b9bd809c4eb846604" "/navigation/24c8ce9a72fa47f58f74576bdef9af82" "/navigation/c414f9315f1b4549838cdb46d6132195" "/navigation/0e38c92b82f04593875412682f6fbaea" "/navigation/99d23e45a78940f885fd5641ac7fb289" "/navigation/de05a4f2947c4d1da9f836d512d01620" "/navigation/bce71392abc54dbea2d26dd643c254ae" "/navigation/b95f9f18c79c4dd0beb1e87271aa42a3" "/navigation/b603abd5aa40405f8bac5cebbf00404a" "/navigation/5506c6283fca4039acd94915b6d5c290" "/navigation/3e5517e59bcd43059da182a82bacca57" "/navigation/e182eb9853264571931c5242cb60bd83" "/navigation/6dc46527c1bd4aca826b2b00db46426c" "/navigation/e8a083e610b54b44ba1a6c8217fa0de7" "/navigation/b66f875e80df48aebd3f9d1d2b06d7b5" "/navigation/b577a5bc8e9c43e0b845313e48cd5f95" "/navigation/74f4e80203b147a0988d741a4df2cf33" "/navigation/e404d99f699b485aa3cbb3f9134c4cf0" "/navigation/2e9e5c9599a54c2986ce96dd7750bd6b" "/navigation/d7d6074b62d54e0789361df75ea629c2" "/navigation/5f3ba4aa216646d58b690cbf6be989d9" "/navigation/e529352cbaca4d6f88f43572b3fba520" "/navigation/a99153b53a0d44e7ae2a4331078d1c9b" "/navigation/2f03faa9e78d494a960f8816169e6c4d" "/navigation/464e35254d9c45d38d72446d67fe476c" "/navigation/b740594cd50e4275aa768f1e05e17e59" "/navigation/fb35f002c8534160928ef3175d27b1a9" "/navigation/31d875d19dd94834842ef9a2a9a7d3a7" "/navigation/0286bfe1c6fd45ebbd3c4315dd1ddfa2" "/navigation/a3932ff7cd184d158ed3f86d729acad6" "/navigation/0716467e95e64f7bb0a252c3765c80dc" "/navigation/72853616b4d046d1b4e0a00f9ca8e424" "/navigation/3be9cb433507477890b3096f758b300c" "/navigation/87b130a6cea9491e9e7ede39a980e7f9" "/navigation/cb70adfa43fb4c9ca5d71728e9189674" "/navigation/3d9b718d47344e3e8cc200f6ea65f4b1" "/navigation/c790c3ba52f64870952ee476f68e4461" "/navigation/ea8edcf97c3d4475b1e569f6a927a812" "/navigation/3b534069c7034794b1fdebf988af69f2" "/navigation/4a267330361848439a96a5c18d3969a0" "/navigation/44c79f272c7642e29a34da030faeea62" "/navigation/4a3db39ed1964a579a6d574e8d8c427a" "/navigation/a4007d88319d4b1c895e24dafa624f6b" "/navigation/8930dae77079496f849953ce86c07360" "/navigation/b9df2db872804a8a85046ca03ece160d" "/navigation/7cc8942bcdd8403aa516758d8ee9a53c" "/navigation/765a5844c3c74af18db8525b0e8f95da" "/navigation/962d8b8022f04334bd350f1ec845d5b7" "/navigation/f267646c08ff4ed1a682f79af7f6d32f" "/navigation/052c3ef5899a4a87a735a56e01a58b79" "/navigation/d5108e4c02f6456e8bc676005171d789" "/navigation/12e4db0f4cca488f8aab82cd4cc4e3eb" "/navigation/f51988bf9ebf481094d3114e484b6ed2" "/navigation/357cb6d53ffb437dba621f5f5ac3576c" "/navigation/bc4b1e13aeaa4daeab1b3b33b1dfa43e" "/navigation/91fe0b3557de4e02b2fc84bb93ce4a2e" "/navigation/f83447b284294b588189e3b33e6646d6" "/navigation/cd80b1a6c1b64ae693ebbcc8a9890124" "/navigation/33957e7e342647bba7f71900731fd850" "/navigation/4557e523dbe943bb9137058494d36b3b" "/navigation/81743c57a49246db86e7d536861a70bb" "/navigation/d79a54d9f0ca4c1ea0a5ab13925746ad" "/navigation/edbf4161377a473ea9d34ec41bd0d13e" "/navigation/18c8a72d65d64920b7dc1df12e56c5a0" "/navigation/dbb3e98cd31046018d95d7715c16a287" "/navigation/57493090d7a145e19a5c33e2a2d6b383" "/navigation/69a6647c6e584441bd4fdd1eca128649" "/navigation/30053fbb306043b0936f6fe9e938e861" "/navigation/aa70483d621041f284d20481003c2a6f" "/navigation/ef4a6e913f4247de95fcf4a8a792c2e5" "/navigation/3945d183af8f4bea96e888f2eee04324" "/navigation/ec6da37405d04d658090c6894f4b895e" "/navigation/b518b8111c6641b1b510f5172482b776" "/navigation/21c5fa59ac90490ab3fc30a14b4908e2" "/navigation/5865ae262a9a407594bad579e2ba5e81" "/navigation/f52ddc70966c4f3c9aa9970d2ac57b81" "/navigation/c7c70ec2c10644d1a693de6569db9779" "/navigation/8bfc4b97047b43e99914c679d14965dd" "/navigation/198417048b6741bb9642b73aa7e2d85c" "/navigation/614186b4429f44ffbe6eed6a0d6551d6" "/navigation/34e9c9334d8040388461069b3d045ccd" "/navigation/554c5d39d73c4bdf82c80a154af30f58" "/navigation/2c1729379b984379ba57d15ef595035d" "/navigation/e0f5f0aab7624ee694109cfa3e3495c7" "/navigation/c92d496a08ca4f7a9e463050534d7249" "/navigation/a947454627234fd2b266a4e22388f327" "/navigation/7afc5ff120974be2946b50ff624f293e" "/navigation/b0a63113da804109a34955a0bffd9d56" "/navigation/3c66a026b2dc4c629367ecb9d1342e27" "/navigation/9fdbf4c14e6f4cf4be9f9f29555ae8e6" "/navigation/ae647ec3741e41cc9522e025a0b1d7a2" "/navigation/76e179ff092d4b348b5b8a59bbf4014c" "/navigation/77e8fcd48aca49e8b2f643dce2aaedb2" "/navigation/bd1c491bf5634a21b5285ae6219ca100" "/navigation/bbcd4fc8815f424693823582c8725629" "/navigation/071b5be147ac4d8284625e1d248e5151" "/navigation/5e8538e84cdd440a8043d45ffde7bcd7" "/navigation/cc82a654e31746a294ce6b74f3559c87" "/navigation/f9255173c34946ed9b007d65bf0cbbc0" "/navigation/23e64d4a6e884d388c875886a456246c" "/navigation/6a4895b42cb144fdb2cb2ddce0261b50" "/navigation/919d7cd02e534cc1882e326f907bfc5f" "/navigation/b3c6b5aa54bb4d578236c059e0fc6c4b" "/navigation/d3a621ac05d047f2bfd36104c95e1e48" "/navigation/d0b24545b76c4c7dba0a9bebadbfe549" "/navigation/5827fbe927124c23aa7f619e0b1b7631" "/navigation/9cc1f669b58343ceaf1b6441472fdbbe" "/navigation/decc1cafe51a4e689b72b9399ab67840" "/navigation/07b4c17755174c92b071eac555cefc40" "/navigation/a7497221d28541199bea0c5f248cfef2" "/navigation/31505c6077f24f52a05f36c300a1f7ec" "/navigation/115cfdbd99e94cab8b6f1b7317ed5270" "/navigation/6e7d0f43355842d1b9d23ae0f4dac027" "/navigation/fdf0cb6579034e058755e6b722080191" "/navigation/f0b0442fdd884b6aabcbaf8b28cf17bc" "/navigation/0ee6220bc45f4b72ab9e6f90e66bd8f9" "/navigation/559f8c84b9bf4960a8cafdde88448c4a" "/navigation/a7d84c3d42b649d8b180f102b27b46e0" "/navigation/c81196713e354f0bab91ccfd493166ca" "/navigation/b32278494b3b4041bb9916774234bbe3" "/navigation/a73bdefb62104ace840cf15d90e0a8b4" "/navigation/40532a70fd56415abcc837871ec1503f" "/navigation/9a2a5c5999fb44fb83bdc7743cd913e6" "/navigation/974f3c5327f94c71842f85effc785b94" "/navigation/8c9986148aec4a858a2f04db8a88dce8" "/navigation/33c389f3c7a7400f9438802946503111" "/navigation/6682033b1b5f4bf69568b74d119d0add" "/navigation/05b1f3246478408299217db1e70a0a71" "/navigation/2aa4edf9d87745449ca90e76e5cee50f" "/navigation/939d3a9fb1684cedadb9e4e46bc115be" "/navigation/90e62db04b29408ea1b2be8e63af2812" "/navigation/39d5505c039d4c51913da596f9f1eea1" "/navigation/7009372a82494a16b3a2bebfbd84d452" "/navigation/9dc925c4df2741eb829df1ac329f7ed5" "/navigation/9865d6116f5b4ec79c1fb03726971dfa" "/navigation/cf564c773660410fa348cbd2cee4efdf" "/navigation/1703638604c8406789a2a380a73e1d19" "/navigation/83b43c1b927542e0a7ecc6e03144539f" "/navigation/ef5f6a85503844e28091d642e0e85fc6" "/navigation/830dae321cf64da0b5582f2cf2a2755b" "/navigation/126758734fef4b809922c23dd0eab237" "/navigation/08b4ffde5f7d48128d284989ce9c0a40" "/navigation/c20c13d4c3cf48aba2d16e695377b920" "/navigation/292b7523f5c64c7d92dbff1e0cf83a3a" "/navigation/a47567261b324239be84f344a7dbce90" "/navigation/c262b484fe1d43b59db9aa6aebb6121b" "/navigation/e900f5701c204c2aad195c1776f2396d" "/navigation/74730bf8952a47799edea0045e71364b" "/navigation/ba3fc06807ab4bb48519197bb6aaae72" "/navigation/2c35b04f7d3b4cb68d6127f16d4cf897" "/navigation/52e1082ded2a4e6c97357e215d10d5b5" "/navigation/08c6b36ef9e64646a1135a5082c714f8" "/navigation/cef9d9f8b6a74f57b1ec0d437d4dd63b" "/navigation/56d749fa59f34287ad1992e06dc99759" "/navigation/e8af9d34e8c34e7698a58806d8d075b1" "/navigation/7104b6b313d647e7af0f7d4df16132fd" "/navigation/5b7ccbdbb522430d9e344c1d04776c51" "/navigation/6a89dc98656341848c503037d3686261" "/navigation/0350a3ac21cb4dfbb8c48dea3ba561a5" "/navigation/2c14e9a944734510b3d6e36797d41126" "/navigation/11e007dc0ce24d8bae07662ead0d81fe" "/navigation/d200a9ae724f4abfa4863c17d8cfea5f" "/navigation/48cc04d481084c018b4fcec743b0b9d1" "/navigation/e86e4920d5474fbcadd14a63802e3b0a" "/navigation/e02c9ab6dc36416ca76a33b3fac76208" "/navigation/45418bedaeb2405ebaa73d1e548ed948" "/navigation/926ad84b88ef421e98af69bd4f55630e" "/navigation/48fc18ca0b5947d09c43ed1a46c0bad0" "/navigation/93eda06ed8b4404689c689eb346841a7" "/navigation/98c2148929fa4f539d7f1e01c6314a90" "/navigation/37c3293c7f8645deb75c3fd8098a3d6e" "/navigation/77c91d8dd4cb4bf78b224519dc49085c" "/navigation/276735699ea14461b87c5fcba9eda5aa" "/navigation/633e6c25dcbb469098f48f3c113c679e" "/navigation/0a43c732d5bf45d29474788be55ad747" "/navigation/103d8cbc0a9842c2a349b4af4675d307" "/navigation/56593f2b5cbf43a4bd285990e8bc1f14" "/navigation/9974171858f34b0d9fb3184fe5d3a30d" "/navigation/8eebace9a1264667bf8fd5956fe8e154" "/navigation/e9d77917c9894cf3817d1f2ff5971a25" "/navigation/ad622b67354e43c18db4ab8f8174d542" "/navigation/32594c8133d043bcb4c1ddfca53e24ad" "/navigation/721d0ff821324aa8bcbf7bf596301e06" "/navigation/8023b58c3a0b4c97940d73bc1675135a" "/navigation/c31643c51dff42e0b3b7621fe6f4577b" "/navigation/5534ba4eaa454957aaf064985402817d" "/navigation/a9ef860e4f3c4136b3858ba75d419243" "/navigation/69b7c98454ea449d9df68a9d84c058f1" "/navigation/78c1a4c8634041ac8c8191e4a2be1b98" "/navigation/12e79ce84cfa4693abc7c8e2a4a526eb" "/navigation/4d8db1d245894eafaf58ea8fc43784b4" "/navigation/5bdab2b7a6204afcb62a1158aee887dc" "/navigation/ad28106eb57d4ed79548ebb5fadf77ec" "/navigation/b6b07c162fb245f0987ac6e74dcf104f" "/navigation/05ef3890058145d3a714204208ac217f" "/navigation/5ea03a10258c410f9b1e25ebf93c34f3" "/navigation/a16b825605e84f6bb30af7f57854656a" "/navigation/cb654e49d7b44c7bba1d8aeb0f27a43a" "/navigation/bd2a701d528a4c96a33e0ef1e9bdff86" "/navigation/f360ae50fd514284aca189cd244b7e60" "/navigation/4276899d0e434748a1e015e5c252edf9" "/navigation/0fb71be444864464aee3a3cb6233e207" "/navigation/b506b3e3297c4858bf3bf55f15d0980c" "/navigation/8b479a9fe3444f0ebc57c2517ae49189" "/navigation/6b0f8e7c5bae4675a9a7aed6a5cea4aa" "/navigation/89e3090e15ae46d0a024847d582ee33e" "/navigation/0cd4961c87634a05a74c6986e35c547f" "/navigation/6336c6ab4e584e58a6d66dae0e1fbb0f" "/navigation/9f9aeea789fb4433af99d0cb16681e76" "/navigation/529acadc92874ff5930417368670021b" "/navigation/e395a6419022404681a31eced127c98a" "/navigation/49d08658787a4ec6a31ef2b952d01e26" "/navigation/042349af454b47ce8fbdfb9496b7b019" "/navigation/21ea08cfda7345f983a72eb0f2b37f26" "/navigation/f12ce59f19d74d0daa52c1a8bee0c116" "/navigation/42af64d0d6fc44ecad343550a992a981" "/navigation/8c1d2d71c02d41c8bcf5948ef8638d69" "/navigation/d253e2e7d7b24bb28604897d07524751" "/navigation/3659ad233c384bc2bbc9a21ba2d8cac7" "/navigation/90ff18ea6e444971a669280978573c3d" "/navigation/e84d563b080a4d02a2528e9d2df8aa66" "/navigation/0df85ac801854c518a93a44db4ccebcc" "/navigation/af5629889cd24007830f29606934c1b9" "/navigation/a2d827ce91f643129df2eae9598321bd" "/navigation/4e140ae831c1464da65c4f07e1c7a865" "/navigation/311e854d05ca4662a6ffcd5c32303419" "/navigation/5d619faf38784408bad2e8133b80fb0f" "/navigation/2f9d6a4f516143aa8309ce6e3d4b0e41" "/navigation/db74d58a479445a2b89a32687802efd2" "/navigation/45f897ac2b5547b1a79e2f8b284c50cc" "/navigation/f47b3ef3c98f4bc0a877b104715c800c" "/navigation/cb74ca574892412f945c141c2b0b82fa" "/navigation/3b599e1b8e714b94b20e61d060641bab" "/navigation/d76cb1fc89724488826218e97321b157" "/navigation/54a3ed7037c244b5ad82b90848b01e73" "/navigation/cc1365d01d144ce3ba3527da38254ad7" "/navigation/61a4097a41914190b954fb44d20157ac" "/navigation/459de429f48f45e89043511d73b3984c" "/navigation/ce1c988b1a29424f9a17027c9a8a9493" "/navigation/2a1cfc8599de4bdfae4ccff1aeb665bf" "/navigation/3ecab312563a47e2afe489a1962b27c8" "/navigation/2cf97ae732914d1a8d48dbd376abb619" "/navigation/a43f05cc7205443483a8180765821a93" "/navigation/ef3db90478e34dae854083f6bd779eb2" "/navigation/102e802eab1b4d358f42862d99b23c82" "/navigation/da03116d8a8e49819b9a7c33d2e5d677" "/navigation/8459c8e916c84fb286588e5d18bd46d3" "/navigation/ce90764563b345a29d327cc3ec62a719" "/navigation/107088faa25a4ce692645819f68a4a67" "/navigation/5bd2f2d78e9a47369d2cf6459ac7fa3d" "/navigation/e6f8c277d2e14123b65ce730fb915a96" "/navigation/13cbe6280d424c7abe43a3ea63628ca7" "/navigation/56b0805bff3d410c8b4aa6553f2a957c" "/navigation/660c2f2fce6547aeb88e880e8c99da57" "/navigation/93a56c1b01de423b92c5c935943f3afb" "/navigation/9adf19a7955f41deb8fa167877e6d76a" "/navigation/772344db90c2474c95ee47bfbc1e3fef" "/navigation/a232748df98340f09c422e777bbbdaf5" "/navigation/e14614f1e92b449abf042d57ad81507b" "/navigation/6001bd715c724adc8aee94b27beb6c48" "/navigation/05cd5bcb17c5450db4cc7c8667b5e63c" "/navigation/82279d6e649949bbb05c4a58f8432299" "/navigation/1193454537ae43c8892d8d35b175052d" "/navigation/a45a55f73c0d485ba81fde8953bb2a6b" "/navigation/4e541cbe68994953a1543d6171ff721f" "/navigation/ba8fb1eacaf446e2a85688890575ca74" "/navigation/defbe00c3e4e40c198954906b8f1e4c3" "/navigation/9c723704b0d647acb75c38d240fee283" "/navigation/c58d9eeea7a045e7b04b242a0efff857" "/navigation/3124b7a6748f476c8a4b4c867b23619a" "/navigation/7b395a0505af413a9ff3c311c7addcff" "/navigation/d146f83429e64cbebea7a923f5542eb1" "/navigation/8b97b064c0e04a32bb7480b1ac17db90" "/navigation/503132b77a924b1889efa8d5db72614b" "/navigation/47c700289ca542c985248a38cd854594" "/navigation/9f554d0dfc354a2a9a724b56630653f8" "/navigation/c37cfc1cfb2b416a9e7e0f09dece2058" "/navigation/1ecc2593e6d44a5299cb879b97ca7098" "/navigation/23bf741eb40a475bbe850f228e1c24a2" "/navigation/1140accfe02a4e58b73382838dc46e60" "/navigation/ee9ec87b4e7d4e2c8ea852cddaa01f50" "/navigation/fa08eefd851c44ad895e4b9838a10c5b" "/navigation/0086884597484e0e868b45e8b3e254f6" "/navigation/0498233c1aef4f068f27a5515edc673f" "/navigation/385eff86f90749cab695bf522fa597dc" "/navigation/d8748e3fd7d14ce1b8669b10c03eed3e" "/navigation/bdb794cd14e34b589391f207ab7c4f2a" "/navigation/c73d9c86cf93467a9a9990adfb212b83" "/navigation/9b38140f8563413cb1c328adaaf7248f" "/navigation/1874411844d24909863ee23853add3cf" "/navigation/358219c230ba4581bc5743d9ac0f1f70" "/navigation/29e64e9da5ef47d8b4173da7c7f1879d" "/navigation/94843b678b3c440bbaf33f9a19586366" "/navigation/17763bf7b5564380b0670db38ca7afbb" "/navigation/f82eee111f3b40f4975fec16de3fb663" "/navigation/18fd7c7c6e5e4c7cb720c5eeacf0553f" "/navigation/dc50dfd5a7b5426f80e4d19e33f208f6" "/navigation/3fb50d6f5dae4156881419c3517c684d" "/navigation/3c88decf9005444db6f5c7448e94aca1" "/navigation/5ceaebbdaabb491b9bc1fa08c650a683" "/navigation/f88484128335435a8bf7d2cf47723d5a" "/navigation/eb39e9f045974364a646083fd6c3e9fe" "/navigation/eea677564cf0450b953c8c5964e2b0b3" "/navigation/cb99f9cdb6c84269adb8cd1170d04296" "/navigation/28c3f46b0fdc4a7987ca9a3a59cc7cb6" "/navigation/6074eb07489440188e58407b6483e67d" "/navigation/2d39769e61fd44539246a56044acc244" "/navigation/b2a27ff1e1b84f1cb4a1ea2e36822988" "/navigation/210928ab4d8d4d9487b93bcc757bec36" "/navigation/8642934054a044e7a31706b8ab41fdda" "/navigation/cda9e5c1f13b4d0389ffea9c60985027" "/navigation/97f877318f104762a67c64b945191580" "/navigation/a8a1b01ce15e4719b2227e0ff3ef4054" "/navigation/2bb647edc46a4e20a437b817a67dd516" "/navigation/de3c0cadd63743408a4b865eb52a2821" "/navigation/64d1377b74334342940051abf06ba790" "/navigation/705d2c60338944f886fcd497f323ecfb" "/navigation/c199707a212f4e85908e7b61d122b526" "/navigation/d7d213df640548348bfbdc221a0cd6dc" "/navigation/a1583a21cf1b4db3b71d9267d29dbafc" "/navigation/662d56cbf0f04a89964445a216c135f8" "/navigation/9d24804feadb4d4f8c28aff1c0c3d922" "/navigation/3b477c2d54b144d69d069636916ff500" "/navigation/34c7c1a5a9a8410cb7f333a0482fe8db" "/navigation/4ad4ff5687114a9eae364bf56ac0c19c" "/navigation/b6d4114f528a4d39ad4355ce4f71c0e6" "/navigation/00a0652d67064f8e8f194a449c637687" "/navigation/16a7e1649dcb43d48843f845e5892045" "/navigation/b34a3c1598874de2a4354fb0758768d0" "/navigation/a0a91c6ef48a4ac793f7f1da34eec242" "/navigation/95d2694ad3f34704a9631a4bdfb3f976" "/navigation/4d0a7b08fe504f53a4fba98f45b37ce7" "/navigation/9d940d947a424cd3b75398c8e127e64f" "/navigation/a12ef6c1675c4e8d840c0b20026b7383" "/navigation/61dbfaade32d4d599b1eefebf8eaf2cb" "/navigation/a047a25df8c3466cbde8ee17c9aab6e0" "/navigation/3848d12b954d4b459421f54bb54b141e" "/navigation/373eed9bb60b439b856cf5fae6aac332" "/navigation/039a962c19044c98b3d4e8d7a1d03664" "/navigation/c67fdd0f7e8646e3bdc161974347f52b" "/navigation/dfb077d2436f42b2bb98c4ca5d6dc3bc" "/navigation/6b25664efe5543df9526b29128a2ad26" "/navigation/739b7945bcf748768a3c85a2ef4500b8" "/navigation/75c90486f8b64d2fb8eb61b8467db608" "/navigation/a2a1f7b1597f4140a485f4785ddb1a71" "/navigation/72bfd85836984d4c88f2b21701169602" "/navigation/5934cb1a43de4cf6922fb8ddf968fbb9" "/navigation/ac0f0f5a53cb4f988c870c3a0259db41" "/navigation/8ffb276e53b4431eb09876ae9b7a316b" "/navigation/9e7b09f843ac426180d22f58df8b5f80" "/navigation/901ab2201d8349a4a28c6cbd9a4e97a4" "/navigation/f01a4d49fbe0475e8f7ab9f584a4ca0d" "/navigation/863a491b08204e27964522254cf89349" "/navigation/f80eb2abdf4b4e65b378771270880d32" "/navigation/baf6d9a90e9b4800b8edadf0485ad835" "/navigation/f48e492d2662449a84f80584e71086f2" "/navigation/9b2eb4990bf940f68164b49569fc5c5a" "/navigation/a24bd59336f6475ba866b0ba42dd2ee5" "/navigation/a151d348ef4247f18019a5ef3fee0520" "/navigation/b9249ad3363940a19f5abafa802d8526" "/navigation/4c1c90deddce42c99ea7dfe335166212" "/navigation/785e44ee5a9143baa698730018709dde" "/navigation/96b24d37ae824c5885a62652158ad39d" "/navigation/9442c135fd7541bebc669d68aae2015b" "/navigation/98353ba1704f42d998bfb1b5ac39789b" "/navigation/3a6964ca5b6d469b99df56aef3f67390" "/navigation/a33b393982634a56800b93a2dd686f80" "/navigation/d085f3889c4d4e019afe94f0c87409a3" "/navigation/1debce35be8641e8a042be7398754cac" "/navigation/3620e89ad40d425e851f9a3825e9fe2a" "/navigation/064d698618f84dae8e2dc3a9e4651ce8" "/navigation/7cb26cd7edbb496c8f2632a40924804a" "/navigation/d2b91e0500994d83b24d536be636847e" "/navigation/6265bad774374cbb857570750d1091bf" "/navigation/5240a263cb294fbfbd3f45ba1215e629" "/navigation/ab7a1ac800cf4a868b890274ed63dbba" "/navigation/1948b7b4444f42b7a6c6f7411cd285e9" "/navigation/a37b3c2569cd49bab945d3fa2bdfd0f4" "/navigation/a78f6e40c4a6495baa212cd26e3fc69a" "/navigation/83de9da7cb614c27b1e74fcf6fc85568" "/navigation/aca3c28ec8e74305bade919c85b04a58" "/navigation/b3dc887185364ba5b3b8e55e6507cca8" "/navigation/ab58f573d56242098ac0d30c72670877" "/navigation/43f1f281793c4b30a40b828ffebd75e3" "/navigation/60892f5778a847e7a2401d5d6b0f451c" "/navigation/253b299936554c33ae12b6eaf12f7700" "/navigation/45f5a8b9578b42d28819d985131671c4" "/navigation/488591edfe8f4332ac3d873a1db6aa54" "/navigation/2041118337b048ca9b5eb17348dea630" "/navigation/f2fda94a48704d4d8f7162d50fc069fc" "/navigation/d8d3b694bd364a078f1ffc9568176be0" "/navigation/f7a96a6c37d64cd59fc1a9db22c31eae" "/navigation/e48fd3a9e6a043b583002748ca4b5354" "/navigation/87baa29700094da7bc79f135301ff020" "/navigation/05329c21a5ea496585a6b61b84ec02bf" "/navigation/4aa82e2207ab4da0a148e5698f6b5e24" "/navigation/f3f9f873e81e4f2cba079654fc64dd05" "/navigation/624f7534e0474c029ed4443a834dde20" "/navigation/93b84d54f10c448b8b503d2f0e9847ef" "/navigation/baacec5aa10c47a286e9df4448dbfd98" "/navigation/0b042b7fbc654c9699221d6bfdde2d63" "/navigation/7402adc727e24b4b9258b7b138dc057e" "/navigation/fa94921810f14b0487fff49a1813954a" "/navigation/ca82e07eee8345eebb574fa1c497e3c1" "/navigation/8991cfce42e74269a4a411d5466f1d0d" "/navigation/3aae51f7312347fc95a877a9ca3f98f7" "/navigation/ad7691390b0a416d92ee14a9a254a772" "/navigation/cba07b9243e24ad190f7d1cd283243da" "/navigation/a44ea0d1cf984f5e9b077a3e986b08e8" "/navigation/9ad60374fdd24abfa916c5815d55646b" "/navigation/5da9fff725ba48abab006ea7dcb8cd33" "/navigation/01de270e2ec8426e923d53ef3a19f205" "/navigation/ae69e3af91db4f00962328df1ed1998e" "/navigation/a87cad7a79a24c369571b542a4b75269" "/navigation/2d0d9616fd4042818c1a33ade2783784" "/navigation/2000fddb3d41482b93fc2ad17230a99a" "/navigation/662cf9d3b5e24cc3ab78329db473c22c" "/navigation/7705c771468d425f877c1cc8ea2d5ba3" "/navigation/015088ec1a9449c4ae548107a885387f" "/navigation/ce913a76490a4b3db77a9b1e830acdc3" "/navigation/67e8ac91278a4c92ad2b3641d0a1f5e5" "/navigation/b3a7c0b4174e41648c64b974a141df00" "/navigation/e3dbd97ab18d4b2684f036c770aa534d" "/navigation/c40b4ae0706248129ae11bf3c681ebda" "/navigation/1fa2d301ba204b7191e1f8d3a8183ffb" "/navigation/ff6fd6d36c1a49fdbafa16d867cb386c" "/navigation/f00d97a0d1fe45eda8186b229a1b01c7" "/navigation/4af7d561d9d5437faef2fc9c3dd6841b" "/navigation/4e827e07acad4d278e6fd8ae1c105d62" "/navigation/29dc1b34e1624462ba9a958ebcbf4d50" "/navigation/ac4609e8795f41c88070b5f073b738e6" "/navigation/cc15caebb8ac41ecac7f027c8c944a6d" "/navigation/1876ca32b0cf42eea4958a776411fa38" "/navigation/6acefc19db2947a5aeb7bac8dfaf423b" "/navigation/5525b9cf35e345d1877aa2d3c656bc84" "/navigation/f042461e706548948363e3d0446b7947" "/navigation/bdcb83263e974b8882eaa28cf13ec8bc" "/navigation/9abb17b08d504e24af9e9ec85dd349ab" "/navigation/45a1c845fb974a6ea50aa0e5302636a3" "/navigation/a5e4bb51873b4b5b81aacea6dc128e92" "/navigation/f9251cdd2fd14cd49d55050f3446b458" "/navigation/f9eedd2e667a46ad990aff0e2ce144a9" "/navigation/e8a92a84945841f7a21883d0b6375054" "/navigation/97d9c06700ab4dc597675338db04b5b8" "/navigation/6cf82af0c4fb4fcea7aea18edb981e39" "/navigation/c6ff6995fff946acb96c87aec9e27aec" "/navigation/f07e9166fdb34a39949dd1bb2e33a3e9" "/navigation/871a2df9a5b543669224cd075587d48c" "/navigation/02bd1ea1915d459a9a003703422f8dbc" "/navigation/0d997ddc45814526ae3261a6668711b8" "/navigation/64f477cec0404591a7b3de0a9ba9e365" "/navigation/1acef092c841489f9cdb634a9ac8b970" "/navigation/41fbaea8b145493fabe4b2ed8d1dab27" "/navigation/b6d1b76cf0374d0ca34f960ed2f885f1" "/navigation/a2724dc3054b44ca83fb5b955b2988af" "/navigation/728f2ecbf3f24f3b9ee1fcd916471f88" "/navigation/f3855a80ec394d629240b8c01fbb8f4f" "/navigation/e09dcb51cca04e28b3affd15c9c8ffdf" "/navigation/a028cb8e1092498f8e0dd2dfaf1ef1e5" "/navigation/207df15a3b9043b3a04a9e2432b874df" "/navigation/a3f010babc0b4b5984c7ac1e506eb74e" "/navigation/111960990c4c4b2c8f8e6450ba7ec4ae" "/navigation/0e044408e4e84a6994d8230ebc907bc5" "/navigation/417bf5953ea446f0b8104973d4eb0927" "/navigation/921004b0adf845f6be97839f59dabb30" "/navigation/31237b94b55e49d18cffae26a2a79eaf" "/navigation/51b8dc780cf448beb27c38f9b4efb1d9" "/navigation/7320f45e1bb54035aff89bdb2d0cd6f1" "/navigation/476e9727f1cc4da295b5487d8597a52a" "/navigation/663ace2af40b4845bc54f3b529a5a0d4" "/navigation/e1db589efb3b46d1af2ce61121340b48" "/navigation/6bd99a91dee7435d9254b2026efc2afc" "/navigation/4f093eeed6af4a85ad316ac565a7d664" "/navigation/37bfec11652640289eefa04b0294ed2b" "/navigation/8e435540846b420e9a4f2b5c4ab73ddd" "/navigation/03755b6a47a94edf88c43da3b2150697" "/navigation/946d49dd5fdc44f8a8d93476e2a0fe96" "/navigation/6988975f64e148d7ad3bbd50453393c0" "/navigation/9d659a4bb8b14e628260289b5d09a4af" "/navigation/da97fba9cddd4e618b17fd74d24aa268" "/navigation/3a2fd8521bef4c478af75fbc1b8980fe" "/navigation/0ba09f9f88124c3cb98cc5de17888998" "/navigation/647562dbd8694aaa9960550cd46422fa" "/navigation/4af94954b06e44dfa5767dd41920ff61" "/navigation/080c2b3d77b24dc897df78c0d9df9a28" "/navigation/04e6433955bd45a7afc001417fd230d9" "/navigation/617310e0c009422fb7576ae1726d770c" "/navigation/752a7d328ba54d4c92c554cab5a06ca9" "/navigation/b557228f29fb430fb32436a645c26bb6" "/navigation/abb7c3f0bfab4169b59618892bdf4abb" "/navigation/3bffe126a0da44bdb1928c6d0fb0943a" "/navigation/6aeb0702b7a646118788734135f5b4ed" "/navigation/fb6aa7e3ffbd4ca9b9b083d8aba61e54" "/navigation/93931c09da0d41ec9146318f6bd76f34" "/navigation/4741e7a7f32b4c5595499a66b6382f6c" "/navigation/1b3159d8ffac4657a674f3442f99469e" "/navigation/31799a88f6a74fa9b6977678d6874a64" "/navigation/975a8024dae14339b885e88fa6fd871d" "/navigation/c9062aa757064596a50d23aef8459506" "/navigation/e481aedf1c5b46ce8ea4e1c141e33eb4" "/navigation/aa6ff5fdbe6e4e7595887fd810979cfa" "/navigation/f1d85dbb996d4ee2a9fbec3d8feacf01" "/navigation/12aff995e05944009016c6fe9def28a0" "/navigation/0e5c89f111e447f7971ff451925fa6b5" "/navigation/664fddde916c4fa2bd23360c40de6bcc" "/navigation/67bb213d47b445d9af5ebdba6f31dbb7" "/navigation/199f1787cbbd460285aefc5104c6114d" "/navigation/db7b310a04ba46a085af9cbb4c9bf73e" "/navigation/4b62271f138d401388ac431573706572" "/navigation/96a4e5bea91a46fdab28419bef4eb294" "/navigation/29092496a7b4428aba27a44cd14c4fd6" "/navigation/4ca9103db47e462e9234c1b6df149b96" "/navigation/e392c2a1cf4445b49173f3539b181b2d" "/navigation/363e4bc7034d473ab46686138855b0a0" "/navigation/b740032bf99747df9d8f922e35247893" "/navigation/2ecff86f351a4e44b68bba771f95031e" "/navigation/9877514bb988461ea80af4b7a720d30a" "/navigation/0f6aabc4cdc840df849ebdf5c97e17e6" "/navigation/662c4bed67d642439d24983a7952d7e9" "/navigation/d9068fd351c34dcdb4b1bd4f1fa27437" "/navigation/3bb3ce64459948afa3dc94177fff02ae" "/navigation/a86d1a44a90a4eadbf2d91ee3e26159b" "/navigation/2fe8553385a94a398292e0e2c2bbea9a" "/navigation/49ca2a113e024b03aa56bbfedf36d5f2" "/navigation/cd218c4783bf4af28f640e54063aa0d6" "/navigation/5deaa7b4545f458a9a8624fbeb86f346" "/navigation/605283c817f0427a970e2646e134aee7" "/navigation/487e3124349f4e268b459c191032e2db" "/navigation/acc38b76aa48446b8f5400e83a0669da" "/navigation/603e7d7227a04a7795d948e8ead1e394" "/navigation/b229febeef3848c39612e647635417fc" "/navigation/7cbdbc5c2c6542a7ad5c7078034cb0c0" "/navigation/054efac0f22747c9b5dbde5586e4d204" "/navigation/1178ffaa184d4353a9803a905c786b55" "/navigation/dd3b9634dfdc49968b75f807882e2dfb" "/navigation/91065897e9694ce1a512b359b37c52d5" "/navigation/2db7828758f04819b83b383465a89bc9" "/navigation/d84c57b8dc7049aeb935abc94d2419a1" "/navigation/b747ae7f531342fdb53a9dc93190289b" "/navigation/11f7e9d5e4144da7bb6aec820c9b7ec7" "/navigation/f9875e65257f4bf79f0fccfbe53373c2" "/navigation/43bcc9aa558842a4b3105e0047432a90" "/navigation/73097b9d7c014d319e6afe337f42d501" "/navigation/9eb51a543c8c4b27a0fa1135887cabd0" "/navigation/855e1fd4b91040c08d3e861431943a2f" "/navigation/2c28f28d32d84b9baf962a9a35124485" "/navigation/e5a56cd1b5914b9ebb1e75ebcd539244" "/navigation/d6b7e6e1d2314addbd9c2ba036cd0ef7" "/navigation/587a6a9154ee4dcb811a88d80aeb4c70" "/navigation/32bb26fa7085438eb732d3375dcdb9f6" "/navigation/58eb6e61e8b64b6c8633d897c0d156e2" "/navigation/6cf3b1f1b1e244c89cdf326c07e6af3e" "/navigation/4c4c9e79d1ac45c5ab3cd9c243192b7b" "/navigation/38fc4b8bf09b49f68ff3ac84efb80185" "/navigation/870bf6419f7c474ea1dd236dddc0e8dc" "/navigation/d491413ef6f44927a35fe361342e61aa" "/navigation/079581a98b7d436fb092c463c68c56bf" "/navigation/e2a0ddc5ba1946e18787525ae8089c63" "/navigation/ba5172c13a2d491d847a7be0c8e9440d" "/navigation/4ffa5f3c2b734685920cb7afd7060ff5" "/navigation/fc298c8bf523488a8a760860354f2980" "/navigation/d824a0e4619248ae8887dd981c7eed33" "/navigation/a2dff93279fe4efda3cda56d9ad7016a" "/navigation/c5beeb4ee5684ddfad64c82b0f4e36a1" "/navigation/7cb30b10d0b34151a8d26ae13045566d" "/navigation/ff4946021370467084b82ec9322c5781" "/navigation/3ebe8671135e456bb20cfacc86e6aef2" "/navigation/120f30a2860b45f3b328fdca709b4638" "/navigation/60b18f1a112c472f89821377ccc3e472" "/navigation/bc9fe769d41e48c68f4814984e492e9d" "/navigation/3ebd6362bdb940f8833520517094ea3d" "/navigation/c868549e82434bf5a7c2ab6db425f54c" "/navigation/fd3dc3f628834d93b1e5409776db0aef" "/navigation/33d6c83f9c65465bb34c4408c7943426" "/navigation/3b9c0332d2c546179b31381e4967247f" "/navigation/6a62fb1d6fe648c6a7113575613ceffe" "/navigation/55c241b7f0f74541a2d9f4f59de101a5" "/navigation/04a9162fd88343b2bee2922c6a3933c3" "/navigation/88c11abb608b4104926339d255514d8f" "/navigation/d90e6a307a13490c85ea53bfb8225941" "/navigation/a5f2ba9fa64c40f98766017bdcb0f9f9" "/navigation/ab73ba4766b8422991200a4c9039dcb2" "/navigation/e652b94f3c1240709e1086e0cf799a0a" "/navigation/8a79e002b76f4f9c9e0af39b38cbbade" "/navigation/506face1073c475986e0723997f1acd2" "/navigation/99daebbaaa53493ab2622d976c5cc08c" "/navigation/1f2440ef1b0b4664a8021e076bb3635c" "/navigation/aad59831ac754ea1996ee39cd740a724" "/navigation/20405538802f42308ecd99a32bbf0ab0" "/navigation/2e84e99115f447e2bc4c569b1c90d9eb" "/navigation/fc7474716dc545ce90ad51805c725677" "/navigation/3b0fab017f6a4a29bac8fa17b8ffb6e6" "/navigation/f8533072245942d6b129960783555b9f" "/navigation/5bd31ad657744749907960d92ec94d5f" "/navigation/caf25daf9912443ca2d97ae047e00ffc" "/navigation/b14b7fd16520401a959b70bd656dafa1" "/navigation/963f7efab9f447f78b49cc8ab0e9e932" "/navigation/b4848b7f7b934be58de9ff9b1a425463" "/navigation/64ba3ad9391043a5a0945f98124a010b" "/navigation/7896e7ad4ba54e6e9005eb3d8866fb7a" "/navigation/b25481501021412ba751b79ec51924ed" "/navigation/db0dc0782b0f4c6a88afd513308fc955" "/navigation/786e49b3975f4321848322f3a8987183" "/navigation/cbd1ee9bf668411782fd7f5a43068d11" "/navigation/75b08504c63440a6bf060ad6d187d15d" "/navigation/219e994953ce40a7aa5591b4468ff391" "/navigation/376e992bd0af4bfda4b392b8778392c8" "/navigation/dcb245a9118842baa577cf8edb9c83ee" "/navigation/0fbf559690a14cecba56ca93cd54f31c" "/navigation/ad1073aa5a1249098103f464ec12ac75" "/navigation/236bbb93472d4fb699c2b732fd490395" "/navigation/7292e5ed5b124c5eb2fef16ef6942d74" "/navigation/0cd3b9e5387f45758d7e2a02044d5b94" "/navigation/d80951a4a8bd44e1a1275f6f48d6c246" "/navigation/07783a3906f341eda07fc8ce286514e4" "/navigation/d78c9b72d51f473691f2be26de356df0" "/navigation/cc74cbb5777b4e068cfb786c6491a765" "/navigation/13aa57dd8ef14c959a1be20cfaa5990f" "/navigation/e320b1aec0524f7596609a6624f60681" "/navigation/9949f46878574f6b818aa8ac5222592f" "/navigation/ac8af6a27e7545b39dc8a1e23002852b" "/navigation/e2c84efb315c4db4b0fa5a30c701261e" "/navigation/5beda608a85b4b7fb605dedf9ec628dc" "/navigation/453be49bcd4b4e9e9205ca3be8077775" "/navigation/9ae8b878e5bb40dcbf95b4a6890eb91e" "/navigation/9e005947e8f241c785c58624cab40dc4" "/navigation/93bf30a18d3a4b82b2629c475d7a46a3" "/navigation/2c2a2266e4d343a7a8de089645e4c07b" "/navigation/4a0235d9e26f4589a46bc2b3e7ace653" "/navigation/8014696d02764e5e8d6242db96c27dec" "/navigation/ba29bf585c3b4f5db4ca4527dc09a3b5" "/navigation/634b42593fd6478f8236e20bf5592426" "/navigation/4cee136394594dd6a1e4098d94536491" "/navigation/2da3c1840e8642599a3519432e34239d" "/navigation/1102d089464e4e0db9514eae5dc522c4" "/navigation/ba78f50e92e4430da13a382d44ec33e4" "/navigation/e59fe81273294f7cac38e92909a97f8d" "/navigation/944ac8c53ce241e38628bd30c6592889" "/navigation/3df3dce7f5944c17bd6462aa6f0e326c" "/navigation/6d6c624d0e9641859b8c83ec0ce0d363" "/navigation/6036b04af456466480f6b18a534dddb3" "/navigation/b88076452ead4032984556f08d30adbf" "/navigation/4906f225a8874aa699aa6e10ff24913f" "/navigation/a5635d992e9f454f9defaa08a4905640" "/navigation/794c23edeee74b79972f6cefdffe48ff" "/navigation/d0db2b61bd414192af90fc4ec0908c8a" "/navigation/5571001050d740fe827b9bca9c7e7d71" "/navigation/184492ed989f481f92906c94a6916821" "/navigation/18ab1c160b9f42afae74c5b4f3a7dd37" "/navigation/703d48fd7a764e5f81ef679b4f6c31ee" "/navigation/ad3afba64239493bb8336750103f702f" "/navigation/93df50b1db384c93af53cabc3cc56989" "/navigation/01564ddb68cc4502930ae5cd0dfc92b0" "/navigation/6fdbad9d65d14b25a0b7837de1a14851" "/navigation/d151e7b3996e4d62a33c4407602bb4b8" "/navigation/eef19c974cf14c268a14126734149310" "/navigation/e3428a4fc8a94529af2c9115324712bc" "/navigation/a1afb05d81ad4911b04f2b7ac41b1b61" "/navigation/ffbbf80fc912436eb1f798aeedbb7ac7" "/navigation/a3074c694f86457faea1905e7a96c57e" "/navigation/e3a12f6219594b5c9b55364dc67c2dd1" "/navigation/cd2ae601d12047af91755a543c349d6a" "/navigation/5801a041f73845e6a47b7709d95ab2d2" "/navigation/2c8ae1b20b0b4308920afde9ec8c7892" "/navigation/919860e767bc4b41926c1e3106cfe4ef" "/navigation/4ea6006c3a504fafa93d868ef03ce9fe" "/navigation/dc85892f5f494dc78b3090859362c2ca" "/navigation/8e09b77402dc4dff9f4d41ecb34650e5" "/navigation/661073d7d87541788addb2ced71d0e84" "/navigation/26300e2fcacc417198ea4c03f1b3d94c" "/navigation/341f0256cc6744f793f0a425aa65deb6" "/navigation/57a858e364a546b393d63c7fd7b74c0c" "/navigation/cb35abc65b2341e2baf95fa7d48e6e33" "/navigation/05beeac20729448c86ec6e2719283277" "/navigation/e4c141eb05154bc79f91b9a4975da6c6" "/navigation/f6cf5d97d448459db5847cfd991973e7" "/navigation/7bf3d5c2a1bc408f9f967a91acc1026e" "/navigation/7d2cca29ab2d4b67ba7a0bc269b151b2" "/navigation/0786baeb48e746f886f81681f2d6c439" "/navigation/091b557f79be4502aa1644055c201371" "/navigation/442b32cc1d714d039c6e06177d696524" "/navigation/edc6d2a4deb34dbb980babf1790a5a6a" "/navigation/bc43cf46e1ef4e52808cde72e2d9ac66" "/navigation/cf3e456c29da42c28d547b94e377178c" "/navigation/d51af834e41b4d78899f4d15a5103fd8" "/navigation/5f3f88b007114b948e128fd1f2d1cd02" "/navigation/f307e3c3920641fbbc1021c55296cf68" "/navigation/26bf98d40a904d1da65305d255f92252" "/navigation/dd549d5e34724648810821f0898af186" "/navigation/acdd15ec4c3a42c988225a8105e2c453" "/navigation/1f7dd5269b4a4222a620a0bb3ffe4f4d" "/navigation/cd6842b5a4114fe7b54f578fcbc4f418" "/navigation/2dafa257dc014664bb05fa11ec1e775e" "/navigation/7acd8ad7850249a2800ca8c060a93906" "/navigation/766b55537e494404bc234e72cb8bd37b" "/navigation/88bd418e49644b13a0b21efd26e6b010" "/navigation/59fa376c770f482db9f65133928fbddf" "/navigation/b1c5a4827eeb43f9ba8c55680bc87d71" "/navigation/79f2587baf864996941608cae4ba227f" "/navigation/a5033d90e29f41b6ada3a337f51e776e" "/navigation/2cd6fa398ffd43f4a78c3fbe6c8e161e" "/navigation/4c0ba20984e34702b2f7470b3060a888" "/navigation/fc1a3272db29453093a9290b819d467c" "/navigation/a9e6456f23224b79a9822511063dae8a" "/navigation/8318a0d0fa3849e3ac53fb3a2e5b17fa" "/navigation/99e9207daff743e485dc5ac6f5383115" "/navigation/cc6e09e7ac5f4a12a64d0ddfdb25bac5" "/navigation/fa11a80968d148ffb143a8a592399a2e" "/navigation/85db616dd1d146dd908824ddb4bb30b1" "/navigation/29345574223d4b698774affbd34668eb" "/navigation/5826400639454ad0aabb2bbf394ae8ba" "/navigation/70959083e47f49c08fcf6ff6465474b1" "/navigation/73f2022e95f74243adadc3b22f6da71c" "/navigation/9583cb3b0b69413dbab29f9d428b74ad" "/navigation/744fd765901f4e9896d699781652a067" "/navigation/18714fa48ec64603b0d570c3c6d926c1" "/navigation/00efcb417c7f44a39c8eab36a1458749" "/navigation/96dadb2a387a4db39944df47350af2de" "/navigation/792933365c704144a10f13d6986e687e" "/navigation/04e61861db9b4f1b8b1be3eec17bcdab" "/navigation/12ceac1b7c3c4743ad8de26f8b74efef" "/navigation/3e7c5975d0c3479d81f65f0de00e1db8" "/navigation/914259851f784ab7ac247e7500c9efb1" "/navigation/8cd0ba2a738140288c55f1b16d23d1f6" "/navigation/b52b2235e86449029e0c0f23d2a1f04a" "/navigation/c019a062be5740189303415af8d5ab1f" "/navigation/600b73f077034b988880d171d25392d8" "/navigation/badc0e7bfd144d73bfd8b13d2bdeaa7d" "/navigation/a0219d85cf8244c082fb0306818fae7e" "/navigation/90775f48aa794e36be79bf183b4b95e5" "/navigation/abad6e417a4246d2b5682ebcf02bf79c" "/navigation/e91878f572de400fafc96bc9e2742b5a" "/navigation/823ed3444a5241bb829b4165e4c9ea5a" "/navigation/8493a20954e1464bb0320281e2d59739" "/navigation/5bfa01fb4c684a2a8554185769c9bd71" "/navigation/94c922987a7043e6af44c648c2681918" "/navigation/322b6caa96f84bb0a0be7aec904b2367" "/navigation/001c1ad347d845648bb1a4f717cec770" "/navigation/0ceaff7a01ca49aebfe4501183526e88" "/navigation/216b3ee3b9ea491c97ace886c9310788" "/navigation/fa0e61d9bf4642d1bca163c8e97dbf3f" "/navigation/b5d76c4fde384c8e873602bd64f6b256" "/navigation/7085a848c5bd48b883f34aa49613d64e" "/navigation/bb51a35d9ef648a686b045dc1bb705b4" "/navigation/592fabcf6039410bb06fc5dc65898b14" "/navigation/b8051170d4d841508a7250edb389b825" "/navigation/d050618ec81346a482d46ed04618f909" "/navigation/c3d75bdd693a4173967d6ca30b92c2d2" "/navigation/1d96b39fc835496aa93d8b931deb0e5b" "/navigation/f4f48f177faa49b0878b4746365f7522" "/navigation/13a7e4d6106b4eed86423656f5510c29" "/navigation/45632ca143ad4a0e85320bf5cda18960" "/navigation/30bd16895d64494692c2ecfae1ff1ede" "/navigation/44c93150519f4d3881e27e9f87cdef78" "/navigation/3c989a48bfc3482191d12c9beda0627b" "/navigation/c40ef72259be451395989b23e5ca7935" "/navigation/7508bbdca21d4ba988b129cc4223f8c8" "/navigation/162aa8330b7c4b2db0b112d0cfc2eb41" "/navigation/ab89c4d529324c86adf5a20723400eb0" "/navigation/338588f1ca1f4c668b986debc93d6168" "/navigation/9193ae5bd87040ab9855844882c26c84" "/navigation/0672bdfbc0d04cb6b907932144424d96" "/navigation/f4d2266b6917418ebfc08a41dedca417" "/navigation/f024d910790441ccb74d29a24ff70337" "/navigation/16f9195b681e44958e47e3b0c5489162" "/navigation/b650f27e6093479cbd16644db7572722" "/navigation/112b7f0098364d2b86d9121eb7e7cd8d" "/navigation/902ff3363ccd4eeb82978f1cc22831d7" "/navigation/c00dbe47dfee477fb08d9811c4b6ea69" "/navigation/69b5f08db0da4c34a5286e817f352bf1" "/navigation/6c51b6266f8c4fd3920d514fb9c083ac" "/navigation/f02b94a42fcb4ec0a45fb7ee6a47004f" "/navigation/e46a9ccc342e48f3867737f2428aa9dd" "/navigation/6c4b1d9d2a51416f8644f6fc905afd67" "/navigation/d54ec2de3de04629b5d88a842698c61f" "/navigation/b898667fbdd14e72bf5c10c6946cf6f1" "/navigation/29a8f4dbe27c47feb358c560efb91f27" "/navigation/dc430beb743d4fb28c8f4f82542e8797" "/navigation/6c736abcd2c64d3da06d9eae6229c487" "/navigation/38718fe709a04e53b8358cd9fc276f86" "/navigation/6cecee853e4f44e0a965547acf6de1d1" "/navigation/25a76866c7184477bf488015e9596bb8" "/navigation/15e97405a111462da1a6d6f4a7c689a9" "/navigation/050509d950e5436c8e9aa71d68792297" "/navigation/235bbd1c055240d99e4685b33e989aa4" "/navigation/b6866c7e0b8b42faa2a8beaa4081db7f" "/navigation/0e42ac0d04644c428781e5671aebed50" "/navigation/0986f503168947b1ad36ed94e2b57d89" "/navigation/17b0e623bbb442eb91747d430aafdb46" "/navigation/7b31ae4a2d8c4fbb9e06115cbbcf5ad2" "/navigation/c5fc54f7493348398fb1ed8458c74100" "/navigation/f322c1b04f1d4c41ba534e4c0356fa1a" "/navigation/2bb1934e766b4db2bb0102faf3d30338" "/navigation/6e34c9cc121e4d13a7232abb6b89fee2" "/navigation/53b444ec25d44265b9ecfc3a112a51bb" "/navigation/5a1353ec45204ff3b3a077d75f8c6265" "/navigation/6ba851d48ff14bfe8d89d4fb43ead250" "/navigation/268efe75bfc6496886a79d8b78eb0069" "/navigation/ca11d1064a444fcba0b44070e23533a7" "/navigation/46f38208f42a4194a97ad0e29d2dea98" "/navigation/e5597ae9456f4a88b59474ddf8ed8c29" "/navigation/748a1ff94d1b426692ac1b53d2b8030d" "/navigation/1d4db0e7e96e4d8db4c2a6f056096bc6" "/navigation/6c9dbe029a6d4d5aac7cdcf577aea8d2" "/navigation/6caaf81c9699495c98b9d5d908187265" "/navigation/5b6bdc203e944107b27776bfe749be5f" "/navigation/75247516ca2d46db967ccaa1e383e0bf" "/navigation/082b6982c48a453398a98042d5408de6" "/navigation/39877c39496240ce833acae6d85cee5e" "/navigation/8eaf19a54a3c400c80b8a956c061c714" "/navigation/b67c5fc296704360bdac287d26897f3a" "/navigation/ecac2a29338744089fa520ab5d2c1c55" "/navigation/41b0a14b403243fd8b489739f7a0dc9d" "/navigation/dcc69f1feec1453d8035f93b6bda81b2" "/navigation/ab16141ae46f46b193fa3b3805a16476" "/navigation/946552da9d1946a7ac353c8321830b3a" "/navigation/a1ac7070669a4e6bbc36ff89c450f5d8" "/navigation/a94aad7bd234451dbc26ec5ac4c00d11" "/navigation/6dadfa617116437b87d4aa14a5b84e96" "/navigation/4ff63a5e8c874f8297b3b90d6ce12972" "/navigation/be68ca655c884cdda806f86d0abe4a89" "/navigation/d6e3034a504243a6977b90eae635ee8b" "/navigation/b3b76a8f7d424bafbb96057672d8911e" "/navigation/34cee49d57784459b321b0c3073d0cca" "/navigation/e28ca353f8d246cc8842b89de79bb0b5" "/navigation/6592690d6fea4eea8acdacdfa4a87c48" "/navigation/2a0dc659f7f1443eb5f6349b3e77fff9" "/navigation/c35a3c110d87458999107f5b4619437c" "/navigation/05d8e2ff853845699400560ce8076818" "/navigation/3c632f41dac34107ab03131a2120e5f3" "/navigation/89fbfd5715e748e5b1591c9beccafcde" "/navigation/26ddc42e6b3d42a5ba1abd392763ef30" "/navigation/5378bdb5377d42fb9ff52f650d95b6f4" "/navigation/30f993a81333422d9d37503158e3348b" "/navigation/87da6af0344c4d1382cc61e0c202763a" "/navigation/5f42f60c83b1485b8b3503cc34164502" "/navigation/cd78542613464c16ab9ab4a13d26adcb" "/navigation/dfa35cb0def8488d8c14ae5bb1874439" "/navigation/08303181880845d8b8feeea15098dd1b" "/navigation/c6c1c65f8fa74dae9346018a9ca28603" "/navigation/3839ae9aeb5d4258aca9b0488fa418bc" "/navigation/077605863bcf4a9f9aa82d88bc0c2736" "/navigation/c6b0c58ee88f40808ca03812cf6b0f92" "/navigation/4fc07a8907334b1993199049575988d4" "/navigation/2b72d7787fda4348aa0e6ab21cb02b4d" "/navigation/376b1be7ac504978902183c695b7bc5b" "/navigation/5888e9b361e348378a3dd3a7f72c4fac" "/navigation/a8870dd790ca48399155ac4ceb519f82" "/navigation/bb2b42455b2e425ea5bd49897e7f5c8a" "/navigation/805a8665669c4dbdb898d7a8ed004d0f" "/navigation/585493f114f74754bde3d1c42eb04050" "/navigation/cb7c66df34aa40e9be6de3690be1c013" "/navigation/1c319842da514ad5b78de5f090f00d91" "/navigation/51ef361fabee47b9a9d5291b8e0b19fb" "/navigation/f76611349f8e4bcaad20a8ae8597048a" "/navigation/81ef4e02f2844b1789481203d312a34b" "/navigation/a72f300975e54cf99aa5aed797f6ffb4" "/navigation/b371a4cd45e749b089fd9739b672c7ae" "/navigation/7481817d50344e3c8343f5dd8e179a74" "/navigation/e7376dccd1024c37a180e92985b856db" "/navigation/61d33652baea4da19f13a3504f92ec55" "/navigation/0e5143ff667e43b0bf7549b7643cd856" "/navigation/1b960a43008d4e819722dff471513888" "/navigation/054eb33a47d4418596cecf5dcadc1c81" "/navigation/8a8f6fe8177a4bf4b4f14f4822f0fbcc" "/navigation/8ddcd0f7134b4939adff56bca6561287" "/navigation/028855986e114430ab9d295b6f1d95c5" "/navigation/b0b7cf0b31a140a6aa3b2c64174c7b70" "/navigation/d7438daa464145ddab05e55f36d5a880" "/navigation/7c4f72a3b8ff4a1daf6dc5afe7c21078" "/navigation/dda348a4a9cb4aaa980bd4cd9bb2c2c2" "/navigation/8869c2eb9a3d4b0eb1dd1f43d2c16508" "/navigation/67f5e603f988466c956441d3a56f7260" "/navigation/afb5b3a08c2c40ddbebb6505b9acfcec" "/navigation/6e84484aedfa4755b90f9b99b6bf8bed" "/navigation/5739b23edc834ba5b04faa94eec42658" "/navigation/4bf413e3f2714e3cb58b9689f285ad48" "/navigation/fc14fffadb5c4125969d309f302c28b9" "/navigation/65f54ed2ebb14bc1990458477f04f041" "/navigation/e119dc2f89d74c74a35c6c655d1f053f" "/navigation/0b37d7c2d2b34d53983d1a4a62395661" "/navigation/38c4bc50106d41c8884cf0f72ada9956" "/navigation/a7c87e32f0534ce0a8d6d6bea5d473fb" "/navigation/02b01e0284ca49a2aa2615fa5bdb373f" "/navigation/4c85286228794409850aa1cb8bc2d210" "/navigation/050bf9043a924844abb183908dc1a00f" "/navigation/1d4290c208694584b44564f00a7364cc" "/navigation/a3365427e0704ce5a2ddb8cd156fbac5" "/navigation/9988256e2e61465f8ed9ebcb2369f0e9" "/navigation/97cd41cbdafe478a8fea5ec9865eef93" "/navigation/fb44468457b84c3b90b256cbab98eaa7" "/navigation/8df4965ee6044b9d94af2172e1b4e03e" "/navigation/b183e7e3efb24563b4b6c719c121a923" "/navigation/c45ab6c18ca641f891f80bf9e119a11c" "/navigation/4189adfc341e4a239f8fb255763d143f" "/navigation/c23ca291431a4e5aa87bf9c67f98e62a" "/navigation/ba37e7b7255046e29b1386245f72aba7" "/navigation/b357458d0f8743ec98d07b422b99a3d9" "/navigation/ab74a141e46d4e49bb6bef7516da3acd" "/navigation/b584516592404b0e9909c4e79cbaab6b" "/navigation/cef39987f6a04ef2ba1c37c4d5eefa8a" "/navigation/3242612e12ad4a93a7b7dca052ebb939" "/navigation/255dc198e89842ba8c09e1d1ee9c8ef6" "/navigation/af285f64b6d14838844f8db7550fcc85" "/navigation/f9de03e9d2e843989290805dc44452a1" "/navigation/a93f914c305f4747b4ca30372c999ee4" "/navigation/e5356903a0544915bcd4fcd1ff4884ef" "/navigation/cd1483ae759e45eb9880d8e54c8cd8cb" "/navigation/0c014c1eae3a45c79986fade0ca7b728" "/navigation/5cd8c585bf5f45728bbbc617d9a82fba" "/navigation/080b3d614a534dc4b816ad554dc14be4" "/navigation/dad7afc1117a473296db6f90060e4806" "/navigation/b672e0677d754fef8f6c4d5e346c239f" "/navigation/560a1bd5a15e462b9de3a84a5f81cf2e" "/navigation/98e4899d8c7a4cacb495a3df29956254" "/navigation/eeef904cefc84d5bb2da8381fe9de6b7" "/navigation/b3caa397bcb24f5ca88a02ceee9dc182" "/navigation/6319b83ecae04029a60d2148e5bc3ffc" "/navigation/c9675b1e98db4f8ebc105c20f366a7ca" "/navigation/babad7c6eff04459b63e3b0b2686b3e5" "/navigation/37932f3b3880416c9c1f16c251dff1b1" "/navigation/759aad270cba4713aa076bd2fad62381" "/navigation/ec38284413644d309bfa5b9d490ebac8" "/navigation/6b37a9e7de9e42df91f08cc31e395fd9" "/navigation/72f8627af825479abf8f87510bf67989" "/navigation/2f7651480df4489c9683b922704cf96e" "/navigation/b6053b94a7a04dfaa6a727c712a1d18e" "/navigation/a1694ce59c5842058289fa24f2f991f9" "/navigation/115db71e08b74b38ab08b3527c351182" "/navigation/28cbc559caec459f8eaec246677911e0" "/navigation/a03d5e63f4da4ace9489f138d41e8b1d" "/navigation/c9b9288e60904900867151f4d5704ad9" "/navigation/0db4847d8ec54f969455b282def9551c" "/navigation/dc5c46da4af5448c8fdb478837639e69" "/navigation/b98d440ee7ae417d85f79e885ceb49a6" "/navigation/aca12e73d12841a1abf1f4e672499699" "/navigation/44bd4717a32c4abca37543d70f46bd9f" "/navigation/6164a1cb32154a4180443a92b1416a0a" "/navigation/a2a3c0183e884474a340877f5485f636" "/navigation/c404ec5a7f844518acd4c7bc2676de55" "/navigation/461210a2fa404845b52c5a5b074a74ea" "/navigation/db83921c8588411db2912bad2069a706" "/navigation/59c8478c42c04cb4b71ee82939c56cce" "/navigation/56af967e2c504139ab97413f87a05b17" "/navigation/9efb56bef5b944fa8595254a46f48521" "/navigation/5cf6d4137bc54855b5f0cc91939558fc" "/navigation/6355f38488804d3892f82f79946301a8" "/navigation/de5e2c8f22bb4a56a3141eff942aa339" "/navigation/ee8c26fbab5e433ea8d8a9b600783161" "/navigation/a3fb628504b04e87a34aa4603defd42b" "/navigation/ceae4a5bc8b54d18b6b6e39f86a7ca94" "/navigation/3e84db9aa308409fb2fcd2dd3bbe9ae9" "/navigation/572979cc7b014e4199d23eb500f030d2" "/navigation/8c5c2a96a5824c3a898f5800835f8dfa" "/navigation/a934400833b04bb2bd660ac8b384de57" "/navigation/a7741e23916b4f3cac963d15fde8d1a2" "/navigation/aa10a61b91ed426ea53479d1c94f017d" "/navigation/7f68c873a87840f68e4891c52036e707" "/navigation/65f6ca3ee85242f6ba81395050ace4e0" "/navigation/9ff1e6d56c3c4ef8aa3b8636d494f6e7" "/navigation/9579c2b8e09e4665953f7b7b6c8e1a21" "/navigation/95e89894cba847fe841032f85517d822" "/navigation/ab58dbe78c6b4f0ba8c0936f48dc4dea" "/navigation/71e46d87ff414ff19511d4c59f6feba2" "/navigation/d70c504c958447b1b94302056d6844f3" "/navigation/3f702cf61d59488e895cd8c3f5feeab5" "/navigation/c103b247bc2349deac8df1b413981dae" "/navigation/e0fc9b2654424448a5dd0b5fff06221f" "/navigation/1b171a33c0f8472193e4f814b49396f6" "/navigation/146aeede343f498aaffcda474d1d2efb" "/navigation/f5d42316dc9047a69bff284475ba9c2d" "/navigation/a1a166f4f3ce4048802b262e796ee002" "/navigation/bcf42e29b14e4550aa35dcdd0f66b342" "/navigation/c38bb0e8aa604996a62d453d3e29f6b3" "/navigation/b095162d7195485db1b078ca4b5474db" "/navigation/fdfbec066b784fbe83a51c50d513a8ed" "/navigation/5ccfac472df845298ce1f89433cf713f" "/navigation/69d7144065574515bbe621ca953b0361" "/navigation/f9245183a70e4f98847c1fcbf9fa869c" "/navigation/d7fecd04891a430aae5b931772c39107" "/navigation/a40d969a4d71484d8a40494b17d0d102" "/navigation/67e5642d1b7f43ad9467c0b9832417cb" "/navigation/93af7bba83eb42ee93ee7f9b7350d05c" "/navigation/619eebaec3ad41a29035acca563abac7" "/navigation/18f4cd9cfde241a3b038a9d244a34b43" "/navigation/617659a247eb4968bfbc1afdfacd71f7" "/navigation/5b912eb20c994007a4f51193a25b2384" "/navigation/3ab2d3ab3a814bfabb167095c88374e6" "/navigation/beded29615d54841b4d74d2a6be495ff" "/navigation/1b901701444e4b9294bce06ca518dec4" "/navigation/4af5ec38a0784e1ea31389a262375b90" "/navigation/c40af39073634fda962a36793ae99e29" "/navigation/bd65de36d1e44f4aa3275044659ee157" "/navigation/ef0a98108dec463c93112f204dacc3e4" "/navigation/2060c445275d4b7499f99492b72cf0b5" "/navigation/26834614e920406ab807f904bece3dd5" "/navigation/4bce5357f311435a88d3e82f3e8860c0" "/navigation/afb877dd8ac54cabb3e836cd6fa8d277" "/navigation/d18ab5a3cb174a79bf46c701dc34b071" "/navigation/f2ba2abda557499ab3aba879702e80d8" "/navigation/6d323a02d1a24cd685f60a361adc9e64" "/navigation/24f1a093a7204c9daae9670e5b4fc6da" "/navigation/46845c07befe44c59d5a8d2682cb9bd8" "/navigation/befe827aeba24e84a8b6a4c98834162c" "/navigation/bda76cd8f8d944a4a2f44776be9d03d3" "/navigation/3d346605b46b42fa987a47dc69236a12" "/navigation/57b44f3f08f540298aa2b2cdf36c6ada" "/navigation/ace4a6782ef2474ca2eba6991ded7733" "/navigation/0e11492b45e9449099af49d080966657" "/navigation/9e9dcc42203f407cb6e64d078378287d" "/navigation/7e5895148f4d49f48f6080f6632cf751" "/navigation/f77a561a3bdf4c2d9d6cf62676b5ff17" "/navigation/1288d07fd7f44d17a75b85a59e9ddddc" "/navigation/310d3423f4cf4560835bc92a5f07059e" "/navigation/90095519af9e4d459454029544956f39" "/navigation/7a7c912b7aa74b7489f66e56dafc9caa" "/navigation/15b0e7e1ebe74fa6833d253d2c8a85a2" "/navigation/b32c52594fc94ae7a6b5f52d8f5afeb3" "/navigation/ea1578cb57d34024abeabc10ac3807b0" "/navigation/a6968d0ac89c4a248fb44d3cd1a29ce0" "/navigation/54bcf683926144ccbeafd8e73bfe1cdf" "/navigation/479f091dbf6646f3a97dfef04393f423" "/navigation/35fee1790fdd44f6b5caed4783a1a631" "/navigation/011488290ed8409f93f2d628f36dbceb" "/navigation/2b386942cbee4fff8c31ddb411eed2c1" "/navigation/83260d287313497b977fe33731c6b46f" "/navigation/bfc62775ffa9412b80e5a73a68849321" "/navigation/023d11b9816841039e4845d5c4ab315d" "/navigation/197b07fd64bf4c948a2496f4a62da3bd" "/navigation/08906c95541d4ce6b1f8eae884e42b4b" "/navigation/9a4b1c0e05ab42e1bf35d8b578af5732" "/navigation/3a84dec3cdc64ff8a6cf6b6b00c1d50b" "/navigation/765ee961f03f4d8eb42322dfe7c69b3c" "/navigation/a265de0e21f54cfb8458cbe55d98b7c6" "/navigation/3b839ef50efc4d41833e86905b01c553" "/navigation/f2199f85d6b14dcfbd6cc2ace235c6c9" "/navigation/56df705c82a5485c9bf1179bd38dd986" "/navigation/04400de74cad435b9f93d1b590424f88" "/navigation/557e8aa517c94c958188e2354f37909e" "/navigation/4ed5d158a59a4e2faa1e2d8661efd0ec" "/navigation/4c67f2193a184ef9b10915d5e58d2bd4" "/navigation/c5fe6153b08748d2b37cdf1f607c556f" "/navigation/b0c4303406b6421c9681ec1b452b0919" "/navigation/6d0e97537e8846238b010f48fb7f00d7" "/navigation/2b25194728fc47d6bb1eff65f5cd6630" "/navigation/28752dbf192a46f580e408cabcd86440" "/navigation/2f6aa92917544578b0d37c0d24f68952" "/navigation/413bdc500ede4cbfbc5390ea0de9fcb8" "/navigation/1c5743efe87b484fa4036c0dba92dc1c" "/navigation/46fc7ccba25547bfaba7bd8dd1ba2944" "/navigation/4e087d73197a4f02bedaa884be0d4c5b" "/navigation/5559c6a1d5c7462b9952a911287a639f" "/navigation/e91e7ea3574b4fe1bfb3e410061f0b12" "/navigation/c5d7f3bf3cbf4e5c8483bbcd82ae9126" "/navigation/ee24ac8840c8427e80b2968e73bce58c" "/navigation/f1463a7d4ac84be78af110fc135558a9" "/navigation/b8f3646b36574f758294c712933a3088" "/navigation/4073c5fc166f4f509721352e48b76ff7" "/navigation/59d5180e6d45481ea014ae88a4931fef" "/navigation/9bdba23d1f134bb682c48a75ead9927d" "/navigation/60f66648c8454fd98aefa227eea835ad" "/navigation/6c819ba579734614b7c19e75cc6cf9ab" "/navigation/9e5aa35cd26d4cb7bc99f85410bd7a0b" "/navigation/bdf7a268d8044f75be839074e78c7554" "/navigation/ec075369673d4d238b3efb54db87c9b7" "/navigation/fb39a705774e40188ac5d1e81e453a82" "/navigation/e1b8d99b8ee34c5a8d8a3d807a1bf839" "/navigation/72d0981cf87d4f9b8e7e0cf0e63c2eb7" "/navigation/4b3eafcc124d469eb14677823b22cfd7" "/navigation/9fe7943aa8d64015a5d71c09db14cd09" "/navigation/8670c866309b46a4ac73c040e0108fc6" "/navigation/1e2f4c3278fc4010aaa5996486adb694" "/navigation/59b5fe6ee9d34aaf8c6d94b0269220c3" "/navigation/69df9e0e485541b69dd3f2383698b6a4" "/navigation/c29d14fa1e69426e94d23667e4940ad2" "/navigation/42b3abb93e02430ead568ac132197433" "/navigation/8794e4c7c031411cbe9f815af10f7475" "/navigation/4cd3426194f04362ba26e826b42b8906" "/navigation/0990dd68a35640b19243f8621c0ce105" "/navigation/2eb9e5ee95f140999a9085443d828ccc" "/navigation/3197a8b084504392bd4d80a98dcce09d" "/navigation/e6450f002553477982905e0476c03bb0" "/navigation/0560092c083f41b5ac742b0a67deedb2" "/navigation/36533033271f426eb757b10f1e3255e5" "/navigation/8734b85fb5ff4aa4b65113bbb6643130" "/navigation/00dc62a0f2f44a73b2cfdddf3f16e48d" "/navigation/37b519c0dfa7479a9f9b7451bc86521f" "/navigation/29307f2d64584ace816df9044524a34d" "/navigation/1ae6bf82e1e54ae686b4f39f52c6978e" "/navigation/82a3de8333bc474ba3558c77a0424c71" "/navigation/a459f49d2d0b46728f5e1fdda19ea168" "/navigation/78f9cc0518044b3eb60ca4dcd9200c06" "/navigation/551c62e4eb344a3cb7a295f561a9a5e9" "/navigation/7ab96ba55b994d7b9f6c927e19c99c96" "/navigation/cd41a83fbac14cb09f0229a16e0e26ef" "/navigation/61b484407a714dc1804179a99e1ee713" "/navigation/142a83a6303f417bb7a859a4d0054cac" "/navigation/574cb255d364491c80ff15cd9de208fa" "/navigation/2bb98feb27864a1e945c13abdcebdd2b" "/navigation/6e2e546cdc014b5b91deaf272b32790f" "/navigation/df9842ec588d43ea80aeb0319a537420" "/navigation/f3567f7cd68544b8bf8b2c0b33b6b11e" "/navigation/97ea19299012479198f7b16e0e4778f6" "/navigation/24980e8439fa4cb6bbc81edef7ae8508" "/navigation/476729ba224e4bd69bf7e89a1b26d52a" "/navigation/af666c656da64a838bf04e77108e834e" "/navigation/8f582b58056e4a3f85135595f15b8e19" "/navigation/4edb621164f14b719db184df17279c76" "/navigation/e58e1f674a054f5e9ce477c300ff888f" "/navigation/560360880cfc44fa98b21b3eeb6d0ae5" "/navigation/a37daf9408ce45c386aac1357acc9f46" "/navigation/8deef35d7ccf45a4820265e2bfac53ca" "/navigation/57550eeb564b487ba0956322d7f2e954" "/navigation/b871bc99e6ef49ff8b73dce63586db34" "/navigation/6fb978fe885840e2b697735800c10598" "/navigation/1adb2d241c9440eab7d5ec0d066d30eb" "/navigation/bbcbe790e55940359f6edce561a771f3" "/navigation/0f251f520b3e4f509ddde608e76bbaf2" "/navigation/068e97c9ea1241c08c36ffb1955e003d" "/navigation/8c54f1d04e2c4fd684d4a84d221ef9bc" "/navigation/44e36cdf01bf4bdc9248676fa561e951" "/navigation/8dd1143c73f845ffa2f64d24538b8b58" "/navigation/ac58688be10f4e238dc92038d78923b0" "/navigation/0dc956497ea749ba8038f57faaec9626" "/navigation/24e48599822041c3bd7ac9c28d0ebcef" "/navigation/19b3f680e98e4773803da71dbba9264c" "/navigation/fc3403b5ba79499c88fdf03babb4ab9e" "/navigation/f76262e6336248059de89ad22419a32a" "/navigation/cc3732eaf0cb42a68c0337647b2f5619" "/navigation/39eb5fe003df41d5bc8fc306db11bbf6" "/navigation/08aabcd4de3948c5abd8391a548610b8" "/navigation/32e1370b21904bd3a38b5bbbe3672bb8" "/navigation/17514c05d9ee46aeab869443beaebd70" "/navigation/74ab93160d234b9c801a87cc9352e2d6" "/navigation/c5a8fc5bc1894d2ca9b4add2f4cb43f9" "/navigation/f6ef2404833f4cf2ab1302276be42c8e" "/navigation/6218aac51a2e4acc8a18df36344b0559" "/navigation/2287658cf4894f0691307737b5c9b9fc" "/navigation/aa04914e60fa459ca4adc41734caf65e" "/navigation/56c8d31c10274e878ee18284ab13af2c" "/navigation/230a46579128485aa0d8494f31a8571c" "/navigation/9520879840e84aeeb9c20792da3ab42d" "/navigation/e1789a54bfd944a1bad01f45f21b3c24" "/navigation/f5d1019e9a28402cb1164c8e672d3d88" "/navigation/36647b20879843d78e65beb7ec88a42f" "/navigation/31b6bc150ea94386af4941872eac97db" "/navigation/9ebf72d5c9b84b4a8d538dc67c6e2f45" "/navigation/9672fbdccca9426faef5af3ba4cadf96" "/navigation/2891ad58db854977aa433e5989bd6095" "/navigation/2e358924ab49446dad68218d0a7c8e9e" "/navigation/85bf0e097ae647cca4e9de2ae536789f" "/navigation/f039259b20ea433daf03b12381cd991d" "/navigation/11cfb075c698479da58a9916c1ba52a4" "/navigation/e41f2062e8b4436db4b9d2eaffc19814" "/navigation/fb71795099444816914811be86f177ec" "/navigation/99e3ad81341744d59f73be6d9fcdfdf9" "/navigation/ca97773362c543c9b3b7f4907402bb3d" "/navigation/1a90256778cd4a92a750cba34ba7a055" "/navigation/7c814ce9db0e46fd8c6ac11aa80eb1ea" "/navigation/d7828087c4ca48219ba112e04e068f96" "/navigation/b5645036268442eeb140cdf343eded68" "/navigation/f15e736a20cb4b3eb052c0c62bac9e17" "/navigation/4887eb58d4ee48c9bed69e5dcd2adfa1" "/navigation/9624c28e502642a7886056bac20a524d" "/navigation/b6a6d7f6abea437d96cf1126f8dc9f64" "/navigation/bc278268e9be4b7e83bf6d03f92fbdb1" "/navigation/4d544b96d1d643fcab399428d7c40507" "/navigation/c7d77b34349649aea3d847b81eb549bd" "/navigation/645eed602772483eabc0e5bd436ad89e" "/navigation/7732cfa84cec48b09863da52a24de817" "/navigation/4ae6d812981e4b678ecd2d7feeb5879e" "/navigation/b6c2ea7aacf5479094dd51728f03be8e" "/navigation/ca1c0be4e77843de8647da88394521f7" "/navigation/2580a420c4ea4caaa62b5870c548c38a" "/navigation/41ea4da0abc748bf82840540e919630f" "/navigation/cdb96e0ffdb24896ae7eb7a95ec62bc9" "/navigation/d197c3c2eea84520817137ac8ff5bf89" "/navigation/74deab1c77f84d94829d692cd3e79325" "/navigation/cae3f333ae64457dae03dc5062b9f68f" "/navigation/4e8922f1b15c45fca165b9c08682a3b4" "/navigation/117cd18789964498bd483c64764eb38e" "/navigation/46f4086aaa9f446e889248b68f02cf47" "/navigation/c42259200ba54e3ea4c5957f6a85ae7f" "/navigation/7f29df31ba934100aa6e8b977a0ca61e" "/navigation/151c6f4152634af48c01e16a76ae0d74" "/navigation/3917fd58650643f7a8ec52f3256980c9" "/navigation/5763a1e32fbe4d7583a8c08349a5a971" "/navigation/4aa960db10194bdf9a1e9319c7e2e555" "/navigation/b33e469e0e944b04b8701b9d6453a8b7" "/navigation/a3871c72142048caaafe81694637da21" "/navigation/7a3368e58a824773bc7ab4dd9a60fe0f" "/navigation/0897f29951c64ad5acdee7c0d3ab0b16" "/navigation/32ec1ca51ff94f51b892f4c140d52749" "/navigation/94cea3d5af7e4b369621616055b102fc" "/navigation/5f97d7cd2d0a4ce8bc8e3746dd55b82e" "/navigation/c850d2d1961b43b2af466e7396b4bdb8" "/navigation/2fdb61ecf40d476f96792122267824ab" "/navigation/1f1a595690424a6bbf939617fed4d712" "/navigation/1726610ce7934dcab6e5272f2c332127" "/navigation/2f0363e0dd5d4fed913e6fd7d1505f7c" "/navigation/8e0bc067f57b41449fc095717e1251f2" "/navigation/0e91e4ce64f5415d8d97db06b8cad87d" "/navigation/158acab745914d3fabd60ad28b8a8a83" "/navigation/94e1136e8c0345fc8c2b3cda0acce1b0" "/navigation/f403700ed099433a86c61fd94b5e2089" "/navigation/f297c32c731544af853eac4260b07121" "/navigation/06b77ed720624b1aad5e088a8d41b6e3" "/navigation/2330db0c57a44ebf8bda115bf7746844" "/navigation/d8fb2c75461149649a398dee791ac58e" "/navigation/6179847e63984bdfb33138ba86af4d0b" "/navigation/126f2248c3dd4162bbcd8c5e5f071dbe" "/navigation/c3ecc1fe0f0f4826947025c2fa8993ca" "/navigation/5debd09ccade423a963f04db7ecf25cb" "/navigation/2d027605d0de465e9aa7b42c906d2510" "/navigation/7f885d4866d84b7aa74200e21ea8e99d" "/navigation/6175057dedbd461f9faf1cc6d0893418" "/navigation/e8d5e1e8dcf7493d830d7e7f591b4d65" "/navigation/da7aac5b22494cd49fcee5443f936e68" "/navigation/a893d9c8a2af469286192f1a6835839b" "/navigation/f9b30617f3844f92b85148cfc7687377" "/navigation/e27f2d79a22c4a218dc4270594649e95" "/navigation/4a1f9fc01a68400ab9ae5f4b69057573" "/navigation/50e4d93a0aef42c9b604749e2f506cf4" "/navigation/cbe9e52c082b49f0a82f32961f3f0bcd" "/navigation/09395f63403f4824aa32443370c8fa26" "/navigation/5c8ed3075bd04e138851fc95889e1ee0" "/navigation/684e78f0549e49b8afa1f69132cbb399" "/navigation/7399ff7d59c14cb78f85d66fc5abb4e4" "/navigation/1888cf7b06f24a5fb66b4670f097a226" "/navigation/cf1d96d97dae45408c17feff34fae182" "/navigation/dc35bcbeccee4a1084ef1cf31c016ae1" "/navigation/2a86c80cac124762b159aea0bd559a2a" "/navigation/b195b1d5856949c18d7d765fc972f8ff" "/navigation/0c064ba8bbc64222a76c6f7c6085ee1f" "/navigation/bdbdad7b7f8947f48e96cb35ca142b2f" "/navigation/09c6d364c9404264ad0487521249cca0" "/navigation/245f0cffddf44371bc63855766ff7f15" "/navigation/a79f757eff9e447ba3b8a8818c98cc49" "/navigation/35d1cf895b874857b320103ed97ce8c7" "/navigation/19e3b20486b24cdfba9a7e2955d43bd4" "/navigation/3da052acec7945fbaf7f12c3592100b3" "/navigation/8ffeb136f5f44ba889b4e5fd62cf9f02" "/navigation/27cc46f2d2b74420a51270f203c58e59" "/navigation/0b42aa3f73a44dcbaea7c22d81faddb9" "/navigation/2dc01d9e744b4f69bccb8ca52b735eb5" "/navigation/3a32e5db3a2b46cb903a66e5e96475a5" "/navigation/6784fa20664840258d201f3ba861f1d1" "/navigation/2e197f74e0c943eb9bc9534bfe9643f0" "/navigation/53d0723d03de40fca58cf47d5113c935" "/navigation/df845aacb0474e688c58024e2db6fe6c" "/navigation/b5c188b6389c47be9807443737b781be" "/navigation/32bf87e808bb4e1882745666930d4e76" "/navigation/368246bfa40f4284a42ce116f908906d" "/navigation/74f440e8782a4bfb835841f1821de745" "/navigation/8cc57e19f717456281448bbdccdf4501" "/navigation/6128e0dcc816463e9b033f6b91859e2f" "/navigation/c899a174fa8d4954ab801857d74e65d5" "/navigation/66e439a271aa42d0a585064df7d6f7d5" "/navigation/3f4b2612dc234fd498a72ac993364fd9" "/navigation/43f15943690741b6938ba9425998558a" "/navigation/467b8a2e61714a57a633f191e30387d0" "/navigation/f0783cc01d6d4728a04d82eb5cc6c703" "/navigation/ee334471b5f243f4883d14cb967b3d64" "/navigation/0213b13f11f64557ad1ef4129a883fb0" "/navigation/4efe5464ecba46f6b07ae099001be7c4" "/navigation/d723c38b455749e5ac2f8b41148d19ef" "/navigation/97940dad821c452a805784712d7a3a0b" "/navigation/3fb1073fcaa047ebbf2191ec078ee014" "/navigation/13ee48fd68624d81bb5e48bf66ec58b2" "/navigation/fb2ba549259042c9a7ab27fb6b40fa70" "/navigation/b3e6d112887d4b64b4931162d48b1292" "/navigation/5fa439afbcd7473b88922090cd5a2848" "/navigation/d8bd45d860e7494096c9ec73e078d83e" b"#»Í\rZþC\x07++Ý—›gA" b"jŠQ\x14kßE®„¯ÅhpuÓ€" ] |
||||||||||||||||||||
|
13.29 ms (6.89%) |
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%" "%|3963b5d57dc34cb58630373d88a2ed9c|%" 6 true true ] |
||||||||||||||||||||
|
3.84 ms (1.99%) |
5 |
# app-scripts::refresh::read SELECT `app`.`id` as `app.id`, `app`.`name` as `app.name`, `app`.`path` as `app.path`, `app`.`author` as `app.author`, `app`.`copyright` as `app.copyright`, `app`.`license` as `app.license`, `app`.`active` as `app.active`, `app`.`configurable` as `app.configurable`, `app`.`privacy` as `app.privacy`, `app`.`version` as `app.version`, `app`.`icon` as `app.iconRaw`, `app`.`app_secret` as `app.appSecret`, `app`.`modules` as `app.modules`, `app`.`main_module` as `app.mainModule`, `app`.`cookies` as `app.cookies`, `app`.`allow_disable` as `app.allowDisable`, `app`.`base_app_url` as `app.baseAppUrl`, `app`.`allowed_hosts` as `app.allowedHosts`, `app`.`template_load_priority` as `app.templateLoadPriority`, `app`.`integration_id` as `app.integrationId`, `app.integration`.`id` as `app.integration.id`, `app.integration`.`label` as `app.integration.label`, `app.integration`.`access_key` as `app.integration.accessKey`, `app.integration`.`secret_access_key` as `app.integration.secretAccessKey`, `app.integration`.`last_usage_at` as `app.integration.lastUsageAt`, `app.integration`.`admin` as `app.integration.admin`, `app.integration`.`custom_fields` as `app.integration.customFields`, `app.integration`.`deleted_at` as `app.integration.deletedAt`, `app.integration`.`write_access` as `app.integration.writeAccess`, `app.integration`.`created_at` as `app.integration.createdAt`, `app.integration`.`updated_at` as `app.integration.updatedAt`, `app`.`acl_role_id` as `app.aclRoleId`, `app.aclRole`.`id` as `app.aclRole.id`, `app.aclRole`.`name` as `app.aclRole.name`, `app.aclRole`.`description` as `app.aclRole.description`, `app.aclRole`.`privileges` as `app.aclRole.privileges`, `app.aclRole`.`deleted_at` as `app.aclRole.deletedAt`, `app.aclRole`.`created_at` as `app.aclRole.createdAt`, `app.aclRole`.`updated_at` as `app.aclRole.updatedAt`, `app`.`created_at` as `app.createdAt`, `app`.`updated_at` as `app.updatedAt`, `app.translation.label`, COALESCE(`app.translation.label`,`app.translation.label`) as `app.label`, `app.translation.description`, COALESCE(`app.translation.description`,`app.translation.description`) as `app.description`, `app.translation.privacyPolicyExtensions`, COALESCE(`app.translation.privacyPolicyExtensions`,`app.translation.privacyPolicyExtensions`) as `app.privacyPolicyExtensions`, `app.translation.customFields`, COALESCE(`app.translation.customFields`,`app.translation.customFields`) as `app.customFields`, `app.translation.createdAt`, `app.translation.updatedAt`, `app.translation.appId`, `app.translation.languageId` FROM `app` LEFT JOIN (SELECT `app.translation`.app_id, `app.translation`.label as `app.translation.label`, `app.translation`.description as `app.translation.description`, `app.translation`.privacy_policy_extensions as `app.translation.privacyPolicyExtensions`, `app.translation`.custom_fields as `app.translation.customFields`, `app.translation`.created_at as `app.translation.createdAt`, `app.translation`.updated_at as `app.translation.updatedAt`, `app.translation`.app_id as `app.translation.appId`, `app.translation`.language_id as `app.translation.languageId` FROM `app_translation` `app.translation` WHERE `app.translation`.language_id = ?) `app.app_translation` ON `app.app_translation`.`app_id` = `app`.`id` LEFT JOIN `integration` `app.integration` ON `app`.`integration_id` = `app.integration`.`id` LEFT JOIN `acl_role` `app.aclRole` ON `app`.`acl_role_id` = `app.aclRole`.`id` WHERE (`app`.`active` = ?)
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" true ] |
||||||||||||||||||||
|
3.40 ms (1.76%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"‘ü¿ ‹ÝEî‚X¾wnƒ"
]
|
||||||||||||||||||||
|
3.27 ms (1.70%) |
5 |
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:
[] |
||||||||||||||||||||
|
2.63 ms (1.36%) |
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.fallback_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.name`,`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.customFields`,`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1.languageId`, `shipping_method.deliveryTime.translation.languageId`, `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`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.fallback_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.fallback_1.title`,`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.fallback_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.fallback_1.alt`,`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.fallback_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.fallback_1.customFields`,`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.fallback_1.createdAt`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.fallback_1.updatedAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.fallback_1.mediaId`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.fallback_1.languageId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.fallback_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.fallback_1.name`,`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.fallback_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.fallback_1.description`,`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.fallback_1.trackingUrl`,`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.fallback_1.customFields`,`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.createdAt`, `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.fallback_1.languageId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId`, `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` AND `shipping_method.translation.fallback_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 `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.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId`, `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_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`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId`, `shipping_method.media.translation.fallback_1`.title as `shipping_method.media.translation.fallback_1.title`, `shipping_method.media.translation.fallback_1`.alt as `shipping_method.media.translation.fallback_1.alt`, `shipping_method.media.translation.fallback_1`.custom_fields as `shipping_method.media.translation.fallback_1.customFields`, `shipping_method.media.translation.fallback_1`.created_at as `shipping_method.media.translation.fallback_1.createdAt`, `shipping_method.media.translation.fallback_1`.updated_at as `shipping_method.media.translation.fallback_1.updatedAt`, `shipping_method.media.translation.fallback_1`.media_id as `shipping_method.media.translation.fallback_1.mediaId`, `shipping_method.media.translation.fallback_1`.language_id as `shipping_method.media.translation.fallback_1.languageId` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.fallback_1`.`media_id` AND `shipping_method.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"h\x1C–\exOI÷‡&\x1C‘›Ìó™" ] |
||||||||||||||||||||
|
2.39 ms (1.24%) |
8 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||
|
2.28 ms (1.18%) |
5 |
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:
[] |
||||||||||||||||||||
|
2.26 ms (1.17%) |
1 |
# 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`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId`, `category.translation.fallback_1`.name as `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb as `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config as `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type as `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link as `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link as `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab as `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description as `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title as `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description as `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords as `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields as `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at as `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at as `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id as `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id as `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id as `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId`, `category.media.translation.fallback_1`.title as `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt as `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields as `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at as `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at as `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id as `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id as `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"9cµÕ}ÃLµ†07=ˆ¢íœ" ] |
||||||||||||||||||||
|
1.73 ms (0.90%) |
1 |
# category::cms-page::association::sections::association::blocks::association::slots::read SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.fallback_1.config`, `cms_slot.translation.config`, COALESCE(`cms_slot.translation.fallback_1.config`,`cms_slot.translation.config`,`cms_slot.translation.config`) as `cms_slot.config`, `cms_slot.translation.fallback_1.customFields`, `cms_slot.translation.customFields`, COALESCE(`cms_slot.translation.fallback_1.customFields`,`cms_slot.translation.customFields`,`cms_slot.translation.customFields`) as `cms_slot.customFields`, `cms_slot.translation.fallback_1.createdAt`, `cms_slot.translation.createdAt`, `cms_slot.translation.fallback_1.updatedAt`, `cms_slot.translation.updatedAt`, `cms_slot.translation.fallback_1.cmsSlotId`, `cms_slot.translation.cmsSlotId`, `cms_slot.translation.fallback_1.languageId`, `cms_slot.translation.languageId`, `cms_slot.translation.fallback_1.cmsSlotVersionId`, `cms_slot.translation.cmsSlotVersionId` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.cms_slot_id, `cms_slot.translation`.cms_slot_version_id, `cms_slot.translation`.config as `cms_slot.translation.config`, `cms_slot.translation`.custom_fields as `cms_slot.translation.customFields`, `cms_slot.translation`.created_at as `cms_slot.translation.createdAt`, `cms_slot.translation`.updated_at as `cms_slot.translation.updatedAt`, `cms_slot.translation`.cms_slot_id as `cms_slot.translation.cmsSlotId`, `cms_slot.translation`.language_id as `cms_slot.translation.languageId`, `cms_slot.translation`.cms_slot_version_id as `cms_slot.translation.cmsSlotVersionId`, `cms_slot.translation.fallback_1`.config as `cms_slot.translation.fallback_1.config`, `cms_slot.translation.fallback_1`.custom_fields as `cms_slot.translation.fallback_1.customFields`, `cms_slot.translation.fallback_1`.created_at as `cms_slot.translation.fallback_1.createdAt`, `cms_slot.translation.fallback_1`.updated_at as `cms_slot.translation.fallback_1.updatedAt`, `cms_slot.translation.fallback_1`.cms_slot_id as `cms_slot.translation.fallback_1.cmsSlotId`, `cms_slot.translation.fallback_1`.language_id as `cms_slot.translation.fallback_1.languageId`, `cms_slot.translation.fallback_1`.cms_slot_version_id as `cms_slot.translation.fallback_1.cmsSlotVersionId` FROM `cms_slot_translation` `cms_slot.translation` LEFT JOIN `cms_slot_translation` `cms_slot.translation.fallback_1` ON `cms_slot.translation`.`cms_slot_id` = `cms_slot.translation.fallback_1`.`cms_slot_id` AND `cms_slot.translation.fallback_1`.language_id = ? AND `cms_slot.translation`.cms_slot_version_id = `cms_slot.translation.fallback_1`.cms_slot_version_id WHERE `cms_slot.translation`.language_id = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.cms_slot_version_id = `cms_slot`.version_id WHERE (`cms_slot`.`version_id` = ?) AND ((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?, ?, ?, ?)))
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\f\x1A[<Æ]A|¨\x1AIì.¦êD" b"\x13#ÿX~íCÛ²'þ;Ñ»õ\x1A" b"S_\x1F銃E\x18—Ý1\x1C5T¶=" b"\x7Fñ*p³xD|œ–ï\tœ˜‚6" b"œ+!,iäK¾Œ„-Ând±" b"Æ\t\x03yõiI©½rV³\x10\x18\x07" b"î‘&äÍÔL§«Þ.\x18žÎh" ] |
||||||||||||||||||||
|
1.49 ms (0.77%) |
1 |
# generic-page::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.fallback_1.name`, `shipping_method.deliveryTime.translation.name`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.name`,`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) as `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.fallback_1.customFields`,`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) as `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1.languageId`, `shipping_method.deliveryTime.translation.languageId`, `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`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.fallback_1.title`, `shipping_method.media.translation.title`, COALESCE(`shipping_method.media.translation.fallback_1.title`,`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) as `shipping_method.media.title`, `shipping_method.media.translation.fallback_1.alt`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.fallback_1.alt`,`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) as `shipping_method.media.alt`, `shipping_method.media.translation.fallback_1.customFields`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.fallback_1.customFields`,`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) as `shipping_method.media.customFields`, `shipping_method.media.translation.fallback_1.createdAt`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.fallback_1.updatedAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.fallback_1.mediaId`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.fallback_1.languageId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.fallback_1.name`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.fallback_1.name`,`shipping_method.translation.name`,`shipping_method.translation.name`) as `shipping_method.name`, `shipping_method.translation.fallback_1.description`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.fallback_1.description`,`shipping_method.translation.description`,`shipping_method.translation.description`) as `shipping_method.description`, `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.fallback_1.trackingUrl`,`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) as `shipping_method.trackingUrl`, `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.fallback_1.customFields`,`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) as `shipping_method.customFields`, `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.createdAt`, `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.shippingMethodId`, `shipping_method.translation.fallback_1.languageId`, `shipping_method.translation.languageId` FROM `shipping_method` LEFT JOIN (SELECT `shipping_method.translation`.shipping_method_id, `shipping_method.translation`.name as `shipping_method.translation.name`, `shipping_method.translation`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId`, `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` AND `shipping_method.translation.fallback_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 `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.deliveryTime.translation`.delivery_time_id, `shipping_method.deliveryTime.translation`.name as `shipping_method.deliveryTime.translation.name`, `shipping_method.deliveryTime.translation`.custom_fields as `shipping_method.deliveryTime.translation.customFields`, `shipping_method.deliveryTime.translation`.created_at as `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation`.updated_at as `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation`.delivery_time_id as `shipping_method.deliveryTime.translation.deliveryTimeId`, `shipping_method.deliveryTime.translation`.language_id as `shipping_method.deliveryTime.translation.languageId`, `shipping_method.deliveryTime.translation.fallback_1`.name as `shipping_method.deliveryTime.translation.fallback_1.name`, `shipping_method.deliveryTime.translation.fallback_1`.custom_fields as `shipping_method.deliveryTime.translation.fallback_1.customFields`, `shipping_method.deliveryTime.translation.fallback_1`.created_at as `shipping_method.deliveryTime.translation.fallback_1.createdAt`, `shipping_method.deliveryTime.translation.fallback_1`.updated_at as `shipping_method.deliveryTime.translation.fallback_1.updatedAt`, `shipping_method.deliveryTime.translation.fallback_1`.delivery_time_id as `shipping_method.deliveryTime.translation.fallback_1.deliveryTimeId`, `shipping_method.deliveryTime.translation.fallback_1`.language_id as `shipping_method.deliveryTime.translation.fallback_1.languageId` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `shipping_method.deliveryTime.translation.fallback_1` ON `shipping_method.deliveryTime.translation`.`delivery_time_id` = `shipping_method.deliveryTime.translation.fallback_1`.`delivery_time_id` AND `shipping_method.deliveryTime.translation.fallback_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`.title as `shipping_method.media.translation.title`, `shipping_method.media.translation`.alt as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.custom_fields as `shipping_method.media.translation.customFields`, `shipping_method.media.translation`.created_at as `shipping_method.media.translation.createdAt`, `shipping_method.media.translation`.updated_at as `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation`.media_id as `shipping_method.media.translation.mediaId`, `shipping_method.media.translation`.language_id as `shipping_method.media.translation.languageId`, `shipping_method.media.translation.fallback_1`.title as `shipping_method.media.translation.fallback_1.title`, `shipping_method.media.translation.fallback_1`.alt as `shipping_method.media.translation.fallback_1.alt`, `shipping_method.media.translation.fallback_1`.custom_fields as `shipping_method.media.translation.fallback_1.customFields`, `shipping_method.media.translation.fallback_1`.created_at as `shipping_method.media.translation.fallback_1.createdAt`, `shipping_method.media.translation.fallback_1`.updated_at as `shipping_method.media.translation.fallback_1.updatedAt`, `shipping_method.media.translation.fallback_1`.media_id as `shipping_method.media.translation.fallback_1.mediaId`, `shipping_method.media.translation.fallback_1`.language_id as `shipping_method.media.translation.fallback_1.languageId` FROM `media_translation` `shipping_method.media.translation` LEFT JOIN `media_translation` `shipping_method.media.translation.fallback_1` ON `shipping_method.media.translation`.`media_id` = `shipping_method.media.translation.fallback_1`.`media_id` AND `shipping_method.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"h\x1C–\exOI÷‡&\x1C‘›Ìó™" ] |
||||||||||||||||||||
|
1.47 ms (0.76%) |
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.analytics`.`id` as `sales_channel.analytics.id`, `sales_channel.analytics`.`tracking_id` as `sales_channel.analytics.trackingId`, `sales_channel.analytics`.`active` as `sales_channel.analytics.active`, `sales_channel.analytics`.`track_orders` as `sales_channel.analytics.trackOrders`, `sales_channel.analytics`.`anonymize_ip` as `sales_channel.analytics.anonymizeIp`, `sales_channel.analytics`.`created_at` as `sales_channel.analytics.createdAt`, `sales_channel.analytics`.`updated_at` as `sales_channel.analytics.updatedAt`, `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.fallback_1.shortName`, `sales_channel.currency.translation.shortName`, COALESCE(`sales_channel.currency.translation.fallback_1.shortName`,`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) as `sales_channel.currency.shortName`, `sales_channel.currency.translation.fallback_1.name`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.fallback_1.name`,`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) as `sales_channel.currency.name`, `sales_channel.currency.translation.fallback_1.customFields`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.fallback_1.customFields`,`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) as `sales_channel.currency.customFields`, `sales_channel.currency.translation.fallback_1.createdAt`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.fallback_1.updatedAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.fallback_1.currencyId`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.fallback_1.languageId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.fallback_1.name`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.fallback_1.name`,`sales_channel.translation.name`,`sales_channel.translation.name`) as `sales_channel.name`, `sales_channel.translation.fallback_1.homeSlotConfig`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.fallback_1.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) as `sales_channel.homeSlotConfig`, `sales_channel.translation.fallback_1.homeEnabled`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.fallback_1.homeEnabled`,`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) as `sales_channel.homeEnabled`, `sales_channel.translation.fallback_1.homeName`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.fallback_1.homeName`,`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) as `sales_channel.homeName`, `sales_channel.translation.fallback_1.homeMetaTitle`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.fallback_1.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) as `sales_channel.homeMetaTitle`, `sales_channel.translation.fallback_1.homeMetaDescription`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.fallback_1.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) as `sales_channel.homeMetaDescription`, `sales_channel.translation.fallback_1.homeKeywords`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.fallback_1.homeKeywords`,`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) as `sales_channel.homeKeywords`, `sales_channel.translation.fallback_1.customFields`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.fallback_1.customFields`,`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) as `sales_channel.customFields`, `sales_channel.translation.fallback_1.createdAt`, `sales_channel.translation.createdAt`, `sales_channel.translation.fallback_1.updatedAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.fallback_1.salesChannelId`, `sales_channel.translation.salesChannelId`, `sales_channel.translation.fallback_1.languageId`, `sales_channel.translation.languageId` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.sales_channel_id, `sales_channel.translation`.name as `sales_channel.translation.name`, `sales_channel.translation`.home_slot_config as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.home_enabled as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.home_name as `sales_channel.translation.homeName`, `sales_channel.translation`.home_meta_title as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.home_meta_description as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.home_keywords as `sales_channel.translation.homeKeywords`, `sales_channel.translation`.custom_fields as `sales_channel.translation.customFields`, `sales_channel.translation`.created_at as `sales_channel.translation.createdAt`, `sales_channel.translation`.updated_at as `sales_channel.translation.updatedAt`, `sales_channel.translation`.sales_channel_id as `sales_channel.translation.salesChannelId`, `sales_channel.translation`.language_id as `sales_channel.translation.languageId`, `sales_channel.translation.fallback_1`.name as `sales_channel.translation.fallback_1.name`, `sales_channel.translation.fallback_1`.home_slot_config as `sales_channel.translation.fallback_1.homeSlotConfig`, `sales_channel.translation.fallback_1`.home_enabled as `sales_channel.translation.fallback_1.homeEnabled`, `sales_channel.translation.fallback_1`.home_name as `sales_channel.translation.fallback_1.homeName`, `sales_channel.translation.fallback_1`.home_meta_title as `sales_channel.translation.fallback_1.homeMetaTitle`, `sales_channel.translation.fallback_1`.home_meta_description as `sales_channel.translation.fallback_1.homeMetaDescription`, `sales_channel.translation.fallback_1`.home_keywords as `sales_channel.translation.fallback_1.homeKeywords`, `sales_channel.translation.fallback_1`.custom_fields as `sales_channel.translation.fallback_1.customFields`, `sales_channel.translation.fallback_1`.created_at as `sales_channel.translation.fallback_1.createdAt`, `sales_channel.translation.fallback_1`.updated_at as `sales_channel.translation.fallback_1.updatedAt`, `sales_channel.translation.fallback_1`.sales_channel_id as `sales_channel.translation.fallback_1.salesChannelId`, `sales_channel.translation.fallback_1`.language_id as `sales_channel.translation.fallback_1.languageId` FROM `sales_channel_translation` `sales_channel.translation` LEFT JOIN `sales_channel_translation` `sales_channel.translation.fallback_1` ON `sales_channel.translation`.`sales_channel_id` = `sales_channel.translation.fallback_1`.`sales_channel_id` AND `sales_channel.translation.fallback_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 `sales_channel_analytics` `sales_channel.analytics` ON `sales_channel`.`analytics_id` = `sales_channel.analytics`.`id` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`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`.name as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.custom_fields as `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation`.created_at as `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation`.updated_at as `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation`.currency_id as `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation`.language_id as `sales_channel.currency.translation.languageId`, `sales_channel.currency.translation.fallback_1`.short_name as `sales_channel.currency.translation.fallback_1.shortName`, `sales_channel.currency.translation.fallback_1`.name as `sales_channel.currency.translation.fallback_1.name`, `sales_channel.currency.translation.fallback_1`.custom_fields as `sales_channel.currency.translation.fallback_1.customFields`, `sales_channel.currency.translation.fallback_1`.created_at as `sales_channel.currency.translation.fallback_1.createdAt`, `sales_channel.currency.translation.fallback_1`.updated_at as `sales_channel.currency.translation.fallback_1.updatedAt`, `sales_channel.currency.translation.fallback_1`.currency_id as `sales_channel.currency.translation.fallback_1.currencyId`, `sales_channel.currency.translation.fallback_1`.language_id as `sales_channel.currency.translation.fallback_1.languageId` FROM `currency_translation` `sales_channel.currency.translation` LEFT JOIN `currency_translation` `sales_channel.currency.translation.fallback_1` ON `sales_channel.currency.translation`.`currency_id` = `sales_channel.currency.translation.fallback_1`.`currency_id` AND `sales_channel.currency.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"jŠQ\x14kßE®„¯ÅhpuÓ€" ] |
||||||||||||||||||||
|
1.42 ms (0.74%) |
1 |
# category::data::read SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId`, `category.translation.fallback_1`.name as `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb as `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config as `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type as `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link as `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link as `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab as `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description as `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title as `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description as `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords as `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields as `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at as `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at as `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id as `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id as `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id as `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId`, `category.media.translation.fallback_1`.title as `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt as `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields as `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at as `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at as `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id as `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id as `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"9cµÕ}ÃLµ†07=ˆ¢íœ" ] |
||||||||||||||||||||
|
1.37 ms (0.71%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
1.36 ms (0.71%) |
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.fallback_1.name`, `language.translationCode.translation.name`, COALESCE(`language.translationCode.translation.fallback_1.name`,`language.translationCode.translation.name`,`language.translationCode.translation.name`) as `language.translationCode.name`, `language.translationCode.translation.fallback_1.territory`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.fallback_1.territory`,`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) as `language.translationCode.territory`, `language.translationCode.translation.fallback_1.customFields`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.fallback_1.customFields`,`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) as `language.translationCode.customFields`, `language.translationCode.translation.fallback_1.createdAt`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.fallback_1.updatedAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.fallback_1.localeId`, `language.translationCode.translation.localeId`, `language.translationCode.translation.fallback_1.languageId`, `language.translationCode.translation.languageId` 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`.territory as `language.translationCode.translation.territory`, `language.translationCode.translation`.custom_fields as `language.translationCode.translation.customFields`, `language.translationCode.translation`.created_at as `language.translationCode.translation.createdAt`, `language.translationCode.translation`.updated_at as `language.translationCode.translation.updatedAt`, `language.translationCode.translation`.locale_id as `language.translationCode.translation.localeId`, `language.translationCode.translation`.language_id as `language.translationCode.translation.languageId`, `language.translationCode.translation.fallback_1`.name as `language.translationCode.translation.fallback_1.name`, `language.translationCode.translation.fallback_1`.territory as `language.translationCode.translation.fallback_1.territory`, `language.translationCode.translation.fallback_1`.custom_fields as `language.translationCode.translation.fallback_1.customFields`, `language.translationCode.translation.fallback_1`.created_at as `language.translationCode.translation.fallback_1.createdAt`, `language.translationCode.translation.fallback_1`.updated_at as `language.translationCode.translation.fallback_1.updatedAt`, `language.translationCode.translation.fallback_1`.locale_id as `language.translationCode.translation.fallback_1.localeId`, `language.translationCode.translation.fallback_1`.language_id as `language.translationCode.translation.fallback_1.languageId` FROM `locale_translation` `language.translationCode.translation` LEFT JOIN `locale_translation` `language.translationCode.translation.fallback_1` ON `language.translationCode.translation`.`locale_id` = `language.translationCode.translation.fallback_1`.`locale_id` AND `language.translationCode.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"/»_ââšMpªXTÎ|ãâ\v" b"Í€Ü(WòO\¢\x16þö\rrå\x14" b"#»Í\rZþC\x07++Ý—›gA" b"gmÒ±\x10\x14Fj'µL±" ] |
||||||||||||||||||||
|
1.31 ms (0.68%) |
1 |
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[] |
||||||||||||||||||||
|
1.19 ms (0.62%) |
1 |
# 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`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.fallback_1.title`, `category.media.translation.title`, COALESCE(`category.media.translation.fallback_1.title`,`category.media.translation.title`,`category.media.translation.title`) as `category.media.title`, `category.media.translation.fallback_1.alt`, `category.media.translation.alt`, COALESCE(`category.media.translation.fallback_1.alt`,`category.media.translation.alt`,`category.media.translation.alt`) as `category.media.alt`, `category.media.translation.fallback_1.customFields`, `category.media.translation.customFields`, COALESCE(`category.media.translation.fallback_1.customFields`,`category.media.translation.customFields`,`category.media.translation.customFields`) as `category.media.customFields`, `category.media.translation.fallback_1.createdAt`, `category.media.translation.createdAt`, `category.media.translation.fallback_1.updatedAt`, `category.media.translation.updatedAt`, `category.media.translation.fallback_1.mediaId`, `category.media.translation.mediaId`, `category.media.translation.fallback_1.languageId`, `category.media.translation.languageId`, `category.translation.fallback_1.name`, `category.translation.name`, COALESCE(`category.translation.fallback_1.name`,`category.translation.name`,`category.translation.name`) as `category.name`, `category.translation.fallback_1.breadcrumb`, `category.translation.breadcrumb`, COALESCE(`category.translation.fallback_1.breadcrumb`,`category.translation.breadcrumb`,`category.translation.breadcrumb`) as `category.breadcrumb`, `category.translation.fallback_1.slotConfig`, `category.translation.slotConfig`, COALESCE(`category.translation.fallback_1.slotConfig`,`category.translation.slotConfig`,`category.translation.slotConfig`) as `category.slotConfig`, `category.translation.fallback_1.linkType`, `category.translation.linkType`, COALESCE(`category.translation.fallback_1.linkType`,`category.translation.linkType`,`category.translation.linkType`) as `category.linkType`, `category.translation.fallback_1.internalLink`, `category.translation.internalLink`, COALESCE(`category.translation.fallback_1.internalLink`,`category.translation.internalLink`,`category.translation.internalLink`) as `category.internalLink`, `category.translation.fallback_1.externalLink`, `category.translation.externalLink`, COALESCE(`category.translation.fallback_1.externalLink`,`category.translation.externalLink`,`category.translation.externalLink`) as `category.externalLink`, `category.translation.fallback_1.linkNewTab`, `category.translation.linkNewTab`, COALESCE(`category.translation.fallback_1.linkNewTab`,`category.translation.linkNewTab`,`category.translation.linkNewTab`) as `category.linkNewTab`, `category.translation.fallback_1.description`, `category.translation.description`, COALESCE(`category.translation.fallback_1.description`,`category.translation.description`,`category.translation.description`) as `category.description`, `category.translation.fallback_1.metaTitle`, `category.translation.metaTitle`, COALESCE(`category.translation.fallback_1.metaTitle`,`category.translation.metaTitle`,`category.translation.metaTitle`) as `category.metaTitle`, `category.translation.fallback_1.metaDescription`, `category.translation.metaDescription`, COALESCE(`category.translation.fallback_1.metaDescription`,`category.translation.metaDescription`,`category.translation.metaDescription`) as `category.metaDescription`, `category.translation.fallback_1.keywords`, `category.translation.keywords`, COALESCE(`category.translation.fallback_1.keywords`,`category.translation.keywords`,`category.translation.keywords`) as `category.keywords`, `category.translation.fallback_1.customFields`, `category.translation.customFields`, COALESCE(`category.translation.fallback_1.customFields`,`category.translation.customFields`,`category.translation.customFields`) as `category.customFields`, `category.translation.fallback_1.createdAt`, `category.translation.createdAt`, `category.translation.fallback_1.updatedAt`, `category.translation.updatedAt`, `category.translation.fallback_1.categoryId`, `category.translation.categoryId`, `category.translation.fallback_1.languageId`, `category.translation.languageId`, `category.translation.fallback_1.categoryVersionId`, `category.translation.categoryVersionId` FROM `category` LEFT JOIN (SELECT `category.translation`.category_id, `category.translation`.category_version_id, `category.translation`.name as `category.translation.name`, `category.translation`.breadcrumb as `category.translation.breadcrumb`, `category.translation`.slot_config as `category.translation.slotConfig`, `category.translation`.link_type as `category.translation.linkType`, `category.translation`.internal_link as `category.translation.internalLink`, `category.translation`.external_link as `category.translation.externalLink`, `category.translation`.link_new_tab as `category.translation.linkNewTab`, `category.translation`.description as `category.translation.description`, `category.translation`.meta_title as `category.translation.metaTitle`, `category.translation`.meta_description as `category.translation.metaDescription`, `category.translation`.keywords as `category.translation.keywords`, `category.translation`.custom_fields as `category.translation.customFields`, `category.translation`.created_at as `category.translation.createdAt`, `category.translation`.updated_at as `category.translation.updatedAt`, `category.translation`.category_id as `category.translation.categoryId`, `category.translation`.language_id as `category.translation.languageId`, `category.translation`.category_version_id as `category.translation.categoryVersionId`, `category.translation.fallback_1`.name as `category.translation.fallback_1.name`, `category.translation.fallback_1`.breadcrumb as `category.translation.fallback_1.breadcrumb`, `category.translation.fallback_1`.slot_config as `category.translation.fallback_1.slotConfig`, `category.translation.fallback_1`.link_type as `category.translation.fallback_1.linkType`, `category.translation.fallback_1`.internal_link as `category.translation.fallback_1.internalLink`, `category.translation.fallback_1`.external_link as `category.translation.fallback_1.externalLink`, `category.translation.fallback_1`.link_new_tab as `category.translation.fallback_1.linkNewTab`, `category.translation.fallback_1`.description as `category.translation.fallback_1.description`, `category.translation.fallback_1`.meta_title as `category.translation.fallback_1.metaTitle`, `category.translation.fallback_1`.meta_description as `category.translation.fallback_1.metaDescription`, `category.translation.fallback_1`.keywords as `category.translation.fallback_1.keywords`, `category.translation.fallback_1`.custom_fields as `category.translation.fallback_1.customFields`, `category.translation.fallback_1`.created_at as `category.translation.fallback_1.createdAt`, `category.translation.fallback_1`.updated_at as `category.translation.fallback_1.updatedAt`, `category.translation.fallback_1`.category_id as `category.translation.fallback_1.categoryId`, `category.translation.fallback_1`.language_id as `category.translation.fallback_1.languageId`, `category.translation.fallback_1`.category_version_id as `category.translation.fallback_1.categoryVersionId` FROM `category_translation` `category.translation` LEFT JOIN `category_translation` `category.translation.fallback_1` ON `category.translation`.`category_id` = `category.translation.fallback_1`.`category_id` AND `category.translation.fallback_1`.language_id = ? AND `category.translation`.category_version_id = `category.translation.fallback_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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.media.translation`.media_id, `category.media.translation`.title as `category.media.translation.title`, `category.media.translation`.alt as `category.media.translation.alt`, `category.media.translation`.custom_fields as `category.media.translation.customFields`, `category.media.translation`.created_at as `category.media.translation.createdAt`, `category.media.translation`.updated_at as `category.media.translation.updatedAt`, `category.media.translation`.media_id as `category.media.translation.mediaId`, `category.media.translation`.language_id as `category.media.translation.languageId`, `category.media.translation.fallback_1`.title as `category.media.translation.fallback_1.title`, `category.media.translation.fallback_1`.alt as `category.media.translation.fallback_1.alt`, `category.media.translation.fallback_1`.custom_fields as `category.media.translation.fallback_1.customFields`, `category.media.translation.fallback_1`.created_at as `category.media.translation.fallback_1.createdAt`, `category.media.translation.fallback_1`.updated_at as `category.media.translation.fallback_1.updatedAt`, `category.media.translation.fallback_1`.media_id as `category.media.translation.fallback_1.mediaId`, `category.media.translation.fallback_1`.language_id as `category.media.translation.fallback_1.languageId` FROM `media_translation` `category.media.translation` LEFT JOIN `media_translation` `category.media.translation.fallback_1` ON `category.media.translation`.`media_id` = `category.media.translation.fallback_1`.`media_id` AND `category.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"9cµÕ}ÃLµ†07=ˆ¢íœ" b"Y/°!шI–¨‘Rô“\x15jT" ] |
||||||||||||||||||||
|
1.19 ms (0.62%) |
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`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.fallback_1.title`, `media.translation.title`, COALESCE(`media.translation.fallback_1.title`,`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.fallback_1.alt`, `media.translation.alt`, COALESCE(`media.translation.fallback_1.alt`,`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.fallback_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.fallback_1.customFields`,`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.fallback_1.createdAt`, `media.translation.createdAt`, `media.translation.fallback_1.updatedAt`, `media.translation.updatedAt`, `media.translation.fallback_1.mediaId`, `media.translation.mediaId`, `media.translation.fallback_1.languageId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId`, `media.translation.fallback_1`.title as `media.translation.fallback_1.title`, `media.translation.fallback_1`.alt as `media.translation.fallback_1.alt`, `media.translation.fallback_1`.custom_fields as `media.translation.fallback_1.customFields`, `media.translation.fallback_1`.created_at as `media.translation.fallback_1.createdAt`, `media.translation.fallback_1`.updated_at as `media.translation.fallback_1.updatedAt`, `media.translation.fallback_1`.media_id as `media.translation.fallback_1.mediaId`, `media.translation.fallback_1`.language_id as `media.translation.fallback_1.languageId` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.fallback_1` ON `media.translation`.`media_id` = `media.translation.fallback_1`.`media_id` AND `media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"¥¼\x03ìÇ4E\x14ªßžTtëc" b"gw\x1FH¬¾¢\x16åQÙf" ] |
||||||||||||||||||||
|
1.14 ms (0.59%) |
1 |
# generic-page::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`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.fallback_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.fallback_1.title`,`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.fallback_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.fallback_1.alt`,`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.fallback_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.fallback_1.customFields`,`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.fallback_1.createdAt`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.fallback_1.updatedAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.fallback_1.mediaId`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.fallback_1.languageId`, `payment_method.media.translation.languageId`, `payment_method.translation.fallback_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.fallback_1.name`,`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.fallback_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.fallback_1.distinguishableName`,`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.fallback_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.fallback_1.description`,`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.fallback_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.fallback_1.customFields`,`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.fallback_1.createdAt`, `payment_method.translation.createdAt`, `payment_method.translation.fallback_1.updatedAt`, `payment_method.translation.updatedAt`, `payment_method.translation.fallback_1.paymentMethodId`, `payment_method.translation.paymentMethodId`, `payment_method.translation.fallback_1.languageId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId`, `payment_method.translation.fallback_1`.name as `payment_method.translation.fallback_1.name`, `payment_method.translation.fallback_1`.distinguishable_name as `payment_method.translation.fallback_1.distinguishableName`, `payment_method.translation.fallback_1`.description as `payment_method.translation.fallback_1.description`, `payment_method.translation.fallback_1`.custom_fields as `payment_method.translation.fallback_1.customFields`, `payment_method.translation.fallback_1`.created_at as `payment_method.translation.fallback_1.createdAt`, `payment_method.translation.fallback_1`.updated_at as `payment_method.translation.fallback_1.updatedAt`, `payment_method.translation.fallback_1`.payment_method_id as `payment_method.translation.fallback_1.paymentMethodId`, `payment_method.translation.fallback_1`.language_id as `payment_method.translation.fallback_1.languageId` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.fallback_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.fallback_1`.`payment_method_id` AND `payment_method.translation.fallback_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 `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.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId`, `payment_method.media.translation.fallback_1`.title as `payment_method.media.translation.fallback_1.title`, `payment_method.media.translation.fallback_1`.alt as `payment_method.media.translation.fallback_1.alt`, `payment_method.media.translation.fallback_1`.custom_fields as `payment_method.media.translation.fallback_1.customFields`, `payment_method.media.translation.fallback_1`.created_at as `payment_method.media.translation.fallback_1.createdAt`, `payment_method.media.translation.fallback_1`.updated_at as `payment_method.media.translation.fallback_1.updatedAt`, `payment_method.media.translation.fallback_1`.media_id as `payment_method.media.translation.fallback_1.mediaId`, `payment_method.media.translation.fallback_1`.language_id as `payment_method.media.translation.fallback_1.languageId` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.fallback_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.fallback_1`.`media_id` AND `payment_method.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"ËŒ¬†ÝíKí¥ú÷“ÛsTd" ] |
||||||||||||||||||||
|
1.07 ms (0.55%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"fr-FR"
]
|
||||||||||||||||||||
|
1.07 ms (0.55%) |
2 |
# navigation-route::meta-information SELECT LOWER(HEX(`id`)), `path`, `level` FROM `category` WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[ b"9cµÕ}ÃLµ†07=ˆ¢íœ" b"9cµÕ}ÃLµ†07=ˆ¢íœ" b"9cµÕ}ÃLµ†07=ˆ¢íœ" ] |
||||||||||||||||||||
|
0.99 ms (0.51%) |
1 |
# category::cms-page::association::sections::read SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.fallback_1.title`, `cms_section.backgroundMedia.translation.title`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.title`,`cms_section.backgroundMedia.translation.title`,`cms_section.backgroundMedia.translation.title`) as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.fallback_1.alt`, `cms_section.backgroundMedia.translation.alt`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.alt`,`cms_section.backgroundMedia.translation.alt`,`cms_section.backgroundMedia.translation.alt`) as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.fallback_1.customFields`, `cms_section.backgroundMedia.translation.customFields`, COALESCE(`cms_section.backgroundMedia.translation.fallback_1.customFields`,`cms_section.backgroundMedia.translation.customFields`,`cms_section.backgroundMedia.translation.customFields`) as `cms_section.backgroundMedia.customFields`, `cms_section.backgroundMedia.translation.fallback_1.createdAt`, `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation.fallback_1.updatedAt`, `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation.fallback_1.mediaId`, `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation.fallback_1.languageId`, `cms_section.backgroundMedia.translation.languageId` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.media_id, `cms_section.backgroundMedia.translation`.title as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.alt as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.custom_fields as `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation`.created_at as `cms_section.backgroundMedia.translation.createdAt`, `cms_section.backgroundMedia.translation`.updated_at as `cms_section.backgroundMedia.translation.updatedAt`, `cms_section.backgroundMedia.translation`.media_id as `cms_section.backgroundMedia.translation.mediaId`, `cms_section.backgroundMedia.translation`.language_id as `cms_section.backgroundMedia.translation.languageId`, `cms_section.backgroundMedia.translation.fallback_1`.title as `cms_section.backgroundMedia.translation.fallback_1.title`, `cms_section.backgroundMedia.translation.fallback_1`.alt as `cms_section.backgroundMedia.translation.fallback_1.alt`, `cms_section.backgroundMedia.translation.fallback_1`.custom_fields as `cms_section.backgroundMedia.translation.fallback_1.customFields`, `cms_section.backgroundMedia.translation.fallback_1`.created_at as `cms_section.backgroundMedia.translation.fallback_1.createdAt`, `cms_section.backgroundMedia.translation.fallback_1`.updated_at as `cms_section.backgroundMedia.translation.fallback_1.updatedAt`, `cms_section.backgroundMedia.translation.fallback_1`.media_id as `cms_section.backgroundMedia.translation.fallback_1.mediaId`, `cms_section.backgroundMedia.translation.fallback_1`.language_id as `cms_section.backgroundMedia.translation.fallback_1.languageId` FROM `media_translation` `cms_section.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_section.backgroundMedia.translation.fallback_1` ON `cms_section.backgroundMedia.translation`.`media_id` = `cms_section.backgroundMedia.translation.fallback_1`.`media_id` AND `cms_section.backgroundMedia.translation.fallback_1`.language_id = ? WHERE `cms_section.backgroundMedia.translation`.language_id = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND ((`cms_section`.`cms_page_id` IN (?)))
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"iTwà.öCå \x16¸>ÔÍö:" ] |
||||||||||||||||||||
|
0.99 ms (0.51%) |
1 |
# 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.fallback_1.description`, `theme.translation.description`, COALESCE(`theme.translation.fallback_1.description`,`theme.translation.description`,`theme.translation.description`) as `theme.description`, `theme.translation.fallback_1.labels`, `theme.translation.labels`, COALESCE(`theme.translation.fallback_1.labels`,`theme.translation.labels`,`theme.translation.labels`) as `theme.labels`, `theme.translation.fallback_1.helpTexts`, `theme.translation.helpTexts`, COALESCE(`theme.translation.fallback_1.helpTexts`,`theme.translation.helpTexts`,`theme.translation.helpTexts`) as `theme.helpTexts`, `theme.translation.fallback_1.customFields`, `theme.translation.customFields`, COALESCE(`theme.translation.fallback_1.customFields`,`theme.translation.customFields`,`theme.translation.customFields`) as `theme.customFields`, `theme.translation.fallback_1.createdAt`, `theme.translation.createdAt`, `theme.translation.fallback_1.updatedAt`, `theme.translation.updatedAt`, `theme.translation.fallback_1.themeId`, `theme.translation.themeId`, `theme.translation.fallback_1.languageId`, `theme.translation.languageId` FROM `theme` LEFT JOIN (SELECT `theme.translation`.theme_id, `theme.translation`.description as `theme.translation.description`, `theme.translation`.labels as `theme.translation.labels`, `theme.translation`.help_texts as `theme.translation.helpTexts`, `theme.translation`.custom_fields as `theme.translation.customFields`, `theme.translation`.created_at as `theme.translation.createdAt`, `theme.translation`.updated_at as `theme.translation.updatedAt`, `theme.translation`.theme_id as `theme.translation.themeId`, `theme.translation`.language_id as `theme.translation.languageId`, `theme.translation.fallback_1`.description as `theme.translation.fallback_1.description`, `theme.translation.fallback_1`.labels as `theme.translation.fallback_1.labels`, `theme.translation.fallback_1`.help_texts as `theme.translation.fallback_1.helpTexts`, `theme.translation.fallback_1`.custom_fields as `theme.translation.fallback_1.customFields`, `theme.translation.fallback_1`.created_at as `theme.translation.fallback_1.createdAt`, `theme.translation.fallback_1`.updated_at as `theme.translation.fallback_1.updatedAt`, `theme.translation.fallback_1`.theme_id as `theme.translation.fallback_1.themeId`, `theme.translation.fallback_1`.language_id as `theme.translation.fallback_1.languageId` FROM `theme_translation` `theme.translation` LEFT JOIN `theme_translation` `theme.translation.fallback_1` ON `theme.translation`.`theme_id` = `theme.translation.fallback_1`.`theme_id` AND `theme.translation.fallback_1`.language_id = ? WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" ] |
||||||||||||||||||||
|
0.98 ms (0.51%) |
1 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||||
|
0.94 ms (0.48%) |
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.91 ms (0.47%) |
1 |
# category::cms-page::read SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.fallback_1.name`, `cms_page.translation.name`, COALESCE(`cms_page.translation.fallback_1.name`,`cms_page.translation.name`,`cms_page.translation.name`) as `cms_page.name`, `cms_page.translation.fallback_1.customFields`, `cms_page.translation.customFields`, COALESCE(`cms_page.translation.fallback_1.customFields`,`cms_page.translation.customFields`,`cms_page.translation.customFields`) as `cms_page.customFields`, `cms_page.translation.fallback_1.createdAt`, `cms_page.translation.createdAt`, `cms_page.translation.fallback_1.updatedAt`, `cms_page.translation.updatedAt`, `cms_page.translation.fallback_1.cmsPageId`, `cms_page.translation.cmsPageId`, `cms_page.translation.fallback_1.languageId`, `cms_page.translation.languageId`, `cms_page.translation.fallback_1.cmsPageVersionId`, `cms_page.translation.cmsPageVersionId` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.cms_page_id, `cms_page.translation`.cms_page_version_id, `cms_page.translation`.name as `cms_page.translation.name`, `cms_page.translation`.custom_fields as `cms_page.translation.customFields`, `cms_page.translation`.created_at as `cms_page.translation.createdAt`, `cms_page.translation`.updated_at as `cms_page.translation.updatedAt`, `cms_page.translation`.cms_page_id as `cms_page.translation.cmsPageId`, `cms_page.translation`.language_id as `cms_page.translation.languageId`, `cms_page.translation`.cms_page_version_id as `cms_page.translation.cmsPageVersionId`, `cms_page.translation.fallback_1`.name as `cms_page.translation.fallback_1.name`, `cms_page.translation.fallback_1`.custom_fields as `cms_page.translation.fallback_1.customFields`, `cms_page.translation.fallback_1`.created_at as `cms_page.translation.fallback_1.createdAt`, `cms_page.translation.fallback_1`.updated_at as `cms_page.translation.fallback_1.updatedAt`, `cms_page.translation.fallback_1`.cms_page_id as `cms_page.translation.fallback_1.cmsPageId`, `cms_page.translation.fallback_1`.language_id as `cms_page.translation.fallback_1.languageId`, `cms_page.translation.fallback_1`.cms_page_version_id as `cms_page.translation.fallback_1.cmsPageVersionId` FROM `cms_page_translation` `cms_page.translation` LEFT JOIN `cms_page_translation` `cms_page.translation.fallback_1` ON `cms_page.translation`.`cms_page_id` = `cms_page.translation.fallback_1`.`cms_page_id` AND `cms_page.translation.fallback_1`.language_id = ? AND `cms_page.translation`.cms_page_version_id = `cms_page.translation.fallback_1`.cms_page_version_id WHERE `cms_page.translation`.language_id = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.cms_page_version_id = `cms_page`.version_id WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"iTwà.öCå \x16¸>ÔÍö:" ] |
||||||||||||||||||||
|
0.90 ms (0.47%) |
1 |
# category::cms-page::association::sections::association::blocks::read SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.fallback_1.title`, `cms_block.backgroundMedia.translation.title`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.title`,`cms_block.backgroundMedia.translation.title`,`cms_block.backgroundMedia.translation.title`) as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.fallback_1.alt`, `cms_block.backgroundMedia.translation.alt`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.alt`,`cms_block.backgroundMedia.translation.alt`,`cms_block.backgroundMedia.translation.alt`) as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.fallback_1.customFields`, `cms_block.backgroundMedia.translation.customFields`, COALESCE(`cms_block.backgroundMedia.translation.fallback_1.customFields`,`cms_block.backgroundMedia.translation.customFields`,`cms_block.backgroundMedia.translation.customFields`) as `cms_block.backgroundMedia.customFields`, `cms_block.backgroundMedia.translation.fallback_1.createdAt`, `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation.fallback_1.updatedAt`, `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation.fallback_1.mediaId`, `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation.fallback_1.languageId`, `cms_block.backgroundMedia.translation.languageId` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.media_id, `cms_block.backgroundMedia.translation`.title as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.alt as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.custom_fields as `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation`.created_at as `cms_block.backgroundMedia.translation.createdAt`, `cms_block.backgroundMedia.translation`.updated_at as `cms_block.backgroundMedia.translation.updatedAt`, `cms_block.backgroundMedia.translation`.media_id as `cms_block.backgroundMedia.translation.mediaId`, `cms_block.backgroundMedia.translation`.language_id as `cms_block.backgroundMedia.translation.languageId`, `cms_block.backgroundMedia.translation.fallback_1`.title as `cms_block.backgroundMedia.translation.fallback_1.title`, `cms_block.backgroundMedia.translation.fallback_1`.alt as `cms_block.backgroundMedia.translation.fallback_1.alt`, `cms_block.backgroundMedia.translation.fallback_1`.custom_fields as `cms_block.backgroundMedia.translation.fallback_1.customFields`, `cms_block.backgroundMedia.translation.fallback_1`.created_at as `cms_block.backgroundMedia.translation.fallback_1.createdAt`, `cms_block.backgroundMedia.translation.fallback_1`.updated_at as `cms_block.backgroundMedia.translation.fallback_1.updatedAt`, `cms_block.backgroundMedia.translation.fallback_1`.media_id as `cms_block.backgroundMedia.translation.fallback_1.mediaId`, `cms_block.backgroundMedia.translation.fallback_1`.language_id as `cms_block.backgroundMedia.translation.fallback_1.languageId` FROM `media_translation` `cms_block.backgroundMedia.translation` LEFT JOIN `media_translation` `cms_block.backgroundMedia.translation.fallback_1` ON `cms_block.backgroundMedia.translation`.`media_id` = `cms_block.backgroundMedia.translation.fallback_1`.`media_id` AND `cms_block.backgroundMedia.translation.fallback_1`.language_id = ? WHERE `cms_block.backgroundMedia.translation`.language_id = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND ((`cms_block`.`cms_section_id` IN (?, ?, ?)))
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\x0F©\x1CãéjK¾KÙÎu,4%" b"\tœ‹\x15S÷Lۙ׬xG.\e" b"c%;´‰¯E*›Ê\x02°õM\tV" b"“Twà.öCå \x16¸>ÔÍö:" ] |
||||||||||||||||||||
|
0.88 ms (0.46%) |
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`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.fallback_1.title`, `payment_method.media.translation.title`, COALESCE(`payment_method.media.translation.fallback_1.title`,`payment_method.media.translation.title`,`payment_method.media.translation.title`) as `payment_method.media.title`, `payment_method.media.translation.fallback_1.alt`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.fallback_1.alt`,`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) as `payment_method.media.alt`, `payment_method.media.translation.fallback_1.customFields`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.fallback_1.customFields`,`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) as `payment_method.media.customFields`, `payment_method.media.translation.fallback_1.createdAt`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.fallback_1.updatedAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.fallback_1.mediaId`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.fallback_1.languageId`, `payment_method.media.translation.languageId`, `payment_method.translation.fallback_1.name`, `payment_method.translation.name`, COALESCE(`payment_method.translation.fallback_1.name`,`payment_method.translation.name`,`payment_method.translation.name`) as `payment_method.name`, `payment_method.translation.fallback_1.distinguishableName`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.fallback_1.distinguishableName`,`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) as `payment_method.distinguishableName`, `payment_method.translation.fallback_1.description`, `payment_method.translation.description`, COALESCE(`payment_method.translation.fallback_1.description`,`payment_method.translation.description`,`payment_method.translation.description`) as `payment_method.description`, `payment_method.translation.fallback_1.customFields`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.fallback_1.customFields`,`payment_method.translation.customFields`,`payment_method.translation.customFields`) as `payment_method.customFields`, `payment_method.translation.fallback_1.createdAt`, `payment_method.translation.createdAt`, `payment_method.translation.fallback_1.updatedAt`, `payment_method.translation.updatedAt`, `payment_method.translation.fallback_1.paymentMethodId`, `payment_method.translation.paymentMethodId`, `payment_method.translation.fallback_1.languageId`, `payment_method.translation.languageId` FROM `payment_method` LEFT JOIN (SELECT `payment_method.translation`.payment_method_id, `payment_method.translation`.name as `payment_method.translation.name`, `payment_method.translation`.distinguishable_name as `payment_method.translation.distinguishableName`, `payment_method.translation`.description as `payment_method.translation.description`, `payment_method.translation`.custom_fields as `payment_method.translation.customFields`, `payment_method.translation`.created_at as `payment_method.translation.createdAt`, `payment_method.translation`.updated_at as `payment_method.translation.updatedAt`, `payment_method.translation`.payment_method_id as `payment_method.translation.paymentMethodId`, `payment_method.translation`.language_id as `payment_method.translation.languageId`, `payment_method.translation.fallback_1`.name as `payment_method.translation.fallback_1.name`, `payment_method.translation.fallback_1`.distinguishable_name as `payment_method.translation.fallback_1.distinguishableName`, `payment_method.translation.fallback_1`.description as `payment_method.translation.fallback_1.description`, `payment_method.translation.fallback_1`.custom_fields as `payment_method.translation.fallback_1.customFields`, `payment_method.translation.fallback_1`.created_at as `payment_method.translation.fallback_1.createdAt`, `payment_method.translation.fallback_1`.updated_at as `payment_method.translation.fallback_1.updatedAt`, `payment_method.translation.fallback_1`.payment_method_id as `payment_method.translation.fallback_1.paymentMethodId`, `payment_method.translation.fallback_1`.language_id as `payment_method.translation.fallback_1.languageId` FROM `payment_method_translation` `payment_method.translation` LEFT JOIN `payment_method_translation` `payment_method.translation.fallback_1` ON `payment_method.translation`.`payment_method_id` = `payment_method.translation.fallback_1`.`payment_method_id` AND `payment_method.translation.fallback_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 `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.media.translation`.media_id, `payment_method.media.translation`.title as `payment_method.media.translation.title`, `payment_method.media.translation`.alt as `payment_method.media.translation.alt`, `payment_method.media.translation`.custom_fields as `payment_method.media.translation.customFields`, `payment_method.media.translation`.created_at as `payment_method.media.translation.createdAt`, `payment_method.media.translation`.updated_at as `payment_method.media.translation.updatedAt`, `payment_method.media.translation`.media_id as `payment_method.media.translation.mediaId`, `payment_method.media.translation`.language_id as `payment_method.media.translation.languageId`, `payment_method.media.translation.fallback_1`.title as `payment_method.media.translation.fallback_1.title`, `payment_method.media.translation.fallback_1`.alt as `payment_method.media.translation.fallback_1.alt`, `payment_method.media.translation.fallback_1`.custom_fields as `payment_method.media.translation.fallback_1.customFields`, `payment_method.media.translation.fallback_1`.created_at as `payment_method.media.translation.fallback_1.createdAt`, `payment_method.media.translation.fallback_1`.updated_at as `payment_method.media.translation.fallback_1.updatedAt`, `payment_method.media.translation.fallback_1`.media_id as `payment_method.media.translation.fallback_1.mediaId`, `payment_method.media.translation.fallback_1`.language_id as `payment_method.media.translation.fallback_1.languageId` FROM `media_translation` `payment_method.media.translation` LEFT JOIN `media_translation` `payment_method.media.translation.fallback_1` ON `payment_method.media.translation`.`media_id` = `payment_method.media.translation.fallback_1`.`media_id` AND `payment_method.media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"ËŒ¬†ÝíKí¥ú÷“ÛsTd" ] |
||||||||||||||||||||
|
0.83 ms (0.43%) |
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`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.fallback_1.title`, `media.translation.title`, COALESCE(`media.translation.fallback_1.title`,`media.translation.title`,`media.translation.title`) as `media.title`, `media.translation.fallback_1.alt`, `media.translation.alt`, COALESCE(`media.translation.fallback_1.alt`,`media.translation.alt`,`media.translation.alt`) as `media.alt`, `media.translation.fallback_1.customFields`, `media.translation.customFields`, COALESCE(`media.translation.fallback_1.customFields`,`media.translation.customFields`,`media.translation.customFields`) as `media.customFields`, `media.translation.fallback_1.createdAt`, `media.translation.createdAt`, `media.translation.fallback_1.updatedAt`, `media.translation.updatedAt`, `media.translation.fallback_1.mediaId`, `media.translation.mediaId`, `media.translation.fallback_1.languageId`, `media.translation.languageId` 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`.title as `media.translation.title`, `media.translation`.alt as `media.translation.alt`, `media.translation`.custom_fields as `media.translation.customFields`, `media.translation`.created_at as `media.translation.createdAt`, `media.translation`.updated_at as `media.translation.updatedAt`, `media.translation`.media_id as `media.translation.mediaId`, `media.translation`.language_id as `media.translation.languageId`, `media.translation.fallback_1`.title as `media.translation.fallback_1.title`, `media.translation.fallback_1`.alt as `media.translation.fallback_1.alt`, `media.translation.fallback_1`.custom_fields as `media.translation.fallback_1.customFields`, `media.translation.fallback_1`.created_at as `media.translation.fallback_1.createdAt`, `media.translation.fallback_1`.updated_at as `media.translation.fallback_1.updatedAt`, `media.translation.fallback_1`.media_id as `media.translation.fallback_1.mediaId`, `media.translation.fallback_1`.language_id as `media.translation.fallback_1.languageId` FROM `media_translation` `media.translation` LEFT JOIN `media_translation` `media.translation.fallback_1` ON `media.translation`.`media_id` = `media.translation.fallback_1`.`media_id` AND `media.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" false true "product_download" b"€@Ç{pmL\x14³`*&˜à~î" b"Ÿº÷›ìŸE²´¼ª\x1Erí$Î" b"\x16\x1E‘ÇUÝCxŒÃŠHÇÿ"&" ] |
||||||||||||||||||||
|
0.83 ms (0.43%) |
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.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.fallback_1.typeName`, `tax_rule.type.translation.typeName`, COALESCE(`tax_rule.type.translation.fallback_1.typeName`,`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) as `tax_rule.type.typeName`, `tax_rule.type.translation.fallback_1.createdAt`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.fallback_1.updatedAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.fallback_1.taxRuleTypeId`, `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation.fallback_1.languageId`, `tax_rule.type.translation.languageId`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt` 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`.created_at as `tax_rule.type.translation.createdAt`, `tax_rule.type.translation`.updated_at as `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation`.tax_rule_type_id as `tax_rule.type.translation.taxRuleTypeId`, `tax_rule.type.translation`.language_id as `tax_rule.type.translation.languageId`, `tax_rule.type.translation.fallback_1`.type_name as `tax_rule.type.translation.fallback_1.typeName`, `tax_rule.type.translation.fallback_1`.created_at as `tax_rule.type.translation.fallback_1.createdAt`, `tax_rule.type.translation.fallback_1`.updated_at as `tax_rule.type.translation.fallback_1.updatedAt`, `tax_rule.type.translation.fallback_1`.tax_rule_type_id as `tax_rule.type.translation.fallback_1.taxRuleTypeId`, `tax_rule.type.translation.fallback_1`.language_id as `tax_rule.type.translation.fallback_1.languageId` FROM `tax_rule_type_translation` `tax_rule.type.translation` LEFT JOIN `tax_rule_type_translation` `tax_rule.type.translation.fallback_1` ON `tax_rule.type.translation`.`tax_rule_type_id` = `tax_rule.type.translation.fallback_1`.`tax_rule_type_id` AND `tax_rule.type.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"\f\x177/æªF\x05š—ü(´\x0FFÄ" b"\rÑM‚/Bê„r*D\x02Uõ\x03" b"ZÐ{\x7F±\x17Bô†„9U\x13ß(\x7F" b"ÞçØ2£\Fî¾_A:Ãæ²\x1C" ] |
||||||||||||||||||||
|
0.79 ms (0.41%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
0.77 ms (0.40%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
|
0.77 ms (0.40%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.75 ms (0.39%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€" b"jŠQ\x14kßE®„¯ÅhpuÓ€" ] |
||||||||||||||||||||
|
0.63 ms (0.33%) |
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.63 ms (0.33%) |
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.62 ms (0.32%) |
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`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.fallback_1.name`, `country.translation.name`, COALESCE(`country.translation.fallback_1.name`,`country.translation.name`,`country.translation.name`) as `country.name`, `country.translation.fallback_1.addressFormat`, `country.translation.addressFormat`, COALESCE(`country.translation.fallback_1.addressFormat`,`country.translation.addressFormat`,`country.translation.addressFormat`) as `country.addressFormat`, `country.translation.fallback_1.customFields`, `country.translation.customFields`, COALESCE(`country.translation.fallback_1.customFields`,`country.translation.customFields`,`country.translation.customFields`) as `country.customFields`, `country.translation.fallback_1.createdAt`, `country.translation.createdAt`, `country.translation.fallback_1.updatedAt`, `country.translation.updatedAt`, `country.translation.fallback_1.countryId`, `country.translation.countryId`, `country.translation.fallback_1.languageId`, `country.translation.languageId` FROM `country` LEFT JOIN (SELECT `country.translation`.country_id, `country.translation`.name as `country.translation.name`, `country.translation`.address_format as `country.translation.addressFormat`, `country.translation`.custom_fields as `country.translation.customFields`, `country.translation`.created_at as `country.translation.createdAt`, `country.translation`.updated_at as `country.translation.updatedAt`, `country.translation`.country_id as `country.translation.countryId`, `country.translation`.language_id as `country.translation.languageId`, `country.translation.fallback_1`.name as `country.translation.fallback_1.name`, `country.translation.fallback_1`.address_format as `country.translation.fallback_1.addressFormat`, `country.translation.fallback_1`.custom_fields as `country.translation.fallback_1.customFields`, `country.translation.fallback_1`.created_at as `country.translation.fallback_1.createdAt`, `country.translation.fallback_1`.updated_at as `country.translation.fallback_1.updatedAt`, `country.translation.fallback_1`.country_id as `country.translation.fallback_1.countryId`, `country.translation.fallback_1`.language_id as `country.translation.fallback_1.languageId` FROM `country_translation` `country.translation` LEFT JOIN `country_translation` `country.translation.fallback_1` ON `country.translation`.`country_id` = `country.translation.fallback_1`.`country_id` AND `country.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"æ\x1Ci›\f‰I#{^ùÆ%Ø" ] |
||||||||||||||||||||
|
0.62 ms (0.32%) |
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"Ó\rn1øìD\x0F“êRDñCŠÒ" b""" \x04jì\x19~6I‘Ž´Ìºý\n ¿h """ b"5AìŠ4N¯°š˜'3Bþo" b"8X•p\x16dMä®HÀP\vóÌÈ" b"9÷ûA9%L\x08‰æò«Ó@ç\x0F" b"G!]¹æ[G?•s†ü<\x11ÊQ" b"Lç™æ©oAU \x12‘g®RÁ" b"g&nñ£\tOÖ¢Îf¡øš`" b"kŠ,¥-ªJI¢x\x1Aš\x02BH•" b""" ‚¿= ÉE\n ¨S\x01ì*;• """ b"…ÙSk:bKÆ’t‡j%¸&" b"ã~Û·ƒL"œ{\x05UZ³/" b"’ݪ\x01¯òGOŠ.ªƒ3˜Â" b"¦.\x1Fj\x1A\vE\x19¯@\ebp£qI" b"½{¨§»TEbŠH\e\x1EÝ©ðö" b"ÊÆ\x03°÷FÒ¦ä¿bfýÚ|" b"ÓMB1vLH3’p®¡\x14à)" b"ÔZöùmoMö•Œ•Ž Á7#" b"ÖÈÑ‚“þMT¤5© rUª¨" b"×\tÈû)jB»™`\x19É\x06¼\x05." b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"è\x0E\x14À)=K‰‡}¦\v=Ë&" b"ñúU¿u[Mÿƒ¢\x08LL‡ïË" b"\x139„àªÿO+½højÝqD\x13" b""" <õA6žmJ/§\n ¨hzeü- """ b"ˆ‡[P½î@\x00¸8rlªÊ’±" b"\tžV\x05OhM_åÀõy}v|" b"(Ê®u¥bO\r˜Z½\x0E³*¡`" b"+lg[8\x0F@œ®"À\x10>…¹" b"4TýÍp’I܈,\x15rµã_E" b"5QæÃ^I\x15™ü>J\x07úý+" b"X\x165\x1EŠÁFÕµTcj¸ ÿ" b"^«ÔO5çH'¤\x1A×)ê5ù\v" b"m1´®ÎA<³ýTŠ»·õ" b"ÔÈJ\x03ú¡K\x12¾>'ˆ…„R" b"Þ&\x1Fˆ\x12(E”³þ(£n\x11Öü" b"ä8X•w0K‡¬:\x13·½Y‡M" b"ð\x17¹ÕgE|“ÒÚfI@‡@" b"ùô\x1C\x1A6ÆGt¥²E\vOxýÝ" b"ûuÏ\x0FE\x10B\x06³ô\x0F6\x1E‹ß\x15" ] |
||||||||||||||||||||
|
0.60 ms (0.31%) |
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.60 ms (0.31%) |
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"8X•p\x16dMä®HÀP\vóÌÈ" b"g&nñ£\tOÖ¢Îf¡øš`" b"kŠ,¥-ªJI¢x\x1Aš\x02BH•" b"ÊÆ\x03°÷FÒ¦ä¿bfýÚ|" b"ÓMB1vLH3’p®¡\x14à)" b"×\tÈû)jB»™`\x19É\x06¼\x05." b"á7Ž·€ŠG‘ž\rt\r]l\x1A" b"è\x0E\x14À)=K‰‡}¦\v=Ë&" b"ñúU¿u[Mÿƒ¢\x08LL‡ïË" b"ð\x17¹ÕgE|“ÒÚfI@‡@" ] |
||||||||||||||||||||
|
0.59 ms (0.31%) |
1 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"jŠQ\x14kßE®„¯ÅhpuÓ€" "7SykxRVtdNu2eS4nt6O7CegL6AGyPthO" ] |
||||||||||||||||||||
|
0.58 ms (0.30%) |
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.fallback_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.fallback_1.shortName`,`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.fallback_1.name`, `currency.translation.name`, COALESCE(`currency.translation.fallback_1.name`,`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.fallback_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.fallback_1.customFields`,`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.fallback_1.createdAt`, `currency.translation.createdAt`, `currency.translation.fallback_1.updatedAt`, `currency.translation.updatedAt`, `currency.translation.fallback_1.currencyId`, `currency.translation.currencyId`, `currency.translation.fallback_1.languageId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId`, `currency.translation.fallback_1`.short_name as `currency.translation.fallback_1.shortName`, `currency.translation.fallback_1`.name as `currency.translation.fallback_1.name`, `currency.translation.fallback_1`.custom_fields as `currency.translation.fallback_1.customFields`, `currency.translation.fallback_1`.created_at as `currency.translation.fallback_1.createdAt`, `currency.translation.fallback_1`.updated_at as `currency.translation.fallback_1.updatedAt`, `currency.translation.fallback_1`.currency_id as `currency.translation.fallback_1.currencyId`, `currency.translation.fallback_1`.language_id as `currency.translation.fallback_1.languageId` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.fallback_1` ON `currency.translation`.`currency_id` = `currency.translation.fallback_1`.`currency_id` AND `currency.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.56 ms (0.29%) |
1 |
# generic-page::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`.description as `shipping_method.translation.description`, `shipping_method.translation`.tracking_url as `shipping_method.translation.trackingUrl`, `shipping_method.translation`.custom_fields as `shipping_method.translation.customFields`, `shipping_method.translation`.created_at as `shipping_method.translation.createdAt`, `shipping_method.translation`.updated_at as `shipping_method.translation.updatedAt`, `shipping_method.translation`.shipping_method_id as `shipping_method.translation.shippingMethodId`, `shipping_method.translation`.language_id as `shipping_method.translation.languageId`, `shipping_method.translation.fallback_1`.name as `shipping_method.translation.fallback_1.name`, `shipping_method.translation.fallback_1`.description as `shipping_method.translation.fallback_1.description`, `shipping_method.translation.fallback_1`.tracking_url as `shipping_method.translation.fallback_1.trackingUrl`, `shipping_method.translation.fallback_1`.custom_fields as `shipping_method.translation.fallback_1.customFields`, `shipping_method.translation.fallback_1`.created_at as `shipping_method.translation.fallback_1.createdAt`, `shipping_method.translation.fallback_1`.updated_at as `shipping_method.translation.fallback_1.updatedAt`, `shipping_method.translation.fallback_1`.shipping_method_id as `shipping_method.translation.fallback_1.shippingMethodId`, `shipping_method.translation.fallback_1`.language_id as `shipping_method.translation.fallback_1.languageId` FROM `shipping_method_translation` `shipping_method.translation` LEFT JOIN `shipping_method_translation` `shipping_method.translation.fallback_1` ON `shipping_method.translation`.`shipping_method_id` = `shipping_method.translation.fallback_1`.`shipping_method_id` AND `shipping_method.translation.fallback_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.fallback_1.name`,`shipping_method.translation.name`)) ASC
Parameters:
[ b"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" true b"jŠQ\x14kßE®„¯ÅhpuÓ€" ] |
||||||||||||||||||||
|
0.55 ms (0.28%) |
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.fallback_1.name`, `customer_group.translation.name`, COALESCE(`customer_group.translation.fallback_1.name`,`customer_group.translation.name`,`customer_group.translation.name`) as `customer_group.name`, `customer_group.translation.fallback_1.registrationTitle`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.fallback_1.registrationTitle`,`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) as `customer_group.registrationTitle`, `customer_group.translation.fallback_1.registrationIntroduction`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.fallback_1.registrationIntroduction`,`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) as `customer_group.registrationIntroduction`, `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.fallback_1.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.fallback_1.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.fallback_1.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.fallback_1.customFields`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.fallback_1.customFields`,`customer_group.translation.customFields`,`customer_group.translation.customFields`) as `customer_group.customFields`, `customer_group.translation.fallback_1.createdAt`, `customer_group.translation.createdAt`, `customer_group.translation.fallback_1.updatedAt`, `customer_group.translation.updatedAt`, `customer_group.translation.fallback_1.customerGroupId`, `customer_group.translation.customerGroupId`, `customer_group.translation.fallback_1.languageId`, `customer_group.translation.languageId` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.customer_group_id, `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`, `customer_group.translation.fallback_1`.name as `customer_group.translation.fallback_1.name`, `customer_group.translation.fallback_1`.registration_title as `customer_group.translation.fallback_1.registrationTitle`, `customer_group.translation.fallback_1`.registration_introduction as `customer_group.translation.fallback_1.registrationIntroduction`, `customer_group.translation.fallback_1`.registration_only_company_registration as `customer_group.translation.fallback_1.registrationOnlyCompanyRegistration`, `customer_group.translation.fallback_1`.registration_seo_meta_description as `customer_group.translation.fallback_1.registrationSeoMetaDescription`, `customer_group.translation.fallback_1`.custom_fields as `customer_group.translation.fallback_1.customFields`, `customer_group.translation.fallback_1`.created_at as `customer_group.translation.fallback_1.createdAt`, `customer_group.translation.fallback_1`.updated_at as `customer_group.translation.fallback_1.updatedAt`, `customer_group.translation.fallback_1`.customer_group_id as `customer_group.translation.fallback_1.customerGroupId`, `customer_group.translation.fallback_1`.language_id as `customer_group.translation.fallback_1.languageId` FROM `customer_group_translation` `customer_group.translation` LEFT JOIN `customer_group_translation` `customer_group.translation.fallback_1` ON `customer_group.translation`.`customer_group_id` = `customer_group.translation.fallback_1`.`customer_group_id` AND `customer_group.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"äõ\x13#,\x17K——‹~\r\x17\vÔ4" ] |
||||||||||||||||||||
|
0.51 ms (0.26%) |
1 |
# cart-rule-loader::load-rules::search-ids SELECT `rule`.`id` FROM `rule` ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters:
[] |
||||||||||||||||||||
|
0.50 ms (0.26%) |
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.fallback_1.shortName`, `currency.translation.shortName`, COALESCE(`currency.translation.fallback_1.shortName`,`currency.translation.shortName`,`currency.translation.shortName`) as `currency.shortName`, `currency.translation.fallback_1.name`, `currency.translation.name`, COALESCE(`currency.translation.fallback_1.name`,`currency.translation.name`,`currency.translation.name`) as `currency.name`, `currency.translation.fallback_1.customFields`, `currency.translation.customFields`, COALESCE(`currency.translation.fallback_1.customFields`,`currency.translation.customFields`,`currency.translation.customFields`) as `currency.customFields`, `currency.translation.fallback_1.createdAt`, `currency.translation.createdAt`, `currency.translation.fallback_1.updatedAt`, `currency.translation.updatedAt`, `currency.translation.fallback_1.currencyId`, `currency.translation.currencyId`, `currency.translation.fallback_1.languageId`, `currency.translation.languageId` FROM `currency` LEFT JOIN (SELECT `currency.translation`.currency_id, `currency.translation`.short_name as `currency.translation.shortName`, `currency.translation`.name as `currency.translation.name`, `currency.translation`.custom_fields as `currency.translation.customFields`, `currency.translation`.created_at as `currency.translation.createdAt`, `currency.translation`.updated_at as `currency.translation.updatedAt`, `currency.translation`.currency_id as `currency.translation.currencyId`, `currency.translation`.language_id as `currency.translation.languageId`, `currency.translation.fallback_1`.short_name as `currency.translation.fallback_1.shortName`, `currency.translation.fallback_1`.name as `currency.translation.fallback_1.name`, `currency.translation.fallback_1`.custom_fields as `currency.translation.fallback_1.customFields`, `currency.translation.fallback_1`.created_at as `currency.translation.fallback_1.createdAt`, `currency.translation.fallback_1`.updated_at as `currency.translation.fallback_1.updatedAt`, `currency.translation.fallback_1`.currency_id as `currency.translation.fallback_1.currencyId`, `currency.translation.fallback_1`.language_id as `currency.translation.fallback_1.languageId` FROM `currency_translation` `currency.translation` LEFT JOIN `currency_translation` `currency.translation.fallback_1` ON `currency.translation`.`currency_id` = `currency.translation.fallback_1`.`currency_id` AND `currency.translation.fallback_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"#»Í\rZþC\x07++Ý—›gA" b"/»_ââšMpªXTÎ|ãâ\v" b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" ] |
||||||||||||||||||||
|
0.48 ms (0.25%) |
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.45 ms (0.23%) |
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"æ\x1Ci›\f‰I#{^ùÆ%Ø" ] |
||||||||||||||||||||
|
0.42 ms (0.22%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
0.42 ms (0.22%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
0.40 ms (0.21%) |
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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
0.35 ms (0.18%) |
1 |
# generic-page::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"jŠQ\x14kßE®„¯ÅhpuÓ€" ] |
||||||||||||||||||||
|
0.32 ms (0.17%) |
1 |
SELECT `country`.`id` FROM `country` LEFT JOIN `sales_channel_country` `country.salesChannels.mapping` ON `country`.`id` = `country.salesChannels.mapping`.`country_id` LEFT JOIN `sales_channel` `country.salesChannels` ON `country.salesChannels.mapping`.`sales_channel_id` = `country.salesChannels`.`id` WHERE ((`country.salesChannels`.`id` = ?)) AND (`country`.`id` IN (?)) GROUP BY `country`.`id`
Parameters:
[ b"jŠQ\x14kßE®„¯ÅhpuÓ€" b"æ\x1Ci›\f‰I#{^ùÆ%Ø" ] |
||||||||||||||||||||
|
0.32 ms (0.17%) |
1 |
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName 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"jŠQ\x14kßE®„¯ÅhpuÓ€"
]
|
||||||||||||||||||||
|
0.28 ms (0.14%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"‘ü¿ ‹ÝEî‚X¾wnƒ"
]
|
||||||||||||||||||||
|
0.26 ms (0.14%) |
1 |
#cart-persister::load SELECT `cart`.`cart` as payload, `cart`.`rule_ids`, 0 as `compressed` FROM cart WHERE `token` = ?
Parameters:
[
"7SykxRVtdNu2eS4nt6O7CegL6AGyPthO"
]
|
||||||||||||||||||||
|
0.22 ms (0.11%) |
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.21 ms (0.11%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
|
0.18 ms (0.09%) |
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.15 ms (0.08%) |
1 |
SELECT LOWER(HEX(language.parent_id)) FROM language WHERE language.id = ?
Parameters:
[
b"#»Í\rZþC\x07++Ý—›gA"
]
|
Database Connections
| Name | Service |
|---|---|
| 0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.