| 1 |
7.90 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":"138bb0696595b338afbab333c555292a"}}}},{"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": 4,
"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": "1c7836dbabd12c458d20e3b35633733a",
"_score": null,
"_source": {
"id": "1c7836dbabd12c458d20e3b35633733a",
"autoIncrement": 90604.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 7,
"productNumber": "14356",
"ean": "4006021013605",
"displayGroup": "ee00d441d4998a1fea0fc7a4c1bae385",
"sales": 0,
"stock": 7,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "10d0307c115143ebe421263971751a20",
"manufacturerNumber": "070-30622",
"releaseDate": null,
"createdAt": "2024-07-17T06:37:01+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"c7e1249ffc03eb9ded908c236bd1996d",
"138bb0696595b338afbab333c555292a"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "c7e1249ffc03eb9ded908c236bd1996d",
"_count": 1
},
{
"id": "138bb0696595b338afbab333c555292a",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf94eba9873aa908a92b5cab2a77e",
"childCount": 0,
"categories": [
{
"id": "138bb0696595b338afbab333c555292a",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beleuchtung & Elektronik"
}
},
{
"id": "c7e1249ffc03eb9ded908c236bd1996d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R\u00fccklicht"
}
}
],
"manufacturer": {
"id": "10d0307c115143ebe421263971751a20",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Busch & M\u00fcller"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"138bb0696595b338afbab333c555292a",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"c7e1249ffc03eb9ded908c236bd1996d"
],
"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": 49.9,
"product_vk3_ebay": 49.9
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Busch & M\u00fcller Toplight Line Brez"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Das R\u00fccklicht mit Bremslicht und Notbremslicht-FunktionDie integrierte Sensorik erkennt jeden Bremsvorgang. Daraufhin leuchtet der Lichtstreifen sehr hell und deutlich auf, um nachfolgenden Verkehrsteilnehmenden die Verlangsamung zu signalisieren. NEU: Im Falle einer abrupten Vollbremsung schaltet das Bremslicht eine weitere Stufe rauf in die hell pulsierende Notbremslicht-Funktion. In diesem Modus vermittelt BREX die Gefahrensituation mit einer nie dagewesenen Signalwirkung und beugt Unf\u00e4llen vor. Praktisch: BREX funktioniert automatisch. Anders als bei bisherigen Brems-R\u00fccklichtern muss keine separate Kabelverbindung zum Bremshebel hergestellt werden. Wie alle unsere R\u00fccklichter: StVZO-zugelassen. Dieses R\u00fccklicht besitzt zus\u00e4tzlich die franz\u00f6sische Freigabe.- Mit Brems- und Notbremslichtfunktion- Sensortechnik: Keine Verbindung zur Bremse n\u00f6tig- Gep\u00e4cktr\u00e4germontage (50 mm)- F\u00fcr Gleichspannungsbetrieb 6-50 V- Integrierter Z-Gro\u00dffl\u00e4chenr\u00fcckstrahlerAbmessungen: (L x B x H): 94 x 45 x 16,5 mmBefestigung: am Gep\u00e4cktr\u00e4ger Bolzenabstand 50 mmBremslichtfunktion: jaLeuchtmittel: LEDStromversorgung: E-Bike AkkuNettogewicht: 53 gStVZO-Zulassung: ja\u00dcberspannungsschutz: ja"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 49.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 41.93
},
"fields": {
"displayGroup": [
"ee00d441d4998a1fea0fc7a4c1bae385"
]
},
"sort": [
0,
"1c7836dbabd12c458d20e3b35633733a"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "6df182582740607da754e4515b70e32d",
"_score": null,
"_source": {
"id": "6df182582740607da754e4515b70e32d",
"autoIncrement": 86685.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 10,
"productNumber": "3948",
"ean": "4002556871390",
"displayGroup": "b5b58477b56c08dbd55ec9042f794bdd",
"sales": 0,
"stock": 10,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "d978e353f0df4f240453e1f3727c98a7",
"manufacturerNumber": "070-50506",
"releaseDate": null,
"createdAt": "2023-10-16T11:38:17+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"c7e1249ffc03eb9ded908c236bd1996d",
"138bb0696595b338afbab333c555292a"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1
},
{
"id": "c7e1249ffc03eb9ded908c236bd1996d",
"_count": 1
},
{
"id": "138bb0696595b338afbab333c555292a",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "c103362c804286977dbe533163a16faa",
"childCount": 0,
"categories": [
{
"id": "138bb0696595b338afbab333c555292a",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "E-Bike"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "43ec517d68b6edd3015b3edc9a11367b",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Beleuchtung & Elektronik"
}
},
{
"id": "c7e1249ffc03eb9ded908c236bd1996d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "R\u00fccklicht"
}
}
],
"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": [
"138bb0696595b338afbab333c555292a",
"28dd2c7955ce926456240b2ff0100bde",
"43ec517d68b6edd3015b3edc9a11367b",
"c7e1249ffc03eb9ded908c236bd1996d"
],
"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,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "MonkeyLink R\u00fccklicht Connect"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Gewicht: 39g Ma\u00dfe: 90x25x38 mm Zubeh\u00f6r: MonkeyLink Sattelklemme n\u00f6tig (ist nicht im Lieferumfang enthalten)Mit wenigen Clicks verwandelt sich ein sportives E-Mountainbike in ein alltagstaugliches Fahrzeug f\u00fcr den t\u00e4glichen Gebrauch und umgekehrt. Magnetisch mit dem BlueDock verbunden und \u00fcber die intuitive Arretierung fixiert, sorgen Beleuchtungskomponenten und Radsch\u00fctzer mit integriertem R\u00fccklicht f\u00fcr Sicherheit im Stra\u00dfenverkehr. Ein unbeabsichtigtes L\u00f6sen w\u00e4hrend der Fahrt ist ausgeschlossen. Versorgt mit Energie aus dem E-Bike-Akku und steuerbar \u00fcber das Display, entsteht dank MonkeyLink die wohl einfachste und innovativste Verbindung zwischen Bike und Bauteil. In Sekundenschnelle angebracht, k\u00f6nnen die Komponenten mit einem Druck auf den BlueButton genauso schnell wieder entfernt werden. MonkeyLink funktioniert mit allen g\u00e4ngigen E-Bike-Antrieben von BOSCH, BROSE, SHIMANO UND SR SUNTOUR. Produktdetails: Energie-Quelle: E-Bike-Akku Leuchtmittel: LED Artikel-Bezeichnung: R\u00fccklicht Farbe: schwarz "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 32.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 27.72
},
"fields": {
"displayGroup": [
"b5b58477b56c08dbd55ec9042f794bdd"
]
},
"sort": [
0,
"6df182582740607da754e4515b70e32d"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.49 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":"138bb0696595b338afbab333c555292a"}}}},{"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
|