| 1 |
5.20 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["7097","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_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": "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": "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
|