| 1 |
4.72 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":"b2d5c05658554116a66d93460788fbdd"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "266932bc4fef4838b8a8e5f8a36cc477",
"_score": null,
"_source": {
"id": "266932bc4fef4838b8a8e5f8a36cc477",
"autoIncrement": 44270.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "21tdi15",
"ean": null,
"displayGroup": "406531268fb3af3157ad56b4c20d76ef",
"sales": 0,
"stock": 1000,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21tdi15",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"b9b451997c214440a0c2fdde63492331",
"b2d5c05658554116a66d93460788fbdd"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "b9b451997c214440a0c2fdde63492331",
"_count": 1
},
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "6b04a652c5644932968b040b63d2f88a",
"childCount": 0,
"categories": [
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "T4",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4",
"5494b24b09d445ebace47112836b4458": "T4",
"de44571ddc4e4d0095c01af6ee299351": "T4"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "0220b95241404dd89bc4e2dab8ae9ecf",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Volkswagen",
"5494b24b09d445ebace47112836b4458": "Volkswagen"
}
},
{
"id": "04a27fd2797642138125e2542c93dc72",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4 (Typ 70) | BJ 1990-2003",
"5494b24b09d445ebace47112836b4458": "T4 (type 70) | BJ 1990-2003",
"de44571ddc4e4d0095c01af6ee299351": "T4 (Type 70) | Year built 1990-2003"
}
},
{
"id": "10608e76cea940f4bf3f9edee15067a3",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T \/ Bus",
"5494b24b09d445ebace47112836b4458": "T \/ Bus",
"de44571ddc4e4d0095c01af6ee299351": "T \/ Bus"
}
},
{
"id": "267bd4273af242ac98c3ccb326e4d519",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AHY | 151 PS (111 kW)",
"5494b24b09d445ebace47112836b4458": "AHY | 151 ch (111 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AHY | 151 hp (111 kW)"
}
},
{
"id": "6257a8f133fd426c8aaf2e61da1c050b",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXG | 151 PS (111 kW)",
"5494b24b09d445ebace47112836b4458": "AXG | 151 ch (111 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AXG | 151 hp (111 kW)"
}
},
{
"id": "91ab4adfafa945128d45b79dfb259172",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 TDI (EA180)",
"5494b24b09d445ebace47112836b4458": "2.5 TDI (EA180)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 TDI (EA180)"
}
}
],
"options": [],
"categoryIds": [
"b2d5c05658554116a66d93460788fbdd"
],
"optionIds": [],
"propertyIds": [
"0220b95241404dd89bc4e2dab8ae9ecf",
"04a27fd2797642138125e2542c93dc72",
"10608e76cea940f4bf3f9edee15067a3",
"267bd4273af242ac98c3ccb326e4d519",
"6257a8f133fd426c8aaf2e61da1c050b",
"91ab4adfafa945128d45b79dfb259172"
],
"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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-150ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 150PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 150PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "More power",
"migration_Shopware5DB_product_bullet3": "More torque",
"migration_Shopware5DB_product_bullet4": "More driving fun",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-150ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 150PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 150PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "VW T4 2,5L TDI 150PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "VW T4 2.5L TDI 150HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr VW T4 Transporter 2.5L TDI 150 PS Motoren. 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. 35 PS Mehrleistung\nca. 55 Nm mehr Drehmoment\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 les moteurs du VW T4 Transporter 2,5L TDI 150 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 35 HP de puissance suppl\u00e9mentaire\nenviron 55 Nm de couple suppl\u00e9mentaire\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 VW T4 Transporter 2.5L TDI 150 HP engines. Please choose from following configurations: Chiptuning V1:\n\nHardware original\napprox. 35 HP more power\napprox. 55 Nm more torque\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 150PS 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": 474.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 399.15,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 472.4895,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 397.05,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 446.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 374.99997,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 545.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 458.7815,
"shop-customer": "458.7815",
"c-dealer": "399.15",
"b-dealer": "397.05",
"a-dealer": "374.99997"
},
"fields": {
"displayGroup": [
"406531268fb3af3157ad56b4c20d76ef"
]
},
"sort": [
"true",
0,
"266932bc4fef4838b8a8e5f8a36cc477"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "2c6b98abe7bc4901a52992d30cad804c",
"_score": null,
"_source": {
"id": "2c6b98abe7bc4901a52992d30cad804c",
"autoIncrement": 44269.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "21tdi14",
"ean": null,
"displayGroup": "b6966afad7875b3dc052ccbc6069069b",
"sales": 0,
"stock": 1000,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21tdi14",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"b9b451997c214440a0c2fdde63492331",
"b2d5c05658554116a66d93460788fbdd"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "b9b451997c214440a0c2fdde63492331",
"_count": 1
},
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "61957cee48304a22873beabb80a2a635",
"childCount": 0,
"categories": [
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "T4",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4",
"5494b24b09d445ebace47112836b4458": "T4",
"de44571ddc4e4d0095c01af6ee299351": "T4"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "0220b95241404dd89bc4e2dab8ae9ecf",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Volkswagen",
"5494b24b09d445ebace47112836b4458": "Volkswagen"
}
},
{
"id": "04a27fd2797642138125e2542c93dc72",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4 (Typ 70) | BJ 1990-2003",
"5494b24b09d445ebace47112836b4458": "T4 (type 70) | BJ 1990-2003",
"de44571ddc4e4d0095c01af6ee299351": "T4 (Type 70) | Year built 1990-2003"
}
},
{
"id": "10608e76cea940f4bf3f9edee15067a3",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T \/ Bus",
"5494b24b09d445ebace47112836b4458": "T \/ Bus",
"de44571ddc4e4d0095c01af6ee299351": "T \/ Bus"
}
},
{
"id": "16f7b01834fd40f9bafedb3e380bae33",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AUF | 102 PS (75 kW)",
"5494b24b09d445ebace47112836b4458": "AUF | 102 ch (75 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AUF | 102 hp (75 kW)"
}
},
{
"id": "2f1063866ade40a7af6428f8c7d037d4",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AYC | 102 PS (75 kW)",
"5494b24b09d445ebace47112836b4458": "AYC | 102 ch (75 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AYC | 102 hp (75 kW)"
}
},
{
"id": "877e228e272e473c8c49c78097e4d59e",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ACV | 102 PS (75 kW)",
"5494b24b09d445ebace47112836b4458": "ACV | 102 ch (75 kW)",
"de44571ddc4e4d0095c01af6ee299351": "ACV | 102 hp (75 kW)"
}
},
{
"id": "91ab4adfafa945128d45b79dfb259172",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 TDI (EA180)",
"5494b24b09d445ebace47112836b4458": "2.5 TDI (EA180)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 TDI (EA180)"
}
},
{
"id": "d242bf15053443a983fc7181d1513048",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXL | 102 PS (75 kW)",
"5494b24b09d445ebace47112836b4458": "AXL | 102 ch (75 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AXL | 102 hp (75 kW)"
}
}
],
"options": [],
"categoryIds": [
"b2d5c05658554116a66d93460788fbdd"
],
"optionIds": [],
"propertyIds": [
"0220b95241404dd89bc4e2dab8ae9ecf",
"04a27fd2797642138125e2542c93dc72",
"10608e76cea940f4bf3f9edee15067a3",
"16f7b01834fd40f9bafedb3e380bae33",
"2f1063866ade40a7af6428f8c7d037d4",
"877e228e272e473c8c49c78097e4d59e",
"91ab4adfafa945128d45b79dfb259172",
"d242bf15053443a983fc7181d1513048"
],
"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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-102ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 102PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 102PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "More power",
"migration_Shopware5DB_product_bullet3": "More torque",
"migration_Shopware5DB_product_bullet4": "More driving fun",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-102ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 102PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 102PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "VW T4 2,5L TDI 102PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "VW T4 2.5L TDI 102HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr VW T4 Transporter 2.5L TDI 102 PS Motoren. 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. 31 PS Mehrleistung\nca. 50 Nm mehr Drehmoment\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 les moteurs du VW T4 Transporter 2,5L TDI 102 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 31 HP de puissance suppl\u00e9mentaire\nenviron 50 Nm de couple suppl\u00e9mentaire\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 VW T4 Transporter 2.5L TDI 102 HP engines. Please choose from following configurations: Chiptuning V1:\n\nHardware original\napprox. 31 HP more power\napprox. 50 Nm more torque\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 102PS 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": 474.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 399.15,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 446.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 374.99997,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 472.4895,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 397.05,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 545.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 458.7815,
"shop-customer": "458.7815",
"c-dealer": "399.15",
"a-dealer": "374.99997",
"b-dealer": "397.05"
},
"fields": {
"displayGroup": [
"b6966afad7875b3dc052ccbc6069069b"
]
},
"sort": [
"true",
0,
"2c6b98abe7bc4901a52992d30cad804c"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "6447fb447a1447acb3ae32ddf9e7c235",
"_score": null,
"_source": {
"id": "6447fb447a1447acb3ae32ddf9e7c235",
"autoIncrement": 44271.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 1000,
"productNumber": "21tdi16",
"ean": null,
"displayGroup": "8df8e87e3dbf14b9f73477987adaad76",
"sales": 0,
"stock": 1000,
"weight": 0.001,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "21tdi16",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"b9b451997c214440a0c2fdde63492331",
"b2d5c05658554116a66d93460788fbdd"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "b9b451997c214440a0c2fdde63492331",
"_count": 1
},
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "ea214b1512bf4e05bb4cc8b70199238f",
"childCount": 0,
"categories": [
{
"id": "b2d5c05658554116a66d93460788fbdd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "T4",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4",
"5494b24b09d445ebace47112836b4458": "T4",
"de44571ddc4e4d0095c01af6ee299351": "T4"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [
{
"id": "01fd46d3a20144478f81e152e8d03369",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AJT | 88 PS (65 kW)",
"5494b24b09d445ebace47112836b4458": "AJT | 88 ch (65 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AJT | 88 hp (65 kW)"
}
},
{
"id": "0220b95241404dd89bc4e2dab8ae9ecf",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Volkswagen",
"5494b24b09d445ebace47112836b4458": "Volkswagen"
}
},
{
"id": "04a27fd2797642138125e2542c93dc72",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T4 (Typ 70) | BJ 1990-2003",
"5494b24b09d445ebace47112836b4458": "T4 (type 70) | BJ 1990-2003",
"de44571ddc4e4d0095c01af6ee299351": "T4 (Type 70) | Year built 1990-2003"
}
},
{
"id": "10608e76cea940f4bf3f9edee15067a3",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T \/ Bus",
"5494b24b09d445ebace47112836b4458": "T \/ Bus",
"de44571ddc4e4d0095c01af6ee299351": "T \/ Bus"
}
},
{
"id": "6fbf319125e04e6389c2a197be5a5005",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AYY | 88 PS (65 kW)",
"5494b24b09d445ebace47112836b4458": "AYY | 88 ch (65 kW)",
"de44571ddc4e4d0095c01af6ee299351": "AYY | 88 hp (65 kW)"
}
},
{
"id": "91ab4adfafa945128d45b79dfb259172",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5 TDI (EA180)",
"5494b24b09d445ebace47112836b4458": "2.5 TDI (EA180)",
"de44571ddc4e4d0095c01af6ee299351": "2.5 TDI (EA180)"
}
}
],
"options": [],
"categoryIds": [
"b2d5c05658554116a66d93460788fbdd"
],
"optionIds": [],
"propertyIds": [
"01fd46d3a20144478f81e152e8d03369",
"0220b95241404dd89bc4e2dab8ae9ecf",
"04a27fd2797642138125e2542c93dc72",
"10608e76cea940f4bf3f9edee15067a3",
"6fbf319125e04e6389c2a197be5a5005",
"91ab4adfafa945128d45b79dfb259172"
],
"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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-88ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 88PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Mehr Leistung",
"migration_Shopware5DB_product_bullet3": "Mehr Drehmoment",
"migration_Shopware5DB_product_bullet4": "Mehr Fahrspa\u00df",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 88PS 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": "BAR-TEK\u00ae Chiptuning ",
"migration_Shopware5DB_product_bullet1": "High boost",
"migration_Shopware5DB_product_bullet2": "More power",
"migration_Shopware5DB_product_bullet3": "More torque",
"migration_Shopware5DB_product_bullet4": "More driving fun",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "vw-t4-transporter-2-5l-tdi-88ps-chiptuning",
"migration_Shopware5DB_product_dreisc_seo_title": "VW T4 2.5L TDI 88PS Chiptuning BAR-TEK\u00ae",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 88PS Chiptuning BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "VW T4 2,5L TDI 88PS Chiptuning BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "VW T4 2.5L TDI 88HP Chiptuning BAR-TEK\u00ae"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Chiptuning f\u00fcr VW T4 Transporter 2.5L TDI 88 PS Motoren. 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. 30 PS Mehrleistung\nca. 45 Nm mehr Drehmoment\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 les moteurs du VW T4 Transporter 2,5L TDI 88 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 30 HP de puissance suppl\u00e9mentaire\nenviron 45 Nm de couple suppl\u00e9mentaire\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 VW T4 Transporter 2.5L TDI 88 HP engines. Please choose from following configurations: Chiptuning V1:\n\nHardware original\napprox. 30 HP more power\napprox. 45 Nm more torque\n\nPlease send your ECU to us after purchase. Other configurations on request."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VW T4 2.5L TDI 88PS 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_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 472.4895,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 397.05,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 446.25,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 374.99997,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 474.99,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 399.15,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 545.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 458.7815,
"shop-customer": "458.7815",
"b-dealer": "397.05",
"a-dealer": "374.99997",
"c-dealer": "399.15"
},
"fields": {
"displayGroup": [
"8df8e87e3dbf14b9f73477987adaad76"
]
},
"sort": [
"true",
0,
"6447fb447a1447acb3ae32ddf9e7c235"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.65 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":"b2d5c05658554116a66d93460788fbdd"}}}},{"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": "b2d5c05658554116a66d93460788fbdd"
}
}
}
},
{
"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
|