| 1 |
1045.36 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":"1751f61e61d54c5dad90da34d05a4eb2"}}}},{"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": 1043,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "4277119b3e3f42ff88b2c1035e48ea93",
"_score": null,
"_source": {
"id": "4277119b3e3f42ff88b2c1035e48ea93",
"autoIncrement": 45721.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 999,
"productNumber": "21kw009",
"ean": "4250580496625",
"displayGroup": "a1bb2a6e80c30f2694128a4c4c1f18aa",
"sales": 0,
"stock": 999,
"weight": 25.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "90f5dc23bbfb405ca7cebd3321b99bcd",
"manufacturerNumber": "39080055",
"releaseDate": null,
"createdAt": "2021-11-22T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"2e8eb18374c5436ea8d0f9f47b5da11f",
"27f9e3ecf3b642e5afe0bc2c87a81d21",
"4422476b7c044566b18f4d74a0ba8a19",
"1751f61e61d54c5dad90da34d05a4eb2"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "2e8eb18374c5436ea8d0f9f47b5da11f",
"_count": 1
},
{
"id": "27f9e3ecf3b642e5afe0bc2c87a81d21",
"_count": 1
},
{
"id": "4422476b7c044566b18f4d74a0ba8a19",
"_count": 1
},
{
"id": "1751f61e61d54c5dad90da34d05a4eb2",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "44d20480b438449d95e3156d22ad5acd",
"childCount": 0,
"categories": [
{
"id": "1751f61e61d54c5dad90da34d05a4eb2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "DDC",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DDC",
"5494b24b09d445ebace47112836b4458": "DDC"
}
}
],
"manufacturer": {
"id": "90f5dc23bbfb405ca7cebd3321b99bcd",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KW Fahrwerke",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "KW suspensions"
},
"_count": 1
},
"properties": [
{
"id": "0069c56b7c774330b3824768bf6ca954",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FV\/8S | BJ 2014-2023",
"5494b24b09d445ebace47112836b4458": "FV\/8S | ANN\u00c9E 2014-2023",
"de44571ddc4e4d0095c01af6ee299351": "FV\/8S | Year built 2014->"
}
},
{
"id": "0220b95241404dd89bc4e2dab8ae9ecf",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Volkswagen",
"5494b24b09d445ebace47112836b4458": "Volkswagen"
}
},
{
"id": "1f296173e204428aa830b6eb59c92589",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cupra",
"5494b24b09d445ebace47112836b4458": "Cupra",
"de44571ddc4e4d0095c01af6ee299351": "Cupra"
}
},
{
"id": "1f4f1e52116740d58f2cf5dc29e8f0aa",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "I | Year built 2016->",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "I (Typ 5FP\/KH7) | BJ 2016->",
"5494b24b09d445ebace47112836b4458": "I (type 5FP\/KH7) | ann\u00e9e 2016->"
}
},
{
"id": "3015be74c9074b48a71ab82e1d2f13b0",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CJXG | 310 PS (228 kW)",
"5494b24b09d445ebace47112836b4458": "CJXG | 310 ch (228 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CJXG | 310 hp (228 kW)"
}
},
{
"id": "44190d0db2de4821a5837c850fa7a6b5",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 TFSI (EA888 evo4)",
"5494b24b09d445ebace47112836b4458": "2.0 TFSI (EA888 evo4)",
"de44571ddc4e4d0095c01af6ee299351": "2.0 TFSI (EA888 Gen. 4)"
}
},
{
"id": "482363e15d924888a2bff9e098afe40e",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Leon",
"5494b24b09d445ebace47112836b4458": "Leon",
"de44571ddc4e4d0095c01af6ee299351": "Leon"
}
},
{
"id": "52c3546a8b6a4d8ab4c24759592f7dde",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "I (Typ VZ) | BJ 2020->",
"5494b24b09d445ebace47112836b4458": "I (type VZ) | BJ 2020->",
"de44571ddc4e4d0095c01af6ee299351": "I (Typ VZ) | Year built 2020->"
}
},
{
"id": "5520a78ff8784aac827c7b65729b7da7",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Golf",
"5494b24b09d445ebace47112836b4458": "Golf",
"de44571ddc4e4d0095c01af6ee299351": "Golf"
}
},
{
"id": "5d0f25d19e954ae1bbf8b58c548fb40c",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CJXC | 300 PS (220 kW)",
"5494b24b09d445ebace47112836b4458": "CJXC | 300 ch (220 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CJXC | 300 hp (220 kW)"
}
},
{
"id": "5f7a59b5eff04dccbb6c7cef881200cc",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ateca",
"5494b24b09d445ebace47112836b4458": "Ateca",
"de44571ddc4e4d0095c01af6ee299351": "Ateca"
}
},
{
"id": "6a791c48f09e46ab965604696f316ef6",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "T-Roc",
"5494b24b09d445ebace47112836b4458": "T-Roc",
"de44571ddc4e4d0095c01af6ee299351": "T-Roc"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "765fe03fdd044109908e44f5e668917c",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 TFSI (EA888 Gen. 3)",
"5494b24b09d445ebace47112836b4458": "2.0 TFSI (EA888 Gen. 3)",
"de44571ddc4e4d0095c01af6ee299351": "2.0 TFSI (EA888 Gen. 3)"
}
},
{
"id": "79d752468929417b92818fd0c2732713",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CJXC | 360 PS (265 kW)",
"5494b24b09d445ebace47112836b4458": "CJXC | 360 ch (265 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CJXC | 360 hp (265 kW)"
}
},
{
"id": "870cb58e9d264ac28124c2898b130d16",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VII (Typ AU) | BJ 2012-2019",
"5494b24b09d445ebace47112836b4458": "VII (type AU) | BJ 2012-2019",
"de44571ddc4e4d0095c01af6ee299351": "VII (Type AU) | Year built 2012-2019"
}
},
{
"id": "90eefafb79e340c8a6154c2c4281437a",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "III (Typ 5F) | BJ 2012-2020",
"5494b24b09d445ebace47112836b4458": "III (type 5F) | BJ 2012-2020",
"de44571ddc4e4d0095c01af6ee299351": "III (Type 5F) | Year built 2012-2020"
}
},
{
"id": "98810049b2d24ea988a77bbe0ff1cb08",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A3 \/ S3 \/ RS3",
"5494b24b09d445ebace47112836b4458": "A3 \/ S3 \/ RS3",
"de44571ddc4e4d0095c01af6ee299351": "A3 \/ S3 \/ RS3"
}
},
{
"id": "9c1f771006e44da4b2ac780446836ecc",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8V | BJ 2012-2020",
"5494b24b09d445ebace47112836b4458": "8V | ANN\u00c9E 2012-2020",
"de44571ddc4e4d0095c01af6ee299351": "8V | Year built 2012-2020"
}
},
{
"id": "9ed679919c734089bd086012ec6e95bf",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Seat",
"5494b24b09d445ebace47112836b4458": "Seat",
"de44571ddc4e4d0095c01af6ee299351": "Seat"
}
},
{
"id": "a1bea52c47894809a1dabe0a5e930ede",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TT \/ TTS \/ TT RS",
"5494b24b09d445ebace47112836b4458": "TT \/ TTS \/ TT RS",
"de44571ddc4e4d0095c01af6ee299351": "TT \/ TTS \/ TT RS"
}
},
{
"id": "a6171f405e5e4f399c7922761664c44e",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DJHA | 310 PS (228 kW)",
"5494b24b09d445ebace47112836b4458": "DJHA | 310 ch (228 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DJHA | 310 hp (228 kW)"
}
},
{
"id": "b52ea71a63f24fb6b19d2fbd3bbe7ea2",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Typ A1 | BJ 2017->",
"5494b24b09d445ebace47112836b4458": "Type A1 | BJ 2017->",
"de44571ddc4e4d0095c01af6ee299351": "Type A1 | Year built 2017->"
}
},
{
"id": "b998b172e7ef4f27b9c119c138878473",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CJXE | 265 PS (195 kW)",
"5494b24b09d445ebace47112836b4458": "CJXE | 265 ch (195 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CJXE | 265 hp (195 kW)"
}
},
{
"id": "c4e5f11d07994ce098f70e4e1190edf9",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DNUE | 300 PS (220 kW)",
"5494b24b09d445ebace47112836b4458": "DNUE | 300 ch (220 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DNUE | 300 hp (220 kW)"
}
},
{
"id": "cea3fda09024441f85499a234a9e12da",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Formentor",
"5494b24b09d445ebace47112836b4458": "Formentor",
"de44571ddc4e4d0095c01af6ee299351": "Formentor"
}
}
],
"options": [],
"categoryIds": [
"1751f61e61d54c5dad90da34d05a4eb2"
],
"optionIds": [],
"propertyIds": [
"0069c56b7c774330b3824768bf6ca954",
"0220b95241404dd89bc4e2dab8ae9ecf",
"1f296173e204428aa830b6eb59c92589",
"1f4f1e52116740d58f2cf5dc29e8f0aa",
"3015be74c9074b48a71ab82e1d2f13b0",
"44190d0db2de4821a5837c850fa7a6b5",
"482363e15d924888a2bff9e098afe40e",
"52c3546a8b6a4d8ab4c24759592f7dde",
"5520a78ff8784aac827c7b65729b7da7",
"5d0f25d19e954ae1bbf8b58c548fb40c",
"5f7a59b5eff04dccbb6c7cef881200cc",
"6a791c48f09e46ab965604696f316ef6",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"765fe03fdd044109908e44f5e668917c",
"79d752468929417b92818fd0c2732713",
"870cb58e9d264ac28124c2898b130d16",
"90eefafb79e340c8a6154c2c4281437a",
"98810049b2d24ea988a77bbe0ff1cb08",
"9c1f771006e44da4b2ac780446836ecc",
"9ed679919c734089bd086012ec6e95bf",
"a1bea52c47894809a1dabe0a5e930ede",
"a6171f405e5e4f399c7922761664c44e",
"b52ea71a63f24fb6b19d2fbd3bbe7ea2",
"b998b172e7ef4f27b9c119c138878473",
"c4e5f11d07994ce098f70e4e1190edf9",
"cea3fda09024441f85499a234a9e12da"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "KW DDC Fahrwerk",
"migration_Shopware5DB_product_bullet1": "Sportlichkeit gepaart ",
"migration_Shopware5DB_product_bullet2": "mit herausragender Optik",
"migration_Shopware5DB_product_bullet3": "vorab optimal eingestellt",
"migration_Shopware5DB_product_bullet4": "Edelstahltechnik \"inox-line\"",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "golf7-r-kw-ddc-gewindefahrwerk",
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R AWD KW DDC Gewindefahrwerk",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "KW DDC Fahrwerk",
"migration_Shopware5DB_product_bullet1": "Sportlichkeit gepaart ",
"migration_Shopware5DB_product_bullet2": "mit herausragender Optik",
"migration_Shopware5DB_product_bullet3": "vorab optimal eingestellt",
"migration_Shopware5DB_product_bullet4": "Edelstahltechnik \"inox-line\"",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R AWD KW DDC Gewindefahrwerk",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "KW DDC suspension",
"migration_Shopware5DB_product_bullet1": "Sportiness paired",
"migration_Shopware5DB_product_bullet2": "with outstanding optics",
"migration_Shopware5DB_product_bullet3": "pre-adjusted",
"migration_Shopware5DB_product_bullet4": "Stainless steel technology \"inox-line",
"migration_Shopware5DB_product_socialfeed": false,
"migration_Shopware5DB_product_dreisc_seo_url": "golf7-r-kw-ddc-threaded-chassis",
"migration_Shopware5DB_product_dreisc_seo_title": "Golf 7R AWD KW DDC Gewindefahrwerk",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Golf 7R AWD DDC Gewindefahrwerk KW",
"5494b24b09d445ebace47112836b4458": "Ch\u00e2ssis filet\u00e9 KW pour la Golf 7R AWD DDC",
"de44571ddc4e4d0095c01af6ee299351": "Golf 7R AWD DDC coilover suspension KW"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bitte bei Bestellung immer die Schl\u00fcsselnummer HSN\/TSN mit angeben.\nKW Gewindefahrwerk DDC \"inox-line\"\nKW Dynamic Damping Control ECU Individualit\u00e4t auf Knopfdruck.Die KW DDC Gewindefahrwerke sind die intelligente Fahrwerkl\u00f6sung zum Nachr\u00fcsten aus dem KW iSuspension Lieferprogramm. Sie kombinieren die Vorteile eines adaptiven D\u00e4mpfungssystems mit einer fahrzeugspezifischen sportlich-harmonischen D\u00e4mpfercharakteristik mit einer stilechten und sportlichen Tieferlegung. Erh\u00e4ltlich sind die adaptiven KW Gewindefahrwerke in der Ausf\u00fchrung KW DDC ECU mit optionaler App-Steuerung f\u00fcr Fahrzeuge ohne aktiv regelndes Serienfahrwerk und als KW DDC Plug & Play Variante f\u00fcr ausgew\u00e4hlte Fahrzeugmodelle mit adaptivem Serienfahrwerk.Die adaptiven KW DDC ECU Gewindefahrwerke erlauben eine stufenlose Tieferlegung im gepr\u00fcften Verstellbereich. Dank des schmutzunempfindlichen Trapezgewindes und dem Polyamid-Gewindering kann die stufenlose Tieferlegung auch nach Jahren schnell und leicht variiert werden. Die Tieferlegung erfolgt fahrzeugbedingt entweder an den radf\u00fchrenden KW Edelstahl-Federbeinen oder bei nicht radf\u00fchrenden Doppelquerlenkerhinterachsen an der Hinterachsh\u00f6henverstellung. Egal wo auf der Welt, sportliche Autofahrer, Automobilmanufakturen und Veredler vertrauen auf unsere KW Technologie \"Made in Germany\".Jedes KW Gewindefahrwerk wird in der Produktion ausgiebigen Belastungstests unterzogen und direkt in unserem Firmenstammsitz im schw\u00e4bischen Fichtenberg entwickelt und gefertigt, um die hohen Standards unseres KW Qualit\u00e4tsmanagements zu erf\u00fcllen. So ist es f\u00fcr uns als deutscher Hersteller eine Selbstverst\u00e4ndlichkeit auf unsere, die Erstausr\u00fcsterqualit\u00e4t \u00fcbertreffenden KW Gewindefahrwerke und \u00fcber 4.600 Anwendungen umfassenden Fahrwerkl\u00f6sungen eine mehrj\u00e4hrige Garantie zu gew\u00e4hrleisten. Sie betr\u00e4gt beim Einbau bei einem unserer KW Fachhandelspartner bis zu f\u00fcnf Jahren. Aktuell sind die adaptiven KW DDC ECU Gewindefahrwerke mit App-Steuerung f\u00fcr Audi, BMW, Mercedes-Benz, Porsche, VW und viele andere Fahrzeuge wie dem Range Rover Evoque lieferbar.\n\nnachr\u00fcstbare elektronische D\u00e4mpferverstellung, kombiniert mit den Vorteilen eines KW Gewindefahrwerks\nmit optionaler App-Steuerung\ndrei D\u00e4mpfungssetups: Comfort \/ Sport \/ Sport +\nBedienung \u00fcber Nachr\u00fcsttaster oder optionale App\nper KW DDC App eigene Setups intuitiv erstellen\n\nKW DDC Taster - 1x Taster, 3x mehr erfahrenDer Lieferumfang des KW DDC ECU Gewindefahrwerks beinhaltet auch einen KW DDC Taster. Dieser erlaubt es auf Wunsch die KW DDC Fahrmodi \"Comfort\", \"Sport\" und \"Sport+\" direkt vom Cockpit auszuw\u00e4hlen. Hierbei \u00e4ndert der KW DDC Taster den Farbton passend zur KW DDC APP.\n\nNur f\u00fcr Fahrzeuge mit einem Klemmdurchmesser an der VA von 55mm\nvorab optimal eingestellt\nsportlich-harmonisch wirkende D\u00e4mpfungstechnik\nEdelstahltechnik \"inox-line\"\nindividuell h\u00f6heneinstellbar\ngepr\u00fcfter Verstellbereich\neinbaufertige Komplettl\u00f6sung\nhochwertige Bauteile f\u00fcr lange Lebensdauer\nkomplette Dokumentation f\u00fcr einfache Handhabung\n\nW-LAN Modul & App-SteuerungOptional erh\u00e4ltliche App-Steuerung zur live Fahrwerksabstimmung per iPhone, iPod touch, iPad.Erleben Sie Innovation und Qualit\u00e4t der Extraklasse \"Made in Germany\": das KW DDC (Dynamic Damping Control) Gewindefahrwerk mit ECU (Electronic Control Unit). Das Gewindefahrwerk mit seinen elektronisch regelbaren D\u00e4mpfern erm\u00f6glicht eine intelligente Fahrwerkabstimmung per App-Steuerung und ist bereits f\u00fcr zahlreiche Fahrzeuge ohne adaptives Serienfahrwerk lieferbar.Dadurch k\u00f6nnen Sie Ihr Fahrzeug mit einer adaptiven D\u00e4mpfersteuerung aufwerten und optional per KW DDC App auf Ihre Fahrweise anpassen. Sie ben\u00f6tigen dazu kein Werkzeug oder m\u00fcssen an den D\u00e4mpfern selbst Hand anlegen.Die kostenlose KW DDC App in Verbindung mit unserem optional erh\u00e4ltlichen W-Lan Modul bilden Ihr Hilfsmittel, um eine individuelle D\u00e4mpferabstimmung live und in Echtzeit vorzunehmen.",
"5494b24b09d445ebace47112836b4458": "Veuillez toujours indiquer le num\u00e9ro de cl\u00e9 HSN\/TSN lors de la commande.\nKit de suspension filet\u00e9 KW DDC \"inox-line\nKW Dynamic Damping Control ECU L'individualit\u00e9 au bout des doigts. Les combin\u00e9s filet\u00e9s KW DDC sont la solution de ch\u00e2ssis intelligente \u00e0 monter en deuxi\u00e8me monte dans le programme de livraison KW iSuspension. Ils combinent les avantages d'un syst\u00e8me d'amortissement adaptatif avec une caract\u00e9ristique d'amortissement sportive et harmonieuse sp\u00e9cifique au v\u00e9hicule avec un abaissement styl\u00e9 et sportif. Les suspensions filet\u00e9es adaptatives KW sont disponibles en version KW DDC ECU avec commande App en option pour les v\u00e9hicules sans suspension de s\u00e9rie \u00e0 r\u00e9glage actif et en variante KW DDC Plug & Play pour certains mod\u00e8les de v\u00e9hicules avec suspension de s\u00e9rie adaptative. Les suspensions filet\u00e9es adaptatives KW DDC ECU permettent un abaissement en continu dans la plage de r\u00e9glage contr\u00f4l\u00e9e. Gr\u00e2ce au filetage trap\u00e9zo\u00efdal insensible \u00e0 la salet\u00e9 et \u00e0 la bague filet\u00e9e en polyamide, le rabaissement en continu peut \u00eatre modifi\u00e9 rapidement et facilement, m\u00eame apr\u00e8s des ann\u00e9es. L'abaissement s'effectue, en fonction du v\u00e9hicule, soit au niveau des jambes de force en acier inoxydable KW guidant les roues, soit, pour les essieux arri\u00e8re \u00e0 double bras transversal ne guidant pas les roues, au niveau du r\u00e9glage de la hauteur de l'essieu arri\u00e8re. O\u00f9 qu'ils soient dans le monde, les automobilistes sportifs, les constructeurs automobiles et les pr\u00e9parateurs font confiance \u00e0 notre technologie KW \"Made in Germany\". Chaque ch\u00e2ssis filet\u00e9 KW est soumis \u00e0 des tests de charge approfondis lors de la production et est d\u00e9velopp\u00e9 et fabriqu\u00e9 directement au si\u00e8ge de notre entreprise \u00e0 Fichtenberg, en Souabe, afin de r\u00e9pondre aux normes \u00e9lev\u00e9es de notre gestion de la qualit\u00e9 KW. En tant que fabricant allemand, il va de soi que nous offrons une garantie de plusieurs ann\u00e9es sur nos suspensions filet\u00e9es KW, qui d\u00e9passent la qualit\u00e9 de l'\u00e9quipement d'origine, et sur plus de 4 600 applications de solutions de suspension. Elle peut aller jusqu'\u00e0 cinq ans en cas de montage chez un de nos partenaires commerciaux sp\u00e9cialis\u00e9s KW. Actuellement, les suspensions filet\u00e9es adaptatives KW DDC ECU avec commande par application sont disponibles pour Audi, BMW, Mercedes-Benz, Porsche, VW et de nombreux autres v\u00e9hicules comme le Range Rover Evoque.\n\nr\u00e9glage \u00e9lectronique de l'amortisseur pouvant \u00eatre mont\u00e9 ult\u00e9rieurement, combin\u00e9 aux avantages d'un ch\u00e2ssis filet\u00e9 KW\navec commande App en option\ntrois r\u00e9glages d'amortissement : Confort \/ Sport \/ Sport +\nCommande par bouton-poussoir de seconde monte ou par app en option\ncr\u00e9er ses propres r\u00e9glages de mani\u00e8re intuitive via l'application KW DDC\n\nBouton-poussoir KW DDC - 1x bouton-poussoir, 3x en savoir plusLe kit de livraison du combin\u00e9 filet\u00e9 KW DDC ECU comprend \u00e9galement un bouton-poussoir KW DDC. Celui-ci permet, si on le souhaite, de s\u00e9lectionner les modes de conduite KW DDC \"Confort\", \"Sport\" et \"Sport+\" directement depuis le cockpit. Pour cela, le bouton KW DDC change de couleur en fonction de l'APP KW DDC.\n\nUniquement pour les v\u00e9hicules avec un diam\u00e8tre de serrage de 55 mm \u00e0 l'avant\npr\u00e9r\u00e9gl\u00e9 de mani\u00e8re optimale\ntechnique d'amortissement sportive et harmonieuse\nTechnique en acier inoxydable \"inox-line\nr\u00e9glage individuel de la hauteur\nplage de r\u00e9glage contr\u00f4l\u00e9e\nsolution compl\u00e8te pr\u00eate au montage\ncomposants de haute qualit\u00e9 pour une longue dur\u00e9e de vie\ndocumentation compl\u00e8te pour une utilisation facile\n\nModule W-LAN & commande AppCommande App disponible en option pour le r\u00e9glage en direct de la suspension via iPhone, iPod touch, iPad. Faites l'exp\u00e9rience de l'innovation et de la qualit\u00e9 de premi\u00e8re classe \"Made in Germany\" : le combin\u00e9 filet\u00e9 KW DDC (Dynamic Damping Control) avec ECU (Electronic Control Unit). Le ch\u00e2ssis filet\u00e9 avec ses amortisseurs r\u00e9glables \u00e9lectroniquement permet un r\u00e9glage intelligent du ch\u00e2ssis par commande App et est d\u00e9j\u00e0 disponible pour de nombreux v\u00e9hicules sans ch\u00e2ssis adaptatif de s\u00e9rie. Cela vous permet d'am\u00e9liorer votre v\u00e9hicule avec une commande d'amortisseur adaptative et de l'adapter en option \u00e0 votre style de conduite via l'application KW DDC. Pour ce faire, vous n'avez pas besoin d'outils ou d'intervenir vous-m\u00eame sur les amortisseurs. L'application gratuite KW DDC, associ\u00e9e \u00e0 notre module W-Lan disponible en option, est votre outil pour effectuer un r\u00e9glage individuel des amortisseurs en direct et en temps r\u00e9el.",
"de44571ddc4e4d0095c01af6ee299351": "Please always state the HSN\/TSN key number when ordering.\nKW coilover suspension DDC \"inox-line\nKW Dynamic Damping Control ECU Individuality at the push of a button. The KW DDC coilovers are the intelligent suspension solution for retrofitting from the KW iSuspension range. They combine the advantages of an adaptive damping system with a vehicle-specific sporty and harmonious damper characteristic with a stylish and sporty lowering. The adaptive KW coilovers are available in the KW DDC ECU version with optional app control for vehicles without actively controlling standard suspension and as a KW DDC Plug & Play variant for selected vehicle models with adaptive standard suspension. The adaptive KW DDC ECU coilovers allow stepless lowering in the tested adjustment range. Thanks to the dirt-resistant trapezoidal thread and the polyamide threaded ring, the stepless lowering can be varied quickly and easily even after years. Depending on the vehicle, the lowering is carried out either at the wheel-guiding KW stainless steel suspension struts or, in the case of non-wheel-guiding double wishbone rear axles, at the rear axle height adjustment. No matter where in the world, sporty drivers, car manufacturers and tuners trust in our KW technology \"Made in Germany\". Every KW coilover suspension is subjected to extensive load tests during production and is developed and manufactured directly at our company headquarters in Fichtenberg, Swabia, to meet the high standards of our KW quality management. As a German manufacturer, it goes without saying that we offer a multi-year warranty on our KW coilover suspensions, which exceed the original equipment quality and include more than 4,600 applications. When installed by one of our KW dealers, this warranty is valid for up to five years. Currently, the adaptive KW DDC ECU coilovers with app control are available for Audi, BMW, Mercedes-Benz, Porsche, VW and many other vehicles such as the Range Rover Evoque.\n\nretrofittable electronic damper adjustment, combined with the advantages of a KW coilover suspension\nwith optional app control\nthree damping setups: Comfort \/ Sport \/ Sport +\nOperation via retrofit button or optional app\ncreate your own setups intuitively via KW DDC App\n\nKW DDC button - 1x button, 3x learn moreThe scope of delivery of the KW DDC ECU coilover suspension also includes a KW DDC button. This allows you to select the KW DDC driving modes \"Comfort\", \"Sport\" and \"Sport+\" directly from the cockpit. The KW DDC button changes the color to match the KW DDC APP.\n\nOnly for vehicles with a clamping diameter at the VA of 55mm\noptimally adjusted in advance\nsporty-harmonious damping technology\nStainless steel technology \"inox-line\nindividually height adjustable\ntested adjustment range\ncomplete solution ready for installation\nhigh-quality components for long service life\ncomplete documentation for easy handling\n\nW-LAN module & app controlOptionally available app control for live suspension tuning via iPhone, iPod touch, iPad. Experience top-class innovation and quality \"Made in Germany\": the KW DDC (Dynamic Damping Control) coilover suspension with ECU (Electronic Control Unit). The coilover suspension with its electronically adjustable dampers enables intelligent suspension tuning via app control and is already available for numerous vehicles without adaptive standard suspension. This allows you to upgrade your vehicle with adaptive damper control and optionally adjust it to your driving style via the KW DDC app. You don't need any tools to do this or have to work on the dampers yourself. The free KW DDC App in conjunction with our optionally available W-Lan module form your tool to make an individual damper tuning live and in real time."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sportlichkeit gepaart mit herausragender Optik. KW Gewindefahrwerke \u2714 15 Jahre Motorsporterfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Sportiness paired with outstanding looks. KW coilovers \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proven \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2672.35,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2245.6705882353,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2672.35,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2245.6705882353,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2672.35,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2245.6705882353,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2949.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2478.9495798319,
"shop-customer": "2478.9495798319",
"c-dealer": "2245.6705882353",
"b-dealer": "2245.6705882353",
"a-dealer": "2245.6705882353"
},
"fields": {
"displayGroup": [
"a1bb2a6e80c30f2694128a4c4c1f18aa"
]
},
"sort": [
"",
0,
"4277119b3e3f42ff88b2c1035e48ea93"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
821.04 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":"1751f61e61d54c5dad90da34d05a4eb2"}}}},{"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": "1751f61e61d54c5dad90da34d05a4eb2"
}
}
}
},
{
"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"
}
{
"took": 819,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"customPrice-100-300": {
"doc_count": 0,
"customPrice-100-300": {
"value": 0
}
},
"isAvailable-filter": {
"doc_count": 1,
"isAvailable": {
"value": 999.0
}
},
"customPrice-1300": {
"doc_count": 1,
"customPrice-1300": {
"value": 1
}
},
"isUniversal-filter": {
"doc_count": 0,
"isUniversal": {
"value": null
}
},
"customPrice-700-900": {
"doc_count": 0,
"customPrice-700-900": {
"value": 0
}
},
"customPrice-500-700": {
"doc_count": 0,
"customPrice-500-700": {
"value": 0
}
},
"customPrice-3-100": {
"doc_count": 0,
"customPrice-3-100": {
"value": 0
}
},
"price": {
"count": 1,
"min": 2949.95,
"max": 2949.95,
"avg": 2949.95,
"sum": 2949.95
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"customPrice-300-500": {
"doc_count": 0,
"customPrice-300-500": {
"value": 0
}
},
"customPrice-900-1300": {
"doc_count": 0,
"customPrice-900-1300": {
"value": 0
}
},
"properties": {
"doc_count": 26,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0069c56b7c774330b3824768bf6ca954",
"doc_count": 1
},
{
"key": "0220b95241404dd89bc4e2dab8ae9ecf",
"doc_count": 1
},
{
"key": "1f296173e204428aa830b6eb59c92589",
"doc_count": 1
},
{
"key": "1f4f1e52116740d58f2cf5dc29e8f0aa",
"doc_count": 1
},
{
"key": "3015be74c9074b48a71ab82e1d2f13b0",
"doc_count": 1
},
{
"key": "44190d0db2de4821a5837c850fa7a6b5",
"doc_count": 1
},
{
"key": "482363e15d924888a2bff9e098afe40e",
"doc_count": 1
},
{
"key": "52c3546a8b6a4d8ab4c24759592f7dde",
"doc_count": 1
},
{
"key": "5520a78ff8784aac827c7b65729b7da7",
"doc_count": 1
},
{
"key": "5d0f25d19e954ae1bbf8b58c548fb40c",
"doc_count": 1
},
{
"key": "5f7a59b5eff04dccbb6c7cef881200cc",
"doc_count": 1
},
{
"key": "6a791c48f09e46ab965604696f316ef6",
"doc_count": 1
},
{
"key": "6ad29fa6f1e6438cb5e0fc6053de7053",
"doc_count": 1
},
{
"key": "765fe03fdd044109908e44f5e668917c",
"doc_count": 1
},
{
"key": "79d752468929417b92818fd0c2732713",
"doc_count": 1
},
{
"key": "870cb58e9d264ac28124c2898b130d16",
"doc_count": 1
},
{
"key": "90eefafb79e340c8a6154c2c4281437a",
"doc_count": 1
},
{
"key": "98810049b2d24ea988a77bbe0ff1cb08",
"doc_count": 1
},
{
"key": "9c1f771006e44da4b2ac780446836ecc",
"doc_count": 1
},
{
"key": "9ed679919c734089bd086012ec6e95bf",
"doc_count": 1
},
{
"key": "a1bea52c47894809a1dabe0a5e930ede",
"doc_count": 1
},
{
"key": "a6171f405e5e4f399c7922761664c44e",
"doc_count": 1
},
{
"key": "b52ea71a63f24fb6b19d2fbd3bbe7ea2",
"doc_count": 1
},
{
"key": "b998b172e7ef4f27b9c119c138878473",
"doc_count": 1
},
{
"key": "c4e5f11d07994ce098f70e4e1190edf9",
"doc_count": 1
},
{
"key": "cea3fda09024441f85499a234a9e12da",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "90f5dc23bbfb405ca7cebd3321b99bcd",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|