Error 500 Internal Server Error

GET https://floeter.mittwald2.salesmachine.biz/navigation/018ebbbbd039724092de1db39aa0bb7f

IP
216.73.216.182
Profiled on
Token
eb97ba
Forwarded to ErrorController (078337)

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 {#11508
  -query: Doctrine\DBAL\Query {#11509
    -sql: """
      -- product-listing-route::loading::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.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`, `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 (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.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:19 [
      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"\x0F©\x1CãéjK¾KÙÎu,4%"
      13 => b"\x01‘¼ŽÍìyG™è\C\x0Fsk\r"
      14 => b"\x01šÞ¡m\x14qu†qÆ[eÀâ<"
      15 => b"\x01“Ú\x13qÇs\x04Fâسn’\x13"
      16 => b"\x01œRHQ\fs½§{Ý!žAíƒ"
      17 => b"\x01\x06a½Èr»‡\x7FÑ=ð;z7"
      18 => b"\x01Ž»»ìrp\e†±:D_\x06‹\x1D"
    ]
    -types: array:19 [
      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 => 16
      14 => 16
      15 => 16
      16 => 16
      17 => 16
      18 => 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/Listing/ProductListingLoader.php -> search (line 344)
  1. private function resolveData(Criteria $criteria, array $mapping, SalesChannelContext $context): EntitySearchResult
  2. {
  3. $read = $criteria->cloneForRead(array_values($mapping));
  4. $read->addAssociation('options.group');
  6. return $this->productRepository->search($read, $context);
  7. }
  8. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> resolveData (line 101)
  1. return $result;
  2. }
  4. $mapping = $this->resolvePreviews($ids, $clone, $context);
  6. $productSearchResult = $this->resolveData($clone, $mapping, $context);
  8. $this->addExtensions($idResult, $productSearchResult, $mapping);
  10. $result = new EntitySearchResult(ProductDefinition::ENTITY_NAME, $idResult->getTotal(), $productSearchResult->getEntities(), $aggregations, $criteria, $context->getContext());
  11. $result->addState(...$idResult->getStates());
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> _load (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> publish (line 57)
  1. * @return EntitySearchResult<ProductCollection>
  2. */
  3. public function load(Criteria $origin, SalesChannelContext $context): EntitySearchResult
  4. {
  5. // allows full service decoration
  6. return $this->extensions->publish(
  7. name: ResolveListingExtension::NAME,
  8. extension: new ResolveListingExtension($origin, $context),
  9. function: $this->_load(...)
  10. );
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php -> load (line 81)
  2. return $criteria;
  3. }
  4. );
  6. $entities = $this->listingLoader->load($criteria, $context);
  8. $result = ProductListingResult::createFrom($entities);
  9. $result->addState(...$entities->getStates());
  11. $result->setStreamId($category->get('productStreamId'));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php -> load (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> trace (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> get (line 66)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  7. $name = self::buildName($categoryId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php -> load (line 45)
  2. $this->eventDispatcher->dispatch(
  3. new ProductListingCriteriaEvent($request, $criteria, $context)
  4. );
  6. $response = $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  8. $response->getResult()->addCurrentFilter('navigationId', $categoryId);
  10. $this->processor->process($request, $response->getResult(), $context);
in vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php -> load (line 77)
  2. $criteria = new Criteria();
  3. $criteria->setTitle('cms::product-listing');
  5. $listing = $this->listingRoute
  6. ->load($navigationId, $request, $context, $criteria)
  7. ->getResult();
  9. $data->setListing($listing);
  10. }
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> enrich (line 138)
  1. $result = new ElementDataCollection();
  3. $this->mapSearchResults($result, $slot, $criteriaList, $criteriaResult);
  4. $this->mapEntities($result, $slot, $criteriaList, $identifierResult);
  6. $resolver->enrich($slot, $resolverContext, $result);
  8. // replace with return value from enrich(), because it's allowed to change the entity type
  9. $slots->set($slotId, $slot);
  10. }
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> enrichCmsSlots (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 67)
  2. // fetch data from storage
  3. $identifierResult = $this->fetchByIdentifier($directReads, $resolverContext->getSalesChannelContext());
  4. $criteriaResult = $this->fetchByCriteria($searches, $resolverContext->getSalesChannelContext());
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataEnrichExtension::NAME,
  8. extension: new CmsSlotsDataEnrichExtension(
  9. slots: $slots,
  10. criteriaList: $criteriaList,
  11. identifierResult: $identifierResult,
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> __resolve (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 82)
  1. );
  2. }
  4. public function resolve(CmsSlotCollection $slots, ResolverContext $resolverContext): CmsSlotCollection
  5. {
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataResolveExtension::NAME,
  8. extension: new CmsSlotsDataResolveExtension($slots, $resolverContext),
  9. function: $this->__resolve(...),
  10. );
  11. }
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> resolve (line 112)
  1. }
  3. private function loadSlotData(CmsSectionCollection $sections, ResolverContext $resolverContext): void
  4. {
  5. $blocks = $sections->getBlocks();
  6. $slots = $this->slotDataResolver->resolve($blocks->getSlots(), $resolverContext);
  8. $blocks->setSlots($slots);
  9. }
  11. /**
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> loadSlotData (line 99)
  2. // step 4, overwrite slot config
  3. $this->overwriteSlotConfig($sections, $overwrite);
  5. // step 5, resolve slot data
  6. $this->loadSlotData($sections, $resolverContext);
  7. }
  9. $this->dispatcher->dispatch(new CmsPageLoadedEvent($request, $pages, $context));
  11. $this->dispatcher->dispatch(new AddCacheTagEvent(...$this->extractProductIds($pages)));
in vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php -> load (line 93)
  1. return new CategoryRouteResponse($category);
  2. }
  4. $resolverContext = new EntityResolverContext($context, $request, $this->categoryDefinition, $category);
  6. $pages = $this->cmsPageLoader->load(
  7. $request,
  8. $this->createCriteria($pageId, $request),
  9. $context,
  10. $slotConfig,
  11. $resolverContext
in vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php -> load (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> trace (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> get (line 73)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  7. $name = self::buildName($navigationId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  11. $item->tag($this->generateTags($navigationId, $response, $request, $context));
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php :: trace (line 62)
  1. {
  2. if (Feature::isActive('cache_rework')) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. return Profiler::trace('category-route', function () use ($navigationId, $request, $context) {
  7. if ($context->hasState(...$this->states)) {
  8. return $this->getDecorated()->load($navigationId, $request, $context);
  9. }
  11. $key = $this->generateKey($navigationId, $request, $context);
CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext)) in custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php (line 46)
  1. return $this->inner;
  2. }
  4. public function load(string $navigationId, Request $request, SalesChannelContext $context): CategoryRouteResponse
  5. {
  6. $response = $this->inner->load($navigationId, $request, $context);
  8. $route = $request->attributes->get('_route');
  10. if (!\is_string($route) || empty($route)) {
  11. return $response;
in vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php -> load (line 41)
  1. $page = NavigationPage::createFrom($page);
  3. $navigationId = $request->attributes->get('navigationId', $context->getSalesChannel()->getNavigationCategoryId());
  5. $category = $this->cmsPageRoute
  6. ->load($navigationId, $request, $context)
  7. ->getCategory();
  9. if (!$category->getActive()) {
  10. throw CategoryException::categoryNotFound($category->getId());
  11. }
in vendor/shopware/storefront/Controller/NavigationController.php -> load (line 69)
  1. defaults: ['_httpCache' => true],
  2. methods: ['GET'],
  3. )]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->navigationPageLoader->load($request, $context);
  8. $this->hook(new NavigationPageLoadedHook($page, $context));
  10. $category = $page->getCategory();
  11. \assert($category !== null);
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/Listing/ProductListingLoader.php -> search (line 344)
  1. private function resolveData(Criteria $criteria, array $mapping, SalesChannelContext $context): EntitySearchResult
  2. {
  3. $read = $criteria->cloneForRead(array_values($mapping));
  4. $read->addAssociation('options.group');
  6. return $this->productRepository->search($read, $context);
  7. }
  8. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> resolveData (line 101)
  1. return $result;
  2. }
  4. $mapping = $this->resolvePreviews($ids, $clone, $context);
  6. $productSearchResult = $this->resolveData($clone, $mapping, $context);
  8. $this->addExtensions($idResult, $productSearchResult, $mapping);
  10. $result = new EntitySearchResult(ProductDefinition::ENTITY_NAME, $idResult->getTotal(), $productSearchResult->getEntities(), $aggregations, $criteria, $context->getContext());
  11. $result->addState(...$idResult->getStates());
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> _load (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> publish (line 57)
  1. * @return EntitySearchResult<ProductCollection>
  2. */
  3. public function load(Criteria $origin, SalesChannelContext $context): EntitySearchResult
  4. {
  5. // allows full service decoration
  6. return $this->extensions->publish(
  7. name: ResolveListingExtension::NAME,
  8. extension: new ResolveListingExtension($origin, $context),
  9. function: $this->_load(...)
  10. );
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php -> load (line 81)
  2. return $criteria;
  3. }
  4. );
  6. $entities = $this->listingLoader->load($criteria, $context);
  8. $result = ProductListingResult::createFrom($entities);
  9. $result->addState(...$entities->getStates());
  11. $result->setStreamId($category->get('productStreamId'));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php -> load (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> trace (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> get (line 66)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  7. $name = self::buildName($categoryId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php -> load (line 45)
  2. $this->eventDispatcher->dispatch(
  3. new ProductListingCriteriaEvent($request, $criteria, $context)
  4. );
  6. $response = $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  8. $response->getResult()->addCurrentFilter('navigationId', $categoryId);
  10. $this->processor->process($request, $response->getResult(), $context);
in vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php -> load (line 77)
  2. $criteria = new Criteria();
  3. $criteria->setTitle('cms::product-listing');
  5. $listing = $this->listingRoute
  6. ->load($navigationId, $request, $context, $criteria)
  7. ->getResult();
  9. $data->setListing($listing);
  10. }
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> enrich (line 138)
  1. $result = new ElementDataCollection();
  3. $this->mapSearchResults($result, $slot, $criteriaList, $criteriaResult);
  4. $this->mapEntities($result, $slot, $criteriaList, $identifierResult);
  6. $resolver->enrich($slot, $resolverContext, $result);
  8. // replace with return value from enrich(), because it's allowed to change the entity type
  9. $slots->set($slotId, $slot);
  10. }
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> enrichCmsSlots (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 67)
  2. // fetch data from storage
  3. $identifierResult = $this->fetchByIdentifier($directReads, $resolverContext->getSalesChannelContext());
  4. $criteriaResult = $this->fetchByCriteria($searches, $resolverContext->getSalesChannelContext());
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataEnrichExtension::NAME,
  8. extension: new CmsSlotsDataEnrichExtension(
  9. slots: $slots,
  10. criteriaList: $criteriaList,
  11. identifierResult: $identifierResult,
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> __resolve (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 82)
  1. );
  2. }
  4. public function resolve(CmsSlotCollection $slots, ResolverContext $resolverContext): CmsSlotCollection
  5. {
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataResolveExtension::NAME,
  8. extension: new CmsSlotsDataResolveExtension($slots, $resolverContext),
  9. function: $this->__resolve(...),
  10. );
  11. }
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> resolve (line 112)
  1. }
  3. private function loadSlotData(CmsSectionCollection $sections, ResolverContext $resolverContext): void
  4. {
  5. $blocks = $sections->getBlocks();
  6. $slots = $this->slotDataResolver->resolve($blocks->getSlots(), $resolverContext);
  8. $blocks->setSlots($slots);
  9. }
  11. /**
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> loadSlotData (line 99)
  2. // step 4, overwrite slot config
  3. $this->overwriteSlotConfig($sections, $overwrite);
  5. // step 5, resolve slot data
  6. $this->loadSlotData($sections, $resolverContext);
  7. }
  9. $this->dispatcher->dispatch(new CmsPageLoadedEvent($request, $pages, $context));
  11. $this->dispatcher->dispatch(new AddCacheTagEvent(...$this->extractProductIds($pages)));
in vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php -> load (line 93)
  1. return new CategoryRouteResponse($category);
  2. }
  4. $resolverContext = new EntityResolverContext($context, $request, $this->categoryDefinition, $category);
  6. $pages = $this->cmsPageLoader->load(
  7. $request,
  8. $this->createCriteria($pageId, $request),
  9. $context,
  10. $slotConfig,
  11. $resolverContext
in vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php -> load (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> trace (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> get (line 73)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  7. $name = self::buildName($navigationId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  11. $item->tag($this->generateTags($navigationId, $response, $request, $context));
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php :: trace (line 62)
  1. {
  2. if (Feature::isActive('cache_rework')) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. return Profiler::trace('category-route', function () use ($navigationId, $request, $context) {
  7. if ($context->hasState(...$this->states)) {
  8. return $this->getDecorated()->load($navigationId, $request, $context);
  9. }
  11. $key = $this->generateKey($navigationId, $request, $context);
CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext)) in custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php (line 46)
  1. return $this->inner;
  2. }
  4. public function load(string $navigationId, Request $request, SalesChannelContext $context): CategoryRouteResponse
  5. {
  6. $response = $this->inner->load($navigationId, $request, $context);
  8. $route = $request->attributes->get('_route');
  10. if (!\is_string($route) || empty($route)) {
  11. return $response;
in vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php -> load (line 41)
  1. $page = NavigationPage::createFrom($page);
  3. $navigationId = $request->attributes->get('navigationId', $context->getSalesChannel()->getNavigationCategoryId());
  5. $category = $this->cmsPageRoute
  6. ->load($navigationId, $request, $context)
  7. ->getCategory();
  9. if (!$category->getActive()) {
  10. throw CategoryException::categoryNotFound($category->getId());
  11. }
in vendor/shopware/storefront/Controller/NavigationController.php -> load (line 69)
  1. defaults: ['_httpCache' => true],
  2. methods: ['GET'],
  3. )]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->navigationPageLoader->load($request, $context);
  8. $this->hook(new NavigationPageLoadedHook($page, $context));
  10. $category = $page->getCategory();
  11. \assert($category !== null);
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/Listing/ProductListingLoader.php -> search (line 344)
  1. private function resolveData(Criteria $criteria, array $mapping, SalesChannelContext $context): EntitySearchResult
  2. {
  3. $read = $criteria->cloneForRead(array_values($mapping));
  4. $read->addAssociation('options.group');
  6. return $this->productRepository->search($read, $context);
  7. }
  8. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> resolveData (line 101)
  1. return $result;
  2. }
  4. $mapping = $this->resolvePreviews($ids, $clone, $context);
  6. $productSearchResult = $this->resolveData($clone, $mapping, $context);
  8. $this->addExtensions($idResult, $productSearchResult, $mapping);
  10. $result = new EntitySearchResult(ProductDefinition::ENTITY_NAME, $idResult->getTotal(), $productSearchResult->getEntities(), $aggregations, $criteria, $context->getContext());
  11. $result->addState(...$idResult->getStates());
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> _load (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php -> publish (line 57)
  1. * @return EntitySearchResult<ProductCollection>
  2. */
  3. public function load(Criteria $origin, SalesChannelContext $context): EntitySearchResult
  4. {
  5. // allows full service decoration
  6. return $this->extensions->publish(
  7. name: ResolveListingExtension::NAME,
  8. extension: new ResolveListingExtension($origin, $context),
  9. function: $this->_load(...)
  10. );
  11. }
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php -> load (line 81)
  2. return $criteria;
  3. }
  4. );
  6. $entities = $this->listingLoader->load($criteria, $context);
  8. $result = ProductListingResult::createFrom($entities);
  9. $result->addState(...$entities->getStates());
  11. $result->setStreamId($category->get('productStreamId'));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php -> load (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> trace (line 69)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  4. $name = self::buildName($categoryId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  8. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Product\SalesChannel\Listing\{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/Listing/CachedProductListingRoute.php -> get (line 66)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($categoryId, $request, $context, $criteria) {
  7. $name = self::buildName($categoryId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($categoryId, $request, $context, $criteria));
  11. $item->tag($this->generateTags($categoryId, $request, $response, $context, $criteria));
in vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php -> load (line 45)
  2. $this->eventDispatcher->dispatch(
  3. new ProductListingCriteriaEvent($request, $criteria, $context)
  4. );
  6. $response = $this->getDecorated()->load($categoryId, $request, $context, $criteria);
  8. $response->getResult()->addCurrentFilter('navigationId', $categoryId);
  10. $this->processor->process($request, $response->getResult(), $context);
in vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php -> load (line 77)
  2. $criteria = new Criteria();
  3. $criteria->setTitle('cms::product-listing');
  5. $listing = $this->listingRoute
  6. ->load($navigationId, $request, $context, $criteria)
  7. ->getResult();
  9. $data->setListing($listing);
  10. }
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> enrich (line 138)
  1. $result = new ElementDataCollection();
  3. $this->mapSearchResults($result, $slot, $criteriaList, $criteriaResult);
  4. $this->mapEntities($result, $slot, $criteriaList, $identifierResult);
  6. $resolver->enrich($slot, $resolverContext, $result);
  8. // replace with return value from enrich(), because it's allowed to change the entity type
  9. $slots->set($slotId, $slot);
  10. }
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> enrichCmsSlots (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 67)
  2. // fetch data from storage
  3. $identifierResult = $this->fetchByIdentifier($directReads, $resolverContext->getSalesChannelContext());
  4. $criteriaResult = $this->fetchByCriteria($searches, $resolverContext->getSalesChannelContext());
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataEnrichExtension::NAME,
  8. extension: new CmsSlotsDataEnrichExtension(
  9. slots: $slots,
  10. criteriaList: $criteriaList,
  11. identifierResult: $identifierResult,
in vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php -> __resolve (line 44)
  1. public function publish(string $name, Extension $extension, callable $function): mixed
  2. {
  3. $this->dispatcher->dispatch($extension, self::pre($name));
  5. if (!$extension->isPropagationStopped()) {
  6. $extension->result = $function(...$extension->getParams());
  7. }
  9. $extension->resetPropagation();
  11. $this->dispatcher->dispatch($extension, self::post($name));
in vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php -> publish (line 82)
  1. );
  2. }
  4. public function resolve(CmsSlotCollection $slots, ResolverContext $resolverContext): CmsSlotCollection
  5. {
  6. return $this->extensions->publish(
  7. name: CmsSlotsDataResolveExtension::NAME,
  8. extension: new CmsSlotsDataResolveExtension($slots, $resolverContext),
  9. function: $this->__resolve(...),
  10. );
  11. }
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> resolve (line 112)
  1. }
  3. private function loadSlotData(CmsSectionCollection $sections, ResolverContext $resolverContext): void
  4. {
  5. $blocks = $sections->getBlocks();
  6. $slots = $this->slotDataResolver->resolve($blocks->getSlots(), $resolverContext);
  8. $blocks->setSlots($slots);
  9. }
  11. /**
in vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php -> loadSlotData (line 99)
  2. // step 4, overwrite slot config
  3. $this->overwriteSlotConfig($sections, $overwrite);
  5. // step 5, resolve slot data
  6. $this->loadSlotData($sections, $resolverContext);
  7. }
  9. $this->dispatcher->dispatch(new CmsPageLoadedEvent($request, $pages, $context));
  11. $this->dispatcher->dispatch(new AddCacheTagEvent(...$this->extractProductIds($pages)));
in vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php -> load (line 93)
  1. return new CategoryRouteResponse($category);
  2. }
  4. $resolverContext = new EntityResolverContext($context, $request, $this->categoryDefinition, $category);
  6. $pages = $this->cmsPageLoader->load(
  7. $request,
  8. $this->createCriteria($pageId, $request),
  9. $context,
  10. $slotConfig,
  11. $resolverContext
in vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php -> load (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/shopware/core/System/SystemConfig/SystemConfigService.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> trace (line 76)
  1. }
  3. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  4. $name = self::buildName($navigationId);
  6. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  8. $item->tag($this->generateTags($navigationId, $response, $request, $context));
  10. return CacheValueCompressor::compress($response);
  11. });
in vendor/symfony/cache-contracts/CacheTrait.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php -> get (line 73)
  2. if ($key === null) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. $value = $this->cache->get($key, function (ItemInterface $item) use ($navigationId, $request, $context) {
  7. $name = self::buildName($navigationId);
  9. $response = $this->tracer->trace($name, fn () => $this->getDecorated()->load($navigationId, $request, $context));
  11. $item->tag($this->generateTags($navigationId, $response, $request, $context));
in vendor/shopware/core/Profiling/Profiler.php -> Shopware\Core\Content\Category\SalesChannel\{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/Category/SalesChannel/CachedCategoryRoute.php :: trace (line 62)
  1. {
  2. if (Feature::isActive('cache_rework')) {
  3. return $this->getDecorated()->load($navigationId, $request, $context);
  4. }
  6. return Profiler::trace('category-route', function () use ($navigationId, $request, $context) {
  7. if ($context->hasState(...$this->states)) {
  8. return $this->getDecorated()->load($navigationId, $request, $context);
  9. }
  11. $key = $this->generateKey($navigationId, $request, $context);
CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext)) in custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php (line 46)
  1. return $this->inner;
  2. }
  4. public function load(string $navigationId, Request $request, SalesChannelContext $context): CategoryRouteResponse
  5. {
  6. $response = $this->inner->load($navigationId, $request, $context);
  8. $route = $request->attributes->get('_route');
  10. if (!\is_string($route) || empty($route)) {
  11. return $response;
in vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php -> load (line 41)
  1. $page = NavigationPage::createFrom($page);
  3. $navigationId = $request->attributes->get('navigationId', $context->getSalesChannel()->getNavigationCategoryId());
  5. $category = $this->cmsPageRoute
  6. ->load($navigationId, $request, $context)
  7. ->getCategory();
  9. if (!$category->getActive()) {
  10. throw CategoryException::categoryNotFound($category->getId());
  11. }
in vendor/shopware/storefront/Controller/NavigationController.php -> load (line 69)
  1. defaults: ['_httpCache' => true],
  2. methods: ['GET'],
  3. )]
  4. public function index(SalesChannelContext $context, Request $request): Response
  5. {
  6. $page = $this->navigationPageLoader->load($request, $context);
  8. $this->hook(new NavigationPageLoadedHook($page, $context));
  10. $category = $page->getCategory();
  11. \assert($category !== null);
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 15:58:31 php User Deprecated: The Shopware\Core\Service\Service bundle should be added to config/bundles.php 
{
    "exception": {}
}
INFO 15:58:31 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 15:58:31 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 15:58:31 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 15:58:31 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 15:58:31 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "eb97ba"
    },
    "request_uri": "https://floeter.mittwald2.salesmachine.biz/_profiler/eb97ba?panel=exception&type=request",
    "method": "GET"
}
DEBUG 15:58:31 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 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 15:58:31 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 15:58:31 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 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\FragmentListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::startSession". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::startSession"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\RouteParamsCleanupListener::__invoke". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteParamsCleanupListener::__invoke"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Twig\TwigDateRequestListener::onKernelRequest". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Twig\\TwigDateRequestListener::onKernelRequest"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\CoreSubscriber::initializeCspNonce". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\CoreSubscriber::initializeCspNonce"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::maintenanceResolver". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::maintenanceResolver"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Storefront\Theme\Twig\ThemeNamespaceHierarchyBuilder::requestEvent". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Storefront\\Theme\\Twig\\ThemeNamespaceHierarchyBuilder::requestEvent"
}
DEBUG 15:58:31 event Notified event "kernel.request" to listener "Shopware\Core\Framework\Routing\RouteEventSubscriber::request". 
{
    "event": "kernel.request",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteEventSubscriber::request"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController". 
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 15:58:31 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 15:58:31 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 15:58:31 event Notified event "kernel.controller" to listener "Swag\PayPal\Checkout\ExpressCheckout\ExpressCheckoutSubscriber::mapShippingCallbackContextToken". 
{
    "event": "kernel.controller",
    "listener": "Swag\\PayPal\\Checkout\\ExpressCheckout\\ExpressCheckoutSubscriber::mapShippingCallbackContextToken"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\ContextResolverListener::resolveContext". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\ContextResolverListener::resolveContext"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\RouteEventSubscriber::controller". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteEventSubscriber::controller"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Swag\PayPal\AgenticCommerce\Routing\AgentContextResolverListener::resolveContext". 
{
    "event": "kernel.controller",
    "listener": "Swag\\PayPal\\AgenticCommerce\\Routing\\AgentContextResolverListener::resolveContext"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Core\Framework\Routing\RouteScopeListener::checkScope". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Core\\Framework\\Routing\\RouteScopeListener::checkScope"
}
DEBUG 15:58:31 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 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\Routing\StorefrontSubscriber::preventPageLoadingFromXmlHttpRequest". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\Routing\\StorefrontSubscriber::preventPageLoadingFromXmlHttpRequest"
}
DEBUG 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\Captcha\CaptchaRouteListener::validateCaptcha". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\Captcha\\CaptchaRouteListener::validateCaptcha"
}
DEBUG 15:58:31 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 15:58:31 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 15:58:31 event Notified event "kernel.controller" to listener "Shopware\Storefront\Framework\AffiliateTracking\AffiliateTrackingListener::checkAffiliateTracking". 
{
    "event": "kernel.controller",
    "listener": "Shopware\\Storefront\\Framework\\AffiliateTracking\\AffiliateTrackingListener::checkAffiliateTracking"
}
DEBUG 15:58:31 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 15:58:31 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 15:58:31 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 15:58:31 event Notified event "kernel.controller_arguments" to listener "ContainerIjl1rYI\RequestPayloadValueResolverGhost8c80924::onKernelControllerArguments". 
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerIjl1rYI\\RequestPayloadValueResolverGhost8c80924::onKernelControllerArguments"
}
DEBUG 15:58:31 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-listing-route::loading::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.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`, `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 (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.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, binary string, binary string, binary string, binary string, binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16, 16, 16, 16, 16, 16))
     (vendor/doctrine/dbal/src/Connection.php:1111)
  at Doctrine\DBAL\Connection->executeQuery('-- product-listing-route::loading::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.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`, `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 (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.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, binary string, binary string, binary string, binary string, binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16, 16, 16, 16, 16, 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-listing-route::loading', 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/Listing/ProductListingLoader.php:344)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->resolveData(object(Criteria), array('0191bc8dcdec794799e85c430f736b0d' => '0191bc8dcdec794799e85c430f736b0d', '019adea16d1471758671c65b65c0e23c' => '019adea16d1471758671c65b65c0e23c', '0193da1371c773049046e2d8b36e9213' => '0193da1371c773049046e2d8b36e9213', '019c5248510c73bda77bdd219e41ed83' => '019c5248510c73bda77bdd219e41ed83', '019d0661bdc872bb877fd13df03b7a37' => '019d0661bdc872bb877fd13df03b7a37', '018ebbbbec72701b86b13a445f068b1d' => '018ebbbbec72701b86b13a445f068b1d'), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:101)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->_load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('listing-loader.resolve', object(ResolveListingExtension), object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:57)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php:81)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:66)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php:45)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php:77)
  at Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver->enrich(object(CmsSlotEntity), object(EntityResolverContext), object(ElementDataCollection))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:138)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots(object(CmsSlotCollection), array(), array(), array(), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.enrich', object(CmsSlotsDataEnrichExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:67)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.resolve', object(CmsSlotsDataResolveExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:82)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:112)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->loadSlotData(object(CmsSectionCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:99)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->load(object(Request), object(Criteria), object(SalesChannelContext), array(), object(EntityResolverContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php:93)
  at Shopware\Core\Content\Category\SalesChannel\CategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:73)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('category-route', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:62)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php:46)
  at Swag\PayPal\Checkout\ExpressCheckout\SalesChannel\ExpressCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php:41)
  at Shopware\Storefront\Page\Navigation\NavigationPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/NavigationController.php:69)
  at Shopware\Storefront\Controller\NavigationController->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-listing-route::loading::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.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`, `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 (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.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, binary string, binary string, binary string, binary string, binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16, 16, 16, 16, 16, 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-listing-route::loading', 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/Listing/ProductListingLoader.php:344)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->resolveData(object(Criteria), array('0191bc8dcdec794799e85c430f736b0d' => '0191bc8dcdec794799e85c430f736b0d', '019adea16d1471758671c65b65c0e23c' => '019adea16d1471758671c65b65c0e23c', '0193da1371c773049046e2d8b36e9213' => '0193da1371c773049046e2d8b36e9213', '019c5248510c73bda77bdd219e41ed83' => '019c5248510c73bda77bdd219e41ed83', '019d0661bdc872bb877fd13df03b7a37' => '019d0661bdc872bb877fd13df03b7a37', '018ebbbbec72701b86b13a445f068b1d' => '018ebbbbec72701b86b13a445f068b1d'), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:101)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->_load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('listing-loader.resolve', object(ResolveListingExtension), object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:57)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php:81)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:66)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php:45)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php:77)
  at Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver->enrich(object(CmsSlotEntity), object(EntityResolverContext), object(ElementDataCollection))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:138)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots(object(CmsSlotCollection), array(), array(), array(), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.enrich', object(CmsSlotsDataEnrichExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:67)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.resolve', object(CmsSlotsDataResolveExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:82)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:112)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->loadSlotData(object(CmsSectionCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:99)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->load(object(Request), object(Criteria), object(SalesChannelContext), array(), object(EntityResolverContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php:93)
  at Shopware\Core\Content\Category\SalesChannel\CategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:73)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('category-route', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:62)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php:46)
  at Swag\PayPal\Checkout\ExpressCheckout\SalesChannel\ExpressCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php:41)
  at Shopware\Storefront\Page\Navigation\NavigationPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/NavigationController.php:69)
  at Shopware\Storefront\Controller\NavigationController->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-listing-route::loading::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.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`, `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 (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.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, binary string, binary string, binary string, binary string, binary string, binary string), array(2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 16, 16, 16, 16, 16, 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-listing-route::loading', 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/Listing/ProductListingLoader.php:344)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->resolveData(object(Criteria), array('0191bc8dcdec794799e85c430f736b0d' => '0191bc8dcdec794799e85c430f736b0d', '019adea16d1471758671c65b65c0e23c' => '019adea16d1471758671c65b65c0e23c', '0193da1371c773049046e2d8b36e9213' => '0193da1371c773049046e2d8b36e9213', '019c5248510c73bda77bdd219e41ed83' => '019c5248510c73bda77bdd219e41ed83', '019d0661bdc872bb877fd13df03b7a37' => '019d0661bdc872bb877fd13df03b7a37', '018ebbbbec72701b86b13a445f068b1d' => '018ebbbbec72701b86b13a445f068b1d'), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:101)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->_load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('listing-loader.resolve', object(ResolveListingExtension), object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingLoader.php:57)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingLoader->load(object(Criteria), object(SalesChannelContext))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ProductListingRoute.php:81)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', 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-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('product-listing-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:69)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->Shopware\Core\Content\Product\SalesChannel\Listing\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('product-listing-route-018ebbbbd039724092de1db39aa0bb7f-d5bf2b6d4417064471121a4d6ba1384d', object(Closure))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/CachedProductListingRoute.php:66)
  at Shopware\Core\Content\Product\SalesChannel\Listing\CachedProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/SalesChannel/Listing/ResolveCriteriaProductListingRoute.php:45)
  at Shopware\Core\Content\Product\SalesChannel\Listing\ResolveCriteriaProductListingRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext), object(Criteria))
     (vendor/shopware/core/Content/Product/Cms/ProductListingCmsElementResolver.php:77)
  at Shopware\Core\Content\Product\Cms\ProductListingCmsElementResolver->enrich(object(CmsSlotEntity), object(EntityResolverContext), object(ElementDataCollection))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:138)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->enrichCmsSlots(object(CmsSlotCollection), array(), array(), array(), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.enrich', object(CmsSlotsDataEnrichExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:67)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->__resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Framework/Extensions/ExtensionDispatcher.php:44)
  at Shopware\Core\Framework\Extensions\ExtensionDispatcher->publish('cms-slots-data.resolve', object(CmsSlotsDataResolveExtension), object(Closure))
     (vendor/shopware/core/Content/Cms/DataResolver/CmsSlotsDataResolver.php:82)
  at Shopware\Core\Content\Cms\DataResolver\CmsSlotsDataResolver->resolve(object(CmsSlotCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:112)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->loadSlotData(object(CmsSectionCollection), object(EntityResolverContext))
     (vendor/shopware/core/Content/Cms/SalesChannel/SalesChannelCmsPageLoader.php:99)
  at Shopware\Core\Content\Cms\SalesChannel\SalesChannelCmsPageLoader->load(object(Request), object(Criteria), object(SalesChannelContext), array(), object(EntityResolverContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CategoryRoute.php:93)
  at Shopware\Core\Content\Category\SalesChannel\CategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/System/SystemConfig/SystemConfigService.php:451)
  at Shopware\Core\System\SystemConfig\SystemConfigService->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Framework/Adapter/Cache/CacheTracer.php:35)
  at Shopware\Core\Framework\Adapter\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', 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('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/storefront/Framework/Cache/CacheTracer.php:35)
  at Shopware\Storefront\Framework\Cache\CacheTracer->trace('category-route-018ebbbbd039724092de1db39aa0bb7f', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:76)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}(object(CacheItem), true)
     (vendor/symfony/cache-contracts/CacheTrait.php:64)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->doGet(object(CacheDecorator), 'category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure), 1.0, array())
     (vendor/symfony/cache-contracts/CacheTrait.php:30)
  at Shopware\Core\Framework\Adapter\Cache\CacheDecorator->get('category-route-018ebbbbd039724092de1db39aa0bb7f-202903f95e2b3ab04276e9bfbd56cbbf', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:73)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->Shopware\Core\Content\Category\SalesChannel\{closure}()
     (vendor/shopware/core/Profiling/Profiler.php:67)
  at Shopware\Core\Profiling\Profiler::trace('category-route', object(Closure))
     (vendor/shopware/core/Content/Category/SalesChannel/CachedCategoryRoute.php:62)
  at Shopware\Core\Content\Category\SalesChannel\CachedCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (custom/plugins/SwagPayPal/src/Checkout/ExpressCheckout/SalesChannel/ExpressCategoryRoute.php:46)
  at Swag\PayPal\Checkout\ExpressCheckout\SalesChannel\ExpressCategoryRoute->load('018ebbbbd039724092de1db39aa0bb7f', object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Page/Navigation/NavigationPageLoader.php:41)
  at Shopware\Storefront\Page\Navigation\NavigationPageLoader->load(object(Request), object(SalesChannelContext))
     (vendor/shopware/storefront/Controller/NavigationController.php:69)
  at Shopware\Storefront\Controller\NavigationController->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)