| 1 |
9.92 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"91482384d112f0bc50ff8a825706d70f"}},{"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": 1,
"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": "db9eeb7e678863649bce209842e0d164",
"_score": null,
"_source": {
"id": "db9eeb7e678863649bce209842e0d164",
"autoIncrement": 88302.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 8,
"productNumber": "2314",
"ean": "9328389027793",
"displayGroup": "d6612eaa5db3065bde00076d095f6316",
"sales": 0,
"stock": 8,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "91482384d112f0bc50ff8a825706d70f",
"manufacturerNumber": "12111KN",
"releaseDate": null,
"createdAt": "2024-03-29T11:23:34+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf9386c9e71f1ac3743d2aed77129",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Glocken & Klingeln"
}
}
],
"manufacturer": {
"id": "91482384d112f0bc50ff8a825706d70f",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_vk2_amazon": 19.99,
"product_vk3_ebay": 19.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog Oi Classic large, schwarz matt"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Die Kult-Klingel von Knog wurde f\u00fcr 2021 wesentlich \u00fcberarbeitet, ohne dabei ihre Einzigartigkeit zu verlieren. Als Neuerung wurde der Hammer verkleinert und verst\u00e4rkt sowie eine k\u00fcrzere und h\u00e4rte Feder verbaut, was nicht nur f\u00fcr eine gr\u00f6\u00dfere Stabilit\u00e4t sondern auch f\u00fcr ein lauteres Klingeln sorgt. So erreicht die neue Knog Oi Classic eine durchschnittliche Lautst\u00e4rke von 85 Dezibel und ist somit auch f\u00fcr den Einsatz an E-Bikes freigegeben. Knog Oi Classic Fahrradklingel- Ringf\u00f6rmige Fahrradklingel in eigenst\u00e4ndigem, elegantem Design- Lenkerdurchmesser: large (23.8-31.8mm)- Material: 7075er Aluminium und verst\u00e4rkter Nylonkunststoff- NEU: Verst\u00e4rkter, verkleinerter Hammer sowie k\u00fcrzere, h\u00e4rtere Feder- NEU: 85 Dezibel Lautst\u00e4rke, f\u00fcr E-Bike Einsatz freigegeben- Aussparung an der Klemmung f\u00fcr Kabel- Breite: 15mm- Gewicht: 25g (large) "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.8
},
"fields": {
"displayGroup": [
"d6612eaa5db3065bde00076d095f6316"
]
},
"sort": [
"knog oi classic large, schwarz matt"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "69dafe8b58066478aea48f3d0f384820",
"_score": null,
"_source": {
"id": "69dafe8b58066478aea48f3d0f384820",
"autoIncrement": 87030.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 9,
"productNumber": "2312",
"ean": "9328389026611",
"displayGroup": "3f0bde34bc34fb1ad45586c1d2a8f9d7",
"sales": 0,
"stock": 9,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "91482384d112f0bc50ff8a825706d70f",
"manufacturerNumber": "11978KN",
"releaseDate": null,
"createdAt": "2023-10-16T11:40:07+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "50508862d439a121b0bf0246d8e6ed1b",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Glocken & Klingeln"
}
}
],
"manufacturer": {
"id": "91482384d112f0bc50ff8a825706d70f",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.99,
"product_vk3_ebay": 19.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog Oi Classic, Messing"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Knog hat mit der Oi das Design der Klingel f\u00fcr Fahrr\u00e4der revolutioniert. Sie l\u00e4sst sich mit ihrem eigenst\u00e4ndigen und eleganten Design auf dem Lenker montieren und f\u00e4llt dabei nicht allzu sehr auf, wie man es von anderen Fahrradklingeln kennt. Die integrierte Aussparung kann als Kabelf\u00fchrung f\u00fcr Bremsleitungen oder Schaltz\u00fcge dienen. Ringf\u00f6rmige Fahrradklingel in eigenst\u00e4ndigem, elegantem Design Aussparung an der Klemmung f\u00fcr Kabel Durchmesser Variante Small: Innen: 22.2mm \/ Au\u00dfen: 37.5mm Breite der Klingel: 15mm Gewicht: 18g Material: Aluminium "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.8
},
"fields": {
"displayGroup": [
"3f0bde34bc34fb1ad45586c1d2a8f9d7"
]
},
"sort": [
"knog oi classic, messing"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "49c0b9d84c2a16fcaf9d25694fda75e1",
"_score": null,
"_source": {
"id": "49c0b9d84c2a16fcaf9d25694fda75e1",
"autoIncrement": 86662.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 15,
"productNumber": "2310",
"ean": "9328389026598",
"displayGroup": "2836bb49f6aff0d596cf50b7291b0565",
"sales": 0,
"stock": 15,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "91482384d112f0bc50ff8a825706d70f",
"manufacturerNumber": "11976KN",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:09+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "875b7e1fe6cfb5fcb99be6573ddbea1b",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
},
{
"id": "a4f23670e1833f3fdb077ca70bbd5d66",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Glocken & Klingeln"
}
}
],
"manufacturer": {
"id": "91482384d112f0bc50ff8a825706d70f",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"a4f23670e1833f3fdb077ca70bbd5d66"
],
"optionIds": [],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 19.99,
"product_vk3_ebay": 19.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Knog Oi Classic, schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Knog hat mit der Oi das Design der Klingel f\u00fcr Fahrr\u00e4der revolutioniert. Sie l\u00e4sst sich mit ihrem eigenst\u00e4ndigen und eleganten Design auf dem Lenker montieren und f\u00e4llt dabei nicht allzu sehr auf, wie man es von anderen Fahrradklingeln kennt. Die integrierte Aussparung kann als Kabelf\u00fchrung f\u00fcr Bremsleitungen oder Schaltz\u00fcge dienen. Ringf\u00f6rmige Fahrradklingel in eigenst\u00e4ndigem, elegantem Design Aussparung an der Klemmung f\u00fcr Kabel Durchmesser Variante Small: Innen: 22.2mm \/ Au\u00dfen: 37.5mm Breite der Klingel: 15mm Gewicht: 18g Material: Aluminium "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.8
},
"fields": {
"displayGroup": [
"2836bb49f6aff0d596cf50b7291b0565"
]
},
"sort": [
"knog oi classic, schwarz"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|