Symfony Profiler

Query Metrics

8.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

5.88 ms

#▲	Execution Time	Info
1	5.88 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":"0192675783837818a20ba36699295e79"}}}},{"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: 13 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": "0192675783837818a20ba36699295e79" } } } }, { "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": 13, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1729666761", "_id": "0192679e257f72088a96db7bacc02829", "_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": "0192679e257f72088a96db7bacc02829", "autoIncrement": 3960.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AID22A748483", "ean": "7654321987654", "displayGroup": "1bc89ce4d4447558bdb7f5c1da4c7c04", "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-07T15:34:47+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679e257f72088a96db7bacc02829", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bohemian Maxi Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Embrace your inner bohemian in this flowy maxi dress. It features a vibrant print, a halter neckline, and a tiered skirt. Perfect for a summer music festival or a beach vacation.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement in this bohemian-inspired maxi dress.", "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": [ "aid22a748483", "7654321987654", "bohemian", "maxi", "dress", "bohemian maxi dress" ] }, "fields": { "displayGroup": [ "1bc89ce4d4447558bdb7f5c1da4c7c04" ] }, "sort": [ "bohemian maxi dress", "0192679e257f72088a96db7bacc02829" ] }, { "_index": "sw_product_1729666761", "_id": "0192679cc0907270a5fe3d8415088dcd", "_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": "0192679cc0907270a5fe3d8415088dcd", "autoIncrement": 3955.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI81F7F969BD", "ean": "3765432198765", "displayGroup": "4317f7939d5d54104d60995b11f55bc3", "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-07T15:33:14+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679cc0907270a5fe3d8415088dcd", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Boho Mini Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Channel your inner free spirit in this boho mini dress. It features a flowy silhouette, bell sleeves, and a vibrant print. Perfect for a music festival or a beach vacation.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Be the ultimate boho babe in this mini dress.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 34.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai81f7f969bd", "3765432198765", "boho", "mini", "dress", "boho mini dress" ] }, "fields": { "displayGroup": [ "4317f7939d5d54104d60995b11f55bc3" ] }, "sort": [ "boho mini dress", "0192679cc0907270a5fe3d8415088dcd" ] }, { "_index": "sw_product_1729666761", "_id": "0192679d5aef702ea66187db6d146f1b", "_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": "0192679d5aef702ea66187db6d146f1b", "autoIncrement": 3957.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI3E99F30E88", "ean": "6723890765432", "displayGroup": "320d8c2aa96fde033aaf9180fdc0d5aa", "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-07T15:33:56+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679d5aef702ea66187db6d146f1b", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Embroidered Maxi Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elevate your style with this stunning embroidered maxi dress. It features a halter neckline and intricate floral embroidery. Perfect for a summer wedding or a vacation.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with this eye-catching embroidered maxi dress.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 69.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 69.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai3e99f30e88", "6723890765432", "embroidered", "maxi", "dress", "embroidered maxi dress" ] }, "fields": { "displayGroup": [ "320d8c2aa96fde033aaf9180fdc0d5aa" ] }, "sort": [ "embroidered maxi dress", "0192679d5aef702ea66187db6d146f1b" ] }, { "_index": "sw_product_1729666761", "_id": "0192679bc0507321ab7ffa45827d99f5", "_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": "0192679bc0507321ab7ffa45827d99f5", "autoIncrement": 3951.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AID3C29620D0", "ean": "7325610987432", "displayGroup": "cf01bfd7b5c8d0d552e2c91cd2b9fdde", "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-07T15:32:07+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679bc0507321ab7ffa45827d99f5", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Floral Maxi Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This beautiful floral maxi dress features a flowy silhouette and a V-neckline. Perfect for a summer day out or a special occasion.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and versatile maxi dress, perfect for any occasion.", "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": [ "aid3c29620d0", "7325610987432", "floral", "maxi", "dress", "floral maxi dress" ] }, "fields": { "displayGroup": [ "cf01bfd7b5c8d0d552e2c91cd2b9fdde" ] }, "sort": [ "floral maxi dress", "0192679bc0507321ab7ffa45827d99f5" ] }, { "_index": "sw_product_1729666761", "_id": "0191b87696d173b6a6f406f88dc852e5", "_score": null, "_source": { "id": "0191b87696d173b6a6f406f88dc852e5", "autoIncrement": 3896.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI32C2611E75", "ean": "9652148735698", "displayGroup": "988668b6b7e5b2ed90d5ac29d578ad5c", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-09-03T15:18:05+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79", "019735db603d7b25967a430ba7a80685", "0198ea9e94ec7cfb9a8b517450acac50" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 }, { "id": "019735db603d7b25967a430ba7a80685", "_count": 1 }, { "id": "0198ea9e94ec7cfb9a8b517450acac50", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0191b87696d173b6a6f406f88dc852e5", "childCount": 0, "categories": [ { "id": "019735db603d7b25967a430ba7a80685", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test" } }, { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung" } }, { "id": "0198ea9e94ec7cfb9a8b517450acac50", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Angebote" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79", "019735db603d7b25967a430ba7a80685", "0198ea9e94ec7cfb9a8b517450acac50", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Floral Sundress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A beautiful sundress with a vibrant floral pattern, perfect for those sunny days. Made from lightweight and breathable fabric, this dress is both comfortable and stylish.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Look effortlessly chic in this floral sundress!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 50.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.0 }, "fields": { "displayGroup": [ "988668b6b7e5b2ed90d5ac29d578ad5c" ] }, "sort": [ "floral sundress", "0191b87696d173b6a6f406f88dc852e5" ] }, { "_index": "sw_product_1729666761", "_id": "0192679c4bb07093bd1a3c94b3655584", "_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": "0192679c4bb07093bd1a3c94b3655584", "autoIncrement": 3953.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIA04E8711F7", "ean": "6567812398567", "displayGroup": "a01feedbedb2c8513ab55198817b0276", "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-07T15:32:45+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679c4bb07093bd1a3c94b3655584", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lace Midi Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This delicate lace midi dress features a high neckline and a flattering A-line silhouette. Perfect for a wedding or a fancy dinner.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement in this elegant lace midi dress.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 59.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aia04e8711f7", "6567812398567", "lace", "midi", "dress", "lace midi dress" ] }, "fields": { "displayGroup": [ "a01feedbedb2c8513ab55198817b0276" ] }, "sort": [ "lace midi dress", "0192679c4bb07093bd1a3c94b3655584" ] }, { "_index": "sw_product_1729666761", "_id": "0192679cfd11724a8a8a240e87b94175", "_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": "0192679cfd11724a8a8a240e87b94175", "autoIncrement": 3956.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI82240759EA", "ean": "9654321987654", "displayGroup": "1833f6a0e45f6257a586877c8800f094", "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-07T15:33:38+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679cfd11724a8a8a240e87b94175", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Little Black Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A wardrobe essential, this little black dress is perfect for any occasion. It features a classic fit and flare silhouette and a subtle V-neckline.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Every woman needs a little black dress in her closet.", "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": [ "ai82240759ea", "9654321987654", "little", "black", "dress", "little black dress" ] }, "fields": { "displayGroup": [ "1833f6a0e45f6257a586877c8800f094" ] }, "sort": [ "little black dress", "0192679cfd11724a8a8a240e87b94175" ] }, { "_index": "sw_product_1729666761", "_id": "0191b87949d1727d83e3b365865d7ea2", "_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": "0191b87949d1727d83e3b365865d7ea2", "autoIncrement": 3906.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI405B176D1F", "ean": "6541289632548", "displayGroup": "1d24c1f432d77be01cafa401c1eae77d", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-09-03T15:20:58+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0191b87949d1727d83e3b365865d7ea2", "childCount": 0, "categories": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Maxi Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Look effortlessly chic in this flowy maxi dress. Featuring a beautiful floral pattern and made from lightweight fabric, this dress is perfect for any occasion.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your wardrobe with this stunning maxi dress!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 55.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 55.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai405b176d1f", "6541289632548", "maxi", "dress", "maxi dress" ] }, "fields": { "displayGroup": [ "1d24c1f432d77be01cafa401c1eae77d" ] }, "sort": [ "maxi dress", "0191b87949d1727d83e3b365865d7ea2" ] }, { "_index": "sw_product_1729666761", "_id": "0192679bf6bb732a87a3223af9f6fab5", "_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": "0192679bf6bb732a87a3223af9f6fab5", "autoIncrement": 3952.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI8E55851C30", "ean": "8568379125632", "displayGroup": "381803c7bb214022ed72ce00974f3e58", "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-07T15:32:28+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679bf6bb732a87a3223af9f6fab5", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Off-Shoulder Bodycon Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and stylish, this off-shoulder bodycon dress hugs your curves and accentuates your figure. Perfect for a night out with the girls!", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turn heads in this stunning off-shoulder bodycon dress.", "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": [ "ai8e55851c30", "8568379125632", "off-shoulder", "bodycon", "dress", "off-shoulder bodycon dress" ] }, "fields": { "displayGroup": [ "381803c7bb214022ed72ce00974f3e58" ] }, "sort": [ "off-shoulder bodycon dress", "0192679bf6bb732a87a3223af9f6fab5" ] }, { "_index": "sw_product_1729666761", "_id": "0192679da0e870f4a6ccc34245966b20", "_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": "0192679da0e870f4a6ccc34245966b20", "autoIncrement": 3958.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI38E50B9378", "ean": "8654321987654", "displayGroup": "c9bc20c00a0e7fe73f1268d32724cf5e", "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-07T15:34:14+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679da0e870f4a6ccc34245966b20", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polka Dot Swing Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fun and flirty, this polka dot swing dress is perfect for a day out with friends. It features a flowy silhouette and a flattering V-neckline.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Add a touch of retro charm to your wardrobe with this polka dot swing dress.", "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": [ "ai38e50b9378", "8654321987654", "polka", "dot", "swing", "dress", "polka dot swing dress" ] }, "fields": { "displayGroup": [ "c9bc20c00a0e7fe73f1268d32724cf5e" ] }, "sort": [ "polka dot swing dress", "0192679da0e870f4a6ccc34245966b20" ] }, { "_index": "sw_product_1729666761", "_id": "0192679de8bb7259b79fee51ed4af4bb", "_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": "0192679de8bb7259b79fee51ed4af4bb", "autoIncrement": 3959.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIE90E4AFBDE", "ean": "9723890654321", "displayGroup": "dded5ecbb4b9b930171246572a44553e", "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-07T15:34:30+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679de8bb7259b79fee51ed4af4bb", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Striped Shirt Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Effortlessly stylish, this striped shirt dress is perfect for a casual day out. It features a button-down front, tie waist, and a classic collar.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with this versatile striped shirt dress.", "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": [ "aie90e4afbde", "9723890654321", "striped", "shirt", "dress", "striped shirt dress" ] }, "fields": { "displayGroup": [ "dded5ecbb4b9b930171246572a44553e" ] }, "sort": [ "striped shirt dress", "0192679de8bb7259b79fee51ed4af4bb" ] }, { "_index": "sw_product_1729666761", "_id": "0191b877ee27708ea89ed9c981b0e739", "_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": "0191b877ee27708ea89ed9c981b0e739", "autoIncrement": 3901.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI11AD044C44", "ean": "8963254789651", "displayGroup": "64174b49ebb76d032da8e7fb2b24388b", "sales": 0, "stock": 99, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-09-03T15:19:30+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0191b877ee27708ea89ed9c981b0e739", "childCount": 0, "categories": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wrap Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A classic wrap dress with a modern twist. Made from flowy fabric and featuring a unique print, this dress is perfect for any occasion.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with this chic wrap dress!", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 40.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 40.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai11ad044c44", "8963254789651", "wrap", "dress", "wrap dress" ] }, "fields": { "displayGroup": [ "64174b49ebb76d032da8e7fb2b24388b" ] }, "sort": [ "wrap dress", "0191b877ee27708ea89ed9c981b0e739" ] }, { "_index": "sw_product_1729666761", "_id": "0192679c8b92722bb78fec132835654e", "_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": "0192679c8b92722bb78fec132835654e", "autoIncrement": 3954.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI67C318DB42", "ean": "4326710987325", "displayGroup": "d8b419e7ffb652b96fca03facacb0836", "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-07T15:32:58+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675783837818a20ba36699295e79" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675783837818a20ba36699295e79", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679c8b92722bb78fec132835654e", "childCount": 0, "categories": [ { "id": "0192675783837818a20ba36699295e79", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675783837818a20ba36699295e79" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wrap Dress", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Effortlessly chic, this wrap dress features a tie waist and a flirty ruffle hem. Perfect for a day at the office or a brunch date.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with this stylish wrap dress.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 44.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 44.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai67c318db42", "4326710987325", "wrap", "dress", "wrap dress" ] }, "fields": { "displayGroup": [ "d8b419e7ffb652b96fca03facacb0836" ] }, "sort": [ "wrap dress", "0192679c8b92722bb78fec132835654e" ] } ] }, "aggregations": { "total-count": { "value": 13 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	2.96 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":"0192675783837818a20ba36699295e79"}}}},{"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": "0192675783837818a20ba36699295e79" } } } }, { "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": 1, "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": 13, "rating": { "value": 0.0 } }, "price": { "count": 13, "min": 29.99, "max": 69.99, "avg": 47.3, "sum": 614.9 }, "options": { "doc_count": 0, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "properties": { "doc_count": 0, "properties": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } }, "manufacturer": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [] } } } `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":"0192675783837818a20ba36699295e79"}}}},{"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: 13
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": "0192675783837818a20ba36699295e79"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 13,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679e257f72088a96db7bacc02829",
                "_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": "0192679e257f72088a96db7bacc02829",
                    "autoIncrement": 3960.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AID22A748483",
                    "ean": "7654321987654",
                    "displayGroup": "1bc89ce4d4447558bdb7f5c1da4c7c04",
                    "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-07T15:34:47+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679e257f72088a96db7bacc02829",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bohemian Maxi Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Embrace your inner bohemian in this flowy maxi dress. It features a vibrant print, a halter neckline, and a tiered skirt. Perfect for a summer music festival or a beach vacation.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement in this bohemian-inspired maxi dress.",
                        "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": [
                        "aid22a748483",
                        "7654321987654",
                        "bohemian",
                        "maxi",
                        "dress",
                        "bohemian maxi dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "1bc89ce4d4447558bdb7f5c1da4c7c04"
                    ]
                },
                "sort": [
                    "bohemian maxi dress",
                    "0192679e257f72088a96db7bacc02829"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679cc0907270a5fe3d8415088dcd",
                "_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": "0192679cc0907270a5fe3d8415088dcd",
                    "autoIncrement": 3955.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI81F7F969BD",
                    "ean": "3765432198765",
                    "displayGroup": "4317f7939d5d54104d60995b11f55bc3",
                    "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-07T15:33:14+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679cc0907270a5fe3d8415088dcd",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Boho Mini Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Channel your inner free spirit in this boho mini dress. It features a flowy silhouette, bell sleeves, and a vibrant print. Perfect for a music festival or a beach vacation.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Be the ultimate boho babe in this mini dress.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 34.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai81f7f969bd",
                        "3765432198765",
                        "boho",
                        "mini",
                        "dress",
                        "boho mini dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "4317f7939d5d54104d60995b11f55bc3"
                    ]
                },
                "sort": [
                    "boho mini dress",
                    "0192679cc0907270a5fe3d8415088dcd"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679d5aef702ea66187db6d146f1b",
                "_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": "0192679d5aef702ea66187db6d146f1b",
                    "autoIncrement": 3957.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI3E99F30E88",
                    "ean": "6723890765432",
                    "displayGroup": "320d8c2aa96fde033aaf9180fdc0d5aa",
                    "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-07T15:33:56+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679d5aef702ea66187db6d146f1b",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Embroidered Maxi Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elevate your style with this stunning embroidered maxi dress. It features a halter neckline and intricate floral embroidery. Perfect for a summer wedding or a vacation.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with this eye-catching embroidered maxi dress.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 69.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 69.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai3e99f30e88",
                        "6723890765432",
                        "embroidered",
                        "maxi",
                        "dress",
                        "embroidered maxi dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "320d8c2aa96fde033aaf9180fdc0d5aa"
                    ]
                },
                "sort": [
                    "embroidered maxi dress",
                    "0192679d5aef702ea66187db6d146f1b"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679bc0507321ab7ffa45827d99f5",
                "_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": "0192679bc0507321ab7ffa45827d99f5",
                    "autoIncrement": 3951.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AID3C29620D0",
                    "ean": "7325610987432",
                    "displayGroup": "cf01bfd7b5c8d0d552e2c91cd2b9fdde",
                    "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-07T15:32:07+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679bc0507321ab7ffa45827d99f5",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Floral Maxi Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This beautiful floral maxi dress features a flowy silhouette and a V-neckline. Perfect for a summer day out or a special occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and versatile maxi dress, perfect for any occasion.",
                        "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": [
                        "aid3c29620d0",
                        "7325610987432",
                        "floral",
                        "maxi",
                        "dress",
                        "floral maxi dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "cf01bfd7b5c8d0d552e2c91cd2b9fdde"
                    ]
                },
                "sort": [
                    "floral maxi dress",
                    "0192679bc0507321ab7ffa45827d99f5"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0191b87696d173b6a6f406f88dc852e5",
                "_score": null,
                "_source": {
                    "id": "0191b87696d173b6a6f406f88dc852e5",
                    "autoIncrement": 3896.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI32C2611E75",
                    "ean": "9652148735698",
                    "displayGroup": "988668b6b7e5b2ed90d5ac29d578ad5c",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-09-03T15:18:05+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79",
                        "019735db603d7b25967a430ba7a80685",
                        "0198ea9e94ec7cfb9a8b517450acac50"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        },
                        {
                            "id": "019735db603d7b25967a430ba7a80685",
                            "_count": 1
                        },
                        {
                            "id": "0198ea9e94ec7cfb9a8b517450acac50",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0191b87696d173b6a6f406f88dc852e5",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "019735db603d7b25967a430ba7a80685",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test"
                            }
                        },
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung"
                            }
                        },
                        {
                            "id": "0198ea9e94ec7cfb9a8b517450acac50",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Angebote"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79",
                        "019735db603d7b25967a430ba7a80685",
                        "0198ea9e94ec7cfb9a8b517450acac50",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Floral Sundress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A beautiful sundress with a vibrant floral pattern, perfect for those sunny days. Made from lightweight and breathable fabric, this dress is both comfortable and stylish.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Look effortlessly chic in this floral sundress!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 50.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.0
                },
                "fields": {
                    "displayGroup": [
                        "988668b6b7e5b2ed90d5ac29d578ad5c"
                    ]
                },
                "sort": [
                    "floral sundress",
                    "0191b87696d173b6a6f406f88dc852e5"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679c4bb07093bd1a3c94b3655584",
                "_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": "0192679c4bb07093bd1a3c94b3655584",
                    "autoIncrement": 3953.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIA04E8711F7",
                    "ean": "6567812398567",
                    "displayGroup": "a01feedbedb2c8513ab55198817b0276",
                    "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-07T15:32:45+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679c4bb07093bd1a3c94b3655584",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lace Midi Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This delicate lace midi dress features a high neckline and a flattering A-line silhouette. Perfect for a wedding or a fancy dinner.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement in this elegant lace midi dress.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 59.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aia04e8711f7",
                        "6567812398567",
                        "lace",
                        "midi",
                        "dress",
                        "lace midi dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "a01feedbedb2c8513ab55198817b0276"
                    ]
                },
                "sort": [
                    "lace midi dress",
                    "0192679c4bb07093bd1a3c94b3655584"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679cfd11724a8a8a240e87b94175",
                "_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": "0192679cfd11724a8a8a240e87b94175",
                    "autoIncrement": 3956.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI82240759EA",
                    "ean": "9654321987654",
                    "displayGroup": "1833f6a0e45f6257a586877c8800f094",
                    "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-07T15:33:38+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679cfd11724a8a8a240e87b94175",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Little Black Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A wardrobe essential, this little black dress is perfect for any occasion. It features a classic fit and flare silhouette and a subtle V-neckline.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Every woman needs a little black dress in her closet.",
                        "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": [
                        "ai82240759ea",
                        "9654321987654",
                        "little",
                        "black",
                        "dress",
                        "little black dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "1833f6a0e45f6257a586877c8800f094"
                    ]
                },
                "sort": [
                    "little black dress",
                    "0192679cfd11724a8a8a240e87b94175"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0191b87949d1727d83e3b365865d7ea2",
                "_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": "0191b87949d1727d83e3b365865d7ea2",
                    "autoIncrement": 3906.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI405B176D1F",
                    "ean": "6541289632548",
                    "displayGroup": "1d24c1f432d77be01cafa401c1eae77d",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-09-03T15:20:58+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0191b87949d1727d83e3b365865d7ea2",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Maxi Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Look effortlessly chic in this flowy maxi dress. Featuring a beautiful floral pattern and made from lightweight fabric, this dress is perfect for any occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Upgrade your wardrobe with this stunning maxi dress!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 55.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 55.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai405b176d1f",
                        "6541289632548",
                        "maxi",
                        "dress",
                        "maxi dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "1d24c1f432d77be01cafa401c1eae77d"
                    ]
                },
                "sort": [
                    "maxi dress",
                    "0191b87949d1727d83e3b365865d7ea2"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679bf6bb732a87a3223af9f6fab5",
                "_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": "0192679bf6bb732a87a3223af9f6fab5",
                    "autoIncrement": 3952.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI8E55851C30",
                    "ean": "8568379125632",
                    "displayGroup": "381803c7bb214022ed72ce00974f3e58",
                    "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-07T15:32:28+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679bf6bb732a87a3223af9f6fab5",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Off-Shoulder Bodycon Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and stylish, this off-shoulder bodycon dress hugs your curves and accentuates your figure. Perfect for a night out with the girls!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Turn heads in this stunning off-shoulder bodycon dress.",
                        "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": [
                        "ai8e55851c30",
                        "8568379125632",
                        "off-shoulder",
                        "bodycon",
                        "dress",
                        "off-shoulder bodycon dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "381803c7bb214022ed72ce00974f3e58"
                    ]
                },
                "sort": [
                    "off-shoulder bodycon dress",
                    "0192679bf6bb732a87a3223af9f6fab5"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679da0e870f4a6ccc34245966b20",
                "_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": "0192679da0e870f4a6ccc34245966b20",
                    "autoIncrement": 3958.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI38E50B9378",
                    "ean": "8654321987654",
                    "displayGroup": "c9bc20c00a0e7fe73f1268d32724cf5e",
                    "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-07T15:34:14+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679da0e870f4a6ccc34245966b20",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polka Dot Swing Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fun and flirty, this polka dot swing dress is perfect for a day out with friends. It features a flowy silhouette and a flattering V-neckline.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Add a touch of retro charm to your wardrobe with this polka dot swing dress.",
                        "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": [
                        "ai38e50b9378",
                        "8654321987654",
                        "polka",
                        "dot",
                        "swing",
                        "dress",
                        "polka dot swing dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c9bc20c00a0e7fe73f1268d32724cf5e"
                    ]
                },
                "sort": [
                    "polka dot swing dress",
                    "0192679da0e870f4a6ccc34245966b20"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679de8bb7259b79fee51ed4af4bb",
                "_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": "0192679de8bb7259b79fee51ed4af4bb",
                    "autoIncrement": 3959.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIE90E4AFBDE",
                    "ean": "9723890654321",
                    "displayGroup": "dded5ecbb4b9b930171246572a44553e",
                    "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-07T15:34:30+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679de8bb7259b79fee51ed4af4bb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Striped Shirt Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Effortlessly stylish, this striped shirt dress is perfect for a casual day out. It features a button-down front, tie waist, and a classic collar.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with this versatile striped shirt dress.",
                        "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": [
                        "aie90e4afbde",
                        "9723890654321",
                        "striped",
                        "shirt",
                        "dress",
                        "striped shirt dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "dded5ecbb4b9b930171246572a44553e"
                    ]
                },
                "sort": [
                    "striped shirt dress",
                    "0192679de8bb7259b79fee51ed4af4bb"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0191b877ee27708ea89ed9c981b0e739",
                "_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": "0191b877ee27708ea89ed9c981b0e739",
                    "autoIncrement": 3901.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI11AD044C44",
                    "ean": "8963254789651",
                    "displayGroup": "64174b49ebb76d032da8e7fb2b24388b",
                    "sales": 0,
                    "stock": 99,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-09-03T15:19:30+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0191b877ee27708ea89ed9c981b0e739",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wrap Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A classic wrap dress with a modern twist. Made from flowy fabric and featuring a unique print, this dress is perfect for any occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with this chic wrap dress!",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 40.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 40.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai11ad044c44",
                        "8963254789651",
                        "wrap",
                        "dress",
                        "wrap dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "64174b49ebb76d032da8e7fb2b24388b"
                    ]
                },
                "sort": [
                    "wrap dress",
                    "0191b877ee27708ea89ed9c981b0e739"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679c8b92722bb78fec132835654e",
                "_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": "0192679c8b92722bb78fec132835654e",
                    "autoIncrement": 3954.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI67C318DB42",
                    "ean": "4326710987325",
                    "displayGroup": "d8b419e7ffb652b96fca03facacb0836",
                    "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-07T15:32:58+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675783837818a20ba36699295e79"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679c8b92722bb78fec132835654e",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675783837818a20ba36699295e79",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleider"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675783837818a20ba36699295e79"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wrap Dress",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Effortlessly chic, this wrap dress features a tie waist and a flirty ruffle hem. Perfect for a day at the office or a brunch date.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with this stylish wrap dress.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 44.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 44.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai67c318db42",
                        "4326710987325",
                        "wrap",
                        "dress",
                        "wrap dress"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "d8b419e7ffb652b96fca03facacb0836"
                    ]
                },
                "sort": [
                    "wrap dress",
                    "0192679c8b92722bb78fec132835654e"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 13
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

2.96 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":"0192675783837818a20ba36699295e79"}}}},{"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": "0192675783837818a20ba36699295e79"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 1,
    "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": 13,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 13,
            "min": 29.99,
            "max": 69.99,
            "avg": 47.3,
            "sum": 614.9
        },
        "options": {
            "doc_count": 0,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "properties": {
            "doc_count": 0,
            "properties": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": []
            }
        },
        "manufacturer": {
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0,
            "buckets": []
        }
    }
}

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/0192675783837818a20ba36699295e79

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices