Symfony Profiler

Query Metrics

39.00 ms Query Time

1 Node(s)

4 Indices

Queries

#▲ Execution Time Info

31.63 ms

#▲	Execution Time	Info
1	31.63 ms	Request: {"index":"sw_product","search_type":"query_then_fetch","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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"019afdc429a77e2a87fb8a5bc6ae48d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"positions.position":{"nested":{"path":"positions","filter":{"term":{"positions.salesChannelCategoryHash":"32f0d3c9994e6fdb9a0f2172c7459616"}}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}} Item count: 15 View formatted request View formatted response View query backtrace POST http://localhost:9666/sw_product/_search?search_type=query_then_fetch&track_total_hits=1 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": "0198991695bc70e7b39cb015d4b9eda4" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "019afdc429a77e2a87fb8a5bc6ae48d8" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "positions.position": { "nested": { "path": "positions", "filter": { "term": { "positions.salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" } } }, "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 15, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 15, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1765174059", "_id": "0198992e967c70feadad663d9cfffada", "_score": null, "_source": { "id": "0198992e967c70feadad663d9cfffada", "autoIncrement": 13.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": true, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 50, "productNumber": "SWDEMO10007.1", "ean": null, "displayGroup": "af160339563fcd7ae2c9becf4cd95adb", "sales": 0, "stock": 50, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "7f24e96676e944b0a0addc20d56728cb", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afcceebca7b50b06681b11d1dc8ee", "019afdc429a77e2a87fb8a5bc6ae48d8", "77b959cf66de4c1590c7f9b7da3982f3", "a515ae260223466f8e37471d279e6406", "019afcdabdfd778cb4532f66e8d457ca", "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afcceebca7b50b06681b11d1dc8ee", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "77b959cf66de4c1590c7f9b7da3982f3", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afcdabdfd778cb4532f66e8d457ca", "_count": 1 }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1 }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1 }, { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": "c7bca22753c84d08b6178a50052b4146", "coverId": "683c3a0a0c26464fb65332d1a9adf7e2", "childCount": 0, "categories": [ { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Herren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Backwaren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products" } }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } }, { "id": "019afcdabdfd778cb4532f66e8d457ca", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pies" } } ], "manufacturer": { "id": "7f24e96676e944b0a0addc20d56728cb", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion" }, "_count": 1 }, "properties": [ { "id": "41e5013b67d64d3a92b7a275da8af441", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "S", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S" } }, { "id": "5193ffa5de8648a1bcfba1fa8a26c02b", "_count": 1, "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32", "group": { "id": "a67cdd9627cb488bb4cd91f3e8d66e32", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Polyester", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polyester" } }, { "id": "54147692cbfb43419a6d11e26cad44dc", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "L", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L" } }, { "id": "5997d91dc0784997bdef68dfc5a08912", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "M", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M" } }, { "id": "78c53f3f6dd14eb4927978415bfb74db", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man", "01989916530973118fd8e27ff0e983c6": "Mann" } }, { "id": "96638a1c7ab847bbb3ca64167ab30a3e", "_count": 1, "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32", "group": { "id": "a67cdd9627cb488bb4cd91f3e8d66e32", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton", "01989916530973118fd8e27ff0e983c6": "Baumwolle" } }, { "id": "acfd7586d02848f1ac801f4776efa414", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "XL", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "XL" } } ], "options": [ { "id": "41e5013b67d64d3a92b7a275da8af441", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "S", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S" } } ], "categoryIds": [ "019afcdabdfd778cb4532f66e8d457ca", "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33" ], "optionIds": [ "41e5013b67d64d3a92b7a275da8af441" ], "propertyIds": [ "41e5013b67d64d3a92b7a275da8af441", "5193ffa5de8648a1bcfba1fa8a26c02b", "54147692cbfb43419a6d11e26cad44dc", "5997d91dc0784997bdef68dfc5a08912", "78c53f3f6dd14eb4927978415bfb74db", "96638a1c7ab847bbb3ca64167ab30a3e", "acfd7586d02848f1ac801f4776efa414" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit Eigenschaften", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product with properties" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.799999999999997, "positions": [ { "position": 1, "categoryId": "19ca405790ff4f07aac8c599d4317868", "salesChannelId": "default", "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f" }, { "position": 2, "categoryId": "77b959cf66de4c1590c7f9b7da3982f3", "salesChannelId": "default", "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045" }, { "position": 1, "categoryId": "2185182cbbd4462ea844abeb2a438b33", "salesChannelId": "default", "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41" }, { "position": 1, "categoryId": "019afcdabdfd778cb4532f66e8d457ca", "salesChannelId": "default", "salesChannelCategoryHash": "e203d3ee8cf3f81bdfd4d60c335afa05" }, { "position": 2, "categoryId": "019afcceebca7b50b06681b11d1dc8ee", "salesChannelId": "default", "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5" }, { "position": 1, "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6", "salesChannelId": "default", "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1" }, { "position": 1, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 1, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "af160339563fcd7ae2c9becf4cd95adb" ] }, "sort": [ 1, "0198992e967c70feadad663d9cfffada" ] }, { "_index": "sw_product_1765174059", "_id": "2a88d9b59d474c7e869d8071649be43c", "_score": null, "_source": { "id": "2a88d9b59d474c7e869d8071649be43c", "autoIncrement": 3.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 10, "productNumber": "SWDEMO10001", "ean": null, "displayGroup": "ad2fab7ad7babdd7322b341443c0033b", "sales": 0, "stock": 10, "weight": 0.17, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "7f24e96676e944b0a0addc20d56728cb", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afcceebca7b50b06681b11d1dc8ee", "019afdc429a77e2a87fb8a5bc6ae48d8", "77b959cf66de4c1590c7f9b7da3982f3", "a515ae260223466f8e37471d279e6406", "019afcdabdfd778cb4532f66e8d457ca", "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33", "251448b91bc742de85643f5fccd89051" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afcceebca7b50b06681b11d1dc8ee", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "77b959cf66de4c1590c7f9b7da3982f3", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afcdabdfd778cb4532f66e8d457ca", "_count": 1 }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1 }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1 }, { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1 }, { "id": "251448b91bc742de85643f5fccd89051", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": null, "coverId": "f0e28db1195847dc9acb8eb016473e0c", "childCount": 0, "categories": [ { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Herren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Backwaren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products" } }, { "id": "251448b91bc742de85643f5fccd89051", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics" } }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } }, { "id": "019afcdabdfd778cb4532f66e8d457ca", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pies" } } ], "manufacturer": { "id": "7f24e96676e944b0a0addc20d56728cb", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion" }, "_count": 1 }, "properties": [ { "id": "6f9359239c994b48b7de282ee19a714d", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Kinder", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Children" } }, { "id": "78c53f3f6dd14eb4927978415bfb74db", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man", "01989916530973118fd8e27ff0e983c6": "Mann" } }, { "id": "7cab88165ae5420f921232511b6e8f7d", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Frau", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Woman" } }, { "id": "dc6f98beeca44852beb078a9e8e21e7d", "_count": 1, "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32", "group": { "id": "a67cdd9627cb488bb4cd91f3e8d66e32", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Plastic", "01989916530973118fd8e27ff0e983c6": "Kunstoff" } } ], "options": [], "categoryIds": [ "019afcdabdfd778cb4532f66e8d457ca", "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33", "251448b91bc742de85643f5fccd89051" ], "optionIds": [], "propertyIds": [ "6f9359239c994b48b7de282ee19a714d", "78c53f3f6dd14eb4927978415bfb74db", "7cab88165ae5420f921232511b6e8f7d", "dc6f98beeca44852beb078a9e8e21e7d" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Hauptartikel", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 495.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 416.76, "positions": [ { "position": 1, "categoryId": "251448b91bc742de85643f5fccd89051", "salesChannelId": "default", "salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b" }, { "position": 3, "categoryId": "19ca405790ff4f07aac8c599d4317868", "salesChannelId": "default", "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f" }, { "position": 4, "categoryId": "77b959cf66de4c1590c7f9b7da3982f3", "salesChannelId": "default", "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045" }, { "position": 2, "categoryId": "2185182cbbd4462ea844abeb2a438b33", "salesChannelId": "default", "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41" }, { "position": 2, "categoryId": "019afcdabdfd778cb4532f66e8d457ca", "salesChannelId": "default", "salesChannelCategoryHash": "e203d3ee8cf3f81bdfd4d60c335afa05" }, { "position": 3, "categoryId": "019afcceebca7b50b06681b11d1dc8ee", "salesChannelId": "default", "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5" }, { "position": 2, "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6", "salesChannelId": "default", "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1" }, { "position": 2, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 2, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "ad2fab7ad7babdd7322b341443c0033b" ] }, "sort": [ 2, "2a88d9b59d474c7e869d8071649be43c" ] }, { "_index": "sw_product_1765174059", "_id": "3ac014f329884b57a2cce5a29f34779c", "_score": null, "_source": { "id": "3ac014f329884b57a2cce5a29f34779c", "autoIncrement": 4.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": true, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 50, "productNumber": "SWDEMO10006", "ean": null, "displayGroup": "72358a503f8624b7a92020a0e3e551b3", "sales": 0, "stock": 50, "weight": 0.15, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "cc1c20c365d34cfb88bfab3c3e81d350", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afdc429a77e2a87fb8a5bc6ae48d8", "77b959cf66de4c1590c7f9b7da3982f3", "a515ae260223466f8e37471d279e6406", "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "77b959cf66de4c1590c7f9b7da3982f3", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1 }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1 }, { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": null, "coverId": "d6448ce8dd0e4720a92c1bdddb9e6c96", "childCount": 0, "categories": [ { "id": "2185182cbbd4462ea844abeb2a438b33", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Herren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } }, { "id": "19ca405790ff4f07aac8c599d4317868", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Backwaren", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products" } }, { "id": "019afdc46fe57db8ae1cd3e1d88652e6", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men" } } ], "manufacturer": { "id": "cc1c20c365d34cfb88bfab3c3e81d350", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Freizeit", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Freetime" }, "_count": 1 }, "properties": [ { "id": "5997d91dc0784997bdef68dfc5a08912", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "M", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M" } }, { "id": "78c53f3f6dd14eb4927978415bfb74db", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man", "01989916530973118fd8e27ff0e983c6": "Mann" } }, { "id": "c53fa30db00e4a84b4516f6b07c02e8d", "_count": 1, "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32", "group": { "id": "a67cdd9627cb488bb4cd91f3e8d66e32", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Leder", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leather" } } ], "options": [], "categoryIds": [ "019afdc46fe57db8ae1cd3e1d88652e6", "19ca405790ff4f07aac8c599d4317868", "2185182cbbd4462ea844abeb2a438b33" ], "optionIds": [], "propertyIds": [ "5997d91dc0784997bdef68dfc5a08912", "78c53f3f6dd14eb4927978415bfb74db", "c53fa30db00e4a84b4516f6b07c02e8d" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Hauptprodukt, versandkostenfrei mit Hervorhebung", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product, free shipping with highlighting" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0, "positions": [ { "position": 2, "categoryId": "19ca405790ff4f07aac8c599d4317868", "salesChannelId": "default", "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f" }, { "position": 3, "categoryId": "77b959cf66de4c1590c7f9b7da3982f3", "salesChannelId": "default", "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045" }, { "position": 3, "categoryId": "2185182cbbd4462ea844abeb2a438b33", "salesChannelId": "default", "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41" }, { "position": 3, "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6", "salesChannelId": "default", "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1" }, { "position": 3, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 3, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "72358a503f8624b7a92020a0e3e551b3" ] }, "sort": [ 3, "3ac014f329884b57a2cce5a29f34779c" ] }, { "_index": "sw_product_1765174059", "_id": "1901dc5e888f4b1ea4168c2c5f005540", "_score": null, "_source": { "id": "1901dc5e888f4b1ea4168c2c5f005540", "autoIncrement": 2.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 40, "productNumber": "SWDEMO100013", "ean": null, "displayGroup": "27c34d8a0a473716816a8631d55e660a", "sales": 0, "stock": 40, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "2326d67406134c88bcf80e52d9d2ecb7", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "77b959cf66de4c1590c7f9b7da3982f3", "019afcceebca7b50b06681b11d1dc8ee", "019afdc429a77e2a87fb8a5bc6ae48d8", "a515ae260223466f8e37471d279e6406", "019afcb13f577126aee7f2181c2b51cb", "019afcdb0bf375e4ae5c6e858392012c", "019afcdb13ae7b519cf759abd4a96845", "019afdc47f3078d3b96a7601ed293279", "48f97f432fd041388b2630184139cf0e", "8de9b484c54f441c894774e5f57e485c", "bb22b05bff9140f3808b1cff975b75eb" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "77b959cf66de4c1590c7f9b7da3982f3", "_count": 1 }, { "id": "019afcceebca7b50b06681b11d1dc8ee", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afcb13f577126aee7f2181c2b51cb", "_count": 1 }, { "id": "019afcdb0bf375e4ae5c6e858392012c", "_count": 1 }, { "id": "019afcdb13ae7b519cf759abd4a96845", "_count": 1 }, { "id": "019afdc47f3078d3b96a7601ed293279", "_count": 1 }, { "id": "48f97f432fd041388b2630184139cf0e", "_count": 1 }, { "id": "8de9b484c54f441c894774e5f57e485c", "_count": 1 }, { "id": "bb22b05bff9140f3808b1cff975b75eb", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": null, "coverId": "0ca83b27e34c4b1f9ab00aed4e3b8b03", "childCount": 0, "categories": [ { "id": "48f97f432fd041388b2630184139cf0e", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Fisch", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fish" } }, { "id": "8de9b484c54f441c894774e5f57e485c", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Damen", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women" } }, { "id": "bb22b05bff9140f3808b1cff975b75eb", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "S\u00fc\u00dfes", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweets" } }, { "id": "019afcdb0bf375e4ae5c6e858392012c", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kot" } }, { "id": "019afdc47f3078d3b96a7601ed293279", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women" } }, { "id": "019afcb13f577126aee7f2181c2b51cb", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nieaktywna" } }, { "id": "019afcdb13ae7b519cf759abd4a96845", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nieaktywna" } } ], "manufacturer": { "id": "2326d67406134c88bcf80e52d9d2ecb7", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Lebensmittel", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Food" }, "_count": 1 }, "properties": [ { "id": "22bdaee755804c1d8099c0d3696e852c", "_count": 1, "groupId": "448f3d72803f4ac8afc0c1108739ddf4", "group": { "id": "448f3d72803f4ac8afc0c1108739ddf4", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sugar", "01989916530973118fd8e27ff0e983c6": "Zucker" } }, { "id": "77421c4f75af40c8a57657cdc2ad49a2", "_count": 1, "groupId": "448f3d72803f4ac8afc0c1108739ddf4", "group": { "id": "448f3d72803f4ac8afc0c1108739ddf4", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Milk", "01989916530973118fd8e27ff0e983c6": "Milch" } } ], "options": [], "categoryIds": [ "019afcb13f577126aee7f2181c2b51cb", "019afcdb0bf375e4ae5c6e858392012c", "019afcdb13ae7b519cf759abd4a96845", "019afdc47f3078d3b96a7601ed293279", "48f97f432fd041388b2630184139cf0e", "8de9b484c54f441c894774e5f57e485c", "bb22b05bff9140f3808b1cff975b75eb" ], "optionIds": [], "propertyIds": [ "22bdaee755804c1d8099c0d3696e852c", "77421c4f75af40c8a57657cdc2ad49a2" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit Bewertungen", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women - Main product with reviews" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.67, "positions": [ { "position": 1, "categoryId": "bb22b05bff9140f3808b1cff975b75eb", "salesChannelId": "default", "salesChannelCategoryHash": "4ff12faede46f9e9dc5389b7d252e7c5" }, { "position": 1, "categoryId": "77b959cf66de4c1590c7f9b7da3982f3", "salesChannelId": "default", "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045" }, { "position": 1, "categoryId": "8de9b484c54f441c894774e5f57e485c", "salesChannelId": "default", "salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf" }, { "position": 2, "categoryId": "48f97f432fd041388b2630184139cf0e", "salesChannelId": "default", "salesChannelCategoryHash": "a5ca9fc8de162c7dbed55c9c87678169" }, { "position": 1, "categoryId": "019afcb13f577126aee7f2181c2b51cb", "salesChannelId": "default", "salesChannelCategoryHash": "8cd4c8dedc85bd81d34389c5611ac26a" }, { "position": 1, "categoryId": "019afcceebca7b50b06681b11d1dc8ee", "salesChannelId": "default", "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5" }, { "position": 2, "categoryId": "019afcdb0bf375e4ae5c6e858392012c", "salesChannelId": "default", "salesChannelCategoryHash": "7287dc69482db0d5be2cd7c276f6795a" }, { "position": 1, "categoryId": "019afcdb13ae7b519cf759abd4a96845", "salesChannelId": "default", "salesChannelCategoryHash": "365f7d40861e755e8a38c924811e76d8" }, { "position": 1, "categoryId": "019afdc47f3078d3b96a7601ed293279", "salesChannelId": "default", "salesChannelCategoryHash": "c49216facc3761ee3bd3813a11b188e6" }, { "position": 4, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 4, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "27c34d8a0a473716816a8631d55e660a" ] }, "sort": [ 4, "1901dc5e888f4b1ea4168c2c5f005540" ] }, { "_index": "sw_product_1765174059", "_id": "0198992e967b7190ab8e8721b7bfcd14", "_score": null, "_source": { "id": "0198992e967b7190ab8e8721b7bfcd14", "autoIncrement": 6.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": true, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 50, "productNumber": "SWDEMO10005.1", "ean": null, "displayGroup": "d88fdc25bf3013e9cc57d679009b77a0", "sales": 0, "stock": 50, "weight": 0.5, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "7f24e96676e944b0a0addc20d56728cb", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afcceebca7b50b06681b11d1dc8ee", "019afdc429a77e2a87fb8a5bc6ae48d8", "77b959cf66de4c1590c7f9b7da3982f3", "a515ae260223466f8e37471d279e6406", "019afcdb0bf375e4ae5c6e858392012c", "019afdc47f3078d3b96a7601ed293279", "48f97f432fd041388b2630184139cf0e", "8de9b484c54f441c894774e5f57e485c" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afcceebca7b50b06681b11d1dc8ee", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "77b959cf66de4c1590c7f9b7da3982f3", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afcdb0bf375e4ae5c6e858392012c", "_count": 1 }, { "id": "019afdc47f3078d3b96a7601ed293279", "_count": 1 }, { "id": "48f97f432fd041388b2630184139cf0e", "_count": 1 }, { "id": "8de9b484c54f441c894774e5f57e485c", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": "43a23e0c03bf4ceabc6055a2185faa87", "coverId": "55a1e7d9f9e84400a17e2b86d7a3fc89", "childCount": 0, "categories": [ { "id": "48f97f432fd041388b2630184139cf0e", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Fisch", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fish" } }, { "id": "8de9b484c54f441c894774e5f57e485c", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Damen", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women" } }, { "id": "019afcdb0bf375e4ae5c6e858392012c", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kot" } }, { "id": "019afdc47f3078d3b96a7601ed293279", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women" } } ], "manufacturer": { "id": "7f24e96676e944b0a0addc20d56728cb", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion" }, "_count": 1 }, "properties": [ { "id": "5997d91dc0784997bdef68dfc5a08912", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "M", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M" } }, { "id": "7cab88165ae5420f921232511b6e8f7d", "_count": 1, "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c", "group": { "id": "1857bb30fe6448c88f8ad331cf6dfa0c", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Frau", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Woman" } }, { "id": "96638a1c7ab847bbb3ca64167ab30a3e", "_count": 1, "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32", "group": { "id": "a67cdd9627cb488bb4cd91f3e8d66e32", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton", "01989916530973118fd8e27ff0e983c6": "Baumwolle" } }, { "id": "acfd7586d02848f1ac801f4776efa414", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "XL", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "XL" } } ], "options": [ { "id": "2bfd278e87204807a890da4a3e81dd90", "_count": 1, "groupId": "269c7e40a54a462e884edb004c5f7bc8", "group": { "id": "269c7e40a54a462e884edb004c5f7bc8", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "Blau", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Blue" } }, { "id": "5997d91dc0784997bdef68dfc5a08912", "_count": 1, "groupId": "75f353b589d04bf48e8a9ab1f5422b0e", "group": { "id": "75f353b589d04bf48e8a9ab1f5422b0e", "_count": 1 }, "name": { "01989916530973118fd8e27ff0e983c6": "M", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M" } } ], "categoryIds": [ "019afcdb0bf375e4ae5c6e858392012c", "019afdc47f3078d3b96a7601ed293279", "48f97f432fd041388b2630184139cf0e", "8de9b484c54f441c894774e5f57e485c" ], "optionIds": [ "2bfd278e87204807a890da4a3e81dd90", "5997d91dc0784997bdef68dfc5a08912" ], "propertyIds": [ "5997d91dc0784997bdef68dfc5a08912", "7cab88165ae5420f921232511b6e8f7d", "96638a1c7ab847bbb3ca64167ab30a3e", "acfd7586d02848f1ac801f4776efa414" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Variantenprodukt", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women - Variant product" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.799999999999997, "positions": [ { "position": 2, "categoryId": "8de9b484c54f441c894774e5f57e485c", "salesChannelId": "default", "salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf" }, { "position": 1, "categoryId": "48f97f432fd041388b2630184139cf0e", "salesChannelId": "default", "salesChannelCategoryHash": "a5ca9fc8de162c7dbed55c9c87678169" }, { "position": 5, "categoryId": "77b959cf66de4c1590c7f9b7da3982f3", "salesChannelId": "default", "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045" }, { "position": 1, "categoryId": "019afcdb0bf375e4ae5c6e858392012c", "salesChannelId": "default", "salesChannelCategoryHash": "7287dc69482db0d5be2cd7c276f6795a" }, { "position": 4, "categoryId": "019afcceebca7b50b06681b11d1dc8ee", "salesChannelId": "default", "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5" }, { "position": 2, "categoryId": "019afdc47f3078d3b96a7601ed293279", "salesChannelId": "default", "salesChannelCategoryHash": "c49216facc3761ee3bd3813a11b188e6" }, { "position": 5, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 5, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "d88fdc25bf3013e9cc57d679009b77a0" ] }, "sort": [ 5, "0198992e967b7190ab8e8721b7bfcd14" ] }, { "_index": "sw_product_1765174059", "_id": "019afdfcd0337768ac550c2457f71e40", "_score": null, "_source": { "id": "019afdfcd0337768ac550c2457f71e40", "autoIncrement": 17.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 20, "productNumber": "SW10000", "ean": null, "displayGroup": "c2787fbc38ccb76ba02a58eca5c4490f", "sales": 0, "stock": 20, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "7f24e96676e944b0a0addc20d56728cb", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2025-12-08T12:44:07+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afdc429a77e2a87fb8a5bc6ae48d8", "a515ae260223466f8e37471d279e6406", "019afdfbd472764b8b02fa5cef04de7c", "019afe04c2a872648d2be9c48e257a49" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afdfbd472764b8b02fa5cef04de7c", "_count": 1 }, { "id": "019afe04c2a872648d2be9c48e257a49", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": null, "coverId": "019afdfe3c6474d8bc83e21d02c9d421", "childCount": 0, "categories": [ { "id": "019afdfbd472764b8b02fa5cef04de7c", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids" } }, { "id": "019afe04c2a872648d2be9c48e257a49", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids" } } ], "manufacturer": { "id": "7f24e96676e944b0a0addc20d56728cb", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion" }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "019afdfbd472764b8b02fa5cef04de7c", "019afe04c2a872648d2be9c48e257a49" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids - Product Sorted" }, "description": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sorting product" }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 100.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 84.033613445378, "positions": [ { "position": 6, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 1, "categoryId": "019afdfbd472764b8b02fa5cef04de7c", "salesChannelId": "default", "salesChannelCategoryHash": "f6288b9317da7e723ac2429d15129d19" }, { "position": 1, "categoryId": "019afe04c2a872648d2be9c48e257a49", "salesChannelId": "default", "salesChannelCategoryHash": "3e653f27bdf0ea12af1fef007c6ad66b" }, { "position": 6, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "c2787fbc38ccb76ba02a58eca5c4490f" ] }, "sort": [ 6, "019afdfcd0337768ac550c2457f71e40" ] }, { "_index": "sw_product_1765174059", "_id": "11dc680240b04f469ccba354cbf0b967", "_score": null, "_source": { "id": "11dc680240b04f469ccba354cbf0b967", "autoIncrement": 1.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": true, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4" } ], "availableStock": 10, "productNumber": "SWDEMO10002", "ean": null, "displayGroup": "9cc83811832d4b1f1593acb545f36678", "sales": 0, "stock": 10, "weight": 45.0, "width": 590.0, "length": 840.0, "height": 600.0, "manufacturerId": "cc1c20c365d34cfb88bfab3c3e81d350", "manufacturerNumber": null, "releaseDate": "2025-08-11T12:50:23+00:00", "createdAt": "2025-08-11T12:50:24+00:00", "categoryTree": [ "01989916539d73129b95f629087f9d2b", "019afdc429a77e2a87fb8a5bc6ae48d8", "a515ae260223466f8e37471d279e6406", "019afdfbd472764b8b02fa5cef04de7c", "019afe04c2a872648d2be9c48e257a49", "251448b91bc742de85643f5fccd89051" ], "categoriesRo": [ { "id": "01989916539d73129b95f629087f9d2b", "_count": 1 }, { "id": "019afdc429a77e2a87fb8a5bc6ae48d8", "_count": 1 }, { "id": "a515ae260223466f8e37471d279e6406", "_count": 1 }, { "id": "019afdfbd472764b8b02fa5cef04de7c", "_count": 1 }, { "id": "019afe04c2a872648d2be9c48e257a49", "_count": 1 }, { "id": "251448b91bc742de85643f5fccd89051", "_count": 1 } ], "taxId": "01989916539c7054889e6a4a0f906d58", "tags": [], "parentId": null, "coverId": "e648140ff1f04177b40128ac6b649d8a", "childCount": 0, "categories": [ { "id": "251448b91bc742de85643f5fccd89051", "_count": 1, "name": { "01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics" } }, { "id": "019afdfbd472764b8b02fa5cef04de7c", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids" } }, { "id": "019afe04c2a872648d2be9c48e257a49", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids" } } ], "manufacturer": { "id": "cc1c20c365d34cfb88bfab3c3e81d350", "name": { "01989916530973118fd8e27ff0e983c6": "Shopware Freizeit", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Freetime" }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "019afdfbd472764b8b02fa5cef04de7c", "019afe04c2a872648d2be9c48e257a49", "251448b91bc742de85643f5fccd89051" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit erweiterten Preisen", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids - Main product with advanced prices" }, "description": { "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.", "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet." }, "metaTitle": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "01989916530973118fd8e27ff0e983c6": null, "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 750.0, "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 630.25, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 950.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 798.3199999999999, "positions": [ { "position": 2, "categoryId": "251448b91bc742de85643f5fccd89051", "salesChannelId": "default", "salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b" }, { "position": 2, "categoryId": "019afdfbd472764b8b02fa5cef04de7c", "salesChannelId": "default", "salesChannelCategoryHash": "f6288b9317da7e723ac2429d15129d19" }, { "position": 7, "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8", "salesChannelId": "default", "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616" }, { "position": 2, "categoryId": "019afe04c2a872648d2be9c48e257a49", "salesChannelId": "default", "salesChannelCategoryHash": "3e653f27bdf0ea12af1fef007c6ad66b" }, { "position": 7, "categoryId": "a515ae260223466f8e37471d279e6406", "salesChannelId": "default", "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0" } ] }, "fields": { "displayGroup": [ "9cc83811832d4b1f1593acb545f36678" ] }, "sort": [ 7, "11dc680240b04f469ccba354cbf0b967" ] } ] }, "aggregations": { "total-count": { "value": 7 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	7.57 ms	Request: {"index":"sw_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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"019afdc429a77e2a87fb8a5bc6ae48d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01989916538e72b183890fa62d207fcf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165398727ebc6e388b687252f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165de27144841265386485dc44_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0198991653b071658d610f622e27b218_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_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://localhost:9666/sw_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": "0198991695bc70e7b39cb015d4b9eda4" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "019afdc429a77e2a87fb8a5bc6ae48d8" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule01989916538e72b183890fa62d207fcf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019899165398727ebc6e388b687252f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule019899165de27144841265386485dc44_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule0198991653b071658d610f622e27b218_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_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": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 12, "shipping-free": { "value": 1.0, "value_as_string": "true" } }, "rating-exists": { "doc_count": 15, "rating": { "value": 0.0 } }, "price": { "count": 15, "min": 1.99, "max": 750.0, "avg": 104.52266666666667, "sum": 1567.84 }, "options": { "doc_count": 16, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "5997d91dc0784997bdef68dfc5a08912", "doc_count": 4 }, { "key": "acfd7586d02848f1ac801f4776efa414", "doc_count": 4 }, { "key": "2bfd278e87204807a890da4a3e81dd90", "doc_count": 2 }, { "key": "52454db2adf942b2ac079a296f454a10", "doc_count": 2 }, { "key": "ad735af1ebfb421e93e408b073c4a89a", "doc_count": 2 }, { "key": "41e5013b67d64d3a92b7a275da8af441", "doc_count": 1 }, { "key": "54147692cbfb43419a6d11e26cad44dc", "doc_count": 1 } ] } }, "properties": { "doc_count": 61, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "5997d91dc0784997bdef68dfc5a08912", "doc_count": 11 }, { "key": "96638a1c7ab847bbb3ca64167ab30a3e", "doc_count": 10 }, { "key": "acfd7586d02848f1ac801f4776efa414", "doc_count": 10 }, { "key": "7cab88165ae5420f921232511b6e8f7d", "doc_count": 7 }, { "key": "78c53f3f6dd14eb4927978415bfb74db", "doc_count": 6 }, { "key": "41e5013b67d64d3a92b7a275da8af441", "doc_count": 4 }, { "key": "5193ffa5de8648a1bcfba1fa8a26c02b", "doc_count": 4 }, { "key": "54147692cbfb43419a6d11e26cad44dc", "doc_count": 4 }, { "key": "22bdaee755804c1d8099c0d3696e852c", "doc_count": 1 }, { "key": "6f9359239c994b48b7de282ee19a714d", "doc_count": 1 }, { "key": "77421c4f75af40c8a57657cdc2ad49a2", "doc_count": 1 }, { "key": "c53fa30db00e4a84b4516f6b07c02e8d", "doc_count": 1 }, { "key": "dc6f98beeca44852beb078a9e8e21e7d", "doc_count": 1 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "7f24e96676e944b0a0addc20d56728cb", "doc_count": 12 }, { "key": "cc1c20c365d34cfb88bfab3c3e81d350", "doc_count": 2 }, { "key": "2326d67406134c88bcf80e52d9d2ecb7", "doc_count": 1 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw_product","search_type":"query_then_fetch","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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"019afdc429a77e2a87fb8a5bc6ae48d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"positions.position":{"nested":{"path":"positions","filter":{"term":{"positions.salesChannelCategoryHash":"32f0d3c9994e6fdb9a0f2172c7459616"}}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}

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


                                    POST http://localhost:9666/sw_product/_search?search_type=query_then_fetch&track_total_hits=1
    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": "0198991695bc70e7b39cb015d4b9eda4"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "019afdc429a77e2a87fb8a5bc6ae48d8"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "positions.position": {
                "nested": {
                    "path": "positions",
                    "filter": {
                        "term": {
                            "positions.salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        }
                    }
                },
                "order": "ASC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 15,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 15,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1765174059",
                "_id": "0198992e967c70feadad663d9cfffada",
                "_score": null,
                "_source": {
                    "id": "0198992e967c70feadad663d9cfffada",
                    "autoIncrement": 13.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": true,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 50,
                    "productNumber": "SWDEMO10007.1",
                    "ean": null,
                    "displayGroup": "af160339563fcd7ae2c9becf4cd95adb",
                    "sales": 0,
                    "stock": 50,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "7f24e96676e944b0a0addc20d56728cb",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afcceebca7b50b06681b11d1dc8ee",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "77b959cf66de4c1590c7f9b7da3982f3",
                        "a515ae260223466f8e37471d279e6406",
                        "019afcdabdfd778cb4532f66e8d457ca",
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afcceebca7b50b06681b11d1dc8ee",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "77b959cf66de4c1590c7f9b7da3982f3",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afcdabdfd778cb4532f66e8d457ca",
                            "_count": 1
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1
                        },
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": "c7bca22753c84d08b6178a50052b4146",
                    "coverId": "683c3a0a0c26464fb65332d1a9adf7e2",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Herren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Backwaren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products"
                            }
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        },
                        {
                            "id": "019afcdabdfd778cb4532f66e8d457ca",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pies"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "7f24e96676e944b0a0addc20d56728cb",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "41e5013b67d64d3a92b7a275da8af441",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "S",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S"
                            }
                        },
                        {
                            "id": "5193ffa5de8648a1bcfba1fa8a26c02b",
                            "_count": 1,
                            "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
                            "group": {
                                "id": "a67cdd9627cb488bb4cd91f3e8d66e32",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Polyester",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polyester"
                            }
                        },
                        {
                            "id": "54147692cbfb43419a6d11e26cad44dc",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "L",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "L"
                            }
                        },
                        {
                            "id": "5997d91dc0784997bdef68dfc5a08912",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "M",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M"
                            }
                        },
                        {
                            "id": "78c53f3f6dd14eb4927978415bfb74db",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man",
                                "01989916530973118fd8e27ff0e983c6": "Mann"
                            }
                        },
                        {
                            "id": "96638a1c7ab847bbb3ca64167ab30a3e",
                            "_count": 1,
                            "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
                            "group": {
                                "id": "a67cdd9627cb488bb4cd91f3e8d66e32",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton",
                                "01989916530973118fd8e27ff0e983c6": "Baumwolle"
                            }
                        },
                        {
                            "id": "acfd7586d02848f1ac801f4776efa414",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "XL",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "XL"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "41e5013b67d64d3a92b7a275da8af441",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "S",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S"
                            }
                        }
                    ],
                    "categoryIds": [
                        "019afcdabdfd778cb4532f66e8d457ca",
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33"
                    ],
                    "optionIds": [
                        "41e5013b67d64d3a92b7a275da8af441"
                    ],
                    "propertyIds": [
                        "41e5013b67d64d3a92b7a275da8af441",
                        "5193ffa5de8648a1bcfba1fa8a26c02b",
                        "54147692cbfb43419a6d11e26cad44dc",
                        "5997d91dc0784997bdef68dfc5a08912",
                        "78c53f3f6dd14eb4927978415bfb74db",
                        "96638a1c7ab847bbb3ca64167ab30a3e",
                        "acfd7586d02848f1ac801f4776efa414"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit Eigenschaften",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product with properties"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.799999999999997,
                    "positions": [
                        {
                            "position": 1,
                            "categoryId": "19ca405790ff4f07aac8c599d4317868",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f"
                        },
                        {
                            "position": 2,
                            "categoryId": "77b959cf66de4c1590c7f9b7da3982f3",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045"
                        },
                        {
                            "position": 1,
                            "categoryId": "2185182cbbd4462ea844abeb2a438b33",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afcdabdfd778cb4532f66e8d457ca",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "e203d3ee8cf3f81bdfd4d60c335afa05"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afcceebca7b50b06681b11d1dc8ee",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 1,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "af160339563fcd7ae2c9becf4cd95adb"
                    ]
                },
                "sort": [
                    1,
                    "0198992e967c70feadad663d9cfffada"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "2a88d9b59d474c7e869d8071649be43c",
                "_score": null,
                "_source": {
                    "id": "2a88d9b59d474c7e869d8071649be43c",
                    "autoIncrement": 3.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "SWDEMO10001",
                    "ean": null,
                    "displayGroup": "ad2fab7ad7babdd7322b341443c0033b",
                    "sales": 0,
                    "stock": 10,
                    "weight": 0.17,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "7f24e96676e944b0a0addc20d56728cb",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afcceebca7b50b06681b11d1dc8ee",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "77b959cf66de4c1590c7f9b7da3982f3",
                        "a515ae260223466f8e37471d279e6406",
                        "019afcdabdfd778cb4532f66e8d457ca",
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33",
                        "251448b91bc742de85643f5fccd89051"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afcceebca7b50b06681b11d1dc8ee",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "77b959cf66de4c1590c7f9b7da3982f3",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afcdabdfd778cb4532f66e8d457ca",
                            "_count": 1
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1
                        },
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1
                        },
                        {
                            "id": "251448b91bc742de85643f5fccd89051",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": null,
                    "coverId": "f0e28db1195847dc9acb8eb016473e0c",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Herren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Backwaren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products"
                            }
                        },
                        {
                            "id": "251448b91bc742de85643f5fccd89051",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics"
                            }
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        },
                        {
                            "id": "019afcdabdfd778cb4532f66e8d457ca",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pies"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "7f24e96676e944b0a0addc20d56728cb",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "6f9359239c994b48b7de282ee19a714d",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Kinder",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Children"
                            }
                        },
                        {
                            "id": "78c53f3f6dd14eb4927978415bfb74db",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man",
                                "01989916530973118fd8e27ff0e983c6": "Mann"
                            }
                        },
                        {
                            "id": "7cab88165ae5420f921232511b6e8f7d",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Frau",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Woman"
                            }
                        },
                        {
                            "id": "dc6f98beeca44852beb078a9e8e21e7d",
                            "_count": 1,
                            "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
                            "group": {
                                "id": "a67cdd9627cb488bb4cd91f3e8d66e32",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Plastic",
                                "01989916530973118fd8e27ff0e983c6": "Kunstoff"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "019afcdabdfd778cb4532f66e8d457ca",
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33",
                        "251448b91bc742de85643f5fccd89051"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "6f9359239c994b48b7de282ee19a714d",
                        "78c53f3f6dd14eb4927978415bfb74db",
                        "7cab88165ae5420f921232511b6e8f7d",
                        "dc6f98beeca44852beb078a9e8e21e7d"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Hauptartikel",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 495.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 416.76,
                    "positions": [
                        {
                            "position": 1,
                            "categoryId": "251448b91bc742de85643f5fccd89051",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b"
                        },
                        {
                            "position": 3,
                            "categoryId": "19ca405790ff4f07aac8c599d4317868",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f"
                        },
                        {
                            "position": 4,
                            "categoryId": "77b959cf66de4c1590c7f9b7da3982f3",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045"
                        },
                        {
                            "position": 2,
                            "categoryId": "2185182cbbd4462ea844abeb2a438b33",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afcdabdfd778cb4532f66e8d457ca",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "e203d3ee8cf3f81bdfd4d60c335afa05"
                        },
                        {
                            "position": 3,
                            "categoryId": "019afcceebca7b50b06681b11d1dc8ee",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 2,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "ad2fab7ad7babdd7322b341443c0033b"
                    ]
                },
                "sort": [
                    2,
                    "2a88d9b59d474c7e869d8071649be43c"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "3ac014f329884b57a2cce5a29f34779c",
                "_score": null,
                "_source": {
                    "id": "3ac014f329884b57a2cce5a29f34779c",
                    "autoIncrement": 4.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": true,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 50,
                    "productNumber": "SWDEMO10006",
                    "ean": null,
                    "displayGroup": "72358a503f8624b7a92020a0e3e551b3",
                    "sales": 0,
                    "stock": 50,
                    "weight": 0.15,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "cc1c20c365d34cfb88bfab3c3e81d350",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "77b959cf66de4c1590c7f9b7da3982f3",
                        "a515ae260223466f8e37471d279e6406",
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "77b959cf66de4c1590c7f9b7da3982f3",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1
                        },
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": null,
                    "coverId": "d6448ce8dd0e4720a92c1bdddb9e6c96",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "2185182cbbd4462ea844abeb2a438b33",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Herren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        },
                        {
                            "id": "19ca405790ff4f07aac8c599d4317868",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Backwaren",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bakery products"
                            }
                        },
                        {
                            "id": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "cc1c20c365d34cfb88bfab3c3e81d350",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Freizeit",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Freetime"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "5997d91dc0784997bdef68dfc5a08912",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "M",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M"
                            }
                        },
                        {
                            "id": "78c53f3f6dd14eb4927978415bfb74db",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man",
                                "01989916530973118fd8e27ff0e983c6": "Mann"
                            }
                        },
                        {
                            "id": "c53fa30db00e4a84b4516f6b07c02e8d",
                            "_count": 1,
                            "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
                            "group": {
                                "id": "a67cdd9627cb488bb4cd91f3e8d66e32",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Leder",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leather"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "019afdc46fe57db8ae1cd3e1d88652e6",
                        "19ca405790ff4f07aac8c599d4317868",
                        "2185182cbbd4462ea844abeb2a438b33"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "5997d91dc0784997bdef68dfc5a08912",
                        "78c53f3f6dd14eb4927978415bfb74db",
                        "c53fa30db00e4a84b4516f6b07c02e8d"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Hauptprodukt, versandkostenfrei mit Hervorhebung",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product, free shipping with highlighting"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.0,
                    "positions": [
                        {
                            "position": 2,
                            "categoryId": "19ca405790ff4f07aac8c599d4317868",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "3c3115dd09210847624eaa18d222b76f"
                        },
                        {
                            "position": 3,
                            "categoryId": "77b959cf66de4c1590c7f9b7da3982f3",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045"
                        },
                        {
                            "position": 3,
                            "categoryId": "2185182cbbd4462ea844abeb2a438b33",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
                        },
                        {
                            "position": 3,
                            "categoryId": "019afdc46fe57db8ae1cd3e1d88652e6",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "94e00cd8520b60a7e0599cba6a1b12b1"
                        },
                        {
                            "position": 3,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 3,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "72358a503f8624b7a92020a0e3e551b3"
                    ]
                },
                "sort": [
                    3,
                    "3ac014f329884b57a2cce5a29f34779c"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "1901dc5e888f4b1ea4168c2c5f005540",
                "_score": null,
                "_source": {
                    "id": "1901dc5e888f4b1ea4168c2c5f005540",
                    "autoIncrement": 2.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 40,
                    "productNumber": "SWDEMO100013",
                    "ean": null,
                    "displayGroup": "27c34d8a0a473716816a8631d55e660a",
                    "sales": 0,
                    "stock": 40,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "2326d67406134c88bcf80e52d9d2ecb7",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "77b959cf66de4c1590c7f9b7da3982f3",
                        "019afcceebca7b50b06681b11d1dc8ee",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "a515ae260223466f8e37471d279e6406",
                        "019afcb13f577126aee7f2181c2b51cb",
                        "019afcdb0bf375e4ae5c6e858392012c",
                        "019afcdb13ae7b519cf759abd4a96845",
                        "019afdc47f3078d3b96a7601ed293279",
                        "48f97f432fd041388b2630184139cf0e",
                        "8de9b484c54f441c894774e5f57e485c",
                        "bb22b05bff9140f3808b1cff975b75eb"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "77b959cf66de4c1590c7f9b7da3982f3",
                            "_count": 1
                        },
                        {
                            "id": "019afcceebca7b50b06681b11d1dc8ee",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afcb13f577126aee7f2181c2b51cb",
                            "_count": 1
                        },
                        {
                            "id": "019afcdb0bf375e4ae5c6e858392012c",
                            "_count": 1
                        },
                        {
                            "id": "019afcdb13ae7b519cf759abd4a96845",
                            "_count": 1
                        },
                        {
                            "id": "019afdc47f3078d3b96a7601ed293279",
                            "_count": 1
                        },
                        {
                            "id": "48f97f432fd041388b2630184139cf0e",
                            "_count": 1
                        },
                        {
                            "id": "8de9b484c54f441c894774e5f57e485c",
                            "_count": 1
                        },
                        {
                            "id": "bb22b05bff9140f3808b1cff975b75eb",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0ca83b27e34c4b1f9ab00aed4e3b8b03",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "48f97f432fd041388b2630184139cf0e",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Fisch",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fish"
                            }
                        },
                        {
                            "id": "8de9b484c54f441c894774e5f57e485c",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Damen",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women"
                            }
                        },
                        {
                            "id": "bb22b05bff9140f3808b1cff975b75eb",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "S\u00fc\u00dfes",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweets"
                            }
                        },
                        {
                            "id": "019afcdb0bf375e4ae5c6e858392012c",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kot"
                            }
                        },
                        {
                            "id": "019afdc47f3078d3b96a7601ed293279",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women"
                            }
                        },
                        {
                            "id": "019afcb13f577126aee7f2181c2b51cb",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nieaktywna"
                            }
                        },
                        {
                            "id": "019afcdb13ae7b519cf759abd4a96845",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nieaktywna"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "2326d67406134c88bcf80e52d9d2ecb7",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Lebensmittel",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Food"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "22bdaee755804c1d8099c0d3696e852c",
                            "_count": 1,
                            "groupId": "448f3d72803f4ac8afc0c1108739ddf4",
                            "group": {
                                "id": "448f3d72803f4ac8afc0c1108739ddf4",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sugar",
                                "01989916530973118fd8e27ff0e983c6": "Zucker"
                            }
                        },
                        {
                            "id": "77421c4f75af40c8a57657cdc2ad49a2",
                            "_count": 1,
                            "groupId": "448f3d72803f4ac8afc0c1108739ddf4",
                            "group": {
                                "id": "448f3d72803f4ac8afc0c1108739ddf4",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Milk",
                                "01989916530973118fd8e27ff0e983c6": "Milch"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "019afcb13f577126aee7f2181c2b51cb",
                        "019afcdb0bf375e4ae5c6e858392012c",
                        "019afcdb13ae7b519cf759abd4a96845",
                        "019afdc47f3078d3b96a7601ed293279",
                        "48f97f432fd041388b2630184139cf0e",
                        "8de9b484c54f441c894774e5f57e485c",
                        "bb22b05bff9140f3808b1cff975b75eb"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "22bdaee755804c1d8099c0d3696e852c",
                        "77421c4f75af40c8a57657cdc2ad49a2"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit Bewertungen",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women - Main product with reviews"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.67,
                    "positions": [
                        {
                            "position": 1,
                            "categoryId": "bb22b05bff9140f3808b1cff975b75eb",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "4ff12faede46f9e9dc5389b7d252e7c5"
                        },
                        {
                            "position": 1,
                            "categoryId": "77b959cf66de4c1590c7f9b7da3982f3",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045"
                        },
                        {
                            "position": 1,
                            "categoryId": "8de9b484c54f441c894774e5f57e485c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf"
                        },
                        {
                            "position": 2,
                            "categoryId": "48f97f432fd041388b2630184139cf0e",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "a5ca9fc8de162c7dbed55c9c87678169"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afcb13f577126aee7f2181c2b51cb",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8cd4c8dedc85bd81d34389c5611ac26a"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afcceebca7b50b06681b11d1dc8ee",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afcdb0bf375e4ae5c6e858392012c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "7287dc69482db0d5be2cd7c276f6795a"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afcdb13ae7b519cf759abd4a96845",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "365f7d40861e755e8a38c924811e76d8"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afdc47f3078d3b96a7601ed293279",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "c49216facc3761ee3bd3813a11b188e6"
                        },
                        {
                            "position": 4,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 4,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "27c34d8a0a473716816a8631d55e660a"
                    ]
                },
                "sort": [
                    4,
                    "1901dc5e888f4b1ea4168c2c5f005540"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "0198992e967b7190ab8e8721b7bfcd14",
                "_score": null,
                "_source": {
                    "id": "0198992e967b7190ab8e8721b7bfcd14",
                    "autoIncrement": 6.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": true,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 50,
                    "productNumber": "SWDEMO10005.1",
                    "ean": null,
                    "displayGroup": "d88fdc25bf3013e9cc57d679009b77a0",
                    "sales": 0,
                    "stock": 50,
                    "weight": 0.5,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "7f24e96676e944b0a0addc20d56728cb",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afcceebca7b50b06681b11d1dc8ee",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "77b959cf66de4c1590c7f9b7da3982f3",
                        "a515ae260223466f8e37471d279e6406",
                        "019afcdb0bf375e4ae5c6e858392012c",
                        "019afdc47f3078d3b96a7601ed293279",
                        "48f97f432fd041388b2630184139cf0e",
                        "8de9b484c54f441c894774e5f57e485c"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afcceebca7b50b06681b11d1dc8ee",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "77b959cf66de4c1590c7f9b7da3982f3",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afcdb0bf375e4ae5c6e858392012c",
                            "_count": 1
                        },
                        {
                            "id": "019afdc47f3078d3b96a7601ed293279",
                            "_count": 1
                        },
                        {
                            "id": "48f97f432fd041388b2630184139cf0e",
                            "_count": 1
                        },
                        {
                            "id": "8de9b484c54f441c894774e5f57e485c",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": "43a23e0c03bf4ceabc6055a2185faa87",
                    "coverId": "55a1e7d9f9e84400a17e2b86d7a3fc89",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "48f97f432fd041388b2630184139cf0e",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Fisch",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fish"
                            }
                        },
                        {
                            "id": "8de9b484c54f441c894774e5f57e485c",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Damen",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women"
                            }
                        },
                        {
                            "id": "019afcdb0bf375e4ae5c6e858392012c",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kot"
                            }
                        },
                        {
                            "id": "019afdc47f3078d3b96a7601ed293279",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "7f24e96676e944b0a0addc20d56728cb",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "5997d91dc0784997bdef68dfc5a08912",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "M",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M"
                            }
                        },
                        {
                            "id": "7cab88165ae5420f921232511b6e8f7d",
                            "_count": 1,
                            "groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
                            "group": {
                                "id": "1857bb30fe6448c88f8ad331cf6dfa0c",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Frau",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Woman"
                            }
                        },
                        {
                            "id": "96638a1c7ab847bbb3ca64167ab30a3e",
                            "_count": 1,
                            "groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
                            "group": {
                                "id": "a67cdd9627cb488bb4cd91f3e8d66e32",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton",
                                "01989916530973118fd8e27ff0e983c6": "Baumwolle"
                            }
                        },
                        {
                            "id": "acfd7586d02848f1ac801f4776efa414",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "XL",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "XL"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "2bfd278e87204807a890da4a3e81dd90",
                            "_count": 1,
                            "groupId": "269c7e40a54a462e884edb004c5f7bc8",
                            "group": {
                                "id": "269c7e40a54a462e884edb004c5f7bc8",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Blau",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Blue"
                            }
                        },
                        {
                            "id": "5997d91dc0784997bdef68dfc5a08912",
                            "_count": 1,
                            "groupId": "75f353b589d04bf48e8a9ab1f5422b0e",
                            "group": {
                                "id": "75f353b589d04bf48e8a9ab1f5422b0e",
                                "_count": 1
                            },
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "M",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M"
                            }
                        }
                    ],
                    "categoryIds": [
                        "019afcdb0bf375e4ae5c6e858392012c",
                        "019afdc47f3078d3b96a7601ed293279",
                        "48f97f432fd041388b2630184139cf0e",
                        "8de9b484c54f441c894774e5f57e485c"
                    ],
                    "optionIds": [
                        "2bfd278e87204807a890da4a3e81dd90",
                        "5997d91dc0784997bdef68dfc5a08912"
                    ],
                    "propertyIds": [
                        "5997d91dc0784997bdef68dfc5a08912",
                        "7cab88165ae5420f921232511b6e8f7d",
                        "96638a1c7ab847bbb3ca64167ab30a3e",
                        "acfd7586d02848f1ac801f4776efa414"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Variantenprodukt",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women - Variant product"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.799999999999997,
                    "positions": [
                        {
                            "position": 2,
                            "categoryId": "8de9b484c54f441c894774e5f57e485c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf"
                        },
                        {
                            "position": 1,
                            "categoryId": "48f97f432fd041388b2630184139cf0e",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "a5ca9fc8de162c7dbed55c9c87678169"
                        },
                        {
                            "position": 5,
                            "categoryId": "77b959cf66de4c1590c7f9b7da3982f3",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "8040fd52adc6805cfc2e2ce5d7692045"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afcdb0bf375e4ae5c6e858392012c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "7287dc69482db0d5be2cd7c276f6795a"
                        },
                        {
                            "position": 4,
                            "categoryId": "019afcceebca7b50b06681b11d1dc8ee",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "137f3d722d70079143ee7e6edc8be8b5"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afdc47f3078d3b96a7601ed293279",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "c49216facc3761ee3bd3813a11b188e6"
                        },
                        {
                            "position": 5,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 5,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "d88fdc25bf3013e9cc57d679009b77a0"
                    ]
                },
                "sort": [
                    5,
                    "0198992e967b7190ab8e8721b7bfcd14"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "019afdfcd0337768ac550c2457f71e40",
                "_score": null,
                "_source": {
                    "id": "019afdfcd0337768ac550c2457f71e40",
                    "autoIncrement": 17.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 20,
                    "productNumber": "SW10000",
                    "ean": null,
                    "displayGroup": "c2787fbc38ccb76ba02a58eca5c4490f",
                    "sales": 0,
                    "stock": 20,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "7f24e96676e944b0a0addc20d56728cb",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2025-12-08T12:44:07+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "a515ae260223466f8e37471d279e6406",
                        "019afdfbd472764b8b02fa5cef04de7c",
                        "019afe04c2a872648d2be9c48e257a49"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afdfbd472764b8b02fa5cef04de7c",
                            "_count": 1
                        },
                        {
                            "id": "019afe04c2a872648d2be9c48e257a49",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019afdfe3c6474d8bc83e21d02c9d421",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "019afdfbd472764b8b02fa5cef04de7c",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids"
                            }
                        },
                        {
                            "id": "019afe04c2a872648d2be9c48e257a49",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "7f24e96676e944b0a0addc20d56728cb",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Kleidung",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion"
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "019afdfbd472764b8b02fa5cef04de7c",
                        "019afe04c2a872648d2be9c48e257a49"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids - Product Sorted"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sorting product"
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 100.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 84.033613445378,
                    "positions": [
                        {
                            "position": 6,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afdfbd472764b8b02fa5cef04de7c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "f6288b9317da7e723ac2429d15129d19"
                        },
                        {
                            "position": 1,
                            "categoryId": "019afe04c2a872648d2be9c48e257a49",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "3e653f27bdf0ea12af1fef007c6ad66b"
                        },
                        {
                            "position": 6,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c2787fbc38ccb76ba02a58eca5c4490f"
                    ]
                },
                "sort": [
                    6,
                    "019afdfcd0337768ac550c2457f71e40"
                ]
            },
            {
                "_index": "sw_product_1765174059",
                "_id": "11dc680240b04f469ccba354cbf0b967",
                "_score": null,
                "_source": {
                    "id": "11dc680240b04f469ccba354cbf0b967",
                    "autoIncrement": 1.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": true,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
                        }
                    ],
                    "availableStock": 10,
                    "productNumber": "SWDEMO10002",
                    "ean": null,
                    "displayGroup": "9cc83811832d4b1f1593acb545f36678",
                    "sales": 0,
                    "stock": 10,
                    "weight": 45.0,
                    "width": 590.0,
                    "length": 840.0,
                    "height": 600.0,
                    "manufacturerId": "cc1c20c365d34cfb88bfab3c3e81d350",
                    "manufacturerNumber": null,
                    "releaseDate": "2025-08-11T12:50:23+00:00",
                    "createdAt": "2025-08-11T12:50:24+00:00",
                    "categoryTree": [
                        "01989916539d73129b95f629087f9d2b",
                        "019afdc429a77e2a87fb8a5bc6ae48d8",
                        "a515ae260223466f8e37471d279e6406",
                        "019afdfbd472764b8b02fa5cef04de7c",
                        "019afe04c2a872648d2be9c48e257a49",
                        "251448b91bc742de85643f5fccd89051"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01989916539d73129b95f629087f9d2b",
                            "_count": 1
                        },
                        {
                            "id": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "_count": 1
                        },
                        {
                            "id": "a515ae260223466f8e37471d279e6406",
                            "_count": 1
                        },
                        {
                            "id": "019afdfbd472764b8b02fa5cef04de7c",
                            "_count": 1
                        },
                        {
                            "id": "019afe04c2a872648d2be9c48e257a49",
                            "_count": 1
                        },
                        {
                            "id": "251448b91bc742de85643f5fccd89051",
                            "_count": 1
                        }
                    ],
                    "taxId": "01989916539c7054889e6a4a0f906d58",
                    "tags": [],
                    "parentId": null,
                    "coverId": "e648140ff1f04177b40128ac6b649d8a",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "251448b91bc742de85643f5fccd89051",
                            "_count": 1,
                            "name": {
                                "01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro",
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics"
                            }
                        },
                        {
                            "id": "019afdfbd472764b8b02fa5cef04de7c",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids"
                            }
                        },
                        {
                            "id": "019afe04c2a872648d2be9c48e257a49",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "cc1c20c365d34cfb88bfab3c3e81d350",
                        "name": {
                            "01989916530973118fd8e27ff0e983c6": "Shopware Freizeit",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Freetime"
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "019afdfbd472764b8b02fa5cef04de7c",
                        "019afe04c2a872648d2be9c48e257a49",
                        "251448b91bc742de85643f5fccd89051"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit erweiterten Preisen",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kids - Main product with advanced prices"
                    },
                    "description": {
                        "01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
                    },
                    "metaTitle": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "01989916530973118fd8e27ff0e983c6": null,
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 750.0,
                    "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 630.25,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 950.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 798.3199999999999,
                    "positions": [
                        {
                            "position": 2,
                            "categoryId": "251448b91bc742de85643f5fccd89051",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afdfbd472764b8b02fa5cef04de7c",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "f6288b9317da7e723ac2429d15129d19"
                        },
                        {
                            "position": 7,
                            "categoryId": "019afdc429a77e2a87fb8a5bc6ae48d8",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "32f0d3c9994e6fdb9a0f2172c7459616"
                        },
                        {
                            "position": 2,
                            "categoryId": "019afe04c2a872648d2be9c48e257a49",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "3e653f27bdf0ea12af1fef007c6ad66b"
                        },
                        {
                            "position": 7,
                            "categoryId": "a515ae260223466f8e37471d279e6406",
                            "salesChannelId": "default",
                            "salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
                        }
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "9cc83811832d4b1f1593acb545f36678"
                    ]
                },
                "sort": [
                    7,
                    "11dc680240b04f469ccba354cbf0b967"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 7
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

7.57 ms

Request:

{"index":"sw_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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"019afdc429a77e2a87fb8a5bc6ae48d8"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01989916538e72b183890fa62d207fcf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165398727ebc6e388b687252f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165de27144841265386485dc44_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0198991653b071658d610f622e27b218_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_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://localhost:9666/sw_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": "0198991695bc70e7b39cb015d4b9eda4"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "019afdc429a77e2a87fb8a5bc6ae48d8"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule01989916538e72b183890fa62d207fcf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019899165398727ebc6e388b687252f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule019899165de27144841265386485dc44_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule0198991653b071658d610f622e27b218_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_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": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 12,
            "shipping-free": {
                "value": 1.0,
                "value_as_string": "true"
            }
        },
        "rating-exists": {
            "doc_count": 15,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 15,
            "min": 1.99,
            "max": 750.0,
            "avg": 104.52266666666667,
            "sum": 1567.84
        },
        "options": {
            "doc_count": 16,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "5997d91dc0784997bdef68dfc5a08912",
                        "doc_count": 4
                    },
                    {
                        "key": "acfd7586d02848f1ac801f4776efa414",
                        "doc_count": 4
                    },
                    {
                        "key": "2bfd278e87204807a890da4a3e81dd90",
                        "doc_count": 2
                    },
                    {
                        "key": "52454db2adf942b2ac079a296f454a10",
                        "doc_count": 2
                    },
                    {
                        "key": "ad735af1ebfb421e93e408b073c4a89a",
                        "doc_count": 2
                    },
                    {
                        "key": "41e5013b67d64d3a92b7a275da8af441",
                        "doc_count": 1
                    },
                    {
                        "key": "54147692cbfb43419a6d11e26cad44dc",
                        "doc_count": 1
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 61,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "5997d91dc0784997bdef68dfc5a08912",
                        "doc_count": 11
                    },
                    {
                        "key": "96638a1c7ab847bbb3ca64167ab30a3e",
                        "doc_count": 10
                    },
                    {
                        "key": "acfd7586d02848f1ac801f4776efa414",
                        "doc_count": 10
                    },
                    {
                        "key": "7cab88165ae5420f921232511b6e8f7d",
                        "doc_count": 7
                    },
                    {
                        "key": "78c53f3f6dd14eb4927978415bfb74db",
                        "doc_count": 6
                    },
                    {
                        "key": "41e5013b67d64d3a92b7a275da8af441",
                        "doc_count": 4
                    },
                    {
                        "key": "5193ffa5de8648a1bcfba1fa8a26c02b",
                        "doc_count": 4
                    },
                    {
                        "key": "54147692cbfb43419a6d11e26cad44dc",
                        "doc_count": 4
                    },
                    {
                        "key": "22bdaee755804c1d8099c0d3696e852c",
                        "doc_count": 1
                    },
                    {
                        "key": "6f9359239c994b48b7de282ee19a714d",
                        "doc_count": 1
                    },
                    {
                        "key": "77421c4f75af40c8a57657cdc2ad49a2",
                        "doc_count": 1
                    },
                    {
                        "key": "c53fa30db00e4a84b4516f6b07c02e8d",
                        "doc_count": 1
                    },
                    {
                        "key": "dc6f98beeca44852beb078a9e8e21e7d",
                        "doc_count": 1
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "7f24e96676e944b0a0addc20d56728cb",
                    "doc_count": 12
                },
                {
                    "key": "cc1c20c365d34cfb88bfab3c3e81d350",
                    "doc_count": 2
                },
                {
                    "key": "2326d67406134c88bcf80e52d9d2ecb7",
                    "doc_count": 1
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "docker-cluster",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 9,
    "active_shards": 9,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 18,
    "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": 33.33333333333333
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw_product_1765174059	open	3, 3	488
.opensearch-observability	open	1, 0	0
.plugins-ml-config	open	1, 0	1
sw_product_1764941511	open	3, 3	268

Symfony Profiler

GET https://advanced-sort.crehler.dev/navigation/019afdc429a77e2a87fb8a5bc6ae48d8

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices