Query Metrics
131
Database Queries
63
Different statements
102.25 ms
Query time
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31.70 ms (31.00%) |
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.68 ms (18.26%) |
1 |
# seo_url::replacement SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[ "/navigation/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" "/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ˆ" ] |
||||||||||||||||||||
7.00 ms (6.84%) |
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.83 ms (4.73%) |
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 ] |
||||||||||||||||||||
4.36 ms (4.26%) |
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„," ] |
||||||||||||||||||||
2.97 ms (2.90%) |
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.44 ms (2.39%) |
16 |
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[ b"šyš=ЪF+“Ô\x0FRmÅhˆ" "XXFUOZmiTq1zoO5JPju3MWBwGhKYgInK" ] |
||||||||||||||||||||
2.23 ms (2.18%) |
2 |
SHOW COLUMNS FROM `cart` WHERE `Field` LIKE ?
Parameters:
[
"payload"
]
|
||||||||||||||||||||
1.79 ms (1.76%) |
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.42 ms (1.39%) |
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.42 ms (1.38%) |
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.20 ms (1.17%) |
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ˆ" "checkout/cart" ] |
||||||||||||||||||||
1.16 ms (1.13%) |
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ˆ"
]
|
||||||||||||||||||||
1.08 ms (1.06%) |
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Ý¡" ] |
||||||||||||||||||||
1.04 ms (1.01%) |
8 |
SELECT `base_class` AS `baseClass`, `author` FROM `plugin`
Parameters:
[] |
||||||||||||||||||||
0.94 ms (0.92%) |
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.90 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.78 ms (0.76%) |
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""" vÛ\n 1•kB¨ºá\x01æÖ¶\x06\x18 """ ] |
||||||||||||||||||||
0.74 ms (0.72%) |
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.72 ms (0.70%) |
2 |
# 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¶ó" ] |
||||||||||||||||||||
0.69 ms (0.67%) |
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.63 ms (0.62%) |
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""" vÛ\n 1•kB¨ºá\x01æÖ¶\x06\x18 """ ] |
||||||||||||||||||||
0.61 ms (0.60%) |
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.61 ms (0.59%) |
1 |
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""" vÛ\n 1•kB¨ºá\x01æÖ¶\x06\x18 """ ] |
||||||||||||||||||||
0.60 ms (0.59%) |
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.57 ms (0.56%) |
1 |
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.54 ms (0.53%) |
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\x05gù\x7F(" b"žûBµïzK˜žr\x1DÖÊ~y‚" b"ªÇ\x1D(•èI¢Œ\x06KÙNhz-" b"Õh\x1C6œ‹L§º¢'¤‚jx\x06" b"زäÄ;\tOù‚\x1A\x1C²z¤Qk" ] |
||||||||||||||||||||
0.49 ms (0.48%) |
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.49 ms (0.48%) |
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.47 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.47 ms (0.46%) |
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.46 ms (0.45%) |
1 |
# theme-service::resolve-media::read SELECT `media`.`id` AS `media.id`, `media`.`user_id` AS `media.userId`, `media`.`media_folder_id` AS `media.mediaFolderId`, `media`.`mime_type` AS `media.mimeType`, `media`.`file_extension` AS `media.fileExtension`, `media`.`uploaded_at` AS `media.uploadedAt`, `media`.`file_name` AS `media.fileName`, `media`.`file_size` AS `media.fileSize`, `media`.`media_type` AS `media.mediaTypeRaw`, `media`.`meta_data` AS `media.metaData`, `media`.`config` AS `media.config`, `media`.`path` AS `media.path`, `media`.`private` AS `media.private`, `media`.`thumbnails_ro` AS `media.thumbnailsRo`, `media`.`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" ] |
||||||||||||||||||||
0.45 ms (0.44%) |
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.44 ms (0.43%) |
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.43 ms (0.42%) |
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.42 ms (0.41%) |
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.37 ms (0.36%) |
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\x1EzØ\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.35 ms (0.35%) |
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.35 ms (0.34%) |
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.34 ms (0.33%) |
1 |
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.33 ms (0.33%) |
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`.`active` = ? AND `country.salesChannels`.`id` = ?) GROUP BY `country`.`id`
Parameters:
[ true b"šyš=ЪF+“Ô\x0FRmÅhˆ" ] |
||||||||||||||||||||
0.32 ms (0.31%) |
1 |
# seo-url::resolve-fallback SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters:
[ b"/»_ââšMpªXTÎ|ãâ\v" b"šyš=ЪF+“Ô\x0FRmÅhˆ" "/checkout/cart" ] |
||||||||||||||||||||
0.32 ms (0.31%) |
1 |
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.32 ms (0.31%) |
1 |
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters:
[
b"K─[\x16\x13║Né▓Ö░8¸É³©"
]
|
||||||||||||||||||||
0.31 ms (0.30%) |
2 |
#cart-persister::load SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
"XXFUOZmiTq1zoO5JPju3MWBwGhKYgInK"
]
|
||||||||||||||||||||
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.29 ms (0.28%) |
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.26 ms (0.25%) |
1 |
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.25 ms (0.25%) |
1 |
# base-context-factory::cash-rounding::search-ids SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters:
[ b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ" b"\x7FÍp\x08û³@¿˜².ïaH\r\x14" ] |
||||||||||||||||||||
0.25 ms (0.24%) |
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.25 ms (0.24%) |
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.24 ms (0.23%) |
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.22 ms (0.21%) |
1 |
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
|
||||||||||||||||||||
0.22 ms (0.21%) |
1 |
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
0.20 ms (0.20%) |
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.18 ms (0.17%) |
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.16 ms (0.16%) |
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.15 ms (0.15%) |
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.15 ms (0.14%) |
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.11 ms (0.11%) |
1 |
SET @@group_concat_max_len = CAST(IF(@@group_concat_max_len > 320000, @@group_concat_max_len, 320000) AS UNSIGNED);SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))
Parameters:
[]
|
||||||||||||||||||||
0.11 ms (0.10%) |
1 |
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
"de-DE"
]
|
||||||||||||||||||||
0.09 ms (0.09%) |
1 |
SELECT `name`, `path`, `author` FROM `app` WHERE `active` = 1
Parameters:
[] |
||||||||||||||||||||
0.09 ms (0.08%) |
1 |
SELECT iso FROM snippet_set WHERE id = ?
Parameters:
[
b"K─[\x16\x13║Né▓Ö░8¸É³©"
]
|
Database Connections
Name | Service |
---|---|
0 | default |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.