| 1 |
6.61 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["5479","7068","7069"]}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":10}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}}]}}]}},"sort":[{"_script":{"type":"number","script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule01894ed2c3f9725883fd3e2c980adaaa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c3fe723e9e7e6790bb62adc1_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c63170738ac1fb06e2f9a3cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01894ed2c40b73e7a27925fdb16701ab_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b2915dc11756f9ae3331d8b23bde5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344c883071bc80a3509bc4043140_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344d56317c42bf44bb7336973244_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b344f5ba07d9a98b86c5bc7d1410a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b34500e857ae3ab1cffcf1594d77b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38dcb139726da7e7f62faff160fa_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018b38e14e777e389a388cd9175c40cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bae1d69bc75b1aa820316abe211f2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018bd73f09d7705595baff2c8cf92203_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c15b8de9c709599df768cb6a224be_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018c19f988aa7cf1ba8f9463cb39048a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01975ef38cc573348c70ad29f503bcd5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019d0b19e2617d48a24a92ca989c6dd2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee44e6782c64247b796b891cf25ae38f7_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1}],"decimals":100,"round":true,"multiplier":100.0}},"order":"ASC"}}],"from":0,"size":24,"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": {
"max_score": null,
"hits": [
{
"_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": [
27.99
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "83187550749e6b8024a097630f9d4722",
"_score": null,
"_source": {
"id": "83187550749e6b8024a097630f9d4722",
"autoIncrement": 90595.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "7069",
"ean": "4022556914912",
"displayGroup": "fb05d86e19bda427804a225cea0c6b7f",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "fc17ba798be771a65da45080f486c387",
"manufacturerNumber": "11567",
"releaseDate": null,
"createdAt": "2024-07-17T06:33:47+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"41ae36ecb9b3eee609d05b90c14222fb",
"9b04d152845ec0a378394003c96da594",
"be83ab3ecd0db773eb2dc1b0a17836a1"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "41ae36ecb9b3eee609d05b90c14222fb",
"_count": 1
},
{
"id": "9b04d152845ec0a378394003c96da594",
"_count": 1
},
{
"id": "be83ab3ecd0db773eb2dc1b0a17836a1",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf94df9f273738aef0b82e4ec3de8",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "41ae36ecb9b3eee609d05b90c14222fb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Gep\u00e4cktr\u00e4ger & Schutzbleche"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
},
{
"id": "9b04d152845ec0a378394003c96da594",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schutzbleche"
}
},
{
"id": "be83ab3ecd0db773eb2dc1b0a17836a1",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "abnehmbar"
}
}
],
"manufacturer": {
"id": "fc17ba798be771a65da45080f486c387",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKS"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"41ae36ecb9b3eee609d05b90c14222fb",
"6855456e2fe46a9d49d3d3af4f57443d",
"9b04d152845ec0a378394003c96da594",
"be83ab3ecd0db773eb2dc1b0a17836a1"
],
"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": "Montage1",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_vk2_amazon": 5.5,
"product_vk3_ebay": 5.5,
"accessory_sorting_order": 7167.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SKS Speedrocker Set"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Schutzblech-Set mit Streben und Doppelspoiler-Funktion Ready to rock the Gravel! Das SKS Schutzblech SPEEDROCKER aus schlagfestem Hochleistungskunststoff wurde speziell f\u00fcr Gravelbikes, Cyclocrosser und Rennr\u00e4der mit Disk Brakes entwickelt. Ein besonderes Feature ist die Doppelspoiler-Funktion am Vorderradschutz, der mit gummierten Klett-Straps befestigt wird. Der Hinterradschutz garantiert durch sein ausziehbares Verl\u00e4ngerungsprofil ebenfalls einen perfekten Spritzschutz und wird mit stabilen Gummistraps fixiert. Flexibles Halterungssystem f\u00fcr jede Geometrie Das Halterungssystem mit flexiblen Flaps l\u00e4sst sich f\u00fcr jede Geometrie am Rahmen befestigen. Integrierte Unterlaufstreben mit ESC Vario-Sicherheitssystem sorgen zudem nicht nur f\u00fcr einen cleanen Look, sondern auch f\u00fcr mehr Freiraum zwischen Radschutz und Reifen. Aus schlagfestem Hochleistungskunststoff Doppelspoiler-Funktion vorne Ausziehbares Verl\u00e4ngerungsprofil hinten Ideal f\u00fcr Gravelbikes und Rennr\u00e4der mit Scheibenbremsen Made in GermanyMaterial: KunststoffFarbe: schwarzGewicht: 408 gRadgr\u00f6\u00dfe: 27,5\" (650b)\", 28 \"Reifenbreite in Zoll: 0.9\"-1.65\"Reifenbreite in mm: 23-42 mmRadschutzl\u00e4nge vorne: 500+210 mmRadschutzl\u00e4nge hinten: 950 mm "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 59.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 50.41
},
"fields": {
"displayGroup": [
"fb05d86e19bda427804a225cea0c6b7f"
]
},
"sort": [
59.99
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|