GET https://tictoys.dataneo.dev/blog/detail/4679f6c71b844d6aa90ef67b2f8484a5

Response
200 OK
IP
216.73.216.238
Profiled on
Token
8c091a

Query Metrics

114 Database Queries
80 Different statements
37.71 ms Query time

Grouped Statements

Show all queries

Time▼ Count Info
3.66 ms
(9.71%) 		6 
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b" V\x02r#BN:Ž÷{Æf\x0FýÛ"
]
View formatted query    View runnable query    Explain query    View query backtrace
2.27 ms
(6.02%) 		2 
-- header::navigation::read
SELECT `category`.`id` as `category.id`, `category`.`version_id` as `category.versionId`, `category`.`parent_id` as `category.parentId`, `category`.`parent_version_id` as `category.parentVersionId`, `category`.`after_category_id` as `category.afterCategoryId`, `category`.`after_category_version_id` as `category.afterCategoryVersionId`, `category`.`media_id` as `category.mediaId`, `category`.`display_nested_products` as `category.displayNestedProducts`, `category`.`auto_increment` as `category.autoIncrement`, `category`.`level` as `category.level`, `category`.`path` as `category.path`, `category`.`child_count` as `category.childCount`, `category`.`type` as `category.type`, `category`.`product_assignment_type` as `category.productAssignmentType`, `category`.`visible` as `category.visible`, `category`.`active` as `category.active`, `category`.`cms_page_id` as `category.cmsPageId`, `category`.`cms_page_version_id` as `category.cmsPageVersionId`, `category`.`product_stream_id` as `category.productStreamId`, `category`.`custom_entity_type_id` as `category.customEntityTypeId`, `category`.`created_at` as `category.createdAt`, `category`.`updated_at` as `category.updatedAt`, `category.media`.`id` as `category.media.id`, `category.media`.`user_id` as `category.media.userId`, `category.media`.`media_folder_id` as `category.media.mediaFolderId`, `category.media`.`mime_type` as `category.media.mimeType`, `category.media`.`file_extension` as `category.media.fileExtension`, `category.media`.`uploaded_at` as `category.media.uploadedAt`, `category.media`.`file_name` as `category.media.fileName`, `category.media`.`file_size` as `category.media.fileSize`, `category.media`.`media_type` as `category.media.mediaTypeRaw`, `category.media`.`meta_data` as `category.media.metaData`, `category.media`.`config` as `category.media.config`, `category.media`.`path` as `category.media.path`, `category.media`.`private` as `category.media.private`, `category.media`.`thumbnails_ro` as `category.media.thumbnailsRo`, `category.media`.`file_hash` as `category.media.fileHash`, `category.media`.`created_at` as `category.media.createdAt`, `category.media`.`updated_at` as `category.media.updatedAt`, `category.media.translation.title`, `category.media.translation.title` as `category.media.title`, `category.media.translation.alt`, `category.media.translation.alt` as `category.media.alt`, `category.media.translation.customFields`, `category.media.translation.customFields` as `category.media.customFields`, `category.translation.name`, `category.translation.name` as `category.name`, `category.translation.breadcrumb`, `category.translation.breadcrumb` as `category.breadcrumb`, `category.translation.slotConfig`, `category.translation.slotConfig` as `category.slotConfig`, `category.translation.linkType`, `category.translation.linkType` as `category.linkType`, `category.translation.internalLink`, `category.translation.internalLink` as `category.internalLink`, `category.translation.externalLink`, `category.translation.externalLink` as `category.externalLink`, `category.translation.linkNewTab`, `category.translation.linkNewTab` as `category.linkNewTab`, `category.translation.description`, `category.translation.description` as `category.description`, `category.translation.metaTitle`, `category.translation.metaTitle` as `category.metaTitle`, `category.translation.metaDescription`, `category.translation.metaDescription` as `category.metaDescription`, `category.translation.keywords`, `category.translation.keywords` as `category.keywords`, `category.translation.customFields`, `category.translation.customFields` as `category.customFields` FROM `category` LEFT JOIN `media` `category.media` ON `category`.`media_id` = `category.media`.`id` LEFT JOIN (SELECT `category.translation`.`category_id`, `category.translation`.`category_version_id`, `category.translation`.`breadcrumb` as `category.translation.breadcrumb`, `category.translation`.`name` as `category.translation.name`, `category.translation`.`custom_fields` as `category.translation.customFields`, `category.translation`.`slot_config` as `category.translation.slotConfig`, `category.translation`.`link_type` as `category.translation.linkType`, `category.translation`.`internal_link` as `category.translation.internalLink`, `category.translation`.`external_link` as `category.translation.externalLink`, `category.translation`.`link_new_tab` as `category.translation.linkNewTab`, `category.translation`.`description` as `category.translation.description`, `category.translation`.`meta_title` as `category.translation.metaTitle`, `category.translation`.`meta_description` as `category.translation.metaDescription`, `category.translation`.`keywords` as `category.translation.keywords` FROM `category_translation` `category.translation` WHERE `category.translation`.`language_id` = ?) `category.category_translation` ON `category.category_translation`.`category_id` = `category`.`id` AND `category.category_translation`.`category_version_id` = `category`.`version_id` LEFT JOIN (SELECT `category.media.translation`.`media_id`, `category.media.translation`.`alt` as `category.media.translation.alt`, `category.media.translation`.`title` as `category.media.translation.title`, `category.media.translation`.`custom_fields` as `category.media.translation.customFields` FROM `media_translation` `category.media.translation` WHERE `category.media.translation`.`language_id` = ?) `category.media.media_translation` ON `category.media.media_translation`.`media_id` = `category.media`.`id` WHERE (`category`.`version_id` = ?) AND (((`category`.`id` = ? OR (`category`.`path` LIKE ? AND (`category`.`level` > ? AND `category`.`level` <= ?)))))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"»vß7PÏB…»èé=ÚhqW"
  "%|bb76df3750cf4285bbe8e93dda687157|%"
  1
  4
]
View formatted query    View runnable query    Explain query    View query backtrace
1.66 ms
(4.40%) 		1 
SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, COALESCE(`product`.`open_graph_media_id`, `product.parent`.`open_graph_media_id`) as `product.openGraphMediaId`, `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`.`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`.`type` as `product.type`, `product`.`states` as `product.states`, `product`.`available_stock` as `product.availableStock`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.shortCode`, `product.unit.translation.shortCode` as `product.unit.shortCode`, `product.unit.translation.name`, `product.unit.translation.name` as `product.unit.name`, `product.unit.translation.customFields`, `product.unit.translation.customFields` as `product.unit.customFields`, `product.deliveryTime`.`id` as `product.deliveryTime.id`, `product.deliveryTime`.`min` as `product.deliveryTime.min`, `product.deliveryTime`.`max` as `product.deliveryTime.max`, `product.deliveryTime`.`unit` as `product.deliveryTime.unit`, `product.deliveryTime`.`created_at` as `product.deliveryTime.createdAt`, `product.deliveryTime`.`updated_at` as `product.deliveryTime.updatedAt`, `product.deliveryTime.translation.name`, `product.deliveryTime.translation.name` as `product.deliveryTime.name`, `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.customFields` as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`file_hash` as `product.cover.media.fileHash`, `product.cover.media`.`created_at` as `product.cover.media.createdAt`, `product.cover.media`.`updated_at` as `product.cover.media.updatedAt`, `product.cover.media.translation.title`, `product.cover.media.translation.title` as `product.cover.media.title`, `product.cover.media.translation.alt`, `product.cover.media.translation.alt` as `product.cover.media.alt`, `product.cover.media.translation.customFields`, `product.cover.media.translation.customFields` as `product.cover.media.customFields`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.ogTitle`, `product.parent.translation.ogTitle`, COALESCE(`product.translation.ogTitle`,`product.parent.translation.ogTitle`) as `product.ogTitle`, `product.translation.ogDescription`, `product.parent.translation.ogDescription`, COALESCE(`product.translation.ogDescription`,`product.parent.translation.ogDescription`) as `product.ogDescription`, `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 `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation`.`og_title` as `product.translation.ogTitle`, `product.translation`.`og_description` as `product.translation.ogDescription` 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`, `product.parent.translation`.`og_title` as `product.parent.translation.ogTitle`, `product.parent.translation`.`og_description` as `product.parent.translation.ogDescription` 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.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields` FROM `unit_translation` `product.unit.translation` WHERE `product.unit.translation`.`language_id` = ?) `product.unit.unit_translation` ON `product.unit.unit_translation`.`unit_id` = `product.unit`.`id` LEFT JOIN (SELECT `product.deliveryTime.translation`.`delivery_time_id`, `product.deliveryTime.translation`.`name` as `product.deliveryTime.translation.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` WHERE `product.deliveryTime.translation`.`language_id` = ?) `product.deliveryTime.delivery_time_translation` ON `product.deliveryTime.delivery_time_translation`.`delivery_time_id` = `product.deliveryTime`.`id` LEFT JOIN `media` `product.cover.media` ON `product.cover`.`media_id` = `product.cover.media`.`id` LEFT JOIN (SELECT `product.cover.media.translation`.`media_id`, `product.cover.media.translation`.`alt` as `product.cover.media.translation.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields` FROM `media_translation` `product.cover.media.translation` WHERE `product.cover.media.translation`.`language_id` = ?) `product.cover.media.media_translation` ON `product.cover.media.media_translation`.`media_id` = `product.cover.media`.`id` WHERE (`product`.`version_id` = ?) AND (`product`.`id` IN (?, ?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  b"Ème–‡¨FË¡0y\t\Zh\x08"
  b"‰\x13}¼0AC²¯<Úò\x1A†ˆ"
  b"ÔAˆ«\x19PKý§_‘8û\x1AœA"
  b"u\eö3fÌMÈ›:g*a^\x18\x1C"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.12 ms
(2.97%) 		1 
SELECT `shopstudio_blog_blog_post`.`id` as `shopstudio_blog_blog_post.id`, `shopstudio_blog_blog_post`.`auto_increment` as `shopstudio_blog_blog_post.autoIncrement`, `shopstudio_blog_blog_post`.`active` as `shopstudio_blog_blog_post.active`, `shopstudio_blog_blog_post`.`author` as `shopstudio_blog_blog_post.author`, `shopstudio_blog_blog_post`.`show_table_of_contents` as `shopstudio_blog_blog_post.showTableOfContents`, `shopstudio_blog_blog_post`.`category_tree` as `shopstudio_blog_blog_post.categoryTree`, `shopstudio_blog_blog_post`.`property_ids` as `shopstudio_blog_blog_post.propertyIds`, `shopstudio_blog_blog_post`.`main_image_id` as `shopstudio_blog_blog_post.mainImageId`, `shopstudio_blog_blog_post`.`main_category_id` as `shopstudio_blog_blog_post.mainCategoryId`, `shopstudio_blog_blog_post`.`main_category_version_id` as `shopstudio_blog_blog_post.mainCategoryVersionId`, `shopstudio_blog_blog_post`.`scheduled` as `shopstudio_blog_blog_post.scheduled`, `shopstudio_blog_blog_post`.`estimated_reading_time` as `shopstudio_blog_blog_post.estimatedReadingTime`, `shopstudio_blog_blog_post`.`language_id` as `shopstudio_blog_blog_post.languageId`, `shopstudio_blog_blog_post`.`published_at` as `shopstudio_blog_blog_post.publishedAt`, `shopstudio_blog_blog_post`.`created_at` as `shopstudio_blog_blog_post.createdAt`, `shopstudio_blog_blog_post`.`updated_at` as `shopstudio_blog_blog_post.updatedAt`, `shopstudio_blog_blog_post.mainImage`.`id` as `shopstudio_blog_blog_post.mainImage.id`, `shopstudio_blog_blog_post.mainImage`.`user_id` as `shopstudio_blog_blog_post.mainImage.userId`, `shopstudio_blog_blog_post.mainImage`.`media_folder_id` as `shopstudio_blog_blog_post.mainImage.mediaFolderId`, `shopstudio_blog_blog_post.mainImage`.`mime_type` as `shopstudio_blog_blog_post.mainImage.mimeType`, `shopstudio_blog_blog_post.mainImage`.`file_extension` as `shopstudio_blog_blog_post.mainImage.fileExtension`, `shopstudio_blog_blog_post.mainImage`.`uploaded_at` as `shopstudio_blog_blog_post.mainImage.uploadedAt`, `shopstudio_blog_blog_post.mainImage`.`file_name` as `shopstudio_blog_blog_post.mainImage.fileName`, `shopstudio_blog_blog_post.mainImage`.`file_size` as `shopstudio_blog_blog_post.mainImage.fileSize`, `shopstudio_blog_blog_post.mainImage`.`media_type` as `shopstudio_blog_blog_post.mainImage.mediaTypeRaw`, `shopstudio_blog_blog_post.mainImage`.`meta_data` as `shopstudio_blog_blog_post.mainImage.metaData`, `shopstudio_blog_blog_post.mainImage`.`config` as `shopstudio_blog_blog_post.mainImage.config`, `shopstudio_blog_blog_post.mainImage`.`path` as `shopstudio_blog_blog_post.mainImage.path`, `shopstudio_blog_blog_post.mainImage`.`private` as `shopstudio_blog_blog_post.mainImage.private`, `shopstudio_blog_blog_post.mainImage`.`thumbnails_ro` as `shopstudio_blog_blog_post.mainImage.thumbnailsRo`, `shopstudio_blog_blog_post.mainImage`.`file_hash` as `shopstudio_blog_blog_post.mainImage.fileHash`, `shopstudio_blog_blog_post.mainImage`.`created_at` as `shopstudio_blog_blog_post.mainImage.createdAt`, `shopstudio_blog_blog_post.mainImage`.`updated_at` as `shopstudio_blog_blog_post.mainImage.updatedAt`, `shopstudio_blog_blog_post.mainImage.translation.title`, `shopstudio_blog_blog_post.mainImage.translation.title` as `shopstudio_blog_blog_post.mainImage.title`, `shopstudio_blog_blog_post.mainImage.translation.alt`, `shopstudio_blog_blog_post.mainImage.translation.alt` as `shopstudio_blog_blog_post.mainImage.alt`, `shopstudio_blog_blog_post.mainImage.translation.customFields`, `shopstudio_blog_blog_post.mainImage.translation.customFields` as `shopstudio_blog_blog_post.mainImage.customFields`, `shopstudio_blog_blog_post.mainCategory`.`id` as `shopstudio_blog_blog_post.mainCategory.id`, `shopstudio_blog_blog_post.mainCategory`.`version_id` as `shopstudio_blog_blog_post.mainCategory.versionId`, `shopstudio_blog_blog_post.mainCategory`.`parent_id` as `shopstudio_blog_blog_post.mainCategory.parentId`, `shopstudio_blog_blog_post.mainCategory`.`parent_version_id` as `shopstudio_blog_blog_post.mainCategory.parentVersionId`, `shopstudio_blog_blog_post.mainCategory`.`after_category_id` as `shopstudio_blog_blog_post.mainCategory.afterCategoryId`, `shopstudio_blog_blog_post.mainCategory`.`after_category_version_id` as `shopstudio_blog_blog_post.mainCategory.afterCategoryVersionId`, `shopstudio_blog_blog_post.mainCategory`.`media_id` as `shopstudio_blog_blog_post.mainCategory.mediaId`, `shopstudio_blog_blog_post.mainCategory`.`display_nested_products` as `shopstudio_blog_blog_post.mainCategory.displayNestedProducts`, `shopstudio_blog_blog_post.mainCategory`.`auto_increment` as `shopstudio_blog_blog_post.mainCategory.autoIncrement`, `shopstudio_blog_blog_post.mainCategory`.`level` as `shopstudio_blog_blog_post.mainCategory.level`, `shopstudio_blog_blog_post.mainCategory`.`path` as `shopstudio_blog_blog_post.mainCategory.path`, `shopstudio_blog_blog_post.mainCategory`.`child_count` as `shopstudio_blog_blog_post.mainCategory.childCount`, `shopstudio_blog_blog_post.mainCategory`.`type` as `shopstudio_blog_blog_post.mainCategory.type`, `shopstudio_blog_blog_post.mainCategory`.`product_assignment_type` as `shopstudio_blog_blog_post.mainCategory.productAssignmentType`, `shopstudio_blog_blog_post.mainCategory`.`visible` as `shopstudio_blog_blog_post.mainCategory.visible`, `shopstudio_blog_blog_post.mainCategory`.`active` as `shopstudio_blog_blog_post.mainCategory.active`, `shopstudio_blog_blog_post.mainCategory`.`cms_page_id` as `shopstudio_blog_blog_post.mainCategory.cmsPageId`, `shopstudio_blog_blog_post.mainCategory`.`cms_page_version_id` as `shopstudio_blog_blog_post.mainCategory.cmsPageVersionId`, `shopstudio_blog_blog_post.mainCategory`.`product_stream_id` as `shopstudio_blog_blog_post.mainCategory.productStreamId`, `shopstudio_blog_blog_post.mainCategory`.`custom_entity_type_id` as `shopstudio_blog_blog_post.mainCategory.customEntityTypeId`, `shopstudio_blog_blog_post.mainCategory`.`created_at` as `shopstudio_blog_blog_post.mainCategory.createdAt`, `shopstudio_blog_blog_post.mainCategory`.`updated_at` as `shopstudio_blog_blog_post.mainCategory.updatedAt`, `shopstudio_blog_blog_post.mainCategory.translation.name`, `shopstudio_blog_blog_post.mainCategory.translation.name` as `shopstudio_blog_blog_post.mainCategory.name`, `shopstudio_blog_blog_post.mainCategory.translation.breadcrumb`, `shopstudio_blog_blog_post.mainCategory.translation.breadcrumb` as `shopstudio_blog_blog_post.mainCategory.breadcrumb`, `shopstudio_blog_blog_post.mainCategory.translation.slotConfig`, `shopstudio_blog_blog_post.mainCategory.translation.slotConfig` as `shopstudio_blog_blog_post.mainCategory.slotConfig`, `shopstudio_blog_blog_post.mainCategory.translation.linkType`, `shopstudio_blog_blog_post.mainCategory.translation.linkType` as `shopstudio_blog_blog_post.mainCategory.linkType`, `shopstudio_blog_blog_post.mainCategory.translation.internalLink`, `shopstudio_blog_blog_post.mainCategory.translation.internalLink` as `shopstudio_blog_blog_post.mainCategory.internalLink`, `shopstudio_blog_blog_post.mainCategory.translation.externalLink`, `shopstudio_blog_blog_post.mainCategory.translation.externalLink` as `shopstudio_blog_blog_post.mainCategory.externalLink`, `shopstudio_blog_blog_post.mainCategory.translation.linkNewTab`, `shopstudio_blog_blog_post.mainCategory.translation.linkNewTab` as `shopstudio_blog_blog_post.mainCategory.linkNewTab`, `shopstudio_blog_blog_post.mainCategory.translation.description`, `shopstudio_blog_blog_post.mainCategory.translation.description` as `shopstudio_blog_blog_post.mainCategory.description`, `shopstudio_blog_blog_post.mainCategory.translation.metaTitle`, `shopstudio_blog_blog_post.mainCategory.translation.metaTitle` as `shopstudio_blog_blog_post.mainCategory.metaTitle`, `shopstudio_blog_blog_post.mainCategory.translation.metaDescription`, `shopstudio_blog_blog_post.mainCategory.translation.metaDescription` as `shopstudio_blog_blog_post.mainCategory.metaDescription`, `shopstudio_blog_blog_post.mainCategory.translation.keywords`, `shopstudio_blog_blog_post.mainCategory.translation.keywords` as `shopstudio_blog_blog_post.mainCategory.keywords`, `shopstudio_blog_blog_post.mainCategory.translation.customFields`, `shopstudio_blog_blog_post.mainCategory.translation.customFields` as `shopstudio_blog_blog_post.mainCategory.customFields`, (SELECT GROUP_CONCAT(HEX(`shopstudio_blog_blog_post.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `shopstudio_blog_blog_post_category` `shopstudio_blog_blog_post.categories.mapping`
                  WHERE `shopstudio_blog_blog_post.categories.mapping`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` ) as `shopstudio_blog_blog_post.categories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`shopstudio_blog_blog_post.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `shopstudio_blog_blog_post_property` `shopstudio_blog_blog_post.properties.mapping`
                  WHERE `shopstudio_blog_blog_post.properties.mapping`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` ) as `shopstudio_blog_blog_post.properties.id_mapping`, (SELECT GROUP_CONCAT(HEX(`shopstudio_blog_blog_post.salesChannels.mapping`.`sales_channel_id`) SEPARATOR '||')
                  FROM `shopstudio_blog_blog_post_sales_channel` `shopstudio_blog_blog_post.salesChannels.mapping`
                  WHERE `shopstudio_blog_blog_post.salesChannels.mapping`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` ) as `shopstudio_blog_blog_post.salesChannels.id_mapping`, `shopstudio_blog_blog_post.translation.title`, `shopstudio_blog_blog_post.translation.title` as `shopstudio_blog_blog_post.title`, `shopstudio_blog_blog_post.translation.description`, `shopstudio_blog_blog_post.translation.description` as `shopstudio_blog_blog_post.description`, `shopstudio_blog_blog_post.translation.metaTitle`, `shopstudio_blog_blog_post.translation.metaTitle` as `shopstudio_blog_blog_post.metaTitle`, `shopstudio_blog_blog_post.translation.metaDescription`, `shopstudio_blog_blog_post.translation.metaDescription` as `shopstudio_blog_blog_post.metaDescription`, `shopstudio_blog_blog_post.translation.robots`, `shopstudio_blog_blog_post.translation.robots` as `shopstudio_blog_blog_post.robots`, `shopstudio_blog_blog_post.translation.keywords`, `shopstudio_blog_blog_post.translation.keywords` as `shopstudio_blog_blog_post.keywords`, `shopstudio_blog_blog_post.translation.customFields`, `shopstudio_blog_blog_post.translation.customFields` as `shopstudio_blog_blog_post.customFields` FROM `shopstudio_blog_blog_post` LEFT JOIN `media` `shopstudio_blog_blog_post.mainImage` ON `shopstudio_blog_blog_post`.`main_image_id` = `shopstudio_blog_blog_post.mainImage`.`id` LEFT JOIN `category` `shopstudio_blog_blog_post.mainCategory` ON `shopstudio_blog_blog_post`.`main_category_id` = `shopstudio_blog_blog_post.mainCategory`.`id` AND `shopstudio_blog_blog_post`.`main_category_version_id` = `shopstudio_blog_blog_post.mainCategory`.`version_id` LEFT JOIN (SELECT `shopstudio_blog_blog_post.translation`.`shopstudio_blog_blog_post_id`, `shopstudio_blog_blog_post.translation`.`title` as `shopstudio_blog_blog_post.translation.title`, `shopstudio_blog_blog_post.translation`.`description` as `shopstudio_blog_blog_post.translation.description`, `shopstudio_blog_blog_post.translation`.`meta_title` as `shopstudio_blog_blog_post.translation.metaTitle`, `shopstudio_blog_blog_post.translation`.`meta_description` as `shopstudio_blog_blog_post.translation.metaDescription`, `shopstudio_blog_blog_post.translation`.`robots` as `shopstudio_blog_blog_post.translation.robots`, `shopstudio_blog_blog_post.translation`.`keywords` as `shopstudio_blog_blog_post.translation.keywords`, `shopstudio_blog_blog_post.translation`.`custom_fields` as `shopstudio_blog_blog_post.translation.customFields` FROM `shopstudio_blog_blog_post_translation` `shopstudio_blog_blog_post.translation` WHERE `shopstudio_blog_blog_post.translation`.`language_id` = ?) `shopstudio_blog_blog_post.shopstudio_blog_blog_post_translation` ON `shopstudio_blog_blog_post.shopstudio_blog_blog_post_translation`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` LEFT JOIN (SELECT `shopstudio_blog_blog_post.mainImage.translation`.`media_id`, `shopstudio_blog_blog_post.mainImage.translation`.`alt` as `shopstudio_blog_blog_post.mainImage.translation.alt`, `shopstudio_blog_blog_post.mainImage.translation`.`title` as `shopstudio_blog_blog_post.mainImage.translation.title`, `shopstudio_blog_blog_post.mainImage.translation`.`custom_fields` as `shopstudio_blog_blog_post.mainImage.translation.customFields` FROM `media_translation` `shopstudio_blog_blog_post.mainImage.translation` WHERE `shopstudio_blog_blog_post.mainImage.translation`.`language_id` = ?) `shopstudio_blog_blog_post.mainImage.media_translation` ON `shopstudio_blog_blog_post.mainImage.media_translation`.`media_id` = `shopstudio_blog_blog_post.mainImage`.`id` LEFT JOIN (SELECT `shopstudio_blog_blog_post.mainCategory.translation`.`category_id`, `shopstudio_blog_blog_post.mainCategory.translation`.`category_version_id`, `shopstudio_blog_blog_post.mainCategory.translation`.`breadcrumb` as `shopstudio_blog_blog_post.mainCategory.translation.breadcrumb`, `shopstudio_blog_blog_post.mainCategory.translation`.`name` as `shopstudio_blog_blog_post.mainCategory.translation.name`, `shopstudio_blog_blog_post.mainCategory.translation`.`custom_fields` as `shopstudio_blog_blog_post.mainCategory.translation.customFields`, `shopstudio_blog_blog_post.mainCategory.translation`.`slot_config` as `shopstudio_blog_blog_post.mainCategory.translation.slotConfig`, `shopstudio_blog_blog_post.mainCategory.translation`.`link_type` as `shopstudio_blog_blog_post.mainCategory.translation.linkType`, `shopstudio_blog_blog_post.mainCategory.translation`.`internal_link` as `shopstudio_blog_blog_post.mainCategory.translation.internalLink`, `shopstudio_blog_blog_post.mainCategory.translation`.`external_link` as `shopstudio_blog_blog_post.mainCategory.translation.externalLink`, `shopstudio_blog_blog_post.mainCategory.translation`.`link_new_tab` as `shopstudio_blog_blog_post.mainCategory.translation.linkNewTab`, `shopstudio_blog_blog_post.mainCategory.translation`.`description` as `shopstudio_blog_blog_post.mainCategory.translation.description`, `shopstudio_blog_blog_post.mainCategory.translation`.`meta_title` as `shopstudio_blog_blog_post.mainCategory.translation.metaTitle`, `shopstudio_blog_blog_post.mainCategory.translation`.`meta_description` as `shopstudio_blog_blog_post.mainCategory.translation.metaDescription`, `shopstudio_blog_blog_post.mainCategory.translation`.`keywords` as `shopstudio_blog_blog_post.mainCategory.translation.keywords` FROM `category_translation` `shopstudio_blog_blog_post.mainCategory.translation` WHERE `shopstudio_blog_blog_post.mainCategory.translation`.`language_id` = ?) `shopstudio_blog_blog_post.mainCategory.category_translation` ON `shopstudio_blog_blog_post.mainCategory.category_translation`.`category_id` = `shopstudio_blog_blog_post.mainCategory`.`id` AND `shopstudio_blog_blog_post.mainCategory.category_translation`.`category_version_id` = `shopstudio_blog_blog_post.mainCategory`.`version_id` WHERE `shopstudio_blog_blog_post`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(2.81%) 		3 
-- 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 = ?)) AND (seo_url.is_deleted = 0)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  "blog/Ostern-mit-Binabo"
  "blog/Ostern-mit-Binabo/"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.97 ms
