| 1 |
3.45 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":"1c97a015acdc4c389f0128e6c18ba981"}},{"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":0,"size":32,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "dev_product_1762781623",
"_id": "0686a9af09da488abc35fe1a785ac5c5",
"_score": null,
"_source": {
"purchasePrices": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": 0.0,
"net": 0.0,
"linked": true
}
],
"referenceUnit": "0.000",
"purchaseUnit": "0.0000",
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"crossSellings": [
{
"id": "feb84fa4c8f04667adeb0c37b979c363",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Schraube f\u00fcr Defender mit NAS \u00dcberrollk\u00e4fig, Edelstahl, Schraube, Defender, NAS, \u00dcberrollk\u00e4fig, NAS \u00dcberrollk\u00e4fig, K\u00e4fig, Edelstahlschraube, Montage NAS K\u00e4fig, Montage K\u00e4fig Defender, NAS Defender, Defender \u00dcberrollb\u00fcgel, Defender \u00dcberrollk\u00e4fig",
"5059dc45b5104c368cc2a7f890b80123": "Stainless Steel Bolt for Defender NAS Roll Cage, Stainless, Steel, Bolt, Defender, NAS, Roll, Cage, defender roll cage bolts, defender roll cage bolts black, defender roll cage bolts black stainless, defender roll cage bolts stainless"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "0686a9af09da488abc35fe1a785ac5c5",
"autoIncrement": 3599.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 157,
"productNumber": "ALR5549-SS",
"ean": null,
"displayGroup": "11ed4153fa2c7b5bbef8c2b68e1bc645",
"sales": 54,
"stock": 157,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1843652dadb745df81d87fa1d5b929a7",
"manufacturerNumber": null,
"deliveryTimeId": "aa4ebf35a1294ea7933bda0a921be17b",
"releaseDate": "2015-12-10T00:00:00+00:00",
"createdAt": "2017-03-16T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"5aa5729c95404d31837be01faa113843",
"94b396a795d942d69c88d75c07c9d994",
"af39c257ae084b90a93f97795f9d277e",
"574c8f322c8045ff901f4585c15cdcfb",
"57073e55ab544d4f8c23b2c9b8e7d21c",
"ee5ee99503864756a20e85a64e9e2ca1",
"1c97a015acdc4c389f0128e6c18ba981",
"330b1746d7004a3bbc959d5889bab9cd",
"5c909719c68f4f1dbee6835b1d5ed84e"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "5aa5729c95404d31837be01faa113843",
"_count": 1
},
{
"id": "94b396a795d942d69c88d75c07c9d994",
"_count": 1
},
{
"id": "af39c257ae084b90a93f97795f9d277e",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "57073e55ab544d4f8c23b2c9b8e7d21c",
"_count": 1
},
{
"id": "ee5ee99503864756a20e85a64e9e2ca1",
"_count": 1
},
{
"id": "1c97a015acdc4c389f0128e6c18ba981",
"_count": 1
},
{
"id": "330b1746d7004a3bbc959d5889bab9cd",
"_count": 1
},
{
"id": "5c909719c68f4f1dbee6835b1d5ed84e",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": "26de51413c9a41128d0a91cdb47856fc",
"coverId": "be0e5db6c5fa495a8fbaa1a4fe6c08fa",
"childCount": 0,
"categories": [
{
"id": "1c97a015acdc4c389f0128e6c18ba981",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00dcberrollk\u00e4fige \/ Rollcage",
"5059dc45b5104c368cc2a7f890b80123": "Rollcage"
}
},
{
"id": "330b1746d7004a3bbc959d5889bab9cd",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land Rover Defender u. Discovery"
}
},
{
"id": "5c909719c68f4f1dbee6835b1d5ed84e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Screws, Fixings, Mountings",
"5059dc45b5104c368cc2a7f890b80123": "Screws, Fixings, Mountings"
}
}
],
"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": "018b0fc7bf5f7b359f067e5693be439b",
"_count": 1,
"groupId": "018b0fc52b147d27b8d544e3664b9891",
"group": {
"id": "018b0fc52b147d27b8d544e3664b9891",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00dcberrollk\u00e4fige",
"5059dc45b5104c368cc2a7f890b80123": "Roll cages"
}
}
],
"options": [
{
"id": "d71fd1c0f3044238a2f6e89432f52add",
"_count": 1,
"groupId": "8d0e108b4b6f4c6894342a2115fcef0b",
"group": {
"id": "8d0e108b4b6f4c6894342a2115fcef0b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl",
"5059dc45b5104c368cc2a7f890b80123": "Stainless steel"
}
}
],
"categoryIds": [
"1c97a015acdc4c389f0128e6c18ba981",
"330b1746d7004a3bbc959d5889bab9cd",
"5c909719c68f4f1dbee6835b1d5ed84e"
],
"optionIds": [
"d71fd1c0f3044238a2f6e89432f52add"
],
"propertyIds": [
"018b00438f8c7dffbc38f1aa32164fc0",
"018b0fc7bf5f7b359f067e5693be439b"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": true,
"migration_MigrationSW501092023V_product_attr8": false,
"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,
"twt_electric_pro_custom_field__product__custom_tab_text": "<ul class=\"content--list list--unstyled\"><li class=\"list--entry\"><a href=\"\/media\/ee\/c9\/2f\/1693556113\/merkblatt-edelstahl-rost-a5-de-en.pdf\" target=\"_blank\" rel=\"noopener\"> Merkblatt Edelstahl und Rost<\/a><\/li><\/ul>",
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "X"
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_pixel_is_configurator": false,
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "X",
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl Schraube f\u00fcr Defender NAS \u00dcberrollk\u00e4fig, einzeln",
"5059dc45b5104c368cc2a7f890b80123": "Stainless Steel Bolt for Defender NAS Roll Cage"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Edelstahl-Schraube entspricht der Land Rover Teilenummer ALR5549.\nDie Edelstahl-Schrauben sind zur Befestigung eines NAS \u00dcberrollk\u00e4figs an den Defender. Beachten Sie, dass Sie zur Montage mindestens ca. 70 Schrauben ben\u00f6tigen.\nMaterial: Edelstahl A2-80 hochfestL\u00e4nge (l): 30 mmDurchmesser (d): 10 mmTorx-Profil: TX50\nDie schwarzen Edelstahlschrauben wurden \u00fcber einen rechnergesteuerten elektrochemischen Prozess mit einer Chromoxid-Schicht \u00fcberzogen. Dadurch sind die Edelstahlschrauben auch weiterhin vor Rost gesch\u00fctzt.\nPreis pro St\u00fcck.",
"5059dc45b5104c368cc2a7f890b80123": "The Stainless Steel Bolt corresponds to the Land Rover part number ALR5549.\nWith the Stainless Steel Bolts you can mount the NAS Roll Cage to the Defender. Please mind that you need at least approx. 70 Bolts for one Roll Cage.\nMaterial: Stainless steel A2-80 high-strengthLength (l): 30 mmDiameter (d): 10 mmTorx-profile: TX50\nThe black stainless steel screws were coated with a chromium-oxide layer via a computer-controlled electrochemical process. As a result, the stainless steel screws are still protected against rust."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Edelstahl Schraube Defender mit NAS \u00dcberrollk\u00e4fig - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Stainless Steel Bolt for Defender NAS Roll Cage - shop now!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f zur Befestigung eines NAS \u00dcberrollk\u00e4figs am Defender \u2714\ufe0f entspricht LR Teilenummer ALR5549 \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f corresponds to the Land Rover part number ALR5549 \u2714\ufe0f coated with a chromium-oxide layer \u2714\ufe0f best quality \u2714\ufe0f fast shipping"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Edelstahl Schraube f\u00fcr Defender mit NAS \u00dcberrollk\u00e4fig",
"Edelstahl",
"Schraube",
"Defender",
"NAS",
"\u00dcberrollk\u00e4fig",
"NAS \u00dcberrollk\u00e4fig",
"K\u00e4fig",
"Edelstahlschraube",
"Montage NAS K\u00e4fig",
"Montage K\u00e4fig Defender",
"NAS Defender",
"Defender \u00dcberrollb\u00fcgel",
"Defender \u00dcberrollk\u00e4fig"
],
"5059dc45b5104c368cc2a7f890b80123": [
"Stainless Steel Bolt for Defender NAS Roll Cage",
"Stainless",
"Steel",
"Bolt",
"Defender",
"NAS",
"Roll",
"Cage",
"defender roll cage bolts",
"defender roll cage bolts black",
"defender roll cage bolts black stainless",
"defender roll cage bolts stainless"
]
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.83,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.5378,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.23,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.0336,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.53,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.2857,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1.83,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.5378,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "alr5549-ss"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "edelstahl"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "schraube"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "f\u00fcr"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "defender"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "nas"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u00fcberrollk\u00e4fig,"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "einzeln"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "mit"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u00fcberrollk\u00e4fig"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "edelstahl schraube f\u00fcr defender nas \u00fcberrollk\u00e4fig, einzeln"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 edelstahl schraube defender mit nas \u00fcberrollk\u00e4fig - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "stainless"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "steel"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "bolt"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "for"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "defender"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "nas"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "roll"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "cage"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "shop"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "now!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "stainless steel bolt for defender nas roll cage"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 stainless steel bolt for defender nas roll cage - shop now!"
}
]
},
"fields": {
"displayGroup": [
"11ed4153fa2c7b5bbef8c2b68e1bc645"
]
},
"sort": [
54,
"0686a9af09da488abc35fe1a785ac5c5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.14 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":"1c97a015acdc4c389f0128e6c18ba981"}},{"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": "1c97a015acdc4c389f0128e6c18ba981"
}
},
{
"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"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|