| 1 |
3.93 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"ab348476a781480cbbd37a8d957c4158"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["5494b24b09d445ebace47112836b4458","de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 4,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0c6933a1cedc4056872439885e109f73",
"_score": null,
"_source": {
"id": "0c6933a1cedc4056872439885e109f73",
"autoIncrement": 57978.0,
"ratingAverage": 5.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": true,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21bmw041.3",
"ean": "4260529059149",
"displayGroup": "faa3afd94eb948b6a59645cf4af0699e",
"sales": 0,
"stock": 0,
"weight": 2.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "646a267d69f4486397b4b5b003bb1bcd",
"manufacturerNumber": "197832225",
"releaseDate": null,
"createdAt": "2019-04-11T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"2daa281a7e65442d951335cb94a64bf1",
"19b76b26ada34a29bba967b9a10943bd",
"ab348476a781480cbbd37a8d957c4158"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "2daa281a7e65442d951335cb94a64bf1",
"_count": 1
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1
},
{
"id": "ab348476a781480cbbd37a8d957c4158",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "d0f8b66f58ea46fd901ae100a73c319e",
"coverId": "55f35630454849d0bbb8c742877ae28b",
"childCount": 0,
"categories": [
{
"id": "ab348476a781480cbbd37a8d957c4158",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "N54",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N54",
"5494b24b09d445ebace47112836b4458": "N54"
}
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados Mahle",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mahle Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "Mahle pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "Mahle Sport Pistons"
}
}
],
"manufacturer": {
"id": "646a267d69f4486397b4b5b003bb1bcd",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mahle",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Mahle"
},
"_count": 1
},
"properties": [
{
"id": "086676afa3924ed18e3e0b03ec007781",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E60, E61 | BJ 2003-2010",
"5494b24b09d445ebace47112836b4458": "E60, E61 | ANN\u00c9E 2003-2010",
"de44571ddc4e4d0095c01af6ee299351": "E60, E61 | Year built 2003-2010"
}
},
{
"id": "098421d418514aaa88ab9f739150c4a2",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "E90 | Year built 2005-2013",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E90 \/ E91 \/ E92 \/ E93 | BJ 2005-2013",
"5494b24b09d445ebace47112836b4458": "E90 \/ E91 \/ E92 \/ E93 | ANN\u00c9E 2005-2013"
}
},
{
"id": "0984e30d8271435da9c1925ab1cd7558",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E71 | BJ 2008-2014",
"5494b24b09d445ebace47112836b4458": "E71 | ANN\u00c9E 2008-2014",
"de44571ddc4e4d0095c01af6ee299351": "E71 | Year built 2008-2014"
}
},
{
"id": "191c688d585e4282b3250801077e939c",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1er",
"5494b24b09d445ebace47112836b4458": "1er",
"de44571ddc4e4d0095c01af6ee299351": "1er"
}
},
{
"id": "1beaee41329e45ca921852acada77941",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Z4",
"5494b24b09d445ebace47112836b4458": "Z4",
"de44571ddc4e4d0095c01af6ee299351": "Z4"
}
},
{
"id": "2815ba1cb6884134b0e7c15831dc936a",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BMW",
"5494b24b09d445ebace47112836b4458": "BMW",
"de44571ddc4e4d0095c01af6ee299351": "BMW"
}
},
{
"id": "410ffd142db24b8791e61fa669159f0d",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N54B30 | 306 PS (225 kW)",
"5494b24b09d445ebace47112836b4458": "N54B30 | 306 ch (225 kW)",
"de44571ddc4e4d0095c01af6ee299351": "N54B30 | 306 hp (225 kW)"
}
},
{
"id": "427a8249db384517bec72aad5a9d19a5",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "X6",
"5494b24b09d445ebace47112836b4458": "X6",
"de44571ddc4e4d0095c01af6ee299351": "X6"
}
},
{
"id": "8907b384ccc04f7c8dc4b471b2f96b70",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "5",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5er",
"de44571ddc4e4d0095c01af6ee299351": "5er"
}
},
{
"id": "89e27fc400284962b6cba792c8d0ec01",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E89 | BJ 2009-2016",
"5494b24b09d445ebace47112836b4458": "E89 | ANN\u00c9E 2009-2016",
"de44571ddc4e4d0095c01af6ee299351": "E89 | Year built 2009-2016"
}
},
{
"id": "918a611e68294e8baed8fd171708e1bf",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "xDrive35i",
"5494b24b09d445ebace47112836b4458": "xDrive35i",
"de44571ddc4e4d0095c01af6ee299351": "xDrive35i"
}
},
{
"id": "a7e69cf7b5754929b197a48c2264e95c",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "335i",
"5494b24b09d445ebace47112836b4458": "335i",
"de44571ddc4e4d0095c01af6ee299351": "335i"
}
},
{
"id": "b4c4eccd8fc447e6bbeef593e01d66de",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "535i",
"5494b24b09d445ebace47112836b4458": "535i",
"de44571ddc4e4d0095c01af6ee299351": "535i"
}
},
{
"id": "c78cd15bfd5244e7be7bde07f1f91806",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "M135i",
"5494b24b09d445ebace47112836b4458": "M135i",
"de44571ddc4e4d0095c01af6ee299351": "M135i"
}
},
{
"id": "d5ea3706be974ca088e7c588d7af5a54",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Typ E87 | BJ 2004-2013",
"5494b24b09d445ebace47112836b4458": "Type E87 | BJ 2004-2013",
"de44571ddc4e4d0095c01af6ee299351": "Type E87 | Year built 2004-2013"
}
},
{
"id": "edc43711c97d461f8d4a460496b80d90",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "3",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3er",
"de44571ddc4e4d0095c01af6ee299351": "3er"
}
},
{
"id": "f7853e1cd3eb418bb426c86dbb99da3e",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "sDrive35i",
"5494b24b09d445ebace47112836b4458": "sDrive35i",
"de44571ddc4e4d0095c01af6ee299351": "sDrive35i"
}
}
],
"options": [
{
"id": "aea6a52aefed4ecc8fa101882c4d30cb",
"_count": 1,
"groupId": "b10fe7537cdc43c79c70604a9ccae0b2",
"group": {
"id": "b10fe7537cdc43c79c70604a9ccae0b2",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "84,50 mm | 10,3:1",
"5494b24b09d445ebace47112836b4458": "84,50 mm | 10,3:1",
"de44571ddc4e4d0095c01af6ee299351": "84,50 mm | 10,3:1"
}
}
],
"categoryIds": [
"19b76b26ada34a29bba967b9a10943bd",
"ab348476a781480cbbd37a8d957c4158"
],
"optionIds": [
"aea6a52aefed4ecc8fa101882c4d30cb"
],
"propertyIds": [
"086676afa3924ed18e3e0b03ec007781",
"098421d418514aaa88ab9f739150c4a2",
"0984e30d8271435da9c1925ab1cd7558",
"191c688d585e4282b3250801077e939c",
"1beaee41329e45ca921852acada77941",
"2815ba1cb6884134b0e7c15831dc936a",
"410ffd142db24b8791e61fa669159f0d",
"427a8249db384517bec72aad5a9d19a5",
"8907b384ccc04f7c8dc4b471b2f96b70",
"89e27fc400284962b6cba792c8d0ec01",
"918a611e68294e8baed8fd171708e1bf",
"a7e69cf7b5754929b197a48c2264e95c",
"b4c4eccd8fc447e6bbeef593e01d66de",
"c78cd15bfd5244e7be7bde07f1f91806",
"d5ea3706be974ca088e7c588d7af5a54",
"edc43711c97d461f8d4a460496b80d90",
"f7853e1cd3eb418bb426c86dbb99da3e"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "22 mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Komplettes Set",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "bmw-n54b30-schmiedekolben-mahle-kolben",
"migration_Shopware5DB_product_dreisc_seo_title": "Mahle Schmiedekolben-Satz f\u00fcr deinen BMW 135i, 335i, z4 35i etc.",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "22 mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Komplettes Set",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Mahle Schmiedekolben-Satz f\u00fcr deinen BMW 135i, 335i, z4 35i etc.",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "High performance piston",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "22 mm piston pin",
"migration_Shopware5DB_product_bullet3": "Extremely light",
"migration_Shopware5DB_product_bullet4": "Complete set",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "bmw-n54b30-high-performance-pistons-kit-je",
"migration_Shopware5DB_product_dreisc_seo_title": "Mahle Schmiedekolben-Satz f\u00fcr deinen BMW 135i, 335i, z4 35i etc.",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mahle Schmiedekolben-Satz passend f\u00fcr BMW N54B30 x35i\/x40i",
"5494b24b09d445ebace47112836b4458": "Jeu de pistons forg\u00e9s Mahle convenant \u00e0 BMW N54B30 x35i\/x40i",
"de44571ddc4e4d0095c01af6ee299351": "Mahle forged piston set suitable for BMW N54B30 x35i\/x40i"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von Mahle Motorsport f\u00fcr deinen BMW E80, E90, E89 und F01 3.0L 24V-Motoren mit dem Motorcode N54B30 wie im 135i, 335i, 740i und z4 35i.\nEine spezielle Legierung und spezielle Ringzonen sorgen f\u00fcr ein geringes Laufspiel und ein geringes Blow-by. Dadurch erreichst du beste Ergebnisse beim Tuning und eine Menge Spa\u00df beim Fahren!\nFeatures:\n\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\n22 mm Kolbenbolzen\nAnti-Friction Grafit-Beschichtung\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nin verschiedenen Bohrungen erh\u00e4ltlich\n\nDie angegebene Kompression ist in Verbindung mit einer Serienzylinderkopfdichtung. Da die Serienpleuel einer Leistungssteigerung ab 500 PS nicht standhalten, empfehlen wir Stahlpleuel zu verwenden.\n(Abbildung \u00e4hnlich)",
"5494b24b09d445ebace47112836b4458": "Pistons forg\u00e9s haute performance de Mahle Motorsport pour vos moteurs BMW E80, E90, E89 et F01 3.0L 24V avec le code moteur N54B30 comme dans les 135i, 335i, 740i et z4 35i.\nUn alliage sp\u00e9cial et des zones annulaires sp\u00e9ciales assurent un faible jeu de fonctionnement et un faible soufflage. Cela vous donne les meilleurs r\u00e9sultats de r\u00e9glage et beaucoup de plaisir \u00e0 conduire !\nCaract\u00e9ristiques :\n\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\nAxe de piston de 22 mm\nRev\u00eatement anti-friction en graphite\nEnsemble complet comprenant l'axe de piston, les segments et les clips\nAl\u00e9sage standard 84,00mm\n\nLa compression indiqu\u00e9e est en rapport avec un joint de culasse en s\u00e9rie. Comme les bielles standard ne peuvent pas supporter une augmentation de puissance \u00e0 partir de 500 HP, nous recommandons d'utiliser des bielles en acier.\n(Image similaire)",
"de44571ddc4e4d0095c01af6ee299351": "Forged high-performance pistons from Mahle Motorsport for your BMW E80, E90, E89 and F01 3.0L 24V engines with the engine code N54B30 as in the 135i, 335i, 740i and z4 35i.\nA special alloy and special ring zones ensure a low running clearance and a low blowby. This will give you the best tuning results and a lot of driving fun!\nfeatures:\n\nExtremely light due to special alloy\nReinforced for maximum performance\n22mm piston pin\nAnti-friction graphite coating\nComplete set incl. Piston pin, rings and clips\nInstallation and drilling dimensions are included\nThe specified compression is in conjunction with a standard cylinder head gasket.\n\nSince the standard conrods are not able to perform 500 hp or more, we recommend strong H-shaft conraods.\n(picture similar)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BMW E36 M3 S50B30 Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "\u2063Mahle High Performance Pistons-Kit for your BMW 135i, 335i or z4 35i"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochleistungskolben f\u00fcr BMW 3.0L 24V-Motoren N54 \u2713 25 Jahre Motorsport-Erfahrung \u2713 Schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "High performance piston for BMW 3.0L 24V engines N54. \u2713 15 years of motorsport experience \u2713 Fast shipping \u2713 BAR-TEK\u00ae approved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1103.81,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 927.57142857143,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1061.19,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 891.75630252101,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1138.6,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 956.80672268908,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1309.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1100.8067226891,
"shop-customer": "1100.8067226891",
"b-dealer": "927.57142857143",
"a-dealer": "891.75630252101",
"c-dealer": "956.80672268908"
},
"fields": {
"displayGroup": [
"faa3afd94eb948b6a59645cf4af0699e"
]
},
"sort": [
"",
0,
"0c6933a1cedc4056872439885e109f73"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.33 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"ab348476a781480cbbd37a8d957c4158"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "ab348476a781480cbbd37a8d957c4158"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|