| 1 |
4.73 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"manufacturer","query":{"term":{"manufacturer.id":"5fd7cdf89e834304ba53206fc435d75a"}}}},{"term":{"active":true}}]}}]}},{"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":["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": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "b58d0c527e824de0a8b66fe4c27fad17",
"_score": null,
"_source": {
"id": "b58d0c527e824de0a8b66fe4c27fad17",
"autoIncrement": 45524.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1,
"productNumber": "2127t26",
"ean": null,
"displayGroup": "061cd4cc726bc2cf8481ba113fe9ddd1",
"sales": 0,
"stock": 1,
"weight": 4.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "5fd7cdf89e834304ba53206fc435d75a",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2020-07-30T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"e7b99030fe7f4e87a5acea3081ff585f",
"45daad3b2bfd42a094d23e97c9b7b5e0",
"b7a1ddc0302043e88da30ffbb1221281"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "e7b99030fe7f4e87a5acea3081ff585f",
"_count": 1
},
{
"id": "45daad3b2bfd42a094d23e97c9b7b5e0",
"_count": 1
},
{
"id": "b7a1ddc0302043e88da30ffbb1221281",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "4cb3582d9dc54cff91d8dc0759213f1b",
"childCount": 0,
"categories": [
{
"id": "45daad3b2bfd42a094d23e97c9b7b5e0",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "V6",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V6",
"5494b24b09d445ebace47112836b4458": "V6"
}
},
{
"id": "b7a1ddc0302043e88da30ffbb1221281",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.7T Biturbo",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.7T Biturbo",
"5494b24b09d445ebace47112836b4458": "2.7T Biturbo"
}
}
],
"manufacturer": {
"id": "5fd7cdf89e834304ba53206fc435d75a",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Auto Verdi Racing",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Car Verdi Racing"
},
"_count": 1
},
"properties": [
{
"id": "22b94ab8174c4a1381fcb616149663a1",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AZB | 265 PS (195 kW)",
"5494b24b09d445ebace47112836b4458": "AZB | 265 ch (195 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AZB | 265 hp (195 kW)"
}
},
{
"id": "32139c2d7fdd42139b3b884ff24e95fe",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A4 \/ S4 \/ RS4",
"5494b24b09d445ebace47112836b4458": "A4 \/ S4 \/ RS4",
"de44571ddc4e4d0095c01af6ee299351": "A4 \/ S4 \/ RS4"
}
},
{
"id": "4b0e2d800e7f4d68881d77c16bc881cc",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.7 Biturbo",
"5494b24b09d445ebace47112836b4458": "2.7 Biturbo",
"de44571ddc4e4d0095c01af6ee299351": "2.7 Biturbo"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "73d1e56990964e2cabb92499ef05003f",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "B5 (Typ 8D) | BJ 1994-2001",
"de44571ddc4e4d0095c01af6ee299351": "B5 (Type 8D) | Year built 1994-2001",
"5494b24b09d445ebace47112836b4458": "B5 (type 8D) | ann\u00e9e de construction 1994-2001"
}
},
{
"id": "a38023d03d1346ac80e2d60262d93979",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AGB | 265 PS (195 kW)",
"5494b24b09d445ebace47112836b4458": "AGB | 265 ch (195 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AGB | 265 hp (195 kW)"
}
},
{
"id": "d3ed6006dcdb47afbb619ad7d1cd12d8",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AZR | 380 PS (280 kW)",
"5494b24b09d445ebace47112836b4458": "AZR | 380 ch (280 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AZR | 380 hp (280 kW)"
}
},
{
"id": "eca79b1b2be7450f97a540c901d0dfb8",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ASJ | 380 PS (280 kW)",
"5494b24b09d445ebace47112836b4458": "ASJ | 380 ch (280 kW)",
"de44571ddc4e4d0095c01af6ee299351": "ASJ | 380 hp (280 kW)"
}
}
],
"options": [],
"categoryIds": [
"45daad3b2bfd42a094d23e97c9b7b5e0",
"b7a1ddc0302043e88da30ffbb1221281"
],
"optionIds": [],
"propertyIds": [
"22b94ab8174c4a1381fcb616149663a1",
"32139c2d7fdd42139b3b884ff24e95fe",
"4b0e2d800e7f4d68881d77c16bc881cc",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"73d1e56990964e2cabb92499ef05003f",
"a38023d03d1346ac80e2d60262d93979",
"d3ed6006dcdb47afbb619ad7d1cd12d8",
"eca79b1b2be7450f97a540c901d0dfb8"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_blog_articles": [
"57baedf2fd1a4948aadc2112b7cfd37b"
],
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"fts_product_kompi_filter_groups": [
"018c3e5dd24078be8fc2d7d2ead2d401"
],
"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": "Billet",
"migration_Shopware5DB_product_bullet3": "extrem leicht & sehr stabil",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "stahlpleuel-h-schaft-auto-verdi-audi-2-7-l-biturbo",
"migration_Shopware5DB_product_dreisc_seo_title": "H-Schaft Stahlpleuel von Auto Verdi f\u00fcr den Audi 2.7L Biturbo",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc&t=2s",
"fts_product_blog_articles": [
"57baedf2fd1a4948aadc2112b7cfd37b"
],
"fts_product_video_1_title": "Pleuel und Pleuelschrauben richtig montieren",
"fts_product_kompi_filter_groups": [
"018c3e5dd24078be8fc2d7d2ead2d401"
],
"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": "Billet",
"migration_Shopware5DB_product_bullet3": "extrem leicht & sehr stabil",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "H-Schaft Stahlpleuel von Auto Verdi f\u00fcr den Audi 2.7L Biturbo",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_blog_articles": [
"57baedf2fd1a4948aadc2112b7cfd37b"
],
"fts_product_video_1_title": "Correctly assemble connecting rod and connecting rod screws",
"fts_product_kompi_filter_groups": [
"018c3e5dd24078be8fc2d7d2ead2d401"
],
"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": "Billet",
"migration_Shopware5DB_product_bullet3": "extremely light & very stable",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "conrods-h-beam-auto-verdi-audi-2-7-l-biturbo",
"migration_Shopware5DB_product_dreisc_seo_title": "H-beam steel con-rods from Auto Verdi for the Audi 2.7L Biturbo",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi 2.7L Biturbo S4 & RS4 H-Schaft Stahlpleuel 154x21mm Auto Verdi",
"5494b24b09d445ebace47112836b4458": "Audi 2.7L Biturbo S4 & RS4 arbre en H \u00e0 baguette en acier 154x21mm Car Verdi",
"de44571ddc4e4d0095c01af6ee299351": "Audi 2.7L Biturbo S4 & RS4 H-Beam Conrods 154x21mm Auto Verdi"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von Auto Verdi f\u00fcr alle Audi 2.7L V6 Biturbo wie im S4 und RS4 B5.\nAb einer Leistung von 500PS empfehlen wir Schmiedepleuel, da die Serienpleuel nicht f\u00fcr hohe Beanspruchungen entwickelt worden sind. Die Auto Verdi Pleuel zeichnen sich durch Top Qualit\u00e4t und beste Verarbeitung aus. In Verbindung mit den 3\/8\" ARP-L19 Schrauben sind diese Pleuel auch f\u00fcr extreme Leistungen geeignet!\nFeatures:\n\nhoch-fest aus dem Vollen gefr\u00e4st\ngeeignet f\u00fcr extreme Leistungssteigerungen von 1000 PS und mehr\nextrem leicht und sehr stabil\nMagnaflux inspiziert\n6 St\u00fcck pro Satz\nMit ARP LR19 Dehnschrauben 3\/8\"\nKurbelgeh\u00e4use Durchmesser: 57,61 mm\nBreite an der Kubelwelle: 20,21 mm\nBreite am Kolbenbolzen: 21,870 mm\nMade in Schweden\n\n154mm L\u00e4nge mit 21mm Kolbenbolzen.\nDie Pleuel k\u00f6nnen nur mit den RS4 Pleuellagerschalen verbaut werden. Nur in dieser Kombination k\u00f6nnen die Pleuel dann auch in den anderen (siehe unten) 2.7L V6 Motoren verbaut werden\nAudi V6 2.7L Biturbo mit Motorcode AZB, AGB, AJK, AZA, ARE, BES, ASJ\nWeitere Informationen zum korrekten Anziehen der Pleuelschrauben HIER",
"5494b24b09d445ebace47112836b4458": "Biellettes sp\u00e9ciales de l'arbre en H d'Auto Verdi pour toutes les Audi 2,7L V6 Biturbo comme dans les S4 et RS4 B5.\n\u00c0 partir d'une puissance de 500PS, nous recommandons des bielles forg\u00e9es, car les bielles standard ne sont pas con\u00e7ues pour des charges \u00e9lev\u00e9es. Les bielles Auto Verdi sont caract\u00e9ris\u00e9es par une qualit\u00e9 sup\u00e9rieure et une fabrication soign\u00e9e. En combinaison avec les vis 3\/8\" ARP-L19, ces bielles sont \u00e9galement adapt\u00e9es \u00e0 des performances extr\u00eames !\nCaract\u00e9ristiques :\n\nhaute r\u00e9sistance moulue \u00e0 partir du solide\nconvient pour des augmentations de puissance extr\u00eames de 1000 HP et plus\nextr\u00eamement l\u00e9ger et tr\u00e8s stable\nMagnaflux inspect\u00e9\n6 pi\u00e8ces par s\u00e9rie\nAvec des vis d'expansion ARP LR19 de 3\/8\".\nDiam\u00e8tre du carter : 57,61 mm\nLargeur \u00e0 l'arbre \u00e0 cames : 20,21 mm\nLargeur \u00e0 l'axe du piston : 21,870 mm\nFabriqu\u00e9 en Su\u00e8de\n\nLongueur de 154 mm avec axe de piston de 21 mm.\nLes bielles ne peuvent \u00eatre install\u00e9es qu'avec les coussinets de bielle RS4. Ce n'est que dans cette combinaison que les bielles peuvent \u00eatre utilis\u00e9es dans les autres moteurs V6 de 2,7 litres (voir ci-dessous)\nAudi V6 2.7L Biturbo avec code moteur AZB, AGB, AJK, AZA, ARE, BES, ASJ\n \nVoici notre vid\u00e9o pour l'installation correcte des bielles et des boulons de bielle :\n\n",
"de44571ddc4e4d0095c01af6ee299351": "Special H-connecting rods from Auto Verdi for all Audi 2.7L V6 biturbo as in the S4 and RS4 B5.\nWe recommend forged connecting rods from a power of 500PS upwards, since the standard connecting rods have not been developed for high loads. The Auto Verdi connecting rods are characterized by top quality and best workmanship. In conjunction with the 3\/8 \"ARP-L19 screws, these connecting rods are also suitable for extreme performance!\nFeatures:\n\nhigh-strength milled from solid\nsuitable for extreme performance increases of 1000 HP and more\nextremely light and very stable\nInspected Magnaflux\n6 pieces per set\nWith ARP LR19 expansion screws 3\/8\"\nCrankcase diameter: 57.61 mm\nWidth on the Crankshaft: 20.21 mm\nWidth on the piston pin: 21.870 mm\nMade in Sweden\n\n154mm length with 21mm piston pin.\nThe conrods can only be installed with the RS4 bearing shells. Only in this combination the rods can also be installed in the other (see under) 2.7L V6 engines.\nAudi V6 2.7L biturbo with engine code AZB, AGB, AJK, AZA, ARE, BES, ASJ\n\nMore information on how to properly tighten the connecting rod bolts"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi 2.7T Biturbo & 2.8L V6 H-Schaft Stahl Pleuel 154x21mm Auto Verdi",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "H-beam steel con-rods from Auto Verdi for the Audi 2.7L Biturbo"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochfeste Stahlpleuel f\u00fcr Leistungssteigerungen bis zu 1000 PS! \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "High-strength steel con-rods for increased performance up to 1000 HP! \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1743.49,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1465.1162790698,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1723.45,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1448.275862069,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1764,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1482.3529411765,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1919.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1613.4033613445,
"shop-customer": "1613.4033613445",
"b-dealer": "1465.1162790698",
"a-dealer": "1448.275862069",
"c-dealer": "1482.3529411765"
},
"fields": {
"displayGroup": [
"061cd4cc726bc2cf8481ba113fe9ddd1"
]
},
"sort": [
"",
0,
"b58d0c527e824de0a8b66fe4c27fad17"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
9.55 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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["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}}]}},{"bool":{"should":[{"bool":{"must":[{"nested":{"path":"manufacturer","query":{"term":{"manufacturer.id":"5fd7cdf89e834304ba53206fc435d75a"}}}},{"term":{"active":true}}]}}]}},{"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-filter":{"nested":{"path":"properties"},"aggregations":{"properties-filter":{"filter":{"terms":{"properties.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}}}},"options-filter":{"nested":{"path":"options"},"aggregations":{"options-filter":{"filter":{"terms":{"options.groupId":["a8bf3b8377cb4590865f2dbe94ba8d0a","711e47e772ca4a4ab448b7212cbf19cb"]}},"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"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.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.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"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
}
}
]
}
},
{
"bool": {
"should": [
{
"bool": {
"must": [
{
"nested": {
"path": "manufacturer",
"query": {
"term": {
"manufacturer.id": "5fd7cdf89e834304ba53206fc435d75a"
}
}
}
},
{
"term": {
"active": true
}
}
]
}
}
]
}
},
{
"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-filter": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties-filter": {
"filter": {
"terms": {
"properties.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
}
}
},
"options-filter": {
"nested": {
"path": "options"
},
"aggregations": {
"options-filter": {
"filter": {
"terms": {
"options.groupId": [
"a8bf3b8377cb4590865f2dbe94ba8d0a",
"711e47e772ca4a4ab448b7212cbf19cb"
]
}
},
"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"
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|