(2.58%) 		1 
-- cart-rule-loader::load-rules::read
SELECT `rule`.`id` as `rule.id`, `rule`.`name` as `rule.name`, `rule`.`priority` as `rule.priority`, `rule`.`description` as `rule.description`, `rule`.`payload` as `rule.payload`, `rule`.`invalid` as `rule.invalid`, `rule`.`areas` as `rule.areas`, `rule`.`custom_fields` as `rule.customFields`, `rule`.`module_types` as `rule.moduleTypes`, `rule`.`created_at` as `rule.createdAt`, `rule`.`updated_at` as `rule.updatedAt` FROM `rule` WHERE `rule`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  b"\x10\x00²E¶¿@Û›ÉvSÓtžÉ"
  b"\x13µ` JâL•ˆX>ðªÇ®X"
  b"\x14^Qš®\x17@ùŸÂ\x07\x07×sûÖ"
  b"$í[)EþL$0CšÈvA^"
  b",+º¯/ÁFõ„¯\x04Ýv{ïˆ"
  b"=+F\t«ÀMP¸?ÞcPöðn"
  b"Q¢°“\x07ŒG\x00¢Ø†ò\x16­1@"
  b"kF%uä&F\x03Ÿg«\f<l²"
  b"mL6\x1EGtC ¨ª¸6¸—ÄI"
  b"o\x1AMOoyH\x12“|-j\x16ižZ"
  b"z©)G˜äH\x14»Æg\x04GD°€"
  b"€3Dq¤¨H¦€¯4i{³Ž#"
  b"œ\x08:f\x1CšO´…\x0Eõ¼-2à\x08"
  b"""
    yJ\x12JeH\n
    ž¢¹zðáê€
    """
  b"£ÍŽÛ\x00\x7FF™¨Ï\x1Aå\tÄÆ"
  b"""
    ºìàÅS\x02N\n
    µ\eÌ\x1AùÎi3
    """
  b"Æ6€ìÊG”Ÿ¿@Iç1 ô"
  b"Øì'D\x02\x0FDó\x15\x7F:ìñ\x18±"
  b"ÙôÄŒÌ<F%£\esFŽ%9’"
  b"í/¿èø.LÝŒ[9{\x02Ö +"
  b"í›…ü\x03IJ°…"¤\x1D\f\x1C\x1Fû"
  b"ö\v\x1FԐÃM\rŒYœ/tH–¶"
  b"6°\t›ÒoBF¯äHù]‡…œ"
  b"ØÔø¢Ÿ€@ó‰òOc¸®c\x05"
  b"\x18ÞC!\x08ãK¾º2Ž\x06^Êù"
  b"\x18â\x01h(\x1ED¬’Pᑆê0e"
  b"$xäGmñCÀŽ\x17t1ŠÉf´"
  b"&}\x0E\f£—F«¼\x005‰‰ˆ\x14Î"
  b".žÆ¢ÁDO@…;x\x04\x1DÔìš"
  b"@\x13l¹þlIøœù®,Ð×}»"
  b"F#´‹åÞOǺC°; 5µâ"
  b"""
    f­\n
    ™¹ÂAõ¬¤F&Äu³Î
    """
  b"mûdc¢\tI\x10¿\x125óLP\eF"
  b"""
    €.ûîGXJæ©1áT\n
    é\x1C@
    """
  b"‰–Ðsb,@ҐËóš„{ÛÎ"
  b"\x1DàR„ëDs»\x16_Yzõe"
  b"›nÏËá|J@—† ?G¤09"
  b"ßQ\x07(qN™•SmOé\x02ÔJ"
  b"¢Uy´d\x14F‘™±\r¤¶¥„î"
  b"·ESó†þL¸Š-AËçX¨8"
  b"¼ÑE2\x15ÅAŒ€Š áSü'#"
  b"ËÑ%pË·@‘¡Tï\x00±—Ñ´"
  b"াPxêF\r™\x1F\x00¬K\x18\x11"
  b"âUžC…¯JŽ©¨”›8µwo"
  b"í+-™\f±NÒ€5¥éN«uð"
  b"ðn\x15]\x048GL¬ï\x08ͳ*)Û"
  b"\x00\x00ß²Z$KýœgÁê­ŒèV"
  b"\x02Ôü8”–CÔ\x03ãù·Ø"
  b"\x05SX%O\x16M#ŸW뇆”7¹"
  b"\x08q DõXE슬eÝNiä¥"
  b"\t$³5€{HøŽ¤‡/\v—Óç"
  b"\vüô\x07Lm@j³ÖÒ™CÇyÚ"
  b"\x0E+6vyYB¡¤GªÌ·Ö="
  b"\x11m\x13Õü\eBã™]ð\x0F§\x00†§"
  b"\x11·\x14Š\x06JF°‡‘è`)Ѽ-"
  b"\x15Ê—­ü£IÖŽ=mzGc\x03…"
  b"\x167CÞ\x06ãNF¤~\x02Õ\x04ò°Ð"
  b"\x17ˆê-3CE\x18ªL\x00»±vÀ+"
  b"\eaYuë6N!ª=\e\x19 ûw\x18"
  b"\x1Cœ¼-äC‘½TÂÓ·Ä\x1F×"
  b"\x1Cãg\fàmAŒ¬ºŽŠ\x16K¹È"
  b"\x1DÐm\x7F„$Lf•Íµ÷q\x1C”J"
  b"%\x14üvŽOM\x11›\x00¥®\x08\dJ"
  b"""
    %KeÐ> Nk…öÛ\x19“\n
    mu
    """
  b"%ÂÃý´ÂKˆ³Ð\x1D-ŽZïI"
  b"1X°%KîHªž\x0E‰b<\x07Ø%"
  b"1d\x7F…ºnO!®ÞÀº¼ˆ“¥"
  b"""
    2o\n
    U±ØI.‹Å%Ô\x12‰¥Ñ
    """
  b"5!zÝBÎL|€˜öè+\x18Ù§"
  b"7\vÀ{÷O,Š´x„ä¼\x01ã"
  b"8q—úÜ¿C¾Ÿ\rš\eõE­9"
  b";ÑÞ2×\x14B2€ŒÀ\x13¡3Q\x10"
  b";ö†oaðM\x03°\x13Ûßìzå\x1E"
  b"<åßúg½LÆ‘\x0FnDò\x07à"
  b"?€ÜC\x02äNó¼Oív\x1CF¼|"
  b"@œÔ\x00gOI‹¯ò¯eϏui"
  b"F7\x1A!šÙO>²o̾\x15šÕC"
  b"G;CžæéD\x01¥%V=»\x02|O"
  b"KŠ.\x03˜\x12I…^.vù“šœ"
  b"L”ÑÞûÊO©œ¾@¡ª·?ß"
  b"N-Ô(œ=Cq¶çÕg\x08"
  b"NKmK,äE½­‰ùûYúKð"
  b"P‹ÍRIÏLî•Hõ'ùbý\n"
  b"P¹#\v–µG\x05°>§…Ù\x02ªë"
  b"Q\x7Fö9\x02†EmŠìÙ¹¾¦Õ\x07"
  b"S˜Ö\x1EIñHÜ»Ù\ó¡6›“"
  b"S¹o\x06ƒkN˜Ü”dQb\x19#"
  b"UÕ9²‚éB\x08Žzö~Ùfø:"
  b"V½Ç±¾¯Gä„G‹ŒS–\x18\"
  b"WbM«L~LÔ¼‚7\f\x0EO\x167"
  b"WÝg´í*Fì‘îՐ¨áqÿ"
  b"^ÌrÝxŠO\x18¿ÉaX\x1CËš­"
  b"`;ùj­kA?“€}¦rrŸ‡"
  b"a›×!ÙHNf˜‰‚ï®\x048e"
  b"euû9ò\x00GËŽ\vó\x06¸ÒÜ"
  b"e•~ùÂ\x17D–„Ú¾$xùèO"
  b"iû$ íKGn¯ÝðɽTO"
  b"jGfu_ºC\x7F„ÉpG\x15dh›"
  b"r\x08F=\x1C<GÛ¹cƒàZ`0+"
  b"sg:ª„·DÞ„B6#BY1z"
  b"u\x0F:UìC\x19¯ÁØÅù‹\x19~"
  b"vSX\x1FÓAVœP×b¬4&|"
  b"w2‡…÷ Moˆ‘œõ\x05[ð<"
  b"wˆoè#mM&Œsž‹Ìbžc"
  b"x+\x01Èl"K\x1A„i4.\x18¢[Î"
  b"""
    }ø\n
    ˆ¸·I\¹\x03{‰3@—(
    """
  b"\x7F£\x05aÒéGv·û¯Tq\x1EÔ"
  b"…\x15´#ÐýJé¦`ú…B\e—"
  b"ˆd¯\x01\eãN6º\x18\x13ªúƒØ\x04"
  b"Ž k[\eÛM\v°œ]žf¯Ð…"
  b"n¸<“ÛOd¸¦\f‹£w¾"
  b"ÔœýÛlH‚ÅL‡úëÔT"
  b">-NaiEÅžq\x1D0!ÊüM"
  b"""
    ×\\n
    T\x05Lֹ뎆\x02”®}
    """
  b"’J;¯¶ïKm–®ÇÕå<½"
  b"’†Š#§JOŠÄËWM\x0ENñ"
  b"’Šy_v€O±µZp»R´Ñ-"
  b"’þ‹\x13àB¿ºŽ\x05ÒåÝ\tÌ"
  b"”Üž¢È!F¤‹9n®J+àK"
  b"•%•_WçG5µõFçð"Z6"
  b"•dÃ÷à\x1DMûŒPq\tÄûœz"
  b"—ÞY-\e/Gn´õ¢6ø7$"
  b"šN\x04%FãKF‡eHÂö—Òß"
  b"œÅW7\rØGN–æ9O}Ãñ\x12"
  b"_\x060Ô@@\x1Cµ“\x10Ó3šìÖ"
  b"|~»NBIJ¼2iv…âB"
  b"žÙ7Y"ÉB#›\r®¾ïáÏ\f"
  b" Ê:zWÙCªl\f½¿›\x17\x18"
  b" â»·a\x05J£±—p¦=JDJ"
  b"¡}Š™;µD\x7F‹À´Éç\e&Î"
  b"¡Ýt²%~Cר°ãz\x11ÉÄW"
  b"¬3íã5\x14Mí–…µ\x14PO] "
  b"¯ású\x14zN°•Žã„&\x11\x1E¬"
  b"µ…évó<KíŽr\x06݃P‹µ"
  b"¶íëqØ)I\x19£ÐÖ"¶\x10\x07°"
  b"¹àLÈé)L΂0{#Ža—&"
  b"»}cPÌèB!±V\x00ŽÔ?'Ô"
  b"½\x12—\x00]üGß·ï\x1Càö˜)—"
  b"½KGTywD被CÄÎÉêµ"
  b"¿üc\<ö@¾¯%Ý#ÝýÜ"
  b"Àš\e?£lHl©ýê[l(\x06®"
  b"Á¼åÐ\x1E‡Mb³ô«\x1FZÔö\x7F"
  b"Âø›?ÁÇH\x11‘ÒÖJ\x1EÅwà"
  b"Æ\x10ŠÁ\vÂC.”´Ã\x02ÃÊKá"
  b"Çs„u·¶F©ƒÛð.•ùYz"
  b"É™LÔwiF\x08§ŸQ¨9úào"
  b"ËMFÖ„FJíž Î„Oó«\x11"
  b"ÍѹnÎ\Ie³\x00¹4uCëû"
  b"Ñ3U„=‰BQ²¤'EHƒ˜¯"
  b"Ѳ°v”E …\x14¾i"ú¸\x07"
  b"ØeK\x06EÈD^®‡Iš\t\’l"
  b"Ø·\x00N\x16“Lj»\f—\x186ˆ?‰"
  b"Ù÷\x1EBøÍL1š\v\x1Aâ=4\x16b"
  b"Ú‰¸÷ŒÇO{•C¶àŽ¦»\x08"
  b"Û\x1C7”·SD;–\e\x07Ä€¹5œ"
  b"ݧï“{ªO!‚@:é\x13ÑÌM"
  b"ã…Ë\týwM!£_\x03\x1F\x1E_\x14„"
  b"䤷u‰DȬԠÎÉðOŽ"
  b"æaÎT\x11œK}³ÝÆ·\x032Ó‡"
  b"""
    ç:Â\n
    Y÷A—¾øؾX¶æ…
    """
  b"ë‹Qù×kMÑŸ\x04Y¡:óNà"
  b"í\x00]rÕâB®Š!þ#¤æ–ƒ"
  b"írÃ\x13ô\eKŽ®E”î'p‘f"
  b"í%ñª\vHç®\x07lS5t¿»"
  b"ù\rÂÛikE°®“2b‘ÜÌÅ"
  b"ùÜùP´ýIE«\v(y\x02C$Ý"
  b"úë.jJ\x17B\x06¬å¿ißÄŠö"
  b"ûŠ•o%µKϸJ—¬Ý ÂŽ"
  b"ûä´–ø\x13Mù¢Âÿ'}¼•ö"
  b"üe\x15CY¤Aî¡s‘~Ö)wæ"
  b"ý\x08ô"\tÿJ\x02«j«×8\f°¿"
  b"""
    ýrp\t2|GýœdöWWî\n
    q
    """
  b"ÿ\x10#\x01þªEï•bÛʳhW1"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.92 ms
(2.43%) 		1 
SELECT `shopstudio_blog_blog_post_content`.`id` as `shopstudio_blog_blog_post_content.id`, `shopstudio_blog_blog_post_content`.`shopstudio_blog_blog_post_id` as `shopstudio_blog_blog_post_content.shopStudioBlogPostId`, `shopstudio_blog_blog_post_content`.`position` as `shopstudio_blog_blog_post_content.position`, `shopstudio_blog_blog_post_content`.`type` as `shopstudio_blog_blog_post_content.type`, `shopstudio_blog_blog_post_content`.`general_config` as `shopstudio_blog_blog_post_content.generalConfig`, `shopstudio_blog_blog_post_content`.`created_at` as `shopstudio_blog_blog_post_content.createdAt`, `shopstudio_blog_blog_post_content`.`updated_at` as `shopstudio_blog_blog_post_content.updatedAt`, `shopstudio_blog_blog_post_content.translation.config`, `shopstudio_blog_blog_post_content.translation.config` as `shopstudio_blog_blog_post_content.config` FROM `shopstudio_blog_blog_post_content` LEFT JOIN (SELECT `shopstudio_blog_blog_post_content.translation`.`shopstudio_blog_blog_post_content_id`, `shopstudio_blog_blog_post_content.translation`.`config` as `shopstudio_blog_blog_post_content.translation.config` FROM `shopstudio_blog_blog_post_content_translation` `shopstudio_blog_blog_post_content.translation` WHERE `shopstudio_blog_blog_post_content.translation`.`language_id` = ?) `shopstudio_blog_blog_post_content.shopstudio_blog_blog_post_content_translation` ON `shopstudio_blog_blog_post_content.shopstudio_blog_blog_post_content_translation`.`shopstudio_blog_blog_post_content_id` = `shopstudio_blog_blog_post_content`.`id` WHERE ((`shopstudio_blog_blog_post_content`.`shopstudio_blog_blog_post_id` IN (?))) ORDER BY `shopstudio_blog_blog_post_content`.`position` ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.87 ms
(2.30%) 		3 
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: 
[
  "/blog/detail/4679f6c71b844d6aa90ef67b2f8484a5"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  b"\x12|s}«\x15Kð«H\x1A£qqÞ„"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.84 ms
(2.23%) 		3 
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"\x14^Qš®\x17@ùŸÂ\x07\x07×sûÖ"
  b",+º¯/ÁFõ„¯\x04Ýv{ïˆ"
  b"=+F\t«ÀMP¸?ÞcPöðn"
  b"Q¢°“\x07ŒG\x00¢Ø†ò\x16­1@"
  b"o\x1AMOoyH\x12“|-j\x16ižZ"
  b"z©)G˜äH\x14»Æg\x04GD°€"
  b"€3Dq¤¨H¦€¯4i{³Ž#"
  b"ö\v\x1FԐÃM\rŒYœ/tH–¶"
  b"\x18ÞC!\x08ãK¾º2Ž\x06^Êù"
  b"@\x13l¹þlIøœù®,Ð×}»"
  b"F#´‹åÞOǺC°; 5µâ"
  b"""
    f­\n
    ™¹ÂAõ¬¤F&Äu³Î
    """
  b"\x1DàR„ëDs»\x16_Yzõe"
  b"¼ÑE2\x15ÅAŒ€Š áSü'#"
  b"\x00\x00ß²Z$KýœgÁê­ŒèV"
  b"\vüô\x07Lm@j³ÖÒ™CÇyÚ"
  b"\x11·\x14Š\x06JF°‡‘è`)Ѽ-"
  b"\x1Cãg\fàmAŒ¬ºŽŠ\x16K¹È"
  b"%\x14üvŽOM\x11›\x00¥®\x08\dJ"
  b";ö†oaðM\x03°\x13Ûßìzå\x1E"
  b"?€ÜC\x02äNó¼Oív\x1CF¼|"
  b"WÝg´í*Fì‘îՐ¨áqÿ"
  b"w2‡…÷ Moˆ‘œõ\x05[ð<"
  b"wˆoè#mM&Œsž‹Ìbžc"
  b"…\x15´#ÐýJé¦`ú…B\e—"
  b"Ž k[\eÛM\v°œ]žf¯Ð…"
  b"’þ‹\x13àB¿ºŽ\x05ÒåÝ\tÌ"
  b"¬3íã5\x14Mí–…µ\x14PO] "
  b"¶íëqØ)I\x19£ÐÖ"¶\x10\x07°"
  b"»}cPÌèB!±V\x00ŽÔ?'Ô"
  b"½\x12—\x00]üGß·ï\x1Càö˜)—"
  b"Æ\x10ŠÁ\vÂC.”´Ã\x02ÃÊKá"
  b"Çs„u·¶F©ƒÛð.•ùYz"
  b"Ú‰¸÷ŒÇO{•C¶àŽ¦»\x08"
  b"ã…Ë\týwM!£_\x03\x1F\x1E_\x14„"
  b"䤷u‰DȬԠÎÉðOŽ"
  b"æaÎT\x11œK}³ÝÆ·\x032Ó‡"
  b"írÃ\x13ô\eKŽ®E”î'p‘f"
  b"ù\rÂÛikE°®“2b‘ÜÌÅ"
  b"ý\x08ô"\tÿJ\x02«j«×8\f°¿"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(2.01%) 		1 
SELECT `shopstudio_blog_blog_post`.`id` as `shopstudio_blog_blog_post.id`, `shopstudio_blog_blog_post`.`auto_increment` as `shopstudio_blog_blog_post.autoIncrement`, `shopstudio_blog_blog_post`.`active` as `shopstudio_blog_blog_post.active`, `shopstudio_blog_blog_post`.`author` as `shopstudio_blog_blog_post.author`, `shopstudio_blog_blog_post`.`show_table_of_contents` as `shopstudio_blog_blog_post.showTableOfContents`, `shopstudio_blog_blog_post`.`category_tree` as `shopstudio_blog_blog_post.categoryTree`, `shopstudio_blog_blog_post`.`property_ids` as `shopstudio_blog_blog_post.propertyIds`, `shopstudio_blog_blog_post`.`main_image_id` as `shopstudio_blog_blog_post.mainImageId`, `shopstudio_blog_blog_post`.`main_category_id` as `shopstudio_blog_blog_post.mainCategoryId`, `shopstudio_blog_blog_post`.`main_category_version_id` as `shopstudio_blog_blog_post.mainCategoryVersionId`, `shopstudio_blog_blog_post`.`scheduled` as `shopstudio_blog_blog_post.scheduled`, `shopstudio_blog_blog_post`.`estimated_reading_time` as `shopstudio_blog_blog_post.estimatedReadingTime`, `shopstudio_blog_blog_post`.`language_id` as `shopstudio_blog_blog_post.languageId`, `shopstudio_blog_blog_post`.`published_at` as `shopstudio_blog_blog_post.publishedAt`, `shopstudio_blog_blog_post`.`created_at` as `shopstudio_blog_blog_post.createdAt`, `shopstudio_blog_blog_post`.`updated_at` as `shopstudio_blog_blog_post.updatedAt`, (SELECT GROUP_CONCAT(HEX(`shopstudio_blog_blog_post.categories.mapping`.`category_id`) SEPARATOR '||')
                  FROM `shopstudio_blog_blog_post_category` `shopstudio_blog_blog_post.categories.mapping`
                  WHERE `shopstudio_blog_blog_post.categories.mapping`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` ) as `shopstudio_blog_blog_post.categories.id_mapping`, (SELECT GROUP_CONCAT(HEX(`shopstudio_blog_blog_post.properties.mapping`.`property_group_option_id`) SEPARATOR '||')
                  FROM `shopstudio_blog_blog_post_property` `shopstudio_blog_blog_post.properties.mapping`
                  WHERE `shopstudio_blog_blog_post.properties.mapping`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` ) as `shopstudio_blog_blog_post.properties.id_mapping`, `shopstudio_blog_blog_post.mainImage`.`id` as `shopstudio_blog_blog_post.mainImage.id`, `shopstudio_blog_blog_post.mainImage`.`user_id` as `shopstudio_blog_blog_post.mainImage.userId`, `shopstudio_blog_blog_post.mainImage`.`media_folder_id` as `shopstudio_blog_blog_post.mainImage.mediaFolderId`, `shopstudio_blog_blog_post.mainImage`.`mime_type` as `shopstudio_blog_blog_post.mainImage.mimeType`, `shopstudio_blog_blog_post.mainImage`.`file_extension` as `shopstudio_blog_blog_post.mainImage.fileExtension`, `shopstudio_blog_blog_post.mainImage`.`uploaded_at` as `shopstudio_blog_blog_post.mainImage.uploadedAt`, `shopstudio_blog_blog_post.mainImage`.`file_name` as `shopstudio_blog_blog_post.mainImage.fileName`, `shopstudio_blog_blog_post.mainImage`.`file_size` as `shopstudio_blog_blog_post.mainImage.fileSize`, `shopstudio_blog_blog_post.mainImage`.`media_type` as `shopstudio_blog_blog_post.mainImage.mediaTypeRaw`, `shopstudio_blog_blog_post.mainImage`.`meta_data` as `shopstudio_blog_blog_post.mainImage.metaData`, `shopstudio_blog_blog_post.mainImage`.`config` as `shopstudio_blog_blog_post.mainImage.config`, `shopstudio_blog_blog_post.mainImage`.`path` as `shopstudio_blog_blog_post.mainImage.path`, `shopstudio_blog_blog_post.mainImage`.`private` as `shopstudio_blog_blog_post.mainImage.private`, `shopstudio_blog_blog_post.mainImage`.`thumbnails_ro` as `shopstudio_blog_blog_post.mainImage.thumbnailsRo`, `shopstudio_blog_blog_post.mainImage`.`file_hash` as `shopstudio_blog_blog_post.mainImage.fileHash`, `shopstudio_blog_blog_post.mainImage`.`created_at` as `shopstudio_blog_blog_post.mainImage.createdAt`, `shopstudio_blog_blog_post.mainImage`.`updated_at` as `shopstudio_blog_blog_post.mainImage.updatedAt`, `shopstudio_blog_blog_post.mainImage.translation.title`, `shopstudio_blog_blog_post.mainImage.translation.title` as `shopstudio_blog_blog_post.mainImage.title`, `shopstudio_blog_blog_post.mainImage.translation.alt`, `shopstudio_blog_blog_post.mainImage.translation.alt` as `shopstudio_blog_blog_post.mainImage.alt`, `shopstudio_blog_blog_post.mainImage.translation.customFields`, `shopstudio_blog_blog_post.mainImage.translation.customFields` as `shopstudio_blog_blog_post.mainImage.customFields`, `shopstudio_blog_blog_post.translation.title`, `shopstudio_blog_blog_post.translation.title` as `shopstudio_blog_blog_post.title`, `shopstudio_blog_blog_post.translation.description`, `shopstudio_blog_blog_post.translation.description` as `shopstudio_blog_blog_post.description`, `shopstudio_blog_blog_post.translation.metaTitle`, `shopstudio_blog_blog_post.translation.metaTitle` as `shopstudio_blog_blog_post.metaTitle`, `shopstudio_blog_blog_post.translation.metaDescription`, `shopstudio_blog_blog_post.translation.metaDescription` as `shopstudio_blog_blog_post.metaDescription`, `shopstudio_blog_blog_post.translation.robots`, `shopstudio_blog_blog_post.translation.robots` as `shopstudio_blog_blog_post.robots`, `shopstudio_blog_blog_post.translation.keywords`, `shopstudio_blog_blog_post.translation.keywords` as `shopstudio_blog_blog_post.keywords`, `shopstudio_blog_blog_post.translation.customFields`, `shopstudio_blog_blog_post.translation.customFields` as `shopstudio_blog_blog_post.customFields` FROM `shopstudio_blog_blog_post` LEFT JOIN `media` `shopstudio_blog_blog_post.mainImage` ON `shopstudio_blog_blog_post`.`main_image_id` = `shopstudio_blog_blog_post.mainImage`.`id` LEFT JOIN (SELECT `shopstudio_blog_blog_post.translation`.`shopstudio_blog_blog_post_id`, `shopstudio_blog_blog_post.translation`.`title` as `shopstudio_blog_blog_post.translation.title`, `shopstudio_blog_blog_post.translation`.`description` as `shopstudio_blog_blog_post.translation.description`, `shopstudio_blog_blog_post.translation`.`meta_title` as `shopstudio_blog_blog_post.translation.metaTitle`, `shopstudio_blog_blog_post.translation`.`meta_description` as `shopstudio_blog_blog_post.translation.metaDescription`, `shopstudio_blog_blog_post.translation`.`robots` as `shopstudio_blog_blog_post.translation.robots`, `shopstudio_blog_blog_post.translation`.`keywords` as `shopstudio_blog_blog_post.translation.keywords`, `shopstudio_blog_blog_post.translation`.`custom_fields` as `shopstudio_blog_blog_post.translation.customFields` FROM `shopstudio_blog_blog_post_translation` `shopstudio_blog_blog_post.translation` WHERE `shopstudio_blog_blog_post.translation`.`language_id` = ?) `shopstudio_blog_blog_post.shopstudio_blog_blog_post_translation` ON `shopstudio_blog_blog_post.shopstudio_blog_blog_post_translation`.`shopstudio_blog_blog_post_id` = `shopstudio_blog_blog_post`.`id` LEFT JOIN (SELECT `shopstudio_blog_blog_post.mainImage.translation`.`media_id`, `shopstudio_blog_blog_post.mainImage.translation`.`alt` as `shopstudio_blog_blog_post.mainImage.translation.alt`, `shopstudio_blog_blog_post.mainImage.translation`.`title` as `shopstudio_blog_blog_post.mainImage.translation.title`, `shopstudio_blog_blog_post.mainImage.translation`.`custom_fields` as `shopstudio_blog_blog_post.mainImage.translation.customFields` FROM `media_translation` `shopstudio_blog_blog_post.mainImage.translation` WHERE `shopstudio_blog_blog_post.mainImage.translation`.`language_id` = ?) `shopstudio_blog_blog_post.mainImage.media_translation` ON `shopstudio_blog_blog_post.mainImage.media_translation`.`media_id` = `shopstudio_blog_blog_post.mainImage`.`id` WHERE `shopstudio_blog_blog_post`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.88%) 		1 
-- footer-pagelet::shipping-methods::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?, ?, ?, ?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"þï¹G4vGD¦n+O(ƒC"
  b"_\x1FâIH²K®¿\x1C\x10jJ\x10Êh"
  b"Nþy\f\x1E@@\x06©ª"¶Ø\x14¹Ñ"
  b"ZÀ\x19éñfN\x1DžÜ(?_ú!_"
  b"8ñ5ÒßÂ@Ø•N/Ò0~ãM"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.71 ms
(1.87%) 		1 
-- base-context-factory::payment-method::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.appPaymentMethod`.`id` as `payment_method.appPaymentMethod.id`, `payment_method.appPaymentMethod`.`app_name` as `payment_method.appPaymentMethod.appName`, `payment_method.appPaymentMethod`.`identifier` as `payment_method.appPaymentMethod.identifier`, `payment_method.appPaymentMethod`.`pay_url` as `payment_method.appPaymentMethod.payUrl`, `payment_method.appPaymentMethod`.`finalize_url` as `payment_method.appPaymentMethod.finalizeUrl`, `payment_method.appPaymentMethod`.`validate_url` as `payment_method.appPaymentMethod.validateUrl`, `payment_method.appPaymentMethod`.`capture_url` as `payment_method.appPaymentMethod.captureUrl`, `payment_method.appPaymentMethod`.`refund_url` as `payment_method.appPaymentMethod.refundUrl`, `payment_method.appPaymentMethod`.`recurring_url` as `payment_method.appPaymentMethod.recurringUrl`, `payment_method.appPaymentMethod`.`app_id` as `payment_method.appPaymentMethod.appId`, `payment_method.appPaymentMethod`.`original_media_id` as `payment_method.appPaymentMethod.originalMediaId`, `payment_method.appPaymentMethod`.`payment_method_id` as `payment_method.appPaymentMethod.paymentMethodId`, `payment_method.appPaymentMethod`.`created_at` as `payment_method.appPaymentMethod.createdAt`, `payment_method.appPaymentMethod`.`updated_at` as `payment_method.appPaymentMethod.updatedAt`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN `app_payment_method` `payment_method.appPaymentMethod` ON `payment_method`.`id` = `payment_method.appPaymentMethod`.`payment_method_id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"1k–\x00\x1DˆKE¼\tdá¼òê<"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.68 ms
(1.80%) 		1 
-- base-context-factory::sales-channel::read
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`measurement_units` as `sales_channel.measurementUnits`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.currency`.`id` as `sales_channel.currency.id`, `sales_channel.currency`.`factor` as `sales_channel.currency.factor`, `sales_channel.currency`.`symbol` as `sales_channel.currency.symbol`, `sales_channel.currency`.`iso_code` as `sales_channel.currency.isoCode`, `sales_channel.currency`.`position` as `sales_channel.currency.position`, `sales_channel.currency`.`tax_free_from` as `sales_channel.currency.taxFreeFrom`, `sales_channel.currency`.`item_rounding` as `sales_channel.currency.itemRounding`, `sales_channel.currency`.`total_rounding` as `sales_channel.currency.totalRounding`, `sales_channel.currency`.`created_at` as `sales_channel.currency.createdAt`, `sales_channel.currency`.`updated_at` as `sales_channel.currency.updatedAt`, `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation.shortName` as `sales_channel.currency.shortName`, `sales_channel.currency.translation.name`, `sales_channel.currency.translation.name` as `sales_channel.currency.name`, `sales_channel.currency.translation.customFields`, `sales_channel.currency.translation.customFields` as `sales_channel.currency.customFields`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN `currency` `sales_channel.currency` ON `sales_channel`.`currency_id` = `sales_channel.currency`.`id` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` LEFT JOIN (SELECT `sales_channel.currency.translation`.`currency_id`, `sales_channel.currency.translation`.`short_name` as `sales_channel.currency.translation.shortName`, `sales_channel.currency.translation`.`name` as `sales_channel.currency.translation.name`, `sales_channel.currency.translation`.`custom_fields` as `sales_channel.currency.translation.customFields` FROM `currency_translation` `sales_channel.currency.translation` WHERE `sales_channel.currency.translation`.`language_id` = ?) `sales_channel.currency.currency_translation` ON `sales_channel.currency.currency_translation`.`currency_id` = `sales_channel.currency`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.67 ms
(1.78%) 		1 
-- base-context-factory::shipping-method::read
SELECT `shipping_method`.`id` as `shipping_method.id`, `shipping_method`.`technical_name` as `shipping_method.technicalName`, `shipping_method`.`active` as `shipping_method.active`, `shipping_method`.`position` as `shipping_method.position`, `shipping_method`.`availability_rule_id` as `shipping_method.availabilityRuleId`, `shipping_method`.`media_id` as `shipping_method.mediaId`, `shipping_method`.`delivery_time_id` as `shipping_method.deliveryTimeId`, `shipping_method`.`tax_type` as `shipping_method.taxType`, `shipping_method`.`tax_id` as `shipping_method.taxId`, `shipping_method`.`created_at` as `shipping_method.createdAt`, `shipping_method`.`updated_at` as `shipping_method.updatedAt`, `shipping_method.media`.`id` as `shipping_method.media.id`, `shipping_method.media`.`user_id` as `shipping_method.media.userId`, `shipping_method.media`.`media_folder_id` as `shipping_method.media.mediaFolderId`, `shipping_method.media`.`mime_type` as `shipping_method.media.mimeType`, `shipping_method.media`.`file_extension` as `shipping_method.media.fileExtension`, `shipping_method.media`.`uploaded_at` as `shipping_method.media.uploadedAt`, `shipping_method.media`.`file_name` as `shipping_method.media.fileName`, `shipping_method.media`.`file_size` as `shipping_method.media.fileSize`, `shipping_method.media`.`media_type` as `shipping_method.media.mediaTypeRaw`, `shipping_method.media`.`meta_data` as `shipping_method.media.metaData`, `shipping_method.media`.`config` as `shipping_method.media.config`, `shipping_method.media`.`path` as `shipping_method.media.path`, `shipping_method.media`.`private` as `shipping_method.media.private`, `shipping_method.media`.`thumbnails_ro` as `shipping_method.media.thumbnailsRo`, `shipping_method.media`.`file_hash` as `shipping_method.media.fileHash`, `shipping_method.media`.`created_at` as `shipping_method.media.createdAt`, `shipping_method.media`.`updated_at` as `shipping_method.media.updatedAt`, `shipping_method.media.translation.title`, `shipping_method.media.translation.title` as `shipping_method.media.title`, `shipping_method.media.translation.alt`, `shipping_method.media.translation.alt` as `shipping_method.media.alt`, `shipping_method.media.translation.customFields`, `shipping_method.media.translation.customFields` as `shipping_method.media.customFields`, `shipping_method.translation.name`, `shipping_method.translation.name` as `shipping_method.name`, `shipping_method.translation.description`, `shipping_method.translation.description` as `shipping_method.description`, `shipping_method.translation.trackingUrl`, `shipping_method.translation.trackingUrl` as `shipping_method.trackingUrl`, `shipping_method.translation.customFields`, `shipping_method.translation.customFields` as `shipping_method.customFields` FROM `shipping_method` LEFT JOIN `media` `shipping_method.media` ON `shipping_method`.`media_id` = `shipping_method.media`.`id` LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name`, `shipping_method.translation`.`custom_fields` as `shipping_method.translation.customFields`, `shipping_method.translation`.`description` as `shipping_method.translation.description`, `shipping_method.translation`.`tracking_url` as `shipping_method.translation.trackingUrl` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN (SELECT `shipping_method.media.translation`.`media_id`, `shipping_method.media.translation`.`alt` as `shipping_method.media.translation.alt`, `shipping_method.media.translation`.`title` as `shipping_method.media.translation.title`, `shipping_method.media.translation`.`custom_fields` as `shipping_method.media.translation.customFields` FROM `media_translation` `shipping_method.media.translation` WHERE `shipping_method.media.translation`.`language_id` = ?) `shipping_method.media.media_translation` ON `shipping_method.media.media_translation`.`media_id` = `shipping_method.media`.`id` WHERE `shipping_method`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"_\x1FâIH²K®¿\x1C\x10jJ\x10Êh"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.59 ms
(1.58%) 		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/e42c208279e8497b89ccf4982225bfac"
  "/navigation/025781ddb891497ca1b5248bd8d31b35"
  "/landingPage/d731627d2d2546f487e117fc33d306fe"
  "/navigation/42b0ea3f8e9144b68a7bc76447898ea5"
  "/navigation/0c258cbbc37c470ba33dc2908d1da0ca"
  "/navigation/958897536f6849b5860dd31c89f62e46"
  "/navigation/010bfbda04f446b18ace7ebb866e9ab7"
  "/navigation/c0738bb0edb54ae4904ddc7d99af774c"
  "/navigation/0660d8319b5c48dd998f2010d115fbb1"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.58 ms
(1.54%) 		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: 
[
  "/landingPage/fad96fcd3a0b4c46824c30c5be4aef3c"
  "/landingPage/bc12060d4fe54158a88b6af0bf8318bc"
  "/landingPage/ec4b25a5ab804ce78c0619dcbacb6e3f"
  "/navigation/1537ad2ab2c2439f9c2a205a0788e24e"
  "/navigation/66b922256d2b4f6a916d19f75cd477b9"
  "/navigation/2a644fe93de544158c5a140e6e8b0430"
  "/navigation/67dbf2932a8143fdbee8f50b56bdd3ca"
  "/navigation/588bda8ffb9644e5a8a541c522e5ac6e"
  "/navigation/dbf2dec1429f40b994f19ff1406102af"
  "/navigation/b44773336870404a8548d322ca8cb761"
  "/navigation/c34a3a2d86cc4ea896f7b71271970b7f"
  "/navigation/e61eddad9b6547c59495a8b04aa1580e"
  "/landingPage/d731627d2d2546f487e117fc33d306fe"
  "/navigation/5093ee9a352a4f0ca96669f5ceb0ec15"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.57 ms
(1.52%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id = ? OR system_config.sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.54 ms
(1.42%) 		4 
SELECT translation_key, value FROM snippet WHERE snippet_set_id = ?
Parameters: 
[
  b"YÇ›7˽F±²\eŠŠÂŒq~"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.53 ms
(1.39%) 		1 
SELECT CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') `key`, CONCAT(TRIM(TRAILING '/' FROM domain.url), '/') url, LOWER(HEX(domain.id)) id, LOWER(HEX(sales_channel.id)) salesChannelId, LOWER(HEX(sales_channel.type_id)) typeId, LOWER(HEX(domain.snippet_set_id)) snippetSetId, LOWER(HEX(domain.currency_id)) currencyId, LOWER(HEX(domain.language_id)) languageId, LOWER(HEX(theme.id)) themeId, sales_channel.maintenance maintenance, sales_channel.maintenance_ip_whitelist maintenanceIpWhitelist, snippet_set.iso as locale, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName FROM sales_channel INNER JOIN sales_channel_domain domain ON domain.sales_channel_id = sales_channel.id LEFT JOIN theme_sales_channel theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id INNER JOIN snippet_set snippet_set ON snippet_set.id = domain.snippet_set_id LEFT JOIN theme theme ON theme_sales_channel.theme_id = theme.id LEFT JOIN theme parentTheme ON theme.parent_theme_id = parentTheme.id WHERE (sales_channel.type_id = UNHEX(?)) AND (sales_channel.active)
Parameters: 
[
  "8a243080f92e4c719546314b577cf82b"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.38%) 		2 
SELECT LOWER(HEX(`category`.`parent_id`)) as `category-ids.key`, COUNT(`category`.`id`) as `category-ids.count`, COUNT(DISTINCT `category`.`id`) as `visible-children-count` FROM `category` WHERE (`category`.`version_id` = ?) AND ((`category`.`path` LIKE ? AND `category`.`level` = ? AND `category`.`active` = ? AND `category`.`visible` = ?)) GROUP BY `category`.`parent_id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  "%|bb76df3750cf4285bbe8e93dda687157|%"
  4
  true
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.38%) 		2 
SELECT `shopstudio_blog_blog_post`.`id`, `shopstudio_blog_blog_post`.`auto_increment` FROM `shopstudio_blog_blog_post` LEFT JOIN `shopstudio_blog_blog_post_sales_channel` `shopstudio_blog_blog_post.salesChannels.mapping` ON `shopstudio_blog_blog_post`.`id` = `shopstudio_blog_blog_post.salesChannels.mapping`.`shopstudio_blog_blog_post_id`  LEFT JOIN `sales_channel` `shopstudio_blog_blog_post.salesChannels` ON `shopstudio_blog_blog_post.salesChannels.mapping`.`sales_channel_id` = `shopstudio_blog_blog_post.salesChannels`.`id`  WHERE (((`shopstudio_blog_blog_post`.`active` = ? AND `shopstudio_blog_blog_post.salesChannels`.`id` = ? AND `shopstudio_blog_blog_post`.`scheduled` = ? AND (`shopstudio_blog_blog_post`.`language_id` <=> ? OR `shopstudio_blog_blog_post`.`language_id` = ?)))) AND (`shopstudio_blog_blog_post`.`id` IN (?)) GROUP BY `shopstudio_blog_blog_post`.`id`
Parameters: 
[
  true
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  false
  null
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.38%) 		3 
SELECT * FROM sales_channel_api_context WHERE (sales_channel_id = ?) AND (token = ?) LIMIT 1
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  "w6MheQZpVteR19Hp9sBQ5tmtYxVpLmS2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.52 ms
(1.37%) 		2 
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"\x157­*²ÂCŸœ* Z\x07ˆâN"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(1.30%) 		4 
#cart-persister::load
            SELECT `cart`.`payload`, `cart`.`rule_ids`, `cart`.`compressed` FROM cart WHERE `token` = ?
Parameters: 
[
  "w6MheQZpVteR19Hp9sBQ5tmtYxVpLmS2"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.49 ms
(1.29%) 		1 
-- footer-pagelet::payment-methods::read
SELECT `payment_method`.`id` as `payment_method.id`, `payment_method`.`plugin_id` as `payment_method.pluginId`, `payment_method`.`handler_identifier` as `payment_method.handlerIdentifier`, `payment_method`.`position` as `payment_method.position`, `payment_method`.`active` as `payment_method.active`, `payment_method`.`after_order_enabled` as `payment_method.afterOrderEnabled`, `payment_method`.`availability_rule_id` as `payment_method.availabilityRuleId`, `payment_method`.`media_id` as `payment_method.mediaId`, `payment_method`.`technical_name` as `payment_method.technicalName`, `payment_method`.`created_at` as `payment_method.createdAt`, `payment_method`.`updated_at` as `payment_method.updatedAt`, `payment_method.media`.`id` as `payment_method.media.id`, `payment_method.media`.`user_id` as `payment_method.media.userId`, `payment_method.media`.`media_folder_id` as `payment_method.media.mediaFolderId`, `payment_method.media`.`mime_type` as `payment_method.media.mimeType`, `payment_method.media`.`file_extension` as `payment_method.media.fileExtension`, `payment_method.media`.`uploaded_at` as `payment_method.media.uploadedAt`, `payment_method.media`.`file_name` as `payment_method.media.fileName`, `payment_method.media`.`file_size` as `payment_method.media.fileSize`, `payment_method.media`.`media_type` as `payment_method.media.mediaTypeRaw`, `payment_method.media`.`meta_data` as `payment_method.media.metaData`, `payment_method.media`.`config` as `payment_method.media.config`, `payment_method.media`.`path` as `payment_method.media.path`, `payment_method.media`.`private` as `payment_method.media.private`, `payment_method.media`.`thumbnails_ro` as `payment_method.media.thumbnailsRo`, `payment_method.media`.`file_hash` as `payment_method.media.fileHash`, `payment_method.media`.`created_at` as `payment_method.media.createdAt`, `payment_method.media`.`updated_at` as `payment_method.media.updatedAt`, `payment_method.media.translation.title`, `payment_method.media.translation.title` as `payment_method.media.title`, `payment_method.media.translation.alt`, `payment_method.media.translation.alt` as `payment_method.media.alt`, `payment_method.media.translation.customFields`, `payment_method.media.translation.customFields` as `payment_method.media.customFields`, `payment_method.translation.name`, `payment_method.translation.name` as `payment_method.name`, `payment_method.translation.distinguishableName`, `payment_method.translation.distinguishableName` as `payment_method.distinguishableName`, `payment_method.translation.description`, `payment_method.translation.description` as `payment_method.description`, `payment_method.translation.customFields`, `payment_method.translation.customFields` as `payment_method.customFields` FROM `payment_method` LEFT JOIN `media` `payment_method.media` ON `payment_method`.`media_id` = `payment_method.media`.`id` LEFT JOIN (SELECT `payment_method.translation`.`payment_method_id`, `payment_method.translation`.`name` as `payment_method.translation.name`, `payment_method.translation`.`distinguishable_name` as `payment_method.translation.distinguishableName`, `payment_method.translation`.`description` as `payment_method.translation.description`, `payment_method.translation`.`custom_fields` as `payment_method.translation.customFields` FROM `payment_method_translation` `payment_method.translation` WHERE `payment_method.translation`.`language_id` = ?) `payment_method.payment_method_translation` ON `payment_method.payment_method_translation`.`payment_method_id` = `payment_method`.`id` LEFT JOIN (SELECT `payment_method.media.translation`.`media_id`, `payment_method.media.translation`.`alt` as `payment_method.media.translation.alt`, `payment_method.media.translation`.`title` as `payment_method.media.translation.title`, `payment_method.media.translation`.`custom_fields` as `payment_method.media.translation.customFields` FROM `media_translation` `payment_method.media.translation` WHERE `payment_method.media.translation`.`language_id` = ?) `payment_method.media.media_translation` ON `payment_method.media.media_translation`.`media_id` = `payment_method.media`.`id` WHERE `payment_method`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"'\x12Qö¬êG!·X>‡Å²\x08E"
  b"1k–\x00\x1DˆKE¼\tdá¼òê<"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.28%) 		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: 
