GET https://menziebz.webwirkungdev.ch/detail/01910ec09fef715bb625bb592c5d64d3

Query Metrics

27 Database Queries
25 Different statements
18.19 ms Query time

Grouped Statements

Show all queries

Time Count Info
5.08 ms
(27.96%)
1
# seo_url::replacement
SELECT seo_path_info, path_info, sales_channel_id FROM seo_url WHERE (seo_url.is_canonical = 1) AND (seo_url.path_info IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (seo_url.language_id = ?) AND (seo_url.sales_channel_id = ? OR seo_url.sales_channel_id IS NULL) AND (seo_url.is_deleted = 0)
Parameters:
[
  "/detail/01910ec09fef715bb625bb592c5d64d3"
  "/navigation/a4eba85b194f484295e1db368487d998"
  "/navigation/6d6ee80f2700478598d2a2dd73db596c"
  "/navigation/019054bb2b5170a9a01d7c52f31f4ea9"
  "/navigation/fd83c2142ea34ff79f669fc3b470c847"
  "/navigation/4caf7ca43166417fbc51a18c8d3b35b5"
  "/navigation/4c3cb605bb5f46d0b8815e225822bb38"
  "/navigation/ec69130494f64dcda67f1b66ee15e944"
  "/navigation/1d01dbdb4fc341dc9a290a794584bb7c"
  "/navigation/047fa5566a90433099a68b4482400a3b"
  "/navigation/af1ada8ff50041b2a7d8214ab38073e7"
  "/navigation/223a73dedbd74d6f9e646bfb26c17644"
  "/navigation/cbe776f2f17445b5b71a4dcd1f17684d"
  "/navigation/df8b1327dc5b43f9bcd2a4acd91292bc"
  "/navigation/6fcab224d2624b1d878a27b23573a3b0"
  "/navigation/2c510ce953744e019e61d3c91a263630"
  "/navigation/a57540baf2404a14bea6b645e586a4bc"
  "/navigation/52860544a42142929223dc983f564868"
  "/navigation/6afcd0f2aa004fcf90e75d26804e6aba"
  "/navigation/ace73fce4a18439ca507e5ef8a621405"
  "/navigation/015cded59f9643cbbb9abe36fe26853c"
  "/navigation/682c3e125204499fbe42ab14ba4be8bc"
  "/navigation/a84134df514649299a5e74a135bd6202"
  "/navigation/2accf100594b4a18b86548e573816b54"
  "/navigation/5f0f26157e27471d975bc7cc1a376544"
  "/navigation/5c56e77c506e40839eb8e46fbe301a2f"
  "/navigation/8b7aa8324bbe4134af70d1498ffca82a"
  "/navigation/529080be909a4c99bdfd83bb642d3e5b"
  "/navigation/377741c87cbb4f81ada4bfa2263a9327"
  "/navigation/08597fcdfd33419eaa40edcee02e108d"
  "/navigation/54cbf57c7c84417291be74e20d339923"
  "/navigation/67137434aa8148c7ac9b6ad0c4e939d6"
  "/navigation/aa796c4af5074afda19790c91972c71c"
  "/navigation/53a4b9bc9c81421da0c93d1df0d30a05"
  "/navigation/61058fc42b244c1785b45c1035c66f56"
  "/navigation/031aa1700ccf4c48bcf1af4dfa1a1ed7"
  "/navigation/fc69b7e724e040889b0cf12da505d36c"
  "/navigation/1b84ab6c827b47fbb1bb3dc82c030e45"
  "/navigation/17830a0aef264dbfaa48994e6c56eab0"
  "/navigation/504b975fc2a14ef98defbebd48d4ce56"
  "/navigation/5d557a1e0e29406b81fe2e2486b6e11a"
  "/navigation/329dd51d6fd8423a960e7c8f26dd008a"
  "/navigation/e4babda014724d45b2a51362ada93000"
  "/navigation/31db06e32f474000b38b730ba8cb7a66"
  "/navigation/402848d7bfda40fa8cd123c23f90a3f2"
  "/navigation/706802a8b40d44c3a7cde9cec363bbea"
  "/navigation/8a7567c6c84542b3b512e66c878c42da"
  "/navigation/10abdfaa320f44e1a066e34e02694fed"
  "/navigation/96d703f3e5184525adea87d4f2a343b6"
  "/navigation/2c368932efa343a79f1c158fd6f9b74a"
  "/navigation/582d16fca3ae4dd6a1d642583f30e51f"
  "/navigation/4a7e5308a0d64685b8a7951ab335d636"
  "/navigation/200d6e2092f04ed78d93156f44c5dcc5"
  "/navigation/603938ad7d2841c4892e7a976d33f355"
  "/navigation/91aa4913710445719d928f4760cd5f72"
  "/navigation/e32c15534c54487d816306309ee3df79"
  "/navigation/f869c1b352984703842b46de65154eda"
  "/navigation/42a1b4a1be8347868a00a19c6f2fd1bd"
  "/navigation/b1cbc7b817624af78dbbcf136346dcb4"
  "/navigation/37456140c9fc4891be3d1d83976e25af"
  "/navigation/8851c6eabf8a45999b0c259c2291f956"
  "/navigation/6cd9878b596e4f08a1ad09f7295cf0bc"
  "/navigation/e78fe328b7d44b2db251867adaaf4d40"
  "/navigation/6a566dc5b6a1411da95731b89b5ecba7"
  "/navigation/04f4be699afa469a9858c79b02c14bd6"
  "/navigation/5fcca137c497482c971e528a59ac5682"
  "/navigation/3f4ea6ea8cc344c1b310990f899b406a"
  "/navigation/53eed4cc11874022b00d6c2224361cd9"
  "/navigation/ca189a3f460141de9513fd718ca02f92"
  "/navigation/ca8e5a5739fb4de5a0e027599b1fcc21"
  "/navigation/f21fde8bbc7d495b8201585439a0e053"
  "/navigation/ae25489caa554f64a962d59ec3614479"
  "/navigation/019150ed7c667a3999470ccbc1702a49"
  "/navigation/ba36106b03bd4fe0bb09f7b1ab699314"
  "/navigation/477404fd7e9d4ab78586e0d26e266f8b"
  "/navigation/019150eddab57d86bf4c4d5eafe6b157"
  "/navigation/5e15e148ad6a4ce189e00bcc6f037ec4"
  "/navigation/228b5086995b4797b2ca631844ba3d44"
  "/navigation/aafdb3c39e004c05850a51612e1875ac"
  "/navigation/7cb74b64b20941d7aafb19b42e5f2fe0"
  "/navigation/99f5ee3a5bd648279a1c28509736d8f7"
  "/navigation/fff53c4488b648a9b9dd095e53bb2440"
  "/navigation/0cdb9daa09fa4d65b8ea01e4559e4efd"
  "/navigation/3292be97c8de4e73b39e5a71e38fbab9"
  "/navigation/0190e90525ff70a89d17aed5e552d36d"
  "/navigation/0190e90565347ca2a4ddcde9c405a8f3"
  "/navigation/019150eba46674b985e95aedd2f28c4e"
  "/navigation/0190e9067f427309af029facda17e279"
  "/navigation/0190e9069c927eecb7b37cb70c885cf1"
  "/navigation/0190e90703467f05960cdf393d2b9334"
  "/navigation/0190e90838d67625a7019d87909e7d2e"
  "/navigation/0190e9106c9e77a2b56ffa46f769f08c"
  "/navigation/0190e94d44e47d94a7f205b85b155086"
  "/navigation/0190e94d5ce2740aa5a658ac5f68d3ce"
  "/navigation/0190e946c6977e1092a7739913a80511"
  "/navigation/0190e94b139e70d49f734c7f0d447eb1"
  "/navigation/0190e94b5379790eae0f4ba3d58d0aae"
  "/navigation/0190e94b72637cb0935dffb236ba6d9b"
  "/navigation/0190e94b83ed7159a7d08dc5864cae3c"
  "/navigation/0190e94b94517b20b9122a5b78be7897"
  "/navigation/b2d347310ba8447a9dac9a9f860a078f"
  "/navigation/0190e955be0472ef926b093587aeec25"
  "/navigation/0190e955d6d276de901444c4a12b4e8c"
  "/navigation/0190e95739267f8099ed81a69c5303e0"
  "/navigation/0190ee64a2637051a9c7c179a0aedc86"
  "/navigation/52eadbc235f2414b9f2abf92bc3d2745"
  "/navigation/164a96bd7d4342de881b37867c767677"
  "/navigation/019150d6e0a37a9787423845e973327a"
  "/navigation/019150d7032b79029708d471a8179169"
  "/navigation/01918eb5428779e5b343828a0c27999f"
  "/navigation/eb8c4e8c0eeb4d61a9cc948194d03837"
  "/navigation/3fca686965c44f0f8cc10d7deba98065"
  "/navigation/0191f155bf31719ba36094641801aa92"
  "/navigation/877581eca99543f69b6dd437d1e52231"
  "/navigation/2f23ce7a9fef421b8712a8398843a212"
  "/navigation/8539fa0bcf884fb6992d29526525b0c2"
  "/navigation/0190e958a3aa7c20af04eb97a5e7275b"
  "/navigation/86830b38338047ff81c4d6c99c3456e5"
  "/navigation/f60703628bef44eab3f8086b8446f142"
  "/navigation/0190e95890bf7becab53fd219c2e2a8c"
  "/navigation/9817a203826d462680aef526185a6e46"
  "/navigation/76f18a459ead4933a7c480f128884e2e"
  "/navigation/c23856d608f2427d8bf020df8c54dcc8"
  "/navigation/0190e9587cf777ce8abf5b0040dea2b7"
  "/navigation/2730b7df44e54f52a07f810653775d14"
  "/navigation/ae62acbe5c624ae1a6cb3aa14b229931"
  "/navigation/2c680d7edafb454eb68276ebf56e6c43"
  "/navigation/bee82e199aee43eebc458a57706362ca"
  "/navigation/0dcd561162fb416c9715b9d8c600dffc"
  "/navigation/7186ebfb563a410989dc3de99beec5ca"
  "/navigation/b8be3bb6650b459aa3192e395f4a80e1"
  "/navigation/38f7724f59454bc4a44e19924bd4a4cf"
  "/navigation/a903d001e82d4c709e2545176fc4afb6"
  "/navigation/cda2229891094652915ae7d767a6c2b4"
  "/navigation/01922a02bf21757caf06ceba1fc61d95"
  "/navigation/f19f9d07a7d34771bb004d673c4005ca"
  "/navigation/06e0851ac15549adb6a228a033ed3619"
  "/navigation/786f48a8e73747c29fd2887b74d9a5e2"
  "/navigation/29e040585255439c9e4fce9fc8e699b3"
  "/navigation/8f09f653a0df4381a2f532d833c5bc03"
  "/navigation/1fb05e61003e421d8dd8daaca863946f"
  "/navigation/3660c6ec7cbb4b51b472e3f17cb4a7eb"
  "/navigation/70afc5c43eed4d1ea4d2e38b3074b5dd"
  "/navigation/1217fc23af1649b68ef836300994a05e"
  "/navigation/019151070d8a74b09fe6479b1f54a5a3"
  "/navigation/89845eafc8b64f47ab81f17702eb537b"
  "/navigation/01915107ba82739ebe07e12fbc4746e7"
  "/navigation/01915107cd647ed5950ff40cfac4a32a"
  "/detail/b0f26142b68b452dabc9bc1ab47870ef"
  "/detail/7b9676ad39144c338290d1d4d73b64af"
  "/detail/09bd2e6e298f48269109fe1a4f98414e"
  "/detail/09f3914c038f4cf8a41a2524b1636e59"
  "/detail/76d8a82f0faf4b5c94e4c467a3d7c7eb"
  "/detail/7b61cf3e6c9d4c23b85407389bd45e72"
  "/detail/8b4153d9fcf0496ebbc1a7c938ca58f7"
  "/navigation/0190de58b01475beb3663897fc94b575"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"õ½iA_mMÇ’\x18}2m}”M"
]
3.11 ms
(17.12%)
1
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, (SELECT GROUP_CONCAT(HEX(`product.blogTags.mapping`.`sas_tag_id`) SEPARATOR '||')
                  FROM `sas_tag_product` `product.blogTags.mapping`
                  WHERE `product.blogTags.mapping`.`product_id` = `product`.`id` ) as `product.blogTags.id_mapping`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords` FROM `product_translation` `product.translation` WHERE `product.translation`.`language_id` = ?) `product.product_translation` ON `product.product_translation`.`product_id` = `product`.`id` AND `product.product_translation`.`product_version_id` = `product`.`version_id` LEFT JOIN (SELECT `product.parent.translation`.`product_id`, `product.parent.translation`.`product_version_id`, `product.parent.translation`.`meta_description` as `product.parent.translation.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords` FROM `product_translation` `product.parent.translation` WHERE `product.parent.translation`.`language_id` = ?) `product.parent.product_translation` ON `product.parent.product_translation`.`product_id` = `product.parent`.`id` AND `product.parent.product_translation`.`product_version_id` = `product.parent`.`version_id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01\x0EÀŸïq[¶%»Y,]dÓ"
]
1.91 ms
(10.52%)
1
SELECT `sas_blog_entries`.`id` as `sas_blog_entries.id`, `sas_blog_entries`.`active` as `sas_blog_entries.active`, `sas_blog_entries`.`detail_teaser_image` as `sas_blog_entries.detailTeaserImage`, `sas_blog_entries`.`media_id` as `sas_blog_entries.mediaId`, `sas_blog_entries`.`author_id` as `sas_blog_entries.authorId`, `sas_blog_entries`.`cms_page_id` as `sas_blog_entries.cmsPageId`, `sas_blog_entries`.`cms_page_version_id` as `sas_blog_entries.cmsPageVersionId`, `sas_blog_entries.media`.`id` as `sas_blog_entries.media.id`, `sas_blog_entries.media`.`user_id` as `sas_blog_entries.media.userId`, `sas_blog_entries.media`.`media_folder_id` as `sas_blog_entries.media.mediaFolderId`, `sas_blog_entries.media`.`mime_type` as `sas_blog_entries.media.mimeType`, `sas_blog_entries.media`.`file_extension` as `sas_blog_entries.media.fileExtension`, `sas_blog_entries.media`.`uploaded_at` as `sas_blog_entries.media.uploadedAt`, `sas_blog_entries.media`.`file_name` as `sas_blog_entries.media.fileName`, `sas_blog_entries.media`.`file_size` as `sas_blog_entries.media.fileSize`, `sas_blog_entries.media`.`media_type` as `sas_blog_entries.media.mediaTypeRaw`, `sas_blog_entries.media`.`meta_data` as `sas_blog_entries.media.metaData`, `sas_blog_entries.media`.`config` as `sas_blog_entries.media.config`, `sas_blog_entries.media`.`path` as `sas_blog_entries.media.path`, `sas_blog_entries.media`.`private` as `sas_blog_entries.media.private`, `sas_blog_entries.media`.`thumbnails_ro` as `sas_blog_entries.media.thumbnailsRo`, `sas_blog_entries.media`.`created_at` as `sas_blog_entries.media.createdAt`, `sas_blog_entries.media`.`updated_at` as `sas_blog_entries.media.updatedAt`, `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation.title` as `sas_blog_entries.media.title`, `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation.alt` as `sas_blog_entries.media.alt`, `sas_blog_entries.media.translation.customFields`, `sas_blog_entries.media.translation.customFields` as `sas_blog_entries.media.customFields`, `sas_blog_entries`.`published_at` as `sas_blog_entries.publishedAt`, `sas_blog_entries`.`created_at` as `sas_blog_entries.createdAt`, `sas_blog_entries`.`updated_at` as `sas_blog_entries.updatedAt`, `sas_blog_entries.translation.title`, `sas_blog_entries.translation.title` as `sas_blog_entries.title`, `sas_blog_entries.translation.slug`, `sas_blog_entries.translation.slug` as `sas_blog_entries.slug`, `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation.teaser` as `sas_blog_entries.teaser`, `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation.metaTitle` as `sas_blog_entries.metaTitle`, `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation.metaDescription` as `sas_blog_entries.metaDescription`, `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation.metaKeywords` as `sas_blog_entries.metaKeywords`, `sas_blog_entries.translation.content`, `sas_blog_entries.translation.content` as `sas_blog_entries.content`, `sas_blog_entries.translation.customFields`, `sas_blog_entries.translation.customFields` as `sas_blog_entries.customFields` FROM `sas_blog_entries` LEFT JOIN `media` `sas_blog_entries.media` ON `sas_blog_entries`.`media_id` = `sas_blog_entries.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `sas_blog_entries.translation`.`title` as `sas_blog_entries.translation.title`, `sas_blog_entries.translation`.`slug` as `sas_blog_entries.translation.slug`, `sas_blog_entries.translation`.`teaser` as `sas_blog_entries.translation.teaser`, `sas_blog_entries.translation`.`meta_title` as `sas_blog_entries.translation.metaTitle`, `sas_blog_entries.translation`.`meta_description` as `sas_blog_entries.translation.metaDescription`, `sas_blog_entries.translation`.`meta_keywords` as `sas_blog_entries.translation.metaKeywords`, `sas_blog_entries.translation`.`content` as `sas_blog_entries.translation.content`, `sas_blog_entries.translation`.`custom_fields` as `sas_blog_entries.translation.customFields` FROM `sas_blog_entries_translation` `sas_blog_entries.translation` WHERE `sas_blog_entries.translation`.`language_id` = ?) `sas_blog_entries.sas_blog_entries_translation` ON `sas_blog_entries.sas_blog_entries_translation`.`sas_blog_entries_id` = `sas_blog_entries`.`id` LEFT JOIN (SELECT `sas_blog_entries.media.translation`.`media_id`, `sas_blog_entries.media.translation`.`alt` as `sas_blog_entries.media.translation.alt`, `sas_blog_entries.media.translation`.`title` as `sas_blog_entries.media.translation.title`, `sas_blog_entries.media.translation`.`custom_fields` as `sas_blog_entries.media.translation.customFields` FROM `media_translation` `sas_blog_entries.media.translation` WHERE `sas_blog_entries.media.translation`.`language_id` = ?) `sas_blog_entries.media.media_translation` ON `sas_blog_entries.media.media_translation`.`media_id` = `sas_blog_entries.media`.`id` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  "2025-05-15T03:42:53+00:00"
]
1.28 ms
(7.05%)
2
SELECT `solid_pv_product_embedded_video_media`.`id` as `solid_pv_product_embedded_video_media.id`, `solid_pv_product_embedded_video_media`.`product_id` as `solid_pv_product_embedded_video_media.productId`, `solid_pv_product_embedded_video_media`.`product_version_id` as `solid_pv_product_embedded_video_media.productVersionId`, `solid_pv_product_embedded_video_media`.`video_id` as `solid_pv_product_embedded_video_media.videoId`, `solid_pv_product_embedded_video_media`.`source` as `solid_pv_product_embedded_video_media.source`, `solid_pv_product_embedded_video_media`.`custom_source_mime_type` as `solid_pv_product_embedded_video_media.customSourceMimeType`, `solid_pv_product_embedded_video_media`.`position` as `solid_pv_product_embedded_video_media.position`, `solid_pv_product_embedded_video_media`.`thumbnail_media_id` as `solid_pv_product_embedded_video_media.thumbnailMediaId`, `solid_pv_product_embedded_video_media`.`custom_fields` as `solid_pv_product_embedded_video_media.customFields`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`id` as `solid_pv_product_embedded_video_media.thumbnailMedia.id`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`user_id` as `solid_pv_product_embedded_video_media.thumbnailMedia.userId`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`media_folder_id` as `solid_pv_product_embedded_video_media.thumbnailMedia.mediaFolderId`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`mime_type` as `solid_pv_product_embedded_video_media.thumbnailMedia.mimeType`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`file_extension` as `solid_pv_product_embedded_video_media.thumbnailMedia.fileExtension`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`uploaded_at` as `solid_pv_product_embedded_video_media.thumbnailMedia.uploadedAt`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`file_name` as `solid_pv_product_embedded_video_media.thumbnailMedia.fileName`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`file_size` as `solid_pv_product_embedded_video_media.thumbnailMedia.fileSize`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`media_type` as `solid_pv_product_embedded_video_media.thumbnailMedia.mediaTypeRaw`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`meta_data` as `solid_pv_product_embedded_video_media.thumbnailMedia.metaData`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`config` as `solid_pv_product_embedded_video_media.thumbnailMedia.config`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`path` as `solid_pv_product_embedded_video_media.thumbnailMedia.path`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`private` as `solid_pv_product_embedded_video_media.thumbnailMedia.private`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`thumbnails_ro` as `solid_pv_product_embedded_video_media.thumbnailMedia.thumbnailsRo`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`created_at` as `solid_pv_product_embedded_video_media.thumbnailMedia.createdAt`, `solid_pv_product_embedded_video_media.thumbnailMedia`.`updated_at` as `solid_pv_product_embedded_video_media.thumbnailMedia.updatedAt`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.title`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.title` as `solid_pv_product_embedded_video_media.thumbnailMedia.title`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.alt`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.alt` as `solid_pv_product_embedded_video_media.thumbnailMedia.alt`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.customFields`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation.customFields` as `solid_pv_product_embedded_video_media.thumbnailMedia.customFields`, `solid_pv_product_embedded_video_media`.`created_at` as `solid_pv_product_embedded_video_media.createdAt`, `solid_pv_product_embedded_video_media`.`updated_at` as `solid_pv_product_embedded_video_media.updatedAt` FROM `solid_pv_product_embedded_video_media` LEFT JOIN `media` `solid_pv_product_embedded_video_media.thumbnailMedia` ON `solid_pv_product_embedded_video_media`.`thumbnail_media_id` = `solid_pv_product_embedded_video_media.thumbnailMedia`.`id` LEFT JOIN (SELECT `solid_pv_product_embedded_video_media.thumbnailMedia.translation`.`media_id`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation`.`alt` as `solid_pv_product_embedded_video_media.thumbnailMedia.translation.alt`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation`.`title` as `solid_pv_product_embedded_video_media.thumbnailMedia.translation.title`, `solid_pv_product_embedded_video_media.thumbnailMedia.translation`.`custom_fields` as `solid_pv_product_embedded_video_media.thumbnailMedia.translation.customFields` FROM `media_translation` `solid_pv_product_embedded_video_media.thumbnailMedia.translation` WHERE `solid_pv_product_embedded_video_media.thumbnailMedia.translation`.`language_id` = ?) `solid_pv_product_embedded_video_media.thumbnailMedia.media_translation` ON `solid_pv_product_embedded_video_media.thumbnailMedia.media_translation`.`media_id` = `solid_pv_product_embedded_video_media.thumbnailMedia`.`id` WHERE (`solid_pv_product_embedded_video_media`.`product_id` = ?)
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01\x0EÀŸïq[¶%»Y,]dÓ"
]
1.00 ms
(5.52%)
1
# breadcrumb-extension::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?, ?, ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"¤ë¨[\x19OHB•áÛ6„‡Ù˜"
  b"TËõ||„Ar‘¾tâ\r3™#"
  b"""
    Sñ╣╝£üB\x1Dá╔=\x1D­Ë\n
    \x05
    """
]
0.78 ms
(4.28%)
1
# seo-url::resolve
SELECT id, path_info pathInfo, is_canonical isCanonical, sales_channel_id salesChannelId FROM seo_url WHERE (language_id = ?) AND ((sales_channel_id = ? OR sales_channel_id IS NULL)) AND ((seo_path_info = ? OR seo_path_info = ?))
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"õ½iA_mMÇ’\x18}2m}”M"
  "ayrton-mistral-s/11240"
  "ayrton-mistral-s/11240/"
]
0.75 ms
(4.14%)
1
SELECT LOWER(HEX(`sas_blog_entries.assignedProducts.mapping`.`product_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`sas_blog_entries.assignedProducts.mapping`.`sas_blog_entries_id`))  ORDER BY `sas_blog_entries`.`published_at` DESC) as `value` FROM `sas_blog_entries` LEFT JOIN `sas_blog_product` `sas_blog_entries.assignedProducts.mapping` ON `sas_blog_entries.assignedProducts.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.id WHERE ((`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?))) AND (`sas_blog_entries.assignedProducts.mapping`.`product_id` IN (?)) GROUP BY `sas_blog_entries.assignedProducts.mapping`.`product_id`
Parameters:
[
  true
  "2025-05-15T03:42:53+00:00"
  b"\x01\x0EÀŸïq[¶%»Y,]dÓ"
]
0.57 ms
(3.14%)
1
SELECT `seo_path_info` AS seoPathInfo, `language_id` AS languageId
            FROM `seo_url`
            WHERE `path_info` = ? AND `is_canonical` = 1 AND
                  `sales_channel_id` = ? AND `language_id` IN (?, ?)
Parameters:
[
  "/detail/01910ec09fef715bb625bb592c5d64d3"
  b"õ½iA_mMÇ’\x18}2m}”M"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
]
0.51 ms
(2.78%)
1
SELECT path FROM category WHERE id = ?
Parameters:
[
  b"""
    Sñ╣╝£üB\x1Dá╔=\x1D­Ë\n
    \x05
    """
]
0.45 ms
(2.46%)
1
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters:
[
  "m1XacJjjYuR1s0r8ewhfj1EATD9XvHxw"
]
0.40 ms
(2.20%)
1
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters:
[
  b"õ½iA_mMÇ’\x18}2m}”M"
  "m1XacJjjYuR1s0r8ewhfj1EATD9XvHxw"
]
0.35 ms
(1.94%)
1
SELECT `ww_dry_hire`.`id` FROM `ww_dry_hire` WHERE (`ww_dry_hire`.`product_id` = ?)
Parameters:
[
  b"\x01\x0EÀŸïq[¶%»Y,]dÓ"
]
0.33 ms
(1.82%)
2
SELECT `key`, `value` FROM `app_config`
Parameters:
[]
0.25 ms
(1.39%)
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.21 ms
(1.13%)
1
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"""
    \x01‘x•'òra‰™Ù$ÜÎ\n
    ë
    """
  b"p\fÆ©uðEe”á¥TvÙ\x0F\x0E"
  b"\x12Ù×>ºI\x04·GïÞï\r\x1C®"
  b"×?Û\x13r\x19ByürHÕNC`\n"
  b"º\x13gÔ€±K˜±´Ö½åü‰æ"
  b"\x01ô\x00ÆþH{ñü6Amj\rLÿ"
  b"…Ì\x13AƒÓI†¤–Iî<\x13"
]
0.16 ms
(0.90%)
1
SELECT `sales_channel_country`.`sales_channel_id`, `sales_channel_country`.`country_id` FROM `sales_channel_country` WHERE (`sales_channel_country`.`sales_channel_id` = ? AND `sales_channel_country`.`country_id` = ?)
Parameters:
[
  b"õ½iA_mMÇ’\x18}2m}”M"
  b"q\x01œ¾ \x07Hȇ9\x04[\x05‹§\x01"
]
0.16 ms
(0.86%)
1
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters:
[]
0.15 ms
(0.82%)
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.14 ms
(0.78%)
1
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters:
[
  "de-DE"
]
0.14 ms
(0.75%)
1
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters:
[]
0.12 ms
(0.68%)
1
# sales-channel::load-analytics::read
SELECT `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` FROM `sales_channel_analytics` WHERE `sales_channel_analytics`.`id` IN (?)
Parameters:
[
  b"\x01‘×jk\x11z\x12½€à\x1E\x1Ee\x18%"
]
0.09 ms
(0.51%)
1
SELECT `domain`.`language_id` AS languageId,
                          `domain`.`id` AS id,
                          `domain`.`url` AS url,
                          `domain`.`hreflang_use_only_locale` AS onlyLocale,
                          `locale`.`code` AS locale
            FROM `sales_channel_domain` AS `domain`
            INNER JOIN `language` ON `language`.`id` = `domain`.`language_id`
            INNER JOIN `locale` ON `locale`.`id` = `language`.`locale_id`
            WHERE `domain`.`sales_channel_id` = ?
Parameters:
[
  b"õ½iA_mMÇ’\x18}2m}”M"
]
0.08 ms
(0.47%)
1
SELECT active FROM `app` WHERE name = ?
Parameters:
[
  "ReqserApp"
]
0.08 ms
(0.45%)
1
SELECT min_search_length FROM product_search_config WHERE language_id = ?
Parameters:
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
0.06 ms
(0.32%)
1
SELECT custom_entity.name, custom_entity.fields, custom_entity.flags
                FROM custom_entity
                    LEFT JOIN app ON app.id = custom_entity.app_id
                WHERE (custom_entity.app_id IS NULL OR app.active = 1) AND custom_entity.deleted_at IS NULL;
Parameters:
[]

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.