Symfony Profiler

Query Metrics

7.00 ms Query Time

1 Node(s)

28 Indices

Queries

#▲ Execution Time Info

3.96 ms

#▲	Execution Time	Info
1	3.96 ms	Request: {"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["3178","4044","5921","6928-6943-3494","7313"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "should": [ { "terms": { "productNumber": [ "3178", "4044", "5921", "6928-6943-3494", "7313" ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 10 } } }, { "term": { "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad" } } ] } } } }, { "term": { "active": true } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "number", "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } }, "order": "ASC" } } ], "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "shopware6-stage_product_1725967126", "_id": "3a0f19df72fef0495c54ced664735a7d", "_score": null, "_source": { "id": "3a0f19df72fef0495c54ced664735a7d", "autoIncrement": 86554.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 48, "productNumber": "7313", "ean": null, "displayGroup": "0d168a61882c448a23edb47f50fcfab8", "sales": 0, "stock": 48, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "e5da136850fac64ea7f9647e61745237", "manufacturerNumber": "060-66105", "releaseDate": null, "createdAt": "2023-10-16T11:37:36+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "819f46e52c25763a55cc642422644317", "cb70ab375662576bd1ac5aaf16b3fca4" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "819f46e52c25763a55cc642422644317", "_count": 1 }, { "id": "cb70ab375662576bd1ac5aaf16b3fca4", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "f9e5c68cf6180bab35e7ae94265c6be8", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "819f46e52c25763a55cc642422644317", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge, Pflege & N\u00fctzliches" } }, { "id": "cb70ab375662576bd1ac5aaf16b3fca4", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N\u00fctzliches Fahrradzubeh\u00f6r" } } ], "manufacturer": { "id": "e5da136850fac64ea7f9647e61745237", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "819f46e52c25763a55cc642422644317", "cb70ab375662576bd1ac5aaf16b3fca4" ], "optionIds": [], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "Montage", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": "", "product_vk2_amazon": 4.99, "product_vk3_ebay": 4.99 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roto Schaltwerkschutzb\u00fcgel" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.03 }, "fields": { "displayGroup": [ "0d168a61882c448a23edb47f50fcfab8" ] }, "sort": [ 5.99 ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "b59442085644532ef03417a3e5a76437", "_score": null, "_source": { "id": "b59442085644532ef03417a3e5a76437", "autoIncrement": 86703.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 15, "productNumber": "5921", "ean": "4250149440823", "displayGroup": "55df308465d9895dce7e4927c29b9bc7", "sales": 0, "stock": 15, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "cbb3ea7ea3c3c4225c13d285f94e81d4", "manufacturerNumber": "080-40355", "releaseDate": null, "createdAt": "2023-10-16T11:38:24+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "6855456e2fe46a9d49d3d3af4f57443d", "01386bd6d8e091c2ab4c7c7de644d37b" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "6855456e2fe46a9d49d3d3af4f57443d", "_count": 1 }, { "id": "01386bd6d8e091c2ab4c7c7de644d37b", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "2e664fee7e9d1b41cc434fac1a90d5e3", "childCount": 0, "categories": [ { "id": "01386bd6d8e091c2ab4c7c7de644d37b", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Handyhalterung" } }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "6855456e2fe46a9d49d3d3af4f57443d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile" } } ], "manufacturer": { "id": "cbb3ea7ea3c3c4225c13d285f94e81d4", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NC-17" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "01386bd6d8e091c2ab4c7c7de644d37b", "28dd2c7955ce926456240b2ff0100bde", "6855456e2fe46a9d49d3d3af4f57443d" ], "optionIds": [], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "Montage4", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": "", "product_vk2_amazon": 24.95, "product_vk3_ebay": 24.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NC-17 Smartphone-Halter A-Head" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.97 }, "fields": { "displayGroup": [ "55df308465d9895dce7e4927c29b9bc7" ] }, "sort": [ 24.95 ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "df5354693177e83e8ba089e94b7b6b55", "_score": null, "_source": { "id": "df5354693177e83e8ba089e94b7b6b55", "autoIncrement": 81612.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 2, "productNumber": "4044", "ean": "4002556875954", "displayGroup": "9fcece259f60dba60addb2c44969ddf0", "sales": 0, "stock": 2, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "d978e353f0df4f240453e1f3727c98a7", "manufacturerNumber": "050-28479", "releaseDate": null, "createdAt": "2023-10-16T11:12:10+00:00", "categoryTree": [], "categoriesRo": [], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "1a85051c6633eac99087ae33e76252b0", "coverId": "c5535355de677d1418a1390df9a0c5b7", "childCount": 0, "categories": [], "manufacturer": { "id": "d978e353f0df4f240453e1f3727c98a7", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink" }, "_count": 1 }, "properties": [ { "id": "2f2e3f5b79e0af274270f86a98dc2957", "_count": 1, "groupId": "622dd2d5e4ce31aeb63cce84815577a0", "group": { "id": "622dd2d5e4ce31aeb63cce84815577a0", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "450 ml" } }, { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [ { "id": "2f2e3f5b79e0af274270f86a98dc2957", "_count": 1, "groupId": "622dd2d5e4ce31aeb63cce84815577a0", "group": { "id": "622dd2d5e4ce31aeb63cce84815577a0", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "450 ml" } } ], "categoryIds": [], "optionIds": [ "2f2e3f5b79e0af274270f86a98dc2957" ], "propertyIds": [ "2f2e3f5b79e0af274270f86a98dc2957", "3a616a5305e06ccc883bda3ab63b10b5" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "Montage", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 4044.1, "product_vk2_amazon": 17.89, "product_vk3_ebay": 17.89 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink Trinkflasche inkl. BottleMount" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.69 }, "fields": { "displayGroup": [ "9fcece259f60dba60addb2c44969ddf0" ] }, "sort": [ 32.95 ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "ba95d78a7c942571185308775a97a3a0", "_score": null, "_source": { "id": "ba95d78a7c942571185308775a97a3a0", "autoIncrement": 81593.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 30, "productNumber": "3178", "ean": "4043197271590", "displayGroup": "f8196f746cd4562e2b859889e0af1857", "sales": 0, "stock": 30, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8", "manufacturerNumber": "S4104230815", "releaseDate": null, "createdAt": "2023-10-16T11:12:10+00:00", "categoryTree": [], "categoriesRo": [], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "15eb9474366241a7d01696ea8d02e9ca", "coverId": "a4c99aac94986d8405c9e81a45ad99d9", "childCount": 0, "categories": [], "manufacturer": { "id": "113a80259eea2dabecb4f1d35f5aafb8", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "options": [ { "id": "795995d1c59b90ec89199aacd3cd42e7", "_count": 1, "groupId": "e682e5d097523765cde5e59df6139363", "group": { "id": "e682e5d097523765cde5e59df6139363", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm" } } ], "categoryIds": [], "optionIds": [ "795995d1c59b90ec89199aacd3cd42e7" ], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5", "795995d1c59b90ec89199aacd3cd42e7" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": 3178.1, "product_vk2_amazon": 69.95, "product_vk3_ebay": 69.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex i-vo cc black" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.95, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.59 }, "fields": { "displayGroup": [ "f8196f746cd4562e2b859889e0af1857" ] }, "sort": [ 89.95 ] }, { "_index": "shopware6-stage_product_1725967126", "_id": "abcee2e80df42bbb77d89f5738e74462", "_score": null, "_source": { "id": "abcee2e80df42bbb77d89f5738e74462", "autoIncrement": 86472.0, "ratingAverage": 0.0, "active": true, "available": true, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 1000, "productNumber": "6928-6943-3494", "ean": null, "displayGroup": "bb77e846e82e42f74f8d4d6480a8288c", "sales": 0, "stock": 1000, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff", "manufacturerNumber": "6928-6943-3494", "releaseDate": null, "createdAt": "2023-10-16T11:37:11+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "28dd2c7955ce926456240b2ff0100bde", "9872ed9fc22fc182d371c3e9ed316094", "31fefc0e570cb3860f2a6d4b38c6490d", "fb7b9ffa5462084c5f4e7e85a093e6d7" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1 }, { "id": "9872ed9fc22fc182d371c3e9ed316094", "_count": 1 }, { "id": "31fefc0e570cb3860f2a6d4b38c6490d", "_count": 1 }, { "id": "fb7b9ffa5462084c5f4e7e85a093e6d7", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": null, "coverId": "7ea0f2d06757a9e6f59fcf8d74636f5d", "childCount": 0, "categories": [ { "id": "28dd2c7955ce926456240b2ff0100bde", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile" } }, { "id": "31fefc0e570cb3860f2a6d4b38c6490d", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rahmenschl\u00f6sser" } }, { "id": "9872ed9fc22fc182d371c3e9ed316094", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser" } }, { "id": "fb7b9ffa5462084c5f4e7e85a093e6d7", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschl\u00f6sser" } } ], "manufacturer": { "id": "4bbd9c23e810a10a299357ea4c2b94ff", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus" }, "_count": 1 }, "properties": [ { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } } ], "options": [], "categoryIds": [ "28dd2c7955ce926456240b2ff0100bde", "31fefc0e570cb3860f2a6d4b38c6490d", "9872ed9fc22fc182d371c3e9ed316094", "fb7b9ffa5462084c5f4e7e85a093e6d7" ], "optionIds": [], "propertyIds": [ "3a616a5305e06ccc883bda3ab63b10b5" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 0.0, "product_slider_terrain": 0.0, "product_slider_ausstattung": 0.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "Montage", "product_click_and_collect": 1.0, "product_store_available": 1.0, "product_parent_article": "", "product_vk2_amazon": 54.95, "product_vk3_ebay": 54.95 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Pro Shield +Zusatzkette Pro Shield+AXA Flex Bef." }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 96.89, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 81.42, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0 }, "fields": { "displayGroup": [ "bb77e846e82e42f74f8d4d6480a8288c" ] }, "sort": [ 96.89 ] } ] } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`
2	3.41 ms	Request: {"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["104215"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"} Item count: View formatted request View formatted response View query backtrace POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch Accept: application/json Content-Type: application/json { "query": { "bool": { "filter": [ { "bool": { "must": [ { "bool": { "should": [ { "terms": { "productNumber": [ "104215" ] } } ] } }, { "bool": { "must_not": [ { "bool": { "must_not": [ { "exists": { "field": "displayGroup" } } ] } } ] } }, { "bool": { "must": [ { "nested": { "path": "visibilities", "query": { "bool": { "must": [ { "range": { "visibilities.visibility": { "gte": 10 } } }, { "term": { "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad" } } ] } } } }, { "term": { "active": true } } ] } } ] } } ] } }, "sort": [ { "_script": { "type": "number", "script": { "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) \|\| doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n", "lang": "painless", "params": { "accessors": [ { "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 }, { "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross", "factor": 1 } ], "decimals": 100, "round": true, "multiplier": 100.0 } }, "order": "ASC" } } ], "from": 0, "size": 24, "collapse": { "field": "displayGroup" }, "timeout": "5s" } { "took": 1, "timed_out": false, "_shards": { "total": 3, "successful": 3, "skipped": 0, "failed": 0 }, "hits": { "max_score": null, "hits": [ { "_index": "shopware6-stage_product_1725967126", "_id": "53f7235d27cc40d10f35210555c499d4", "_score": null, "_source": { "id": "53f7235d27cc40d10f35210555c499d4", "autoIncrement": 80455.0, "ratingAverage": 0.0, "active": true, "available": false, "isCloseout": true, "shippingFree": false, "markAsTopseller": false, "visibilities": [ { "_count": 1, "visibility": 30, "salesChannelId": "01895226670e72a4a15f371adce297ad" } ], "availableStock": 0, "productNumber": "104215", "ean": "4063518166527", "displayGroup": "99475cbc64fc5ab44481764a2093c783", "sales": 0, "stock": 0, "weight": 0.0, "width": 0.0, "length": 0.0, "height": 0.0, "manufacturerId": "6462331a69cdc7b76dc81136ca2713dd", "manufacturerNumber": "632-10748", "releaseDate": null, "createdAt": "2023-10-16T11:08:03+00:00", "categoryTree": [ "01894ed2c40070099cf25d59f2d1a99e", "33e75ff09dd601bbe69f351039152189", "e369853df766fa44e1ed0ff613f563bd", "19ca14e7ea6328a42e0eb13d585e4c22", "66808e327dc79d135ba18e051673d906" ], "categoriesRo": [ { "id": "01894ed2c40070099cf25d59f2d1a99e", "_count": 1 }, { "id": "33e75ff09dd601bbe69f351039152189", "_count": 1 }, { "id": "e369853df766fa44e1ed0ff613f563bd", "_count": 1 }, { "id": "19ca14e7ea6328a42e0eb13d585e4c22", "_count": 1 }, { "id": "66808e327dc79d135ba18e051673d906", "_count": 1 } ], "taxId": "01894ed2c3ff70308e0b51a025a38ddd", "tags": [], "parentId": "f390347c681a3807d3bfaddd86f3dfdb", "coverId": "40967556960c6932666d190cd2e4dad1", "childCount": 0, "categories": [ { "id": "19ca14e7ea6328a42e0eb13d585e4c22", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Street" } }, { "id": "33e75ff09dd601bbe69f351039152189", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der" } }, { "id": "66808e327dc79d135ba18e051673d906", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Herren" } }, { "id": "e369853df766fa44e1ed0ff613f563bd", "_count": 1, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbike" } } ], "manufacturer": { "id": "6462331a69cdc7b76dc81136ca2713dd", "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls" }, "_count": 1 }, "properties": [ { "id": "06779f443aad686267674335679f12f4", "_count": 1, "groupId": "90172b5a229214a431a4352c66865e89", "group": { "id": "90172b5a229214a431a4352c66865e89", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT" } }, { "id": "06be404af15b174e8f487b3a3b44d0d5", "_count": 1, "groupId": "a8c218e8daf51c2528ffec6ba60c0c07", "group": { "id": "a8c218e8daf51c2528ffec6ba60c0c07", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano BL-MT201" } }, { "id": "0a6516eba0cd7353007daeaf2afed7b9", "_count": 1, "groupId": "c3beefaefa0c82a810da3211f962fa99", "group": { "id": "c3beefaefa0c82a810da3211f962fa99", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "48 cm" } }, { "id": "0d5e3902d0bfaeab5929855eae3e211f", "_count": 1, "groupId": "9ce1042f3530e102e670fd8040e9495a", "group": { "id": "9ce1042f3530e102e670fd8040e9495a", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sportive Comfort" } }, { "id": "0fe3633193758e625c5fbdebdd3cd280", "_count": 1, "groupId": "6c08e78b28fa89c1c312ff53e2d81088", "group": { "id": "6c08e78b28fa89c1c312ff53e2d81088", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKS Velo 55" } }, { "id": "116b0c4466fc9803cc97dd1de983a992", "_count": 1, "groupId": "e50ebe47ad39a09a92d06070287e368b", "group": { "id": "e50ebe47ad39a09a92d06070287e368b", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon RL-Mini LED mit Standlichtfunktion" } }, { "id": "1ed920c9e27592593e21a6ddaba1a979", "_count": 1, "groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a", "group": { "id": "8d3c06e4ef7fec22377ee4ea56e7df6a", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung" } }, { "id": "2217afc936988b09838ba934e8eb5c53", "_count": 1, "groupId": "503f306fc1edbd32bb55a9d4d3994f8d", "group": { "id": "503f306fc1edbd32bb55a9d4d3994f8d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27" } }, { "id": "2c56e02a283fa9a33beed5fcd980431e", "_count": 1, "groupId": "c259161c2ad279d194b0a5cfe729e273", "group": { "id": "c259161c2ad279d194b0a5cfe729e273", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschutzring" } }, { "id": "3a616a5305e06ccc883bda3ab63b10b5", "_count": 1, "groupId": "53d6255f9051ddc256c25536f2aecac5", "group": { "id": "53d6255f9051ddc256c25536f2aecac5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J" } }, { "id": "49c903179d3ed9d593a98da9f48bd3e1", "_count": 1, "groupId": "4b20688ca061fc9a853d8dd3c4625fa8", "group": { "id": "4b20688ca061fc9a853d8dd3c4625fa8", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX riserbar" } }, { "id": "4e93759a50b70b433ccdb1ef4185fcc1", "_count": 1, "groupId": "16fd55d02a23f31097ca58eccfeec97c", "group": { "id": "16fd55d02a23f31097ca58eccfeec97c", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "blau" } }, { "id": "4ec969a032686f09de30ead2a801c018", "_count": 1, "groupId": "611e9d73fb6447db4ff09b58ecadce21", "group": { "id": "611e9d73fb6447db4ff09b58ecadce21", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein" } }, { "id": "57ea44f19b74405f40baa45fc561493a", "_count": 1, "groupId": "79958f9b32c396332e45ef4487152f13", "group": { "id": "79958f9b32c396332e45ef4487152f13", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein" } }, { "id": "6325a5e3e6f0ccd9502cb37af8d1b802", "_count": 1, "groupId": "ecf1a4775ece0c53ee7dc9957d1edd24", "group": { "id": "ecf1a4775ece0c53ee7dc9957d1edd24", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon FS-50SL 50 Lux, switch, sensor, Standlichtfunktion" } }, { "id": "6bc4aff51344fb647415b10faad1782f", "_count": 1, "groupId": "483e959c479e7b2fe6423516bb994643", "group": { "id": "483e959c479e7b2fe6423516bb994643", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX Aluminium" } }, { "id": "7052790f352e0b66c5f5ceea1429da94", "_count": 1, "groupId": "f424bfe0316bd62a53f56a46d5eb8d7d", "group": { "id": "f424bfe0316bd62a53f56a46d5eb8d7d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja" } }, { "id": "7c5810fa9eb432a1a1eae36e311adc32", "_count": 1, "groupId": "b33509e4101693a82829fd320a7394ef", "group": { "id": "b33509e4101693a82829fd320a7394ef", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren" } }, { "id": "a247a76861865fa404e25d480c91a0da", "_count": 1, "groupId": "bf2129aece92fe202715f8914e9d9e95", "group": { "id": "bf2129aece92fe202715f8914e9d9e95", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hinterbaust\u00e4nder, zul\u00e4ssiges Gesamtgewicht: 135 kg" } }, { "id": "a3bcfd726d8625df4442a9030f3a18cb", "_count": 1, "groupId": "6952d7680528b2ba9f7ab0e454eed1db", "group": { "id": "6952d7680528b2ba9f7ab0e454eed1db", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supero Ranger Anti Puncture, 44-622" } }, { "id": "acdae9f5f89dabe00a07d5b7b5b7da34", "_count": 1, "groupId": "ea9a44ed7ed83415d29d57fcdd199e52", "group": { "id": "ea9a44ed7ed83415d29d57fcdd199e52", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS" } }, { "id": "b0324cc75b3bd4b541a9bf664cb18bda", "_count": 1, "groupId": "ae1de98645eed200149ba8a40a93df97", "group": { "id": "ae1de98645eed200149ba8a40a93df97", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR Suntour NEX HLO" } }, { "id": "c071fb59de149bed7201d2039b4a04db", "_count": 1, "groupId": "72fb53d4716f03510b2c461fb0ef8ebf", "group": { "id": "72fb53d4716f03510b2c461fb0ef8ebf", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus SL-M2010" } }, { "id": "c4fb240e82b0e93180022e66adbce4d3", "_count": 1, "groupId": "ceb6fd21dc31360b88ac128686052a5e", "group": { "id": "ceb6fd21dc31360b88ac128686052a5e", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus FC-M371 48\/36\/26T" } }, { "id": "c712aed261879de46bc8989e36fe639b", "_count": 1, "groupId": "a16022e7816ee4b03a8e54519ee7bf02", "group": { "id": "a16022e7816ee4b03a8e54519ee7bf02", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10" } }, { "id": "c8bb250ce4ae8f1cb3003218719fbfd5", "_count": 1, "groupId": "f9109ae7ce709818cf47ead51feb3096", "group": { "id": "f9109ae7ce709818cf47ead51feb3096", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant" } }, { "id": "cd51b23a5a270ee839f6b402c3ffe26b", "_count": 1, "groupId": "d7cd942099e8fa42173503c86c8880ce", "group": { "id": "d7cd942099e8fa42173503c86c8880ce", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA No.11" } }, { "id": "ceb2ffd6b65a22cefbe1c054128201ea", "_count": 1, "groupId": "13df042e46bbd8a2eb06116548c29107", "group": { "id": "13df042e46bbd8a2eb06116548c29107", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus FD-M370" } }, { "id": "d14234136d6d332d9605d06a7a79a122", "_count": 1, "groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7", "group": { "id": "adf2abbdb5a021f12b6bc1a1fd34dbc7", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2023" } }, { "id": "d1d158fa6beaeac603efdb7f981a0b1f", "_count": 1, "groupId": "a9afe3dfd367b52569af60a0af3d19c1", "group": { "id": "a9afe3dfd367b52569af60a0af3d19c1", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT \/ Formula" } }, { "id": "d215aedab5221382a37a177485268129", "_count": 1, "groupId": "1dfcee408979620926ced38d7ae45bb3", "group": { "id": "1dfcee408979620926ced38d7ae45bb3", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium" } }, { "id": "d9435ac0370717e0d64cb08281b16888", "_count": 1, "groupId": "b7353c4ace70858b93234198b10691b5", "group": { "id": "b7353c4ace70858b93234198b10691b5", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX" } }, { "id": "e3bd215230288e4282434df986650d10", "_count": 1, "groupId": "3ea4bb03c22f227764c0c1fc05655f9f", "group": { "id": "3ea4bb03c22f227764c0c1fc05655f9f", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX DDM-2" } }, { "id": "f775c3037f79d286884b62ad2e1ff7b7", "_count": 1, "groupId": "05044f92622e2a4b4b94bf95bb76fa5d", "group": { "id": "05044f92622e2a4b4b94bf95bb76fa5d", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Acera RD-M3100 Shadow" } }, { "id": "fc7c95e8a0c10edfec779479917546ca", "_count": 1, "groupId": "f5fed9bc267410759ab04276601a9f42", "group": { "id": "f5fed9bc267410759ab04276601a9f42", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\"" } }, { "id": "fd55a5a0843b99e6164c11734c6cd5a0", "_count": 1, "groupId": "f7a9fede8828c7ad00054338044d0dbe", "group": { "id": "f7a9fede8828c7ad00054338044d0dbe", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr." } }, { "id": "ff38ae8d2e4e2225204122517de8b410", "_count": 1, "groupId": "8f5fb50f0ee251c4c2af213e489e63bb", "group": { "id": "8f5fb50f0ee251c4c2af213e489e63bb", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren" } } ], "options": [ { "id": "0a6516eba0cd7353007daeaf2afed7b9", "_count": 1, "groupId": "c3beefaefa0c82a810da3211f962fa99", "group": { "id": "c3beefaefa0c82a810da3211f962fa99", "_count": 1 }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "48 cm" } } ], "categoryIds": [ "19ca14e7ea6328a42e0eb13d585e4c22", "33e75ff09dd601bbe69f351039152189", "66808e327dc79d135ba18e051673d906", "e369853df766fa44e1ed0ff613f563bd" ], "optionIds": [ "0a6516eba0cd7353007daeaf2afed7b9" ], "propertyIds": [ "06779f443aad686267674335679f12f4", "06be404af15b174e8f487b3a3b44d0d5", "0a6516eba0cd7353007daeaf2afed7b9", "0d5e3902d0bfaeab5929855eae3e211f", "0fe3633193758e625c5fbdebdd3cd280", "116b0c4466fc9803cc97dd1de983a992", "1ed920c9e27592593e21a6ddaba1a979", "2217afc936988b09838ba934e8eb5c53", "2c56e02a283fa9a33beed5fcd980431e", "3a616a5305e06ccc883bda3ab63b10b5", "49c903179d3ed9d593a98da9f48bd3e1", "4e93759a50b70b433ccdb1ef4185fcc1", "4ec969a032686f09de30ead2a801c018", "57ea44f19b74405f40baa45fc561493a", "6325a5e3e6f0ccd9502cb37af8d1b802", "6bc4aff51344fb647415b10faad1782f", "7052790f352e0b66c5f5ceea1429da94", "7c5810fa9eb432a1a1eae36e311adc32", "a247a76861865fa404e25d480c91a0da", "a3bcfd726d8625df4442a9030f3a18cb", "acdae9f5f89dabe00a07d5b7b5b7da34", "b0324cc75b3bd4b541a9bf664cb18bda", "c071fb59de149bed7201d2039b4a04db", "c4fb240e82b0e93180022e66adbce4d3", "c712aed261879de46bc8989e36fe639b", "c8bb250ce4ae8f1cb3003218719fbfd5", "cd51b23a5a270ee839f6b402c3ffe26b", "ceb2ffd6b65a22cefbe1c054128201ea", "d14234136d6d332d9605d06a7a79a122", "d1d158fa6beaeac603efdb7f981a0b1f", "d215aedab5221382a37a177485268129", "d9435ac0370717e0d64cb08281b16888", "e3bd215230288e4282434df986650d10", "f775c3037f79d286884b62ad2e1ff7b7", "fc7c95e8a0c10edfec779479917546ca", "fd55a5a0843b99e6164c11734c6cd5a0", "ff38ae8d2e4e2225204122517de8b410" ], "tagIds": [], "states": [ "is-physical" ], "customFields": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": { "product_slider_einsatz": 4.0, "product_slider_terrain": 4.0, "product_slider_ausstattung": 6.0, "product_slider_e_bike": 0.0, "product_minderest": 0.0, "product_zubehora_article": "", "product_click_and_collect": 0.0, "product_store_available": 0.0, "product_parent_article": 104215.1, "product_vk2_amazon": 979.0, "product_vk3_ebay": 979.0 } }, "name": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Cross Street Herren blau 2022\/2023" }, "description": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Cross Street Als sportliches Multitalent bewegt sich das Cross Street schnell und sicher zwischen Alltag und Freizeit. Dank 27-Gang-Schaltung, hydraulischen Shimano-Scheibenbremsen, Luftfedergabel mit Lenker-Lockout und pannengesch\u00fctzten Supero Ranger Profilreifen ist das Cross Street bereit f\u00fcr neue Herausforderungen." }, "metaTitle": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "metaDescription": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "customSearchKeywords": { "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null }, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 777.0, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 652.94, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 27.99, "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 27.99 }, "fields": { "displayGroup": [ "99475cbc64fc5ab44481764a2093c783" ] }, "sort": [ 777.0 ] } ] } } `Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search`

Request:

{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["3178","4044","5921","6928-6943-3494","7313"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "terms": {
                                                "productNumber": [
                                                    "3178",
                                                    "4044",
                                                    "5921",
                                                    "6928-6943-3494",
                                                    "7313"
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 10
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "number",
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                },
                "order": "ASC"
            }
        }
    ],
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": [
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "3a0f19df72fef0495c54ced664735a7d",
                "_score": null,
                "_source": {
                    "id": "3a0f19df72fef0495c54ced664735a7d",
                    "autoIncrement": 86554.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 48,
                    "productNumber": "7313",
                    "ean": null,
                    "displayGroup": "0d168a61882c448a23edb47f50fcfab8",
                    "sales": 0,
                    "stock": 48,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "e5da136850fac64ea7f9647e61745237",
                    "manufacturerNumber": "060-66105",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:37:36+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "819f46e52c25763a55cc642422644317",
                        "cb70ab375662576bd1ac5aaf16b3fca4"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "819f46e52c25763a55cc642422644317",
                            "_count": 1
                        },
                        {
                            "id": "cb70ab375662576bd1ac5aaf16b3fca4",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "f9e5c68cf6180bab35e7ae94265c6be8",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "819f46e52c25763a55cc642422644317",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge, Pflege & N\u00fctzliches"
                            }
                        },
                        {
                            "id": "cb70ab375662576bd1ac5aaf16b3fca4",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N\u00fctzliches Fahrradzubeh\u00f6r"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "e5da136850fac64ea7f9647e61745237",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "819f46e52c25763a55cc642422644317",
                        "cb70ab375662576bd1ac5aaf16b3fca4"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "Montage",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 4.99,
                            "product_vk3_ebay": 4.99
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roto Schaltwerkschutzb\u00fcgel"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 5.03
                },
                "fields": {
                    "displayGroup": [
                        "0d168a61882c448a23edb47f50fcfab8"
                    ]
                },
                "sort": [
                    5.99
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "b59442085644532ef03417a3e5a76437",
                "_score": null,
                "_source": {
                    "id": "b59442085644532ef03417a3e5a76437",
                    "autoIncrement": 86703.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 15,
                    "productNumber": "5921",
                    "ean": "4250149440823",
                    "displayGroup": "55df308465d9895dce7e4927c29b9bc7",
                    "sales": 0,
                    "stock": 15,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "cbb3ea7ea3c3c4225c13d285f94e81d4",
                    "manufacturerNumber": "080-40355",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:38:24+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "6855456e2fe46a9d49d3d3af4f57443d",
                        "01386bd6d8e091c2ab4c7c7de644d37b"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "6855456e2fe46a9d49d3d3af4f57443d",
                            "_count": 1
                        },
                        {
                            "id": "01386bd6d8e091c2ab4c7c7de644d37b",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "2e664fee7e9d1b41cc434fac1a90d5e3",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "01386bd6d8e091c2ab4c7c7de644d37b",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Handyhalterung"
                            }
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "6855456e2fe46a9d49d3d3af4f57443d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "cbb3ea7ea3c3c4225c13d285f94e81d4",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NC-17"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "01386bd6d8e091c2ab4c7c7de644d37b",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "6855456e2fe46a9d49d3d3af4f57443d"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "Montage4",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 24.95,
                            "product_vk3_ebay": 24.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "NC-17 Smartphone-Halter A-Head"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.97
                },
                "fields": {
                    "displayGroup": [
                        "55df308465d9895dce7e4927c29b9bc7"
                    ]
                },
                "sort": [
                    24.95
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "df5354693177e83e8ba089e94b7b6b55",
                "_score": null,
                "_source": {
                    "id": "df5354693177e83e8ba089e94b7b6b55",
                    "autoIncrement": 81612.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 2,
                    "productNumber": "4044",
                    "ean": "4002556875954",
                    "displayGroup": "9fcece259f60dba60addb2c44969ddf0",
                    "sales": 0,
                    "stock": 2,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "d978e353f0df4f240453e1f3727c98a7",
                    "manufacturerNumber": "050-28479",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:10+00:00",
                    "categoryTree": [],
                    "categoriesRo": [],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "1a85051c6633eac99087ae33e76252b0",
                    "coverId": "c5535355de677d1418a1390df9a0c5b7",
                    "childCount": 0,
                    "categories": [],
                    "manufacturer": {
                        "id": "d978e353f0df4f240453e1f3727c98a7",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "2f2e3f5b79e0af274270f86a98dc2957",
                            "_count": 1,
                            "groupId": "622dd2d5e4ce31aeb63cce84815577a0",
                            "group": {
                                "id": "622dd2d5e4ce31aeb63cce84815577a0",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "450 ml"
                            }
                        },
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "2f2e3f5b79e0af274270f86a98dc2957",
                            "_count": 1,
                            "groupId": "622dd2d5e4ce31aeb63cce84815577a0",
                            "group": {
                                "id": "622dd2d5e4ce31aeb63cce84815577a0",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "450 ml"
                            }
                        }
                    ],
                    "categoryIds": [],
                    "optionIds": [
                        "2f2e3f5b79e0af274270f86a98dc2957"
                    ],
                    "propertyIds": [
                        "2f2e3f5b79e0af274270f86a98dc2957",
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "Montage",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 4044.1,
                            "product_vk2_amazon": 17.89,
                            "product_vk3_ebay": 17.89
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink Trinkflasche inkl. BottleMount"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.69
                },
                "fields": {
                    "displayGroup": [
                        "9fcece259f60dba60addb2c44969ddf0"
                    ]
                },
                "sort": [
                    32.95
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "ba95d78a7c942571185308775a97a3a0",
                "_score": null,
                "_source": {
                    "id": "ba95d78a7c942571185308775a97a3a0",
                    "autoIncrement": 81593.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 30,
                    "productNumber": "3178",
                    "ean": "4043197271590",
                    "displayGroup": "f8196f746cd4562e2b859889e0af1857",
                    "sales": 0,
                    "stock": 30,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "113a80259eea2dabecb4f1d35f5aafb8",
                    "manufacturerNumber": "S4104230815",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:12:10+00:00",
                    "categoryTree": [],
                    "categoriesRo": [],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "15eb9474366241a7d01696ea8d02e9ca",
                    "coverId": "a4c99aac94986d8405c9e81a45ad99d9",
                    "childCount": 0,
                    "categories": [],
                    "manufacturer": {
                        "id": "113a80259eea2dabecb4f1d35f5aafb8",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "795995d1c59b90ec89199aacd3cd42e7",
                            "_count": 1,
                            "groupId": "e682e5d097523765cde5e59df6139363",
                            "group": {
                                "id": "e682e5d097523765cde5e59df6139363",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "52-57 cm"
                            }
                        }
                    ],
                    "categoryIds": [],
                    "optionIds": [
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "795995d1c59b90ec89199aacd3cd42e7"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": 3178.1,
                            "product_vk2_amazon": 69.95,
                            "product_vk3_ebay": 69.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Uvex i-vo cc black"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 89.95,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 75.59
                },
                "fields": {
                    "displayGroup": [
                        "f8196f746cd4562e2b859889e0af1857"
                    ]
                },
                "sort": [
                    89.95
                ]
            },
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "abcee2e80df42bbb77d89f5738e74462",
                "_score": null,
                "_source": {
                    "id": "abcee2e80df42bbb77d89f5738e74462",
                    "autoIncrement": 86472.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": true,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 1000,
                    "productNumber": "6928-6943-3494",
                    "ean": null,
                    "displayGroup": "bb77e846e82e42f74f8d4d6480a8288c",
                    "sales": 0,
                    "stock": 1000,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
                    "manufacturerNumber": "6928-6943-3494",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:37:11+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "28dd2c7955ce926456240b2ff0100bde",
                        "9872ed9fc22fc182d371c3e9ed316094",
                        "31fefc0e570cb3860f2a6d4b38c6490d",
                        "fb7b9ffa5462084c5f4e7e85a093e6d7"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1
                        },
                        {
                            "id": "9872ed9fc22fc182d371c3e9ed316094",
                            "_count": 1
                        },
                        {
                            "id": "31fefc0e570cb3860f2a6d4b38c6490d",
                            "_count": 1
                        },
                        {
                            "id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": null,
                    "coverId": "7ea0f2d06757a9e6f59fcf8d74636f5d",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "28dd2c7955ce926456240b2ff0100bde",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
                            }
                        },
                        {
                            "id": "31fefc0e570cb3860f2a6d4b38c6490d",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rahmenschl\u00f6sser"
                            }
                        },
                        {
                            "id": "9872ed9fc22fc182d371c3e9ed316094",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
                            }
                        },
                        {
                            "id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschl\u00f6sser"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "4bbd9c23e810a10a299357ea4c2b94ff",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        }
                    ],
                    "options": [],
                    "categoryIds": [
                        "28dd2c7955ce926456240b2ff0100bde",
                        "31fefc0e570cb3860f2a6d4b38c6490d",
                        "9872ed9fc22fc182d371c3e9ed316094",
                        "fb7b9ffa5462084c5f4e7e85a093e6d7"
                    ],
                    "optionIds": [],
                    "propertyIds": [
                        "3a616a5305e06ccc883bda3ab63b10b5"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 0.0,
                            "product_slider_terrain": 0.0,
                            "product_slider_ausstattung": 0.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "Montage",
                            "product_click_and_collect": 1.0,
                            "product_store_available": 1.0,
                            "product_parent_article": "",
                            "product_vk2_amazon": 54.95,
                            "product_vk3_ebay": 54.95
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Pro Shield +Zusatzkette Pro Shield+AXA Flex Bef."
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 96.89,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 81.42,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 0.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 0.0
                },
                "fields": {
                    "displayGroup": [
                        "bb77e846e82e42f74f8d4d6480a8288c"
                    ]
                },
                "sort": [
                    96.89
                ]
            }
        ]
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

