1 |
733.08 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":"5532c86be07545f491df5ef0b605f545"}}}},{"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": 730,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 20,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "0623c4ad664147cd93d426e62af41b43",
"_score": null,
"_source": {
"id": "0623c4ad664147cd93d426e62af41b43",
"autoIncrement": 53805.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ho019.2",
"ean": null,
"displayGroup": "2b522709bbb665eb660ea46e97f7b4f4",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "646a267d69f4486397b4b5b003bb1bcd",
"manufacturerNumber": "929986129",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"e92bc96c8e274d69a6491c8a1102f81f",
"19b76b26ada34a29bba967b9a10943bd",
"5532c86be07545f491df5ef0b605f545"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "e92bc96c8e274d69a6491c8a1102f81f",
"_count": 1
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1
},
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "1070a3398586400585d392d4cad912db",
"coverId": "ff9e735561d94b628aaeb3df57ae3365",
"childCount": 0,
"categories": [
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V",
"5494b24b09d445ebace47112836b4458": "2.0L 16V"
}
},
{
"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": "87f336a30b764736b3c4ca9b3a356a02",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda",
"5494b24b09d445ebace47112836b4458": "Honda",
"de44571ddc4e4d0095c01af6ee299351": "Honda"
}
},
{
"id": "9c1a7f58c8a946b2a9c28ad53ac129b9",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S2000",
"5494b24b09d445ebace47112836b4458": "S2000",
"de44571ddc4e4d0095c01af6ee299351": "S2000"
}
}
],
"options": [
{
"id": "892d8d05953b461a9d9c1c4048fbac86",
"_count": 1,
"groupId": "b10fe7537cdc43c79c70604a9ccae0b2",
"group": {
"id": "b10fe7537cdc43c79c70604a9ccae0b2",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "87,10 mm \/ 12,5:1",
"5494b24b09d445ebace47112836b4458": "87,10 mm \/ 12,5:1",
"de44571ddc4e4d0095c01af6ee299351": "87,10 mm \/ 12,5:1"
}
}
],
"categoryIds": [
"19b76b26ada34a29bba967b9a10943bd",
"5532c86be07545f491df5ef0b605f545"
],
"optionIds": [
"892d8d05953b461a9d9c1c4048fbac86"
],
"propertyIds": [
"87f336a30b764736b3c4ca9b3a356a02",
"9c1a7f58c8a946b2a9c28ad53ac129b9"
],
"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": "Schmiedekolben MAHLE",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Mega Leistung",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Hochleistungskolben",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "honda-s2000-20l-16v-schmiedekolben-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz MAHLE",
"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": "Schmiedekolben MAHLE",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Mega Leistung",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet4": "Hochleistungskolben",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz MAHLE",
"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": "Forged piston MAHLE",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Mega performance",
"migration_Shopware5DB_product_bullet3": "Top quality",
"migration_Shopware5DB_product_bullet4": "High performance piston",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "honda-s2000-20l-16v-forged-piston-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz MAHLE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda S2000 2.0L 16V Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": "Honda S2000 2.0L 16V forg\u00e9e jeu de pistons MAHLE",
"de44571ddc4e4d0095c01af6ee299351": "Honda S2000 2.0L 16V High Performance Pistons-Kit MAHLE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochleistungskolben von MAHLE Motorsport f\u00fcr alle Honda S2000 2.0L 16V 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 153x23mm Pleuel\nBohrung in 87.00mm, 87.10mm und 87.25mm w\u00e4hlbar\nVerdichtung w\u00e4hlbar\nGeringes Blow-by durch spezielle Ringzonen\nAnti-Friction Grafit Beschichtung\nMahle High Performance Kolbenringe\n\nPassend f\u00fcr:\n\nHonda S2000 2.0L 16V Motoren\n\nAlle 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 Honda S2000 2.0L 16V. 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 biellede 153x23mm\nper\u00e7age en 87.00mm, 87.10mm et 87.25mm s\u00e9lectionnable\nCompression 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 Honda S2000 2.0L 16V\n\nTous les ensembles 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 Honda S2000 2.0L 16V engines. We are proud to offer these pistons for the Honda S2000 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 153x23mm conrods\nBorsize 87.00mm, 87.10mm and 87.25mm available\ncompression selectable\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\nHonda S2000 2.0L 16V 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": "Honda S2000 2.0L 16V Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "\u2063Honda S2000 2.0L 16V forged piston set MAHLE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 949.98,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 798.3025210084,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 900.0,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 756.3025210084,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 849.96,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 714.25210084034,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1015.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 853.73949579832,
"shop-customer": "853.73949579832",
"c-dealer": "798.3025210084",
"b-dealer": "756.3025210084",
"a-dealer": "714.25210084034"
},
"fields": {
"displayGroup": [
"2b522709bbb665eb660ea46e97f7b4f4"
]
},
"sort": [
"",
0,
"0623c4ad664147cd93d426e62af41b43"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "1aac6d52c51f4f1d978509b6fe5da060",
"_score": null,
"_source": {
"id": "1aac6d52c51f4f1d978509b6fe5da060",
"autoIncrement": 49165.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ho009.6",
"ean": null,
"displayGroup": "686be74a86b512980fca19a5a5bf0064",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6aadff5484494e05b2cd9cd32ec57924",
"manufacturerNumber": "JE-296909",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"e92bc96c8e274d69a6491c8a1102f81f",
"5532c86be07545f491df5ef0b605f545",
"dd423f04067c42059fc90c7bd91c59f6"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "e92bc96c8e274d69a6491c8a1102f81f",
"_count": 1
},
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "6b0b2405f7394532a7339d030e5ee21d",
"coverId": "93c6ef35961649e583aacc8de10a3e69",
"childCount": 0,
"categories": [
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V",
"5494b24b09d445ebace47112836b4458": "2.0L 16V"
}
},
{
"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": "87f336a30b764736b3c4ca9b3a356a02",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda",
"5494b24b09d445ebace47112836b4458": "Honda",
"de44571ddc4e4d0095c01af6ee299351": "Honda"
}
},
{
"id": "9c1a7f58c8a946b2a9c28ad53ac129b9",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S2000",
"5494b24b09d445ebace47112836b4458": "S2000",
"de44571ddc4e4d0095c01af6ee299351": "S2000"
}
}
],
"options": [
{
"id": "984f0c5c85e14dfb93860b047fbd00cf",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "87,50 mm \/ 9:1",
"5494b24b09d445ebace47112836b4458": "87,50 mm \/ 9:1",
"de44571ddc4e4d0095c01af6ee299351": "87.50 mm \/ 9:1"
}
}
],
"categoryIds": [
"5532c86be07545f491df5ef0b605f545",
"dd423f04067c42059fc90c7bd91c59f6"
],
"optionIds": [
"984f0c5c85e14dfb93860b047fbd00cf"
],
"propertyIds": [
"87f336a30b764736b3c4ca9b3a356a02",
"9c1a7f58c8a946b2a9c28ad53ac129b9"
],
"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": "23mm Kolbenbolzen",
"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": "honda-s2000-2-0l-16v-schmiedekolben-je-kolben",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V 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": "23mm Kolbenbolzen",
"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": "Honda S2000 2.0L 16V 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": "23mm piston pin",
"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": "honda-s2000-2-0l-16v-high-performance-pistons-kit-je",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda S2000 2.0L 16V Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": "Honda S2000 2.0L 16V forg\u00e9e jeu de pistons JE",
"de44571ddc4e4d0095c01af6ee299351": "Honda S2000 2.0L 16V High Performance Pistons-Kit JE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von JE Piston f\u00fcr alle Honda S2000 2.0L 16V Motoren mit dem Motorcode F20C.\nFeatures:\n\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch f\u00fcr Serienbohrung 87,00mm\n23mm Kolbenbolzen\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nEinbau- und Bohrma\u00dfe liegen bei\n\nDie angegebene Kompression ist in Verbindung mit einer 1,00mm Zylinderkopfdichtung. F\u00fcr Honda S2000 2.0L 16V Motoren mit dem Motorcode F20C. 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 Honda S2000 2.0L 16V avec le code moteur F20C.\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 de 87,00mm\nAxe de piston de 23 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,00 mm. Pour les moteurs Honda S2000 2.0L 16V avec le code moteur F20C. 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 Honda S2000 2.0L 16V with enginecode F20C.\r\nFeatures:\r\n\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 87,00mm\r\n23mm piston pin diameter\r\n\r\nThe specified compression is based on a 1,00mm 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": "Honda S2000 2.0L 16V Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Honda S2000 2.0L 16V Forged Piston Set JE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 620.58,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 521.49333333333,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 581.79,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 488.9,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 664.9,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 558.74285714286,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 930.87,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 782.24369747899,
"shop-customer": "782.24369747899",
"b-dealer": "521.49333333333",
"a-dealer": "488.9",
"c-dealer": "558.74285714286"
},
"fields": {
"displayGroup": [
"686be74a86b512980fca19a5a5bf0064"
]
},
"sort": [
"",
0,
"1aac6d52c51f4f1d978509b6fe5da060"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "23d7fbe82ebb4198b72c5540d5e92f42",
"_score": null,
"_source": {
"id": "23d7fbe82ebb4198b72c5540d5e92f42",
"autoIncrement": 49171.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ho005.3",
"ean": null,
"displayGroup": "ef79ef8ad0476a7dc60864bc5ec4da71",
"sales": 0,
"stock": 0,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "73b7e885f67d4e63844ce268112d265f",
"manufacturerNumber": "WK682M875AP",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"e92bc96c8e274d69a6491c8a1102f81f",
"5532c86be07545f491df5ef0b605f545",
"685cf0aa104740fc8ff09754472d4913"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "e92bc96c8e274d69a6491c8a1102f81f",
"_count": 1
},
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "9de68ba53881498fbf798200095fad78",
"coverId": "785d297fd368494e80615b0bc3b3357b",
"childCount": 0,
"categories": [
{
"id": "5532c86be07545f491df5ef0b605f545",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V",
"5494b24b09d445ebace47112836b4458": "2.0L 16V"
}
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados Wiseco",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wiseco Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "Wiseco pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "Wiseco Sport Pistons"
}
}
],
"manufacturer": {
"id": "73b7e885f67d4e63844ce268112d265f",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "WISECO"
},
"_count": 1
},
"properties": [
{
"id": "87f336a30b764736b3c4ca9b3a356a02",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda",
"5494b24b09d445ebace47112836b4458": "Honda",
"de44571ddc4e4d0095c01af6ee299351": "Honda"
}
},
{
"id": "9c1a7f58c8a946b2a9c28ad53ac129b9",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S2000",
"5494b24b09d445ebace47112836b4458": "S2000",
"de44571ddc4e4d0095c01af6ee299351": "S2000"
}
}
],
"options": [
{
"id": "3224fa65121c4641a476dc1b11a4e305",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "87,50 mm \/ 11:1",
"5494b24b09d445ebace47112836b4458": "87,50 mm \/ 11:1",
"de44571ddc4e4d0095c01af6ee299351": "87.50 mm \/ 11:1"
}
}
],
"categoryIds": [
"5532c86be07545f491df5ef0b605f545",
"685cf0aa104740fc8ff09754472d4913"
],
"optionIds": [
"3224fa65121c4641a476dc1b11a4e305"
],
"propertyIds": [
"87f336a30b764736b3c4ca9b3a356a02",
"9c1a7f58c8a946b2a9c28ad53ac129b9"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2f37bfd0f23f482bad9d34a02199499b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"migration_Shopware5DB_product_onco_universal_article": false
},
"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": "23mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet4": "Kolbenhemd beschichtet",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "honda-s2000-2-0l-16v-schmiedekolben-pistons-wiseco",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"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": "23mm Kolbenbolzen",
"migration_Shopware5DB_product_bullet4": "Kolbenhemd beschichtet",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"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": "23mm piston pin",
"migration_Shopware5DB_product_bullet4": "Piston skirt coated",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "honda-s2000-2-0l-16v-high-performance-pistons-kit-wiseco",
"migration_Shopware5DB_product_dreisc_seo_title": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": "Honda S2000 2.0L 16V jeu de pistons forg\u00e9s WISECO",
"de44571ddc4e4d0095c01af6ee299351": "Honda S2000 2.0L 16V High Performance Pistons-Kit WISECO"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von Wiseco f\u00fcr Honda S2000 2.0L 16V Motoren mit dem Motorcode F20C.\nFeatures:\n\nOriginal Wiseco\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch in Serienbohrung 87,00mm erh\u00e4ltlich\n23mm Kolbenbolzen\nKolbenhemd beschichtet f\u00fcr weniger Reibung\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nEinbau- und Bohrma\u00dfe liegen bei\n\nF\u00fcr Honda S2000 2.0L 16V Motoren mit dem Motorcode F20C. Die angegebene Kompression ist in Verbindung mit einer 0,75mm Zylinderkopfdichtung. Wir empfehlen zus\u00e4tzlich entweder die Serienpleuel mit ARP Pleuelschrauben zu verwenden oder direkt auf H-Schaft Pleuel umzubauen. Made in USA Abbildung \u00e4hnlich.",
"5494b24b09d445ebace47112836b4458": "Pistons forg\u00e9s haute performance de Wiseco pour les moteurs Honda S2000 2,0L 16V avec le code moteur F20C\nCaract\u00e9ristiques :\n\nOriginal Wiseco\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\n\u00c9galement disponible en s\u00e9rie, avec un al\u00e9sage de 87,00 mm\nAxe de piston de 23 mm\nJupe de piston rev\u00eatue pour r\u00e9duire les frottements\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\nPour les moteurs Honda S2000 2.0L 16V avec le code moteur F20C. La compression indiqu\u00e9e est en combinaison avec un joint de culasse de 0,75 mm. Nous recommandons \u00e9galement d'utiliser les bielles standard avec des boulons de bielle ARP ou de les convertir directement en bielles \u00e0 arbre en H. Made in USA Figure similaire.",
"de44571ddc4e4d0095c01af6ee299351": "Wiseco High Performance Pistons kit for Honda S2000 2.0L 16V with enginecode F20C.\r\nFeatures:\r\n\r\noriginal Wiseco\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 87,00mm\r\n23mm piston pin diameter\r\nskirt coated for less friction\r\n\r\nThe specified compression is based on a 0,75mm head gasket. The picture is similar."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Honda S2000 2.0L 16V Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Honda S2000 2.0L 16V forged piston set WISECO"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 620.16,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 521.14285714286,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 542.64,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 456,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 578.82,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 486.4,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 868.22,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 729.59663865546,
"shop-customer": "729.59663865546",
"c-dealer": "521.14285714286",
"a-dealer": "456",
"b-dealer": "486.4"
},
"fields": {
"displayGroup": [
"ef79ef8ad0476a7dc60864bc5ec4da71"
]
},
"sort": [
"",
0,
"23d7fbe82ebb4198b72c5540d5e92f42"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
2 |
217.01 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":"5532c86be07545f491df5ef0b605f545"}}}},{"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": "5532c86be07545f491df5ef0b605f545"
}
}
}
},
{
"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
|