| 1 |
4.64 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.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.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":"1b0911e075ec48bc8d42a5b7749bafc4"}}}},{"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":["2f37bfd0f23f482bad9d34a02199499b","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": 2,
"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": "22f5ff2ebcc3419c9539dcb34d16373f",
"_score": null,
"_source": {
"id": "22f5ff2ebcc3419c9539dcb34d16373f",
"autoIncrement": 44064.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ni018",
"ean": null,
"displayGroup": "b5409dec4076aab207c77974b3edf8cf",
"sales": 0,
"stock": 0,
"weight": 4.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6aadff5484494e05b2cd9cd32ec57924",
"manufacturerNumber": "JE-321249",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"452be90462ed4aba9b7e282cf4694914",
"1b0911e075ec48bc8d42a5b7749bafc4",
"dd423f04067c42059fc90c7bd91c59f6"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "452be90462ed4aba9b7e282cf4694914",
"_count": 1
},
{
"id": "1b0911e075ec48bc8d42a5b7749bafc4",
"_count": 1
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "f0ae9d6b7e0842ca9d5fa657b537cdd3",
"coverId": "55e07c732eb24a25938f699be36877e5",
"childCount": 0,
"categories": [
{
"id": "1b0911e075ec48bc8d42a5b7749bafc4",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "3.5L 24V VQ35",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3.5L 24V VQ35",
"5494b24b09d445ebace47112836b4458": "3.5L 24V VQ35"
}
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones JE Pistones forjados",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JE Pistons Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "JE Pistons pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "JE Pistons"
}
}
],
"manufacturer": {
"id": "6aadff5484494e05b2cd9cd32ec57924",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JE Pistons",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "JE Pistons"
},
"_count": 1
},
"properties": [
{
"id": "0fcd0158753541ab9236a38786db112e",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VQ35DE | 280 PS (206 kW)",
"5494b24b09d445ebace47112836b4458": "VQ35DE | 280 ch (206 kW)",
"de44571ddc4e4d0095c01af6ee299351": "VQ35DE | 280 hp (206 kW)"
}
},
{
"id": "12848a27f2454817b7d239bf24ceb440",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "350Z",
"5494b24b09d445ebace47112836b4458": "350Z",
"de44571ddc4e4d0095c01af6ee299351": "350Z"
}
},
{
"id": "1e06d04370e74897a22493f4e28d25b6",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan",
"de44571ddc4e4d0095c01af6ee299351": "Nissan"
}
},
{
"id": "87ac9b92685342f8938d855a43eb633b",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3.5 V6 (VQ35)",
"5494b24b09d445ebace47112836b4458": "3.5 V6 (VQ35)",
"de44571ddc4e4d0095c01af6ee299351": "3.5 V6 (VQ35)"
}
},
{
"id": "d3a1125efa4e462b983611524611b679",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Z33 | BJ 2002-2009",
"5494b24b09d445ebace47112836b4458": "Z33 | ANN\u00c9E 2002-2009",
"de44571ddc4e4d0095c01af6ee299351": "Z33 | Year built 2002-2009"
}
}
],
"options": [
{
"id": "2d9dd65389314419887e7456afe75876",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "95,50 mm \/ 8,5:1",
"5494b24b09d445ebace47112836b4458": "95,50 mm \/ 8,5:1",
"de44571ddc4e4d0095c01af6ee299351": "95.50 mm \/ 8.5:1"
}
}
],
"categoryIds": [
"1b0911e075ec48bc8d42a5b7749bafc4",
"dd423f04067c42059fc90c7bd91c59f6"
],
"optionIds": [
"2d9dd65389314419887e7456afe75876"
],
"propertyIds": [
"0fcd0158753541ab9236a38786db112e",
"12848a27f2454817b7d239bf24ceb440",
"1e06d04370e74897a22493f4e28d25b6",
"87ac9b92685342f8938d855a43eb633b",
"d3a1125efa4e462b983611524611b679"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"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": "Extrem leicht ",
"migration_Shopware5DB_product_bullet3": "Verst\u00e4rkt",
"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": "nissan-3-5l-24v-vq35-schmiedekolben-je-kolben",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 3.5L 24V VQ35 Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"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": "Extrem leicht ",
"migration_Shopware5DB_product_bullet3": "Verst\u00e4rkt",
"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": "Nissan 3.5L 24V VQ35 Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"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": "Extremely light ",
"migration_Shopware5DB_product_bullet3": "Amplified",
"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": "nissan-3-5l-24v-vq35-high-performance-pistons-kit-je",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 3.5L 24V VQ35 Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 3.5L 24V VQ35 Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": "Nissan 3.5L 24V VQ35 Jeu de pistons forg\u00e9s JE",
"de44571ddc4e4d0095c01af6ee299351": "Nissan 3.5L 24V VQ35 High Performance Pistons-Kit JE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von JE Piston f\u00fcr alle Nissan 3.5L 24V VQ35 Motoren.\nFeatures:\n\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch f\u00fcr Serienbohrung 95,50mm\n22mm Kolbenbolzen\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nEinbau- und Bohrma\u00dfe liegen bei\n\nDie angegebene Kompression ist in Verbindung mit einer 1mm Zylinderkopfdichtung. Preis f\u00fcr einen Satz JE Kolben ohne Beschichtung, diese kann aber gegen Aufpreis speziell von JE gefertigt werden. Das letzte Bild zeigt JE Kolben mit Sonderbeschichtungen an Kolbenhemd und Kolbenboden. Die Sonderbeschichtung kann bei uns separat bestellt werden. (siehe weiter unten) (Abbildung \u00e4hnlich)",
"5494b24b09d445ebace47112836b4458": "Pistons forg\u00e9s haute performance de JE Piston pour tous les moteurs Nissan 3,5L 24V VQ35.\nCaract\u00e9ristiques :\n\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\nEgalement pour les s\u00e9ries 95,50mm\nAxe de piston de 22 mm\nEnsemble complet comprenant l'axe de piston, les segments et les clips\nLes dimensions de l'installation et du forage sont indiqu\u00e9es dans le tableau ci-dessous\n\nLa compression indiqu\u00e9e est en combinaison avec un joint de culasse de 1 mm. Prix pour un jeu de pistons JE sans rev\u00eatement, mais celui-ci peut \u00eatre sp\u00e9cialement fabriqu\u00e9 par JE moyennant un suppl\u00e9ment. La derni\u00e8re photo montre des pistons JE avec des rev\u00eatements sp\u00e9ciaux sur la jupe et la couronne du piston.Le rev\u00eatement sp\u00e9cial peut \u00eatre command\u00e9 s\u00e9par\u00e9ment. ( voir ci-dessous) (Illustration similaire )",
"de44571ddc4e4d0095c01af6ee299351": "High Performance Pistons kit for all Nissan 3.5L 24V VQ35 engines.\r\nFeatures:\r\n\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 95,50mm\r\n22mm piston pin diameter\r\n\r\nThe specified compression is based on a 1mm head gasket. The last pic shows JE pistons WITH special coatings. These coatings are not included with this price but can be ordered at JE (scroll down). (Example picture)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 3.5L 24V VQ35 Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Nissan 3.5L 24V VQ35 Forged Piston Set JE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 997.36,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 838.11428571429,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 930.87,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 782.24,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 872.69,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 733.35,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1396.3,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1173.3613445378,
"shop-customer": "1173.3613445378",
"c-dealer": "838.11428571429",
"b-dealer": "782.24",
"a-dealer": "733.35"
},
"fields": {
"displayGroup": [
"b5409dec4076aab207c77974b3edf8cf"
]
},
"sort": [
"",
0,
"22f5ff2ebcc3419c9539dcb34d16373f"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "721703a627b543caa216da06446a0b84",
"_score": null,
"_source": {
"id": "721703a627b543caa216da06446a0b84",
"autoIncrement": 44827.0,
"ratingAverage": 0.0,
"active": true,
"available": false,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ni048",
"ean": null,
"displayGroup": "6c98f2478fe7185941da26af898d9cb0",
"sales": 0,
"stock": 0,
"weight": 5.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "646a267d69f4486397b4b5b003bb1bcd",
"manufacturerNumber": "929809360",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"452be90462ed4aba9b7e282cf4694914",
"19b76b26ada34a29bba967b9a10943bd",
"1b0911e075ec48bc8d42a5b7749bafc4"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "452be90462ed4aba9b7e282cf4694914",
"_count": 1
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1
},
{
"id": "1b0911e075ec48bc8d42a5b7749bafc4",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "e89a2c2534f841f68e2b9f5cc4fb5ca2",
"coverId": "d05cac6ea23c493f9131a7629835c604",
"childCount": 0,
"categories": [
{
"id": "1b0911e075ec48bc8d42a5b7749bafc4",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "3.5L 24V VQ35",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3.5L 24V VQ35",
"5494b24b09d445ebace47112836b4458": "3.5L 24V VQ35"
}
},
{
"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": "0fcd0158753541ab9236a38786db112e",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VQ35DE | 280 PS (206 kW)",
"5494b24b09d445ebace47112836b4458": "VQ35DE | 280 ch (206 kW)",
"de44571ddc4e4d0095c01af6ee299351": "VQ35DE | 280 hp (206 kW)"
}
},
{
"id": "12848a27f2454817b7d239bf24ceb440",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "350Z",
"5494b24b09d445ebace47112836b4458": "350Z",
"de44571ddc4e4d0095c01af6ee299351": "350Z"
}
},
{
"id": "1e06d04370e74897a22493f4e28d25b6",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan",
"de44571ddc4e4d0095c01af6ee299351": "Nissan"
}
},
{
"id": "87ac9b92685342f8938d855a43eb633b",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3.5 V6 (VQ35)",
"5494b24b09d445ebace47112836b4458": "3.5 V6 (VQ35)",
"de44571ddc4e4d0095c01af6ee299351": "3.5 V6 (VQ35)"
}
},
{
"id": "d3a1125efa4e462b983611524611b679",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Z33 | BJ 2002-2009",
"5494b24b09d445ebace47112836b4458": "Z33 | ANN\u00c9E 2002-2009",
"de44571ddc4e4d0095c01af6ee299351": "Z33 | Year built 2002-2009"
}
}
],
"options": [
{
"id": "e14ebd5615c243e89b10a20ce78f61b8",
"_count": 1,
"groupId": "b10fe7537cdc43c79c70604a9ccae0b2",
"group": {
"id": "b10fe7537cdc43c79c70604a9ccae0b2",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "95,50 mm \/ 9,4:1",
"5494b24b09d445ebace47112836b4458": "95,50 mm \/ 9,4:1",
"de44571ddc4e4d0095c01af6ee299351": "95,50 mm \/ 9,4:1"
}
}
],
"categoryIds": [
"19b76b26ada34a29bba967b9a10943bd",
"1b0911e075ec48bc8d42a5b7749bafc4"
],
"optionIds": [
"e14ebd5615c243e89b10a20ce78f61b8"
],
"propertyIds": [
"0fcd0158753541ab9236a38786db112e",
"12848a27f2454817b7d239bf24ceb440",
"1e06d04370e74897a22493f4e28d25b6",
"87ac9b92685342f8938d855a43eb633b",
"d3a1125efa4e462b983611524611b679"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "MAHLE Schmiedekolben",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Verarbeitung",
"migration_Shopware5DB_product_bullet3": "Super Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Motorsport",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "nissan-35l-24v-vq35de-schmiedekolben-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 3.5L 24V VQ35DE Schmiedekolben-Satz MAHLE",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "MAHLE Schmiedekolben",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Verarbeitung",
"migration_Shopware5DB_product_bullet3": "Super Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Motorsport",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 3.5L 24V VQ35DE Schmiedekolben-Satz MAHLE",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "MAHLE Schmiedekolben",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Verarbeitung",
"migration_Shopware5DB_product_bullet3": "Super Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Motorsport",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "nissan-3-5l-24v-vq35det-high-performance-pistons-kit-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 3.5L 24V VQ35DE Schmiedekolben-Satz MAHLE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 3.5L 24V VQ35DE Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": "Nissan 3.5L 24V VQ35DE Jeu de pistons forg\u00e9s MAHLE",
"de44571ddc4e4d0095c01af6ee299351": "Nissan 3.5L 24V VQ35DET High Performance Pistons-Kit MAHLE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochleistungskolben von MAHLE Motorsport f\u00fcr alle Nissan 3.5L 24V VQ35DE Motoren. Mit diesen Kolben ist es recht einfach die Verdichtung herab zu setzen, und gleichzeitig mehr Leistung und Haltbarkeit zu erhalten. Die Firma Mahle produziert Kolben unter anderem auch f\u00fcr Formel 1 Motoren. Kaum ein anderer Kolbenhersteller hat mehr Erfahrung und Know-How als Mahle. Deshalb setzen auch wir auf Hochleistungskolben von Mahle. Features:\n\nGeringes Laufspiel m\u00f6glich dank spezieller Legierung\nRuhiger Motorlauf auch in Kaltstartphase\nHigh Performance Kolbenbolzen\nIdeale Verdichtung und optimale Kolbenform\nF\u00fcr 144.1x22mm Pleuel\nBohrung 95.50mm\/8.5:1 oder 96.00mm\/8.6:1 w\u00e4hlbar\nGeringes Blow-by durch spezielle Ringzonen\nAnti-Friction Grafit Beschichtung\nMahle High Performance Kolbenringe\n\nPassend f\u00fcr:\n\nNissan 3.5L 24V VQ35DET Motoren\n\n Alle Kolbens\u00e4tze werden mit hoch festen Kolbenbolzen und kompletten Rings\u00e4tzen geliefert.\nEinbau- und Bohrma\u00dfe liegen nat\u00fcrlich bei. Gerne k\u00f6nnen auch wir den Einbau in unserem Hause \u00fcbernehmen oder komplette Rennmotoren nach Kundenwunsch aufbauen.\nAbbildung \u00e4hnlich.",
"5494b24b09d445ebace47112836b4458": "Pistons haute performance de MAHLE Motorsport pour tous les moteurs Nissan 3,5L 24V VQ35DE. Avec ces pistons, il est assez facile de r\u00e9duire la compression et d'obtenir en m\u00eame temps plus de puissance et de durabilit\u00e9. La soci\u00e9t\u00e9 Mahle produit des pistons pour les moteurs de Formule 1, entre autres.Presque aucun autre fabricant de pistons n'a plus d'exp\u00e9rience et de savoir-faire que Mahle.C'est pourquoi nous comptons \u00e9galement sur les pistons haute performance de Mahle. des fonctionnalit\u00e9s :\n\nUn alliage sp\u00e9cial permet d'obtenir un faible jeu de fonctionnement\nUn moteur qui tourne en douceur, m\u00eame en phase de d\u00e9marrage \u00e0 froid\nAxe de piston haute performance\nUne compression id\u00e9ale et une forme de piston optimale\nPour une biellede 144,1x22mm\nal\u00e9sage 95,50mm\/8,5:1 ou 96,00mm\/8,6:1 s\u00e9lectionnable\nFaible taux de fuite gr\u00e2ce \u00e0 des zones sp\u00e9ciales\nRev\u00eatement anti-friction en graphite\nSegments de piston Mahle High Performance\n\nAppropri\u00e9 pour :\n\nMoteurs Nissan 3,5L 24V VQ35DET\n\n Tous les jeux de pistons sont fournis avec des axes de piston \u00e0 haute r\u00e9sistance et des jeux de segments complets.\nLes dimensions d'installation et de forage sont bien s\u00fbr incluses. Nous pouvons \u00e9galement prendre en charge l'installation dans notre entreprise ou construire des moteurs de course complets selon les besoins du client.\nImage similaire.",
"de44571ddc4e4d0095c01af6ee299351": "MAHLE High Performance Pistons kit for Nissan 3.5L 24V VQ35DET engines. We are proud to offer these pistons for the VQ35DET engines, which offer industry-leading features, OEM fitment, and OEM-like wear characteristics. These pistons are recommended for any high performance engine build, as they offer unparalleled strength and longevity. Features:\n\nFor 144.1x22mm conrods\nBorsize 95.50mm\/8.5:1 or 96.00mm\/8.6:1 available\nOEM fitment and wear characteristics\nQuite piston operation\nIdeal compression ratio and dish shape\nDurable forged pistons\nLightweight piston design\nHigh strength German steel wrist pins for high horsepower support\nPropriety Mahle low-expansion 142P alloy\nTight ring to piston groove clearances to reduce blow-by\nHard anodized ring lands to avoid micro-welding\nGrafal anti-friction skirt coating\nOil squirter notches that ensure no piston skirt to squirter interference\n\nFits for:\n\nNissan 3.5L 24V VQ35DET engines\n\n To maximize power output, the clearances between the rings and piston have been brought in very tightly to reduce blow by. This is achieved by hard anodizing the top ring lands, which prevents micro welding which could be caused otherwise. To maintain OEM-like wear characteristics, these pistons are coated with Mahle\u2019s Grafal skirt coating. This coating reduces friction on the skirts, keeping them quiet and from wearing over time- extending piston life. The grey appearance of these pistons is due to a phosphate coating. Providing a lubricant film in the pin bores and ring grooves, this coating is essential for initial startup and break-in of the engine to prevent micro welding and galling. Features like these are what allow these pistons to last for thousands of miles, just like OEM units.\nPicture shows similar."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 3.5L 24V VQ35DET Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Nissan 3.5L 24V VQ35DET High Performance Pistons-Kit MAHLE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 816.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 686.54621848739,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 773.98,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 650.40336134454,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 730.96,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 614.25210084034,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 889.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 747.85714285714,
"shop-customer": "747.85714285714",
"c-dealer": "686.54621848739",
"b-dealer": "650.40336134454",
"a-dealer": "614.25210084034"
},
"fields": {
"displayGroup": [
"6c98f2478fe7185941da26af898d9cb0"
]
},
"sort": [
"",
0,
"721703a627b543caa216da06446a0b84"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.94 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.2f37bfd0f23f482bad9d34a02199499b"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.2f37bfd0f23f482bad9d34a02199499b.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":"1b0911e075ec48bc8d42a5b7749bafc4"}}}},{"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.2f37bfd0f23f482bad9d34a02199499b.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.2f37bfd0f23f482bad9d34a02199499b.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.2f37bfd0f23f482bad9d34a02199499b"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.2f37bfd0f23f482bad9d34a02199499b.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": "1b0911e075ec48bc8d42a5b7749bafc4"
}
}
}
},
{
"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.2f37bfd0f23f482bad9d34a02199499b.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.2f37bfd0f23f482bad9d34a02199499b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|