| 1 |
7.27 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":"a72aad1d6b4a4bb296cd16004955658e"}},{"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": 2,
"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": "69c04f4b333e42e7a6a7c889182d101b",
"_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": "018e79e3842e732db3c885c29889e7e0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel"
}
},
{
"id": "f5860c3e14c344539f9bfb0ca0a2b5aa",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das k\u00f6nnte Sie auch interessieren"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankdeckelklappe, Abdeckung Tankdeckel, Kraftstoffschutz, Trekfinder Tankdeckel, Treckfinder, TD4, TD5, Land Rover Defender, Tankschutz, Schutzklappe, Trekfinder, Verschlei\u00dfteil Trekfinder, Ersatzteil Trekfinder, ",
"5059dc45b5104c368cc2a7f890b80123": "Fuel filler flap, Fuel filler cap cover, Fuel protector, Trekfinder fuel filler cap, Trekfinder, TD4, TD5, Land Rover Defender, Fuel filler protector, Protective flap, Trekfinder, Wear part Trekfinder, Spare part Trekfinder,"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "St\u00fcck",
"5059dc45b5104c368cc2a7f890b80123": "Piece"
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "69c04f4b333e42e7a6a7c889182d101b",
"autoIncrement": 5054.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 472,
"productNumber": "1-LRDETAK",
"ean": null,
"displayGroup": "aecb5cd75882bd93470b5590295ffa36",
"sales": 132,
"stock": 472,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "01912bf611197149ad6220e9e7862455",
"manufacturerNumber": null,
"deliveryTimeId": "aa4ebf35a1294ea7933bda0a921be17b",
"releaseDate": null,
"createdAt": "2021-06-10T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"5aa5729c95404d31837be01faa113843",
"af39c257ae084b90a93f97795f9d277e",
"574c8f322c8045ff901f4585c15cdcfb",
"57073e55ab544d4f8c23b2c9b8e7d21c",
"e6dd4e6e71cd473280b8f12d9465a13a",
"94b396a795d942d69c88d75c07c9d994",
"018b5c698aca709e974fe3f7db35cead",
"330b1746d7004a3bbc959d5889bab9cd",
"7cecfd5f7db24668a16e579a3a8c29aa",
"a72aad1d6b4a4bb296cd16004955658e",
"bd880cbba8794f43a9bf3b0698c68922"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "5aa5729c95404d31837be01faa113843",
"_count": 1
},
{
"id": "af39c257ae084b90a93f97795f9d277e",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "57073e55ab544d4f8c23b2c9b8e7d21c",
"_count": 1
},
{
"id": "e6dd4e6e71cd473280b8f12d9465a13a",
"_count": 1
},
{
"id": "94b396a795d942d69c88d75c07c9d994",
"_count": 1
},
{
"id": "018b5c698aca709e974fe3f7db35cead",
"_count": 1
},
{
"id": "330b1746d7004a3bbc959d5889bab9cd",
"_count": 1
},
{
"id": "7cecfd5f7db24668a16e579a3a8c29aa",
"_count": 1
},
{
"id": "a72aad1d6b4a4bb296cd16004955658e",
"_count": 1
},
{
"id": "bd880cbba8794f43a9bf3b0698c68922",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "01917f485cef7a409544dca6df2593fc",
"name": "Verkaufsartikel",
"_count": 1
}
],
"parentId": null,
"coverId": "8299401f269449ca859738136c27f570",
"childCount": 0,
"categories": [
{
"id": "330b1746d7004a3bbc959d5889bab9cd",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land Rover Defender u. Discovery"
}
},
{
"id": "7cecfd5f7db24668a16e579a3a8c29aa",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuel Tank Protection",
"5059dc45b5104c368cc2a7f890b80123": "Fuel Tank Protection"
}
},
{
"id": "a72aad1d6b4a4bb296cd16004955658e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankschutz",
"5059dc45b5104c368cc2a7f890b80123": "Tank protection"
}
},
{
"id": "bd880cbba8794f43a9bf3b0698c68922",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatz- und Verschlei\u00dfteile",
"5059dc45b5104c368cc2a7f890b80123": "Spare Parts and Consumables"
}
}
],
"manufacturer": {
"id": "01912bf611197149ad6220e9e7862455",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STOCK & STEIN GmbH",
"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": "018b0fc624d67f7b9d9be149424ffdaa",
"_count": 1,
"groupId": "018b0fc52b147d27b8d544e3664b9891",
"group": {
"id": "018b0fc52b147d27b8d544e3664b9891",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankschutz",
"5059dc45b5104c368cc2a7f890b80123": "Tank protection"
}
}
],
"options": [],
"categoryIds": [
"330b1746d7004a3bbc959d5889bab9cd",
"7cecfd5f7db24668a16e579a3a8c29aa",
"a72aad1d6b4a4bb296cd16004955658e",
"bd880cbba8794f43a9bf3b0698c68922"
],
"optionIds": [],
"propertyIds": [
"018b00438f8c7dffbc38f1aa32164fc0",
"018b0fc624d67f7b9d9be149424ffdaa"
],
"tagIds": [
"01917f485cef7a409544dca6df2593fc"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr1": "0",
"migration_MigrationSW501092023V_product_attr2": "0",
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr13": "'0'",
"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": "TREKFINDER Tankdeckel Abdeckung f\u00fcr Land Rover Defender bis Baujahr 2016",
"5059dc45b5104c368cc2a7f890b80123": "TREKFINDER Fuel Cap Cover for Land Rover Defender until MY2016"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TREKFINDER Tankdeckel Abdeckung f\u00fcr Land Rover Defender bis Baujahr 2016\nDer versenkte Tankstutzen ohne Klappe ist so ein typisches Defender-Detail aus einer ganz anderen Zeit. Wo Otto Normal mit dem Kopf sch\u00fcttelt, freut sich der Landy-Enthusiast \u00fcber die Eigenheit und denkt dar\u00fcber nach, wie sich die offensichtlichen Nachteile der Konstruktion durch eine kleine Mod beheben lassen. So eine sinnvolle Modifikation gab es bei uns lange Zeit unter dem Namen Defendoor aus Tschechien. Da es nun die tschechische Firma und ihr Produkt leider nicht mehr gibt, aber noch jede Menge Bedarf an Tankabdeckungen f\u00fcr den Landy, haben wir uns mit den Spezialisten von TREKFINDER zusammengetan und das Produkt wieder aufleben lassen. Der genial simple Deckel h\u00e4lt N\u00e4sse, Schnee, Eis, Salz, Spritzwasser, Schlamm und Staub garantiert vom Tankstutzen fern und sieht dabei auch noch gut aus. Die Abdeckung f\u00fcr die Karosserie\u00f6ffnung ist aus hochwertigem, leicht flexiblem Kunststoff und wird durch die umlaufende Rille sicher in Position gehalten. Keine Schrauben, Nieten oder bewegliche Teile f\u00fcr den Einbau. Beim Tanken dann einfach gegendr\u00fccken und den Deckel l\u00f6sen. Der Kunststoff ist UV- und temperaturbest\u00e4ndig und garantiert lange Lebensdauer sowie gleichbleibende Materialeigenschaften.\nPassend f\u00fcr:Defender 110 bis 2016Defender 90 ab 1998 bis 2016\nNicht passend f\u00fcr:110 HCPU und 130 HCPU90 bis Baujahr 1997",
"5059dc45b5104c368cc2a7f890b80123": "TREKFINDER Fuel filler cap cover for Land Rover Defender\nThe recessed fuel tank cavity is a typical Defender detail, dating back to very different times. Today\u2019s average drivers would probably shake their heads in disapproval, but Landy enthusiasts will cherish the excentricity and immediately set their minds to fixing the design\u2019s obvious short-comings with a little Defender hack. For a long time, we had been able to offer one of those nifty little fixes under the product name Defendoor, made by a Czech company.Sadly, both the company and their fabulous product are no longer in existence, but since we still register a lot of demand for fueling cavity covers, we got together with Defender specialists TREKFINDER and breathed new life into the idea.The cover is as simple as it is effective when it comes to keeping out water, snow, ice, salt, spray, mud and dust. It will also add to the rugged good looks of your Defender. Made from sturdy but slightly flexible high-quality synthetics, it is kept in position by a groove running around the sides. There is no need for screws or rivets or moving parts to hold it securely in place. When fueling, simply press the cover in and remove it from the fueling cavity. The material is UV- and temperature-resistant, guaranteeing long product life and long-lasting quality.\nThe cover fits:Defender 110 up until MY2016Defender 90 from 1998 to 2016\nDoes NOT fit:110 HCPU and 130 HCPU90 until MY 1997"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Tankdeckel Abdeckung f\u00fcr Defender - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Tank cap cover for Defender - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f von TREKFINDER \u2714\ufe0f f\u00fcr Defender 110 bis MY 2016 \u2714\ufe0f f\u00fcr Defender 90 ab MY 1998 bis 2016 \u2714\ufe0f Farbe Schwarz \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand\n",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f by TREKFINDER \u2714\ufe0f for Defender 110 to MY 2016 \u2714\ufe0f for Defender 90 from MY 1998 to 2016 \u2714\ufe0f color black \u2714\ufe0f best quality \u2714\ufe0f fast shipping"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Tankdeckelklappe",
"Abdeckung Tankdeckel",
"Kraftstoffschutz",
"Trekfinder Tankdeckel",
"Treckfinder",
"TD4",
"TD5",
"Land Rover Defender",
"Tankschutz",
"Schutzklappe",
"Trekfinder",
"Verschlei\u00dfteil Trekfinder",
"Ersatzteil Trekfinder"
],
"5059dc45b5104c368cc2a7f890b80123": [
"Fuel filler flap",
"Fuel filler cap cover",
"Fuel protector",
"Trekfinder fuel filler cap",
"Trekfinder",
"TD4",
"TD5",
"Land Rover Defender",
"Fuel filler protector",
"Protective flap",
"Trekfinder",
"Wear part Trekfinder",
"Spare part Trekfinder"
]
},
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.5,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.3445,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.1261,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 15.75,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 13.2353,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 18.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 15.1261,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "1-lrdetak"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "trekfinder"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "tankdeckel"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "abdeckung"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "f\u00fcr"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "land"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "rover"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "defender"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "bis"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "baujahr"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "2016"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "trekfinder tankdeckel abdeckung f\u00fcr land rover defender bis baujahr 2016"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 tankdeckel abdeckung f\u00fcr defender - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "trekfinder"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "fuel"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "cap"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "cover"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "for"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "land"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "rover"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "defender"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "until"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "my2016"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "tank"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "trekfinder fuel cap cover for land rover defender until my2016"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 tank cap cover for defender - available here!"
}
]
},
"fields": {
"displayGroup": [
"aecb5cd75882bd93470b5590295ffa36"
]
},
"sort": [
132,
"69c04f4b333e42e7a6a7c889182d101b"
]
},
{
"_index": "dev_product_1762781623",
"_id": "955f6a9e7ba446c395a1bcf8db7c4246",
"_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": "923a8ee7dcc64548a35b8f1e7ff28f77",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00c4hnliche Artikel",
"5059dc45b5104c368cc2a7f890b80123": "Similar article"
}
}
],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tank, Schutz, Tankschutzplatte, Gel\u00e4nde, Defender 90, Defender 110, Defender 130, Defender Td5, Defender Td4, Gel\u00e4ndeeinsatz, Aluminium, defender tankschutz, Tank Schutz Defender, Platte Tank Defender, tankschutz defender td4, Defender Tankschutz",
"5059dc45b5104c368cc2a7f890b80123": "tank, protection, tank protection plate, off-road, Defender 90, Defender 110, Defender 130, Defender Td5, Defender Td4, off-road use, aluminium, defender tank protection, tank protection Defender, plate tank Defender, tank protection defender td4, Defender tank protection"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5059dc45b5104c368cc2a7f890b80123": null
},
"id": "955f6a9e7ba446c395a1bcf8db7c4246",
"autoIncrement": 5785.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "08d2beb617754d2e9b8813e67fbd3a10"
}
],
"availableStock": 0,
"productNumber": "TSPLRDEF-90",
"ean": null,
"displayGroup": "dc47ab3f17ffa485409e0f0a5a34e89c",
"sales": 1,
"stock": 0,
"weight": 7.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "1843652dadb745df81d87fa1d5b929a7",
"manufacturerNumber": null,
"deliveryTimeId": "78d910be74c84ad7a22e7c83bde5f805",
"releaseDate": "2015-12-10T00:00:00+00:00",
"createdAt": "2015-11-01T00:00:00+00:00",
"categoryTree": [
"e95720b66e054265932a3d4f1d75ea24",
"018b5c698aca709e974fe3f7db35cead",
"574c8f322c8045ff901f4585c15cdcfb",
"57073e55ab544d4f8c23b2c9b8e7d21c",
"e6dd4e6e71cd473280b8f12d9465a13a",
"becc0d51b8af40cf8aed0eeb6388e45f",
"5aa5729c95404d31837be01faa113843",
"94b396a795d942d69c88d75c07c9d994",
"eeef5800b5dc4cea958feeefe6657b39",
"338c9cb9d866425985f97bca5df6ba5e",
"7cecfd5f7db24668a16e579a3a8c29aa",
"9ab8c2335f44419683a3cad9d72527f0",
"a72aad1d6b4a4bb296cd16004955658e",
"b8904218ee3f42ea9400b4c580877e44",
"bd880cbba8794f43a9bf3b0698c68922"
],
"categoriesRo": [
{
"id": "e95720b66e054265932a3d4f1d75ea24",
"_count": 1
},
{
"id": "018b5c698aca709e974fe3f7db35cead",
"_count": 1
},
{
"id": "574c8f322c8045ff901f4585c15cdcfb",
"_count": 1
},
{
"id": "57073e55ab544d4f8c23b2c9b8e7d21c",
"_count": 1
},
{
"id": "e6dd4e6e71cd473280b8f12d9465a13a",
"_count": 1
},
{
"id": "becc0d51b8af40cf8aed0eeb6388e45f",
"_count": 1
},
{
"id": "5aa5729c95404d31837be01faa113843",
"_count": 1
},
{
"id": "94b396a795d942d69c88d75c07c9d994",
"_count": 1
},
{
"id": "eeef5800b5dc4cea958feeefe6657b39",
"_count": 1
},
{
"id": "338c9cb9d866425985f97bca5df6ba5e",
"_count": 1
},
{
"id": "7cecfd5f7db24668a16e579a3a8c29aa",
"_count": 1
},
{
"id": "9ab8c2335f44419683a3cad9d72527f0",
"_count": 1
},
{
"id": "a72aad1d6b4a4bb296cd16004955658e",
"_count": 1
},
{
"id": "b8904218ee3f42ea9400b4c580877e44",
"_count": 1
},
{
"id": "bd880cbba8794f43a9bf3b0698c68922",
"_count": 1
}
],
"taxId": "d97cf5cff5d945aa8624948165e25887",
"tags": [
{
"id": "019189a28a2c700fbbc93e2d074fa990",
"name": "alter Artikel",
"_count": 1
}
],
"parentId": "5bde485220a74e1c990adb88b0c6807b",
"coverId": "018e79deb66c717bab022ef776a11529",
"childCount": 0,
"categories": [
{
"id": "338c9cb9d866425985f97bca5df6ba5e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tanks und Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Tanks and accessories"
}
},
{
"id": "7cecfd5f7db24668a16e579a3a8c29aa",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuel Tank Protection",
"5059dc45b5104c368cc2a7f890b80123": "Fuel Tank Protection"
}
},
{
"id": "9ab8c2335f44419683a3cad9d72527f0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "alte Artikel"
}
},
{
"id": "a72aad1d6b4a4bb296cd16004955658e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankschutz",
"5059dc45b5104c368cc2a7f890b80123": "Tank protection"
}
},
{
"id": "b8904218ee3f42ea9400b4c580877e44",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tanks and Accessories",
"5059dc45b5104c368cc2a7f890b80123": "Tanks and Accessories"
}
},
{
"id": "bd880cbba8794f43a9bf3b0698c68922",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ersatz- und Verschlei\u00dfteile",
"5059dc45b5104c368cc2a7f890b80123": "Spare Parts and Consumables"
}
}
],
"manufacturer": {
"id": "1843652dadb745df81d87fa1d5b929a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nakatanenga",
"5059dc45b5104c368cc2a7f890b80123": null
},
"_count": 1
},
"deliveryTime": {
"id": "78d910be74c84ad7a22e7c83bde5f805",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20-25 Werktage",
"5059dc45b5104c368cc2a7f890b80123": "20-25 working days"
},
"_count": 1
},
"properties": [
{
"id": "018b0fc624d67f7b9d9be149424ffdaa",
"_count": 1,
"groupId": "018b0fc52b147d27b8d544e3664b9891",
"group": {
"id": "018b0fc52b147d27b8d544e3664b9891",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankschutz",
"5059dc45b5104c368cc2a7f890b80123": "Tank protection"
}
},
{
"id": "018b1038f12c7e7895e607e84da8e899",
"_count": 1,
"groupId": "018b0041cf2973db9b1541aba7036caf",
"group": {
"id": "018b0041cf2973db9b1541aba7036caf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land-Rover New-Defender",
"5059dc45b5104c368cc2a7f890b80123": "Land Rover New Defender"
}
},
{
"id": "018b5c9032a27889823ddd7f2e6f2a36",
"_count": 1,
"groupId": "018b5c8fbb9578aa9b18f289ad01270d",
"group": {
"id": "018b5c8fbb9578aa9b18f289ad01270d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tanks und Zubeh\u00f6r",
"5059dc45b5104c368cc2a7f890b80123": "Tanks and accessories"
}
}
],
"options": [
{
"id": "b2b8929977464206b6138d21b324fbd8",
"_count": 1,
"groupId": "64c88545d0ab48cba477f9dd058083a7",
"group": {
"id": "64c88545d0ab48cba477f9dd058083a7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Land Rover Defender 90"
}
}
],
"categoryIds": [
"338c9cb9d866425985f97bca5df6ba5e",
"7cecfd5f7db24668a16e579a3a8c29aa",
"9ab8c2335f44419683a3cad9d72527f0",
"a72aad1d6b4a4bb296cd16004955658e",
"b8904218ee3f42ea9400b4c580877e44",
"bd880cbba8794f43a9bf3b0698c68922"
],
"optionIds": [
"b2b8929977464206b6138d21b324fbd8"
],
"propertyIds": [
"018b0fc624d67f7b9d9be149424ffdaa",
"018b1038f12c7e7895e607e84da8e899",
"018b5c9032a27889823ddd7f2e6f2a36"
],
"tagIds": [
"019189a28a2c700fbbc93e2d074fa990"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_MigrationSW501092023V_product_attr6": false,
"migration_MigrationSW501092023V_product_attr7": false,
"migration_MigrationSW501092023V_product_attr8": false,
"migration_MigrationSW501092023V_product_attr9": "Artikel aus GB",
"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_kilb_article_hider_is_hidden": false,
"migration_MigrationSW501092023V_product_kilb_article_hider_is_hidden_seo": false,
"migration_MigrationSW501092023V_product_deposit": 0.0,
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "X"
},
"5059dc45b5104c368cc2a7f890b80123": {
"migration_MigrationSW501092023V_product_custom_shippingtime_y3": "X",
"migration_MigrationSW501092023V_product_attr16": true
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tankschutzplatte f\u00fcr Land Rover Defender",
"5059dc45b5104c368cc2a7f890b80123": "Tank protection plate for Land Rover Defender"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die Tankschutzplatte f\u00fcr den Land Rover Defender 90\/110\/130 der Baureihen Td5 und Td4 (2.4 und 2.2) sch\u00fctzt den Tank auf seiner gesamten Breite beim Gel\u00e4ndeeinsatz vor Beulen, Besch\u00e4digungen und Lecks. Ausfallzeiten des Fahrzeugs sowie kostspielige Umweltsch\u00e4den werden so vermieden.\nDie Tankschutzplatte l\u00e4\u00dft sich zusammen mit den g\u00e4ngigen Anh\u00e4ngerkupplungen verwenden. Sie ist aus gewichtsoptimiertem, 6mm starken, eloxiertem Aluminium gefertigt.\nBitte w\u00e4hlen Sie nachfolgend ihren Fahrzeugtyp aus.",
"5059dc45b5104c368cc2a7f890b80123": "The tank protection plate for the Land Rover Defender 90\/110\/130 of the Td5 and Td4 series (2.4 and 2.2) protects the entire width of the tank from dents, damage and leaks during off-road use. This prevents vehicle downtime and costly environmental damage.\n \nThe tank protection plate can be used in conjunction with standard trailer couplings. It is made of weight-optimised, 6 mm thick, anodised aluminium.\n \nPlease select your vehicle type below.\n \n \n "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u25b7 Tankschutzplatte f\u00fcr Land Rover Defender - hier erh\u00e4ltlich!",
"5059dc45b5104c368cc2a7f890b80123": "\u25b7 Tank protection plate for Land Rover Defender - available here!"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u21aa\ufe0f Tankschutzplatte f\u00fcr Defender 90\/110\/130 der Baureihen Td5 und Td4 sch\u00fctzt den Tank auf seiner gesamten Breite \u2714\ufe0f beste Qualit\u00e4t \u2714\ufe0f schneller Versand",
"5059dc45b5104c368cc2a7f890b80123": "\u21aa\ufe0f Tank protection plate for Defender 90\/110\/130 of the Td5 and Td4 series protects the tank across its entire width \u2714\ufe0f best quality \u2714\ufe0f fast shipping\n"
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Tank",
"Schutz",
"Tankschutzplatte",
"Gel\u00e4nde",
"Defender 90",
"Defender 110",
"Defender 130",
"Defender Td5",
"Defender Td4",
"Gel\u00e4ndeeinsatz",
"Aluminium",
"defender tankschutz",
"Tank Schutz Defender",
"Platte Tank Defender",
"tankschutz defender td4",
"Defender Tankschutz"
],
"5059dc45b5104c368cc2a7f890b80123": null
},
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 270.0,
"cheapest_price_rule892bba83aadf4e539a3c6a1446af67c3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 226.8908,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 220.0,
"cheapest_price_rule1601200eea0d4bee8c49cc14788ea44b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 184.8739,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 270.0,
"cheapest_price_rule061ab606cc7f44b4857e9b27b6a71420_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 226.8908,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 270.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 226.8908,
"visibility_08d2beb617754d2e9b8813e67fbd3a10": 30,
"warehouseGroupStockField": {
"warehouse_group_stock": null,
"parent_warehouse_group_stock": null
},
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
{
"key": "all",
"value": "tsplrdef-90"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "tankschutzplatte"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "f\u00fcr"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "land"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "rover"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "defender"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "hier"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "erh\u00e4ltlich!"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "tankschutzplatte f\u00fcr land rover defender"
},
{
"key": "2fbb5fe2e29a4d70aa5854ce7ce3e20b",
"value": "\u25b7 tankschutzplatte f\u00fcr land rover defender - hier erh\u00e4ltlich!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "tank"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "protection"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "plate"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "for"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "land"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "rover"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "defender"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "available"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "here!"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "tank protection plate for land rover defender"
},
{
"key": "5059dc45b5104c368cc2a7f890b80123",
"value": "\u25b7 tank protection plate for land rover defender - available here!"
}
]
},
"fields": {
"displayGroup": [
"dc47ab3f17ffa485409e0f0a5a34e89c"
]
},
"sort": [
1,
"955f6a9e7ba446c395a1bcf8db7c4246"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.82 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":"a72aad1d6b4a4bb296cd16004955658e"}},{"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": "a72aad1d6b4a4bb296cd16004955658e"
}
},
{
"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
|