| 1 |
3.15 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":"3aaa0b8abe954c09892d40b581d29df3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"eda4ad354a9a5893bedb63e5d48ee35c"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":30,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 4,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "009b13b1b2855857bc6494d54c1f2a32",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "009b13b1b2855857bc6494d54c1f2a32",
"autoIncrement": 6252.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "135-41611",
"ean": "4013285416110",
"displayGroup": "abcb36266cb3fb1cdbe745cbacf2e265",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "41611",
"releaseDate": null,
"createdAt": "2024-08-28T02:26:16+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "0ea0e947c6cf56b0a21aca488d2573dd",
"childCount": 0,
"categories": [
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bastelmaterial"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
}
],
"options": [],
"categoryIds": [
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"a7bf0a869ea95f54aad9e1cdfe705db5"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBP",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-03-05 05:47:46.001",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "41611 Dachplatten"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F\u00fcr Dachneigungen zwischen 35 und 55 Grad. Zur Komplettierung empfehlen wir den Art. 135-41609 Dachrinnen, Fallrohre.\n2 St\u00fcck mit Firstabschluss\n2 St\u00fcck ohne Firstabschluss.\n\nJe 200 x 80 mm"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.77310924369748,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.06,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.06
},
"fields": {
"displayGroup": [
"abcb36266cb3fb1cdbe745cbacf2e265"
]
},
"sort": [
0,
"009b13b1b2855857bc6494d54c1f2a32"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "00c22ffe24ca539cb78dae9cd59c16ff",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "00c22ffe24ca539cb78dae9cd59c16ff",
"autoIncrement": 6054.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "135-52232",
"ean": "4013285522323",
"displayGroup": "38c781f6fb128c11f9edbf5860df6761",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "52232",
"releaseDate": null,
"createdAt": "2024-08-28T02:11:48+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "72613f7f822e50319285bdb0eccb922f",
"childCount": 0,
"categories": [
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bastelmaterial"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "ad56a3facf30589e9b146e0e872c3343",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alle Ma\u00dfst\u00e4be"
}
}
],
"options": [],
"categoryIds": [
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"optionIds": [],
"propertyIds": [
"ad56a3facf30589e9b146e0e872c3343"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBP",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-03-05 05:26:48.934",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52232 Dekorplatte Trapezblech rotbraun"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aus Kunststoff. Sehr stabil, fein strukturiert, vielseitig einsetzbar.\nFarbabweichungen je Charge m\u00f6glich.\n2 St\u00fcck\n\nje 100 x 200 mm"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.1,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.966386554621849,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.13
},
"fields": {
"displayGroup": [
"38c781f6fb128c11f9edbf5860df6761"
]
},
"sort": [
0,
"00c22ffe24ca539cb78dae9cd59c16ff"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "011884b9ba7d58379624e4974a2f02b6",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "011884b9ba7d58379624e4974a2f02b6",
"autoIncrement": 5576.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "135-52418",
"ean": "4013285524181",
"displayGroup": "1fe2457a8dc8b588617d249a46b9ac2a",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "52418",
"releaseDate": null,
"createdAt": "2024-08-27T16:43:36+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "bfc85378d235552f98475c164eb30164",
"childCount": 0,
"categories": [
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bastelmaterial"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "74c2f7f3cafe569281287ebf4bd3a1b0",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:120"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
},
{
"id": "ec9aa648a19653c1b8da667f029afb76",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur TT"
}
}
],
"options": [],
"categoryIds": [
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"74c2f7f3cafe569281287ebf4bd3a1b0",
"a7bf0a869ea95f54aad9e1cdfe705db5",
"ec9aa648a19653c1b8da667f029afb76"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBP",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-03-05 03:28:48.921",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52418 Dekorplatte Bretterwand holzfarbig lose"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aus Kunststoff. Sehr stabil, fein strukturiert, vielseitig einsetzbar.\nFarbabweichungen je Charge m\u00f6glich.\n\n100 x 200 mm"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.100840336134454,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.71,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.71
},
"fields": {
"displayGroup": [
"1fe2457a8dc8b588617d249a46b9ac2a"
]
},
"sort": [
0,
"011884b9ba7d58379624e4974a2f02b6"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "01721735ac5f5cd9a1b0bd90c2ab224d",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "01721735ac5f5cd9a1b0bd90c2ab224d",
"autoIncrement": 6606.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 8,
"productNumber": "135-52423",
"ean": "4013285524235",
"displayGroup": "6b0046ca5f9cc2c4af06b0f8f565e821",
"sales": 0,
"stock": 8,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "52423",
"releaseDate": null,
"createdAt": "2024-08-28T04:27:22+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"e37bb61902b64d49a0a4636302925e4f",
"e463192ee1344ba785e6c3fb01c12a0b",
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "e37bb61902b64d49a0a4636302925e4f",
"_count": 1
},
{
"id": "e463192ee1344ba785e6c3fb01c12a0b",
"_count": 1
},
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "fdbb07b4cb425ca39f1d19ecfcc167cf",
"childCount": 0,
"categories": [
{
"id": "eda4ad354a9a5893bedb63e5d48ee35c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bastelmaterial"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "5c7c0cabef365bd28653e9d4e0f81045",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur H0"
}
},
{
"id": "74c2f7f3cafe569281287ebf4bd3a1b0",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:120"
}
},
{
"id": "a7bf0a869ea95f54aad9e1cdfe705db5",
"_count": 1,
"groupId": "0670df00da5d528a9b01a0c8b8b0fe18",
"group": {
"id": "0670df00da5d528a9b01a0c8b8b0fe18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1:87"
}
},
{
"id": "ec9aa648a19653c1b8da667f029afb76",
"_count": 1,
"groupId": "a61efc337e945b4ebe4b4c292268087c",
"group": {
"id": "a61efc337e945b4ebe4b4c292268087c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spur TT"
}
}
],
"options": [],
"categoryIds": [
"eda4ad354a9a5893bedb63e5d48ee35c"
],
"optionIds": [],
"propertyIds": [
"5c7c0cabef365bd28653e9d4e0f81045",
"74c2f7f3cafe569281287ebf4bd3a1b0",
"a7bf0a869ea95f54aad9e1cdfe705db5",
"ec9aa648a19653c1b8da667f029afb76"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "MBP",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-06-26 13:09:07.042",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52423 Dekorplatte Fu\u00dfsteig grau lose"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aus Kunststoff. Sehr stabil, fein strukturiert, vielseitig einsetzbar.\nFarbabweichungen je Charge m\u00f6glich.\n\n100 x 200 mm"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.5,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.100840336134454,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.71,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.71
},
"fields": {
"displayGroup": [
"6b0046ca5f9cc2c4af06b0f8f565e821"
]
},
"sort": [
0,
"01721735ac5f5cd9a1b0bd90c2ab224d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 4
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.55 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":"3aaa0b8abe954c09892d40b581d29df3"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"eda4ad354a9a5893bedb63e5d48ee35c"}}}},{"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_rule7f7788cf3af2461baf0501b1d3fa3467_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule84eba0cd9f104132abf16ec7cab16db3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled6d70f6002614a40953d9876e8009c60_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule49847b689f7f42c281e8fab5fadaf4cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc039c828d144b038fa68a61ff71e438_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}}}},"is-in-stock-filter":{"filter":{"range":{"stock":{"gt":0}}},"aggregations":{"is-in-stock":{"max":{"field":"stock"}}}},"active-filter":{"filter":{"term":{"isCloseout":true}},"aggregations":{"active":{"max":{"field":"isCloseout"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|