[
  "/blog/detail/4679f6c71b844d6aa90ef67b2f8484a5"
  "/detail/c86d659687a846cba13079095c5a6808"
  "/detail/89137dbc81304143b2af3cdaf21a8688"
  "/detail/d44188ab19504bfda75f9138fb1a9c41"
  "/detail/751bf63366cc4dc89b3a672a615e181c"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.48 ms
(1.27%) 		2 
-- seo-url::resolve-fallback
SELECT path_info pathInfo, seo_path_info seoPathInfo FROM seo_url WHERE (language_id = ?) AND (sales_channel_id = ?) AND (path_info = ?) AND (is_canonical = 1) AND (is_deleted = 0) LIMIT 1
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  "/_esi/global/header"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.47 ms
(1.25%) 		1 
-- header::languages::search-ids
SELECT `language`.`id` FROM `language` LEFT JOIN `sales_channel_domain` `language.salesChannelDomains` ON `language`.`id` = `language.salesChannelDomains`.`language_id` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language`.`id` = `language.salesChannels.mapping`.`language_id`  LEFT JOIN `sales_channel` `language.salesChannels` ON `language.salesChannels.mapping`.`sales_channel_id` = `language.salesChannels`.`id`  WHERE (`language.salesChannelDomains`.`sales_channel_id` = ? AND `language.salesChannels`.`id` = ?) GROUP BY `language`.`id` ORDER BY MIN(`language`.`name`) ASC
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(1.21%) 		1 
-- theme-service::resolve-media::read
SELECT `media`.`id` as `media.id`, `media`.`user_id` as `media.userId`, `media`.`media_folder_id` as `media.mediaFolderId`, `media`.`mime_type` as `media.mimeType`, `media`.`file_extension` as `media.fileExtension`, `media`.`uploaded_at` as `media.uploadedAt`, `media`.`file_name` as `media.fileName`, `media`.`file_size` as `media.fileSize`, `media`.`media_type` as `media.mediaTypeRaw`, `media`.`meta_data` as `media.metaData`, `media`.`config` as `media.config`, `media`.`path` as `media.path`, `media`.`private` as `media.private`, `media`.`thumbnails_ro` as `media.thumbnailsRo`, `media`.`file_hash` as `media.fileHash`, `media`.`created_at` as `media.createdAt`, `media`.`updated_at` as `media.updatedAt`, `media.translation.title`, `media.translation.title` as `media.title`, `media.translation.alt`, `media.translation.alt` as `media.alt`, `media.translation.customFields`, `media.translation.customFields` as `media.customFields` FROM `media` LEFT JOIN `media_folder` `media.mediaFolder` ON `media`.`media_folder_id` = `media.mediaFolder`.`id` LEFT JOIN (SELECT `media.translation`.`media_id`, `media.translation`.`alt` as `media.translation.alt`, `media.translation`.`title` as `media.translation.title`, `media.translation`.`custom_fields` as `media.translation.customFields` FROM `media_translation` `media.translation` WHERE `media.translation`.`language_id` = ?) `media.media_translation` ON `media.media_translation`.`media_id` = `media`.`id` LEFT JOIN `media_default_folder` `media.mediaFolder.defaultFolder` ON `media.mediaFolder`.`default_folder_id` = `media.mediaFolder.defaultFolder`.`id` WHERE (((`media`.`private` = ? OR (`media`.`private` = ? AND `media.mediaFolder.defaultFolder`.`entity` = ?)))) AND (`media`.`id` IN (?, ?, ?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  false
  true
  "product_download"
  b" V\x02r#BN:Ž÷{Æf\x0FýÛ"
  b"fϘèHGJ‰€¶û|#\x1Cî"
  b"kë—¶5oK餂4\x1A};7Û"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.20%) 		3 
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"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.45 ms
(1.20%) 		1 
-- footer-pagelet::shipping-methods::search-ids
SELECT `shipping_method`.`id` FROM `shipping_method` LEFT JOIN `sales_channel_shipping_method` `shipping_method.salesChannels.mapping` ON `shipping_method`.`id` = `shipping_method.salesChannels.mapping`.`shipping_method_id`  LEFT JOIN (SELECT `shipping_method.translation`.`shipping_method_id`, `shipping_method.translation`.`name` as `shipping_method.translation.name` FROM `shipping_method_translation` `shipping_method.translation` WHERE `shipping_method.translation`.`language_id` = ?) `shipping_method.shipping_method_translation` ON `shipping_method.shipping_method_translation`.`shipping_method_id` = `shipping_method`.`id` LEFT JOIN `sales_channel` `shipping_method.salesChannels` ON `shipping_method.salesChannels.mapping`.`sales_channel_id` = `shipping_method.salesChannels`.`id`  WHERE (`shipping_method`.`active` = ? AND `shipping_method.salesChannels`.`id` = ?) GROUP BY `shipping_method`.`id` ORDER BY MIN(`shipping_method`.`position`) ASC, MIN(COALESCE(`shipping_method.translation.name`)) ASC
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  true
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.44 ms
(1.17%) 		2 
# navigation-route::meta-information
            SELECT LOWER(HEX(`id`)), `path`, `level`
            FROM `category`
            WHERE `id` = ? OR `id` = ?
Parameters: 
[
  b"»vß7PÏB…»èé=ÚhqW"
  b"»vß7PÏB…»èé=ÚhqW"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(1.15%) 		1 
-- header::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` WHERE `language`.`id` IN (?, ?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x12|s}«\x15Kð«H\x1A£qqÞ„"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.43 ms
(1.13%) 		1 
-- base-context-factory::taxes::association::rules::read
SELECT `tax_rule`.`id` as `tax_rule.id`, `tax_rule`.`tax_rule_type_id` as `tax_rule.taxRuleTypeId`, `tax_rule`.`country_id` as `tax_rule.countryId`, `tax_rule`.`tax_rate` as `tax_rule.taxRate`, `tax_rule`.`data` as `tax_rule.data`, `tax_rule`.`tax_id` as `tax_rule.taxId`, `tax_rule`.`active_from` as `tax_rule.activeFrom`, `tax_rule`.`created_at` as `tax_rule.createdAt`, `tax_rule`.`updated_at` as `tax_rule.updatedAt`, `tax_rule.type`.`id` as `tax_rule.type.id`, `tax_rule.type`.`technical_name` as `tax_rule.type.technicalName`, `tax_rule.type`.`position` as `tax_rule.type.position`, `tax_rule.type`.`created_at` as `tax_rule.type.createdAt`, `tax_rule.type`.`updated_at` as `tax_rule.type.updatedAt`, `tax_rule.type.translation.typeName`, `tax_rule.type.translation.typeName` as `tax_rule.type.typeName` FROM `tax_rule` LEFT JOIN `tax_rule_type` `tax_rule.type` ON `tax_rule`.`tax_rule_type_id` = `tax_rule.type`.`id` LEFT JOIN (SELECT `tax_rule.type.translation`.`tax_rule_type_id`, `tax_rule.type.translation`.`type_name` as `tax_rule.type.translation.typeName` FROM `tax_rule_type_translation` `tax_rule.type.translation` WHERE `tax_rule.type.translation`.`language_id` = ?) `tax_rule.type.tax_rule_type_translation` ON `tax_rule.type.tax_rule_type_translation`.`tax_rule_type_id` = `tax_rule.type`.`id` WHERE ((`tax_rule`.`tax_id` IN (?, ?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"FE2–ŽFù±‹z\füŽ*D"
  b"†\x1F”lÅûF\x04•<YiÌ2cç"
  b"ŒÏz˜iAÒ˜Ñýz¸ª{‹"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(1.12%) 		1 
-- base-context-factory::sales-channel::association::languages::read
SELECT `language`.`id` as `language.id`, `language`.`parent_id` as `language.parentId`, `language`.`locale_id` as `language.localeId`, `language`.`translation_code_id` as `language.translationCodeId`, `language`.`name` as `language.name`, `language`.`active` as `language.active`, `language`.`custom_fields` as `language.customFields`, `language`.`created_at` as `language.createdAt`, `language`.`updated_at` as `language.updatedAt`, `language.translationCode`.`id` as `language.translationCode.id`, `language.translationCode`.`code` as `language.translationCode.code`, `language.translationCode`.`created_at` as `language.translationCode.createdAt`, `language.translationCode`.`updated_at` as `language.translationCode.updatedAt`, `language.translationCode.translation.name`, `language.translationCode.translation.name` as `language.translationCode.name`, `language.translationCode.translation.territory`, `language.translationCode.translation.territory` as `language.translationCode.territory`, `language.translationCode.translation.customFields`, `language.translationCode.translation.customFields` as `language.translationCode.customFields`, `language.locale`.`id` as `language.locale.id`, `language.locale`.`code` as `language.locale.code`, `language.locale`.`created_at` as `language.locale.createdAt`, `language.locale`.`updated_at` as `language.locale.updatedAt`, `language.locale.translation.name`, `language.locale.translation.name` as `language.locale.name`, `language.locale.translation.territory`, `language.locale.translation.territory` as `language.locale.territory`, `language.locale.translation.customFields`, `language.locale.translation.customFields` as `language.locale.customFields` FROM `language` LEFT JOIN `locale` `language.translationCode` ON `language`.`translation_code_id` = `language.translationCode`.`id` LEFT JOIN `locale` `language.locale` ON `language`.`locale_id` = `language.locale`.`id` LEFT JOIN (SELECT `language.translationCode.translation`.`locale_id`, `language.translationCode.translation`.`name` as `language.translationCode.translation.name`, `language.translationCode.translation`.`territory` as `language.translationCode.translation.territory`, `language.translationCode.translation`.`custom_fields` as `language.translationCode.translation.customFields` FROM `locale_translation` `language.translationCode.translation` WHERE `language.translationCode.translation`.`language_id` = ?) `language.translationCode.locale_translation` ON `language.translationCode.locale_translation`.`locale_id` = `language.translationCode`.`id` LEFT JOIN (SELECT `language.locale.translation`.`locale_id`, `language.locale.translation`.`name` as `language.locale.translation.name`, `language.locale.translation`.`territory` as `language.locale.translation.territory`, `language.locale.translation`.`custom_fields` as `language.locale.translation.customFields` FROM `locale_translation` `language.locale.translation` WHERE `language.locale.translation`.`language_id` = ?) `language.locale.locale_translation` ON `language.locale.locale_translation`.`locale_id` = `language.locale`.`id` WHERE ((`language`.`id` = ?)) AND (`language`.`id` IN (?))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.42 ms
(1.11%) 		1 
-- cart-rule-loader::load-rules::search-ids
SELECT `rule`.`id` FROM `rule` WHERE (`rule`.`invalid` = ?) ORDER BY `rule`.`priority` DESC, `rule`.`id` ASC LIMIT 500
Parameters: 
[
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(1.04%) 		1 
SELECT `sales_channel`.`id` as `sales_channel.id`, `sales_channel`.`type_id` as `sales_channel.typeId`, `sales_channel`.`language_id` as `sales_channel.languageId`, `sales_channel`.`customer_group_id` as `sales_channel.customerGroupId`, `sales_channel`.`currency_id` as `sales_channel.currencyId`, `sales_channel`.`payment_method_id` as `sales_channel.paymentMethodId`, `sales_channel`.`shipping_method_id` as `sales_channel.shippingMethodId`, `sales_channel`.`country_id` as `sales_channel.countryId`, `sales_channel`.`analytics_id` as `sales_channel.analyticsId`, `sales_channel`.`navigation_category_id` as `sales_channel.navigationCategoryId`, `sales_channel`.`navigation_category_version_id` as `sales_channel.navigationCategoryVersionId`, `sales_channel`.`navigation_category_depth` as `sales_channel.navigationCategoryDepth`, `sales_channel`.`footer_category_id` as `sales_channel.footerCategoryId`, `sales_channel`.`footer_category_version_id` as `sales_channel.footerCategoryVersionId`, `sales_channel`.`service_category_id` as `sales_channel.serviceCategoryId`, `sales_channel`.`service_category_version_id` as `sales_channel.serviceCategoryVersionId`, `sales_channel`.`mail_header_footer_id` as `sales_channel.mailHeaderFooterId`, `sales_channel`.`hreflang_default_domain_id` as `sales_channel.hreflangDefaultDomainId`, `sales_channel`.`measurement_units` as `sales_channel.measurementUnits`, `sales_channel`.`short_name` as `sales_channel.shortName`, `sales_channel`.`tax_calculation_type` as `sales_channel.taxCalculationType`, `sales_channel`.`access_key` as `sales_channel.accessKey`, `sales_channel`.`configuration` as `sales_channel.configuration`, `sales_channel`.`active` as `sales_channel.active`, `sales_channel`.`hreflang_active` as `sales_channel.hreflangActive`, `sales_channel`.`maintenance` as `sales_channel.maintenance`, `sales_channel`.`maintenance_ip_whitelist` as `sales_channel.maintenanceIpWhitelist`, `sales_channel`.`payment_method_ids` as `sales_channel.paymentMethodIds`, `sales_channel`.`home_cms_page_id` as `sales_channel.homeCmsPageId`, `sales_channel`.`home_cms_page_version_id` as `sales_channel.homeCmsPageVersionId`, `sales_channel`.`created_at` as `sales_channel.createdAt`, `sales_channel`.`updated_at` as `sales_channel.updatedAt`, `sales_channel.translation.name`, `sales_channel.translation.name` as `sales_channel.name`, `sales_channel.translation.homeSlotConfig`, `sales_channel.translation.homeSlotConfig` as `sales_channel.homeSlotConfig`, `sales_channel.translation.homeEnabled`, `sales_channel.translation.homeEnabled` as `sales_channel.homeEnabled`, `sales_channel.translation.homeName`, `sales_channel.translation.homeName` as `sales_channel.homeName`, `sales_channel.translation.homeMetaTitle`, `sales_channel.translation.homeMetaTitle` as `sales_channel.homeMetaTitle`, `sales_channel.translation.homeMetaDescription`, `sales_channel.translation.homeMetaDescription` as `sales_channel.homeMetaDescription`, `sales_channel.translation.homeKeywords`, `sales_channel.translation.homeKeywords` as `sales_channel.homeKeywords`, `sales_channel.translation.customFields`, `sales_channel.translation.customFields` as `sales_channel.customFields` FROM `sales_channel` LEFT JOIN (SELECT `sales_channel.translation`.`sales_channel_id`, `sales_channel.translation`.`name` as `sales_channel.translation.name`, `sales_channel.translation`.`custom_fields` as `sales_channel.translation.customFields`, `sales_channel.translation`.`home_slot_config` as `sales_channel.translation.homeSlotConfig`, `sales_channel.translation`.`home_enabled` as `sales_channel.translation.homeEnabled`, `sales_channel.translation`.`home_name` as `sales_channel.translation.homeName`, `sales_channel.translation`.`home_meta_title` as `sales_channel.translation.homeMetaTitle`, `sales_channel.translation`.`home_meta_description` as `sales_channel.translation.homeMetaDescription`, `sales_channel.translation`.`home_keywords` as `sales_channel.translation.homeKeywords` FROM `sales_channel_translation` `sales_channel.translation` WHERE `sales_channel.translation`.`language_id` = ?) `sales_channel.sales_channel_translation` ON `sales_channel.sales_channel_translation`.`sales_channel_id` = `sales_channel`.`id` WHERE `sales_channel`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.38 ms
(1.02%) 		1 
SELECT LOWER(HEX(language.id)) AS array_key, LOWER(HEX(language.id)) AS id, locale.code, parentLocale.code AS parentCode, LOWER(HEX(language.parent_id)) parentId FROM language LEFT JOIN locale locale ON language.translation_code_id = locale.id LEFT JOIN language parentLanguage ON language.parent_id = parentLanguage.id LEFT JOIN locale parentLocale ON parentLanguage.translation_code_id = parentLocale.id
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.36 ms
(0.94%) 		1 
# context-factory::base-context

        SELECT
          sales_channel.id as sales_channel_id,
          sales_channel.language_id as sales_channel_default_language_id,
          sales_channel.currency_id as sales_channel_currency_id,
          currency.factor as sales_channel_currency_factor,
          GROUP_CONCAT(LOWER(HEX(sales_channel_language.language_id))) as sales_channel_language_ids
        FROM sales_channel
            INNER JOIN currency
                ON sales_channel.currency_id = currency.id
            LEFT JOIN sales_channel_language
                ON sales_channel_language.sales_channel_id = sales_channel.id
        WHERE sales_channel.id = ?
        GROUP BY sales_channel.id, sales_channel.language_id, sales_channel.currency_id, currency.factor
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.93%) 		4 
SELECT iso FROM snippet_set WHERE id = ?
Parameters: 
[
  b"YÇ›7˽F±²\eŠŠÂŒq~"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.35 ms
(0.92%) 		1 
-- base-context-factory::country::read
SELECT `country`.`id` as `country.id`, `country`.`iso` as `country.iso`, `country`.`position` as `country.position`, `country`.`active` as `country.active`, `country`.`shipping_available` as `country.shippingAvailable`, `country`.`iso3` as `country.iso3`, `country`.`display_state_in_registration` as `country.displayStateInRegistration`, `country`.`force_state_in_registration` as `country.forceStateInRegistration`, `country`.`check_vat_id_pattern` as `country.checkVatIdPattern`, `country`.`vat_id_required` as `country.vatIdRequired`, `country`.`vat_id_pattern` as `country.vatIdPattern`, `country`.`customer_tax` as `country.customerTax`, `country`.`company_tax` as `country.companyTax`, `country`.`postal_code_required` as `country.postalCodeRequired`, `country`.`check_postal_code_pattern` as `country.checkPostalCodePattern`, `country`.`check_advanced_postal_code_pattern` as `country.checkAdvancedPostalCodePattern`, `country`.`advanced_postal_code_pattern` as `country.advancedPostalCodePattern`, `country`.`default_postal_code_pattern` as `country.defaultPostalCodePattern`, `country`.`is_eu` as `country.isEu`, `country`.`created_at` as `country.createdAt`, `country`.`updated_at` as `country.updatedAt`, `country.translation.name`, `country.translation.name` as `country.name`, `country.translation.addressFormat`, `country.translation.addressFormat` as `country.addressFormat`, `country.translation.customFields`, `country.translation.customFields` as `country.customFields` FROM `country` LEFT JOIN (SELECT `country.translation`.`country_id`, `country.translation`.`name` as `country.translation.name`, `country.translation`.`custom_fields` as `country.translation.customFields`, `country.translation`.`address_format` as `country.translation.addressFormat` FROM `country_translation` `country.translation` WHERE `country.translation`.`language_id` = ?) `country.country_translation` ON `country.country_translation`.`country_id` = `country`.`id` WHERE `country`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"“ôçÐÍyH°„\f!4ñt^Î"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.34 ms
(0.91%) 		1 
SELECT `product`.`id`, `product`.`product_number`, `product`.`auto_increment` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `product_visibility` `product.visibilities` ON `product`.`visibilities` = `product.visibilities`.`product_id` AND `product`.version_id = `product.visibilities`.product_version_id WHERE (`product`.`version_id` = ?) AND ((((`product.visibilities`.`visibility` >= ?) AND `product.visibilities`.`sales_channel_id` = ? AND IFNULL(`product`.`active`, `product.parent`.`active`) = ?))) AND (`product`.`id` IN (?, ?, ?, ?)) GROUP BY `product`.`id`
Parameters: 
[
  b"\x0F©\x1CãéjK¾KÙÎu,4%"
  10
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  true
  b"Ème–‡¨FË¡0y\t\Zh\x08"
  b"‰\x13}¼0AC²¯<Úò\x1A†ˆ"
  b"ÔAˆ«\x19PKý§_‘8û\x1AœA"
  b"u\eö3fÌMÈ›:g*a^\x18\x1C"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.89%) 		1 
-- base-context-factory::customer-group::read
SELECT `customer_group`.`id` as `customer_group.id`, `customer_group`.`display_gross` as `customer_group.displayGross`, `customer_group`.`registration_active` as `customer_group.registrationActive`, `customer_group`.`created_at` as `customer_group.createdAt`, `customer_group`.`updated_at` as `customer_group.updatedAt`, `customer_group.translation.name`, `customer_group.translation.name` as `customer_group.name`, `customer_group.translation.registrationTitle`, `customer_group.translation.registrationTitle` as `customer_group.registrationTitle`, `customer_group.translation.registrationIntroduction`, `customer_group.translation.registrationIntroduction` as `customer_group.registrationIntroduction`, `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationOnlyCompanyRegistration` as `customer_group.registrationOnlyCompanyRegistration`, `customer_group.translation.registrationSeoMetaDescription`, `customer_group.translation.registrationSeoMetaDescription` as `customer_group.registrationSeoMetaDescription`, `customer_group.translation.customFields`, `customer_group.translation.customFields` as `customer_group.customFields` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name`, `customer_group.translation`.`custom_fields` as `customer_group.translation.customFields`, `customer_group.translation`.`registration_title` as `customer_group.translation.registrationTitle`, `customer_group.translation`.`registration_introduction` as `customer_group.translation.registrationIntroduction`, `customer_group.translation`.`registration_only_company_registration` as `customer_group.translation.registrationOnlyCompanyRegistration`, `customer_group.translation`.`registration_seo_meta_description` as `customer_group.translation.registrationSeoMetaDescription` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE `customer_group`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"Tk=TŽÕOô„Wߥ¥p”o"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.87%) 		1 
-- footer-pagelet::payment-methods::search-ids
SELECT `payment_method`.`id` FROM `payment_method` LEFT JOIN `sales_channel_payment_method` `payment_method.salesChannels.mapping` ON `payment_method`.`id` = `payment_method.salesChannels.mapping`.`payment_method_id`  LEFT JOIN `sales_channel` `payment_method.salesChannels` ON `payment_method.salesChannels.mapping`.`sales_channel_id` = `payment_method.salesChannels`.`id`  WHERE (`payment_method`.`active` = ? AND `payment_method.salesChannels`.`id` = ?) GROUP BY `payment_method`.`id` ORDER BY MIN(`payment_method`.`position`) ASC
Parameters: 
[
  true
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(0.86%) 		1 
SELECT `name`, `type` FROM `custom_field` WHERE `active` = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.84%) 		1 
-- theme-service::load-config::read
SELECT `theme`.`id` as `theme.id`, `theme`.`technical_name` as `theme.technicalName`, `theme`.`name` as `theme.name`, `theme`.`author` as `theme.author`, `theme`.`preview_media_id` as `theme.previewMediaId`, `theme`.`parent_theme_id` as `theme.parentThemeId`, `theme`.`theme_json` as `theme.themeJson`, `theme`.`base_config` as `theme.baseConfig`, `theme`.`config_values` as `theme.configValues`, `theme`.`active` as `theme.active`, `theme`.`created_at` as `theme.createdAt`, `theme`.`updated_at` as `theme.updatedAt`, `theme.translation.description`, `theme.translation.description` as `theme.description`, `theme.translation.labels`, `theme.translation.labels` as `theme.labels`, `theme.translation.helpTexts`, `theme.translation.helpTexts` as `theme.helpTexts`, `theme.translation.customFields`, `theme.translation.customFields` as `theme.customFields` FROM `theme` LEFT JOIN (SELECT `theme.translation`.`theme_id`, `theme.translation`.`description` as `theme.translation.description`, `theme.translation`.`labels` as `theme.translation.labels`, `theme.translation`.`help_texts` as `theme.translation.helpTexts`, `theme.translation`.`custom_fields` as `theme.translation.customFields` FROM `theme_translation` `theme.translation` WHERE `theme.translation`.`language_id` = ?) `theme.theme_translation` ON `theme.theme_translation`.`theme_id` = `theme`.`id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.84%) 		1 
-- base-context-factory::currency::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(0.84%) 		1 
SELECT `customer_group`.`id` FROM `customer_group` LEFT JOIN (SELECT `customer_group.translation`.`customer_group_id`, `customer_group.translation`.`name` as `customer_group.translation.name` FROM `customer_group_translation` `customer_group.translation` WHERE `customer_group.translation`.`language_id` = ?) `customer_group.customer_group_translation` ON `customer_group.customer_group_translation`.`customer_group_id` = `customer_group`.`id` WHERE ((COALESCE(`customer_group.translation.name`) IN (?, ?)))
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  "Gesperrte-Kundengruppe"
  "Declined customer group"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.75%) 		1 
-- header::currencies::read
SELECT `currency`.`id` as `currency.id`, `currency`.`factor` as `currency.factor`, `currency`.`symbol` as `currency.symbol`, `currency`.`iso_code` as `currency.isoCode`, `currency`.`position` as `currency.position`, `currency`.`tax_free_from` as `currency.taxFreeFrom`, `currency`.`item_rounding` as `currency.itemRounding`, `currency`.`total_rounding` as `currency.totalRounding`, `currency`.`created_at` as `currency.createdAt`, `currency`.`updated_at` as `currency.updatedAt`, `currency.translation.shortName`, `currency.translation.shortName` as `currency.shortName`, `currency.translation.name`, `currency.translation.name` as `currency.name`, `currency.translation.customFields`, `currency.translation.customFields` as `currency.customFields` FROM `currency` LEFT JOIN (SELECT `currency.translation`.`currency_id`, `currency.translation`.`short_name` as `currency.translation.shortName`, `currency.translation`.`name` as `currency.translation.name`, `currency.translation`.`custom_fields` as `currency.translation.customFields` FROM `currency_translation` `currency.translation` WHERE `currency.translation`.`language_id` = ?) `currency.currency_translation` ON `currency.currency_translation`.`currency_id` = `currency`.`id` WHERE `currency`.`id` IN (?)
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.74%) 		1 
SELECT `shopstudio_blog_blog_post_content_translation`.`config` as `shopstudio_blog_blog_post_content_translation.config`, `shopstudio_blog_blog_post_content_translation`.`created_at` as `shopstudio_blog_blog_post_content_translation.createdAt`, `shopstudio_blog_blog_post_content_translation`.`updated_at` as `shopstudio_blog_blog_post_content_translation.updatedAt`, `shopstudio_blog_blog_post_content_translation`.`shopstudio_blog_blog_post_content_id` as `shopstudio_blog_blog_post_content_translation.shopstudioBlogBlogPostContentId`, `shopstudio_blog_blog_post_content_translation`.`language_id` as `shopstudio_blog_blog_post_content_translation.languageId` FROM `shopstudio_blog_blog_post_content_translation` WHERE ((`shopstudio_blog_blog_post_content_translation`.`shopstudio_blog_blog_post_content_id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)))
Parameters: 
[
  b"‘g›Q\x12§JS¬=\dp€x\x18"
  b"a^IN™×L°Á½EŽí½\x1E"
  b"%£\x05îR9FQ…‰â&\x1D]\vQ"
  b"è\x1D#…ÄÊO5Ž@©Ý\x07ëu§"
  b"˜x ÇQXG4“rm<\x1Ax‰Á"
  b"\x18¼vÉ-tFS¢OßþŒV\x11"
  b"[zdï\x05\x1ADt›X\x1E\x08Õ5Š"
  b"""
    Ë\n
    eã|áC?¬c\x12\x05çν©
    """
  b"ˆ\x119\x017ÜA{¢2‰BlhÂø"
  b"\x10ý\x16m#ªO_˜*+PÝ0¡‹"
  b"\x00Š\x14tÚðG1­Â\x1FI%fN2"
  b"ŠTW2\r J<©õÒ)_mÚA"
  b"JÒ­´@½L¦Š³3hð¨V/"
  b"R{\fÑ&HO=”\x14¡VšÁ²\x7F"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.28 ms
(0.74%) 		3 
-- 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`.`track_offcanvas_cart` as `sales_channel_analytics.trackOffcanvasCart`, `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"ÚEÐê$Dï#œvw\x06]t"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.72%) 		2 
SELECT COUNT(*) FROM (SELECT `shopstudio_blog_blog_post_vote`.`id` FROM `shopstudio_blog_blog_post_vote` WHERE ((`shopstudio_blog_blog_post_vote`.`shopstudio_blog_blog_post_id` = ? AND `shopstudio_blog_blog_post_vote`.`type` = ?))) total
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
  "like"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.72%) 		2 
SELECT `shopstudio_blog_blog_post_vote`.`id` FROM `shopstudio_blog_blog_post_vote` WHERE ((`shopstudio_blog_blog_post_vote`.`shopstudio_blog_blog_post_id` = ? AND `shopstudio_blog_blog_post_vote`.`type` = ?))
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
  "like"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.71%) 		1 
SELECT `product_price`.`id` as `product_price.id`, `product_price`.`version_id` as `product_price.versionId`, `product_price`.`product_id` as `product_price.productId`, `product_price`.`product_version_id` as `product_price.productVersionId`, `product_price`.`rule_id` as `product_price.ruleId`, `product_price`.`price` as `product_price.price`, `product_price`.`custom_fields` as `product_price.customFields`, `product_price`.`quantity_start` as `product_price.quantityStart`, `product_price`.`quantity_end` as `product_price.quantityEnd`, `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"u\eö3fÌMÈ›:g*a^\x18\x1C"
  b"‰\x13}¼0AC²¯<Úò\x1A†ˆ"
  b"Ème–‡¨FË¡0y\t\Zh\x08"
  b"ÔAˆ«\x19PKý§_‘8û\x1AœA"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(0.71%) 		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.25 ms
(0.65%) 		1 
-- header::currencies::search-ids
SELECT `currency`.`id` FROM `currency` LEFT JOIN `sales_channel_currency` `currency.salesChannels.mapping` ON `currency`.`id` = `currency.salesChannels.mapping`.`currency_id`  LEFT JOIN `sales_channel` `currency.salesChannels` ON `currency.salesChannels.mapping`.`sales_channel_id` = `currency.salesChannels`.`id`  WHERE (`currency.salesChannels`.`id` = ?) GROUP BY `currency`.`id`
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.65%) 		1 
SELECT `shopstudio_blog_blog_post_comment`.`id` FROM `shopstudio_blog_blog_post_comment` WHERE ((`shopstudio_blog_blog_post_comment`.`shopstudio_blog_blog_post_id` = ? AND `shopstudio_blog_blog_post_comment`.`status` = ?)) ORDER BY `shopstudio_blog_blog_post_comment`.`created_at` ASC LIMIT 10
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(0.64%) 		1 
SELECT LOWER(HEX(`language.salesChannels.mapping`.`sales_channel_id`)) as `key`, GROUP_CONCAT(LOWER(HEX(`language.salesChannels.mapping`.`language_id`)) ) as `value` FROM `language` LEFT JOIN `sales_channel_language` `language.salesChannels.mapping` ON `language.salesChannels.mapping`.`language_id` = `language`.id WHERE ((`language`.`id` = ?)) AND (`language.salesChannels.mapping`.`sales_channel_id` IN (?)) GROUP BY `language.salesChannels.mapping`.`sales_channel_id`
Parameters: 
[
  b"/»_ââšMpªXTÎ|ãâ\v"
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.61%) 		1 
-- base-context-factory::cash-rounding::search-ids
SELECT `currency_country_rounding`.`id` FROM `currency_country_rounding` WHERE (`currency_country_rounding`.`currency_id` = ? AND `currency_country_rounding`.`country_id` = ?) LIMIT 1
Parameters: 
[
  b"·ÒUK\fèGÍ‚ó¬›ÑÀßÊ"
  b"“ôçÐÍyH°„\f!4ñt^Î"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(0.61%) 		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.23 ms
(0.61%) 		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.22 ms
(0.59%) 		1 
SELECT LOWER(HEX(theme.id)) themeId, theme.technical_name as themeName, parentTheme.technical_name as parentThemeName, LOWER(HEX(parentTheme.parent_theme_id)) as grandParentThemeId
            FROM sales_channel
                LEFT JOIN theme_sales_channel ON sales_channel.id = theme_sales_channel.sales_channel_id
                LEFT JOIN theme ON theme_sales_channel.theme_id = theme.id
                LEFT JOIN theme AS parentTheme ON parentTheme.id = theme.parent_theme_id
            WHERE sales_channel.id = ?
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.54%) 		1 
-- base-context-factory::sales-channel::association::domains::read
SELECT `sales_channel_domain`.`id` as `sales_channel_domain.id`, `sales_channel_domain`.`url` as `sales_channel_domain.url`, `sales_channel_domain`.`sales_channel_id` as `sales_channel_domain.salesChannelId`, `sales_channel_domain`.`language_id` as `sales_channel_domain.languageId`, `sales_channel_domain`.`currency_id` as `sales_channel_domain.currencyId`, `sales_channel_domain`.`snippet_set_id` as `sales_channel_domain.snippetSetId`, `sales_channel_domain`.`measurement_units` as `sales_channel_domain.measurementUnits`, `sales_channel_domain`.`hreflang_use_only_locale` as `sales_channel_domain.hreflangUseOnlyLocale`, `sales_channel_domain`.`custom_fields` as `sales_channel_domain.customFields`, `sales_channel_domain`.`created_at` as `sales_channel_domain.createdAt`, `sales_channel_domain`.`updated_at` as `sales_channel_domain.updatedAt` FROM `sales_channel_domain` WHERE ((`sales_channel_domain`.`sales_channel_id` IN (?)))
Parameters: 
[
  b"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.52%) 		1 
-- base-context-factory::taxes::read
SELECT `tax`.`id` as `tax.id`, `tax`.`tax_rate` as `tax.taxRate`, `tax`.`name` as `tax.name`, `tax`.`position` as `tax.position`, `tax`.`custom_fields` as `tax.customFields`, `tax`.`created_at` as `tax.createdAt`, `tax`.`updated_at` as `tax.updatedAt` FROM `tax`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.51%) 		1 
SELECT `shopstudio_blog_blog_post_translation`.`title` as `shopstudio_blog_blog_post_translation.title`, `shopstudio_blog_blog_post_translation`.`description` as `shopstudio_blog_blog_post_translation.description`, `shopstudio_blog_blog_post_translation`.`meta_title` as `shopstudio_blog_blog_post_translation.metaTitle`, `shopstudio_blog_blog_post_translation`.`meta_description` as `shopstudio_blog_blog_post_translation.metaDescription`, `shopstudio_blog_blog_post_translation`.`robots` as `shopstudio_blog_blog_post_translation.robots`, `shopstudio_blog_blog_post_translation`.`keywords` as `shopstudio_blog_blog_post_translation.keywords`, `shopstudio_blog_blog_post_translation`.`custom_fields` as `shopstudio_blog_blog_post_translation.customFields`, `shopstudio_blog_blog_post_translation`.`created_at` as `shopstudio_blog_blog_post_translation.createdAt`, `shopstudio_blog_blog_post_translation`.`updated_at` as `shopstudio_blog_blog_post_translation.updatedAt`, `shopstudio_blog_blog_post_translation`.`shopstudio_blog_blog_post_id` as `shopstudio_blog_blog_post_translation.shopstudioBlogBlogPostId`, `shopstudio_blog_blog_post_translation`.`language_id` as `shopstudio_blog_blog_post_translation.languageId` FROM `shopstudio_blog_blog_post_translation` WHERE ((`shopstudio_blog_blog_post_translation`.`shopstudio_blog_blog_post_id` IN (?)))
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.19 ms
(0.50%) 		1 
SELECT `shopstudio_blog_blog_post_cross_selling`.`id` FROM `shopstudio_blog_blog_post_cross_selling` WHERE (`shopstudio_blog_blog_post_cross_selling`.`blog_post_id` = ? AND `shopstudio_blog_blog_post_cross_selling`.`active` = ?) ORDER BY `shopstudio_blog_blog_post_cross_selling`.`position` ASC
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
  true
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.46%) 		1 
SELECT `base_class` AS `baseClass`, `author`
                FROM `plugin`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.39%) 		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"\x13ì\x1D±\r.AU•ÑM±\x18›€\x12"
  b"“ôçÐÍyH°„\f!4ñt^Î"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.39%) 		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.14 ms
