| 1 |
5.18 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.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"6b833d0e8971447187ec48670c32908c"}}}},{"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":["5494b24b09d445ebace47112836b4458","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": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "c0bf7c3287e74e22b36f2ef843359ae0",
"_score": null,
"_source": {
"id": "c0bf7c3287e74e22b36f2ef843359ae0",
"autoIncrement": 44169.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo027",
"ean": null,
"displayGroup": "a2db82ea24316e2c300fc923091b5e03",
"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",
"6b833d0e8971447187ec48670c32908c"
],
"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": "6b833d0e8971447187ec48670c32908c",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "ace685c7853e4ab98169d279562f9926",
"childCount": 0,
"categories": [
{
"id": "6b833d0e8971447187ec48670c32908c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 8V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 8V",
"5494b24b09d445ebace47112836b4458": "2.0L 8V"
}
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
}
],
"manufacturer": {
"id": "bf196e6048be4b1eb93b2a1f7cb02296",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "K1"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"6b833d0e8971447187ec48670c32908c"
],
"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-scorpio-20l-8v-stahl-pleuel-h-schaft-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Scorpio 2.0L 8V 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 Scorpio 2.0L 8V 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-scorpio-20l-8v-stahl-pleuel-h-schaft-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Scorpio steel connecting rod H-shank K1",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Scorpio 2.0L 8V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": "Ford Scorpio 2.0L 8V acier Pleuel arbre en H K1",
"de44571ddc4e4d0095c01af6ee299351": "Ford Scorpio 2.0L 8V Conrods Motorsport K1"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von K1 f\u00fcr alle Ford Scorpio 2.0L 8V 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.0L 8V 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.0L 8V. 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 0L 8V avec bielles 149,30x20mm. ",
"de44571ddc4e4d0095c01af6ee299351": "Spezial Conrods by K1 for all Ford Scorpio 2.0L 8V engines. Very light and for extreme performance. Including 4 pieces with ARP rod bolts. The K1 conrods will fit for all Ford Scorpio 2.0L 8V engines with 149,30x20mm conrods. (Example picture, it will be delivered 4 pcs.)"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Scorpio 2.0L 8V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Ford Scorpio steel connecting rod H-shank K1"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "From K1 special H-shaft connector for Ford Scorpio 2.0L 8V engines. ✓ 15 years motorsport experience ✓ worldwide shipping ✓ BAR-TEK® proved ➔ 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": [
"a2db82ea24316e2c300fc923091b5e03"
]
},
"sort": [
"",
0,
"c0bf7c3287e74e22b36f2ef843359ae0"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "fc34baca1dc94245b617c091c6956cd0",
"_score": null,
"_source": {
"id": "fc34baca1dc94245b617c091c6956cd0",
"autoIncrement": 44168.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo026",
"ean": null,
"displayGroup": "4a3b55abc2aee66655a2a66f8dedebf3",
"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",
"6b833d0e8971447187ec48670c32908c"
],
"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": "6b833d0e8971447187ec48670c32908c",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "f2f72f687dcf45b388085329ba57eb9c",
"childCount": 0,
"categories": [
{
"id": "6b833d0e8971447187ec48670c32908c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 8V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 8V",
"5494b24b09d445ebace47112836b4458": "2.0L 8V"
}
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
}
],
"manufacturer": {
"id": "bf196e6048be4b1eb93b2a1f7cb02296",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "K1"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"6b833d0e8971447187ec48670c32908c"
],
"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-0l8v-sierra-stahl-pleuel-conrods-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Sierra 2.0L 8V 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 Sierra 2.0L 8V 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-0l8v-sierra-stahl-pleuel-conrods-k1",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Sierra 2.0L 8V Stahl Pleuel H-Schaft K1",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Sierra 2.0L 8V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": "Ford Sierra 2.0L 8V acier Pleuel arbre en H K1",
"de44571ddc4e4d0095c01af6ee299351": "Ford Sierra 2.0L 8V Conrods Motorsport K1"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezial H-Schaftpleuel von K1 f\u00fcr alle Ford Sierra 2.0L 8V Motoren. Bei hohen Leistungssteigerungen notwendig, da die Serienpleuel nicht f\u00fcr hohe Beanspruchungen entwickelt worden sind. -Original K1 -hoch-fest aus dem Vollen gefr\u00e4st -geeignet f\u00fcr hohe Leistungssteigerungen -extrem leicht und sehr stabil -4 St\u00fcck pro Satz -Mit ARP 2000 Dehnschrauben 3\/8\" -ARP Montagepaste Die K1 Stahlpleuel sind passend f\u00fcr alle Ford Sierra 2.0L 8V 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 Sierra 2.0L 8V. 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 Sierra 2.Moteurs 0L 8V avec bielle 149,30x20mm. ",
"de44571ddc4e4d0095c01af6ee299351": "Special H-beam conrods from K1 for all Ford Sierra 2.0L 8V engines.\n\nNecessary for high power increases, since the series connecting rods are not designed for high loads.\n\noriginal K1high-strength milled from the solidsuitable 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 Sierra 2.0L 8V 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 Sierra 2.0L 8V Stahl Pleuel H-Schaft K1",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Ford Sierra 2.0L 8V H-Beam 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": 453.42,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 381.02666666667,
"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_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 680.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 571.54,
"shop-customer": "571.54",
"b-dealer": "381.02666666667",
"a-dealer": "357.2125",
"c-dealer": "408.24285714286"
},
"fields": {
"displayGroup": [
"4a3b55abc2aee66655a2a66f8dedebf3"
]
},
"sort": [
"",
0,
"fc34baca1dc94245b617c091c6956cd0"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.71 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.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":"6b833d0e8971447187ec48670c32908c"}}}},{"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"
}
},
{
"exists": {
"field": "customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"
}
}
]
}
},
{
"multi_match": {
"query": false,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.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": "6b833d0e8971447187ec48670c32908c"
}
}
}
},
{
"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.5494b24b09d445ebace47112836b4458.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.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|