| 1 |
4.83 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":"d395771085aab05244a4fb8fd91bf4ee"}}}},{"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": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "235bc57f6e3b2b7ca06ea634f1b092e6",
"_score": null,
"_source": {
"id": "235bc57f6e3b2b7ca06ea634f1b092e6",
"autoIncrement": 84791.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "201493",
"ean": "9008594229242",
"displayGroup": "04fd1862bbc51672c1140b9bb614e34d",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "dcd5f50d22ad0afab2af9fb732dd9bbf",
"manufacturerNumber": "2230708106",
"releaseDate": null,
"createdAt": "2023-10-16T11:28:50+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"33e75ff09dd601bbe69f351039152189",
"e369853df766fa44e1ed0ff613f563bd",
"f033ab37c30201f73f142449d037028d",
"d947bf06a885db0d477d707121934ff8",
"d395771085aab05244a4fb8fd91bf4ee",
"1c383cd30b7c298ab50293adfecb7b18",
"66808e327dc79d135ba18e051673d906",
"92c8c96e4c37100777c7190b76d28233"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "e369853df766fa44e1ed0ff613f563bd",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1
},
{
"id": "d395771085aab05244a4fb8fd91bf4ee",
"_count": 1
},
{
"id": "1c383cd30b7c298ab50293adfecb7b18",
"_count": 1
},
{
"id": "66808e327dc79d135ba18e051673d906",
"_count": 1
},
{
"id": "92c8c96e4c37100777c7190b76d28233",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "2f87c6ed57f34aec5766794478c03f8b",
"coverId": "dfdb2e295c79245c8bb47856aa1c36b4",
"childCount": 0,
"categories": [
{
"id": "1c383cd30b7c298ab50293adfecb7b18",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Offroad"
}
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "66808e327dc79d135ba18e051673d906",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Herren"
}
},
{
"id": "92c8c96e4c37100777c7190b76d28233",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Offroad Sale"
}
},
{
"id": "d395771085aab05244a4fb8fd91bf4ee",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbike Sale"
}
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad Sale"
}
},
{
"id": "e369853df766fa44e1ed0ff613f563bd",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbike"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "dcd5f50d22ad0afab2af9fb732dd9bbf",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM"
},
"_count": 1
},
"properties": [
{
"id": "04f2d8d9128c4263fc15be45237b0dea",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "zul\u00e4ssiges Gesamtgewicht 131 kg"
}
},
{
"id": "103dd9c2a4e1e51101a50dd26cd61907",
"_count": 1,
"groupId": "1dfcee408979620926ced38d7ae45bb3",
"group": {
"id": "1dfcee408979620926ced38d7ae45bb3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "6061 Aluminium"
}
},
{
"id": "154f7187d58295a4082e3a15d261d0f7",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schwalbe Smart Sam Perf. 44-622 RT Addix \/ Schwalbe Smart Sam Perf. 44-622 RT Addix"
}
},
{
"id": "1e2eee1032b9111be4ab622683cb0cec",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2024"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "1eefc25dfb07df4e200ed6e6b5ebfd7a",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "2de0874030b04e62db898db6bcbcddf6",
"_count": 1,
"groupId": "72fb53d4716f03510b2c461fb0ef8ebf",
"group": {
"id": "72fb53d4716f03510b2c461fb0ef8ebf",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Deore XT T8000-10 display"
}
},
{
"id": "37d01c0fdf697c21fcf9390242e51f27",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM"
}
},
{
"id": "3a2229656e224a9c56ac575e3b0674da",
"_count": 1,
"groupId": "d7cd942099e8fa42173503c86c8880ce",
"group": {
"id": "d7cd942099e8fa42173503c86c8880ce",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Team drop\/in 1.1\/8\"-1.5\""
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "4e1a18edee888f097a50e4d7e0915f2d",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Team Offroad LSB"
}
},
{
"id": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "4f6e4b5bc2cba06ce5b940670166f6d8",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "30"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "5c9d310a9c710e6ad89f4fc16619778c",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Deore XT T8000 48-36-26T"
}
},
{
"id": "62fc7cf144a8a750ec5419d8d712af15",
"_count": 1,
"groupId": "a9afe3dfd367b52569af60a0af3d19c1",
"group": {
"id": "a9afe3dfd367b52569af60a0af3d19c1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Line Shimano HB-M8000\/FH-M8000 CL 32 H 100QR"
}
},
{
"id": "799a52429aee541219472d41e8f20934",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Deore XT T8000-10 SGS shadow"
}
},
{
"id": "7c5810fa9eb432a1a1eae36e311adc32",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
},
{
"id": "80ccba4563866c0de5894d73043a40ea",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Comp Hybrid"
}
},
{
"id": "8b5f764ac04400a8a004d00e5c94c6f9",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Suntour NCX-E Air RL 63mm"
}
},
{
"id": "907febd57471a641963d2e8458318fec",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Team 27.2"
}
},
{
"id": "981b48b88746495c8526351a93a479ac",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Team flat 2X 620mm"
}
},
{
"id": "9c07b329eb635444f74b635e939a9392",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46 cm"
}
},
{
"id": "9d8e59364a1798d0545ee916174c1c6f",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Line 7\u00b0"
}
},
{
"id": "b368b4fe2b404a1e91acdfcfc235dc3f",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "schwarz"
}
},
{
"id": "c712aed261879de46bc8989e36fe639b",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10"
}
},
{
"id": "c8bb250ce4ae8f1cb3003218719fbfd5",
"_count": 1,
"groupId": "f9109ae7ce709818cf47ead51feb3096",
"group": {
"id": "f9109ae7ce709818cf47ead51feb3096",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
}
},
{
"id": "d7f0e9589c8162f4271a042a8296b553",
"_count": 1,
"groupId": "13df042e46bbd8a2eb06116548c29107",
"group": {
"id": "13df042e46bbd8a2eb06116548c29107",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano Deore XT T8000"
}
},
{
"id": "f4f128650af97c6ac1e513979f6d972a",
"_count": 1,
"groupId": "711c14702e48a5a53a7dd8802bfd1667",
"group": {
"id": "711c14702e48a5a53a7dd8802bfd1667",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Richman 2.0 double butted INOX, black \/ Richman 2.0 double butted INOX, black"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
},
{
"id": "fd55a5a0843b99e6164c11734c6cd5a0",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse hydr."
}
},
{
"id": "ff38ae8d2e4e2225204122517de8b410",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
}
],
"options": [
{
"id": "9c07b329eb635444f74b635e939a9392",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "46 cm"
}
}
],
"categoryIds": [
"1c383cd30b7c298ab50293adfecb7b18",
"33e75ff09dd601bbe69f351039152189",
"66808e327dc79d135ba18e051673d906",
"92c8c96e4c37100777c7190b76d28233",
"d395771085aab05244a4fb8fd91bf4ee",
"d947bf06a885db0d477d707121934ff8",
"e369853df766fa44e1ed0ff613f563bd",
"f033ab37c30201f73f142449d037028d"
],
"optionIds": [
"9c07b329eb635444f74b635e939a9392"
],
"propertyIds": [
"04f2d8d9128c4263fc15be45237b0dea",
"103dd9c2a4e1e51101a50dd26cd61907",
"154f7187d58295a4082e3a15d261d0f7",
"1e2eee1032b9111be4ab622683cb0cec",
"1ed920c9e27592593e21a6ddaba1a979",
"1eefc25dfb07df4e200ed6e6b5ebfd7a",
"2de0874030b04e62db898db6bcbcddf6",
"37d01c0fdf697c21fcf9390242e51f27",
"3a2229656e224a9c56ac575e3b0674da",
"3a616a5305e06ccc883bda3ab63b10b5",
"4e1a18edee888f097a50e4d7e0915f2d",
"4ec969a032686f09de30ead2a801c018",
"4f6e4b5bc2cba06ce5b940670166f6d8",
"57ea44f19b74405f40baa45fc561493a",
"5c9d310a9c710e6ad89f4fc16619778c",
"62fc7cf144a8a750ec5419d8d712af15",
"799a52429aee541219472d41e8f20934",
"7c5810fa9eb432a1a1eae36e311adc32",
"80ccba4563866c0de5894d73043a40ea",
"8b5f764ac04400a8a004d00e5c94c6f9",
"907febd57471a641963d2e8458318fec",
"981b48b88746495c8526351a93a479ac",
"9c07b329eb635444f74b635e939a9392",
"9d8e59364a1798d0545ee916174c1c6f",
"b368b4fe2b404a1e91acdfcfc235dc3f",
"c712aed261879de46bc8989e36fe639b",
"c8bb250ce4ae8f1cb3003218719fbfd5",
"d7f0e9589c8162f4271a042a8296b553",
"f4f128650af97c6ac1e513979f6d972a",
"fc7c95e8a0c10edfec779479917546ca",
"fd55a5a0843b99e6164c11734c6cd5a0",
"ff38ae8d2e4e2225204122517de8b410"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 7.0,
"product_slider_terrain": 5.0,
"product_slider_ausstattung": 8.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "7538-2729",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": 201493.1,
"product_vk2_amazon": 2049.0,
"product_vk3_ebay": 2049.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "KTM Loreto Cross Herren schwarz 2024"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 1499.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1259.66,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross_percentage": 26.84,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net_percentage": 26.84
},
"fields": {
"displayGroup": [
"04fd1862bbc51672c1140b9bb614e34d"
]
},
"sort": [
0,
"235bc57f6e3b2b7ca06ea634f1b092e6"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "a0b793cc4f97d44aa4ae2bcef416e18b",
"_score": null,
"_source": {
"id": "a0b793cc4f97d44aa4ae2bcef416e18b",
"autoIncrement": 80146.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 10,
"productNumber": "104097S",
"ean": "4063518165056",
"displayGroup": "deb0cb5aa545a74748d5cbbeadcd6283",
"sales": 0,
"stock": 10,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "6462331a69cdc7b76dc81136ca2713dd",
"manufacturerNumber": "632-00944",
"releaseDate": null,
"createdAt": "2023-10-16T11:06:52+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"f033ab37c30201f73f142449d037028d",
"d947bf06a885db0d477d707121934ff8",
"d395771085aab05244a4fb8fd91bf4ee",
"e3796ae838835da0b6f6ea37bcf8bcb7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1
},
{
"id": "d395771085aab05244a4fb8fd91bf4ee",
"_count": 1
},
{
"id": "e3796ae838835da0b6f6ea37bcf8bcb7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "5d688fcd642e4808d9b8ff7942253207",
"coverId": "3cd3e3056ffc95154f1e359b118b8481",
"childCount": 0,
"categories": [
{
"id": "d395771085aab05244a4fb8fd91bf4ee",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbike Sale"
}
},
{
"id": "d947bf06a885db0d477d707121934ff8",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad Sale"
}
},
{
"id": "e3796ae838835da0b6f6ea37bcf8bcb7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Crossbikes Street Sale"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "6462331a69cdc7b76dc81136ca2713dd",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls"
},
"_count": 1
},
"properties": [
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "40fbe167bbe1280e42ecc34ce80779de",
"_count": 1,
"groupId": "f7a9fede8828c7ad00054338044d0dbe",
"group": {
"id": "f7a9fede8828c7ad00054338044d0dbe",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenbremse mech."
}
},
{
"id": "4e93759a50b70b433ccdb1ef4185fcc1",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "blau"
}
},
{
"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": "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": "835bc14c1a6a26438f0ed4acb1237f7e",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "21"
}
},
{
"id": "c712aed261879de46bc8989e36fe639b",
"_count": 1,
"groupId": "a16022e7816ee4b03a8e54519ee7bf02",
"group": {
"id": "a16022e7816ee4b03a8e54519ee7bf02",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "10"
}
},
{
"id": "d1a6de8528057b72c46b6b64d4de8ce6",
"_count": 1,
"groupId": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"group": {
"id": "adf2abbdb5a021f12b6bc1a1fd34dbc7",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "2022"
}
},
{
"id": "e6552f3f5b40ad3731fd08680f2ccb85",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "44 cm"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
},
{
"id": "ff38ae8d2e4e2225204122517de8b410",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
}
],
"options": [
{
"id": "e6552f3f5b40ad3731fd08680f2ccb85",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "44 cm"
}
}
],
"categoryIds": [
"d395771085aab05244a4fb8fd91bf4ee",
"d947bf06a885db0d477d707121934ff8",
"e3796ae838835da0b6f6ea37bcf8bcb7",
"f033ab37c30201f73f142449d037028d"
],
"optionIds": [
"e6552f3f5b40ad3731fd08680f2ccb85"
],
"propertyIds": [
"1ed920c9e27592593e21a6ddaba1a979",
"3a616a5305e06ccc883bda3ab63b10b5",
"40fbe167bbe1280e42ecc34ce80779de",
"4e93759a50b70b433ccdb1ef4185fcc1",
"4ec969a032686f09de30ead2a801c018",
"57ea44f19b74405f40baa45fc561493a",
"7052790f352e0b66c5f5ceea1429da94",
"7c5810fa9eb432a1a1eae36e311adc32",
"835bc14c1a6a26438f0ed4acb1237f7e",
"c712aed261879de46bc8989e36fe639b",
"d1a6de8528057b72c46b6b64d4de8ce6",
"e6552f3f5b40ad3731fd08680f2ccb85",
"fc7c95e8a0c10edfec779479917546ca",
"ff38ae8d2e4e2225204122517de8b410"
],
"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": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "104097S.1",
"product_vk2_amazon": 594.0,
"product_vk3_ebay": 594.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Bulls Wildcross mit Stra\u00dfenausstattung Herren blau"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BULLS Wildcross Mit seiner 21-Gang-Schaltung bietet das Wildcross Geschwindigkeit und Kletter-Power gleicherma\u00dfen. Gemeinsam mit den mechanischen Scheibenbremsen und den pannengesch\u00fctzten Supero Ranger Profilreifen ist das Wildcross ein Bike, das auf allen Strecken f\u00fcr sportlichen Fahrspa\u00df sorgt. Wir haben dir das Modell bereits mit der hochwertigen Fuxon Magma Easy-Beleuchtung, mit original SKS Velo Cross 55-Schutzblechen und einem sehr stabilen Bulls Solid-St\u00e4nder sowie mit Reflektoren und einer Klingel ausgestattet. Mit der Beleuchtung und den Reflektoren bist du auch im Dunkeln gut sichtbar und sicher unterwegs. Die Schutzbleche sind abnehmbar, so dass du bei gutem Wetter auch ohne fahren kannst."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 544.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 457.14
},
"fields": {
"displayGroup": [
"deb0cb5aa545a74748d5cbbeadcd6283"
]
},
"sort": [
0,
"a0b793cc4f97d44aa4ae2bcef416e18b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.52 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":"d395771085aab05244a4fb8fd91bf4ee"}}}},{"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": 5,
"rating": {
"value": 0.0
}
},
"price": {
"count": 5,
"min": 544.0,
"max": 1499.0,
"avg": 1308.0,
"sum": 6540.0
},
"options": {
"doc_count": 5,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "6baa66c87b0c7e587a5059d880d324c1",
"doc_count": 1
},
{
"key": "9c07b329eb635444f74b635e939a9392",
"doc_count": 1
},
{
"key": "c730505f1cf47e66f3841e7df046cd7a",
"doc_count": 1
},
{
"key": "e559bbf8c5e8bf764b62ac61f20d8e19",
"doc_count": 1
},
{
"key": "e6552f3f5b40ad3731fd08680f2ccb85",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 142,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "1ed920c9e27592593e21a6ddaba1a979",
"doc_count": 5
},
{
"key": "3a616a5305e06ccc883bda3ab63b10b5",
"doc_count": 5
},
{
"key": "4ec969a032686f09de30ead2a801c018",
"doc_count": 5
},
{
"key": "57ea44f19b74405f40baa45fc561493a",
"doc_count": 5
},
{
"key": "7c5810fa9eb432a1a1eae36e311adc32",
"doc_count": 5
},
{
"key": "c712aed261879de46bc8989e36fe639b",
"doc_count": 5
},
{
"key": "fc7c95e8a0c10edfec779479917546ca",
"doc_count": 5
},
{
"key": "ff38ae8d2e4e2225204122517de8b410",
"doc_count": 5
},
{
"key": "04f2d8d9128c4263fc15be45237b0dea",
"doc_count": 4
},
{
"key": "103dd9c2a4e1e51101a50dd26cd61907",
"doc_count": 4
},
{
"key": "154f7187d58295a4082e3a15d261d0f7",
"doc_count": 4
},
{
"key": "1e2eee1032b9111be4ab622683cb0cec",
"doc_count": 4
},
{
"key": "1eefc25dfb07df4e200ed6e6b5ebfd7a",
"doc_count": 4
},
{
"key": "2de0874030b04e62db898db6bcbcddf6",
"doc_count": 4
},
{
"key": "37d01c0fdf697c21fcf9390242e51f27",
"doc_count": 4
},
{
"key": "3a2229656e224a9c56ac575e3b0674da",
"doc_count": 4
},
{
"key": "4e1a18edee888f097a50e4d7e0915f2d",
"doc_count": 4
},
{
"key": "4f6e4b5bc2cba06ce5b940670166f6d8",
"doc_count": 4
},
{
"key": "5c9d310a9c710e6ad89f4fc16619778c",
"doc_count": 4
},
{
"key": "62fc7cf144a8a750ec5419d8d712af15",
"doc_count": 4
},
{
"key": "799a52429aee541219472d41e8f20934",
"doc_count": 4
},
{
"key": "80ccba4563866c0de5894d73043a40ea",
"doc_count": 4
},
{
"key": "8b5f764ac04400a8a004d00e5c94c6f9",
"doc_count": 4
},
{
"key": "907febd57471a641963d2e8458318fec",
"doc_count": 4
},
{
"key": "981b48b88746495c8526351a93a479ac",
"doc_count": 4
},
{
"key": "9d8e59364a1798d0545ee916174c1c6f",
"doc_count": 4
},
{
"key": "b368b4fe2b404a1e91acdfcfc235dc3f",
"doc_count": 4
},
{
"key": "c8bb250ce4ae8f1cb3003218719fbfd5",
"doc_count": 4
},
{
"key": "d7f0e9589c8162f4271a042a8296b553",
"doc_count": 4
},
{
"key": "f4f128650af97c6ac1e513979f6d972a",
"doc_count": 4
},
{
"key": "fd55a5a0843b99e6164c11734c6cd5a0",
"doc_count": 4
},
{
"key": "40fbe167bbe1280e42ecc34ce80779de",
"doc_count": 1
},
{
"key": "4e93759a50b70b433ccdb1ef4185fcc1",
"doc_count": 1
},
{
"key": "6baa66c87b0c7e587a5059d880d324c1",
"doc_count": 1
},
{
"key": "7052790f352e0b66c5f5ceea1429da94",
"doc_count": 1
},
{
"key": "835bc14c1a6a26438f0ed4acb1237f7e",
"doc_count": 1
},
{
"key": "9c07b329eb635444f74b635e939a9392",
"doc_count": 1
},
{
"key": "c730505f1cf47e66f3841e7df046cd7a",
"doc_count": 1
},
{
"key": "d1a6de8528057b72c46b6b64d4de8ce6",
"doc_count": 1
},
{
"key": "e559bbf8c5e8bf764b62ac61f20d8e19",
"doc_count": 1
},
{
"key": "e6552f3f5b40ad3731fd08680f2ccb85",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "dcd5f50d22ad0afab2af9fb732dd9bbf",
"doc_count": 4
},
{
"key": "6462331a69cdc7b76dc81136ca2713dd",
"doc_count": 1
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|