3.41 ms

Request:

{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["104215"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}

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


                                    POST http://10.30.0.4:9200/shopware6-stage_product/_search?track_total_hits=0&search_type=query_then_fetch
    Accept: application/json
    Content-Type: application/json

        {
    "query": {
        "bool": {
            "filter": [
                {
                    "bool": {
                        "must": [
                            {
                                "bool": {
                                    "should": [
                                        {
                                            "terms": {
                                                "productNumber": [
                                                    "104215"
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must_not": [
                                        {
                                            "bool": {
                                                "must_not": [
                                                    {
                                                        "exists": {
                                                            "field": "displayGroup"
                                                        }
                                                    }
                                                ]
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "nested": {
                                                "path": "visibilities",
                                                "query": {
                                                    "bool": {
                                                        "must": [
                                                            {
                                                                "range": {
                                                                    "visibilities.visibility": {
                                                                        "gte": 10
                                                                    }
                                                                }
                                                            },
                                                            {
                                                                "term": {
                                                                    "visibilities.salesChannelId": "01895226670e72a4a15f371adce297ad"
                                                                }
                                                            }
                                                        ]
                                                    }
                                                }
                                            }
                                        },
                                        {
                                            "term": {
                                                "active": true
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "_script": {
                "type": "number",
                "script": {
                    "source": "double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n    for (accessor in accessors) {\n        def key = accessor['key'];\n\n        if (!doc.containsKey(key) || doc[key].empty) {\n            continue;\n        }\n\n        def factor = accessor['factor'];\n        def value = doc[key].value * factor;\n\n        value = Math.round(value * decimals);\n        value = (double) value \/ decimals;\n\n        if (!round) {\n            return (double) value;\n        }\n\n        value = Math.round(value * multiplier);\n\n        value = (double) value \/ multiplier;\n\n        return (double) value;\n    }\n\n    return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n",
                    "lang": "painless",
                    "params": {
                        "accessors": [
                            {
                                "key": "cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            },
                            {
                                "key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
                                "factor": 1
                            }
                        ],
                        "decimals": 100,
                        "round": true,
                        "multiplier": 100.0
                    }
                },
                "order": "ASC"
            }
        }
    ],
    "from": 0,
    "size": 24,
    "collapse": {
        "field": "displayGroup"
    },
    "timeout": "5s"
}


                                    {
    "took": 1,
    "timed_out": false,
    "_shards": {
        "total": 3,
        "successful": 3,
        "skipped": 0,
        "failed": 0
    },
    "hits": {
        "max_score": null,
        "hits": [
            {
                "_index": "shopware6-stage_product_1725967126",
                "_id": "53f7235d27cc40d10f35210555c499d4",
                "_score": null,
                "_source": {
                    "id": "53f7235d27cc40d10f35210555c499d4",
                    "autoIncrement": 80455.0,
                    "ratingAverage": 0.0,
                    "active": true,
                    "available": false,
                    "isCloseout": true,
                    "shippingFree": false,
                    "markAsTopseller": false,
                    "visibilities": [
                        {
                            "_count": 1,
                            "visibility": 30,
                            "salesChannelId": "01895226670e72a4a15f371adce297ad"
                        }
                    ],
                    "availableStock": 0,
                    "productNumber": "104215",
                    "ean": "4063518166527",
                    "displayGroup": "99475cbc64fc5ab44481764a2093c783",
                    "sales": 0,
                    "stock": 0,
                    "weight": 0.0,
                    "width": 0.0,
                    "length": 0.0,
                    "height": 0.0,
                    "manufacturerId": "6462331a69cdc7b76dc81136ca2713dd",
                    "manufacturerNumber": "632-10748",
                    "releaseDate": null,
                    "createdAt": "2023-10-16T11:08:03+00:00",
                    "categoryTree": [
                        "01894ed2c40070099cf25d59f2d1a99e",
                        "33e75ff09dd601bbe69f351039152189",
                        "e369853df766fa44e1ed0ff613f563bd",
                        "19ca14e7ea6328a42e0eb13d585e4c22",
                        "66808e327dc79d135ba18e051673d906"
                    ],
                    "categoriesRo": [
                        {
                            "id": "01894ed2c40070099cf25d59f2d1a99e",
                            "_count": 1
                        },
                        {
                            "id": "33e75ff09dd601bbe69f351039152189",
                            "_count": 1
                        },
                        {
                            "id": "e369853df766fa44e1ed0ff613f563bd",
                            "_count": 1
                        },
                        {
                            "id": "19ca14e7ea6328a42e0eb13d585e4c22",
                            "_count": 1
                        },
                        {
                            "id": "66808e327dc79d135ba18e051673d906",
                            "_count": 1
                        }
                    ],
                    "taxId": "01894ed2c3ff70308e0b51a025a38ddd",
                    "tags": [],
                    "parentId": "f390347c681a3807d3bfaddd86f3dfdb",
                    "coverId": "40967556960c6932666d190cd2e4dad1",
                    "childCount": 0,
                    "categories": [
                        {
                            "id": "19ca14e7ea6328a42e0eb13d585e4c22",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Street"
                            }
                        },
                        {
                            "id": "33e75ff09dd601bbe69f351039152189",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
                            }
                        },
                        {
                            "id": "66808e327dc79d135ba18e051673d906",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Herren"
                            }
                        },
                        {
                            "id": "e369853df766fa44e1ed0ff613f563bd",
                            "_count": 1,
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbike"
                            }
                        }
                    ],
                    "manufacturer": {
                        "id": "6462331a69cdc7b76dc81136ca2713dd",
                        "name": {
                            "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls"
                        },
                        "_count": 1
                    },
                    "properties": [
                        {
                            "id": "06779f443aad686267674335679f12f4",
                            "_count": 1,
                            "groupId": "90172b5a229214a431a4352c66865e89",
                            "group": {
                                "id": "90172b5a229214a431a4352c66865e89",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT"
                            }
                        },
                        {
                            "id": "06be404af15b174e8f487b3a3b44d0d5",
                            "_count": 1,
                            "groupId": "a8c218e8daf51c2528ffec6ba60c0c07",
                            "group": {
                                "id": "a8c218e8daf51c2528ffec6ba60c0c07",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano BL-MT201"
                            }
                        },
                        {
                            "id": "0a6516eba0cd7353007daeaf2afed7b9",
                            "_count": 1,
                            "groupId": "c3beefaefa0c82a810da3211f962fa99",
                            "group": {
                                "id": "c3beefaefa0c82a810da3211f962fa99",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "48 cm"
                            }
                        },
                        {
                            "id": "0d5e3902d0bfaeab5929855eae3e211f",
                            "_count": 1,
                            "groupId": "9ce1042f3530e102e670fd8040e9495a",
                            "group": {
                                "id": "9ce1042f3530e102e670fd8040e9495a",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sportive Comfort"
                            }
                        },
                        {
                            "id": "0fe3633193758e625c5fbdebdd3cd280",
                            "_count": 1,
                            "groupId": "6c08e78b28fa89c1c312ff53e2d81088",
                            "group": {
                                "id": "6c08e78b28fa89c1c312ff53e2d81088",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKS Velo 55"
                            }
                        },
                        {
                            "id": "116b0c4466fc9803cc97dd1de983a992",
                            "_count": 1,
                            "groupId": "e50ebe47ad39a09a92d06070287e368b",
                            "group": {
                                "id": "e50ebe47ad39a09a92d06070287e368b",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon RL-Mini LED mit Standlichtfunktion"
                            }
                        },
                        {
                            "id": "1ed920c9e27592593e21a6ddaba1a979",
                            "_count": 1,
                            "groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
                            "group": {
                                "id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
                            }
                        },
                        {
                            "id": "2217afc936988b09838ba934e8eb5c53",
                            "_count": 1,
                            "groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
                            "group": {
                                "id": "503f306fc1edbd32bb55a9d4d3994f8d",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27"
                            }
                        },
                        {
                            "id": "2c56e02a283fa9a33beed5fcd980431e",
                            "_count": 1,
                            "groupId": "c259161c2ad279d194b0a5cfe729e273",
                            "group": {
                                "id": "c259161c2ad279d194b0a5cfe729e273",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschutzring"
                            }
                        },
                        {
                            "id": "3a616a5305e06ccc883bda3ab63b10b5",
                            "_count": 1,
                            "groupId": "53d6255f9051ddc256c25536f2aecac5",
                            "group": {
                                "id": "53d6255f9051ddc256c25536f2aecac5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
                            }
                        },
                        {
                            "id": "49c903179d3ed9d593a98da9f48bd3e1",
                            "_count": 1,
                            "groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
                            "group": {
                                "id": "4b20688ca061fc9a853d8dd3c4625fa8",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX riserbar"
                            }
                        },
                        {
                            "id": "4e93759a50b70b433ccdb1ef4185fcc1",
                            "_count": 1,
                            "groupId": "16fd55d02a23f31097ca58eccfeec97c",
                            "group": {
                                "id": "16fd55d02a23f31097ca58eccfeec97c",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "blau"
                            }
                        },
                        {
                            "id": "4ec969a032686f09de30ead2a801c018",
                            "_count": 1,
                            "groupId": "611e9d73fb6447db4ff09b58ecadce21",
                            "group": {
                                "id": "611e9d73fb6447db4ff09b58ecadce21",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
                            }
                        },
                        {
                            "id": "57ea44f19b74405f40baa45fc561493a",
                            "_count": 1,
                            "groupId": "79958f9b32c396332e45ef4487152f13",
                            "group": {
                                "id": "79958f9b32c396332e45ef4487152f13",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
                            }
                        },
                        {
                            "id": "6325a5e3e6f0ccd9502cb37af8d1b802",
                            "_count": 1,
                            "groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
                            "group": {
                                "id": "ecf1a4775ece0c53ee7dc9957d1edd24",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon FS-50SL 50 Lux, switch, sensor, Standlichtfunktion"
                            }
                        },
                        {
                            "id": "6bc4aff51344fb647415b10faad1782f",
                            "_count": 1,
                            "groupId": "483e959c479e7b2fe6423516bb994643",
                            "group": {
                                "id": "483e959c479e7b2fe6423516bb994643",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX Aluminium"
                            }
                        },
                        {
                            "id": "7052790f352e0b66c5f5ceea1429da94",
                            "_count": 1,
                            "groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
                            "group": {
                                "id": "f424bfe0316bd62a53f56a46d5eb8d7d",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
                            }
                        },
                        {
                            "id": "7c5810fa9eb432a1a1eae36e311adc32",
                            "_count": 1,
                            "groupId": "b33509e4101693a82829fd320a7394ef",
                            "group": {
                                "id": "b33509e4101693a82829fd320a7394ef",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
                            }
                        },
                        {
                            "id": "a247a76861865fa404e25d480c91a0da",
                            "_count": 1,
                            "groupId": "bf2129aece92fe202715f8914e9d9e95",
                            "group": {
                                "id": "bf2129aece92fe202715f8914e9d9e95",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hinterbaust\u00e4nder, zul\u00e4ssiges Gesamtgewicht: 135 kg"
                            }
                        },
                        {
                            "id": "a3bcfd726d8625df4442a9030f3a18cb",
                            "_count": 1,
                            "groupId": "6952d7680528b2ba9f7ab0e454eed1db",
                            "group": {
                                "id": "6952d7680528b2ba9f7ab0e454eed1db",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supero Ranger Anti Puncture, 44-622"
                            }
                        },
                        {
                            "id": "acdae9f5f89dabe00a07d5b7b5b7da34",
                            "_count": 1,
                            "groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
                            "group": {
                                "id": "ea9a44ed7ed83415d29d57fcdd199e52",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS"
                            }
                        },
                        {
                            "id": "b0324cc75b3bd4b541a9bf664cb18bda",
                            "_count": 1,
                            "groupId": "ae1de98645eed200149ba8a40a93df97",
                            "group": {
                                "id": "ae1de98645eed200149ba8a40a93df97",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR Suntour NEX HLO"
                            }
                        },
                        {
                            "id": "c071fb59de149bed7201d2039b4a04db",
                            "_count": 1,
                            "groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
                            "group": {
                                "id": "72fb53d4716f03510b2c461fb0ef8ebf",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus SL-M2010"
                            }
                        },
                        {
                            "id": "c4fb240e82b0e93180022e66adbce4d3",
                            "_count": 1,
                            "groupId": "ceb6fd21dc31360b88ac128686052a5e",
                            "group": {
                                "id": "ceb6fd21dc31360b88ac128686052a5e",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus FC-M371 48\/36\/26T"
                            }
                        },
                        {
                            "id": "c712aed261879de46bc8989e36fe639b",
                            "_count": 1,
                            "groupId": "a16022e7816ee4b03a8e54519ee7bf02",
                            "group": {
                                "id": "a16022e7816ee4b03a8e54519ee7bf02",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10"
                            }
                        },
                        {
                            "id": "c8bb250ce4ae8f1cb3003218719fbfd5",
                            "_count": 1,
                            "groupId": "f9109ae7ce709818cf47ead51feb3096",
                            "group": {
                                "id": "f9109ae7ce709818cf47ead51feb3096",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
                            }
                        },
                        {
                            "id": "cd51b23a5a270ee839f6b402c3ffe26b",
                            "_count": 1,
                            "groupId": "d7cd942099e8fa42173503c86c8880ce",
                            "group": {
                                "id": "d7cd942099e8fa42173503c86c8880ce",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA No.11"
                            }
                        },
                        {
                            "id": "ceb2ffd6b65a22cefbe1c054128201ea",
                            "_count": 1,
                            "groupId": "13df042e46bbd8a2eb06116548c29107",
                            "group": {
                                "id": "13df042e46bbd8a2eb06116548c29107",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus FD-M370"
                            }
                        },
                        {
                            "id": "d14234136d6d332d9605d06a7a79a122",
                            "_count": 1,
                            "groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
                            "group": {
                                "id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2023"
                            }
                        },
                        {
                            "id": "d1d158fa6beaeac603efdb7f981a0b1f",
                            "_count": 1,
                            "groupId": "a9afe3dfd367b52569af60a0af3d19c1",
                            "group": {
                                "id": "a9afe3dfd367b52569af60a0af3d19c1",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT \/ Formula"
                            }
                        },
                        {
                            "id": "d215aedab5221382a37a177485268129",
                            "_count": 1,
                            "groupId": "1dfcee408979620926ced38d7ae45bb3",
                            "group": {
                                "id": "1dfcee408979620926ced38d7ae45bb3",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
                            }
                        },
                        {
                            "id": "d9435ac0370717e0d64cb08281b16888",
                            "_count": 1,
                            "groupId": "b7353c4ace70858b93234198b10691b5",
                            "group": {
                                "id": "b7353c4ace70858b93234198b10691b5",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX"
                            }
                        },
                        {
                            "id": "e3bd215230288e4282434df986650d10",
                            "_count": 1,
                            "groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
                            "group": {
                                "id": "3ea4bb03c22f227764c0c1fc05655f9f",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX DDM-2"
                            }
                        },
                        {
                            "id": "f775c3037f79d286884b62ad2e1ff7b7",
                            "_count": 1,
                            "groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
                            "group": {
                                "id": "05044f92622e2a4b4b94bf95bb76fa5d",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Acera RD-M3100 Shadow"
                            }
                        },
                        {
                            "id": "fc7c95e8a0c10edfec779479917546ca",
                            "_count": 1,
                            "groupId": "f5fed9bc267410759ab04276601a9f42",
                            "group": {
                                "id": "f5fed9bc267410759ab04276601a9f42",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
                            }
                        },
                        {
                            "id": "fd55a5a0843b99e6164c11734c6cd5a0",
                            "_count": 1,
                            "groupId": "f7a9fede8828c7ad00054338044d0dbe",
                            "group": {
                                "id": "f7a9fede8828c7ad00054338044d0dbe",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
                            }
                        },
                        {
                            "id": "ff38ae8d2e4e2225204122517de8b410",
                            "_count": 1,
                            "groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
                            "group": {
                                "id": "8f5fb50f0ee251c4c2af213e489e63bb",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
                            }
                        }
                    ],
                    "options": [
                        {
                            "id": "0a6516eba0cd7353007daeaf2afed7b9",
                            "_count": 1,
                            "groupId": "c3beefaefa0c82a810da3211f962fa99",
                            "group": {
                                "id": "c3beefaefa0c82a810da3211f962fa99",
                                "_count": 1
                            },
                            "name": {
                                "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "48 cm"
                            }
                        }
                    ],
                    "categoryIds": [
                        "19ca14e7ea6328a42e0eb13d585e4c22",
                        "33e75ff09dd601bbe69f351039152189",
                        "66808e327dc79d135ba18e051673d906",
                        "e369853df766fa44e1ed0ff613f563bd"
                    ],
                    "optionIds": [
                        "0a6516eba0cd7353007daeaf2afed7b9"
                    ],
                    "propertyIds": [
                        "06779f443aad686267674335679f12f4",
                        "06be404af15b174e8f487b3a3b44d0d5",
                        "0a6516eba0cd7353007daeaf2afed7b9",
                        "0d5e3902d0bfaeab5929855eae3e211f",
                        "0fe3633193758e625c5fbdebdd3cd280",
                        "116b0c4466fc9803cc97dd1de983a992",
                        "1ed920c9e27592593e21a6ddaba1a979",
                        "2217afc936988b09838ba934e8eb5c53",
                        "2c56e02a283fa9a33beed5fcd980431e",
                        "3a616a5305e06ccc883bda3ab63b10b5",
                        "49c903179d3ed9d593a98da9f48bd3e1",
                        "4e93759a50b70b433ccdb1ef4185fcc1",
                        "4ec969a032686f09de30ead2a801c018",
                        "57ea44f19b74405f40baa45fc561493a",
                        "6325a5e3e6f0ccd9502cb37af8d1b802",
                        "6bc4aff51344fb647415b10faad1782f",
                        "7052790f352e0b66c5f5ceea1429da94",
                        "7c5810fa9eb432a1a1eae36e311adc32",
                        "a247a76861865fa404e25d480c91a0da",
                        "a3bcfd726d8625df4442a9030f3a18cb",
                        "acdae9f5f89dabe00a07d5b7b5b7da34",
                        "b0324cc75b3bd4b541a9bf664cb18bda",
                        "c071fb59de149bed7201d2039b4a04db",
                        "c4fb240e82b0e93180022e66adbce4d3",
                        "c712aed261879de46bc8989e36fe639b",
                        "c8bb250ce4ae8f1cb3003218719fbfd5",
                        "cd51b23a5a270ee839f6b402c3ffe26b",
                        "ceb2ffd6b65a22cefbe1c054128201ea",
                        "d14234136d6d332d9605d06a7a79a122",
                        "d1d158fa6beaeac603efdb7f981a0b1f",
                        "d215aedab5221382a37a177485268129",
                        "d9435ac0370717e0d64cb08281b16888",
                        "e3bd215230288e4282434df986650d10",
                        "f775c3037f79d286884b62ad2e1ff7b7",
                        "fc7c95e8a0c10edfec779479917546ca",
                        "fd55a5a0843b99e6164c11734c6cd5a0",
                        "ff38ae8d2e4e2225204122517de8b410"
                    ],
                    "tagIds": [],
                    "states": [
                        "is-physical"
                    ],
                    "customFields": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
                            "product_slider_einsatz": 4.0,
                            "product_slider_terrain": 4.0,
                            "product_slider_ausstattung": 6.0,
                            "product_slider_e_bike": 0.0,
                            "product_minderest": 0.0,
                            "product_zubehora_article": "",
                            "product_click_and_collect": 0.0,
                            "product_store_available": 0.0,
                            "product_parent_article": 104215.1,
                            "product_vk2_amazon": 979.0,
                            "product_vk3_ebay": 979.0
                        }
                    },
                    "name": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Cross Street Herren blau 2022\/2023"
                    },
                    "description": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Cross Street   Als sportliches Multitalent bewegt sich das Cross Street schnell und sicher zwischen Alltag und Freizeit. Dank 27-Gang-Schaltung, hydraulischen Shimano-Scheibenbremsen, Luftfedergabel mit Lenker-Lockout und pannengesch\u00fctzten Supero Ranger Profilreifen ist das Cross Street bereit f\u00fcr neue Herausforderungen."
                    },
                    "metaTitle": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "metaDescription": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "customSearchKeywords": {
                        "2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
                    },
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 777.0,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 652.94,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 27.99,
                    "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 27.99
                },
                "fields": {
                    "displayGroup": [
                        "99475cbc64fc5ab44481764a2093c783"
                    ]
                },
                "sort": [
                    777.0
                ]
            }
        ]
    }
}

Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search

Cluster Status

{
    "cluster_name": "elasticsearch",
    "status": "yellow",
    "timed_out": false,
    "number_of_nodes": 1,
    "number_of_data_nodes": 1,
    "active_primary_shards": 86,
    "active_shards": 86,
    "relocating_shards": 0,
    "initializing_shards": 0,
    "unassigned_shards": 252,
    "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": 25.443786982248522
}

Indices

Name▲	Status	Replication (pri, rep)	Doc Count
sw-admin-payment-method-listing_1732606828	open	3, 3	45
shopware6-stage_product_1725962023	open	3, 3	698878
shopware6-new_product_1723452452	open	3, 3	698878
sw-admin-mollie-refund_1732606829	open	3, 3	0
shopware6-stage_product_01894ed2cf1a70659e13690a9aca16a3_1723451325	open	3, 3	411469
sw-admin-promotion-listing_1732606828	open	3, 3	9
shopware6-stage_product_2fbb5fe2e29a4d70aa5854ce7ce3e20b_1723451325	open	3, 3	411469
sw-admin-media-listing_1732606828	open	3, 3	10049
sw-admin-product-stream-listing_1732606829	open	3, 3	7353
sw-admin-manufacturer-listing_1732606827	open	3, 3	127
sw-admin-newsletter-recipient-listing_1732606829	open	3, 3	1
sw-admin-cms-page-listing_1732606827	open	3, 3	65
sw-admin-product-listing_1732606828	open	3, 3	9462
shopware6-stage_product_1717777228	open	3, 3	698886
shopware6-stage_product_1725967126	open	3, 3	773930
sw-admin-sales-channel-listing_1732606828	open	3, 3	2
shopware6-new_product_1723451173	open	3, 3	698866
sw-admin-landing-page-listing_1732606827	open	3, 3	16
sw-admin-customer-group-listing_1732606827	open	3, 3	2
shopware6-stage_product_1725967107	open	3, 3	698878
sw-admin-category-listing_1732606829	open	3, 3	374
sw-admin-mollie-subscription_1732606829	open	3, 3	0
sw-admin-order-listing_1732606828	open	3, 3	462
shopware6-stage_product_1725958313	open	3, 3	698878
sw-admin-property-group-listing_1732606828	open	3, 3	137
sw-admin-customer-listing_1732606827	open	3, 3	133
sw-admin-shipping-method-listing_1732606828	open	3, 3	3
shopware6-stage_product_1725962160	open	3, 3	698878

Symfony Profiler

GET https://stage-sw6.radwelt-shop.de/detail/964bff51b588ca2c37015c0967529e9b

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Cluster Status

Indices