(0.37%) 		1 
SELECT path FROM category WHERE id = ?
Parameters: 
[
  b"»vß7PÏB…»èé=ÚhqW"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.37%) 		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.14 ms
(0.36%) 		1 
SELECT DISTINCT `technical_name`
    FROM `theme_runtime_config`
    WHERE `technical_name` IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.36%) 		1 
SELECT
    `theme_id`,
    `technical_name`,
    `resolved_config`,
    `view_inheritance`,
    `script_files`,
    `icon_sets`,
    `updated_at`
    FROM `theme_runtime_config`
    WHERE `technical_name` = ?
Parameters: 
[
  "TicToysTheme"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.34%) 		1 
-- app-scripts::refresh::search-ids
SELECT `app`.`id` FROM `app` WHERE (`app`.`active` = ? AND `app`.`self_managed` = ?)
Parameters: 
[
  true
  false
]
View formatted query    View runnable query    Explain query    View query backtrace
0.11 ms
(0.28%) 		1 
SELECT `shopstudio_blog_blog_post_vote`.`id` FROM `shopstudio_blog_blog_post_vote` WHERE ((`shopstudio_blog_blog_post_vote`.`shopstudio_blog_blog_post_id` = ? AND `shopstudio_blog_blog_post_vote`.`ip_hash` = ?)) LIMIT 1
Parameters: 
[
  b"FyöÇ\e„Mj©\x0Eö{/„„¥"
  "2fe0db3f9959c2c544e8bddfc24c3df0cbd25a8709bce1541563597f09b80fae"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.20%) 		1 
