| 1 |
5.89 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":"69cb3ea317a32c4e6143e665fdb20b14"}}}},{"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": 3,
"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": "5ca3e9b122f61f8f06494c97b1afccf3",
"_score": null,
"_source": {
"id": "5ca3e9b122f61f8f06494c97b1afccf3",
"autoIncrement": 86610.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 13,
"productNumber": "1384",
"ean": "4030701045556",
"displayGroup": "97eaa4b6b26e1ba67b703d820fbdcdd6",
"sales": 1,
"stock": 13,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "34baca408d2a10d268a5905ba3266147",
"manufacturerNumber": "061-28553",
"releaseDate": null,
"createdAt": "2023-10-16T11:37:53+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"f033ab37c30201f73f142449d037028d",
"36660e59856b4de58a219bcf4e27eba3",
"69cb3ea317a32c4e6143e665fdb20b14",
"8c19f571e251e61cb8dd3612f26d5ecf"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "36660e59856b4de58a219bcf4e27eba3",
"_count": 1
},
{
"id": "69cb3ea317a32c4e6143e665fdb20b14",
"_count": 1
},
{
"id": "8c19f571e251e61cb8dd3612f26d5ecf",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "39473b44a84d991b344f18b8313eea9d",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "357a6fdf7642bf815a88822c447d9dc4",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradteile"
}
},
{
"id": "36660e59856b4de58a219bcf4e27eba3",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Pedale"
}
},
{
"id": "69cb3ea317a32c4e6143e665fdb20b14",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "8c19f571e251e61cb8dd3612f26d5ecf",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Plattform-Pedale"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
}
],
"manufacturer": {
"id": "34baca408d2a10d268a5905ba3266147",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon"
},
"_count": 1
},
"properties": [
{
"id": "3a616a5305e06ccc883bda3ab63b10b5",
"_count": 1,
"groupId": "53d6255f9051ddc256c25536f2aecac5",
"group": {
"id": "53d6255f9051ddc256c25536f2aecac5",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "J"
}
}
],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"357a6fdf7642bf815a88822c447d9dc4",
"36660e59856b4de58a219bcf4e27eba3",
"69cb3ea317a32c4e6143e665fdb20b14",
"8c19f571e251e61cb8dd3612f26d5ecf",
"f033ab37c30201f73f142449d037028d"
],
"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": 27.69,
"product_vk3_ebay": 27.69,
"accessory_sorting_order": "3092|4044"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fuxon Pedalen MTB VP-197"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Super leichtes MTB-Pedal aus Aluminium (250 g\/Paar). Mit Cr-Mo Achse, 9\/16 Zoll Gewinde, Kugellager und Reflektoren. Produktdetails:Ausf\u00fchrung: Standard PedalEinsatz: MTBHerstellerfarbe: schwarzProduktgruppe: MTBMaterial: Aluminiumk\u00e4figMaterial: Aluminiumk\u00f6rperMaterial: Edelstahlachse, CNC-gefr\u00e4stPedalgewinde: 9 \/ 16\"Lagerung: LSL-LagerGewicht: 272 gAbmessung: 98 x 62 mmGr\u00f6\u00dfe: 9\/16 ZollISO 4210 M gepr\u00fcftReflektorProduktart: Pedalen"
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 25.17
},
"fields": {
"displayGroup": [
"97eaa4b6b26e1ba67b703d820fbdcdd6"
]
},
"sort": [
1,
"5ca3e9b122f61f8f06494c97b1afccf3"
]
},
{
"_index": "shopware6-stage_product_1773667835",
"_id": "d9a6712aecef7f0cef35ff4cd75c09d3",
"_score": null,
"_source": {
"id": "d9a6712aecef7f0cef35ff4cd75c09d3",
"autoIncrement": 87679.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01895226670e72a4a15f371adce297ad"
}
],
"availableStock": 500,
"productNumber": "6929A",
"ean": null,
"displayGroup": "dd34da07073be943f6fca4d7b6f944d5",
"sales": 0,
"stock": 500,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "fa246d0262c3925617b0c72bb20eeb1d",
"manufacturerNumber": "050-31272",
"releaseDate": null,
"createdAt": "2023-11-13T11:00:26+00:00",
"categoryTree": [
"01894ed2c40070099cf25d59f2d1a99e",
"28dd2c7955ce926456240b2ff0100bde",
"9872ed9fc22fc182d371c3e9ed316094",
"f033ab37c30201f73f142449d037028d",
"31fefc0e570cb3860f2a6d4b38c6490d",
"69cb3ea317a32c4e6143e665fdb20b14",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"categoriesRo": [
{
"id": "01894ed2c40070099cf25d59f2d1a99e",
"_count": 1
},
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1
},
{
"id": "69cb3ea317a32c4e6143e665fdb20b14",
"_count": 1
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1
}
],
"taxId": "01894ed2c3ff70308e0b51a025a38ddd",
"tags": [],
"parentId": null,
"coverId": "61aab7af09d44d83e99c80bf5f60d649",
"childCount": 0,
"categories": [
{
"id": "28dd2c7955ce926456240b2ff0100bde",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r & Teile"
}
},
{
"id": "31fefc0e570cb3860f2a6d4b38c6490d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Rahmenschl\u00f6sser"
}
},
{
"id": "69cb3ea317a32c4e6143e665fdb20b14",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r"
}
},
{
"id": "9872ed9fc22fc182d371c3e9ed316094",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Fahrradschl\u00f6sser"
}
},
{
"id": "f033ab37c30201f73f142449d037028d",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sale"
}
},
{
"id": "fb7b9ffa5462084c5f4e7e85a093e6d7",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kettenschl\u00f6sser"
}
}
],
"manufacturer": {
"id": "fa246d0262c3925617b0c72bb20eeb1d",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"28dd2c7955ce926456240b2ff0100bde",
"31fefc0e570cb3860f2a6d4b38c6490d",
"69cb3ea317a32c4e6143e665fdb20b14",
"9872ed9fc22fc182d371c3e9ed316094",
"f033ab37c30201f73f142449d037028d",
"fb7b9ffa5462084c5f4e7e85a093e6d7"
],
"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": "Montage",
"product_click_and_collect": 1.0,
"product_store_available": 0.0,
"product_vk2_amazon": 54.95,
"product_vk3_ebay": 54.95,
"accessory_sorting_order": "6924|7271"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "ZEG Sicherheitspaket"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": " Nur in Verbindung mit einem Pegasus E-Bike erh\u00e4ltlich Zeg Sicherheitpaket - bestehend aus dem Axa Rahmenschloss Defender RL, der passenden Zusatzkette sowie einer Satteltasche. Ab den 2025er Modellen von Pegasus ist kein Axa Rahmenschloss mehr verbaut, sondern ein Rahmenschloss der Firma Abus. Die Axa Zusatzkette ist weiterhin im Lieferumfang enthalten und mit dem Abus Rahmenschloss kombinierbar. Zudem ist die Sicherheitsstufe identisch. Axa Rahmenschloss Defender RL Rahmenschloss, hochwertige Qualit\u00e4t, symmetrisches Design, die sichere Wegfahrsperre f\u00fcr den Zwischenstopp. Mit Plug-in Anschluss f\u00fcr Einsteckkabel und ketten zum doppelten Diebstahlschutz. St\u00e4rke: 8,5 mmFarbe: schwarzGewicht: 640 g<?xml:namespace prefix = \"o\" ns = \"urn:schemas-microsoft-com:office:office\" \/> Technologie: - Korrosionsgesch\u00fctztes Stahlgeh\u00e4use - Geh\u00e4rteter Stahlb\u00fcgel von 8,5 mm \u00d8 - Pr\u00e4zisionszylinder mit Schlagschutz gegen gewaltsames Aufbrechen - Stabile, patentierte Schl\u00fcssel (auch Klappschl\u00fcssel) - Mindestens 10.000 Schlie\u00dfungen - Sicherung gegen unabsichtliches Schlie\u00dfen w\u00e4hrend der Fahrt (Kindersicherung) - Niedrige Bauh\u00f6he, montierbar auch bei kleinen Rahmen, Kopfh\u00f6he 46 mm - Gewicht 640 Gramm - Lange Lebensdauer durch ausgesuchte hochfeste und bew\u00e4hrte Materialien - Zus\u00e4tzliche Bohrung f\u00fcr die Schutzblechmontage - Schl\u00fcssel bei ge\u00f6ffnetem Schloss nicht abziehbar - Zugelassen zur Fahrradversicherung in NL\/FIN\/DK\/SE\/UK Axa Defender Zusatzkette Einsteckkette mit Tasche. Die ideale Erg\u00e4nzung f\u00fcr das Defender zum zweifachen Diebstahlschutz Alle Defender Plug-ins sind mit einem verst\u00e4rkten Stahleinrastbolzen von 10 mm Durchmesser ausgestattet. Au\u00dferdem ist der Einrastbolzen mit dem neuen Soft-touch f\u00fcr optimale Griffigkeit versehen. Jeder Plug-in hat eine robuste Ummantelung, die den Fahrradlack sch\u00fctzt. Mit starker Nylonummantelung. - Gewicht: 1110 g - L\u00e4nge: 130 cm - Material geh\u00e4rteter Stahl Zusammen haben das Schloss und die Zusatzkette eine Sicherheitsstufe von 15! "
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 69.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 58.78
},
"fields": {
"displayGroup": [
"dd34da07073be943f6fca4d7b6f944d5"
]
},
"sort": [
0,
"d9a6712aecef7f0cef35ff4cd75c09d3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.57 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":"69cb3ea317a32c4e6143e665fdb20b14"}}}},{"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
|