| 1 |
5.73 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"should":[{"terms":{"productNumber":["2254","2255","2269","2282"]}}]}},{"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": "38651c4450f87348fcbe1f992746a954",
"_score": null,
"_source": {
"id": "38651c4450f87348fcbe1f992746a954",
"autoIncrement": 86485.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 17,
"productNumber": "2254",
"ean": "4003318724831",
"displayGroup": "8d5d680d570f6d4ff6aaea3336292fea",
"sales": 0,
"stock": 17,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "72483",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:16+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "3218217f1d7ac33e8e0ee4de2bbcac2a",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschl\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",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"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
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Steel-O-Chain 4804K\/75 schwarz"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " MIT EINEM KLICK AUTOMATISCH GESICHERTProfitieren Sie bei diesem Fahrradschloss von der praktischen Schlie\u00dfautomatik. Damit geht das Abschlie\u00dfen schnell und ganz ohne Schl\u00fcssel Das Kettenschloss Steel-O-Chain 4804K eignet sich besonders, wenn es schnell gehen soll. Durch den Automatikzylinder ben\u00f6tigen Sie zum Abschlie\u00dfen Ihres Fahrrades keinen Schl\u00fcssel mehr. Sie m\u00fcssen einfach das Schloss \u00f6ffnen und den Schlie\u00dfbolzen in den Schlossk\u00f6rper dr\u00fccken fertig. Das Fahrradschloss ist ideal zur Sicherung von g\u00fcnstigen R\u00e4dern und Kinderfahrr\u00e4dern bei einem niedrigen Diebstahlrisiko. - 4 mm starke Vierkantkette mit Textilschlauch zum Schutz vor Lacksch\u00e4den- Die Kette ist aus Spezialstahl gefertigt Produkt: Steel-O-Chain 4804KArtikelbezeichnung: 4804K\/75 BKArtikelbezeichnung: STEEL-O-CHAINSchlie\u00dfung: verschiedenschlie\u00dfendSecurity Level Bike: 4Anzahl mitgelieferte Schl\u00fcssel: inkl. 2 Schl\u00fcsselDesignfarbe: schwarzFacettenfarbe: schwarzHalter: ohne HalterL\u00e4nge [cm]: 75Gewicht [g]: 380Schlie\u00dftyp: Schl\u00fcsselSt\u00e4rke [mm]: 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": [
"8d5d680d570f6d4ff6aaea3336292fea"
]
},
"sort": [
24.95
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "51de85ddd068f0bc787691d356176df9",
"_score": null,
"_source": {
"id": "51de85ddd068f0bc787691d356176df9",
"autoIncrement": 86940.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 8,
"productNumber": "2269",
"ean": "4003318724879",
"displayGroup": "7398add91da6ca709078e85ca110c253",
"sales": 0,
"stock": 8,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "4bbd9c23e810a10a299357ea4c2b94ff",
"manufacturerNumber": "72487",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:39+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "99ef6d353087032bd2204a6f3ebdec5e",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschl\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",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"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
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abus Steel-O-Chain 4804K\/75 pink"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MIT EINEM KLICK AUTOMATISCH GESICHERTProfitieren Sie bei diesem Fahrradschloss von der praktischen Schlie\u00dfautomatik. Damit geht das Abschlie\u00dfen schnell und ganz ohne Schl\u00fcssel Das Kettenschloss Steel-O-Chain 4804K eignet sich besonders, wenn es schnell gehen soll. Durch den Automatikzylinder ben\u00f6tigen Sie zum Abschlie\u00dfen Ihres Fahrrades keinen Schl\u00fcssel mehr. Sie m\u00fcssen einfach das Schloss \u00f6ffnen und den Schlie\u00dfbolzen in den Schlossk\u00f6rper dr\u00fccken fertig. Das Fahrradschloss ist ideal zur Sicherung von g\u00fcnstigen R\u00e4dern und Kinderfahrr\u00e4dern bei einem niedrigen Diebstahlrisiko. - 4 mm starke Vierkantkette mit Textilschlauch zum Schutz vor Lacksch\u00e4den- Die Kette ist aus Spezialstahl gefertigt Produkt: Steel-O-Chain 4804KArtikelbezeichnung: 4804K\/75 PKArtikelbezeichnung: STEEL-O-CHAINSchlie\u00dfung: verschiedenschlie\u00dfendSecurity Level Bike: 4Anzahl mitgelieferte Schl\u00fcssel: inkl. 2 Schl\u00fcsselDesignfarbe: pinkFacettenfarbe: pinkHalter: ohne HalterL\u00e4nge [cm]: 75Gewicht [g]: 380Schlie\u00dftyp: Schl\u00fcsselSt\u00e4rke [mm]: 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": [
"7398add91da6ca709078e85ca110c253"
]
},
"sort": [
24.95
]
}
]
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|