| 1 |
43.42 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"d2e1508eb60b4f51b6d8f3bb04fff2a6"}}}},{"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":["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": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "04cc6f9997194c55b5e04ba70af05290",
"_score": null,
"_source": {
"id": "04cc6f9997194c55b5e04ba70af05290",
"autoIncrement": 53803.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ni047.1",
"ean": null,
"displayGroup": "4844107e885fea1ca1355123ffc5dedf",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "646a267d69f4486397b4b5b003bb1bcd",
"manufacturerNumber": "929811601",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"452be90462ed4aba9b7e282cf4694914",
"19b76b26ada34a29bba967b9a10943bd",
"d2e1508eb60b4f51b6d8f3bb04fff2a6"
],
"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": "d2e1508eb60b4f51b6d8f3bb04fff2a6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "9e7ed283b2db48d5bd2e992202972e46",
"coverId": "dfc2bf001ca0437d974fcf04ac4f958a",
"childCount": 0,
"categories": [
{
"id": "d2e1508eb60b4f51b6d8f3bb04fff2a6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.5L 24V RB25DET",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L 24V RB25DET",
"5494b24b09d445ebace47112836b4458": "2.5L 24V RB25DET"
}
},
{
"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": "16881a1603904016a1c56022db25f39a",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "RB25DE | 180 PS (132 kW)",
"5494b24b09d445ebace47112836b4458": "RB25DE | 180 ch (132 kW)",
"de44571ddc4e4d0095c01af6ee299351": " RB25DE | 180 hp (132 kW)"
}
},
{
"id": "1e06d04370e74897a22493f4e28d25b6",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan",
"de44571ddc4e4d0095c01af6ee299351": "Nissan"
}
},
{
"id": "311cc8a1c0654fa7894e441588cd719a",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R32 | BJ 1989-1993",
"5494b24b09d445ebace47112836b4458": "R32 | ANN\u00c9E 1989-1993",
"de44571ddc4e4d0095c01af6ee299351": "R32 | Year built 1989-1993"
}
},
{
"id": "471d169c6abb48bbb0e6611f830803f0",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 R6 (RB25)",
"5494b24b09d445ebace47112836b4458": "2.5 R6 (RB25)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 R6 (RB25)"
}
},
{
"id": "57c042d83d874201a98e933991d69f16",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Skyline GT-R",
"5494b24b09d445ebace47112836b4458": "Skyline GT-R",
"de44571ddc4e4d0095c01af6ee299351": "Skyline GT-R"
}
},
{
"id": "9321604578664e458f5be26a117cf5ee",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "RB25DE | 190 PS (140 kW)",
"5494b24b09d445ebace47112836b4458": "RB25DE | 190 ch (140 kW)",
"de44571ddc4e4d0095c01af6ee299351": " RB25DE | 190 hp (140 kW)"
}
},
{
"id": "94fb30eda7ff466ba503c36a43df7fb3",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R33 | BJ 1993-1998",
"5494b24b09d445ebace47112836b4458": "R33 | ANN\u00c9E 1993-1998",
"de44571ddc4e4d0095c01af6ee299351": "R33 | Year built 1993-1998"
}
}
],
"options": [
{
"id": "d0b3e33c6f6d424a8632c9e7bba7cc49",
"_count": 1,
"groupId": "b10fe7537cdc43c79c70604a9ccae0b2",
"group": {
"id": "b10fe7537cdc43c79c70604a9ccae0b2",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "87,00 mm\/ 8,0:1",
"5494b24b09d445ebace47112836b4458": "87,00 mm\/ 8,0:1",
"de44571ddc4e4d0095c01af6ee299351": "87,00 mm\/ 8,0:1"
}
}
],
"categoryIds": [
"19b76b26ada34a29bba967b9a10943bd",
"d2e1508eb60b4f51b6d8f3bb04fff2a6"
],
"optionIds": [
"d0b3e33c6f6d424a8632c9e7bba7cc49"
],
"propertyIds": [
"16881a1603904016a1c56022db25f39a",
"1e06d04370e74897a22493f4e28d25b6",
"311cc8a1c0654fa7894e441588cd719a",
"471d169c6abb48bbb0e6611f830803f0",
"57c042d83d874201a98e933991d69f16",
"9321604578664e458f5be26a117cf5ee",
"94fb30eda7ff466ba503c36a43df7fb3"
],
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Ruhiger Motorlauf",
"migration_Shopware5DB_product_bullet3": "Geringes Laufspiel",
"migration_Shopware5DB_product_bullet4": "Geringes Blow-by ",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "nissan-25l-24v-rb25det-schmiedekolben-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 2.5L 24V RB25DET 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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Ruhiger Motorlauf",
"migration_Shopware5DB_product_bullet3": "Geringes Laufspiel",
"migration_Shopware5DB_product_bullet4": "Geringes Blow-by ",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 2.5L 24V RB25DET 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": "High performance piston",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Quiet engine running",
"migration_Shopware5DB_product_bullet3": "Low running clearance",
"migration_Shopware5DB_product_bullet4": "Low blow-by ",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "nissan-2-5l-24v-rb25det-high-performance-pistons-kit-mahle",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz MAHLE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": "Jeu de pistons forg\u00e9s Nissan 2.5L 24V RB25DET MAHLE",
"de44571ddc4e4d0095c01af6ee299351": "Nissan 2.5L 24V RB25DET High Performance Pistons-Kit MAHLE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochleistungskolben von MAHLE Motorsport f\u00fcr alle Nissan 2.5L 24V RB25DET 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 121.5x21mm Pleuel\nBohrung 86.50mm oder 87.00mm w\u00e4hlbar\nVerdichtung 8.5:1\nGeringes Blow-by durch spezielle Ringzonen\nAnti-Friction Grafit Beschichtung\nMahle High Performance Kolbenringe\n\nPassend f\u00fcr:\n\nNissan 2.5L 24V RB25DET Motoren\n\n Die \u00d6lspritzd\u00fcsen m\u00fcssen mit 2.5mm Unterlegscheiben unterlegt werden.\nAlle Kolbens\u00e4tze werden mit hoch festen Kolbenbolzen und kompletten Rings\u00e4tzen geliefert. Einbau- 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 2,5L 24V RB25DET. 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 121,5x21mm\nAl\u00e9sage s\u00e9lectionnable 86,50 mm ou 87,00 mm\nCompression 8.5:1\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 2,5L 24V RB25DET\n\n Les buses de pulv\u00e9risation d'huile doivent \u00eatre munies de rondelles de 2,5 mm.\nTous les ensembles de pistons sont fournis avec des axes de piston \u00e0 haute r\u00e9sistance et des jeux de segments complets.Les 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 2.5L 24V RB25DET engines. We are proud to offer these pistons for the RB25DET 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:\r\n\r\nFor 121.5x21mm conrods\r\nBorsize 86.50mm or 87.00mm available\r\ncompression 8.5:1\r\nOEM fitment and wear characteristics\r\nQuite piston operation\r\nIdeal compression ratio and dish shape\r\nDurable forged pistons\r\nLightweight piston design\r\nHigh strength German steel wrist pins for high horsepower support\r\nPropriety Mahle low-expansion 142P alloy\r\nTight ring to piston groove clearances to reduce blow-by\r\nHard anodized ring lands to avoid micro-welding\r\nGrafal anti-friction skirt coating\r\nOil squirter notches that ensure no piston skirt to squirter interference\r\n\r\nFits for:\r\n\r\nNissan 2.5L 24V RB25DET engines\r\n\r\nRequire 2.5mm washers under squirters.\r\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’s 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.\r\nPicture shows similar."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz MAHLE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Nissan 2.5L 24V RB25DET Forged piston set MAHLE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 782,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 657.14285714286,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 729.87,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 613.33333333333,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 782,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 657.14285714286,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 889.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 747.85714285714,
"shop-customer": "747.85714285714",
"b-dealer": "657.14285714286",
"a-dealer": "613.33333333333",
"c-dealer": "657.14285714286"
},
"fields": {
"displayGroup": [
"4844107e885fea1ca1355123ffc5dedf"
]
},
"sort": [
"",
0,
"04cc6f9997194c55b5e04ba70af05290"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "0e4d904f4edb4838990d34742cba835b",
"_score": null,
"_source": {
"id": "0e4d904f4edb4838990d34742cba835b",
"autoIncrement": 62922.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21ni006.1",
"ean": null,
"displayGroup": "2d1a34a4ba30439144fc348f2a1ff759",
"sales": 0,
"stock": 0,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "73b7e885f67d4e63844ce268112d265f",
"manufacturerNumber": "WK578M865AP",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"452be90462ed4aba9b7e282cf4694914",
"685cf0aa104740fc8ff09754472d4913",
"d2e1508eb60b4f51b6d8f3bb04fff2a6"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "452be90462ed4aba9b7e282cf4694914",
"_count": 1
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1
},
{
"id": "d2e1508eb60b4f51b6d8f3bb04fff2a6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "1078f6e6a212435eaacacfbbc398c4d0",
"coverId": "0c7257324bbb40b2aa43399931e7ae18",
"childCount": 0,
"categories": [
{
"id": "d2e1508eb60b4f51b6d8f3bb04fff2a6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.5L 24V RB25DET",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L 24V RB25DET",
"5494b24b09d445ebace47112836b4458": "2.5L 24V RB25DET"
}
},
{
"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": "16881a1603904016a1c56022db25f39a",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "RB25DE | 180 PS (132 kW)",
"5494b24b09d445ebace47112836b4458": "RB25DE | 180 ch (132 kW)",
"de44571ddc4e4d0095c01af6ee299351": " RB25DE | 180 hp (132 kW)"
}
},
{
"id": "1e06d04370e74897a22493f4e28d25b6",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan",
"de44571ddc4e4d0095c01af6ee299351": "Nissan"
}
},
{
"id": "311cc8a1c0654fa7894e441588cd719a",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R32 | BJ 1989-1993",
"5494b24b09d445ebace47112836b4458": "R32 | ANN\u00c9E 1989-1993",
"de44571ddc4e4d0095c01af6ee299351": "R32 | Year built 1989-1993"
}
},
{
"id": "471d169c6abb48bbb0e6611f830803f0",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 R6 (RB25)",
"5494b24b09d445ebace47112836b4458": "2.5 R6 (RB25)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 R6 (RB25)"
}
},
{
"id": "57c042d83d874201a98e933991d69f16",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Skyline GT-R",
"5494b24b09d445ebace47112836b4458": "Skyline GT-R",
"de44571ddc4e4d0095c01af6ee299351": "Skyline GT-R"
}
},
{
"id": "9321604578664e458f5be26a117cf5ee",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "RB25DE | 190 PS (140 kW)",
"5494b24b09d445ebace47112836b4458": "RB25DE | 190 ch (140 kW)",
"de44571ddc4e4d0095c01af6ee299351": " RB25DE | 190 hp (140 kW)"
}
},
{
"id": "94fb30eda7ff466ba503c36a43df7fb3",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R33 | BJ 1993-1998",
"5494b24b09d445ebace47112836b4458": "R33 | ANN\u00c9E 1993-1998",
"de44571ddc4e4d0095c01af6ee299351": "R33 | Year built 1993-1998"
}
}
],
"options": [
{
"id": "cf152e4af7db4f558208cfbd0becd0a2",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "86,50 mm \/ 8:1-8.4:1",
"5494b24b09d445ebace47112836b4458": "86,50 mm \/ 8:1-8.4:1",
"de44571ddc4e4d0095c01af6ee299351": "86.50 mm \/ 8:1-8.4:1"
}
}
],
"categoryIds": [
"685cf0aa104740fc8ff09754472d4913",
"d2e1508eb60b4f51b6d8f3bb04fff2a6"
],
"optionIds": [
"cf152e4af7db4f558208cfbd0becd0a2"
],
"propertyIds": [
"16881a1603904016a1c56022db25f39a",
"1e06d04370e74897a22493f4e28d25b6",
"311cc8a1c0654fa7894e441588cd719a",
"471d169c6abb48bbb0e6611f830803f0",
"57c042d83d874201a98e933991d69f16",
"9321604578664e458f5be26a117cf5ee",
"94fb30eda7ff466ba503c36a43df7fb3"
],
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Kolbenhemd beschichtet",
"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": "nissan-2-5l-24v-rb25det-schmiedekolben-pistons-wiseco",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz WISECO",
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Kolbenhemd beschichtet",
"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": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz WISECO",
"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": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Piston skirt coated",
"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": "nissan-2-5l-24v-rb25det-high-performance-pistons-kit-wiseco",
"migration_Shopware5DB_product_dreisc_seo_title": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz WISECO",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": "Nissan 2.5L 24V RB25DET Jeu de pistons forg\u00e9s WISECO",
"de44571ddc4e4d0095c01af6ee299351": "Nissan 2.5L 24V RB25DET High Performance Pistons-Kit WISECO"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von Wiseco f\u00fcr Nissan 2.5L 24V RB25DET Motoren.\nFeatures:\n\nOriginal Wiseco\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nBohrung ab 86,25mm erh\u00e4ltlich\n21mm Kolbenbolzen\nKolbenhemd beschichtet f\u00fcr weniger Reibung\nKomplettes Set inkl. Kolbenbolzen, Ringen und Clipsen\nEinbau- und Bohrma\u00dfe liegen bei\n\nF\u00fcr Nissan 2.5L 24V RB25DET Motoren. Die angegebene Kompression ist in Verbindung mit einer 1mm 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 Nissan 2,5L 24V RB25DET\nCaract\u00e9ristiques :\n\nOriginal Wiseco\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\nPer\u00e7age disponible \u00e0 partir de 86,25mm\nAxe de piston de 21 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 Nissan 2,5L 24V RB25DET. La compression indiqu\u00e9e est en rapport avec un joint de culasse de 1 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 Nissan 2.5L 24V RB25DET engine.\r\nFeatures:\r\n\r\noriginal Wiseco\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nbore size available over 86,25mm\r\n21mm piston pin diameter\r\nskirt coated for less friction\r\n\r\nThe specified compression is based on a 1mm head gasket. The picture is similar."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 2.5L 24V RB25DET Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Nissan 2.5L 24V RB25DET Forged piston set WISECO"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 777.98,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 653.7625,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 829.84,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 697.34666666667,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 889.12,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 747.15714285714,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 999.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 840.29411764706,
"shop-customer": "840.29411764706",
"a-dealer": "653.7625",
"b-dealer": "697.34666666667",
"c-dealer": "747.15714285714"
},
"fields": {
"displayGroup": [
"2d1a34a4ba30439144fc348f2a1ff759"
]
},
"sort": [
"",
0,
"0e4d904f4edb4838990d34742cba835b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
8.71 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.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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":"d2e1508eb60b4f51b6d8f3bb04fff2a6"}}}},{"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.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.de44571ddc4e4d0095c01af6ee299351.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.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"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": "d2e1508eb60b4f51b6d8f3bb04fff2a6"
}
}
}
},
{
"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.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|