| 1 |
7.02 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":"07cdfd23373b17c6b337251c22b7ea57"}}}},{"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": 4,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "10e035c3e638ec867d7f668d546abeb9",
"_score": null,
"_source": {
"id": "10e035c3e638ec867d7f668d546abeb9",
"autoIncrement": 79844.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "103953",
"ean": "4063518164820",
"displayGroup": "f4860da2d91614285c8ecf19ce8b402a",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6462331a69cdc7b76dc81136ca2713dd",
"manufacturerNumber": "631-35351",
"releaseDate": null,
"createdAt": "2023-10-16T11:06:03+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"f033ab37c30201f73f142449d037028d",
"d947bf06a885db0d477d707121934ff8",
"63923f49e5241343aa7acb6a06a751e7",
"33e75ff09dd601bbe69f351039152189",
"34173cb38f07f89ddbebc2ac9128303f",
"07cdfd23373b17c6b337251c22b7ea57",
"182be0c5cdcd5072bb1864cdee4d3d6e"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1
},
{
"id": "63923f49e5241343aa7acb6a06a751e7",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "34173cb38f07f89ddbebc2ac9128303f",
"_count": 1
},
{
"id": "07cdfd23373b17c6b337251c22b7ea57",
"_count": 1
},
{
"id": "182be0c5cdcd5072bb1864cdee4d3d6e",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "229e12cf52844e981bceb8d662dd3ec2",
"coverId": "9fccf5e75d51092ee3a248c45d0f02dd",
"childCount": 0,
"categories": [
{
"id": "07cdfd23373b17c6b337251c22b7ea57",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Street MTB Sale"
}
},
{
"id": "182be0c5cdcd5072bb1864cdee4d3d6e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Street MTB"
}
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "34173cb38f07f89ddbebc2ac9128303f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mountainbike"
}
},
{
"id": "63923f49e5241343aa7acb6a06a751e7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mountainbike Sale"
}
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad Sale"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "6462331a69cdc7b76dc81136ca2713dd",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls"
},
"_count": 1
},
"properties": [
{
"id": "06779f443aad686267674335679f12f4",
"_count": 1,
"groupId": "90172b5a229214a431a4352c66865e89",
"group": {
"id": "90172b5a229214a431a4352c66865e89",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT"
}
},
{
"id": "0d5e3902d0bfaeab5929855eae3e211f",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sportive Comfort"
}
},
{
"id": "1752c866d20137c75ade67c2a32475ab",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supero Ranger Anti Puncture, 57-622"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "1ff00dfd47d0ef32794ff97e3c8ffb76",
"_count": 1,
"groupId": "d7cd942099e8fa42173503c86c8880ce",
"group": {
"id": "d7cd942099e8fa42173503c86c8880ce",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA no.11"
}
},
{
"id": "2c56e02a283fa9a33beed5fcd980431e",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschutzring"
}
},
{
"id": "3a045cb5b8fe825027a86977edff8697",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoff"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "3ed47e4ae6da84ec4f255ab95fce260f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "gr\u00fcn"
}
},
{
"id": "47a9649328d3c021fe3a0627b02e5f2d",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus SL-M310"
}
},
{
"id": "49c903179d3ed9d593a98da9f48bd3e1",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX riserbar"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "55875fb6b754e7e078007324a69007f4",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon RL-Mini mit Standlichtfunktion"
}
},
{
"id": "56c1a1b89f4a737f1c7a4b52e5ecc7aa",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "29\""
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "66403ab51f1fd786af6bd60b25d3305f",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hinterbaust\u00e4nder, zul\u00e4ssiges Gesamtgewicht: 125 kg"
}
},
{
"id": "69a5aad12bff0c00a9d18843d1f9a746",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "24"
}
},
{
"id": "6b0c36b19007cb2516ca20b905d347c4",
"_count": 1,
"groupId": "13df042e46bbd8a2eb06116548c29107",
"group": {
"id": "13df042e46bbd8a2eb06116548c29107",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Tourney FD-TY500"
}
},
{
"id": "6bc4aff51344fb647415b10faad1782f",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX Aluminium"
}
},
{
"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": "7eb652187ff4b17561fa2893a695749b",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX DBM-2"
}
},
{
"id": "82f05129dcd5ac26ee98f614bb46a904",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hardtail"
}
},
{
"id": "884910c87d546463bb5392afd5449fa8",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon F-30 EB, 25 Lux"
}
},
{
"id": "956ec8918c6d1ef8e2165f839b95bd1d",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX 42\/34\/24T"
}
},
{
"id": "9dc0e7eb91ed410e67730d9fb7b6bd09",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus RD-M310"
}
},
{
"id": "a02f92ccbe2773615526e843bb5a61cb",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "11"
}
},
{
"id": "ac2b2ac4fbf7068207776b887796f5b7",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8"
}
},
{
"id": "acdae9f5f89dabe00a07d5b7b5b7da34",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS"
}
},
{
"id": "b8c379f8b9d499096cdf862bb7974706",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR Suntour NVX 30"
}
},
{
"id": "bba58a030e2f1aeb3b2542e7d31644f6",
"_count": 1,
"groupId": "a9afe3dfd367b52569af60a0af3d19c1",
"group": {
"id": "a9afe3dfd367b52569af60a0af3d19c1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabenydamo DH-3D32 \/ Formula"
}
},
{
"id": "c730505f1cf47e66f3841e7df046cd7a",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 cm"
}
},
{
"id": "d14234136d6d332d9605d06a7a79a122",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2023"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "d9435ac0370717e0d64cb08281b16888",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX"
}
},
{
"id": "e2b33f491d6380be91d19e54c3654fd3",
"_count": 1,
"groupId": "a8c218e8daf51c2528ffec6ba60c0c07",
"group": {
"id": "a8c218e8daf51c2528ffec6ba60c0c07",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tektro HD-M275"
}
},
{
"id": "fd55a5a0843b99e6164c11734c6cd5a0",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
}
}
],
"options": [
{
"id": "c730505f1cf47e66f3841e7df046cd7a",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 cm"
}
}
],
"categoryIds": [
"07cdfd23373b17c6b337251c22b7ea57",
"182be0c5cdcd5072bb1864cdee4d3d6e",
"33e75ff09dd601bbe69f351039152189",
"34173cb38f07f89ddbebc2ac9128303f",
"63923f49e5241343aa7acb6a06a751e7",
"d947bf06a885db0d477d707121934ff8",
"f033ab37c30201f73f142449d037028d"
],
"optionIds": [
"c730505f1cf47e66f3841e7df046cd7a"
],
"propertyIds": [
"06779f443aad686267674335679f12f4",
"0d5e3902d0bfaeab5929855eae3e211f",
"1752c866d20137c75ade67c2a32475ab",
"1ed920c9e27592593e21a6ddaba1a979",
"1ff00dfd47d0ef32794ff97e3c8ffb76",
"2c56e02a283fa9a33beed5fcd980431e",
"3a045cb5b8fe825027a86977edff8697",
"3a616a5305e06ccc883bda3ab63b10b5",
"3ed47e4ae6da84ec4f255ab95fce260f",
"47a9649328d3c021fe3a0627b02e5f2d",
"49c903179d3ed9d593a98da9f48bd3e1",
"4ec969a032686f09de30ead2a801c018",
"55875fb6b754e7e078007324a69007f4",
"56c1a1b89f4a737f1c7a4b52e5ecc7aa",
"57ea44f19b74405f40baa45fc561493a",
"66403ab51f1fd786af6bd60b25d3305f",
"69a5aad12bff0c00a9d18843d1f9a746",
"6b0c36b19007cb2516ca20b905d347c4",
"6bc4aff51344fb647415b10faad1782f",
"7052790f352e0b66c5f5ceea1429da94",
"7c5810fa9eb432a1a1eae36e311adc32",
"7eb652187ff4b17561fa2893a695749b",
"82f05129dcd5ac26ee98f614bb46a904",
"884910c87d546463bb5392afd5449fa8",
"956ec8918c6d1ef8e2165f839b95bd1d",
"9dc0e7eb91ed410e67730d9fb7b6bd09",
"a02f92ccbe2773615526e843bb5a61cb",
"ac2b2ac4fbf7068207776b887796f5b7",
"acdae9f5f89dabe00a07d5b7b5b7da34",
"b8c379f8b9d499096cdf862bb7974706",
"bba58a030e2f1aeb3b2542e7d31644f6",
"c730505f1cf47e66f3841e7df046cd7a",
"d14234136d6d332d9605d06a7a79a122",
"d215aedab5221382a37a177485268129",
"d9435ac0370717e0d64cb08281b16888",
"e2b33f491d6380be91d19e54c3654fd3",
"fd55a5a0843b99e6164c11734c6cd5a0"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 5.0,
"product_slider_terrain": 5.0,
"product_slider_ausstattung": 5.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 103951.1,
"product_vk2_amazon": 749.0,
"product_vk3_ebay": 749.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Sharptail Street 3 29'' gr\u00fcn 2022\/2023"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sharptail Street 3 Mit seinen hydraulischen Scheibenbremsen bietet das Sharptail Street 3 sportliche Fahrsicherheit auf allen Strecken und Touren, bei Trockenheit wie bei N\u00e4sse. Dazu liefert die 24-Gang-Schaltung von Shimano eine gro\u00dfe \u00dcbersetzungsbandbreite, um auch auf anspruchsvollem Terrain immer \u00fcber den passenden Gang zu verf\u00fcgen. Neben dem souver\u00e4nen Fahrgef\u00fchl der breiten Supero Ranger Reifen sorgt der leistungsstarke Pannenschutz zus\u00e4tzlich f\u00fcr ein gutes Gef\u00fchl."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 799.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 671.43,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 11.12,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 11.12
},
"fields": {
"displayGroup": [
"f4860da2d91614285c8ecf19ce8b402a"
]
},
"sort": [
0,
"10e035c3e638ec867d7f668d546abeb9"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "c107b95d125fda0d05c1f245ae8e75d7",
"_score": null,
"_source": {
"id": "c107b95d125fda0d05c1f245ae8e75d7",
"autoIncrement": 79818.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "103939",
"ean": "4063518164677",
"displayGroup": "4738a334f0ca387ad62025cf518112c5",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6462331a69cdc7b76dc81136ca2713dd",
"manufacturerNumber": "631-34751",
"releaseDate": null,
"createdAt": "2023-10-16T11:05:57+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"f033ab37c30201f73f142449d037028d",
"d947bf06a885db0d477d707121934ff8",
"63923f49e5241343aa7acb6a06a751e7",
"33e75ff09dd601bbe69f351039152189",
"34173cb38f07f89ddbebc2ac9128303f",
"07cdfd23373b17c6b337251c22b7ea57",
"182be0c5cdcd5072bb1864cdee4d3d6e"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1
},
{
"id": "63923f49e5241343aa7acb6a06a751e7",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "34173cb38f07f89ddbebc2ac9128303f",
"_count": 1
},
{
"id": "07cdfd23373b17c6b337251c22b7ea57",
"_count": 1
},
{
"id": "182be0c5cdcd5072bb1864cdee4d3d6e",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "b14c27a8176bf7ab8beb8bcc436901cb",
"coverId": "ab0f2fc6b8de972487ab0205e9c6f284",
"childCount": 0,
"categories": [
{
"id": "07cdfd23373b17c6b337251c22b7ea57",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Street MTB Sale"
}
},
{
"id": "182be0c5cdcd5072bb1864cdee4d3d6e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Street MTB"
}
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "34173cb38f07f89ddbebc2ac9128303f",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mountainbike"
}
},
{
"id": "63923f49e5241343aa7acb6a06a751e7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mountainbike Sale"
}
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad Sale"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "6462331a69cdc7b76dc81136ca2713dd",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls"
},
"_count": 1
},
"properties": [
{
"id": "06779f443aad686267674335679f12f4",
"_count": 1,
"groupId": "90172b5a229214a431a4352c66865e89",
"group": {
"id": "90172b5a229214a431a4352c66865e89",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabendynamo DH-3D32NT"
}
},
{
"id": "0d5e3902d0bfaeab5929855eae3e211f",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sportive Comfort"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "1ff00dfd47d0ef32794ff97e3c8ffb76",
"_count": 1,
"groupId": "d7cd942099e8fa42173503c86c8880ce",
"group": {
"id": "d7cd942099e8fa42173503c86c8880ce",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA no.11"
}
},
{
"id": "2c56e02a283fa9a33beed5fcd980431e",
"_count": 1,
"groupId": "c259161c2ad279d194b0a5cfe729e273",
"group": {
"id": "c259161c2ad279d194b0a5cfe729e273",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschutzring"
}
},
{
"id": "3a045cb5b8fe825027a86977edff8697",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoff"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "3ed47e4ae6da84ec4f255ab95fce260f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "gr\u00fcn"
}
},
{
"id": "41c857a8da3221ed81f5f3fc4caed8f3",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "27,5\""
}
},
{
"id": "49c903179d3ed9d593a98da9f48bd3e1",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX riserbar"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "55875fb6b754e7e078007324a69007f4",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon RL-Mini mit Standlichtfunktion"
}
},
{
"id": "57beb890a94329bd11ca34c91fc24598",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Supero Ranger Anti Puncture, 57-584"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "66403ab51f1fd786af6bd60b25d3305f",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hinterbaust\u00e4nder, zul\u00e4ssiges Gesamtgewicht: 125 kg"
}
},
{
"id": "69a5aad12bff0c00a9d18843d1f9a746",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "24"
}
},
{
"id": "6b0c36b19007cb2516ca20b905d347c4",
"_count": 1,
"groupId": "13df042e46bbd8a2eb06116548c29107",
"group": {
"id": "13df042e46bbd8a2eb06116548c29107",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Tourney FD-TY500"
}
},
{
"id": "6bc4aff51344fb647415b10faad1782f",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX Aluminium"
}
},
{
"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": "7eb652187ff4b17561fa2893a695749b",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX DBM-2"
}
},
{
"id": "82f05129dcd5ac26ee98f614bb46a904",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hardtail"
}
},
{
"id": "884910c87d546463bb5392afd5449fa8",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon F-30 EB, 25 Lux"
}
},
{
"id": "956ec8918c6d1ef8e2165f839b95bd1d",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX 42\/34\/24T"
}
},
{
"id": "9dc0e7eb91ed410e67730d9fb7b6bd09",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus RD-M310"
}
},
{
"id": "a02f92ccbe2773615526e843bb5a61cb",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "11"
}
},
{
"id": "ac2b2ac4fbf7068207776b887796f5b7",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "8"
}
},
{
"id": "acdae9f5f89dabe00a07d5b7b5b7da34",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS"
}
},
{
"id": "b8c379f8b9d499096cdf862bb7974706",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SR Suntour NVX 30"
}
},
{
"id": "bba58a030e2f1aeb3b2542e7d31644f6",
"_count": 1,
"groupId": "a9afe3dfd367b52569af60a0af3d19c1",
"group": {
"id": "a9afe3dfd367b52569af60a0af3d19c1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Nabenydamo DH-3D32 \/ Formula"
}
},
{
"id": "c730505f1cf47e66f3841e7df046cd7a",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 cm"
}
},
{
"id": "d14234136d6d332d9605d06a7a79a122",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2023"
}
},
{
"id": "d215aedab5221382a37a177485268129",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Aluminium"
}
},
{
"id": "d2e47f617a44a1ac9dc03bcff1d57945",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Altus SL-M315"
}
},
{
"id": "d9435ac0370717e0d64cb08281b16888",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STYX"
}
},
{
"id": "e2b33f491d6380be91d19e54c3654fd3",
"_count": 1,
"groupId": "a8c218e8daf51c2528ffec6ba60c0c07",
"group": {
"id": "a8c218e8daf51c2528ffec6ba60c0c07",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tektro HD-M275"
}
},
{
"id": "fd55a5a0843b99e6164c11734c6cd5a0",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
}
}
],
"options": [
{
"id": "c730505f1cf47e66f3841e7df046cd7a",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "51 cm"
}
}
],
"categoryIds": [
"07cdfd23373b17c6b337251c22b7ea57",
"182be0c5cdcd5072bb1864cdee4d3d6e",
"33e75ff09dd601bbe69f351039152189",
"34173cb38f07f89ddbebc2ac9128303f",
"63923f49e5241343aa7acb6a06a751e7",
"d947bf06a885db0d477d707121934ff8",
"f033ab37c30201f73f142449d037028d"
],
"optionIds": [
"c730505f1cf47e66f3841e7df046cd7a"
],
"propertyIds": [
"06779f443aad686267674335679f12f4",
"0d5e3902d0bfaeab5929855eae3e211f",
"1ed920c9e27592593e21a6ddaba1a979",
"1ff00dfd47d0ef32794ff97e3c8ffb76",
"2c56e02a283fa9a33beed5fcd980431e",
"3a045cb5b8fe825027a86977edff8697",
"3a616a5305e06ccc883bda3ab63b10b5",
"3ed47e4ae6da84ec4f255ab95fce260f",
"41c857a8da3221ed81f5f3fc4caed8f3",
"49c903179d3ed9d593a98da9f48bd3e1",
"4ec969a032686f09de30ead2a801c018",
"55875fb6b754e7e078007324a69007f4",
"57beb890a94329bd11ca34c91fc24598",
"57ea44f19b74405f40baa45fc561493a",
"66403ab51f1fd786af6bd60b25d3305f",
"69a5aad12bff0c00a9d18843d1f9a746",
"6b0c36b19007cb2516ca20b905d347c4",
"6bc4aff51344fb647415b10faad1782f",
"7052790f352e0b66c5f5ceea1429da94",
"7c5810fa9eb432a1a1eae36e311adc32",
"7eb652187ff4b17561fa2893a695749b",
"82f05129dcd5ac26ee98f614bb46a904",
"884910c87d546463bb5392afd5449fa8",
"956ec8918c6d1ef8e2165f839b95bd1d",
"9dc0e7eb91ed410e67730d9fb7b6bd09",
"a02f92ccbe2773615526e843bb5a61cb",
"ac2b2ac4fbf7068207776b887796f5b7",
"acdae9f5f89dabe00a07d5b7b5b7da34",
"b8c379f8b9d499096cdf862bb7974706",
"bba58a030e2f1aeb3b2542e7d31644f6",
"c730505f1cf47e66f3841e7df046cd7a",
"d14234136d6d332d9605d06a7a79a122",
"d215aedab5221382a37a177485268129",
"d2e47f617a44a1ac9dc03bcff1d57945",
"d9435ac0370717e0d64cb08281b16888",
"e2b33f491d6380be91d19e54c3654fd3",
"fd55a5a0843b99e6164c11734c6cd5a0"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 5.0,
"product_slider_terrain": 5.0,
"product_slider_ausstattung": 5.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 103937.1,
"product_vk2_amazon": 749.0,
"product_vk3_ebay": 749.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Sharptail Street 3 27,5'' gr\u00fcn 2022\/2023"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Sharptail Street 3 Mit seinen hydraulischen Scheibenbremsen bietet das Sharptail Street 3 sportliche Fahrsicherheit auf allen Strecken und Touren, bei Trockenheit wie bei N\u00e4sse. Dazu liefert die 24-Gang-Schaltung von Shimano eine gro\u00dfe \u00dcbersetzungsbandbreite, um auch auf anspruchsvollem Terrain immer \u00fcber den passenden Gang zu verf\u00fcgen. Neben dem souver\u00e4nen Fahrgef\u00fchl der breiten Supero Ranger Reifen sorgt der leistungsstarke Pannenschutz zus\u00e4tzlich f\u00fcr ein gutes Gef\u00fchl."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 799.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 672.23,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 11.11,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 11.11
},
"fields": {
"displayGroup": [
"4738a334f0ca387ad62025cf518112c5"
]
},
"sort": [
0,
"c107b95d125fda0d05c1f245ae8e75d7"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.47 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":"07cdfd23373b17c6b337251c22b7ea57"}}}},{"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": 5,
"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": 3,
"rating": {
"value": 0.0
}
},
"price": {
"count": 3,
"min": 799.0,
"max": 799.95,
"avg": 799.3166666666666,
"sum": 2397.95
},
"options": {
"doc_count": 3,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "c730505f1cf47e66f3841e7df046cd7a",
"doc_count": 2
},
{
"key": "9c07b329eb635444f74b635e939a9392",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 111,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "06779f443aad686267674335679f12f4",
"doc_count": 3
},
{
"key": "0d5e3902d0bfaeab5929855eae3e211f",
"doc_count": 3
},
{
"key": "1ed920c9e27592593e21a6ddaba1a979",
"doc_count": 3
},
{
"key": "1ff00dfd47d0ef32794ff97e3c8ffb76",
"doc_count": 3
},
{
"key": "2c56e02a283fa9a33beed5fcd980431e",
"doc_count": 3
},
{
"key": "3a045cb5b8fe825027a86977edff8697",
"doc_count": 3
},
{
"key": "3a616a5305e06ccc883bda3ab63b10b5",
"doc_count": 3
},
{
"key": "3ed47e4ae6da84ec4f255ab95fce260f",
"doc_count": 3
},
{
"key": "49c903179d3ed9d593a98da9f48bd3e1",
"doc_count": 3
},
{
"key": "4ec969a032686f09de30ead2a801c018",
"doc_count": 3
},
{
"key": "55875fb6b754e7e078007324a69007f4",
"doc_count": 3
},
{
"key": "57ea44f19b74405f40baa45fc561493a",
"doc_count": 3
},
{
"key": "66403ab51f1fd786af6bd60b25d3305f",
"doc_count": 3
},
{
"key": "69a5aad12bff0c00a9d18843d1f9a746",
"doc_count": 3
},
{
"key": "6b0c36b19007cb2516ca20b905d347c4",
"doc_count": 3
},
{
"key": "6bc4aff51344fb647415b10faad1782f",
"doc_count": 3
},
{
"key": "7052790f352e0b66c5f5ceea1429da94",
"doc_count": 3
},
{
"key": "7c5810fa9eb432a1a1eae36e311adc32",
"doc_count": 3
},
{
"key": "7eb652187ff4b17561fa2893a695749b",
"doc_count": 3
},
{
"key": "82f05129dcd5ac26ee98f614bb46a904",
"doc_count": 3
},
{
"key": "884910c87d546463bb5392afd5449fa8",
"doc_count": 3
},
{
"key": "956ec8918c6d1ef8e2165f839b95bd1d",
"doc_count": 3
},
{
"key": "9dc0e7eb91ed410e67730d9fb7b6bd09",
"doc_count": 3
},
{
"key": "a02f92ccbe2773615526e843bb5a61cb",
"doc_count": 3
},
{
"key": "ac2b2ac4fbf7068207776b887796f5b7",
"doc_count": 3
},
{
"key": "acdae9f5f89dabe00a07d5b7b5b7da34",
"doc_count": 3
},
{
"key": "b8c379f8b9d499096cdf862bb7974706",
"doc_count": 3
},
{
"key": "bba58a030e2f1aeb3b2542e7d31644f6",
"doc_count": 3
},
{
"key": "d14234136d6d332d9605d06a7a79a122",
"doc_count": 3
},
{
"key": "d215aedab5221382a37a177485268129",
"doc_count": 3
},
{
"key": "d9435ac0370717e0d64cb08281b16888",
"doc_count": 3
},
{
"key": "e2b33f491d6380be91d19e54c3654fd3",
"doc_count": 3
},
{
"key": "fd55a5a0843b99e6164c11734c6cd5a0",
"doc_count": 3
},
{
"key": "1752c866d20137c75ade67c2a32475ab",
"doc_count": 2
},
{
"key": "47a9649328d3c021fe3a0627b02e5f2d",
"doc_count": 2
},
{
"key": "56c1a1b89f4a737f1c7a4b52e5ecc7aa",
"doc_count": 2
},
{
"key": "c730505f1cf47e66f3841e7df046cd7a",
"doc_count": 2
},
{
"key": "41c857a8da3221ed81f5f3fc4caed8f3",
"doc_count": 1
},
{
"key": "57beb890a94329bd11ca34c91fc24598",
"doc_count": 1
},
{
"key": "9c07b329eb635444f74b635e939a9392",
"doc_count": 1
},
{
"key": "d2e47f617a44a1ac9dc03bcff1d57945",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6462331a69cdc7b76dc81136ca2713dd",
"doc_count": 3
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|