Symfony Profiler

Query Metrics

9.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

7.83 ms

#▲	Execution Time	Info
1	7.83 ms	Request: {"index":"sw_product","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":"a775c9963b5b44a6a7b05cdc1664865d"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018dad4a445576728f1a6d9f4ea21a72"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["6231a902253c4604afa84d8068f5d412","2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 29 View formatted request View formatted response View query backtrace POST http://localhost:9500/sw_product/_search?track_total_hits=1&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": "a775c9963b5b44a6a7b05cdc1664865d" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "018dad4a445576728f1a6d9f4ea21a72" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "string", "script": { "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n", "lang": "painless", "params": { "field": "name", "languages": [ "6231a902253c4604afa84d8068f5d412", "2fbb5fe2e29a4d70aa5854ce7ce3e20b" ] } }, "order": "ASC" } }, { "id": { "order": "ASC" } } ], "aggregations": { "total-count": { "cardinality": { "field": "displayGroup" } } }, "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 2, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 29, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1729666761", "_id": "0192d8d708c470cea75a9b9d1ba21fa1", "_score": null, "_source": { "purchasePrices": [ { "net": 0.0, "gross": 0.0, "linked": true, "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca" } ], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "id": "0192d8d708c470cea75a9b9d1ba21fa1", "autoIncrement": 4114.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": true, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 0, "productNumber": "SW10007.1", "ean": null, "displayGroup": "7db76ce7f0d3c7f9ff57bf43a469b73f", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "0192d7c523e8790aae21199eb02a9b5a", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-29T15:13:44+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": "0192d8d615f7735588d67c4fc0d2bc02", "coverId": "0192d8dd07a2756384e0ae3bd0820276", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": "0192d7c523e8790aae21199eb02a9b5a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mr pixel", "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [ { "id": "018dad6027c4733baf6491e861741871", "_count": 1, "groupId": "018dad5ea62974a885345091391c63e9", "group": { "id": "018dad5ea62974a885345091391c63e9", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beige-Grau" } }, { "id": "018dad61030a7a4eba6ad00201d63874", "_count": 1, "groupId": "018dad5ea62974a885345091391c63e9", "group": { "id": "018dad5ea62974a885345091391c63e9", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dunkelblau " } }, { "id": "018dad617bd2792eb0fb83479ac0b50e", "_count": 1, "groupId": "018dad5ea62974a885345091391c63e9", "group": { "id": "018dad5ea62974a885345091391c63e9", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wei\u00df" } }, { "id": "0192d8680cd37368920f6a661c326d4e", "_count": 1, "groupId": "0192d867de6e7669a130663076809001", "group": { "id": "0192d867de6e7669a130663076809001", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20 Zoll Laptopfach" } }, { "id": "0192d868d2b078588379f6fd3c39880e", "_count": 1, "groupId": "0192d867de6e7669a130663076809001", "group": { "id": "0192d867de6e7669a130663076809001", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "15 Zoll Laptopfach" } } ], "options": [ { "id": "018dad6027c4733baf6491e861741871", "_count": 1, "groupId": "018dad5ea62974a885345091391c63e9", "group": { "id": "018dad5ea62974a885345091391c63e9", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beige-Grau" } }, { "id": "0192d8680cd37368920f6a661c326d4e", "_count": 1, "groupId": "0192d867de6e7669a130663076809001", "group": { "id": "0192d867de6e7669a130663076809001", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20 Zoll Laptopfach" } } ], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [ "018dad6027c4733baf6491e861741871", "0192d8680cd37368920f6a661c326d4e" ], "propertyIds": [ "018dad6027c4733baf6491e861741871", "018dad61030a7a4eba6ad00201d63874", "018dad617bd2792eb0fb83479ac0b50e", "0192d8680cd37368920f6a661c326d4e", "0192d868d2b078588379f6fd3c39880e" ], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": ".Notebook-Rucksack", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wir stellen das ultimative Accessoire f\u00fcr den modernen Studenten oder Berufst\u00e4tigen vor \u2013 den Notebook-Rucksack!\u00a0Diese vielseitige Tasche kombiniert die Funktionalit\u00e4t eines herk\u00f6mmlichen Rucksacks mit dem Komfort eines speziellen Notebookfachs und ist damit die perfekte Wahl f\u00fcr unterwegs.\u00a0Mit seinem ger\u00e4umigen Hauptfach bietet dieser Rucksack problemlos Platz f\u00fcr Notebooks mit einer Gr\u00f6\u00dfe von bis zu 15 Zoll (38,1 Zoll) und bietet ausreichend Platz f\u00fcr alle wichtigen Utensilien. Das Notebookfach ist gepolstert und mit weichem Stoff ausgekleidet, um sicherzustellen, dass Ihr Ger\u00e4t unterwegs sicher und gesch\u00fctzt bleibt. Aber das ist noch nicht alles \u2013 der Notebook-Rucksack verf\u00fcgt au\u00dferdem \u00fcber mehrere Taschen und F\u00e4cher, darunter eine vordere Rei\u00dfverschlusstasche f\u00fcr einfachen Zugriff auf kleinere Gegenst\u00e4nde und zwei Seitentaschen f\u00fcr Wasserflaschen oder Regenschirme. Die verstellbaren Schultergurte und das gepolsterte R\u00fcckenteil sorgen f\u00fcr maximalen Komfort, auch beim Tragen schwerer Lasten.Egal, ob Sie zum Unterricht, ins B\u00fcro oder zu einem Wochenendabenteuer gehen, mit dem Notebook-Rucksack sind Sie bestens ger\u00fcstet. Warum sollten Sie sich also mit einem normalen Rucksack zufrieden geben, wenn Sie auch einen speziell f\u00fcr Ihr Notebook entworfenen haben k\u00f6nnen? R\u00fcsten Sie noch heute auf den Notebook-Rucksack um und erleben Sie die perfekte Mischung aus Stil und Funktionalit\u00e4t.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.411764705882, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "sw10007.1", ".notebook-rucksack" ] }, "fields": { "displayGroup": [ "7db76ce7f0d3c7f9ff57bf43a469b73f" ] }, "sort": [ ".notebook-rucksack", "0192d8d708c470cea75a9b9d1ba21fa1" ] }, { "_index": "sw_product_1729666761", "_id": "019275b4795072a992da96ba137b4b52", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275b4795072a992da96ba137b4b52", "autoIncrement": 4016.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIC2A21810E1", "ean": "6543210987654", "displayGroup": "4b5e34906be86b109084beebe96b923f", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:13:50+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275b4795072a992da96ba137b4b52", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Flat Key Keyboard", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and slim, this keyboard is perfect for those who prefer a low-profile design. The bluetooth connectivity allows for easy pairing with any device, making it great for on-the-go use. The flat keys provide a comfortable typing experience, perfect for long hours of work.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience the convenience of a bluetooth keyboard with the comfort of flat keys. Perfect for the modern professional.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 89.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aic2a21810e1", "6543210987654", "bluetooth", "flat", "key", "keyboard", "bluetooth flat key keyboard" ] }, "fields": { "displayGroup": [ "4b5e34906be86b109084beebe96b923f" ] }, "sort": [ "bluetooth flat key keyboard", "019275b4795072a992da96ba137b4b52" ] }, { "_index": "sw_product_1729666761", "_id": "019275af7e1172249ecc02de994c1183", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275af7e1172249ecc02de994c1183", "autoIncrement": 4010.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI8593196554", "ean": "4567890123456", "displayGroup": "c74d145e8be99c82c86ecf23e543e906", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:08:22+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275af7e1172249ecc02de994c1183", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Headphones", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enjoy crystal clear sound with our Bluetooth headphones. The perfect companion for your daily commutes or workout sessions.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience wireless freedom with our Bluetooth headphones!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai8593196554", "4567890123456", "bluetooth", "headphones", "bluetooth headphones" ] }, "fields": { "displayGroup": [ "c74d145e8be99c82c86ecf23e543e906" ] }, "sort": [ "bluetooth headphones", "019275af7e1172249ecc02de994c1183" ] }, { "_index": "sw_product_1729666761", "_id": "019275b2cedd711f8bd5f363f7017964", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275b2cedd711f8bd5f363f7017964", "autoIncrement": 4013.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AID46E323173", "ean": "8467021937642", "displayGroup": "9d07e2674af08ef5a95349f6c0be8012", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:12:00+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275b2cedd711f8bd5f363f7017964", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Mouse", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This Bluetooth mouse offers precise tracking and a comfortable grip for all-day use. No more tangled wires on your desk!", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience wireless freedom with our Bluetooth mouse.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aid46e323173", "8467021937642", "bluetooth", "mouse", "bluetooth mouse" ] }, "fields": { "displayGroup": [ "9d07e2674af08ef5a95349f6c0be8012" ] }, "sort": [ "bluetooth mouse", "019275b2cedd711f8bd5f363f7017964" ] }, { "_index": "sw_product_1729666761", "_id": "019b090e41e47418be794af7ac56c2dd", "_score": null, "_source": { "id": "019b090e41e47418be794af7ac56c2dd", "autoIncrement": 4137.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "98432def39fc4624b33213a56b8c944d" }, { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 0, "productNumber": "SW10009", "ean": null, "displayGroup": "a709ff562570ae5f958fe1901001b3ec", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2025-12-10T16:19:40+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": null, "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-download" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Digitales Produkt", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test eines digitalen Produkts", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.84033613445378 }, "fields": { "displayGroup": [ "a709ff562570ae5f958fe1901001b3ec" ] }, "sort": [ "digitales produkt", "019b090e41e47418be794af7ac56c2dd" ] }, { "_index": "sw_product_1729666761", "_id": "019275b308ad71f88e0f45b1c56561b0", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275b308ad71f88e0f45b1c56561b0", "autoIncrement": 4014.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIA6272293E1", "ean": "9256018473098", "displayGroup": "72974f39fb07ea8471ded9c99169f826", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:12:16+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275b308ad71f88e0f45b1c56561b0", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gaming Headset", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Immerse yourself in your favorite games with our gaming headset. Featuring noise-cancelling technology and a comfortable fit, it's perfect for long gaming sessions.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hear every sound and dominate every game with our gaming headset.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aia6272293e1", "9256018473098", "gaming", "headset", "gaming headset" ] }, "fields": { "displayGroup": [ "72974f39fb07ea8471ded9c99169f826" ] }, "sort": [ "gaming headset", "019275b308ad71f88e0f45b1c56561b0" ] }, { "_index": "sw_product_1729666761", "_id": "019275af077071139fae7e2a8eec70db", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275af077071139fae7e2a8eec70db", "autoIncrement": 4008.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1D8B7AD964", "ean": "2345678901234", "displayGroup": "b2aa8785b93b5d62e7b046da8e4900a9", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:07:51+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275af077071139fae7e2a8eec70db", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mechanical Gaming Keyboard", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Designed for hardcore gamers, this mechanical keyboard offers precise and responsive keys for the ultimate gaming experience.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Take your gaming to the next level with our mechanical keyboard!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai1d8b7ad964", "2345678901234", "mechanical", "gaming", "keyboard", "mechanical gaming keyboard" ] }, "fields": { "displayGroup": [ "b2aa8785b93b5d62e7b046da8e4900a9" ] }, "sort": [ "mechanical gaming keyboard", "019275af077071139fae7e2a8eec70db" ] }, { "_index": "sw_product_1729666761", "_id": "0192d889ac6d7173861befc3b1250895", "_score": null, "_source": { "id": "0192d889ac6d7173861befc3b1250895", "autoIncrement": 4101.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "98432def39fc4624b33213a56b8c944d" }, { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 0, "productNumber": "SW10006.1", "ean": null, "displayGroup": "332d6c720ba9809566c1cd542b1dd844", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "0192d7c523e8790aae21199eb02a9b5a", "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-29T13:49:14+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": "0192d88262807b59ab5a149818c2fc32", "coverId": "0192d888df467cb3ac84d6c8d78d19cb", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": "0192d7c523e8790aae21199eb02a9b5a", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mr pixel", "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [ { "id": "0192d88541d5751bb0755a2cac59a2c4", "_count": 1, "groupId": "0192d883377f7ebda549f928072b48cd", "group": { "id": "0192d883377f7ebda549f928072b48cd", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dunkelblau " } } ], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [ "0192d88541d5751bb0755a2cac59a2c4" ], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stift mit indivudeller Gravur", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.3529411764706 }, "fields": { "displayGroup": [ "332d6c720ba9809566c1cd542b1dd844" ] }, "sort": [ "stift mit indivudeller gravur", "0192d889ac6d7173861befc3b1250895" ] }, { "_index": "sw_product_1729666761", "_id": "019275afb68a72be9d84875e20de32bb", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275afb68a72be9d84875e20de32bb", "autoIncrement": 4011.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI0077A38D30", "ean": "5678901234567", "displayGroup": "dbac1057493f162f2ad80bd055080245", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:08:37+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275afb68a72be9d84875e20de32bb", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Charging Pad", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Simplify your charging routine with our wireless charging pad. Just place your device on the pad and watch it charge wirelessly.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "No more messy wires, just effortless charging with our wireless charging pad!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai0077a38d30", "5678901234567", "wireless", "charging", "pad", "wireless charging pad" ] }, "fields": { "displayGroup": [ "dbac1057493f162f2ad80bd055080245" ] }, "sort": [ "wireless charging pad", "019275afb68a72be9d84875e20de32bb" ] }, { "_index": "sw_product_1729666761", "_id": "019275aec84271e3bf4d879b2d797e8e", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275aec84271e3bf4d879b2d797e8e", "autoIncrement": 4007.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIB0196894E6", "ean": "1234567890123", "displayGroup": "b805fbe78b8cc2b2411fcafc73136f5d", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:07:37+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275aec84271e3bf4d879b2d797e8e", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Keyboard", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This wireless keyboard features flat keys for a comfortable typing experience. Perfect for those looking for a sleek and modern design.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your typing experience with our new wireless keyboard!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aib0196894e6", "1234567890123", "wireless", "keyboard", "wireless keyboard" ] }, "fields": { "displayGroup": [ "b805fbe78b8cc2b2411fcafc73136f5d" ] }, "sort": [ "wireless keyboard", "019275aec84271e3bf4d879b2d797e8e" ] }, { "_index": "sw_product_1729666761", "_id": "019275b27d67734880a1f78a7fff9739", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275b27d67734880a1f78a7fff9739", "autoIncrement": 4012.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AICE768833A7", "ean": "7643098712367", "displayGroup": "b76a17cf9f26c68157d03e8f6bdea27f", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:11:45+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275b27d67734880a1f78a7fff9739", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Keyboard", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This wireless keyboard features mechanical keys for a more tactile typing experience and a flat design for easy storage. Perfect for any computer setup.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your typing with our wireless keyboard.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aice768833a7", "7643098712367", "wireless", "keyboard", "wireless keyboard" ] }, "fields": { "displayGroup": [ "b76a17cf9f26c68157d03e8f6bdea27f" ] }, "sort": [ "wireless keyboard", "019275b27d67734880a1f78a7fff9739" ] }, { "_index": "sw_product_1729666761", "_id": "019275b431ae7188acab6809130561e9", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275b431ae7188acab6809130561e9", "autoIncrement": 4015.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI50E1BD86A8", "ean": "7894561234567", "displayGroup": "c326765a89976bf1dac478cc44ffddc0", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:13:34+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275b431ae7188acab6809130561e9", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Mechanical Keyboard", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enjoy the freedom of a wireless keyboard with the tactile feel of mechanical keys. Perfect for gaming or typing, this keyboard offers a responsive and comfortable experience. With a sleek design and long battery life, it's the perfect addition to your desk.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your keyboard game with this wireless mechanical keyboard. ", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 129.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai50e1bd86a8", "7894561234567", "wireless", "mechanical", "keyboard", "wireless mechanical keyboard" ] }, "fields": { "displayGroup": [ "c326765a89976bf1dac478cc44ffddc0" ] }, "sort": [ "wireless mechanical keyboard", "019275b431ae7188acab6809130561e9" ] }, { "_index": "sw_product_1729666761", "_id": "019275af3d5f7160bbb6f0463a2164b7", "_score": null, "_source": { "purchasePrices": [], "referenceUnit": null, "purchaseUnit": null, "unit": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "shortCode": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "_count": 1 }, "crossSellings": [], "keywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnit": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "packUnitPlural": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "id": "019275af3d5f7160bbb6f0463a2164b7", "autoIncrement": 4009.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1FA0527BC6", "ean": "3456789012345", "displayGroup": "b54102d586cd6f906589350296e12a5b", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-10-10T09:08:08+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4841f6741ea0c6ee2999386542", "018dad4a445576728f1a6d9f4ea21a72" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4841f6741ea0c6ee2999386542", "_count": 1 }, { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019275af3d5f7160bbb6f0463a2164b7", "childCount": 0, "categories": [ { "id": "018dad4a445576728f1a6d9f4ea21a72", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4a445576728f1a6d9f4ea21a72" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Mouse", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Say goodbye to tangled wires with our wireless mouse. Its ergonomic design provides comfort and convenience for everyday use.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade to a wireless mouse for seamless scrolling and clicking!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai1fa0527bc6", "3456789012345", "wireless", "mouse", "wireless mouse" ] }, "fields": { "displayGroup": [ "b54102d586cd6f906589350296e12a5b" ] }, "sort": [ "wireless mouse", "019275af3d5f7160bbb6f0463a2164b7" ] } ] }, "aggregations": { "total-count": { "value": 13 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	1.98 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":"a775c9963b5b44a6a7b05cdc1664865d"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018dad4a445576728f1a6d9f4ea21a72"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_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:9500/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": "a775c9963b5b44a6a7b05cdc1664865d" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "018dad4a445576728f1a6d9f4ea21a72" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_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": 0, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 29, "rating": { "value": 0.0 } }, "price": { "count": 29, "min": 1.0, "max": 129.99, "avg": 36.852413793103445, "sum": 1068.7199999999998 }, "options": { "doc_count": 24, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0192d8680cd37368920f6a661c326d4e", "doc_count": 3 }, { "key": "0192d868d2b078588379f6fd3c39880e", "doc_count": 3 }, { "key": "018dad6027c4733baf6491e861741871", "doc_count": 2 }, { "key": "018dad61030a7a4eba6ad00201d63874", "doc_count": 2 }, { "key": "018dad617bd2792eb0fb83479ac0b50e", "doc_count": 2 }, { "key": "0192d88474f57a4c9edde041e69ea6c5", "doc_count": 1 }, { "key": "0192d884cb2076ed918c0b6a88421c6c", "doc_count": 1 }, { "key": "0192d885028d75008c0d1280f5f88573", "doc_count": 1 }, { "key": "0192d88541d5751bb0755a2cac59a2c4", "doc_count": 1 }, { "key": "0192d885797f7d64ae43d9dc148fe555", "doc_count": 1 }, { "key": "0192d885c20c75a2acbae503103266e4", "doc_count": 1 }, { "key": "0192d885fbe072b298799ae9350bdb4e", "doc_count": 1 }, { "key": "0192d8863d8e7dca9b93a36114f73946", "doc_count": 1 }, { "key": "0192d886a078720e9beb33d7c7c41c69", "doc_count": 1 }, { "key": "0192d886e57c7775933dcd0212d5a32d", "doc_count": 1 }, { "key": "0192d887226c75fc89f6048876013bd0", "doc_count": 1 }, { "key": "0192d8874df570c9b8d62f878cbbc4b8", "doc_count": 1 } ] } }, "properties": { "doc_count": 30, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018dad6027c4733baf6491e861741871", "doc_count": 6 }, { "key": "018dad61030a7a4eba6ad00201d63874", "doc_count": 6 }, { "key": "018dad617bd2792eb0fb83479ac0b50e", "doc_count": 6 }, { "key": "0192d8680cd37368920f6a661c326d4e", "doc_count": 6 }, { "key": "0192d868d2b078588379f6fd3c39880e", "doc_count": 6 } ] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "0192d7c523e8790aae21199eb02a9b5a", "doc_count": 18 } ] } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate`

Request:

{"index":"sw_product","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":"a775c9963b5b44a6a7b05cdc1664865d"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018dad4a445576728f1a6d9f4ea21a72"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["6231a902253c4604afa84d8068f5d412","2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://localhost:9500/sw_product/_search?track_total_hits=1&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": "a775c9963b5b44a6a7b05cdc1664865d"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018dad4a445576728f1a6d9f4ea21a72"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "string",
                "script": {
                    "source": "def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n",
                    "lang": "painless",
                    "params": {
                        "field": "name",
                        "languages": [
                            "6231a902253c4604afa84d8068f5d412",
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b"
                        ]
                    }
                },
                "order": "ASC"
            }
        },
        {
            "id": {
                "order": "ASC"
            }
        }
    ],
    "aggregations": {
        "total-count": {
            "cardinality": {
                "field": "displayGroup"
            }
        }
    },
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 2,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 29,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1729666761",
                "_id": "0192d8d708c470cea75a9b9d1ba21fa1",
                "_score": null,
                "_source": {
                    "purchasePrices": [
                        {
                            "net": 0.0,
                            "gross": 0.0,
                            "linked": true,
                            "currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca"
                        }
                    ],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "id": "0192d8d708c470cea75a9b9d1ba21fa1",
                    "autoIncrement": 4114.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": true,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "SW10007.1",
                    "ean": null,
                    "displayGroup": "7db76ce7f0d3c7f9ff57bf43a469b73f",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "0192d7c523e8790aae21199eb02a9b5a",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-29T15:13:44+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": "0192d8d615f7735588d67c4fc0d2bc02",
                    "coverId": "0192d8dd07a2756384e0ae3bd0820276",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0192d7c523e8790aae21199eb02a9b5a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mr pixel",
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "018dad6027c4733baf6491e861741871",
                            "_count": 1,
                            "groupId": "018dad5ea62974a885345091391c63e9",
                            "group": {
                                "id": "018dad5ea62974a885345091391c63e9",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beige-Grau"
                            }
                        },
                        {
                            "id": "018dad61030a7a4eba6ad00201d63874",
                            "_count": 1,
                            "groupId": "018dad5ea62974a885345091391c63e9",
                            "group": {
                                "id": "018dad5ea62974a885345091391c63e9",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dunkelblau "
                            }
                        },
                        {
                            "id": "018dad617bd2792eb0fb83479ac0b50e",
                            "_count": 1,
                            "groupId": "018dad5ea62974a885345091391c63e9",
                            "group": {
                                "id": "018dad5ea62974a885345091391c63e9",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wei\u00df"
                            }
                        },
                        {
                            "id": "0192d8680cd37368920f6a661c326d4e",
                            "_count": 1,
                            "groupId": "0192d867de6e7669a130663076809001",
                            "group": {
                                "id": "0192d867de6e7669a130663076809001",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20 Zoll Laptopfach"
                            }
                        },
                        {
                            "id": "0192d868d2b078588379f6fd3c39880e",
                            "_count": 1,
                            "groupId": "0192d867de6e7669a130663076809001",
                            "group": {
                                "id": "0192d867de6e7669a130663076809001",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "15 Zoll Laptopfach"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "018dad6027c4733baf6491e861741871",
                            "_count": 1,
                            "groupId": "018dad5ea62974a885345091391c63e9",
                            "group": {
                                "id": "018dad5ea62974a885345091391c63e9",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beige-Grau"
                            }
                        },
                        {
                            "id": "0192d8680cd37368920f6a661c326d4e",
                            "_count": 1,
                            "groupId": "0192d867de6e7669a130663076809001",
                            "group": {
                                "id": "0192d867de6e7669a130663076809001",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20 Zoll Laptopfach"
                            }
                        }
                    ],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [
                        "018dad6027c4733baf6491e861741871",
                        "0192d8680cd37368920f6a661c326d4e"
                    ],
                    "propertyIds": [
                        "018dad6027c4733baf6491e861741871",
                        "018dad61030a7a4eba6ad00201d63874",
                        "018dad617bd2792eb0fb83479ac0b50e",
                        "0192d8680cd37368920f6a661c326d4e",
                        "0192d868d2b078588379f6fd3c39880e"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": ".Notebook-Rucksack",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wir stellen das ultimative Accessoire f\u00fcr den modernen Studenten oder Berufst\u00e4tigen vor \u2013 den Notebook-Rucksack!\u00a0Diese vielseitige Tasche kombiniert die Funktionalit\u00e4t eines herk\u00f6mmlichen Rucksacks mit dem Komfort eines speziellen Notebookfachs und ist damit die perfekte Wahl f\u00fcr unterwegs.\u00a0Mit seinem ger\u00e4umigen Hauptfach bietet dieser Rucksack problemlos Platz f\u00fcr Notebooks mit einer Gr\u00f6\u00dfe von bis zu 15 Zoll (38,1 Zoll) und bietet ausreichend Platz f\u00fcr alle wichtigen Utensilien. Das Notebookfach ist gepolstert und mit weichem Stoff ausgekleidet, um sicherzustellen, dass Ihr Ger\u00e4t unterwegs sicher und gesch\u00fctzt bleibt. Aber das ist noch nicht alles \u2013 der Notebook-Rucksack verf\u00fcgt au\u00dferdem \u00fcber mehrere Taschen und F\u00e4cher, darunter eine vordere Rei\u00dfverschlusstasche f\u00fcr einfachen Zugriff auf kleinere Gegenst\u00e4nde und zwei Seitentaschen f\u00fcr Wasserflaschen oder Regenschirme. Die verstellbaren Schultergurte und das gepolsterte R\u00fcckenteil sorgen f\u00fcr maximalen Komfort, auch beim Tragen schwerer Lasten.Egal, ob Sie zum Unterricht, ins B\u00fcro oder zu einem Wochenendabenteuer gehen, mit dem Notebook-Rucksack sind Sie bestens ger\u00fcstet. Warum sollten Sie sich also mit einem normalen Rucksack zufrieden geben, wenn Sie auch einen speziell f\u00fcr Ihr Notebook entworfenen haben k\u00f6nnen? R\u00fcsten Sie noch heute auf den Notebook-Rucksack um und erleben Sie die perfekte Mischung aus Stil und Funktionalit\u00e4t.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.411764705882,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "sw10007.1",
                        ".notebook-rucksack"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "7db76ce7f0d3c7f9ff57bf43a469b73f"
                    ]
                },
                "sort": [
                    ".notebook-rucksack",
                    "0192d8d708c470cea75a9b9d1ba21fa1"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275b4795072a992da96ba137b4b52",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275b4795072a992da96ba137b4b52",
                    "autoIncrement": 4016.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIC2A21810E1",
                    "ean": "6543210987654",
                    "displayGroup": "4b5e34906be86b109084beebe96b923f",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:13:50+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275b4795072a992da96ba137b4b52",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Flat Key Keyboard",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and slim, this keyboard is perfect for those who prefer a low-profile design. The bluetooth connectivity allows for easy pairing with any device, making it great for on-the-go use. The flat keys provide a comfortable typing experience, perfect for long hours of work.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience the convenience of a bluetooth keyboard with the comfort of flat keys. Perfect for the modern professional.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 89.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aic2a21810e1",
                        "6543210987654",
                        "bluetooth",
                        "flat",
                        "key",
                        "keyboard",
                        "bluetooth flat key keyboard"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "4b5e34906be86b109084beebe96b923f"
                    ]
                },
                "sort": [
                    "bluetooth flat key keyboard",
                    "019275b4795072a992da96ba137b4b52"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275af7e1172249ecc02de994c1183",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275af7e1172249ecc02de994c1183",
                    "autoIncrement": 4010.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI8593196554",
                    "ean": "4567890123456",
                    "displayGroup": "c74d145e8be99c82c86ecf23e543e906",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:08:22+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275af7e1172249ecc02de994c1183",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Headphones",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enjoy crystal clear sound with our Bluetooth headphones. The perfect companion for your daily commutes or workout sessions.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience wireless freedom with our Bluetooth headphones!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai8593196554",
                        "4567890123456",
                        "bluetooth",
                        "headphones",
                        "bluetooth headphones"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c74d145e8be99c82c86ecf23e543e906"
                    ]
                },
                "sort": [
                    "bluetooth headphones",
                    "019275af7e1172249ecc02de994c1183"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275b2cedd711f8bd5f363f7017964",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275b2cedd711f8bd5f363f7017964",
                    "autoIncrement": 4013.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AID46E323173",
                    "ean": "8467021937642",
                    "displayGroup": "9d07e2674af08ef5a95349f6c0be8012",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:12:00+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275b2cedd711f8bd5f363f7017964",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bluetooth Mouse",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This Bluetooth mouse offers precise tracking and a comfortable grip for all-day use. No more tangled wires on your desk!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience wireless freedom with our Bluetooth mouse.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aid46e323173",
                        "8467021937642",
                        "bluetooth",
                        "mouse",
                        "bluetooth mouse"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "9d07e2674af08ef5a95349f6c0be8012"
                    ]
                },
                "sort": [
                    "bluetooth mouse",
                    "019275b2cedd711f8bd5f363f7017964"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019b090e41e47418be794af7ac56c2dd",
                "_score": null,
                "_source": {
                    "id": "019b090e41e47418be794af7ac56c2dd",
                    "autoIncrement": 4137.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "98432def39fc4624b33213a56b8c944d"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "SW10009",
                    "ean": null,
                    "displayGroup": "a709ff562570ae5f958fe1901001b3ec",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2025-12-10T16:19:40+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": null,
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-download"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Digitales Produkt",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test eines digitalen Produkts",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 0.84033613445378
                },
                "fields": {
                    "displayGroup": [
                        "a709ff562570ae5f958fe1901001b3ec"
                    ]
                },
                "sort": [
                    "digitales produkt",
                    "019b090e41e47418be794af7ac56c2dd"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275b308ad71f88e0f45b1c56561b0",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275b308ad71f88e0f45b1c56561b0",
                    "autoIncrement": 4014.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIA6272293E1",
                    "ean": "9256018473098",
                    "displayGroup": "72974f39fb07ea8471ded9c99169f826",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:12:16+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275b308ad71f88e0f45b1c56561b0",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gaming Headset",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Immerse yourself in your favorite games with our gaming headset. Featuring noise-cancelling technology and a comfortable fit, it's perfect for long gaming sessions.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hear every sound and dominate every game with our gaming headset.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aia6272293e1",
                        "9256018473098",
                        "gaming",
                        "headset",
                        "gaming headset"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "72974f39fb07ea8471ded9c99169f826"
                    ]
                },
                "sort": [
                    "gaming headset",
                    "019275b308ad71f88e0f45b1c56561b0"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275af077071139fae7e2a8eec70db",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275af077071139fae7e2a8eec70db",
                    "autoIncrement": 4008.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1D8B7AD964",
                    "ean": "2345678901234",
                    "displayGroup": "b2aa8785b93b5d62e7b046da8e4900a9",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:07:51+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275af077071139fae7e2a8eec70db",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mechanical Gaming Keyboard",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Designed for hardcore gamers, this mechanical keyboard offers precise and responsive keys for the ultimate gaming experience.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Take your gaming to the next level with our mechanical keyboard!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 99.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 99.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai1d8b7ad964",
                        "2345678901234",
                        "mechanical",
                        "gaming",
                        "keyboard",
                        "mechanical gaming keyboard"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b2aa8785b93b5d62e7b046da8e4900a9"
                    ]
                },
                "sort": [
                    "mechanical gaming keyboard",
                    "019275af077071139fae7e2a8eec70db"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192d889ac6d7173861befc3b1250895",
                "_score": null,
                "_source": {
                    "id": "0192d889ac6d7173861befc3b1250895",
                    "autoIncrement": 4101.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "98432def39fc4624b33213a56b8c944d"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "SW10006.1",
                    "ean": null,
                    "displayGroup": "332d6c720ba9809566c1cd542b1dd844",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "0192d7c523e8790aae21199eb02a9b5a",
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-29T13:49:14+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": "0192d88262807b59ab5a149818c2fc32",
                    "coverId": "0192d888df467cb3ac84d6c8d78d19cb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "0192d7c523e8790aae21199eb02a9b5a",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mr pixel",
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [
                        {
                            "id": "0192d88541d5751bb0755a2cac59a2c4",
                            "_count": 1,
                            "groupId": "0192d883377f7ebda549f928072b48cd",
                            "group": {
                                "id": "0192d883377f7ebda549f928072b48cd",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dunkelblau "
                            }
                        }
                    ],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [
                        "0192d88541d5751bb0755a2cac59a2c4"
                    ],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stift mit indivudeller Gravur",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.3529411764706
                },
                "fields": {
                    "displayGroup": [
                        "332d6c720ba9809566c1cd542b1dd844"
                    ]
                },
                "sort": [
                    "stift mit indivudeller gravur",
                    "0192d889ac6d7173861befc3b1250895"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275afb68a72be9d84875e20de32bb",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275afb68a72be9d84875e20de32bb",
                    "autoIncrement": 4011.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI0077A38D30",
                    "ean": "5678901234567",
                    "displayGroup": "dbac1057493f162f2ad80bd055080245",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:08:37+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275afb68a72be9d84875e20de32bb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Charging Pad",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Simplify your charging routine with our wireless charging pad. Just place your device on the pad and watch it charge wirelessly.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "No more messy wires, just effortless charging with our wireless charging pad!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai0077a38d30",
                        "5678901234567",
                        "wireless",
                        "charging",
                        "pad",
                        "wireless charging pad"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "dbac1057493f162f2ad80bd055080245"
                    ]
                },
                "sort": [
                    "wireless charging pad",
                    "019275afb68a72be9d84875e20de32bb"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275aec84271e3bf4d879b2d797e8e",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275aec84271e3bf4d879b2d797e8e",
                    "autoIncrement": 4007.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIB0196894E6",
                    "ean": "1234567890123",
                    "displayGroup": "b805fbe78b8cc2b2411fcafc73136f5d",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:07:37+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275aec84271e3bf4d879b2d797e8e",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Keyboard",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This wireless keyboard features flat keys for a comfortable typing experience. Perfect for those looking for a sleek and modern design.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your typing experience with our new wireless keyboard!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aib0196894e6",
                        "1234567890123",
                        "wireless",
                        "keyboard",
                        "wireless keyboard"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b805fbe78b8cc2b2411fcafc73136f5d"
                    ]
                },
                "sort": [
                    "wireless keyboard",
                    "019275aec84271e3bf4d879b2d797e8e"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275b27d67734880a1f78a7fff9739",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275b27d67734880a1f78a7fff9739",
                    "autoIncrement": 4012.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AICE768833A7",
                    "ean": "7643098712367",
                    "displayGroup": "b76a17cf9f26c68157d03e8f6bdea27f",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:11:45+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275b27d67734880a1f78a7fff9739",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Keyboard",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This wireless keyboard features mechanical keys for a more tactile typing experience and a flat design for easy storage. Perfect for any computer setup.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your typing with our wireless keyboard.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 49.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aice768833a7",
                        "7643098712367",
                        "wireless",
                        "keyboard",
                        "wireless keyboard"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b76a17cf9f26c68157d03e8f6bdea27f"
                    ]
                },
                "sort": [
                    "wireless keyboard",
                    "019275b27d67734880a1f78a7fff9739"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275b431ae7188acab6809130561e9",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275b431ae7188acab6809130561e9",
                    "autoIncrement": 4015.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI50E1BD86A8",
                    "ean": "7894561234567",
                    "displayGroup": "c326765a89976bf1dac478cc44ffddc0",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:13:34+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275b431ae7188acab6809130561e9",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Mechanical Keyboard",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enjoy the freedom of a wireless keyboard with the tactile feel of mechanical keys. Perfect for gaming or typing, this keyboard offers a responsive and comfortable experience. With a sleek design and long battery life, it's the perfect addition to your desk.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your keyboard game with this wireless mechanical keyboard. ",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 129.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 129.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai50e1bd86a8",
                        "7894561234567",
                        "wireless",
                        "mechanical",
                        "keyboard",
                        "wireless mechanical keyboard"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c326765a89976bf1dac478cc44ffddc0"
                    ]
                },
                "sort": [
                    "wireless mechanical keyboard",
                    "019275b431ae7188acab6809130561e9"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019275af3d5f7160bbb6f0463a2164b7",
                "_score": null,
                "_source": {
                    "purchasePrices": [],
                    "referenceUnit": null,
                    "purchaseUnit": null,
                    "unit": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "shortCode": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                        },
                        "_count": 1
                    },
                    "crossSellings": [],
                    "keywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnit": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "packUnitPlural": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "id": "019275af3d5f7160bbb6f0463a2164b7",
                    "autoIncrement": 4009.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1FA0527BC6",
                    "ean": "3456789012345",
                    "displayGroup": "b54102d586cd6f906589350296e12a5b",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-10-10T09:08:08+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4841f6741ea0c6ee2999386542",
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4841f6741ea0c6ee2999386542",
                            "_count": 1
                        },
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019275af3d5f7160bbb6f0463a2164b7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad4a445576728f1a6d9f4ea21a72",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4a445576728f1a6d9f4ea21a72"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wireless Mouse",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Say goodbye to tangled wires with our wireless mouse. Its ergonomic design provides comfort and convenience for everyday use.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade to a wireless mouse for seamless scrolling and clicking!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai1fa0527bc6",
                        "3456789012345",
                        "wireless",
                        "mouse",
                        "wireless mouse"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b54102d586cd6f906589350296e12a5b"
                    ]
                },
                "sort": [
                    "wireless mouse",
                    "019275af3d5f7160bbb6f0463a2164b7"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 13
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

1.98 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":"a775c9963b5b44a6a7b05cdc1664865d"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018dad4a445576728f1a6d9f4ea21a72"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_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:9500/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": "a775c9963b5b44a6a7b05cdc1664865d"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018dad4a445576728f1a6d9f4ea21a72"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_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": 0,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 29,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 29,
            "min": 1.0,
            "max": 129.99,
            "avg": 36.852413793103445,
            "sum": 1068.7199999999998
        },
        "options": {
            "doc_count": 24,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "0192d8680cd37368920f6a661c326d4e",
                        "doc_count": 3
                    },
                    {
                        "key": "0192d868d2b078588379f6fd3c39880e",
                        "doc_count": 3
                    },
                    {
                        "key": "018dad6027c4733baf6491e861741871",
                        "doc_count": 2
                    },
                    {
                        "key": "018dad61030a7a4eba6ad00201d63874",
                        "doc_count": 2
                    },
                    {
                        "key": "018dad617bd2792eb0fb83479ac0b50e",
                        "doc_count": 2
                    },
                    {
                        "key": "0192d88474f57a4c9edde041e69ea6c5",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d884cb2076ed918c0b6a88421c6c",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d885028d75008c0d1280f5f88573",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d88541d5751bb0755a2cac59a2c4",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d885797f7d64ae43d9dc148fe555",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d885c20c75a2acbae503103266e4",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d885fbe072b298799ae9350bdb4e",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d8863d8e7dca9b93a36114f73946",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d886a078720e9beb33d7c7c41c69",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d886e57c7775933dcd0212d5a32d",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d887226c75fc89f6048876013bd0",
                        "doc_count": 1
                    },
                    {
                        "key": "0192d8874df570c9b8d62f878cbbc4b8",
                        "doc_count": 1
                    }
                ]
            }
        },
        "properties": {
            "doc_count": 30,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "018dad6027c4733baf6491e861741871",
                        "doc_count": 6
                    },
                    {
                        "key": "018dad61030a7a4eba6ad00201d63874",
                        "doc_count": 6
                    },
                    {
                        "key": "018dad617bd2792eb0fb83479ac0b50e",
                        "doc_count": 6
                    },
                    {
                        "key": "0192d8680cd37368920f6a661c326d4e",
                        "doc_count": 6
                    },
                    {
                        "key": "0192d868d2b078588379f6fd3c39880e",
                        "doc_count": 6
                    }
                ]
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": [
                {
                    "key": "0192d7c523e8790aae21199eb02a9b5a",
                    "doc_count": 18
                }
            ]
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate

Cluster Status

{
    "cluster_name": "opensearch_9500",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "discovered_master": true,
    "discovered_cluster_manager": true,
    "active_primary_shards": 12,
    "active_shards": 12,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 29,
    "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": 29.268292682926827
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw_product_1729666761	open	3, 3	2438
.opensearch-observability	open	1, 0	0
sw_product_manufacturer_1729666761	open	3, 3	1
sw_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1684308762	open	1, 1	54677
sw_category_1729666761	open	3, 3	5
sw_product_6231a902253c4604afa84d8068f5d412_1684308762	open	1, 1	54677

Symfony Profiler

GET https://maxcluster-demo.noneddon.de/navigation/018dad4a445576728f1a6d9f4ea21a72

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices