GET https://maxcluster-test.dev.intocommerce.de/detail/608808b545a04939b4b2e475c2c62b65

Query Metrics

145 Database Queries
76 Different statements
105.65 ms Query time

Grouped Statements

Show all queries

Time Count Info
24.17 ms
(22.88%)
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.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `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` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `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` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|b2f2d44613e14b4395b4e4e8e21ab6f3|%"
  1
  5
]
18.74 ms
(17.74%)
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:
[
  "/detail/608808b545a04939b4b2e475c2c62b65"
  "/navigation/088ab33dd0bc4a5f8c0934c398349c15"
  "/navigation/1d8e1177402c40c8a62dd1f82a988c6e"
  "/navigation/3c9f9ad04c044e60848ad7b8bf00ff75"
  "/navigation/4648e24b29894e34911f755368bc4bc2"
  "/navigation/5d78813ad07c4ec8be05b8761b358536"
  "/navigation/81a030a873ec4238abd40602c7950d25"
  "/navigation/8d2a6ffaef704adbb0d36b136f2cff00"
  "/navigation/acfc5c7680954f77860160cf04a3f678"
  "/navigation/adc3e8f212254b17ad6f2b12dbea26f0"
  "/navigation/cf602e9d39874898a3d07bf70242de97"
  "/navigation/d30c5a690af944dd89958dd8abdb7b06"
  "/navigation/d6ce4f206cf44513b7e4fef5035f07e9"
  "/navigation/fde599cdee64413d9c346d6bf031dbb8"
  "/navigation/018f7c68b8f27a4ca2e158e78b76383d"
  "/navigation/6897244154f593885eb2c8832d00ed81"
  "/navigation/14966fc566af43c1a35467a502c535f5"
  "/navigation/011ff033b7a641ae8a3bd6505ceb1703"
  "/navigation/2cd64315ccd34e05aa0617d056418871"
  "/navigation/40c6b6fd64224ef9bc66bfcf15dd9ca0"
  "/navigation/6306816b71514ac992a5590e9ddc9ad0"
  "/navigation/707a74b50a6b4ab3933a9b320cd875c1"
  "/navigation/e154f9d3a10e443cbaa18188baa5b4ee"
  "/navigation/257e634185da4731905e09d90799ed46"
  "/navigation/053ea0ee61a34a39ba0cb8dcacd391bd"
  "/navigation/08a69edca4974fa4a095b5cbc46ed360"
  "/navigation/29e4e7a2557a4c8eac7a7d4916b6ab85"
  "/navigation/2f16cae5a9cc4c7bbc027c4985dff0a5"
  "/navigation/42e6fd36b2b3442c83ca118108e2180a"
  "/navigation/76880fa406724bee9451994b5634076e"
  "/navigation/79d223bb5f134ed3b9102ec77a676fa2"
  "/navigation/80c2922725cb45e980f5003034cae392"
  "/navigation/84705047aca54f468b5f1de0af0c3037"
  "/navigation/d1110308dac44ff397b3f2eb4b01d83e"
  "/navigation/2dfee922b82540f08879eadf99b40bff"
  "/navigation/1082641265e1491c89a8d4cb17007c21"
  "/navigation/1fd297f931e5413f9b813c5df0bbd913"
  "/navigation/33a281fc29244f2da09b2a8e26c0b1fd"
  "/navigation/5d5c104ced274a8b8a5487b166b80c59"
  "/navigation/7b64a4e24a2e45cf970cdb50f961c4b0"
  "/navigation/80261dfb09724466bc537ea977ca57d3"
  "/navigation/8c8555054c294ef6acc09afef3f93bb8"
  "/navigation/e3e0cb77bae6477d9d5c364f540c6c2f"
  "/navigation/45b3117d30d146fabc2bcc2376cc8f15"
  "/navigation/2597c2478adf4c8280f28780ef208a8c"
  "/navigation/3735e229cdc7483a91e257bde1567e26"
  "/navigation/43fa5e3d35864f1883dad1dd97f7d56c"
  "/navigation/963c3ed4a39d43ffa25f7fd7220dd791"
  "/navigation/b16a2c3080c945cfba6cb81a8b77733d"
  "/navigation/e512a43fe6de49969e2f9f4cf8b5177b"
  "/navigation/518339d33ae7444e84ffece83d850541"
  "/navigation/1a238de28a4f4f8798be6225f5a223d1"
  "/navigation/1d53d591d6d24b978149649c2409e462"
  "/navigation/365cd782dfb748c4873bc653791021cf"
  "/navigation/426074dcccac4448b2aa22daea9c8ccf"
  "/navigation/4e8e956f75e143dab1bce462b482c258"
  "/navigation/5be19d0a3f7941909bc0a4df452e790d"
  "/navigation/62be1a4f54274b62bb013903224d178a"
  "/navigation/95f9509c6b5e455287f576c9895d1c76"
  "/navigation/c100a32e27e1441c830ecbcab4800174"
  "/navigation/d92dfd3269ce4e16b8d3f3e04a57b69d"
  "/navigation/e72315c703644d609ec3a73bc3387d54"
  "/navigation/f7db62fa03044448bbf3d678a46dcefd"
  "/navigation/fe27677a6aa344e7a3484ea64a5ee455"
  "/navigation/60a4908f81a14045adbd53fd1e73004d"
  "/navigation/396f5ffaa48b4df5bef139ca5011b3db"
  "/navigation/3c58388f397f41d680581772457fc00e"
  "/navigation/476bdb92f9094a50ae0614608b2dd36c"
  "/navigation/62ffe49c73db418b916b07e546405555"
  "/navigation/7b5a65a81f6b4d85b635910cc07bf730"
  "/navigation/9525176729374bdaa65381f27ce5f516"
  "/navigation/a25845af1b9a4ae8aae22e4699f7895f"
  "/navigation/a549511597184fbe9896da6a9b5ffe4f"
  "/navigation/b9ee97bd532a491080c98f0cb4548ccd"
  "/navigation/c2cac1c2cd6944fcbedae34e4a9bc634"
  "/navigation/f7536239747d432a91e04a5a766d9109"
  "/navigation/ba12538ad08b4a52a5f51eeb96d544af"
  "/navigation/35ed4d7dfeca411ebfb86fb9451eb633"
  "/navigation/4b190a8985784f77965a171473f7d492"
  "/navigation/5098515a4fb54c1e9946898e6ef80e1e"
  "/navigation/58d6fc10fba84cf1b9487bbd8a2f44f8"
  "/navigation/7297f1506691419a954a66e08a9fa454"
  "/navigation/8608f7fbc58e45f3aae78d5daa05c7b0"
  "/navigation/9e491c6dc46a4d83b0dca0fd04dddd1a"
  "/navigation/aa3788faa9344f438039bf8766fa453f"
  "/navigation/c1c74912b333437a9b4adc13473a298f"
  "/navigation/c8f29bf169e143e6be7b623a3be2d437"
  "/navigation/dd4d3e01a56348c9bbd05bf068d302b5"
  "/navigation/e6c907286fed4b1eb8b0ce407f72dd89"
  "/navigation/eaabea926057416b8a58fa1f625b129c"
  "/navigation/fff81b83d78f43cc875850b9efb5b31f"
  "/navigation/d79ed083670946128d0e042845587de9"
  "/navigation/19e6e83127d84a71a6390c55d68525fd"
  "/navigation/23ec418b8c50487d83bd9684801f15e3"
  "/navigation/9242638377d248d2ad33aff5734bf3e4"
  "/navigation/e249114fe6834c21995d0eec4164e3fc"
  "/navigation/52efe64d01444605b69f670a1f12d5cd"
  "/navigation/9da1d85f9f964dd6845f624ac2d66174"
  "/navigation/f2ff83619c1c4144965224fa028b9367"
  "/navigation/382e54c61b4b44e69b881eb3ec77586f"
  "/navigation/00242735f4a34a88ae734ae5776779f9"
  "/navigation/19507577c4bc4f868468e3c58a60f600"
  "/navigation/3f8c42d8ba4e41548fe214fe422ba949"
  "/navigation/9473ca5405ad47f0adbe17a80f6adda1"
  "/navigation/bd4077a37c584cd38d964bb250430835"
  "/navigation/c1baf527f37f4369922518a87211c2ac"
  "/navigation/99d297a6786f428b95daa78371e561f7"
  "/navigation/0d8256c7dc83401c9230bfd8e31d79ab"
  "/navigation/0fb6ae96bf084d9daa8312f8407bf438"
  "/navigation/2b8c69d3aef24072b898e5b3ef2dcf4b"
  "/navigation/36b2f1a187bb420487daa2a1de285132"
  "/navigation/4f259d0b751b4fcc9be8ca1329b37303"
  "/navigation/505fc425cde44a0ea99fd9327e24136f"
  "/navigation/53842b72f8c74cf1b41635e19b4b8240"
  "/navigation/63704ff15424494ea74833c6dd4a455e"
  "/navigation/7c25407d91924d7cb0315cea70fb2440"
  "/navigation/83a14bc41cee463b80b95b07f1c43aad"
  "/navigation/85083976bf384c9b83a12e8fa64499a4"
  "/navigation/864456f071a84641be01c579fd8858f4"
  "/navigation/a1973dddaa084a3e91c940497a675872"
  "/navigation/adc0abcb756f4e12bcae1309c9f4074c"
  "/navigation/b80457c4ec0d4b94ac65de0c1c46dbfd"
  "/navigation/bd8b9b249fd54bd6ba7136cae74dac74"
  "/navigation/c8d0b7962f4d45059d082a462f472e47"
  "/navigation/fda108eb042d4cd7b9fd70b91f138736"
  "/navigation/aec8b3bf5611428e9d310051e618fe31"
  "/navigation/12048f5aeffa47d6b650a3847b7ff4d1"
  "/navigation/2f7fd1e6769248efbf222154bead7793"
  "/navigation/3787e6e229c24c7f8cffd70b489007e4"
  "/navigation/41442e3c37404c39a3cb5146574d3f58"
  "/navigation/53ae35eaf32d418194790728b84a893b"
  "/navigation/5738f034c8654986b17f1236c7595903"
  "/navigation/6bc7f7f256ba4c48b8bac5a7f69c52ea"
  "/navigation/7329db8f5e3c48e38b2383c52f694f7a"
  "/navigation/82d764e954df42e79a2b137c1400867f"
  "/navigation/a3f0ce29570e4b018a2405f899fbea85"
  "/navigation/c5c5d534e2214e1cb23b82aef855895b"
  "/navigation/d2b39fb0175546d9b6ea8c2942840c9c"
  "/navigation/e5d0bd89fb39487b923325af59b84f4c"
  "/navigation/f237173478704142aad7feb01e8aceea"
  "/navigation/f1cba8851e454aa4abb1315e6500846a"
  "/navigation/055a63fbc5a84b3d8740594b1bb8d606"
  "/navigation/0a0fa93c45d642bebbf5f228f981d8fc"
  "/navigation/110155b86f1e4d89b762fd2ba4d6595b"
  "/navigation/5ed58d500ec74d1db847efbfc63d258b"
  "/navigation/6934ad2fe92a47b082e77923f6361e4b"
  "/navigation/6b370fef10414743a840b4c6a527bcce"
  "/navigation/953e98a675fe477a9ced62f5d048597a"
  "/navigation/95f4d77c59184406bc8e7d6d6aaf263e"
  "/navigation/bbb0b8da68944ee1afef8bb8cdd26dd5"
  "/navigation/d7dba130deee4dd79200bb915275ecab"
  "/navigation/f385d22eb2fa408cb4839e4bee88e60b"
  "/navigation/322e1f8f6bdd4345b0adb06e47a96643"
  "/navigation/9ba5c667beb24a8fa93926a2cc73668c"
  "/navigation/b0414ab6f02241e7b32fdca182e76ed0"
  "/navigation/b6cf7b5eb41f4b83849dfd0b037a64fb"
  "/navigation/41e734eb10444033b992fd4b5b2576ba"
  "/navigation/03bab0d568b84defb4f42f67ee08c09d"
  "/navigation/1f6236811d0949e3b7ae9c5143a9d90b"
  "/navigation/29b7c8dd0a1b431a81cffbabaa00b661"
  "/navigation/2c08d940f03b460cadc54c664602c114"
  "/navigation/3b565f68f38b48e988184148d9d9fd27"
  "/navigation/3d1f349403134211999a909e79e11125"
  "/navigation/40088ff7d7404051ae38510c65f026d2"
  "/navigation/412c90c5432a429baf785306a7f4f9ec"
  "/navigation/563e2aa4094a4808bc5253b1d7772b40"
  "/navigation/6ee041c6d189441686f1abf478dcdc13"
  "/navigation/9cd58c17170e43cba716b290f7be8d5d"
  "/navigation/b1fb1f72841e4c5a8943c7b3e6929dc2"
  "/navigation/dc81c1404e1d41c8af803f875ae6f937"
  "/navigation/f04b05872d764f5ea4c9832bc659b725"
  "/navigation/f97fa5db01c749dd99bdb72035448b6e"
  "/navigation/5017761a2df84b23937f376082303643"
  "/navigation/130a2eb651e041baa0ed552177174572"
  "/navigation/31f3835ee8e340d29905055f8933d293"
  "/navigation/796bbebedb8045f0a283fbb4cc2bf55b"
  "/navigation/5928db52a7ce4b0fa63fa082a99753d0"
  "/navigation/353e9cf8f36b4007858c99b36a5f9b10"
  "/navigation/4d39cf27788d4493990d032365b8e47b"
  "/navigation/55af1c22a64f4a51b1d307fd7b601c3c"
  "/navigation/df1ff64456cc4834a77398d8695c383f"
  "/navigation/ebb9022060f247188a22753275f7ccb4"
  "/navigation/5aa31b9adf6647779bfe979aa358a03f"
  "/navigation/09d5bc9286ec454180f3d3c969278556"
  "/navigation/59f81712508141fdaf92f1535b46bfa6"
  "/navigation/5bc80e037cd14f60805d423b429cb21f"
  "/navigation/8280dc3681714852a1ad91332ba32878"
  "/navigation/601c0288b7864b06b336b4a8fc88d517"
  "/navigation/038fc327195a4fb7a3e303d8470b8898"
  "/navigation/05bb2d463c38461daf38c80db142a0ed"
  "/navigation/23efcf3f4c5c48cabb610b6ae5b83246"
  "/navigation/2889e653e9df4c0db4270f770a47dcf6"
  "/navigation/2bb1b91f198f4ddc9b078928a0b93cd8"
  "/navigation/3849a001038c4eb598f8419accaa7570"
  "/navigation/4c24468279574576b54e0a079dd7dabc"
  "/navigation/54096719657f46068bc879d10c4e42e6"
  "/navigation/6e4253006e94443da33f3ce62ec6ce12"
  "/navigation/777e97e997554b81b10921a9b489d608"
  "/navigation/8958be49443d4c08b080590338fb7590"
  "/navigation/b3c53ce370814c27b865665d6e96a7bf"
  "/navigation/dc9d899cbdeb43edb92e592cdc0f0ea4"
  "/navigation/ddf84d3c7ad14016b289cb96e6284aca"
  "/navigation/f255e02be07f4f098967e2b32e7f6f54"
  "/navigation/838d96d6ae75488f99c25f0949ec6a03"
  "/navigation/0b60010a1d0643679ea80a7050a9558e"
  "/navigation/12ae1b1a3ed442a0933f56727a88de03"
  "/navigation/44040d66797d49b7a4555b469edba8d8"
  "/navigation/94b379060abf473eb2afece105786a5e"
  "/navigation/b23b7e6e958c45fd805596e7e7801391"
  "/navigation/946e34fc3fd44fdc862b2fdd3ede15b4"
  "/navigation/0e5f6c7028f24f61ba81a3df091f8c9d"
  "/navigation/4e92779a6ba147ea870020932b8f8e11"
  "/navigation/7826c1dc14dd432d9a983bccb08ef2b6"
  "/navigation/9496e1f5f67c4bcaacb15b7ca0e759c9"
  "/navigation/a33bcfec239f44d3895ecc356570fe41"
  "/navigation/bcda30414cd74bdc99eae14e4a9b68b5"
  "/navigation/c69927d7dd304ac793b5c67d22d51b7f"
  "/navigation/a1a410051dfa42b39456f817d9070956"
  "/navigation/2708652e9e7f4889b2ee98ee444f700b"
  "/navigation/2bc3db9ced464f3cbe2c01fc6161cd6d"
  "/navigation/46d87882303640deabed1b022724e8be"
  "/navigation/7e118c556d824881a28257cbbf8dabd1"
  "/navigation/7ebf42096bd043bab2b9a4cc9ba17b2c"
  "/navigation/d76ac142032b49eba4b41631d624e599"
  "/navigation/f43c78a9ad194c8ea3c2995650037439"
  "/navigation/ffcf3faffab0449f9111c4b4b4de3f1d"
  "/navigation/c8544fad97874aa688ef34848452b3eb"
  "/navigation/07cdb3416d1847e3ade26e1eb6b8f48e"
  "/navigation/7d4ca565731a4b3ead21c07731bb46d4"
  "/navigation/c9ef528c90a34952a09e5d476ca6a5c1"
  "/navigation/ca3952a9ab2144f2b7a22d51e962c22e"
  "/navigation/14967c95b88747cd802a1a9075eabfd5"
  "/navigation/2a12382cbbdd4af99437dcc940cddfbd"
  "/navigation/2aadc1afcf7e4aed9c63eec7be008bb0"
  "/navigation/2ab01e3b914a439297dcb63cf92a9f78"
  "/navigation/44c16a7fa16945f8b41fdbb53280c138"
  "/navigation/52592caf857b4d6c9cf58b878499cc77"
  "/navigation/5c044936b476478b812b6c308af8afca"
  "/navigation/5d324eed929f47ecb435d66b41f732ad"
  "/navigation/7ad54c89616749d3a1c81504cb110d89"
  "/navigation/90d0701303884813b1f0137b21d0afc4"
  "/navigation/ad2d897fcad64ffa9dffe8265df65feb"
  "/navigation/ad355273e2be4ac286c27013762bf4f3"
  "/navigation/c34dbdc970c04d72a71fd474f99d9f98"
  "/navigation/c86fab5d485642489dc28ba1624fd393"
  "/navigation/db9433d836844df39fb79e68640864c6"
  "/navigation/dc660634931144479387b17bead0abfa"
  "/navigation/ddcee570cdeb43478cbc1a0991dede6f"
  "/navigation/deab3fef95284e0cbb061a0e7725b041"
  "/navigation/e032928c031b402a88d3f0e4090af286"
  "/navigation/f2e2c2980dfc4b039f5c06316df77f3c"
  "/navigation/cad3c22cf909401fa8c4687d3fa78643"
  "/navigation/071e5c6f9e144c418b9a00fd6a1fd54e"
  "/navigation/1100ef423d6246b2b36672a17052426b"
  "/navigation/287af0aaef724aa387eaf301354d7be6"
  "/navigation/3adce5ed23e34d3a819209fd79f22946"
  "/navigation/44519239dc0a4a70ac32fa6ad03c3e63"
  "/navigation/4b4e374f0ec64b9eaf9333a1f571c26b"
  "/navigation/8414fddeac2c4874ad6bb1ed8277d9ea"
  "/navigation/a1f89c5fa8744325b863345d130dbe66"
  "/navigation/a4890f6c26944107975fac6097a51df3"
  "/navigation/df0fbc94170246ebb3990d34ecedafd9"
  "/navigation/e88b99f6f91b4648860c055553206470"
  "/navigation/ecb39c50a723464985e3674de9ebe4de"
  "/navigation/e2a12951673a4cb89ff3619f155839b1"
  "/navigation/6c6729ac0df84a2f94e5485d6f4f1edd"
  "/navigation/e4cb3dd975de4b0faf2e342555ae8c4c"
  "/navigation/1d30ffd10aab4ea993d27e9e1a1c6685"
  "/navigation/60362513a78d47a79c43999326dd4b1b"
  "/navigation/eac6e74d05bf40e2be2b2e42e199fd35"
  "/navigation/2e519877e05f4d409fa5ff690032b8de"
  "/navigation/2460b8f79e714621b768ec8d73756499"
  "/navigation/a2bdc34cc7884b43839ee81fc05aa4f5"
  "/navigation/4d684a6737b34598ad26b283bf16a333"
  "/navigation/327a9b534bd443909f6248c6d9057b3c"
  "/navigation/772c16f646a64b3b862a6751dd009445"
  "/navigation/7e75eba197ac4af891b93b2c468cf279"
  "/navigation/af7318668cd24c0ab15bd8f6f8f9f499"
  "/navigation/fcb2407330894813b88e3468ab4ff214"
  "/navigation/a2cc2abafaaf46ee8cc9858bf27d90bf"
  "/navigation/b6f0d0d0cc9740d6a0642ca063a4dabc"
  "/navigation/19a32b6bc5f040dda7d8c19dd8f58438"
  "/navigation/1f3671fbf4264c35b861472c67a50235"
  "/navigation/8b9027ef389342dba8fe2b96ff685b7c"
  "/navigation/e33c0cd2ca8c4ef6bafad807ef0d677b"
  "/navigation/1ad95753e8b649a28a26a021c00d17b6"
  "/navigation/1bb1cbc34253455293f19b8f009da4af"
  "/navigation/6216d946dbd14c648d4c58ada3e9101a"
  "/navigation/ab0cbf07ba464da88fa8aea963bddaaf"
  "/navigation/d4adf381f87645aeac870dbe5ffd7bef"
  "/navigation/f5cfd2f0bd4d458395a6953087a7c26c"
  "/navigation/1c1ce5841a724cc78a57d7ef1762f24f"
  "/navigation/5db5f94977dd499187c9394d81a4fc0a"
  "/navigation/82558dc2681e4dab8cb975fd0f1f3e5b"
  "/navigation/852cdb3711cf4c16b13e0e8e29e373c9"
  "/navigation/e4cdf61db0a04e83b99345e457aadb5c"
  "/navigation/4b55d794c2944406ad7f02700f24112a"
  "/navigation/37f6e12c03804f4caf18a612ee56f15b"
  "/navigation/eeea3f5be7a841f5aab0b8f55d5f2775"
  "/navigation/72a1cf34f95f4db39a981def792b4f9f"
  "/navigation/01a22e69aeb346a3a17d461374789f9d"
  "/navigation/3df9b69addbd4737af52f24b93c9abec"
  "/navigation/43f6c2f18c2944bcadc6ec376363411d"
  "/navigation/5d2db8546ec74dd0834c3d176ab1f374"
  "/navigation/9c06050bac6b453bb76e95a67a991398"
  "/navigation/89b2774fc6284d97a17901f72622ac11"
  "/navigation/251bc93a6af14f20924f85d26f5d213e"
  "/navigation/62ede537498f4b5faa478782f45699fc"
  "/navigation/76b6eddc92e74d88aa41235e1f7eaa3b"
  "/navigation/91a5e5c512764cea9d8b0d7b8886e21b"
  "/navigation/a9bedd8bfde048ed91a9eeeb6ee8bb64"
  "/navigation/b792e1d7dc3142e599bf5dc694cbd06f"
  "/navigation/b7b2c896af384394a4742c339a259ffb"
  "/navigation/ce59c014d9a0415c868e889447d7ae28"
  "/navigation/f19806c10ef74d4ab3c9737f77922432"
  "/navigation/a95465aa9f224c64a083b1aeb18a4619"
  "/navigation/4a25371ffb064c9bbb05f80bd1156289"
  "/navigation/af25e6d422d0453d881908cef34c498c"
  "/navigation/21a0a9d4b9544487a48f4ad63b56c285"
  "/navigation/616bd91d537541f59e9a60c8e96cd681"
  "/navigation/b314252b49ee40599a6c59d02c97d604"
  "/navigation/0a8c62f10b3f4b1d833a8f46a8d63430"
  "/navigation/4421e0c9746449a9baf9909fd673191e"
  "/navigation/4e1b628f96c940e8b009830fcdcafd2e"
  "/navigation/86e9b0f3d0624e59b7effed328450cc2"
  "/navigation/937d96bc983d4bee8404abaffbbab38b"
  "/navigation/d3dd24e936b54cdba94981e9ae89d7e8"
  "/navigation/c267f8a7055a4866a3c0cf240ba714a8"
  "/navigation/72c02060bcaf4ed9a5121d532bc6d85e"
  "/navigation/73a57f2dc666485ca1c45cc49d16657d"
  "/navigation/b2f6ee3b56b5441796b1b8d021959934"
  "/navigation/b4bef3b4f639484fbea1ad30bdbbe27c"
  "/navigation/c00f2f52fc3d4e039eb3c637f8bb08b3"
  "/navigation/e6f36980b55948a68b0b73f9a087177f"
  "/navigation/f0cbe088b7cd4773a332aac98098a9c9"
  "/navigation/08a945dcf70e49d0a705b804da682c1c"
  "/navigation/12d164e94c8c433590db7cafad3b38cf"
  "/navigation/342bf38357fb4d33ae8f8d450710bae0"
  "/navigation/39047663ea3345a48c7cdee08a9ef337"
  "/navigation/3f23c481ca474893822bdd7eea3d5a65"
  "/navigation/78e6452317454baa81f3994eca4f791d"
  "/navigation/bb29500045e242f299d88228fb8e29e4"
  "/navigation/d4a5e38067a740e38ec9d674068b99e8"
  "/navigation/f3b7a02f97d740d9adc7c7b33dfa30a3"
  "/navigation/aa96d4808a504df1a969870f2ddeac97"
  "/navigation/f50f4f96dcb04df28687ddec95b0dcc3"
  "/navigation/39583ea06f2649188f627fdd8b1acd56"
  "/navigation/514c68eff9734cf080e34cac7a188d5a"
  "/navigation/980b40fc09c84c31b600a3b606162b57"
  "/navigation/a833fe17b5894bb19c555e919fe177d1"
  "/navigation/fd8cc79cd81844f89dcfe02a4332ad6b"
  "/navigation/fc25d489599c47b0a399fd1d66eca149"
  "/navigation/3e2df6c2cebc48cab924e0aa46fd6f22"
  "/navigation/8168586b300f4acb91c00e08472b07a5"
  "/navigation/84bb363ec79546dd8d249d3b56f61769"
  "/navigation/8cba9f67c5c7429fa7cf00df2f67eb1f"
  "/navigation/fc8ee83bd3e14668bda416d869921d3c"
  "/navigation/c8e5696bdcb54bf7abd427fcecfe0ce8"
  "/navigation/e99ea1265be64896841a95421657af25"
  "/navigation/13a75595beb940109e61f7c7bbda8b19"
  "/navigation/07402d8694c44c7ca6a63a5c1762496e"
  "/navigation/0da34f854d8f417f8b411a14a9d923e9"
  "/navigation/29c816a2d0ab45f4bc3a62c829a4d6ad"
  "/navigation/30748b97f2ee4b73b01b494f89e4a42b"
  "/navigation/32d4439185f84dc18d5f78116561978d"
  "/navigation/5607be3ad4fd437a9a1aea47e7d86b3d"
  "/navigation/56595fb9f7b047c9b1d2d9cc7fa55b1f"
  "/navigation/5b8b80f844e14c179fff88d6fd4d37d2"
  "/navigation/69d919b63f0341d78fd9e0fd6331adbf"
  "/navigation/69fdf7894bd04b45a2cfb5b5a25c698c"
  "/navigation/82d74d67e8d347ef9e9c715dd0fe4b82"
  "/navigation/8460eaf18274443e94812d3e331b9401"
  "/navigation/8d2d7773d5064ab3a8ee4565d88c0c56"
  "/navigation/909d254be884427eb8644de360acda80"
  "/navigation/941c4c1e10c4447b983d4ba80b516e72"
  "/navigation/96eeb75b713a45e5aa866d458b497957"
  "/navigation/9a8546dc1ab84f889377b327906612f5"
  "/navigation/9b3414235d0545bcaa25cd76bf21699b"
  "/navigation/aae34c4e97de45fdbb59f974db0178d3"
  "/navigation/b585fddb8d454560957b4ee8772d82e9"
  "/navigation/b8c898a36b904f6890d36b4027f787c8"
  "/navigation/c20e57b279524de7a1bc966cc95510d4"
  "/navigation/c621b19668a84e4c8ff55d0ec04af77c"
  "/navigation/d20a8422b9ab4f46a59646a60dda6b73"
  "/navigation/d7a1efd528574604a895db7852dff24a"
  "/navigation/18dc1713f55842aebc4ab49306e425d8"
  "/navigation/09623455a354440b93326ac63f213686"
  "/navigation/13c48816d6ef4c8bb19966605d57286c"
  "/navigation/1baf4db4b5474fc7a6beb7bac24ff4d5"
  "/navigation/23b5c439d1c64b308a4665ff7bd20fa3"
  "/navigation/2f7654a5c92c41a39e0490623eb36136"
  "/navigation/72575bbe0bdf4e45820338bd9c84e562"
  "/navigation/7db1f753911e40b28a1a11244f11b7f5"
  "/navigation/a019f55f5e384dcd8687ea4391022463"
  "/navigation/aa20d63abb274f28a1b784d3c8ccf67a"
  "/navigation/d1b1e7bddd9e47f880965ed5e4003592"
  "/navigation/d95c4a4507c14f8e8537eefb353bf098"
  "/navigation/e89bb7e56f58420b87f2748c227b413f"
  "/navigation/fdf76543cf1e4ee9b641c8bb37eca6f2"
  "/navigation/25a7a1c84f0544258aa8565bc0adf2fe"
  "/navigation/1240511d7c8c4fa494dc9fcb6c58a27a"
  "/navigation/3f0228b85f4b44308c01be84feef2458"
  "/navigation/6e762f30da4a4b06a31456fac9ceb83a"
  "/navigation/7b0f1cdd89774ff98b5c398fef698aee"
  "/navigation/aa75442ff41b4f4f8b910e6f9d9b4914"
  "/navigation/b89f914c7a3e477d8e4492139aabc6d7"
  "/navigation/bbf121713c72485fbfc1771e058f7e1f"
  "/navigation/d42a9725a3be4e258a59e2b00a7cb28f"
  "/navigation/dc68e66c6b9a4315bbb28fb1ce908d99"
  "/navigation/f8048c5ca87a4ff68b9a746a4ce13a83"
  "/navigation/ff5aae875f5646038879a14c6bb373dc"
  "/navigation/2e342aa304f3400b8a7faadb52a1136d"
  "/navigation/df5e40e0d47a4303a351692d0b703ab2"
  "/navigation/36a74456b5c34c86a5afcde6b58cedf0"
  "/navigation/f7418a034096450395693b3bdd0fe474"
  "/navigation/3c2d13a2aeab414ea3a9091bb6ed15a6"
  "/navigation/dbb60c244c304fb4986d5e042b11a3af"
  "/navigation/3cb4821cb0fb41d19994d1c7dce7e903"
  "/navigation/127ad15b2530499487bf358fa5fee2af"
  "/navigation/4404c89ebef344a48e2361cf9bac440f"
  "/navigation/951f9a678fa445e2992919d945e3a534"
  "/navigation/98dff911d22b4ccd9fbef04ccd233463"
  "/navigation/9adff91cae4045eeb56c65d44c9dbefb"
  "/navigation/a097cfc043804379ba6d0872fdde275b"
  "/navigation/cc9904034a564e048af842d974e13e46"
  "/navigation/5071349196ef4fcb81b6387a4cd5e3d1"
  "/navigation/2a119f37ca144384bcf7290b44defc8f"
  "/navigation/871f2644c7bf497f8045679faa6f36f9"
  "/navigation/ac7e2b182a814a3bab2663c78c0e4761"
  "/navigation/c33820f292d643a49a09f4f561911c01"
  "/navigation/d9f215e058ad494db420cd5a2345b965"
  "/navigation/577253ed0fdc4f14a8dda94494d7d29b"
  "/navigation/1c965bfe1f10436aba8b27c57355b485"
  "/navigation/523cc18c2a274a78ab2fa47a015ee94d"
  "/navigation/c7d498855de940bf9aa169246d9eca0f"
  "/navigation/f27d4e6df3db4299adf551019993ce8a"
  "/navigation/5e354e44f79e428dbf9267c65da5c987"
  "/navigation/3ac1625f509845919e35e09c768767d6"
  "/navigation/6013511ebeb64c41945d2cb71febabf0"
  "/navigation/051a53c122a94732b7d0bb6fdf75fe69"
  "/navigation/0d307302822b4eeb888bc1728cc3fd87"
  "/navigation/1560dbfc3178401b8630827846e772fb"
  "/navigation/2f73e5e3db0a4ffdae48551887239724"
  "/navigation/422ac16b55b948bb87fe165116486177"
  "/navigation/4e70a3a9e28944a49d7d0861765bde68"
  "/navigation/6c65c9b1a927498bb4348608b426a17a"
  "/navigation/a04d0d10f73840ceb35d435a2b802955"
  "/navigation/af9559e12a6147d594101f5ed0dcea16"
  "/navigation/da9aa410f454462ab6ae2828263d66d4"
  "/navigation/ec8f8e3fb895463cbf2473de7597913b"
  "/navigation/7beb1dbb8b5341de96e1934526e60269"
  "/navigation/25e77313aa7d4448b15328239722ba54"
  "/navigation/3572061e1a614babbe95cb50f9903db8"
  "/navigation/8fb72d939ee3451ea684afdb8130f88e"
  "/navigation/b1edf629aba941ab9637af31b963fd86"
  "/navigation/f5e7d4c86e8a478f814dce2bddd30584"
  "/navigation/85d69e5f491e4c37b00c63739611b7cf"
  "/navigation/24439c30e78842eab81fcc5397341474"
  "/navigation/529ea0545029413f9b04789ba81fcba7"
  "/navigation/8047abc77b87414fa12c1cd93a76053b"
  "/navigation/a0bbe8128e01478087de809d3c6a1114"
  "/navigation/2b3aca235ce44e9f97cf9289c378e8ee"
  "/navigation/7635efc2cbf7413d9076196cc35e75e6"
  "/navigation/811a7dde8d0a40838405d1d2e3700880"
  "/navigation/8c840ee8d5f54bed8058d495e748cd5e"
  "/navigation/92074a55024d4e5ebfcdd27dc2faff14"
  "/navigation/a100f3a5f0d0499db930062a97a3dbf3"
  "/navigation/d3f369f151504b52811d60d22630f238"
  "/navigation/b0c1c6dfd11f4d54911c7a4c73742469"
  "/navigation/03e0fab567134d34ac02f6fe0a11a980"
  "/navigation/0e3b8379358e428b8324a50c755e5bc6"
  "/navigation/131718320df94670b2908caecde0e22d"
  "/navigation/2c231b6c886347d8b98c2302357e33db"
  "/navigation/35a0a7eddff1463d800b19fa8ebd2567"
  "/navigation/40110f46afa84e0a9971d68f1ebadd87"
  "/navigation/425291b35cce465eaae5c1a0d8f6028d"
  "/navigation/6f0af6b7c97f4aa7a4cc2a3bde22c549"
  "/navigation/8fe99f9c3a3d4ade994e501edbaa5a17"
  "/navigation/99869987e97742bc81ff19a506c3cead"
  "/navigation/ab91269e8b1b4cc99d81f2978dc1b8d7"
  "/navigation/d208193a7e964457b114c100d95d86fb"
  "/navigation/1bc6559f55414476bb6227a21cad4237"
  "/navigation/46dad8a4b47649948b7065efa0f5f453"
  "/navigation/6136c2435a9b4a86973390ce86766bab"
  "/navigation/75b8e01c48044d3f87a382a028e36c31"
  "/navigation/81ad89e900fb4e32bb55de989bc5b66e"
  "/navigation/92712c957f544f3f8e2f905c24218388"
  "/navigation/95510066e9834a17bb94e687dd00de15"
  "/navigation/dae68b140ab8423ea05c24129fcfe8cf"
  "/navigation/dfc7b50a3cd14bd4ac1d3da6edfe007e"
  "/navigation/4beb502464b1485095b2451de5dcda60"
  "/navigation/6fb6fd32bbce4bf8b234b48009bc7af8"
  "/navigation/07b5141a0748442a82c5709edb1a2151"
  "/navigation/47ae79069d1547f5b0df0163dc2d9bcf"
  "/navigation/7f6cd69918504a1e84f5b8e18fd88950"
  "/navigation/c6607d931c4246bf8841cfc217af8f9d"
  "/navigation/d97406acf9b04356a7039cddc0e33e6b"
  "/navigation/ed5b2c3d99444a0c99f50f42417dd891"
  "/navigation/2a62240556fe4c4fa02ecf877924b733"
  "/navigation/48a4b0a72844459db42b075b0c02e96d"
  "/navigation/d4c0f6127720448c84d44a9e66513b86"
  "/navigation/370792a24dde4754887c068060d10922"
  "/navigation/2d4c2d86231549979a72572e0d5c0a98"
  "/navigation/9c393db1b02e4185b7155d3a138215e2"
  "/navigation/4d2968a35838470fbd4e25dae2cb55d4"
  "/navigation/53496134c58041f3a8cfcd8097224da8"
  "/navigation/704ef17a4e5844d98e9d320add0ab7a5"
  "/navigation/dd967cb86c11422f8f2a362ad738c3a7"
  "/navigation/5aaae9e5257044f2923ea2b7c56dc349"
  "/navigation/29b7f0143dc6486488f1c5d437884187"
  "/navigation/2ad2c37be5aa4f0aafdaa21e52ca8809"
  "/navigation/482ce856eeed400d936b9bcf2774b4d6"
  "/navigation/5dd49c2e3873470b926dca5bdc998582"
  "/navigation/7d20f9bcc2fb4279a8555de2c56dccb1"
  "/navigation/76b0007685e44ee3a0e44a4d81650db3"
  "/navigation/3ca7890d3ddf422bb38483e8260f0f14"
  "/navigation/80a4cc865e9c47e7908d06aec03ff245"
  "/navigation/04a6085371b14655813695ebff9c5147"
  "/navigation/58451ef7ad594d8b8bf3d0703b396eeb"
  "/navigation/8f18a25e95df44aa90eace4c96be37d2"
  "/navigation/d94580c203324db8b252e5943870cec5"
  "/navigation/989f28a7381a4d09b10f0825d329fd48"
  "/navigation/a95171171ed14b2ca3d77f659d6a4736"
  "/navigation/dc2feab64f964e4aa5929f69c0c077f1"
  "/navigation/a029b7a58bfd480ab2b7a5148ff206d9"
  "/navigation/3017d8fb6a05449db32ab8c130c9745a"
  "/navigation/b2da61700e5741ae9839acc5aa349ccc"
  "/navigation/1a6bacc3e2914cfa927f66098119ef14"
  "/navigation/237fb0415a7947b681f0762a9e92f427"
  "/navigation/49ccc5e0114942118b0e4afb297ccfaa"
  "/navigation/7380aea17e7e40f89678e736e9b2c3ff"
  "/navigation/83ed7861ef78412d9f8cfa9d4c69e15d"
  "/navigation/9e66155307104689ac175dbbb8ca20ee"
  "/navigation/abc8463a54fe451492b8f4f25d619957"
  "/navigation/c6476935ec8146f99ca345106226eac7"
  "/navigation/ca6c0cfe1cd54ade8229ff3aa5928945"
  "/navigation/fbced8ce01cd44199c9e4dd0ffa51856"
  "/navigation/fe0524ac820d4289adebd55763589eaf"
  "/navigation/c64b5e4ff03f41a6a29910915fb46f81"
  "/navigation/3421c59f2c6349b8b38233afdb331698"
  "/navigation/3a96bdddc6204c2c894c28da4597245c"
  "/navigation/ecf5a529632a4134a6ea89ba825284db"
  "/navigation/6440f8b7dfcb4ffaaf46c6882392bf33"
  "/navigation/f1e70e2d4ece4566be9897ef98215b3a"
  "/navigation/1978aafa100742728f9cef49106bebca"
  "/navigation/3f574019f35f4a73a59328d45b24fb13"
  "/navigation/c0db7979942d402b80710d1cdf3566b4"
  "/navigation/cd66878f032746039ea4f62901ea6ae3"
  "/navigation/f4372c591abb43b1a670bc9b73507afd"
  "/navigation/02911ed8198148449ba5d1e3bb87ed47"
  "/navigation/eeb36e3ca9574d78ae852d435baf4087"
  "/navigation/2703f8a3a8a24c8d8a362df6594700a0"
  "/navigation/4f13c0547eb84ec384fd8c66e97a3002"
  "/navigation/879b1f2c49384ae09bb0885a831f6ebe"
  "/navigation/b7db69acf0c1476eacbb856011b60e28"
  "/navigation/b9a9f76e0cc8442ab1abc27c6d6f92a7"
  "/navigation/ec895be7047b486295e3ed24bd7267fd"
  "/navigation/3bb79319285f45b9a8ce1c5f566b4b53"
  "/navigation/a1a817a6fb624609b0976b3b3ca3a639"
  "/navigation/ce2eb9415f944d499a1bca1d968642db"
  "/navigation/e6460378857a4304925b5f9cb193abb6"
  "/navigation/feb7c08005854f24aae3f826866f4bca"
  "/navigation/3f627d737c6e4ef39510d5c48c9826ce"
  "/navigation/3442a9dcb0974ca2b2c583f95f27a726"
  "/navigation/bc8e03efeb3a4ce29fbe9c6e3670f63e"
  "/navigation/4b165da0d8844985a59da63f1b4e3f84"
  "/navigation/1e9a34ca47a44b1691cfbb9f9cf810ab"
  "/navigation/24b58e22956a451bb35c03f408b8e734"
  "/navigation/6034895a2cb2414e8f2806492b552f81"
  "/navigation/c01aae24743948ff8575c6564119d1a7"
  "/navigation/cb4488aca5f944de992141745ed7d5ea"
  "/navigation/e94b588d9e984840831ba7ee5732d985"
  "/navigation/fa063dc03f6c49fd961cdeb27d7f9e84"
  "/navigation/5c40ec9e663d4530befd90d2d8e0e1e0"
  "/navigation/0ad0bcfca0484e1ba4902159cd94a48a"
  "/navigation/66287d5f49c540489682662419d5a5c5"
  "/navigation/8da7298e4a5e444d8814c0660bd7c74b"
  "/navigation/af354350f3b040d5a2285588c02b578f"
  "/navigation/bafd463e1a634f808f67771822a21488"
  "/navigation/638f20327e1d4170a993f00e916db310"
  "/navigation/31469e44f0574616b465edaa8bf52cf2"
  "/navigation/e98163533c9249df83e0ffe1c8400e2b"
  "/navigation/66e8111fe82b4ebcad051db8bbbc8557"
  "/navigation/b87e2d68e18542c2abe301bacc36b129"
  "/navigation/e3e2a5edd79d41a5a4247a20d2e49654"
  "/navigation/ea8df079a710401e91ee6179c7739794"
  "/navigation/7b1bc70b87c5403e992e75a1d6bc6365"
  "/navigation/0c847ab52068437b8af10f05ebc8fbcf"
  "/navigation/1e627ac6c7a54826a067d1405085e218"
  "/navigation/22eb8fbea8f445679524675859106516"
  "/navigation/55ded434064947d9b792255b10f2c775"
  "/navigation/62606d03ad634754ba841cc0fc52971e"
  "/navigation/c37282c53455464f8149d621d781174e"
  "/navigation/fc0d4e6f4ef14e73b621dbb4c8dac2e1"
  "/navigation/fcbf0c805c6f4bb7ba8ed89b243dff5f"
  "/navigation/8057fb79c0e840caa4c68b76f8cb551b"
  "/navigation/d17762da78044ddd957264c0a03c4fda"
  "/navigation/8b722d0392ac4302b6be4101dc53c01f"
  "/navigation/41dd959f6a9645e9b1ffbe4e41e09cb7"
  "/navigation/588997cbc233468f8e544c61b0fab861"
  "/navigation/9254518f2d594eefbff1f743a9f72880"
  "/navigation/f6a4e914f4194ccba9f60886d4d79b40"
  "/navigation/8dcdb90e084242dd803d962bc403f98a"
  "/navigation/3f9df11839d343aa98e694e908ecd776"
  "/navigation/b8bbfba178864c50956a3343e737d9a1"
  "/navigation/8df975603d1f4506bd900c344bf2f5bd"
  "/navigation/716603a25ec84fda95579e3284a57649"
  "/navigation/80064a254a064c05bbc4cad7ed28e888"
  "/navigation/90cd023f0f574997a79e280d776c543c"
  "/navigation/54aec46f39cb47a2bb3ff232f379a394"
  "/navigation/e1bba466e209460cbc4923c0066ea6da"
  "/navigation/eaa723a758cd4d46b0cf634d18513bcf"
  "/navigation/a296ee1fe22d440781b8037581bb197e"
  "/navigation/0076c37d2e1d4c7cb92bbad09b095f04"
  "/navigation/75d90a6a25bc475582630a7f8a116591"
  "/navigation/7786423abc37418484337228d4b6c143"
  "/navigation/acc5a57af5ee46bbbd1ea16a8a12db76"
  "/navigation/2f007136eea047b68168e65a19b4487c"
  "/navigation/4de407f20f2244b78879c0eddf69602f"
  "/navigation/6cd520bb1c3e4232805dc6f24b874ac3"
  "/navigation/c028b35802114466b1a05ca6bfa46c27"
  "/navigation/c53e1d87a0444e91a1c13a612c42fccd"
  "/navigation/b70bdac520bb437792dab0f4a7b8a995"
  "/navigation/43cba25b0df443789529bdc7fd4db148"
  "/navigation/d4e10c355e6e4d26bc832c4a35cf0507"
  "/navigation/bec7ea5106d8464a9d094f91008c527c"
  "/navigation/4ac3956a8ed64c63a1b04c4667193726"
  "/navigation/c92789e0282d4a338e641301ce531ccc"
  "/navigation/17fc106ea92a4d04b760cd79ff35f386"
  "/navigation/2f2fa34990744fa2947f5d84d5bad42b"
  "/navigation/cf7a0e7b10d44258afc3e82b8f9a54d9"
  "/navigation/e7bc970467ea42cfafcc095bd3858df6"
  "/navigation/d1aeef4ae9c742bbb868335e36a5dee7"
  "/navigation/21a268c6aa9b4bf0a1c889a7473fcbf6"
  "/navigation/45c85ed034ce4e999a2a677c59231296"
  "/navigation/5f8060cd269142438c5f5652e0482e10"
  "/navigation/80c660407a6f4bc38e9ea5977263bd48"
  "/navigation/b5e8572ac2b0429ebc9f6d7e8fbc802c"
  "/navigation/e20d62c08ca94a4f87e7327966f6cee8"
  "/navigation/e74ae9f044bb462194adcce8f75cccf0"
  "/navigation/d2c69ee7241a46228ce1470efe59a752"
  "/navigation/4c1a26e80c164fbcbdbe3f4867b7d2c0"
  "/navigation/6d8a895de9e64700ad33b15ba1147f3e"
  "/navigation/6f3784018a80441689c615d15beaaa56"
  "/navigation/6faae91537e94cff984407538f7c9f8c"
  "/navigation/a83c27bd03784d6fa3184e30079ce3d3"
  "/navigation/b3c64b56a5cd40ce9a312185a78bc564"
  "/navigation/efffae5f3f614f329d24588681b91614"
  "/navigation/d81789bb9fe042f494424094a713bcbc"
  "/navigation/7e796d71f95d4299beae6afe0772ad49"
  "/navigation/e279d4c7a1144c95a8a9db3a22fd691e"
  "/navigation/31ca32f49a5e4585bae8413502be404f"
  "/navigation/3e557bc32f454d2c8ed8f6e80c4a6a54"
  "/navigation/c7e8fcc493df495783d4c41291717de9"
  "/navigation/d37ad61b71174331ab393437973ae17b"
  "/navigation/f34e048f1c974ea29f1e05785b6a37ff"
  "/navigation/eea6f1f33ab743269048544bb803bd81"
  "/navigation/becbd9f2b602494dbc73781d337d7472"
  "/navigation/f5395c35736a40d0a49b1a864e4c28f8"
  "/navigation/74b10e2dbe954b06a55b780f5246845d"
  "/navigation/f838f70ef8134a87b0e8836fc4ae57d7"
  "/navigation/1719a381652c479f99521fed450f96e8"
  "/navigation/2b33d8417b1c4482bc36647b4224270f"
  "/navigation/c719c7d2e5984e85b3e19fc728375efe"
  "/navigation/dc3ad880ab9b4f7dbbdad73ac92afa88"
  "/navigation/fbb6f70de8bb4ad7a4e672e96d8b4493"
  "/navigation/1727293ddda64d19b63927518ab2775c"
  "/navigation/20ca5295f2654cd79c377c9824f91a66"
  "/navigation/ba5e7e52754e4072b34437623d04bbd4"
  "/navigation/f858f386336b46d4a5b8867de8111773"
  "/navigation/fdb17e6e7efc4f109050180fb7dd7448"
  "/navigation/7a3c74ff118d4a57bd12cd8cf5c0cde5"
  "/navigation/cd265740e3094e419bbe9049830c32d0"
  "/navigation/dea139e85faf44c185fb01894698363a"
  "/navigation/dfe07be2f04c4c9bb3e1204560d515bf"
  "/navigation/e053a1ae15b04aff98fb40f8b06e4d7a"
  "/navigation/fe657cc91a3a46d182448d3936db790d"
  "/navigation/50ebda91b6f74888ad86753fd7422857"
  "/navigation/7a11f59949f040f19593d95e5aae98a7"
  "/navigation/8467a249b7a74cc887d0cb745941dfcd"
  "/navigation/b0812fa1e2ac4d0ca1d9be17bd73f06f"
  "/navigation/cec42cc0dc834c6dad3b7d4150334aa4"
  "/navigation/089c5bda910c4fbcb81489cdcdf36ce1"
  "/navigation/876b1a93fbe7414aa81b9910819bd92a"
  "/navigation/18a95e58878248b0b4fb9a3ce4a2a6e2"
  "/navigation/0d40d0f66fd1498ca510e64a333d0bab"
  "/navigation/38c0832f74414555aeda4310a6071dfd"
  "/navigation/40582cf5ab034b9f85cef0049853edd8"
  "/navigation/6c105c95f3e742e4a82c11f32324f8e4"
  "/navigation/b7b2c58d8a224e2fa7e81e407844b0ae"
  "/navigation/e04b8c45aa674756a25f5c4464c7b8db"
  "/navigation/f84d4ed51697473ea953db5aba0139f9"
  "/navigation/5f6c262422a14930b94b72734affdcf6"
  "/navigation/0f799e3b9e454997a46d5ac1c3174e35"
  "/navigation/18dde6613db14425b6318de0be6f0a32"
  "/navigation/fa0ae265e0064701a1c207e03679db57"
  "/navigation/64810cee960c47c8b81702b3df161e65"
  "/navigation/0064321529344f08bb279faf4b5f0005"
  "/navigation/0827bdce62234c459b0814076c30967b"
  "/navigation/5707daf186734800bf891e6b47d9811a"
  "/navigation/5c51f1265147406e8f8a706dda94b7e4"
  "/navigation/5fffd3702619458db0c1250ea9b3809c"
  "/navigation/711839a2c6c24b1b99b21e55a7853a77"
  "/navigation/7f6470faf268419785380c1e6006ca0c"
  "/navigation/8363c3ada91546c89c79625fd23363b7"
  "/navigation/9d0f6dd41d7b4180ae47d5d531c35455"
  "/navigation/e1e0d71f4d33459190ff397bd9b787c8"
  "/navigation/f72ddd71ff8f4e94900f06131a216df8"
  "/navigation/a859113e898940979eaad876595dc611"
  "/navigation/08854b6d955d49e5993e177ab2bfbbb7"
  "/navigation/c648cc7454144b3d9939f41a6f31b93b"
  "/navigation/cd47e8a3605048e8bf2fd157495d6ce6"
  "/navigation/b3f4cd7b8a404731b1357c66e7785c7c"
  "/navigation/8d6b43e406d24c9384998ae3b919b19c"
  "/navigation/93138a3e052542639a9df6697b530aa5"
  "/navigation/b48a4219d9d24da4a1a45a956df21d8e"
  "/navigation/b9761570f4854daa8603878f5ac7c760"
  "/navigation/c6631b6c53594c1298bd6c2b216f9903"
  "/navigation/c67f358c03774d0c864a4548650c3b2f"
  "/navigation/fbbf63907ac24aa7a9ab9d5fcc535cd0"
  "/navigation/05094b7cf80948bc9fca866ab51de423"
  "/navigation/1b730fde675a46d9ba06446bb7edd0f9"
  "/navigation/654caf828dc14d1ea4bff9582840baaa"
  "/navigation/72417b0e9eea4f1aa14e047063969538"
  "/navigation/75f272d6c5974720b84a383887830dd4"
  "/navigation/7ac91f668fbe492493e83a22d318c5c2"
  "/navigation/93630083c4f8406a9b11e0091457f03e"
  "/navigation/b9229c3cc4304c96b10d96dded289255"
  "/navigation/bf69050404e54d839b2de07041951381"
  "/navigation/d0cb4161992a49488e59d1bd1831bb41"
  "/navigation/e12b5494d36847fab33f3668281938c0"
  "/navigation/f0a35d03b7634401b4149876a287d616"
  "/navigation/fc390db4bc0a48aa997bb09787e251b4"
  "/navigation/fd1ea64d10ff4b8b841fa7c02284238d"
  "/account/recover"
  "/navigation/69a588b1c5c44492ab6129df1d56c09a"
  "/navigation/75b4bb00b2d6491582e34e375462c723"
  "/navigation/97d2c201750545f48b3edb835748aa0a"
  "/navigation/b0ac33e9e5924740a7e891358f15c82f"
  "/navigation/b4b435281582440d942cfec181b17604"
  "/navigation/809f910a1b0c40e787265d6e650279a1"
  "/navigation/1a969f2dcb234aa899b8d9fc3422edab"
  "/navigation/49c710df1e3543969f6d7fbbd4983b0c"
  "/navigation/5ace52e456064d5aaa29d6ef235baa33"
  "/navigation/77fbd596fb8a42c8ad26cd504315740c"
  "/navigation/bd20ef77334a4ed7afb0966c3fa5e750"
  "/navigation/c7fbddc5e7694cfabbe962261f8be641"
  "/navigation/042c9b061f9b445b812b0fe7b2915861"
  "/navigation/15f5d5b563ec4651a002d5f212a6eca5"
  "/navigation/188e919495184bc4858c7b7b4958cdde"
  "/navigation/351071518ac7427fa64a7326ab4d759a"
  "/navigation/6181f6ed58084c258d528a7d516a0f17"
  "/navigation/f006cb46f500407ba0d1331681357192"
  "/navigation/09bb659ad43a49c88f517ba41f45afb7"
  "/navigation/c19985caa80e4324a677577d830569d2"
  "/navigation/7c4911f5e2dd4ba5805fefc856ab86a5"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
6.97 ms
(6.60%)
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%"
  "%|b2f2d44613e14b4395b4e4e8e21ab6f3|%"
  5
  true
  true
]
4.16 ms
(3.94%)
9
# 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.91 ms
(3.70%)
9
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`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"9oiiôµD5ªx\x01n&\x1A„,"
]
3.05 ms
(2.89%)
1
# product-detail-route::read
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product.parent`.`cheapest_price` AS `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) AS `product.cheapestPrice`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.manufacturer`.`id` AS `product.manufacturer.id`, `product.manufacturer`.`version_id` AS `product.manufacturer.versionId`, `product.manufacturer`.`media_id` AS `product.manufacturer.mediaId`, `product.manufacturer`.`link` AS `product.manufacturer.link`, `product.manufacturer`.`created_at` AS `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` AS `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` AS `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` AS `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` AS `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` AS `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` AS `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` AS `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` AS `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` AS `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` AS `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` AS `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` AS `product.manufacturer.media.config`, `product.manufacturer.media`.`path` AS `product.manufacturer.media.path`, `product.manufacturer.media`.`private` AS `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` AS `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`created_at` AS `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` AS `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.title`,`product.manufacturer.media.translation.title`) AS `product.manufacturer.media.title`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.alt`,`product.manufacturer.media.translation.alt`) AS `product.manufacturer.media.alt`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.customFields`,`product.manufacturer.media.translation.customFields`) AS `product.manufacturer.media.customFields`, `product.manufacturer.media.translation.createdAt`, `product.manufacturer.media.translation.updatedAt`, `product.manufacturer.media.translation.mediaId`, `product.manufacturer.media.translation.languageId`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.name`,`product.manufacturer.translation.name`) AS `product.manufacturer.name`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.description`,`product.manufacturer.translation.description`) AS `product.manufacturer.description`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.customFields`,`product.manufacturer.translation.customFields`) AS `product.manufacturer.customFields`, `product.manufacturer.translation.createdAt`, `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation.languageId`, `product.manufacturer.translation.productManufacturerVersionId`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) AS `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_property` `product.properties.mapping`
                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) AS `product.properties.id_mapping`, `product.unit`.`id` AS `product.unit.id`, `product.unit`.`created_at` AS `product.unit.createdAt`, `product.unit`.`updated_at` AS `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) AS `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) AS `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) AS `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` AS `product.deliveryTime.id`, `product.deliveryTime`.`min` AS `product.deliveryTime.min`, `product.deliveryTime`.`max` AS `product.deliveryTime.max`, `product.deliveryTime`.`unit` AS `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` AS `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` AS `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) AS `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) AS `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` AS `product.cover.id`, `product.cover`.`version_id` AS `product.cover.versionId`, `product.cover`.`product_id` AS `product.cover.productId`, `product.cover`.`product_version_id` AS `product.cover.productVersionId`, `product.cover`.`media_id` AS `product.cover.mediaId`, `product.cover`.`position` AS `product.cover.position`, `product.cover.media`.`id` AS `product.cover.media.id`, `product.cover.media`.`user_id` AS `product.cover.media.userId`, `product.cover.media`.`media_folder_id` AS `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` AS `product.cover.media.mimeType`, `product.cover.media`.`file_extension` AS `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` AS `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` AS `product.cover.media.fileName`, `product.cover.media`.`file_size` AS `product.cover.media.fileSize`, `product.cover.media`.`media_type` AS `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` AS `product.cover.media.metaData`, `product.cover.media`.`config` AS `product.cover.media.config`, `product.cover.media`.`path` AS `product.cover.media.path`, `product.cover.media`.`private` AS `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` AS `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` AS `product.cover.media.createdAt`, `product.cover.media`.`updated_at` AS `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) AS `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) AS `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) AS `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` AS `product.cover.customFields`, `product.cover`.`created_at` AS `product.cover.createdAt`, `product.cover`.`updated_at` AS `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.manufacturer.translation`.product_manufacturer_id, `product.manufacturer.translation`.product_manufacturer_version_id, `product.manufacturer.translation`.name AS `product.manufacturer.translation.name`, `product.manufacturer.translation`.description AS `product.manufacturer.translation.description`, `product.manufacturer.translation`.custom_fields AS `product.manufacturer.translation.customFields`, `product.manufacturer.translation`.created_at AS `product.manufacturer.translation.createdAt`, `product.manufacturer.translation`.updated_at AS `product.manufacturer.translation.updatedAt`, `product.manufacturer.translation`.product_manufacturer_id AS `product.manufacturer.translation.productManufacturerId`, `product.manufacturer.translation`.language_id AS `product.manufacturer.translation.languageId`, `product.manufacturer.translation`.product_manufacturer_version_id AS `product.manufacturer.translation.productManufacturerVersionId` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.language_id = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.product_manufacturer_version_id = `product.manufacturer`.version_id LEFT JOIN `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.media_id, `product.manufacturer.media.translation`.title AS `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation`.alt AS `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation`.custom_fields AS `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation`.created_at AS `product.manufacturer.media.translation.createdAt`, `product.manufacturer.media.translation`.updated_at AS `product.manufacturer.media.translation.updatedAt`, `product.manufacturer.media.translation`.media_id AS `product.manufacturer.media.translation.mediaId`, `product.manufacturer.media.translation`.language_id AS `product.manufacturer.media.translation.languageId` FROM `media_translation` `product.manufacturer.media.translation` WHERE `product.manufacturer.media.translation`.language_id = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code AS `product.unit.translation.shortCode`, `product.unit.translation`.name AS `product.unit.translation.name`, `product.unit.translation`.custom_fields AS `product.unit.translation.customFields`, `product.unit.translation`.created_at AS `product.unit.translation.createdAt`, `product.unit.translation`.updated_at AS `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id AS `product.unit.translation.unitId`, `product.unit.translation`.language_id AS `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name AS `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields AS `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at AS `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at AS `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id AS `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id AS `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title AS `product.cover.media.translation.title`, `product.cover.media.translation`.alt AS `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields AS `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at AS `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at AS `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id AS `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id AS `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
]
3.01 ms
(2.85%)
9
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.33 ms
(2.21%)
1
SELECT `product`.`id` AS `product.id`, `product`.`version_id` AS `product.versionId`, `product`.`parent_id` AS `product.parentId`, `product`.`parent_version_id` AS `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) AS `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) AS `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) AS `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) AS `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) AS `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) AS `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) AS `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) AS `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) AS `product.canonicalProductId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) AS `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) AS `product.cmsPageVersionId`, `product.parent`.`price` AS `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) AS `product.price`, `product`.`product_number` AS `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) AS `product.restockTime`, `product`.`auto_increment` AS `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) AS `product.active`, `product`.`available` AS `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) AS `product.isCloseout`, `product`.`display_group` AS `product.displayGroup`, `product.parent`.`variant_listing_config` AS `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) AS `product.variantListingConfig`, `product`.`variant_restrictions` AS `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) AS `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) AS `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) AS `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) AS `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) AS `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) AS `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) AS `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) AS `product.shippingFree`, `product.parent`.`purchase_prices` AS `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) AS `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) AS `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) AS `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) AS `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) AS `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) AS `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) AS `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) AS `product.ratingAverage`, `product.parent`.`category_tree` AS `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) AS `product.categoryTree`, `product.parent`.`property_ids` AS `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) AS `product.propertyIds`, `product.parent`.`option_ids` AS `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) AS `product.optionIds`, `product.parent`.`stream_ids` AS `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) AS `product.streamIds`, `product.parent`.`tag_ids` AS `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) AS `product.tagIds`, `product.parent`.`category_ids` AS `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) AS `product.categoryIds`, `product`.`child_count` AS `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) AS `product.customFieldSetSelectionActive`, `product`.`sales` AS `product.sales`, `product`.`states` AS `product.states`, `product.tax`.`id` AS `product.tax.id`, `product.tax`.`tax_rate` AS `product.tax.taxRate`, `product.tax`.`name` AS `product.tax.name`, `product.tax`.`position` AS `product.tax.position`, `product.tax`.`custom_fields` AS `product.tax.customFields`, `product.tax`.`created_at` AS `product.tax.createdAt`, `product.tax`.`updated_at` AS `product.tax.updatedAt`, `product`.`available_stock` AS `product.availableStock`, `product`.`stock` AS `product.stock`, `product.parent`.`cheapest_price` AS `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) AS `product.cheapestPrice`, `product`.`created_at` AS `product.createdAt`, `product`.`updated_at` AS `product.updatedAt`, `product.unit`.`id` AS `product.unit.id`, `product.unit`.`created_at` AS `product.unit.createdAt`, `product.unit`.`updated_at` AS `product.unit.updatedAt`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.shortCode`,`product.unit.translation.shortCode`) AS `product.unit.shortCode`, `product.unit.translation.name`, COALESCE(`product.unit.translation.name`,`product.unit.translation.name`) AS `product.unit.name`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.customFields`,`product.unit.translation.customFields`) AS `product.unit.customFields`, `product.unit.translation.createdAt`, `product.unit.translation.updatedAt`, `product.unit.translation.unitId`, `product.unit.translation.languageId`, `product.deliveryTime`.`id` AS `product.deliveryTime.id`, `product.deliveryTime`.`min` AS `product.deliveryTime.min`, `product.deliveryTime`.`max` AS `product.deliveryTime.max`, `product.deliveryTime`.`unit` AS `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` AS `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` AS `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.name`,`product.deliveryTime.translation.name`) AS `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.customFields`,`product.deliveryTime.translation.customFields`) AS `product.deliveryTime.customFields`, `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation.languageId`, `product.cover`.`id` AS `product.cover.id`, `product.cover`.`version_id` AS `product.cover.versionId`, `product.cover`.`product_id` AS `product.cover.productId`, `product.cover`.`product_version_id` AS `product.cover.productVersionId`, `product.cover`.`media_id` AS `product.cover.mediaId`, `product.cover`.`position` AS `product.cover.position`, `product.cover.media`.`id` AS `product.cover.media.id`, `product.cover.media`.`user_id` AS `product.cover.media.userId`, `product.cover.media`.`media_folder_id` AS `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` AS `product.cover.media.mimeType`, `product.cover.media`.`file_extension` AS `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` AS `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` AS `product.cover.media.fileName`, `product.cover.media`.`file_size` AS `product.cover.media.fileSize`, `product.cover.media`.`media_type` AS `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` AS `product.cover.media.metaData`, `product.cover.media`.`config` AS `product.cover.media.config`, `product.cover.media`.`path` AS `product.cover.media.path`, `product.cover.media`.`private` AS `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` AS `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` AS `product.cover.media.createdAt`, `product.cover.media`.`updated_at` AS `product.cover.media.updatedAt`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.title`,`product.cover.media.translation.title`) AS `product.cover.media.title`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.alt`,`product.cover.media.translation.alt`) AS `product.cover.media.alt`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.customFields`,`product.cover.media.translation.customFields`) AS `product.cover.media.customFields`, `product.cover.media.translation.createdAt`, `product.cover.media.translation.updatedAt`, `product.cover.media.translation.mediaId`, `product.cover.media.translation.languageId`, `product.cover`.`custom_fields` AS `product.cover.customFields`, `product.cover`.`created_at` AS `product.cover.createdAt`, `product.cover`.`updated_at` AS `product.cover.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`,`product.translation.metaDescription`) AS `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`,`product.translation.name`) AS `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`,`product.translation.keywords`) AS `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`,`product.translation.description`) AS `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`,`product.translation.metaTitle`) AS `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`,`product.translation.packUnit`) AS `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`,`product.translation.packUnitPlural`) AS `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`,`product.translation.customSearchKeywords`) AS `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`,`product.translation.slotConfig`) AS `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`,`product.translation.customFields`) AS `product.customFields`, `product.translation.createdAt`, `product.parent.translation.createdAt`, `product.translation.updatedAt`, `product.parent.translation.updatedAt`, `product.translation.productId`, `product.parent.translation.productId`, `product.translation.languageId`, `product.parent.translation.languageId`, `product.translation.productVersionId`, `product.parent.translation.productVersionId` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN (SELECT `product.translation`.product_id, `product.translation`.product_version_id, `product.translation`.meta_description AS `product.translation.metaDescription`, `product.translation`.name AS `product.translation.name`, `product.translation`.keywords AS `product.translation.keywords`, `product.translation`.description AS `product.translation.description`, `product.translation`.meta_title AS `product.translation.metaTitle`, `product.translation`.pack_unit AS `product.translation.packUnit`, `product.translation`.pack_unit_plural AS `product.translation.packUnitPlural`, `product.translation`.custom_search_keywords AS `product.translation.customSearchKeywords`, `product.translation`.slot_config AS `product.translation.slotConfig`, `product.translation`.custom_fields AS `product.translation.customFields`, `product.translation`.created_at AS `product.translation.createdAt`, `product.translation`.updated_at AS `product.translation.updatedAt`, `product.translation`.product_id AS `product.translation.productId`, `product.translation`.language_id AS `product.translation.languageId`, `product.translation`.product_version_id AS `product.translation.productVersionId` FROM `product_translation` `product.translation` WHERE `product.translation`.language_id = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.product_version_id = `product`.version_id LEFT JOIN (SELECT `product.parent.translation`.product_id, `product.parent.translation`.product_version_id, `product.parent.translation`.meta_description AS `product.parent.translation.metaDescription`, `product.parent.translation`.name AS `product.parent.translation.name`, `product.parent.translation`.keywords AS `product.parent.translation.keywords`, `product.parent.translation`.description AS `product.parent.translation.description`, `product.parent.translation`.meta_title AS `product.parent.translation.metaTitle`, `product.parent.translation`.pack_unit AS `product.parent.translation.packUnit`, `product.parent.translation`.pack_unit_plural AS `product.parent.translation.packUnitPlural`, `product.parent.translation`.custom_search_keywords AS `product.parent.translation.customSearchKeywords`, `product.parent.translation`.slot_config AS `product.parent.translation.slotConfig`, `product.parent.translation`.custom_fields AS `product.parent.translation.customFields`, `product.parent.translation`.created_at AS `product.parent.translation.createdAt`, `product.parent.translation`.updated_at AS `product.parent.translation.updatedAt`, `product.parent.translation`.product_id AS `product.parent.translation.productId`, `product.parent.translation`.language_id AS `product.parent.translation.languageId`, `product.parent.translation`.product_version_id AS `product.parent.translation.productVersionId` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.language_id = ?) `product.product_translation.parent` ON `product.product_translation.parent`.`product_id` = `product.parent`.`id` AND `product.product_translation.parent`.product_version_id = `product.parent`.version_id LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.unit_id, `product.unit.translation`.short_code AS `product.unit.translation.shortCode`, `product.unit.translation`.name AS `product.unit.translation.name`, `product.unit.translation`.custom_fields AS `product.unit.translation.customFields`, `product.unit.translation`.created_at AS `product.unit.translation.createdAt`, `product.unit.translation`.updated_at AS `product.unit.translation.updatedAt`, `product.unit.translation`.unit_id AS `product.unit.translation.unitId`, `product.unit.translation`.language_id AS `product.unit.translation.languageId` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.language_id = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.delivery_time_id, `product.deliveryTime.translation`.name AS `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.custom_fields AS `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation`.created_at AS `product.deliveryTime.translation.createdAt`, `product.deliveryTime.translation`.updated_at AS `product.deliveryTime.translation.updatedAt`, `product.deliveryTime.translation`.delivery_time_id AS `product.deliveryTime.translation.deliveryTimeId`, `product.deliveryTime.translation`.language_id AS `product.deliveryTime.translation.languageId` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.language_id = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.media_id, `product.cover.media.translation`.title AS `product.cover.media.translation.title`, `product.cover.media.translation`.alt AS `product.cover.media.translation.alt`, `product.cover.media.translation`.custom_fields AS `product.cover.media.translation.customFields`, `product.cover.media.translation`.created_at AS `product.cover.media.translation.createdAt`, `product.cover.media.translation`.updated_at AS `product.cover.media.translation.updatedAt`, `product.cover.media.translation`.media_id AS `product.cover.media.translation.mediaId`, `product.cover.media.translation`.language_id AS `product.cover.media.translation.languageId` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.language_id = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
]
2.11 ms
(2.00%)
16
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  "SxmaTAKrVLYLIrwwNAfIwD4yvM2c4SKo"
]
1.79 ms
(1.69%)
9
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:
[]
1.69 ms
(1.60%)
2
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
  "payload"
]
1.62 ms
(1.53%)
1
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  true
  b"\x08µE I9´²äuÂÆ+e"
]
1.56 ms
(1.48%)
1
# product-detail-route::association::properties::read
SELECT `property_group_option`.`id` AS `property_group_option.id`, `property_group_option`.`property_group_id` AS `property_group_option.groupId`, `property_group_option`.`color_hex_code` AS `property_group_option.colorHexCode`, `property_group_option`.`media_id` AS `property_group_option.mediaId`, `property_group_option`.`created_at` AS `property_group_option.createdAt`, `property_group_option`.`updated_at` AS `property_group_option.updatedAt`, `property_group_option.group`.`id` AS `property_group_option.group.id`, `property_group_option.group`.`display_type` AS `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` AS `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` AS `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` AS `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` AS `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` AS `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, COALESCE(`property_group_option.group.translation.name`,`property_group_option.group.translation.name`) AS `property_group_option.group.name`, `property_group_option.group.translation.description`, COALESCE(`property_group_option.group.translation.description`,`property_group_option.group.translation.description`) AS `property_group_option.group.description`, `property_group_option.group.translation.position`, COALESCE(`property_group_option.group.translation.position`,`property_group_option.group.translation.position`) AS `property_group_option.group.position`, `property_group_option.group.translation.customFields`, COALESCE(`property_group_option.group.translation.customFields`,`property_group_option.group.translation.customFields`) AS `property_group_option.group.customFields`, `property_group_option.group.translation.createdAt`, `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation.languageId`, `property_group_option.translation.name`, COALESCE(`property_group_option.translation.name`,`property_group_option.translation.name`) AS `property_group_option.name`, `property_group_option.translation.position`, COALESCE(`property_group_option.translation.position`,`property_group_option.translation.position`) AS `property_group_option.position`, `property_group_option.translation.customFields`, COALESCE(`property_group_option.translation.customFields`,`property_group_option.translation.customFields`) AS `property_group_option.customFields`, `property_group_option.translation.createdAt`, `property_group_option.translation.updatedAt`, `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation.languageId` FROM `property_group_option` LEFT JOIN (SELECT `property_group_option.translation`.property_group_option_id, `property_group_option.translation`.name AS `property_group_option.translation.name`, `property_group_option.translation`.position AS `property_group_option.translation.position`, `property_group_option.translation`.custom_fields AS `property_group_option.translation.customFields`, `property_group_option.translation`.created_at AS `property_group_option.translation.createdAt`, `property_group_option.translation`.updated_at AS `property_group_option.translation.updatedAt`, `property_group_option.translation`.property_group_option_id AS `property_group_option.translation.propertyGroupOptionId`, `property_group_option.translation`.language_id AS `property_group_option.translation.languageId` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.language_id = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` LEFT JOIN (SELECT `property_group_option.group.translation`.property_group_id, `property_group_option.group.translation`.name AS `property_group_option.group.translation.name`, `property_group_option.group.translation`.description AS `property_group_option.group.translation.description`, `property_group_option.group.translation`.position AS `property_group_option.group.translation.position`, `property_group_option.group.translation`.custom_fields AS `property_group_option.group.translation.customFields`, `property_group_option.group.translation`.created_at AS `property_group_option.group.translation.createdAt`, `property_group_option.group.translation`.updated_at AS `property_group_option.group.translation.updatedAt`, `property_group_option.group.translation`.property_group_id AS `property_group_option.group.translation.propertyGroupId`, `property_group_option.group.translation`.language_id AS `property_group_option.group.translation.languageId` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.language_id = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` WHERE `property_group_option`.`id` IN (?, ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"lqmn½\x16Gí¼\eWÍwzÍ\x10"
  b"Œì»ú\x06<O\v\x19º\x16Ù(Á{"
]
1.49 ms
(1.41%)
9
SELECT `script`.`id` AS `script.id`, `script`.`script` AS `script.script`, `script`.`hook` AS `script.hook`, `script`.`name` AS `script.name`, `script`.`active` AS `script.active`, `script`.`app_id` AS `script.appId`, `script`.`created_at` AS `script.createdAt`, `script`.`updated_at` AS `script.updatedAt` FROM `script` WHERE (`script`.`app_id` IN (?))
Parameters:
[
  b"9oiiôµD5ªx\x01n&\x1A„,"
]
1.45 ms
(1.38%)
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.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `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` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `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` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"²òÔF\x13áKC•´äèâ\x1A¶ó"
]
1.32 ms
(1.25%)
3
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `parent_id` = ? OR `id` = ?
Parameters:
[
  b"²òÔF\x13áKC•´äèâ\x1A¶ó"
  b"²òÔF\x13áKC•´äèâ\x1A¶ó"
  b"²òÔF\x13áKC•´äèâ\x1A¶ó"
]
1.32 ms
(1.24%)
8
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters:
[]
1.24 ms
(1.18%)
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.typeName`, COALESCE(`tax_rule.type.translation.typeName`,`tax_rule.type.translation.typeName`) AS `tax_rule.type.typeName`, `tax_rule.type.translation.createdAt`, `tax_rule.type.translation.updatedAt`, `tax_rule.type.translation.taxRuleTypeId`, `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` FROM `tax_rule_type_translation` `tax_rule.type.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b")²YÜÃÙN6ö¨)Å\x18Ìå┼"
  b"ˆ¶Y\x07JœFÈ–™s\x05\x7F("
  b"žûBµïzK˜žr\x1DÖÊ~y‚"
  b"ªÇ\x1D(•èI¢Œ\x06KÙNhz-"
  b"Õh\x1C6œ‹L§º¢'¤‚jx\x06"
  b"زäÄ;\tOù‚\x1A\x1C²z¤Qk"
]
1.23 ms
(1.17%)
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.title`, COALESCE(`media.translation.title`,`media.translation.title`) AS `media.title`, `media.translation.alt`, COALESCE(`media.translation.alt`,`media.translation.alt`) AS `media.alt`, `media.translation.customFields`, COALESCE(`media.translation.customFields`,`media.translation.customFields`) AS `media.customFields`, `media.translation.createdAt`, `media.translation.updatedAt`, `media.translation.mediaId`, `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` FROM `media_translation` `media.translation` WHERE `media.translation`.language_id = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b"_H\e¡â«HÃŽ«"‹…—Âo"
  b"\x01ŽŸfâ¦q‹¸[àS½à“R"
]
1.11 ms
(1.05%)
1
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND (seo_path_info = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  "Leibniz-Schokoriegel-PiCK-UP-CHOCO-2-x-28-g-Pack./GRATIS-492030000"
]
0.93 ms
(0.88%)
1
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters:
[]
0.84 ms
(0.80%)
1
# product-detail-route::find-best-variant::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((`product`.`parent_id` = ? AND ((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) ORDER BY IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) AS DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC, `product`.`available` DESC LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
  10
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  true
]
0.80 ms
(0.76%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.77 ms
(0.73%)
1
# breadcrumb-extension::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `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` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"­Ãèò\x12%K\x17­o+\x12Ûê&ð"
  b"\x1D»‹SAÞ–á“E&æ\x02i"
  b"5r\x06\x1E\x1AaK½¥ò╦P¨É=©"
]
0.72 ms
(0.68%)
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.title`, COALESCE(`category.media.translation.title`,`category.media.translation.title`) AS `category.media.title`, `category.media.translation.alt`, COALESCE(`category.media.translation.alt`,`category.media.translation.alt`) AS `category.media.alt`, `category.media.translation.customFields`, COALESCE(`category.media.translation.customFields`,`category.media.translation.customFields`) AS `category.media.customFields`, `category.media.translation.createdAt`, `category.media.translation.updatedAt`, `category.media.translation.mediaId`, `category.media.translation.languageId`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `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` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id LEFT JOIN `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` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.language_id = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"5r\x06\x1E\x1AaK½¥ò╦P¨É=©"
  b""œs÷6?Fν\e-c%Ž,w"
]
0.67 ms
(0.64%)
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.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `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.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `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` FROM `shipping_method_translation` `shipping_method.translation` 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` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` 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` FROM `media_translation` `shipping_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┼è┴L\$E│É"5PçhÝ¡"
]
0.67 ms
(0.63%)
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.shortName`, COALESCE(`sales_channel.currency.translation.shortName`,`sales_channel.currency.translation.shortName`) AS `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, COALESCE(`sales_channel.currency.translation.name`,`sales_channel.currency.translation.name`) AS `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, COALESCE(`sales_channel.currency.translation.customFields`,`sales_channel.currency.translation.customFields`) AS `sales_channel.currency.customFields`, `sales_channel.currency.translation.createdAt`, `sales_channel.currency.translation.updatedAt`, `sales_channel.currency.translation.currencyId`, `sales_channel.currency.translation.languageId`, `sales_channel.translation.name`, COALESCE(`sales_channel.translation.name`,`sales_channel.translation.name`) AS `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, COALESCE(`sales_channel.translation.homeSlotConfig`,`sales_channel.translation.homeSlotConfig`) AS `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, COALESCE(`sales_channel.translation.homeEnabled`,`sales_channel.translation.homeEnabled`) AS `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, COALESCE(`sales_channel.translation.homeName`,`sales_channel.translation.homeName`) AS `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, COALESCE(`sales_channel.translation.homeMetaTitle`,`sales_channel.translation.homeMetaTitle`) AS `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, COALESCE(`sales_channel.translation.homeMetaDescription`,`sales_channel.translation.homeMetaDescription`) AS `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, COALESCE(`sales_channel.translation.homeKeywords`,`sales_channel.translation.homeKeywords`) AS `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, COALESCE(`sales_channel.translation.customFields`,`sales_channel.translation.customFields`) AS `sales_channel.customFields`, `sales_channel.translation.createdAt`, `sales_channel.translation.updatedAt`, `sales_channel.translation.salesChannelId`, `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` FROM `sales_channel_translation` `sales_channel.translation` 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` FROM `currency_translation` `sales_channel.currency.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.66 ms
(0.63%)
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.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `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` FROM `payment_method_translation` `payment_method.translation` 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` FROM `media_translation` `payment_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x12eVgù'E>Øt¢³\x1CFÎ╠"
  b""‘\x1D_\x04¤FT¨n\x1EC\x05\x13©\"
  b"Ál'Hë\x18L\x08Ž|ïXU†ï\e"
  b"""
    \n
    1•kB¨ºá\x01æÖ¶\x06\x18
    """
]
0.66 ms
(0.62%)
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.name`, COALESCE(`shipping_method.deliveryTime.translation.name`,`shipping_method.deliveryTime.translation.name`) AS `shipping_method.deliveryTime.name`, `shipping_method.deliveryTime.translation.customFields`, COALESCE(`shipping_method.deliveryTime.translation.customFields`,`shipping_method.deliveryTime.translation.customFields`) AS `shipping_method.deliveryTime.customFields`, `shipping_method.deliveryTime.translation.createdAt`, `shipping_method.deliveryTime.translation.updatedAt`, `shipping_method.deliveryTime.translation.deliveryTimeId`, `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.title`, COALESCE(`shipping_method.media.translation.title`,`shipping_method.media.translation.title`) AS `shipping_method.media.title`, `shipping_method.media.translation.alt`, COALESCE(`shipping_method.media.translation.alt`,`shipping_method.media.translation.alt`) AS `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, COALESCE(`shipping_method.media.translation.customFields`,`shipping_method.media.translation.customFields`) AS `shipping_method.media.customFields`, `shipping_method.media.translation.createdAt`, `shipping_method.media.translation.updatedAt`, `shipping_method.media.translation.mediaId`, `shipping_method.media.translation.languageId`, `shipping_method.translation.name`, COALESCE(`shipping_method.translation.name`,`shipping_method.translation.name`) AS `shipping_method.name`, `shipping_method.translation.description`, COALESCE(`shipping_method.translation.description`,`shipping_method.translation.description`) AS `shipping_method.description`, `shipping_method.translation.trackingUrl`, COALESCE(`shipping_method.translation.trackingUrl`,`shipping_method.translation.trackingUrl`) AS `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, COALESCE(`shipping_method.translation.customFields`,`shipping_method.translation.customFields`) AS `shipping_method.customFields`, `shipping_method.translation.createdAt`, `shipping_method.translation.updatedAt`, `shipping_method.translation.shippingMethodId`, `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` FROM `shipping_method_translation` `shipping_method.translation` 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` FROM `delivery_time_translation` `shipping_method.deliveryTime.translation` 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` FROM `media_translation` `shipping_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"┼è┴L\$E│É"5PçhÝ¡"
]
0.63 ms
(0.59%)
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.title`, COALESCE(`payment_method.media.translation.title`,`payment_method.media.translation.title`) AS `payment_method.media.title`, `payment_method.media.translation.alt`, COALESCE(`payment_method.media.translation.alt`,`payment_method.media.translation.alt`) AS `payment_method.media.alt`, `payment_method.media.translation.customFields`, COALESCE(`payment_method.media.translation.customFields`,`payment_method.media.translation.customFields`) AS `payment_method.media.customFields`, `payment_method.media.translation.createdAt`, `payment_method.media.translation.updatedAt`, `payment_method.media.translation.mediaId`, `payment_method.media.translation.languageId`, `payment_method.translation.name`, COALESCE(`payment_method.translation.name`,`payment_method.translation.name`) AS `payment_method.name`, `payment_method.translation.distinguishableName`, COALESCE(`payment_method.translation.distinguishableName`,`payment_method.translation.distinguishableName`) AS `payment_method.distinguishableName`, `payment_method.translation.description`, COALESCE(`payment_method.translation.description`,`payment_method.translation.description`) AS `payment_method.description`, `payment_method.translation.customFields`, COALESCE(`payment_method.translation.customFields`,`payment_method.translation.customFields`) AS `payment_method.customFields`, `payment_method.translation.createdAt`, `payment_method.translation.updatedAt`, `payment_method.translation.paymentMethodId`, `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` FROM `payment_method_translation` `payment_method.translation` 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` FROM `media_translation` `payment_method.media.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"""
    \n
    1•kB¨ºá\x01æÖ¶\x06\x18
    """
]
0.62 ms
(0.59%)
1
# product-detail-route::association::media::read
SELECT `product_media`.`id` AS `product_media.id`, `product_media`.`version_id` AS `product_media.versionId`, `product_media`.`product_id` AS `product_media.productId`, `product_media`.`product_version_id` AS `product_media.productVersionId`, `product_media`.`media_id` AS `product_media.mediaId`, `product_media`.`position` AS `product_media.position`, `product_media.media`.`id` AS `product_media.media.id`, `product_media.media`.`user_id` AS `product_media.media.userId`, `product_media.media`.`media_folder_id` AS `product_media.media.mediaFolderId`, `product_media.media`.`mime_type` AS `product_media.media.mimeType`, `product_media.media`.`file_extension` AS `product_media.media.fileExtension`, `product_media.media`.`uploaded_at` AS `product_media.media.uploadedAt`, `product_media.media`.`file_name` AS `product_media.media.fileName`, `product_media.media`.`file_size` AS `product_media.media.fileSize`, `product_media.media`.`media_type` AS `product_media.media.mediaTypeRaw`, `product_media.media`.`meta_data` AS `product_media.media.metaData`, `product_media.media`.`config` AS `product_media.media.config`, `product_media.media`.`path` AS `product_media.media.path`, `product_media.media`.`private` AS `product_media.media.private`, `product_media.media`.`thumbnails_ro` AS `product_media.media.thumbnailsRo`, `product_media.media`.`created_at` AS `product_media.media.createdAt`, `product_media.media`.`updated_at` AS `product_media.media.updatedAt`, `product_media.media.translation.title`, COALESCE(`product_media.media.translation.title`,`product_media.media.translation.title`) AS `product_media.media.title`, `product_media.media.translation.alt`, COALESCE(`product_media.media.translation.alt`,`product_media.media.translation.alt`) AS `product_media.media.alt`, `product_media.media.translation.customFields`, COALESCE(`product_media.media.translation.customFields`,`product_media.media.translation.customFields`) AS `product_media.media.customFields`, `product_media.media.translation.createdAt`, `product_media.media.translation.updatedAt`, `product_media.media.translation.mediaId`, `product_media.media.translation.languageId`, `product_media`.`custom_fields` AS `product_media.customFields`, `product_media`.`created_at` AS `product_media.createdAt`, `product_media`.`updated_at` AS `product_media.updatedAt` FROM `product_media` LEFT JOIN `media` `product_media.media` ON `product_media`.`media_id` = `product_media.media`.`id` LEFT JOIN (SELECT `product_media.media.translation`.media_id, `product_media.media.translation`.title AS `product_media.media.translation.title`, `product_media.media.translation`.alt AS `product_media.media.translation.alt`, `product_media.media.translation`.custom_fields AS `product_media.media.translation.customFields`, `product_media.media.translation`.created_at AS `product_media.media.translation.createdAt`, `product_media.media.translation`.updated_at AS `product_media.media.translation.updatedAt`, `product_media.media.translation`.media_id AS `product_media.media.translation.mediaId`, `product_media.media.translation`.language_id AS `product_media.media.translation.languageId` FROM `media_translation` `product_media.media.translation` WHERE `product_media.media.translation`.language_id = ?) `product_media.media.media_translation` ON `product_media.media.media_translation`.`media_id` = `product_media.media`.`id` WHERE (`product_media`.`version_id` = ?) AND ((`product_media`.`product_id` IN (?)))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
]
0.62 ms
(0.59%)
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.50 ms
(0.48%)
1
# product-review-route::aggregation::customer-login-filter
SELECT `product_review`.`points` AS `ratingMatrix.key`, COUNT(`product_review`.`id`) AS `ratingMatrix.count` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE ((((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) AND (((`product_review`.`status` = ?))) GROUP BY `product_review`.`points`
Parameters:
[
  true
  b"\x08µE I9´²äuÂÆ+e"
  b"\x08µE I9´²äuÂÆ+e"
  true
]
0.49 ms
(0.46%)
1
SELECT `product_price`.`id` AS `product_price.id`, `product_price`.`version_id` AS `product_price.versionId`, `product_price`.`product_id` AS `product_price.productId`, `product_price`.`product_version_id` AS `product_price.productVersionId`, `product_price`.`rule_id` AS `product_price.ruleId`, `product_price`.`price` AS `product_price.price`, `product_price`.`quantity_start` AS `product_price.quantityStart`, `product_price`.`quantity_end` AS `product_price.quantityEnd`, `product_price`.`custom_fields` AS `product_price.customFields`, `product_price`.`created_at` AS `product_price.createdAt`, `product_price`.`updated_at` AS `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?)))
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
]
0.49 ms
(0.46%)
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.name`, COALESCE(`language.translationCode.translation.name`,`language.translationCode.translation.name`) AS `language.translationCode.name`, `language.translationCode.translation.territory`, COALESCE(`language.translationCode.translation.territory`,`language.translationCode.translation.territory`) AS `language.translationCode.territory`, `language.translationCode.translation.customFields`, COALESCE(`language.translationCode.translation.customFields`,`language.translationCode.translation.customFields`) AS `language.translationCode.customFields`, `language.translationCode.translation.createdAt`, `language.translationCode.translation.updatedAt`, `language.translationCode.translation.localeId`, `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` FROM `locale_translation` `language.translationCode.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"s1'E̓DѼ´5§Fˆx#"
]
0.49 ms
(0.46%)
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` FROM `shipping_method_translation` `shipping_method.translation` 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.name`)) ASC
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.48 ms
(0.46%)
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.description`, COALESCE(`theme.translation.description`,`theme.translation.description`) AS `theme.description`, `theme.translation.labels`, COALESCE(`theme.translation.labels`,`theme.translation.labels`) AS `theme.labels`, `theme.translation.helpTexts`, COALESCE(`theme.translation.helpTexts`,`theme.translation.helpTexts`) AS `theme.helpTexts`, `theme.translation.customFields`, COALESCE(`theme.translation.customFields`,`theme.translation.customFields`) AS `theme.customFields`, `theme.translation.createdAt`, `theme.translation.updatedAt`, `theme.translation.themeId`, `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` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.language_id = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.48 ms
(0.45%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.46 ms
(0.44%)
1
# product-detail-route::association::mainCategories::read
SELECT `main_category`.`id` AS `main_category.id`, `main_category`.`product_id` AS `main_category.productId`, `main_category`.`product_version_id` AS `main_category.productVersionId`, `main_category`.`category_id` AS `main_category.categoryId`, `main_category`.`category_version_id` AS `main_category.categoryVersionId`, `main_category`.`sales_channel_id` AS `main_category.salesChannelId`, `main_category`.`created_at` AS `main_category.createdAt`, `main_category`.`updated_at` AS `main_category.updatedAt`, `main_category.category`.`id` AS `main_category.category.id`, `main_category.category`.`version_id` AS `main_category.category.versionId`, `main_category.category`.`parent_id` AS `main_category.category.parentId`, `main_category.category`.`parent_version_id` AS `main_category.category.parentVersionId`, `main_category.category`.`after_category_id` AS `main_category.category.afterCategoryId`, `main_category.category`.`after_category_version_id` AS `main_category.category.afterCategoryVersionId`, `main_category.category`.`media_id` AS `main_category.category.mediaId`, `main_category.category`.`display_nested_products` AS `main_category.category.displayNestedProducts`, `main_category.category`.`auto_increment` AS `main_category.category.autoIncrement`, `main_category.category`.`level` AS `main_category.category.level`, `main_category.category`.`path` AS `main_category.category.path`, `main_category.category`.`child_count` AS `main_category.category.childCount`, `main_category.category`.`type` AS `main_category.category.type`, `main_category.category`.`product_assignment_type` AS `main_category.category.productAssignmentType`, `main_category.category`.`visible` AS `main_category.category.visible`, `main_category.category`.`active` AS `main_category.category.active`, `main_category.category`.`cms_page_id` AS `main_category.category.cmsPageId`, `main_category.category`.`cms_page_version_id` AS `main_category.category.cmsPageVersionId`, `main_category.category`.`product_stream_id` AS `main_category.category.productStreamId`, `main_category.category`.`custom_entity_type_id` AS `main_category.category.customEntityTypeId`, `main_category.category`.`created_at` AS `main_category.category.createdAt`, `main_category.category`.`updated_at` AS `main_category.category.updatedAt`, `main_category.category.translation.name`, COALESCE(`main_category.category.translation.name`,`main_category.category.translation.name`) AS `main_category.category.name`, `main_category.category.translation.breadcrumb`, COALESCE(`main_category.category.translation.breadcrumb`,`main_category.category.translation.breadcrumb`) AS `main_category.category.breadcrumb`, `main_category.category.translation.slotConfig`, COALESCE(`main_category.category.translation.slotConfig`,`main_category.category.translation.slotConfig`) AS `main_category.category.slotConfig`, `main_category.category.translation.linkType`, COALESCE(`main_category.category.translation.linkType`,`main_category.category.translation.linkType`) AS `main_category.category.linkType`, `main_category.category.translation.internalLink`, COALESCE(`main_category.category.translation.internalLink`,`main_category.category.translation.internalLink`) AS `main_category.category.internalLink`, `main_category.category.translation.externalLink`, COALESCE(`main_category.category.translation.externalLink`,`main_category.category.translation.externalLink`) AS `main_category.category.externalLink`, `main_category.category.translation.linkNewTab`, COALESCE(`main_category.category.translation.linkNewTab`,`main_category.category.translation.linkNewTab`) AS `main_category.category.linkNewTab`, `main_category.category.translation.description`, COALESCE(`main_category.category.translation.description`,`main_category.category.translation.description`) AS `main_category.category.description`, `main_category.category.translation.metaTitle`, COALESCE(`main_category.category.translation.metaTitle`,`main_category.category.translation.metaTitle`) AS `main_category.category.metaTitle`, `main_category.category.translation.metaDescription`, COALESCE(`main_category.category.translation.metaDescription`,`main_category.category.translation.metaDescription`) AS `main_category.category.metaDescription`, `main_category.category.translation.keywords`, COALESCE(`main_category.category.translation.keywords`,`main_category.category.translation.keywords`) AS `main_category.category.keywords`, `main_category.category.translation.customFields`, COALESCE(`main_category.category.translation.customFields`,`main_category.category.translation.customFields`) AS `main_category.category.customFields`, `main_category.category.translation.createdAt`, `main_category.category.translation.updatedAt`, `main_category.category.translation.categoryId`, `main_category.category.translation.languageId`, `main_category.category.translation.categoryVersionId` FROM `main_category` LEFT JOIN `category` `main_category.category` ON `main_category`.`category_id` = `main_category.category`.`id` AND `main_category`.`category_version_id` = `main_category.category`.`version_id` LEFT JOIN (SELECT `main_category.category.translation`.category_id, `main_category.category.translation`.category_version_id, `main_category.category.translation`.name AS `main_category.category.translation.name`, `main_category.category.translation`.breadcrumb AS `main_category.category.translation.breadcrumb`, `main_category.category.translation`.slot_config AS `main_category.category.translation.slotConfig`, `main_category.category.translation`.link_type AS `main_category.category.translation.linkType`, `main_category.category.translation`.internal_link AS `main_category.category.translation.internalLink`, `main_category.category.translation`.external_link AS `main_category.category.translation.externalLink`, `main_category.category.translation`.link_new_tab AS `main_category.category.translation.linkNewTab`, `main_category.category.translation`.description AS `main_category.category.translation.description`, `main_category.category.translation`.meta_title AS `main_category.category.translation.metaTitle`, `main_category.category.translation`.meta_description AS `main_category.category.translation.metaDescription`, `main_category.category.translation`.keywords AS `main_category.category.translation.keywords`, `main_category.category.translation`.custom_fields AS `main_category.category.translation.customFields`, `main_category.category.translation`.created_at AS `main_category.category.translation.createdAt`, `main_category.category.translation`.updated_at AS `main_category.category.translation.updatedAt`, `main_category.category.translation`.category_id AS `main_category.category.translation.categoryId`, `main_category.category.translation`.language_id AS `main_category.category.translation.languageId`, `main_category.category.translation`.category_version_id AS `main_category.category.translation.categoryVersionId` FROM `category_translation` `main_category.category.translation` WHERE `main_category.category.translation`.language_id = ?) `main_category.category.category_translation` ON `main_category.category.category_translation`.`category_id` = `main_category.category`.`id` AND `main_category.category.category_translation`.category_version_id = `main_category.category`.version_id WHERE (`main_category`.`sales_channel_id` = ? AND `main_category`.`product_id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  b"\x08µE I9´²äuÂÆ+e"
]
0.43 ms
(0.40%)
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"‘8÷‡KVF¨º\rˉôļ"
  b"ß7ìÀÇèGÅæ×\rt\r]l\x1A"
  b"ã"ƒ¨Y.JïŠmÌAN<Å["
  b"ìÈ)\x10~\vNv”’þ@9ÓÐÄ"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"ç=îó¶üF¦± ÚÀ\x00SÉÁ"
]
0.42 ms
(0.40%)
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.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `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` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.41 ms
(0.39%)
1
# breadcrumb-builder::read
SELECT `category`.`id` AS `category.id`, `category`.`version_id` AS `category.versionId`, `category`.`parent_id` AS `category.parentId`, `category`.`parent_version_id` AS `category.parentVersionId`, `category`.`after_category_id` AS `category.afterCategoryId`, `category`.`after_category_version_id` AS `category.afterCategoryVersionId`, `category`.`media_id` AS `category.mediaId`, `category`.`display_nested_products` AS `category.displayNestedProducts`, `category`.`auto_increment` AS `category.autoIncrement`, `category`.`level` AS `category.level`, `category`.`path` AS `category.path`, `category`.`child_count` AS `category.childCount`, `category`.`type` AS `category.type`, `category`.`product_assignment_type` AS `category.productAssignmentType`, `category`.`visible` AS `category.visible`, `category`.`active` AS `category.active`, `category`.`cms_page_id` AS `category.cmsPageId`, `category`.`cms_page_version_id` AS `category.cmsPageVersionId`, `category`.`product_stream_id` AS `category.productStreamId`, `category`.`custom_entity_type_id` AS `category.customEntityTypeId`, `category`.`created_at` AS `category.createdAt`, `category`.`updated_at` AS `category.updatedAt`, `category.translation.name`, COALESCE(`category.translation.name`,`category.translation.name`) AS `category.name`, `category.translation.breadcrumb`, COALESCE(`category.translation.breadcrumb`,`category.translation.breadcrumb`) AS `category.breadcrumb`, `category.translation.slotConfig`, COALESCE(`category.translation.slotConfig`,`category.translation.slotConfig`) AS `category.slotConfig`, `category.translation.linkType`, COALESCE(`category.translation.linkType`,`category.translation.linkType`) AS `category.linkType`, `category.translation.internalLink`, COALESCE(`category.translation.internalLink`,`category.translation.internalLink`) AS `category.internalLink`, `category.translation.externalLink`, COALESCE(`category.translation.externalLink`,`category.translation.externalLink`) AS `category.externalLink`, `category.translation.linkNewTab`, COALESCE(`category.translation.linkNewTab`,`category.translation.linkNewTab`) AS `category.linkNewTab`, `category.translation.description`, COALESCE(`category.translation.description`,`category.translation.description`) AS `category.description`, `category.translation.metaTitle`, COALESCE(`category.translation.metaTitle`,`category.translation.metaTitle`) AS `category.metaTitle`, `category.translation.metaDescription`, COALESCE(`category.translation.metaDescription`,`category.translation.metaDescription`) AS `category.metaDescription`, `category.translation.keywords`, COALESCE(`category.translation.keywords`,`category.translation.keywords`) AS `category.keywords`, `category.translation.customFields`, COALESCE(`category.translation.customFields`,`category.translation.customFields`) AS `category.customFields`, `category.translation.createdAt`, `category.translation.updatedAt`, `category.translation.categoryId`, `category.translation.languageId`, `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` FROM `category_translation` `category.translation` WHERE `category.translation`.language_id = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.category_version_id = `category`.version_id WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"5r\x06\x1E\x1AaK½¥ò╦P¨É=©"
]
0.38 ms
(0.35%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.35 ms
(0.33%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.34 ms
(0.33%)
1
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
  b"K─[\x16\x13║Né▓Ö░8¸É³©"
]
0.34 ms
(0.32%)
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.33 ms
(0.31%)
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.name`, COALESCE(`country.translation.name`,`country.translation.name`) AS `country.name`, `country.translation.addressFormat`, COALESCE(`country.translation.addressFormat`,`country.translation.addressFormat`) AS `country.addressFormat`, `country.translation.customFields`, COALESCE(`country.translation.customFields`,`country.translation.customFields`) AS `country.customFields`, `country.translation.createdAt`, `country.translation.updatedAt`, `country.translation.countryId`, `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` FROM `country_translation` `country.translation` WHERE `country.translation`.language_id = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x7FÍp\x08û³@¿˜².ïaH\r\x14"
]
0.31 ms
(0.30%)
1
# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?))) ORDER BY `product_review`.`created_at` DESC LIMIT 10
Parameters:
[
  true
  b"\x08µE I9´²äuÂÆ+e"
  b"\x08µE I9´²äuÂÆ+e"
]
0.30 ms
(0.29%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.30 ms
(0.29%)
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.30 ms
(0.28%)
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.shortName`, COALESCE(`currency.translation.shortName`,`currency.translation.shortName`) AS `currency.shortName`, `currency.translation.name`, COALESCE(`currency.translation.name`,`currency.translation.name`) AS `currency.name`, `currency.translation.customFields`, COALESCE(`currency.translation.customFields`,`currency.translation.customFields`) AS `currency.customFields`, `currency.translation.createdAt`, `currency.translation.updatedAt`, `currency.translation.currencyId`, `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` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.language_id = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
0.29 ms
(0.27%)
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.name`, COALESCE(`customer_group.translation.name`,`customer_group.translation.name`) AS `customer_group.name`, `customer_group.translation.registrationTitle`, COALESCE(`customer_group.translation.registrationTitle`,`customer_group.translation.registrationTitle`) AS `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, COALESCE(`customer_group.translation.registrationIntroduction`,`customer_group.translation.registrationIntroduction`) AS `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, COALESCE(`customer_group.translation.registrationOnlyCompanyRegistration`,`customer_group.translation.registrationOnlyCompanyRegistration`) AS `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, COALESCE(`customer_group.translation.registrationSeoMetaDescription`,`customer_group.translation.registrationSeoMetaDescription`) AS `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, COALESCE(`customer_group.translation.customFields`,`customer_group.translation.customFields`) AS `customer_group.customFields`, `customer_group.translation.createdAt`, `customer_group.translation.updatedAt`, `customer_group.translation.customerGroupId`, `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` FROM `customer_group_translation` `customer_group.translation` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"¤¢P\x18ËìAÏ¡╩\x10┘O╚¢Í"
]
0.28 ms
(0.27%)
1
# product-price-calculator::units::read
SELECT `unit`.`id` AS `unit.id`, `unit`.`created_at` AS `unit.createdAt`, `unit`.`updated_at` AS `unit.updatedAt`, `unit.translation.shortCode`, COALESCE(`unit.translation.shortCode`,`unit.translation.shortCode`) AS `unit.shortCode`, `unit.translation.name`, COALESCE(`unit.translation.name`,`unit.translation.name`) AS `unit.name`, `unit.translation.customFields`, COALESCE(`unit.translation.customFields`,`unit.translation.customFields`) AS `unit.customFields`, `unit.translation.createdAt`, `unit.translation.updatedAt`, `unit.translation.unitId`, `unit.translation.languageId` FROM `unit` LEFT JOIN (SELECT `unit.translation`.unit_id, `unit.translation`.short_code AS `unit.translation.shortCode`, `unit.translation`.name AS `unit.translation.name`, `unit.translation`.custom_fields AS `unit.translation.customFields`, `unit.translation`.created_at AS `unit.translation.createdAt`, `unit.translation`.updated_at AS `unit.translation.updatedAt`, `unit.translation`.unit_id AS `unit.translation.unitId`, `unit.translation`.language_id AS `unit.translation.languageId` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.language_id = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.28 ms
(0.27%)
1
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
0.28 ms
(0.26%)
1
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id
Parameters:
[]
0.27 ms
(0.26%)
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"8X•p\x16dMä®HÀP\vóÌÈ"
  b"b‰3*²ûCZ¾žpñ†Í¡s"
  b"‘8÷‡KVF¨º\rˉôļ"
  b"¦.\x1Fj\x1A\vE\x19¯@\ebp£qI"
  b"ß7ìÀÇèGÅæ×\rt\r]l\x1A"
  b"ã"ƒ¨Y.JïŠmÌAN<Å["
  b"ìÈ)\x10~\vNv”’þ@9ÓÐÄ"
  b"""
    <õA6žmJ/§\n
    ¨hzeü-
    """
  b"╩&3╦uaBñ»\x0E4ì?övì"
  b"(Ê®u¥bO\r˜Z½\x0E³*¡`"
  b"MèÀ¢ÒƒM!ŠÞ,SÆ–_\x11"
  b"ç=îó¶üF¦± ÚÀ\x00SÉÁ"
  b"\x15╬ôØ|'Hù£!¶▀ÛåZ¾"
  b"Gººî xN<ÿ6,Å┤²ƒ\"
  b"GÆ,榼FY†QÒª·Žt*"
  b"v\x1Câò#ØN\x00«\x04\x1E\f:▓"
  b"‚·‹?ÿP@\x19¶iR`XXÀ¾"
  b"ÑL/ƒü│Fë®8Ýô½╚<¾"
  b"Õ*XÕÄéNÂŽÁ˜›<ÛÑ "
  b"¦J5×\x0FáMXÄdÅò╗÷î1"
  b"ò\x04\x7FÜû BÓ§ee,Eº02"
]
0.25 ms
(0.24%)
1
# product-detail-route::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?)) GROUP BY `product`.`id`
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  true
  b"\x08µE I9´²äuÂÆ+e"
]
0.25 ms
(0.24%)
1
SELECT COUNT(*) FROM (# product-review-route::search-ids
SELECT `product_review`.`id` FROM `product_review` LEFT JOIN `product` `product_review.product` ON `product_review`.`product_id` = `product_review.product`.`id` AND `product_review`.`product_version_id` = `product_review.product`.`version_id` LEFT JOIN `product` `product_review.product.parent` ON `product_review.product`.`parent_id` = `product_review.product.parent`.`id` AND `product_review.product`.`parent_version_id` = `product_review.product.parent`.`version_id` WHERE (((`product_review`.`status` = ?) AND (`product_review.product`.`id` = ? OR `product_review.product`.`parent_id` = ?)))) total
Parameters:
[
  true
  b"\x08µE I9´²äuÂÆ+e"
  b"\x08µE I9´²äuÂÆ+e"
]
0.25 ms
(0.23%)
2
#cart-persister::load
                SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
  "SxmaTAKrVLYLIrwwNAfIwD4yvM2c4SKo"
]
0.24 ms
(0.22%)
1
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.23 ms
(0.21%)
1
# breadcrumb-builder::main-category::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` LEFT JOIN `main_category` `category.mainCategories` ON `category`.`id` = `category.mainCategories`.`category_id` AND `category`.version_id = `category.mainCategories`.category_version_id WHERE (`category`.`version_id` = ?) AND (((`category.mainCategories`.`product_id` = ? AND `category.mainCategories`.`sales_channel_id` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?)))) LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
  b"šyš=ЪF+“Ô\x0FRmÅhˆ"
  "%|b2f2d44613e14b4395b4e4e8e21ab6f3|%"
  "%|229c73f7363f46cebd1b2d63258e2c77|%"
]
0.22 ms
(0.21%)
1
# product-cross-selling-route::search-ids
SELECT `product_cross_selling`.`id` FROM `product_cross_selling` LEFT JOIN `product` `product_cross_selling.product` ON `product_cross_selling`.`product_id` = `product_cross_selling.product`.`crossSellings` AND `product_cross_selling`.`product_version_id` = `product_cross_selling.product`.`version_id` LEFT JOIN `product` `product_cross_selling.product.parent` ON `product_cross_selling.product`.`parent_id` = `product_cross_selling.product.parent`.`id` AND `product_cross_selling.product`.`parent_version_id` = `product_cross_selling.product.parent`.`version_id` WHERE (`product_cross_selling.product`.`id` = ? AND `product_cross_selling`.`active` = ?) ORDER BY `product_cross_selling`.`position` ASC
Parameters:
[
  b"\x08µE I9´²äuÂÆ+e"
  1
]
0.21 ms
(0.20%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.21 ms
(0.20%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
  b"\x7FÍp\x08û³@¿˜².ïaH\r\x14"
]
0.20 ms
(0.19%)
1
SELECT `vio_b2b_privilege`.`id` AS `vio_b2b_privilege.id`, `vio_b2b_privilege`.`active` AS `vio_b2b_privilege.active`, `vio_b2b_privilege`.`namespace` AS `vio_b2b_privilege.namespace`, `vio_b2b_privilege`.`name` AS `vio_b2b_privilege.name`, `vio_b2b_privilege`.`description` AS `vio_b2b_privilege.description`, `vio_b2b_privilege`.`plugin_id` AS `vio_b2b_privilege.pluginId`, `vio_b2b_privilege`.`custom_fields` AS `vio_b2b_privilege.customFields`, `vio_b2b_privilege`.`created_at` AS `vio_b2b_privilege.createdAt`, `vio_b2b_privilege`.`updated_at` AS `vio_b2b_privilege.updatedAt` FROM `vio_b2b_privilege` WHERE (`vio_b2b_privilege`.`active` = ?)
Parameters:
[
  true
]
0.19 ms
(0.18%)
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"šyš=ЪF+“Ô\x0FRmÅhˆ"
]
0.19 ms
(0.18%)
1
# product-detail-route::association::prices::read
SELECT `product_price`.`id` AS `product_price.id`, `product_price`.`version_id` AS `product_price.versionId`, `product_price`.`product_id` AS `product_price.productId`, `product_price`.`product_version_id` AS `product_price.productVersionId`, `product_price`.`rule_id` AS `product_price.ruleId`, `product_price`.`price` AS `product_price.price`, `product_price`.`quantity_start` AS `product_price.quantityStart`, `product_price`.`quantity_end` AS `product_price.quantityEnd`, `product_price`.`custom_fields` AS `product_price.customFields`, `product_price`.`created_at` AS `product_price.createdAt`, `product_price`.`updated_at` AS `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND ((`product_price`.`product_id` IN (?)))
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x08µE I9´²äuÂÆ+e"
]
0.18 ms
(0.17%)
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"\x7FÍp\x08û³@¿˜².ïaH\r\x14"
]
0.17 ms
(0.17%)
1
# breadcrumb-builder::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`active` = ? AND (`category`.`path` LIKE ? OR `category`.`path` LIKE ?))) AND (`category`.`id` IN (?)) LIMIT 1
Parameters:
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  true
  "%|b2f2d44613e14b4395b4e4e8e21ab6f3|%"
  "%|229c73f7363f46cebd1b2d63258e2c77|%"
  b"5r\x06\x1E\x1AaK½¥ò╦P¨É=©"
]
0.17 ms
(0.16%)
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.16 ms
(0.15%)
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.15 ms
(0.14%)
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.15 ms
(0.14%)
1
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
0.12 ms
(0.12%)
1
SELECT `name`, `path`, `author`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.11 ms
(0.11%)
1
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
  b"K─[\x16\x13║Né▓Ö░8¸É³©"
]
0.10 ms
(0.10%)
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:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.