GET https://menziebz.webwirkungdev.ch/navigation/529080be909a4c99bdfd83bb642d3e5b

Response
200 OK
Browse referrer URL
IP
18.221.124.95
Profiled on
Token
4ad30a

Query Metrics

70 Database Queries
62 Different statements
31.17 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
4.07 ms
(13.07%) 		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.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.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.translation.name`, `product.manufacturer.translation.name` as `product.manufacturer.name`, `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.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `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.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.solidPvVideoThumbnail`.`id` as `product.cover.solidPvVideoThumbnail.id`, `product.cover.solidPvVideoThumbnail`.`product_media_id` as `product.cover.solidPvVideoThumbnail.productMediaId`, `product.cover.solidPvVideoThumbnail`.`product_media_version_id` as `product.cover.solidPvVideoThumbnail.productMediaVersionId`, `product.cover.solidPvVideoThumbnail`.`media_id` as `product.cover.solidPvVideoThumbnail.mediaId`, `product.cover.solidPvVideoThumbnail.media`.`id` as `product.cover.solidPvVideoThumbnail.media.id`, `product.cover.solidPvVideoThumbnail.media`.`user_id` as `product.cover.solidPvVideoThumbnail.media.userId`, `product.cover.solidPvVideoThumbnail.media`.`media_folder_id` as `product.cover.solidPvVideoThumbnail.media.mediaFolderId`, `product.cover.solidPvVideoThumbnail.media`.`mime_type` as `product.cover.solidPvVideoThumbnail.media.mimeType`, `product.cover.solidPvVideoThumbnail.media`.`file_extension` as `product.cover.solidPvVideoThumbnail.media.fileExtension`, `product.cover.solidPvVideoThumbnail.media`.`uploaded_at` as `product.cover.solidPvVideoThumbnail.media.uploadedAt`, `product.cover.solidPvVideoThumbnail.media`.`file_name` as `product.cover.solidPvVideoThumbnail.media.fileName`, `product.cover.solidPvVideoThumbnail.media`.`file_size` as `product.cover.solidPvVideoThumbnail.media.fileSize`, `product.cover.solidPvVideoThumbnail.media`.`media_type` as `product.cover.solidPvVideoThumbnail.media.mediaTypeRaw`, `product.cover.solidPvVideoThumbnail.media`.`meta_data` as `product.cover.solidPvVideoThumbnail.media.metaData`, `product.cover.solidPvVideoThumbnail.media`.`config` as `product.cover.solidPvVideoThumbnail.media.config`, `product.cover.solidPvVideoThumbnail.media`.`path` as `product.cover.solidPvVideoThumbnail.media.path`, `product.cover.solidPvVideoThumbnail.media`.`private` as `product.cover.solidPvVideoThumbnail.media.private`, `product.cover.solidPvVideoThumbnail.media`.`thumbnails_ro` as `product.cover.solidPvVideoThumbnail.media.thumbnailsRo`, `product.cover.solidPvVideoThumbnail.media`.`created_at` as `product.cover.solidPvVideoThumbnail.media.createdAt`, `product.cover.solidPvVideoThumbnail.media`.`updated_at` as `product.cover.solidPvVideoThumbnail.media.updatedAt`, `product.cover.solidPvVideoThumbnail.media.translation.title`, `product.cover.solidPvVideoThumbnail.media.translation.title` as `product.cover.solidPvVideoThumbnail.media.title`, `product.cover.solidPvVideoThumbnail.media.translation.alt`, `product.cover.solidPvVideoThumbnail.media.translation.alt` as `product.cover.solidPvVideoThumbnail.media.alt`, `product.cover.solidPvVideoThumbnail.media.translation.customFields`, `product.cover.solidPvVideoThumbnail.media.translation.customFields` as `product.cover.solidPvVideoThumbnail.media.customFields`, `product.cover.solidPvVideoThumbnail`.`created_at` as `product.cover.solidPvVideoThumbnail.createdAt`, `product.cover.solidPvVideoThumbnail`.`updated_at` as `product.cover.solidPvVideoThumbnail.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 `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.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`.`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 `solid_pv_product_media_video_thumbnail` `product.cover.solidPvVideoThumbnail` ON `product.cover`.`id` = `product.cover.solidPvVideoThumbnail`.`product_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` LEFT JOIN `media` `product.cover.solidPvVideoThumbnail.media` ON `product.cover.solidPvVideoThumbnail`.`media_id` = `product.cover.solidPvVideoThumbnail.media`.`id` LEFT JOIN (SELECT `product.cover.solidPvVideoThumbnail.media.translation`.`media_id`, `product.cover.solidPvVideoThumbnail.media.translation`.`alt` as `product.cover.solidPvVideoThumbnail.media.translation.alt`, `product.cover.solidPvVideoThumbnail.media.translation`.`title` as `product.cover.solidPvVideoThumbnail.media.translation.title`, `product.cover.solidPvVideoThumbnail.media.translation`.`custom_fields` as `product.cover.solidPvVideoThumbnail.media.translation.customFields` FROM `media_translation` `product.cover.solidPvVideoThumbnail.media.translation` WHERE `product.cover.solidPvVideoThumbnail.media.translation`.`language_id` = ?) `product.cover.solidPvVideoThumbnail.media.media_translation` ON `product.cover.solidPvVideoThumbnail.media.media_translation`.`media_id` = `product.cover.solidPvVideoThumbnail.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\t*ª=¾±I(Ÿ\x1FK\x14=£\x17l"
  b"\x13ÍÑ9¥┘BÉÆ´2\x16░/Ƕ"
  b"`²\x17\x06JÉO—”Å·÷8’á×"
  b"bRC:┘iIÖØ┴³}ı│?""
  b"×Ïî]\x13ÙJ-³ø\x19À¥·W>"
  b"áàeìëŒO[¨ÙÓ\ð.ž2"
]
View formatted query    View runnable query    Explain query    View query backtrace
4.06 ms
(13.03%) 		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/529080be909a4c99bdfd83bb642d3e5b"
  "/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/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/092aaa3dbeb149289f1f4b143da3176c"
  "/detail/13d6a539bed9429092ef3216b02f80f4"
  "/detail/60b217064ac94f9794c5b7f73892e1d7"
  "/detail/6252433ad96949999dc1fc7dd5b33f22"
  "/detail/d7cfee5d13d94a2db3f819c0a5b7573e"
  "/detail/e1e065eceb8c4f5ba8d9d35cf02e9e32"
  "/sas_blog/019589b67058798dabba3dc37600a7db"
  "/sas_blog/019465535ddb7ca38a42922c98ec48b3"
  "/sas_blog/019463d72b497b93b41e21317093ca8a"
  "/navigation/0190de58b01475beb3663897fc94b575"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"õ½iA_mMÇ’\x18}2m}”M"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.92 ms
(6.17%) 		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 `kplngi_productcategoryposition` `product.kplngiPositions` ON     
            `product`.`id` = `product.kplngiPositions`.`product_id`
         AND `product.kplngiPositions`.`category_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` <=> ?))) GROUP BY `product`.`display_group` ORDER BY MAX(`product.kplngiPositions`.`position`) DESC, MIN(`product`.`id`) ASC LIMIT 15
