| 1 |
22.95 ms |
Request:
{"index":"sw2_stage_product","search_type":"query_then_fetch","track_total_hits":true,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_018d17682b2279e199fd7eae60dfec83":{"gte":30}}}]}},{"term":{"categoryTree":"caf686e5263a5b3983a66a38b85ba9e9"}},{"exists":{"field":"displayGroup"}}]}}]}},"sort":[{"name.2fbb5fe2e29a4d70aa5854ce7ce3e20b":{"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 13,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw2_stage_product_1779904693",
"_id": "477781cb28ed5355b95b5b7f3809200b",
"_score": null,
"_source": {
"id": "477781cb28ed5355b95b5b7f3809200b",
"autoIncrement": 4308.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "018d17682b2279e199fd7eae60dfec83"
},
{
"_count": 1,
"visibility": 30,
"salesChannelId": "018d17c31cda765bad622f40d23ad2f6"
}
],
"availableStock": 3,
"productNumber": [
"VERSKARTNB15"
],
"ean": "4060953351907",
"displayGroup": "c5883277b66c212ed25035c79770ee75cfa9c43924add25bce77db98b17410e1",
"sales": 103,
"stock": 3,
"weight": 0.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"type": "physical",
"manufacturerId": "8feae9ffc7f65e19afb0b2ac04b6e827",
"manufacturerNumber": "VERSKARTNB15",
"deliveryTimeId": null,
"releaseDate": null,
"createdAt": "2024-02-22T10:04:56+00:00",
"categoryTree": [
"caf686e5263a5b3983a66a38b85ba9e9",
"6f92959738fb5bbbbe741ca4f3937478",
"d5478bd8f8455ab088f76e6b01708972"
],
"categoriesRo": [
{
"id": "caf686e5263a5b3983a66a38b85ba9e9",
"_count": 1
},
{
"id": "6f92959738fb5bbbbe741ca4f3937478",
"_count": 1
},
{
"id": "d5478bd8f8455ab088f76e6b01708972",
"_count": 1
}
],
"taxId": "018d0df7b8ac72b984d93f433873c571",
"tags": [],
"parentId": null,
"coverId": "1fefc08750b85900987035c214ed91c5",
"childCount": 0,
"categories": [
{
"id": "d5478bd8f8455ab088f76e6b01708972",
"_count": 1,
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Cajas de env\u00edo",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Cartons d'exp\u00e9dition",
"018d0dfcf59f72db96801cf118615f03": "Scatole di spedizione",
"018d0e1019dd717d830be1872cd35666": "Shipping Boxes",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Versandkartons"
}
}
],
"manufacturer": {
"id": "8feae9ffc7f65e19afb0b2ac04b6e827",
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": null,
"018d0dfcf59e72bfb6e9e6dde7c330e6": null,
"018d0dfcf59f72db96801cf118615f03": null,
"018d0e1019dd717d830be1872cd35666": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Acer"
},
"_count": 1
},
"deliveryTime": {
"id": null,
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": null,
"018d0dfcf59e72bfb6e9e6dde7c330e6": null,
"018d0dfcf59f72db96801cf118615f03": null,
"018d0e1019dd717d830be1872cd35666": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"properties": [
{
"id": "018de5f61b4776fc818c74d0535ffbf8",
"_count": 1,
"groupId": "018de5f42748758b994ce3f9c14407fd",
"group": {
"id": "018de5f42748758b994ce3f9c14407fd",
"_count": 1
},
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Nuevo",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Neuf",
"018d0dfcf59f72db96801cf118615f03": "Nuovo",
"018d0e1019dd717d830be1872cd35666": "New",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Neu"
}
},
{
"id": "018deaf238e173aebaa9c4b058ee418f",
"_count": 1,
"groupId": "018deaef745b75ebb28e35fb1930e822",
"group": {
"id": "018deaef745b75ebb28e35fb1930e822",
"_count": 1
},
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "no",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "non",
"018d0dfcf59f72db96801cf118615f03": "no",
"018d0e1019dd717d830be1872cd35666": "no",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "nein"
}
},
{
"id": "e790f64489f150dd9d9d7542f2914421",
"_count": 1,
"groupId": "018de5f4a1fc77dcb6d6c24dd121b402",
"group": {
"id": "018de5f4a1fc77dcb6d6c24dd121b402",
"_count": 1
},
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Embalaje",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Emballage",
"018d0dfcf59f72db96801cf118615f03": "Imballaggio",
"018d0e1019dd717d830be1872cd35666": "Packaging",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Verpackung"
}
}
],
"options": [],
"categoryIds": [
"d5478bd8f8455ab088f76e6b01708972"
],
"optionIds": [],
"propertyIds": [
"018de5f61b4776fc818c74d0535ffbf8",
"018deaf238e173aebaa9c4b058ee418f",
"e790f64489f150dd9d9d7542f2914421"
],
"tagIds": [],
"streamIds": [
"018d17c2af437d46a21798da31994cab",
"01932ab558017dec93627f01cc1ef223",
"01932abc052c7e4ab0db30c2cd7d6e0a",
"01932abd32257ba994fa3de991db9102",
"019dab018a8a7362b29339f025a5c65d"
],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"custom_product_availability_state_": "is_available"
}
},
"name": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Acer Caja de env\u00edo para notebook 15,6\" incl. material de embalaje (originale)",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Acer Carton d'exp\u00e9dition pour notebook 15,6\" incl. mat\u00e9riel d'emballage (Original)",
"018d0dfcf59f72db96801cf118615f03": "Acer Scatola di spedizione per notebook 15,6\" incl. materiale di imballaggio (originale)",
"018d0e1019dd717d830be1872cd35666": "Acer 15.6\" Notebook shipping carton incl. packaging material (Original)",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Acer 11,6\" - 13,3\" - 13,5\" - 14\" - 14,5\" - 15,6\" Notebook Versandkarton inkl. Verpackungsmaterial (Original)"
},
"description": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Produktinformationen: Acer Caja de env\u00edo para notebook 15,6\" incl. material de embalaje compatible con Caracter\u00edsticas:Embalaje de env\u00edoCaja con material de embalajeTama\u00f1o: 15,6 pulgadasEstado: Nuevo \/ Directamente del fabricante (ORIGINAL)Si necesitas una pieza de repuesto para otro producto que todav\u00eda no se encuentra en nuestra tienda, cons\u00faltanos por correo electr\u00f3nico o por tel\u00e9fono.Salvo que se indique expresamente lo contrario, todas las piezas de repuesto ofrecidas son exclusivamente piezas originales del fabricante.El producto puede diferir de la imagen.",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Produktinformationen: Acer Carton d'exp\u00e9dition pour notebook 15,6\" incl. mat\u00e9riel d'emballage compatible avec Caract\u00e9ristiques\u00a0:Emballage d'exp\u00e9ditionCarton avec mat\u00e9riel d'emballageTaille: 15,6 pouces\u00c9tat : Neuf \/ Direct du fabricant (MARCHANDISE ORIGINALE)Si vous avez besoin d\u2019une pi\u00e8ce d\u00e9tach\u00e9e pour un autre produit qui ne se trouve pas encore dans notre boutique, veuillez nous contacter par e-mail ou par t\u00e9l\u00e9phone.Sauf indication contraire expresse, toutes les pi\u00e8ces d\u00e9tach\u00e9es propos\u00e9es sont exclusivement des pi\u00e8ces d\u2019origine du fabricant.Le produit peut diff\u00e9rer de l\u2019illustration.",
"018d0dfcf59f72db96801cf118615f03": "Produktinformationen: OriginalAcer Scatola di spedizione per notebook 15,6\" incl. materiale di imballaggio compatibile con Caratteristiche:Imballaggio di spedizioneScatola con materiale di imballaggioDimensione: 15,6 polliciCondizione: Nuovo \/ Direttamente dal produttore (ORIGINALE)Se hai bisogno di un ricambio per un altro prodotto che non \u00e8 ancora presente nel nostro shop, contattaci via e-mail o telefonicamente.Salvo diversa indicazione espressa, tutti i ricambi offerti sono esclusivamente ricambi originali del produttore.Il prodotto pu\u00f2 differire dall\u2019immagine.",
"018d0e1019dd717d830be1872cd35666": "Produktinformationen: Acer 15.6\" Notebook shipping carton incl. packaging material compatible with Features:Shipping packagingCarton with packaging materialSize: 15.6 inchesCondition: New \/ Direct from manufacturer (ORIGINAL GOODS)If you require a spare part for another product that is not yet available in our shop, please contact us by e-mail or phone.Unless expressly stated otherwise, all spare parts offered are exclusively original manufacturer spare parts.Product may differ from illustration.",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Produktinformationen: Acer Versandkarton passend f\u00fcr Eigenschaften:VersandverpackungKarton mit Verpackungsmaterialpassend f\u00fcr: 11,6\" - 13,3\" - 13,5\" - 14\" - 14,5\" - 15,6\"Artikelzustand: Neu \/ Direkter Bezug vom Hersteller (ORIGINALWARE)Solltest Du ein Ersatzteil f\u00fcr ein anderes Produkt ben\u00f6tigen, welches sich noch nicht bei uns im Shop befindet, frage dieses bitte per E-Mail oder telefonisch bei uns an.Alle angebotenen Ersatzteile sind, falls nicht ausdr\u00fccklich angegeben, ausschlie\u00dflich originale Ersatzteile des Herstellers.Produkt kann von Abbildung abweichen."
},
"metaTitle": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Repuesto para Acer | sb-electronics.de",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Pi\u00e8ce de rechange pour Acer | sb-electronics.de",
"018d0dfcf59f72db96801cf118615f03": "Ricambio per Acer | sb-electronics.de",
"018d0e1019dd717d830be1872cd35666": "Spare Part for Acer | sb-electronics.de",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "15,6\" Notebook Versandkarton | Original Acer Ersatzteil"
},
"metaDescription": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": "Repuesto (Art.: VERSKARTNB15) original Acer \u2013 Repuesto. Compra en sb-electronics.de\/es. ? Env\u00edo r\u00e1pido",
"018d0dfcf59e72bfb6e9e6dde7c330e6": "Pi\u00e8ce originale Acer \u2013 Pi\u00e8ce de rechange (R\u00e9f.: VERSKARTNB15). Commandez sur sb-electronics.de\/fr. ? Livraison rapide",
"018d0dfcf59f72db96801cf118615f03": "Ricambio (Rif.: VERSKARTNB15) originale Acer \u2013 Ricambio. Ordina su sb-electronics.de\/it. ? Consegna rapida",
"018d0e1019dd717d830be1872cd35666": "Original Acer \u2013 Spare Part (MPN: VERSKARTNB15). Order at sb-electronics.de\/en. ? Fast delivery",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Original Acer Ersatzteil \u2013 15,6\" Notebook Versandkarton inkl. Verpackungsmaterial. Jetzt bei sb-electronics.de. ? Schnelle Lieferung"
},
"customSearchKeywords": {
"018d0dfcf59e72bfb6e9e6dde5f5ddc0": null,
"018d0dfcf59e72bfb6e9e6dde7c330e6": null,
"018d0dfcf59f72db96801cf118615f03": null,
"018d0e1019dd717d830be1872cd35666": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_rule018f1496ebca71399bb29a9c7be2942a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9000000000000003552713678800500929355621337890625,
"cheapest_price_rule018f1496ebca71399bb29a9c7be2942a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.840336134453782079845041153021156787872314453125,
"cheapest_price_rule018d8d686aef7ff5ba594f114e5e8771_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9000000000000003552713678800500929355621337890625,
"cheapest_price_rule018d8d686aef7ff5ba594f114e5e8771_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.840336134453782079845041153021156787872314453125,
"cheapest_price_rule018d18a13e097d0d876a3dd2e7156ab6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9000000000000003552713678800500929355621337890625,
"cheapest_price_rule018d18a13e097d0d876a3dd2e7156ab6_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.840336134453782079845041153021156787872314453125,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 12.9000000000000003552713678800500929355621337890625,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 10.840336134453782079845041153021156787872314453125,
"visibility_018d17682b2279e199fd7eae60dfec83": 30,
"visibility_018d17c31cda765bad622f40d23ad2f6": 30
},
"fields": {
"displayGroup": [
"c5883277b66c212ed25035c79770ee75cfa9c43924add25bce77db98b17410e1"
]
},
"sort": [
"acer 11,6\" - 13,3\" - 13,5\" - 14\" - 14,5\" - 15,6\" notebook versandkarton inkl. verpackungsmaterial (original)",
"477781cb28ed5355b95b5b7f3809200b"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
13.99 ms |
Request:
{"index":"sw2_stage_product","track_total_hits":false,"body":{"query":{"bool":{"filter":[{"bool":{"must":[{"bool":{"must":[{"term":{"active":true}},{"range":{"visibility_018d17682b2279e199fd7eae60dfec83":{"gte":30}}}]}},{"term":{"categoryTree":"caf686e5263a5b3983a66a38b85ba9e9"}},{"exists":{"field":"displayGroup"}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"source":"double getPrice(def accessors, def doc, def decimals, def round, def multiplier) {\n for (accessor in accessors) {\n def key = accessor['key'];\n\n if (!doc.containsKey(key) || doc[key].empty) {\n continue;\n }\n\n def factor = accessor['factor'];\n def value = doc[key].value * factor;\n\n value = Math.round(value * decimals);\n value = (double) value \/ decimals;\n\n if (!round) {\n return (double) value;\n }\n\n value = Math.round(value * multiplier);\n\n value = (double) value \/ multiplier;\n\n return (double) value;\n }\n\n return 0;\n}\n\nreturn getPrice(params['accessors'], doc, params['decimals'], params['round'], params['multiplier']);\n","lang":"painless","params":{"accessors":[{"key":"cheapest_price_rule018d0df7b8aa7231bb4623e0ff288738_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018d0df7b8b773f482ea84c101f20f31_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01934b47f3a771308671b66032a0c421_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0193251275d27e44a709334f5a6512e6_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
|