| 1 |
3.14 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"f78833b45c46f32d5922a036b06062a0"}},{"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": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "b628386c9b92481fab68fbf284bd6a64",
"_score": null,
"_source": {
"id": "b628386c9b92481fab68fbf284bd6a64",
"autoIncrement": 86949.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 33,
"productNumber": "2714",
"ean": "8715019701719",
"displayGroup": "e6e1d5db702403642facef281e712fdc",
"sales": 0,
"stock": 33,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "f78833b45c46f32d5922a036b06062a0",
"manufacturerNumber": "051-21607",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:42+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": "1c8e90159740c11573cf9544969c82cd",
"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": "f78833b45c46f32d5922a036b06062a0",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Basil"
},
"_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": 0.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 15.99,
"product_vk3_ebay": 15.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Basil Adapterplatte MIK"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das MIK-System passt auf fast alle Gep\u00e4cktr\u00e4ger. Man verwendet die MIK Adapterplatte in der Kombination mit einem Gep\u00e4cktr\u00e4ger mit dem MIK-System. Wenn Sie aber (noch) kein Fahrrad mit einem Gep\u00e4cktr\u00e4ger haben, der mit dem integrierten MIK-System ausgestattet ist, dann k\u00f6nnen Sie die MIK-Tr\u00e4gerplatte verwenden. Die MIK-Tr\u00e4gerplatte k\u00f6nnen Sie dann ganz einfach auf Ihrem Gep\u00e4cktr\u00e4ger montieren. Mit der MIK-Adapterplatte k\u00f6nnen verschiedene Zubeh\u00f6rteile, K\u00f6rbe und Taschen in 1 Sekunde befestigt werden. Auch das Abnehmen und Mitnehmen dieser Teile funktioniert wegen der MIK-Adapterplatte rasend schnell. Mit dem MIK-System ist so ein Auswechseln besonders einfach. MIK ADAPTER PLATE, Adapterplatte, inkl. Schl\u00fcssel zum sichern vom Fahrradzubeh\u00f6r, geeignet f\u00fcr abnehmbares Fahrradzubeh\u00f6r, geeignet f\u00fcr Gep\u00e4cktr\u00e4ger, versehen mit dem MIK System oder der MIK Carrier plate (NICHT INBEGRIFFEN), geeignet f\u00fcr elektrische Fahrr\u00e4der, schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 21.0
},
"fields": {
"displayGroup": [
"e6e1d5db702403642facef281e712fdc"
]
},
"sort": [
"basil adapterplatte mik"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "ac2460b56866901d732f996b82b69d31",
"_score": null,
"_source": {
"id": "ac2460b56866901d732f996b82b69d31",
"autoIncrement": 86512.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 33,
"productNumber": "5479",
"ean": "8715019111167",
"displayGroup": "faee84dc752a5cce814b6870d931b2ec",
"sales": 0,
"stock": 33,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "f78833b45c46f32d5922a036b06062a0",
"manufacturerNumber": "050-20565",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:22+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": "8cd4cd4497fe813484a0a77a7d1e6c6c",
"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": "f78833b45c46f32d5922a036b06062a0",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Basil"
},
"_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": 21.99,
"product_vk3_ebay": 21.99
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "BASIL Schultaschenkorb Cento"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Material: Stahl HR, engmaschig - HR-Schultaschenkorb- Stahl- engmaschig- feste Montage auf Gep\u00e4cktr\u00e4ger (inkl. Befestigungsmaterial), abgeschr\u00e4gt, stabiler Rahmen, - Korb wird in Fahrtrichtung befestigt, - Oberm: 42x32cm, - schwarz "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 27.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 23.52
},
"fields": {
"displayGroup": [
"faee84dc752a5cce814b6870d931b2ec"
]
},
"sort": [
"basil schultaschenkorb cento"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|