| 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":"b014f56ed7c65e34b1aae7e020b53119"}}}},{"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": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "012d01b8e7535fb68a632a6f62c4a6c2",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "012d01b8e7535fb68a632a6f62c4a6c2",
"autoIncrement": 5507.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 20,
"productNumber": "2-370410064",
"ean": "2-410064",
"displayGroup": "bc090fb78a7b9215d35b15db98962932",
"sales": 0,
"stock": 20,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "370410064",
"releaseDate": null,
"createdAt": "2024-08-27T15:52:17+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"4d54589552a94428a135f0b22efbffd6",
"b014f56ed7c65e34b1aae7e020b53119"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "4d54589552a94428a135f0b22efbffd6",
"_count": 1
},
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "f1f17599fc2b5e3f85821010109ef4c9",
"childCount": 0,
"categories": [
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b014f56ed7c65e34b1aae7e020b53119"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "RCZUB",
"mlok_product_availability": "2",
"isPreOrderProduct": false,
"importedAt": "2025-06-16 11:51:04.484",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "370410064 Lithium-Polymer Akku (f.10111)"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Carrera 89823 3,7V 150mAh Li-Po Akku f\u00fcr Helikopter Green Chopper (501003), Black Stinger (501010), Orange Sply (501005), Red Buzzer (500001), Blue Papy (500002), Purple Falcon (500003). \nSowie f\u00fcr Wireless+ Handregler der Linien DIGITAL 124\/132, EVOLUTION und DIGITAL 143 3,7V - 150mAh - 055Wh"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.49,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 9.65546218487395
},
"fields": {
"displayGroup": [
"bc090fb78a7b9215d35b15db98962932"
]
},
"sort": [
0,
"012d01b8e7535fb68a632a6f62c4a6c2"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "018735cde3355c07bfd7fba53f349f56",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "018735cde3355c07bfd7fba53f349f56",
"autoIncrement": 11048.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "121-TRX2960X",
"ean": "0020334296092",
"displayGroup": "31a2ff2e714e43d68522af1c39a58219",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "TRX2960X",
"releaseDate": null,
"createdAt": "2024-10-08T12:50:04+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"4d54589552a94428a135f0b22efbffd6",
"b014f56ed7c65e34b1aae7e020b53119"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "4d54589552a94428a135f0b22efbffd6",
"_count": 1
},
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "4ee650b94108554782138ff1ccc6c14e",
"childCount": 0,
"categories": [
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b014f56ed7c65e34b1aae7e020b53119"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "RCZUB",
"mlok_product_availability": "1",
"isPreOrderProduct": false,
"importedAt": "2025-03-05 04:51:41.464",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TRX2960X Power Cell Serie 5 NiMH 7-Zellen Stick "
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AKKU - Power Cell Serie 5 NiMH 7-Zellen Stick 5000mAh 8,4V - TRAXXAS mit iD-Stecker (L160xH26xB48mm) - Ma\u00dfe: 193x55x32"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 68.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 57.94117647058824,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 10.4,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 10.4
},
"fields": {
"displayGroup": [
"31a2ff2e714e43d68522af1c39a58219"
]
},
"sort": [
0,
"018735cde3355c07bfd7fba53f349f56"
]
},
{
"_index": "sw_product_1743509857",
"_type": "_doc",
"_id": "01902d66bac8559b8e0466ab923bed42",
"_score": null,
"_ignored": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.importedAt"
],
"_source": {
"id": "01902d66bac8559b8e0466ab923bed42",
"autoIncrement": 9371.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "3aaa0b8abe954c09892d40b581d29df3"
}
],
"availableStock": 0,
"productNumber": "11490-609042",
"ean": null,
"displayGroup": "e113ee6a2672d23a8fe63b6f1731baf4",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": null,
"manufacturerNumber": "609042",
"releaseDate": null,
"createdAt": "2024-09-04T15:20:31+00:00",
"categoryTree": [
"960adcd8bdb7465e888a7f0e0d739de3",
"4d54589552a94428a135f0b22efbffd6",
"b014f56ed7c65e34b1aae7e020b53119"
],
"categoriesRo": [
{
"id": "960adcd8bdb7465e888a7f0e0d739de3",
"_count": 1
},
{
"id": "4d54589552a94428a135f0b22efbffd6",
"_count": 1
},
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1
}
],
"taxId": "8b79f09838fd4d9b8d060a8bb8c9b39d",
"tags": [],
"parentId": null,
"coverId": "b42384aceb185b00803ad7386ba203ef",
"childCount": 0,
"categories": [
{
"id": "b014f56ed7c65e34b1aae7e020b53119",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"b014f56ed7c65e34b1aae7e020b53119"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"wbo": "RCZUB",
"mlok_product_availability": "5",
"isPreOrderProduct": true,
"importedAt": "2025-03-04 18:54:59.619",
"repertus_packstation_delivery_enabled": true,
"eva_product_rueckstand": 0.0,
"eva_product_resibestandkasse": 0.0,
"eva_product_resibestandfaktura": 0.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "609042 Akkuset Mignon 1,2 V\/2100 mAh (4)"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Art.Nr.: 500609042\nArt.bezeichnung: 1,2V\/2100mAh Mignon\/AA Akku Set (4)\n\nDer Testsieger! \n\nDie ANSMANN Energy-Akkus sind die Top-Energiespender f\u00fcr alle RC-Anwendungen und viele weitere Einsatzzwecke in Taschenlampen, Fernbedienungen, Fotoapparaten und mobilen Ger\u00e4ten.\n\n- sofort einsetzbar, da vorgeladen!\n- lange benutzbar, da minimale Selbstentladung!\n- liefern viel Strom, da echte 2100 mAh!\n outdoor-tauglich, da k\u00e4lteunempfindlich!\n- langlebig, da bis zu 1000x wiederaufladbar!\n\nTechnische Daten\nSpannung: 1,2 V\nKapazit\u00e4t: 2100 mAh\nBaugr\u00f6\u00dfe: Mignon\/AA\/HR6\n\nLieferumfang:\n4 Akkus"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.798319327731093
},
"fields": {
"displayGroup": [
"e113ee6a2672d23a8fe63b6f1731baf4"
]
},
"sort": [
0,
"01902d66bac8559b8e0466ab923bed42"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.65 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":"b014f56ed7c65e34b1aae7e020b53119"}}}},{"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
|