| 1 |
4.76 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["2276","3118","11305","W1"]}}]}},{"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": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "1e9944dfac1eac7a602d65620b492a48",
"_score": null,
"_source": {
"id": "1e9944dfac1eac7a602d65620b492a48",
"autoIncrement": 86898.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 99,
"productNumber": "W1",
"ean": null,
"displayGroup": "88413a8a96b016af68ded9b842a51a56",
"sales": 0,
"stock": 99,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2023-10-16T11:39:25+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"819f46e52c25763a55cc642422644317",
"e4a6222cdb5b34375400904f03d8e6a5"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1
},
{
"id": "e4a6222cdb5b34375400904f03d8e6a5",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "ac2de7d8969e6e2c5748c0acf00919ef",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge, Pflege & N\u00fctzliches"
}
},
{
"id": "e4a6222cdb5b34375400904f03d8e6a5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Werkzeuge"
}
}
],
"manufacturer": {
"id": "fa246d0262c3925617b0c72bb20eeb1d",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"819f46e52c25763a55cc642422644317",
"e4a6222cdb5b34375400904f03d8e6a5"
],
"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": 0.0,
"product_vk2_amazon": 12.98,
"product_vk3_ebay": 12.98,
"accessory_sorting_order": "6924|7271",
"fts_shipping_price_price": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": null,
"net": null,
"linked": true
}
]
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad-Werkzeug f\u00fcr Lenker & Pedale"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrrad Werkzeug folgende Artikel sind enthalten: Konusschl\u00fcssel\/Maulschl\u00fcssel Gr\u00f6\u00dfe: 15 mm Material: Kunststoff und Stahl Innensechskantschl\u00fcssel Gr\u00f6\u00dfe: 4-6 mm Material: Stahl sonstiges: komfortabler Gummigriff"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.6
},
"fields": {
"displayGroup": [
"88413a8a96b016af68ded9b842a51a56"
]
},
"sort": [
14.99
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "f0031c7a91d74015a9addfbc589f3fe5",
"_score": null,
"_source": {
"id": "f0031c7a91d74015a9addfbc589f3fe5",
"autoIncrement": 86456.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 7,
"productNumber": "3118",
"ean": "4016224071609",
"displayGroup": "4d976c91496e51a8b12c1c8e8ed9f246",
"sales": 0,
"stock": 7,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "9a29c5277361e6bb969ec5dbbc61fba2",
"manufacturerNumber": "050-24701",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:05+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"d1f491a404d6854880943e5c3cd9ca25",
"1afa34a7f984eeabdbb0a7d494132ee5"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "d1f491a404d6854880943e5c3cd9ca25",
"_count": 1
},
{
"id": "1afa34a7f984eeabdbb0a7d494132ee5",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "3e51b135b16c6e3f936d4fa088ceb351",
"childCount": 0,
"categories": [
{
"id": "1afa34a7f984eeabdbb0a7d494132ee5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "mit Kabel"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "d1f491a404d6854880943e5c3cd9ca25",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Computer & Navigation"
}
}
],
"manufacturer": {
"id": "9a29c5277361e6bb969ec5dbbc61fba2",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sigma"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"1afa34a7f984eeabdbb0a7d494132ee5",
"28dd2c7955ce926456240b2ff0100bde",
"d1f491a404d6854880943e5c3cd9ca25"
],
"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": "Montage1",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 18.95,
"product_vk3_ebay": 18.95,
"accessory_sorting_order": "2122|7076"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sigma Computer BC 7.16"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Einsteigermodell - Viel Display, wenig Geh\u00e4useDer BC 7.16 zeigt neben den Basisfunktionen auch die Gesamtfahrzeit und die Durchschnittsgeschwindigkeit an. Ein gro\u00dfes Display verpackt in einem sportlichen Design machen ihn zum unverzichtbaren Tourenbegleiter. Das Design der TOPLINE 2016 ist vertikal orientiert und passt mit dem schlanken Design optimal auf den Lenkervorbau. Die neue Form erm\u00f6glicht verbesserte Darstellungsm\u00f6glichkeiten der Funktionen. So ist z.B. die Geschwindigkeit beim BC 7.16 gro\u00df und permanent in dem dreizeiligen Display sichtbar. Artikelbezeichnung: Sigma Computer BC 7.16Fahrrad-Funktionen: Aktuelle Geschwindigkeit- Automatischer Start\/Stopp- Durchschnittsgeschwindigkeit Tageskilometer GesamtkilometerZeit-Funktionen:- Fahrzeit- Gesamtfahrzeit \/ Gesamttrainingszeit- Trainingszeit- Uhrzeit (12\/24)Geh\u00e4use:- 50 mm x 38,5 mm x 10,2 mm (HxBxT)Display:- 27 mm x 35 mm (HxB)"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.97
},
"fields": {
"displayGroup": [
"4d976c91496e51a8b12c1c8e8ed9f246"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "998f28b5baa9b34f23eaf2e08ed2d63c",
"_score": null,
"_source": {
"id": "998f28b5baa9b34f23eaf2e08ed2d63c",
"autoIncrement": 81837.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 19,
"productNumber": "11305",
"ean": "4003318672644",
"displayGroup": "865aa40a5f1aa5ecb788cf2a77d00df3",
"sales": 0,
"stock": 19,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "67264",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:20+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"35f4a8d465e6e1edc05f3d8ab658c551",
"f7664060cc52bc6f3d620bcedc94a4b6"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "35f4a8d465e6e1edc05f3d8ab658c551",
"_count": 1
},
{
"id": "f7664060cc52bc6f3d620bcedc94a4b6",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "60634e9e788fec0b8d4d0f5512d70ad6",
"coverId": "679aef94a920fbb645d3509ca7e9bee1",
"childCount": 0,
"categories": [
{
"id": "35f4a8d465e6e1edc05f3d8ab658c551",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Helme"
}
},
{
"id": "f7664060cc52bc6f3d620bcedc94a4b6",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinder- & Jugendhelme"
}
}
],
"manufacturer": {
"id": "4bbd9c23e810a10a299357ea4c2b94ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "84f86c88f742acdbfc13a2dd1fb8fd36",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50-55 cm"
}
}
],
"options": [
{
"id": "84f86c88f742acdbfc13a2dd1fb8fd36",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "50-55 cm"
}
}
],
"categoryIds": [
"35f4a8d465e6e1edc05f3d8ab658c551",
"f7664060cc52bc6f3d620bcedc94a4b6"
],
"optionIds": [
"84f86c88f742acdbfc13a2dd1fb8fd36"
],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5",
"84f86c88f742acdbfc13a2dd1fb8fd36"
],
"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": 0.0,
"product_parent_article": 11304.1,
"product_vk2_amazon": 34.95,
"product_vk3_ebay": 34.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Smiley 3.0 blue croco"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Technologie In-Mold f\u00fcr eine dauerhafte Verbindung der Au\u00dfenschale mit dem sto\u00dfabsorbierendem Helmmaterial (EPS) Helm erstreckt sich bis in den Schl\u00e4fen- und Nackenbereich f\u00fcr einen besseren Rundumschutz H\u00f6henverstellbares Verstellsystem mit Pferdeschwanzkompatibilit\u00e4t f\u00fcr Fahrer mit l\u00e4ngerem Haar Zoom Ace Kids - h\u00f6henverstellbares Verstellsystem mit rutschfestem Verstellrad am Hinterkopf Die Gr\u00f6\u00dfeneinstellung erfolgt \u00fcber einen Ring aus robustem und flexiblem Kunststoff f\u00fcr optimale Stabilit\u00e4t und Anpassungsf\u00e4higkeit Hervorragende Bel\u00fcftung mit 4 Lufteinl\u00e4ssen und 4 Luftausl\u00e4ssen Herausnehmbare und waschbare Polsterung f\u00fcr maximalen Tragekomfort Integriertes Fliegennetz Passive Sicherheit durch Reflektoren Technische DatenProdukt: Smiley 3.0R\u00fccklicht: NeinKopfumfang [cm]: 50-55Designfarbe: blue crocoFacettenfarbe: blau|gr\u00fcnGr\u00f6\u00dfe: MGewicht [g]: 240"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.57
},
"fields": {
"displayGroup": [
"865aa40a5f1aa5ecb788cf2a77d00df3"
]
},
"sort": [
39.95
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|