Error 500 Internal Server Error

GET https://floeter.mittwald2.salesmachine.biz/detail/0191a86e6f6875dc8eda2e020dd5f9eb

IP
216.73.216.182
Profiled on
Token
76dff2
Forwarded to ErrorController (7abe0e)

Exceptions

PDOException Exception InvalidFieldNameException

HTTP 500 Internal Server Error

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

Exceptions 3

Doctrine\DBAL\Exception\ InvalidFieldNameException

Show exception properties 
Doctrine\DBAL\Exception\InvalidFieldNameException {#7222
  -query: Doctrine\DBAL\Query {#7223
    -sql: """
      -- product-detail-route::read\n
      SELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`guarantee_months`, `product.parent`.`guarantee_months`) as `product.guaranteeMonths`, COALESCE(`product`.`guarantee_confirmed`, `product.parent`.`guarantee_confirmed`) as `product.guaranteeConfirmed`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.override_1.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.override_1.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.override_1.customFields`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.override_1.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.override_1.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.override_1.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.override_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.override_1.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR '||')\n
                        FROM `product_option` `product.options.mapping`\n
                        WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR '||')\n
                        FROM `product_property` `product.properties.mapping`\n
                        WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.override_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.override_1.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.override_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.override_1.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.override_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.override_1.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.override_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.override_1.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.override_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.override_1.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`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.override_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.override_1.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.override_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.override_1.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.override_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.override_1.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` 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.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` 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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation.override_1`.`name` as `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation.override_1`.`description` as `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`, `product.manufacturer.translation.override_1`.`custom_fields` as `product.manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.override_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_id` AND `product.manufacturer.translation.override_1`.`language_id` = ? AND `product.manufacturer.translation`.`product_manufacturer_version_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_version_id` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.override_1`.`alt` as `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.override_1`.`title` as `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.override_1`.`custom_fields` as `product.manufacturer.media.translation.override_1.customFields` FROM `media_translation` `product.manufacturer.media.translation` LEFT JOIN `media_translation` `product.manufacturer.media.translation.override_1` ON `product.manufacturer.media.translation`.`media_id` = `product.manufacturer.media.translation.override_1`.`media_id` AND `product.manufacturer.media.translation.override_1`.`language_id` = ? WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation.override_1`.`short_code` as `product.unit.translation.override_1.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation.override_1`.`name` as `product.unit.translation.override_1.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`, `product.unit.translation.override_1`.`custom_fields` as `product.unit.translation.override_1.customFields` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.override_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.override_1`.`unit_id` AND `product.unit.translation.override_1`.`language_id` = ? 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.override_1`.`name` as `product.deliveryTime.translation.override_1.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.override_1`.`custom_fields` as `product.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.override_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.override_1`.`delivery_time_id` AND `product.deliveryTime.translation.override_1`.`language_id` = ? 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.override_1`.`alt` as `product.cover.media.translation.override_1.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation.override_1`.`title` as `product.cover.media.translation.override_1.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`, `product.cover.media.translation.override_1`.`custom_fields` as `product.cover.media.translation.override_1.customFields` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.override_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.override_1`.`media_id` AND `product.cover.media.translation.override_1`.`language_id` = ? 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 (?))
      """
    -params: array:16 [
      0 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      1 => b"/»_ââšMpªXTÎ|ãâ\v"
      2 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      3 => b"/»_ââšMpªXTÎ|ãâ\v"
      4 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      5 => b"/»_ââšMpªXTÎ|ãâ\v"
      6 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      7 => b"/»_ââšMpªXTÎ|ãâ\v"
      8 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      9 => b"/»_ââšMpªXTÎ|ãâ\v"
      10 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      11 => b"/»_ââšMpªXTÎ|ãâ\v"
      12 => b"\x01Ž£j\x06îs.Ž^\x00§vy¼½"
      13 => b"/»_ââšMpªXTÎ|ãâ\v"
      14 => b"\x0F©\x1CãéjK¾KÙÎu,4%"
      15 => b"\x01‘¨nohuÜŽÚ.\x02\rÕùë"
    ]
    -types: array:16 [
      0 => 2
      1 => 2
      2 => 2
      3 => 2
      4 => 2
      5 => 2
      6 => 2
      7 => 2
      8 => 2
      9 => 2
      10 => 2
      11 => 2
      12 => 2
      13 => 2
      14 => 2
      15 => 16
    ]
  }
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 69)
  1. return new UniqueConstraintViolationException($exception, $query);
  3. case 1054:
  4. case 1166:
  5. case 1611:
  6. return new InvalidFieldNameException($exception, $query);
  8. case 1052:
  9. case 1060:
  10. case 1110:
  11. return new NonUniqueFieldNameException($exception, $query);
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1976)
  1. private function handleDriverException(
  2. Driver\Exception $driverException,
  3. ?Query $query
  4. ): DriverException {
  5. $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6. $exception = $this->exceptionConverter->convert($driverException, $query);
  8. if ($exception instanceof ConnectionLost) {
  9. $this->close();
  10. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1918)
  1. Driver\Exception $e,
  2. string $sql,
  3. array $params = [],
  4. array $types = []
  5. ): DriverException {
  6. return $this->handleDriverException($e, new Query($sql, $params, $types));
  7. }
  9. /** @internal */
  10. final public function convertException(Driver\Exception $e): DriverException
  11. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 1111)
  1. $result = $connection->query($sql);
  2. }
  4. return new Result($result, $this);
  5. } catch (Driver\Exception $e) {
  6. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  7. } finally {
  8. if ($logger !== null) {
  9. $logger->stopQuery();
  10. }
  11. }
