| 1 |
26.54 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"56ebfbd98f92f90704f38a00be40420e"}},{"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": "4e477793df9bdde030226dcd3a262a4a",
"_score": null,
"_source": {
"id": "4e477793df9bdde030226dcd3a262a4a",
"autoIncrement": 86738.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 10,
"productNumber": "4023",
"ean": "4048174130303",
"displayGroup": "dd9ea97dfbff378d8b6bbdd21a875e25",
"sales": 0,
"stock": 10,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "56ebfbd98f92f90704f38a00be40420e",
"manufacturerNumber": "050-20595",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:34+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9fc3d7152ba9336a670e36d0ed79bc43",
"02522a2b2726fb0a03bb19f2d8d9524d"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9fc3d7152ba9336a670e36d0ed79bc43",
"_count": 1
},
{
"id": "02522a2b2726fb0a03bb19f2d8d9524d",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "c07fe96e38bf225354d35548543e040f",
"childCount": 0,
"categories": [
{
"id": "02522a2b2726fb0a03bb19f2d8d9524d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K\u00f6rbe"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9fc3d7152ba9336a670e36d0ed79bc43",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K\u00f6rbe & Taschen"
}
}
],
"manufacturer": {
"id": "56ebfbd98f92f90704f38a00be40420e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Racktime"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"02522a2b2726fb0a03bb19f2d8d9524d",
"28dd2c7955ce926456240b2ff0100bde",
"9fc3d7152ba9336a670e36d0ed79bc43"
],
"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": "Montage4",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 39.9,
"product_vk3_ebay": 39.9
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Racktime Korb Trunk 28 Liter"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F\u00fcr die gro\u00dfe Shopping- Tour:Unglaubliche 28 Liter Fassungsverm\u00f6gen! Dank des serienm\u00e4\u00dfig vorinstallierten SNAPit-Systemadapters ist auch Ihr gro\u00dfer Einkauf sicher mit Ihrem racktime-Tr\u00e4ger verbunden -mit einem Klick. Eine Schultasche passt \u00fcbrigens auch locker rein. Adaptersystem: SnapitH\u00f6he: 20 cmBreite: 30 cmTiefe: 51 cm Produktdetails:Produktart: Hinterrad-Korb Belastbarkeit: 10 kg Herstellerfarbe: schwarz Ma\u00dfe: 200 x 300 x 510 mm Material: Draht Volumen: 28 Liter Gewicht: 1.700 g "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 69.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 58.78
},
"fields": {
"displayGroup": [
"dd9ea97dfbff378d8b6bbdd21a875e25"
]
},
"sort": [
"racktime korb trunk 28 liter"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "c6335734dbc0b1ded766421cfc611750",
"_score": null,
"_source": {
"id": "c6335734dbc0b1ded766421cfc611750",
"autoIncrement": 86733.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 10,
"productNumber": "2106",
"ean": "4048174170170",
"displayGroup": "b73bdfd3084ede8c9fbbc327c72d91f2",
"sales": 0,
"stock": 10,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "56ebfbd98f92f90704f38a00be40420e",
"manufacturerNumber": "050-20170",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:33+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9fc3d7152ba9336a670e36d0ed79bc43",
"8d5e957f297893487bd98fa830fa6413"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9fc3d7152ba9336a670e36d0ed79bc43",
"_count": 1
},
{
"id": "8d5e957f297893487bd98fa830fa6413",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "d8d704b6737479356f4b21ff553339b4",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "8d5e957f297893487bd98fa830fa6413",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "9fc3d7152ba9336a670e36d0ed79bc43",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "K\u00f6rbe & Taschen"
}
}
],
"manufacturer": {
"id": "56ebfbd98f92f90704f38a00be40420e",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Racktime"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"8d5e957f297893487bd98fa830fa6413",
"9fc3d7152ba9336a670e36d0ed79bc43"
],
"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": 4.99,
"product_vk3_ebay": 4.99,
"accessory_sorting_order": "2122|7076"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Racktime Snap it Adapter verstellbar"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Der Snapit-Adapter ist das patentierte Herzst\u00fcck der racktime Produktlinie. Er verbindet K\u00f6rbe, Taschen und andere Beh\u00e4lter mit dem Gep\u00e4cktr\u00e4ger.Sobald der Adapter auf den Gep\u00e4cktr\u00e4ger aufgesetzt und leicht nach vorne geschoben wird, rastet er mit einem \"Klick\" im Tr\u00e4ger ein.Hebt man den Ausl\u00f6sehebel an, kann der Adapter mit einem Griff einfach vom Tr\u00e4ger getrennt werden. Den Snapit -Systemadapter gibt es auch einzeln. Der Phantasie sind daher keine Grenzen gesetzt - alles, was mit muss, kann aufgeschraubt werden. SnapIT-Adapter!Mit einem Klick dran. Solide und sicher. Meit einem HAndgriff gel\u00f6st. Genial einfach. Egal, was Sie mitnehmen m\u00f6chten: SnapIT dranschrauben- funktioniert! Befestigungsset ist im Lieferumfang enthalten. Belastbarkeit max. 12 kg. Produktdetails:Material: KunststoffTragf\u00e4higkeit: 12 KgHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.76
},
"fields": {
"displayGroup": [
"b73bdfd3084ede8c9fbbc327c72d91f2"
]
},
"sort": [
"racktime snap it adapter verstellbar"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|