| 1 |
5.94 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"cf8a3f59abe95022116f5a666c8367ff"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"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":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 3,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "fba96c3477dc4835dcd5b789aed8a9be",
"_score": null,
"_source": {
"id": "fba96c3477dc4835dcd5b789aed8a9be",
"autoIncrement": 81019.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": true,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 2,
"productNumber": "101307",
"ean": "8713568440868",
"displayGroup": "8742dd31cd56d18bf0d182a00007cd60",
"sales": 0,
"stock": 2,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "cf8a3f59abe95022116f5a666c8367ff",
"manufacturerNumber": "HWWX-4788",
"releaseDate": null,
"createdAt": "2023-10-16T11:10:41+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"fc490ca45c00b1249bbe3554a4fdf6fb",
"310dcbbf4cce62f762a2aaa148d556bd"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "fc490ca45c00b1249bbe3554a4fdf6fb",
"_count": 1
},
{
"id": "310dcbbf4cce62f762a2aaa148d556bd",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "e45490e6b96a4eb8131b130767471ea4",
"childCount": 0,
"categories": [
{
"id": "310dcbbf4cce62f762a2aaa148d556bd",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Lastenrad"
}
},
{
"id": "fc490ca45c00b1249bbe3554a4fdf6fb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bikes"
}
}
],
"manufacturer": {
"id": "cf8a3f59abe95022116f5a666c8367ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Babboe"
},
"_count": 1
},
"properties": [
{
"id": "01fd735cd49214d47bc95566e57502f1",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schwalbe Big Apple"
}
},
{
"id": "04446b6adccabfa4be2fa8247b14102a",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl"
}
},
{
"id": "0622c5290bcc24edde88c19018975298",
"_count": 1,
"groupId": "ecc93cb4118559ffc538281ac056e6b0",
"group": {
"id": "ecc93cb4118559ffc538281ac056e6b0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "integriert"
}
},
{
"id": "13ccda05aeff8101d5ebeae2791fddf5",
"_count": 1,
"groupId": "32c2fa2e414fa02a4132be02a1cb4c1d",
"group": {
"id": "32c2fa2e414fa02a4132be02a1cb4c1d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "bis 60 km, abh\u00e4ngig von der Fahrweise, Belastung und dem Gel\u00e4nde"
}
},
{
"id": "1b7f2223e7b987837744b818edeee604",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enviolo"
}
},
{
"id": "1c059b62b1b70d10ca614d7a4e464a69",
"_count": 1,
"groupId": "65ce779069844efcd5809a96bbcc2270",
"group": {
"id": "65ce779069844efcd5809a96bbcc2270",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
},
{
"id": "1e065fc06c44460744999df462f00f13",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Enviolo NuVinci"
}
},
{
"id": "1f1c3bdfa509ce742869fdd369babb5b",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "5"
}
},
{
"id": "21521f6958bace0e499e1b3d1b7fe4c7",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Doppelwandig"
}
},
{
"id": "30aa6069be72decba083cd6e255a7c8d",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ungefedert"
}
},
{
"id": "349d3d5ee350907411de3950bb96ec79",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Axa LED"
}
},
{
"id": "373a8515fa6860b090218271badd299f",
"_count": 1,
"groupId": "3f89663f0ab68bdf364a590c8f133f4b",
"group": {
"id": "3f89663f0ab68bdf364a590c8f133f4b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yamaha PW-ST"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "3bab7586e8cf4bc4fcac869ba13fc6eb",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unisex"
}
},
{
"id": "403207a664ca3b73f3f1abaf19581d43",
"_count": 1,
"groupId": "d9c530b6b501df9943bed7514c2b54d7",
"group": {
"id": "d9c530b6b501df9943bed7514c2b54d7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lithium-ion"
}
},
{
"id": "448e71746245d5891e418a8b53df3d03",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "20\"\/26\""
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "6579ee34534224cd540239aacacbdede",
"_count": 1,
"groupId": "b9987a246a537f4fe86f1f2e3d10dbdb",
"group": {
"id": "b9987a246a537f4fe86f1f2e3d10dbdb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yamaha LED"
}
},
{
"id": "66c94563c3d199fe719a72b4386943fc",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2021"
}
},
{
"id": "762ebe3a6713e35e1b3983733490ae73",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "rutschfest"
}
},
{
"id": "81026c5a10266e94fccc1048c77757b1",
"_count": 1,
"groupId": "a1beca20c312f61bd82db0d0e523cefc",
"group": {
"id": "a1beca20c312f61bd82db0d0e523cefc",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "70 Nm"
}
},
{
"id": "8747cbe47a02f22f0ce9a6f546b1dd04",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfort"
}
},
{
"id": "93bef5d08917545e5d4af43132ccd5f8",
"_count": 1,
"groupId": "b33538179f5661a86cbe327a1793e199",
"group": {
"id": "b33538179f5661a86cbe327a1793e199",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yamaha PW-ST"
}
},
{
"id": "a23dc8440e832ad3f036c044f43f10ef",
"_count": 1,
"groupId": "f0e28a841328150bad18692f92a69fb3",
"group": {
"id": "f0e28a841328150bad18692f92a69fb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "ab8066d653431b38c504d7be827f7750",
"_count": 1,
"groupId": "711c14702e48a5a53a7dd8802bfd1667",
"group": {
"id": "711c14702e48a5a53a7dd8802bfd1667",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "extra robust"
}
},
{
"id": "b368b4fe2b404a1e91acdfcfc235dc3f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "schwarz"
}
},
{
"id": "bbc4046e81a414f1d3ff77c650c24491",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spanninga LED"
}
},
{
"id": "c03a1c923ab5d26522d999068b43df73",
"_count": 1,
"groupId": "c4b89253123017ee3fbb833485a18a6c",
"group": {
"id": "c4b89253123017ee3fbb833485a18a6c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500 Wh"
}
},
{
"id": "c2015370a4c0b41a6d24cc41ae222f22",
"_count": 1,
"groupId": "c247725dc3c6da0c83ca6910169595d0",
"group": {
"id": "c247725dc3c6da0c83ca6910169595d0",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 6 Std."
}
},
{
"id": "c28e0fa4ab41a3b101ea3782a17db5e9",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comfort"
}
},
{
"id": "cd5c6f78a22052257f5b4bfb0217c536",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "verstellbar"
}
},
{
"id": "e330a259b38a4839bae4f1295c5a8a98",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50 cm"
}
},
{
"id": "e521bcc50e50e34f6753c0af57d004f3",
"_count": 1,
"groupId": "6afa18974577c7533cbea98c14c8a294",
"group": {
"id": "6afa18974577c7533cbea98c14c8a294",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Cargo"
}
},
{
"id": "ea2497359de8c858fe47648456a81d1d",
"_count": 1,
"groupId": "e3b5b81abbd12ca8f2f34d6740e8e31e",
"group": {
"id": "e3b5b81abbd12ca8f2f34d6740e8e31e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "500 Wh"
}
},
{
"id": "ebe2946d388e152e4e37f0829ff81e54",
"_count": 1,
"groupId": "e445d5074a7f9c03ce70dcd85141cdb4",
"group": {
"id": "e445d5074a7f9c03ce70dcd85141cdb4",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "bis 25 km\/h"
}
},
{
"id": "f093e5e65f388f4377ac5c734a162d69",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zweibeinst\u00e4nder, Rahmenschloss Trelock, Belastung Box 80 kg, inkl. Sitzpolster, Abdeckplane"
}
},
{
"id": "fd55a5a0843b99e6164c11734c6cd5a0",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
}
},
{
"id": "fdc6a18e3cf8aa36c553c7d8aba30e32",
"_count": 1,
"groupId": "57d10a42e9e995a36d6bdafd88387f18",
"group": {
"id": "57d10a42e9e995a36d6bdafd88387f18",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Yamaha"
}
},
{
"id": "fe66573ec1752226a7c639adbb97cdd2",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "stufenlos"
}
},
{
"id": "feacb384a797917192e078310178f4a0",
"_count": 1,
"groupId": "7524dd23d046d6b6828caeb359c3bdec",
"group": {
"id": "7524dd23d046d6b6828caeb359c3bdec",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "36 V"
}
}
],
"options": [
{
"id": "e330a259b38a4839bae4f1295c5a8a98",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50 cm"
}
}
],
"categoryIds": [
"310dcbbf4cce62f762a2aaa148d556bd",
"fc490ca45c00b1249bbe3554a4fdf6fb"
],
"optionIds": [
"e330a259b38a4839bae4f1295c5a8a98"
],
"propertyIds": [
"01fd735cd49214d47bc95566e57502f1",
"04446b6adccabfa4be2fa8247b14102a",
"0622c5290bcc24edde88c19018975298",
"13ccda05aeff8101d5ebeae2791fddf5",
"1b7f2223e7b987837744b818edeee604",
"1c059b62b1b70d10ca614d7a4e464a69",
"1e065fc06c44460744999df462f00f13",
"1f1c3bdfa509ce742869fdd369babb5b",
"21521f6958bace0e499e1b3d1b7fe4c7",
"30aa6069be72decba083cd6e255a7c8d",
"349d3d5ee350907411de3950bb96ec79",
"373a8515fa6860b090218271badd299f",
"3a616a5305e06ccc883bda3ab63b10b5",
"3bab7586e8cf4bc4fcac869ba13fc6eb",
"403207a664ca3b73f3f1abaf19581d43",
"448e71746245d5891e418a8b53df3d03",
"4ec969a032686f09de30ead2a801c018",
"57ea44f19b74405f40baa45fc561493a",
"6579ee34534224cd540239aacacbdede",
"66c94563c3d199fe719a72b4386943fc",
"762ebe3a6713e35e1b3983733490ae73",
"81026c5a10266e94fccc1048c77757b1",
"8747cbe47a02f22f0ce9a6f546b1dd04",
"93bef5d08917545e5d4af43132ccd5f8",
"a23dc8440e832ad3f036c044f43f10ef",
"ab8066d653431b38c504d7be827f7750",
"b368b4fe2b404a1e91acdfcfc235dc3f",
"bbc4046e81a414f1d3ff77c650c24491",
"c03a1c923ab5d26522d999068b43df73",
"c2015370a4c0b41a6d24cc41ae222f22",
"c28e0fa4ab41a3b101ea3782a17db5e9",
"cd5c6f78a22052257f5b4bfb0217c536",
"e330a259b38a4839bae4f1295c5a8a98",
"e521bcc50e50e34f6753c0af57d004f3",
"ea2497359de8c858fe47648456a81d1d",
"ebe2946d388e152e4e37f0829ff81e54",
"f093e5e65f388f4377ac5c734a162d69",
"fd55a5a0843b99e6164c11734c6cd5a0",
"fdc6a18e3cf8aa36c553c7d8aba30e32",
"fe66573ec1752226a7c639adbb97cdd2",
"feacb384a797917192e078310178f4a0"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 0.0,
"product_slider_terrain": 0.0,
"product_slider_ausstattung": 0.0,
"product_slider_e_bike": 0.0,
"product_minderest": 1.0,
"product_zubehora_article": 54.0,
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 101307.0,
"product_vk2_amazon": 4313.75,
"product_vk3_ebay": 4313.75
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Babboe City Mountain 500 Wh schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2999.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 2520.17
},
"fields": {
"displayGroup": [
"8742dd31cd56d18bf0d182a00007cd60"
]
},
"sort": [
"babboe city mountain 500 wh schwarz"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|