| 1 |
4.45 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":"24fed206bada4696b795a96eb1c95868"}}}},{"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": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "08a4347ca7ad45b992d5ac1de651848e",
"_score": null,
"_source": {
"id": "08a4347ca7ad45b992d5ac1de651848e",
"autoIncrement": 45018.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "21fo052",
"ean": null,
"displayGroup": "99843f982b21d9c12c839d795dc3164b",
"sales": 0,
"stock": 1000,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21fo052",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"24fed206bada4696b795a96eb1c95868"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "f06b5ab53b854d5988c74c67d4c851f5",
"childCount": 0,
"categories": [
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Ford",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford",
"5494b24b09d445ebace47112836b4458": "Ford",
"de44571ddc4e4d0095c01af6ee299351": "Ford"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "1ba416b4c036424fb3433e2c53d3fdf3",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.3 EcoBoost",
"5494b24b09d445ebace47112836b4458": "2.3 EcoBoost",
"de44571ddc4e4d0095c01af6ee299351": "2.3 EcoBoost"
}
},
{
"id": "4601cc6864b54ecba370c38eb572f4f4",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford",
"5494b24b09d445ebace47112836b4458": "Ford",
"de44571ddc4e4d0095c01af6ee299351": "Ford"
}
},
{
"id": "c3dca742a5cc41d5b320182113e11ec1",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "3. Gen (type DYB) | BJ 2010-2018",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "3. Gen. (Typ DYB) | BJ 2010-2018",
"de44571ddc4e4d0095c01af6ee299351": "3. Gen. (Type DYB) | Year built 2010-2018"
}
},
{
"id": "c715139afb4544c9820bb31f9480c901",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "EcoBoost 2.3 | 350 PS (257 kW)",
"5494b24b09d445ebace47112836b4458": "EcoBoost 2.3 | 350 ch (257 kW)",
"de44571ddc4e4d0095c01af6ee299351": "EcoBoost 2.3 | 350 hp (257 kW)"
}
},
{
"id": "f45e2c517c8d4ade81f993fe77bbae76",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Focus",
"5494b24b09d445ebace47112836b4458": "Focus",
"de44571ddc4e4d0095c01af6ee299351": "Focus"
}
}
],
"options": [],
"categoryIds": [
"24fed206bada4696b795a96eb1c95868"
],
"optionIds": [],
"propertyIds": [
"1ba416b4c036424fb3433e2c53d3fdf3",
"4601cc6864b54ecba370c38eb572f4f4",
"c3dca742a5cc41d5b320182113e11ec1",
"c715139afb4544c9820bb31f9480c901",
"f45e2c517c8d4ade81f993fe77bbae76"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet3": "Mehr Leistung",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-rs-mk3-350ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_bullet3": "Mehr Leistung",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top quality",
"migration_Shopware5DB_product_bullet3": "More power",
"migration_Shopware5DB_product_bullet4": "More driving fun",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-rs-mk3-350ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus RS MK3 350HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr den Ford Focus RS MK3 mit 350 PS Motor. Bei der Abstimmung haben wir das Augenmerk auf optimale Leistung in Verbindung mit Haltbarkeit gelegt. Bitte w\u00e4hle zwischen folgenden Konfigurationen: Chiptuning V1:\n\nHardware Serie\nca. 20 PS Mehrleistung (auf ca. 370 PS)\nca. 60 Nm mehr Drehmoment (auf ca. 500 Nm Drehmoment)\nV-Max aufgehoben\n\nSteuerger\u00e4t muss nach dem Kauf an uns versendet werden, oder Abstimmung bei uns vor Ort. Andere Konfigurationen gerne auf Anfrage.",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Chiptuning pour la Ford Focus RS MK3 avec un moteur de 350 HP. Lors du r\u00e9glage, nous avons mis l'accent sur des performances optimales en combinaison avec la durabilit\u00e9. Veuillez choisir entre les configurations suivantes : Chiptuning V1 :\n\nS\u00e9rie Mat\u00e9riel\nenviron 20 HP de puissance suppl\u00e9mentaire (jusqu'\u00e0 environ 370 PS)\nenviron 60 Nm de couple suppl\u00e9mentaire (jusqu'\u00e0 environ 500 Nm de couple)\nV-Max lev\u00e9\n\nL'unit\u00e9 de contr\u00f4le doit nous \u00eatre envoy\u00e9e apr\u00e8s l'achat, ou la coordination dans nos locaux.Autres configurations sur demande.",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Chiptuning for Ford Focus RS MK3 with 350 HP engine. Please choose from following configurations:\nChiptuning V1:\n\nhardware Serie\napprox. 20 HP more power (tuned on appx. 370 PS)\napprox. 60 Nm more torque (tuned on appx. 500 Nm torque)\nspeed limiter increased\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK3 350PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 759.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 638.65,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 755.9475,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 635.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 713.95,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 599.95795,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 881.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 741.1344,
"shop-customer": "741.1344",
"c-dealer": "638.65",
"b-dealer": "635.25",
"a-dealer": "599.95795"
},
"fields": {
"displayGroup": [
"99843f982b21d9c12c839d795dc3164b"
]
},
"sort": [
"true",
0,
"08a4347ca7ad45b992d5ac1de651848e"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "1202c33e93324e0a9c5439b9bef9e976",
"_score": null,
"_source": {
"id": "1202c33e93324e0a9c5439b9bef9e976",
"autoIncrement": 46429.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo048",
"ean": null,
"displayGroup": "415e340c1decd345a4fc2383831a3f93",
"sales": 0,
"stock": 0,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21fo048",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"24fed206bada4696b795a96eb1c95868"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "05ba26457ca440c89e740df151324225",
"coverId": "ebeee4e7d15045d5a892c912851e6f91",
"childCount": 0,
"categories": [
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Ford",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford",
"5494b24b09d445ebace47112836b4458": "Ford",
"de44571ddc4e4d0095c01af6ee299351": "Ford"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "4601cc6864b54ecba370c38eb572f4f4",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford",
"5494b24b09d445ebace47112836b4458": "Ford",
"de44571ddc4e4d0095c01af6ee299351": "Ford"
}
},
{
"id": "93fb6caf19a44083b756e09f4c6b1c08",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "HYDA | 226 PS (166 kW)",
"5494b24b09d445ebace47112836b4458": "HYDA | 226 ch (166 kW)",
"de44571ddc4e4d0095c01af6ee299351": "HYDA | 226 hp (166 kW)"
}
},
{
"id": "b8adab39de3440a5952838eabdce96c2",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Duratec 2.5 R5 20V",
"5494b24b09d445ebace47112836b4458": "Duratec 2.5 R5 20V",
"de44571ddc4e4d0095c01af6ee299351": "Duratec 2.5 R5 20V"
}
},
{
"id": "bb37a40eef704119a27e5eed95b29e9a",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "2. Gen (type DA3) | BJ 2004-2010",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ DA3) | BJ 2004-2010",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type DA3) | Year built 2004-2010"
}
},
{
"id": "f45e2c517c8d4ade81f993fe77bbae76",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Focus",
"5494b24b09d445ebace47112836b4458": "Focus",
"de44571ddc4e4d0095c01af6ee299351": "Focus"
}
}
],
"options": [
{
"id": "8b3aed5db68d4119b4a534a4fe2d3234",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning V1",
"5494b24b09d445ebace47112836b4458": "Chiptuning V1",
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning V1"
}
}
],
"categoryIds": [
"24fed206bada4696b795a96eb1c95868"
],
"optionIds": [
"8b3aed5db68d4119b4a534a4fe2d3234"
],
"propertyIds": [
"4601cc6864b54ecba370c38eb572f4f4",
"93fb6caf19a44083b756e09f4c6b1c08",
"b8adab39de3440a5952838eabdce96c2",
"bb37a40eef704119a27e5eed95b29e9a",
"f45e2c517c8d4ade81f993fe77bbae76"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "Mehr Leistung",
"migration_Shopware5DB_product_bullet2": "Mehr Fahrspass",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-st-25l-225ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "Mehr Leistung",
"migration_Shopware5DB_product_bullet2": "Mehr Fahrspass",
"migration_Shopware5DB_product_bullet3": "Top Qualit\u00e4t",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "More power",
"migration_Shopware5DB_product_bullet2": "More driving fun",
"migration_Shopware5DB_product_bullet3": "Top quality",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-st-25l-225ps-chiptuning"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus ST 2.5L 225HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr den Ford Focus ST MK2 mit 225 PS Motor. Bei der Abstimmung haben wir das Augenmerk auf optimale Leistung in Verbindung mit Haltbarkeit gelegt. Bitte w\u00e4hle zwischen folgenden Konfigurationen: Chiptuning V1:\n\nHardware Serie\nca. 40 PS Mehrleistung (auf ca. 265 PS)\nca. 80 Nm mehr Drehmoment (auf ca. 400 Nm Drehmoment)\nV-Max aufgehoben\n\nChiptuning V2:\n\nf\u00fcr 76mm Downpipe & Sportkat (Wie unsere Milltek)\nf\u00fcr Upgrade Ladeluftk\u00fchler (Wie unser Wagner oder Forge)\nca. 55 PS Mehrleistung (auf ca. 280 PS)\nca. 105 Nm mehr Drehmoment (auf ca. 425 Nm Drehmoment)\nV-Max aufgehoben\n\nSteuerger\u00e4t muss nach dem Kauf an uns versendet werden, oder Abstimmung bei uns vor Ort. Andere Konfigurationen gerne auf Anfrage.",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Chiptuning pour la Ford Focus ST MK2 avec moteur de 225 HP. Lors du r\u00e9glage, nous avons mis l'accent sur des performances optimales en combinaison avec la durabilit\u00e9. Veuillez choisir entre les configurations suivantes : Chiptuning V1 :\n\nS\u00e9rie Mat\u00e9riel\nenviron 40 HP de puissance suppl\u00e9mentaire (jusqu'\u00e0 environ 265 PS)\nenviron 80 Nm de couple suppl\u00e9mentaire (\u00e0 environ 400 Nm de couple)\nV-Max lev\u00e9\n\nChiptuning V2 :\n\npour Downpipe 76mm & Sportkat (comme notre Milltek)\npour la mise \u00e0 niveau de l'intercooler (comme notre Wagner ou notre Forge)\nenviron 55 HP de puissance suppl\u00e9mentaire (jusqu'\u00e0 environ 280 CV)\nenviron 105 Nm de couple suppl\u00e9mentaire (\u00e0 environ 425 Nm de couple)\nV-Max lev\u00e9\n\nL'unit\u00e9 de contr\u00f4le doit nous \u00eatre envoy\u00e9e apr\u00e8s l'achat, ou la coordination dans nos locaux.Autres configurations sur demande.",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Chiptuning for Ford Focus ST MK2 with 225 HP engine. Please choose from following configurations:\nChiptuning V1:\n\nhardware Serie\napprox. 40 HP more power (tuned on appx. 265 PS)\napprox. 80 Nm more torque (tuned on appx. 400 Nm torque)\nspeed limiter increased\n\nChiptuning V2:\n\nFor 76mm Downpipe & Sport Cat (like our Milltek systems)\napprox. 55 HP more power (tuned on appx. 280 PS)\napprox. 105 Nm more torquet (tuned on appx. 425 Nm torque)\nspeed limiter increased\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus ST 2.5L 225PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 535.45,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 449.95798,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 566.9755,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 476.45,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 569.95,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 478.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 661.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 555.84033,
"shop-customer": "555.84033",
"a-dealer": "449.95798",
"b-dealer": "476.45",
"c-dealer": "478.95"
},
"fields": {
"displayGroup": [
"415e340c1decd345a4fc2383831a3f93"
]
},
"sort": [
"true",
0,
"1202c33e93324e0a9c5439b9bef9e976"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "98c8922d0fa24231b788f7106cdc787f",
"_score": null,
"_source": {
"id": "98c8922d0fa24231b788f7106cdc787f",
"autoIncrement": 45016.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "21fo050",
"ean": null,
"displayGroup": "5da63be433e220ea19bdbcb556583904",
"sales": 0,
"stock": 0,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21fo050",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"24fed206bada4696b795a96eb1c95868"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "ea78aecbdbac4a30acb955a3b2fbbaa2",
"coverId": "2ade0f7f07064f8fa58af4002eafdb3f",
"childCount": 0,
"categories": [
{
"id": "24fed206bada4696b795a96eb1c95868",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Ford",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford",
"5494b24b09d445ebace47112836b4458": "Ford",
"de44571ddc4e4d0095c01af6ee299351": "Ford"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "44fcfd9fc9ab4e32b1240ada8b9afedc",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A3 8P",
"5494b24b09d445ebace47112836b4458": "A3 8P",
"de44571ddc4e4d0095c01af6ee299351": "A3 8P"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "8600526d9d314338b4cd540de21983de",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI EA888 (200 CV) | CAWB,CCZA | BJ 07.2004 - 03.2013",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI EA888 (200 PS) | CAWB,CCZA | BJ 07.2004 - 03.2013",
"de44571ddc4e4d0095c01af6ee299351": "2.0L TFSI EA888 (200 PS) | CAWB,CCZA | Year 07.2004 - 03.2013"
}
},
{
"id": "be0300913bb7414c9d11c1b367ae0078",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BJ 2003 - 2013",
"5494b24b09d445ebace47112836b4458": "BJ 2003 - 2013",
"de44571ddc4e4d0095c01af6ee299351": "Year built 2003-2013"
}
}
],
"options": [
{
"id": "8b3aed5db68d4119b4a534a4fe2d3234",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Chiptuning V1",
"5494b24b09d445ebace47112836b4458": "Chiptuning V1",
"de44571ddc4e4d0095c01af6ee299351": "Chiptuning V1"
}
}
],
"categoryIds": [
"24fed206bada4696b795a96eb1c95868"
],
"optionIds": [
"8b3aed5db68d4119b4a534a4fe2d3234"
],
"propertyIds": [
"44fcfd9fc9ab4e32b1240ada8b9afedc",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"8600526d9d314338b4cd540de21983de",
"be0300913bb7414c9d11c1b367ae0078"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Leistung",
"migration_Shopware5DB_product_bullet3": "Purer Fahrspa\u00df ",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-rs-mk2-304ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top Leistung",
"migration_Shopware5DB_product_bullet3": "Purer Fahrspa\u00df ",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "Top performance",
"migration_Shopware5DB_product_bullet3": "Pure driving fun",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false,
"migration_Shopware5DB_product_dreisc_seo_url": "ford-focus-rs-mk2-304ps-chiptuning"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "Ford Focus RS MK2 305HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr den Ford Focus RS MK2 mit 305 PS Motor. Bei der Abstimmung haben wir das Augenmerk auf optimale Leistung in Verbindung mit Haltbarkeit gelegt. Bitte w\u00e4hle zwischen folgenden Konfigurationen: Chiptuning V1:\n\nHardware Serie\nca. 45 PS Mehrleistung (auf ca. 350 PS)\nca. 90 Nm mehr Drehmoment (auf ca. 530 Nm Drehmoment)\nV-Max aufgehoben\n\nChiptuning V2:\n\nf\u00fcr 76mm Downpipe & Sportkat (Wie unsere Milltek)\nf\u00fcr Upgrade Ladeluftk\u00fchler (Wie unser Wagner oder Forge)\nca. 65 PS Mehrleistung (auf ca. 370 PS)\nca. 110 Nm mehr Drehmoment (auf ca. 550 Nm Drehmoment)\nV-Max aufgehoben\n\nSteuerger\u00e4t muss nach dem Kauf an uns versendet werden, oder Abstimmung bei uns vor Ort. Andere Konfigurationen gerne auf Anfrage.",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae Chiptuning pour la Ford Focus RS MK2 avec moteur 305 HP. Lors du r\u00e9glage, nous avons mis l'accent sur des performances optimales en combinaison avec la durabilit\u00e9. Veuillez choisir entre les configurations suivantes : Chiptuning V1 :\n\nS\u00e9rie Mat\u00e9riel\nenviron 45 HP de puissance suppl\u00e9mentaire (jusqu'\u00e0 environ 350 CV)\nenviron 90 Nm de couple suppl\u00e9mentaire (\u00e0 environ 530 Nm de couple)\nV-Max lev\u00e9\n\nChiptuning V2 :\n\npour Downpipe 76mm & Sportkat (comme notre Milltek)\npour la mise \u00e0 niveau de l'intercooler (comme notre Wagner ou notre Forge)\nenviron 65 HP de puissance suppl\u00e9mentaire (jusqu'\u00e0 environ 370 PS)\nenviron 110 Nm de couple suppl\u00e9mentaire (\u00e0 environ 550 Nm de couple)\nV-Max lev\u00e9\n\nL'unit\u00e9 de contr\u00f4le doit nous \u00eatre envoy\u00e9e apr\u00e8s l'achat, ou la coordination dans nos locaux.Autres configurations sur demande.",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Chiptuning for Ford Focus RS MK2 with 305 HP engine. Please choose from following configurations:\nChiptuning V1:\n\nhardware Serie\napprox. 45 HP more power (tuned on appx. 350 PS)\napprox. 90 Nm more torque (tuned on appx. 530 Nm torque)\nspeed limiter increased\n\nChiptuning V2:\n\nFor 76mm Downpipe & Sport Cat (like our Milltek systems)\nFor Upgrade Intercooler ( Wagner or Forge)\napprox. 65 HP more power (tuned on appx. 370 PS)\napprox. 110 Nm more torquet (tuned on appx. 550 Nm torque)\nspeed limiter increased\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ford Focus RS MK2 305PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 580.1,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 487.47894,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 617.49,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 518.9,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 614.278,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 516.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 713.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 599.95795,
"shop-customer": "599.95795",
"a-dealer": "487.47894",
"c-dealer": "518.9",
"b-dealer": "516.2"
},
"fields": {
"displayGroup": [
"5da63be433e220ea19bdbcb556583904"
]
},
"sort": [
"true",
0,
"98c8922d0fa24231b788f7106cdc787f"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.53 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":"24fed206bada4696b795a96eb1c95868"}}}},{"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": "24fed206bada4696b795a96eb1c95868"
}
}
}
},
{
"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
|