SELECT LOWER(HEX(`script`.`app_id`)) as `app_id`,
                   `script`.`name` AS scriptName,
                   `script`.`script` AS script,
                   `script`.`hook` AS hook,
                   `app`.`name` AS appName,
                   `app`.`version` AS appVersion,
                   LOWER(HEX(`app`.`integration_id`)) AS integrationId,
                   IFNULL(`script`.`updated_at`, `script`.`created_at`) AS lastModified,
                   IF(`script`.`active` = 1 AND (`app`.id IS NULL OR `app`.`active` = 1), 1, 0) AS active
            FROM `script`
            LEFT JOIN `app` ON `script`.`app_id` = `app`.`id`
            ORDER BY `app`.`created_at`, `app`.`id`, `script`.`name`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.19%) 		1 
SELECT `key`, `value` FROM `app_config`
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(0.19%) 		1 
SELECT configuration_key, configuration_value FROM system_config WHERE sales_channel_id IS NULL ORDER BY sales_channel_id ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.06 ms
(0.15%) 		1 
# dbal-plugin-loader
        SELECT
               `name`,
               `base_class` AS baseClass,
               IF(`active` = 1 AND `installed_at` IS NOT NULL, 1, 0) AS active,
               `path`,
               `version`,
               `autoload`,
               `managed_by_composer` AS managedByComposer,
               composer_name as composerName
        FROM `plugin`
        ORDER BY `installed_at`;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.04 ms
(0.12%) 		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

Database Connections

Name Service
0 default

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.