| 1 |
4.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.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":"14cabcacfdc44fb896fd98e0be238b48"}}}},{"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": 1,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "24d7ff8b469942bc816b3b2b6e76eddf",
"_score": null,
"_source": {
"id": "24d7ff8b469942bc816b3b2b6e76eddf",
"autoIncrement": 45445.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21op033",
"ean": null,
"displayGroup": "a0a6b87a9d44b7c5341cd963ba23d9f1",
"sales": 0,
"stock": 0,
"weight": 3.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4396f92377dd479c96c0d1020a53f5c9",
"manufacturerNumber": "R-OPE-001-I",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"66983bdc2764477ca97fc114c7e7ad3b",
"14cabcacfdc44fb896fd98e0be238b48",
"776c1977e4da421e973434cd65dc2928",
"92ea3f04f5c84f7994f7fa88514cfa92"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "66983bdc2764477ca97fc114c7e7ad3b",
"_count": 1
},
{
"id": "14cabcacfdc44fb896fd98e0be238b48",
"_count": 1
},
{
"id": "776c1977e4da421e973434cd65dc2928",
"_count": 1
},
{
"id": "92ea3f04f5c84f7994f7fa88514cfa92",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "7b71426d8995421fa96b5ef4220d90ee",
"childCount": 0,
"categories": [
{
"id": "92ea3f04f5c84f7994f7fa88514cfa92",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Biela ZRP",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZRP Pleuel",
"5494b24b09d445ebace47112836b4458": "ZRP bielle",
"de44571ddc4e4d0095c01af6ee299351": "ZRP Con-Rods"
}
},
{
"id": "776c1977e4da421e973434cd65dc2928",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L C20XE",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L C20XE",
"5494b24b09d445ebace47112836b4458": "2.0L C20XE"
}
},
{
"id": "14cabcacfdc44fb896fd98e0be238b48",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L C20LET",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L C20LET",
"5494b24b09d445ebace47112836b4458": "2.0L C20LET"
}
}
],
"manufacturer": {
"id": "4396f92377dd479c96c0d1020a53f5c9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZRP",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "ZRP"
},
"_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": "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": "bdfb2505349b462ebf7bb03cd94dcff8",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Calibra",
"5494b24b09d445ebace47112836b4458": "Calibra",
"de44571ddc4e4d0095c01af6ee299351": "Calibra"
}
},
{
"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": "f69b86a771554a0bb44b0f34cf09c8d2",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "C20LET | 204 PS (150 kW)",
"5494b24b09d445ebace47112836b4458": "C20LET | 204 ch (150 kW)",
"de44571ddc4e4d0095c01af6ee299351": " C20LET | 204 hp (150 kW)"
}
},
{
"id": "fc6646f55cbf43ac90c2ad35172e66f4",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Astra",
"5494b24b09d445ebace47112836b4458": "Astra",
"de44571ddc4e4d0095c01af6ee299351": "Astra"
}
}
],
"options": [],
"categoryIds": [
"14cabcacfdc44fb896fd98e0be238b48",
"776c1977e4da421e973434cd65dc2928",
"92ea3f04f5c84f7994f7fa88514cfa92"
],
"optionIds": [],
"propertyIds": [
"00ed1377450b4445a73ef242cf270127",
"45ccda450b7543de8ba4eb5e1ee1cb68",
"642106eee91348aca2f49bb4ba6665fe",
"bdfb2505349b462ebf7bb03cd94dcff8",
"edafcc8952be4906b8d8e9188adb407c",
"f4dced69f17c403180381f26f5810c08",
"f69b86a771554a0bb44b0f34cf09c8d2",
"fc6646f55cbf43ac90c2ad35172e66f4"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"fts_product_video_1_description": "In diesem Video zeigt dir Bartek, wie dir die richtige Montage der Pleuel und Pleuelschrauben von ARP gelingt! Bartek erkl\u00e4rt dir zum Beispiel, worauf du beim Schrauben anziehen achten musst. Du bekommst zum Thema Pleuelschrauben wichtige Tips und Tricks direkt vom Experten. Au\u00dferdem zeigt er dir den richtigen Umgang mit der Federwaage und erkl\u00e4rt, was beim Pleuellagerspiel wichtig ist. Wann man den Drehmomentschl\u00fcssel einsetzen sollte und welche Rolle die Messuhr beim Einbauen spielt, erf\u00e4hrst du alles in diesem Video von Bartek Motorsport. Das richtige Werkzeug daf\u00fcr, wie Wiseco Kolben oder Pleuel Winkeln ist die halbe Miete. Diese und viele weitere passende Werkzeuge findet Ihr direkt in unserem Shop: https:\/\/www.bar-tek-tuning.de\/messuhr-pleuelschrauben-bar-tek https:\/\/www.bar-tek-tuning.de\/arp2000-pleuelschrauben-pleuel-2006209 https:\/\/www.bar-tek-tuning.de\/pleuel-richtig-anziehen Lasst bei Fragen oder Anregungen einen Kommentar unter diesem Video da oder meldet euch einfach telefonisch \/ per Email. @: info@bar-tek.de +49(0)2207\/7056916 Folgt uns unbedingt auch auf unseren Social Media Kan\u00e4len! Ihr findet uns auch auf Facebook: https:\/\/de-de.facebook.com\/BARTEK.Motorsport Checkt jetzt unseren Instagram Kanal aus: https:\/\/www.instagram.com\/bartekmotorsport\/?hl=de #pleuel #federwaage #pleuellagerschaden",
"fts_product_video_1_upload_date": "2020-01-06 13:30:12.000",
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "H-Schaft Stahlpleuel",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Aus dem Vollen gefr\u00e4st",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Sehr stabil",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "stahlpleuel-zrp-opel-c20xe",
"migration_Shopware5DB_product_dreisc_seo_title": "Stahlpleuel I-Schaft von ZRP f\u00fcr den Opel 2.0L 16V C20XE\/LET",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc&t=2s",
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "H-Schaft Stahlpleuel",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Aus dem Vollen gefr\u00e4st",
"migration_Shopware5DB_product_bullet3": "Extrem leicht",
"migration_Shopware5DB_product_bullet4": "Sehr stabil",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Stahlpleuel I-Schaft von ZRP f\u00fcr den Opel 2.0L 16V C20XE\/LET",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_video_1_title": "Correctly assemble connecting rod and connecting rod screws",
"migration_Shopware5DB_product_attr14": "2820",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "H-Shaft Steel Connecting Rod",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Milled from the solid",
"migration_Shopware5DB_product_bullet3": "Extremely light",
"migration_Shopware5DB_product_bullet4": "Very stable",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "con-rods-zrp-opel-c20xe",
"migration_Shopware5DB_product_dreisc_seo_title": "ZRP I-Beam connecting rods for Opel 2.0L 16V C20XE\/LET",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20XE\/LET Stahlpleuel I-Schaft ZRP",
"5494b24b09d445ebace47112836b4458": "Opel 2.0L 16V C20XE\/LET arbre en I \u00e0 bielle en acier ZRP",
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20XE\/LET I-Beam Conrods ZRP"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stabile I-Schaft Pleuel aus Stahl f\u00fcr C20 Motoren\nI-Schaft Stahlpleuel f\u00fcr alle C20 Motoren sind konstruiert f\u00fcr eine extreme Leistungssteigerung bis zu 800 PS. Damit erh\u00f6hst du die Performance deines Opel gewaltig. Ab einer Leistung von 300PS solltest du unbedingt auf die Pleuel aufr\u00fcsten, da die Originalparts diese hohe Belastung nicht aushalten und brechen k\u00f6nnen.\nDank des I-Schafts Profil sind diese Pleuel extrem robust und weisen eine sehr hohe Torsionsbest\u00e4ndigkeit auf. Die Belastungen werden reduziert und auf den Pleuel verteilt, weshalb sie auch sehr best\u00e4ndig sind. Obwohl sie vor Stabilit\u00e4t strotzen, sind die Pleuel extrem leicht: Bei der Leistungssteigerung z\u00e4hlt schlie\u00dflich jedes Gramm.\nAlle Pleuel von ZRP werden exakt gewinkelt und getestet. Mit dabei sind nat\u00fcrlich 3\/8\" ARP 2000 Dehnschrauben und die Montagepaste. Bei der Montage gilt es einiges zu beachten, deshalb haben wir ein paar Infos zum korrekten Anziehen der Pleuelschrauben f\u00fcr dich zusammengefasst!\nFeatures der I-Schaft Pleuel:\n\naus dem Vollen gefr\u00e4st und deshalb sehr robust\ngeeignet f\u00fcr extreme Leistungssteigerungen bis ca. 800 PS\nextrem leicht und sehr stabil\nMagnaflux inspiziert\n4 St\u00fcck pro Satz\nMa\u00dfe 143 x 21 mm\nMit ARP 2000 Dehnschrauben 3\/8\"\nARP Montagepaste\n",
"5494b24b09d445ebace47112836b4458": "Bielle en acier stable \u00e0 arbre en I pour les moteurs C20\nLes bielles en acier de l'arbre en I de tous les moteurs C20 sont con\u00e7ues pour uneaugmentation extr\u00eame desperformances jusqu'\u00e0 800 HP. Vous augmentez ainsi consid\u00e9rablement les performances de votre Opel. \u00c0 partir d'une puissance de 300 ch, il faut absolument passer aux bielles, car les pi\u00e8ces d'origine ne peuvent pas supporter cette charge \u00e9lev\u00e9e et se brisent.\nGr\u00e2ce au profil de l'arbre en I, ces bielles sont extr\u00eamement robustes et pr\u00e9sentent une tr\u00e8s grande r\u00e9sistance \u00e0 la torsion. Les charges sont r\u00e9duites et r\u00e9parties sur la bielle, ce qui explique qu'elles soient \u00e9galement tr\u00e8s durables. Bien qu'ils soient pleins de stabilit\u00e9 , les b\u00e2tonnets sontextr\u00eamement l\u00e9gers: apr\u00e8s tout, chaque gramme compte lorsqu'il s'agit d'augmenter les performances.\nToutes les bielles de la ZRP sonttest\u00e9es sur le site , avec unangle pr\u00e9cis et . Sont bien s\u00fbr inclus les boulons d'expansion ARP 2000 de 3\/8\" et la p\u00e2te de montage. Il y a quelques \u00e9l\u00e9ments \u00e0 prendre en compte lors du montage, c'est pourquoi nous avons r\u00e9sum\u00e9 pour vous quelques informations sur le \nCaract\u00e9ristiques de la Tige de bielle en I :\n\nmoulue \u00e0 partir du solide et donc tr\u00e8s robuste\nconvient pour des augmentations de puissance extr\u00eames jusqu'\u00e0 environ 800 HP\nextr\u00eamement l\u00e9ger et tr\u00e8s stable\nMagnaflux inspect\u00e9\n4 pi\u00e8ces par ensemble\nDimensions 143 x 21 mm\nAvec des vis d'expansion ARP 2000 de 3\/8\".\nP\u00e2te d'assemblage ARP\n",
"de44571ddc4e4d0095c01af6ee299351": "Sturdy steel I-Beam connecting rods for C20 engines\nI-beam steel connecting rods for all C20 engines, are designed for an extreme performance increase up to 600 hp. This will increase the performance of your Opel\/Vauxhall enormously. From a performance of 300 hp you should upgrade to these connecting rods, as the original parts cannot withstand and tear this high load.\nThanks to the I-beam these connecting rods are extremely robust and have a very high torsion resistance. The loads are reduced and distributed to the connecting rod, which is why they are also very crack-resistant. Although they are full of stability, these connecting rods are extremely light: every gram counts when it comes to increasing performance.\nAll ZRP connecting rods are precisely angled and tested. Included are of course 3\/8\" ARP 2000 expansion bolts and the assembly paste. There are a few things to keep in mind during assembly, so we've summarized some information on how to tighten the connecting rod bolts correctly for you!\nFeatures of I-Beam connecting rods:\n\nmilled from solid material and therefore very robust\nsuitable for extreme performance increases up to approx. 800 hp\nextremely light and very stable\nMagnaflux inspected\n4 pieces per set\nDimensions 143 x 21 mm\nWith ARP 2000 expansion bolts 3\/8\"\nARP Assembly paste\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20XE\/LET Stahlpleuel I-Schaft ZRP",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "ZRP I-Beam connecting rods for Opel 2.0L 16V C20XE\/LET"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F\u00fcr extreme Leistungssteigerungen bis zu 800 PS geeignet! \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "For extreme performance increases up to 800 hp suitable! \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae approved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 554.8434619,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 466.25501,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 554.8434619,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 466.25501,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 554.8434619,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 466.25501,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 625.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 526.01680672269,
"shop-customer": "526.01680672269",
"c-dealer": "466.25501",
"a-dealer": "466.25501",
"b-dealer": "466.25501"
},
"fields": {
"displayGroup": [
"a0a6b87a9d44b7c5341cd963ba23d9f1"
]
},
"sort": [
"",
0,
"24d7ff8b469942bc816b3b2b6e76eddf"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "3e99d2d6588b4fa7828f28f5168b1dd5",
"_score": null,
"_source": {
"id": "3e99d2d6588b4fa7828f28f5168b1dd5",
"autoIncrement": 59642.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "k1c20let",
"ean": null,
"displayGroup": "1144f1d0f0a3c0947961988433fb86e5",
"sales": 0,
"stock": 0,
"weight": 4.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "bf196e6048be4b1eb93b2a1f7cb02296",
"manufacturerNumber": "042DO16143",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"66983bdc2764477ca97fc114c7e7ad3b",
"009f131b1e6341e29d97811901c473b2",
"14cabcacfdc44fb896fd98e0be238b48"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "66983bdc2764477ca97fc114c7e7ad3b",
"_count": 1
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1
},
{
"id": "14cabcacfdc44fb896fd98e0be238b48",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "a70c8e7122074927aa960e22e22c78f2",
"childCount": 0,
"categories": [
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
},
{
"id": "14cabcacfdc44fb896fd98e0be238b48",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L C20LET",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L C20LET",
"5494b24b09d445ebace47112836b4458": "2.0L C20LET"
}
}
],
"manufacturer": {
"id": "bf196e6048be4b1eb93b2a1f7cb02296",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "K1"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"14cabcacfdc44fb896fd98e0be238b48"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"fts_product_video_1_description": "In diesem Video zeigt dir Bartek, wie dir die richtige Montage der Pleuel und Pleuelschrauben von ARP gelingt! Bartek erkl\u00e4rt dir zum Beispiel, worauf du beim Schrauben anziehen achten musst. Du bekommst zum Thema Pleuelschrauben wichtige Tips und Tricks direkt vom Experten. Au\u00dferdem zeigt er dir den richtigen Umgang mit der Federwaage und erkl\u00e4rt, was beim Pleuellagerspiel wichtig ist. Wann man den Drehmomentschl\u00fcssel einsetzen sollte und welche Rolle die Messuhr beim Einbauen spielt, erf\u00e4hrst du alles in diesem Video von Bartek Motorsport. Das richtige Werkzeug daf\u00fcr, wie Wiseco Kolben oder Pleuel Winkeln ist die halbe Miete. Diese und viele weitere passende Werkzeuge findet Ihr direkt in unserem Shop: https:\/\/www.bar-tek-tuning.de\/messuhr-pleuelschrauben-bar-tek https:\/\/www.bar-tek-tuning.de\/arp2000-pleuelschrauben-pleuel-2006209 https:\/\/www.bar-tek-tuning.de\/pleuel-richtig-anziehen Lasst bei Fragen oder Anregungen einen Kommentar unter diesem Video da oder meldet euch einfach telefonisch \/ per Email. @: info@bar-tek.de +49(0)2207\/7056916 Folgt uns unbedingt auch auf unseren Social Media Kan\u00e4len! Ihr findet uns auch auf Facebook: https:\/\/de-de.facebook.com\/BARTEK.Motorsport Checkt jetzt unseren Instagram Kanal aus: https:\/\/www.instagram.com\/bartekmotorsport\/?hl=de #pleuel #federwaage #pleuellagerschaden",
"fts_product_video_1_upload_date": "2020-01-06 13:30:12.000",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Spezial H-Schaftpleuel",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "extrem leicht",
"migration_Shopware5DB_product_bullet3": "sehr stabil",
"migration_Shopware5DB_product_bullet4": "aus dem Vollen gefr\u00e4st",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "opel-2-0l16v-c20let-stahl-pleuel-conrods-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20LET Stahl Pleuel H-Schaft K1",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc&t=2s",
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Spezial H-Schaftpleuel",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "extrem leicht",
"migration_Shopware5DB_product_bullet3": "sehr stabil",
"migration_Shopware5DB_product_bullet4": "aus dem Vollen gefr\u00e4st",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20LET Stahl Pleuel H-Schaft K1",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_video_1_title": "Correctly assemble connecting rod and connecting rod screws",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Special H-Shaft Connecting Rod",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Very light",
"migration_Shopware5DB_product_bullet3": "Very stable",
"migration_Shopware5DB_product_bullet4": "Milled from the solid",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "opel-2-0l-16v-c20let-conrods-motorsport-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Opel 2.0L 16V C20LET Stahl Pleuel H-Schaft K1",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20LET Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": "Opel 2.0L 16V C20LET acier Pleuel arbre en H K1",
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20LET Conrods Motorsport K1"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von K1 f\u00fcr alle Opel 2.0L 16V C20LET Motoren. Bei hohen Leistungssteigerungen notwendig, da die Serienpleuel nicht f\u00fcr hohe Beanspruchungen entwickelt worden sind. Original K1hoch-fest aus dem Vollen gefr\u00e4stgeeignet f\u00fcr hohe Leistungssteigerungenextrem leicht und sehr stabil4 St\u00fcck pro SatzMit ARP 2000 Dehnschrauben 3\/8\"ARP Montagepaste Die K1 Stahlpleuel sind passend f\u00fcr alle Opel 2.0L 16V C20LET Motoren mit 143x21mm Pleuel. Weitere Informationen zum korrekten Anziehen der Pleuelschrauben HIER (Beispielbild, geliefert werden 4 Stk.)",
"5494b24b09d445ebace47112836b4458": "Bielle sp\u00e9ciale en H de K1 pour tous les moteurs Opel 2.0L 16V C20LET. N\u00e9cessaire \u00e0 l'augmentation des performances, car les bielles en s\u00e9rie n'ont pas \u00e9t\u00e9 d\u00e9velopp\u00e9es pour des charges \u00e9lev\u00e9es. -Original K1 -forter\u00e9sistance frais\u00e9e dans la masse-convient pour les augmentations de performance-extr\u00eamement l\u00e9ger et tr\u00e8s stable-4 pi\u00e8ces par jeu-Avec boulons d'expansion ARP 2000 3\/8\"-P\u00e2te de montage ARP Les bielles en acier K1 conviennent pour toutes les Opel 2.Moteurs 0L 16V C20LET avec bielles 143x21mm. ",
"de44571ddc4e4d0095c01af6ee299351": " \r\nSpezial Conrods by K1 for all Opel 2.0L 16V C20LET engines with engines. Very light and for extreme performance. Including 4 pieces with ARP rod bolts. The K1 conrods will fit for all Opel 2.0L 16V C20LET engines with 143x21mm conrods. (Example picture, it will be delivered 4 pcs.)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Opel 2.0L 16V C20LET Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Opel 2.0L 16V C20LET Conrods Motorsport K1"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 514.71766507,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 432.535853,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 482.559875,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 405.5125,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 514.71766507,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 432.535853,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 680.96,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 572.23529411765,
"shop-customer": "572.23529411765",
"b-dealer": "432.535853",
"a-dealer": "405.5125",
"c-dealer": "432.535853"
},
"fields": {
"displayGroup": [
"1144f1d0f0a3c0947961988433fb86e5"
]
},
"sort": [
"",
0,
"3e99d2d6588b4fa7828f28f5168b1dd5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.31 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":"14cabcacfdc44fb896fd98e0be238b48"}}}},{"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": "14cabcacfdc44fb896fd98e0be238b48"
}
}
}
},
{
"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
|