| 1 |
17.02 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":"48f97f432fd041388b2630184139cf0e"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"positions.position":{"nested":{"path":"positions","filter":{"term":{"positions.salesChannelCategoryHash":"a5ca9fc8de162c7dbed55c9c87678169"}}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 6,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 7,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_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": [
1,
"0198992e967b7190ab8e8721b7bfcd14"
]
},
{
"_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": [
2,
"1901dc5e888f4b1ea4168c2c5f005540"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
15.38 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":"48f97f432fd041388b2630184139cf0e"}}}},{"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
|