GET https://shop.devmsa.sharpness.de/navigation/9d2b0fec9ebf49feb299f3060de6a174?p=52

Response
200 OK
IP
216.73.216.157
Profiled on
Token
9f7909

Query Metrics

45 Database Queries
44 Different statements
262.96 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
132.30 ms
(50.31%) 		1 
-- product-listing-route::loading::association::prices::read
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`created_at` as `product_price.createdAt`, `product_price`.`updated_at` as `product_price.updatedAt` FROM `product_price` WHERE (`product_price`.`version_id` = ?) AND (((`product_price`.`product_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x046²zß9K\x00—H€ex¾¹§"
  b"\x06¬\x05¶¦@@µžda[S2"
  b"\f©ËS\x17A\x1D€H\x17[ž9–1"
  b"\x14ƒzy±pAÁ¢\x07göÑ™ø\n"
  b"\x16TÀZ4\x00H1— Ù\R;•\x11"
  b"\e\x00LeùŸNÅ»”Jær\x154Ã"
  b"\e\x14å\t\x17\x10@\x01¸1»Š\t‚òv"
  b"\x1D4°hú[B|ƒª~N»û\x07É"
  b"<‡äÈX)Ep¶3ö\x12Wbp‘"
  b"Csþ\x08‘B3°Ý§äÑPºÎ"
  b"T\x1DÇT|ÈH| ÁuͧnLÙ"
  b"gÈ‚\x04\x1D¶Kí£­5\~Þ|$"
  b"iq7u:G\x03±í«’Oúy‚"
  b"|õH‹c…B=„•¨Ô¥Šª|"
  b"}ËïዱLyŽ=3:YÚ‘%"
  b"——ô ø1M›Ÿ\t°|ÑïGJ"
  b"­\x12&†\x0EîEÂ*v\x06Fä*\x12"
  b"¸˜U±<@L^º,B•\x02„d-"
  b"Ë\fZ\f²5I-¾¾eÿ\r ª¦"
  b"Òz\x00Ãs/GøŒƒZî>#&d"
  b"Õ›%¡s\x12Bx§û‚.\x04Sž\e"
  b"áÝp¶\esB\x0F‹—䈺ò»<"
  b"îÜ\x07\wtD8ªÖ˜\x01UÔV\x19"
  b"þA\tn‚I««F<s'ù\x17>"
]
View formatted query    View runnable query    Explain query    View query backtrace
68.98 ms
(26.23%) 		1 
-- product-listing-route::loading::read
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`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.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `product.manufacturer.translation.link`, `product.manufacturer.translation.link` as `product.manufacturer.link`, `product.manufacturer.translation.description`, `product.manufacturer.translation.description` as `product.manufacturer.description`, `product.manufacturer.translation.customFields`, `product.manufacturer.translation.customFields` as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `product_option` `product.options.mapping`
                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`file_hash` as `product.cover.media.fileHash`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `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.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 `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `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` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`link` as `product.manufacturer.translation.link`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x06¬\x05¶¦@@µžda[S2"
  b"áÝp¶\esB\x0F‹—䈺ò»<"
  b"­\x12&†\x0EîEÂ*v\x06Fä*\x12"
  b"\x14ƒzy±pAÁ¢\x07göÑ™ø\n"
  b"——ô ø1M›Ÿ\t°|ÑïGJ"
  b"|õH‹c…B=„•¨Ô¥Šª|"
  b"\e\x14å\t\x17\x10@\x01¸1»Š\t‚òv"
  b"\x1D4°hú[B|ƒª~N»û\x07É"
  b"Ë\fZ\f²5I-¾¾eÿ\r ª¦"
  b"gÈ‚\x04\x1D¶Kí£­5\~Þ|$"
  b"iq7u:G\x03±í«’Oúy‚"
  b"\x046²zß9K\x00—H€ex¾¹§"
  b"Òz\x00Ãs/GøŒƒZî>#&d"
  b"þA\tn‚I««F<s'ù\x17>"
  b"Csþ\x08‘B3°Ý§äÑPºÎ"
  b"îÜ\x07\wtD8ªÖ˜\x01UÔV\x19"
  b"}ËïዱLyŽ=3:YÚ‘%"
  b"T\x1DÇT|ÈH| ÁuͧnLÙ"
  b"\x16TÀZ4\x00H1— Ù\R;•\x11"
  b"Õ›%¡s\x12Bx§û‚.\x04Sž\e"
  b"\e\x00LeùŸNÅ»”Jær\x154Ã"
  b"\f©ËS\x17A\x1D€H\x17[ž9–1"
  b"<‡äÈX)Ep¶3ö\x12Wbp‘"
  b"¸˜U±<@L^º,B•\x02„d-"
]
View formatted query    View runnable query    Explain query    View query backtrace
24.91 ms
(9.47%) 		1 
-- product-listing-route::loading::aggregation::properties
SELECT LOWER(HEX(`product.properties`.`id`)) as `properties.key`, COUNT(`product`.`id`) as `properties.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_property` `product.properties.mapping` ON `product`.`properties` = `product.properties.mapping`.`product_id`  AND `product`.`version_id` = `product.properties.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.properties` ON `product.properties.mapping`.`property_group_option_id` = `product.properties`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  true
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
11.03 ms
(4.19%) 		1 
-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MIN(`product`.`product_number`) ASC, MIN(`product`.`id`) ASC LIMIT 24 OFFSET 1224
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  true
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
7.19 ms
(2.73%) 		1 
SELECT COUNT(*) FROM (-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  true
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
6.17 ms
(2.35%) 		1 
-- product-listing-route::loading::aggregation::options
SELECT LOWER(HEX(`product.options`.`id`)) as `options.key`, COUNT(`product`.`id`) as `options.count` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id LEFT JOIN `product_category_tree` `product.categoriesRo.mapping` ON `product`.`id` = `product.categoriesRo.mapping`.`product_id`  AND `product`.`version_id` = `product.categoriesRo.mapping`.`product_version_id` LEFT JOIN `product_option` `product.options.mapping` ON `product`.`id` = `product.options.mapping`.`product_id`  AND `product`.`version_id` = `product.options.mapping`.`product_version_id` LEFT JOIN `category` `product.categoriesRo` ON `product.categoriesRo.mapping`.`category_id` = `product.categoriesRo`.`id`  AND `product.categoriesRo`.`version_id` = `product.categoriesRo.mapping`.`category_version_id` LEFT JOIN `property_group_option` `product.options` ON `product.options.mapping`.`property_group_option_id` = `product.options`.`id`  WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?) AND `product.categoriesRo`.`id` = ? AND NOT (`product`.`display_group` <=> ?) AND NOT (IFNULL(`product`.`is_closeout`, `product.parent`.`is_closeout`) <=> ? AND `product`.`available` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  true
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
  null
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
2.44 ms
(0.93%) 		1 
-- product-listing::property-filter::read
SELECT `property_group_option`.`id` as `property_group_option.id`, `property_group_option`.`property_group_id` as `property_group_option.groupId`, `property_group_option`.`color_hex_code` as `property_group_option.colorHexCode`, `property_group_option`.`media_id` as `property_group_option.mediaId`, `property_group_option`.`created_at` as `property_group_option.createdAt`, `property_group_option`.`updated_at` as `property_group_option.updatedAt`, `property_group_option.media`.`id` as `property_group_option.media.id`, `property_group_option.media`.`user_id` as `property_group_option.media.userId`, `property_group_option.media`.`media_folder_id` as `property_group_option.media.mediaFolderId`, `property_group_option.media`.`mime_type` as `property_group_option.media.mimeType`, `property_group_option.media`.`file_extension` as `property_group_option.media.fileExtension`, `property_group_option.media`.`uploaded_at` as `property_group_option.media.uploadedAt`, `property_group_option.media`.`file_name` as `property_group_option.media.fileName`, `property_group_option.media`.`file_size` as `property_group_option.media.fileSize`, `property_group_option.media`.`media_type` as `property_group_option.media.mediaTypeRaw`, `property_group_option.media`.`meta_data` as `property_group_option.media.metaData`, `property_group_option.media`.`config` as `property_group_option.media.config`, `property_group_option.media`.`path` as `property_group_option.media.path`, `property_group_option.media`.`private` as `property_group_option.media.private`, `property_group_option.media`.`thumbnails_ro` as `property_group_option.media.thumbnailsRo`, `property_group_option.media`.`file_hash` as `property_group_option.media.fileHash`, `property_group_option.media`.`created_at` as `property_group_option.media.createdAt`, `property_group_option.media`.`updated_at` as `property_group_option.media.updatedAt`, `property_group_option.media.translation.title`, `property_group_option.media.translation.title` as `property_group_option.media.title`, `property_group_option.media.translation.alt`, `property_group_option.media.translation.alt` as `property_group_option.media.alt`, `property_group_option.media.translation.customFields`, `property_group_option.media.translation.customFields` as `property_group_option.media.customFields`, `property_group_option.translation.name`, `property_group_option.translation.name` as `property_group_option.name`, `property_group_option.translation.position`, `property_group_option.translation.position` as `property_group_option.position`, `property_group_option.translation.customFields`, `property_group_option.translation.customFields` as `property_group_option.customFields` FROM `property_group_option` LEFT JOIN `media` `property_group_option.media` ON `property_group_option`.`media_id` = `property_group_option.media`.`id` LEFT JOIN (SELECT `property_group_option.translation`.`property_group_option_id`, `property_group_option.translation`.`name` as `property_group_option.translation.name`, `property_group_option.translation`.`position` as `property_group_option.translation.position`, `property_group_option.translation`.`custom_fields` as `property_group_option.translation.customFields` FROM `property_group_option_translation` `property_group_option.translation` WHERE `property_group_option.translation`.`language_id` = ?) `property_group_option.property_group_option_translation` ON `property_group_option.property_group_option_translation`.`property_group_option_id` = `property_group_option`.`id` LEFT JOIN (SELECT `property_group_option.media.translation`.`media_id`, `property_group_option.media.translation`.`alt` as `property_group_option.media.translation.alt`, `property_group_option.media.translation`.`title` as `property_group_option.media.translation.title`, `property_group_option.media.translation`.`custom_fields` as `property_group_option.media.translation.customFields` FROM `media_translation` `property_group_option.media.translation` WHERE `property_group_option.media.translation`.`language_id` = ?) `property_group_option.media.media_translation` ON `property_group_option.media.media_translation`.`media_id` = `property_group_option.media`.`id` WHERE `property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x00*êélQF¯³UÀŒ1\x1Fµ"
  b"\x00V\x10%\x1E"E{¾Ë#ìå´\f¢"
  b"\x00õn\x04„ÏEߝTxK\x17gLø"
  b"\x01\x0F+G™OŒº;ó+\x17¼åÖ"
  b"\x01CÁ\x00i€»\x15ˆ†éqJ,wF"
  b"\x01c´-Á\x04K\x0F¦K»\x08J0ü©"
  b"\x01~\x0F‹L{L…µrZ°Z_ɘ"
  b"\x02ˆzJnXCL§4•ò\x14’Ã"
  b"\x02¤öâÖ(E!¢\x19\x17¢"\x18—M"
  b"\x02´Rÿ-7\x05$cUÀ/\x15(Pø"
  b"\x03$\x7F\x13\rÝN$¾3¹‘Å£àý"
  b"\x03-=Á¿Ê$|slN\x0EÞT§i"
  b"\x034\x01þ\x02&A’¦-c£üG9Â"
  b"\x03wðqs\x1D4ƒ×xMñuA\x06-"
  b"\x03}¢Ó¿­KSž\x1DowTåØØ"
  b"\x03ðS”¼JE\x15­4È8^»\x19ª"
  b"\x03õF\x0F•SD²€ÔÇ\x1E&˜»Ë"
  b"\x04&|÷/¾I\x04“ˆÐO£p\x1F"
  b"\x04KZÅ\x15˜òMáì\x12`c\x1DXÝ"
  b"\x04¹\x19‡*<@MžD{v\x1Acð3"
  b"\x04¼r“ِOH™ ñ9gÿIò"
  b"\x05±"\x11E«M‚fµ±\x10×'a"
  b"\x05âwyӝJí¨™ïÒ·$•G"
  b"\x06\x1C\x02 Ó<@E»—Y`-·ö¤"
  b"\x0684zŸ‚IŽ¾ýÒµðXDT"
  b"\x06é*¾EKM¾`£¥"‰¾"
  b"\x06ê¦\x15\x0F¢B\x1E‚ñh—œÜâ"
  b"\x07BK\x1Cí¾/§\x053BØ>Wå\x18"
  b"\x07hôF(\eeUùš¯ñ^ÎRÚ"
  b"\x08\x12eŽK3H\x16¸0\x16zÀ_oz"
  b"\x08ʤw2œG莿\x1E\x13²\x18‹°"
  b"\x08éq;ÑAEw¹rc\vfÈèß"
  b"\tí¸žH\vNõ…\x15¯år®[Â"
  b"""
    \n
    WþûØ\eMƒ\x06Ä‚ñ{xA
    """
  b"""
    \n
    ­1Ž¨:IŁW®%ÔƒøÆ
    """
  b"\v$ ndÇJ¹·à%\x1E¬ˆü±"
  b"\vh"Ґ™ø•„@‘Ùõö¾~"
  b"\v’\t—Ö–\v³«ZlZ¯\x05t"
  b"\vÌš\e\x14A'Áí\x13ž†›ƒm"
  b"\võŸîeZK9¯qÉyÜ\x17P("
  b"\vù`@’×HÚ™\<<_—²Ë"
  b"\f9\e\x01ü*J\x03¨º\x13§¥•Ø·"
  b"\r++!Ã7òa\x16(å"âÈ#‚"
  b"\rɧoˆ«\x15\x0FêO¥ÎPÌBH"
  b"\rÚ\x02©<ÿ$$•\rñ{\x1ESÛ"
  b"\x0E]Ã\x13I\x07Hà‚1\x1F)ÿ*¾!"
  b"\x0E…H\x0E0ŽM+¤A\x18(ŽŒa\x12"
  b"\x0EÚñÛ\x14„F‰Ž;™tl\x0Eà"
  b"\x10†áÁÖðEA´CÍZ¸%¿c"
  b"\x10Ä°.èþCÉ„QÛ¡O\x16Jr"
  b"\x10ÚtŸœé¼5:ˆUü!4\x1F­"
  b"\x10Ý*À‘ñ§šQ[ì!/_ªò"
  b"\x11IAç"FG¢®µÈ}ú¢\x01Ÿ"
  b"\x11š°A–ø@¾JmÐ(Ž“F"
  b"\x11\vm\x03!Hj”3,\x01Ó•úÚ"
  b"\x13.\x07\x16Òý°J™‰\x16>Dâ×X"
  b"\x132\x18ËÏH-þû\x18ø¤Bb"
  b"\x13ww²;o.9çÒ;ÀÙÕû"
  b"\x14£§†…5BÓ™’ßsì\v8â"
  b"\x15\x13Á{ÞsW@\x1E\x04þv¹¨3Ø"
  b"\x15…\x18\x18\x13&Ь”\x04^zEÝï<"
  b"\x15ÜÆ\x14~gK{‘mUaî˜\x15ƒ"
  b"\x15éñîêc'¿Ä\x13ˆ@Ü[Î)"
  b"\x16xàGCù6¡Lš\x04åñ‚Žô"
  b"\x17\x17ÈbJvF쏩¥ŠW\x19¦y"
  b"\x17Ƽv…ôò \x19¯ðP\x0EŸŒ'"
  b"""
    \x17Í‹Î\n
    ŽOñŠNY&ê¢![
    """
  b"\x17õ\x05´38ÓŸwì\x01ãš‹\x06ƒ"
  b"\x18\x1Ew[\x1D5\x10OTUW¤\x17\x19N~"
  b"\x19:Ùì\x07\x02Mý¢.Ø_è™\e°"
  b"\x1A\e£¼†ÊMû‰b\x1FÄ•\x1AZ×"
  b"\eŽ×\x00\x1EÓD‰ªåÈ:\x02\x15@°"
  b"\x1C\t‘çôHF]»\x02W©©}\x0Eä"
  b"\x1CgfF²9\ý6þê›0udÏ"
  b"\x1C÷$‘%êF\x15Žìis2e6"
  b"\x1D\x06ŠìÐ\x01B\r‰{ô×)‹ÒP"
  b"\x1D§\x00éÛá\x172[W\x04»V\x05«¦"
  b"""
    \x1E?ße3É\n
    ø\x0E΋§‘¿fÎ
    """
  b"\x1E^¸G@?A]ŽTŒ'O¸áØ"
  b"\x1Eõ×ØÌÑF¼‚\x17¯Y¾ÔŠ"
  b"\x1F§(\f1†JŸ¿CV0\x0Fà®s"
  b"\x1F÷\x1Df´¥Kk«ª6š\x14\x0E…\x1A"
  b"!nÒLÒ\x01¾¤Q\x1ARßœ\x13\x05y"
  b"!Ÿþ/I³G\x1C‚”OL`\v¿á"
  b""P9\x19ÉŠFJ®m3²+馎"
  b"""
    "öN\n
    }\eJ†¶W°ú…CE–
    """
  b"#išÂÆWD䄵᪴϶“"
  b"#Åv.D°Dš²Š\fb+f~P"
  b"$\x03†'Œö_ÑOxYˆ(ZbŒ"
  b"$JHÙ9û@´€¹÷¶ÂÇŠO"
  b"$\x7F›¡pCk\r€Ý\x1FÎ\x06¥û_"
  b"""
    %o\x05J{JM\x06®¯,Ih¬\n
    Ï
    """
  b"&\x01Ÿ“ÈÞ%I¬`¾ãŒàn®"
  b"&\x18\x12_ Ž\x12¤Ðdv.ßÖt»"
  b"&æAäÑGF;šè5§‘i:É"
  b"&ýÎæ›wKh[#\t>óè7"
  b"'e!áÀEA¡¿Ä9U/MŽ–"
  b"'¬&\x04<öGÂœå÷‰GЉ\e"
  b"(\x11µõõXõ¡\x0Fw\fŽ¥cÎ#"
  b"((K.Lj\x13?‚Oó!SàBÉ"
  b"( åÉ=àI§R}\x1Fû•7\f"
  b")\x1FL÷øGB©˜€† E\x11|"
  b")`).m<K‡ÓÐ¥B/ž\x04"
  b"){þUM\x10K\x1A‘ Õ\x00\x05+Ëç"
  b",\x0Eb\x15éC\¯ú›«X:‰ð"
  b"-\x17LlÒ\x1A@ӏæ qZÏœÞ"
  b"-?\x1C\x100ãLó¼÷û–ê\x03Õ,"
  b"-Sn¹:4ê™ØÛá\x1CúÕz"
  b"/ßH\x07fé¥\x0Fëíÿ»ì/F"
  b"0W:ð9}I\‹t—C_\x02øÙ"
  b"0o]ÕL'ÚÍ=¡´l\v·Ó€"
  b"0ùš•—lE\x1F‰\x03smk÷`1"
  b"2T‡\x13\x0FyA Œ\rÔŒ¯î×+"
  b"2û)ß ï…W=~!\x14 W·ñ"
  b"2ÿ\x0F\rŒŽK»©.žÚ(—¬&"
  b"3ɪq”õI\r¥ß‚ó_0›:"
  b"3úRåý¢Jq·r4á$˜4d"
  b"4d\e\x00à¸Lì¾;ð_˜-³m"
  b"6¥š7uaë+_¦ls‰w„\x00"
  b"9ìm«ŽF=ŒÚ\x0FøŸ:äŠ"
  b":죑\x11ûºÙK’UEË˳Æ"
  b";\vµN¼\x15Z?·-\x04\x06^î\x1At"
  b"<¶RÎl=Hu“v-…êš±…"
  b"=bqêŠØ\x12+}?Ò& —à|"
  b">:3ìfõr>Îݶv\x1A_R"
  b"?ŽEÇQè\x1C«Ð’JEºü8ì"
  b"?Ø‚–»˜ÕTWÉÿ\x1FΈH¯"
  b"@'þË×èEуfnãsØM\r"
  b"AÖHu(£ÅظGÅ~d!²"
  b"B\x0EϏÜΐHÔF_É5\x12§\e"
  b"C\x1F\x1A<ïCE-©|H‚2gúL"
  b"CÌ5è\x06>H\x19œ81Qj\x1F¿—"
  b"DœW’/AFcªÜ©\x17\x1D<\t"
  b"Dóf*{J·kcä@1º\x14\x06m"
  b"E³L¤-¢K\x0E»  +N\x03B$"
  b"F‹ï\Šæ\x02G¾5ë\x17à €æ"
  b"F¼^”ÓÒ†‹X=ÕœJSæÌ"
  b"GÞ˜‹EP\rz\x06W\x03H0¹Ç"
  b"IŸœÒ‘Hº¿ÖŠTŸe¤Î"
  b"JÝÜ<ù…F\x01†çh S¸úª"
  b"KГ\e5‚ÊÉ—Ó‘\x1F–.°"
  b"LځïþªL{ªE½'[.R“"
  b"M5x\x04{\tN·ªÈ#m!9Üy"
  b"M¯\x14«P,ãÀ¦\x03Oy\v´©È"
  b"MÔ‘Í\x10õH‡ŽM˜os᪊"
  b"NX*q\x14;úÄN„XŽ”·¢P"
  b"OÕ\x1D°3«Ki™\x08Þ\x1DùÛê="
  b"PGY†?Ú_Ó1ôŽáãµzv"
  b"Q9O\x0E\x08sD\x06¸—á†íÁ/z"
  b"Q:éÕ\x1C¿®Zž±½\x07ëeW"
  b"R)›\x01YÖD\x02„¦\x03èæË¢Ì"
  b"""
    Tù8yKO\n
    ”g·æs”Ýs
    """
  b"UsCè(iÅ#æåÃ'B\x17Ö="
  b"U²w}Ù£OÈšÆN\x0F\x03&+o"
  b"U¹•\x7F-]EÀ™\x1D¹\x12ÖnO\x7F"
  b"VcÐö³oMR£Ã½ <\v\x1Eé"
  b"W—Ýc@\x17\x11Æ\x1CªÔˆëAQ\x15"
  b"WíU§ýpK<¶ä²QŽ\x12]\x12"
  b"XÓmŽÿÃÙ'—HÄ¥¹…§n"
  b"Y\fF®SE\x05¥9W0ç7ô"
  b"Z]íý`ãÛ·®Ð\x0F\x10ž‡®\v"
  b"\q\x1Cä\>BC…Ó\x0EÁÙx]T"
  b"\ÀF£\x03AHî¡Ê•\x03¡ð,¾"
  b"]G\x07(DO‹ŒÀ3è¼ÄÆX"
  b"] bm\rž\f7rUÿ·_°“0"
  b"^ÈÀĺZOc¸œ©-¬ËÇÈ"
  b"`|\x1FèäkG§ŠëÔV#›È\x14"
  b"`“F$>¥š°\x0Eí$}?{ ¶"
  b"`™¢NædN§°Giá`'¶."
  b"a\x18"\x14N‡CnX™Ñ14â÷"
  b"b-K\x16}*ñgÅ™etwꯜ"
  b"eýáu‚<G„¢2.8SƤO"
  b"fɉÂO\rEPfˆ\x05ž¥\e\r\x06"
  b"fÕ5\x15/;MþŽ›7\x0FæÉH»"
  b"g¿”§0âA\x07–ë\x17ˆˆÅ};"
  b"jêT'i:éøµÉŽGAe£j"
  b"k{)?H[NŒŽGy\x00Þ\vÍ"
  b"l"Óü5ÚKt‘ò6Ÿ\*\x17ü"
  b"m\eÚÐeÍEÔ´_žš†ÙÓh"
  b"m:+·Z\x07Er•\r\x18\x10/è!¤"
  b"m„¨–ü)LE´ˆºSIcYh"
  b"nžÈ\x03bœ:êÀúÀ¨Ñµ\x083"
  b"p(¡º\x19àC`Š\x19¸¶9ª`ã"
  b"pÞš\x11:cD\x13¤\x1Fò\v¢y=Î"
  b"q„âLçÏb‚wÿwô=`Â\x1F"
  b"q”ïIå'D´£_hº”-\x04P"
  b"r\x04ˆb¥¯At£3tˆRcí\x15"
  b"""
    r7fCïW\x7F\n
    =ðbèq{¨Ä
    """
  b"s\v÷ë§×Bnˆ\x7F\x129ů\vŠ"
  b"sE\x19øÆ+Jþ¼0\x18Ô|«jµ"
  b"t\x06dêr&LH‹$\x116š¸ˆ—"
  b"t&¯ZT\v\x05Ù¾µoøHà"
  b"uÈÍ\x07ÁbDú‚yˆcâyéî"
  b"vsE~]\tIß‹¯ía<$x]"
  b"vË\x10G†eG§´ \x13Ïù|\x01/"
  b"w[àa>VN\x7FªM#Æ™ï‹"
  b"xÏO\x7F¸l¯ \r}u\x16\x1E\x10Ñ\x07"
  b"xÜ\x17\x00*\x1DBÝ€k\x06C'QÏó"
  b"|„IþzÓÿµo\x1DIÖ\x10sç""
  b"|À¸*µeþ3\x19$\e‹\x1C²He"
  b"}=é\x056\eKó‡»ÚÔwÔ€\t"
  b"}r¿xØáNHº#øÍÀÍåZ"
  b"~S\f’b_Nß±\eh÷\rGcÇ"
  b"~Ægõojî\x11»\x00@Å_Ýù#"
  b"\x7F¡a…‰‡î\x19<‹\x11M\x10Q~\x16"
  b"€ÖÍ””eC ¢ŸNu¦Õ/"
  b"‚h´xúOÑ·ÿg¤\vÇZ€"
  b"ƒXmpúeývô)ÀóŠ3ö”"
  b"ƒ­\x04X½[HÌ›‘Ñò\x10\x07ýZ"
  b"„U~ߎcBÒÅÅ¡^\rK±"
  b"""
    „÷=„$ØN\x1F¼KE\n
    \f\x1F{È
    """
  b"…\x05\x15¸âàDR½\x02Ý8ƒ<–¡"
  b"…\tz\x0F\x17‘‹Y&­Ý·‹Þö¡"
  b"…RA&ºUj¹ƒôðA© ´¼"
  b"…n5ÚÏÍFð§ÆéþLc2z"
  b"†\x13\x00÷/B|›`¸ø Î\x1C"
  b"‡_Óú¶ÃB³¡Â¢0é¯ï©"
  b"ˆ¿ð@m;I¸aˆUòŠ’C"
  b"‰\ubíîC•\x04H­o\ry"
  b"‹45m\eÕDÙ˜‡ãké\v¸\x04"
  b"‹žàbÂûE⣉\eéÅsQq"
  b"‹²¬9ÖU⡽’=Fjí«"
  b"Œ\x06’ã†;þ^\x00‚¬Âûêñ["
  b"""
    Œ@O¯åŽE¡Ô\n
    Óa,Æ\t
    """
  b"Œqéó\x0003¯"®W \t¦Êi"
  b"Œí5Ú5úC9†õÎ\x01\x072/h"
  b"Ž@žÂ\x02ÑBt¢z3Ÿ\x1A™Ê+"
  b"Ž|á/#{¥i¤‚“­ü\x0F¿¿"
  b"Žðjg[õKõ·Hâ»Õò\x16\x16"
  b"\x08ƒ‚æÎÄÑ&U\x7F\tu«\x04L"
  b"Ê\x1Cú~…I\t†nuãíú\t“"
  b"èÏá­(J\x19œ!\vùÁmƒS"
  b"“³W} ­J{®‹\x05¿ýîÑ"
  b"""
    “ÖC\n
    ëí\n
    ŒTÈfň\t—\x1E
    """
  b"”yÒ:Ü\x7FMŠžýLÉ»Cn\x00"
  b"•¡\vŸÿ]íÔ•ëö²ÁŽ=Ñ"
  b"–K\x0E\x07_‹Ñ@ÍŽO>Žá\x02_"
  b"—VÆ4ÖjM”¦Öúñá\x11Ñè"
  b"˜ëÏèŽÜǸ•i8\x1CŸ¬!x"
  b"™??7³±N«‚•†\x1EßÝýš"
  b"™X\x14k™£H\x12°uñà\x11Ôp&"
  b"™ypð€‰J\•Nû-HÎX6"
  b"›\x12ªÔ´ˆHYµëƒ\x14âî\t´"
  b"›@½Ž%\x07@¨ŽŽÌþ\rDa3"
  b"›I‰ék¸I띩u$EÕà)"
  b"›vj»£\e»)\x1Aîò\x18bEõ¯"
  b"Ž\x02ÆH¡\x08#ä5æÃ2k¸"
  b"žd;Æ"pB°\x00¾\x1FÕ\x06B£¦"
  b"Ÿ\x12­OüÎkD¹¡­\x1E\væDª"
  b"ŸÄ†19ÇI©–ŽŸG=\x17#º"
  b"¡µ@ôú\x16rð•cîma´\x12,"
  b"¢ñš(õ4¾ì*‘¾BÏÛ'"
  b"£¶9]I\x14B?‡þ–õYBao"
  b"¤,²nO¡~%æ@Š\x01í\x0FÞw"
  b"¤pMã3…ax^¬\x07^7ž"
  b"¤Ý4ÐÆ•Hƒ‰ï«cTÄ!ö"
  b"¥\Šœ\x1AâÙ_=ƒ$aL\x0F"
  b"¦\x10µéÚŠKŸdJPßÔC@-"
  b"¦+Ã\x7FuM‹º½­\x14ÄçãÚ"
  b"§úx9¦EKQ“Wò\x16ý\x00ŒW"
  b"©,’\x061I-©J–¡@é¶\x13"
  b"©x¬§éAþø0†Å,±à\x08é"
  b"©Â[ËÙ·1 >ÀÂR\x03¢*‡"
  b"©ìíÓéÚ2Ôê\x1D6CXy‚é"
  b"ªŸ_m‡VÝŽË\x1Aém5\e\x1D"
  b"¬ñ¼\x0EÖ\x03D\x02“Þ®±s‰Žq"
  b"®\x18\e^MÐyýÎË€gnp\x13é"
  b"®;\x01ÒŒŸŽ×…‡\x17R¯Šcƒ"
  b"¯P¹pzÒ@Ö®óçe×7\x1E*"
  b"¯z•¥œ\x08Ÿ\r‹’ùñŽ\rÆP"
  b"²?”€%TI¥¿¹?=L‰¡ø"
  b"²‚´óóñEi”×Y¶ôÁm)"
  b"´v®z³[F\x13†²óøkyŒÉ"
  b"´Â„p†FD5¯hÎÂWn*D"
  b"µæ´ÝY9mŽ½›·7>\x08#"
  b"""
    \x07ë\n
    æâ8Z.y\x11ùÇÕv[
    """
  b"·NOŒyï=å\x16èCèƒ\x120ó"
  b"·Ç”z‚MK–ÃÇnjŸv"
  b"·£Ý|ö9BX üînèùð<"
  b"·ÇÙv¡ÚFdÅƇº´ö\e"
  b"¹\x7F+=8d†³à9¼:ó,*"
  b"¹•”Q\x00“H4„Jq\x03Ü\f£€"
  b"¹æ×Ûç®BË¡x¥Îö'rD"
  b"º7Ù_\x03\x15è„dr'–þ­Èâ"
  b"ºí@PÓ¶D2±¶ð¼Ô\x0FÅ\x07"
  b"¼»ýè™ZE"¸bÓÕY>Œ×"
  b"¼Ù 4!…CO„î¹0詯9"
  b"¾'øLP\x04m8Ã\x00æêýGÔ\"
  b"¾G\x1EŽ\x1FèG¿¢ëœK\x03\x0EÓ©"
  b"ÁTQ&ºb×>*ã\x04Œt蘊"
  b"•¾•úîMY©§Ÿy\eVº"
  b"ø9Ÿ¾\x16K—’µ¬ö[È’U"
  b"Ä\x14Ie²\x19\f0®Û@*u)ë""
  b"Å\x1FñS\x04\e{ÛI†–´x˜jx"
  b"Ç\x0E\x7F\x00èçKv—(\rô\x17@Ÿ\x10"
  b"È­æðQáãø‹¸øÞ«8Ö«"
  b"ɺý\x0E¾Öþœ5$“ÑåŒT„"
  b"Ëâi¾í\Mʪg“¨a\x04…>"
  b"Ëéðî\x1A@\x00ÁÈü=„˜ÿÓW"
  b"̰꤅¼3¡‚z7J/\x04¥"
  b"ε\e±‚£A/âêWâ(Ô\x08"
  b"Îÿz¼\x01+=v\x07\x06Ó0/\x1CD3"
  b"Ñ/`\x02ðxH\‰<\x163P¬µ"
  b"ÒgäY)¦K9²‘Ä]ù\x06\v›"
  b"ÓV\x06\x14UlNš¥óûdiÂòá"
  b"Ô†h–"†J°Ã0¶±peÌ"
  b"ØÐU\x19˜(Cl¦\¢\x1Eû™Ö+"
  b"ÙUÏïTš\x10…\x14þÊ‚?¦j\x01"
  b"Ù¶ª:A\x15F\x1C¿\x11ÖÅmö\f"
  b"Ú\x7FÒŽ\vbGǬq¯yÂ\x1E3¼"
  b"ڝèn—­ó\x0F\e)¼)cë"
  b"܇¤ÉHÑVÕÏø\x16·Ì\x17}\v"
  b"ÞšÅë_à>T?MÍ;B>\x11ˆ"
  b"ßa\x04ˆ¡·qnà\x1C'¿ŒÉ\x11ª"
  b"ßo\x7FƒpŒ@#¤òE2Ü™ªà"
  b"à\x18röÛÄKx\x01ö X\x1Ar\x7F"
  b"ઐ×\x07Ø@ìrµI.\x10\x0E^"
  b"àÛ¬: ÀL¦†tJOÐA\rÄ"
  b"""
    á’\x06mº•K\n
    ¬\x14lžÆOEâ
    """
  b"âî#\x1AÙÁ€NÏ:PŠ6‹ÓJ"
  b"äX_:ƒGCF‚ëV1Wó\x18\x1C"
  b"æ\x7F\x19?ÑôFà©\x16;†NU."
  b"çó¿„@*ÂúJzHh¾sá"
  b"é÷Æ\x01z8¨\f»GQŒÌex¬"
  b"ëÃÅ&±cFO£IgöHQ\x08Ý"
  b"ìõ\vU\t'?­ol”\x15.lSž"
  b"í*§±dODx‡‘\x1D+‹Ú[¾"
  b"îîƬÎ,ïÂ[²UÖ"H"
  b"ðÑŸ© •Dvœ\x0F \tŽüyË"
  b"ò\x1CŽIn\x0E*Â\x1Aj«n\x19¹d§"
  b"òçÁgzŽrÿ\x07ëQ­ÔáW£"
  b"óü‚\x12µµªï[ì\x16\x06e˜\x19í"
  b"ôuã¼1‡vQ²Þ\x15èÞš\x17"
  b"ôâÅxIZWZ–\x7FGêgüY­"
  b"õÚ6ÅÉcOíýÀF……Ææ"
  b"ö‘o\x1D|>„²¤ö\x124•†\x7FÙ"
  b"öä•\x15êßM蝄jdÔBÞ;"
  b"÷D$2Q»(]\x18`&Ž\x1E¯+ä"
  b"÷\p·Ø©k,~\x13¨žQX2,"
  b"÷èÐcLãÜy!\x1EL@I\x13ø"
  b"ú#\e+—-E~\x075zT¦\x03*"
  b"ú…K¤\x01@@ª"ÞàûC>"
  b"ú¢\x03¼ÃpK`’ìh„4Ï^ˆ"
  b"ú¸ïÒƒàDû®om\x0FîZKð"
  b"úé=Y¦½MfµœÑy$§çÛ"
  b"û\x15é\x12ÃS>|\x06yÔ‹\x7Fdœ"
  b"ý}òä—×ELº´C¤íë¶""
  b"ý‰‰Ø·²Eõ§ÄÀ‰óáŁ"
  b"ÿ\x18\x7FIΦzô–ªcuÖŒ.&"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.84 ms
(0.70%) 		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/9d2b0fec9ebf49feb299f3060de6a174"
  "/navigation/c3057bb031634c669cd6dfb0d4acbb15"
  "/navigation/19ca405790ff4f07aac8c599d4317868"
  "/navigation/48f97f432fd041388b2630184139cf0e"
  "/navigation/bb22b05bff9140f3808b1cff975b75eb"
  "/navigation/06f5dda360c04112937601574122c515"
  "/navigation/9350ecd5bd6e4f85b7a14c85c0c3b31e"
  "/navigation/4aafda73311b49f5b9d06888f2608c18"
  "/navigation/7f29e74723ac457ea8c30ae0c3b2f598"
  "/navigation/e379fcc096f343568dcb1e294d45c931"
  "/detail/06ac05b6a64040b59e9d64615b533281"
  "/detail/e1dd70b61b73420f8b97e488baf2bb3c"
  "/detail/ad1226860eee45c3822a760646e42a12"
  "/detail/14837a79b17041c1a20767f6d199f80a"
  "/detail/9797f4a0f8314d9b9f09b07cd1ef474a"
  "/detail/7cf5488b6385423d8495a8d4a58aaa7c"
  "/detail/1b14e50917104001b831bb8a0982f276"
  "/detail/1d34b068fa5b427c83aa7e4ebbfb07c9"
  "/detail/cb0c5a0cb235492dbebe65ff0da0aaa6"
  "/detail/67c882041db64beda3ad355c7ede7c24"
  "/detail/697137753a814703b1edab924ffa7982"
  "/detail/0436b27adf394b009748806578beb9a7"
  "/detail/d27a00c3732f47f88c835aee3e232664"
  "/detail/fe41096ec28249abab463c7327f9173e"
  "/detail/4373fe089d914233b0dda7e4d150bace"
  "/detail/eedc075c77744438aad6980155d45619"
  "/detail/7dcbefe18bb14c798d3d333a59da9125"
  "/detail/541dc7547cc8487ca0c175cda76e4cd9"
  "/detail/1654c05a340048319720d95c523b9511"
  "/detail/d59b25a173124278a7fb822e04539e1b"
  "/detail/1b004c65f99f4ec5bb944ae6721534c3"
  "/detail/0ca9cb538117411d8048175b9e399631"
  "/detail/3c87e4c858294570b633f61257627091"
  "/detail/b89855b13c404c5eba2c42950284642d"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(0.23%) 		1 
-- product-listing-route::loading::search-ids
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  true
  b"\x06¬\x05¶¦@@µžda[S2"
  b"áÝp¶\esB\x0F‹—䈺ò»<"
  b"­\x12&†\x0EîEÂ*v\x06Fä*\x12"
  b"\x14ƒzy±pAÁ¢\x07göÑ™ø\n"
  b"——ô ø1M›Ÿ\t°|ÑïGJ"
  b"|õH‹c…B=„•¨Ô¥Šª|"
  b"\e\x14å\t\x17\x10@\x01¸1»Š\t‚òv"
  b"\x1D4°hú[B|ƒª~N»û\x07É"
  b"Ë\fZ\f²5I-¾¾eÿ\r ª¦"
  b"gÈ‚\x04\x1D¶Kí£­5\~Þ|$"
  b"iq7u:G\x03±í«’Oúy‚"
  b"\x046²zß9K\x00—H€ex¾¹§"
  b"Òz\x00Ãs/GøŒƒZî>#&d"
  b"þA\tn‚I««F<s'ù\x17>"
  b"Csþ\x08‘B3°Ý§äÑPºÎ"
  b"îÜ\x07\wtD8ªÖ˜\x01UÔV\x19"
  b"}ËïዱLyŽ=3:YÚ‘%"
  b"T\x1DÇT|ÈH| ÁuͧnLÙ"
  b"\x16TÀZ4\x00H1— Ù\R;•\x11"
  b"Õ›%¡s\x12Bx§û‚.\x04Sž\e"
  b"\e\x00LeùŸNÅ»”Jær\x154Ã"
  b"\f©ËS\x17A\x1D€H\x17[ž9–1"
  b"<‡äÈX)Ep¶3ö\x12Wbp‘"
  b"¸˜U±<@L^º,B•\x02„d-"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(0.19%) 		1 
-- category::data::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `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 `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`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` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` 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"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.18%) 		1 
# product-listing-loader::resolve-previews
            SELECT
                parent.variant_listing_config as variantListingConfig,
                LOWER(HEX(child.id)) as id,
                LOWER(HEX(parent.id)) as parentId
             FROM product as child
                INNER JOIN product as parent
                    ON parent.id = child.parent_id
                    AND parent.version_id = child.version_id
             WHERE child.version_id = ?
             AND child.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x06¬\x05¶¦@@µžda[S2"
  b"áÝp¶\esB\x0F‹—䈺ò»<"
  b"­\x12&†\x0EîEÂ*v\x06Fä*\x12"
  b"\x14ƒzy±pAÁ¢\x07göÑ™ø\n"
  b"——ô ø1M›Ÿ\t°|ÑïGJ"
  b"|õH‹c…B=„•¨Ô¥Šª|"
  b"\e\x14å\t\x17\x10@\x01¸1»Š\t‚òv"
  b"\x1D4°hú[B|ƒª~N»û\x07É"
  b"Ë\fZ\f²5I-¾¾eÿ\r ª¦"
  b"gÈ‚\x04\x1D¶Kí£­5\~Þ|$"
  b"iq7u:G\x03±í«’Oúy‚"
  b"\x046²zß9K\x00—H€ex¾¹§"
  b"Òz\x00Ãs/GøŒƒZî>#&d"
  b"þA\tn‚I««F<s'ù\x17>"
  b"Csþ\x08‘B3°Ý§äÑPºÎ"
  b"îÜ\x07\wtD8ªÖ˜\x01UÔV\x19"
  b"}ËïዱLyŽ=3:YÚ‘%"
  b"T\x1DÇT|ÈH| ÁuͧnLÙ"
  b"\x16TÀZ4\x00H1— Ù\R;•\x11"
  b"Õ›%¡s\x12Bx§û‚.\x04Sž\e"
  b"\e\x00LeùŸNÅ»”Jær\x154Ã"
  b"\f©ËS\x17A\x1D€H\x17[ž9–1"
  b"<‡äÈX)Ep¶3ö\x12Wbp‘"
  b"¸˜U±<@L^º,B•\x02„d-"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(0.17%) 		1 
-- product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `unit.translation.shortCode` as `unit.shortCode`, `unit.translation.name`, `unit.translation.name` as `unit.name`, `unit.translation.customFields`, `unit.translation.customFields` as `unit.customFields` FROM `unit` LEFT JOIN (SELECT `unit.translation`.`unit_id`, `unit.translation`.`short_code` as `unit.translation.shortCode`, `unit.translation`.`name` as `unit.translation.name`, `unit.translation`.`custom_fields` as `unit.translation.customFields` FROM `unit_translation` `unit.translation` WHERE `unit.translation`.`language_id` = ?) `unit.unit_translation` ON `unit.unit_translation`.`unit_id` = `unit`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.12%) 		1 
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.translation.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"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.12%) 		1 
-- product-listing::property-group-filter::read
SELECT `property_group`.`id` as `property_group.id`, `property_group`.`display_type` as `property_group.displayType`, `property_group`.`sorting_type` as `property_group.sortingType`, `property_group`.`filterable` as `property_group.filterable`, `property_group`.`visible_on_product_detail_page` as `property_group.visibleOnProductDetailPage`, `property_group`.`created_at` as `property_group.createdAt`, `property_group`.`updated_at` as `property_group.updatedAt`, `property_group.translation.name`, `property_group.translation.name` as `property_group.name`, `property_group.translation.description`, `property_group.translation.description` as `property_group.description`, `property_group.translation.position`, `property_group.translation.position` as `property_group.position`, `property_group.translation.customFields`, `property_group.translation.customFields` as `property_group.customFields` FROM `property_group` LEFT JOIN (SELECT `property_group.translation`.`property_group_id`, `property_group.translation`.`name` as `property_group.translation.name`, `property_group.translation`.`description` as `property_group.translation.description`, `property_group.translation`.`position` as `property_group.translation.position`, `property_group.translation`.`custom_fields` as `property_group.translation.customFields` FROM `property_group_translation` `property_group.translation` WHERE `property_group.translation`.`language_id` = ?) `property_group.property_group_translation` ON `property_group.property_group_translation`.`property_group_id` = `property_group`.`id` WHERE ((`property_group`.`filterable` = ?)) AND (`property_group`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"‘éÚ\x1EìŒEÙ€H÷‹\fFb«"
  b"Á¸R´ñûO›ªÌV™›;94"
  b"Î\x7FŒ\r"ÂFòŽ ª\fá\x0E÷²"
  b"Í\x0E`]m\x1FG…š•U}£/½"
  b"÷W\x15€\x02¯@ŸŽÑaà(~ÆÁ"
  b"œ:<º\rXIb¡\v~Ñlišö"
  b"År\x13žG©HH¨˜ú\x01i¥N®"
  b"A»I_\x16KB)ŠT›"<3›W"
  b"]ŽÃd0\x05MaH-Ž2\x14¿÷"
  b"\rÒPü8•EÖ…Ôi“Ø’Ÿl"
  b"Bdé\r¹O®²ƒ¼Õ\x10ÖZó"
  b"³\e\x18­üÕI‡¹m\x0E­j\x1CÚ"
  b"\x08Eñ\t8Eê·Ö,«ŽÉùŒ"
  b"\x15'þÿFL¡,ÆÊ’\x0E5m"
  b"O÷Ô(ï®H_»»ùŸ\x16ˆér"
  b"7¹“ñ\x1AÂCj·Ž»(»]\"
  b"ø¯³šY,BŽœ\x1EÕ‹Îb\x04z"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.12%) 		1 