in vendor/doctrine/dbal/src/Query/QueryBuilder.php -> executeQuery (line 344)
  1. *
  2. * @throws Exception
  3. */
  4. public function executeQuery(): Result
  5. {
  6. return $this->connection->executeQuery(
  7. $this->getSQL(),
  8. $this->params,
  9. $this->paramTypes,
  10. $this->resultCacheProfile,
  11. );
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> executeQuery (line 317)
  2. if ($criteria->getTitle()) {
  3. $query->setTitle($criteria->getTitle() . '::read');
  4. }
  6. return $query->executeQuery()->fetchAllAssociative();
  7. }
  9. /**
  10. * @param EntityCollection<Entity> $collection
  11. * @param array<string, mixed> $partial
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> fetch (line 133)
  2. if ($definition->isInheritanceAware() && $criteria->hasAssociation('parent')) {
  3. throw DataAbstractionLayerException::parentAssociationCannotBeFetched();
  4. }
  6. $rows = $this->fetch($criteria, $definition, $context, $fields, $partial);
  8. $collection = $this->hydrator->hydrate($collection, $definition->getEntityClass(), $definition, $rows, $definition->getEntityName(), $context, $partial);
  10. $collection = $this->fetchAssociations($criteria, $definition, $context, $collection, $fields, $partial);
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> _read (line 76)
  1. /** @var EntityCollection<Entity> $collectionClass */
  2. $collectionClass = $definition->getCollectionClass();
  4. $fields = $this->criteriaFieldsResolver->resolve($criteria, $definition);
  6. return $this->_read(
  7. $criteria,
  8. $definition,
  9. $context,
  10. new $collectionClass(),
  11. $definition->getFields()->getBasicFields(),
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 183)
  1. private function read(Criteria $criteria, SalesChannelContext $salesChannelContext): EntityCollection
  2. {
  3. $criteria = clone $criteria;
  5. /** @var TEntityCollection $entities */
  6. $entities = $this->reader->read($this->definition, $criteria, $salesChannelContext->getContext());
  8. if ($criteria->getFields() === []) {
  9. $events = $this->eventFactory->createForSalesChannel($entities->getElements(), $salesChannelContext);
  10. } else {
  11. $events = $this->eventFactory->createPartialForSalesChannel($entities->getElements(), $salesChannelContext);
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 121)
  1. return new EntitySearchResult($this->definition->getEntityName(), $ids->getTotal(), new $collection(), $aggregations, $criteria, $salesChannelContext->getContext());
  2. }
  4. $readCriteria = $criteria->cloneForRead($ids->getIds());
  6. $entities = $this->read($readCriteria, $salesChannelContext);
  8. $search = $ids->getData();
  10. foreach ($entities as $element) {
  11. if (!\array_key_exists($element->getUniqueIdentifier(), $search)) {
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> _search (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\System\SalesChannel\Entity\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php :: trace (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php -> search (line 105)
  1. $this->addFilters($context, $criteria);
  3. $criteria->setIds([$productId]);
  4. $criteria->setTitle('product-detail-route');
  6. $product = $this->productRepository->search($criteria, $context)->getEntities()->first();
  7. if (!$product instanceof SalesChannelProductEntity) {
  8. throw ProductException::notFound($productId);
  9. }
  11. $parent = $product->getParentId() ?? $product->getId();
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php :: trace (line 88)
  1. ],
  2. methods: [Request::METHOD_POST]
  3. )]
  4. public function load(string $productId, Request $request, SalesChannelContext $context, Criteria $criteria): ProductDetailRouteResponse
  5. {
  6. return Profiler::trace('product-detail-route', function () use ($productId, $request, $context, $criteria) {
  7. $mainVariantId = $this->checkVariantListingConfig($productId, $context);
  9. $resolveVariantIdEvent = new ResolveVariantIdEvent(
  10. $productId,
  11. $mainVariantId,
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> load (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 451)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Translation/Translator.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 101)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php -> Shopware\Storefront\Framework\Cache\{closure} (line 97)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> trace (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 64)
  1. }
  2. }
  4. if ($recompute) {
  5. $save = true;
  6. $item->set($callback($item, $save));
  7. if ($save) {
  8. $pool->save($item);
  9. }
  10. }
in vendor/symfony/cache-contracts/CacheTrait.php -> doGet (line 30)
  1. */
  2. trait CacheTrait
  3. {
  4. public function get(string $key, callable $callback, ?float $beta = null, ?array &$metadata = null): mixed
  5. {
  6. return $this->doGet($this, $key, $callback, $beta, $metadata);
  7. }
  9. public function delete(string $key): bool
  10. {
  11. return $this->deleteItem($key);
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> get (line 64)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($productId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  7. $name = self::buildName($productId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
in vendor/shopware/storefront/Page/Product/ProductPageLoader.php -> load (line 71)
  1. new FieldSorting('position')
  2. );
  4. $this->eventDispatcher->dispatch(new ProductPageCriteriaEvent($productId, $criteria, $context));
  6. $result = $this->productDetailRoute->load($productId, $request, $context, $criteria);
  7. $product = $result->getProduct();
  9. if ($product->getMedia() && $product->getCover()) {
  10. $product->setMedia(new ProductMediaCollection(array_merge(
  11. [$product->getCover()->getId() => $product->getCover()],
in vendor/shopware/storefront/Controller/ProductController.php -> load (line 63)
  1. }
  3. #[Route(path: '/detail/{productId}', name: 'frontend.detail.page', defaults: ['_httpCache' => true], methods: ['GET'])]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->productPageLoader->load($request, $context);
  8. $this->hook(new ProductPageLoadedHook($page, $context));
  10. return $this->renderStorefront('@Storefront/storefront/page/content/product-detail.html.twig', ['page' => $page]);
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php -> handle (line 72)
  1. $this->dispatcher->dispatch($event);
  3. return $event->getResponse();
  4. }
  6. return parent::handle($request, $type, $catch);
  7. }
  8. }
in vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php -> handle (line 86)
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  5. try {
  6. return $kernel->handle($request, $type, $catch);
  7. } finally {
  8. // restore global state
  9. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  10. }
  11. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php :: handle (line 476)
  1. protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2. {
  3. $this->surrogate?->addSurrogateCapability($request);
  5. // always a "master" request (as the real master request can be in cache)
  6. $response = SubRequestHandler::handle($this->kernel, $request, HttpKernelInterface::MAIN_REQUEST, $catch);
  7. $this->forwardedRequest = $request;
  9. // These headers drive how the body is restored before sending the response.
  10. // Only the store and the surrogate may set them, never the backend.
  11. $response->headers->remove('X-Body-File');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> forward (line 453)
  2. // avoid that the backend sends no content
  3. $subRequest->headers->remove('If-Modified-Since');
  4. $subRequest->headers->remove('If-None-Match');
  6. $response = $this->forward($subRequest, $catch);
  8. if ($response->isCacheable()) {
  9. $this->store($request, $response);
  10. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> fetch (line 351)
  1. }
  3. if (null === $entry) {
  4. $this->record($request, 'miss');
  6. return $this->fetch($request, $catch);
  7. }
  9. if (!$this->isFreshEnough($request, $entry)) {
  10. $this->record($request, 'stale');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> lookup (line 220)
  1. $response = $this->fetch($request, $catch);
  2. } else {
  3. $response = null;
  4. do {
  5. try {
  6. $response = $this->lookup($request, $catch);
  7. } catch (CacheWasLockedException) {
  8. }
  9. } while (null === $response);
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php -> handle (line 65)
  2. // only handle main request inside http cache, because ESI tags are also interpreted as main request.
  3. // sub requests are requests, which are forwarded to the kernel inside the php stack
  4. // https://github.com/symfony/symfony/issues/51648#issuecomment-1717846894
  5. if ($type === HttpKernelInterface::MAIN_REQUEST) {
  6. $response = parent::handle($request, $type, $catch);
  7. } elseif ($request->attributes->has('_sw_esi')) {
  8. $response = parent::handle($request, $type, $catch);
  9. } else {
  10. $response = $this->getKernel()->handle($request, $type, $catch);
  11. }
in vendor/shopware/core/Kernel.php -> handle (line 153)
  2. public function handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response
  3. {
  4. $this->boot();
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. }
  9. public function boot(): void
  10. {
  11. if (!$this->booted) {
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 34)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. $response->send(false);
  10. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  11. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/html/shopware/vendor/autoload_runtime.php') in public/index.php (line 10)
  1. use Shopware\Core\Installer\InstallerKernel;
  2. use Shopware\Core\Framework\Adapter\Kernel\KernelFactory;
  4. $_SERVER['SCRIPT_FILENAME'] = __FILE__;
  6. require_once __DIR__ . '/../vendor/autoload_runtime.php';
  8. if (!file_exists(__DIR__ . '/../.env') && !file_exists(__DIR__ . '/../.env.dist') && !file_exists(__DIR__ . '/../.env.local.php')) {
  9. $_SERVER['APP_RUNTIME_OPTIONS']['disable_dotenv'] = true;
  10. }

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  6. return new self($exception->getMessage(), $sqlState, $code, $exception);
  7. }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php :: new (line 132)
  1. }
  3. try {
  4. $this->stmt->execute($params);
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  9. return new Result($this->stmt);
  10. }
  11. }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php -> execute (line 70)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute($params);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1104)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/dbal/src/Query/QueryBuilder.php -> executeQuery (line 344)
  1. *
  2. * @throws Exception
  3. */
  4. public function executeQuery(): Result
  5. {
  6. return $this->connection->executeQuery(
  7. $this->getSQL(),
  8. $this->params,
  9. $this->paramTypes,
  10. $this->resultCacheProfile,
  11. );
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> executeQuery (line 317)
  2. if ($criteria->getTitle()) {
  3. $query->setTitle($criteria->getTitle() . '::read');
  4. }
  6. return $query->executeQuery()->fetchAllAssociative();
  7. }
  9. /**
  10. * @param EntityCollection<Entity> $collection
  11. * @param array<string, mixed> $partial
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> fetch (line 133)
  2. if ($definition->isInheritanceAware() && $criteria->hasAssociation('parent')) {
  3. throw DataAbstractionLayerException::parentAssociationCannotBeFetched();
  4. }
  6. $rows = $this->fetch($criteria, $definition, $context, $fields, $partial);
  8. $collection = $this->hydrator->hydrate($collection, $definition->getEntityClass(), $definition, $rows, $definition->getEntityName(), $context, $partial);
  10. $collection = $this->fetchAssociations($criteria, $definition, $context, $collection, $fields, $partial);
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> _read (line 76)
  1. /** @var EntityCollection<Entity> $collectionClass */
  2. $collectionClass = $definition->getCollectionClass();
  4. $fields = $this->criteriaFieldsResolver->resolve($criteria, $definition);
  6. return $this->_read(
  7. $criteria,
  8. $definition,
  9. $context,
  10. new $collectionClass(),
  11. $definition->getFields()->getBasicFields(),
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 183)
  1. private function read(Criteria $criteria, SalesChannelContext $salesChannelContext): EntityCollection
  2. {
  3. $criteria = clone $criteria;
  5. /** @var TEntityCollection $entities */
  6. $entities = $this->reader->read($this->definition, $criteria, $salesChannelContext->getContext());
  8. if ($criteria->getFields() === []) {
  9. $events = $this->eventFactory->createForSalesChannel($entities->getElements(), $salesChannelContext);
  10. } else {
  11. $events = $this->eventFactory->createPartialForSalesChannel($entities->getElements(), $salesChannelContext);
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 121)
  1. return new EntitySearchResult($this->definition->getEntityName(), $ids->getTotal(), new $collection(), $aggregations, $criteria, $salesChannelContext->getContext());
  2. }
  4. $readCriteria = $criteria->cloneForRead($ids->getIds());
  6. $entities = $this->read($readCriteria, $salesChannelContext);
  8. $search = $ids->getData();
  10. foreach ($entities as $element) {
  11. if (!\array_key_exists($element->getUniqueIdentifier(), $search)) {
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> _search (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\System\SalesChannel\Entity\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php :: trace (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php -> search (line 105)
  1. $this->addFilters($context, $criteria);
  3. $criteria->setIds([$productId]);
  4. $criteria->setTitle('product-detail-route');
  6. $product = $this->productRepository->search($criteria, $context)->getEntities()->first();
  7. if (!$product instanceof SalesChannelProductEntity) {
  8. throw ProductException::notFound($productId);
  9. }
  11. $parent = $product->getParentId() ?? $product->getId();
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php :: trace (line 88)
  1. ],
  2. methods: [Request::METHOD_POST]
  3. )]
  4. public function load(string $productId, Request $request, SalesChannelContext $context, Criteria $criteria): ProductDetailRouteResponse
  5. {
  6. return Profiler::trace('product-detail-route', function () use ($productId, $request, $context, $criteria) {
  7. $mainVariantId = $this->checkVariantListingConfig($productId, $context);
  9. $resolveVariantIdEvent = new ResolveVariantIdEvent(
  10. $productId,
  11. $mainVariantId,
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> load (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 451)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Translation/Translator.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 101)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php -> Shopware\Storefront\Framework\Cache\{closure} (line 97)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> trace (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 64)
  1. }
  2. }
  4. if ($recompute) {
  5. $save = true;
  6. $item->set($callback($item, $save));
  7. if ($save) {
  8. $pool->save($item);
  9. }
  10. }
in vendor/symfony/cache-contracts/CacheTrait.php -> doGet (line 30)
  1. */
  2. trait CacheTrait
  3. {
  4. public function get(string $key, callable $callback, ?float $beta = null, ?array &$metadata = null): mixed
  5. {
  6. return $this->doGet($this, $key, $callback, $beta, $metadata);
  7. }
  9. public function delete(string $key): bool
  10. {
  11. return $this->deleteItem($key);
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> get (line 64)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($productId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  7. $name = self::buildName($productId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
in vendor/shopware/storefront/Page/Product/ProductPageLoader.php -> load (line 71)
  1. new FieldSorting('position')
  2. );
  4. $this->eventDispatcher->dispatch(new ProductPageCriteriaEvent($productId, $criteria, $context));
  6. $result = $this->productDetailRoute->load($productId, $request, $context, $criteria);
  7. $product = $result->getProduct();
  9. if ($product->getMedia() && $product->getCover()) {
  10. $product->setMedia(new ProductMediaCollection(array_merge(
  11. [$product->getCover()->getId() => $product->getCover()],
in vendor/shopware/storefront/Controller/ProductController.php -> load (line 63)
  1. }
  3. #[Route(path: '/detail/{productId}', name: 'frontend.detail.page', defaults: ['_httpCache' => true], methods: ['GET'])]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->productPageLoader->load($request, $context);
  8. $this->hook(new ProductPageLoadedHook($page, $context));
  10. return $this->renderStorefront('@Storefront/storefront/page/content/product-detail.html.twig', ['page' => $page]);
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php -> handle (line 72)
  1. $this->dispatcher->dispatch($event);
  3. return $event->getResponse();
  4. }
  6. return parent::handle($request, $type, $catch);
  7. }
  8. }
in vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php -> handle (line 86)
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  5. try {
  6. return $kernel->handle($request, $type, $catch);
  7. } finally {
  8. // restore global state
  9. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  10. }
  11. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php :: handle (line 476)
  1. protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2. {
  3. $this->surrogate?->addSurrogateCapability($request);
  5. // always a "master" request (as the real master request can be in cache)
  6. $response = SubRequestHandler::handle($this->kernel, $request, HttpKernelInterface::MAIN_REQUEST, $catch);
  7. $this->forwardedRequest = $request;
  9. // These headers drive how the body is restored before sending the response.
  10. // Only the store and the surrogate may set them, never the backend.
  11. $response->headers->remove('X-Body-File');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> forward (line 453)
  2. // avoid that the backend sends no content
  3. $subRequest->headers->remove('If-Modified-Since');
  4. $subRequest->headers->remove('If-None-Match');
  6. $response = $this->forward($subRequest, $catch);
  8. if ($response->isCacheable()) {
  9. $this->store($request, $response);
  10. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> fetch (line 351)
  1. }
  3. if (null === $entry) {
  4. $this->record($request, 'miss');
  6. return $this->fetch($request, $catch);
  7. }
  9. if (!$this->isFreshEnough($request, $entry)) {
  10. $this->record($request, 'stale');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> lookup (line 220)
  1. $response = $this->fetch($request, $catch);
  2. } else {
  3. $response = null;
  4. do {
  5. try {
  6. $response = $this->lookup($request, $catch);
  7. } catch (CacheWasLockedException) {
  8. }
  9. } while (null === $response);
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php -> handle (line 65)
  2. // only handle main request inside http cache, because ESI tags are also interpreted as main request.
  3. // sub requests are requests, which are forwarded to the kernel inside the php stack
  4. // https://github.com/symfony/symfony/issues/51648#issuecomment-1717846894
  5. if ($type === HttpKernelInterface::MAIN_REQUEST) {
  6. $response = parent::handle($request, $type, $catch);
  7. } elseif ($request->attributes->has('_sw_esi')) {
  8. $response = parent::handle($request, $type, $catch);
  9. } else {
  10. $response = $this->getKernel()->handle($request, $type, $catch);
  11. }
in vendor/shopware/core/Kernel.php -> handle (line 153)
  2. public function handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response
  3. {
  4. $this->boot();
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. }
  9. public function boot(): void
  10. {
  11. if (!$this->booted) {
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 34)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. $response->send(false);
  10. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  11. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/html/shopware/vendor/autoload_runtime.php') in public/index.php (line 10)
  1. use Shopware\Core\Installer\InstallerKernel;
  2. use Shopware\Core\Framework\Adapter\Kernel\KernelFactory;
  4. $_SERVER['SCRIPT_FILENAME'] = __FILE__;
  6. require_once __DIR__ . '/../vendor/autoload_runtime.php';
  8. if (!file_exists(__DIR__ . '/../.env') && !file_exists(__DIR__ . '/../.env.dist') && !file_exists(__DIR__ . '/../.env.local.php')) {
  9. $_SERVER['APP_RUNTIME_OPTIONS']['disable_dotenv'] = true;
  10. }

PDOException

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

in vendor/doctrine/dbal/src/Driver/PDO/Statement.php (line 130)
  1. . ' Statement::bindParam() or Statement::bindValue() instead.',
  2. );
  3. }
  5. try {
  6. $this->stmt->execute($params);
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/PDO/Statement.php -> execute (line 130)
  1. . ' Statement::bindParam() or Statement::bindValue() instead.',
  2. );
  3. }
  5. try {
  6. $this->stmt->execute($params);
  7. } catch (PDOException $exception) {
  8. throw Exception::new($exception);
  9. }
  11. return new Result($this->stmt);
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php -> execute (line 69)
  1. /**
  2. * {@inheritDoc}
  3. */
  4. public function execute($params = null): Result
  5. {
  6. return $this->wrappedStatement->execute($params);
  7. }
  8. }
in vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php -> execute (line 70)
  2. $this->stopwatch?->start('doctrine', 'doctrine');
  3. $query->start();
  5. try {
  6. return parent::execute($params);
  7. } finally {
  8. $query->stop();
  9. $this->stopwatch?->stop('doctrine');
  10. }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> execute (line 1104)
  2. $stmt = $connection->prepare($sql);
  4. $this->bindParameters($stmt, $params, $types);
  6. $result = $stmt->execute();
  7. } else {
  8. $result = $connection->query($sql);
  9. }
  11. return new Result($result, $this);
in vendor/doctrine/dbal/src/Query/QueryBuilder.php -> executeQuery (line 344)
  1. *
  2. * @throws Exception
  3. */
  4. public function executeQuery(): Result
  5. {
  6. return $this->connection->executeQuery(
  7. $this->getSQL(),
  8. $this->params,
  9. $this->paramTypes,
  10. $this->resultCacheProfile,
  11. );
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> executeQuery (line 317)
  2. if ($criteria->getTitle()) {
  3. $query->setTitle($criteria->getTitle() . '::read');
  4. }
  6. return $query->executeQuery()->fetchAllAssociative();
  7. }
  9. /**
  10. * @param EntityCollection<Entity> $collection
  11. * @param array<string, mixed> $partial
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> fetch (line 133)
  2. if ($definition->isInheritanceAware() && $criteria->hasAssociation('parent')) {
  3. throw DataAbstractionLayerException::parentAssociationCannotBeFetched();
  4. }
  6. $rows = $this->fetch($criteria, $definition, $context, $fields, $partial);
  8. $collection = $this->hydrator->hydrate($collection, $definition->getEntityClass(), $definition, $rows, $definition->getEntityName(), $context, $partial);
  10. $collection = $this->fetchAssociations($criteria, $definition, $context, $collection, $fields, $partial);
in vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php -> _read (line 76)
  1. /** @var EntityCollection<Entity> $collectionClass */
  2. $collectionClass = $definition->getCollectionClass();
  4. $fields = $this->criteriaFieldsResolver->resolve($criteria, $definition);
  6. return $this->_read(
  7. $criteria,
  8. $definition,
  9. $context,
  10. new $collectionClass(),
  11. $definition->getFields()->getBasicFields(),
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 183)
  1. private function read(Criteria $criteria, SalesChannelContext $salesChannelContext): EntityCollection
  2. {
  3. $criteria = clone $criteria;
  5. /** @var TEntityCollection $entities */
  6. $entities = $this->reader->read($this->definition, $criteria, $salesChannelContext->getContext());
  8. if ($criteria->getFields() === []) {
  9. $events = $this->eventFactory->createForSalesChannel($entities->getElements(), $salesChannelContext);
  10. } else {
  11. $events = $this->eventFactory->createPartialForSalesChannel($entities->getElements(), $salesChannelContext);
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> read (line 121)
  1. return new EntitySearchResult($this->definition->getEntityName(), $ids->getTotal(), new $collection(), $aggregations, $criteria, $salesChannelContext->getContext());
  2. }
  4. $readCriteria = $criteria->cloneForRead($ids->getIds());
  6. $entities = $this->read($readCriteria, $salesChannelContext);
  8. $search = $ids->getData();
  10. foreach ($entities as $element) {
  11. if (!\array_key_exists($element->getUniqueIdentifier(), $search)) {
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php -> _search (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\System\SalesChannel\Entity\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php :: trace (line 68)
  1. {
  2. if (!$criteria->getTitle()) {
  3. return $this->_search($criteria, $salesChannelContext);
  4. }
  6. return Profiler::trace($criteria->getTitle(), fn () => $this->_search($criteria, $salesChannelContext), 'saleschannel-repository');
  7. }
  9. public function aggregate(Criteria $criteria, SalesChannelContext $salesChannelContext): AggregationResultCollection
  10. {
  11. if (!$criteria->getTitle()) {
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php -> search (line 105)
  1. $this->addFilters($context, $criteria);
  3. $criteria->setIds([$productId]);
  4. $criteria->setTitle('product-detail-route');
  6. $product = $this->productRepository->search($criteria, $context)->getEntities()->first();
  7. if (!$product instanceof SalesChannelProductEntity) {
  8. throw ProductException::notFound($productId);
  9. }
  11. $parent = $product->getParentId() ?? $product->getId();
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 67)
  1. try {
  2. foreach (self::$profilers as $profiler) {
  3. $profiler->start($name, $category, $tags);
  4. }
  6. $result = $closure();
  7. } finally {
  8. foreach (self::$profilers as $profiler) {
  9. $profiler->stop($name);
  10. }
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php :: trace (line 88)
  1. ],
  2. methods: [Request::METHOD_POST]
  3. )]
  4. public function load(string $productId, Request $request, SalesChannelContext $context, Criteria $criteria): ProductDetailRouteResponse
  5. {
  6. return Profiler::trace('product-detail-route', function () use ($productId, $request, $context, $criteria) {
  7. $mainVariantId = $this->checkVariantListingConfig($productId, $context);
  9. $resolveVariantIdEvent = new ResolveVariantIdEvent(
  10. $productId,
  11. $mainVariantId,
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> load (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 451)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Translation/Translator.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 101)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php -> Shopware\Core\Framework\Adapter\Cache\{closure} (line 56)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php -> trace (line 35)
  1. throw new DecorationPatternException(self::class);
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->collection->trace($key, fn () => $this->translator->trace($key, fn () => $this->config->trace($key, $param)));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_merge(
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php -> Shopware\Storefront\Framework\Cache\{closure} (line 97)
  1. public function trace(string $key, \Closure $param)
  2. {
  3. $this->traces[$key] = [];
  4. $this->keys[$key] = true;
  6. $result = $param();
  8. unset($this->keys[$key]);
  10. return $result;
  11. }
in vendor/shopware/storefront/Framework/Cache/CacheTracer.php -> trace (line 35)
  1. return $this->decorated;
  2. }
  4. public function trace(string $key, \Closure $param)
  5. {
  6. return $this->themeConfigAccessor->trace($key, fn () => $this->getDecorated()->trace($key, $param));
  7. }
  9. public function get(string $key): array
  10. {
  11. return array_unique(array_merge(
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> trace (line 67)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  4. $name = self::buildName($productId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Detail\{closure} (line 64)
  1. }
  2. }
  4. if ($recompute) {
  5. $save = true;
  6. $item->set($callback($item, $save));
  7. if ($save) {
  8. $pool->save($item);
  9. }
  10. }
in vendor/symfony/cache-contracts/CacheTrait.php -> doGet (line 30)
  1. */
  2. trait CacheTrait
  3. {
  4. public function get(string $key, callable $callback, ?float $beta = null, ?array &$metadata = null): mixed
  5. {
  6. return $this->doGet($this, $key, $callback, $beta, $metadata);
  7. }
  9. public function delete(string $key): bool
  10. {
  11. return $this->deleteItem($key);
in vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php -> get (line 64)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($productId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($productId, $request, $context, $criteria) {
  7. $name = self::buildName($productId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($productId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($productId, $request, $response, $context, $criteria));
in vendor/shopware/storefront/Page/Product/ProductPageLoader.php -> load (line 71)
  1. new FieldSorting('position')
  2. );
  4. $this->eventDispatcher->dispatch(new ProductPageCriteriaEvent($productId, $criteria, $context));
  6. $result = $this->productDetailRoute->load($productId, $request, $context, $criteria);
  7. $product = $result->getProduct();
  9. if ($product->getMedia() && $product->getCover()) {
  10. $product->setMedia(new ProductMediaCollection(array_merge(
  11. [$product->getCover()->getId() => $product->getCover()],
in vendor/shopware/storefront/Controller/ProductController.php -> load (line 63)
  1. }
  3. #[Route(path: '/detail/{productId}', name: 'frontend.detail.page', defaults: ['_httpCache' => true], methods: ['GET'])]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->productPageLoader->load($request, $context);
  8. $this->hook(new ProductPageLoadedHook($page, $context));
  10. return $this->renderStorefront('@Storefront/storefront/page/content/product-detail.html.twig', ['page' => $page]);
  11. }
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1. $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2. $controller = $event->getController();
  3. $arguments = $event->getArguments();
  5. // call controller
  6. $response = $controller(...$arguments);
  8. // view
  9. if (!$response instanceof Response) {
  10. $event = new ViewEvent($this, $request, $type, $response, $event);
  11. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3. $this->requestStack->push($request);
  4. $response = null;
  5. try {
  6. return $response = $this->handleRaw($request, $type);
  7. } catch (\Throwable $e) {
  8. if ($e instanceof \Error && !$this->handleAllThrowables) {
  9. throw $e;
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php -> handle (line 72)
  1. $this->dispatcher->dispatch($event);
  3. return $event->getResponse();
  4. }
  6. return parent::handle($request, $type, $catch);
  7. }
  8. }
in vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php -> handle (line 86)
  1. if (!IpUtils::checkIp('127.0.0.1', $trustedProxies)) {
  2. Request::setTrustedProxies(array_merge($trustedProxies, ['127.0.0.1']), Request::getTrustedHeaderSet());
  3. }
  5. try {
  6. return $kernel->handle($request, $type, $catch);
  7. } finally {
  8. // restore global state
  9. Request::setTrustedProxies($trustedProxies, $trustedHeaderSet);
  10. }
  11. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php :: handle (line 476)
  1. protected function forward(Request $request, bool $catch = false, ?Response $entry = null): Response
  2. {
  3. $this->surrogate?->addSurrogateCapability($request);
  5. // always a "master" request (as the real master request can be in cache)
  6. $response = SubRequestHandler::handle($this->kernel, $request, HttpKernelInterface::MAIN_REQUEST, $catch);
  7. $this->forwardedRequest = $request;
  9. // These headers drive how the body is restored before sending the response.
  10. // Only the store and the surrogate may set them, never the backend.
  11. $response->headers->remove('X-Body-File');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> forward (line 453)
  2. // avoid that the backend sends no content
  3. $subRequest->headers->remove('If-Modified-Since');
  4. $subRequest->headers->remove('If-None-Match');
  6. $response = $this->forward($subRequest, $catch);
  8. if ($response->isCacheable()) {
  9. $this->store($request, $response);
  10. }
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> fetch (line 351)
  1. }
  3. if (null === $entry) {
  4. $this->record($request, 'miss');
  6. return $this->fetch($request, $catch);
  7. }
  9. if (!$this->isFreshEnough($request, $entry)) {
  10. $this->record($request, 'stale');
in vendor/symfony/http-kernel/HttpCache/HttpCache.php -> lookup (line 220)
  1. $response = $this->fetch($request, $catch);
  2. } else {
  3. $response = null;
  4. do {
  5. try {
  6. $response = $this->lookup($request, $catch);
  7. } catch (CacheWasLockedException) {
  8. }
  9. } while (null === $response);
  10. }
in vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php -> handle (line 65)
  2. // only handle main request inside http cache, because ESI tags are also interpreted as main request.
  3. // sub requests are requests, which are forwarded to the kernel inside the php stack
  4. // https://github.com/symfony/symfony/issues/51648#issuecomment-1717846894
  5. if ($type === HttpKernelInterface::MAIN_REQUEST) {
  6. $response = parent::handle($request, $type, $catch);
  7. } elseif ($request->attributes->has('_sw_esi')) {
  8. $response = parent::handle($request, $type, $catch);
  9. } else {
  10. $response = $this->getKernel()->handle($request, $type, $catch);
  11. }
in vendor/shopware/core/Kernel.php -> handle (line 153)
  2. public function handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response
  3. {
  4. $this->boot();
  6. return $this->getHttpKernel()->handle($request, $type, $catch);
  7. }
  9. public function boot(): void
  10. {
  11. if (!$this->booted) {
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 34)
  1. ) {
  2. }
  4. public function run(): int
  5. {
  6. $response = $this->kernel->handle($this->request);
  8. $response->send(false);
  10. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  11. fastcgi_finish_request();
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4. $runtime
  5. ->getRunner($app)
  6. ->run()
  7. );
require_once('/html/shopware/vendor/autoload_runtime.php') in public/index.php (line 10)
  1. use Shopware\Core\Installer\InstallerKernel;
  2. use Shopware\Core\Framework\Adapter\Kernel\KernelFactory;
  4. $_SERVER['SCRIPT_FILENAME'] = __FILE__;
  6. require_once __DIR__ . '/../vendor/autoload_runtime.php';
  8. if (!file_exists(__DIR__ . '/../.env') && !file_exists(__DIR__ . '/../.env.dist') && !file_exists(__DIR__ . '/../.env.local.php')) {
  9. $_SERVER['APP_RUNTIME_OPTIONS']['disable_dotenv'] = true;
  10. }

Logs

Level Channel Message
INFO 17:48:01 php User Deprecated: The Shopware\Core\Service\Service bundle should be added to config/bundles.php 
{
    "exception": {}
}
INFO 17:48:01 php User Deprecated: Method "Shopware\Core\Framework\DataAbstractionLayer\EntityExtension::getEntityName()" is deprecated and will be removed in v6.7.0.0. Use "Method will be abstract" instead. 
{
    "exception": {}
}
INFO 17:48:01 php User Deprecated: Method "Shopware\Core\Framework\DataAbstractionLayer\EntityExtension::getEntityName()" is deprecated and will be removed in v6.7.0.0. Use "Method will be abstract" instead. 
{
    "exception": {}
}
INFO 17:48:01 php User Deprecated: The "Shopware\Core\Framework\DataAbstractionLayer\Search\EntityAggregatorInterface" interface is considered internal. It may change without further notice. You should not use it from "Swag\Security\Fixes\GHSAm8952hj38cg9\EntityAggregatorDecorator". 
{
    "exception": {}
}
INFO 17:48:01 php User Deprecated: The "Shopware\Core\Framework\DataAbstractionLayer\EntityRepository" class uses "Symfony\Component\VarExporter\LazyGhostTrait" that is deprecated since Symfony 7.3, use native lazy objects instead. 
{
    "exception": {}
}
INFO 17:48:01 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "76dff2"
    },
    "request_uri": "https://floeter.mittwald2.salesmachine.biz/_profiler/76dff2?panel=exception&type=request",
    "method": "GET"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Api\EventListener\CorsListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Api\EventListener\JsonRequestTransformerListener::onRequest". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\JsonRequestTransformerListener::onRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Api\EventListener\Authentication\ApiAuthenticationListener::setupOAuth". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\Authentication\\ApiAuthenticationListener::setupOAuth"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\FragmentListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::startSession". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::startSession"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\RouteParamsCleanupListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteParamsCleanupListener::__invoke"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Twig\TwigDateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Twig\\TwigDateRequestListener::onKernelRequest"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\CoreSubscriber::initializeCspNonce". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\CoreSubscriber::initializeCspNonce"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::maintenanceResolver". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::maintenanceResolver"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder::requestEvent". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Theme\\Twig\\ThemeNamespaceHierarchyBuilder::requestEvent"
}
DEBUG 17:48:01 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\RouteEventSubscriber::request". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteEventSubscriber::request"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Api\EventListener\Authentication\SalesChannelAuthenticationListener::validateRequest". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\Authentication\\SalesChannelAuthenticationListener::validateRequest"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Api\EventListener\Authentication\ApiAuthenticationListener::validateRequest". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\Authentication\\ApiAuthenticationListener::validateRequest"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Swag\PayPal\Checkout\ExpressCheckout\ExpressCheckoutSubscriber::mapShippingCallbackContextToken". 
{
    "event": "kernel.controller",
    "listener": "Swag\\PayPal\\Checkout\\ExpressCheckout\\ExpressCheckoutSubscriber::mapShippingCallbackContextToken"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\ContextResolverListener::resolveContext"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\RouteEventSubscriber::controller". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteEventSubscriber::controller"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Swag\PayPal\AgenticCommerce\Routing\AgentContextResolverListener::resolveContext". 
{
    "event": "kernel.controller",
    "listener": "Swag\\PayPal\\AgenticCommerce\\Routing\\AgentContextResolverListener::resolveContext"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\RouteScopeListener::checkScope". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteScopeListener::checkScope"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Api\Acl\AclAnnotationValidator::validate". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Api\\Acl\\AclAnnotationValidator::validate"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::preventPageLoadingFromXmlHttpRequest". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::preventPageLoadingFromXmlHttpRequest"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\Captcha\CaptchaRouteListener::validateCaptcha". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\Captcha\\CaptchaRouteListener::validateCaptcha"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Adapter\Cache\CacheStateSubscriber::setStates". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Adapter\\Cache\\CacheStateSubscriber::setStates"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Api\EventListener\ExpectationSubscriber::checkExpectations". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Api\\EventListener\\ExpectationSubscriber::checkExpectations"
}
DEBUG 17:48:01 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\AffiliateTracking\AffiliateTrackingListener::checkAffiliateTracking". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\AffiliateTracking\\AffiliateTrackingListener::checkAffiliateTracking"
}
DEBUG 17:48:01 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\IsSignatureValidAttributeListener::onKernelControllerArguments"
}
DEBUG 17:48:01 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 17:48:01 event Notified event "kernel.controller_arguments" to listener "Swag\AmazonPay\Framework\EventListeners\AmazonPayAddressValidationListener::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Swag\\AmazonPay\\Framework\\EventListeners\\AmazonPayAddressValidationListener::onKernelControllerArguments"
}
DEBUG 17:48:01 event Notified event "kernel.controller_arguments" to listener "ContainerIjl1rYI\RequestPayloadValueResolverGhost8c80924::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerIjl1rYI\\RequestPayloadValueResolverGhost8c80924::onKernelControllerArguments"
}
DEBUG 17:48:01 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 3

[3/3] InvalidFieldNameException 
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1976)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1918)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), '-- product-detail-route::readSELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`guarantee_months`, `product.parent`.`guarantee_months`) as `product.guaranteeMonths`, COALESCE(`product`.`guarantee_confirmed`, `product.parent`.`guarantee_confirmed`) as `product.guaranteeConfirmed`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.override_1.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.override_1.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.override_1.customFields`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.override_1.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.override_1.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.override_1.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.override_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.override_1.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_option` `product.options.mapping`                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_property` `product.properties.mapping`                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.override_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.override_1.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.override_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.override_1.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.override_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.override_1.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.override_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.override_1.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.override_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.override_1.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`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.override_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.override_1.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.override_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.override_1.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.override_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.override_1.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` 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.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` 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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation.override_1`.`name` as `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation.override_1`.`description` as `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`, `product.manufacturer.translation.override_1`.`custom_fields` as `product.manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.override_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_id` AND `product.manufacturer.translation.override_1`.`language_id` = ? AND `product.manufacturer.translation`.`product_manufacturer_version_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_version_id` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.override_1`.`alt` as `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.override_1`.`title` as `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.override_1`.`custom_fields` as `product.manufacturer.media.translation.override_1.customFields` FROM `media_translation` `product.manufacturer.media.translation` LEFT JOIN `media_translation` `product.manufacturer.media.translation.override_1` ON `product.manufacturer.media.translation`.`media_id` = `product.manufacturer.media.translation.override_1`.`media_id` AND `product.manufacturer.media.translation.override_1`.`language_id` = ? WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation.override_1`.`short_code` as `product.unit.translation.override_1.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation.override_1`.`name` as `product.unit.translation.override_1.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`, `product.unit.translation.override_1`.`custom_fields` as `product.unit.translation.override_1.customFields` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.override_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.override_1`.`unit_id` AND `product.unit.translation.override_1`.`language_id` = ? 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.override_1`.`name` as `product.deliveryTime.translation.override_1.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.override_1`.`custom_fields` as `product.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.override_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.override_1`.`delivery_time_id` AND `product.deliveryTime.translation.override_1`.`language_id` = ? 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.override_1`.`alt` as `product.cover.media.translation.override_1.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation.override_1`.`title` as `product.cover.media.translation.override_1.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`, `product.cover.media.translation.override_1`.`custom_fields` as `product.cover.media.translation.override_1.customFields` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.override_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.override_1`.`media_id` AND `product.cover.media.translation.override_1`.`language_id` = ? 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 (?))', array(binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16))
     (vendor/doctrine/dbal/src/Connection.php:1111)
  at Doctrine\DBAL\Connection->executeQuery('-- product-detail-route::readSELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`guarantee_months`, `product.parent`.`guarantee_months`) as `product.guaranteeMonths`, COALESCE(`product`.`guarantee_confirmed`, `product.parent`.`guarantee_confirmed`) as `product.guaranteeConfirmed`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.override_1.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.override_1.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.override_1.customFields`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.override_1.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.override_1.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.override_1.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.override_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.override_1.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_option` `product.options.mapping`                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_property` `product.properties.mapping`                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.override_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.override_1.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.override_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.override_1.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.override_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.override_1.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.override_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.override_1.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.override_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.override_1.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`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.override_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.override_1.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.override_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.override_1.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.override_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.override_1.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` 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.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` 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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation.override_1`.`name` as `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation.override_1`.`description` as `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`, `product.manufacturer.translation.override_1`.`custom_fields` as `product.manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.override_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_id` AND `product.manufacturer.translation.override_1`.`language_id` = ? AND `product.manufacturer.translation`.`product_manufacturer_version_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_version_id` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.override_1`.`alt` as `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.override_1`.`title` as `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.override_1`.`custom_fields` as `product.manufacturer.media.translation.override_1.customFields` FROM `media_translation` `product.manufacturer.media.translation` LEFT JOIN `media_translation` `product.manufacturer.media.translation.override_1` ON `product.manufacturer.media.translation`.`media_id` = `product.manufacturer.media.translation.override_1`.`media_id` AND `product.manufacturer.media.translation.override_1`.`language_id` = ? WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation.override_1`.`short_code` as `product.unit.translation.override_1.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation.override_1`.`name` as `product.unit.translation.override_1.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`, `product.unit.translation.override_1`.`custom_fields` as `product.unit.translation.override_1.customFields` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.override_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.override_1`.`unit_id` AND `product.unit.translation.override_1`.`language_id` = ? 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.override_1`.`name` as `product.deliveryTime.translation.override_1.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.override_1`.`custom_fields` as `product.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.override_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.override_1`.`delivery_time_id` AND `product.deliveryTime.translation.override_1`.`language_id` = ? 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.override_1`.`alt` as `product.cover.media.translation.override_1.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation.override_1`.`title` as `product.cover.media.translation.override_1.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`, `product.cover.media.translation.override_1`.`custom_fields` as `product.cover.media.translation.override_1.customFields` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.override_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.override_1`.`media_id` AND `product.cover.media.translation.override_1`.`language_id` = ? 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 (?))', array(binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16), null)
     (vendor/doctrine/dbal/src/Query/QueryBuilder.php:344)
  at Doctrine\DBAL\Query\QueryBuilder->executeQuery()
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:317)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(CompiledFieldCollection), array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:133)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(SalesChannelProductCollection), object(CompiledFieldCollection), true, array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:76)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read(object(SalesChannelProductDefinition), object(Criteria), object(Context))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:183)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:121)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->Shopware\Core\System\SalesChannel\Entity\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure), 'saleschannel-repository')
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:105)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:88)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Translation/Translator.php:101)
  at Shopware\Core\Framework\Adapter\Translation\Translator->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php:56)
  at Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure}()
     (vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php:97)
  at Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:64)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/storefront/Page/Product/ProductPageLoader.php:71)
  at Shopware\Storefront\Page\Product\ProductPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/ProductController.php:63)
  at Shopware\Storefront\Controller\ProductController->index(object(SalesChannelContext), object(Request))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php:72)
  at Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(object(HttpKernel), object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:476)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:453)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:351)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:220)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php:65)
  at Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Kernel.php:153)
  at Shopware\Core\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/html/shopware/vendor/autoload_runtime.php')
     (public/index.php:10)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:132)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1104)
  at Doctrine\DBAL\Connection->executeQuery('-- product-detail-route::readSELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`guarantee_months`, `product.parent`.`guarantee_months`) as `product.guaranteeMonths`, COALESCE(`product`.`guarantee_confirmed`, `product.parent`.`guarantee_confirmed`) as `product.guaranteeConfirmed`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.override_1.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.override_1.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.override_1.customFields`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.override_1.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.override_1.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.override_1.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.override_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.override_1.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_option` `product.options.mapping`                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_property` `product.properties.mapping`                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.override_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.override_1.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.override_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.override_1.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.override_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.override_1.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.override_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.override_1.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.override_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.override_1.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`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.override_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.override_1.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.override_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.override_1.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.override_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.override_1.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` 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.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` 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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation.override_1`.`name` as `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation.override_1`.`description` as `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`, `product.manufacturer.translation.override_1`.`custom_fields` as `product.manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.override_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_id` AND `product.manufacturer.translation.override_1`.`language_id` = ? AND `product.manufacturer.translation`.`product_manufacturer_version_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_version_id` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.override_1`.`alt` as `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.override_1`.`title` as `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.override_1`.`custom_fields` as `product.manufacturer.media.translation.override_1.customFields` FROM `media_translation` `product.manufacturer.media.translation` LEFT JOIN `media_translation` `product.manufacturer.media.translation.override_1` ON `product.manufacturer.media.translation`.`media_id` = `product.manufacturer.media.translation.override_1`.`media_id` AND `product.manufacturer.media.translation.override_1`.`language_id` = ? WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation.override_1`.`short_code` as `product.unit.translation.override_1.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation.override_1`.`name` as `product.unit.translation.override_1.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`, `product.unit.translation.override_1`.`custom_fields` as `product.unit.translation.override_1.customFields` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.override_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.override_1`.`unit_id` AND `product.unit.translation.override_1`.`language_id` = ? 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.override_1`.`name` as `product.deliveryTime.translation.override_1.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.override_1`.`custom_fields` as `product.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.override_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.override_1`.`delivery_time_id` AND `product.deliveryTime.translation.override_1`.`language_id` = ? 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.override_1`.`alt` as `product.cover.media.translation.override_1.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation.override_1`.`title` as `product.cover.media.translation.override_1.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`, `product.cover.media.translation.override_1`.`custom_fields` as `product.cover.media.translation.override_1.customFields` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.override_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.override_1`.`media_id` AND `product.cover.media.translation.override_1`.`language_id` = ? 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 (?))', array(binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16), null)
     (vendor/doctrine/dbal/src/Query/QueryBuilder.php:344)
  at Doctrine\DBAL\Query\QueryBuilder->executeQuery()
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:317)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(CompiledFieldCollection), array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:133)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(SalesChannelProductCollection), object(CompiledFieldCollection), true, array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:76)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read(object(SalesChannelProductDefinition), object(Criteria), object(Context))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:183)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:121)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->Shopware\Core\System\SalesChannel\Entity\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure), 'saleschannel-repository')
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:105)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:88)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Translation/Translator.php:101)
  at Shopware\Core\Framework\Adapter\Translation\Translator->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php:56)
  at Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure}()
     (vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php:97)
  at Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:64)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/storefront/Page/Product/ProductPageLoader.php:71)
  at Shopware\Storefront\Page\Product\ProductPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/ProductController.php:63)
  at Shopware\Storefront\Controller\ProductController->index(object(SalesChannelContext), object(Request))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php:72)
  at Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(object(HttpKernel), object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:476)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:453)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:351)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:220)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php:65)
  at Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Kernel.php:153)
  at Shopware\Core\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/html/shopware/vendor/autoload_runtime.php')
     (public/index.php:10)
