| 1 |
6.69 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":"3b8a614226a953a8cd9526fca6fe9ba5"}}}},{"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": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "49f85a9ed090b20c8bed85a5923c669f",
"_score": null,
"_source": {
"id": "49f85a9ed090b20c8bed85a5923c669f",
"autoIncrement": 87210.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "9381",
"ean": null,
"displayGroup": "461710a50261548135026cc3b15bf930",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e87b2ad973028e550ad31b7a41d32df1",
"manufacturerNumber": "HAM553013",
"releaseDate": null,
"createdAt": "2023-10-16T11:41:07+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"3b8a614226a953a8cd9526fca6fe9ba5"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "3b8a614226a953a8cd9526fca6fe9ba5",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "81c3b9e7382dbc09da9efa79c9aeb54f",
"childCount": 0,
"categories": [
{
"id": "3b8a614226a953a8cd9526fca6fe9ba5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kindersitze"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "e87b2ad973028e550ad31b7a41d32df1",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hamax"
},
"_count": 1
},
"properties": [
{
"id": "4eee70ed64219d5914eb3cf6d1c61506",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
}
],
"options": [],
"categoryIds": [
"3b8a614226a953a8cd9526fca6fe9ba5",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"4eee70ed64219d5914eb3cf6d1c61506"
],
"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": 164.9,
"product_vk3_ebay": 164.9
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hamax Caress Carrier Adapter schwarz-grau\/rot"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mit dem Gep\u00e4cktr\u00e4ger-Adapter sind die hinten montierten Caress-Fahrradsitze f\u00fcr fast alle Fahrr\u00e4der einsetzbar. F\u00fcr die steigende Zahl an Elektrofahrr\u00e4dern und andere Fahrr\u00e4der mit Rahmendurchmessern jenseits von 28-40 mm ist der Hamax-Gep\u00e4cktr\u00e4ger-Adapter eine hervorragende Wahl. - Gep\u00e4cktr\u00e4ger Montiert - Schlafposition - 9 Monaten bis 22 kg 20\u00b0 Ergonomische SchlafpositionDas Hamax-Klappsystem wurde in den neuen Fahrradsitz integriert, so das eine Schlafposition von 20\u00b0 f\u00fcr das Kind eingestellt werden kann. SchulterpolsterDie Schulterpolster sorgen f\u00fcr zus\u00e4tzlichen Komfort und erleichtern das Anlegen des SicherheitsgurtsR\u00fcckenst\u00fctze h\u00f6henverstellbarDas verstellbare R\u00fcckensystem erlaubt eine H\u00f6heneinstellung der R\u00fcckenst\u00fctze, sodass der Fahrradsitz mitw\u00e4chstReflektorenDer Fahrradsitz ist durch die Reflektoren an der R\u00fcckseite besser sichtbar.HelmaussparungHelmaussparung f\u00fcr optimalen Komfort beim Tragen eines Fahrradhelmes- Erm\u00f6glicht die Montages des Sitzes am vorhandenen Gep\u00e4cktr\u00e4ger- Geeignet f\u00fcr Elektrofahrr\u00e4der- Gep\u00e4cktr\u00e4ger m\u00fcssen f\u00fcr Lasten von 25 kg zugelassen sein- Integrierte Federung f\u00fcr maximalen Komfort Ihres Kindes- Unterst\u00fctzt die Sitzneigungsfunktion- Geeignet f\u00fcr Gep\u00e4cktr\u00e4ger von 120-180 mm- Rohrdurchmesser 10-20 mm. Die Rohre m\u00fcssen rund sein- Einfache Montage"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.57
},
"fields": {
"displayGroup": [
"461710a50261548135026cc3b15bf930"
]
},
"sort": [
0,
"49f85a9ed090b20c8bed85a5923c669f"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "96a0cc2f93365fadfcc06ba14e95fae1",
"_score": null,
"_source": {
"id": "96a0cc2f93365fadfcc06ba14e95fae1",
"autoIncrement": 87019.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 5,
"productNumber": "9380",
"ean": null,
"displayGroup": "51d69005dd01e94bbf7a231897a3b474",
"sales": 0,
"stock": 5,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "e87b2ad973028e550ad31b7a41d32df1",
"manufacturerNumber": "HAM553011",
"releaseDate": null,
"createdAt": "2023-10-16T11:40:04+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"6855456e2fe46a9d49d3d3af4f57443d",
"854d6fae5ee42911677c739ee1734486",
"979d472a84804b9f647bc185a877a8b5",
"3b8a614226a953a8cd9526fca6fe9ba5"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "6855456e2fe46a9d49d3d3af4f57443d",
"_count": 1
},
{
"id": "854d6fae5ee42911677c739ee1734486",
"_count": 1
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1
},
{
"id": "3b8a614226a953a8cd9526fca6fe9ba5",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "8b5673658f946c740541454dd03e2982",
"childCount": 0,
"categories": [
{
"id": "3b8a614226a953a8cd9526fca6fe9ba5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kindersitze"
}
},
{
"id": "979d472a84804b9f647bc185a877a8b5",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kinderanh\u00e4nger & -sitze"
}
}
],
"manufacturer": {
"id": "e87b2ad973028e550ad31b7a41d32df1",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hamax"
},
"_count": 1
},
"properties": [
{
"id": "4eee70ed64219d5914eb3cf6d1c61506",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "N"
}
}
],
"options": [],
"categoryIds": [
"3b8a614226a953a8cd9526fca6fe9ba5",
"979d472a84804b9f647bc185a877a8b5"
],
"optionIds": [],
"propertyIds": [
"4eee70ed64219d5914eb3cf6d1c61506"
],
"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": 164.9,
"product_vk3_ebay": 164.9
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Hamax Caress Carrier Adapter wei\u00df-grau"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Mit dem Gep\u00e4cktr\u00e4ger-Adapter sind die hinten montierten Caress-Fahrradsitze f\u00fcr fast alle Fahrr\u00e4der einsetzbar. F\u00fcr die steigende Zahl an Elektrofahrr\u00e4dern und andere Fahrr\u00e4der mit Rahmendurchmessern jenseits von 28-40 mm ist der Hamax-Gep\u00e4cktr\u00e4ger-Adapter eine hervorragende Wahl. - Gep\u00e4cktr\u00e4ger Montiert - Schlafposition - 9 Monaten bis 22 kg 20\u00b0 Ergonomische SchlafpositionDas Hamax-Klappsystem wurde in den neuen Fahrradsitz integriert, so das eine Schlafposition von 20\u00b0 f\u00fcr das Kind eingestellt werden kann. SchulterpolsterDie Schulterpolster sorgen f\u00fcr zus\u00e4tzlichen Komfort und erleichtern das Anlegen des SicherheitsgurtsR\u00fcckenst\u00fctze h\u00f6henverstellbarDas verstellbare R\u00fcckensystem erlaubt eine H\u00f6heneinstellung der R\u00fcckenst\u00fctze, sodass der Fahrradsitz mitw\u00e4chstReflektorenDer Fahrradsitz ist durch die Reflektoren an der R\u00fcckseite besser sichtbar.HelmaussparungHelmaussparung f\u00fcr optimalen Komfort beim Tragen eines Fahrradhelmes- Erm\u00f6glicht die Montages des Sitzes am vorhandenen Gep\u00e4cktr\u00e4ger- Geeignet f\u00fcr Elektrofahrr\u00e4der- Gep\u00e4cktr\u00e4ger m\u00fcssen f\u00fcr Lasten von 25 kg zugelassen sein- Integrierte Federung f\u00fcr maximalen Komfort Ihres Kindes- Unterst\u00fctzt die Sitzneigungsfunktion- Geeignet f\u00fcr Gep\u00e4cktr\u00e4ger von 120-180 mm- Rohrdurchmesser 10-20 mm. Die Rohre m\u00fcssen rund sein- Einfache Montage"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 164.9,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 138.57
},
"fields": {
"displayGroup": [
"51d69005dd01e94bbf7a231897a3b474"
]
},
"sort": [
0,
"96a0cc2f93365fadfcc06ba14e95fae1"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.24 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":"3b8a614226a953a8cd9526fca6fe9ba5"}}}},{"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
|