| 1 |
14.55 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"c2779de71eb9ff9181eaf02891e93bce"}},{"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": "90968598e1b1d4ae4838f0ad8e39bf11",
"_score": null,
"_source": {
"id": "90968598e1b1d4ae4838f0ad8e39bf11",
"autoIncrement": 86665.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "10294",
"ean": "4260649040225",
"displayGroup": "da4b17c7e2e4a00477ad066c7803e5da",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "c2779de71eb9ff9181eaf02891e93bce",
"manufacturerNumber": "23210512000",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:11+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"289dff07669d7a23de0ef88d2f7129e7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "7a8cf7c1f1b540c20219be2de15d102c",
"childCount": 0,
"categories": [
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradspiegel"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
}
],
"manufacturer": {
"id": "c2779de71eb9ff9181eaf02891e93bce",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"289dff07669d7a23de0ef88d2f7129e7",
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 8.99,
"product_vk3_ebay": 8.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe KF Cross"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "- schnell einklappbar- gro\u00dfe, konvexe Spiegelfl\u00e4che = gr\u00f6\u00dferer Blickwinkel- steigert die Verkehrssicherheit, da man den r\u00fcckw\u00e4rtigen Verkehr im Blick behalten kann- einfache und schnelle Montage- kein Verkratzen von lackierten Lenkern- beim Klappen des Spiegels bleibt die Justierung bestehen und es ist kein m\u00fchsames neues Einstellen erforderlich- nur links verwendbar"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.61
},
"fields": {
"displayGroup": [
"da4b17c7e2e4a00477ad066c7803e5da"
]
},
"sort": [
"krampe kf cross"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "37f2fc94430a30d7dba690d94d7e1223",
"_score": null,
"_source": {
"id": "37f2fc94430a30d7dba690d94d7e1223",
"autoIncrement": 86666.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 32,
"productNumber": "10293",
"ean": "4260649040201",
"displayGroup": "a618bdac28c3ac0f0d71767380c0d2ea",
"sales": 0,
"stock": 32,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "c2779de71eb9ff9181eaf02891e93bce",
"manufacturerNumber": "23210512000",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:11+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"289dff07669d7a23de0ef88d2f7129e7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "91caef99a4b10ce957be77734332f324",
"childCount": 0,
"categories": [
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradspiegel"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
}
],
"manufacturer": {
"id": "c2779de71eb9ff9181eaf02891e93bce",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"289dff07669d7a23de0ef88d2f7129e7",
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 8.99,
"product_vk3_ebay": 8.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe KF Sport"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "- schnell einklappbar- gro\u00dfe, konvexe Spiegelfl\u00e4che = gr\u00f6\u00dferer Blickwinkel- steigert die Verkehrssicherheit, da man den r\u00fcckw\u00e4rtigen Verkehr im Blick behalten kann- einfache und schnelle Montage- kein Verkratzen von lackierten Lenkern- beim Klappen des Spiegels bleibt die Justierung bestehen und es ist kein m\u00fchsames neues Einstellen erforderlich- nur links verwendbar"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.33
},
"fields": {
"displayGroup": [
"a618bdac28c3ac0f0d71767380c0d2ea"
]
},
"sort": [
"krampe kf sport"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "cf011ff8d8380280133bce806e0f7bb1",
"_score": null,
"_source": {
"id": "cf011ff8d8380280133bce806e0f7bb1",
"autoIncrement": 86664.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 12,
"productNumber": "8316",
"ean": "4260649040003",
"displayGroup": "8ee55d98867f879fac95fa669013d792",
"sales": 0,
"stock": 12,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "c2779de71eb9ff9181eaf02891e93bce",
"manufacturerNumber": "050-23394",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:10+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"289dff07669d7a23de0ef88d2f7129e7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "7f988dff7b3a5dd7218e0300aced9c18",
"childCount": 0,
"categories": [
{
"id": "289dff07669d7a23de0ef88d2f7129e7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradspiegel"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
}
],
"manufacturer": {
"id": "c2779de71eb9ff9181eaf02891e93bce",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"289dff07669d7a23de0ef88d2f7129e7",
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 8.99,
"product_vk3_ebay": 8.99,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Krampe Spiegel KF 1 klappbar"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Clou des neuen klappbaren Systems steckt im Fu\u00df des Spiegels. Durch eine einfache Drehbewegung kann der Fahrradspiegel eingeklappt werden. So st\u00f6rt er nicht beim Abstellen des Rades im Fahrradst\u00e4nder und wird auch beim Umfallen des Fahrrades nicht zerst\u00f6rt. Das Rad kann platzsparend abgestellt werden und ist so auch f\u00fcr engere Fahrradboxen geeignet, ohne dass der Spiegel abmontiert werden muss. Beim Ausklappen des Spiegels bleibt die bisherige Justierung bestehen und es ist kein m\u00fchsames neues Einstellen der bisherigen Justierung erforderlich. Eine einfache Drehbewegung in die entgegengesetzte Richtung reicht und schon ist der klappbare Fahrradspiegel zur\u00fcck in der gewohnten Einstellung. Durch das neue System gestaltet sich auch der Transport des Fahrrades auf einem Fahrradtr\u00e4ger deutlich komfortabler, da kein Werkzeug ben\u00f6tigt wird, um den Spiegel am Zielort wieder richtig einzustellen. Produktdetails:Material: Aluminium Herstellerfarbe: schwarz "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.53
},
"fields": {
"displayGroup": [
"8ee55d98867f879fac95fa669013d792"
]
},
"sort": [
"krampe spiegel kf 1 klappbar"
]
}
]
},
"aggregations": {
"total-count": {
"value": 3
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|