Symfony Profiler

Query Metrics

8.00 ms Query Time

1 Node(s)

6 Indices

Queries

#▲ Execution Time Info

6.21 ms

#▲	Execution Time	Info
1	6.21 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":"018dad48fe3e767d98346ac2147221f7"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["6231a902253c4604afa84d8068f5d412","2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: 13 View formatted request View formatted response View query backtrace POST http://localhost:9500/sw_product/_search?track_total_hits=1&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 30 } } }, { "term": { "visibilities.salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } } ] } } } }, { "term": { "active": true } } ] } }, { "nested": { "path": "categoriesRo", "query": { "term": { "categoriesRo.id": "018dad48fe3e767d98346ac2147221f7" } } } }, { "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": 13, "relation": "eq" }, "max_score": null, "hits": [ { "_index": "sw_product_1729666761", "_id": "01928a46ef32711dad43ee6462742b5f", "_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": "01928a46ef32711dad43ee6462742b5f", "autoIncrement": 4059.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI3AA9FEAE66", "ean": "4321098760006", "displayGroup": "b64e27729e52307c9e043690b1c654d8", "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-14T09:06:13+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a46ef32711dad43ee6462742b5f", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Assorted Chocolates", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A delightful mix of milk, dark, and white chocolates filled with various flavors and textures. Perfect for sharing or indulging on your own.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience a symphony of flavors with our Assorted Chocolates.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai3aa9feae66", "4321098760006", "assorted", "chocolates", "assorted chocolates" ] }, "fields": { "displayGroup": [ "b64e27729e52307c9e043690b1c654d8" ] }, "sort": [ "assorted chocolates", "01928a46ef32711dad43ee6462742b5f" ] }, { "_index": "sw_product_1729666761", "_id": "01928a467a6f727683ab0ebe5eaa479e", "_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": "01928a467a6f727683ab0ebe5eaa479e", "autoIncrement": 4057.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI42717CB302", "ean": "6543210980004", "displayGroup": "49809a3d7dacd58438974a83f4630364", "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-14T09:05:43+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a467a6f727683ab0ebe5eaa479e", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Caramel Popcorn", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Buttery and crunchy popcorn coated in a sweet and sticky caramel glaze. The perfect movie night snack.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Satisfy your cravings with our irresistible Caramel Popcorn.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai42717cb302", "6543210980004", "caramel", "popcorn", "caramel popcorn" ] }, "fields": { "displayGroup": [ "49809a3d7dacd58438974a83f4630364" ] }, "sort": [ "caramel popcorn", "01928a467a6f727683ab0ebe5eaa479e" ] }, { "_index": "sw_product_1729666761", "_id": "01928a47a18370bfa6f85cb25dd36135", "_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": "01928a47a18370bfa6f85cb25dd36135", "autoIncrement": 4062.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI68A05047A1", "ean": "1098765430009", "displayGroup": "e1e2ffac1913488c5e38f48f1c02fab0", "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-14T09:06:56+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a47a18370bfa6f85cb25dd36135", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chocolate Covered Pretzels", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Salty pretzels coated in a layer of rich and smooth milk chocolate. The ultimate sweet and savory snack.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Satisfy your cravings with our irresistible Chocolate Covered Pretzels.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.49, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.49, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai68a05047a1", "1098765430009", "chocolate", "covered", "pretzels", "chocolate covered pretzels" ] }, "fields": { "displayGroup": [ "e1e2ffac1913488c5e38f48f1c02fab0" ] }, "sort": [ "chocolate covered pretzels", "01928a47a18370bfa6f85cb25dd36135" ] }, { "_index": "sw_product_1729666761", "_id": "01928a47659172d3b908da76684b2109", "_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": "01928a47659172d3b908da76684b2109", "autoIncrement": 4061.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI8E57B5EE99", "ean": "2109876540008", "displayGroup": "172fab488d7acc1d65693cffd5f7c777", "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-14T09:06:42+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a47659172d3b908da76684b2109", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton Candy", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fluffy and light cotton candy in a variety of fun colors and flavors. A nostalgic treat that brings back childhood memories.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Let the sweet and airy delight of our Cotton Candy melt in your mouth.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai8e57b5ee99", "2109876540008", "cotton", "candy", "cotton candy" ] }, "fields": { "displayGroup": [ "172fab488d7acc1d65693cffd5f7c777" ] }, "sort": [ "cotton candy", "01928a47659172d3b908da76684b2109" ] }, { "_index": "sw_product_1729666761", "_id": "01928a4641e873d48d4928c2305e1bfb", "_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": "01928a4641e873d48d4928c2305e1bfb", "autoIncrement": 4056.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI651E764863", "ean": "7654321090003", "displayGroup": "fea0b53ace76052e6963745488fce7a2", "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-14T09:05:27+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a4641e873d48d4928c2305e1bfb", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dark Chocolate Truffles", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Decadent dark chocolate truffles filled with a creamy ganache center. A luxurious indulgence for chocolate lovers.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience the rich and intense flavor of our Dark Chocolate Truffles.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai651e764863", "7654321090003", "dark", "chocolate", "truffles", "dark chocolate truffles" ] }, "fields": { "displayGroup": [ "fea0b53ace76052e6963745488fce7a2" ] }, "sort": [ "dark chocolate truffles", "01928a4641e873d48d4928c2305e1bfb" ] }, { "_index": "sw_product_1729666761", "_id": "01928a46bb3b715ea4f1b6b6ddcf7808", "_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": "01928a46bb3b715ea4f1b6b6ddcf7808", "autoIncrement": 4058.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AICD1CD3385F", "ean": "5432109870005", "displayGroup": "2a607c33abbcca33e258b79ea8c80b4a", "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-14T09:05:57+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a46bb3b715ea4f1b6b6ddcf7808", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fruit Gummies", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Juicy and flavorful fruit-shaped gummies bursting with real fruit juice. A fun and fruity treat for any occasion.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Taste the rainbow with our colorful and delicious Fruit Gummies.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.49, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.49, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "aicd1cd3385f", "5432109870005", "fruit", "gummies", "fruit gummies" ] }, "fields": { "displayGroup": [ "2a607c33abbcca33e258b79ea8c80b4a" ] }, "sort": [ "fruit gummies", "01928a46bb3b715ea4f1b6b6ddcf7808" ] }, { "_index": "sw_product_1729666761", "_id": "01928a4609a17123b9ed5aececd7bbf7", "_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": "01928a4609a17123b9ed5aececd7bbf7", "autoIncrement": 4055.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI1AEE7C0251", "ean": "8765432100002", "displayGroup": "cfbb2f06e99adcc9d746b656b6b06863", "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-14T09:05:12+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a4609a17123b9ed5aececd7bbf7", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gummy Bears", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Soft and chewy gummy bears in a variety of fruity flavors. A classic treat for all ages.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Get your daily dose of fruity goodness with our Gummy Bears.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai1aee7c0251", "8765432100002", "gummy", "bears", "gummy bears" ] }, "fields": { "displayGroup": [ "cfbb2f06e99adcc9d746b656b6b06863" ] }, "sort": [ "gummy bears", "01928a4609a17123b9ed5aececd7bbf7" ] }, { "_index": "sw_product_1729666761", "_id": "01928a47d7cc71f6a9fd051bb56682e3", "_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": "01928a47d7cc71f6a9fd051bb56682e3", "autoIncrement": 4063.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI34C173834A", "ean": "0987654320010", "displayGroup": "771459190be0921895bceba1725c1172", "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-14T09:07:10+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a47d7cc71f6a9fd051bb56682e3", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jelly Beans", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Colorful and flavorful jelly beans in a variety of fruity and sour flavors. A classic treat loved by all.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Taste the rainbow of flavors with our Jelly Beans.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai34c173834a", "0987654320010", "jelly", "beans", "jelly beans" ] }, "fields": { "displayGroup": [ "771459190be0921895bceba1725c1172" ] }, "sort": [ "jelly beans", "01928a47d7cc71f6a9fd051bb56682e3" ] }, { "_index": "sw_product_1729666761", "_id": "018dad6436d370e587c1a761414d1d1c", "_score": null, "_source": { "id": "018dad6436d370e587c1a761414d1d1c", "autoIncrement": 3811.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": true, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "0190bad23cbd78a5868e7b1421e7fbf5" }, { "_count": 1, "visibility": 30, "salesChannelId": "98432def39fc4624b33213a56b8c944d" }, { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": -12, "productNumber": "SW10004.1", "ean": null, "displayGroup": "915daaded23dc63c28f421e3a1386222", "sales": 10, "stock": -11, "weight": 1.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": null, "manufacturerNumber": null, "releaseDate": null, "createdAt": "2024-02-15T15:30:42+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48e90577b38c213ee9948e8a54", "018dad48fe3e767d98346ac2147221f7", "019735db603d7b25967a430ba7a80685", "0198ea9e94ec7cfb9a8b517450acac50" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48e90577b38c213ee9948e8a54", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 }, { "id": "019735db603d7b25967a430ba7a80685", "_count": 1 }, { "id": "0198ea9e94ec7cfb9a8b517450acac50", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [ { "id": "0198f004d53e7d8ea912649ef84450d4", "name": "spedition", "_count": 1 } ], "parentId": "018dad4c4ffa74c693127aeb0f5f2579", "coverId": "018dad6a33cb71ebb56766b71c8a804d", "childCount": 0, "categories": [ { "id": "019735db603d7b25967a430ba7a80685", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test" } }, { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home", "6231a902253c4604afa84d8068f5d412": "Home" } }, { "id": "0198ea9e94ec7cfb9a8b517450acac50", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Angebote" } }, { "id": "018dad48e90577b38c213ee9948e8a54", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Getr\u00e4nke" } }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [ { "id": "018dad6183517144996b728225d43476", "_count": 1, "groupId": "018dad5ea369751282a090d13b2a2daa", "group": { "id": "018dad5ea369751282a090d13b2a2daa", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kr\u00e4uter" } } ], "categoryIds": [ "018dad48e90577b38c213ee9948e8a54", "018dad48fe3e767d98346ac2147221f7", "019735db603d7b25967a430ba7a80685", "0198ea9e94ec7cfb9a8b517450acac50", "027b6bc0fb97499da37d015d89e58c77" ], "optionIds": [ "018dad6183517144996b728225d43476" ], "propertyIds": [], "tagIds": [ "0198f004d53e7d8ea912649ef84450d4" ], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": [] }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Limonade", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Limonade, eine perfekte Mischung aus himmlischen Kr\u00e4utern und sprudelndem Quellwasser, belebt Ihre Sinne und stillt Ihren Durst. Frisch gepfl\u00fcckte Kr\u00e4uter von h\u00f6chster Qualit\u00e4t sorgen f\u00fcr einen intensiven, ausgewogenen Geschmack. Perfekt f\u00fcr jeden Anlass - genie\u00dfen Sie die prickelnde Frische unserer Kr\u00e4uter-Limonade, egal wo Sie sind.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.2, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.0084033613445 }, "fields": { "displayGroup": [ "915daaded23dc63c28f421e3a1386222" ] }, "sort": [ "limonade", "018dad6436d370e587c1a761414d1d1c" ] }, { "_index": "sw_product_1729666761", "_id": "01928a45c52f72359754c6211a3bba67", "_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": "01928a45c52f72359754c6211a3bba67", "autoIncrement": 4054.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI2899DE29FF", "ean": "9876543210001", "displayGroup": "ae174dffacab2aafe696aacce3fd5584", "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-14T09:04:58+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a45c52f72359754c6211a3bba67", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Milk Chocolate Bar", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Creamy milk chocolate bar with a rich and smooth texture. Perfect for satisfying your sweet tooth.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Indulge in the velvety goodness of our Milk Chocolate Bar.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.99, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai2899de29ff", "9876543210001", "milk", "chocolate", "bar", "milk chocolate bar" ] }, "fields": { "displayGroup": [ "ae174dffacab2aafe696aacce3fd5584" ] }, "sort": [ "milk chocolate bar", "01928a45c52f72359754c6211a3bba67" ] }, { "_index": "sw_product_1729666761", "_id": "01928a472d0d738d87eff09bea2abc47", "_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": "01928a472d0d738d87eff09bea2abc47", "autoIncrement": 4060.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": false, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d" } ], "availableStock": 99, "productNumber": "AI8AC6759D99", "ean": "3210987650007", "displayGroup": "aa5a6b1480362552d5d0a832d1157a84", "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-14T09:06:27+00:00", "categoryTree": [ "027b6bc0fb97499da37d015d89e58c77", "018dad4803a775b2b962667bd9d68949", "018dad48fe3e767d98346ac2147221f7" ], "categoriesRo": [ { "id": "027b6bc0fb97499da37d015d89e58c77", "_count": 1 }, { "id": "018dad4803a775b2b962667bd9d68949", "_count": 1 }, { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1 } ], "taxId": "794f894c0e3f44c18fac8415f6adcc1d", "tags": [], "parentId": null, "coverId": "01928a472d0d738d87eff09bea2abc47", "childCount": 0, "categories": [ { "id": "018dad48fe3e767d98346ac2147221f7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren" } } ], "manufacturer": { "id": null, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "_count": 1 }, "properties": [], "options": [], "categoryIds": [ "018dad48fe3e767d98346ac2147221f7" ], "optionIds": [], "propertyIds": [], "tagIds": [], "states": [ "is-physical" ], "customFields": [], "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Peanut Butter Cups", "6231a902253c4604afa84d8068f5d412": null }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Creamy peanut butter encased in a smooth milk chocolate shell. A classic combination that never fails to please.", "6231a902253c4604afa84d8068f5d412": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Indulge in the perfect balance of sweet and salty with our Peanut Butter Cups.", "6231a902253c4604afa84d8068f5d412": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null, "6231a902253c4604afa84d8068f5d412": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.49, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.49, "warehouseGroups": [ { "id": null, "_count": 0 } ], "completion": [ "ai8ac6759d99", "3210987650007", "peanut", "butter", "cups", "peanut butter cups" ] }, "fields": { "displayGroup": [ "aa5a6b1480362552d5d0a832d1157a84" ] }, "sort": [ "peanut butter cups", "01928a472d0d738d87eff09bea2abc47" ] } ] }, "aggregations": { "total-count": { "value": 11 } } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	2.23 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":"018dad48fe3e767d98346ac2147221f7"}}}},{"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": "018dad48fe3e767d98346ac2147221f7" } } } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } } ] } } ] } }, "aggregations": { "manufacturer": { "terms": { "field": "manufacturerId", "size": 10000 } }, "price": { "stats": { "script": { "id": "cheapest_price", "params": { "accessors": [ { "key": "cheapest_price_rule1dcbfed84b174af0ad0f4943a91a4d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule25659a685b8f4434bac1af4df9e4d80c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule34bbe303b95e4a32a542d17e46a976ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule8ed05a6358434062b320e005fad58854_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule9cfb08df1c1945549ed22eacfcde0475_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } } } }, "rating-exists": { "filter": { "range": { "ratingAverage": { "gte": 0.0 } } }, "aggregations": { "rating": { "max": { "field": "ratingAverage" } } } }, "shipping-free-filter": { "filter": { "term": { "shippingFree": true } }, "aggregations": { "shipping-free": { "max": { "field": "shippingFree" } } } }, "properties": { "nested": { "path": "properties" }, "aggregations": { "properties": { "terms": { "field": "properties.id", "size": 10000 } } } }, "options": { "nested": { "path": "options" }, "aggregations": { "options": { "terms": { "field": "options.id", "size": 10000 } } } } }, "size": 0, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [] }, "aggregations": { "shipping-free-filter": { "doc_count": 0, "shipping-free": { "value": null } }, "rating-exists": { "doc_count": 13, "rating": { "value": 0.0 } }, "price": { "count": 13, "min": 1.2, "max": 7.99, "avg": 3.6923076923076925, "sum": 48.0 }, "options": { "doc_count": 3, "options": { "doc_count_error_upper_bound": 0, "sum_other_doc_count": 0, "buckets": [ { "key": "018dad6030bf7c76be09f2d8782aa4de", "doc_count": 1 }, { "key": "018dad61615a7874ba5981ead7703e19", "doc_count": 1 }, { "key": "018dad6183517144996b728225d43476", "doc_count": 1 } ] } }, "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":"018dad48fe3e767d98346ac2147221f7"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n    def field_name = params['field'] + '.' + languages[i] + suffix;\n\n    if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n        def fieldValue = doc[field_name].value;\n\n        return fieldValue.toString();\n    }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["6231a902253c4604afa84d8068f5d412","2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://localhost:9500/sw_product/_search?track_total_hits=1&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 30
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "nested": {
                                    "path": "categoriesRo",
                                    "query": {
                                        "term": {
                                            "categoriesRo.id": "018dad48fe3e767d98346ac2147221f7"
                                        }
                                    }
                                }
                            },
                            {
                                "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": 13,
            "relation": "eq"
        },
        "max_score": null,
        "hits": [
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a46ef32711dad43ee6462742b5f",
                "_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": "01928a46ef32711dad43ee6462742b5f",
                    "autoIncrement": 4059.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI3AA9FEAE66",
                    "ean": "4321098760006",
                    "displayGroup": "b64e27729e52307c9e043690b1c654d8",
                    "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-14T09:06:13+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a46ef32711dad43ee6462742b5f",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Assorted Chocolates",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A delightful mix of milk, dark, and white chocolates filled with various flavors and textures. Perfect for sharing or indulging on your own.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience a symphony of flavors with our Assorted Chocolates.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 6.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai3aa9feae66",
                        "4321098760006",
                        "assorted",
                        "chocolates",
                        "assorted chocolates"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "b64e27729e52307c9e043690b1c654d8"
                    ]
                },
                "sort": [
                    "assorted chocolates",
                    "01928a46ef32711dad43ee6462742b5f"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a467a6f727683ab0ebe5eaa479e",
                "_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": "01928a467a6f727683ab0ebe5eaa479e",
                    "autoIncrement": 4057.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI42717CB302",
                    "ean": "6543210980004",
                    "displayGroup": "49809a3d7dacd58438974a83f4630364",
                    "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-14T09:05:43+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a467a6f727683ab0ebe5eaa479e",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Caramel Popcorn",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Buttery and crunchy popcorn coated in a sweet and sticky caramel glaze. The perfect movie night snack.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Satisfy your cravings with our irresistible Caramel Popcorn.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 3.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 3.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai42717cb302",
                        "6543210980004",
                        "caramel",
                        "popcorn",
                        "caramel popcorn"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "49809a3d7dacd58438974a83f4630364"
                    ]
                },
                "sort": [
                    "caramel popcorn",
                    "01928a467a6f727683ab0ebe5eaa479e"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a47a18370bfa6f85cb25dd36135",
                "_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": "01928a47a18370bfa6f85cb25dd36135",
                    "autoIncrement": 4062.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI68A05047A1",
                    "ean": "1098765430009",
                    "displayGroup": "e1e2ffac1913488c5e38f48f1c02fab0",
                    "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-14T09:06:56+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a47a18370bfa6f85cb25dd36135",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chocolate Covered Pretzels",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Salty pretzels coated in a layer of rich and smooth milk chocolate. The ultimate sweet and savory snack.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Satisfy your cravings with our irresistible Chocolate Covered Pretzels.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.49,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.49,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai68a05047a1",
                        "1098765430009",
                        "chocolate",
                        "covered",
                        "pretzels",
                        "chocolate covered pretzels"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "e1e2ffac1913488c5e38f48f1c02fab0"
                    ]
                },
                "sort": [
                    "chocolate covered pretzels",
                    "01928a47a18370bfa6f85cb25dd36135"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a47659172d3b908da76684b2109",
                "_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": "01928a47659172d3b908da76684b2109",
                    "autoIncrement": 4061.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI8E57B5EE99",
                    "ean": "2109876540008",
                    "displayGroup": "172fab488d7acc1d65693cffd5f7c777",
                    "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-14T09:06:42+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a47659172d3b908da76684b2109",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cotton Candy",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fluffy and light cotton candy in a variety of fun colors and flavors. A nostalgic treat that brings back childhood memories.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Let the sweet and airy delight of our Cotton Candy melt in your mouth.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai8e57b5ee99",
                        "2109876540008",
                        "cotton",
                        "candy",
                        "cotton candy"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "172fab488d7acc1d65693cffd5f7c777"
                    ]
                },
                "sort": [
                    "cotton candy",
                    "01928a47659172d3b908da76684b2109"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a4641e873d48d4928c2305e1bfb",
                "_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": "01928a4641e873d48d4928c2305e1bfb",
                    "autoIncrement": 4056.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI651E764863",
                    "ean": "7654321090003",
                    "displayGroup": "fea0b53ace76052e6963745488fce7a2",
                    "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-14T09:05:27+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a4641e873d48d4928c2305e1bfb",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dark Chocolate Truffles",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Decadent dark chocolate truffles filled with a creamy ganache center. A luxurious indulgence for chocolate lovers.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Experience the rich and intense flavor of our Dark Chocolate Truffles.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 7.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai651e764863",
                        "7654321090003",
                        "dark",
                        "chocolate",
                        "truffles",
                        "dark chocolate truffles"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "fea0b53ace76052e6963745488fce7a2"
                    ]
                },
                "sort": [
                    "dark chocolate truffles",
                    "01928a4641e873d48d4928c2305e1bfb"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a46bb3b715ea4f1b6b6ddcf7808",
                "_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": "01928a46bb3b715ea4f1b6b6ddcf7808",
                    "autoIncrement": 4058.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AICD1CD3385F",
                    "ean": "5432109870005",
                    "displayGroup": "2a607c33abbcca33e258b79ea8c80b4a",
                    "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-14T09:05:57+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a46bb3b715ea4f1b6b6ddcf7808",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fruit Gummies",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Juicy and flavorful fruit-shaped gummies bursting with real fruit juice. A fun and fruity treat for any occasion.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Taste the rainbow with our colorful and delicious Fruit Gummies.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.49,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.49,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "aicd1cd3385f",
                        "5432109870005",
                        "fruit",
                        "gummies",
                        "fruit gummies"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "2a607c33abbcca33e258b79ea8c80b4a"
                    ]
                },
                "sort": [
                    "fruit gummies",
                    "01928a46bb3b715ea4f1b6b6ddcf7808"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a4609a17123b9ed5aececd7bbf7",
                "_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": "01928a4609a17123b9ed5aececd7bbf7",
                    "autoIncrement": 4055.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI1AEE7C0251",
                    "ean": "8765432100002",
                    "displayGroup": "cfbb2f06e99adcc9d746b656b6b06863",
                    "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-14T09:05:12+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a4609a17123b9ed5aececd7bbf7",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gummy Bears",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Soft and chewy gummy bears in a variety of fruity flavors. A classic treat for all ages.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Get your daily dose of fruity goodness with our Gummy Bears.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai1aee7c0251",
                        "8765432100002",
                        "gummy",
                        "bears",
                        "gummy bears"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "cfbb2f06e99adcc9d746b656b6b06863"
                    ]
                },
                "sort": [
                    "gummy bears",
                    "01928a4609a17123b9ed5aececd7bbf7"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a47d7cc71f6a9fd051bb56682e3",
                "_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": "01928a47d7cc71f6a9fd051bb56682e3",
                    "autoIncrement": 4063.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI34C173834A",
                    "ean": "0987654320010",
                    "displayGroup": "771459190be0921895bceba1725c1172",
                    "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-14T09:07:10+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a47d7cc71f6a9fd051bb56682e3",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Jelly Beans",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Colorful and flavorful jelly beans in a variety of fruity and sour flavors. A classic treat loved by all.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Taste the rainbow of flavors with our Jelly Beans.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai34c173834a",
                        "0987654320010",
                        "jelly",
                        "beans",
                        "jelly beans"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "771459190be0921895bceba1725c1172"
                    ]
                },
                "sort": [
                    "jelly beans",
                    "01928a47d7cc71f6a9fd051bb56682e3"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "018dad6436d370e587c1a761414d1d1c",
                "_score": null,
                "_source": {
                    "id": "018dad6436d370e587c1a761414d1d1c",
                    "autoIncrement": 3811.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": true,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "0190bad23cbd78a5868e7b1421e7fbf5"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "98432def39fc4624b33213a56b8c944d"
                        },
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": -12,
                    "productNumber": "SW10004.1",
                    "ean": null,
                    "displayGroup": "915daaded23dc63c28f421e3a1386222",
                    "sales": 10,
                    "stock": -11,
                    "weight": 1.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": null,
                    "manufacturerNumber": null,
                    "releaseDate": null,
                    "createdAt": "2024-02-15T15:30:42+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48e90577b38c213ee9948e8a54",
                        "018dad48fe3e767d98346ac2147221f7",
                        "019735db603d7b25967a430ba7a80685",
                        "0198ea9e94ec7cfb9a8b517450acac50"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48e90577b38c213ee9948e8a54",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        },
                        {
                            "id": "019735db603d7b25967a430ba7a80685",
                            "_count": 1
                        },
                        {
                            "id": "0198ea9e94ec7cfb9a8b517450acac50",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [
                        {
                            "id": "0198f004d53e7d8ea912649ef84450d4",
                            "name": "spedition",
                            "_count": 1
                        }
                    ],
                    "parentId": "018dad4c4ffa74c693127aeb0f5f2579",
                    "coverId": "018dad6a33cb71ebb56766b71c8a804d",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "019735db603d7b25967a430ba7a80685",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Test"
                            }
                        },
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Home",
                                "6231a902253c4604afa84d8068f5d412": "Home"
                            }
                        },
                        {
                            "id": "0198ea9e94ec7cfb9a8b517450acac50",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Angebote"
                            }
                        },
                        {
                            "id": "018dad48e90577b38c213ee9948e8a54",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Getr\u00e4nke"
                            }
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [
                        {
                            "id": "018dad6183517144996b728225d43476",
                            "_count": 1,
                            "groupId": "018dad5ea369751282a090d13b2a2daa",
                            "group": {
                                "id": "018dad5ea369751282a090d13b2a2daa",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kr\u00e4uter"
                            }
                        }
                    ],
                    "categoryIds": [
                        "018dad48e90577b38c213ee9948e8a54",
                        "018dad48fe3e767d98346ac2147221f7",
                        "019735db603d7b25967a430ba7a80685",
                        "0198ea9e94ec7cfb9a8b517450acac50",
                        "027b6bc0fb97499da37d015d89e58c77"
                    ],
                    "optionIds": [
                        "018dad6183517144996b728225d43476"
                    ],
                    "propertyIds": [],
                    "tagIds": [
                        "0198f004d53e7d8ea912649ef84450d4"
                    ],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": []
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Limonade",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unsere Limonade, eine perfekte Mischung aus himmlischen Kr\u00e4utern und sprudelndem Quellwasser, belebt Ihre Sinne und stillt Ihren Durst. Frisch gepfl\u00fcckte Kr\u00e4uter von h\u00f6chster Qualit\u00e4t sorgen f\u00fcr einen intensiven, ausgewogenen Geschmack. Perfekt f\u00fcr jeden Anlass - genie\u00dfen Sie die prickelnde Frische unserer Kr\u00e4uter-Limonade, egal wo Sie sind.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.2,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.0084033613445
                },
                "fields": {
                    "displayGroup": [
                        "915daaded23dc63c28f421e3a1386222"
                    ]
                },
                "sort": [
                    "limonade",
                    "018dad6436d370e587c1a761414d1d1c"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a45c52f72359754c6211a3bba67",
                "_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": "01928a45c52f72359754c6211a3bba67",
                    "autoIncrement": 4054.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI2899DE29FF",
                    "ean": "9876543210001",
                    "displayGroup": "ae174dffacab2aafe696aacce3fd5584",
                    "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-14T09:04:58+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a45c52f72359754c6211a3bba67",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Milk Chocolate Bar",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Creamy milk chocolate bar with a rich and smooth texture. Perfect for satisfying your sweet tooth.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Indulge in the velvety goodness of our Milk Chocolate Bar.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.99,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai2899de29ff",
                        "9876543210001",
                        "milk",
                        "chocolate",
                        "bar",
                        "milk chocolate bar"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "ae174dffacab2aafe696aacce3fd5584"
                    ]
                },
                "sort": [
                    "milk chocolate bar",
                    "01928a45c52f72359754c6211a3bba67"
                ]
            },
            {
                "_index": "sw_product_1729666761",
                "_id": "01928a472d0d738d87eff09bea2abc47",
                "_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": "01928a472d0d738d87eff09bea2abc47",
                    "autoIncrement": 4060.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": false,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "a775c9963b5b44a6a7b05cdc1664865d"
                        }
                    ],
                    "availableStock": 99,
                    "productNumber": "AI8AC6759D99",
                    "ean": "3210987650007",
                    "displayGroup": "aa5a6b1480362552d5d0a832d1157a84",
                    "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-14T09:06:27+00:00",
                    "categoryTree": [
                        "027b6bc0fb97499da37d015d89e58c77",
                        "018dad4803a775b2b962667bd9d68949",
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "027b6bc0fb97499da37d015d89e58c77",
                            "_count": 1
                        },
                        {
                            "id": "018dad4803a775b2b962667bd9d68949",
                            "_count": 1
                        },
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1
                        }
                    ],
                    "taxId": "794f894c0e3f44c18fac8415f6adcc1d",
                    "tags": [],
                    "parentId": null,
                    "coverId": "01928a472d0d738d87eff09bea2abc47",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "018dad48fe3e767d98346ac2147221f7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00fc\u00dfwaren"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": null,
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                            "6231a902253c4604afa84d8068f5d412": null
                        },
                        "_count": 1
                    },
                    "properties": [],
                    "options": [],
                    "categoryIds": [
                        "018dad48fe3e767d98346ac2147221f7"
                    ],
                    "optionIds": [],
                    "propertyIds": [],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": [],
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Peanut Butter Cups",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Creamy peanut butter encased in a smooth milk chocolate shell. A classic combination that never fails to please.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Indulge in the perfect balance of sweet and salty with our Peanut Butter Cups.",
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
                        "6231a902253c4604afa84d8068f5d412": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.49,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.49,
                    "warehouseGroups": [
                        {
                            "id": null,
                            "_count": 0
                        }
                    ],
                    "completion": [
                        "ai8ac6759d99",
                        "3210987650007",
                        "peanut",
                        "butter",
                        "cups",
                        "peanut butter cups"
                    ]
                },
                "fields": {
                    "displayGroup": [
                        "aa5a6b1480362552d5d0a832d1157a84"
                    ]
                },
                "sort": [
                    "peanut butter cups",
                    "01928a472d0d738d87eff09bea2abc47"
                ]
            }
        ]
    },
    "aggregations": {
        "total-count": {
            "value": 11
        }
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

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


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": []
    },
    "aggregations": {
        "shipping-free-filter": {
            "doc_count": 0,
            "shipping-free": {
                "value": null
            }
        },
        "rating-exists": {
            "doc_count": 13,
            "rating": {
                "value": 0.0
            }
        },
        "price": {
            "count": 13,
            "min": 1.2,
            "max": 7.99,
            "avg": 3.6923076923076925,
            "sum": 48.0
        },
        "options": {
            "doc_count": 3,
            "options": {
                "doc_count_error_upper_bound": 0,
                "sum_other_doc_count": 0,
                "buckets": [
                    {
                        "key": "018dad6030bf7c76be09f2d8782aa4de",
                        "doc_count": 1
                    },
                    {
                        "key": "018dad61615a7874ba5981ead7703e19",
                        "doc_count": 1
                    },
                    {
                        "key": "018dad6183517144996b728225d43476",
                        "doc_count": 1
                    }
                ]
            }
        },
        "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/018dad48fe3e767d98346ac2147221f7

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices