| 1 |
3.35 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":"e93bab12d62b4d11912f4de29694e6b9"}}}},{"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": 1,
"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": "4c735ff5cbcb49bfbd3b9b3b3214551a",
"_score": null,
"_source": {
"id": "4c735ff5cbcb49bfbd3b9b3b3214551a",
"autoIncrement": 48263.0,
"ratingAverage": 5.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 187,
"productNumber": "2100369",
"ean": null,
"displayGroup": "e708b47ac256853b9c9635bb3dc5c88d",
"sales": 0,
"stock": 187,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "R3-143",
"releaseDate": null,
"createdAt": "2020-02-28T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"f220574e2c5b49d3850303e3bb6842cb",
"e8457c8beac747a48901db895675b052",
"0aaab16423fd4419adccee8ba0d329b6",
"867bc7067f9c48609e1374ad1b0fb72d",
"e93bab12d62b4d11912f4de29694e6b9",
"f212ea012b3d47f4a9568a0d81e7b124"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "f220574e2c5b49d3850303e3bb6842cb",
"_count": 1
},
{
"id": "e8457c8beac747a48901db895675b052",
"_count": 1
},
{
"id": "0aaab16423fd4419adccee8ba0d329b6",
"_count": 1
},
{
"id": "867bc7067f9c48609e1374ad1b0fb72d",
"_count": 1
},
{
"id": "e93bab12d62b4d11912f4de29694e6b9",
"_count": 1
},
{
"id": "f212ea012b3d47f4a9568a0d81e7b124",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "5fb979279a294f7caff83a2eb41f8315",
"coverId": "1cd99246a7bc490987ee00e1a3c27599",
"childCount": 0,
"categories": [
{
"id": "f212ea012b3d47f4a9568a0d81e7b124",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "VW",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW",
"5494b24b09d445ebace47112836b4458": "VW"
}
},
{
"id": "867bc7067f9c48609e1374ad1b0fb72d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Audi",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi"
}
},
{
"id": "e93bab12d62b4d11912f4de29694e6b9",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Nissan",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan"
}
},
{
"id": "0aaab16423fd4419adccee8ba0d329b6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios del radiador de aceite",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00d6lk\u00fchler-Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Refroidisseur d'huile- accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Oil cooler accessories"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "5607890d085243d88119d33d972d2dd9",
"_count": 1,
"groupId": "8ff677a23030401ca5295db2c634ae98",
"group": {
"id": "8ff677a23030401ca5295db2c634ae98",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dash 8",
"de44571ddc4e4d0095c01af6ee299351": "Dash 8",
"5494b24b09d445ebace47112836b4458": " Dash 8"
}
}
],
"categoryIds": [
"0aaab16423fd4419adccee8ba0d329b6",
"867bc7067f9c48609e1374ad1b0fb72d",
"e93bab12d62b4d11912f4de29694e6b9",
"f212ea012b3d47f4a9568a0d81e7b124"
],
"optionIds": [
"5607890d085243d88119d33d972d2dd9"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=EoAxekaQIDo",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Dash-Leitung richtig zusammenbauen ",
"fts_product_video_1_description": "Heute zeigt euch Bartek, wie man eine Dash-Leitung richtig zusammenbaut! Welche g\u00e4ngigen Systeme gibt es? Was passiert, wenn die Dash-Leitung f\u00fcr den Kraftstoff undicht ist? Wann sollte der Nylonschlauch der Dash-Leitung abgeschnitten werden? Diese und weitere wichtige Fragen beantwortet euch Bartek in diesem Video. Was m\u00f6chtet ihr als n\u00e4chstes sehen, was interessiert euch besonders? Schreibt es in die Kommentare! Hier geht\u2019s zu den Produkten im Video: https:\/\/www.bar-tek-tuning.de\/dash-schluessel-verstellbar https:\/\/www.bar-tek-tuning.de\/aluminium-anschluss-fitting-dash-10 https:\/\/www.bar-tek-tuning.de\/schlauchleitung-nylon-stahl-dash-10 Stay tuned! Ihr habt Fragen?! @: info@bar-tek.de 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 Nutzt auch unsere eigenen GIPHYs: https:\/\/giphy.com\/BAR-TEK_Motorsport #dashleitung #dash #dashsystem",
"fts_product_video_1_upload_date": "2020-11-22 17:00:03.000",
"migration_Shopware5DB_product_attr9": "lmb: 51634",
"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_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "adapter-thermostatflansch-dash-8",
"migration_Shopware5DB_product_dreisc_seo_title": "Adapter-Schraube f\u00fcr Thermostatflansch Dash 8 BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=EoAxekaQIDo&list=PLBeJT6bDbwm_5DMRKymqvHtti-XYrgkl6&index=16",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Dash-Leitung richtig zusammenbauen ",
"migration_Shopware5DB_product_attr9": "lmb: 51634",
"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_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Adapter-Schraube f\u00fcr Thermostatflansch Dash 8 BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_video_1": "https:\/\/www.youtube.com\/watch?v=EoAxekaQIDo",
"fts_product_is_bartek": true,
"fts_product_video_1_title": "Dash-Leitung richtig zusammenbauen ",
"migration_Shopware5DB_product_attr9": "lmb: 51634",
"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_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "adapter-thermostat-flange-dash-8",
"migration_Shopware5DB_product_dreisc_seo_title": "Adapter screw for Dash 8 BAR-TEK\u00ae thermostatic flange",
"migration_Shopware5DB_product_onco_universal_article": true,
"migration_Shopware5DB_product_dreisc_seo_title_replace": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dash Adapter f\u00fcr \u00d6lk\u00fchler Thermostatflansch Umbau BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Adaptateur Dash pour refroidisseur d'huile Bride de thermostat Conversion BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Dash adapter for oil cooler thermostat flange conversion BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Adapter M18x1,5 auf Dash 8 oder wahlweise auf Dash 10 f\u00fcr unseren Thermostatflansch.\nDieser Adapter wird ben\u00f6tigt wenn man unsere \u00d6lk\u00fchlerkits mit Dashleitungen versehen m\u00f6chte.\nFeatures:\n\nAus dem Vollen gefr\u00e4\u00dft\nEinfache Montage\nEloxiert\n\nAchtung: geliefert wird 1 St\u00fcck. F\u00fcr unseren\u00a0Thermostatflansch\u00a0werden 2 St\u00fcck ben\u00f6tigt.",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Adaptateur M18x1,5 sur Dash 6, Dash 8 ou au choix sur Dash 10 pour notre bride thermostatique.\nCet adaptateur est n\u00e9cessaire si l'on souhaite \u00e9quiper nos kits de refroidissement d'huile de conduites Dash.\nCaract\u00e9ristiques de l'adaptateur :\n\nFrais\u00e9 dans la masse\nMontage facile\nAnodis\u00e9\n\nAttention : 1 pi\u00e8ce est livr\u00e9e. Pour notrebride thermostatique , 2 pi\u00e8ces sont n\u00e9cessaires.",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Adapter M18x1,5 to Dash 8 or optional to Dash 10 for our thermostat flange.\nThis adapter is needed if you want to add dash lines to our oil cooler kits.\nFeatures:\n\nMilled from solid\nEasy to mount\nAnodized\n\nAttention: 1 piece is delivered. For our\u00a0thermostat flange\u00a02 pieces are needed."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00d6lk\u00fchler Schraube f\u00fcr Thermostatflansch BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Adapter screw for Dash 8 BAR-TEK\u00ae thermostatic flange"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ist bei Verwendung unserer \u00d6lk\u00fchlerkits mit Dashleitungen notwendig! \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Is necessary when using our oil cooler kits with dash lines! \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 buy BAR-TEK\u00ae proved \u2794 now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.1170006,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.3,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 4.9,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.117647,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.08,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.2666666666667,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.3,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.134454,
"shop-customer": "6.134454",
"b-dealer": "4.3",
"a-dealer": "4.117647",
"c-dealer": "4.2666666666667"
},
"fields": {
"displayGroup": [
"e708b47ac256853b9c9635bb3dc5c88d"
]
},
"sort": [
"true",
0,
"4c735ff5cbcb49bfbd3b9b3b3214551a"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "6ec40cfbce6b40a7bb87b054faadb394",
"_score": null,
"_source": {
"id": "6ec40cfbce6b40a7bb87b054faadb394",
"autoIncrement": 61063.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 33,
"productNumber": "21ni054",
"ean": "4260630978810",
"displayGroup": "4d35c093949a805fb1902c7cb86880c7",
"sales": 0,
"stock": 33,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "Racimex Schraube 51620 + Mocal Flansch",
"releaseDate": "2022-12-13T14:42:59+00:00",
"createdAt": "2019-10-25T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"f220574e2c5b49d3850303e3bb6842cb",
"e8457c8beac747a48901db895675b052",
"867bc7067f9c48609e1374ad1b0fb72d",
"e93bab12d62b4d11912f4de29694e6b9",
"f212ea012b3d47f4a9568a0d81e7b124"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "f220574e2c5b49d3850303e3bb6842cb",
"_count": 1
},
{
"id": "e8457c8beac747a48901db895675b052",
"_count": 1
},
{
"id": "867bc7067f9c48609e1374ad1b0fb72d",
"_count": 1
},
{
"id": "e93bab12d62b4d11912f4de29694e6b9",
"_count": 1
},
{
"id": "f212ea012b3d47f4a9568a0d81e7b124",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "b2ddc932925e41eda3702fc0ec16f9ba",
"childCount": 0,
"categories": [
{
"id": "f212ea012b3d47f4a9568a0d81e7b124",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "VW",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW",
"5494b24b09d445ebace47112836b4458": "VW"
}
},
{
"id": "867bc7067f9c48609e1374ad1b0fb72d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Audi",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi"
}
},
{
"id": "e93bab12d62b4d11912f4de29694e6b9",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Nissan",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan",
"5494b24b09d445ebace47112836b4458": "Nissan"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"867bc7067f9c48609e1374ad1b0fb72d",
"e93bab12d62b4d11912f4de29694e6b9",
"f212ea012b3d47f4a9568a0d81e7b124"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "Ganz normal G60 Kit",
"migration_Shopware5DB_product_attr14": "2550",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "\u00d6lk\u00fchler Kit ",
"migration_Shopware5DB_product_bullet1": "Komplettes Dichtungs- und Anbaumaterial.",
"migration_Shopware5DB_product_bullet2": "Komplettes Kit",
"migration_Shopware5DB_product_bullet3": "Verhindert hohe \u00d6ltemperaturen",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "oelkuehler-kit-nissan-350z",
"migration_Shopware5DB_product_dreisc_seo_title": "Komplettes \u00d6lk\u00fchler-Kit von BAR-TEK\u00ae f\u00fcr deinen Nissan 350Z",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "Ganz normal G60 Kit",
"migration_Shopware5DB_product_attr14": "2550",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "\u00d6lk\u00fchler Kit ",
"migration_Shopware5DB_product_bullet1": "Komplettes Dichtungs- und Anbaumaterial.",
"migration_Shopware5DB_product_bullet2": "Komplettes Kit",
"migration_Shopware5DB_product_bullet3": "Verhindert hohe \u00d6ltemperaturen",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Komplettes \u00d6lk\u00fchler-Kit von BAR-TEK\u00ae f\u00fcr deinen Nissan 350Z",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr9": "Ganz normal G60 Kit",
"migration_Shopware5DB_product_attr14": "2550",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Oil cooler kit ",
"migration_Shopware5DB_product_bullet1": "Complete sealing and mounting material.",
"migration_Shopware5DB_product_bullet2": "Complete kit",
"migration_Shopware5DB_product_bullet3": "Prevents high oil temperatures",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "oil-cooler-kit-nissan-350-z",
"migration_Shopware5DB_product_dreisc_seo_title": "Complete oil cooler kit from BAR-TEKu00ae for your Nissan 350Z",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 350Z \u00d6lk\u00fchler-Kit BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Kit de refroidissement d'huile BAR-TEK\u00ae pour Nissan 350Z",
"de44571ddc4e4d0095c01af6ee299351": "Nissan 350Z Oilcooler-Kit BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Speziell designtes \u00d6lk\u00fchler Kit f\u00fcr deinen 350Z\nDas hochwertige \u00d6lk\u00fchler-Kit verhindert zu hohe \u00d6ltemperaturen. Es gew\u00e4hrleistet einen konstanten \u00d6ldruck. Auch die Motordichtungen h\u00e4rten nicht aus, was die Lebensdauer des Motors positiv beeinflusst.\n31 teiliges Komplett-Kit:\n\n19 Reihen \u00d6lk\u00fchler\n\u00d6lk\u00fchlerflansch mit Thermostat. (ca.80\u00b0C)\nHochdruck-Leitungen in Dash 8\nKomplettes Dichtungs- und Anbaumaterial\n\nDieses Kit l\u00e4sst sich nicht nur einfach einbauen: Aufgrund seiner hochwertigen Verarbeitung hast du eine konstante \u00d6ltemperatur und die Kontrolle \u00fcber den \u00d6ldruck. Durch die fertig stahlummantelten Leitungen hat dein Motor eine lange Lebensdauer.\n",
"5494b24b09d445ebace47112836b4458": "Kit de refroidisseur d'huile sp\u00e9cialement con\u00e7u pour votre 350Z\nLe kit de refroidissement de l'huile de haute qualit\u00e9 emp\u00eache les temp\u00e9ratures excessives de l'huile. Il assure une pression d'huile constante. Les joints du moteur ne durcissent pas non plus, ce qui a un effet positif sur la dur\u00e9e de vie du moteur.\nKit complet de 31 pi\u00e8ces :\n\nRefroidisseur d'huile \u00e0 19 rang\u00e9es\nBride de refroidisseur d'huile avec thermostat. (environ 80\u00b0C)\nTuyaux \u00e0 haute pression gain\u00e9s d'acier, pr\u00eats \u00e0 \u00eatre press\u00e9s\nMat\u00e9riel de scellement et de montage complet\n\nCe kit n'est pas seulement facile \u00e0 installer : Gr\u00e2ce \u00e0 sa fabrication de haute qualit\u00e9, vous avez une temp\u00e9rature d'huile constante et un contr\u00f4le de la pression de l'huile. Gr\u00e2ce aux conduites \u00e0 gaine d'acier, votre moteur a une longue dur\u00e9e de vie.",
"de44571ddc4e4d0095c01af6ee299351": "Specially designed oil cooler kit for your 350Z\nThe high quality oil cooler kit prevents too high oil temperatures. It ensures a constant oil pressure. Also, the engine seals do not harden, which positively affects the life of the engine.\n31 piece complete kit:\n\n13 rows of oil cooler\noil cooler flange with thermostat. (about 80 \u00b0 C)\nhigh-pressure lines in Dash 8\nComplete sealing and installation material\n\nThis kit is not only to build: Considering its high quality workmanship you have a constant oil temperature and control over the oil pressure. Your engine has a long service life thanks to the finished steel sheathed cables."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nissan 350Z \u00d6lk\u00fchler-Kit",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Complete oil cooler kit from BAR-TEK\u00ae for your Nissan 350Z"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u00d6lk\u00fchler inkl. Hochdruck-Leitungen und Dichtungs- und Anbaumaterial. \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Oil cooler incl. High-pressure lines and sealing and installation material. \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_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 230.65,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 193.82352,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 238,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 200,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 249.90001,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 210.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 314.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 264.66385,
"shop-customer": "264.66385",
"a-dealer": "193.82352",
"c-dealer": "200",
"b-dealer": "210.0"
},
"fields": {
"displayGroup": [
"4d35c093949a805fb1902c7cb86880c7"
]
},
"sort": [
"true",
0,
"6ec40cfbce6b40a7bb87b054faadb394"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.61 ms |
Request:
{"index":"sw6_stage__product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.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":"e93bab12d62b4d11912f4de29694e6b9"}}}},{"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": "e93bab12d62b4d11912f4de29694e6b9"
}
}
}
},
{
"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
|