Parameters: 
[
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.92 ms
(6.15%) 		1 
# product-listing-route::loading::aggregation::price
SELECT MIN(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0191789527f272618999d924dcce0aeb.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule700cc6a975f0456594e1a55476d90f0e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9512d9d73eba4904b747efdeef0d1cae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9e3fea1372194279817248e54e43600a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleba1367d480b14b98b1b4d6bde5fc89e6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01930092e7487ba48136416d6a0d4c98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule85cc134183d34986a49649ee3c133ed0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0191789527f272618999d924dcce0aeb.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule700cc6a975f0456594e1a55476d90f0e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9512d9d73eba4904b747efdeef0d1cae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9e3fea1372194279817248e54e43600a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleba1367d480b14b98b1b4d6bde5fc89e6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01930092e7487ba48136416d6a0d4c98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule85cc134183d34986a49649ee3c133ed0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20)))) as `price.min`, MAX(IFNULL(COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule0191789527f272618999d924dcce0aeb.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule700cc6a975f0456594e1a55476d90f0e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9512d9d73eba4904b747efdeef0d1cae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule9e3fea1372194279817248e54e43600a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruleba1367d480b14b98b1b4d6bde5fc89e6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule01930092e7487ba48136416d6a0d4c98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.rule85cc134183d34986a49649ee3c133ed0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20)), COALESCE((ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule0191789527f272618999d924dcce0aeb.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule700cc6a975f0456594e1a55476d90f0e.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9512d9d73eba4904b747efdeef0d1cae.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule9e3fea1372194279817248e54e43600a.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruleba1367d480b14b98b1b4d6bde5fc89e6.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule01930092e7487ba48136416d6a0d4c98.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.rule85cc134183d34986a49649ee3c133ed0.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20),(ROUND((ROUND(CAST((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`cheapest_price_accessor`, "$.ruledefault.currencyb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) * 1) as DECIMAL(30, 20)), 2)) * 20, 0) / 20)))) as `price.max` 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` <=> ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
1.28 ms
(4.11%) 		1 
# category::data::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.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"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
1.10 ms
(3.54%) 		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.group`.`id` as `property_group_option.group.id`, `property_group_option.group`.`display_type` as `property_group_option.group.displayType`, `property_group_option.group`.`sorting_type` as `property_group_option.group.sortingType`, `property_group_option.group`.`filterable` as `property_group_option.group.filterable`, `property_group_option.group`.`visible_on_product_detail_page` as `property_group_option.group.visibleOnProductDetailPage`, `property_group_option.group`.`created_at` as `property_group_option.group.createdAt`, `property_group_option.group`.`updated_at` as `property_group_option.group.updatedAt`, `property_group_option.group.translation.name`, `property_group_option.group.translation.name` as `property_group_option.group.name`, `property_group_option.group.translation.description`, `property_group_option.group.translation.description` as `property_group_option.group.description`, `property_group_option.group.translation.position`, `property_group_option.group.translation.position` as `property_group_option.group.position`, `property_group_option.group.translation.customFields`, `property_group_option.group.translation.customFields` as `property_group_option.group.customFields`, `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`.`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 `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` 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.group.translation`.`property_group_id`, `property_group_option.group.translation`.`name` as `property_group_option.group.translation.name`, `property_group_option.group.translation`.`description` as `property_group_option.group.translation.description`, `property_group_option.group.translation`.`position` as `property_group_option.group.translation.position`, `property_group_option.group.translation`.`custom_fields` as `property_group_option.group.translation.customFields` FROM `property_group_translation` `property_group_option.group.translation` WHERE `property_group_option.group.translation`.`language_id` = ?) `property_group_option.group.property_group_translation` ON `property_group_option.group.property_group_translation`.`property_group_id` = `property_group_option.group`.`id` 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"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0E†•Äq\x12N\x17˜±\x16fDUé\e"
  b"\x11ü–øœÈL\vŒæ6I8º\x182"
  b"\x14v–§j/K÷‚´\x03̳éš+"
  b"\x18y1\x16©ò@\x15ƒ¯Y­\x0EıÉï"
  b"\x19\x02AÚØ1Aºë¨úûCzQÐ"
  b"\x19@É\x1DÑàH:ék=²_\x13ÁJ"
  b",O¼ÃÞñC\x11®?#{"\x10&´"
  b"-ÕŽç%R@¿‘-\x05\x07­¬ÛX"
  b"?׬\x1FMðEŽŠÒÏ\x13BÃOû"
  b"GÜ\x10ÎОH[‡Z˜¾\x0F¦\t\x0E"
  b"Jz¡Û┼~Dâ¿HOÜì&┴´"
  b"Pê\x07\x05ÌžH<œ«“6¿\x0EÚã"
  b"X`^XhFFŒ®6vù&fÆ?"
  b"Y‹[)ì\x02Iò¸^\x07/>\x05GG"
  b"]àÌ{],Eè½¼Ôd½TÏ©"
  b"bf0UO‗B¨Å{<\x0E ┐▒╗"
  b"""
    gV\n
    r_\x7FM\t•º5:ôªÜ•
    """
  b"r┴¿ZñÖ@ÖÅ¡=Ï|\f┐\x07"
  b"sÜ\x1CGñ²Bi±N‰‚ª\x0Eøô"
  b"|&ÿ×X)K\x08±ÒØÅÍa/Ž"
  b"†U6\f1cGä¡@.\x03p\v¯µ"
  b"Ä▄â├ÅÝM½ûsÝìÉ¿*º"
  b"æ¹¼\x11¡¾A┌üZäÇÕs÷_"
  b"’Q!;ΩJ¯ºð÷¥HZF~"
  b"""
    ž³Ï\x13sÏHÑ£\x08\e\re \n
    Ä
    """
  b"""
    £½ÞdM—HA²d}ÀÛ\n
    \x05N
    """
  b"""
    ¨\x1D€2\n
    «O\t²qâNÞ·\x11B
    """
  b"©A-Y®ÆHhœ­\x00ò\x1AJla"
  b"Ç8Mai€Mw¦\x17|\x02²q\x13m"
  b"ÉeD¢ÊÐKt­‹#%\x14¡Çx"
  b"̤±¬Ë[F\t‚ÞúÏ5Æ›¾"
  b"ÌÄX 3 A2‰\x0Eæ\x0E\x1Eòqë"
  b"ÎâØ#¿ÂM;Üé9ÃíNIÍ"
  b"×í.ݬ\rO+§\rµ‹\vCi0"
  b"▀9ì`«│F=¿\x18¨│Ð\x17E;"
  b"´{é╬? O*áôÙZì¨▒╔"
  b"òÿÞ2—SLF¿F3v\x19„†–"
  b"·B .\x06'FøÄÞɸM│3;"
  b"ý¶èÀúçE¼†¬€è†ûJR"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.05 ms
(3.37%) 		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` <=> ?))) GROUP BY `product.properties`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.85 ms
(2.71%) 		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"\t*ª=¾±I(Ÿ\x1FK\x14=£\x17l"
  b"\x13ÍÑ9¥┘BÉÆ´2\x16░/Ƕ"
  b"`²\x17\x06JÉO—”Å·÷8’á×"
  b"bRC:┘iIÖØ┴³}ı│?""
  b"×Ïî]\x13ÙJ-³ø\x19À¥·W>"
  b"áàeìëŒO[¨ÙÓ\ð.ž2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.79 ms
(2.55%) 		1 
SELECT `sas_blog_entries`.`id` FROM `sas_blog_entries` LEFT JOIN (SELECT `sas_blog_entries.translation`.`sas_blog_entries_id`, `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` WHERE (`sas_blog_entries`.`active` = ? AND (`sas_blog_entries`.`published_at` <= ?) AND (COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) LIKE ? OR COALESCE(IF(JSON_TYPE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) != "NULL", CONVERT(JSON_UNQUOTE(JSON_EXTRACT(`sas_blog_entries.translation.customFields`, '$.salesChannelIds')) USING "utf8mb4") COLLATE utf8mb4_unicode_ci, NULL)) <=> ?)) ORDER BY `sas_blog_entries`.`published_at` DESC LIMIT 3
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  "2025-05-14T20:57:12+00:00"
  "%f5bd69415f6d4dc792187d326d7d944d%"
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.74 ms
(2.39%) 		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"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.69 ms
(2.20%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500
Parameters: 
[
  true
  b"\x0E†•Äq\x12N\x17˜±\x16fDUé\e"
  b"\x11ü–øœÈL\vŒæ6I8º\x182"
  b"\x14v–§j/K÷‚´\x03̳éš+"
  b"\x18y1\x16©ò@\x15ƒ¯Y­\x0EıÉï"
  b"\x19\x02AÚØ1Aºë¨úûCzQÐ"
  b"\x19@É\x1DÑàH:ék=²_\x13ÁJ"
  b",O¼ÃÞñC\x11®?#{"\x10&´"
  b"-ÕŽç%R@¿‘-\x05\x07­¬ÛX"
  b"?׬\x1FMðEŽŠÒÏ\x13BÃOû"
  b"GÜ\x10ÎОH[‡Z˜¾\x0F¦\t\x0E"
  b"JN¶Ñ<îJU‹—^ }(\x1ED"
  b"Jz¡Û┼~Dâ¿HOÜì&┴´"
  b"Pê\x07\x05ÌžH<œ«“6¿\x0EÚã"
  b"""
    QÉ\x14s▀´Fø¡Ë\x04ÃG \n
    └
    """
  b"X`^XhFFŒ®6vù&fÆ?"
  b"Y‹[)ì\x02Iò¸^\x07/>\x05GG"
  b"Z%Ö°dÌL\eØ;¢\x15Åæ±u"
  b"]àÌ{],Eè½¼Ôd½TÏ©"
  b"bf0UO‗B¨Å{<\x0E ┐▒╗"
  b"""
    gV\n
    r_\x7FM\t•º5:ôªÜ•
    """
  b"jæÖ·àˆMŒ—ê Ô¯ãN\x0F"
  b"r┴¿ZñÖ@ÖÅ¡=Ï|\f┐\x07"
  b"sÜ\x1CGñ²Bi±N‰‚ª\x0Eøô"
  b"|&ÿ×X)K\x08±ÒØÅÍa/Ž"
  b"ƒ#è2\e'Aò³\t\x1A°`˜½´"
  b"„À\x1A\x18S•A­’ª~\x01úo9\v"
  b"†U6\f1cGä¡@.\x03p\v¯µ"
  b"Ä▄â├ÅÝM½ûsÝìÉ¿*º"
  b"æ¹¼\x11¡¾A┌üZäÇÕs÷_"
  b"’%è\x1D|OOt¯­½¦\x008ò°"
  b"’Q!;ΩJ¯ºð÷¥HZF~"
  b"""
    ž³Ï\x13sÏHÑ£\x08\e\re \n
    Ä
    """
  b"""
    £½ÞdM—HA²d}ÀÛ\n
    \x05N
    """
  b"""
    ¨\x1D€2\n
    «O\t²qâNÞ·\x11B
    """
  b"©A-Y®ÆHhœ­\x00ò\x1AJla"
  b"°6„\x13wÞL³›Z•1…vÔª"
  b"┤`èÄ\x12▀G\x06«┤É{HÔô═"
  b"À\x1D2üݶOƒ’\x12K·Ü’9k"
  b"─Dð_Ø╗Oõùålkí`╔'"
  b"Ç8Mai€Mw¦\x17|\x02²q\x13m"
  b"ÉeD¢ÊÐKt­‹#%\x14¡Çx"
  b"̤±¬Ë[F\t‚ÞúÏ5Æ›¾"
  b"ÌÄX 3 A2‰\x0Eæ\x0E\x1Eòqë"
  b"ÎâØ#¿ÂM;Üé9ÃíNIÍ"
  b"×í.ݬ\rO+§\rµ‹\vCi0"
  b"▀9ì`«│F=¿\x18¨│Ð\x17E;"
  b"´{é╬? O*áôÙZì¨▒╔"
  b"òÿÞ2—SLF¿F3v\x19„†–"
  b"·B .\x06'FøÄÞɸM│3;"
  b"ý¶èÀúçE¼†¬€è†ûJR"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.63 ms
(2.02%) 		6 
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"\t*ª=¾±I(Ÿ\x1FK\x14=£\x17l"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.62 ms
(2.00%) 		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 `kplngi_productcategoryposition` `product.kplngiPositions` ON     
            `product`.`id` = `product.kplngiPositions`.`product_id`
         AND `product.kplngiPositions`.`category_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` <=> ?))) GROUP BY `product`.`display_group`) total
Parameters: 
[
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.90%) 		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: 
[
  "/navigation/529080be909a4c99bdfd83bb642d3e5b"
  b"õ½iA_mMÇ’\x18}2m}”M"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Ž\x05ŸÐ)ùHh¼µ³¼…ìO8"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.87%) 		1 
# manufacturer-aggregation::read
SELECT `product_manufacturer`.`id` as `product_manufacturer.id`, `product_manufacturer`.`version_id` as `product_manufacturer.versionId`, `product_manufacturer`.`media_id` as `product_manufacturer.mediaId`, `product_manufacturer`.`link` as `product_manufacturer.link`, `product_manufacturer`.`created_at` as `product_manufacturer.createdAt`, `product_manufacturer`.`updated_at` as `product_manufacturer.updatedAt`, `product_manufacturer.translation.name`, `product_manufacturer.translation.name` as `product_manufacturer.name`, `product_manufacturer.translation.description`, `product_manufacturer.translation.description` as `product_manufacturer.description`, `product_manufacturer.translation.customFields`, `product_manufacturer.translation.customFields` as `product_manufacturer.customFields` FROM `product_manufacturer` LEFT JOIN (SELECT `product_manufacturer.translation`.`product_manufacturer_id`, `product_manufacturer.translation`.`product_manufacturer_version_id`, `product_manufacturer.translation`.`name` as `product_manufacturer.translation.name`, `product_manufacturer.translation`.`description` as `product_manufacturer.translation.description`, `product_manufacturer.translation`.`custom_fields` as `product_manufacturer.translation.customFields` 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` WHERE (`product_manufacturer`.`version_id` = ?) AND (`product_manufacturer`.`id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ž\x04p`2ÃJU‚ØÒÇ^÷\vÆ"
  b"•*%GS@L)ŒœÔ«Lé0S"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.86%) 		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` <=> ?))) GROUP BY `product.options`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.82%) 		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"
  "produkte/static-light/studio/softlight"
  "produkte/static-light/studio/softlight/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(1.76%) 		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"ìi\x13\x04”öMͦ\x7F\efî\x15éD"
  b"ïz¿2K¥A4»pÐIų¿*"
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(1.64%) 		1 
# product-listing-route::loading::aggregation::manufacturer
SELECT LOWER(HEX(IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`))) as `manufacturer` 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` <=> ?))) GROUP BY IFNULL(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`)
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
]
View formatted query    View runnable query    Explain query    View query backtrace
0.51 ms
(1.64%) 		1 
# product-listing::property-filter::search-ids
SELECT `property_group_option`.`id` FROM `property_group_option` LEFT JOIN `property_group` `property_group_option.group` ON `property_group_option`.`property_group_id` = `property_group_option.group`.`id` WHERE ((`property_group_option.group`.`filterable` = ?)) AND (`property_group_option`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY `property_group_option`.`id` ASC LIMIT 500 OFFSET 500
Parameters: 
[
  true
  b"\x0E†•Äq\x12N\x17˜±\x16fDUé\e"
  b"\x11ü–øœÈL\vŒæ6I8º\x182"
  b"\x14v–§j/K÷‚´\x03̳éš+"
  b"\x18y1\x16©ò@\x15ƒ¯Y­\x0EıÉï"
  b"\x19\x02AÚØ1Aºë¨úûCzQÐ"
  b"\x19@É\x1DÑàH:ék=²_\x13ÁJ"
  b",O¼ÃÞñC\x11®?#{"\x10&´"
  b"-ÕŽç%R@¿‘-\x05\x07­¬ÛX"
  b"?׬\x1FMðEŽŠÒÏ\x13BÃOû"
  b"GÜ\x10ÎОH[‡Z˜¾\x0F¦\t\x0E"
  b"JN¶Ñ<îJU‹—^ }(\x1ED"
  b"Jz¡Û┼~Dâ¿HOÜì&┴´"
  b"Pê\x07\x05ÌžH<œ«“6¿\x0EÚã"
  b"""
    QÉ\x14s▀´Fø¡Ë\x04ÃG \n
    └
    """
  b"X`^XhFFŒ®6vù&fÆ?"
  b"Y‹[)ì\x02Iò¸^\x07/>\x05GG"
  b"Z%Ö°dÌL\eØ;¢\x15Åæ±u"
  b"]àÌ{],Eè½¼Ôd½TÏ©"
  b"bf0UO‗B¨Å{<\x0E ┐▒╗"
  b"""
    gV\n
    r_\x7FM\t•º5:ôªÜ•
    """
  b"jæÖ·àˆMŒ—ê Ô¯ãN\x0F"
  b"r┴¿ZñÖ@ÖÅ¡=Ï|\f┐\x07"
  b"sÜ\x1CGñ²Bi±N‰‚ª\x0Eøô"
  b"|&ÿ×X)K\x08±ÒØÅÍa/Ž"
  b"ƒ#è2\e'Aò³\t\x1A°`˜½´"
  b"„À\x1A\x18S•A­’ª~\x01úo9\v"
  b"†U6\f1cGä¡@.\x03p\v¯µ"
  b"Ä▄â├ÅÝM½ûsÝìÉ¿*º"
  b"æ¹¼\x11¡¾A┌üZäÇÕs÷_"
  b"’%è\x1D|OOt¯­½¦\x008ò°"
  b"’Q!;ΩJ¯ºð÷¥HZF~"
  b"""
    ž³Ï\x13sÏHÑ£\x08\e\re \n
    Ä
    """
  b"""
    £½ÞdM—HA²d}ÀÛ\n
    \x05N
    """
  b"""
    ¨\x1D€2\n
    «O\t²qâNÞ·\x11B
    """
  b"©A-Y®ÆHhœ­\x00ò\x1AJla"
  b"°6„\x13wÞL³›Z•1…vÔª"
  b"┤`èÄ\x12▀G\x06«┤É{HÔô═"
  b"À\x1D2üݶOƒ’\x12K·Ü’9k"
  b"─Dð_Ø╗Oõùålkí`╔'"
  b"Ç8Mai€Mw¦\x17|\x02²q\x13m"
  b"ÉeD¢ÊÐKt­‹#%\x14¡Çx"
  b"̤±¬Ë[F\t‚ÞúÏ5Æ›¾"
  b"ÌÄX 3 A2‰\x0Eæ\x0E\x1Eòqë"
  b"ÎâØ#¿ÂM;Üé9ÃíNIÍ"
  b"×í.ݬ\rO+§\rµ‹\vCi0"
  b"▀9ì`«│F=¿\x18¨│Ð\x17E;"
  b"´{é╬? O*áôÙZì¨▒╔"
  b"òÿÞ2—SLF¿F3v\x19„†–"
  b"·B .\x06'FøÄÞɸM│3;"
  b"ý¶èÀúçE¼†¬€è†ûJR"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.45%) 		2 
