| 1 |
5.43 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":"b492285eb7594a95a72b4e6bdb4fffcf"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["5494b24b09d445ebace47112836b4458","de44571ddc4e4d0095c01af6ee299351","2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"fts_product_is_bartek"}},"order":"DESC"}},{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "d57ce16e5d6c493090d1232e756dcf2a",
"_score": null,
"_source": {
"id": "d57ce16e5d6c493090d1232e756dcf2a",
"autoIncrement": 59268.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "DPP20TMQBIS20SP",
"ean": null,
"displayGroup": "6cc5cb5fd7fbae26d9e4fc359f69f041",
"sales": 0,
"stock": 0,
"weight": 0.1,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "049d04ff57b0486eb57cb1ecd2f60649",
"manufacturerNumber": "DPP20TMQBIS20SP",
"releaseDate": null,
"createdAt": "2019-07-24T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"4f325ac5501a40fa98f239034ed2f949",
"e797b77047e84d24a2e01bb471812b90",
"b9b451997c214440a0c2fdde63492331",
"c2ae32cf01d64b04a20f1145ab12aea3",
"263c9a24122642829cd4c680c9a29299",
"b492285eb7594a95a72b4e6bdb4fffcf",
"d4da6d645b7245f393c903fadbe3eb93",
"fb43f528a97e4b14a61f9bede37f4c06"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "4f325ac5501a40fa98f239034ed2f949",
"_count": 1
},
{
"id": "e797b77047e84d24a2e01bb471812b90",
"_count": 1
},
{
"id": "b9b451997c214440a0c2fdde63492331",
"_count": 1
},
{
"id": "c2ae32cf01d64b04a20f1145ab12aea3",
"_count": 1
},
{
"id": "263c9a24122642829cd4c680c9a29299",
"_count": 1
},
{
"id": "b492285eb7594a95a72b4e6bdb4fffcf",
"_count": 1
},
{
"id": "d4da6d645b7245f393c903fadbe3eb93",
"_count": 1
},
{
"id": "fb43f528a97e4b14a61f9bede37f4c06",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "f8ec8d2eb9304bb08f6f81270e848235",
"childCount": 0,
"categories": [
{
"id": "d4da6d645b7245f393c903fadbe3eb93",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "TT",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TT",
"5494b24b09d445ebace47112836b4458": "TT",
"de44571ddc4e4d0095c01af6ee299351": "TT"
}
},
{
"id": "b492285eb7594a95a72b4e6bdb4fffcf",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tiguan",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tiguan",
"5494b24b09d445ebace47112836b4458": "Tiguan",
"de44571ddc4e4d0095c01af6ee299351": "Tiguan"
}
},
{
"id": "fb43f528a97e4b14a61f9bede37f4c06",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Golf 7",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Golf 7",
"5494b24b09d445ebace47112836b4458": "Golf 7",
"de44571ddc4e4d0095c01af6ee299351": "Golf 7"
}
},
{
"id": "263c9a24122642829cd4c680c9a29299",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Octavia",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Octavia",
"5494b24b09d445ebace47112836b4458": "Octavia",
"de44571ddc4e4d0095c01af6ee299351": "Octavia"
}
}
],
"manufacturer": {
"id": "049d04ff57b0486eb57cb1ecd2f60649",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "APR",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "APR"
},
"_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": "16a8f75b2a1242d5b0d17a5419176132",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Octavia",
"5494b24b09d445ebace47112836b4458": "Octavia",
"de44571ddc4e4d0095c01af6ee299351": "Octavia"
}
},
{
"id": "1f296173e204428aa830b6eb59c92589",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cupra",
"5494b24b09d445ebace47112836b4458": "Cupra",
"de44571ddc4e4d0095c01af6ee299351": "Cupra"
}
},
{
"id": "2afa5482e15349e3aff5d10ae7172047",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A6 \/ S6 \/ RS6",
"5494b24b09d445ebace47112836b4458": "A6 \/ S6 \/ RS6",
"de44571ddc4e4d0095c01af6ee299351": "A6 \/ S6 \/ RS6"
}
},
{
"id": "331c8b3f32d54654a10a36ee96cd54b8",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CHHA | 230 PS (169 kW)",
"5494b24b09d445ebace47112836b4458": "CHHA | 230 ch (169 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CHHA | 230 hp (169 kW)"
}
},
{
"id": "3614ecdc0f644f76b5a59ec1975bac4d",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DKTA | 230 PS (169 kW)",
"5494b24b09d445ebace47112836b4458": "DKTA | 230 ch (169 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DKTA | 230 hp (169 kW)"
}
},
{
"id": "37e6f10ae7af4ff6b65163eb52bbed73",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "C8 (4K) | BJ 2018->",
"5494b24b09d445ebace47112836b4458": "C8 (4K) | BJ 2018->",
"de44571ddc4e4d0095c01af6ee299351": "C8 (4K) | Year built 2018->"
}
},
{
"id": "3ba076355bc24e2dacea6045c6071a87",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tiguan",
"5494b24b09d445ebace47112836b4458": "Tiguan",
"de44571ddc4e4d0095c01af6ee299351": "Tiguan"
}
},
{
"id": "40677f501d784284868fe341625182ed",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F3 | BJ 2018->",
"5494b24b09d445ebace47112836b4458": "F3 | BJ 2018->",
"de44571ddc4e4d0095c01af6ee299351": "F3 | Year built 2018->"
}
},
{
"id": "42ec0b7cb8824f6194b239e610efde25",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "III (Typ 5E) | BJ 2012-2019",
"5494b24b09d445ebace47112836b4458": "III (type 5E) | BJ 2012-2019",
"de44571ddc4e4d0095c01af6ee299351": "III (Type 5E) | Year built 2012-2019"
}
},
{
"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": "53acb6fc17a343f6a7f7790d4308049b",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "C8 | Year built 2018->",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "C8 (Typ F2) | BJ 2018->",
"5494b24b09d445ebace47112836b4458": "C8 (type F2) | BJ 2018->"
}
},
{
"id": "5520a78ff8784aac827c7b65729b7da7",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Golf",
"5494b24b09d445ebace47112836b4458": "Golf",
"de44571ddc4e4d0095c01af6ee299351": "Golf"
}
},
{
"id": "584510b78d3a45b29617b47fb1f32cec",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "A7 \/ S7 \/ RS7",
"5494b24b09d445ebace47112836b4458": "A7 \/ S7 \/ RS7",
"de44571ddc4e4d0095c01af6ee299351": "A7 \/ S7 \/ RS7"
}
},
{
"id": "5bf90ae818984cb2864069c0f2341244",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "II (Typ AD1) | BJ 2016-2023",
"5494b24b09d445ebace47112836b4458": "II (type AD1) | BJ 2016-2023",
"de44571ddc4e4d0095c01af6ee299351": "II (Type AD1) | Year built 2016->"
}
},
{
"id": "5ce5282afb24454d9103ec3c791990a2",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "2.0 TFSI (EA888)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 TFSI (EA888 Gen. 1 & 2)",
"5494b24b09d445ebace47112836b4458": "2.0 TFSI (EA888 Gen. 1 & 2)"
}
},
{
"id": "663282aa1b3d4530b86b68e0f56a1f6f",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DKTB | 245 PS (180 kW)",
"5494b24b09d445ebace47112836b4458": "DKTB | 245 ch (180 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DKTB | 245 hp (180 kW)"
}
},
{
"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": "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": "8a480d3cf5194472a30603939ebf5b5b",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sportback | BJ 2019->",
"5494b24b09d445ebace47112836b4458": "Sportback | BJ 2019->",
"de44571ddc4e4d0095c01af6ee299351": "Sportback | Year built 2019->"
}
},
{
"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": "ac46e7be4ba1420e8c4bbebdaefc26f6",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "\u0160koda",
"5494b24b09d445ebace47112836b4458": "\u0160koda",
"de44571ddc4e4d0095c01af6ee299351": "\u0160koda"
}
},
{
"id": "b57b56d48b7542f6b82f8cec0a01af4b",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Q3 \/ RS Q3",
"5494b24b09d445ebace47112836b4458": "Q3 \/ RS Q3",
"de44571ddc4e4d0095c01af6ee299351": "Q3 \/ RS Q3"
}
},
{
"id": "c21bc6bc6ccd44759d256848e311a46b",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "IV (Typ NX) | BJ 2019->",
"5494b24b09d445ebace47112836b4458": "IV (type NX) | BJ 2019->",
"de44571ddc4e4d0095c01af6ee299351": "IV (Type NX) | Year built 2019->"
}
},
{
"id": "cea3fda09024441f85499a234a9e12da",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Formentor",
"5494b24b09d445ebace47112836b4458": "Formentor",
"de44571ddc4e4d0095c01af6ee299351": "Formentor"
}
},
{
"id": "ed23d9fc7ccb43079af2a2920d14c441",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DLBA | 245 PS (180 kW)",
"5494b24b09d445ebace47112836b4458": "DLBA | 245 ch (180 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DLBA | 245 hp (180 kW)"
}
},
{
"id": "ed463056d2804fe6a4c2551a24c29c3d",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CHHC | 230 PS (169 kW)",
"5494b24b09d445ebace47112836b4458": "CHHC | 230 ch (169 kW)",
"de44571ddc4e4d0095c01af6ee299351": "CHHC | 230 hp (169 kW)"
}
},
{
"id": "ed9c23fea1924e4ab69b4907e7b070b6",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DNJA | 230 PS (169 kW)",
"5494b24b09d445ebace47112836b4458": "DNJA | 230 ch (169 kW)",
"de44571ddc4e4d0095c01af6ee299351": "DNJA | 230 hp (169 kW)"
}
}
],
"options": [],
"categoryIds": [
"263c9a24122642829cd4c680c9a29299",
"b492285eb7594a95a72b4e6bdb4fffcf",
"d4da6d645b7245f393c903fadbe3eb93",
"fb43f528a97e4b14a61f9bede37f4c06"
],
"optionIds": [],
"propertyIds": [
"0069c56b7c774330b3824768bf6ca954",
"0220b95241404dd89bc4e2dab8ae9ecf",
"16a8f75b2a1242d5b0d17a5419176132",
"1f296173e204428aa830b6eb59c92589",
"2afa5482e15349e3aff5d10ae7172047",
"331c8b3f32d54654a10a36ee96cd54b8",
"3614ecdc0f644f76b5a59ec1975bac4d",
"37e6f10ae7af4ff6b65163eb52bbed73",
"3ba076355bc24e2dacea6045c6071a87",
"40677f501d784284868fe341625182ed",
"42ec0b7cb8824f6194b239e610efde25",
"52c3546a8b6a4d8ab4c24759592f7dde",
"53acb6fc17a343f6a7f7790d4308049b",
"5520a78ff8784aac827c7b65729b7da7",
"584510b78d3a45b29617b47fb1f32cec",
"5bf90ae818984cb2864069c0f2341244",
"5ce5282afb24454d9103ec3c791990a2",
"663282aa1b3d4530b86b68e0f56a1f6f",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"765fe03fdd044109908e44f5e668917c",
"870cb58e9d264ac28124c2898b130d16",
"8a480d3cf5194472a30603939ebf5b5b",
"a1bea52c47894809a1dabe0a5e930ede",
"ac46e7be4ba1420e8c4bbebdaefc26f6",
"b57b56d48b7542f6b82f8cec0a01af4b",
"c21bc6bc6ccd44759d256848e311a46b",
"cea3fda09024441f85499a234a9e12da",
"ed23d9fc7ccb43079af2a2920d14c441",
"ed463056d2804fe6a4c2551a24c29c3d",
"ed9c23fea1924e4ab69b4907e7b070b6"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_bullet0": "APR Stage 1 Software",
"migration_Shopware5DB_product_bullet1": "Optimiert auf 286 PS",
"migration_Shopware5DB_product_bullet2": "Mit T\u00dcV-Gutachten",
"migration_Shopware5DB_product_bullet3": "APR Care m\u00f6glich",
"migration_Shopware5DB_product_bullet4": "F\u00fcr original Hardware",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "opf-chiptuning-software-apr-2-0-l-tsi-mqb",
"migration_Shopware5DB_product_dreisc_seo_title": "OPF Chiptuning-Software von APR f\u00fcr 2.0L TSI EA888 Gen.3",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_bullet0": "APR Stage 1 Software",
"migration_Shopware5DB_product_bullet1": "Optimiert auf 286 PS",
"migration_Shopware5DB_product_bullet2": "Mit T\u00dcV-Gutachten",
"migration_Shopware5DB_product_bullet3": "APR Care m\u00f6glich",
"migration_Shopware5DB_product_bullet4": "F\u00fcr original Hardware",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "OPF Chiptuning-Software von APR f\u00fcr 2.0L TSI EA888 Gen.3",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_bullet0": "APR Stage 1 Software",
"migration_Shopware5DB_product_bullet1": "Optimized to 286 hp",
"migration_Shopware5DB_product_bullet2": "With T\u00dcV certificate",
"migration_Shopware5DB_product_bullet3": "APR Care possible",
"migration_Shopware5DB_product_bullet4": "For original hardware",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "opf-chip-tuning-software-apr-2-0-l-tsi-mqb",
"migration_Shopware5DB_product_dreisc_seo_title": "OPF chip tuning software from APR for 2.0L TSI EA888 Gen.3",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TSI Golf 7 GTI, Audi TT etc. OPF Chiptuning Software APR",
"5494b24b09d445ebace47112836b4458": "2.0L TSI Golf 7 GTI, Audi TT etc. OPF Chiptuning Software APR",
"de44571ddc4e4d0095c01af6ee299351": "2.0L TSI EA888 Gen.3 MQB OPF chip tuning software APR"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die APR Stage 1 Software f\u00fcr die neuen 2.0 TSI\/TFSI 230 PS & 245 PS mit Otto-Partikelfilter. Aufgrund des Partikelfilters konnten wir leider nicht mehr an die Leistungsausbeute des Vorg\u00e4ngers ankn\u00fcpfen.\nMit der APR Software hast du den Anfang gemacht, um deinen 2.0L TSI mehr Leistung einzuhauchen. Eine einfache und sichere Sache dein Fahrzeug zu tunen und das alles mit T\u00dcV. Dazu kommt, dass du durch die APR Software ein solides Fundament f\u00fcr alle weiteren Tuning-Ma\u00dfnahmen hast. Wenn du sp\u00e4ter einmal aufr\u00fcsten m\u00f6chtest, um noch mehr Leistung zu generieren, z.B durch eine Downpipe und Hochdruckpumpe von APR, kannst du diese Software ohne Aufpreis mit einem Upgrade erweitern. M\u00f6chtest du auf ein Upgrade erweitern mit Hardware-Komponenten die nicht von APR sind, z.B eine Downpipe von einem anderen Hersteller, kannst du das f\u00fcr einen Aufpreis von 389\u20ac. Hier ein Beispiel: Du hast die Stage 1 Software auf Stage 2 aktualisiert, m\u00f6chtest jetzt einen gr\u00f6\u00dferen Turbolader montieren, dann bekommst du daf\u00fcr das Software-Upgrade gratis. Features Software Stage 1:\n\nF\u00fcr original Hardware\nOptimiert auf 286 PS\nErh\u00f6htes Drehmoment auf 450 Nm\nMit T\u00dcV-Gutachten\nUpgrade auf alle APR Hardware Komponenten Gratis\nBetreuung vom APR K\u00f6ln St\u00fctzpunkt\nAPR Care m\u00f6glich\n\nAlle Hardwareteile, welche an den jeweiligen Vorg\u00e4ngern gepasst haben, passen auch an den OPF Fahrzeugen.\nAPR Chiptuning by BAR-TEK Motorsport. Entweder nach Terminabsprache bei uns vor Ort (n\u00e4he K\u00f6ln) oder per Einsenden deines Steuerger\u00e4tes.\nDie APR Software ist eine Anschaffung f\u00fcr\u00b4s ganze TSI Leben. Du bist versorgt von Stufe 1 - Open End!",
"5494b24b09d445ebace47112836b4458": "Le logiciel APR Stage 1 pour les nouvelles 2.0 TSI\/TFSI 230 HP & 245 PS avec filtre \u00e0 particules HP . En raison du filtre \u00e0 particules, nous n'avons malheureusement pas pu \u00e9galer la puissance du pr\u00e9d\u00e9cesseur.\nAvec le logiciel APR, vous avez commenc\u00e9 \u00e0 donner plus de puissance \u00e0 votre TSI 2.0L.Un moyen simple et s\u00fbr de r\u00e9gler votre voiture et tout cela avec le T\u00dcV.En outre, le logiciel APR vous offre une base solide pour toutes les mesures de r\u00e9glage ult\u00e9rieures.Si vous souhaitez effectuer une mise \u00e0 niveau ult\u00e9rieure pour produire encore plus d'\u00e9nergie, par exemple avec une pompe \u00e0 haute pression et un tuyau de descente de l'APR, vous pouvez mettre ce logiciel \u00e0 niveau sans frais suppl\u00e9mentaires. Si vous souhaitez effectuer une mise \u00e0 niveau avec des composants mat\u00e9riels qui ne proviennent pas d'APR, par exemple un tuyau de descente d'un autre fabricant, vous pouvez le faire pour 389\u20ac suppl\u00e9mentaires. Voici un exemple : si vous avez mis \u00e0 niveau le logiciel de la phase 1 vers la phase 2 et que vous souhaitez maintenant installer un turbocompresseur plus puissant, vous obtiendrez la mise \u00e0 niveau du logiciel gratuitement. Comprend l'\u00e9tape 1 du logiciel :\n\nPour le mat\u00e9riel d'origine\nOptimis\u00e9 \u00e0 286 HP\nAugmentation du couple \u00e0 450 Nm\nAvec certificat T\u00dcV\nMise \u00e0 niveau de tous les composants mat\u00e9riels de l'APR Gratuit\nSoutien de la base APR de Cologne\nAPR Care possible\n\nToutes les pi\u00e8ces de quincaillerie, qui s'adaptent sur les pr\u00e9d\u00e9cesseurs respectifs, s'adaptent \u00e9galement sur les v\u00e9hicules de l'OPF.\nAPR Chiptuning par bar-tek Motorsport. Soit en prenant rendez-vous avec nous sur place (pr\u00e8s de Cologne), soit en nous envoyant votre unit\u00e9 de contr\u00f4le.\nLe logiciel APR est un achat pour toute la dur\u00e9e de vie du TSI. Vous \u00eates fourni \u00e0 partir de l'\u00e9tape 1 - Open End !",
"de44571ddc4e4d0095c01af6ee299351": "The APR Stage 1 software for the new 2.0 TSI \/ TFSI 230 hp & 245 hp with Otto particle filter.Unfortunately, due to the particle filter, we were unable to match the performance of our pre facelift.\nWith the APR software you have made the beginning to give your 2.0L TSI more power.A simple and safe thing to tune your vehicle and all this with T\u00dcV.In addition, the APR software provides you with a solid foundation for all further tuning measures.If you want to upgrade later to get even more power, for example through a downpipe and APR high pressure pump, you can upgrade this software at no extra cost. If you want to upgrade to hardware components that are not from APR, such as a downpipe from another manufacturer, you can do that for an additional charge of 389 \u20ac.\nHere is an example: You have updated the Stage 1 software on Stage 2, now you want to mount a larger turbocharger, then you get the software upgrade for free.\nFeatures Software Stage 1:\n\nFor original hardware\nOptimized to 286 hp\nIncreased torque to 450 Nm\nWith T\u00dcV certificate\nUpgrade to all APR hardware components for free\nSupervision of the APR Cologne base\nAPR Care possible\n\nAll hardware parts that fit the respective predecessors also fit on the OPF vehicles.\nAPR Chiptuning by BAR-TEK Motorsport. Either by appointment with us locally (near Cologne) or by sending in your control unit.\nThe APR software is an acquisition for the whole TSI life. You are powered by Level 1 - Open End!"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TSI Golf 7 GTI, TT 8S & A3 8V Chiptuning Software APR",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "OPF chip tuning software from APR for 2.0L TSI EA888 Gen.3"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stage 1 - Optimiert auf 286 PS bei 450 Nm - und das ganze mit T\u00dcV! \u2713 25 Jahre Motorsport-Erfahrung \u2713 schneller Versand \u2713 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Stage 1 - Optimized to 286 hp at 450 Nm - and the whole with T\u00dcV! \u2713 15 years of motorsport experience \u2713 fast shipping \u2713 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1273,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1069.75,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1139.01,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 957.15,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1206.01,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1013.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1338.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1125.1680672269,
"shop-customer": "1125.1680672269",
"c-dealer": "1069.75",
"a-dealer": "957.15",
"b-dealer": "1013.45"
},
"fields": {
"displayGroup": [
"6cc5cb5fd7fbae26d9e4fc359f69f041"
]
},
"sort": [
"",
0,
"d57ce16e5d6c493090d1232e756dcf2a"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.46 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":"b492285eb7594a95a72b4e6bdb4fffcf"}}}},{"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": "b492285eb7594a95a72b4e6bdb4fffcf"
}
}
}
},
{
"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": 4,
"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": 0.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": 1338.95,
"max": 1338.95,
"avg": 1338.95,
"sum": 1338.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": 30,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0069c56b7c774330b3824768bf6ca954",
"doc_count": 1
},
{
"key": "0220b95241404dd89bc4e2dab8ae9ecf",
"doc_count": 1
},
{
"key": "16a8f75b2a1242d5b0d17a5419176132",
"doc_count": 1
},
{
"key": "1f296173e204428aa830b6eb59c92589",
"doc_count": 1
},
{
"key": "2afa5482e15349e3aff5d10ae7172047",
"doc_count": 1
},
{
"key": "331c8b3f32d54654a10a36ee96cd54b8",
"doc_count": 1
},
{
"key": "3614ecdc0f644f76b5a59ec1975bac4d",
"doc_count": 1
},
{
"key": "37e6f10ae7af4ff6b65163eb52bbed73",
"doc_count": 1
},
{
"key": "3ba076355bc24e2dacea6045c6071a87",
"doc_count": 1
},
{
"key": "40677f501d784284868fe341625182ed",
"doc_count": 1
},
{
"key": "42ec0b7cb8824f6194b239e610efde25",
"doc_count": 1
},
{
"key": "52c3546a8b6a4d8ab4c24759592f7dde",
"doc_count": 1
},
{
"key": "53acb6fc17a343f6a7f7790d4308049b",
"doc_count": 1
},
{
"key": "5520a78ff8784aac827c7b65729b7da7",
"doc_count": 1
},
{
"key": "584510b78d3a45b29617b47fb1f32cec",
"doc_count": 1
},
{
"key": "5bf90ae818984cb2864069c0f2341244",
"doc_count": 1
},
{
"key": "5ce5282afb24454d9103ec3c791990a2",
"doc_count": 1
},
{
"key": "663282aa1b3d4530b86b68e0f56a1f6f",
"doc_count": 1
},
{
"key": "6ad29fa6f1e6438cb5e0fc6053de7053",
"doc_count": 1
},
{
"key": "765fe03fdd044109908e44f5e668917c",
"doc_count": 1
},
{
"key": "870cb58e9d264ac28124c2898b130d16",
"doc_count": 1
},
{
"key": "8a480d3cf5194472a30603939ebf5b5b",
"doc_count": 1
},
{
"key": "a1bea52c47894809a1dabe0a5e930ede",
"doc_count": 1
},
{
"key": "ac46e7be4ba1420e8c4bbebdaefc26f6",
"doc_count": 1
},
{
"key": "b57b56d48b7542f6b82f8cec0a01af4b",
"doc_count": 1
},
{
"key": "c21bc6bc6ccd44759d256848e311a46b",
"doc_count": 1
},
{
"key": "cea3fda09024441f85499a234a9e12da",
"doc_count": 1
},
{
"key": "ed23d9fc7ccb43079af2a2920d14c441",
"doc_count": 1
},
{
"key": "ed463056d2804fe6a4c2551a24c29c3d",
"doc_count": 1
},
{
"key": "ed9c23fea1924e4ab69b4907e7b070b6",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "049d04ff57b0486eb57cb1ecd2f60649",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|