| 1 |
3.92 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"6c8349cc7260ae62e3b1396831a8398f"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 1,
"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": "cd8b6d6b65460976f5c5081117feb26b",
"_score": null,
"_source": {
"id": "cd8b6d6b65460976f5c5081117feb26b",
"autoIncrement": 93792.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 3,
"productNumber": "400722",
"ean": "8717231331965",
"displayGroup": "6f896d8028eb379f538ff773a57cdf84",
"sales": 0,
"stock": 3,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9914b4a164534b7cd5a9385ea36bb0f9",
"manufacturerNumber": "A7732",
"releaseDate": null,
"createdAt": "2026-03-16T11:46:58+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"33e75ff09dd601bbe69f351039152189",
"f7177163c833dff4b38fc8d2872f1ec6",
"6c8349cc7260ae62e3b1396831a8398f"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "f7177163c833dff4b38fc8d2872f1ec6",
"_count": 1
},
{
"id": "6c8349cc7260ae62e3b1396831a8398f",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "ae3b3361ddec55bf3cab7989bea23d5e",
"coverId": "019cf9b3091f71428f54049a238afdc5",
"childCount": 0,
"categories": [
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "6c8349cc7260ae62e3b1396831a8398f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hollandrad Herren"
}
},
{
"id": "f7177163c833dff4b38fc8d2872f1ec6",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hollandrad"
}
}
],
"manufacturer": {
"id": "9914b4a164534b7cd5a9385ea36bb0f9",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gazelle"
},
"_count": 1
},
"properties": [
{
"id": "04446b6adccabfa4be2fa8247b14102a",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl"
}
},
{
"id": "0b8fa09c9f26414cac547abeb259bc84",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 22,9 kg"
}
},
{
"id": "0ca5744086b86cdb942240d7d15c6ff1",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "57 cm"
}
},
{
"id": "0cad7bdf1aba0519a323be97b77d98a7",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tourenmodell fest, verbreitert"
}
},
{
"id": "13dee3cd4a3e72bbd8a5148cb0edef52",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl poliert"
}
},
{
"id": "154abb2dde1da54b5b1fda53ebf3d17b",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Brooks B67 Leder"
}
},
{
"id": "1600b1940f326e760597b2fbe4d7f384",
"_count": 1,
"groupId": "7eb4ca27b65686333ee285cbf14f1768",
"group": {
"id": "7eb4ca27b65686333ee285cbf14f1768",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Nexus, 7, R\u00fccktrittbremse"
}
},
{
"id": "21c5be7df10f2e4c7e67920825f1ba78",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Nexus 7"
}
},
{
"id": "243698605b47162153220cbef4720768",
"_count": 1,
"groupId": "90f571e210d39186ad49b461324b8e4c",
"group": {
"id": "90f571e210d39186ad49b461324b8e4c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gazelle Aero Leather, luxuri\u00f6se Ledergriffe f\u00fcr angenehmes Gef\u00fchl und zus\u00e4tzlicher Komfort"
}
},
{
"id": "2ddd418f305dd2d8cb31b42777004deb",
"_count": 1,
"groupId": "711c14702e48a5a53a7dd8802bfd1667",
"group": {
"id": "711c14702e48a5a53a7dd8802bfd1667",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl, extra stark"
}
},
{
"id": "353c3a65a7300036e66ca2af710dcba4",
"_count": 1,
"groupId": "92f0eab8e780264bb5666a3c122c0349",
"group": {
"id": "92f0eab8e780264bb5666a3c122c0349",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "black gl\u00e4nzend"
}
},
{
"id": "4daf1780476294db6cade928a3e44aa5",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "starr, 25,4 mm"
}
},
{
"id": "535a6e7fb7113a5d1f22a02978c64d7e",
"_count": 1,
"groupId": "e538d0269e6680acb6225575c4ca5b60",
"group": {
"id": "e538d0269e6680acb6225575c4ca5b60",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXA Defender"
}
},
{
"id": "535e5865755412973e014463e3090380",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "CST Classic Tradition, 40-635"
}
},
{
"id": "54d199e8640f97cf0ce8c7cd129ec513",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GAZELLE Nr 9"
}
},
{
"id": "5725225d8d211568332388ef2f46b9b9",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "7"
}
},
{
"id": "58ed07e95f7d931eddea2b46c3bddcc9",
"_count": 1,
"groupId": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"group": {
"id": "67257a0b244c56fc1f85cbf6ae0eb5f7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "130 kg"
}
},
{
"id": "60511fc47b6fd3f40ea2618e7329030c",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl, ungefedert"
}
},
{
"id": "60cfc53898323e18a63ded62e9102c11",
"_count": 1,
"groupId": "cf3fbe199317cb59105ece4c22b93a6f",
"group": {
"id": "cf3fbe199317cb59105ece4c22b93a6f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Massload GA-KA63"
}
},
{
"id": "6d8d4cffaa6d5c0527b6a6cc713b9334",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GAZELLE Niro, nicht verstellbar"
}
},
{
"id": "70200a4e94fea991b530e6d7bcefc326",
"_count": 1,
"groupId": "a8c218e8daf51c2528ffec6ba60c0c07",
"group": {
"id": "a8c218e8daf51c2528ffec6ba60c0c07",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gazelle Ergo"
}
},
{
"id": "7052790f352e0b66c5f5ceea1429da94",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "7c5810fa9eb432a1a1eae36e311adc32",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
},
{
"id": "7e3e096ed53003332cb4f17ec02e1ca4",
"_count": 1,
"groupId": "b04bfe8ba585adb14de7523ff4a2f14e",
"group": {
"id": "b04bfe8ba585adb14de7523ff4a2f14e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Nabendynamo (3W)"
}
},
{
"id": "9acc664466a84ba14ebd9f39e8f4698e",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "9d9dd4ed6d2c6a1c00069a994ecd1311",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "a2b92ba84cea70c8695ed0fe6e857871",
"_count": 1,
"groupId": "cee5323b4f8c6b149f75aa2b1aadd1ba",
"group": {
"id": "cee5323b4f8c6b149f75aa2b1aadd1ba",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO BR-C3000F"
}
},
{
"id": "a6213cb4203e7d5c456ca59a2d29592c",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Edelstahl"
}
},
{
"id": "afd92f7f5d2ddf7092737ba2d4077739",
"_count": 1,
"groupId": "a6422bb08b1146d1c55779ac81586ab3",
"group": {
"id": "a6422bb08b1146d1c55779ac81586ab3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Stahl"
}
},
{
"id": "b2a6d2c74be3c9782cc83fb61fcba0fe",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nabenschaltung"
}
},
{
"id": "b368b4fe2b404a1e91acdfcfc235dc3f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "schwarz"
}
},
{
"id": "bdbf6e6a6af2a27b98a4445877a1edab",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rollenbremse"
}
},
{
"id": "c03a01c3a1bb726efcfa077db5dc4e24",
"_count": 1,
"groupId": "205d463d996b4cee01479ac2f05ec614",
"group": {
"id": "205d463d996b4cee01479ac2f05ec614",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "c8bb250ce4ae8f1cb3003218719fbfd5",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
}
},
{
"id": "e16c0db1553ed454f056479460f8f9fb",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Busch & M\u00fcller LYT Lumotec Retro 25"
}
},
{
"id": "e2e1320c677c779ab410288bc5c75147",
"_count": 1,
"groupId": "6afa18974577c7533cbea98c14c8a294",
"group": {
"id": "6afa18974577c7533cbea98c14c8a294",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Holland"
}
},
{
"id": "e7bcfe30f9e24468e1069470c966fdf5",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nexus, 7 G\u00e4nge"
}
},
{
"id": "fbe1ddde1b262e35d6cebc25d5e2aeb6",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2026"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
}
],
"options": [
{
"id": "0ca5744086b86cdb942240d7d15c6ff1",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "57 cm"
}
}
],
"categoryIds": [
"33e75ff09dd601bbe69f351039152189",
"6c8349cc7260ae62e3b1396831a8398f",
"f7177163c833dff4b38fc8d2872f1ec6"
],
"optionIds": [
"0ca5744086b86cdb942240d7d15c6ff1"
],
"propertyIds": [
"04446b6adccabfa4be2fa8247b14102a",
"0b8fa09c9f26414cac547abeb259bc84",
"0ca5744086b86cdb942240d7d15c6ff1",
"0cad7bdf1aba0519a323be97b77d98a7",
"13dee3cd4a3e72bbd8a5148cb0edef52",
"154abb2dde1da54b5b1fda53ebf3d17b",
"1600b1940f326e760597b2fbe4d7f384",
"21c5be7df10f2e4c7e67920825f1ba78",
"243698605b47162153220cbef4720768",
"2ddd418f305dd2d8cb31b42777004deb",
"353c3a65a7300036e66ca2af710dcba4",
"4daf1780476294db6cade928a3e44aa5",
"535a6e7fb7113a5d1f22a02978c64d7e",
"535e5865755412973e014463e3090380",
"54d199e8640f97cf0ce8c7cd129ec513",
"5725225d8d211568332388ef2f46b9b9",
"58ed07e95f7d931eddea2b46c3bddcc9",
"60511fc47b6fd3f40ea2618e7329030c",
"60cfc53898323e18a63ded62e9102c11",
"6d8d4cffaa6d5c0527b6a6cc713b9334",
"70200a4e94fea991b530e6d7bcefc326",
"7052790f352e0b66c5f5ceea1429da94",
"7c5810fa9eb432a1a1eae36e311adc32",
"7e3e096ed53003332cb4f17ec02e1ca4",
"9acc664466a84ba14ebd9f39e8f4698e",
"9d9dd4ed6d2c6a1c00069a994ecd1311",
"a2b92ba84cea70c8695ed0fe6e857871",
"a6213cb4203e7d5c456ca59a2d29592c",
"afd92f7f5d2ddf7092737ba2d4077739",
"b2a6d2c74be3c9782cc83fb61fcba0fe",
"b368b4fe2b404a1e91acdfcfc235dc3f",
"bdbf6e6a6af2a27b98a4445877a1edab",
"c03a01c3a1bb726efcfa077db5dc4e24",
"c8bb250ce4ae8f1cb3003218719fbfd5",
"e16c0db1553ed454f056479460f8f9fb",
"e2e1320c677c779ab410288bc5c75147",
"e7bcfe30f9e24468e1069470c966fdf5",
"fbe1ddde1b262e35d6cebc25d5e2aeb6",
"fc7c95e8a0c10edfec779479917546ca"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 4.0,
"product_slider_terrain": 4.0,
"product_slider_ausstattung": 6.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_vk2_amazon": 1199.0,
"product_vk3_ebay": 1199.0,
"accessory_sorting_order": "5479|6790|6943|14193|W1",
"product_parent_article": 400722.1
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gazelle Tour Populair C7 Herren schwarz 2026"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gazelle Tour Populair C7 Klassisches Hollandrad mit 7-Gang-Komfort Das Gazelle Tour Populair C7 ist ein echter Klassiker f\u00fcr alle, die entspannt, stilvoll und zuverl\u00e4ssig unterwegs sein wollen. Der traditionelle Hollandrad-Rahmen mit tiefem Einstieg und aufrechter Sitzposition sorgt f\u00fcr bequemes Fahren und beste \u00dcbersicht im Stadtverkehr ideal f\u00fcr den Weg zur Arbeit, zum Einkaufen oder die gem\u00fctliche Feierabendrunde. Die 7-Gang-Nabenschaltung l\u00e4sst sich leicht und nahezu wartungsfrei bedienen und bietet dir gen\u00fcgend G\u00e4nge f\u00fcr Stadt, leichte Steigungen und Ausfl\u00fcge ins Umland. Zusammen mit den angenehm breiten Reifen und dem bequemen Sattel f\u00e4hrt sich das Tour Populair C7 ruhig, souver\u00e4n und \u00e4u\u00dferst komfortabel genau so, wie man es von einem echten Hollandrad erwartet. Dank kompletter Alltagsausstattung mit Lichtanlage, Schutzblechen und stabilem Gep\u00e4cktr\u00e4ger ist das Rad sofort einsatzbereit ob mit Korb, Packtasche oder Einkauf. Das zeitlose Gazelle-Design mit klassischen Details macht das Tour Populair C7 zudem zum eleganten Blickfang. Highlights auf einen Blick: Klassischer Hollandrad-Rahmen mit tiefem Einstieg Aufrechte, komfortable Sitzposition f\u00fcr beste \u00dcbersicht Wartungsarme 7-Gang-Nabenschaltung ideal f\u00fcr den Stadtalltag Breite Reifen und bequemer Sattel f\u00fcr hohen Fahrkomfort Voll alltagstauglich: Lichtanlage, Schutzbleche, Gep\u00e4cktr\u00e4ger Zeitloses Gazelle-Design mit klassischem Charme Sichere dir jetzt das Gazelle Tour Populair C7 und genie\u00dfe entspanntes, stilvolles Radfahren im Alltag und in der Freizeit!"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1099.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 923.53
},
"fields": {
"displayGroup": [
"6f896d8028eb379f538ff773a57cdf84"
]
},
"sort": [
0,
"cd8b6d6b65460976f5c5081117feb26b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.98 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"6c8349cc7260ae62e3b1396831a8398f"}}}},{"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_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 1,
"rating": {
"value": 0.0
}
},
"price": {
"count": 1,
"min": 1099.0,
"max": 1099.0,
"avg": 1099.0,
"sum": 1099.0
},
"options": {
"doc_count": 1,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0ca5744086b86cdb942240d7d15c6ff1",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 39,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "04446b6adccabfa4be2fa8247b14102a",
"doc_count": 1
},
{
"key": "0b8fa09c9f26414cac547abeb259bc84",
"doc_count": 1
},
{
"key": "0ca5744086b86cdb942240d7d15c6ff1",
"doc_count": 1
},
{
"key": "0cad7bdf1aba0519a323be97b77d98a7",
"doc_count": 1
},
{
"key": "13dee3cd4a3e72bbd8a5148cb0edef52",
"doc_count": 1
},
{
"key": "154abb2dde1da54b5b1fda53ebf3d17b",
"doc_count": 1
},
{
"key": "1600b1940f326e760597b2fbe4d7f384",
"doc_count": 1
},
{
"key": "21c5be7df10f2e4c7e67920825f1ba78",
"doc_count": 1
},
{
"key": "243698605b47162153220cbef4720768",
"doc_count": 1
},
{
"key": "2ddd418f305dd2d8cb31b42777004deb",
"doc_count": 1
},
{
"key": "353c3a65a7300036e66ca2af710dcba4",
"doc_count": 1
},
{
"key": "4daf1780476294db6cade928a3e44aa5",
"doc_count": 1
},
{
"key": "535a6e7fb7113a5d1f22a02978c64d7e",
"doc_count": 1
},
{
"key": "535e5865755412973e014463e3090380",
"doc_count": 1
},
{
"key": "54d199e8640f97cf0ce8c7cd129ec513",
"doc_count": 1
},
{
"key": "5725225d8d211568332388ef2f46b9b9",
"doc_count": 1
},
{
"key": "58ed07e95f7d931eddea2b46c3bddcc9",
"doc_count": 1
},
{
"key": "60511fc47b6fd3f40ea2618e7329030c",
"doc_count": 1
},
{
"key": "60cfc53898323e18a63ded62e9102c11",
"doc_count": 1
},
{
"key": "6d8d4cffaa6d5c0527b6a6cc713b9334",
"doc_count": 1
},
{
"key": "70200a4e94fea991b530e6d7bcefc326",
"doc_count": 1
},
{
"key": "7052790f352e0b66c5f5ceea1429da94",
"doc_count": 1
},
{
"key": "7c5810fa9eb432a1a1eae36e311adc32",
"doc_count": 1
},
{
"key": "7e3e096ed53003332cb4f17ec02e1ca4",
"doc_count": 1
},
{
"key": "9acc664466a84ba14ebd9f39e8f4698e",
"doc_count": 1
},
{
"key": "9d9dd4ed6d2c6a1c00069a994ecd1311",
"doc_count": 1
},
{
"key": "a2b92ba84cea70c8695ed0fe6e857871",
"doc_count": 1
},
{
"key": "a6213cb4203e7d5c456ca59a2d29592c",
"doc_count": 1
},
{
"key": "afd92f7f5d2ddf7092737ba2d4077739",
"doc_count": 1
},
{
"key": "b2a6d2c74be3c9782cc83fb61fcba0fe",
"doc_count": 1
},
{
"key": "b368b4fe2b404a1e91acdfcfc235dc3f",
"doc_count": 1
},
{
"key": "bdbf6e6a6af2a27b98a4445877a1edab",
"doc_count": 1
},
{
"key": "c03a01c3a1bb726efcfa077db5dc4e24",
"doc_count": 1
},
{
"key": "c8bb250ce4ae8f1cb3003218719fbfd5",
"doc_count": 1
},
{
"key": "e16c0db1553ed454f056479460f8f9fb",
"doc_count": 1
},
{
"key": "e2e1320c677c779ab410288bc5c75147",
"doc_count": 1
},
{
"key": "e7bcfe30f9e24468e1069470c966fdf5",
"doc_count": 1
},
{
"key": "fbe1ddde1b262e35d6cebc25d5e2aeb6",
"doc_count": 1
},
{
"key": "fc7c95e8a0c10edfec779479917546ca",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "9914b4a164534b7cd5a9385ea36bb0f9",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|