[1/3] PDOException 
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.guarantee_months' in 'field list'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130
  at PDOStatement->execute(null)
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130)
  at Doctrine\DBAL\Driver\PDO\Statement->execute(null)
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute(null)
     (vendor/symfony/doctrine-bridge/Middleware/Debug/DBAL3/Statement.php:70)
  at Symfony\Bridge\Doctrine\Middleware\Debug\DBAL3\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1104)
  at Doctrine\DBAL\Connection->executeQuery('-- product-detail-route::readSELECT `product`.`id` as `product.id`, `product`.`version_id` as `product.versionId`, `product`.`parent_id` as `product.parentId`, `product`.`parent_version_id` as `product.parentVersionId`, COALESCE(`product`.`product_manufacturer_id`, `product.parent`.`product_manufacturer_id`) as `product.manufacturerId`, COALESCE(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) as `product.productManufacturerVersionId`, COALESCE(`product`.`unit_id`, `product.parent`.`unit_id`) as `product.unitId`, COALESCE(`product`.`tax_id`, `product.parent`.`tax_id`) as `product.taxId`, COALESCE(`product`.`product_media_id`, `product.parent`.`product_media_id`) as `product.coverId`, COALESCE(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) as `product.productMediaVersionId`, COALESCE(`product`.`delivery_time_id`, `product.parent`.`delivery_time_id`) as `product.deliveryTimeId`, COALESCE(`product`.`product_feature_set_id`, `product.parent`.`product_feature_set_id`) as `product.featureSetId`, COALESCE(`product`.`canonical_product_id`, `product.parent`.`canonical_product_id`) as `product.canonicalProductId`, COALESCE(`product`.`canonical_product_version_id`, `product.parent`.`canonical_product_version_id`) as `product.canonicalProductVersionId`, COALESCE(`product`.`cms_page_id`, `product.parent`.`cms_page_id`) as `product.cmsPageId`, COALESCE(`product`.`cms_page_version_id`, `product.parent`.`cms_page_version_id`) as `product.cmsPageVersionId`, `product.parent`.`price` as `product.price.inherited`, COALESCE(`product`.`price`, `product.parent`.`price`) as `product.price`, `product`.`product_number` as `product.productNumber`, COALESCE(`product`.`restock_time`, `product.parent`.`restock_time`) as `product.restockTime`, `product`.`auto_increment` as `product.autoIncrement`, COALESCE(`product`.`active`, `product.parent`.`active`) as `product.active`, `product`.`available` as `product.available`, COALESCE(`product`.`is_closeout`, `product.parent`.`is_closeout`) as `product.isCloseout`, `product`.`available_stock` as `product.availableStock`, `product`.`stock` as `product.stock`, `product`.`display_group` as `product.displayGroup`, `product.parent`.`variant_listing_config` as `product.variantListingConfig.inherited`, COALESCE(`product`.`variant_listing_config`, `product.parent`.`variant_listing_config`) as `product.variantListingConfig`, `product`.`variant_restrictions` as `product.variantRestrictions`, COALESCE(`product`.`manufacturer_number`, `product.parent`.`manufacturer_number`) as `product.manufacturerNumber`, COALESCE(`product`.`guarantee_months`, `product.parent`.`guarantee_months`) as `product.guaranteeMonths`, COALESCE(`product`.`guarantee_confirmed`, `product.parent`.`guarantee_confirmed`) as `product.guaranteeConfirmed`, COALESCE(`product`.`ean`, `product.parent`.`ean`) as `product.ean`, COALESCE(`product`.`purchase_steps`, `product.parent`.`purchase_steps`) as `product.purchaseSteps`, COALESCE(`product`.`max_purchase`, `product.parent`.`max_purchase`) as `product.maxPurchase`, COALESCE(`product`.`min_purchase`, `product.parent`.`min_purchase`) as `product.minPurchase`, COALESCE(`product`.`purchase_unit`, `product.parent`.`purchase_unit`) as `product.purchaseUnit`, COALESCE(`product`.`reference_unit`, `product.parent`.`reference_unit`) as `product.referenceUnit`, COALESCE(`product`.`shipping_free`, `product.parent`.`shipping_free`) as `product.shippingFree`, `product.parent`.`purchase_prices` as `product.purchasePrices.inherited`, COALESCE(`product`.`purchase_prices`, `product.parent`.`purchase_prices`) as `product.purchasePrices`, COALESCE(`product`.`mark_as_topseller`, `product.parent`.`mark_as_topseller`) as `product.markAsTopseller`, COALESCE(`product`.`weight`, `product.parent`.`weight`) as `product.weight`, COALESCE(`product`.`width`, `product.parent`.`width`) as `product.width`, COALESCE(`product`.`height`, `product.parent`.`height`) as `product.height`, COALESCE(`product`.`length`, `product.parent`.`length`) as `product.length`, COALESCE(`product`.`release_date`, `product.parent`.`release_date`) as `product.releaseDate`, COALESCE(`product`.`rating_average`, `product.parent`.`rating_average`) as `product.ratingAverage`, `product.parent`.`category_tree` as `product.categoryTree.inherited`, COALESCE(`product`.`category_tree`, `product.parent`.`category_tree`) as `product.categoryTree`, `product.parent`.`property_ids` as `product.propertyIds.inherited`, COALESCE(`product`.`property_ids`, `product.parent`.`property_ids`) as `product.propertyIds`, `product.parent`.`option_ids` as `product.optionIds.inherited`, COALESCE(`product`.`option_ids`, `product.parent`.`option_ids`) as `product.optionIds`, `product.parent`.`stream_ids` as `product.streamIds.inherited`, COALESCE(`product`.`stream_ids`, `product.parent`.`stream_ids`) as `product.streamIds`, `product.parent`.`tag_ids` as `product.tagIds.inherited`, COALESCE(`product`.`tag_ids`, `product.parent`.`tag_ids`) as `product.tagIds`, `product.parent`.`category_ids` as `product.categoryIds.inherited`, COALESCE(`product`.`category_ids`, `product.parent`.`category_ids`) as `product.categoryIds`, `product`.`child_count` as `product.childCount`, COALESCE(`product`.`custom_field_set_selection_active`, `product.parent`.`custom_field_set_selection_active`) as `product.customFieldSetSelectionActive`, `product`.`sales` as `product.sales`, `product`.`states` as `product.states`, `product.tax`.`id` as `product.tax.id`, `product.tax`.`tax_rate` as `product.tax.taxRate`, `product.tax`.`name` as `product.tax.name`, `product.tax`.`position` as `product.tax.position`, `product.tax`.`custom_fields` as `product.tax.customFields`, `product.tax`.`created_at` as `product.tax.createdAt`, `product.tax`.`updated_at` as `product.tax.updatedAt`, `product.parent`.`cheapest_price` as `product.cheapestPrice.inherited`, COALESCE(`product`.`cheapest_price`, `product.parent`.`cheapest_price`) as `product.cheapestPrice`, `product`.`created_at` as `product.createdAt`, `product`.`updated_at` as `product.updatedAt`, `product.manufacturer`.`id` as `product.manufacturer.id`, `product.manufacturer`.`version_id` as `product.manufacturer.versionId`, `product.manufacturer`.`media_id` as `product.manufacturer.mediaId`, `product.manufacturer`.`link` as `product.manufacturer.link`, `product.manufacturer`.`created_at` as `product.manufacturer.createdAt`, `product.manufacturer`.`updated_at` as `product.manufacturer.updatedAt`, `product.manufacturer.media`.`id` as `product.manufacturer.media.id`, `product.manufacturer.media`.`user_id` as `product.manufacturer.media.userId`, `product.manufacturer.media`.`media_folder_id` as `product.manufacturer.media.mediaFolderId`, `product.manufacturer.media`.`mime_type` as `product.manufacturer.media.mimeType`, `product.manufacturer.media`.`file_extension` as `product.manufacturer.media.fileExtension`, `product.manufacturer.media`.`uploaded_at` as `product.manufacturer.media.uploadedAt`, `product.manufacturer.media`.`file_name` as `product.manufacturer.media.fileName`, `product.manufacturer.media`.`file_size` as `product.manufacturer.media.fileSize`, `product.manufacturer.media`.`media_type` as `product.manufacturer.media.mediaTypeRaw`, `product.manufacturer.media`.`meta_data` as `product.manufacturer.media.metaData`, `product.manufacturer.media`.`config` as `product.manufacturer.media.config`, `product.manufacturer.media`.`path` as `product.manufacturer.media.path`, `product.manufacturer.media`.`private` as `product.manufacturer.media.private`, `product.manufacturer.media`.`thumbnails_ro` as `product.manufacturer.media.thumbnailsRo`, `product.manufacturer.media`.`file_hash` as `product.manufacturer.media.fileHash`, `product.manufacturer.media`.`created_at` as `product.manufacturer.media.createdAt`, `product.manufacturer.media`.`updated_at` as `product.manufacturer.media.updatedAt`, `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation.title`, COALESCE(`product.manufacturer.media.translation.override_1.title`,`product.manufacturer.media.translation.title`) as `product.manufacturer.media.title`, `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation.alt`, COALESCE(`product.manufacturer.media.translation.override_1.alt`,`product.manufacturer.media.translation.alt`) as `product.manufacturer.media.alt`, `product.manufacturer.media.translation.override_1.customFields`, `product.manufacturer.media.translation.customFields`, COALESCE(`product.manufacturer.media.translation.override_1.customFields`,`product.manufacturer.media.translation.customFields`) as `product.manufacturer.media.customFields`, `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation.name`, COALESCE(`product.manufacturer.translation.override_1.name`,`product.manufacturer.translation.name`) as `product.manufacturer.name`, `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation.description`, COALESCE(`product.manufacturer.translation.override_1.description`,`product.manufacturer.translation.description`) as `product.manufacturer.description`, `product.manufacturer.translation.override_1.customFields`, `product.manufacturer.translation.customFields`, COALESCE(`product.manufacturer.translation.override_1.customFields`,`product.manufacturer.translation.customFields`) as `product.manufacturer.customFields`, (SELECT GROUP_CONCAT(HEX(`product.options.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_option` `product.options.mapping`                  WHERE `product.options.mapping`.`product_id` = `product`.`id` ) as `product.options.id_mapping`, (SELECT GROUP_CONCAT(HEX(`product.properties.mapping`.`property_group_option_id`) SEPARATOR \'||\')                  FROM `product_property` `product.properties.mapping`                  WHERE `product.properties.mapping`.`product_id` = `product`.`properties` ) as `product.properties.id_mapping`, `product.unit`.`id` as `product.unit.id`, `product.unit`.`created_at` as `product.unit.createdAt`, `product.unit`.`updated_at` as `product.unit.updatedAt`, `product.unit.translation.override_1.shortCode`, `product.unit.translation.shortCode`, COALESCE(`product.unit.translation.override_1.shortCode`,`product.unit.translation.shortCode`) as `product.unit.shortCode`, `product.unit.translation.override_1.name`, `product.unit.translation.name`, COALESCE(`product.unit.translation.override_1.name`,`product.unit.translation.name`) as `product.unit.name`, `product.unit.translation.override_1.customFields`, `product.unit.translation.customFields`, COALESCE(`product.unit.translation.override_1.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.override_1.name`, `product.deliveryTime.translation.name`, COALESCE(`product.deliveryTime.translation.override_1.name`,`product.deliveryTime.translation.name`) as `product.deliveryTime.name`, `product.deliveryTime.translation.override_1.customFields`, `product.deliveryTime.translation.customFields`, COALESCE(`product.deliveryTime.translation.override_1.customFields`,`product.deliveryTime.translation.customFields`) as `product.deliveryTime.customFields`, `product.cover`.`id` as `product.cover.id`, `product.cover`.`version_id` as `product.cover.versionId`, `product.cover`.`product_id` as `product.cover.productId`, `product.cover`.`product_version_id` as `product.cover.productVersionId`, `product.cover`.`media_id` as `product.cover.mediaId`, `product.cover`.`position` as `product.cover.position`, `product.cover.media`.`id` as `product.cover.media.id`, `product.cover.media`.`user_id` as `product.cover.media.userId`, `product.cover.media`.`media_folder_id` as `product.cover.media.mediaFolderId`, `product.cover.media`.`mime_type` as `product.cover.media.mimeType`, `product.cover.media`.`file_extension` as `product.cover.media.fileExtension`, `product.cover.media`.`uploaded_at` as `product.cover.media.uploadedAt`, `product.cover.media`.`file_name` as `product.cover.media.fileName`, `product.cover.media`.`file_size` as `product.cover.media.fileSize`, `product.cover.media`.`media_type` as `product.cover.media.mediaTypeRaw`, `product.cover.media`.`meta_data` as `product.cover.media.metaData`, `product.cover.media`.`config` as `product.cover.media.config`, `product.cover.media`.`path` as `product.cover.media.path`, `product.cover.media`.`private` as `product.cover.media.private`, `product.cover.media`.`thumbnails_ro` as `product.cover.media.thumbnailsRo`, `product.cover.media`.`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.override_1.title`, `product.cover.media.translation.title`, COALESCE(`product.cover.media.translation.override_1.title`,`product.cover.media.translation.title`) as `product.cover.media.title`, `product.cover.media.translation.override_1.alt`, `product.cover.media.translation.alt`, COALESCE(`product.cover.media.translation.override_1.alt`,`product.cover.media.translation.alt`) as `product.cover.media.alt`, `product.cover.media.translation.override_1.customFields`, `product.cover.media.translation.customFields`, COALESCE(`product.cover.media.translation.override_1.customFields`,`product.cover.media.translation.customFields`) as `product.cover.media.customFields`, `product.cover`.`custom_fields` as `product.cover.customFields`, `product.cover`.`created_at` as `product.cover.createdAt`, `product.cover`.`updated_at` as `product.cover.updatedAt`, `product.translation.override_1.metaDescription`, `product.parent.translation.override_1.metaDescription`, `product.translation.metaDescription`, `product.parent.translation.metaDescription`, COALESCE(`product.translation.override_1.metaDescription`,`product.parent.translation.override_1.metaDescription`,`product.translation.metaDescription`,`product.parent.translation.metaDescription`) as `product.metaDescription`, `product.translation.override_1.name`, `product.parent.translation.override_1.name`, `product.translation.name`, `product.parent.translation.name`, COALESCE(`product.translation.override_1.name`,`product.parent.translation.override_1.name`,`product.translation.name`,`product.parent.translation.name`) as `product.name`, `product.translation.override_1.keywords`, `product.parent.translation.override_1.keywords`, `product.translation.keywords`, `product.parent.translation.keywords`, COALESCE(`product.translation.override_1.keywords`,`product.parent.translation.override_1.keywords`,`product.translation.keywords`,`product.parent.translation.keywords`) as `product.keywords`, `product.translation.override_1.description`, `product.parent.translation.override_1.description`, `product.translation.description`, `product.parent.translation.description`, COALESCE(`product.translation.override_1.description`,`product.parent.translation.override_1.description`,`product.translation.description`,`product.parent.translation.description`) as `product.description`, `product.translation.override_1.metaTitle`, `product.parent.translation.override_1.metaTitle`, `product.translation.metaTitle`, `product.parent.translation.metaTitle`, COALESCE(`product.translation.override_1.metaTitle`,`product.parent.translation.override_1.metaTitle`,`product.translation.metaTitle`,`product.parent.translation.metaTitle`) as `product.metaTitle`, `product.translation.override_1.packUnit`, `product.parent.translation.override_1.packUnit`, `product.translation.packUnit`, `product.parent.translation.packUnit`, COALESCE(`product.translation.override_1.packUnit`,`product.parent.translation.override_1.packUnit`,`product.translation.packUnit`,`product.parent.translation.packUnit`) as `product.packUnit`, `product.translation.override_1.packUnitPlural`, `product.parent.translation.override_1.packUnitPlural`, `product.translation.packUnitPlural`, `product.parent.translation.packUnitPlural`, COALESCE(`product.translation.override_1.packUnitPlural`,`product.parent.translation.override_1.packUnitPlural`,`product.translation.packUnitPlural`,`product.parent.translation.packUnitPlural`) as `product.packUnitPlural`, `product.translation.override_1.customSearchKeywords`, `product.parent.translation.override_1.customSearchKeywords`, `product.translation.customSearchKeywords`, `product.parent.translation.customSearchKeywords`, COALESCE(`product.translation.override_1.customSearchKeywords`,`product.parent.translation.override_1.customSearchKeywords`,`product.translation.customSearchKeywords`,`product.parent.translation.customSearchKeywords`) as `product.customSearchKeywords`, `product.translation.override_1.slotConfig`, `product.parent.translation.override_1.slotConfig`, `product.translation.slotConfig`, `product.parent.translation.slotConfig`, COALESCE(`product.translation.override_1.slotConfig`,`product.parent.translation.override_1.slotConfig`,`product.translation.slotConfig`,`product.parent.translation.slotConfig`) as `product.slotConfig`, `product.translation.override_1.customFields`, `product.parent.translation.override_1.customFields`, `product.translation.customFields`, `product.parent.translation.customFields`, COALESCE(`product.translation.override_1.customFields`,`product.parent.translation.override_1.customFields`,`product.translation.customFields`,`product.parent.translation.customFields`) as `product.customFields` FROM `product` LEFT JOIN `product` `product.parent` ON `product`.`parent_id` = `product.parent`.`id` AND `product`.`parent_version_id` = `product.parent`.`version_id` LEFT JOIN `tax` `product.tax` ON `product`.`tax` = `product.tax`.`id` LEFT JOIN `product_manufacturer` `product.manufacturer` ON `product`.`manufacturer` = `product.manufacturer`.`id` AND IFNULL(`product`.`product_manufacturer_version_id`, `product.parent`.`product_manufacturer_version_id`) = `product.manufacturer`.`version_id` LEFT JOIN `unit` `product.unit` ON `product`.`unit` = `product.unit`.`id` LEFT JOIN `delivery_time` `product.deliveryTime` ON `product`.`deliveryTime` = `product.deliveryTime`.`id` LEFT JOIN `product_media` `product.cover` ON `product`.`cover` = `product.cover`.`id` AND IFNULL(`product`.`product_media_version_id`, `product.parent`.`product_media_version_id`) = `product.cover`.`version_id` LEFT JOIN (SELECT `product.translation`.`product_id`, `product.translation`.`product_version_id`, `product.translation`.`meta_description` as `product.translation.metaDescription`, `product.translation.override_1`.`meta_description` as `product.translation.override_1.metaDescription`, `product.translation`.`name` as `product.translation.name`, `product.translation.override_1`.`name` as `product.translation.override_1.name`, `product.translation`.`keywords` as `product.translation.keywords`, `product.translation.override_1`.`keywords` as `product.translation.override_1.keywords`, `product.translation`.`description` as `product.translation.description`, `product.translation.override_1`.`description` as `product.translation.override_1.description`, `product.translation`.`meta_title` as `product.translation.metaTitle`, `product.translation.override_1`.`meta_title` as `product.translation.override_1.metaTitle`, `product.translation`.`pack_unit` as `product.translation.packUnit`, `product.translation.override_1`.`pack_unit` as `product.translation.override_1.packUnit`, `product.translation`.`pack_unit_plural` as `product.translation.packUnitPlural`, `product.translation.override_1`.`pack_unit_plural` as `product.translation.override_1.packUnitPlural`, `product.translation`.`custom_fields` as `product.translation.customFields`, `product.translation.override_1`.`custom_fields` as `product.translation.override_1.customFields`, `product.translation`.`slot_config` as `product.translation.slotConfig`, `product.translation.override_1`.`slot_config` as `product.translation.override_1.slotConfig`, `product.translation`.`custom_search_keywords` as `product.translation.customSearchKeywords`, `product.translation.override_1`.`custom_search_keywords` as `product.translation.override_1.customSearchKeywords` FROM `product_translation` `product.translation` LEFT JOIN `product_translation` `product.translation.override_1` ON `product.translation`.`product_id` = `product.translation.override_1`.`product_id` AND `product.translation.override_1`.`language_id` = ? AND `product.translation`.`product_version_id` = `product.translation.override_1`.`product_version_id` 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.override_1`.`meta_description` as `product.parent.translation.override_1.metaDescription`, `product.parent.translation`.`name` as `product.parent.translation.name`, `product.parent.translation.override_1`.`name` as `product.parent.translation.override_1.name`, `product.parent.translation`.`keywords` as `product.parent.translation.keywords`, `product.parent.translation.override_1`.`keywords` as `product.parent.translation.override_1.keywords`, `product.parent.translation`.`description` as `product.parent.translation.description`, `product.parent.translation.override_1`.`description` as `product.parent.translation.override_1.description`, `product.parent.translation`.`meta_title` as `product.parent.translation.metaTitle`, `product.parent.translation.override_1`.`meta_title` as `product.parent.translation.override_1.metaTitle`, `product.parent.translation`.`pack_unit` as `product.parent.translation.packUnit`, `product.parent.translation.override_1`.`pack_unit` as `product.parent.translation.override_1.packUnit`, `product.parent.translation`.`pack_unit_plural` as `product.parent.translation.packUnitPlural`, `product.parent.translation.override_1`.`pack_unit_plural` as `product.parent.translation.override_1.packUnitPlural`, `product.parent.translation`.`custom_fields` as `product.parent.translation.customFields`, `product.parent.translation.override_1`.`custom_fields` as `product.parent.translation.override_1.customFields`, `product.parent.translation`.`slot_config` as `product.parent.translation.slotConfig`, `product.parent.translation.override_1`.`slot_config` as `product.parent.translation.override_1.slotConfig`, `product.parent.translation`.`custom_search_keywords` as `product.parent.translation.customSearchKeywords`, `product.parent.translation.override_1`.`custom_search_keywords` as `product.parent.translation.override_1.customSearchKeywords` FROM `product_translation` `product.parent.translation` LEFT JOIN `product_translation` `product.parent.translation.override_1` ON `product.parent.translation`.`product_id` = `product.parent.translation.override_1`.`product_id` AND `product.parent.translation.override_1`.`language_id` = ? AND `product.parent.translation`.`product_version_id` = `product.parent.translation.override_1`.`product_version_id` 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 `media` `product.manufacturer.media` ON `product.manufacturer`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.manufacturer.translation`.`product_manufacturer_id`, `product.manufacturer.translation`.`product_manufacturer_version_id`, `product.manufacturer.translation`.`name` as `product.manufacturer.translation.name`, `product.manufacturer.translation.override_1`.`name` as `product.manufacturer.translation.override_1.name`, `product.manufacturer.translation`.`description` as `product.manufacturer.translation.description`, `product.manufacturer.translation.override_1`.`description` as `product.manufacturer.translation.override_1.description`, `product.manufacturer.translation`.`custom_fields` as `product.manufacturer.translation.customFields`, `product.manufacturer.translation.override_1`.`custom_fields` as `product.manufacturer.translation.override_1.customFields` FROM `product_manufacturer_translation` `product.manufacturer.translation` LEFT JOIN `product_manufacturer_translation` `product.manufacturer.translation.override_1` ON `product.manufacturer.translation`.`product_manufacturer_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_id` AND `product.manufacturer.translation.override_1`.`language_id` = ? AND `product.manufacturer.translation`.`product_manufacturer_version_id` = `product.manufacturer.translation.override_1`.`product_manufacturer_version_id` WHERE `product.manufacturer.translation`.`language_id` = ?) `product.manufacturer.product_manufacturer_translation` ON `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_id` = `product.manufacturer`.`id` AND `product.manufacturer.product_manufacturer_translation`.`product_manufacturer_version_id` = `product.manufacturer`.`version_id` LEFT JOIN (SELECT `product.manufacturer.media.translation`.`media_id`, `product.manufacturer.media.translation`.`alt` as `product.manufacturer.media.translation.alt`, `product.manufacturer.media.translation.override_1`.`alt` as `product.manufacturer.media.translation.override_1.alt`, `product.manufacturer.media.translation`.`title` as `product.manufacturer.media.translation.title`, `product.manufacturer.media.translation.override_1`.`title` as `product.manufacturer.media.translation.override_1.title`, `product.manufacturer.media.translation`.`custom_fields` as `product.manufacturer.media.translation.customFields`, `product.manufacturer.media.translation.override_1`.`custom_fields` as `product.manufacturer.media.translation.override_1.customFields` FROM `media_translation` `product.manufacturer.media.translation` LEFT JOIN `media_translation` `product.manufacturer.media.translation.override_1` ON `product.manufacturer.media.translation`.`media_id` = `product.manufacturer.media.translation.override_1`.`media_id` AND `product.manufacturer.media.translation.override_1`.`language_id` = ? WHERE `product.manufacturer.media.translation`.`language_id` = ?) `product.manufacturer.media.media_translation` ON `product.manufacturer.media.media_translation`.`media_id` = `product.manufacturer.media`.`id` LEFT JOIN (SELECT `product.unit.translation`.`unit_id`, `product.unit.translation`.`short_code` as `product.unit.translation.shortCode`, `product.unit.translation.override_1`.`short_code` as `product.unit.translation.override_1.shortCode`, `product.unit.translation`.`name` as `product.unit.translation.name`, `product.unit.translation.override_1`.`name` as `product.unit.translation.override_1.name`, `product.unit.translation`.`custom_fields` as `product.unit.translation.customFields`, `product.unit.translation.override_1`.`custom_fields` as `product.unit.translation.override_1.customFields` FROM `unit_translation` `product.unit.translation` LEFT JOIN `unit_translation` `product.unit.translation.override_1` ON `product.unit.translation`.`unit_id` = `product.unit.translation.override_1`.`unit_id` AND `product.unit.translation.override_1`.`language_id` = ? 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.override_1`.`name` as `product.deliveryTime.translation.override_1.name`, `product.deliveryTime.translation`.`custom_fields` as `product.deliveryTime.translation.customFields`, `product.deliveryTime.translation.override_1`.`custom_fields` as `product.deliveryTime.translation.override_1.customFields` FROM `delivery_time_translation` `product.deliveryTime.translation` LEFT JOIN `delivery_time_translation` `product.deliveryTime.translation.override_1` ON `product.deliveryTime.translation`.`delivery_time_id` = `product.deliveryTime.translation.override_1`.`delivery_time_id` AND `product.deliveryTime.translation.override_1`.`language_id` = ? 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.override_1`.`alt` as `product.cover.media.translation.override_1.alt`, `product.cover.media.translation`.`title` as `product.cover.media.translation.title`, `product.cover.media.translation.override_1`.`title` as `product.cover.media.translation.override_1.title`, `product.cover.media.translation`.`custom_fields` as `product.cover.media.translation.customFields`, `product.cover.media.translation.override_1`.`custom_fields` as `product.cover.media.translation.override_1.customFields` FROM `media_translation` `product.cover.media.translation` LEFT JOIN `media_translation` `product.cover.media.translation.override_1` ON `product.cover.media.translation`.`media_id` = `product.cover.media.translation.override_1`.`media_id` AND `product.cover.media.translation.override_1`.`language_id` = ? 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 (?))', array(binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, '/�_��Mp�XT�|��', binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16), null)
     (vendor/doctrine/dbal/src/Query/QueryBuilder.php:344)
  at Doctrine\DBAL\Query\QueryBuilder->executeQuery()
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:317)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->fetch(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(CompiledFieldCollection), array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:133)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->_read(object(Criteria), object(SalesChannelProductDefinition), object(Context), object(SalesChannelProductCollection), object(CompiledFieldCollection), true, array())
     (vendor/shopware/core/Framework/DataAbstractionLayer/Dbal/EntityReader.php:76)
  at Shopware\Core\Framework\DataAbstractionLayer\Dbal\EntityReader->read(object(SalesChannelProductDefinition), object(Criteria), object(Context))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:183)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->read(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:121)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->_search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->Shopware\Core\System\SalesChannel\Entity\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure), 'saleschannel-repository')
     (vendor/shopware/core/System/SalesChannel/Entity/SalesChannelRepository.php:68)
  at Shopware\Core\System\SalesChannel\Entity\SalesChannelRepository->search(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:105)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('product-detail-route', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php:88)
  at Shopware\Core\Content\Product\SalesChannel\Detail\ProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Translation/Translator.php:101)
  at Shopware\Core\Framework\Adapter\Translation\Translator->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->Shopware\Core\Framework\Adapter\Cache\{closure}()
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTagCollection.php:56)
  at Shopware\Core\Framework\Adapter\Cache\CacheTagCollection->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->Shopware\Storefront\Framework\Cache\{closure}()
     (vendor/shopware/storefront/Theme/ThemeConfigValueAccessor.php:97)
  at Shopware\Storefront\Theme\ThemeConfigValueAccessor->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:67)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->Shopware\Core\Content\Product\SalesChannel\Detail\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-detail-route-0191a86e6f6875dc8eda2e020dd5f9eb-132b4bf0a16948339f2b4a81f7570bda', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Detail/CachedProductDetailRoute.php:64)
  at Shopware\Core\Content\Product\SalesChannel\Detail\CachedProductDetailRoute->load('0191a86e6f6875dc8eda2e020dd5f9eb', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/storefront/Page/Product/ProductPageLoader.php:71)
  at Shopware\Storefront\Page\Product\ProductPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/ProductController.php:63)
  at Shopware\Storefront\Controller\ProductController->index(object(SalesChannelContext), object(Request))
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpKernel.php:72)
  at Shopware\Core\Framework\Adapter\Kernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php:86)
  at Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(object(HttpKernel), object(Request), 1, true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:476)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:453)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:351)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(object(Request), true)
     (vendor/symfony/http-kernel/HttpCache/HttpCache.php:220)
  at Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(object(Request), 1, true)
     (vendor/shopware/core/Framework/Adapter/Kernel/HttpCacheKernel.php:65)
  at Shopware\Core\Framework\Adapter\Kernel\HttpCacheKernel->handle(object(Request), 1, true)
     (vendor/shopware/core/Kernel.php:153)
  at Shopware\Core\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:34)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/html/shopware/vendor/autoload_runtime.php')
     (public/index.php:10)