-- category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`file_hash` as `cms_block.backgroundMedia.fileHash`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation.title` as `cms_block.backgroundMedia.title`, `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation.alt` as `cms_block.backgroundMedia.alt`, `cms_block.backgroundMedia.translation.customFields`, `cms_block.backgroundMedia.translation.customFields` as `cms_block.backgroundMedia.customFields` FROM `cms_block` LEFT JOIN `media` `cms_block.backgroundMedia` ON `cms_block`.`background_media_id` = `cms_block.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_block.backgroundMedia.translation`.`media_id`, `cms_block.backgroundMedia.translation`.`alt` as `cms_block.backgroundMedia.translation.alt`, `cms_block.backgroundMedia.translation`.`title` as `cms_block.backgroundMedia.translation.title`, `cms_block.backgroundMedia.translation`.`custom_fields` as `cms_block.backgroundMedia.translation.customFields` FROM `media_translation` `cms_block.backgroundMedia.translation` WHERE `cms_block.backgroundMedia.translation`.`language_id` = ?) `cms_block.backgroundMedia.media_translation` ON `cms_block.backgroundMedia.media_translation`.`media_id` = `cms_block.backgroundMedia`.`id` WHERE (`cms_block`.`version_id` = ?) AND (((`cms_block`.`cms_section_id` IN (?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"/š\x02ûª=B)¾àÇ᤹Z\x1D"
  b"/ó¶\x05–ßA'Œç51˜)ûø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.12%) 		1 
-- theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` 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"\x01›1{Aõpµ·ñ:C‹u\x10È"
  b"\x01›1{AüqU¢Ý}ìë(D}"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.12%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  "AdbPJWtgjtCZe8HlTfawiBxv2kupA9cl"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.11%) 		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"Ã\x05{°1cLfœÖß°Ô¬»\x15"
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.11%) 		1 
-- category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`file_hash` as `cms_section.backgroundMedia.fileHash`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation.title` as `cms_section.backgroundMedia.title`, `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation.alt` as `cms_section.backgroundMedia.alt`, `cms_section.backgroundMedia.translation.customFields`, `cms_section.backgroundMedia.translation.customFields` as `cms_section.backgroundMedia.customFields` FROM `cms_section` LEFT JOIN `media` `cms_section.backgroundMedia` ON `cms_section`.`background_media_id` = `cms_section.backgroundMedia`.`id` LEFT JOIN (SELECT `cms_section.backgroundMedia.translation`.`media_id`, `cms_section.backgroundMedia.translation`.`alt` as `cms_section.backgroundMedia.translation.alt`, `cms_section.backgroundMedia.translation`.`title` as `cms_section.backgroundMedia.translation.title`, `cms_section.backgroundMedia.translation`.`custom_fields` as `cms_section.backgroundMedia.translation.customFields` FROM `media_translation` `cms_section.backgroundMedia.translation` WHERE `cms_section.backgroundMedia.translation`.`language_id` = ?) `cms_section.backgroundMedia.media_translation` ON `cms_section.backgroundMedia.media_translation`.`media_id` = `cms_section.backgroundMedia`.`id` WHERE (`cms_section`.`version_id` = ?) AND (((`cms_section`.`cms_page_id` IN (?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"vˆT\x04°{KC·ñ \x06xµ\x05œ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.10%) 		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"Íe’Æ6®Kóƒx°\x1A›1äm"
  "navigation/9d2b0fec9ebf49feb299f3060de6a174"
  "navigation/9d2b0fec9ebf49feb299f3060de6a174/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.09%) 		2 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "AdbPJWtgjtCZe8HlTfawiBxv2kupA9cl"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.09%) 		1 
-- category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.config`, `cms_slot.translation.config` as `cms_slot.config`, `cms_slot.translation.customFields`, `cms_slot.translation.customFields` as `cms_slot.customFields` FROM `cms_slot` LEFT JOIN (SELECT `cms_slot.translation`.`cms_slot_id`, `cms_slot.translation`.`cms_slot_version_id`, `cms_slot.translation`.`config` as `cms_slot.translation.config`, `cms_slot.translation`.`custom_fields` as `cms_slot.translation.customFields` FROM `cms_slot_translation` `cms_slot.translation` WHERE `cms_slot.translation`.`language_id` = ?) `cms_slot.cms_slot_translation` ON `cms_slot.cms_slot_translation`.`cms_slot_id` = `cms_slot`.`id` AND `cms_slot.cms_slot_translation`.`cms_slot_version_id` = `cms_slot`.`version_id` WHERE (`cms_slot`.`version_id` = ?) AND (((`cms_slot`.`cms_block_id` IN (?, ?, ?, ?))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"‚Ä|°LžCl„ÌFI2¡4J"
  b"ŽÇE\tø\rIÚ–„Á¬Î\x10\x1D"
  b"æôe‚ßhNÿ¦$oñ˶‡m"
  b"™,ÉX}\x1CFÀº\x1F¥p{J«<"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.09%) 		1 
-- category::cms-page::read
SELECT `cms_page`.`id` as `cms_page.id`, `cms_page`.`version_id` as `cms_page.versionId`, `cms_page`.`type` as `cms_page.type`, `cms_page`.`entity` as `cms_page.entity`, `cms_page`.`css_class` as `cms_page.cssClass`, `cms_page`.`config` as `cms_page.config`, `cms_page`.`preview_media_id` as `cms_page.previewMediaId`, `cms_page`.`locked` as `cms_page.locked`, `cms_page`.`created_at` as `cms_page.createdAt`, `cms_page`.`updated_at` as `cms_page.updatedAt`, `cms_page.translation.name`, `cms_page.translation.name` as `cms_page.name`, `cms_page.translation.customFields`, `cms_page.translation.customFields` as `cms_page.customFields` FROM `cms_page` LEFT JOIN (SELECT `cms_page.translation`.`cms_page_id`, `cms_page.translation`.`cms_page_version_id`, `cms_page.translation`.`name` as `cms_page.translation.name`, `cms_page.translation`.`custom_fields` as `cms_page.translation.customFields` FROM `cms_page_translation` `cms_page.translation` WHERE `cms_page.translation`.`language_id` = ?) `cms_page.cms_page_translation` ON `cms_page.cms_page_translation`.`cms_page_id` = `cms_page`.`id` AND `cms_page.cms_page_translation`.`cms_page_version_id` = `cms_page`.`version_id` WHERE (`cms_page`.`version_id` = ?) AND (`cms_page`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"vˆT\x04°{KC·ñ \x06xµ\x05œ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.09%) 		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"""
    \x17\n
    C\x7F6ø@²—-ûrøæ¿b
    """
  b"\x1E›mÉ\vRG|·'÷ïeÆ]Ö"
  b"8X•p\x16dMä®HÀP\vóÌÈ"
  b"¸Rs=·eO;‚°T•Ë!ÚW"
  b"Ð[4\ÛyIgƒ\x12\x17[ÄLKL"
  b"á7Ž·€ŠG‘ž\rt\r]l\x1A"
  b"ï\x7FÙ.®S@I’\x06€\x12¨.’‹"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.08%) 		1 
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"´ \x18·vGÉ‹\t\x17DV;ûÍ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.08%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.07%) 		1 
-- product-listing::load-sortings::read
SELECT `product_sorting`.`id` as `product_sorting.id`, `product_sorting`.`locked` as `product_sorting.locked`, `product_sorting`.`url_key` as `product_sorting.key`, `product_sorting`.`priority` as `product_sorting.priority`, `product_sorting`.`active` as `product_sorting.active`, `product_sorting`.`fields` as `product_sorting.fields`, `product_sorting`.`created_at` as `product_sorting.createdAt`, `product_sorting`.`updated_at` as `product_sorting.updatedAt`, `product_sorting.translation.label`, `product_sorting.translation.label` as `product_sorting.label` FROM `product_sorting` LEFT JOIN (SELECT `product_sorting.translation`.`product_sorting_id`, `product_sorting.translation`.`label` as `product_sorting.translation.label` FROM `product_sorting_translation` `product_sorting.translation` WHERE `product_sorting.translation`.`language_id` = ?) `product_sorting.product_sorting_translation` ON `product_sorting.product_sorting_translation`.`product_sorting_id` = `product_sorting`.`id` WHERE `product_sorting`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"´ \x18·vGÉ‹\t\x17DV;ûÍ"
  b"""
    \Ú\x06 .~GΔ\x15d¼¾\x05\n
    «
    """
  b"ëbxQRjE-¸Ùc™#é!°"
  b"X`\rüN$N ©\x1FP\x1A‚}8ž"
  b"~sÌ+¤ÝJá‘\tdA\\x16vJ"
  b"–7JüB½A’¥Š\x1Fr«—GÃ"
  b"\x06jkîü~Kn‰)ÖL(ˆ¥\x1A"
  b""?xÂbúL¿ŸÕ1œ1Q±&"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.06%) 		1 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Íe’Æ6®Kóƒx°\x1A›1äm"
  "/navigation/9d2b0fec9ebf49feb299f3060de6a174"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.06%) 		1 
-- category::data::association::translations::read
SELECT `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` WHERE (`category_translation`.`category_version_id` = ?) AND (((`category_translation`.`category_id` IN (?))))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.06%) 		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"Íe’Æ6®Kóƒx°\x1A›1äm"
  b"Å\x08×PÉVKÿ»IQ\x1EøP\x08r"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.06%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.06%) 		1 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
  b"w¹YÏfÞL\x15Çù·Ú9‚ó"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.06%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.05%) 		1 
SELECT `name`, `path`, `author`, `self_managed`
                FROM `app`
                WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.05%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.05%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "Storefront"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.05%) 		1 
SELECT LOWER(HEX(id)) FROM snippet_set WHERE iso = ?
Parameters: 
[
  "de-DE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.05%) 		1 
-- product-listing::load-sortings::search-ids
SELECT `product_sorting`.`id` FROM `product_sorting` WHERE (`product_sorting`.`active` = ?) ORDER BY `product_sorting`.`priority` DESC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.04%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.04%) 		1 
-- product-listing-route::category-loading::search-ids
SELECT `category`.`id`, `category`.`auto_increment` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?)) LIMIT 1
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.04%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.04%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(0.03%) 		1 
-- product-listing-route::category-loading::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`product_stream_id` as `category.productStreamId` FROM `category` WHERE (`category`.`version_id` = ?) AND (`category`.`id` IN (?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"+\x0Fìž¿Iþ²™ó\x06\ræ¡t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.03%) 		1 
SELECT `min_search_length` FROM `product_search_config` WHERE `language_id` = ?
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.