| 1 |
6.03 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":"f7e6c85504ce6e82442c770f7c8606f0"}}}},{"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": 1,
"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": "17ae6739cdbe8fda7dbf9d8a18bb6de0",
"_score": null,
"_source": {
"id": "17ae6739cdbe8fda7dbf9d8a18bb6de0",
"autoIncrement": 94985.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 17,
"productNumber": "11617",
"ean": null,
"displayGroup": "d39355e1439ffecb3a7b3c220bbc5ac9",
"sales": 0,
"stock": 17,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "007e03b50ca2dd06cfee5c8a2abbfc95",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2026-03-17T00:14:37+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"b73ce398c39f506af761d2277d853a92",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf924ff9e7351b83fe916cd768ccf",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unisex"
}
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel"
}
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking"
}
}
],
"manufacturer": {
"id": "007e03b50ca2dd06cfee5c8a2abbfc95",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"b73ce398c39f506af761d2277d853a92",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": [],
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Selle Royal Sattel Respiro Soft Moderate"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Der Respiro bietet absoluten Komfort, der sich sowohl f\u00fcr das Pendeln in der Stadt als auch f\u00fcr das Fahren in der Freizeit eignet und f\u00fcr frischen Wind sorgt. Durch den einzigartigen Bel\u00fcftungskanal, der die Luftzirkulation f\u00f6rdert und den Druck im Dammbereich mindert, sorgt der Respiro f\u00fcr erfrischendes, k\u00fchles Fahrgef\u00fchl. Das innovative Obermaterial des Respiro reflektiert Sonnenstrahlen, um die Oberfl\u00e4chentemperatur zu senken. Die Royalgel-Polsterung bietet optimalen Halt und passt sich den Bewegungen des K\u00f6rpers an, w\u00e4hrend sto\u00dfd\u00e4mpfende Elastomere Unebenheiten auf der Stra\u00dfe abfedern.Einsatzbereich: TrekkingGewicht: 535 gL\u00e4nge: 277 mmBreite: 182 mmFarbe: schwarzPolster: GelExtras: ICS-Clip System - kompatibel mit sBox und Lookin-Satteltaschen und BlinklichtRESPIRO:RESPIRO ist die Linie f\u00fcr den anspruchsvollen Radfahrer. Die S\u00e4ttel verf\u00fcgen \u00fcber eine innovative k\u00fchlende Decke und einen Ventilationskanal, der zudem die Druckbelastung auf den Genitalbereich reduziert. MODERATE:Der Moderate-Fahrer sitzt in der Regel mit einem Wirbels\u00e4ulenwinkel von 60 Grad auf dem Sattel. "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 79.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 64.72
},
"fields": {
"displayGroup": [
"d39355e1439ffecb3a7b3c220bbc5ac9"
]
},
"sort": [
0,
"17ae6739cdbe8fda7dbf9d8a18bb6de0"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "1eaa260fddcc15e3c1f09453b8d5bd92",
"_score": null,
"_source": {
"id": "1eaa260fddcc15e3c1f09453b8d5bd92",
"autoIncrement": 81765.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 12,
"productNumber": "9467",
"ean": "4711946198114",
"displayGroup": "6c6ef2c0ca991991ac58812066c0af27",
"sales": 0,
"stock": 12,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "96c388341791599bd705a51696b2a005",
"manufacturerNumber": "061-30790",
"releaseDate": null,
"createdAt": "2023-10-16T11:12:16+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"140f6969d5213fd0ece03148e62e461e",
"b73ce398c39f506af761d2277d853a92",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1
},
{
"id": "1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"_count": 1
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": "eeebd92dadc008d3ce94764f8ddaa96a",
"coverId": "4ae93da80ed49cff5a2050c6d38b887c",
"childCount": 0,
"categories": [
{
"id": "140f6969d5213fd0ece03148e62e461e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel & Sattelst\u00fctzen"
}
},
{
"id": "1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "City"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "a4a042cf4fd6bfb47701cbc8a1653ada",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Unisex"
}
},
{
"id": "b73ce398c39f506af761d2277d853a92",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S\u00e4ttel"
}
},
{
"id": "f7e6c85504ce6e82442c770f7c8606f0",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Trekking"
}
}
],
"manufacturer": {
"id": "96c388341791599bd705a51696b2a005",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comodoro"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
},
{
"id": "99d7c131edb365a2cf0febee56bee7c1",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S"
}
}
],
"options": [
{
"id": "99d7c131edb365a2cf0febee56bee7c1",
"_count": 1,
"groupId": "e682e5d097523765cde5e59df6139363",
"group": {
"id": "e682e5d097523765cde5e59df6139363",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "S"
}
}
],
"categoryIds": [
"140f6969d5213fd0ece03148e62e461e",
"1ff8a7b5dc7a7d1f0ed65aaa29c04b1e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"a4a042cf4fd6bfb47701cbc8a1653ada",
"b73ce398c39f506af761d2277d853a92",
"f7e6c85504ce6e82442c770f7c8606f0"
],
"optionIds": [
"99d7c131edb365a2cf0febee56bee7c1"
],
"propertyIds": [
"3a616a5305e06ccc883bda3ab63b10b5",
"99d7c131edb365a2cf0febee56bee7c1"
],
"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": 9467.1,
"product_vk2_amazon": 59.95,
"product_vk3_ebay": 59.95
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Comodoro Hydro Foam"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Die neue Sattellinie Comodoro wird exclusiv f\u00fcr die ZEG produziert. Entwickelt vom Produktmanagement der ZEG. Das Modell Comodoro wird in 3 Gr\u00f6\u00dfen angeboten. So findet jeder Fahrertyp den passenden Sattel. S 163mm Breite \/ 275mm L\u00e4ngeM 195mm Breite \/ 266mm L\u00e4ngeL 220mm Breite \/ 270mm L\u00e4nge Hydrofoam (high density foam)Nach einem langen Entwicklungszeitraum haben wir eine optimale L\u00f6sung gefunden welche mit einer einzigartigen Formel das richtige Ma\u00df an Druckentlastung, Halt und Sto\u00dfd\u00e4mpfung bietet. Hydrofoam erm\u00f6glicht es das sich das Polster perfekt an die Anatomie des Fahrers anpasst und trotzdem den ben\u00f6tigten Halt bietet. Kombiniert mit der Arctech Federung wird ein maximum an Komfort f\u00fcr Ganztagsausfl\u00fcge generiert. Stufensattel DesignDurch die tiefer liegende Sattelnase wird wertvoller Platz f\u00fcr die sensiblen Bereiche von Frau und Mann erzeugt. Dadurch k\u00f6nnen Druckbeschwerden und Taubheitsgef\u00fchle eliminiert werden. ArcTechArcTech passt sich intuitiv den Bewegungen des Fahrers an. Die patentierte ArchTech Sattelstrebentechnologie erm\u00f6glicht eine verbesserte Flexibilit\u00e4t sowie eine zus\u00e4tzliche D\u00e4mpfung Produktdetails:Polster: HydrofoamBefestigung: Patentsattelst\u00fctzeL\u00e4nge: 275 mmBreite: 163 mmH\u00f6he: 86 mmHerstellerfarbe: schwarzHerstellerfarbe: schwarz"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 39.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 33.61
},
"fields": {
"displayGroup": [
"6c6ef2c0ca991991ac58812066c0af27"
]
},
"sort": [
0,
"1eaa260fddcc15e3c1f09453b8d5bd92"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
3.46 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":"f7e6c85504ce6e82442c770f7c8606f0"}}}},{"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
|