| 1 |
5.13 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"3b24adb00570f5613cc8706ee397b0c0"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "51a0b967f108f237147609b7d54a9cef",
"_score": null,
"_source": {
"id": "51a0b967f108f237147609b7d54a9cef",
"autoIncrement": 86429.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": true,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 0,
"productNumber": "750173",
"ean": "4052968316101",
"displayGroup": "12c8b94b22a5a23ff49409e443b6975f",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "3b24adb00570f5613cc8706ee397b0c0",
"manufacturerNumber": "31AK1015",
"releaseDate": null,
"createdAt": "2023-10-16T11:36:55+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"33e75ff09dd601bbe69f351039152189",
"a5bfc9e07964f8dddeb95fc584cd965d"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1
},
{
"id": "a5bfc9e07964f8dddeb95fc584cd965d",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "ee2485296a69d2999a672d3bbcaa6753",
"coverId": "ec95953ba7aa67157e4fc58d0390a105",
"childCount": 0,
"categories": [
{
"id": "33e75ff09dd601bbe69f351039152189",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrr\u00e4der"
}
},
{
"id": "a5bfc9e07964f8dddeb95fc584cd965d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gravel Bikes"
}
}
],
"manufacturer": {
"id": "3b24adb00570f5613cc8706ee397b0c0",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ghost"
},
"_count": 1
},
"properties": [
{
"id": "185a811a79e508abbae578884112699d",
"_count": 1,
"groupId": "a9afe3dfd367b52569af60a0af3d19c1",
"group": {
"id": "a9afe3dfd367b52569af60a0af3d19c1",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano HB-RS470 12x100mm"
}
},
{
"id": "1b18457a349fb5d1924ffa3ea4cfd2a9",
"_count": 1,
"groupId": "e50ebe47ad39a09a92d06070287e368b",
"group": {
"id": "e50ebe47ad39a09a92d06070287e368b",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lezyne Hecto Pro 65"
}
},
{
"id": "1b3c2adeac7d34892553dd4c631ed393",
"_count": 1,
"groupId": "483e959c479e7b2fe6423516bb994643",
"group": {
"id": "483e959c479e7b2fe6423516bb994643",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GND 51 27.2 mm"
}
},
{
"id": "1ed920c9e27592593e21a6ddaba1a979",
"_count": 1,
"groupId": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"group": {
"id": "8d3c06e4ef7fec22377ee4ea56e7df6a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschaltung"
}
},
{
"id": "2950efaa909fe58079f474c2e19d73bb",
"_count": 1,
"groupId": "b452f9cfcee052c98c3cc127a83eb467",
"group": {
"id": "b452f9cfcee052c98c3cc127a83eb467",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ca. 12,8 kg"
}
},
{
"id": "3696d3c00e7e1d0cc428a52272653014",
"_count": 1,
"groupId": "d7cd942099e8fa42173503c86c8880ce",
"group": {
"id": "d7cd942099e8fa42173503c86c8880ce",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ACROS"
}
},
{
"id": "38853327ccf3c5fb06d84e2eaa9319f5",
"_count": 1,
"groupId": "ea9a44ed7ed83415d29d57fcdd199e52",
"group": {
"id": "ea9a44ed7ed83415d29d57fcdd199e52",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FPD NW-91K"
}
},
{
"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": "4ec969a032686f09de30ead2a801c018",
"_count": 1,
"groupId": "611e9d73fb6447db4ff09b58ecadce21",
"group": {
"id": "611e9d73fb6447db4ff09b58ecadce21",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "534ca5b505ab9db617574eeab1bd8934",
"_count": 1,
"groupId": "05044f92622e2a4b4b94bf95bb76fa5d",
"group": {
"id": "05044f92622e2a4b4b94bf95bb76fa5d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Sora RD-R3000-GS 9-S"
}
},
{
"id": "548ee6ca88a2bcff7d35ba0450b7ae7f",
"_count": 1,
"groupId": "bf2129aece92fe202715f8914e9d9e95",
"group": {
"id": "bf2129aece92fe202715f8914e9d9e95",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "zul\u00e4ssiges Gesamtgewicht 120kg"
}
},
{
"id": "557d20358170b68bc9bedd9dfc46c82b",
"_count": 1,
"groupId": "7eb4ca27b65686333ee285cbf14f1768",
"group": {
"id": "7eb4ca27b65686333ee285cbf14f1768",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shimano FH-MT400 12x142mm"
}
},
{
"id": "57ea44f19b74405f40baa45fc561493a",
"_count": 1,
"groupId": "79958f9b32c396332e45ef4487152f13",
"group": {
"id": "79958f9b32c396332e45ef4487152f13",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Nein"
}
},
{
"id": "64363d34bd31a246f9ad52522ce1dd4d",
"_count": 1,
"groupId": "3ea4bb03c22f227764c0c1fc05655f9f",
"group": {
"id": "3ea4bb03c22f227764c0c1fc05655f9f",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "WTB ST i25"
}
},
{
"id": "6bf324274b0ba387f9143a0caa934a01",
"_count": 1,
"groupId": "ceb6fd21dc31360b88ac128686052a5e",
"group": {
"id": "ceb6fd21dc31360b88ac128686052a5e",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FSA CK-C201ST 46-30T"
}
},
{
"id": "6c9464854ccfb363616adf31ac8b1120",
"_count": 1,
"groupId": "d6bd6f9e3367dae962449921e7fe7869",
"group": {
"id": "d6bd6f9e3367dae962449921e7fe7869",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Feimin FP-B908N"
}
},
{
"id": "7052790f352e0b66c5f5ceea1429da94",
"_count": 1,
"groupId": "f424bfe0316bd62a53f56a46d5eb8d7d",
"group": {
"id": "f424bfe0316bd62a53f56a46d5eb8d7d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ja"
}
},
{
"id": "7172614405ccf04ee5ba891b726f6412",
"_count": 1,
"groupId": "ecf1a4775ece0c53ee7dc9957d1edd24",
"group": {
"id": "ecf1a4775ece0c53ee7dc9957d1edd24",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lezyne Hecto Pro 65"
}
},
{
"id": "7c5810fa9eb432a1a1eae36e311adc32",
"_count": 1,
"groupId": "b33509e4101693a82829fd320a7394ef",
"group": {
"id": "b33509e4101693a82829fd320a7394ef",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Herren"
}
},
{
"id": "81370e99b457dc7aa64a36b4a0696228",
"_count": 1,
"groupId": "711c14702e48a5a53a7dd8802bfd1667",
"group": {
"id": "711c14702e48a5a53a7dd8802bfd1667",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "DT SWISS 2.0"
}
},
{
"id": "8aebf2fa38edb4e045dadb21ea6229f3",
"_count": 1,
"groupId": "ae1de98645eed200149ba8a40a93df97",
"group": {
"id": "ae1de98645eed200149ba8a40a93df97",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "GHOST Carbon"
}
},
{
"id": "94f83f4f781923f19512152f584e34a1",
"_count": 1,
"groupId": "b7353c4ace70858b93234198b10691b5",
"group": {
"id": "b7353c4ace70858b93234198b10691b5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ghost Dia. 31.8mm"
}
},
{
"id": "9adb0a2d476ab62bdb3b0e7a31e5f0be",
"_count": 1,
"groupId": "13df042e46bbd8a2eb06116548c29107",
"group": {
"id": "13df042e46bbd8a2eb06116548c29107",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHIMANO Sora FD-R3030"
}
},
{
"id": "9c633102df50acc5507eafd0eecc6d6d",
"_count": 1,
"groupId": "8f5fb50f0ee251c4c2af213e489e63bb",
"group": {
"id": "8f5fb50f0ee251c4c2af213e489e63bb",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Diamant"
}
},
{
"id": "b8566c7bbdac337ff9153dbf85ee2ab6",
"_count": 1,
"groupId": "6c08e78b28fa89c1c312ff53e2d81088",
"group": {
"id": "6c08e78b28fa89c1c312ff53e2d81088",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Curana Apollo 55"
}
},
{
"id": "ba316d8fd51cd2665ded7b20cd58c4d7",
"_count": 1,
"groupId": "a6422bb08b1146d1c55779ac81586ab3",
"group": {
"id": "a6422bb08b1146d1c55779ac81586ab3",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Racktime Light IT 2.0"
}
},
{
"id": "c24d6d52db4bba5909a999940d251c14",
"_count": 1,
"groupId": "16fd55d02a23f31097ca58eccfeec97c",
"group": {
"id": "16fd55d02a23f31097ca58eccfeec97c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "lila"
}
},
{
"id": "c388aef8e02d018ea7ac9cb0da7b9bd0",
"_count": 1,
"groupId": "4b20688ca061fc9a853d8dd3c4625fa8",
"group": {
"id": "4b20688ca061fc9a853d8dd3c4625fa8",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gravel Bar RA120A 420(XS) 440(S) 460(M) 480(L) 500(XL)"
}
},
{
"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": "c8f4894c0ec2eb7697dd7a01cfcd163c",
"_count": 1,
"groupId": "6952d7680528b2ba9f7ab0e454eed1db",
"group": {
"id": "6952d7680528b2ba9f7ab0e454eed1db",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Maxxis Ravager Exo TR 40-622"
}
},
{
"id": "c95e1f378d4ed255e707ddd9ba204083",
"_count": 1,
"groupId": "503f306fc1edbd32bb55a9d4d3994f8d",
"group": {
"id": "503f306fc1edbd32bb55a9d4d3994f8d",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "18"
}
},
{
"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": "e4606d7480338d5ba194dff8a56aacf6",
"_count": 1,
"groupId": "9ce1042f3530e102e670fd8040e9495a",
"group": {
"id": "9ce1042f3530e102e670fd8040e9495a",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal"
}
},
{
"id": "e6e9aead8a009cf3958c014a595a6d47",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "41 cm"
}
},
{
"id": "fc7c95e8a0c10edfec779479917546ca",
"_count": 1,
"groupId": "f5fed9bc267410759ab04276601a9f42",
"group": {
"id": "f5fed9bc267410759ab04276601a9f42",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "28\""
}
}
],
"options": [
{
"id": "e6e9aead8a009cf3958c014a595a6d47",
"_count": 1,
"groupId": "c3beefaefa0c82a810da3211f962fa99",
"group": {
"id": "c3beefaefa0c82a810da3211f962fa99",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "41 cm"
}
}
],
"categoryIds": [
"33e75ff09dd601bbe69f351039152189",
"a5bfc9e07964f8dddeb95fc584cd965d"
],
"optionIds": [
"e6e9aead8a009cf3958c014a595a6d47"
],
"propertyIds": [
"185a811a79e508abbae578884112699d",
"1b18457a349fb5d1924ffa3ea4cfd2a9",
"1b3c2adeac7d34892553dd4c631ed393",
"1ed920c9e27592593e21a6ddaba1a979",
"2950efaa909fe58079f474c2e19d73bb",
"3696d3c00e7e1d0cc428a52272653014",
"38853327ccf3c5fb06d84e2eaa9319f5",
"3a616a5305e06ccc883bda3ab63b10b5",
"40fbe167bbe1280e42ecc34ce80779de",
"4ec969a032686f09de30ead2a801c018",
"534ca5b505ab9db617574eeab1bd8934",
"548ee6ca88a2bcff7d35ba0450b7ae7f",
"557d20358170b68bc9bedd9dfc46c82b",
"57ea44f19b74405f40baa45fc561493a",
"64363d34bd31a246f9ad52522ce1dd4d",
"6bf324274b0ba387f9143a0caa934a01",
"6c9464854ccfb363616adf31ac8b1120",
"7052790f352e0b66c5f5ceea1429da94",
"7172614405ccf04ee5ba891b726f6412",
"7c5810fa9eb432a1a1eae36e311adc32",
"81370e99b457dc7aa64a36b4a0696228",
"8aebf2fa38edb4e045dadb21ea6229f3",
"94f83f4f781923f19512152f584e34a1",
"9adb0a2d476ab62bdb3b0e7a31e5f0be",
"9c633102df50acc5507eafd0eecc6d6d",
"b8566c7bbdac337ff9153dbf85ee2ab6",
"ba316d8fd51cd2665ded7b20cd58c4d7",
"c24d6d52db4bba5909a999940d251c14",
"c388aef8e02d018ea7ac9cb0da7b9bd0",
"c712aed261879de46bc8989e36fe639b",
"c8bb250ce4ae8f1cb3003218719fbfd5",
"c8f4894c0ec2eb7697dd7a01cfcd163c",
"c95e1f378d4ed255e707ddd9ba204083",
"d14234136d6d332d9605d06a7a79a122",
"d215aedab5221382a37a177485268129",
"e4606d7480338d5ba194dff8a56aacf6",
"e6e9aead8a009cf3958c014a595a6d47",
"fc7c95e8a0c10edfec779479917546ca"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"product_slider_einsatz": 5.0,
"product_slider_terrain": 6.0,
"product_slider_ausstattung": 5.0,
"product_slider_e_bike": 0.0,
"product_minderest": 0.0,
"product_zubehora_article": "",
"product_click_and_collect": 0.0,
"product_store_available": 0.0,
"product_parent_article": 750173.1,
"product_vk2_amazon": 1799.0,
"product_vk3_ebay": 1799.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ghost Asket EQ lila 2023"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 999.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 839.5
},
"fields": {
"displayGroup": [
"12c8b94b22a5a23ff49409e443b6975f"
]
},
"sort": [
"ghost asket eq lila 2023"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|