Symfony Profiler

Query Metrics

8.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

6.00 ms

#▲	Execution Time	Info
1	6.00 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":"0192675795477f3094fabf99ba9a6640"}}}},{"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: 10 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": "0192675795477f3094fabf99ba9a6640" } } } }, { "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": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 10, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1729666761", "_id": "01926795b6a373a1a56121e884415649", "_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": "01926795b6a373a1a56121e884415649", "autoIncrement": 3942.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1359AF5E96", "ean": "9567123846501", "displayGroup": "9dd6028b534d157014c65f22db6fca41", "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:25:33+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926795b6a373a1a56121e884415649", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cargo Pants", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Durable and functional, these cargo pants are perfect for hiking or outdoor activities. Multiple pockets for all your essentials and made from tough, water-resistant fabric.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Functional and durable cargo pants for all your outdoor adventures.", "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": [ "ai1359af5e96", "9567123846501", "cargo", "pants", "cargo pants" ] }, "fields": { "displayGroup": [ "9dd6028b534d157014c65f22db6fca41" ] }, "sort": [ "cargo pants", "01926795b6a373a1a56121e884415649" ] }, { "_index": "sw_product_1729666761", "_id": "0191b879d05e72c78617b40e9b6c41b1", "_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": "0191b879d05e72c78617b40e9b6c41b1", "autoIncrement": 3908.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIC53B923B67", "ean": "1236547896258", "displayGroup": "4b78920e2b7923071a03c9ab4472af81", "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:21:37+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0191b879d05e72c78617b40e9b6c41b1", "childCount": 0, "categories": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Flare Jeans", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with these trendy cropped flare jeans. Featuring a unique design and made from stretchy denim material, these jeans are sure to turn heads.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 50.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aic53b923b67", "1236547896258", "cropped", "flare", "jeans", "cropped flare jeans" ] }, "fields": { "displayGroup": [ "4b78920e2b7923071a03c9ab4472af81" ] }, "sort": [ "cropped flare jeans", "0191b879d05e72c78617b40e9b6c41b1" ] }, { "_index": "sw_product_1729666761", "_id": "01926795f6477246ba9bc1433f7c00a0", "_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": "01926795f6477246ba9bc1433f7c00a0", "autoIncrement": 3943.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI02DBA47E97", "ean": "5247984356129", "displayGroup": "3f66f673b80f921c00c7fc67fb9f8f9b", "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:25:49+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926795f6477246ba9bc1433f7c00a0", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Flare Pants", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy and versatile, these cropped flare pants can be dressed up or down for any occasion. Made from soft and breathable fabric for ultimate comfort.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Versatile and trendy cropped flare pants for a stylish and comfortable look.", "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": [ "ai02dba47e97", "5247984356129", "cropped", "flare", "pants", "cropped flare pants" ] }, "fields": { "displayGroup": [ "3f66f673b80f921c00c7fc67fb9f8f9b" ] }, "sort": [ "cropped flare pants", "01926795f6477246ba9bc1433f7c00a0" ] }, { "_index": "sw_product_1729666761", "_id": "01926796f41c70359862cda21bdec54c", "_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": "01926796f41c70359862cda21bdec54c", "autoIncrement": 3949.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI96E51FFC58", "ean": "4567891234567", "displayGroup": "c4d66df593ba4bd1b5b4f8e306b891b1", "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:26:52+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926796f41c70359862cda21bdec54c", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Wide-leg Jeans", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A modern twist on classic denim, these cropped wide-leg jeans are a must-have for any fashion lover. Made from high-quality denim for a flattering and comfortable fit.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy and stylish cropped wide-leg jeans for a unique and fashionable look.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 89.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai96e51ffc58", "4567891234567", "cropped", "wide-leg", "jeans", "cropped wide-leg jeans" ] }, "fields": { "displayGroup": [ "c4d66df593ba4bd1b5b4f8e306b891b1" ] }, "sort": [ "cropped wide-leg jeans", "01926796f41c70359862cda21bdec54c" ] }, { "_index": "sw_product_1729666761", "_id": "0191b877ad5a72f2b6e8ebf92373eae9", "_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": "0191b877ad5a72f2b6e8ebf92373eae9", "autoIncrement": 3900.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI41C7446A10", "ean": "1236547896254", "displayGroup": "be6c82aa36770adfe1cd0151736e43c2", "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:12+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0191b877ad5a72f2b6e8ebf92373eae9", "childCount": 0, "categories": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-Waisted Jeans", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "These flattering high-waisted jeans are a must-have for any wardrobe. Made from stretchy denim material, these jeans are both comfortable and stylish.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with these high-waisted jeans!", "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": [ "ai41c7446a10", "1236547896254", "high-waisted", "jeans", "high-waisted jeans" ] }, "fields": { "displayGroup": [ "be6c82aa36770adfe1cd0151736e43c2" ] }, "sort": [ "high-waisted jeans", "0191b877ad5a72f2b6e8ebf92373eae9" ] }, { "_index": "sw_product_1729666761", "_id": "01926796b8d171cd9eda17ad41ea7d9c", "_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": "01926796b8d171cd9eda17ad41ea7d9c", "autoIncrement": 3947.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI9A67BC972C", "ean": "1234567894567", "displayGroup": "41551b3d332f22bfd390e5d9d1bcac4e", "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:26:38+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926796b8d171cd9eda17ad41ea7d9c", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-waisted Palazzo Pants", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and sophisticated, these high-waisted palazzo pants are perfect for a night out or a special occasion. Made from flowy and lightweight fabric for a flattering fit.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and flowy high-waisted palazzo pants for a chic and flattering look.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai9a67bc972c", "1234567894567", "high-waisted", "palazzo", "pants", "high-waisted palazzo pants" ] }, "fields": { "displayGroup": [ "41551b3d332f22bfd390e5d9d1bcac4e" ] }, "sort": [ "high-waisted palazzo pants", "01926796b8d171cd9eda17ad41ea7d9c" ] }, { "_index": "sw_product_1729666761", "_id": "01926796768873c592c385e8319756eb", "_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": "01926796768873c592c385e8319756eb", "autoIncrement": 3945.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI609C7F08D2", "ean": "7892345123789", "displayGroup": "6e609c5f367cd4b97374ccfad575ef07", "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:26:23+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926796768873c592c385e8319756eb", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jogger Pants", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfortable and stylish, these jogger pants are perfect for lounging or running errands. Made from soft and stretchy fabric for maximum comfort.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Soft and stretchy jogger pants for a comfortable and casual look.", "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": [ "ai609c7f08d2", "7892345123789", "jogger", "pants", "jogger pants" ] }, "fields": { "displayGroup": [ "6e609c5f367cd4b97374ccfad575ef07" ] }, "sort": [ "jogger pants", "01926796768873c592c385e8319756eb" ] }, { "_index": "sw_product_1729666761", "_id": "01926795215273509a97a8e3c3b5ede0", "_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": "01926795215273509a97a8e3c3b5ede0", "autoIncrement": 3940.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI7DF97DDBE6", "ean": "8569731425685", "displayGroup": "1de1a79661696ea493c57055109cd19c", "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:25:01+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926795215273509a97a8e3c3b5ede0", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Skinny Jeans", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-waisted, stretchy denim skinny jeans that hug your curves in all the right places. Perfect for a night out or a casual day at the office.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Curve-hugging high-waisted stretchy denim skinny jeans.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 75.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai7df97ddbe6", "8569731425685", "skinny", "jeans", "skinny jeans" ] }, "fields": { "displayGroup": [ "1de1a79661696ea493c57055109cd19c" ] }, "sort": [ "skinny jeans", "01926795215273509a97a8e3c3b5ede0" ] }, { "_index": "sw_product_1729666761", "_id": "01926796318b70c58865a8276c0818f7", "_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": "01926796318b70c58865a8276c0818f7", "autoIncrement": 3944.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI89B7F6E88C", "ean": "2976851234567", "displayGroup": "a47302fa4d9b95d9c1ba14ef3bc07f10", "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:26:06+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926796318b70c58865a8276c0818f7", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Slim-fit Chinos", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic and timeless, these slim-fit chinos are a must-have in every wardrobe. Made from high-quality cotton for a comfortable and polished look.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Timeless and polished slim-fit chinos for a classic look.", "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": [ "ai89b7f6e88c", "2976851234567", "slim-fit", "chinos", "slim-fit chinos" ] }, "fields": { "displayGroup": [ "a47302fa4d9b95d9c1ba14ef3bc07f10" ] }, "sort": [ "slim-fit chinos", "01926796318b70c58865a8276c0818f7" ] }, { "_index": "sw_product_1729666761", "_id": "019267957b1b73babc004499f008f7d9", "_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": "019267957b1b73babc004499f008f7d9", "autoIncrement": 3941.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIA8CC4FCA72", "ean": "6743820193762", "displayGroup": "b709e754cd8bd949dc284e666345c4ab", "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:25:17+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "0192675795477f3094fabf99ba9a6640" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "019267957b1b73babc004499f008f7d9", "childCount": 0, "categories": [ { "id": "0192675795477f3094fabf99ba9a6640", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "0192675795477f3094fabf99ba9a6640" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wide-leg Trousers", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flowy and comfortable, these wide-leg trousers are perfect for a day at the beach or a summer picnic. Made from lightweight, breathable fabric.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lightweight and flowy wide-leg trousers for a comfortable and stylish summer look.", "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": [ "aia8cc4fca72", "6743820193762", "wide-leg", "trousers", "wide-leg trousers" ] }, "fields": { "displayGroup": [ "b709e754cd8bd949dc284e666345c4ab" ] }, "sort": [ "wide-leg trousers", "019267957b1b73babc004499f008f7d9" ] } ] }, "aggregations": { "total-count": { "value": 10 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	2.21 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":"0192675795477f3094fabf99ba9a6640"}}}},{"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": "0192675795477f3094fabf99ba9a6640" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 0, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 10, "rating": { "value": 0.0 } }, "price": { "count": 10, "min": 29.99, "max": 89.99, "avg": 60.092, "sum": 600.92 }, "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":"0192675795477f3094fabf99ba9a6640"}}}},{"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: 10
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": "0192675795477f3094fabf99ba9a6640"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 10,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1729666761",
                "_id": "01926795b6a373a1a56121e884415649",
                "_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": "01926795b6a373a1a56121e884415649",
                    "autoIncrement": 3942.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1359AF5E96",
                    "ean": "9567123846501",
                    "displayGroup": "9dd6028b534d157014c65f22db6fca41",
                    "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:25:33+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926795b6a373a1a56121e884415649",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cargo Pants",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Durable and functional, these cargo pants are perfect for hiking or outdoor activities. Multiple pockets for all your essentials and made from tough, water-resistant fabric.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Functional and durable cargo pants for all your outdoor adventures.",
                        "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": [
                        "ai1359af5e96",
                        "9567123846501",
                        "cargo",
                        "pants",
                        "cargo pants"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "9dd6028b534d157014c65f22db6fca41"
                    ]
                },
                "sort": [
                    "cargo pants",
                    "01926795b6a373a1a56121e884415649"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0191b879d05e72c78617b40e9b6c41b1",
                "_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": "0191b879d05e72c78617b40e9b6c41b1",
                    "autoIncrement": 3908.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIC53B923B67",
                    "ean": "1236547896258",
                    "displayGroup": "4b78920e2b7923071a03c9ab4472af81",
                    "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:21:37+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0191b879d05e72c78617b40e9b6c41b1",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Flare Jeans",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Make a statement with these trendy cropped flare jeans. Featuring a unique design and made from stretchy denim material, these jeans are sure to turn heads.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 50.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aic53b923b67",
                        "1236547896258",
                        "cropped",
                        "flare",
                        "jeans",
                        "cropped flare jeans"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "4b78920e2b7923071a03c9ab4472af81"
                    ]
                },
                "sort": [
                    "cropped flare jeans",
                    "0191b879d05e72c78617b40e9b6c41b1"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926795f6477246ba9bc1433f7c00a0",
                "_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": "01926795f6477246ba9bc1433f7c00a0",
                    "autoIncrement": 3943.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI02DBA47E97",
                    "ean": "5247984356129",
                    "displayGroup": "3f66f673b80f921c00c7fc67fb9f8f9b",
                    "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:25:49+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926795f6477246ba9bc1433f7c00a0",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Flare Pants",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy and versatile, these cropped flare pants can be dressed up or down for any occasion. Made from soft and breathable fabric for ultimate comfort.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Versatile and trendy cropped flare pants for a stylish and comfortable look.",
                        "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": [
                        "ai02dba47e97",
                        "5247984356129",
                        "cropped",
                        "flare",
                        "pants",
                        "cropped flare pants"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "3f66f673b80f921c00c7fc67fb9f8f9b"
                    ]
                },
                "sort": [
                    "cropped flare pants",
                    "01926795f6477246ba9bc1433f7c00a0"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926796f41c70359862cda21bdec54c",
                "_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": "01926796f41c70359862cda21bdec54c",
                    "autoIncrement": 3949.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI96E51FFC58",
                    "ean": "4567891234567",
                    "displayGroup": "c4d66df593ba4bd1b5b4f8e306b891b1",
                    "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:26:52+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926796f41c70359862cda21bdec54c",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cropped Wide-leg Jeans",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A modern twist on classic denim, these cropped wide-leg jeans are a must-have for any fashion lover. Made from high-quality denim for a flattering and comfortable fit.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy and stylish cropped wide-leg jeans for a unique and fashionable look.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 89.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai96e51ffc58",
                        "4567891234567",
                        "cropped",
                        "wide-leg",
                        "jeans",
                        "cropped wide-leg jeans"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "c4d66df593ba4bd1b5b4f8e306b891b1"
                    ]
                },
                "sort": [
                    "cropped wide-leg jeans",
                    "01926796f41c70359862cda21bdec54c"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0191b877ad5a72f2b6e8ebf92373eae9",
                "_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": "0191b877ad5a72f2b6e8ebf92373eae9",
                    "autoIncrement": 3900.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI41C7446A10",
                    "ean": "1236547896254",
                    "displayGroup": "be6c82aa36770adfe1cd0151736e43c2",
                    "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:12+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0191b877ad5a72f2b6e8ebf92373eae9",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kleidung"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-Waisted Jeans",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "These flattering high-waisted jeans are a must-have for any wardrobe. Made from stretchy denim material, these jeans are both comfortable and stylish.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stay on-trend with these high-waisted jeans!",
                        "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": [
                        "ai41c7446a10",
                        "1236547896254",
                        "high-waisted",
                        "jeans",
                        "high-waisted jeans"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "be6c82aa36770adfe1cd0151736e43c2"
                    ]
                },
                "sort": [
                    "high-waisted jeans",
                    "0191b877ad5a72f2b6e8ebf92373eae9"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926796b8d171cd9eda17ad41ea7d9c",
                "_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": "01926796b8d171cd9eda17ad41ea7d9c",
                    "autoIncrement": 3947.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI9A67BC972C",
                    "ean": "1234567894567",
                    "displayGroup": "41551b3d332f22bfd390e5d9d1bcac4e",
                    "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:26:38+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926796b8d171cd9eda17ad41ea7d9c",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-waisted Palazzo Pants",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and sophisticated, these high-waisted palazzo pants are perfect for a night out or a special occasion. Made from flowy and lightweight fabric for a flattering fit.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant and flowy high-waisted palazzo pants for a chic and flattering look.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 79.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai9a67bc972c",
                        "1234567894567",
                        "high-waisted",
                        "palazzo",
                        "pants",
                        "high-waisted palazzo pants"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "41551b3d332f22bfd390e5d9d1bcac4e"
                    ]
                },
                "sort": [
                    "high-waisted palazzo pants",
                    "01926796b8d171cd9eda17ad41ea7d9c"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926796768873c592c385e8319756eb",
                "_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": "01926796768873c592c385e8319756eb",
                    "autoIncrement": 3945.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI609C7F08D2",
                    "ean": "7892345123789",
                    "displayGroup": "6e609c5f367cd4b97374ccfad575ef07",
                    "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:26:23+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926796768873c592c385e8319756eb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jogger Pants",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfortable and stylish, these jogger pants are perfect for lounging or running errands. Made from soft and stretchy fabric for maximum comfort.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Soft and stretchy jogger pants for a comfortable and casual look.",
                        "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": [
                        "ai609c7f08d2",
                        "7892345123789",
                        "jogger",
                        "pants",
                        "jogger pants"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "6e609c5f367cd4b97374ccfad575ef07"
                    ]
                },
                "sort": [
                    "jogger pants",
                    "01926796768873c592c385e8319756eb"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926795215273509a97a8e3c3b5ede0",
                "_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": "01926795215273509a97a8e3c3b5ede0",
                    "autoIncrement": 3940.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI7DF97DDBE6",
                    "ean": "8569731425685",
                    "displayGroup": "1de1a79661696ea493c57055109cd19c",
                    "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:25:01+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926795215273509a97a8e3c3b5ede0",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Skinny Jeans",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High-waisted, stretchy denim skinny jeans that hug your curves in all the right places. Perfect for a night out or a casual day at the office.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Curve-hugging high-waisted stretchy denim skinny jeans.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 75.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai7df97ddbe6",
                        "8569731425685",
                        "skinny",
                        "jeans",
                        "skinny jeans"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "1de1a79661696ea493c57055109cd19c"
                    ]
                },
                "sort": [
                    "skinny jeans",
                    "01926795215273509a97a8e3c3b5ede0"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926796318b70c58865a8276c0818f7",
                "_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": "01926796318b70c58865a8276c0818f7",
                    "autoIncrement": 3944.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI89B7F6E88C",
                    "ean": "2976851234567",
                    "displayGroup": "a47302fa4d9b95d9c1ba14ef3bc07f10",
                    "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:26:06+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926796318b70c58865a8276c0818f7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Slim-fit Chinos",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic and timeless, these slim-fit chinos are a must-have in every wardrobe. Made from high-quality cotton for a comfortable and polished look.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Timeless and polished slim-fit chinos for a classic look.",
                        "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": [
                        "ai89b7f6e88c",
                        "2976851234567",
                        "slim-fit",
                        "chinos",
                        "slim-fit chinos"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "a47302fa4d9b95d9c1ba14ef3bc07f10"
                    ]
                },
                "sort": [
                    "slim-fit chinos",
                    "01926796318b70c58865a8276c0818f7"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "019267957b1b73babc004499f008f7d9",
                "_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": "019267957b1b73babc004499f008f7d9",
                    "autoIncrement": 3941.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIA8CC4FCA72",
                    "ean": "6743820193762",
                    "displayGroup": "b709e754cd8bd949dc284e666345c4ab",
                    "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:25:17+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "019267957b1b73babc004499f008f7d9",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "0192675795477f3094fabf99ba9a6640",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hosen"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "0192675795477f3094fabf99ba9a6640"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wide-leg Trousers",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Flowy and comfortable, these wide-leg trousers are perfect for a day at the beach or a summer picnic. Made from lightweight, breathable fabric.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lightweight and flowy wide-leg trousers for a comfortable and stylish summer look.",
                        "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": [
                        "aia8cc4fca72",
                        "6743820193762",
                        "wide-leg",
                        "trousers",
                        "wide-leg trousers"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b709e754cd8bd949dc284e666345c4ab"
                    ]
                },
                "sort": [
                    "wide-leg trousers",
                    "019267957b1b73babc004499f008f7d9"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 10
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

2.21 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":"0192675795477f3094fabf99ba9a6640"}}}},{"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": "0192675795477f3094fabf99ba9a6640"
                                        }
                                    }
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "aggregations": {
        "manufacturer": {
            "terms": {
                "field": "manufacturerId",
                "size": 10000
            }
        },
        "price": {
            "stats": {
                "script": {
                    "id": "cheapest_price",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                }
            }
        },
        "rating-exists": {
            "filter": {
                "range": {
                    "ratingAverage": {
                        "gte": 0.0
                    }
                }
            },
            "aggregations": {
                "rating": {
                    "max": {
                        "field": "ratingAverage"
                    }
                }
            }
        },
        "shipping-free-filter": {
            "filter": {
                "term": {
                    "shippingFree": true
                }
            },
            "aggregations": {
                "shipping-free": {
                    "max": {
                        "field": "shippingFree"
                    }
                }
            }
        },
        "properties": {
            "nested": {
                "path": "properties"
            },
            "aggregations": {
                "properties": {
                    "terms": {
                        "field": "properties.id",
                        "size": 10000
                    }
                }
            }
        },
        "options": {
            "nested": {
                "path": "options"
            },
            "aggregations": {
                "options": {
                    "terms": {
                        "field": "options.id",
                        "size": 10000
                    }
                }
            }
        }
    },
    "size": 0,
    "timeout": "5s"
}


                                    {
    "took": 0,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 10,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 10,
            "min": 29.99,
            "max": 89.99,
            "avg": 60.092,
            "sum": 600.92
        },
        "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/0192675795477f3094fabf99ba9a6640

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices