| 1 |
44.99 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":"a515ae260223466f8e37471d279e6406"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"positions.position":{"nested":{"path":"positions","filter":{"term":{"positions.salesChannelCategoryHash":"23e3074461b5f36ceb1d7e570043e8f2"}}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 22,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 13,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1764941511",
"_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",
"a515ae260223466f8e37471d279e6406",
"8de9b484c54f441c894774e5f57e485c"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_count": 1
},
{
"id": "8de9b484c54f441c894774e5f57e485c",
"_count": 1
}
],
"taxId": "01989916539c7054889e6a4a0f906d58",
"tags": [],
"parentId": "43a23e0c03bf4ceabc6055a2185faa87",
"coverId": "55a1e7d9f9e84400a17e2b86d7a3fc89",
"childCount": 0,
"categories": [
{
"id": "8de9b484c54f441c894774e5f57e485c",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Damen",
"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": [
"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": 1,
"categoryId": "8de9b484c54f441c894774e5f57e485c",
"salesChannelId": "default",
"salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf"
},
{
"position": 1,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"d88fdc25bf3013e9cc57d679009b77a0"
]
},
"sort": [
9223372036854775807,
"0198992e967b7190ab8e8721b7bfcd14"
]
},
{
"_index": "sw_product_1764941511",
"_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",
"a515ae260223466f8e37471d279e6406",
"2185182cbbd4462ea844abeb2a438b33"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_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"
}
}
],
"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": [
"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": 2,
"categoryId": "2185182cbbd4462ea844abeb2a438b33",
"salesChannelId": "default",
"salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
},
{
"position": 4,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"af160339563fcd7ae2c9becf4cd95adb"
]
},
"sort": [
9223372036854775807,
"0198992e967c70feadad663d9cfffada"
]
},
{
"_index": "sw_product_1764941511",
"_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",
"a515ae260223466f8e37471d279e6406",
"77b959cf66de4c1590c7f9b7da3982f3",
"8de9b484c54f441c894774e5f57e485c",
"bb22b05bff9140f3808b1cff975b75eb"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_count": 1
},
{
"id": "77b959cf66de4c1590c7f9b7da3982f3",
"_count": 1
},
{
"id": "8de9b484c54f441c894774e5f57e485c",
"_count": 1
},
{
"id": "bb22b05bff9140f3808b1cff975b75eb",
"_count": 1
}
],
"taxId": "01989916539c7054889e6a4a0f906d58",
"tags": [],
"parentId": null,
"coverId": "0ca83b27e34c4b1f9ab00aed4e3b8b03",
"childCount": 0,
"categories": [
{
"id": "8de9b484c54f441c894774e5f57e485c",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Damen",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Women"
}
},
{
"id": "bb22b05bff9140f3808b1cff975b75eb",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "S\u00fc\u00dfes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sweets"
}
}
],
"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": [
"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": 2,
"categoryId": "8de9b484c54f441c894774e5f57e485c",
"salesChannelId": "default",
"salesChannelCategoryHash": "f2a412f76ea74ca18975ec38ee44cddf"
},
{
"position": 2,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"27c34d8a0a473716816a8631d55e660a"
]
},
"sort": [
9223372036854775807,
"1901dc5e888f4b1ea4168c2c5f005540"
]
},
{
"_index": "sw_product_1764941511",
"_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",
"a515ae260223466f8e37471d279e6406",
"2185182cbbd4462ea844abeb2a438b33",
"251448b91bc742de85643f5fccd89051"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_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": "251448b91bc742de85643f5fccd89051",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics"
}
}
],
"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": [
"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": "2185182cbbd4462ea844abeb2a438b33",
"salesChannelId": "default",
"salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
},
{
"position": 5,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"ad2fab7ad7babdd7322b341443c0033b"
]
},
"sort": [
9223372036854775807,
"2a88d9b59d474c7e869d8071649be43c"
]
},
{
"_index": "sw_product_1764941511",
"_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",
"a515ae260223466f8e37471d279e6406",
"2185182cbbd4462ea844abeb2a438b33"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_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"
}
}
],
"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": [
"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": 1,
"categoryId": "2185182cbbd4462ea844abeb2a438b33",
"salesChannelId": "default",
"salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
},
{
"position": 3,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"72358a503f8624b7a92020a0e3e551b3"
]
},
"sort": [
9223372036854775807,
"3ac014f329884b57a2cce5a29f34779c"
]
}
]
},
"aggregations": {
"total-count": {
"value": 5
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
25.18 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":"a515ae260223466f8e37471d279e6406"}}}},{"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"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|