| 1 |
4.99 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"23b6de7768165ef9a6879887b1e709b4"}},{"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": 3,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "6e96be832cf8bc6b35a956e8fb66c76a",
"_score": null,
"_source": {
"id": "6e96be832cf8bc6b35a956e8fb66c76a",
"autoIncrement": 86590.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 6,
"productNumber": "6852",
"ean": "4260416640061",
"displayGroup": "3c24c1cf26c0fdbfcee5b1133337d5b1",
"sales": 0,
"stock": 6,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "23b6de7768165ef9a6879887b1e709b4",
"manufacturerNumber": "DSL",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:47+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"0bb4aec1710521c12ee76289d9440817"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "0bb4aec1710521c12ee76289d9440817",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "78e7cea77411e83b85cb545b360a8910",
"childCount": 0,
"categories": [
{
"id": "0bb4aec1710521c12ee76289d9440817",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike Zubeh\u00f6r"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
}
],
"manufacturer": {
"id": "23b6de7768165ef9a6879887b1e709b4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"0bb4aec1710521c12ee76289d9440817",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d"
],
"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": "",
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 5.99,
"product_vk3_ebay": 5.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin Display Schutz\/Tasche"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Das DISPLAY SLEEVE ist eine kleine Tasche f\u00fcr Display und Bordcomputer. Sie passt sich allen Gr\u00f6\u00dfen an und ist mit einem weichen Innenfutter versehen, um so das Display gegen Kratzer und Besch\u00e4digungen optimal zu sch\u00fctzen. Das DISPLAY SLEEVE kann w\u00e4hrend der Fahrt am Rahmenrohr befestigt werden. So brauchen Sie keine Extratasche daf\u00fcr und es bleibt sofort einsatzbereit. Features:- robustes Au\u00dfenmaterial- weiches Futter- f\u00fcr verschiedene Displaygr\u00f6\u00dfen zu benutzen- max. Ma\u00dfe 15 x 9 x 1,9 cm (L x B x Tiefe)"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 5.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 4.2
},
"fields": {
"displayGroup": [
"3c24c1cf26c0fdbfcee5b1133337d5b1"
]
},
"sort": [
"fahrer berlin display schutz\/tasche"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "f26ecc6e3bc7f5e9c8cf23a7c7a315dd",
"_score": null,
"_source": {
"id": "f26ecc6e3bc7f5e9c8cf23a7c7a315dd",
"autoIncrement": 88054.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "6853",
"ean": "00068536",
"displayGroup": "dafdf4ef3d693609d028ccaeae788041",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "23b6de7768165ef9a6879887b1e709b4",
"manufacturerNumber": "RUC",
"releaseDate": null,
"createdAt": "2024-02-20T06:47:26+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"819f46e52c25763a55cc642422644317",
"357a6fdf7642bf815a88822c447d9dc4",
"cb70ab375662576bd1ac5aaf16b3fca4"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "cb70ab375662576bd1ac5aaf16b3fca4",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "bf7e1e9b5b20c6bb95d6899b04c7e9ff",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge, Pflege & N\u00fctzliches"
}
},
{
"id": "cb70ab375662576bd1ac5aaf16b3fca4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N\u00fctzliches Fahrradzubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "23b6de7768165ef9a6879887b1e709b4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"819f46e52c25763a55cc642422644317",
"cb70ab375662576bd1ac5aaf16b3fca4"
],
"optionIds": [],
"propertyIds": [],
"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_vk2_amazon": 5.9,
"product_vk3_ebay": 5.9,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin Schutz Bedieneinheit"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Universeller Kappe aus elastischem Zellkautschuk zur Abdeckung von Lenkerfernbedienungen und Minidisplays wie BOSCH Purion. Sch\u00fctzt vor Witterung, Einfrieren, Schmutz und Besch\u00e4digung. Geeignet als Schutz beim Abstellen des Rades im Freien oder w\u00e4hrend des Transports am Auto. Auch ideal zum Schutz des Kontaktsockels bei abnehmbaren Displays. Geeignet f\u00fcr Bosch eBike Systems, Shimano Steps, Yamaha eBike Systems und andere. Features: Material: kaschiertes Neopren Farbe: schwarz Befestigung: mittels Klettverschluss"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 7.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 6.71
},
"fields": {
"displayGroup": [
"dafdf4ef3d693609d028ccaeae788041"
]
},
"sort": [
"fahrer berlin schutz bedieneinheit"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "69dca86777abc0b6d673fc08252f827e",
"_score": null,
"_source": {
"id": "69dca86777abc0b6d673fc08252f827e",
"autoIncrement": 86904.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 14,
"productNumber": "6853a",
"ean": null,
"displayGroup": "3b872605b8bbe421682f2b5da29fb070",
"sales": 0,
"stock": 14,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "23b6de7768165ef9a6879887b1e709b4",
"manufacturerNumber": "RUC",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:28+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"0bb4aec1710521c12ee76289d9440817"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "0bb4aec1710521c12ee76289d9440817",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "b203f88198badd5a619f44ec44749246",
"childCount": 0,
"categories": [
{
"id": "0bb4aec1710521c12ee76289d9440817",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike Zubeh\u00f6r"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
}
],
"manufacturer": {
"id": "23b6de7768165ef9a6879887b1e709b4",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"0bb4aec1710521c12ee76289d9440817",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d"
],
"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": 0.0,
"product_click_and_collect": 1.0,
"product_store_available": 1.0,
"product_parent_article": "",
"product_vk2_amazon": 5.99,
"product_vk3_ebay": 5.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrer Berlin Schutz Bedieneinheit"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Universeller Kappe aus elastischem Zellkautschuk zur Abdeckung von Lenkerfernbedienungen und Minidisplays wie BOSCH Purion. Sch\u00fctzt vor Witterung, Einfrieren, Schmutz und Besch\u00e4digung. Geeignet als Schutz beim Abstellen des Rades im Freien oder w\u00e4hrend des Transports am Auto. Auch ideal zum Schutz des Kontaktsockels bei abnehmbaren Displays. Geeignet f\u00fcr Bosch eBike Systems, Shimano Steps, Yamaha eBike Systems und andere. Features: Material: kaschiertes Neopren Farbe: schwarz Befestigung: mittels Klettverschluss"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.11
},
"fields": {
"displayGroup": [
"3b872605b8bbe421682f2b5da29fb070"
]
},
"sort": [
"fahrer berlin schutz bedieneinheit"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|