| 1 |
9.65 ms |
Request:
{"index":"dev_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"b5fc7ad46da94523bbb7ecea3ca095fb"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":32,"size":32,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 43,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "e274d2880b6648808c9026b6d5fa8be2",
"_score": null,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": 0.0,
"net": 0.0,
"linked": true
}
],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"crossSellings": [
{
"id": "47c7800887d24a5681ded6912cc34f32",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nabenkappen Dotz, Nabenkappe Defender, Nabenkappen DO716-S, Nabenkappen DO716-B, Kappen Felgen Dotz, dotz nabendeckel, dotz nabenkappe, dotz nabenabdeckung, dotz nabenabdeckung silber, dotz nabenkappe silber, Defender Dotz Nabendeckel",
"5059dc45b5104c368cc2a7f890b80123": "Hubcaps Dotz, hubcap Defender, hubcaps DO716-S, hubcaps DO716-B, caps rims Dotz, dotz hubcap, dotz hubcap, dotz hubcap silver, dotz hubcap silver, Defender Dotz hubcap"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "e274d2880b6648808c9026b6d5fa8be2",
"autoIncrement": 765.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 12,
"productNumber": "NA-205050",
"ean": null,
"displayGroup": "fd2ebdefbd0b68819ecb02e5ca90dd06",
"sales": 0,
"stock": 12,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1843652dadb745df81d87fa1d5b929a7",
"manufacturerNumber": null,
"deliveryTimeId": "aa4ebf35a1294ea7933bda0a921be17b",
"releaseDate": null,
"createdAt": "2015-11-01T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"018b5c698aca709e974fe3f7db35cead",
"783dd49eb257410481619fd360189486",
"126bea7ed87c44c8a97b32b72a089ab6",
"574c8f322c8045ff901f4585c15cdcfb",
"eeef5800b5dc4cea958feeefe6657b39",
"3ac1a37477164905999ddc5e75802f91",
"2f639e090613474a96f27a62a29641f6",
"b5fc7ad46da94523bbb7ecea3ca095fb",
"c4473f8c6faa4f29a133ab9d82199b38"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "018b5c698aca709e974fe3f7db35cead",
"_count": 1
},
{
"id": "783dd49eb257410481619fd360189486",
"_count": 1
},
{
"id": "126bea7ed87c44c8a97b32b72a089ab6",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "eeef5800b5dc4cea958feeefe6657b39",
"_count": 1
},
{
"id": "3ac1a37477164905999ddc5e75802f91",
"_count": 1
},
{
"id": "2f639e090613474a96f27a62a29641f6",
"_count": 1
},
{
"id": "b5fc7ad46da94523bbb7ecea3ca095fb",
"_count": 1
},
{
"id": "c4473f8c6faa4f29a133ab9d82199b38",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "2d32f11f5562474e854a9d9d43a47a33",
"childCount": 0,
"categories": [
{
"id": "2f639e090613474a96f27a62a29641f6",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land Rover Defender u. Discovery"
}
},
{
"id": "b5fc7ad46da94523bbb7ecea3ca095fb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Accessories"
}
},
{
"id": "c4473f8c6faa4f29a133ab9d82199b38",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Accessories",
"5059dc45b5104c368cc2a7f890b80123": "Accessories"
}
}
],
"manufacturer": {
"id": "1843652dadb745df81d87fa1d5b929a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nakatanenga",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": "aa4ebf35a1294ea7933bda0a921be17b",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-10 Werktage",
"5059dc45b5104c368cc2a7f890b80123": "5-10 working days"
},
"_count": 1
},
"properties": [
{
"id": "018b00438f8c7dffbc38f1aa32164fc0",
"_count": 1,
"groupId": "018b0041cf2973db9b1541aba7036caf",
"group": {
"id": "018b0041cf2973db9b1541aba7036caf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land Rover",
"5059dc45b5104c368cc2a7f890b80123": "Land Rover"
}
},
{
"id": "018b201bcc6d70bda9ce09b9944a4aeb",
"_count": 1,
"groupId": "018b201a27567e829cf6980419de7cd1",
"group": {
"id": "018b201a27567e829cf6980419de7cd1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Accessories"
}
}
],
"options": [],
"categoryIds": [
"2f639e090613474a96f27a62a29641f6",
"b5fc7ad46da94523bbb7ecea3ca095fb",
"c4473f8c6faa4f29a133ab9d82199b38"
],
"optionIds": [],
"propertyIds": [
"018b00438f8c7dffbc38f1aa32164fc0",
"018b201bcc6d70bda9ce09b9944a4aeb"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr1": "0",
"migration_MigrationSW501092023V_product_attr2": "0",
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": false,
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr11": "NEW",
"migration_MigrationSW501092023V_product_attr14": false,
"migration_MigrationSW501092023V_product_attr15": false,
"migration_MigrationSW501092023V_product_attr16": true,
"migration_MigrationSW501092023V_product_attr19": false,
"migration_MigrationSW501092023V_product_icue_pseudoprice": 0.0,
"migration_MigrationSW501092023V_product_icue_min_order_exception": false,
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_pixel_is_confianfrage": false,
"migration_MigrationSW501092023V_product_deposit": 0.0,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dotz Nabenkappe",
"5059dc45b5104c368cc2a7f890b80123": "Dotz hub cap "
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zuverlässiger Schutz für die Radnabe\nFür Land Rover Defender Felge DO716Material: Edelstahl verchromt, Preis pro Stück",
"5059dc45b5104c368cc2a7f890b80123": "Reliable protection for the wheel hub\nFor Land Rover Defender wheel DO716\n \nMaterial: Chrome-plated stainless steel,\n \nPrice per piece"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Dotz Nabenkappe - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Dotz hub cap - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f f\u00fcr Land Rover Defender Felgen (DO716-S und DO716-B) \u2714\ufe0f Material: Edelstahl \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f Land Rover Defender rims (DO716-S and DO716-B) \u2714\ufe0f material: stainless steel \u2714\ufe0f best quality \u2714\ufe0f fast shipping"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"hubcaps DO716-S",
"hubcaps DO716-B"
],
"5059dc45b5104c368cc2a7f890b80123": [
"hubcaps DO716-S",
"hubcaps DO716-B"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 55.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 46.2185,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.0,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 41.1765,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 55.0,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 46.2185,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 55.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 46.2185,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "na-205050"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "dotz"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "nabenkappe"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "dotz nabenkappe"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 dotz nabenkappe - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "dotz"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "hub"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "cap"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "dotz hub cap "
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 dotz hub cap - available here!"
}
]
},
"fields": {
"displayGroup": [
"fd2ebdefbd0b68819ecb02e5ca90dd06"
]
},
"sort": [
0,
"e274d2880b6648808c9026b6d5fa8be2"
]
}
]
},
"aggregations": {
"total-count": {
"value": 33
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.47 ms |
Request:
{"index":"dev_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_08d2beb617754d2e9b8813e67fbd3a10":{"gte":30}}}]}},{"term":{"categoryTree":"b5fc7ad46da94523bbb7ecea3ca095fb"}},{"exists":{"field":"displayGroup"}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"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_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://localhost:9200/dev_product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"must": [
{
"term": {
"active": true
}
},
{
"range": {
"visibility_08d2beb617754d2e9b8813e67fbd3a10": {
"gte": 30
}
}
}
]
}
},
{
"term": {
"categoryTree": "b5fc7ad46da94523bbb7ecea3ca095fb"
}
},
{
"exists": {
"field": "displayGroup"
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must": [
{
"term": {
"isCloseout": true
}
},
{
"term": {
"available": false
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"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_rule76a1b37a7dbf4165b46c7ab2ff1a4841_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule56b8897938be44a48f5d23076fee8aa4_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5053d723cbcc2ffca7e2f1d37_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50593737ca9f4a6695a28df19_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b505a971d6b33bc2b7f77ff188_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b50779728dbd34b221819dbf1f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179b5077e722793b82b3113582988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019266bd95457bad916f0e7402a76e90_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule89396462b19442de853b499f33b78cef_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule8a3d72aab5a5468fa089505163f644f9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulef9da93f84ada4ccd8efd95692a615991_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule06c3e6c40cde40fb88ada175db3b7938_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed59dd72ecb5248c3701a4a9a7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a33735dadfaae7d48ee3774_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5a7373caa742a3ca2b474faa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5abc7260ba0d7f86a5f49012_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ae473cc8acbdbd09e697f1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5afd73938316ce5d62b21885_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b3472fb8689bff52c36d24e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b47710cbb88d4cabe575530_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b657021952452aa52c2f262_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5b887386bf07cbfb0c6dc4d9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5bb77063b42436de2bb2654d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5be971dfb78ef0b9ab954636_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c0f732b83a6fa611b17c9b0_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c1c72e1bd5dd45fa91ae988_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c48709db0bb1d772acb893a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c61739288a8f19f5fee5c9f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5c83710a9f725ed88fa40977_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5cb47127996aaac8a7f6bdbe_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5ce97102b94464fe862ca787_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5d78715b957280e0dd517331_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e047192aaa473cfc729c45f_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5e987014b27850d1f01683cb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5eb972a9811e6559447a6fdc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f01707fbf3a6adca420f5b1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5f4a728eb343c4ceca55df24_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed5fc1716ab9e26008508a989e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed601171ca8bcbf7c4e4b15d12_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed604073a8a7cc7283597bc561_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6086727a8ed87d86b79ab028_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed60bb7173b3c5caa2b21a03e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed611b719b8c493426397e071b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed616973d6ae87df29ca6fab45_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed617970548b9ab2028aaccee3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed61d27021a6d3f256f1fe6301_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6233707282cee72b0a78165c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed629f739f81ef49fbfd3175b8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed630d72bfb80b0b616e56f094_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed632870c88f4d50e0091bdc8d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed6337724eaaf100fe723a9c73_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63797281ae1e4a20fee27b7e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63a670b0b0b52d88b864e4db_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63dc70b69dd94cbfea630307_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule019179ed63ff71859ac60b2064da4af9_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"rating-exists": {
"filter": {
"range": {
"ratingAverage": {
"gte": 0.0
}
}
},
"aggregations": {
"rating": {
"max": {
"field": "ratingAverage"
}
}
}
},
"shipping-free-filter": {
"filter": {
"term": {
"shippingFree": true
}
},
"aggregations": {
"shipping-free": {
"max": {
"field": "shippingFree"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
{
"took": 2,
"timed_out": false,
"terminated_early": true,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 43,
"rating": {
"value": 0.0
}
},
"price": {
"count": 43,
"min": 2.0,
"max": 253.0,
"avg": 47.943953488372095,
"sum": 2061.59
},
"options": {
"doc_count": 16,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0a2823d99c104b65ae6e169277a1eaba",
"doc_count": 2
},
{
"key": "01912bf711257082a8a07fbeded9a18b",
"doc_count": 1
},
{
"key": "01912bf74fab736d98fb2209dff03e4c",
"doc_count": 1
},
{
"key": "075eba7764ec4bb0903a2d0cf9fbeaa4",
"doc_count": 1
},
{
"key": "29c887aa711d48e29a39ad66773f4ee9",
"doc_count": 1
},
{
"key": "35428a8350b243b28c4121de07f9c349",
"doc_count": 1
},
{
"key": "572fb17301f3415793e074f819e891d4",
"doc_count": 1
},
{
"key": "6e5a61b6607c4ce782066d85f9e767dd",
"doc_count": 1
},
{
"key": "b6133fa65ce1499b9271d6e836bafc27",
"doc_count": 1
},
{
"key": "cc59969f349e4025bdd3442e7f8bb798",
"doc_count": 1
},
{
"key": "d40b31179aea4464b7529f9cadb47975",
"doc_count": 1
},
{
"key": "e48e2dec6da14e1f867cc2a82bda8936",
"doc_count": 1
},
{
"key": "ecec8e922e7e45ddafa784b078920ace",
"doc_count": 1
},
{
"key": "fa0eafd3d8254f55a97b29cbca1d1a2d",
"doc_count": 1
},
{
"key": "fae036ea2c1c41e792c1b3149947a873",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 93,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018b201bcc6d70bda9ce09b9944a4aeb",
"doc_count": 43
},
{
"key": "018b00438f8c7dffbc38f1aa32164fc0",
"doc_count": 18
},
{
"key": "018b1038f12c7e7895e607e84da8e899",
"doc_count": 16
},
{
"key": "018b201b9485714b8b44998b55acda08",
"doc_count": 4
},
{
"key": "018b201d97c8785b9d79c70cf46e7e08",
"doc_count": 3
},
{
"key": "018b201d105c7c55aa046b09ffacb0f3",
"doc_count": 2
},
{
"key": "018b25255d837c72ba5861e5bacc3794",
"doc_count": 2
},
{
"key": "018b0044564a772f89b1b593aa0934d8",
"doc_count": 1
},
{
"key": "018b058defc57c7d9c9e63993c39d2a3",
"doc_count": 1
},
{
"key": "018b201ca9367ecd8b4001a514a913d2",
"doc_count": 1
},
{
"key": "018b2963612b745e84a7442d0ea5e05e",
"doc_count": 1
},
{
"key": "018b5c9eba8f72798f1bfee38337f3de",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1843652dadb745df81d87fa1d5b929a7",
"doc_count": 37
},
{
"key": "01912bf68c417208afbf6067addf7d78",
"doc_count": 3
},
{
"key": "01912bf63870707981e96fc8deb7ec93",
"doc_count": 2
},
{
"key": "01912bf611197149ad6220e9e7862455",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|