| 1 |
5.15 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"77bd4a7dec974c9f81c83974d5bfebfc"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "539b52dc34f64ca2ae3b6169247b59b3",
"_score": null,
"_source": {
"id": "539b52dc34f64ca2ae3b6169247b59b3",
"autoIncrement": 46179.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo035",
"ean": null,
"displayGroup": "9fcfe16557be674773fa209c716bf102",
"sales": 0,
"stock": 0,
"weight": 4.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "bf196e6048be4b1eb93b2a1f7cb02296",
"manufacturerNumber": "011EF14149",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"28ef82db85ec40baa6303c59f41b9c68",
"009f131b1e6341e29d97811901c473b2",
"77bd4a7dec974c9f81c83974d5bfebfc"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "28ef82db85ec40baa6303c59f41b9c68",
"_count": 1
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1
},
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "ec136ed5e95546729ebf117a05b1a442",
"childCount": 0,
"categories": [
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
},
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.3L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.3L 16V",
"5494b24b09d445ebace47112836b4458": "2.3L 16V"
}
}
],
"manufacturer": {
"id": "bf196e6048be4b1eb93b2a1f7cb02296",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "K1"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"77bd4a7dec974c9f81c83974d5bfebfc"
],
"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_attr16": "0",
"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": "ford-scorpio-23l-16v-stahl-pleuel-h-schaft-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Scorpio 2.3L 16V 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_attr16": "0",
"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": "Ford Scorpio 2.3L 16V 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_attr16": "0",
"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": "ford-scorpio-23l-16v-stahl-pleuel-h-schaft-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Scorpio 2.3L Rod H-Shank K1",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Scorpio 2.3L 16V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": "Ford Scorpio 2.3L 16V acier Pleuel arbre en H K1",
"de44571ddc4e4d0095c01af6ee299351": "Ford Scorpio 2.3L 16V Conrods Motorsport K1"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von K1 f\u00fcr alle Ford Scorpio 2.3L 16V 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 Ford Scorpio 2.3L 16V Motoren mit 149,30x20mm Pleuel. Weitere Informationen zum korrekten Anziehen der Pleuelschrauben HIER (Beispielbild, geliefert werden 4 Stk.)",
"5494b24b09d445ebace47112836b4458": "Bielle en H sp\u00e9ciale de K1 pour tous les moteurs Ford Scorpio 2,3L 16V. 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 \u00e0 toutes les Ford Scorpio 2.Moteurs 3L 16V avec bielles 149,30x20mm. ",
"de44571ddc4e4d0095c01af6ee299351": "Special H-beam conrod from K1 for all Ford Scorpio 2.3L 16V engines.\n\nNecessary for high power upgrades, as the stock connecting rods are not designed for high stresses.\n\noriginal K1high-strength milled from solid materialsuitable for high power increasesextremely light and very stable4 pieces per setwith ARP 2000 expansion screws 3\/8\"ARP assembly paste\n\nThe K1 steel connecting rods are suitable for all Ford Scorpio 2.3L 16V engines with 149.30x20mm connecting rods.\n\nMore information about the correct tightening of the connecting rod bolts HERE.\n\n(Example picture, 4 pcs. are delivered)\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Scorpio 2.3L 16V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Ford Scorpio 2.3L Rod H-Shank K1"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Special H-beam connecting rod for all Ford Scorpio 2.3L 16V engines for performance. \u2713 15 years motorsport experience \u2713 worldwide shipping \u2713 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 453.42,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 381.02666666667,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 485.81,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 408.24285714286,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 425.08,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 357.2125,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 680.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 571.54,
"shop-customer": "571.54",
"b-dealer": "381.02666666667",
"c-dealer": "408.24285714286",
"a-dealer": "357.2125"
},
"fields": {
"displayGroup": [
"9fcfe16557be674773fa209c716bf102"
]
},
"sort": [
"",
0,
"539b52dc34f64ca2ae3b6169247b59b3"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "913242d786304ff68aedd8bd91aa1d06",
"_score": null,
"_source": {
"id": "913242d786304ff68aedd8bd91aa1d06",
"autoIncrement": 44171.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo033",
"ean": null,
"displayGroup": "f53b5e89e7303c0c9f83c2d8e38a110e",
"sales": 0,
"stock": 0,
"weight": 4.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "bf196e6048be4b1eb93b2a1f7cb02296",
"manufacturerNumber": "011BM16155",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"28ef82db85ec40baa6303c59f41b9c68",
"009f131b1e6341e29d97811901c473b2",
"77bd4a7dec974c9f81c83974d5bfebfc"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "28ef82db85ec40baa6303c59f41b9c68",
"_count": 1
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1
},
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "26e1a93ad89a43148f72ddf206e65b69",
"childCount": 0,
"categories": [
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
},
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.3L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.3L 16V",
"5494b24b09d445ebace47112836b4458": "2.3L 16V"
}
}
],
"manufacturer": {
"id": "bf196e6048be4b1eb93b2a1f7cb02296",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "K1"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"77bd4a7dec974c9f81c83974d5bfebfc"
],
"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": "ford-2-3l16v-focus-duratec-stahl-pleuel-conrods-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus Duratec 2.3L 16V 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": "Ford Focus Duratec 2.3L 16V 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": "ford-2-3l16v-focus-duratec-stahl-pleuel-conrods-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus Duratec 2.3L 16V Stahl Pleuel H-Schaft K1",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus Duratec 2.3L 16V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": "Ford Focus Duratec 2,3L 16V acier Pleuel arbre en H K1",
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus Duratec 2.3L 16V Conrods Motorsport K1"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von K1 f\u00fcr alle Ford Focus Duratec 2.3L 16V 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 Ford Focus Duratec 2.3L 16V Motoren mit 154,80x21mm 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 Ford Focus Duratec 2,3L 16V. 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 \u00e0 toutes les Ford Focus Duratec 2.Moteurs 3L 16V avec bielles 154,80x21mm. ",
"de44571ddc4e4d0095c01af6ee299351": "Special H-beam connecting rod by K1 for all Ford Focus Duratec 2.3L 16V engines.\n\nNecessary for high performance upgrades, as the stock connecting rods are not designed for high stresses.\n\noriginal K1high-strength milled from solid materialsuitable for high power increasesextremely light and very stable4 pieces per setwith ARP 2000 expansion screws 3\/8\"ARP assembly paste\n\nThe K1 steel connecting rods are suitable for all Ford Focus Duratec 2.3L 16V engines with 154,80x21mm connecting rods.\n\nMore information about the correct tightening of the connecting rod bolts HERE.\n\n(Example picture, supplied are 4 pcs.)\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus Duratec 2.3L 16V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus Duratec 2.3L 16V Conrods Motorsport K1"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 425.08,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 357.2125,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 485.81,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 408.24285714286,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 453.42,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 381.02666666667,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 680.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 571.54,
"shop-customer": "571.54",
"a-dealer": "357.2125",
"c-dealer": "408.24285714286",
"b-dealer": "381.02666666667"
},
"fields": {
"displayGroup": [
"f53b5e89e7303c0c9f83c2d8e38a110e"
]
},
"sort": [
"",
0,
"913242d786304ff68aedd8bd91aa1d06"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "fd926e54f3374c06b1deb398a6e4252f",
"_score": null,
"_source": {
"id": "fd926e54f3374c06b1deb398a6e4252f",
"autoIncrement": 47088.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo059",
"ean": null,
"displayGroup": "bfb76fde1b4c9badb6c45a49a09cfacd",
"sales": 0,
"stock": 0,
"weight": 2.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4396f92377dd479c96c0d1020a53f5c9",
"manufacturerNumber": "R-FOR-009-I",
"releaseDate": null,
"createdAt": "2019-07-03T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"28ef82db85ec40baa6303c59f41b9c68",
"77bd4a7dec974c9f81c83974d5bfebfc",
"92ea3f04f5c84f7994f7fa88514cfa92"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "28ef82db85ec40baa6303c59f41b9c68",
"_count": 1
},
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1
},
{
"id": "92ea3f04f5c84f7994f7fa88514cfa92",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "04902e605b9b44beaf82336c1a4c41c8",
"childCount": 0,
"categories": [
{
"id": "77bd4a7dec974c9f81c83974d5bfebfc",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.3L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.3L 16V",
"5494b24b09d445ebace47112836b4458": "2.3L 16V"
}
},
{
"id": "92ea3f04f5c84f7994f7fa88514cfa92",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Biela ZRP",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZRP Pleuel",
"5494b24b09d445ebace47112836b4458": "ZRP bielle",
"de44571ddc4e4d0095c01af6ee299351": "ZRP Con-Rods"
}
}
],
"manufacturer": {
"id": "4396f92377dd479c96c0d1020a53f5c9",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZRP",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "ZRP"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"77bd4a7dec974c9f81c83974d5bfebfc",
"92ea3f04f5c84f7994f7fa88514cfa92"
],
"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 & Pleuelschrauben einsetzten ",
"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-i-schaft-ford-focus-rs-mk3-zrp",
"migration_Shopware5DB_product_dreisc_seo_title": "Stahlpleuel I-Schaft von ZRP f\u00fcr Ford Focus RS MK3 2.3L 16V",
"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 & Pleuelschrauben einsetzten ",
"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 Ford Focus RS MK3 2.3L 16V",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=Im9lvgQ6hBc",
"fts_product_video_1_title": "Insert connecting rod & 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-i-beam-ford-focus-rs-mk3-zrp",
"migration_Shopware5DB_product_dreisc_seo_title": "Con Rods I-Beam by ZRP for Ford Focus RS MK3 2.3L 16V",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK3 2.3L 16V I-Schaft Stahlpleuel ZRP",
"5494b24b09d445ebace47112836b4458": "Ford Focus RS MK3 2,3L 16V arbre en I \u00e0 bielle en acier ZRP",
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus RS MK3 2.3L 16V I-Beam Steel Con-Rods ZRP"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "High Performance I-Schaftpleuel von ZRP f\u00fcr den Ford Focus RS MK3 und Ford Mustang MK6 mit 2.3L 16V Ecoboost Motoren.\nBei hohen Leistungssteigerungen notwendig, da die Serienpleuel nicht f\u00fcr hohe Beanspruchungen entwickelt worden sind.\nFeatures:\n\nOriginal ZRP\nhoch-fest aus dem Vollen gefr\u00e4st\ngeeignet f\u00fcr hohe Leistungssteigerungen\nextrem leicht und sehr stabil\nmit 22,5mm Kolbenbolzen\n4 St\u00fcck pro Satz\nMit ARP 2000 Dehnschrauben 3\/8\"\nARP Montagepaste\n\nDie ZRP Stahlpleuel sind passend f\u00fcr alle 2.3L 16V Ecoboost Motoren mit 149,25 x 22,5mm Pleuel.Weitere Informationen zum korrekten Anziehen der Pleuelschrauben HIER",
"5494b24b09d445ebace47112836b4458": "Biellettes I-Stem haute performance de ZRP pour les Ford Focus RS MK3 et Ford Mustang MK6 avec moteurs 2,3L 16V Ecoboost.\nN\u00e9cessaire \u00e0 l'augmentation des performances, car les bielles standard ne sont pas d\u00e9velopp\u00e9es pour des charges \u00e9lev\u00e9es.\nCaract\u00e9ristiques :\n\nZRP original\nhaute r\u00e9sistance moulue \u00e0 partir du solide\nadapt\u00e9 \u00e0 des augmentations de performances \u00e9lev\u00e9es\nextr\u00eamement l\u00e9ger et tr\u00e8s stable\navec axe de piston de 22,5 mm\n4 pi\u00e8ces par ensemble\nAvec des vis d'expansion ARP 2000 de 3\/8\".\nP\u00e2te d'assemblage ARP\n\nLes bielles en acier ZRP sont adapt\u00e9es \u00e0 tous les moteurs Ecoboost 2,3L 16V avec des bielles de 149,25 x 22,5 mm.",
"de44571ddc4e4d0095c01af6ee299351": "Performance I-Shaft by ZRP for all Ford Focus RS MK3 und Ford Mustang MK6 mit 2.3L 16V Ecoboost Motoren.\nAt high performance increases necessary because the Serienpleuel not been developed for high loads.\nfeatures:\n\nOriginal ZRP\nhigh-solid milled from the solid\nsuitable for high performance increases\nextremely light and very stable\nwith 22,5 piston pin\n4 pieces per set\nWith ARP 2000 expansion screws 3\/8 \"\nARP assembly paste\n\nThe ZRP steel connecting rods are suitable for all 2.3L 16V Ecoboost engines with 149,25 x 22,5mm connecting rods."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK3 2.3L 16V Stahlpleuel I-Schaft ZRP",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Con Rods I-Beam by ZRP for Ford Focus RS MK3 2.3L 16V"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Extrem leicht und sehr stabil, f\u00fcr hohe Leistungssteigerung geeignet. \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Extremely light and very stable, suitable for high performance. \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 584.77,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 491.4,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 626.54,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 526.5,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 548.22,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 460.6875,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 699.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 588.19327731092,
"shop-customer": "588.19327731092",
"b-dealer": "491.4",
"c-dealer": "526.5",
"a-dealer": "460.6875"
},
"fields": {
"displayGroup": [
"bfb76fde1b4c9badb6c45a49a09cfacd"
]
},
"sort": [
"",
0,
"fd926e54f3374c06b1deb398a6e4252f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.96 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"77bd4a7dec974c9f81c83974d5bfebfc"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}},"isAvailable-filter":{"filter":{"term":{"active":true}},"aggregations":{"isAvailable":{"max":{"field":"stock"}}}},"customPrice-3-100":{"filter":{"range":{"shop-customer":{"gte":2.5210084033613445,"lte":84.03361344537815}}},"aggregations":{"customPrice-3-100":{"value_count":{"field":"id"}}}},"customPrice-100-300":{"filter":{"range":{"shop-customer":{"gte":84.03361344537815,"lte":252.10084033613447}}},"aggregations":{"customPrice-100-300":{"value_count":{"field":"id"}}}},"customPrice-300-500":{"filter":{"range":{"shop-customer":{"gte":252.10084033613447,"lte":420.1680672268908}}},"aggregations":{"customPrice-300-500":{"value_count":{"field":"id"}}}},"customPrice-500-700":{"filter":{"range":{"shop-customer":{"gte":420.1680672268908,"lte":588.2352941176471}}},"aggregations":{"customPrice-500-700":{"value_count":{"field":"id"}}}},"customPrice-700-900":{"filter":{"range":{"shop-customer":{"gte":588.2352941176471,"lte":756.3025210084033}}},"aggregations":{"customPrice-700-900":{"value_count":{"field":"id"}}}},"customPrice-900-1300":{"filter":{"range":{"shop-customer":{"gte":756.3025210084033,"lte":1092.4369747899161}}},"aggregations":{"customPrice-900-1300":{"value_count":{"field":"id"}}}},"customPrice-1300":{"filter":{"range":{"shop-customer":{"gte":1092.4369747899161}}},"aggregations":{"customPrice-1300":{"value_count":{"field":"id"}}}},"isUniversal-filter":{"filter":{"multi_match":{"query":true,"fields":["customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"],"type":"best_fields"}},"aggregations":{"isUniversal":{"max":{"field":"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article"}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
POST http://opensearch-master:9200/sw6_stage__product/_search?track_total_hits=0&search_type=query_then_fetch
Accept: application/json
Content-Type: application/json
{
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"bool": {
"should": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"
],
"type": "best_fields"
}
}
]
}
},
{
"bool": {
"must": [
{
"nested": {
"path": "visibilities",
"query": {
"bool": {
"must": [
{
"range": {
"visibilities.visibility": {
"gte": 30
}
}
},
{
"term": {
"visibilities.salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
}
]
}
}
}
},
{
"term": {
"active": true
}
}
]
}
},
{
"nested": {
"path": "categoriesRo",
"query": {
"term": {
"categoriesRo.id": "77bd4a7dec974c9f81c83974d5bfebfc"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|