| 1 |
6.06 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["6924","7271"]}}]}},{"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_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": 3,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "4e246a381baf2ce038b3b0f82c7d6fb4",
"_score": null,
"_source": {
"id": "4e246a381baf2ce038b3b0f82c7d6fb4",
"autoIncrement": 86467.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 723,
"productNumber": "6924",
"ean": "4003318112584",
"displayGroup": "683367759c4b6caa5c63b9617597ce17",
"sales": 0,
"stock": 723,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "496 LH NKR",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:08+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": "233ea7fe02cd72a4cae3414108b59b1a",
"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_vk2_amazon": 21.95,
"product_vk3_ebay": 21.95,
"accessory_sorting_order": "3241|6928|7097",
"fts_shipping_price_price": [
{
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca",
"gross": null,
"net": null,
"linked": true
}
]
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Rahmenschloss Tectic 496"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " St\u00e4rke: 8,5 mmGewicht: 490 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- Extra gro\u00dfer Raddurchlauf- ABUS Automatikzylinder- Zwei Schl\u00fcssel im Lieferumfang enthalten Einsatz und Anwendung:- Guter Schutz bei niedrigem Diebstahlrisiko- Empfohlen f\u00fcr die Absicherung g\u00fcnstiger Zweir\u00e4der Transport:- LH - Einfache Befestigung an den HinterbaustrebenTipps:- Rahmenschl\u00f6sser sind ein leicht und schnell zu bedienender Schutz gegen unbefugte Benutzung des Rades- Besonders empfehlenswert ist auch die Nutzung eines Zweitschlosses neben dem Rahmenschloss- Das Schloss ist nur in der Version NKR erh\u00e4ltlich, das bedeutet der Schl\u00fcssel kann abgezogen werden, wenn das Schloss ge\u00f6ffnet ist"
},
"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": [
"683367759c4b6caa5c63b9617597ce17"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "52fc2aee802efbad698503d28ebd3a1f",
"_score": null,
"_source": {
"id": "52fc2aee802efbad698503d28ebd3a1f",
"autoIncrement": 86470.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 24,
"productNumber": "7271",
"ean": "4003318134142",
"displayGroup": "936f459ce49b76660d0d1cd14d10a771",
"sales": 0,
"stock": 24,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "13415",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:10+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": "ca5f52d5cf36456a7ad3bf21ffc699d5",
"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": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"a2557a7b2e94197ff767970b67041697"
],
"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": 29.95,
"product_vk3_ebay": 29.95,
"accessory_sorting_order": "7097|9531"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ABUS Tresor 6512C\/180"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " EINFACH, SICHER, PREISG\u00dcNSTIGDas Spiralkabelschloss Tresor 6512C ist der richtige Begleiter, wenn Sie Ihr Fahrrad preisg\u00fcnstig und gut sichern m\u00f6chten. Das Innenleben dieses ABUS Fahrradschlosses besteht aus einem 12 mm starken und superflexiblen Spiralkabel. Die schwarze Ummantelung ist aus Kunststoff hergestellt und sch\u00fctzt den Fahrradlack vor m\u00f6glichen Kratzern. Der vierstellige Zahlencode, der zum \u00d6ffnen des Schlosses ben\u00f6tigt wird, ist individuell einstellbar. So k\u00f6nnen Sie ganz einfach Ihre Lieblingszahlen verwenden. Au\u00dferdem eignet sich ein ABUS Zahlenschloss besonders gut, wenn das Schloss von mehreren Personen genutzt werden soll. 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 2-Komponenten Zahlenwalzen gew\u00e4hrleisten dauerhafte Lesbarkeitder Ziffern Zahlencode individuell einstellbar Technische DatenProdukt: Tresor 6512CSchlie\u00dftyp: ZahlenkombinationSchlie\u00dfung: einstellbare ZahlenkombinationAnzahl mitgelieferte Schl\u00fcssel: ohne Schl\u00fcsselFacettenfarbe: schwarz|schwarzDesignfarbe: blackL\u00e4nge cm [cm]: 180St\u00e4rke [mm]: 12Halter: ohne HalterGewicht [g]: 549Security Level Bike: 4"
},
"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": [
"936f459ce49b76660d0d1cd14d10a771"
]
},
"sort": [
24.95
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|