Symfony Profiler

Query Metrics

12.00 ms Query Time

1 Node(s)

28 Indices

Queries

#▲ Execution Time Info

6.49 ms

#▲	Execution Time	Info
1	6.49 ms	Request: {"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"13f9896df61279c928f19721878fac41"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 20 View formatted request View formatted response View query backtrace POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "13f9896df61279c928f19721878fac41" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "sales": { "order": "DESC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 12, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 20, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "shopware6-stage_product_1725967126", "_id": "7d411dca7348327b71e894c52e76eeeb", "_score": null, "_source": { "id": "7d411dca7348327b71e894c52e76eeeb", "autoIncrement": 81640.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 5, "productNumber": "4507", "ean": "4043197346328", "displayGroup": "fdf6d41d936cd0c25a05944acc9fc36b", "sales": 2, "stock": 5, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4104191517", "releaseDate": null, "createdAt": "2023-10-16T11:12:11+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "b9b891c67fc2de021ec4a3407ed1980c", "coverId": "f21ba046a778c5d7fa77528e2d1125d6", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "acb353354acaee3cb567120cb31a568d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm" } } ], "options": [ { "id": "acb353354acaee3cb567120cb31a568d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "acb353354acaee3cb567120cb31a568d" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "acb353354acaee3cb567120cb31a568d" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 4506.1, "product_vk2_amazon": 129.95, "product_vk3_ebay": 129.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex City i-vo all black" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 109.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 92.39 }, "fields": { "displayGroup": [ "fdf6d41d936cd0c25a05944acc9fc36b" ] }, "sort": [ 2, "7d411dca7348327b71e894c52e76eeeb" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "034e2db715b4e796a5e72861ce06963a", "_score": null, "_source": { "id": "034e2db715b4e796a5e72861ce06963a", "autoIncrement": 81718.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 0, "productNumber": "6550", "ean": "4003318614651", "displayGroup": "572081a09e2a4c1401b19cc491c2e672", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "61465", "releaseDate": null, "createdAt": "2023-10-16T11:12:14+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "496d67932fe78c90a3877e91f95fc379", "coverId": "6515c1687355f4f7d0a9fec2e1e4e439", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "b572df75cd52949fa9f60b5c3a80adac", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-61 cm" } } ], "options": [ { "id": "b572df75cd52949fa9f60b5c3a80adac", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-61 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "b572df75cd52949fa9f60b5c3a80adac" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "b572df75cd52949fa9f60b5c3a80adac" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 0.0, "product_store_available": 0.0, "product_parent_article": 6550.1, "product_vk2_amazon": 79.95, "product_vk3_ebay": 79.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Hyban 2.0 LED signal silver" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 20.01, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 20.01 }, "fields": { "displayGroup": [ "572081a09e2a4c1401b19cc491c2e672" ] }, "sort": [ 0, "034e2db715b4e796a5e72861ce06963a" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "124461dcd3571e6674ec4e0e140cc298", "_score": null, "_source": { "id": "124461dcd3571e6674ec4e0e140cc298", "autoIncrement": 81639.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 17, "productNumber": "4504", "ean": "4043197346298", "displayGroup": "dd2bd6f59c0ef976870a163175275d03", "sales": 0, "stock": 17, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4104191415", "releaseDate": null, "createdAt": "2023-10-16T11:12:11+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "814dcb6ae01965819da91076f8609f86", "coverId": "108019a027e37a67794b10b858defe16", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "options": [ { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "795995d1c59b90ec89199aacd3cd42e7" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "795995d1c59b90ec89199aacd3cd42e7" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 4504.1, "product_vk2_amazon": 59.95, "product_vk3_ebay": 59.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex city i-vo white-black" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 109.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 92.39 }, "fields": { "displayGroup": [ "dd2bd6f59c0ef976870a163175275d03" ] }, "sort": [ 0, "124461dcd3571e6674ec4e0e140cc298" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "12bcd658ef0a540cabc36cdf2b1046fd", "_score": null, "_source": { "id": "12bcd658ef0a540cabc36cdf2b1046fd", "autoIncrement": 81713.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 0, "productNumber": "6543", "ean": "4003318669477", "displayGroup": "491e992cb7bb9585170eea5b498612d4", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "66947", "releaseDate": null, "createdAt": "2023-10-16T11:12:14+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "457a49e746adf97be9d9a7a809a2eda9", "coverId": "6448894594949216b3bcc7bb292a916f", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "fe6425c6c2ec15b60f53b9bddf404fb8", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "54-58 cm" } } ], "options": [ { "id": "fe6425c6c2ec15b60f53b9bddf404fb8", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "54-58 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "fe6425c6c2ec15b60f53b9bddf404fb8" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "fe6425c6c2ec15b60f53b9bddf404fb8" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 0.0, "product_store_available": 0.0, "product_parent_article": 6543.1, "product_vk2_amazon": 149.95, "product_vk3_ebay": 149.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus HUD-Y titan" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 149.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 126.01 }, "fields": { "displayGroup": [ "491e992cb7bb9585170eea5b498612d4" ] }, "sort": [ 0, "12bcd658ef0a540cabc36cdf2b1046fd" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "2a8a812400df8963b2e2ac0ed01b07b8", "_score": null, "_source": { "id": "2a8a812400df8963b2e2ac0ed01b07b8", "autoIncrement": 81557.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 10, "productNumber": "2231", "ean": "4003318819131", "displayGroup": "10d997bb004fefbf3cabcaf93f521406", "sales": 0, "stock": 10, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "81913", "releaseDate": null, "createdAt": "2023-10-16T11:12:09+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "5f174710116c5341c2e076618b236ba7", "coverId": "c9ae1c548e95ced6c611b0751a1058f4", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "8afd504fbe5a997ddadaf8a0a2f1580a", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-62 cm" } } ], "options": [ { "id": "8afd504fbe5a997ddadaf8a0a2f1580a", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-62 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "8afd504fbe5a997ddadaf8a0a2f1580a" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "8afd504fbe5a997ddadaf8a0a2f1580a" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 2221.1, "product_vk2_amazon": 49.95, "product_vk3_ebay": 49.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Pedelec 2.0 velvet black" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 179.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 151.22 }, "fields": { "displayGroup": [ "10d997bb004fefbf3cabcaf93f521406" ] }, "sort": [ 0, "2a8a812400df8963b2e2ac0ed01b07b8" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "395db788289ee286662bbcabe78d99da", "_score": null, "_source": { "id": "395db788289ee286662bbcabe78d99da", "autoIncrement": 81888.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 2, "productNumber": "13147", "ean": "4043197336213", "displayGroup": "901879ff4d3f90db01a9a441efc54393", "sales": 0, "stock": 2, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4106120215", "releaseDate": null, "createdAt": "2023-10-16T11:12:23+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "5e625635e478849146b371458bbd5621", "coverId": "53b9ee3cf70830da736583bd0369b358", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "options": [ { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "795995d1c59b90ec89199aacd3cd42e7" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "795995d1c59b90ec89199aacd3cd42e7" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 13147.1, "product_vk2_amazon": 129.95, "product_vk3_ebay": 129.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex City I-vo MIPS titan" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 139.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 117.61 }, "fields": { "displayGroup": [ "901879ff4d3f90db01a9a441efc54393" ] }, "sort": [ 0, "395db788289ee286662bbcabe78d99da" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "46cf745606c655fd6e0b3e199873022e", "_score": null, "_source": { "id": "46cf745606c655fd6e0b3e199873022e", "autoIncrement": 81893.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 0, "productNumber": "13214", "ean": "4003318869297", "displayGroup": "24288752fb0754ba56317e696e19d3eb", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "86929", "releaseDate": null, "createdAt": "2023-10-16T11:12:23+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "a7ac0a75385e34245d135df395f3eed8", "coverId": "8abf2f18defc685dda4d7f5cf1afa71f", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "5b8fa71396ee23af2a935beb1323a788", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-58 cm" } } ], "options": [ { "id": "5b8fa71396ee23af2a935beb1323a788", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-58 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "5b8fa71396ee23af2a935beb1323a788" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "5b8fa71396ee23af2a935beb1323a788" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 0.0, "product_store_available": 0.0, "product_parent_article": 13214.1, "product_vk2_amazon": 79.95, "product_vk3_ebay": 79.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Hyban 2.0 glacier blue" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 67.18 }, "fields": { "displayGroup": [ "24288752fb0754ba56317e696e19d3eb" ] }, "sort": [ 0, "46cf745606c655fd6e0b3e199873022e" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "51f15efdd170e6043fa02a74882f0470", "_score": null, "_source": { "id": "51f15efdd170e6043fa02a74882f0470", "autoIncrement": 81697.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 2, "productNumber": "6477", "ean": "4003318868658", "displayGroup": "5b79878dea228acc6628d228a2b467e8", "sales": 0, "stock": 2, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "86865", "releaseDate": null, "createdAt": "2023-10-16T11:12:14+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "c8318e111d59177774b0c43e5f65c05d", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "68241d636cd3db75d23a32d33c06efaf", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm" } } ], "options": [ { "id": "68241d636cd3db75d23a32d33c06efaf", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "68241d636cd3db75d23a32d33c06efaf" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "68241d636cd3db75d23a32d33c06efaf" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 6477.0, "product_vk2_amazon": 149.95, "product_vk3_ebay": 149.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Urban-I 3.0 titan" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99 }, "fields": { "displayGroup": [ "5b79878dea228acc6628d228a2b467e8" ] }, "sort": [ 0, "51f15efdd170e6043fa02a74882f0470" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "90fd26a243f6d14c4b3df082cdc8da66", "_score": null, "_source": { "id": "90fd26a243f6d14c4b3df082cdc8da66", "autoIncrement": 81706.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 0, "productNumber": "6533", "ean": "4003318673412", "displayGroup": "5e93a6924e574bfbdbfa42a92335ab2e", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "67341", "releaseDate": null, "createdAt": "2023-10-16T11:12:14+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "fd54ec4143349e97fa1f683a9a75c7bb", "coverId": "543261ba9c3e320da4bc460ca0872944", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "options": [ { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "795995d1c59b90ec89199aacd3cd42e7" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "795995d1c59b90ec89199aacd3cd42e7" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 0.0, "product_store_available": 0.0, "product_parent_article": 6533.1, "product_vk2_amazon": 219.95, "product_vk3_ebay": 219.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Pedelec 2.0 ACE glacier blue" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 219.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 184.83 }, "fields": { "displayGroup": [ "5e93a6924e574bfbdbfa42a92335ab2e" ] }, "sort": [ 0, "90fd26a243f6d14c4b3df082cdc8da66" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "ab49ef78e2877bfd2c2bfa738e459bf0", "_score": null, "_source": { "id": "ab49ef78e2877bfd2c2bfa738e459bf0", "autoIncrement": 81699.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 14, "productNumber": "6476", "ean": "4003318868696", "displayGroup": "dca0b956d333ea25cc879699ae6e3f89", "sales": 0, "stock": 14, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "86869", "releaseDate": null, "createdAt": "2023-10-16T11:12:14+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "92342108454f9e04d7e8d084b1ac5485", "coverId": "612cd8ea5c2925aeb5a39f476c853d63", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "68241d636cd3db75d23a32d33c06efaf", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm" } } ], "options": [ { "id": "68241d636cd3db75d23a32d33c06efaf", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "68241d636cd3db75d23a32d33c06efaf" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "68241d636cd3db75d23a32d33c06efaf" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 6474.1, "product_vk2_amazon": 149.95, "product_vk3_ebay": 149.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Urban-I 3.0 signal yellow" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99 }, "fields": { "displayGroup": [ "dca0b956d333ea25cc879699ae6e3f89" ] }, "sort": [ 0, "ab49ef78e2877bfd2c2bfa738e459bf0" ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "d974ad2631a2a6977d640ba9d4c98bdd", "_score": null, "_source": { "id": "d974ad2631a2a6977d640ba9d4c98bdd", "autoIncrement": 81842.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "11395", "ean": "4043197346373", "displayGroup": "11d95301ca8321269864f97a6c54eef3", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4106130417", "releaseDate": null, "createdAt": "2023-10-16T11:12:20+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "13f9896df61279c928f19721878fac41" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "13f9896df61279c928f19721878fac41", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "86cd3fca9148f95ae73ee77be1a46c17", "coverId": "3657f87918f676fb09661c99cfcc2a5e", "childCount": 0, "categories": [ { "id": "13f9896df61279c928f19721878fac41", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme" } }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "acb353354acaee3cb567120cb31a568d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm" } } ], "options": [ { "id": "acb353354acaee3cb567120cb31a568d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm" } } ], "categoryIds": [ "13f9896df61279c928f19721878fac41", "35f4a8d465e6e1edc05f3d8ab658c551" ], "optionIds": [ "acb353354acaee3cb567120cb31a568d" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "acb353354acaee3cb567120cb31a568d" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 11391.1, "product_vk2_amazon": 129.95, "product_vk3_ebay": 129.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex i-vo cc MIPS dove grey" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 119.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 100.8 }, "fields": { "displayGroup": [ "11d95301ca8321269864f97a6c54eef3" ] }, "sort": [ 0, "d974ad2631a2a6977d640ba9d4c98bdd" ] } ] }, "aggregations": { "total-count": { "value": 11 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	5.71 ms	Request: {"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"13f9896df61279c928f19721878fac41"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "13f9896df61279c928f19721878fac41" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 4, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 20, "rating": { "value": 0.0 } }, "price": { "count": 20, "min": 79.95, "max": 219.95, "avg": 131.95, "sum": 2639.0 }, "options": { "doc_count": 20, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "795995d1c59b90ec89199aacd3cd42e7", "doc_count": 6 }, { "key": "acb353354acaee3cb567120cb31a568d", "doc_count": 4 }, { "key": "5b8fa71396ee23af2a935beb1323a788", "doc_count": 2 }, { "key": "68241d636cd3db75d23a32d33c06efaf", "doc_count": 2 }, { "key": "8afd504fbe5a997ddadaf8a0a2f1580a", "doc_count": 2 }, { "key": "b572df75cd52949fa9f60b5c3a80adac", "doc_count": 2 }, { "key": "c8f2e500958bdfe02d2caa6dd8eaccc3", "doc_count": 1 }, { "key": "fe6425c6c2ec15b60f53b9bddf404fb8", "doc_count": 1 } ] } }, "properties": { "doc_count": 40, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "3a616a5305e06ccc883bda3ab63b10b5", "doc_count": 20 }, { "key": "795995d1c59b90ec89199aacd3cd42e7", "doc_count": 6 }, { "key": "acb353354acaee3cb567120cb31a568d", "doc_count": 4 }, { "key": "5b8fa71396ee23af2a935beb1323a788", "doc_count": 2 }, { "key": "68241d636cd3db75d23a32d33c06efaf", "doc_count": 2 }, { "key": "8afd504fbe5a997ddadaf8a0a2f1580a", "doc_count": 2 }, { "key": "b572df75cd52949fa9f60b5c3a80adac", "doc_count": 2 }, { "key": "c8f2e500958bdfe02d2caa6dd8eaccc3", "doc_count": 1 }, { "key": "fe6425c6c2ec15b60f53b9bddf404fb8", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "4bbd9c23e810a10a299357ea4c2b94ff", "doc_count": 12 }, { "key": "113a80259eea2dabecb4f1d35f5aafb8", "doc_count": 8 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"13f9896df61279c928f19721878fac41"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

Item count: 20
View formatted request View formatted response View query backtrace


                                    POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=1&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "13f9896df61279c928f19721878fac41"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "sales": {
                "order": "DESC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 12,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 20,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "7d411dca7348327b71e894c52e76eeeb",
                "_score": null,
                "_source": {
                    "id": "7d411dca7348327b71e894c52e76eeeb",
                    "autoIncrement": 81640.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 5,
                    "productNumber": "4507",
                    "ean": "4043197346328",
                    "displayGroup": "fdf6d41d936cd0c25a05944acc9fc36b",
                    "sales": 2,
                    "stock": 5,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4104191517",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:11+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "b9b891c67fc2de021ec4a3407ed1980c",
                    "coverId": "f21ba046a778c5d7fa77528e2d1125d6",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "acb353354acaee3cb567120cb31a568d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "acb353354acaee3cb567120cb31a568d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "acb353354acaee3cb567120cb31a568d"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "acb353354acaee3cb567120cb31a568d"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 4506.1,
                            "product_vk2_amazon": 129.95,
                            "product_vk3_ebay": 129.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex City i-vo all black"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 109.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 92.39
                },
                "fields": {
                    "displayGroup": [
                        "fdf6d41d936cd0c25a05944acc9fc36b"
                    ]
                },
                "sort": [
                    2,
                    "7d411dca7348327b71e894c52e76eeeb"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "034e2db715b4e796a5e72861ce06963a",
                "_score": null,
                "_source": {
                    "id": "034e2db715b4e796a5e72861ce06963a",
                    "autoIncrement": 81718.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "6550",
                    "ean": "4003318614651",
                    "displayGroup": "572081a09e2a4c1401b19cc491c2e672",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "61465",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:14+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "496d67932fe78c90a3877e91f95fc379",
                    "coverId": "6515c1687355f4f7d0a9fec2e1e4e439",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "b572df75cd52949fa9f60b5c3a80adac",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-61 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "b572df75cd52949fa9f60b5c3a80adac",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-61 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "b572df75cd52949fa9f60b5c3a80adac"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "b572df75cd52949fa9f60b5c3a80adac"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 0.0,
                            "product_store_available": 0.0,
                            "product_parent_article": 6550.1,
                            "product_vk2_amazon": 79.95,
                            "product_vk3_ebay": 79.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Hyban 2.0 LED signal silver"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 20.01,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 20.01
                },
                "fields": {
                    "displayGroup": [
                        "572081a09e2a4c1401b19cc491c2e672"
                    ]
                },
                "sort": [
                    0,
                    "034e2db715b4e796a5e72861ce06963a"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "124461dcd3571e6674ec4e0e140cc298",
                "_score": null,
                "_source": {
                    "id": "124461dcd3571e6674ec4e0e140cc298",
                    "autoIncrement": 81639.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 17,
                    "productNumber": "4504",
                    "ean": "4043197346298",
                    "displayGroup": "dd2bd6f59c0ef976870a163175275d03",
                    "sales": 0,
                    "stock": 17,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4104191415",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:11+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "814dcb6ae01965819da91076f8609f86",
                    "coverId": "108019a027e37a67794b10b858defe16",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 4504.1,
                            "product_vk2_amazon": 59.95,
                            "product_vk3_ebay": 59.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex city i-vo white-black"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 109.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 92.39
                },
                "fields": {
                    "displayGroup": [
                        "dd2bd6f59c0ef976870a163175275d03"
                    ]
                },
                "sort": [
                    0,
                    "124461dcd3571e6674ec4e0e140cc298"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "12bcd658ef0a540cabc36cdf2b1046fd",
                "_score": null,
                "_source": {
                    "id": "12bcd658ef0a540cabc36cdf2b1046fd",
                    "autoIncrement": 81713.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "6543",
                    "ean": "4003318669477",
                    "displayGroup": "491e992cb7bb9585170eea5b498612d4",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "66947",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:14+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "457a49e746adf97be9d9a7a809a2eda9",
                    "coverId": "6448894594949216b3bcc7bb292a916f",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "fe6425c6c2ec15b60f53b9bddf404fb8",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "54-58 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "fe6425c6c2ec15b60f53b9bddf404fb8",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "54-58 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "fe6425c6c2ec15b60f53b9bddf404fb8"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "fe6425c6c2ec15b60f53b9bddf404fb8"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 0.0,
                            "product_store_available": 0.0,
                            "product_parent_article": 6543.1,
                            "product_vk2_amazon": 149.95,
                            "product_vk3_ebay": 149.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus HUD-Y titan"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 149.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 126.01
                },
                "fields": {
                    "displayGroup": [
                        "491e992cb7bb9585170eea5b498612d4"
                    ]
                },
                "sort": [
                    0,
                    "12bcd658ef0a540cabc36cdf2b1046fd"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "2a8a812400df8963b2e2ac0ed01b07b8",
                "_score": null,
                "_source": {
                    "id": "2a8a812400df8963b2e2ac0ed01b07b8",
                    "autoIncrement": 81557.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "2231",
                    "ean": "4003318819131",
                    "displayGroup": "10d997bb004fefbf3cabcaf93f521406",
                    "sales": 0,
                    "stock": 10,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "81913",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:09+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "5f174710116c5341c2e076618b236ba7",
                    "coverId": "c9ae1c548e95ced6c611b0751a1058f4",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "8afd504fbe5a997ddadaf8a0a2f1580a",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-62 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "8afd504fbe5a997ddadaf8a0a2f1580a",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-62 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "8afd504fbe5a997ddadaf8a0a2f1580a"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "8afd504fbe5a997ddadaf8a0a2f1580a"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 2221.1,
                            "product_vk2_amazon": 49.95,
                            "product_vk3_ebay": 49.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Pedelec 2.0 velvet black"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 179.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 151.22
                },
                "fields": {
                    "displayGroup": [
                        "10d997bb004fefbf3cabcaf93f521406"
                    ]
                },
                "sort": [
                    0,
                    "2a8a812400df8963b2e2ac0ed01b07b8"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "395db788289ee286662bbcabe78d99da",
                "_score": null,
                "_source": {
                    "id": "395db788289ee286662bbcabe78d99da",
                    "autoIncrement": 81888.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "13147",
                    "ean": "4043197336213",
                    "displayGroup": "901879ff4d3f90db01a9a441efc54393",
                    "sales": 0,
                    "stock": 2,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4106120215",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:23+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "5e625635e478849146b371458bbd5621",
                    "coverId": "53b9ee3cf70830da736583bd0369b358",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 13147.1,
                            "product_vk2_amazon": 129.95,
                            "product_vk3_ebay": 129.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex City I-vo MIPS titan"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 139.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 117.61
                },
                "fields": {
                    "displayGroup": [
                        "901879ff4d3f90db01a9a441efc54393"
                    ]
                },
                "sort": [
                    0,
                    "395db788289ee286662bbcabe78d99da"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "46cf745606c655fd6e0b3e199873022e",
                "_score": null,
                "_source": {
                    "id": "46cf745606c655fd6e0b3e199873022e",
                    "autoIncrement": 81893.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "13214",
                    "ean": "4003318869297",
                    "displayGroup": "24288752fb0754ba56317e696e19d3eb",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "86929",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:23+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "a7ac0a75385e34245d135df395f3eed8",
                    "coverId": "8abf2f18defc685dda4d7f5cf1afa71f",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "5b8fa71396ee23af2a935beb1323a788",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-58 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "5b8fa71396ee23af2a935beb1323a788",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-58 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "5b8fa71396ee23af2a935beb1323a788"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "5b8fa71396ee23af2a935beb1323a788"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 0.0,
                            "product_store_available": 0.0,
                            "product_parent_article": 13214.1,
                            "product_vk2_amazon": 79.95,
                            "product_vk3_ebay": 79.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Hyban 2.0 glacier blue"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 67.18
                },
                "fields": {
                    "displayGroup": [
                        "24288752fb0754ba56317e696e19d3eb"
                    ]
                },
                "sort": [
                    0,
                    "46cf745606c655fd6e0b3e199873022e"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "51f15efdd170e6043fa02a74882f0470",
                "_score": null,
                "_source": {
                    "id": "51f15efdd170e6043fa02a74882f0470",
                    "autoIncrement": 81697.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "6477",
                    "ean": "4003318868658",
                    "displayGroup": "5b79878dea228acc6628d228a2b467e8",
                    "sales": 0,
                    "stock": 2,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "86865",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:14+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "c8318e111d59177774b0c43e5f65c05d",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "68241d636cd3db75d23a32d33c06efaf",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "68241d636cd3db75d23a32d33c06efaf",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "68241d636cd3db75d23a32d33c06efaf"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "68241d636cd3db75d23a32d33c06efaf"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 6477.0,
                            "product_vk2_amazon": 149.95,
                            "product_vk3_ebay": 149.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Urban-I 3.0 titan"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99
                },
                "fields": {
                    "displayGroup": [
                        "5b79878dea228acc6628d228a2b467e8"
                    ]
                },
                "sort": [
                    0,
                    "51f15efdd170e6043fa02a74882f0470"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "90fd26a243f6d14c4b3df082cdc8da66",
                "_score": null,
                "_source": {
                    "id": "90fd26a243f6d14c4b3df082cdc8da66",
                    "autoIncrement": 81706.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "6533",
                    "ean": "4003318673412",
                    "displayGroup": "5e93a6924e574bfbdbfa42a92335ab2e",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "67341",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:14+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "fd54ec4143349e97fa1f683a9a75c7bb",
                    "coverId": "543261ba9c3e320da4bc460ca0872944",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 0.0,
                            "product_store_available": 0.0,
                            "product_parent_article": 6533.1,
                            "product_vk2_amazon": 219.95,
                            "product_vk3_ebay": 219.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Pedelec 2.0 ACE glacier blue"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 219.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 184.83
                },
                "fields": {
                    "displayGroup": [
                        "5e93a6924e574bfbdbfa42a92335ab2e"
                    ]
                },
                "sort": [
                    0,
                    "90fd26a243f6d14c4b3df082cdc8da66"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "ab49ef78e2877bfd2c2bfa738e459bf0",
                "_score": null,
                "_source": {
                    "id": "ab49ef78e2877bfd2c2bfa738e459bf0",
                    "autoIncrement": 81699.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 14,
                    "productNumber": "6476",
                    "ean": "4003318868696",
                    "displayGroup": "dca0b956d333ea25cc879699ae6e3f89",
                    "sales": 0,
                    "stock": 14,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "86869",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:14+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "92342108454f9e04d7e8d084b1ac5485",
                    "coverId": "612cd8ea5c2925aeb5a39f476c853d63",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "68241d636cd3db75d23a32d33c06efaf",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "68241d636cd3db75d23a32d33c06efaf",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "61-65 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "68241d636cd3db75d23a32d33c06efaf"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "68241d636cd3db75d23a32d33c06efaf"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 6474.1,
                            "product_vk2_amazon": 149.95,
                            "product_vk3_ebay": 149.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Urban-I 3.0 signal yellow"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 83.99
                },
                "fields": {
                    "displayGroup": [
                        "dca0b956d333ea25cc879699ae6e3f89"
                    ]
                },
                "sort": [
                    0,
                    "ab49ef78e2877bfd2c2bfa738e459bf0"
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "d974ad2631a2a6977d640ba9d4c98bdd",
                "_score": null,
                "_source": {
                    "id": "d974ad2631a2a6977d640ba9d4c98bdd",
                    "autoIncrement": 81842.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "11395",
                    "ean": "4043197346373",
                    "displayGroup": "11d95301ca8321269864f97a6c54eef3",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4106130417",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:20+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "13f9896df61279c928f19721878fac41"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "86cd3fca9148f95ae73ee77be1a46c17",
                    "coverId": "3657f87918f676fb09661c99cfcc2a5e",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "13f9896df61279c928f19721878fac41",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City- & Trekkinghelme"
                            }
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "acb353354acaee3cb567120cb31a568d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "acb353354acaee3cb567120cb31a568d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "56-60 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "13f9896df61279c928f19721878fac41",
                        "35f4a8d465e6e1edc05f3d8ab658c551"
                    ],
                    "optionIds": [
                        "acb353354acaee3cb567120cb31a568d"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "acb353354acaee3cb567120cb31a568d"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 11391.1,
                            "product_vk2_amazon": 129.95,
                            "product_vk3_ebay": 129.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex i-vo cc MIPS dove grey"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 119.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 100.8
                },
                "fields": {
                    "displayGroup": [
                        "11d95301ca8321269864f97a6c54eef3"
                    ]
                },
                "sort": [
                    0,
                    "d974ad2631a2a6977d640ba9d4c98bdd"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 11
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

5.71 ms

Request:

{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"13f9896df61279c928f19721878fac41"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}

Item count:
View formatted request View formatted response View query backtrace


                                    POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "13f9896df61279c928f19721878fac41"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                }
            }
        },
        "rating-exists": {
            "filter": {
                "range": {
                    "ratingAverage": {
                        "gte": 0.0
                    }
                }
            },
            "aggregations": {
                "rating": {
                    "max": {
                        "field": "ratingAverage"
                    }
                }
            }
        },
        "shipping-free-filter": {
            "filter": {
                "term": {
                    "shippingFree": true
                }
            },
            "aggregations": {
                "shipping-free": {
                    "max": {
                        "field": "shippingFree"
                    }
                }
            }
        },
        "properties": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    }
                }
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 4,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 20,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 20,
            "min": 79.95,
            "max": 219.95,
            "avg": 131.95,
            "sum": 2639.0
        },
        "options": {
            "doc_count": 20,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "795995d1c59b90ec89199aacd3cd42e7",
                        "doc_count": 6
                    },
                    {
                        "key": "acb353354acaee3cb567120cb31a568d",
                        "doc_count": 4
                    },
                    {
                        "key": "5b8fa71396ee23af2a935beb1323a788",
                        "doc_count": 2
                    },
                    {
                        "key": "68241d636cd3db75d23a32d33c06efaf",
                        "doc_count": 2
                    },
                    {
                        "key": "8afd504fbe5a997ddadaf8a0a2f1580a",
                        "doc_count": 2
                    },
                    {
                        "key": "b572df75cd52949fa9f60b5c3a80adac",
                        "doc_count": 2
                    },
                    {
                        "key": "c8f2e500958bdfe02d2caa6dd8eaccc3",
                        "doc_count": 1
                    },
                    {
                        "key": "fe6425c6c2ec15b60f53b9bddf404fb8",
                        "doc_count": 1
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 40,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "3a616a5305e06ccc883bda3ab63b10b5",
                        "doc_count": 20
                    },
                    {
                        "key": "795995d1c59b90ec89199aacd3cd42e7",
                        "doc_count": 6
                    },
                    {
                        "key": "acb353354acaee3cb567120cb31a568d",
                        "doc_count": 4
                    },
                    {
                        "key": "5b8fa71396ee23af2a935beb1323a788",
                        "doc_count": 2
                    },
                    {
                        "key": "68241d636cd3db75d23a32d33c06efaf",
                        "doc_count": 2
                    },
                    {
                        "key": "8afd504fbe5a997ddadaf8a0a2f1580a",
                        "doc_count": 2
                    },
                    {
                        "key": "b572df75cd52949fa9f60b5c3a80adac",
                        "doc_count": 2
                    },
                    {
                        "key": "c8f2e500958bdfe02d2caa6dd8eaccc3",
                        "doc_count": 1
                    },
                    {
                        "key": "fe6425c6c2ec15b60f53b9bddf404fb8",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "doc_count": 12
                },
                {
                    "key": "113a80259eea2dabecb4f1d35f5aafb8",
                    "doc_count": 8
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 86,
    "active_shards": 86,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 252,
    "delayed_unassigned_shards": 0,
    "number_of_pending_tasks": 0,
    "number_of_in_flight_fetch": 0,
    "task_max_waiting_in_queue_millis": 0,
    "active_shards_percent_as_number": 25.443786982248522
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw-admin-payment-method-listing_1732606828	open	3, 3	45
shopware6-stage_product_1725962023	open	3, 3	698878
shopware6-new_product_1723452452	open	3, 3	698878
sw-admin-mollie-refund_1732606829	open	3, 3	0
shopware6-stage_product_01894ed2cf1a70659e13690a9aca16a3_1723451325	open	3, 3	411469
sw-admin-promotion-listing_1732606828	open	3, 3	9
shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325	open	3, 3	411469
sw-admin-media-listing_1732606828	open	3, 3	10049
sw-admin-product-stream-listing_1732606829	open	3, 3	7353
sw-admin-manufacturer-listing_1732606827	open	3, 3	127
sw-admin-newsletter-recipient-listing_1732606829	open	3, 3	1
sw-admin-cms-page-listing_1732606827	open	3, 3	65
sw-admin-product-listing_1732606828	open	3, 3	9462
shopware6-stage_product_1717777228	open	3, 3	698886
shopware6-stage_product_1725967126	open	3, 3	773930
sw-admin-sales-channel-listing_1732606828	open	3, 3	2
shopware6-new_product_1723451173	open	3, 3	698866
sw-admin-landing-page-listing_1732606827	open	3, 3	16
sw-admin-customer-group-listing_1732606827	open	3, 3	2
shopware6-stage_product_1725967107	open	3, 3	698878
sw-admin-category-listing_1732606829	open	3, 3	374
sw-admin-mollie-subscription_1732606829	open	3, 3	0
sw-admin-order-listing_1732606828	open	3, 3	462
shopware6-stage_product_1725958313	open	3, 3	698878
sw-admin-property-group-listing_1732606828	open	3, 3	137
sw-admin-customer-listing_1732606827	open	3, 3	133
sw-admin-shipping-method-listing_1732606828	open	3, 3	3
shopware6-stage_product_1725962160	open	3, 3	698878

Symfony Profiler

GET https://stage-sw6.radwelt-shop.de/navigation/13f9896df61279c928f19721878fac41

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices