| 1 |
4.45 ms |
Request:
{"index":"sw6_stage__product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"bool":{"must_not":[{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.5494b24b09d445ebace47112836b4458"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.de44571ddc4e4d0095c01af6ee299351"}},{"exists":{"field":"customFields.migration_Shopware5DB_product_attr17.2fbb5fe2e29a4d70aa5854ce7ce3e20b"}}]}},{"multi_match":{"query":false,"fields":["customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_attr17","customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_attr17","customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_attr17"],"type":"best_fields"}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"bc03b12fca6e446c9bbe735ae1f4d0ce"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"bb648acf4e8e4bf5a5b8280bfc3b0a2c"}}}},{"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": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "09cdac798f2b4b85be7a7d834c86aa23",
"_score": null,
"_source": {
"id": "09cdac798f2b4b85be7a7d834c86aa23",
"autoIncrement": 57815.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "101-2801.1",
"ean": "672036048723",
"displayGroup": "800ae4947293114c49edb30b3d5d296a",
"sales": 0,
"stock": 0,
"weight": 0.5,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "f20e3466c41c4e2fbee6750a8f9914ed",
"manufacturerNumber": "101-2802",
"releaseDate": null,
"createdAt": "2019-04-17T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"7b61f1c673a14ba7a90ea1aed2f7a74a",
"bb648acf4e8e4bf5a5b8280bfc3b0a2c"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "7b61f1c673a14ba7a90ea1aed2f7a74a",
"_count": 1
},
{
"id": "bb648acf4e8e4bf5a5b8280bfc3b0a2c",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "32513a28167e43be8c67f1da4c375526",
"coverId": "b726cb8c2af8422ab53dd1aa961afae5",
"childCount": 0,
"categories": [
{
"id": "bb648acf4e8e4bf5a5b8280bfc3b0a2c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Tornillos del volante ARP",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ARP Schwungradschrauben",
"5494b24b09d445ebace47112836b4458": "ARP Vis de volant d'inertie",
"de44571ddc4e4d0095c01af6ee299351": "ARP flywheel bolts"
}
}
],
"manufacturer": {
"id": "f20e3466c41c4e2fbee6750a8f9914ed",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ARP",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "ARP"
},
"_count": 1
},
"properties": [
{
"id": "09bbfea2510d4e85ae59cd5a38699f35",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "174 PS (128 kW) \/ #3421",
"5494b24b09d445ebace47112836b4458": "174 ch (128 kW) \/ #3421",
"de44571ddc4e4d0095c01af6ee299351": "174 hp (128 kW) \/ #3421"
}
},
{
"id": "137dc4c666f64dd5a0c05f4ef1426cff",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "184 PS (135 kW) \/ #3422",
"5494b24b09d445ebace47112836b4458": "184 ch (135 kW) \/ #3422",
"de44571ddc4e4d0095c01af6ee299351": "184 hp (135 kW) \/ #3422"
}
},
{
"id": "198e5f1dd4214b26a7ffd382535f2e6e",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1. Gen. (Typ R50) | BJ 2001-2006",
"5494b24b09d445ebace47112836b4458": "1. Gen (type R50) | ann\u00e9e 2001-2006",
"de44571ddc4e4d0095c01af6ee299351": "1. Gen. (Type R50) | Year built 2001-2006"
}
},
{
"id": "2569817a856e4b9e8e32b0da1a364abc",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "TT FV\/8S",
"5494b24b09d445ebace47112836b4458": "TT FV\/8S",
"de44571ddc4e4d0095c01af6ee299351": "TT FV\/8S"
}
},
{
"id": "2f9764491ce84b4a91b1d9e8ac56e21b",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.6 16V R4",
"5494b24b09d445ebace47112836b4458": "1.6 16V R4",
"de44571ddc4e4d0095c01af6ee299351": "1.6 16V R4"
}
},
{
"id": "33b42c80fc9341f595d8cb68f53d1ae6",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "218 PS (160 kW) \/ #3431",
"5494b24b09d445ebace47112836b4458": "218 ch (160 kW) \/ #3431",
"de44571ddc4e4d0095c01af6ee299351": " 218 hp (160 kW) \/ #3431"
}
},
{
"id": "361d56d2d8cc413990f97ec54b724ce6",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "75 PS (55 kW) \/ #3408",
"5494b24b09d445ebace47112836b4458": "75 ch (55 kW) \/ #3408",
"de44571ddc4e4d0095c01af6ee299351": "75 hp (55 kW) \/ #3408"
}
},
{
"id": "364826fe36344ef88a7285753c556962",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R59) | BJ 2012-2015",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R59) | Year built 2012-2015",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R59) | ann\u00e9e de construction 2012-2015"
}
},
{
"id": "42f18e0ab19b4bb98d90040305243889",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0 D R4",
"5494b24b09d445ebace47112836b4458": "2.0 D R4",
"de44571ddc4e4d0095c01af6ee299351": "2.0 D R4"
}
},
{
"id": "45ae523927c248f38cd00c38a98fb125",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1. Gen. (Typ R53) | BJ 2002-2006",
"de44571ddc4e4d0095c01af6ee299351": "1. Gen. (Type R53) | Year built 2002-2006",
"5494b24b09d445ebace47112836b4458": "1. 2\u00e8me g\u00e9n\u00e9ration (type R53) | ann\u00e9e 2002-2006"
}
},
{
"id": "49484796389847379fdaa70978afb77f",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R55) | BJ 2008-2014",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R55) | Year built 2008-2014",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R55) | ann\u00e9e de construction 2008-2014"
}
},
{
"id": "4acc045baee14956aca4126888799d94",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R60) | BJ 2010-2016",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R60) | Year built 2010-2016",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R60) | ann\u00e9e de construction 2010-2016"
}
},
{
"id": "5c39b0e075c54b50aaa1a2aa5eb84ed1",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R61) | BJ 2013-2015",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R61) | Year built 2013-2015",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R61) | BJ 2013-2015"
}
},
{
"id": "5f18d2b68d8b4629b49b1f31d9def107",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R56) | BJ 2007-2013",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R56) | Year built 2007-2013",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R56) | BJ 2007-2013"
}
},
{
"id": "67cbca122f8f48f480e46d470145d54a",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "190 PS (140 kW) \/ #3434",
"5494b24b09d445ebace47112836b4458": "190 ch (140 kW) \/ #3434",
"de44571ddc4e4d0095c01af6ee299351": " 190 hp (140 kW) \/ #3434"
}
},
{
"id": "6ad29fa6f1e6438cb5e0fc6053de7053",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Audi",
"5494b24b09d445ebace47112836b4458": "Audi",
"de44571ddc4e4d0095c01af6ee299351": "Audi"
}
},
{
"id": "71a9da52787e4da1ab3e417a6a3c4e7a",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI EA888 Gen3 TTS (310 PS) | CJXG | BJ 10.2014 - 06.2018",
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI EA888 Gen.3 TTS (310 CV) | CJXG | BJ 10.2014 - 06.2018",
"de44571ddc4e4d0095c01af6ee299351": "2.0L TFSI EA888 Gen3 TTS (310 PS) | CJXG | Year 10.2014 - 06.2018"
}
},
{
"id": "7340f68bb9e645e98f5323516bc1750a",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Clubman",
"5494b24b09d445ebace47112836b4458": "Clubman",
"de44571ddc4e4d0095c01af6ee299351": "Clubman"
}
},
{
"id": "79b376d7c51c4ce1a1c57857d473caed",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cabrio",
"5494b24b09d445ebace47112836b4458": "Cabrio",
"de44571ddc4e4d0095c01af6ee299351": "Cabrio"
}
},
{
"id": "7a0417fc8ebf4473a7730750ccfaf8c7",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"5494b24b09d445ebace47112836b4458": "Hatch (3 portes)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hatch (3-T\u00fcrer)",
"de44571ddc4e4d0095c01af6ee299351": "Hatch (3-T\u00fcrer)"
}
},
{
"id": "7e9237ca26d54596ad7f3d62c5340273",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mini Coup\u00e9",
"5494b24b09d445ebace47112836b4458": "Mini Coup\u00e9",
"de44571ddc4e4d0095c01af6ee299351": "Mini Coup\u00e9"
}
},
{
"id": "8a71c7427b5048df9a36d2d7cde8153b",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Roadster",
"5494b24b09d445ebace47112836b4458": "Roadster",
"de44571ddc4e4d0095c01af6ee299351": "Roadster"
}
},
{
"id": "90963d9d34f24aefa8e9858a45f15da8",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "170 PS (125 kW) \/ #3424",
"5494b24b09d445ebace47112836b4458": "170 ch (125 kW) \/ #3424",
"de44571ddc4e4d0095c01af6ee299351": "170 hp (125 kW) \/ #3424"
}
},
{
"id": "975e09f2553041f28f47602bb60358c1",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "120 PS (88 kW) \/ #3414",
"5494b24b09d445ebace47112836b4458": "120 ch (88 kW) \/ #3414",
"de44571ddc4e4d0095c01af6ee299351": " 120 hp (88 kW) \/ #3414"
}
},
{
"id": "9b3ed6ccf44947dca76c4bc8c31cb3c5",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BJ 2014 ->",
"5494b24b09d445ebace47112836b4458": "BJ 2014 ->",
"de44571ddc4e4d0095c01af6ee299351": "Year built 2014 ->"
}
},
{
"id": "aac0e1abf52541f3be34bfdb05fb8c52",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "122 PS (90 kW) \/ #3415",
"5494b24b09d445ebace47112836b4458": "122 ch (90 kW) \/ #3415",
"de44571ddc4e4d0095c01af6ee299351": " 122 hp (90 kW) \/ #3415"
}
},
{
"id": "ade0d98e8d5b4ae68d56050fb399b61a",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "98 PS (72 kW) \/ #3409",
"5494b24b09d445ebace47112836b4458": "98 ch (72 kW) \/ #3409",
"de44571ddc4e4d0095c01af6ee299351": "98 hp (72 kW) \/ #3409"
}
},
{
"id": "ba70329b941d482ead4f3e5da5d5b7ad",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "143 PS (105 kW) \/ #3439",
"5494b24b09d445ebace47112836b4458": "143 ch (105 kW) \/ #3439",
"de44571ddc4e4d0095c01af6ee299351": "143 hp (105 kW) \/ #3439"
}
},
{
"id": "bdf1b057e67947c5b56b62d86228ba28",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R57) | BJ 2009-2015",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R57) | Year built 2009-2015",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R57) | ann\u00e9e 2009-2015"
}
},
{
"id": "bfbfbb910cb44e51957959c74e1c3058",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "211 PS (155 kW) \/ #3430",
"5494b24b09d445ebace47112836b4458": "211 ch (155 kW) \/ #3430",
"de44571ddc4e4d0095c01af6ee299351": " 211 hp (155 kW) \/ #3430"
}
},
{
"id": "d277d36775cd48b9a0bca5bc096f2a19",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "116 PS (85 kW) \/ #3413",
"5494b24b09d445ebace47112836b4458": "116 ch (85 kW) \/ #3413",
"de44571ddc4e4d0095c01af6ee299351": "116 hp (85 kW) \/ #3413"
}
},
{
"id": "d294b6aa0e35462385ee6ae1eef7acc3",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1. Gen. (Typ R52) | BJ 2004-2008",
"de44571ddc4e4d0095c01af6ee299351": "1. Gen. (Type R52) | Year built 2004-2008",
"5494b24b09d445ebace47112836b4458": "1. 2\u00e8me g\u00e9n\u00e9ration (type R52) | ann\u00e9e de construction 2004-2008"
}
},
{
"id": "da2eae4ba42c469a812d98b46101d5c1",
"_count": 1,
"groupId": "3f7ee0c73e1e467a82182c6c2706a946",
"group": {
"id": "3f7ee0c73e1e467a82182c6c2706a946",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2. Gen. (Typ R58) | BJ 2011-2015",
"de44571ddc4e4d0095c01af6ee299351": "2. Gen. (Type R58) | Year built 2011-2015",
"5494b24b09d445ebace47112836b4458": "2. 2\u00e8me g\u00e9n\u00e9ration (type R58) | ann\u00e9e 2011-2015"
}
},
{
"id": "dc5f68007a3144f79fcd5931d6802de4",
"_count": 1,
"groupId": "22a715b71ff441609b1deade031b2578",
"group": {
"id": "22a715b71ff441609b1deade031b2578",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4 16V R4",
"5494b24b09d445ebace47112836b4458": "1.4 16V R4",
"de44571ddc4e4d0095c01af6ee299351": "1.4 16V R4"
}
},
{
"id": "decb73d1756b48fb9931e7503eb0be66",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "163 PS (120 kW) \/#3423",
"5494b24b09d445ebace47112836b4458": "163 ch (120 kW) \/#3423",
"de44571ddc4e4d0095c01af6ee299351": " 163 hp (120 kW) \/#3423"
}
},
{
"id": "e0f5f4ce9a8443bdb3c10f23134da8d5",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Paceman",
"5494b24b09d445ebace47112836b4458": "Paceman",
"de44571ddc4e4d0095c01af6ee299351": "Paceman"
}
},
{
"id": "e113237b92144df4bffa8329c13d6230",
"_count": 1,
"groupId": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"group": {
"id": "9bfe3494a0a0490e92b3f5f9af6d67c6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mini",
"5494b24b09d445ebace47112836b4458": "Mini",
"de44571ddc4e4d0095c01af6ee299351": "Mini"
}
},
{
"id": "e67b471d27d946678db5e500468fb394",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "75 PS (55 kW) \/ #3406",
"5494b24b09d445ebace47112836b4458": "75 ch (55 kW) \/ #3406",
"de44571ddc4e4d0095c01af6ee299351": "75 hp (55 kW) \/ #3406"
}
},
{
"id": "e825b695e8264d308231d9cacb46a0ff",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "95 PS (70 kW) \/ #3405",
"5494b24b09d445ebace47112836b4458": "95 ch (70 kW) \/ #3405",
"de44571ddc4e4d0095c01af6ee299351": " 95 hp (70 kW) \/ #3405"
}
},
{
"id": "f5f3855e99a24088a75993ec1171ac14",
"_count": 1,
"groupId": "ac03081994a8471bba6ea29efb799da6",
"group": {
"id": "ac03081994a8471bba6ea29efb799da6",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Countryman",
"5494b24b09d445ebace47112836b4458": "Countryman",
"de44571ddc4e4d0095c01af6ee299351": "Countryman"
}
},
{
"id": "f986e276465941d1bcd03af526bd82e6",
"_count": 1,
"groupId": "e00aee2989ce455da4afcb5b09031d05",
"group": {
"id": "e00aee2989ce455da4afcb5b09031d05",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "90 PS (66 kW) \/ #3404",
"5494b24b09d445ebace47112836b4458": "90 ch (66 kW) \/ #3404",
"de44571ddc4e4d0095c01af6ee299351": "90 hp (66 kW) \/ #3404"
}
}
],
"options": [
{
"id": "06fb0aa8440c4099a59b59bff673b106",
"_count": 1,
"groupId": "08c38d44024442a2a3a55906cd8f69b5",
"group": {
"id": "08c38d44024442a2a3a55906cd8f69b5",
"_count": 1
},
"name": {
"de44571ddc4e4d0095c01af6ee299351": "25 mm UHL standard flywheel",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "25 mm UHL Standard-Schwungrad",
"5494b24b09d445ebace47112836b4458": "volant d'inertie standard UHL de 25 mm"
}
}
],
"categoryIds": [
"bb648acf4e8e4bf5a5b8280bfc3b0a2c"
],
"optionIds": [
"06fb0aa8440c4099a59b59bff673b106"
],
"propertyIds": [
"09bbfea2510d4e85ae59cd5a38699f35",
"137dc4c666f64dd5a0c05f4ef1426cff",
"198e5f1dd4214b26a7ffd382535f2e6e",
"2569817a856e4b9e8e32b0da1a364abc",
"2f9764491ce84b4a91b1d9e8ac56e21b",
"33b42c80fc9341f595d8cb68f53d1ae6",
"361d56d2d8cc413990f97ec54b724ce6",
"364826fe36344ef88a7285753c556962",
"42f18e0ab19b4bb98d90040305243889",
"45ae523927c248f38cd00c38a98fb125",
"49484796389847379fdaa70978afb77f",
"4acc045baee14956aca4126888799d94",
"5c39b0e075c54b50aaa1a2aa5eb84ed1",
"5f18d2b68d8b4629b49b1f31d9def107",
"67cbca122f8f48f480e46d470145d54a",
"6ad29fa6f1e6438cb5e0fc6053de7053",
"71a9da52787e4da1ab3e417a6a3c4e7a",
"7340f68bb9e645e98f5323516bc1750a",
"79b376d7c51c4ce1a1c57857d473caed",
"7a0417fc8ebf4473a7730750ccfaf8c7",
"7e9237ca26d54596ad7f3d62c5340273",
"8a71c7427b5048df9a36d2d7cde8153b",
"90963d9d34f24aefa8e9858a45f15da8",
"975e09f2553041f28f47602bb60358c1",
"9b3ed6ccf44947dca76c4bc8c31cb3c5",
"aac0e1abf52541f3be34bfdb05fb8c52",
"ade0d98e8d5b4ae68d56050fb399b61a",
"ba70329b941d482ead4f3e5da5d5b7ad",
"bdf1b057e67947c5b56b62d86228ba28",
"bfbfbb910cb44e51957959c74e1c3058",
"d277d36775cd48b9a0bca5bc096f2a19",
"d294b6aa0e35462385ee6ae1eef7acc3",
"da2eae4ba42c469a812d98b46101d5c1",
"dc5f68007a3144f79fcd5931d6802de4",
"decb73d1756b48fb9931e7503eb0be66",
"e0f5f4ce9a8443bdb3c10f23134da8d5",
"e113237b92144df4bffa8329c13d6230",
"e67b471d27d946678db5e500468fb394",
"e825b695e8264d308231d9cacb46a0ff",
"f5f3855e99a24088a75993ec1171ac14",
"f986e276465941d1bcd03af526bd82e6"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr9": "BB: 25mm #254-2801\n\n(20mm 254-2901 (Ford))",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Schrauben Satz",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "30% H\u00e4rterer Dehnstahl",
"migration_Shopware5DB_product_bullet3": "nahezu unzerst\u00f6rbar",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "mini-schwungradschrauben-heavyduty-arp",
"migration_Shopware5DB_product_dreisc_seo_title": "Mini ARP HEAVY DUTY Schraube f\u00fcr Schwungrad",
"migration_Shopware5DB_product_onco_universal_article": false
},
"5494b24b09d445ebace47112836b4458": {
"migration_Shopware5DB_product_attr9": "BB: 25mm #254-2801\n\n(20mm 254-2901 (Ford))",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Schrauben Satz",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "30% H\u00e4rterer Dehnstahl",
"migration_Shopware5DB_product_bullet3": "nahezu unzerst\u00f6rbar",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Mini ARP HEAVY DUTY Schraube f\u00fcr Schwungrad",
"migration_Shopware5DB_product_onco_universal_article": false
},
"de44571ddc4e4d0095c01af6ee299351": {
"migration_Shopware5DB_product_attr9": "BB: 25mm #254-2801\n\n(20mm 254-2901 (Ford))",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Screws set",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "30% Harder Elongation Steel",
"migration_Shopware5DB_product_bullet3": "almost indestructible",
"migration_Shopware5DB_product_socialfeed": false,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Mini ARP HEAVY DUTY Schraube f\u00fcr Schwungrad",
"migration_Shopware5DB_product_onco_universal_article": false,
"migration_Shopware5DB_product_dreisc_seo_url": "mini-arp-flywheel-bolts-arp-flywheel"
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mini ARP HEAVY DUTY Schraube f\u00fcr Schwungrad",
"5494b24b09d445ebace47112836b4458": "Mini ARP HEAVY DUTY Vis pour volant d'inertie",
"de44571ddc4e4d0095c01af6ee299351": "Mini ARP HEAVY DUTY Bolts for flywheel"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hochfeste ARP Schraube aus Molybd\u00e4n Stahl f\u00fcr die Montage der Schwungscheibe an die Kurbelwelle. F\u00fcr alle Mini Motoren geeignet. Besonders bei getunten Motoren unerl\u00e4sslich, da wesentlich h\u00f6here Drehmomente an der Kurbelwelle \u00fcbertragen werden m\u00fcssen! Gewinde M9x1,25\nAlle ARP Schrauben k\u00f6nnen wiederverwendet werden.\nDiese Schrauben sind l\u00e4nger als Serienschrauben. Bitte bei der Montage beachten! Anzugsfolge: 1) Loctite 242 (blau\/mittelfest) auf die Gewinde auftragen 2) ARP Ultra torque Paste unter den Schraubenkopf auftragen 3) Schrauben nur handfest anziehen 4) Dann \u00fcber Kreuz auf 95 Nm",
"5494b24b09d445ebace47112836b4458": "Vis ARP \u00e0 haute r\u00e9sistance en acier au molybd\u00e8ne pour le montage du volant d'inertie sur le vilebrequin. Convient \u00e0 tous les moteurs Mini. Surtout pour les moteurs r\u00e9gl\u00e9s, ce qui est essentiel, car des couples beaucoup plus \u00e9lev\u00e9s doivent \u00eatre transmis au vilebrequin ! filetage M9x1,25\nToutes les vis ARP peuvent \u00eatre r\u00e9utilis\u00e9es.\nCes vis sont plus longues que les vis standard. A noter lors de l'assembl\u00e9e ! S\u00e9quence de serrage :1) Appliquer de la Loctite 242 (bleu\/moyenne r\u00e9sistance) sur les filets 2)Appliquer de la p\u00e2te ARP Ultra torque sous la t\u00eate de lavis3) Serrer les vis uniquement\u00e0 lamain4) Puis en croix \u00e0 95 Nm",
"de44571ddc4e4d0095c01af6ee299351": "High strength molybdenum steel ARP bolt for mounting the flywheel to the crankshaft. Suitable for all Mini engines.\n\nEspecially essential for tuned engines, since much higher torques must be transmitted to the crankshaft!\n\nThread M9x1,25\n\nAll ARP bolts can be reused.\n\nThese bolts are longer than stock bolts. Please note during assembly!\n\nTightening sequence:\n1) Apply Loctite 242 (blue\/medium strength) to the threads.\n2) Apply ARP Ultra torque Paste under the bolt head.\n3) Tighten bolts only hand-tight\n4) Then tighten crosswise to 95 Nm\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ARP HEAVY DUTY Schraube f\u00fcr Schwungrad VW & Audi",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Mini ARP HEAVY DUTY Bolts for flywheel"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 65.093,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 54.7,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 69.73400000000001,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 58.6,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 66.878,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 56.2,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 52.45,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 44.0756302521008,
"shop-customer": "44.0756302521008",
"a-dealer": "54.7",
"c-dealer": "58.6",
"b-dealer": "56.2"
},
"fields": {
"displayGroup": [
"800ae4947293114c49edb30b3d5d296a"
]
},
"sort": [
"",
0,
"09cdac798f2b4b85be7a7d834c86aa23"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.86 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":"bb648acf4e8e4bf5a5b8280bfc3b0a2c"}}}},{"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": "bb648acf4e8e4bf5a5b8280bfc3b0a2c"
}
}
}
},
{
"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": 2,
"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": 2,
"isAvailable": {
"value": 0.0
}
},
"customPrice-1300": {
"doc_count": 0,
"customPrice-1300": {
"value": 0
}
},
"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": 2,
"customPrice-3-100": {
"value": 2
}
},
"price": {
"count": 2,
"min": 43.35,
"max": 52.45,
"avg": 47.900000000000006,
"sum": 95.80000000000001
},
"options": {
"doc_count": 2,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "06fb0aa8440c4099a59b59bff673b106",
"doc_count": 1
},
{
"key": "391b5e2afc4d42f79523289d2f317a33",
"doc_count": 1
}
]
}
},
"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": 82,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "09bbfea2510d4e85ae59cd5a38699f35",
"doc_count": 2
},
{
"key": "137dc4c666f64dd5a0c05f4ef1426cff",
"doc_count": 2
},
{
"key": "198e5f1dd4214b26a7ffd382535f2e6e",
"doc_count": 2
},
{
"key": "2569817a856e4b9e8e32b0da1a364abc",
"doc_count": 2
},
{
"key": "2f9764491ce84b4a91b1d9e8ac56e21b",
"doc_count": 2
},
{
"key": "33b42c80fc9341f595d8cb68f53d1ae6",
"doc_count": 2
},
{
"key": "361d56d2d8cc413990f97ec54b724ce6",
"doc_count": 2
},
{
"key": "364826fe36344ef88a7285753c556962",
"doc_count": 2
},
{
"key": "42f18e0ab19b4bb98d90040305243889",
"doc_count": 2
},
{
"key": "45ae523927c248f38cd00c38a98fb125",
"doc_count": 2
},
{
"key": "49484796389847379fdaa70978afb77f",
"doc_count": 2
},
{
"key": "4acc045baee14956aca4126888799d94",
"doc_count": 2
},
{
"key": "5c39b0e075c54b50aaa1a2aa5eb84ed1",
"doc_count": 2
},
{
"key": "5f18d2b68d8b4629b49b1f31d9def107",
"doc_count": 2
},
{
"key": "67cbca122f8f48f480e46d470145d54a",
"doc_count": 2
},
{
"key": "6ad29fa6f1e6438cb5e0fc6053de7053",
"doc_count": 2
},
{
"key": "71a9da52787e4da1ab3e417a6a3c4e7a",
"doc_count": 2
},
{
"key": "7340f68bb9e645e98f5323516bc1750a",
"doc_count": 2
},
{
"key": "79b376d7c51c4ce1a1c57857d473caed",
"doc_count": 2
},
{
"key": "7a0417fc8ebf4473a7730750ccfaf8c7",
"doc_count": 2
},
{
"key": "7e9237ca26d54596ad7f3d62c5340273",
"doc_count": 2
},
{
"key": "8a71c7427b5048df9a36d2d7cde8153b",
"doc_count": 2
},
{
"key": "90963d9d34f24aefa8e9858a45f15da8",
"doc_count": 2
},
{
"key": "975e09f2553041f28f47602bb60358c1",
"doc_count": 2
},
{
"key": "9b3ed6ccf44947dca76c4bc8c31cb3c5",
"doc_count": 2
},
{
"key": "aac0e1abf52541f3be34bfdb05fb8c52",
"doc_count": 2
},
{
"key": "ade0d98e8d5b4ae68d56050fb399b61a",
"doc_count": 2
},
{
"key": "ba70329b941d482ead4f3e5da5d5b7ad",
"doc_count": 2
},
{
"key": "bdf1b057e67947c5b56b62d86228ba28",
"doc_count": 2
},
{
"key": "bfbfbb910cb44e51957959c74e1c3058",
"doc_count": 2
},
{
"key": "d277d36775cd48b9a0bca5bc096f2a19",
"doc_count": 2
},
{
"key": "d294b6aa0e35462385ee6ae1eef7acc3",
"doc_count": 2
},
{
"key": "da2eae4ba42c469a812d98b46101d5c1",
"doc_count": 2
},
{
"key": "dc5f68007a3144f79fcd5931d6802de4",
"doc_count": 2
},
{
"key": "decb73d1756b48fb9931e7503eb0be66",
"doc_count": 2
},
{
"key": "e0f5f4ce9a8443bdb3c10f23134da8d5",
"doc_count": 2
},
{
"key": "e113237b92144df4bffa8329c13d6230",
"doc_count": 2
},
{
"key": "e67b471d27d946678db5e500468fb394",
"doc_count": 2
},
{
"key": "e825b695e8264d308231d9cacb46a0ff",
"doc_count": 2
},
{
"key": "f5f3855e99a24088a75993ec1171ac14",
"doc_count": 2
},
{
"key": "f986e276465941d1bcd03af526bd82e6",
"doc_count": 2
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "f20e3466c41c4e2fbee6750a8f9914ed",
"doc_count": 2
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|