| 1 |
5.35 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["3241","6928","7097"]}}]}},{"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": "993edc98ca87f7e08494eec37fa836f7",
"_score": null,
"_source": {
"id": "993edc98ca87f7e08494eec37fa836f7",
"autoIncrement": 87709.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 30,
"productNumber": "7097",
"ean": "4003318108742",
"displayGroup": "ae4282a3235300631ff97eff67826d0d",
"sales": 0,
"stock": 30,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "13400",
"releaseDate": null,
"createdAt": "2023-11-28T03:56:27+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"a2557a7b2e94197ff767970b67041697"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "a2557a7b2e94197ff767970b67041697",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "18017e93095545d1b194bc7549fb6399",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
},
{
"id": "a2557a7b2e94197ff767970b67041697",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Spiralkabelschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "4bbd9c23e810a10a299357ea4c2b94ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"a2557a7b2e94197ff767970b67041697"
],
"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": "",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_vk2_amazon": 29.95,
"product_vk3_ebay": 29.95,
"accessory_sorting_order": "6928|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Schloss Booster 6512K"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das Spiralkabelschloss Booster 6512K l\u00e4sst sich besonders einfach transportieren und ist vielseitig anwendbar. Mit diesem Fahrradschloss stehen Ihnen viele M\u00f6glichkeiten offen. Profitieren Sie von hochwertigen Materialien und der fortschrittlichen ABUS Technologie. Durch das 12 mm starke, hochwertige und superflexible Spiralkabel mit einer Gesamtl\u00e4nge von 180 cm l\u00e4sst sich Ihr Fahrrad bei Bedarf \u00fcberall anschlie\u00dfen. Genauso einfach gestaltet sich der Transport. Durch sein kompaktes Transportma\u00df kann das Spiralkabelschloss Booster 6512K schnell und unkompliziert in der Snap Cage Halterung am Fahrrad mitgef\u00fchrt werden. Wir empfehlen das Spiralkabelschloss Booster 6512K zur Absicherung Ihres g\u00fcnstigen Fahrrads. Einsatz und Anwendung- Guter Schutz bei niedrigem Diebstahlrisiko- Empfohlen f\u00fcr die Absicherung g\u00fcnstiger Zweir\u00e4der Technologie- 12 mm starkes, hochwertiges und superflexibles Spiralkabel- Kunststoffummantelung zum Schutz vor Lacksch\u00e4den Technische DatenProdukt: Booster 6512KSchlie\u00dftyp: Schl\u00fcsselAnzahl mitgelieferte Schl\u00fcssel: zwei Schl\u00fcssel inklusiveFacettenfarbe: schwarz|schwarzDesignfarbe: blackL\u00e4nge cm [cm]: 180St\u00e4rke [mm]: 12Halter: ohne HalterGewicht [g]: 531Security Level Bike: 4gleichschlie\u00dfend kombinierbar: Nein"
},
"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": [
"ae4282a3235300631ff97eff67826d0d"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "20c1945eae4b9868cbbfd09675f7d76e",
"_score": null,
"_source": {
"id": "20c1945eae4b9868cbbfd09675f7d76e",
"autoIncrement": 86462.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 2317,
"productNumber": "6928",
"ean": "4003318396991",
"displayGroup": "3330f2edab40c55080b35caa64dff3f4",
"sales": -2,
"stock": 2317,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "050-31670",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:06+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"31fefc0e570cb3860f2a6d4b38c6490d"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf8d73d1473e78a327f363d52be83",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rahmenschl\u00f6sser"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "4bbd9c23e810a10a299357ea4c2b94ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"31fefc0e570cb3860f2a6d4b38c6490d",
"9872ed9fc22fc182d371c3e9ed316094"
],
"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": 32.95,
"product_vk3_ebay": 32.95,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Rahmenschloss Pro Shield"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " St\u00e4rke: 8,5 mmGewicht: 770 gTechnologie:- 8,5 mm starker Verriegelungsb\u00fcgel- Der B\u00fcgel, das Geh\u00e4use sowie tragende Teile des Verriegelungsmechanismus sind aus speziell geh\u00e4rtetem Stahl gefertigt- ABUS push'n lock der patentierte Verschlussmechanismus zum einfachen Anschlie\u00dfen von Zubeh\u00f6r- Extra gro\u00dfer Raddurchlauf- ABUS Automatikzylinder mit bedienerfreundlichem Wendeschl\u00fcssel- Zwei Schl\u00fcssel im Lieferumfang enthalten Einsatz und Anwendung:- Guter Schutz bei mittlerem Diebstahlrisiko- Empfohlen f\u00fcr die Absicherung guter Zweir\u00e4der Transport:- LH - Einfache Befestigung durch Anschrauben an den Hinterbaustreben"
},
"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": [
"3330f2edab40c55080b35caa64dff3f4"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "a64bd53139f71961c5c31a9af03d775e",
"_score": null,
"_source": {
"id": "a64bd53139f71961c5c31a9af03d775e",
"autoIncrement": 86475.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 39,
"productNumber": "3241",
"ean": "4003318785955",
"displayGroup": "eecbbebd6b71cff255e2a8d00875ce1c",
"sales": 0,
"stock": 39,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "31493",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:12+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"9dcb88e0137649590b755372b040afad"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "9dcb88e0137649590b755372b040afad",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "2661f0d620b2be62f0d219b02ebfbab9",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
},
{
"id": "9dcb88e0137649590b755372b040afad",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kabelschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "4bbd9c23e810a10a299357ea4c2b94ff",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"9dcb88e0137649590b755372b040afad"
],
"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": 39.95,
"product_vk3_ebay": 39.95,
"accessory_sorting_order": "3208|6928|9531"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Centuro 860\/85 QS RBU"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " DAS DUO F\u00dcR DOPPELTE SICHERHEITDieses ABUS Spiralkabelschloss sorgt durch einen doppelten Schutz, in Form eines robusten Stahlkabels und \u00fcberlappenden Stahlh\u00fclsen, f\u00fcr doppelte Sicherheit. Dieses ABUS Fahrradschloss macht Fahrraddieben das Stehlen besonders schwer. Das Spiralkabelschloss Steel-O-Flex Centuro 860 besteht aus 20 mm starken, sich \u00fcberlappenden Stahlh\u00fclsen aus speziell geh\u00e4rtetem Stahl, die das innenliegende Stahlkabel ummanteln und so f\u00fcr doppelte Sicherheit sorgen. Ein Durchtrennen des Kabels ist dadurch wesentlich schwerer, als bei einem einfachen Kabelschloss. Wir empfehlen die Anwendung des Steel-O-Flex Centuro 860 vor allem f\u00fcr die Absicherung guter Fahrr\u00e4der und als Schutz in Gebieten mit einem mittleren Diebstahlrisiko. Einsatz und Anwendung- Guter Schutz bei mittlerem Diebstahlrisiko- Empfohlen f\u00fcr die Absicherung guter Zweir\u00e4der- Je gr\u00f6\u00dfer das L\u00e4ngenma\u00df, umso einfacher das Anschlie\u00dfen an einen festen Gegenstand Technologie- 20 mm starke, \u00fcberlappende Stahlh\u00fclsen sch\u00fctzen das innenliegende Stahlkabel- Kunststoffummantelung zum Schutz vor Lacksch\u00e4den- Die Stahlh\u00fclsen sowie tragende Teile des Verriegelungsmechanismus sind aus speziell geh\u00e4rtetem Stahl gefertigt Technische DatenProdukt: Centuro 860Schlie\u00dftyp: Schl\u00fcsselAnzahl mitgelieferte Schl\u00fcssel: zwei Schl\u00fcssel inklusiveFacettenfarbe: schwarzDesignfarbe: blackSt\u00e4rke [mm]: 20L\u00e4nge cm [cm]: 85Halter: mit HalterHalterung: QuickSnap RBUGewicht [g]: 825Security Level Bike: 7gleichschlie\u00dfend kombinierbar: Nein"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 54.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 46.18
},
"fields": {
"displayGroup": [
"eecbbebd6b71cff255e2a8d00875ce1c"
]
},
"sort": [
54.95
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|