Symfony Profiler

Query Metrics

20.00 ms Query Time

1 Node(s)

23 Indices

Queries

#▲ Execution Time Info

7.79 ms

#▲	Execution Time	Info
1	7.79 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":"35f4a8d465e6e1edc05f3d8ab658c551"}}}},{"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: 45 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": "35f4a8d465e6e1edc05f3d8ab658c551" } } } }, { "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": 4, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 45, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "shopware6-stage_product_1747130459", "_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_1747130459", "_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_1747130459", "_id": "05d341cd809694e4e44660c97c11e8e4", "_score": null, "_source": { "id": "05d341cd809694e4e44660c97c11e8e4", "autoIncrement": 81908.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 10, "productNumber": "13374", "ean": "4043197336183", "displayGroup": "df095657f936fb9c09f33020a11a6225", "sales": 0, "stock": 10, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4106100317", "releaseDate": null, "createdAt": "2023-10-16T11:12:24+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "8f121ce07d74717e0b1f21d122e04521" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "8f121ce07d74717e0b1f21d122e04521", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "a4d92c6a2e3afcedd597f962be626a91", "coverId": "8393178f1557ff5e23ebbccc27c74019", "childCount": 0, "categories": [ { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } }, { "id": "8f121ce07d74717e0b1f21d122e04521", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB-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": "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": [ "35f4a8d465e6e1edc05f3d8ab658c551", "8f121ce07d74717e0b1f21d122e04521" ], "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": 1.0, "product_store_available": 1.0, "product_parent_article": 13373.1, "product_vk2_amazon": 59.95, "product_vk3_ebay": 59.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex quatro cc MIPS all black" }, "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": [ "df095657f936fb9c09f33020a11a6225" ] }, "sort": [ 0, "05d341cd809694e4e44660c97c11e8e4" ] }, { "_index": "shopware6-stage_product_1747130459", "_id": "0868dbe2d591f3c1beb2f6dd50bdb72e", "_score": null, "_source": { "id": "0868dbe2d591f3c1beb2f6dd50bdb72e", "autoIncrement": 81829.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 3, "productNumber": "10699", "ean": "4003318879074", "displayGroup": "948841432fdda57a6c5e49f4de27254b", "sales": 0, "stock": 3, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "87907", "releaseDate": null, "createdAt": "2023-10-16T11:12:19+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "39059724f73a9969845dfe4146c5660e" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "39059724f73a9969845dfe4146c5660e", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "bbbfb9cd75cef4ae35c1fbeed063919f", "coverId": "e6c96fb3709ffcbb453ec07464490663", "childCount": 0, "categories": [ { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } }, { "id": "39059724f73a9969845dfe4146c5660e", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rennrad-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": "9588dbdcf99bb86e045638971fdb69fe", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "59-61 cm" } } ], "options": [ { "id": "9588dbdcf99bb86e045638971fdb69fe", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "59-61 cm" } } ], "categoryIds": [ "35f4a8d465e6e1edc05f3d8ab658c551", "39059724f73a9969845dfe4146c5660e" ], "optionIds": [ "9588dbdcf99bb86e045638971fdb69fe" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "9588dbdcf99bb86e045638971fdb69fe" ], "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": 10698.1, "product_vk2_amazon": 149.95, "product_vk3_ebay": 149.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus StormChaser Gravel olive green" }, "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": [ "948841432fdda57a6c5e49f4de27254b" ] }, "sort": [ 0, "0868dbe2d591f3c1beb2f6dd50bdb72e" ] }, { "_index": "shopware6-stage_product_1747130459", "_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_1747130459", "_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_1747130459", "_id": "1731592aca5fb4d789c4119c65c10b4b", "_score": null, "_source": { "id": "1731592aca5fb4d789c4119c65c10b4b", "autoIncrement": 81630.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 5, "productNumber": "4494", "ean": "4043197345413", "displayGroup": "6a32bc822ce97584b1de146d15818ba8", "sales": 0, "stock": 5, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4109671015", "releaseDate": null, "createdAt": "2023-10-16T11:12:11+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "8f121ce07d74717e0b1f21d122e04521" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "8f121ce07d74717e0b1f21d122e04521", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "dd68fc3d2444cf141d1250356c515ebe", "coverId": "66d8aea9f508375c7fa6b5bef6261ef7", "childCount": 0, "categories": [ { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } }, { "id": "8f121ce07d74717e0b1f21d122e04521", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB-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": [ "35f4a8d465e6e1edc05f3d8ab658c551", "8f121ce07d74717e0b1f21d122e04521" ], "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": 4494.1, "product_vk2_amazon": 59.95, "product_vk3_ebay": 59.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex finale 2.0 rhino-neon yellow matt" }, "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": 28.58, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 28.59 }, "fields": { "displayGroup": [ "6a32bc822ce97584b1de146d15818ba8" ] }, "sort": [ 0, "1731592aca5fb4d789c4119c65c10b4b" ] }, { "_index": "shopware6-stage_product_1747130459", "_id": "18a010d2a9813e91907ce88cd9143fdf", "_score": null, "_source": { "id": "18a010d2a9813e91907ce88cd9143fdf", "autoIncrement": 86842.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 19, "productNumber": "4277", "ean": "4043197285740", "displayGroup": "c582d173066d690f98c8caf45cb9aa84", "sales": 0, "stock": 19, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4191150400", "releaseDate": null, "createdAt": "2023-10-16T11:39:07+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "7f100b7b36092fb9b06dfb4fac360931" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "7f100b7b36092fb9b06dfb4fac360931", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "f36d4cd40c467367a7351d75a3203c32", "childCount": 0, "categories": [ { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } }, { "id": "7f100b7b36092fb9b06dfb4fac360931", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helmzubeh\u00f6r" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "35f4a8d465e6e1edc05f3d8ab658c551", "7f100b7b36092fb9b06dfb4fac360931" ], "optionIds": [], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5" ], "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": "", "product_vk2_amazon": 49.95, "product_vk3_ebay": 49.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex plug-in led quatro" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.88 }, "fields": { "displayGroup": [ "c582d173066d690f98c8caf45cb9aa84" ] }, "sort": [ 0, "18a010d2a9813e91907ce88cd9143fdf" ] }, { "_index": "shopware6-stage_product_1747130459", "_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_1747130459", "_id": "2f64bf56821bc84ff5418577e2dc48d9", "_score": null, "_source": { "id": "2f64bf56821bc84ff5418577e2dc48d9", "autoIncrement": 81845.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 16, "productNumber": "11416", "ean": "4043197272528", "displayGroup": "8cad79246fb463695b65ec66b7f015ca", "sales": 0, "stock": 16, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4143061715", "releaseDate": null, "createdAt": "2023-10-16T11:12:20+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "35f4a8d465e6e1edc05f3d8ab658c551", "f7664060cc52bc6f3d620bcedc94a4b6" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1 }, { "id": "f7664060cc52bc6f3d620bcedc94a4b6", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "827ffdcbd2f6c6fd7e2b82d28b8ed0e8", "childCount": 0, "categories": [ { "id": "35f4a8d465e6e1edc05f3d8ab658c551", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme" } }, { "id": "f7664060cc52bc6f3d620bcedc94a4b6", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinder- & Jugendhelme" } } ], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "157d94028c20dc35f31a01a4a6e7135d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46-52 cm" } }, { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [ { "id": "157d94028c20dc35f31a01a4a6e7135d", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46-52 cm" } } ], "categoryIds": [ "35f4a8d465e6e1edc05f3d8ab658c551", "f7664060cc52bc6f3d620bcedc94a4b6" ], "optionIds": [ "157d94028c20dc35f31a01a4a6e7135d" ], "propertyIds": [ "157d94028c20dc35f31a01a4a6e7135d", "3a616a5305e06ccc883bda3ab63b10b5" ], "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": 11416.0, "product_vk2_amazon": 49.95, "product_vk3_ebay": 49.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex kid 2 dolly" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.57, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0 }, "fields": { "displayGroup": [ "8cad79246fb463695b65ec66b7f015ca" ] }, "sort": [ 0, "2f64bf56821bc84ff5418577e2dc48d9" ] }, { "_index": "shopware6-stage_product_1747130459", "_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_1747130459", "_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" ] } ] }, "aggregations": { "total-count": { "value": 28 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	12.85 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":"35f4a8d465e6e1edc05f3d8ab658c551"}}}},{"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": "35f4a8d465e6e1edc05f3d8ab658c551" } } } }, { "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": 11, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 3, "shipping-free": { "value": 1.0, "value_as_string": "true" } }, "rating-exists": { "doc_count": 45, "rating": { "value": 0.0 } }, "price": { "count": 45, "min": 12.95, "max": 219.95, "avg": 104.86111111111111, "sum": 4718.75 }, "options": { "doc_count": 43, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "795995d1c59b90ec89199aacd3cd42e7", "doc_count": 11 }, { "key": "157d94028c20dc35f31a01a4a6e7135d", "doc_count": 5 }, { "key": "acb353354acaee3cb567120cb31a568d", "doc_count": 4 }, { "key": "b572df75cd52949fa9f60b5c3a80adac", "doc_count": 4 }, { "key": "fe6425c6c2ec15b60f53b9bddf404fb8", "doc_count": 3 }, { "key": "3db70f5edf39aacb119f308d4c163269", "doc_count": 2 }, { "key": "5b8fa71396ee23af2a935beb1323a788", "doc_count": 2 }, { "key": "68241d636cd3db75d23a32d33c06efaf", "doc_count": 2 }, { "key": "84f86c88f742acdbfc13a2dd1fb8fd36", "doc_count": 2 }, { "key": "8afd504fbe5a997ddadaf8a0a2f1580a", "doc_count": 2 }, { "key": "c8f2e500958bdfe02d2caa6dd8eaccc3", "doc_count": 2 }, { "key": "85b46db105f3e91cd6ce70d38f5aa94d", "doc_count": 1 }, { "key": "9588dbdcf99bb86e045638971fdb69fe", "doc_count": 1 }, { "key": "958fb40a9b8d829ee5212a7b228e705a", "doc_count": 1 }, { "key": "a4821ccd905311b3c415b4c2cd625719", "doc_count": 1 } ] } }, "properties": { "doc_count": 88, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "3a616a5305e06ccc883bda3ab63b10b5", "doc_count": 45 }, { "key": "795995d1c59b90ec89199aacd3cd42e7", "doc_count": 11 }, { "key": "157d94028c20dc35f31a01a4a6e7135d", "doc_count": 5 }, { "key": "acb353354acaee3cb567120cb31a568d", "doc_count": 4 }, { "key": "b572df75cd52949fa9f60b5c3a80adac", "doc_count": 4 }, { "key": "fe6425c6c2ec15b60f53b9bddf404fb8", "doc_count": 3 }, { "key": "3db70f5edf39aacb119f308d4c163269", "doc_count": 2 }, { "key": "5b8fa71396ee23af2a935beb1323a788", "doc_count": 2 }, { "key": "68241d636cd3db75d23a32d33c06efaf", "doc_count": 2 }, { "key": "84f86c88f742acdbfc13a2dd1fb8fd36", "doc_count": 2 }, { "key": "8afd504fbe5a997ddadaf8a0a2f1580a", "doc_count": 2 }, { "key": "c8f2e500958bdfe02d2caa6dd8eaccc3", "doc_count": 2 }, { "key": "85b46db105f3e91cd6ce70d38f5aa94d", "doc_count": 1 }, { "key": "9588dbdcf99bb86e045638971fdb69fe", "doc_count": 1 }, { "key": "958fb40a9b8d829ee5212a7b228e705a", "doc_count": 1 }, { "key": "a4821ccd905311b3c415b4c2cd625719", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "113a80259eea2dabecb4f1d35f5aafb8", "doc_count": 25 }, { "key": "4bbd9c23e810a10a299357ea4c2b94ff", "doc_count": 20 } ] } } } `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":"35f4a8d465e6e1edc05f3d8ab658c551"}}}},{"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: 45
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": "35f4a8d465e6e1edc05f3d8ab658c551"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 4,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 45,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "shopware6-stage_product_1747130459",
                "_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_1747130459",
                "_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_1747130459",
                "_id": "05d341cd809694e4e44660c97c11e8e4",
                "_score": null,
                "_source": {
                    "id": "05d341cd809694e4e44660c97c11e8e4",
                    "autoIncrement": 81908.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "13374",
                    "ean": "4043197336183",
                    "displayGroup": "df095657f936fb9c09f33020a11a6225",
                    "sales": 0,
                    "stock": 10,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4106100317",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:24+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "8f121ce07d74717e0b1f21d122e04521"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "8f121ce07d74717e0b1f21d122e04521",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "a4d92c6a2e3afcedd597f962be626a91",
                    "coverId": "8393178f1557ff5e23ebbccc27c74019",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        },
                        {
                            "id": "8f121ce07d74717e0b1f21d122e04521",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB-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": "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": [
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "8f121ce07d74717e0b1f21d122e04521"
                    ],
                    "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": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 13373.1,
                            "product_vk2_amazon": 59.95,
                            "product_vk3_ebay": 59.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex quatro cc MIPS all black"
                    },
                    "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": [
                        "df095657f936fb9c09f33020a11a6225"
                    ]
                },
                "sort": [
                    0,
                    "05d341cd809694e4e44660c97c11e8e4"
                ]
            },
            {
                "_index": "shopware6-stage_product_1747130459",
                "_id": "0868dbe2d591f3c1beb2f6dd50bdb72e",
                "_score": null,
                "_source": {
                    "id": "0868dbe2d591f3c1beb2f6dd50bdb72e",
                    "autoIncrement": 81829.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 3,
                    "productNumber": "10699",
                    "ean": "4003318879074",
                    "displayGroup": "948841432fdda57a6c5e49f4de27254b",
                    "sales": 0,
                    "stock": 3,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "87907",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:19+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "39059724f73a9969845dfe4146c5660e"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "39059724f73a9969845dfe4146c5660e",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "bbbfb9cd75cef4ae35c1fbeed063919f",
                    "coverId": "e6c96fb3709ffcbb453ec07464490663",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        },
                        {
                            "id": "39059724f73a9969845dfe4146c5660e",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rennrad-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": "9588dbdcf99bb86e045638971fdb69fe",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "59-61 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "9588dbdcf99bb86e045638971fdb69fe",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "59-61 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "39059724f73a9969845dfe4146c5660e"
                    ],
                    "optionIds": [
                        "9588dbdcf99bb86e045638971fdb69fe"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "9588dbdcf99bb86e045638971fdb69fe"
                    ],
                    "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": 10698.1,
                            "product_vk2_amazon": 149.95,
                            "product_vk3_ebay": 149.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus StormChaser Gravel olive green"
                    },
                    "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": [
                        "948841432fdda57a6c5e49f4de27254b"
                    ]
                },
                "sort": [
                    0,
                    "0868dbe2d591f3c1beb2f6dd50bdb72e"
                ]
            },
            {
                "_index": "shopware6-stage_product_1747130459",
                "_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_1747130459",
                "_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_1747130459",
                "_id": "1731592aca5fb4d789c4119c65c10b4b",
                "_score": null,
                "_source": {
                    "id": "1731592aca5fb4d789c4119c65c10b4b",
                    "autoIncrement": 81630.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 5,
                    "productNumber": "4494",
                    "ean": "4043197345413",
                    "displayGroup": "6a32bc822ce97584b1de146d15818ba8",
                    "sales": 0,
                    "stock": 5,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4109671015",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:11+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "8f121ce07d74717e0b1f21d122e04521"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "8f121ce07d74717e0b1f21d122e04521",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "dd68fc3d2444cf141d1250356c515ebe",
                    "coverId": "66d8aea9f508375c7fa6b5bef6261ef7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        },
                        {
                            "id": "8f121ce07d74717e0b1f21d122e04521",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MTB-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": [
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "8f121ce07d74717e0b1f21d122e04521"
                    ],
                    "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": 4494.1,
                            "product_vk2_amazon": 59.95,
                            "product_vk3_ebay": 59.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex finale 2.0 rhino-neon yellow matt"
                    },
                    "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": 28.58,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 28.59
                },
                "fields": {
                    "displayGroup": [
                        "6a32bc822ce97584b1de146d15818ba8"
                    ]
                },
                "sort": [
                    0,
                    "1731592aca5fb4d789c4119c65c10b4b"
                ]
            },
            {
                "_index": "shopware6-stage_product_1747130459",
                "_id": "18a010d2a9813e91907ce88cd9143fdf",
                "_score": null,
                "_source": {
                    "id": "18a010d2a9813e91907ce88cd9143fdf",
                    "autoIncrement": 86842.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 19,
                    "productNumber": "4277",
                    "ean": "4043197285740",
                    "displayGroup": "c582d173066d690f98c8caf45cb9aa84",
                    "sales": 0,
                    "stock": 19,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4191150400",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:39:07+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "7f100b7b36092fb9b06dfb4fac360931"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "7f100b7b36092fb9b06dfb4fac360931",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "f36d4cd40c467367a7351d75a3203c32",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        },
                        {
                            "id": "7f100b7b36092fb9b06dfb4fac360931",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helmzubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "7f100b7b36092fb9b06dfb4fac360931"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "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": "",
                            "product_vk2_amazon": 49.95,
                            "product_vk3_ebay": 49.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex plug-in led quatro"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.88
                },
                "fields": {
                    "displayGroup": [
                        "c582d173066d690f98c8caf45cb9aa84"
                    ]
                },
                "sort": [
                    0,
                    "18a010d2a9813e91907ce88cd9143fdf"
                ]
            },
            {
                "_index": "shopware6-stage_product_1747130459",
                "_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_1747130459",
                "_id": "2f64bf56821bc84ff5418577e2dc48d9",
                "_score": null,
                "_source": {
                    "id": "2f64bf56821bc84ff5418577e2dc48d9",
                    "autoIncrement": 81845.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 16,
                    "productNumber": "11416",
                    "ean": "4043197272528",
                    "displayGroup": "8cad79246fb463695b65ec66b7f015ca",
                    "sales": 0,
                    "stock": 16,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4143061715",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:20+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "f7664060cc52bc6f3d620bcedc94a4b6"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1
                        },
                        {
                            "id": "f7664060cc52bc6f3d620bcedc94a4b6",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "827ffdcbd2f6c6fd7e2b82d28b8ed0e8",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "35f4a8d465e6e1edc05f3d8ab658c551",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
                            }
                        },
                        {
                            "id": "f7664060cc52bc6f3d620bcedc94a4b6",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinder- & Jugendhelme"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "157d94028c20dc35f31a01a4a6e7135d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46-52 cm"
                            }
                        },
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "157d94028c20dc35f31a01a4a6e7135d",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46-52 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "35f4a8d465e6e1edc05f3d8ab658c551",
                        "f7664060cc52bc6f3d620bcedc94a4b6"
                    ],
                    "optionIds": [
                        "157d94028c20dc35f31a01a4a6e7135d"
                    ],
                    "propertyIds": [
                        "157d94028c20dc35f31a01a4a6e7135d",
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "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": 11416.0,
                            "product_vk2_amazon": 49.95,
                            "product_vk3_ebay": 49.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex kid 2 dolly"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.57,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
                },
                "fields": {
                    "displayGroup": [
                        "8cad79246fb463695b65ec66b7f015ca"
                    ]
                },
                "sort": [
                    0,
                    "2f64bf56821bc84ff5418577e2dc48d9"
                ]
            },
            {
                "_index": "shopware6-stage_product_1747130459",
                "_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_1747130459",
                "_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"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 28
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

12.85 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":"35f4a8d465e6e1edc05f3d8ab658c551"}}}},{"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": "35f4a8d465e6e1edc05f3d8ab658c551"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 11,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 3,
            "shipping-free": {
                "value": 1.0,
                "value_as_string": "true"
            }
        },
        "rating-exists": {
            "doc_count": 45,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 45,
            "min": 12.95,
            "max": 219.95,
            "avg": 104.86111111111111,
            "sum": 4718.75
        },
        "options": {
            "doc_count": 43,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "795995d1c59b90ec89199aacd3cd42e7",
                        "doc_count": 11
                    },
                    {
                        "key": "157d94028c20dc35f31a01a4a6e7135d",
                        "doc_count": 5
                    },
                    {
                        "key": "acb353354acaee3cb567120cb31a568d",
                        "doc_count": 4
                    },
                    {
                        "key": "b572df75cd52949fa9f60b5c3a80adac",
                        "doc_count": 4
                    },
                    {
                        "key": "fe6425c6c2ec15b60f53b9bddf404fb8",
                        "doc_count": 3
                    },
                    {
                        "key": "3db70f5edf39aacb119f308d4c163269",
                        "doc_count": 2
                    },
                    {
                        "key": "5b8fa71396ee23af2a935beb1323a788",
                        "doc_count": 2
                    },
                    {
                        "key": "68241d636cd3db75d23a32d33c06efaf",
                        "doc_count": 2
                    },
                    {
                        "key": "84f86c88f742acdbfc13a2dd1fb8fd36",
                        "doc_count": 2
                    },
                    {
                        "key": "8afd504fbe5a997ddadaf8a0a2f1580a",
                        "doc_count": 2
                    },
                    {
                        "key": "c8f2e500958bdfe02d2caa6dd8eaccc3",
                        "doc_count": 2
                    },
                    {
                        "key": "85b46db105f3e91cd6ce70d38f5aa94d",
                        "doc_count": 1
                    },
                    {
                        "key": "9588dbdcf99bb86e045638971fdb69fe",
                        "doc_count": 1
                    },
                    {
                        "key": "958fb40a9b8d829ee5212a7b228e705a",
                        "doc_count": 1
                    },
                    {
                        "key": "a4821ccd905311b3c415b4c2cd625719",
                        "doc_count": 1
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 88,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "3a616a5305e06ccc883bda3ab63b10b5",
                        "doc_count": 45
                    },
                    {
                        "key": "795995d1c59b90ec89199aacd3cd42e7",
                        "doc_count": 11
                    },
                    {
                        "key": "157d94028c20dc35f31a01a4a6e7135d",
                        "doc_count": 5
                    },
                    {
                        "key": "acb353354acaee3cb567120cb31a568d",
                        "doc_count": 4
                    },
                    {
                        "key": "b572df75cd52949fa9f60b5c3a80adac",
                        "doc_count": 4
                    },
                    {
                        "key": "fe6425c6c2ec15b60f53b9bddf404fb8",
                        "doc_count": 3
                    },
                    {
                        "key": "3db70f5edf39aacb119f308d4c163269",
                        "doc_count": 2
                    },
                    {
                        "key": "5b8fa71396ee23af2a935beb1323a788",
                        "doc_count": 2
                    },
                    {
                        "key": "68241d636cd3db75d23a32d33c06efaf",
                        "doc_count": 2
                    },
                    {
                        "key": "84f86c88f742acdbfc13a2dd1fb8fd36",
                        "doc_count": 2
                    },
                    {
                        "key": "8afd504fbe5a997ddadaf8a0a2f1580a",
                        "doc_count": 2
                    },
                    {
                        "key": "c8f2e500958bdfe02d2caa6dd8eaccc3",
                        "doc_count": 2
                    },
                    {
                        "key": "85b46db105f3e91cd6ce70d38f5aa94d",
                        "doc_count": 1
                    },
                    {
                        "key": "9588dbdcf99bb86e045638971fdb69fe",
                        "doc_count": 1
                    },
                    {
                        "key": "958fb40a9b8d829ee5212a7b228e705a",
                        "doc_count": 1
                    },
                    {
                        "key": "a4821ccd905311b3c415b4c2cd625719",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "113a80259eea2dabecb4f1d35f5aafb8",
                    "doc_count": 25
                },
                {
                    "key": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "doc_count": 20
                }
            ]
        }
    }
}

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": 71,
    "active_shards": 71,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 207,
    "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.539568345323744
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw-admin-payment-method-listing_1732606828	open	3, 3	45
sw-admin-customer-group-listing_1732606827	open	3, 3	2
sw-admin-category-listing_1732606829	open	3, 3	374
sw-admin-mollie-subscription_1732606829	open	3, 3	0
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
sw-admin-order-listing_1732606828	open	3, 3	476
shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325	open	3, 3	411469
sw-admin-media-listing_1732606828	open	3, 3	10049
sw-admin-property-group-listing_1732606828	open	3, 3	137
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-customer-listing_1732606827	open	3, 3	140
shopware6-stage_product_1747130459	open	3, 3	773930
sw-admin-cms-page-listing_1732606827	open	3, 3	65
sw-admin-product-listing_1732606828	open	3, 3	9462
sw-admin-shipping-method-listing_1732606828	open	3, 3	3
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

Symfony Profiler

GET https://stage-sw6.radwelt-shop.de/navigation/35f4a8d465e6e1edc05f3d8ab658c551

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices