Symfony Profiler

Query Metrics

10.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

8.28 ms

#▲	Execution Time	Info
1	8.28 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":"01926759b0337ef0a5ec508d6f0387b7"}}}},{"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: 11 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": "01926759b0337ef0a5ec508d6f0387b7" } } } }, { "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": 3, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "total": { "value": 11, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1729666761", "_id": "01926792f2e97361a6f7e60465b4a2a7", "_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": "01926792f2e97361a6f7e60465b4a2a7", "autoIncrement": 3934.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI9D856B6E6D", "ean": "8632910487562", "displayGroup": "cc87a9898a311b39ca09988a3131092e", "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:22:38+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926792f2e97361a6f7e60465b4a2a7", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamond Pendant Necklace", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stunning diamond pendant necklace, featuring a brilliant round cut diamond set in 14k white gold.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dazzling diamond pendant necklace, perfect for a special occasion.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 450.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 450.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai9d856b6e6d", "8632910487562", "diamond", "pendant", "necklace", "diamond pendant necklace" ] }, "fields": { "displayGroup": [ "cc87a9898a311b39ca09988a3131092e" ] }, "sort": [ "diamond pendant necklace", "01926792f2e97361a6f7e60465b4a2a7" ] }, { "_index": "sw_product_1729666761", "_id": "0192678f9151737d8c7b7040ad2de232", "_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": "0192678f9151737d8c7b7040ad2de232", "autoIncrement": 3921.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI85D27BCB56", "ean": " 726394859210", "displayGroup": "50251d368bfdb4dc96d248d866db31b2", "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:18:55+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192678f9151737d8c7b7040ad2de232", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamond Stud Earrings", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "These stunning diamond stud earrings are a timeless addition to any jewelry collection. The sparkling diamonds are set in 14K white gold, giving them a modern and luxurious look.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Elevate your style with these dazzling diamond stud earrings.\"", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 350.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 350.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai85d27bcb56", "726394859210", "diamond", "stud", "earrings", " 726394859210", "diamond stud earrings" ] }, "fields": { "displayGroup": [ "50251d368bfdb4dc96d248d866db31b2" ] }, "sort": [ "diamond stud earrings", "0192678f9151737d8c7b7040ad2de232" ] }, { "_index": "sw_product_1729666761", "_id": "0192679347f9737ea357de9bcc879667", "_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": "0192679347f9737ea357de9bcc879667", "autoIncrement": 3935.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI3E1C1F72F7", "ean": "6253719840243", "displayGroup": "3cde1ff13d2afdfafdfed0a045158f3f", "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:22:54+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679347f9737ea357de9bcc879667", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Emerald Stud Earrings", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beautiful emerald stud earrings, perfect for adding a pop of color to any outfit.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gorgeous emerald stud earrings, a must-have for any jewelry collection.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 120.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 120.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai3e1c1f72f7", "6253719840243", "emerald", "stud", "earrings", "emerald stud earrings" ] }, "fields": { "displayGroup": [ "3cde1ff13d2afdfafdfed0a045158f3f" ] }, "sort": [ "emerald stud earrings", "0192679347f9737ea357de9bcc879667" ] }, { "_index": "sw_product_1729666761", "_id": "01926792b33f73829909357a0d2ee6f3", "_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": "01926792b33f73829909357a0d2ee6f3", "autoIncrement": 3933.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI790283D410", "ean": "7845123409876", "displayGroup": "8ebc577b0abff556e258b7676328a317", "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:22:16+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926792b33f73829909357a0d2ee6f3", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gold Hoop Earrings", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Simple and elegant gold hoop earrings, perfect for everyday wear.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic gold hoop earrings for any occasion.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai790283d410", "7845123409876", "gold", "hoop", "earrings", "gold hoop earrings" ] }, "fields": { "displayGroup": [ "8ebc577b0abff556e258b7676328a317" ] }, "sort": [ "gold hoop earrings", "01926792b33f73829909357a0d2ee6f3" ] }, { "_index": "sw_product_1729666761", "_id": "0192678f4e6871debc048233d325480b", "_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": "0192678f4e6871debc048233d325480b", "autoIncrement": 3920.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1CBE794467", "ean": " 483726543218", "displayGroup": "5d14922f79080e656a9b148539eb4fbb", "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:18:34+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192678f4e6871debc048233d325480b", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gold Necklace", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This elegant gold necklace is perfect for everyday wear. Its simple design makes it suitable for any occasion, while the high-quality materials ensure durability and shine.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Add a touch of luxury to your outfit with this beautiful gold necklace.\"", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai1cbe794467", "483726543218", "gold", "necklace", " 483726543218", "gold necklace" ] }, "fields": { "displayGroup": [ "5d14922f79080e656a9b148539eb4fbb" ] }, "sort": [ "gold necklace", "0192678f4e6871debc048233d325480b" ] }, { "_index": "sw_product_1729666761", "_id": "01926793c04372c49f77b1418268ff88", "_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": "01926793c04372c49f77b1418268ff88", "autoIncrement": 3937.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1D7E97FEEF", "ean": "7826391047523", "displayGroup": "da394713451367f92e40ec26f6abb75f", "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:23:26+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926793c04372c49f77b1418268ff88", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pearl Drop Earrings", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant pearl drop earrings, featuring lustrous freshwater pearls and sparkling diamonds.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic pearl drop earrings, perfect for a formal event or date night.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 250.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 250.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai1d7e97feef", "7826391047523", "pearl", "drop", "earrings", "pearl drop earrings" ] }, "fields": { "displayGroup": [ "da394713451367f92e40ec26f6abb75f" ] }, "sort": [ "pearl drop earrings", "01926793c04372c49f77b1418268ff88" ] }, { "_index": "sw_product_1729666761", "_id": "0192679f2684729299bb0211789027e4", "_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": "0192679f2684729299bb0211789027e4", "autoIncrement": 3962.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI632A2C9409", "ean": "2749182736456", "displayGroup": "0fec62f346c7a6bad2888d911e230b2d", "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:35:54+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679f2684729299bb0211789027e4", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pleated Midi Skirt", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Add a touch of elegance to your wardrobe with our Pleated Midi Skirt. The pleats create a flattering A-line shape, while the midi length is perfect for any occasion.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elevate your outfit with our Pleated Midi Skirt - the perfect combination of style and sophistication. ", "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": [ "ai632a2c9409", "2749182736456", "pleated", "midi", "skirt", "pleated midi skirt" ] }, "fields": { "displayGroup": [ "0fec62f346c7a6bad2888d911e230b2d" ] }, "sort": [ "pleated midi skirt", "0192679f2684729299bb0211789027e4" ] }, { "_index": "sw_product_1729666761", "_id": "0192679404ac710ea6351e3f6dcef1e7", "_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": "0192679404ac710ea6351e3f6dcef1e7", "autoIncrement": 3938.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AIC860ADE8C4", "ean": "5629381094752", "displayGroup": "a3d4559b8f1e7b762df049be69c041ab", "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:23:43+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679404ac710ea6351e3f6dcef1e7", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rose Gold Stackable Rings", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Set of three dainty rose gold rings, perfect for mixing and matching.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy rose gold stackable rings, a must-have for any fashion-forward jewelry lover.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 90.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 90.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aic860ade8c4", "5629381094752", "rose", "gold", "stackable", "rings", "rose gold stackable rings" ] }, "fields": { "displayGroup": [ "a3d4559b8f1e7b762df049be69c041ab" ] }, "sort": [ "rose gold stackable rings", "0192679404ac710ea6351e3f6dcef1e7" ] }, { "_index": "sw_product_1729666761", "_id": "0192679445a87295bbb6d0430c35a939", "_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": "0192679445a87295bbb6d0430c35a939", "autoIncrement": 3939.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI7AC1199AD5", "ean": "3648120956732", "displayGroup": "9f38a9e75c5cbe179e8098a7a695cd4e", "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:24:05+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192679445a87295bbb6d0430c35a939", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sapphire Tennis Bracelet", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Timeless sapphire tennis bracelet, featuring a row of vibrant sapphires set in 18k white gold.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Luxurious sapphire tennis bracelet, a statement piece for any formal occasion.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 650.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 650.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai7ac1199ad5", "3648120956732", "sapphire", "tennis", "bracelet", "sapphire tennis bracelet" ] }, "fields": { "displayGroup": [ "9f38a9e75c5cbe179e8098a7a695cd4e" ] }, "sort": [ "sapphire tennis bracelet", "0192679445a87295bbb6d0430c35a939" ] }, { "_index": "sw_product_1729666761", "_id": "0192678fe2e772bfb1e9b1a52e79612c", "_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": "0192678fe2e772bfb1e9b1a52e79612c", "autoIncrement": 3923.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1984448AF0", "ean": " 638492017265", "displayGroup": "7575f266d2e60c03a0423f5895426cd9", "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:19:12+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "0192678fe2e772bfb1e9b1a52e79612c", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Silver Bracelet", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Made from sterling silver, this bracelet is both stylish and durable. Its intricate design adds a unique touch to any outfit, making it a must-have for any jewelry lover.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Complete your look with this elegant silver bracelet.\"", "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": [ "ai1984448af0", "638492017265", "silver", "bracelet", " 638492017265", "silver bracelet" ] }, "fields": { "displayGroup": [ "7575f266d2e60c03a0423f5895426cd9" ] }, "sort": [ "silver bracelet", "0192678fe2e772bfb1e9b1a52e79612c" ] }, { "_index": "sw_product_1729666761", "_id": "01926793887270bca62b8d44de81f23a", "_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": "01926793887270bca62b8d44de81f23a", "autoIncrement": 3936.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI6F28CC8214", "ean": "4392875261986", "displayGroup": "ace1f2cf1ead9748ed52deb9eb1692fa", "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:23:09+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4870907168b466afda1cc04e77", "019267588033766782f520110b4f2edb", "01926759b0337ef0a5ec508d6f0387b7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4870907168b466afda1cc04e77", "_count": 1 }, { "id": "019267588033766782f520110b4f2edb", "_count": 1 }, { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01926793887270bca62b8d44de81f23a", "childCount": 0, "categories": [ { "id": "01926759b0337ef0a5ec508d6f0387b7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "01926759b0337ef0a5ec508d6f0387b7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Silver Cuff Bracelet", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and modern silver cuff bracelet, perfect for layering with other bracelets.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Minimalist silver cuff bracelet, a versatile piece for any outfit.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 75.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.0, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai6f28cc8214", "4392875261986", "silver", "cuff", "bracelet", "silver cuff bracelet" ] }, "fields": { "displayGroup": [ "ace1f2cf1ead9748ed52deb9eb1692fa" ] }, "sort": [ "silver cuff bracelet", "01926793887270bca62b8d44de81f23a" ] } ] }, "aggregations": { "total-count": { "value": 11 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	2.59 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":"01926759b0337ef0a5ec508d6f0387b7"}}}},{"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": "01926759b0337ef0a5ec508d6f0387b7" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 11, "rating": { "value": 0.0 } }, "price": { "count": 11, "min": 25.0, "max": 650.0, "avg": 196.27181818181816, "sum": 2158.99 }, "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":"01926759b0337ef0a5ec508d6f0387b7"}}}},{"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: 11
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": "01926759b0337ef0a5ec508d6f0387b7"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 3,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "total": {
            "value": 11,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1729666761",
                "_id": "01926792f2e97361a6f7e60465b4a2a7",
                "_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": "01926792f2e97361a6f7e60465b4a2a7",
                    "autoIncrement": 3934.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI9D856B6E6D",
                    "ean": "8632910487562",
                    "displayGroup": "cc87a9898a311b39ca09988a3131092e",
                    "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:22:38+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926792f2e97361a6f7e60465b4a2a7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamond Pendant Necklace",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stunning diamond pendant necklace, featuring a brilliant round cut diamond set in 14k white gold.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dazzling diamond pendant necklace, perfect for a special occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 450.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 450.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai9d856b6e6d",
                        "8632910487562",
                        "diamond",
                        "pendant",
                        "necklace",
                        "diamond pendant necklace"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "cc87a9898a311b39ca09988a3131092e"
                    ]
                },
                "sort": [
                    "diamond pendant necklace",
                    "01926792f2e97361a6f7e60465b4a2a7"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192678f9151737d8c7b7040ad2de232",
                "_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": "0192678f9151737d8c7b7040ad2de232",
                    "autoIncrement": 3921.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI85D27BCB56",
                    "ean": " 726394859210",
                    "displayGroup": "50251d368bfdb4dc96d248d866db31b2",
                    "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:18:55+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192678f9151737d8c7b7040ad2de232",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamond Stud Earrings",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "These stunning diamond stud earrings are a timeless addition to any jewelry collection. The sparkling diamonds are set in 14K white gold, giving them a modern and luxurious look.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Elevate your style with these dazzling diamond stud earrings.\"",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 350.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 350.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai85d27bcb56",
                        "726394859210",
                        "diamond",
                        "stud",
                        "earrings",
                        " 726394859210",
                        "diamond stud earrings"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "50251d368bfdb4dc96d248d866db31b2"
                    ]
                },
                "sort": [
                    "diamond stud earrings",
                    "0192678f9151737d8c7b7040ad2de232"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679347f9737ea357de9bcc879667",
                "_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": "0192679347f9737ea357de9bcc879667",
                    "autoIncrement": 3935.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI3E1C1F72F7",
                    "ean": "6253719840243",
                    "displayGroup": "3cde1ff13d2afdfafdfed0a045158f3f",
                    "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:22:54+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679347f9737ea357de9bcc879667",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Emerald Stud Earrings",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beautiful emerald stud earrings, perfect for adding a pop of color to any outfit.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gorgeous emerald stud earrings, a must-have for any jewelry collection.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 120.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 120.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai3e1c1f72f7",
                        "6253719840243",
                        "emerald",
                        "stud",
                        "earrings",
                        "emerald stud earrings"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "3cde1ff13d2afdfafdfed0a045158f3f"
                    ]
                },
                "sort": [
                    "emerald stud earrings",
                    "0192679347f9737ea357de9bcc879667"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926792b33f73829909357a0d2ee6f3",
                "_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": "01926792b33f73829909357a0d2ee6f3",
                    "autoIncrement": 3933.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI790283D410",
                    "ean": "7845123409876",
                    "displayGroup": "8ebc577b0abff556e258b7676328a317",
                    "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:22:16+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926792b33f73829909357a0d2ee6f3",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gold Hoop Earrings",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Simple and elegant gold hoop earrings, perfect for everyday wear.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic gold hoop earrings for any occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 39.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai790283d410",
                        "7845123409876",
                        "gold",
                        "hoop",
                        "earrings",
                        "gold hoop earrings"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "8ebc577b0abff556e258b7676328a317"
                    ]
                },
                "sort": [
                    "gold hoop earrings",
                    "01926792b33f73829909357a0d2ee6f3"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192678f4e6871debc048233d325480b",
                "_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": "0192678f4e6871debc048233d325480b",
                    "autoIncrement": 3920.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1CBE794467",
                    "ean": " 483726543218",
                    "displayGroup": "5d14922f79080e656a9b148539eb4fbb",
                    "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:18:34+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192678f4e6871debc048233d325480b",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gold Necklace",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "This elegant gold necklace is perfect for everyday wear. Its simple design makes it suitable for any occasion, while the high-quality materials ensure durability and shine.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Add a touch of luxury to your outfit with this beautiful gold necklace.\"",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 25.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai1cbe794467",
                        "483726543218",
                        "gold",
                        "necklace",
                        " 483726543218",
                        "gold necklace"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "5d14922f79080e656a9b148539eb4fbb"
                    ]
                },
                "sort": [
                    "gold necklace",
                    "0192678f4e6871debc048233d325480b"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926793c04372c49f77b1418268ff88",
                "_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": "01926793c04372c49f77b1418268ff88",
                    "autoIncrement": 3937.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1D7E97FEEF",
                    "ean": "7826391047523",
                    "displayGroup": "da394713451367f92e40ec26f6abb75f",
                    "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:23:26+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926793c04372c49f77b1418268ff88",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pearl Drop Earrings",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elegant pearl drop earrings, featuring lustrous freshwater pearls and sparkling diamonds.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Classic pearl drop earrings, perfect for a formal event or date night.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 250.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 250.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai1d7e97feef",
                        "7826391047523",
                        "pearl",
                        "drop",
                        "earrings",
                        "pearl drop earrings"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "da394713451367f92e40ec26f6abb75f"
                    ]
                },
                "sort": [
                    "pearl drop earrings",
                    "01926793c04372c49f77b1418268ff88"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679f2684729299bb0211789027e4",
                "_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": "0192679f2684729299bb0211789027e4",
                    "autoIncrement": 3962.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI632A2C9409",
                    "ean": "2749182736456",
                    "displayGroup": "0fec62f346c7a6bad2888d911e230b2d",
                    "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:35:54+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679f2684729299bb0211789027e4",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pleated Midi Skirt",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Add a touch of elegance to your wardrobe with our Pleated Midi Skirt. The pleats create a flattering A-line shape, while the midi length is perfect for any occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Elevate your outfit with our Pleated Midi Skirt - the perfect combination of style and sophistication. ",
                        "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": [
                        "ai632a2c9409",
                        "2749182736456",
                        "pleated",
                        "midi",
                        "skirt",
                        "pleated midi skirt"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "0fec62f346c7a6bad2888d911e230b2d"
                    ]
                },
                "sort": [
                    "pleated midi skirt",
                    "0192679f2684729299bb0211789027e4"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679404ac710ea6351e3f6dcef1e7",
                "_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": "0192679404ac710ea6351e3f6dcef1e7",
                    "autoIncrement": 3938.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AIC860ADE8C4",
                    "ean": "5629381094752",
                    "displayGroup": "a3d4559b8f1e7b762df049be69c041ab",
                    "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:23:43+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679404ac710ea6351e3f6dcef1e7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rose Gold Stackable Rings",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Set of three dainty rose gold rings, perfect for mixing and matching.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trendy rose gold stackable rings, a must-have for any fashion-forward jewelry lover.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 90.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 90.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aic860ade8c4",
                        "5629381094752",
                        "rose",
                        "gold",
                        "stackable",
                        "rings",
                        "rose gold stackable rings"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "a3d4559b8f1e7b762df049be69c041ab"
                    ]
                },
                "sort": [
                    "rose gold stackable rings",
                    "0192679404ac710ea6351e3f6dcef1e7"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192679445a87295bbb6d0430c35a939",
                "_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": "0192679445a87295bbb6d0430c35a939",
                    "autoIncrement": 3939.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI7AC1199AD5",
                    "ean": "3648120956732",
                    "displayGroup": "9f38a9e75c5cbe179e8098a7a695cd4e",
                    "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:24:05+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192679445a87295bbb6d0430c35a939",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sapphire Tennis Bracelet",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Timeless sapphire tennis bracelet, featuring a row of vibrant sapphires set in 18k white gold.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Luxurious sapphire tennis bracelet, a statement piece for any formal occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 650.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 650.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai7ac1199ad5",
                        "3648120956732",
                        "sapphire",
                        "tennis",
                        "bracelet",
                        "sapphire tennis bracelet"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "9f38a9e75c5cbe179e8098a7a695cd4e"
                    ]
                },
                "sort": [
                    "sapphire tennis bracelet",
                    "0192679445a87295bbb6d0430c35a939"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "0192678fe2e772bfb1e9b1a52e79612c",
                "_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": "0192678fe2e772bfb1e9b1a52e79612c",
                    "autoIncrement": 3923.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1984448AF0",
                    "ean": " 638492017265",
                    "displayGroup": "7575f266d2e60c03a0423f5895426cd9",
                    "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:19:12+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "0192678fe2e772bfb1e9b1a52e79612c",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Silver Bracelet",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Made from sterling silver, this bracelet is both stylish and durable. Its intricate design adds a unique touch to any outfit, making it a must-have for any jewelry lover.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": " \"Complete your look with this elegant silver bracelet.\"",
                        "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": [
                        "ai1984448af0",
                        "638492017265",
                        "silver",
                        "bracelet",
                        " 638492017265",
                        "silver bracelet"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "7575f266d2e60c03a0423f5895426cd9"
                    ]
                },
                "sort": [
                    "silver bracelet",
                    "0192678fe2e772bfb1e9b1a52e79612c"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01926793887270bca62b8d44de81f23a",
                "_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": "01926793887270bca62b8d44de81f23a",
                    "autoIncrement": 3936.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI6F28CC8214",
                    "ean": "4392875261986",
                    "displayGroup": "ace1f2cf1ead9748ed52deb9eb1692fa",
                    "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:23:09+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4870907168b466afda1cc04e77",
                        "019267588033766782f520110b4f2edb",
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4870907168b466afda1cc04e77",
                            "_count": 1
                        },
                        {
                            "id": "019267588033766782f520110b4f2edb",
                            "_count": 1
                        },
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01926793887270bca62b8d44de81f23a",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01926759b0337ef0a5ec508d6f0387b7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmuck"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "01926759b0337ef0a5ec508d6f0387b7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Silver Cuff Bracelet",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sleek and modern silver cuff bracelet, perfect for layering with other bracelets.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Minimalist silver cuff bracelet, a versatile piece for any outfit.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 75.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.0,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai6f28cc8214",
                        "4392875261986",
                        "silver",
                        "cuff",
                        "bracelet",
                        "silver cuff bracelet"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "ace1f2cf1ead9748ed52deb9eb1692fa"
                    ]
                },
                "sort": [
                    "silver cuff bracelet",
                    "01926793887270bca62b8d44de81f23a"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 11
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

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


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 11,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 11,
            "min": 25.0,
            "max": 650.0,
            "avg": 196.27181818181816,
            "sum": 2158.99
        },
        "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/01926759b0337ef0a5ec508d6f0387b7

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices