| 1 |
5.50 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":"ab68b6782b7c4b70a0d789fb6919262c"}}}},{"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": 3,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 11,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw6_stage__product_1742425202",
"_id": "cca099bc2e8243718b172ee58b7f4f9d",
"_score": null,
"_source": {
"id": "cca099bc2e8243718b172ee58b7f4f9d",
"autoIncrement": 48892.0,
"ratingAverage": 4.83333,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 142,
"productNumber": "2100253",
"ean": "686226819505",
"displayGroup": "9ff6bf753c8fe842d9d1d84d5a3bb83b",
"sales": 0,
"stock": 142,
"weight": 0.15,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e8c1a2f622aa4c319cb4b82536ef0dca",
"manufacturerNumber": "81950",
"releaseDate": null,
"createdAt": "2019-04-30T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"97205f7d3c9f4be28e4a3661b52e5f4b",
"f387061892b04d04bdf38c30bb4a9894",
"5cab358463a44af0aa72884825ae503b",
"b5ca2018d1804d08bbed846f04315251",
"e7b99030fe7f4e87a5acea3081ff585f",
"a4848581fcec4627891c4deb855f6fc3",
"eb27df81065f4f6fa3fc825e4a49bdd6",
"009f131b1e6341e29d97811901c473b2",
"034dcf280a994070898587f558590d60",
"12f18dbae78346cdb53202127a055dcd",
"164a294d648345c882e6f1eaf8e40128",
"191cb88879ab45f7836f97a265fd57e9",
"19b76b26ada34a29bba967b9a10943bd",
"213f6ed490954b01958ab87c926853ca",
"26ded2de1f954bfc93e59128fb4edb2a",
"27d2446b113442039de31d7ced278d1a",
"293fe9a74b9d4515be605896dfd7698e",
"2f8594ca109b4400bb35eb0d411a0a53",
"32ced28872f141608ec881d7993c4abd",
"36b43b18059145c490f3cb829502c566",
"4747c14d60ed4db28ab0601f6d215f95",
"4e1eac684a6b4622bc79a5273fd7bbb0",
"5015512de905467a9f5b847bb9892a58",
"60b0989a1d584b17a91abdbff77d4943",
"685cf0aa104740fc8ff09754472d4913",
"6951410ea81942039dbfc5d674192b55",
"7aa559a5c74143cfbf2940c9d9d1da56",
"7de6d65ec2974b2d8d144c0791d08145",
"8dfb6481debf4eae8e58e143d293b513",
"90441e96c2584f70b5d2d0191d6e38b8",
"93b7d88252ad4db6879cc1920bf45e1f",
"a3e594b9da854e31a28673b16df59cc2",
"a43900727b7642d693e0dce19586e577",
"a44b5990cf64411ca34b0186f52ee657",
"a4bb272a9af447f3a1f9ecc461d69cbf",
"a94adb25797442b4bde65548c68d1ad2",
"ab68b6782b7c4b70a0d789fb6919262c",
"b282df6a11ec4780be26d6f34e9c2129",
"b8f70b7f2a2f4ac0bbc33efad76422f9",
"c3440b30c2e940288419e298c395777d",
"c4e923ef038f44cf8af9fead947ca274",
"c6f880e9e2d14daab2ba44d17d5a7754",
"dd423f04067c42059fc90c7bd91c59f6",
"f39ae28f209c4ad183d858bd500fff76",
"f4a89ee8fe7f4f85910456e1e08b4f53",
"fcbe2984ba944fd49a7b243abe259d3a"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "97205f7d3c9f4be28e4a3661b52e5f4b",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "5cab358463a44af0aa72884825ae503b",
"_count": 1
},
{
"id": "b5ca2018d1804d08bbed846f04315251",
"_count": 1
},
{
"id": "e7b99030fe7f4e87a5acea3081ff585f",
"_count": 1
},
{
"id": "a4848581fcec4627891c4deb855f6fc3",
"_count": 1
},
{
"id": "eb27df81065f4f6fa3fc825e4a49bdd6",
"_count": 1
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1
},
{
"id": "034dcf280a994070898587f558590d60",
"_count": 1
},
{
"id": "12f18dbae78346cdb53202127a055dcd",
"_count": 1
},
{
"id": "164a294d648345c882e6f1eaf8e40128",
"_count": 1
},
{
"id": "191cb88879ab45f7836f97a265fd57e9",
"_count": 1
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1
},
{
"id": "213f6ed490954b01958ab87c926853ca",
"_count": 1
},
{
"id": "26ded2de1f954bfc93e59128fb4edb2a",
"_count": 1
},
{
"id": "27d2446b113442039de31d7ced278d1a",
"_count": 1
},
{
"id": "293fe9a74b9d4515be605896dfd7698e",
"_count": 1
},
{
"id": "2f8594ca109b4400bb35eb0d411a0a53",
"_count": 1
},
{
"id": "32ced28872f141608ec881d7993c4abd",
"_count": 1
},
{
"id": "36b43b18059145c490f3cb829502c566",
"_count": 1
},
{
"id": "4747c14d60ed4db28ab0601f6d215f95",
"_count": 1
},
{
"id": "4e1eac684a6b4622bc79a5273fd7bbb0",
"_count": 1
},
{
"id": "5015512de905467a9f5b847bb9892a58",
"_count": 1
},
{
"id": "60b0989a1d584b17a91abdbff77d4943",
"_count": 1
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1
},
{
"id": "6951410ea81942039dbfc5d674192b55",
"_count": 1
},
{
"id": "7aa559a5c74143cfbf2940c9d9d1da56",
"_count": 1
},
{
"id": "7de6d65ec2974b2d8d144c0791d08145",
"_count": 1
},
{
"id": "8dfb6481debf4eae8e58e143d293b513",
"_count": 1
},
{
"id": "90441e96c2584f70b5d2d0191d6e38b8",
"_count": 1
},
{
"id": "93b7d88252ad4db6879cc1920bf45e1f",
"_count": 1
},
{
"id": "a3e594b9da854e31a28673b16df59cc2",
"_count": 1
},
{
"id": "a43900727b7642d693e0dce19586e577",
"_count": 1
},
{
"id": "a44b5990cf64411ca34b0186f52ee657",
"_count": 1
},
{
"id": "a4bb272a9af447f3a1f9ecc461d69cbf",
"_count": 1
},
{
"id": "a94adb25797442b4bde65548c68d1ad2",
"_count": 1
},
{
"id": "ab68b6782b7c4b70a0d789fb6919262c",
"_count": 1
},
{
"id": "b282df6a11ec4780be26d6f34e9c2129",
"_count": 1
},
{
"id": "b8f70b7f2a2f4ac0bbc33efad76422f9",
"_count": 1
},
{
"id": "c3440b30c2e940288419e298c395777d",
"_count": 1
},
{
"id": "c4e923ef038f44cf8af9fead947ca274",
"_count": 1
},
{
"id": "c6f880e9e2d14daab2ba44d17d5a7754",
"_count": 1
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1
},
{
"id": "f39ae28f209c4ad183d858bd500fff76",
"_count": 1
},
{
"id": "f4a89ee8fe7f4f85910456e1e08b4f53",
"_count": 1
},
{
"id": "fcbe2984ba944fd49a7b243abe259d3a",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": null,
"coverId": "8ca8b823ec6446e19ecdd514ba2ccb02",
"childCount": 0,
"categories": [
{
"id": "213f6ed490954b01958ab87c926853ca",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "R8",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R8",
"5494b24b09d445ebace47112836b4458": "R8"
}
},
{
"id": "293fe9a74b9d4515be605896dfd7698e",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "R32",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R32",
"5494b24b09d445ebace47112836b4458": "R32"
}
},
{
"id": "60b0989a1d584b17a91abdbff77d4943",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "R36",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R36",
"5494b24b09d445ebace47112836b4458": "R36"
}
},
{
"id": "7aa559a5c74143cfbf2940c9d9d1da56",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "G60",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "G60",
"5494b24b09d445ebace47112836b4458": "G60"
}
},
{
"id": "8dfb6481debf4eae8e58e143d293b513",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "VR6",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "VR6",
"5494b24b09d445ebace47112836b4458": "VR6"
}
},
{
"id": "ab68b6782b7c4b70a0d789fb6919262c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "G40",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "G40",
"5494b24b09d445ebace47112836b4458": "G40"
}
},
{
"id": "c3440b30c2e940288419e298c395777d",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "V6 24V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "V6 24V",
"5494b24b09d445ebace47112836b4458": "V6 24V"
}
},
{
"id": "32ced28872f141608ec881d7993c4abd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 8V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 8V",
"5494b24b09d445ebace47112836b4458": "2.0L 8V"
}
},
{
"id": "4747c14d60ed4db28ab0601f6d215f95",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8L 8V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8L 8V",
"5494b24b09d445ebace47112836b4458": "1.8L 8V"
}
},
{
"id": "a3e594b9da854e31a28673b16df59cc2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "16V G60",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "16V G60",
"5494b24b09d445ebace47112836b4458": "16V G60"
}
},
{
"id": "009f131b1e6341e29d97811901c473b2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "K1 Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K1 Pleuel",
"5494b24b09d445ebace47112836b4458": "K1 bielle",
"de44571ddc4e4d0095c01af6ee299351": "K1 Con-Rods"
}
},
{
"id": "12f18dbae78346cdb53202127a055dcd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.4L TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.4L TSI",
"5494b24b09d445ebace47112836b4458": "1.4L TSI"
}
},
{
"id": "164a294d648345c882e6f1eaf8e40128",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L 16V",
"5494b24b09d445ebace47112836b4458": "2.0L 16V"
}
},
{
"id": "26ded2de1f954bfc93e59128fb4edb2a",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8T 20V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8T 20V",
"5494b24b09d445ebace47112836b4458": " 1.8T 20V",
"de44571ddc4e4d0095c01af6ee299351": "1.8T 20V"
}
},
{
"id": "27d2446b113442039de31d7ced278d1a",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8T 20V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8T 20V",
"5494b24b09d445ebace47112836b4458": " 1.8T 20V"
}
},
{
"id": "36b43b18059145c490f3cb829502c566",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Polo 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polo 16V",
"5494b24b09d445ebace47112836b4458": "Polo 16V"
}
},
{
"id": "4e1eac684a6b4622bc79a5273fd7bbb0",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8L TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8L TSI",
"5494b24b09d445ebace47112836b4458": "1.8L TSI"
}
},
{
"id": "7de6d65ec2974b2d8d144c0791d08145",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8L 16V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8L 16V",
"5494b24b09d445ebace47112836b4458": "1.8L 16V"
}
},
{
"id": "a44b5990cf64411ca34b0186f52ee657",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Almac\u00e9n",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lager",
"5494b24b09d445ebace47112836b4458": "Camp",
"de44571ddc4e4d0095c01af6ee299351": "Bearings"
}
},
{
"id": "b282df6a11ec4780be26d6f34e9c2129",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8L TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8L TSI",
"5494b24b09d445ebace47112836b4458": "1.8L TSI"
}
},
{
"id": "f39ae28f209c4ad183d858bd500fff76",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8T 20V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8T 20V",
"5494b24b09d445ebace47112836b4458": " 1.8T 20V"
}
},
{
"id": "f4a89ee8fe7f4f85910456e1e08b4f53",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "1.8T 20V",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "1.8T 20V",
"5494b24b09d445ebace47112836b4458": " 1.8T 20V"
}
},
{
"id": "5015512de905467a9f5b847bb9892a58",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.5L TFSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.5L TFSI",
"5494b24b09d445ebace47112836b4458": "2.5L TFSI"
}
},
{
"id": "191cb88879ab45f7836f97a265fd57e9",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Accesorios",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r",
"5494b24b09d445ebace47112836b4458": " Accessoires",
"de44571ddc4e4d0095c01af6ee299351": "Extras"
}
},
{
"id": "6951410ea81942039dbfc5d674192b55",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "5 cilindros",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Zylinder",
"5494b24b09d445ebace47112836b4458": "5 cylindres",
"de44571ddc4e4d0095c01af6ee299351": "5-Cylinder"
}
},
{
"id": "93b7d88252ad4db6879cc1920bf45e1f",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "5 cilindros",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Zylinder",
"5494b24b09d445ebace47112836b4458": "5 cylindres",
"de44571ddc4e4d0095c01af6ee299351": "5-Cylinder"
}
},
{
"id": "a4bb272a9af447f3a1f9ecc461d69cbf",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "5 cilindros",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5-Zylinder",
"5494b24b09d445ebace47112836b4458": "5 cylindres",
"de44571ddc4e4d0095c01af6ee299351": "5-Cylinder"
}
},
{
"id": "c4e923ef038f44cf8af9fead947ca274",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.7T Biturbo",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.7T Biturbo",
"5494b24b09d445ebace47112836b4458": "2.7T Biturbo"
}
},
{
"id": "c6f880e9e2d14daab2ba44d17d5a7754",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Cig\u00fce\u00f1ales",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kurbelwellen",
"5494b24b09d445ebace47112836b4458": "Vilebrequins",
"de44571ddc4e4d0095c01af6ee299351": "Crankshafts"
}
},
{
"id": "034dcf280a994070898587f558590d60",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L TFSI \/ TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI \/ TSI",
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI \/ TSI"
}
},
{
"id": "2f8594ca109b4400bb35eb0d411a0a53",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Biela integrada",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Integrated Pleuel",
"5494b24b09d445ebace47112836b4458": "Int\u00e9gr\u00e9 bielle",
"de44571ddc4e4d0095c01af6ee299351": "Integrated Con-Rods"
}
},
{
"id": "90441e96c2584f70b5d2d0191d6e38b8",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L TFSI \/ TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI \/ TSI",
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI \/ TSI"
}
},
{
"id": "a43900727b7642d693e0dce19586e577",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L TFSI \/ TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI \/ TSI",
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI \/ TSI"
}
},
{
"id": "fcbe2984ba944fd49a7b243abe259d3a",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "2.0L TFSI \/ TSI",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2.0L TFSI \/ TSI",
"5494b24b09d445ebace47112836b4458": " 2.0 TFSI \/ TSI"
}
},
{
"id": "a94adb25797442b4bde65548c68d1ad2",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "\u00ae BAR-TEK Biela",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae Pleuel",
"5494b24b09d445ebace47112836b4458": " BAR-TEK\u00ae bielle",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae Con-Rods"
}
},
{
"id": "b8f70b7f2a2f4ac0bbc33efad76422f9",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Lubricantes y aceites",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schmierstoffe & \u00d6le",
"5494b24b09d445ebace47112836b4458": "Lubrifiants & huiles",
"de44571ddc4e4d0095c01af6ee299351": "Lubricants and Oils"
}
},
{
"id": "19b76b26ada34a29bba967b9a10943bd",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados Mahle",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mahle Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "Mahle pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "Mahle Sport Pistons"
}
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados Wiseco",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wiseco Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "Wiseco pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "Wiseco Sport Pistons"
}
},
{
"id": "dd423f04067c42059fc90c7bd91c59f6",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones JE Pistones forjados",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "JE Pistons Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "JE Pistons pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "JE Pistons"
}
}
],
"manufacturer": {
"id": "e8c1a2f622aa4c319cb4b82536ef0dca",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BAR-TEK\u00ae",
"5494b24b09d445ebace47112836b4458": "BAR-TEK\u00ae",
"de44571ddc4e4d0095c01af6ee299351": "BAR-TEK\u00ae"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"009f131b1e6341e29d97811901c473b2",
"034dcf280a994070898587f558590d60",
"12f18dbae78346cdb53202127a055dcd",
"164a294d648345c882e6f1eaf8e40128",
"191cb88879ab45f7836f97a265fd57e9",
"19b76b26ada34a29bba967b9a10943bd",
"213f6ed490954b01958ab87c926853ca",
"26ded2de1f954bfc93e59128fb4edb2a",
"27d2446b113442039de31d7ced278d1a",
"293fe9a74b9d4515be605896dfd7698e",
"2f8594ca109b4400bb35eb0d411a0a53",
"32ced28872f141608ec881d7993c4abd",
"36b43b18059145c490f3cb829502c566",
"4747c14d60ed4db28ab0601f6d215f95",
"4e1eac684a6b4622bc79a5273fd7bbb0",
"5015512de905467a9f5b847bb9892a58",
"60b0989a1d584b17a91abdbff77d4943",
"685cf0aa104740fc8ff09754472d4913",
"6951410ea81942039dbfc5d674192b55",
"7aa559a5c74143cfbf2940c9d9d1da56",
"7de6d65ec2974b2d8d144c0791d08145",
"8dfb6481debf4eae8e58e143d293b513",
"90441e96c2584f70b5d2d0191d6e38b8",
"93b7d88252ad4db6879cc1920bf45e1f",
"a3e594b9da854e31a28673b16df59cc2",
"a43900727b7642d693e0dce19586e577",
"a44b5990cf64411ca34b0186f52ee657",
"a4bb272a9af447f3a1f9ecc461d69cbf",
"a94adb25797442b4bde65548c68d1ad2",
"ab68b6782b7c4b70a0d789fb6919262c",
"b282df6a11ec4780be26d6f34e9c2129",
"b8f70b7f2a2f4ac0bbc33efad76422f9",
"c3440b30c2e940288419e298c395777d",
"c4e923ef038f44cf8af9fead947ca274",
"c6f880e9e2d14daab2ba44d17d5a7754",
"dd423f04067c42059fc90c7bd91c59f6",
"f39ae28f209c4ad183d858bd500fff76",
"f4a89ee8fe7f4f85910456e1e08b4f53",
"fcbe2984ba944fd49a7b243abe259d3a"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"fts_product_is_bartek": true,
"custom_gpsr_prod_content": "\nAchtung kann zu Hautirritationen f\u00fchren. Kontakt mit Haut und Augen vermeiden. Einatmen von Gas vermeiden.\n\n",
"fts_product_blog_articles": [
"4974be4328324e83a3739d9db6609b30"
],
"migration_Shopware5DB_product_attr14": "2735",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Montage\u00f6l",
"migration_Shopware5DB_product_bullet1": "f\u00fcr Kurbelwelle, Lagerschalen uvm.",
"migration_Shopware5DB_product_bullet2": "Inhalt: 118ml",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_made_in_germany": true,
"migration_Shopware5DB_product_dreisc_seo_url": "permatex-montageoel-nockenwellen-kolben-motor",
"migration_Shopware5DB_product_dreisc_seo_title": "Permatex\u00ae Ultra Slick\u2122 Montage\u00f6l f\u00fcr den Motor",
"migration_Shopware5DB_product_onco_universal_article": true
},
"5494b24b09d445ebace47112836b4458": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"4974be4328324e83a3739d9db6609b30"
],
"migration_Shopware5DB_product_attr14": "2735",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Montage\u00f6l",
"migration_Shopware5DB_product_bullet1": "f\u00fcr Kurbelwelle, Lagerschalen uvm.",
"migration_Shopware5DB_product_bullet2": "Inhalt: 118ml",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Permatex\u00ae Ultra Slick\u2122 Montage\u00f6l f\u00fcr den Motor",
"migration_Shopware5DB_product_onco_universal_article": true
},
"de44571ddc4e4d0095c01af6ee299351": {
"fts_product_is_bartek": true,
"fts_product_blog_articles": [
"4974be4328324e83a3739d9db6609b30"
],
"migration_Shopware5DB_product_attr14": "2735",
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Assembly oil",
"migration_Shopware5DB_product_bullet1": "for crankshaft, bearing shells etc.",
"migration_Shopware5DB_product_bullet2": "Content: 118ml",
"migration_Shopware5DB_product_socialfeed": true,
"migration_Shopware5DB_product_dreisc_seo_url": "permatex-assambly-oil",
"migration_Shopware5DB_product_dreisc_seo_title": "Permatex\u00ae Ultra Slick\u2122 Assembly oil for the engine",
"migration_Shopware5DB_product_onco_universal_article": true
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Permatex\u00ae Ultra Slick\u2122 Montage\u00f6l f\u00fcr den Motor",
"5494b24b09d445ebace47112836b4458": "Permatex\u00ae Ultra Slick\u2122 Huile de montage pour le moteur",
"de44571ddc4e4d0095c01af6ee299351": "Permatex\u00ae Ultra Slick\u2122 Assembly oil for the engine"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezielles Montage\u00f6l f\u00fcr alle Motoren. Das \u00d6l bietet extremen Schutz f\u00fcr stark belastete Teile w\u00e4hrend dem ersten Motorstart. \nUltra Slick\u2122 haftet auf den Oberfl\u00e4chen der Komponenten, um Abrieb beim ersten Start zu vermeiden. Diese hochwertige \u00d6l erf\u00fcllt und \u00fcbertrifft die OEM-Leistungsspezifikationen f\u00fcr Schmiermittel f\u00fcr Motormontagen.\nVerwendbar f\u00fcr:\n\nKurbelwelle\nLagerschalen\nLagergasse Nockenwelle\nKolbenringe\nKolbenbolzen\n\nInhalt: 118ml\nMit dem Montagefett beugt man einem kapitalen Motorschaden vor. Perfekte Schmierung f\u00fcr den ersten Motor Start.",
"5494b24b09d445ebace47112836b4458": "Huile de montage sp\u00e9ciale pour tous les moteurs. L'huile offre une protection extr\u00eame pour les pi\u00e8ces fortement charg\u00e9es lors du premier d\u00e9marrage du moteur. \nUltra Slick\u2122 adh\u00e8re aux surfaces des composants pour \u00e9viter l'abrasion lors du premier d\u00e9marrage. Cette huile de haute qualit\u00e9 satisfait et d\u00e9passe les sp\u00e9cifications de performance des OEM pour les lubrifiants d'assemblage de moteurs.\nConvient pour :\n\nVilebrequin\nCoquilles de roulements\nCouloir de roulement Arbre \u00e0 cames\nSegments de piston\nAxe de piston\n\nContenu : 118ml\nAvec la graisse de montage, vous \u00e9vitez d'endommager le moteur. Une lubrification parfaite pour le premier d\u00e9marrage du moteur.",
"de44571ddc4e4d0095c01af6ee299351": "Special assembly oil for all engines. The oil offers extreme protection for heavily loaded parts during the first engine start. \nUltra Slick\u2122 adheres to the surfaces of the components to avoid abrasion during the first start. This high-quality oil meets and exceeds OEM performance specifications for engine assembly lubricants.\nSuitable for:\n\nCrankshaft\nBearing shells\nBearing lane Camshaft\nPiston rings\nPiston pin\n\nContent: 118ml\nWith the assembly grease you prevent a capital engine damage. Perfect lubrication for the first engine start."
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Montage\u00f6l f\u00fcr den Motor",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Permatex\u00ae Ultra Slick\u2122 Assembly oil for the engine"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spezielles Montage\u00f6l f\u00fcr alle Motoren. \u2714 25 Jahre Motorsport-Erfahrung \u2714 schneller Versand \u2714 BAR-TEK\u00ae proved \u2794 jetzt kaufen",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Special assembly oil for all engines. \u2714 15 years of motorsport experience \u2714 fast shipping \u2714 BAR-TEK\u00ae proved \u2794 buy now"
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.328,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.2,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 13.6,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 11.428571428571,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.5,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.504201,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 20.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 17.605042,
"shop-customer": "17.605042",
"b-dealer": "11.2",
"c-dealer": "11.428571428571",
"a-dealer": "10.504201"
},
"fields": {
"displayGroup": [
"9ff6bf753c8fe842d9d1d84d5a3bb83b"
]
},
"sort": [
"true",
0,
"cca099bc2e8243718b172ee58b7f4f9d"
]
},
{
"_index": "sw6_stage__product_1742425202",
"_id": "40c191ef86524034912ca473520d1b22",
"_score": null,
"_source": {
"id": "40c191ef86524034912ca473520d1b22",
"autoIncrement": 62539.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "bc03b12fca6e446c9bbe735ae1f4d0ce"
}
],
"availableStock": 0,
"productNumber": "2140057.8",
"ean": null,
"displayGroup": "bcb2f7f04a89a47351aa80cfa345389a",
"sales": 0,
"stock": 0,
"weight": 2.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "73b7e885f67d4e63844ce268112d265f",
"manufacturerNumber": "WKE195M765",
"releaseDate": null,
"createdAt": "2017-01-01T00:00:00+00:00",
"categoryTree": [
"cb95cee79e0a46e996dedabeb3ddafea",
"8cdc2eabbd08462badf21298702c943a",
"87c86b255c784be7b2eebacd4ca87422",
"f387061892b04d04bdf38c30bb4a9894",
"5cab358463a44af0aa72884825ae503b",
"685cf0aa104740fc8ff09754472d4913",
"ab68b6782b7c4b70a0d789fb6919262c"
],
"categoriesRo": [
{
"id": "cb95cee79e0a46e996dedabeb3ddafea",
"_count": 1
},
{
"id": "8cdc2eabbd08462badf21298702c943a",
"_count": 1
},
{
"id": "87c86b255c784be7b2eebacd4ca87422",
"_count": 1
},
{
"id": "f387061892b04d04bdf38c30bb4a9894",
"_count": 1
},
{
"id": "5cab358463a44af0aa72884825ae503b",
"_count": 1
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1
},
{
"id": "ab68b6782b7c4b70a0d789fb6919262c",
"_count": 1
}
],
"taxId": "af6eefd59599421ea0dff74093c31ebd",
"tags": [],
"parentId": "866cd82d940e4d66bfd5c26939677009",
"coverId": "d3b96c85accb4593a431ef94e91d2de6",
"childCount": 0,
"categories": [
{
"id": "ab68b6782b7c4b70a0d789fb6919262c",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "G40",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "G40",
"5494b24b09d445ebace47112836b4458": "G40"
}
},
{
"id": "685cf0aa104740fc8ff09754472d4913",
"_count": 1,
"name": {
"2f37bfd0f23f482bad9d34a02199499b": "Pistones forjados Wiseco",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wiseco Schmiedekolben",
"5494b24b09d445ebace47112836b4458": "Wiseco pistons forg\u00e9s",
"de44571ddc4e4d0095c01af6ee299351": "Wiseco Sport Pistons"
}
}
],
"manufacturer": {
"id": "73b7e885f67d4e63844ce268112d265f",
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "WISECO"
},
"_count": 1
},
"properties": [],
"options": [
{
"id": "10edb52d63c8491b911d4278bf87678d",
"_count": 1,
"groupId": "b10fe7537cdc43c79c70604a9ccae0b2",
"group": {
"id": "b10fe7537cdc43c79c70604a9ccae0b2",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "76,50 mm \/ 12,5:1",
"5494b24b09d445ebace47112836b4458": "76,50 mm \/ 12,5:1",
"de44571ddc4e4d0095c01af6ee299351": "76,50 mm \/ 12,5:1"
}
}
],
"categoryIds": [
"685cf0aa104740fc8ff09754472d4913",
"ab68b6782b7c4b70a0d789fb6919262c"
],
"optionIds": [
"10edb52d63c8491b911d4278bf87678d"
],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"migration_Shopware5DB_product_attr15": false,
"migration_Shopware5DB_product_attr16": "0",
"migration_Shopware5DB_product_attr17": false,
"migration_Shopware5DB_product_attr19": false,
"migration_Shopware5DB_product_bullet0": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "extrem Leicht",
"migration_Shopware5DB_product_bullet3": "verst\u00e4rkt",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": "polo-g40-schmiedekolben-pistons",
"migration_Shopware5DB_product_dreisc_seo_title": "Polo & G40 Schmiedekolben-Satz WISECO",
"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_attr19": false,
"migration_Shopware5DB_product_bullet0": "Hochleistungskolben",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "extrem Leicht",
"migration_Shopware5DB_product_bullet3": "verst\u00e4rkt",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_title": "Polo & G40 Schmiedekolben-Satz WISECO",
"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_attr19": false,
"migration_Shopware5DB_product_bullet0": "High performance piston",
"migration_Shopware5DB_product_bullet1": "High Boost",
"migration_Shopware5DB_product_bullet2": "Extremely light",
"migration_Shopware5DB_product_bullet3": "amplified",
"migration_Shopware5DB_product_socialfeed": true,
"fts_product_is_quick_link_authorized_dealer": true,
"migration_Shopware5DB_product_dreisc_seo_url": " ",
"migration_Shopware5DB_product_dreisc_seo_title": "Polo & G40 Schmiedekolben-Satz WISECO",
"migration_Shopware5DB_product_onco_universal_article": false
}
},
"name": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polo & G40 Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": "Jeu de pistons forg\u00e9s Polo & G40 WISECO",
"de44571ddc4e4d0095c01af6ee299351": "Polo & G40 High Performance Pistons-Kit WISECO"
},
"description": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Geschmiedete Hochleistungskolben f\u00fcr alle Polo 86c und G40 Motoren von WISECO.\nFeatures:\n\nBesonders Stabil auch f\u00fcr Turbo Umbau geeignet\nVerdichtung 8:1 f\u00fcr G40 oder G40 Turbo Motoren\nVerdichtung 12.5:1 f\u00fcr Polo Saugmotoren\n20mm Kolbenbolzen (wie Serie)\nExtrem leichte Bauform\nKolbenhemd beschichtet f\u00fcr weniger Reibung\nAuch f\u00fcr Serienbohrung 75mm lieferbar\n\nAlle Kolbens\u00e4tze werden mit hochfesten Kolbenbolzen und kompletten Rings\u00e4tzen geliefert. Einbau und Bohrma\u00dfe liegen bei. (Abbildung zeigt G60 Kolben)",
"5494b24b09d445ebace47112836b4458": "Pistons forg\u00e9s haute performance pour tous les moteurs Polo 86c et G40 de WISECO.\nCaract\u00e9ristiques :\n\nParticuli\u00e8rement stable, convient \u00e9galement pour la conversion en turbo\nCompression 8:1 pour les moteurs G40 ou G40 Turbo\nCompression 12,5:1 pour les moteurs \u00e0 aspiration naturelle de la Polo\nGoujon de 20 mm (en standard)\nConstruction extr\u00eamement l\u00e9g\u00e8re\nJupe de piston rev\u00eatue pour r\u00e9duire les frottements\nEgalement disponible pour les s\u00e9ries de 75mm\n\nTous les ensembles de pistons sont fournis avec des axes de piston \u00e0 haute r\u00e9sistance et des jeux de segments complets. Les dimensions de l'installation et du forage sont indiqu\u00e9es dans le pr\u00e9sent document. (La photo montre des pistons G60)",
"de44571ddc4e4d0095c01af6ee299351": "High Performance Pistons kit for G-40.\r\nFeatures:\r\n\r\noriginal Wiseco\r\nmuch lighter\r\nreinforced\r\ncompression 8:1 for G40 or G40 Turbo engines\r\ncompression 12.5:1 for Polo NA engines\r\ncomplete kit with rings and pins\r\nalso for OEM bore size available 75,00mm\r\n20mm piston pin diameter\r\nskirt coated for less friction\r\n"
},
"metaTitle": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Polo & G40 Schmiedekolben-Satz WISECO",
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": "Polo G40 High Performance Pistons-Kit WISECO"
},
"metaDescription": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"customSearchKeywords": {
"2f37bfd0f23f482bad9d34a02199499b": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null,
"5494b24b09d445ebace47112836b4458": null,
"de44571ddc4e4d0095c01af6ee299351": null
},
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 642.77,
"cheapest_price_ruleb4daa7b35f5b45149574165a87cbef85_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 540.14285714286,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 599.92,
"cheapest_price_rule09dae9e1f8354e12aecb7b42b8c8c3e2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 504.13333333333,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 562.42,
"cheapest_price_rule66adae9d7d154013bfc77ea83afd2d80_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 472.625,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 899.88,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 756.20168067227,
"shop-customer": "756.20168067227",
"c-dealer": "540.14285714286",
"b-dealer": "504.13333333333",
"a-dealer": "472.625"
},
"fields": {
"displayGroup": [
"bcb2f7f04a89a47351aa80cfa345389a"
]
},
"sort": [
"",
0,
"40c191ef86524034912ca473520d1b22"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.09 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":"ab68b6782b7c4b70a0d789fb6919262c"}}}},{"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": "ab68b6782b7c4b70a0d789fb6919262c"
}
}
}
},
{
"bool": {
"must_not": [
{
"bool": {
"must_not": [
{
"exists": {
"field": "displayGroup"
}
}
]
}
}
]
}
}
]
}
}
]
}
},
"aggregations": {
"manufacturer": {
"terms": {
"field": "manufacturerId",
"size": 10000
}
},
"price": {
"stats": {
"script": {
"id": "cheapest_price",
"params": {
"accessors": [
{
"key": "cheapest_price_rule1cc29aa9f88949329e6cd664b787d516_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6598b1e356e544aca14190369f541afd_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6fc5504f876847f3a0141e22e4c26a50_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule85d57b12075f46a2900284013873d2a8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec0412fc3a3f143b28d448bb7159c0093_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulecdb735e7d3134436b8e4903f940fb0c8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledc8abfeae1214f8293d61d6093798ceb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule243c52152d234b3687fd0a44399fd191_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulea8f2508d908f42a9b77c36c70e404fc6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb19ca2e7e7b148ce93fa5339fcd72c06_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule38535ec8e284419db79495611c950227_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule5548eedc74e1440baaa75c289eabeec6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rule6ee4f48f76b049f7bcf4052b54b75610_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruleb2215ffece654a23b0020cb503c2f316_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_rulec87cc889ffa744f4ab9e76d88c720fc3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
},
{
"key": "cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross",
"factor": 1
}
],
"decimals": 100,
"round": true,
"multiplier": 100.0
}
}
}
},
"properties": {
"nested": {
"path": "properties"
},
"aggregations": {
"properties": {
"terms": {
"field": "properties.id",
"size": 10000
}
}
}
},
"options": {
"nested": {
"path": "options"
},
"aggregations": {
"options": {
"terms": {
"field": "options.id",
"size": 10000
}
}
}
},
"isAvailable-filter": {
"filter": {
"term": {
"active": true
}
},
"aggregations": {
"isAvailable": {
"max": {
"field": "stock"
}
}
}
},
"customPrice-3-100": {
"filter": {
"range": {
"shop-customer": {
"gte": 2.5210084033613445,
"lte": 84.03361344537815
}
}
},
"aggregations": {
"customPrice-3-100": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-100-300": {
"filter": {
"range": {
"shop-customer": {
"gte": 84.03361344537815,
"lte": 252.10084033613447
}
}
},
"aggregations": {
"customPrice-100-300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-300-500": {
"filter": {
"range": {
"shop-customer": {
"gte": 252.10084033613447,
"lte": 420.1680672268908
}
}
},
"aggregations": {
"customPrice-300-500": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-500-700": {
"filter": {
"range": {
"shop-customer": {
"gte": 420.1680672268908,
"lte": 588.2352941176471
}
}
},
"aggregations": {
"customPrice-500-700": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-700-900": {
"filter": {
"range": {
"shop-customer": {
"gte": 588.2352941176471,
"lte": 756.3025210084033
}
}
},
"aggregations": {
"customPrice-700-900": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-900-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 756.3025210084033,
"lte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-900-1300": {
"value_count": {
"field": "id"
}
}
}
},
"customPrice-1300": {
"filter": {
"range": {
"shop-customer": {
"gte": 1092.4369747899161
}
}
},
"aggregations": {
"customPrice-1300": {
"value_count": {
"field": "id"
}
}
}
},
"isUniversal-filter": {
"filter": {
"multi_match": {
"query": true,
"fields": [
"customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article",
"customFields.de44571ddc4e4d0095c01af6ee299351.migration_Shopware5DB_product_onco_universal_article",
"customFields.2fbb5fe2e29a4d70aa5854ce7ce3e20b.migration_Shopware5DB_product_onco_universal_article"
],
"type": "best_fields"
}
},
"aggregations": {
"isUniversal": {
"max": {
"field": "customFields.5494b24b09d445ebace47112836b4458.migration_Shopware5DB_product_onco_universal_article"
}
}
}
}
},
"size": 0,
"timeout": "5s"
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|