SELECT `kplngi_productcategoryposition`.`id` FROM `kplngi_productcategoryposition` WHERE (`kplngi_productcategoryposition`.`category_id` = ?) LIMIT 1
Parameters: 
[
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.41 ms
(1.31%) 		1 
# product-listing-route::loading::aggregation::rating-exists
SELECT MAX(IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`)) as `rating` 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 (((IFNULL(`product`.`rating_average`, `product.parent`.`rating_average`) >= ?)))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(1.17%) 		1 
# product-listing-route::loading::aggregation::shipping-free-filter
SELECT MAX(IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`)) as `shipping-free` 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 ((IFNULL(`product`.`shipping_free`, `product.parent`.`shipping_free`) = ?))
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  30
  b"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  null
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(1.08%) 		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"õ½iA_mMÇ’\x18}2m}”M"
  true
  b"\t*ª=¾±I(Ÿ\x1FK\x14=£\x17l"
  b"\x13ÍÑ9¥┘BÉÆ´2\x16░/Ƕ"
  b"`²\x17\x06JÉO—”Å·÷8’á×"
  b"bRC:┘iIÖØ┴³}ı│?""
  b"×Ïî]\x13ÙJ-³ø\x19À¥·W>"
  b"áàeìëŒO[¨ÙÓ\ð.ž2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.01%) 		1 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "wy2YYNheDh4ShnBW8RIjZ97NUlZnDzcW"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.01%) 		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"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(1.00%) 		2 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.98%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.29 ms
