| 1 |
3.35 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"term":{"manufacturerId":"abf9cd412ca678eaeb0c223c5106c6ab"}},{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"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": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "6dbd2699e8e7ec0047de2d5d1b28a75b",
"_score": null,
"_source": {
"id": "6dbd2699e8e7ec0047de2d5d1b28a75b",
"autoIncrement": 86511.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 27,
"productNumber": "3494",
"ean": "8713249243566",
"displayGroup": "b648c34bce8d1565ea8cd764a627ebde",
"sales": 0,
"stock": 27,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "abf9cd412ca678eaeb0c223c5106c6ab",
"manufacturerNumber": "050-31209",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:22+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"58a2fc6ed39fd083f55d4182bf88826d"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "58a2fc6ed39fd083f55d4182bf88826d",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "c46f875343df0c62551453bd6925040d",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "58a2fc6ed39fd083f55d4182bf88826d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "abf9cd412ca678eaeb0c223c5106c6ab",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXA"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"58a2fc6ed39fd083f55d4182bf88826d",
"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": 29.95,
"product_vk3_ebay": 29.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Axa Flex Befestigung f\u00fcr Defender\/Solid"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Die AXA Flex Mount sind 2 flexible Befestigungsleisten, mit denen ein Schloss einfach am Rahmen eines Fahrrades befestigt werden kann. Wenn keine Montagel\u00f6cher im Rahmen des Fahrrads vorhanden sind, um eine Ringsperre zu montieren, k\u00f6nnen diese flexiblen Streifen verwendet werden. Dar\u00fcber hinaus sind sie auch dann praktisch, wenn im Rahmen f\u00fcr einen Flaschenhalter keine L\u00f6cher im Rahmen sind, Sie aber dennoch einen Klappverschluss am Rahmen anbringen m\u00f6chten. Die Streifen passen auch auf verschiedene Rahmenrohre"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 11.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.04
},
"fields": {
"displayGroup": [
"b648c34bce8d1565ea8cd764a627ebde"
]
},
"sort": [
"axa flex befestigung f\u00fcr defender\/solid"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "7012ef0335aa2adbab58bd6d0702ba41",
"_score": null,
"_source": {
"id": "7012ef0335aa2adbab58bd6d0702ba41",
"autoIncrement": 86932.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 14,
"productNumber": "7077",
"ean": "8713249132327",
"displayGroup": "f566f87a7975aa5601d2924e664bc144",
"sales": 0,
"stock": 14,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "abf9cd412ca678eaeb0c223c5106c6ab",
"manufacturerNumber": "050-31241",
"releaseDate": null,
"createdAt": "2023-10-16T11:39:37+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": "877f7a17238e3c87fef24bbbfe5f2b3a",
"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": "abf9cd412ca678eaeb0c223c5106c6ab",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXA"
},
"_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": "",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 29.99,
"product_vk3_ebay": 29.99,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "AXA Rahmenschloss Defender RL"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Rahmenschloss, hochwertige Qualit\u00e4t, symmetrisches Design, die sichere Wegfahrsperre f\u00fcr den Zwischenstopp. Mit Plug-in Anschluss f\u00fcr Einsteckkabel und ketten zum doppelten Diebstahlschutz.Artikelbezeichnung: AXA Rahmenschloss Defender RL St\u00e4rke: 8,5 mmFarbe: schwarzGewicht: 640 g Technologie:- Korrosionsgesch\u00fctztes Stahlgeh\u00e4use- Geh\u00e4rteter Stahlb\u00fcgel von 8,5 mm \u00d8- Pr\u00e4zisionszylinder mit Schlagschutz gegen gewaltsames Aufbrechen- Stabile, patentierte Schl\u00fcssel (auch Klappschl\u00fcssel)- Mindestens 10.000 Schlie\u00dfungen- Sicherung gegen unabsichtliches Schlie\u00dfen w\u00e4hrend der Fahrt (Kindersicherung)- Niedrige Bauh\u00f6he, montierbar auch bei kleinen Rahmen, Kopfh\u00f6he 46 mm- Reifendurchlass Breite 50 mm- Gewicht 640 Gramm- Lange Lebensdauer durch ausgesuchte hochfeste und bew\u00e4hrte Materialien- Zus\u00e4tzliche Bohrung f\u00fcr die Schutzblechmontage- Schl\u00fcssel bei ge\u00f6ffnetem Schloss nicht abziehbar Wenn Sie diesen Artikel direkt mit einem Fahrrad kaufen, montieren wir Ihnen diesen direkt. "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 34.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 29.37
},
"fields": {
"displayGroup": [
"f566f87a7975aa5601d2924e664bc144"
]
},
"sort": [
"axa rahmenschloss defender rl"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|