| 1 |
5.82 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":"9cfdf10e8fc047a44b08ed031e1f0ed1"}}}},{"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": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "shopware6-stage_product_1773667835",
"_id": "7e8dae845c0913d1bff36953378df627",
"_score": null,
"_source": {
"id": "7e8dae845c0913d1bff36953378df627",
"autoIncrement": 94177.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 12,
"productNumber": "14458",
"ean": "4006539081837",
"displayGroup": "e78c2dd5c2de9d50f994ddaab123ec61",
"sales": 0,
"stock": 12,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b853c4c71ab833fd4e9dc559319d7515",
"manufacturerNumber": "080-22441",
"releaseDate": null,
"createdAt": "2026-03-16T12:56:49+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"819f46e52c25763a55cc642422644317",
"13fe9d84310e77f13a6d184dbf1232f3",
"9cfdf10e8fc047a44b08ed031e1f0ed1"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1
},
{
"id": "13fe9d84310e77f13a6d184dbf1232f3",
"_count": 1
},
{
"id": "9cfdf10e8fc047a44b08ed031e1f0ed1",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "019cf9d8fad572c9a787bc8b451ae221",
"childCount": 0,
"categories": [
{
"id": "13fe9d84310e77f13a6d184dbf1232f3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pflege"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9cfdf10e8fc047a44b08ed031e1f0ed1",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "b853c4c71ab833fd4e9dc559319d7515",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dr. Wack"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"13fe9d84310e77f13a6d184dbf1232f3",
"28dd2c7955ce926456240b2ff0100bde",
"9cfdf10e8fc047a44b08ed031e1f0ed1"
],
"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_vk2_amazon": 1398.0,
"product_vk3_ebay": 1398.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dr. Wack F100 Der Waschhandschuh Premium"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ULTRA SOFT Die schonendste Art zu waschen!Hochwertige Mikrofaser: Besteht beidseitig aus besonders weichen und hochflorigen Mikrofasern, die sanft \u00fcber die Oberfl\u00e4che gleiten und den Schmutz optimal im Handschuh binden.Mega Saugkraft: Es werden \u00fcber 500 ml Fl\u00fcssigkeit im Waschhandschuh aufgenommenPerfekte Passform: Bietet optimalen Tragekomfort f\u00fcr eine leichte Anwendung ohne Kraftaufwand. Inkl. rutschfestem Elastikbund und eingen\u00e4hter Mittelnaht. Ideal f\u00fcr Links- und Rechtsh\u00e4nderSehr langlebig & umweltfreundlich: H\u00e4lt ca. 200 Waschzyklen, ist waschbar und trocknertauglich Der saugf\u00e4hige und softe Waschhandschuh von F100 besitzt hochflorige Mikrofasern, die sanft \u00fcber Oberfl\u00e4chen gleiten und anhaftenden Schmutz hervorragend aufnehmen. Damit erm\u00f6glicht er dir eine besonders schonende und effektive Reinigung deine Bikes. Der rutschfeste Elastikbund und die universelle Passform sorgen dabei f\u00fcr hohen Tragekomfort und erleichtern dir das Putzen. Dar\u00fcber hinaus ist der Waschhandschuh waschmaschinengeeignet und kann mit hoher Haltbarkeit punkten. Details: saugf\u00e4higer und softer Waschhandschuh f\u00fcr schonende Fahrradreinigung effektive Schmutzaufnahme dank hochfloriger Mikrofasern rutschfester Elastikbund f\u00fcr sicheren Sitz universelle Passform mit hohem Tragekomfort maschinenwaschbar bis 40\u00b0C "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 14.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 12.6
},
"fields": {
"displayGroup": [
"e78c2dd5c2de9d50f994ddaab123ec61"
]
},
"sort": [
0,
"7e8dae845c0913d1bff36953378df627"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "dfeb9598fbfb97cc6bbcc0aff2c785d6",
"_score": null,
"_source": {
"id": "dfeb9598fbfb97cc6bbcc0aff2c785d6",
"autoIncrement": 86441.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 22,
"productNumber": "3485",
"ean": "4006539080045",
"displayGroup": "3bb8e9b5faf924b3ba713d271ec8f40d",
"sales": 0,
"stock": 22,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "b853c4c71ab833fd4e9dc559319d7515",
"manufacturerNumber": "080-22418",
"releaseDate": null,
"createdAt": "2023-10-16T11:36:59+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"819f46e52c25763a55cc642422644317",
"13fe9d84310e77f13a6d184dbf1232f3",
"9cfdf10e8fc047a44b08ed031e1f0ed1"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "819f46e52c25763a55cc642422644317",
"_count": 1
},
{
"id": "13fe9d84310e77f13a6d184dbf1232f3",
"_count": 1
},
{
"id": "9cfdf10e8fc047a44b08ed031e1f0ed1",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "b4eb5f53b3f50720a79c02b562d95cc7",
"childCount": 0,
"categories": [
{
"id": "13fe9d84310e77f13a6d184dbf1232f3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pflege"
}
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "9cfdf10e8fc047a44b08ed031e1f0ed1",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "b853c4c71ab833fd4e9dc559319d7515",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dr. Wack"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"13fe9d84310e77f13a6d184dbf1232f3",
"28dd2c7955ce926456240b2ff0100bde",
"9cfdf10e8fc047a44b08ed031e1f0ed1"
],
"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": 1398.0,
"product_vk3_ebay": 1398.0
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Dr. Wack F100 ''Das Tuch''"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F100 DAS TUCH - Premium MikrofaserF\u00fcr das perfekte Finish am Fahrrad DAS TUCH wurde von der Dr. Wack-Anwendungstechnik aus \u00fcber 50 Alternativen ausgew\u00e4hlt! Ideal zur Nachbehandlung nach der Fahrradw\u00e4schehohe Saugkraft zum AbledernPerfekt zur Verarbeitung des F100 Matt-Pflege SpraysZum Auftragen des F100 Schutz- und Pflege\u00f6ls (nicht zum Nachwischen, da durch hohe Saugkraft zu viel Produkt entfernt werden kann)Extrem weich und flauschig f\u00fcr besonders sanfte Oberfl\u00e4chenbehandlungBeidseitiger Hoch-Flor somit sehr lange einsetzbar, absolut sicher gegen falsche Anwendung und doppelte Nutzungsfl\u00e4cheNahtlos durch Ultra-Sonic-Cut f\u00fcr ein kratzfreies AuspolierenH\u00e4lt ca. 300 WaschzyklenSogar f\u00fcr empfindliche Lacke wie Klavierlack geeignetSehr angenehme und weiche Haptik"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 9.99,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 8.39
},
"fields": {
"displayGroup": [
"3bb8e9b5faf924b3ba713d271ec8f40d"
]
},
"sort": [
0,
"dfeb9598fbfb97cc6bbcc0aff2c785d6"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
4.82 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":"9cfdf10e8fc047a44b08ed031e1f0ed1"}}}},{"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
|