(0.95%) 		1 
SELECT `ww_stopper`.`id` as `ww_stopper.id`, `ww_stopper`.`link_type` as `ww_stopper.linkType`, `ww_stopper`.`target` as `ww_stopper.target`, `ww_stopper`.`position` as `ww_stopper.position`, `ww_stopper`.`dark_mode` as `ww_stopper.darkMode`, `ww_stopper`.`active` as `ww_stopper.active`, `ww_stopper`.`media_id` as `ww_stopper.mediaId`, `ww_stopper.media`.`id` as `ww_stopper.media.id`, `ww_stopper.media`.`user_id` as `ww_stopper.media.userId`, `ww_stopper.media`.`media_folder_id` as `ww_stopper.media.mediaFolderId`, `ww_stopper.media`.`mime_type` as `ww_stopper.media.mimeType`, `ww_stopper.media`.`file_extension` as `ww_stopper.media.fileExtension`, `ww_stopper.media`.`uploaded_at` as `ww_stopper.media.uploadedAt`, `ww_stopper.media`.`file_name` as `ww_stopper.media.fileName`, `ww_stopper.media`.`file_size` as `ww_stopper.media.fileSize`, `ww_stopper.media`.`media_type` as `ww_stopper.media.mediaTypeRaw`, `ww_stopper.media`.`meta_data` as `ww_stopper.media.metaData`, `ww_stopper.media`.`config` as `ww_stopper.media.config`, `ww_stopper.media`.`path` as `ww_stopper.media.path`, `ww_stopper.media`.`private` as `ww_stopper.media.private`, `ww_stopper.media`.`thumbnails_ro` as `ww_stopper.media.thumbnailsRo`, `ww_stopper.media`.`created_at` as `ww_stopper.media.createdAt`, `ww_stopper.media`.`updated_at` as `ww_stopper.media.updatedAt`, `ww_stopper.media.translation.title`, `ww_stopper.media.translation.title` as `ww_stopper.media.title`, `ww_stopper.media.translation.alt`, `ww_stopper.media.translation.alt` as `ww_stopper.media.alt`, `ww_stopper.media.translation.customFields`, `ww_stopper.media.translation.customFields` as `ww_stopper.media.customFields`, `ww_stopper`.`link_product_id` as `ww_stopper.linkProductId`, `ww_stopper.linkProduct`.`id` as `ww_stopper.linkProduct.id`, `ww_stopper.linkProduct`.`version_id` as `ww_stopper.linkProduct.versionId`, `ww_stopper.linkProduct`.`parent_id` as `ww_stopper.linkProduct.parentId`, `ww_stopper.linkProduct`.`parent_version_id` as `ww_stopper.linkProduct.parentVersionId`, COALESCE(`ww_stopper.linkProduct`.`product_manufacturer_id`, `ww_stopper.linkProduct.parent`.`product_manufacturer_id`) as `ww_stopper.linkProduct.manufacturerId`, COALESCE(`ww_stopper.linkProduct`.`product_manufacturer_version_id`, `ww_stopper.linkProduct.parent`.`product_manufacturer_version_id`) as `ww_stopper.linkProduct.productManufacturerVersionId`, COALESCE(`ww_stopper.linkProduct`.`unit_id`, `ww_stopper.linkProduct.parent`.`unit_id`) as `ww_stopper.linkProduct.unitId`, COALESCE(`ww_stopper.linkProduct`.`tax_id`, `ww_stopper.linkProduct.parent`.`tax_id`) as `ww_stopper.linkProduct.taxId`, COALESCE(`ww_stopper.linkProduct`.`product_media_id`, `ww_stopper.linkProduct.parent`.`product_media_id`) as `ww_stopper.linkProduct.coverId`, COALESCE(`ww_stopper.linkProduct`.`product_media_version_id`, `ww_stopper.linkProduct.parent`.`product_media_version_id`) as `ww_stopper.linkProduct.productMediaVersionId`, COALESCE(`ww_stopper.linkProduct`.`delivery_time_id`, `ww_stopper.linkProduct.parent`.`delivery_time_id`) as `ww_stopper.linkProduct.deliveryTimeId`, COALESCE(`ww_stopper.linkProduct`.`product_feature_set_id`, `ww_stopper.linkProduct.parent`.`product_feature_set_id`) as `ww_stopper.linkProduct.featureSetId`, COALESCE(`ww_stopper.linkProduct`.`canonical_product_id`, `ww_stopper.linkProduct.parent`.`canonical_product_id`) as `ww_stopper.linkProduct.canonicalProductId`, COALESCE(`ww_stopper.linkProduct`.`canonical_product_version_id`, `ww_stopper.linkProduct.parent`.`canonical_product_version_id`) as `ww_stopper.linkProduct.canonicalProductVersionId`, COALESCE(`ww_stopper.linkProduct`.`cms_page_id`, `ww_stopper.linkProduct.parent`.`cms_page_id`) as `ww_stopper.linkProduct.cmsPageId`, COALESCE(`ww_stopper.linkProduct`.`cms_page_version_id`, `ww_stopper.linkProduct.parent`.`cms_page_version_id`) as `ww_stopper.linkProduct.cmsPageVersionId`, `ww_stopper.linkProduct.parent`.`price` as `ww_stopper.linkProduct.price.inherited`, COALESCE(`ww_stopper.linkProduct`.`price`, `ww_stopper.linkProduct.parent`.`price`) as `ww_stopper.linkProduct.price`, `ww_stopper.linkProduct`.`product_number` as `ww_stopper.linkProduct.productNumber`, COALESCE(`ww_stopper.linkProduct`.`restock_time`, `ww_stopper.linkProduct.parent`.`restock_time`) as `ww_stopper.linkProduct.restockTime`, `ww_stopper.linkProduct`.`auto_increment` as `ww_stopper.linkProduct.autoIncrement`, COALESCE(`ww_stopper.linkProduct`.`active`, `ww_stopper.linkProduct.parent`.`active`) as `ww_stopper.linkProduct.active`, `ww_stopper.linkProduct`.`available` as `ww_stopper.linkProduct.available`, COALESCE(`ww_stopper.linkProduct`.`is_closeout`, `ww_stopper.linkProduct.parent`.`is_closeout`) as `ww_stopper.linkProduct.isCloseout`, `ww_stopper.linkProduct`.`available_stock` as `ww_stopper.linkProduct.availableStock`, `ww_stopper.linkProduct`.`stock` as `ww_stopper.linkProduct.stock`, `ww_stopper.linkProduct`.`display_group` as `ww_stopper.linkProduct.displayGroup`, `ww_stopper.linkProduct.parent`.`variant_listing_config` as `ww_stopper.linkProduct.variantListingConfig.inherited`, COALESCE(`ww_stopper.linkProduct`.`variant_listing_config`, `ww_stopper.linkProduct.parent`.`variant_listing_config`) as `ww_stopper.linkProduct.variantListingConfig`, `ww_stopper.linkProduct`.`variant_restrictions` as `ww_stopper.linkProduct.variantRestrictions`, COALESCE(`ww_stopper.linkProduct`.`manufacturer_number`, `ww_stopper.linkProduct.parent`.`manufacturer_number`) as `ww_stopper.linkProduct.manufacturerNumber`, COALESCE(`ww_stopper.linkProduct`.`ean`, `ww_stopper.linkProduct.parent`.`ean`) as `ww_stopper.linkProduct.ean`, COALESCE(`ww_stopper.linkProduct`.`purchase_steps`, `ww_stopper.linkProduct.parent`.`purchase_steps`) as `ww_stopper.linkProduct.purchaseSteps`, COALESCE(`ww_stopper.linkProduct`.`max_purchase`, `ww_stopper.linkProduct.parent`.`max_purchase`) as `ww_stopper.linkProduct.maxPurchase`, COALESCE(`ww_stopper.linkProduct`.`min_purchase`, `ww_stopper.linkProduct.parent`.`min_purchase`) as `ww_stopper.linkProduct.minPurchase`, COALESCE(`ww_stopper.linkProduct`.`purchase_unit`, `ww_stopper.linkProduct.parent`.`purchase_unit`) as `ww_stopper.linkProduct.purchaseUnit`, COALESCE(`ww_stopper.linkProduct`.`reference_unit`, `ww_stopper.linkProduct.parent`.`reference_unit`) as `ww_stopper.linkProduct.referenceUnit`, COALESCE(`ww_stopper.linkProduct`.`shipping_free`, `ww_stopper.linkProduct.parent`.`shipping_free`) as `ww_stopper.linkProduct.shippingFree`, `ww_stopper.linkProduct.parent`.`purchase_prices` as `ww_stopper.linkProduct.purchasePrices.inherited`, COALESCE(`ww_stopper.linkProduct`.`purchase_prices`, `ww_stopper.linkProduct.parent`.`purchase_prices`) as `ww_stopper.linkProduct.purchasePrices`, COALESCE(`ww_stopper.linkProduct`.`mark_as_topseller`, `ww_stopper.linkProduct.parent`.`mark_as_topseller`) as `ww_stopper.linkProduct.markAsTopseller`, COALESCE(`ww_stopper.linkProduct`.`weight`, `ww_stopper.linkProduct.parent`.`weight`) as `ww_stopper.linkProduct.weight`, COALESCE(`ww_stopper.linkProduct`.`width`, `ww_stopper.linkProduct.parent`.`width`) as `ww_stopper.linkProduct.width`, COALESCE(`ww_stopper.linkProduct`.`height`, `ww_stopper.linkProduct.parent`.`height`) as `ww_stopper.linkProduct.height`, COALESCE(`ww_stopper.linkProduct`.`length`, `ww_stopper.linkProduct.parent`.`length`) as `ww_stopper.linkProduct.length`, COALESCE(`ww_stopper.linkProduct`.`release_date`, `ww_stopper.linkProduct.parent`.`release_date`) as `ww_stopper.linkProduct.releaseDate`, COALESCE(`ww_stopper.linkProduct`.`rating_average`, `ww_stopper.linkProduct.parent`.`rating_average`) as `ww_stopper.linkProduct.ratingAverage`, `ww_stopper.linkProduct.parent`.`category_tree` as `ww_stopper.linkProduct.categoryTree.inherited`, COALESCE(`ww_stopper.linkProduct`.`category_tree`, `ww_stopper.linkProduct.parent`.`category_tree`) as `ww_stopper.linkProduct.categoryTree`, `ww_stopper.linkProduct.parent`.`property_ids` as `ww_stopper.linkProduct.propertyIds.inherited`, COALESCE(`ww_stopper.linkProduct`.`property_ids`, `ww_stopper.linkProduct.parent`.`property_ids`) as `ww_stopper.linkProduct.propertyIds`, `ww_stopper.linkProduct.parent`.`option_ids` as `ww_stopper.linkProduct.optionIds.inherited`, COALESCE(`ww_stopper.linkProduct`.`option_ids`, `ww_stopper.linkProduct.parent`.`option_ids`) as `ww_stopper.linkProduct.optionIds`, `ww_stopper.linkProduct.parent`.`stream_ids` as `ww_stopper.linkProduct.streamIds.inherited`, COALESCE(`ww_stopper.linkProduct`.`stream_ids`, `ww_stopper.linkProduct.parent`.`stream_ids`) as `ww_stopper.linkProduct.streamIds`, `ww_stopper.linkProduct.parent`.`tag_ids` as `ww_stopper.linkProduct.tagIds.inherited`, COALESCE(`ww_stopper.linkProduct`.`tag_ids`, `ww_stopper.linkProduct.parent`.`tag_ids`) as `ww_stopper.linkProduct.tagIds`, `ww_stopper.linkProduct.parent`.`category_ids` as `ww_stopper.linkProduct.categoryIds.inherited`, COALESCE(`ww_stopper.linkProduct`.`category_ids`, `ww_stopper.linkProduct.parent`.`category_ids`) as `ww_stopper.linkProduct.categoryIds`, `ww_stopper.linkProduct`.`child_count` as `ww_stopper.linkProduct.childCount`, COALESCE(`ww_stopper.linkProduct`.`custom_field_set_selection_active`, `ww_stopper.linkProduct.parent`.`custom_field_set_selection_active`) as `ww_stopper.linkProduct.customFieldSetSelectionActive`, `ww_stopper.linkProduct`.`sales` as `ww_stopper.linkProduct.sales`, `ww_stopper.linkProduct`.`states` as `ww_stopper.linkProduct.states`, `ww_stopper.linkProduct.tax`.`id` as `ww_stopper.linkProduct.tax.id`, `ww_stopper.linkProduct.tax`.`tax_rate` as `ww_stopper.linkProduct.tax.taxRate`, `ww_stopper.linkProduct.tax`.`name` as `ww_stopper.linkProduct.tax.name`, `ww_stopper.linkProduct.tax`.`position` as `ww_stopper.linkProduct.tax.position`, `ww_stopper.linkProduct.tax`.`custom_fields` as `ww_stopper.linkProduct.tax.customFields`, `ww_stopper.linkProduct.tax`.`created_at` as `ww_stopper.linkProduct.tax.createdAt`, `ww_stopper.linkProduct.tax`.`updated_at` as `ww_stopper.linkProduct.tax.updatedAt`, `ww_stopper.linkProduct`.`created_at` as `ww_stopper.linkProduct.createdAt`, `ww_stopper.linkProduct`.`updated_at` as `ww_stopper.linkProduct.updatedAt`, `ww_stopper.linkProduct.translation.metaDescription`, `ww_stopper.linkProduct.parent.translation.metaDescription`, COALESCE(`ww_stopper.linkProduct.translation.metaDescription`,`ww_stopper.linkProduct.parent.translation.metaDescription`) as `ww_stopper.linkProduct.metaDescription`, `ww_stopper.linkProduct.translation.name`, `ww_stopper.linkProduct.parent.translation.name`, COALESCE(`ww_stopper.linkProduct.translation.name`,`ww_stopper.linkProduct.parent.translation.name`) as `ww_stopper.linkProduct.name`, `ww_stopper.linkProduct.translation.keywords`, `ww_stopper.linkProduct.parent.translation.keywords`, COALESCE(`ww_stopper.linkProduct.translation.keywords`,`ww_stopper.linkProduct.parent.translation.keywords`) as `ww_stopper.linkProduct.keywords`, `ww_stopper.linkProduct.translation.description`, `ww_stopper.linkProduct.parent.translation.description`, COALESCE(`ww_stopper.linkProduct.translation.description`,`ww_stopper.linkProduct.parent.translation.description`) as `ww_stopper.linkProduct.description`, `ww_stopper.linkProduct.translation.metaTitle`, `ww_stopper.linkProduct.parent.translation.metaTitle`, COALESCE(`ww_stopper.linkProduct.translation.metaTitle`,`ww_stopper.linkProduct.parent.translation.metaTitle`) as `ww_stopper.linkProduct.metaTitle`, `ww_stopper.linkProduct.translation.packUnit`, `ww_stopper.linkProduct.parent.translation.packUnit`, COALESCE(`ww_stopper.linkProduct.translation.packUnit`,`ww_stopper.linkProduct.parent.translation.packUnit`) as `ww_stopper.linkProduct.packUnit`, `ww_stopper.linkProduct.translation.packUnitPlural`, `ww_stopper.linkProduct.parent.translation.packUnitPlural`, COALESCE(`ww_stopper.linkProduct.translation.packUnitPlural`,`ww_stopper.linkProduct.parent.translation.packUnitPlural`) as `ww_stopper.linkProduct.packUnitPlural`, `ww_stopper.linkProduct.translation.customSearchKeywords`, `ww_stopper.linkProduct.parent.translation.customSearchKeywords`, COALESCE(`ww_stopper.linkProduct.translation.customSearchKeywords`,`ww_stopper.linkProduct.parent.translation.customSearchKeywords`) as `ww_stopper.linkProduct.customSearchKeywords`, `ww_stopper.linkProduct.translation.slotConfig`, `ww_stopper.linkProduct.parent.translation.slotConfig`, COALESCE(`ww_stopper.linkProduct.translation.slotConfig`,`ww_stopper.linkProduct.parent.translation.slotConfig`) as `ww_stopper.linkProduct.slotConfig`, `ww_stopper.linkProduct.translation.customFields`, `ww_stopper.linkProduct.parent.translation.customFields`, COALESCE(`ww_stopper.linkProduct.translation.customFields`,`ww_stopper.linkProduct.parent.translation.customFields`) as `ww_stopper.linkProduct.customFields`, `ww_stopper`.`link_category_id` as `ww_stopper.linkCategoryId`, `ww_stopper.linkCategory`.`id` as `ww_stopper.linkCategory.id`, `ww_stopper.linkCategory`.`version_id` as `ww_stopper.linkCategory.versionId`, `ww_stopper.linkCategory`.`parent_id` as `ww_stopper.linkCategory.parentId`, `ww_stopper.linkCategory`.`parent_version_id` as `ww_stopper.linkCategory.parentVersionId`, `ww_stopper.linkCategory`.`after_category_id` as `ww_stopper.linkCategory.afterCategoryId`, `ww_stopper.linkCategory`.`after_category_version_id` as `ww_stopper.linkCategory.afterCategoryVersionId`, `ww_stopper.linkCategory`.`media_id` as `ww_stopper.linkCategory.mediaId`, `ww_stopper.linkCategory`.`display_nested_products` as `ww_stopper.linkCategory.displayNestedProducts`, `ww_stopper.linkCategory`.`auto_increment` as `ww_stopper.linkCategory.autoIncrement`, `ww_stopper.linkCategory`.`level` as `ww_stopper.linkCategory.level`, `ww_stopper.linkCategory`.`path` as `ww_stopper.linkCategory.path`, `ww_stopper.linkCategory`.`child_count` as `ww_stopper.linkCategory.childCount`, `ww_stopper.linkCategory`.`type` as `ww_stopper.linkCategory.type`, `ww_stopper.linkCategory`.`product_assignment_type` as `ww_stopper.linkCategory.productAssignmentType`, `ww_stopper.linkCategory`.`visible` as `ww_stopper.linkCategory.visible`, `ww_stopper.linkCategory`.`active` as `ww_stopper.linkCategory.active`, `ww_stopper.linkCategory`.`cms_page_id` as `ww_stopper.linkCategory.cmsPageId`, `ww_stopper.linkCategory`.`cms_page_version_id` as `ww_stopper.linkCategory.cmsPageVersionId`, `ww_stopper.linkCategory`.`product_stream_id` as `ww_stopper.linkCategory.productStreamId`, `ww_stopper.linkCategory`.`custom_entity_type_id` as `ww_stopper.linkCategory.customEntityTypeId`, `ww_stopper.linkCategory`.`created_at` as `ww_stopper.linkCategory.createdAt`, `ww_stopper.linkCategory`.`updated_at` as `ww_stopper.linkCategory.updatedAt`, `ww_stopper.linkCategory.translation.name`, `ww_stopper.linkCategory.translation.name` as `ww_stopper.linkCategory.name`, `ww_stopper.linkCategory.translation.breadcrumb`, `ww_stopper.linkCategory.translation.breadcrumb` as `ww_stopper.linkCategory.breadcrumb`, `ww_stopper.linkCategory.translation.slotConfig`, `ww_stopper.linkCategory.translation.slotConfig` as `ww_stopper.linkCategory.slotConfig`, `ww_stopper.linkCategory.translation.linkType`, `ww_stopper.linkCategory.translation.linkType` as `ww_stopper.linkCategory.linkType`, `ww_stopper.linkCategory.translation.internalLink`, `ww_stopper.linkCategory.translation.internalLink` as `ww_stopper.linkCategory.internalLink`, `ww_stopper.linkCategory.translation.externalLink`, `ww_stopper.linkCategory.translation.externalLink` as `ww_stopper.linkCategory.externalLink`, `ww_stopper.linkCategory.translation.linkNewTab`, `ww_stopper.linkCategory.translation.linkNewTab` as `ww_stopper.linkCategory.linkNewTab`, `ww_stopper.linkCategory.translation.description`, `ww_stopper.linkCategory.translation.description` as `ww_stopper.linkCategory.description`, `ww_stopper.linkCategory.translation.metaTitle`, `ww_stopper.linkCategory.translation.metaTitle` as `ww_stopper.linkCategory.metaTitle`, `ww_stopper.linkCategory.translation.metaDescription`, `ww_stopper.linkCategory.translation.metaDescription` as `ww_stopper.linkCategory.metaDescription`, `ww_stopper.linkCategory.translation.keywords`, `ww_stopper.linkCategory.translation.keywords` as `ww_stopper.linkCategory.keywords`, `ww_stopper.linkCategory.translation.customFields`, `ww_stopper.linkCategory.translation.customFields` as `ww_stopper.linkCategory.customFields`, `ww_stopper`.`created_at` as `ww_stopper.createdAt`, `ww_stopper`.`updated_at` as `ww_stopper.updatedAt`, (SELECT GROUP_CONCAT(HEX(`ww_stopper.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `ww_stopper_stopper_category` `ww_stopper.categories.mapping`
                  WHERE `ww_stopper.categories.mapping`.`ww_stopper_id` = `ww_stopper`.`id` ) as `ww_stopper.categories.id_mapping`, `ww_stopper.translation.title`, `ww_stopper.translation.title` as `ww_stopper.title`, `ww_stopper.translation.linkUrl`, `ww_stopper.translation.linkUrl` as `ww_stopper.linkUrl`, `ww_stopper.translation.linkText`, `ww_stopper.translation.linkText` as `ww_stopper.linkText` FROM `ww_stopper` LEFT JOIN `media` `ww_stopper.media` ON `ww_stopper`.`media_id` = `ww_stopper.media`.`id` LEFT JOIN `product` `ww_stopper.linkProduct` ON `ww_stopper`.`link_product_id` = `ww_stopper.linkProduct`.`id` AND `ww_stopper.linkProduct`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN `category` `ww_stopper.linkCategory` ON `ww_stopper`.`link_category_id` = `ww_stopper.linkCategory`.`id` AND `ww_stopper.linkCategory`.`version_id` = UNHEX("0fa91ce3e96a4bc2be4bd9ce752c3425") LEFT JOIN (SELECT `ww_stopper.translation`.`ww_stopper_id`, `ww_stopper.translation`.`title` as `ww_stopper.translation.title`, `ww_stopper.translation`.`link_url` as `ww_stopper.translation.linkUrl`, `ww_stopper.translation`.`link_text` as `ww_stopper.translation.linkText` FROM `ww_stopper_translation` `ww_stopper.translation` WHERE `ww_stopper.translation`.`language_id` = ?) `ww_stopper.ww_stopper_translation` ON `ww_stopper.ww_stopper_translation`.`ww_stopper_id` = `ww_stopper`.`id` LEFT JOIN (SELECT `ww_stopper.media.translation`.`media_id`, `ww_stopper.media.translation`.`alt` as `ww_stopper.media.translation.alt`, `ww_stopper.media.translation`.`title` as `ww_stopper.media.translation.title`, `ww_stopper.media.translation`.`custom_fields` as `ww_stopper.media.translation.customFields` FROM `media_translation` `ww_stopper.media.translation` WHERE `ww_stopper.media.translation`.`language_id` = ?) `ww_stopper.media.media_translation` ON `ww_stopper.media.media_translation`.`media_id` = `ww_stopper.media`.`id` LEFT JOIN `product` `ww_stopper.linkProduct.parent` ON `ww_stopper.linkProduct`.`parent_id` = `ww_stopper.linkProduct.parent`.`id` AND `ww_stopper.linkProduct`.`parent_version_id` = `ww_stopper.linkProduct.parent`.`version_id` LEFT JOIN `tax` `ww_stopper.linkProduct.tax` ON `ww_stopper.linkProduct`.`tax` = `ww_stopper.linkProduct.tax`.`id` LEFT JOIN (SELECT `ww_stopper.linkProduct.translation`.`product_id`, `ww_stopper.linkProduct.translation`.`product_version_id`, `ww_stopper.linkProduct.translation`.`meta_description` as `ww_stopper.linkProduct.translation.metaDescription`, `ww_stopper.linkProduct.translation`.`name` as `ww_stopper.linkProduct.translation.name`, `ww_stopper.linkProduct.translation`.`keywords` as `ww_stopper.linkProduct.translation.keywords`, `ww_stopper.linkProduct.translation`.`description` as `ww_stopper.linkProduct.translation.description`, `ww_stopper.linkProduct.translation`.`meta_title` as `ww_stopper.linkProduct.translation.metaTitle`, `ww_stopper.linkProduct.translation`.`pack_unit` as `ww_stopper.linkProduct.translation.packUnit`, `ww_stopper.linkProduct.translation`.`pack_unit_plural` as `ww_stopper.linkProduct.translation.packUnitPlural`, `ww_stopper.linkProduct.translation`.`custom_fields` as `ww_stopper.linkProduct.translation.customFields`, `ww_stopper.linkProduct.translation`.`slot_config` as `ww_stopper.linkProduct.translation.slotConfig`, `ww_stopper.linkProduct.translation`.`custom_search_keywords` as `ww_stopper.linkProduct.translation.customSearchKeywords` FROM `product_translation` `ww_stopper.linkProduct.translation` WHERE `ww_stopper.linkProduct.translation`.`language_id` = ?) `ww_stopper.linkProduct.product_translation` ON `ww_stopper.linkProduct.product_translation`.`product_id` = `ww_stopper.linkProduct`.`id` AND `ww_stopper.linkProduct.product_translation`.`product_version_id` = `ww_stopper.linkProduct`.`version_id` LEFT JOIN (SELECT `ww_stopper.linkProduct.parent.translation`.`product_id`, `ww_stopper.linkProduct.parent.translation`.`product_version_id`, `ww_stopper.linkProduct.parent.translation`.`meta_description` as `ww_stopper.linkProduct.parent.translation.metaDescription`, `ww_stopper.linkProduct.parent.translation`.`name` as `ww_stopper.linkProduct.parent.translation.name`, `ww_stopper.linkProduct.parent.translation`.`keywords` as `ww_stopper.linkProduct.parent.translation.keywords`, `ww_stopper.linkProduct.parent.translation`.`description` as `ww_stopper.linkProduct.parent.translation.description`, `ww_stopper.linkProduct.parent.translation`.`meta_title` as `ww_stopper.linkProduct.parent.translation.metaTitle`, `ww_stopper.linkProduct.parent.translation`.`pack_unit` as `ww_stopper.linkProduct.parent.translation.packUnit`, `ww_stopper.linkProduct.parent.translation`.`pack_unit_plural` as `ww_stopper.linkProduct.parent.translation.packUnitPlural`, `ww_stopper.linkProduct.parent.translation`.`custom_fields` as `ww_stopper.linkProduct.parent.translation.customFields`, `ww_stopper.linkProduct.parent.translation`.`slot_config` as `ww_stopper.linkProduct.parent.translation.slotConfig`, `ww_stopper.linkProduct.parent.translation`.`custom_search_keywords` as `ww_stopper.linkProduct.parent.translation.customSearchKeywords` FROM `product_translation` `ww_stopper.linkProduct.parent.translation` WHERE `ww_stopper.linkProduct.parent.translation`.`language_id` = ?) `ww_stopper.linkProduct.parent.product_translation` ON `ww_stopper.linkProduct.parent.product_translation`.`product_id` = `ww_stopper.linkProduct.parent`.`id` AND `ww_stopper.linkProduct.parent.product_translation`.`product_version_id` = `ww_stopper.linkProduct.parent`.`version_id` LEFT JOIN (SELECT `ww_stopper.linkCategory.translation`.`category_id`, `ww_stopper.linkCategory.translation`.`category_version_id`, `ww_stopper.linkCategory.translation`.`breadcrumb` as `ww_stopper.linkCategory.translation.breadcrumb`, `ww_stopper.linkCategory.translation`.`name` as `ww_stopper.linkCategory.translation.name`, `ww_stopper.linkCategory.translation`.`custom_fields` as `ww_stopper.linkCategory.translation.customFields`, `ww_stopper.linkCategory.translation`.`slot_config` as `ww_stopper.linkCategory.translation.slotConfig`, `ww_stopper.linkCategory.translation`.`link_type` as `ww_stopper.linkCategory.translation.linkType`, `ww_stopper.linkCategory.translation`.`internal_link` as `ww_stopper.linkCategory.translation.internalLink`, `ww_stopper.linkCategory.translation`.`external_link` as `ww_stopper.linkCategory.translation.externalLink`, `ww_stopper.linkCategory.translation`.`link_new_tab` as `ww_stopper.linkCategory.translation.linkNewTab`, `ww_stopper.linkCategory.translation`.`description` as `ww_stopper.linkCategory.translation.description`, `ww_stopper.linkCategory.translation`.`meta_title` as `ww_stopper.linkCategory.translation.metaTitle`, `ww_stopper.linkCategory.translation`.`meta_description` as `ww_stopper.linkCategory.translation.metaDescription`, `ww_stopper.linkCategory.translation`.`keywords` as `ww_stopper.linkCategory.translation.keywords` FROM `category_translation` `ww_stopper.linkCategory.translation` WHERE `ww_stopper.linkCategory.translation`.`language_id` = ?) `ww_stopper.linkCategory.category_translation` ON `ww_stopper.linkCategory.category_translation`.`category_id` = `ww_stopper.linkCategory`.`id` AND `ww_stopper.linkCategory.category_translation`.`category_version_id` = `ww_stopper.linkCategory`.`version_id` WHERE `ww_stopper`.`id` IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01‘Ñvz6q:³@¤\ef,\x05î"
  b"\x01’½½Dþrœ™K\x01j\x0EožÓ"
  b"\x01‘Ñ\x7F6U~m­áê6^Eb\x04"
  b"\x01‘Ñ„Ú-yz³ž÷\x01I½JE"
  b"\x01‘цèì|Ïœé\x12r\x0FÈ¢ï"
  b"\x01‘ш ‰{ü—‹.»ð›‚—"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.90%) 		1 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"õ½iA_mMÇ’\x18}2m}”M"
  "wy2YYNheDh4ShnBW8RIjZ97NUlZnDzcW"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(0.82%) 		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.blogAuthor`.`id` as `sas_blog_entries.blogAuthor.id`, `sas_blog_entries.blogAuthor`.`media_id` as `sas_blog_entries.blogAuthor.mediaId`, `sas_blog_entries.blogAuthor`.`salutation_id` as `sas_blog_entries.blogAuthor.salutationId`, `sas_blog_entries.blogAuthor`.`first_name` as `sas_blog_entries.blogAuthor.firstName`, `sas_blog_entries.blogAuthor`.`last_name` as `sas_blog_entries.blogAuthor.lastName`, `sas_blog_entries.blogAuthor`.`email` as `sas_blog_entries.blogAuthor.email`, `sas_blog_entries.blogAuthor`.`display_name` as `sas_blog_entries.blogAuthor.displayName`, `sas_blog_entries.blogAuthor.media`.`id` as `sas_blog_entries.blogAuthor.media.id`, `sas_blog_entries.blogAuthor.media`.`user_id` as `sas_blog_entries.blogAuthor.media.userId`, `sas_blog_entries.blogAuthor.media`.`media_folder_id` as `sas_blog_entries.blogAuthor.media.mediaFolderId`, `sas_blog_entries.blogAuthor.media`.`mime_type` as `sas_blog_entries.blogAuthor.media.mimeType`, `sas_blog_entries.blogAuthor.media`.`file_extension` as `sas_blog_entries.blogAuthor.media.fileExtension`, `sas_blog_entries.blogAuthor.media`.`uploaded_at` as `sas_blog_entries.blogAuthor.media.uploadedAt`, `sas_blog_entries.blogAuthor.media`.`file_name` as `sas_blog_entries.blogAuthor.media.fileName`, `sas_blog_entries.blogAuthor.media`.`file_size` as `sas_blog_entries.blogAuthor.media.fileSize`, `sas_blog_entries.blogAuthor.media`.`media_type` as `sas_blog_entries.blogAuthor.media.mediaTypeRaw`, `sas_blog_entries.blogAuthor.media`.`meta_data` as `sas_blog_entries.blogAuthor.media.metaData`, `sas_blog_entries.blogAuthor.media`.`config` as `sas_blog_entries.blogAuthor.media.config`, `sas_blog_entries.blogAuthor.media`.`path` as `sas_blog_entries.blogAuthor.media.path`, `sas_blog_entries.blogAuthor.media`.`private` as `sas_blog_entries.blogAuthor.media.private`, `sas_blog_entries.blogAuthor.media`.`thumbnails_ro` as `sas_blog_entries.blogAuthor.media.thumbnailsRo`, `sas_blog_entries.blogAuthor.media`.`created_at` as `sas_blog_entries.blogAuthor.media.createdAt`, `sas_blog_entries.blogAuthor.media`.`updated_at` as `sas_blog_entries.blogAuthor.media.updatedAt`, `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation.title` as `sas_blog_entries.blogAuthor.media.title`, `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation.alt` as `sas_blog_entries.blogAuthor.media.alt`, `sas_blog_entries.blogAuthor.media.translation.customFields`, `sas_blog_entries.blogAuthor.media.translation.customFields` as `sas_blog_entries.blogAuthor.media.customFields`, `sas_blog_entries.blogAuthor`.`created_at` as `sas_blog_entries.blogAuthor.createdAt`, `sas_blog_entries.blogAuthor`.`updated_at` as `sas_blog_entries.blogAuthor.updatedAt`, `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation.description` as `sas_blog_entries.blogAuthor.description`, `sas_blog_entries.blogAuthor.translation.customFields`, `sas_blog_entries.blogAuthor.translation.customFields` as `sas_blog_entries.blogAuthor.customFields`, (SELECT GROUP_CONCAT(HEX(`sas_blog_entries.blogCategories.mapping`.`sas_blog_category_id`) SEPARATOR '||')
                  FROM `sas_blog_blog_category` `sas_blog_entries.blogCategories.mapping`
                  WHERE `sas_blog_entries.blogCategories.mapping`.`sas_blog_entries_id` = `sas_blog_entries`.`id` ) as `sas_blog_entries.blogCategories.id_mapping`, `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 `sas_blog_author` `sas_blog_entries.blogAuthor` ON `sas_blog_entries`.`author_id` = `sas_blog_entries.blogAuthor`.`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` LEFT JOIN `media` `sas_blog_entries.blogAuthor.media` ON `sas_blog_entries.blogAuthor`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.translation`.`sas_blog_author_id`, `sas_blog_entries.blogAuthor.translation`.`description` as `sas_blog_entries.blogAuthor.translation.description`, `sas_blog_entries.blogAuthor.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.translation.customFields` FROM `sas_blog_author_translation` `sas_blog_entries.blogAuthor.translation` WHERE `sas_blog_entries.blogAuthor.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.sas_blog_author_translation` ON `sas_blog_entries.blogAuthor.sas_blog_author_translation`.`sas_blog_author_id` = `sas_blog_entries.blogAuthor`.`id` LEFT JOIN (SELECT `sas_blog_entries.blogAuthor.media.translation`.`media_id`, `sas_blog_entries.blogAuthor.media.translation`.`alt` as `sas_blog_entries.blogAuthor.media.translation.alt`, `sas_blog_entries.blogAuthor.media.translation`.`title` as `sas_blog_entries.blogAuthor.media.translation.title`, `sas_blog_entries.blogAuthor.media.translation`.`custom_fields` as `sas_blog_entries.blogAuthor.media.translation.customFields` FROM `media_translation` `sas_blog_entries.blogAuthor.media.translation` WHERE `sas_blog_entries.blogAuthor.media.translation`.`language_id` = ?) `sas_blog_entries.blogAuthor.media.media_translation` ON `sas_blog_entries.blogAuthor.media.media_translation`.`media_id` = `sas_blog_entries.blogAuthor.media`.`id` WHERE `sas_blog_entries`.`id` IN (?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01òëÂpXyì½║=├v\x00º█"
  b"\x01”eS]Û|£ŠB’,˜ìH³"
  b"\x01”c×+I{“´\x1E!1p“ÊŠ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.81%) 		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"\t*ª=¾±I(Ÿ\x1FK\x14=£\x17l"
  b"\x13ÍÑ9¥┘BÉÆ´2\x16░/Ƕ"
  b"`²\x17\x06JÉO—”Å·÷8’á×"
  b"bRC:┘iIÖØ┴³}ı│?""
  b"×Ïî]\x13ÙJ-³ø\x19À¥·W>"
  b"áàeìëŒO[¨ÙÓ\ð.ž2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.74%) 		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`.`parent_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x00\x16½*\x01+FÙGÀà\x14”|3"
  b"\x01ÉÚ\x05e4|óñ¦═Ú─\x05¿¾"
  b"\x01ÉÚ\x088Ív%º\x01ØçÉ×}."
  b"\x01ÉÚFãù~\x10ƺsÖ\x13¿\x05\x11"
  b"\x01ÉÚG\r_té║═]þ¡±*┴"
  b"\x01ÉÚG?¯sÌø}▄H¹ÏáÎ"
  b"\x01ÉÚX|¸w╬è┐[\x00@ÌóÀ"
  b"\x01ÉÚXÉ┐{ý½S²!£.*î"
  b"\x01ÉÚXú¬| »\x04ÙùÑþ'["
  b"\x01‘PÖà£z—‡B8Eés2z"
  b"\x01‘P×\x03+y\x02—\x08Ôq¨\x17‘i"
  b"\x01‘Pí|fz9™G\fËÁp*I"
  b"\x01‘Q\x07\rŠt°ŸæG›\x1FT¥£"
  b"\x01‘Q\x07º‚sž¾\x07á/¼GFç"
  b"\x01‘Q\x07Íd~Õ•\x0Fô\fúÄ£*"
  b"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"\x01‘ñU¿1q›£`”d\x18\x01ª’"
  b"\x01’*\x02¿!u|¯\x06κ\x1FÆ\x1D•"
  b"\x03\x1A¡p\fÏLH¼ñ¯Mú\x1A\x1E×"
  b"\f█ج\t·Me©Û\x01õU×N²"
  b"\rÍV\x11bûAl—\x15¹ØÆ\x00ßü"
  b"\x10«ßª2\x0FDá fãN\x02iOí"
  b"\x12\x17ü#¯\x16I¶Žø60\t” ^"
  b"\x16J–½}CBÞˆ\e7†|vvw"
  b"""
    \x17ƒ\n
    \n
    ï&M¿ªH™NlVê°
    """
  b"\x18¥è-\x01¥O\f¤›S\x13\eþaV"
  b"""
    \x1D\x01ÛÛOÃAÜš)\n
    yE„»|
    """
  b"\x1F░^a\x00>B\x1DìÏ┌¼¿cöo"
  b" \rn Æ­NÎìô\x15oD┼▄┼"
  b""‹P†™[G—²Êc\x18Dº=D"
  b"%ú”\x06ûK@y·Ã¢´ôÿ¤~"
  b"'0À▀DÕORá\x7Fü\x06Sw]\x14"
  b")à@XRUCœžOΟÈ晳"
  b",6ë2´úCºƒ\x1C\x15ÅͨÀJ"
  b",h\r~ÚûEN¶‚vëõnlC"
  b"/#ÎzŸïB\e‡\x12¨9ˆC¢\x12"
  b"1Û\x06ã/G@\x00³‹s\v¨Ëzf"
  b"2Æ¥ù╚ÌNs│×ZqÒÅ║╣"
  b"2Øı\x1DoÏB:û\x0E|Å&¦\x00è"
  b"6`Æì|»KQ´rãñ|´§ë"
  b"7Ea@ÉüH‘¾=\x1Dƒ—n%¯"
  b"8÷rOYEKĤN\x19’KÔ¤Ï"
  b"?N¦êŒÃDÁ³\x10™\x0F‰›@j"
  b"?ÊhieÄO\x0FŒÁ\r}ë©€e"
  b"Bq\x10y\x00ÖM:üp}┤▓ué³"
  b"B¡´¡¾ƒG†Š\x00¡œo/ѽ"
  b"J~S\x08 ÖF…¸§•\x1A³5Ö6"
  b"PKù_┬íN¨ì´¥¢HÈ╬V"
  b"""
    Sñ╣╝£üB\x1Dá╔=\x1D­Ë\n
    \x05
    """
  b"V╦ì¶Ç%D3ÿ\x03n¥ê®Ò~"
  b"X‘zl\x1E\x1FHØ¡6\x00\x14ll>‚"
  b"ZÉ¢Î│zMWü!ıþW\x1E\x7F2"
  b"]Uz\x1E\x0E)@kü■.$åÂß\x1A"
  b"^\x15áH­jLá‰à\vÌo\x03~Ä"
  b"`98­}(Aĉ.z—m3óU"
  b"a\x05Å─+$L\x17à┤\\x105ãoV"
  b"cÔ\x03cæåKõ§§É÷ð^┬"
  b"e\x1E8\x02+¬G™…\fÜ-™‹g&"
  b"g\x13t4¬üHüøjð─Ú9Í"
  b"lÙ‡‹YnO\x08¡­\t÷)\ð¼"
  b"ph\x02¨´\rDçÍéÎÃc»ê"
  b"p¯ÅÄ>íM\x1E¤Òã‹0tµÝ"
  b"q†ëûV:A\t‰Ü=é›îÅÊ"
  b"uÞŒÞ\x18±Oæ›ÎÈA„—“\"
  b"vñŠEž­I3§Ä€ñ(ˆN."
  b"xoH¨ç7GŸ҈{tÙ¥â"
  b"x¼Á%=âGq”C͸¸^k«"
  b"{Å╠Ǩ█C▓½)┘Å¿)\x06Ð"
  b"|·Kd²\tAתû\x19´._/à"
  b"|ÿ••F]I\x7F…ö°ï7ìÊ‘"
  b"é¢B\esQB╗ØIÌL¹lYp"
  b"àÆ‗-¥AOþÅa&\x07ÑÕ{:"
  b"åâ\v83ÇG ü─Í╔£4VÕ"
  b"‡eïïŠEN,¼æ¬{l]Ý$"
  b"çuüý®òC÷ømÈ7ÐÕ"1"
  b"ëä^»╚ÂOG½ü±w\x02ÙS{"
  b"ŠugÆÈEB³µ\x12æl‡ŒBÚ"
  b"‹C \v8ÖM¿»“Z\x17¤¨Çf"
  b"ïz¿2K¥A4»pÐIų¿*"
  b"Å\t÷Sá▀Cüó§2Ï3┼╝\x03"
  b"æ¬I\x13q\x04EqØÆÅG`═_r"
  b"’\x0Ey\\x12¿Dê…$œÉ*ÖñÇ"
  b"“\x05¾ÒzÿKû‰­ï\x06\e\x17ìë"
  b"•_5Ì¡TOÛ£DgpÏʵ¾"
  b"––Ÿ/ªþCh±ä8 k»Õã"
  b"–×\x03óå\x18E%­ê‡Ôò£C¶"
  b"˜\x17¢\x03‚mF&€®õ&\x18ZnF"
  b"™õî:[ÖH'š\x1C(P—6Ø÷"
  b"§X\x06`*±H\x1Aƒ`ØJv\x00¡ÿ"
  b"©\x03Ð\x01è-Lpž%E\x17oį¶"
  b"¬ylJ§\x07J²íùÉ╔\x19rÃ\x1C"
  b"¬ç?ÎJ\x18Cœ¥\x07åïŠb\x14\x05"
  b"®b¬¾\bJá¦Ë:¡K"™1"
  b"▒╦é\x17bJ¸ì╗¤\x13cF▄┤"
  b"""
    ▓ËG1\v¿Dzؼ܃å\n
    \x07Å
    """
  b"┤[╝%SÍGòØG┴\f;Ôìp"
  b"µn&/ô4N\t»YdCÀ\x1C\x04À"
  b"¸¾;¶e\vEš£\x19.9_J€á"
  b"¾…PSŠ)B:¡î€\x0F\Þa¨"
  b"¾è.\x19šîCî¼EŠWpcbÊ"
  b"Â8VÖ\x08òB}‹ð ߌTÜÈ"
  b"""
    ├B\n
    ƒü│G╣É/ \ÂLQo
    """
  b"╚Ý▒t═µJ0É/ Ñoûv┴"
  b"ÌÙ~¡¬\eHF‹Ï\x1DÙkÑ×3"
  b"Í¢"˜‘\tFR‘Zç×g¦Â´"
  b"×&¶%Ñ CS²ƒË§Í\x0E_Ï"
  b"ÙØ’\x07¡\x0EF1žæhB^o¼¤"
  b"Ò,\x15SLTH}üc\x060×Ò▀y"
  b"亽 \x14rME²¥\x13b­©0\x00"
  b"þr\x17\x1E╠òClôÍ÷Ù┴ü7Ó"
  b"Þ\x10\t:û\e@└ÄKdñüæ$J"
  b"ÙîNî\x0EÙMa®╠öüöð87"
  b"íaîa\x12óI¹‡gù\f§£\x159"
  b"±ƒØ\x07ºËGq╗\x00Mg<@\x05╩"
  b"ö\x07\x03b‹ïDê³ø\x08k„FñB"
  b"øiÁ³R˜G\x03„+FÞe\x15NÚ"
  b"úÁ­UiÈIe‡c\x1C´ãÅJ±"
  b"üi·ç$à@ˆ›\fñ-¥\x05Ól"
  b"ÿõ<Dˆ¶H©¹Ý\t^S»$@"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.73%) 		2 
SELECT `kplngi_productcategoryposition`.`id` as `kplngi_productcategoryposition.id`, `kplngi_productcategoryposition`.`product_id` as `kplngi_productcategoryposition.productId`, `kplngi_productcategoryposition`.`category_id` as `kplngi_productcategoryposition.categoryId`, `kplngi_productcategoryposition`.`product_parent_id` as `kplngi_productcategoryposition.productParentId`, `kplngi_productcategoryposition`.`position` as `kplngi_productcategoryposition.position`, `kplngi_productcategoryposition`.`created_at` as `kplngi_productcategoryposition.createdAt`, `kplngi_productcategoryposition`.`updated_at` as `kplngi_productcategoryposition.updatedAt` FROM `kplngi_productcategoryposition` WHERE `kplngi_productcategoryposition`.`id` IN (?)
Parameters: 
[
  b"\x01‘W£÷ýq!¨à 99¢á2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.72%) 		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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(0.72%) 		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"RÉÇ¥ÉÜLÖ¢²â╗d->["
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.65%) 		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`.`parent_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01ÉÚ\x05% p¿Ø\x17«ıÕRËm"
  b"\x06à…\x1AÁUI­¶¢( 3í6\x19"
  b"\e„«l‚{Gû±»=È,\x03\x0EE"
  b"@(HÎ┐┌@·îÐ#┬?Éú‗"
  b"RêÛÂ5òAKŸ*¿’¼='E"
  b"TËõ||„Ar‘¾tâ\r3™#"
  b"X-\x16ü£®MÖ¡ÖBX?0å\x1F"
  b"…9ú\vψO¶™-)Re%°Â"
  b"ˆQÆê¿ŠE™›\f%œ"‘ùV"
  b"ªý³Ãž\x00L\x05…\nQa.\x18u¬"
  b"ìi\x13\x04”öMͦ\x7F\efî\x15éD"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.18 ms
(0.58%) 		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`.`parent_id` = ? AND `category`.`active` = ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"¤ë¨[\x19OHB•áÛ6„‡Ù˜"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.54%) 		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`.`author_id` IN (?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x01Æ3åÅ©z#«\f╠ȸö┴╦"
  b"\x01’3‡\x1C3px§¯)%Ä÷Þ×"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(0.52%) 		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>Ð"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.48%) 		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`.`parent_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01\ÞÕŸ–CË»š¾6þ&…<"
  b"\x01ÉÚ\x06\x7FBs\t»\x02ƒ¼┌\x17Ôy"
  b"\x01ÉÚ\x06£Æ~ýÀ│|À\fê\±"
  b"\x01ÉÚ\x06»Y{À¡§┼\tGë┤Ã"
  b"\x01ÉÚ\x06┬ð|½Æ■êì"!┐2"
  b"\x01ÉÚ\x06¦¬\x7Fï┐M\x10A┐Ê╩a"
  b"\x01ÉÚ\x06±ü{╠ª┘S0g¤¨}"
  b"\x01ÉÚ\x07\x03F\x7F\x05û\f▀9=+ô4"
  b"\x01ÉÚ\x10l×wóÁo·F¸i­î"
  b"\x01ÉÚ\x10Çúw{âOê¢\x1C¤sÖ"
  b"\x01ÉÚG╩ãr\x05ÆÐ<ÄãÕ2Ê"
  b"\x01ÉÚGÓ!s¶ÿ\x06\x7FT|úJ\x00"
  b"\x01ÉÚH\x00\x02{╗Â┬╚■}3ÃM"
  b"\x01ÉÚH !yz╣ã┬ï╠åSd"
  b"\x01ÉÚHC¼w\x08ïsÔËzÂÕ¾"
  b"\x01ÉÚK\x13×pȃsL\x7F\rD~▒"
  b"""
    \x01ÉÚKSyy\x0E«\x0FKúıì\n
    «
    """
  b"\x01ÉÚKrc|░ô] ▓6║mø"
  b"\x01ÉÚKâÝqYºðì┼åL«<"
  b"\x01ÉÚKöQ{ ╣\x12*[x¥xù"
  b"\x01ÉÚMDõ}öº‗\x05©[\x15På"
  b"""
    \x01ÉÚM\Ôt\n
    ѪX¼_hË╬
    """
  b"\x01ÉÚU¥\x04r´Æk\t5ç«ý%"
  b"\x01ÉÚUÍÊvÌÉ\x14D─í+Nî"
  b"\x01ÉÚW9&\x7FÇÖÝüª£S\x03Ó"
  b"\x01ɯdócpQ®Ã┴yá«▄å"
  b"\x01‘PÕýIq8‹¢›¥Õ]rø"
  b"\x01‘Pë\x07ˆpÌ»'\x18ÿ[+…&"
  b"\x01‘Pë¤ft¹…éZíÒòŒN"
  b"\x01‘PíÚµ}†¿LM^¯æ±W"
  b"\x01–^¬ê@\x7Fª¦˜š°¤Za&"
  b"\x01–^­\f³~I•1>Ð2¨r5"
  b"""
    \x04\x7FÑVjÉC0ÖªïDé@\n
    ;
    """
  b"\x04ô¾išúFš˜XÇ›\x02ÁKÖ"
  b"\x08Y\x7F═²3A׬@Ý╬Ó.\x10ì"
  b"\v6\fð";BwžúåR_™¤ø"
  b"\x11ÄoØÍ\x1C@2 &¦óY\fÐh"
  b"\x1AŒa<ø5LF¥\x1A¤}q\x1D\x7FQ"
  b"":sÞÛ×Moždkû&ÁvD"
  b"$A½!Tö@½±¶½U\x0FÄ(B"
  b")oBÜ5░E╠ìrÆz\x1F\x1FCÖ"
  b"*╠±\x00YKJ\x18©eHÕsükT"
  b",Q\féStN\x01žaÓÉ\x1A&60"
  b"7wA╚|╗Oü¡ñ┐ó&:ô'"
  b"Gt\x04²~ØJÀàåÓÊn&oï"
  b"R†\x05D¤!B’’#ܘ?VHh"
  b"RÉÇ¥ÉÜLÖ¢²â╗d->["
  b"SîÔÌ\x11‡@"°\rl"$6\x1CÙ"
  b"\Vç|Pn@ƒž¸äo¾0\x1A/"
  b"\­\x1Fzá˜Iõ¬NUÙ"¨¸¯"
  b"^Ša\x0El¤O†ŠnHÌ\rØïî"
  b"_\x0F&\x15~'G\x1D—[ÇÌ\x1A7eD"
  b"_Ì¡7Ä—H,—\x1ERŠY¬V‚"
  b"h,>\x12R\x04IŸ¾B«\x14ºKè¼"
  b"iÏi©Ã\x01A\x19´è\f÷Z\x0EÞ§"
  b"jVmŶ¡A\x1D©W1¸›^˧"
  b"j³ð‗¬\x00O¤Éþ]&ÇNj║"
  b"oʲ$ÒbK\x1D‡Š'²5s£°"
  b"qƒ\x1F\x165‡J£ªÉT\x07–{{t"
  b"z.äö8{A\x03²u³:íîÂÒ"
  b"\x7F┌¢µêöIü│r░K0-J▒"
  b"ƒ¦eX(ÈOÅ¿·îªi¶\x020"
  b"ú\x1FR³╬:J¯üx¸hJFé;"
  b"¥u@ºò@J\x14¾¦¶E冤¼"
  b"¨A4ßQFI)š^t¡5½b\x02"
  b"«h×Y©ÜG¨Œ\f$×o8\x12q"
  b"®%HœªUOd©bÕžÃaDy"
  b"»\x1A┌ŧ\x00A▓ºÏ!J│Çsþ"
  b"º6\x10k\x03½Oà»\t÷±«i“\x14"
  b"Ê\x18š?F\x01AÞ•\x13ýqŒ /’"
  b"ÊŽZW9ûMå à'Y›\x1FÌ!"
  b"ËçvòñtEµ·\x1AMÍ\x1F\x17hM"
  b"ÌF\x19ÁÞ"OÄœ‡ú’®C\x18 "
  b"ß‹\x13'Ü[Cù¼Ò¤¬Ù\x12’¼"
  b"þÅÒ(ÀÈK-▓Qåz┌»M@"
  b"ò\x1FÞ‹¼}I[‚\x01XT9 àS"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.46%) 		1 
# category::cms-page::association::sections::read
SELECT `cms_section`.`id` as `cms_section.id`, `cms_section`.`position` as `cms_section.position`, `cms_section`.`type` as `cms_section.type`, `cms_section`.`locked` as `cms_section.locked`, `cms_section`.`name` as `cms_section.name`, `cms_section`.`sizing_mode` as `cms_section.sizingMode`, `cms_section`.`mobile_behavior` as `cms_section.mobileBehavior`, `cms_section`.`background_color` as `cms_section.backgroundColor`, `cms_section`.`background_media_id` as `cms_section.backgroundMediaId`, `cms_section`.`background_media_mode` as `cms_section.backgroundMediaMode`, `cms_section`.`css_class` as `cms_section.cssClass`, `cms_section`.`cms_page_id` as `cms_section.pageId`, `cms_section`.`visibility` as `cms_section.visibility`, `cms_section`.`custom_fields` as `cms_section.customFields`, `cms_section`.`version_id` as `cms_section.versionId`, `cms_section`.`cms_page_version_id` as `cms_section.cmsPageVersionId`, `cms_section`.`created_at` as `cms_section.createdAt`, `cms_section`.`updated_at` as `cms_section.updatedAt`, `cms_section.backgroundMedia`.`id` as `cms_section.backgroundMedia.id`, `cms_section.backgroundMedia`.`user_id` as `cms_section.backgroundMedia.userId`, `cms_section.backgroundMedia`.`media_folder_id` as `cms_section.backgroundMedia.mediaFolderId`, `cms_section.backgroundMedia`.`mime_type` as `cms_section.backgroundMedia.mimeType`, `cms_section.backgroundMedia`.`file_extension` as `cms_section.backgroundMedia.fileExtension`, `cms_section.backgroundMedia`.`uploaded_at` as `cms_section.backgroundMedia.uploadedAt`, `cms_section.backgroundMedia`.`file_name` as `cms_section.backgroundMedia.fileName`, `cms_section.backgroundMedia`.`file_size` as `cms_section.backgroundMedia.fileSize`, `cms_section.backgroundMedia`.`media_type` as `cms_section.backgroundMedia.mediaTypeRaw`, `cms_section.backgroundMedia`.`meta_data` as `cms_section.backgroundMedia.metaData`, `cms_section.backgroundMedia`.`config` as `cms_section.backgroundMedia.config`, `cms_section.backgroundMedia`.`path` as `cms_section.backgroundMedia.path`, `cms_section.backgroundMedia`.`private` as `cms_section.backgroundMedia.private`, `cms_section.backgroundMedia`.`thumbnails_ro` as `cms_section.backgroundMedia.thumbnailsRo`, `cms_section.backgroundMedia`.`created_at` as `cms_section.backgroundMedia.createdAt`, `cms_section.backgroundMedia`.`updated_at` as `cms_section.backgroundMedia.updatedAt`, `cms_section.backgroundMedia.translation.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"2ŒÛcTãOæ†+3\x14í¯›å"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.41%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.39%) 		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"7oÝ hêE-  `Ì"b2ø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.37%) 		1 
SELECT `sas_blog_category`.`id` as `sas_blog_category.id`, `sas_blog_category`.`version_id` as `sas_blog_category.versionId`, `sas_blog_category`.`parent_id` as `sas_blog_category.parentId`, `sas_blog_category`.`parent_version_id` as `sas_blog_category.parentVersionId`, `sas_blog_category`.`after_category_id` as `sas_blog_category.afterCategoryId`, `sas_blog_category`.`level` as `sas_blog_category.level`, `sas_blog_category`.`path` as `sas_blog_category.path`, `sas_blog_category`.`child_count` as `sas_blog_category.childCount`, `sas_blog_category`.`created_at` as `sas_blog_category.createdAt`, `sas_blog_category`.`updated_at` as `sas_blog_category.updatedAt`, `sas_blog_category.translation.name`, `sas_blog_category.translation.name` as `sas_blog_category.name`, `sas_blog_category.translation.breadcrumb`, `sas_blog_category.translation.breadcrumb` as `sas_blog_category.breadcrumb`, `sas_blog_category.translation.customFields`, `sas_blog_category.translation.customFields` as `sas_blog_category.customFields` FROM `sas_blog_category` LEFT JOIN (SELECT `sas_blog_category.translation`.`sas_blog_category_id`, `sas_blog_category.translation`.`sas_blog_category_version_id`, `sas_blog_category.translation`.`name` as `sas_blog_category.translation.name`, `sas_blog_category.translation`.`custom_fields` as `sas_blog_category.translation.customFields`, `sas_blog_category.translation`.`breadcrumb` as `sas_blog_category.translation.breadcrumb` FROM `sas_blog_category_translation` `sas_blog_category.translation` WHERE `sas_blog_category.translation`.`language_id` = ?) `sas_blog_category.sas_blog_category_translation` ON `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_id` = `sas_blog_category`.`id` AND `sas_blog_category.sas_blog_category_translation`.`sas_blog_category_version_id` = `sas_blog_category`.`version_id` WHERE (`sas_blog_category`.`version_id` = ?) AND (`sas_blog_category`.`id` IN (?, ?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"\x01‘½.C uyŠÍ´Ñ$—‹-"
  b"\x01‘½.»ÐqÏ­NÀ\x13=³"1"
  b"\x01‘½.YÙqé¡k™i¢¤áe"
  b"\x01æ¢.ëÂ}ı│°@åìçýY"
  b"\x0Fy\x06™¿>CÉ«ò7Žj—%Ø"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.37%) 		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"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"\x01‘ŽµB‡yå³C‚Š\f'™Ÿ"
  b"lÙ‡‹YnO\x08¡­\t÷)\ð¼"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.37%) 		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"2ŒÛcTãOæ†+3\x14í¯›å"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.35%) 		1 
# category::cms-page::association::sections::association::blocks::read
SELECT `cms_block`.`id` as `cms_block.id`, `cms_block`.`position` as `cms_block.position`, `cms_block`.`type` as `cms_block.type`, `cms_block`.`locked` as `cms_block.locked`, `cms_block`.`name` as `cms_block.name`, `cms_block`.`section_position` as `cms_block.sectionPosition`, `cms_block`.`margin_top` as `cms_block.marginTop`, `cms_block`.`margin_bottom` as `cms_block.marginBottom`, `cms_block`.`margin_left` as `cms_block.marginLeft`, `cms_block`.`margin_right` as `cms_block.marginRight`, `cms_block`.`background_color` as `cms_block.backgroundColor`, `cms_block`.`background_media_id` as `cms_block.backgroundMediaId`, `cms_block`.`background_media_mode` as `cms_block.backgroundMediaMode`, `cms_block`.`css_class` as `cms_block.cssClass`, `cms_block`.`visibility` as `cms_block.visibility`, `cms_block`.`cms_section_id` as `cms_block.sectionId`, `cms_block`.`custom_fields` as `cms_block.customFields`, `cms_block`.`version_id` as `cms_block.versionId`, `cms_block`.`cms_section_version_id` as `cms_block.cmsSectionVersionId`, `cms_block`.`created_at` as `cms_block.createdAt`, `cms_block`.`updated_at` as `cms_block.updatedAt`, `cms_block.backgroundMedia`.`id` as `cms_block.backgroundMedia.id`, `cms_block.backgroundMedia`.`user_id` as `cms_block.backgroundMedia.userId`, `cms_block.backgroundMedia`.`media_folder_id` as `cms_block.backgroundMedia.mediaFolderId`, `cms_block.backgroundMedia`.`mime_type` as `cms_block.backgroundMedia.mimeType`, `cms_block.backgroundMedia`.`file_extension` as `cms_block.backgroundMedia.fileExtension`, `cms_block.backgroundMedia`.`uploaded_at` as `cms_block.backgroundMedia.uploadedAt`, `cms_block.backgroundMedia`.`file_name` as `cms_block.backgroundMedia.fileName`, `cms_block.backgroundMedia`.`file_size` as `cms_block.backgroundMedia.fileSize`, `cms_block.backgroundMedia`.`media_type` as `cms_block.backgroundMedia.mediaTypeRaw`, `cms_block.backgroundMedia`.`meta_data` as `cms_block.backgroundMedia.metaData`, `cms_block.backgroundMedia`.`config` as `cms_block.backgroundMedia.config`, `cms_block.backgroundMedia`.`path` as `cms_block.backgroundMedia.path`, `cms_block.backgroundMedia`.`private` as `cms_block.backgroundMedia.private`, `cms_block.backgroundMedia`.`thumbnails_ro` as `cms_block.backgroundMedia.thumbnailsRo`, `cms_block.backgroundMedia`.`created_at` as `cms_block.backgroundMedia.createdAt`, `cms_block.backgroundMedia`.`updated_at` as `cms_block.backgroundMedia.updatedAt`, `cms_block.backgroundMedia.translation.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"\x01ŽðªÃ\x05t\e‘’›\x12˜'óD"
  b"w&▀WñóAnÉ\x110¤Þ─ı┘"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.35%) 		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%"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.33%) 		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.08 ms
(0.27%) 		1 
# product-price-calculator::units::read
SELECT `unit`.`id` as `unit.id`, `unit`.`created_at` as `unit.createdAt`, `unit`.`updated_at` as `unit.updatedAt`, `unit.translation.shortCode`, `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.08 ms
(0.26%) 		1 
# category::cms-page::association::sections::association::blocks::association::slots::read
SELECT `cms_slot`.`id` as `cms_slot.id`, `cms_slot`.`version_id` as `cms_slot.versionId`, `cms_slot`.`type` as `cms_slot.type`, `cms_slot`.`slot` as `cms_slot.slot`, `cms_slot`.`locked` as `cms_slot.locked`, `cms_slot`.`cms_block_id` as `cms_slot.blockId`, `cms_slot`.`cms_block_version_id` as `cms_slot.cmsBlockVersionId`, `cms_slot`.`created_at` as `cms_slot.createdAt`, `cms_slot`.`updated_at` as `cms_slot.updatedAt`, `cms_slot.translation.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"\x01Žð«%RpM‚êÀï\x1A\x14H&"
  b"\x01Åå¸\x13Ã|1ë\vÙúH0j╣"
  b"\x01æÅ:@3sM©┴╗Ë\x08óú\n"
  b"\x01Žð®*,y\x1D©\tÉ—ýÛ†‹"
  b"\x01æÉ\x05L(zdò.fÿ:®õË"
  b"\x01æÉ\x05░\vsô¼¥È\tô╦/┼"
  b"ª&züv™D\t›´ÿýw¿ýE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.25%) 		1 
SELECT `ww_stopper`.`id` FROM `ww_stopper` WHERE (`ww_stopper`.`active` = ?) ORDER BY `ww_stopper`.`position` ASC
Parameters: 
[
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.08 ms
(0.24%) 		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.07 ms
(0.23%) 		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.07 ms
(0.23%) 		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.07 ms
(0.21%) 		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.06 ms
(0.20%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.06 ms
(0.20%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.06 ms
(0.19%) 		1 
SELECT active FROM `app` WHERE name = ?
Parameters: 
[
  "ReqserApp"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.06 ms
(0.19%) 		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
0.05 ms
(0.17%) 		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"7oÝ hêE-  `Ì"b2ø"
  b"\x18çW\x08\x160NÞ•¢¦”Pi8Ú"
  b"\x04\x03 %‘ÑIó‚Aí•\x05§\x19\x13"
  b"ÄÅÂ`ÔÿL3Š¼ãîÔ€ÎS"
  b"\x07»»\x06iÐHQ–z›\x02›ï¼í"
  b"l\x16—_ÚäKݳҳ1\x1Fïâ³"
]
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.