| 1 |
4.67 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":"c368a8ab2f4148889b2e8dc9e2f1ba82"}}}},{"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": 9,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "351c91295a764be194bb401ba4eae4e1",
"_score": null,
"_source": {
"id": "351c91295a764be194bb401ba4eae4e1",
"autoIncrement": 50104.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21op012.1",
"ean": null,
"displayGroup": "2dd590df8f896462a50042d6f16f07f7",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6aadff5484494e05b2cd9cd32ec57924",
"manufacturerNumber": "JE-298741",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"3f77ad1cbf224a22a74f443feffdd539",
"c368a8ab2f4148889b2e8dc9e2f1ba82",
"dd423f04067c42059fc90c7bd91c59f6"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "3f77ad1cbf224a22a74f443feffdd539",
"_count": 1
},
{
"id": "c368a8ab2f4148889b2e8dc9e2f1ba82",
"_count": 1
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "8147d2f14d594d4692371b229d054bed",
"coverId": "8974a169f75e435bb7df351ea6afc79e",
"childCount": 0,
"categories": [
{
"id": "c368a8ab2f4148889b2e8dc9e2f1ba82",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V C20XE",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V C20XE",
"5494b24b09d445ebace47112836b4458": "2.0L 16V C20XE"
}
},
{
"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": "00ed1377450b4445a73ef242cf270127",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel \/ Vauxhall",
"5494b24b09d445ebace47112836b4458": "Opel \/ Vauxhall",
"de44571ddc4e4d0095c01af6ee299351": "Opel \/ Vauxhall"
}
},
{
"id": "45ccda450b7543de8ba4eb5e1ee1cb68",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "C20XE | 150 PS (110 kW)",
"5494b24b09d445ebace47112836b4458": "C20XE | 150 ch (110 kW)",
"de44571ddc4e4d0095c01af6ee299351": "C20XE | 150 hp (110 kW)"
}
},
{
"id": "4b18a1fbfa7640aaa9c8bf51d90d7e0d",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vectra",
"5494b24b09d445ebace47112836b4458": "Vectra",
"de44571ddc4e4d0095c01af6ee299351": "Vectra"
}
},
{
"id": "5192322983854718a9849ee08428c311",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "Cadet",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kadett",
"de44571ddc4e4d0095c01af6ee299351": "Kadett"
}
},
{
"id": "642106eee91348aca2f49bb4ba6665fe",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F | BJ 1992-2002",
"5494b24b09d445ebace47112836b4458": "F | ANN\u00c9E 1992-2002",
"de44571ddc4e4d0095c01af6ee299351": "F | Year built 1992-2002"
}
},
{
"id": "6b61f478369d413e8aefddd55ecb3bb4",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E | BJ 1984-1993",
"5494b24b09d445ebace47112836b4458": "E | ANN\u00c9E 1984-1993",
"de44571ddc4e4d0095c01af6ee299351": "E | Year built 1984-1993"
}
},
{
"id": "bdfb2505349b462ebf7bb03cd94dcff8",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Calibra",
"5494b24b09d445ebace47112836b4458": "Calibra",
"de44571ddc4e4d0095c01af6ee299351": "Calibra"
}
},
{
"id": "dbf30fc3bc1447a6afb7d972e228c925",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A | BJ 1988-1995",
"5494b24b09d445ebace47112836b4458": "A | BJ 1988-1995",
"de44571ddc4e4d0095c01af6ee299351": "A | Year built 1988-1995"
}
},
{
"id": "edafcc8952be4906b8d8e9188adb407c",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Calibra | BJ 1989-1997",
"5494b24b09d445ebace47112836b4458": "Calibra | BJ 1989-1997",
"de44571ddc4e4d0095c01af6ee299351": "Calibra | Year built 1989-1997"
}
},
{
"id": "f4dced69f17c403180381f26f5810c08",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "2.0 16V (C20)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 (Family 2)",
"5494b24b09d445ebace47112836b4458": "2.0 (Famille 2)"
}
},
{
"id": "fc6646f55cbf43ac90c2ad35172e66f4",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Astra",
"5494b24b09d445ebace47112836b4458": "Astra",
"de44571ddc4e4d0095c01af6ee299351": "Astra"
}
}
],
"options": [
{
"id": "14dabfb424e74219993ad3f6f9c4b0dd",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "86,50 mm \/ 10,5:1",
"5494b24b09d445ebace47112836b4458": "86,50 mm \/ 10,5:1",
"de44571ddc4e4d0095c01af6ee299351": "86.50 mm \/ 10.5:1"
}
}
],
"categoryIds": [
"c368a8ab2f4148889b2e8dc9e2f1ba82",
"dd423f04067c42059fc90c7bd91c59f6"
],
"optionIds": [
"14dabfb424e74219993ad3f6f9c4b0dd"
],
"propertyIds": [
"00ed1377450b4445a73ef242cf270127",
"45ccda450b7543de8ba4eb5e1ee1cb68",
"4b18a1fbfa7640aaa9c8bf51d90d7e0d",
"5192322983854718a9849ee08428c311",
"642106eee91348aca2f49bb4ba6665fe",
"6b61f478369d413e8aefddd55ecb3bb4",
"bdfb2505349b462ebf7bb03cd94dcff8",
"dbf30fc3bc1447a6afb7d972e228c925",
"edafcc8952be4906b8d8e9188adb407c",
"f4dced69f17c403180381f26f5810c08",
"fc6646f55cbf43ac90c2ad35172e66f4"
],
"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": "opel-2-0l-16v-c20xe-schmiedekolben-je-kolben",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20XE 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": "Opel 2.0L 16V C20XE 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": "opel-2-0l-16v-c20xe-high-performance-pistons-kit-je",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20XE Schmiedekolben-Satz JE",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20XE Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": "Jeu de pistons forg\u00e9s Opel 2.0L 16V C20XE JE",
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20XE High Performance Pistons-Kit JE"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von JE Piston f\u00fcr alle Opel 2.0L 16V C20XE.\nFeatures:\n\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch f\u00fcr Serienbohrung 86,00mm\n21mm 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) Da die Serienpleuel einer Leistungssteigerung ab 300 PS nicht standhalten, empfehlen wir Stahlpleuel zu verwenden. (Abbildung \u00e4hnlich)",
"5494b24b09d445ebace47112836b4458": "Pistons haute performance forg\u00e9s de JE Piston pour toutes les Opel 2.0L 16V C20XE.\nCaract\u00e9ristiques :\n\nExtr\u00eamement l\u00e9ger gr\u00e2ce \u00e0 un alliage sp\u00e9cial\nRenforc\u00e9 pour une performance maximale\n\u00c9galement pour les s\u00e9ries de 86,00mm\nAxe de piston de 21 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) Comme les bielles standard ne supportent pas une augmentation de puissance \u00e0 partir de 300 HP, nous recommandons d'utiliser des bielles en acier. (Image similaire) ",
"de44571ddc4e4d0095c01af6ee299351": "High Performance Pistons kit for all Opel 2.0L 16V C20XE engines.\r\nFeatures:\r\n\r\nmuch lighter\r\nreinforced\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 86,00mm\r\n21mm piston pin diameter\r\n\r\nThe 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": "Opel 2.0L 16V C20XE Schmiedekolben-Satz JE",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20XE High Performance Pistons-Kit JE"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 664.9,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 558.74285714286,
"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_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 930.87,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 782.24369747899,
"shop-customer": "782.24369747899",
"c-dealer": "558.74285714286",
"b-dealer": "521.49333333333",
"a-dealer": "488.9"
},
"fields": {
"displayGroup": [
"2dd590df8f896462a50042d6f16f07f7"
]
},
"sort": [
"",
0,
"351c91295a764be194bb401ba4eae4e1"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "5663bcd96c024602b90c02892c78104d",
"_score": null,
"_source": {
"id": "5663bcd96c024602b90c02892c78104d",
"autoIncrement": 46682.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21op003",
"ean": null,
"displayGroup": "0a5aa28afd5ab447bd6d8ab7abc89f2c",
"sales": 0,
"stock": 0,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "73b7e885f67d4e63844ce268112d265f",
"manufacturerNumber": "WKE163M86AP",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"3f77ad1cbf224a22a74f443feffdd539",
"685cf0aa104740fc8ff09754472d4913",
"c368a8ab2f4148889b2e8dc9e2f1ba82"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "3f77ad1cbf224a22a74f443feffdd539",
"_count": 1
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1
},
{
"id": "c368a8ab2f4148889b2e8dc9e2f1ba82",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "e1bd224c11c7486b897a8525cf88a7ca",
"coverId": "b60bd9a6dd1148fa8bfad6e0ea56cbde",
"childCount": 0,
"categories": [
{
"id": "c368a8ab2f4148889b2e8dc9e2f1ba82",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V C20XE",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V C20XE",
"5494b24b09d445ebace47112836b4458": "2.0L 16V C20XE"
}
},
{
"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": "00ed1377450b4445a73ef242cf270127",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel \/ Vauxhall",
"5494b24b09d445ebace47112836b4458": "Opel \/ Vauxhall",
"de44571ddc4e4d0095c01af6ee299351": "Opel \/ Vauxhall"
}
},
{
"id": "45ccda450b7543de8ba4eb5e1ee1cb68",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "C20XE | 150 PS (110 kW)",
"5494b24b09d445ebace47112836b4458": "C20XE | 150 ch (110 kW)",
"de44571ddc4e4d0095c01af6ee299351": "C20XE | 150 hp (110 kW)"
}
},
{
"id": "4b18a1fbfa7640aaa9c8bf51d90d7e0d",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Vectra",
"5494b24b09d445ebace47112836b4458": "Vectra",
"de44571ddc4e4d0095c01af6ee299351": "Vectra"
}
},
{
"id": "5192322983854718a9849ee08428c311",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "Cadet",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kadett",
"de44571ddc4e4d0095c01af6ee299351": "Kadett"
}
},
{
"id": "642106eee91348aca2f49bb4ba6665fe",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F | BJ 1992-2002",
"5494b24b09d445ebace47112836b4458": "F | ANN\u00c9E 1992-2002",
"de44571ddc4e4d0095c01af6ee299351": "F | Year built 1992-2002"
}
},
{
"id": "6b61f478369d413e8aefddd55ecb3bb4",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E | BJ 1984-1993",
"5494b24b09d445ebace47112836b4458": "E | ANN\u00c9E 1984-1993",
"de44571ddc4e4d0095c01af6ee299351": "E | Year built 1984-1993"
}
},
{
"id": "bdfb2505349b462ebf7bb03cd94dcff8",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Calibra",
"5494b24b09d445ebace47112836b4458": "Calibra",
"de44571ddc4e4d0095c01af6ee299351": "Calibra"
}
},
{
"id": "dbf30fc3bc1447a6afb7d972e228c925",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A | BJ 1988-1995",
"5494b24b09d445ebace47112836b4458": "A | BJ 1988-1995",
"de44571ddc4e4d0095c01af6ee299351": "A | Year built 1988-1995"
}
},
{
"id": "edafcc8952be4906b8d8e9188adb407c",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Calibra | BJ 1989-1997",
"5494b24b09d445ebace47112836b4458": "Calibra | BJ 1989-1997",
"de44571ddc4e4d0095c01af6ee299351": "Calibra | Year built 1989-1997"
}
},
{
"id": "f4dced69f17c403180381f26f5810c08",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "2.0 16V (C20)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 (Family 2)",
"5494b24b09d445ebace47112836b4458": "2.0 (Famille 2)"
}
},
{
"id": "fc6646f55cbf43ac90c2ad35172e66f4",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Astra",
"5494b24b09d445ebace47112836b4458": "Astra",
"de44571ddc4e4d0095c01af6ee299351": "Astra"
}
}
],
"options": [
{
"id": "f82e6d4109064740ad2a5933fbcf9fd2",
"_count": 1,
"groupId": "1b3988d5c24541b38d14b30f9df96c23",
"group": {
"id": "1b3988d5c24541b38d14b30f9df96c23",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "86,00 mm \/ 12,5:1",
"5494b24b09d445ebace47112836b4458": "86,00 mm \/ 12,5:1",
"de44571ddc4e4d0095c01af6ee299351": "86.00 mm \/ 12.5:1"
}
}
],
"categoryIds": [
"685cf0aa104740fc8ff09754472d4913",
"c368a8ab2f4148889b2e8dc9e2f1ba82"
],
"optionIds": [
"f82e6d4109064740ad2a5933fbcf9fd2"
],
"propertyIds": [
"00ed1377450b4445a73ef242cf270127",
"45ccda450b7543de8ba4eb5e1ee1cb68",
"4b18a1fbfa7640aaa9c8bf51d90d7e0d",
"5192322983854718a9849ee08428c311",
"642106eee91348aca2f49bb4ba6665fe",
"6b61f478369d413e8aefddd55ecb3bb4",
"bdfb2505349b462ebf7bb03cd94dcff8",
"dbf30fc3bc1447a6afb7d972e228c925",
"edafcc8952be4906b8d8e9188adb407c",
"f4dced69f17c403180381f26f5810c08",
"fc6646f55cbf43ac90c2ad35172e66f4"
],
"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": "Hochkleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Extrem leicht",
"migration_Shopware5DB_product_bullet3": "Kolbenhemd beschichtet",
"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": "opel-2-0l-16v-c20xe-schmiedekolben-pistons",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20XE 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": "Hochkleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Extrem leicht",
"migration_Shopware5DB_product_bullet3": "Kolbenhemd beschichtet",
"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": "Opel 2.0L 16V C20XE 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": "Piston skirt coated",
"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": "opel-2-0l-16v-c20xe-high-performance-pistons-kit-wiseco",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20XE Schmiedekolben-Satz WISECO",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20XE Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": "Jeu de pistons forg\u00e9s Opel 2.0L 16V C20XE WISECO",
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20XE High Performance Pistons-Kit WISECO"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben von Wiseco f\u00fcr Opel 2.0L 16V C20XE Motoren.\nFeatures:\n\nOriginal Wiseco\nExtrem leicht durch Speziallegierung\nVerst\u00e4rkt f\u00fcr maximale Leistung\nAuch in Serienbohrung 86,00mm 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 Opel 2.0L 16V C20XE Motoren. Die angegebene Kompression ist in Verbindung mit einer 1,40mm 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 Opel 2.0L 16V C20XE.\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 al\u00e9sage standard 86,00mm\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 Opel 2.0L 16V C20XE. La compression indiqu\u00e9e est en relation avec un joint de culasse de 1,40 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 Opel 2.0L 16V C20XE engine.\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 86,00mm\r\n21mm piston pin diameter\r\nskirt coated for less friction\r\n\r\nThe specified compression is based on a 1,40mm head gasket. The picture is similar."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20XE Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20XE High Performance Pistons-Kit WISECO"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 678.3,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 570.0,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 678.3,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 570.0,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 678.3,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 570.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 999.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 840.3025210084,
"shop-customer": "840.3025210084",
"a-dealer": "570.0",
"c-dealer": "570.0",
"b-dealer": "570.0"
},
"fields": {
"displayGroup": [
"0a5aa28afd5ab447bd6d8ab7abc89f2c"
]
},
"sort": [
"",
0,
"5663bcd96c024602b90c02892c78104d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.61 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":"c368a8ab2f4148889b2e8dc9e2f1ba82"}}}},{"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": "c368a8ab2f4148889b2e8dc9e2f1ba82"
}
}
}
},
{
"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
|