| 1 |
5.41 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"fe9fc289c3ff0af142b6d3bead98a923"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"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": {
"total": {
"value": 4,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "4f81b1d964419548f01ca35bbaeeda75",
"_score": null,
"_source": {
"id": "4f81b1d964419548f01ca35bbaeeda75",
"autoIncrement": 86686.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 14,
"productNumber": "4035",
"ean": "4002556871437",
"displayGroup": "3b35c3104d3f9457a3302805b752578e",
"sales": 3,
"stock": 14,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "d978e353f0df4f240453e1f3727c98a7",
"manufacturerNumber": "070-50512",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:17+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"43ec517d68b6edd3015b3edc9a11367b",
"c5ff2543b53f4cc0ad3819a36752467b",
"fe9fc289c3ff0af142b6d3bead98a923"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "c5ff2543b53f4cc0ad3819a36752467b",
"_count": 1
},
{
"id": "fe9fc289c3ff0af142b6d3bead98a923",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "7852b6408ced79e3133ebfb94378c07f",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beleuchtung & Elektronik"
}
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Anbauteile"
}
},
{
"id": "c5ff2543b53f4cc0ad3819a36752467b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Klick-Systeme"
}
},
{
"id": "fe9fc289c3ff0af142b6d3bead98a923",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Komplett-Sets"
}
}
],
"manufacturer": {
"id": "d978e353f0df4f240453e1f3727c98a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"6855456e2fe46a9d49d3d3af4f57443d",
"c5ff2543b53f4cc0ad3819a36752467b",
"fe9fc289c3ff0af142b6d3bead98a923"
],
"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": "Montage4",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": "",
"product_vk2_amazon": 24.95,
"product_vk3_ebay": 24.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink Beleuchtungsset Recharge 30 Lux"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Wiederaufladbar mit USB Schnittstelle an den LeuchtenGewicht Scheinwerfer: 99g Gewicht R\u00fccklicht: 49gMa\u00dfe Vorne: 80x45x45 mm Ma\u00dfe Hinten: 90x25x38 mm80 Lumen Zubeh\u00f6r: MonkeyLink Vorbau und MonkeyLink Sattelklemme n\u00f6tig (nicht im Lieferumfang enthalten) Auch herk\u00f6mmliche Fahrr\u00e4der profitieren von der smarten Verbindung. Mit nur wenigen Einzelteilen ist eine Nachr\u00fcstung auf den neuen MonkeyLink Standard jederzeit problemlos m\u00f6glich. Wie beim E-Bike werden die Komponenten \u00fcber den Magnetkontakt verbunden und mit einem Klick arretiert. Komponenten der Recharge Serie werden in diesem Fall \u00fcber den internen Akku mit Strom versorgt und k\u00f6nnen \u00fcber einen USB-Anschluss bequem geladen werden. Produktdetails:Leuchtst\u00e4rke: 30 Lux Energie-Quelle: Akku Artikel-Bezeichnung: Beleuchtungsset Leuchtmittel: LED Herstellerfarbe: schwarz "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 67.22
},
"fields": {
"displayGroup": [
"3b35c3104d3f9457a3302805b752578e"
]
},
"sort": [
3,
"4f81b1d964419548f01ca35bbaeeda75"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "3e1fb9297735057d44263e674078a7fd",
"_score": null,
"_source": {
"id": "3e1fb9297735057d44263e674078a7fd",
"autoIncrement": 87720.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 7,
"productNumber": "10218",
"ean": "4002556917616",
"displayGroup": "010030058bfee06d02fd09520fadc098",
"sales": 0,
"stock": 7,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "d978e353f0df4f240453e1f3727c98a7",
"manufacturerNumber": "070-50523",
"releaseDate": null,
"createdAt": "2024-01-15T09:37:36+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"fe9fc289c3ff0af142b6d3bead98a923",
"8dd48d6a2e2cad213179a3992c0be53c"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "fe9fc289c3ff0af142b6d3bead98a923",
"_count": 1
},
{
"id": "8dd48d6a2e2cad213179a3992c0be53c",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "069f283ad34890982a70281747be634c",
"coverId": "98e83eed84fe446675cb72d2a138d449",
"childCount": 0,
"categories": [
{
"id": "8dd48d6a2e2cad213179a3992c0be53c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike"
}
}
],
"manufacturer": {
"id": "d978e353f0df4f240453e1f3727c98a7",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink"
},
"_count": 1
},
"properties": [
{
"id": "d8c0c89bc82e91d5e8e0d655a92a3a9b",
"_count": 1,
"groupId": "8c3a6cae85e651f3632548508cda27fc",
"group": {
"id": "8c3a6cae85e651f3632548508cda27fc",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100 Lux"
}
}
],
"options": [
{
"id": "d8c0c89bc82e91d5e8e0d655a92a3a9b",
"_count": 1,
"groupId": "8c3a6cae85e651f3632548508cda27fc",
"group": {
"id": "8c3a6cae85e651f3632548508cda27fc",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "100 Lux"
}
}
],
"categoryIds": [
"8dd48d6a2e2cad213179a3992c0be53c"
],
"optionIds": [
"d8c0c89bc82e91d5e8e0d655a92a3a9b"
],
"propertyIds": [
"d8c0c89bc82e91d5e8e0d655a92a3a9b"
],
"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": "Montage4",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_parent_article": 3943.1,
"product_vk2_amazon": 24.95,
"product_vk3_ebay": 24.95,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink Beleuchtungsset Connect S"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mit diesem Beleuchtungs-Set (Frontscheinwerfer & sportives R\u00fccklicht) aus der Connect-Serie verwandeln Sie Ihr E-MTB in ein stra\u00dfentaugliches E-Bike. Magnetisch mit dem ML-Interface verbunden und \u00fcber die intuitive Arretierung fixiert. Versorgt mit Energie aus dem E-Bike-Akku und steuerbar \u00fcber das Display, entsteht dank MonkeyLink eine einfache und innovative Verbindung zwischen Bike und Beleuchtungs-Set. In Sekundenschnelle k\u00f6nnen die Leuchten an allen mit MonkeyLink Schnittstellen ausgestatteten E-Bikes angebracht werden und mit einem Druck auf den BlueButton genauso schnell wieder entfernt werden. Ein unbeabsichtigtes L\u00f6sen w\u00e4hrend der Fahrt ist dank der innovativen Kombination aus magnetischer F\u00fchrung, mechanischer Arretierung und elektrischer Kontaktierung nicht m\u00f6glich. MonkeyLink kann auchnachger\u00fcstet werden! Produktdetails:Leuchtst\u00e4rke: 100 LuxLeuchtmittel: LEDEnergie-Quelle: E-Bike-AkkuHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 139.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 117.61
},
"fields": {
"displayGroup": [
"010030058bfee06d02fd09520fadc098"
]
},
"sort": [
0,
"3e1fb9297735057d44263e674078a7fd"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
12.10 ms |
Request:
{"index":"shopware6-stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"nested":{"path":"visibilities","query":{"bool":{"must":[{"range":{"visibilities.visibility":{"gte":30}}},{"term":{"visibilities.salesChannelId":"01895226670e72a4a15f371adce297ad"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"fe9fc289c3ff0af142b6d3bead98a923"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","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}}}},"rating-exists":{"filter":{"range":{"ratingAverage":{"gte":0.0}}},"aggregations":{"rating":{"max":{"field":"ratingAverage"}}}},"shipping-free-filter":{"filter":{"term":{"shippingFree":true}},"aggregations":{"shipping-free":{"max":{"field":"shippingFree"}}}},"properties":{"nested":{"path":"properties"},"aggregations":{"properties":{"terms":{"field":"properties.id","size":10000}}}},"options":{"nested":{"path":"options"},"aggregations":{"options":{"terms":{"field":"options.id","size":10000}}}}},"size":0,"timeout":"5s"},"search_type":"query_then_fetch"}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|