Symfony Profiler

Query Metrics

12.00 ms Query Time

1 Node(s)

24 Indices

Queries

#▲ Execution Time Info

6.00 ms

#▲	Execution Time	Info
1	6.00 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":"c0e190d8267e36708f955d7ab048990d"}}}},{"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: 8 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": "c0e190d8267e36708f955d7ab048990d" } } } }, { "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": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 8, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "shopware6-stage_product_1773667835", "_id": "03db60c2331018b18c4166c1787072fe", "_score": null, "_source": { "id": "03db60c2331018b18c4166c1787072fe", "autoIncrement": 86620.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "8504", "ean": "4030701044047", "displayGroup": "c5a31782b001b2e5b393d1e78e02763e", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "34baca408d2a10d268a5905ba3266147", "manufacturerNumber": "061-72336", "releaseDate": null, "createdAt": "2023-10-16T11:37:56+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "6c689a784bc238620ea10bb80a5081d4", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "34baca408d2a10d268a5905ba3266147", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_parent_article": "", "product_vk2_amazon": 16.99, "product_vk3_ebay": 16.99, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Flat Bar" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Flat BarMaterial: Aluminium 25,4mm\/620mm\/5\u00b0 Material: AluminiumLenkerklemmung: 25,4 mmLenkerbreite: 620 mmLenkerh\u00f6he: 30 mmLenkergriffwinkel: 5 GradLenkergriffdurchmesser: 22,2 mmSonstiges: mit L\u00e4ngeneinteilungGewicht: 188 g" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.28 }, "fields": { "displayGroup": [ "c5a31782b001b2e5b393d1e78e02763e" ] }, "sort": [ 0, "03db60c2331018b18c4166c1787072fe" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "149815eb972b3c370dee3b89d645ae14", "_score": null, "_source": { "id": "149815eb972b3c370dee3b89d645ae14", "autoIncrement": 87874.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 18, "productNumber": "2323", "ean": "9008594140813", "displayGroup": "64e657ae1587b7be435c0d7d4888e9a8", "sales": 0, "stock": 18, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d", "manufacturerNumber": "842360270", "releaseDate": null, "createdAt": "2024-01-15T12:11:23+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "f1623d3f1aeda78157bafb7920ff10ee", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "fa246d0262c3925617b0c72bb20eeb1d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige" }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "optionIds": [], "propertyIds": [], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_vk2_amazon": 13.99, "product_vk3_ebay": 13.99, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Comfort Lenker Line" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Comfort Lenker Line Gewicht: 265g Lenkerbreite: 590mm Lenkergriffl\u00e4nge: 180mm Lenkergriffwinkel: 47 Grad Lenkerh\u00f6he: 35mm Lenkerklemmung: 31,6 mm Material: Aluminium Farbe: Schwarz" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.61 }, "fields": { "displayGroup": [ "64e657ae1587b7be435c0d7d4888e9a8" ] }, "sort": [ 0, "149815eb972b3c370dee3b89d645ae14" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "2a50e9c2d6b89b95bcb416d6857f8b45", "_score": null, "_source": { "id": "2a50e9c2d6b89b95bcb416d6857f8b45", "autoIncrement": 86609.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 9, "productNumber": "1320", "ean": "4030701053971", "displayGroup": "1825170a155c574d7f059e6d3134907c", "sales": 0, "stock": 9, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "34baca408d2a10d268a5905ba3266147", "manufacturerNumber": "060-72164", "releaseDate": null, "createdAt": "2023-10-16T11:37:53+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "019cf8e20e65725cac51debe3734641c", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "34baca408d2a10d268a5905ba3266147", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_parent_article": "", "product_vk2_amazon": 14.95, "product_vk3_ebay": 14.95, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Trekking Premio SL" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Premio SLMaterial: Aluminium 24 Gang Material: AluminiumLenkerklemmung: 25,4 mmLenkerbreite: 620 mmLenkergriffdurchmesser: 25,4 mmGewicht: 373 gFarbrichtung: schwarz" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.6 }, "fields": { "displayGroup": [ "1825170a155c574d7f059e6d3134907c" ] }, "sort": [ 0, "2a50e9c2d6b89b95bcb416d6857f8b45" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "451e10de8e2fb18a9f795679b52dc9f6", "_score": null, "_source": { "id": "451e10de8e2fb18a9f795679b52dc9f6", "autoIncrement": 88052.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "13886", "ean": "4016538101177", "displayGroup": "c87984a667c952e1d06055954c4f4922", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "27361101a74f1edf8824f150d03b569e", "manufacturerNumber": "060-72353", "releaseDate": null, "createdAt": "2024-02-20T06:45:42+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "019cf932324271f4af4bad7a743fcd98", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "27361101a74f1edf8824f150d03b569e", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_vk2_amazon": 24.9, "product_vk3_ebay": 24.9, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Lenker Rise Bar" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Lenkerb\u00fcgel \u00fcberzeugt nicht nur durch die hervorragende Verarbeitung sondern auch durch seine satte Breite von 780 mm, was der Lenkerstabilit\u00e4t im Gel\u00e4nde zugute kommt. Bei Bedarf kann dieser problemlos bis zu 100mm gek\u00fcrzt werden.Produktkategorie: MTB-LenkerDurchmesser Lenkerklemmung: 31,8 mmLenkerbreite: 780 mmGriffl\u00e4nge: 230 mmMaterial: Aluinium 6061 T6Farbe: schwarz" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.9, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.34 }, "fields": { "displayGroup": [ "c87984a667c952e1d06055954c4f4922" ] }, "sort": [ 0, "451e10de8e2fb18a9f795679b52dc9f6" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "60a0dd962e40d6cb0456e5e1910230e8", "_score": null, "_source": { "id": "60a0dd962e40d6cb0456e5e1910230e8", "autoIncrement": 86444.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "7642", "ean": "4030701053988", "displayGroup": "5e75ff65b413492fe5e1436cf64d403c", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "34baca408d2a10d268a5905ba3266147", "manufacturerNumber": "060-72165", "releaseDate": null, "createdAt": "2023-10-16T11:36:59+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "4e66d279a9cebb9eb1c678531dfb2360", "childCount": 0, "categories": [ { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "34baca408d2a10d268a5905ba3266147", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_parent_article": "", "product_vk2_amazon": 59.95, "product_vk3_ebay": 59.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Low Riser Premio SL \/ Piazza \/ Solero" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cruiser Lenker Produktdetails:Material: 6061 AluminiumLenkerklemmung: 25,4 mmLenkerbreite: 600 mmLenkerh\u00f6he: 28 mmLenkergriffwinkel: 37 GradLenkergriffl\u00e4nge: 180 mmLenkergriffdurchmesser: 22,2 mmGewicht **: 380 gverbaut in Modell: Piazzaverbaut in Modell: Premio SLverbaut in Modell: SoleroHerstellerfarbe: schwarz matt" }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.12 }, "fields": { "displayGroup": [ "5e75ff65b413492fe5e1436cf64d403c" ] }, "sort": [ 0, "60a0dd962e40d6cb0456e5e1910230e8" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "96fe1255e032940e2739e06072855b95", "_score": null, "_source": { "id": "96fe1255e032940e2739e06072855b95", "autoIncrement": 90441.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "14345", "ean": "4052862019764", "displayGroup": "db4c9fc8639bdca36abda46a0ce0cb14", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d", "manufacturerNumber": "060-72334", "releaseDate": null, "createdAt": "2024-07-17T04:51:33+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "b644642cbed97d256332fd65775acaf0", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "fa246d0262c3925617b0c72bb20eeb1d", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige" }, "_count": 1 }, "properties": [ { "id": "8a18e94fc839d50ffd7e72f754588f9c", "_count": 1, "groupId": "526407a60c19a5cb7d801e27ffb71051", "group": { "id": "526407a60c19a5cb7d801e27ffb71051", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "760 mm" } } ], "options": [ { "id": "8a18e94fc839d50ffd7e72f754588f9c", "_count": 1, "groupId": "526407a60c19a5cb7d801e27ffb71051", "group": { "id": "526407a60c19a5cb7d801e27ffb71051", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "760 mm" } } ], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "optionIds": [ "8a18e94fc839d50ffd7e72f754588f9c" ], "propertyIds": [ "8a18e94fc839d50ffd7e72f754588f9c" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_vk2_amazon": 29.95, "product_vk3_ebay": 29.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zecure Lenker HB-HR 101" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Zecure Produkte bieten eine einen h\u00f6heren belastungsstandart als herk\u00f6mmliche Produkte. Die maximale Belastung der Produkte betr\u00e4gt 150kg (Fahrergesamtgewicht). Einsatzbereich: City-\/Trekking-LenkerBreite Lenkerklemmung: 31,8 mmDurchmesser Lenkerklemmung: 31,8 mmFarbe: schwarzGriffl\u00e4nge: 255 mmLenkerbreite (mm): 760 mmMaterial: AluminiumNettogewicht: 360 g " }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.2 }, "fields": { "displayGroup": [ "db4c9fc8639bdca36abda46a0ce0cb14" ] }, "sort": [ 0, "96fe1255e032940e2739e06072855b95" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "aaebdb8bb6b0e73f6c3c54a0ab0c6415", "_score": null, "_source": { "id": "aaebdb8bb6b0e73f6c3c54a0ab0c6415", "autoIncrement": 88295.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 5, "productNumber": "4597", "ean": "4016538080472", "displayGroup": "45805687ed4bfdcb6b842f7ffc4abd35", "sales": 0, "stock": 5, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "27361101a74f1edf8824f150d03b569e", "manufacturerNumber": "16712001", "releaseDate": null, "createdAt": "2024-03-29T11:19:23+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "019cf937ffdf70759761ca685c846438", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "27361101a74f1edf8824f150d03b569e", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_vk2_amazon": 24.9, "product_vk3_ebay": 24.9, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Lenker Rizer Bar 30" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Lenkerb\u00fcgel \u00fcberzeugt nicht nur durch die hervorragende Verarbeitung sondern auch durch seine satte Breite von 780 mm, was der Lenkerstabilit\u00e4t im Gel\u00e4nde zugute kommt. Bei Bedarf kann dieser problemlos bis zu 100mm gek\u00fcrzt werden. Auch mit Safety Level 6+ erh\u00e4ltlich. Der ergotec 6+ Lenker ist aus einem speziellem, kaltgezogenen 7050-T76 Aluminium, wie es auch in der Luftfahrt Anwendung findet, gefertigt. Zus\u00e4tzlich wurden die Wandst\u00e4rke den Belastungszonen des Lenkers so angepasst, dass der Lenker noch gut flext. Das Ergebnis ist ein extrem stabiler Lenker, welcher sowohl f\u00fcr den harten Renneinsatz als auch f\u00fcr schwere Fahrer von E-MTBs geeignet ist. Die 12\u00b0 Griffwinkel (Back Sweep) entlasten die Handgelenke und sorgen auch auf l\u00e4ngeren Fahrten f\u00fcr ein angenehmes und sicheres Handling. Der breite Griffbereich bietet ausreichend Platz, zum Anbau von allen notwendigen Anbauteile.Produktkategorie: MTB LenkerMaterial: AL 6061 T6Klemmung: 31,8 mmBreite: 780 mmH\u00f6he: 30 mmGriffl\u00e4nge: 260 mm " }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.9, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.34 }, "fields": { "displayGroup": [ "45805687ed4bfdcb6b842f7ffc4abd35" ] }, "sort": [ 0, "aaebdb8bb6b0e73f6c3c54a0ab0c6415" ] }, { "_index": "shopware6-stage_product_1773667835", "_id": "d7b431b1a0cc5f032399870ff4710743", "_score": null, "_source": { "id": "d7b431b1a0cc5f032399870ff4710743", "autoIncrement": 86882.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 6, "productNumber": "5485", "ean": "4016538071791", "displayGroup": "e843c23e9c915a5b0b5189b75a2050ac", "sales": 0, "stock": 6, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "27361101a74f1edf8824f150d03b569e", "manufacturerNumber": "060-72131", "releaseDate": null, "createdAt": "2023-10-16T11:39:20+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "e96ed478dab8595a7dbda4cbcbee168f", "c0e190d8267e36708f955d7ab048990d" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1 }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1 }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "019cf8f5bc1773a7a4e324c129c41833", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "357a6fdf7642bf815a88822c447d9dc4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile" } }, { "id": "c0e190d8267e36708f955d7ab048990d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker" } }, { "id": "e96ed478dab8595a7dbda4cbcbee168f", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe" } } ], "manufacturer": { "id": "27361101a74f1edf8824f150d03b569e", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "357a6fdf7642bf815a88822c447d9dc4", "c0e190d8267e36708f955d7ab048990d", "e96ed478dab8595a7dbda4cbcbee168f" ], "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": "Montage2", "product_click_and_collect": 1.0, "product_store_available": 0.0, "product_parent_article": "", "product_vk2_amazon": 9.99, "product_vk3_ebay": 9.99, "accessory_sorting_order": "2122\|7076" } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ergotec Lenker Lady Town" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Material: Aluminium Level 2 Leichter Alu-Lenker f\u00fcr den sportlichen Trekkingtouristen oder Roadbiker, der eine Entlastung der Handgelenke mit einer sportlichen Sitzposition kombinieren m\u00f6chte." }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.9, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.4 }, "fields": { "displayGroup": [ "e843c23e9c915a5b0b5189b75a2050ac" ] }, "sort": [ 0, "d7b431b1a0cc5f032399870ff4710743" ] } ] }, "aggregations": { "total-count": { "value": 8 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	6.30 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":"c0e190d8267e36708f955d7ab048990d"}}}},{"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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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": "c0e190d8267e36708f955d7ab048990d" } } } }, { "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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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": 5, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 8, "rating": { "value": 0.0 } }, "price": { "count": 8, "min": 14.99, "max": 59.9, "avg": 32.70625, "sum": 261.65 }, "options": { "doc_count": 1, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "8a18e94fc839d50ffd7e72f754588f9c", "doc_count": 1 } ] } }, "properties": { "doc_count": 7, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "3a616a5305e06ccc883bda3ab63b10b5", "doc_count": 6 }, { "key": "8a18e94fc839d50ffd7e72f754588f9c", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "27361101a74f1edf8824f150d03b569e", "doc_count": 3 }, { "key": "34baca408d2a10d268a5905ba3266147", "doc_count": 3 }, { "key": "fa246d0262c3925617b0c72bb20eeb1d", "doc_count": 2 } ] } } } `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":"c0e190d8267e36708f955d7ab048990d"}}}},{"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: 8
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": "c0e190d8267e36708f955d7ab048990d"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 8,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "03db60c2331018b18c4166c1787072fe",
                "_score": null,
                "_source": {
                    "id": "03db60c2331018b18c4166c1787072fe",
                    "autoIncrement": 86620.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "8504",
                    "ean": "4030701044047",
                    "displayGroup": "c5a31782b001b2e5b393d1e78e02763e",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "34baca408d2a10d268a5905ba3266147",
                    "manufacturerNumber": "061-72336",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:37:56+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "6c689a784bc238620ea10bb80a5081d4",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "34baca408d2a10d268a5905ba3266147",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 16.99,
                            "product_vk3_ebay": 16.99,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Flat Bar"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Flat BarMaterial: Aluminium 25,4mm\/620mm\/5\u00b0  Material:                        AluminiumLenkerklemmung:          25,4 mmLenkerbreite:                 620 mmLenkerh\u00f6he:                  30 mmLenkergriffwinkel:          5 GradLenkergriffdurchmesser: 22,2 mmSonstiges:                      mit L\u00e4ngeneinteilungGewicht:                        188 g"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 16.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 14.28
                },
                "fields": {
                    "displayGroup": [
                        "c5a31782b001b2e5b393d1e78e02763e"
                    ]
                },
                "sort": [
                    0,
                    "03db60c2331018b18c4166c1787072fe"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "149815eb972b3c370dee3b89d645ae14",
                "_score": null,
                "_source": {
                    "id": "149815eb972b3c370dee3b89d645ae14",
                    "autoIncrement": 87874.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 18,
                    "productNumber": "2323",
                    "ean": "9008594140813",
                    "displayGroup": "64e657ae1587b7be435c0d7d4888e9a8",
                    "sales": 0,
                    "stock": 18,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d",
                    "manufacturerNumber": "842360270",
                    "releaseDate": null,
                    "createdAt": "2024-01-15T12:11:23+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "f1623d3f1aeda78157bafb7920ff10ee",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "fa246d0262c3925617b0c72bb20eeb1d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_vk2_amazon": 13.99,
                            "product_vk3_ebay": 13.99,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Comfort Lenker Line"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Comfort Lenker Line Gewicht:                    265g Lenkerbreite:              590mm Lenkergriffl\u00e4nge:         180mm Lenkergriffwinkel:        47 Grad Lenkerh\u00f6he:               35mm Lenkerklemmung:        31,6 mm Material:                    Aluminium Farbe:                       Schwarz"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.61
                },
                "fields": {
                    "displayGroup": [
                        "64e657ae1587b7be435c0d7d4888e9a8"
                    ]
                },
                "sort": [
                    0,
                    "149815eb972b3c370dee3b89d645ae14"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "2a50e9c2d6b89b95bcb416d6857f8b45",
                "_score": null,
                "_source": {
                    "id": "2a50e9c2d6b89b95bcb416d6857f8b45",
                    "autoIncrement": 86609.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 9,
                    "productNumber": "1320",
                    "ean": "4030701053971",
                    "displayGroup": "1825170a155c574d7f059e6d3134907c",
                    "sales": 0,
                    "stock": 9,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "34baca408d2a10d268a5905ba3266147",
                    "manufacturerNumber": "060-72164",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:37:53+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019cf8e20e65725cac51debe3734641c",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "34baca408d2a10d268a5905ba3266147",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 14.95,
                            "product_vk3_ebay": 14.95,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Trekking Premio SL"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Lenker Premio SLMaterial: Aluminium 24 Gang  Material:                         AluminiumLenkerklemmung:           25,4 mmLenkerbreite:                  620 mmLenkergriffdurchmesser: 25,4 mmGewicht:                        373 gFarbrichtung:                  schwarz"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.6
                },
                "fields": {
                    "displayGroup": [
                        "1825170a155c574d7f059e6d3134907c"
                    ]
                },
                "sort": [
                    0,
                    "2a50e9c2d6b89b95bcb416d6857f8b45"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "451e10de8e2fb18a9f795679b52dc9f6",
                "_score": null,
                "_source": {
                    "id": "451e10de8e2fb18a9f795679b52dc9f6",
                    "autoIncrement": 88052.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "13886",
                    "ean": "4016538101177",
                    "displayGroup": "c87984a667c952e1d06055954c4f4922",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "27361101a74f1edf8824f150d03b569e",
                    "manufacturerNumber": "060-72353",
                    "releaseDate": null,
                    "createdAt": "2024-02-20T06:45:42+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019cf932324271f4af4bad7a743fcd98",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27361101a74f1edf8824f150d03b569e",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_vk2_amazon": 24.9,
                            "product_vk3_ebay": 24.9,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Lenker Rise Bar"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Lenkerb\u00fcgel \u00fcberzeugt nicht nur durch die hervorragende Verarbeitung sondern auch durch seine satte Breite von 780 mm, was der Lenkerstabilit\u00e4t im Gel\u00e4nde zugute kommt. Bei Bedarf kann dieser problemlos bis zu 100mm gek\u00fcrzt werden.Produktkategorie: MTB-LenkerDurchmesser Lenkerklemmung: 31,8 mmLenkerbreite: 780 mmGriffl\u00e4nge: 230 mmMaterial: Aluinium 6061 T6Farbe: schwarz"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.9,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.34
                },
                "fields": {
                    "displayGroup": [
                        "c87984a667c952e1d06055954c4f4922"
                    ]
                },
                "sort": [
                    0,
                    "451e10de8e2fb18a9f795679b52dc9f6"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "60a0dd962e40d6cb0456e5e1910230e8",
                "_score": null,
                "_source": {
                    "id": "60a0dd962e40d6cb0456e5e1910230e8",
                    "autoIncrement": 86444.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "7642",
                    "ean": "4030701053988",
                    "displayGroup": "5e75ff65b413492fe5e1436cf64d403c",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "34baca408d2a10d268a5905ba3266147",
                    "manufacturerNumber": "060-72165",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:36:59+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "4e66d279a9cebb9eb1c678531dfb2360",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "34baca408d2a10d268a5905ba3266147",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 59.95,
                            "product_vk3_ebay": 59.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Low Riser Premio SL \/ Piazza \/ Solero"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cruiser Lenker   Produktdetails:Material: 6061 AluminiumLenkerklemmung: 25,4 mmLenkerbreite: 600 mmLenkerh\u00f6he: 28 mmLenkergriffwinkel: 37 GradLenkergriffl\u00e4nge: 180 mmLenkergriffdurchmesser: 22,2 mmGewicht **: 380 gverbaut in Modell: Piazzaverbaut in Modell: Premio SLverbaut in Modell: SoleroHerstellerfarbe: schwarz matt"
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 17.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.12
                },
                "fields": {
                    "displayGroup": [
                        "5e75ff65b413492fe5e1436cf64d403c"
                    ]
                },
                "sort": [
                    0,
                    "60a0dd962e40d6cb0456e5e1910230e8"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "96fe1255e032940e2739e06072855b95",
                "_score": null,
                "_source": {
                    "id": "96fe1255e032940e2739e06072855b95",
                    "autoIncrement": 90441.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "14345",
                    "ean": "4052862019764",
                    "displayGroup": "db4c9fc8639bdca36abda46a0ce0cb14",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d",
                    "manufacturerNumber": "060-72334",
                    "releaseDate": null,
                    "createdAt": "2024-07-17T04:51:33+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "b644642cbed97d256332fd65775acaf0",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "fa246d0262c3925617b0c72bb20eeb1d",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "8a18e94fc839d50ffd7e72f754588f9c",
                            "_count": 1,
                            "groupId": "526407a60c19a5cb7d801e27ffb71051",
                            "group": {
                                "id": "526407a60c19a5cb7d801e27ffb71051",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "760 mm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "8a18e94fc839d50ffd7e72f754588f9c",
                            "_count": 1,
                            "groupId": "526407a60c19a5cb7d801e27ffb71051",
                            "group": {
                                "id": "526407a60c19a5cb7d801e27ffb71051",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "760 mm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "optionIds": [
                        "8a18e94fc839d50ffd7e72f754588f9c"
                    ],
                    "propertyIds": [
                        "8a18e94fc839d50ffd7e72f754588f9c"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_vk2_amazon": 29.95,
                            "product_vk3_ebay": 29.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zecure Lenker HB-HR 101"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Zecure Produkte bieten eine einen h\u00f6heren belastungsstandart als herk\u00f6mmliche Produkte. Die maximale Belastung der Produkte betr\u00e4gt 150kg (Fahrergesamtgewicht). Einsatzbereich: City-\/Trekking-LenkerBreite Lenkerklemmung: 31,8 mmDurchmesser Lenkerklemmung: 31,8 mmFarbe: schwarzGriffl\u00e4nge: 255 mmLenkerbreite (mm): 760 mmMaterial: AluminiumNettogewicht: 360 g "
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.2
                },
                "fields": {
                    "displayGroup": [
                        "db4c9fc8639bdca36abda46a0ce0cb14"
                    ]
                },
                "sort": [
                    0,
                    "96fe1255e032940e2739e06072855b95"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "aaebdb8bb6b0e73f6c3c54a0ab0c6415",
                "_score": null,
                "_source": {
                    "id": "aaebdb8bb6b0e73f6c3c54a0ab0c6415",
                    "autoIncrement": 88295.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 5,
                    "productNumber": "4597",
                    "ean": "4016538080472",
                    "displayGroup": "45805687ed4bfdcb6b842f7ffc4abd35",
                    "sales": 0,
                    "stock": 5,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "27361101a74f1edf8824f150d03b569e",
                    "manufacturerNumber": "16712001",
                    "releaseDate": null,
                    "createdAt": "2024-03-29T11:19:23+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019cf937ffdf70759761ca685c846438",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27361101a74f1edf8824f150d03b569e",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_vk2_amazon": 24.9,
                            "product_vk3_ebay": 24.9,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec Lenker Rizer Bar 30"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Lenkerb\u00fcgel \u00fcberzeugt nicht nur durch die hervorragende Verarbeitung sondern auch durch seine satte Breite von 780 mm, was der Lenkerstabilit\u00e4t im Gel\u00e4nde zugute kommt. Bei Bedarf kann dieser problemlos bis zu 100mm gek\u00fcrzt werden. Auch mit Safety Level 6+ erh\u00e4ltlich. Der ergotec 6+ Lenker ist aus einem speziellem, kaltgezogenen 7050-T76 Aluminium, wie es auch in der Luftfahrt Anwendung findet, gefertigt. Zus\u00e4tzlich wurden die Wandst\u00e4rke den Belastungszonen des Lenkers so angepasst, dass der Lenker noch gut flext. Das Ergebnis ist ein extrem stabiler Lenker, welcher sowohl f\u00fcr den harten Renneinsatz als auch f\u00fcr schwere Fahrer von E-MTBs geeignet ist. Die 12\u00b0 Griffwinkel (Back Sweep) entlasten die Handgelenke und sorgen auch auf l\u00e4ngeren Fahrten f\u00fcr ein angenehmes und sicheres Handling. Der breite Griffbereich bietet ausreichend Platz, zum Anbau von allen notwendigen Anbauteile.Produktkategorie: MTB LenkerMaterial: AL 6061 T6Klemmung: 31,8 mmBreite: 780 mmH\u00f6he: 30 mmGriffl\u00e4nge: 260 mm  "
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.9,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.34
                },
                "fields": {
                    "displayGroup": [
                        "45805687ed4bfdcb6b842f7ffc4abd35"
                    ]
                },
                "sort": [
                    0,
                    "aaebdb8bb6b0e73f6c3c54a0ab0c6415"
                ]
            },
            {
                "_index": "shopware6-stage_product_1773667835",
                "_id": "d7b431b1a0cc5f032399870ff4710743",
                "_score": null,
                "_source": {
                    "id": "d7b431b1a0cc5f032399870ff4710743",
                    "autoIncrement": 86882.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 6,
                    "productNumber": "5485",
                    "ean": "4016538071791",
                    "displayGroup": "e843c23e9c915a5b0b5189b75a2050ac",
                    "sales": 0,
                    "stock": 6,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "27361101a74f1edf8824f150d03b569e",
                    "manufacturerNumber": "060-72131",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:39:20+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "e96ed478dab8595a7dbda4cbcbee168f",
                        "c0e190d8267e36708f955d7ab048990d"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019cf8f5bc1773a7a4e324c129c41833",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "357a6fdf7642bf815a88822c447d9dc4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
                            }
                        },
                        {
                            "id": "c0e190d8267e36708f955d7ab048990d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker"
                            }
                        },
                        {
                            "id": "e96ed478dab8595a7dbda4cbcbee168f",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lenker & Griffe"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "27361101a74f1edf8824f150d03b569e",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ergotec"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "357a6fdf7642bf815a88822c447d9dc4",
                        "c0e190d8267e36708f955d7ab048990d",
                        "e96ed478dab8595a7dbda4cbcbee168f"
                    ],
                    "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": "Montage2",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 0.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 9.99,
                            "product_vk3_ebay": 9.99,
                            "accessory_sorting_order": "2122|7076"
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ergotec Lenker Lady Town"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Material: Aluminium Level 2  Leichter Alu-Lenker f\u00fcr den sportlichen Trekkingtouristen oder Roadbiker, der eine Entlastung der Handgelenke mit einer sportlichen Sitzposition kombinieren m\u00f6chte."
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 21.9,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 18.4
                },
                "fields": {
                    "displayGroup": [
                        "e843c23e9c915a5b0b5189b75a2050ac"
                    ]
                },
                "sort": [
                    0,
                    "d7b431b1a0cc5f032399870ff4710743"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 8
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

6.30 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":"c0e190d8267e36708f955d7ab048990d"}}}},{"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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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": "c0e190d8267e36708f955d7ab048990d"
                                        }
                                    }
                                }
                            },
                            {
                                "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_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_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": 5,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 8,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 8,
            "min": 14.99,
            "max": 59.9,
            "avg": 32.70625,
            "sum": 261.65
        },
        "options": {
            "doc_count": 1,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "8a18e94fc839d50ffd7e72f754588f9c",
                        "doc_count": 1
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 7,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "3a616a5305e06ccc883bda3ab63b10b5",
                        "doc_count": 6
                    },
                    {
                        "key": "8a18e94fc839d50ffd7e72f754588f9c",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "27361101a74f1edf8824f150d03b569e",
                    "doc_count": 3
                },
                {
                    "key": "34baca408d2a10d268a5905ba3266147",
                    "doc_count": 3
                },
                {
                    "key": "fa246d0262c3925617b0c72bb20eeb1d",
                    "doc_count": 2
                }
            ]
        }
    }
}

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": 74,
    "active_shards": 74,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 216,
    "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.517241379310345
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw-admin-payment-method-listing_1732606828	open	3, 3	49
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	11
shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325	open	3, 3	411469
sw-admin-media-listing_1732606828	open	3, 3	11392
sw-admin-product-stream-listing_1732606829	open	3, 3	9130
sw-admin-manufacturer-listing_1732606827	open	3, 3	129
sw-admin-newsletter-recipient-listing_1732606829	open	3, 3	1
shopware6-stage_product_1747130459	open	3, 3	919801
sw-admin-cms-page-listing_1732606827	open	3, 3	66
sw-admin-product-listing_1732606828	open	3, 3	10874
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	17
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
sw-admin-order-listing_1732606828	open	3, 3	539
sw-admin-property-group-listing_1732606828	open	3, 3	140
sw-admin-customer-listing_1732606827	open	3, 3	195
sw-admin-shipping-method-listing_1732606828	open	3, 3	3
shopware6-stage_product_1773667835	open	3, 3	921171

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices