| 1 |
13.77 ms |
Request:
{"index":"sw_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":"01916a8b94f873b8abf36daf28eb865c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0191a1830fa3739ba5863c0661ef7dec"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"product_pre_ordered"}},"order":"DESC"}},{"_script":{"type":"string","script":{"source":"def languages = params['languages'];\ndef suffix = params.containsKey('suffix') ? '.' + params['suffix'] : '';\n\nfor (int i = 0; i < languages.length; i++) {\n def field_name = params['field'] + '.' + languages[i] + suffix;\n\n if (doc[field_name].size() > 0 && doc[field_name].value != null && doc[field_name].value.toString().length() > 0) {\n def fieldValue = doc[field_name].value;\n\n return fieldValue.toString();\n }\n}\n\nreturn '';\n","lang":"painless","params":{"field":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"},"search_type":"query_then_fetch"}
{
"took": 4,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1734503886",
"_type": "_doc",
"_id": "01926cb3547772a18b1b2bf814db9f61",
"_score": null,
"_source": {
"purchasePrices": [
{
"net": 0.0,
"gross": 0.0,
"linked": true,
"currencyId": "b7d2554b0ce847cd82f3ac9bd1c0dfca"
}
],
"referenceUnit": null,
"purchaseUnit": null,
"unit": {
"id": null,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"shortCode": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"_count": 1
},
"crossSellings": [],
"keywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kolloid Kolloidale nachf\u00fcllen Reisegr\u00f6\u00dfe lebe natur lebenatur"
},
"packUnit": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"packUnitPlural": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"id": "01926cb3547772a18b1b2bf814db9f61",
"autoIncrement": 209.0,
"ratingAverage": 0.0,
"active": true,
"available": false,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "01916a8b94f873b8abf36daf28eb865c"
}
],
"availableStock": 0,
"productNumber": "TEST-21201",
"ean": null,
"displayGroup": "b05efe5a745a096b402d839e8ad3fa31",
"sales": 0,
"stock": 0,
"weight": 0.0,
"width": 30.0,
"length": 30.0,
"height": 109.0,
"manufacturerId": "1d2efba59e2e9bf96bcfa8fe2efb3ea0",
"manufacturerNumber": null,
"releaseDate": null,
"createdAt": "2024-10-08T15:15:44+00:00",
"categoryTree": [
"01919397d27f707fa87aee0385e95a41",
"0191a17ecabc7458bcdf93a1dfdb4dfb",
"0191a18015cb74eba8b8e7277f09b81c",
"0191bb8969ec708485374756ae89f6cf",
"01927bd855bc7158b9e21db20aa058de",
"0191a182c8d47ec39cc59192ff5acc85",
"0191a182e39273dfa4ed66e183eb8be9",
"0191a1830fa3739ba5863c0661ef7dec",
"0191bb8a2168745f9be186edbfa83923",
"01927bd86f687321803a65d6dd9cee76"
],
"categoriesRo": [
{
"id": "01919397d27f707fa87aee0385e95a41",
"_count": 1
},
{
"id": "0191a17ecabc7458bcdf93a1dfdb4dfb",
"_count": 1
},
{
"id": "0191a18015cb74eba8b8e7277f09b81c",
"_count": 1
},
{
"id": "0191bb8969ec708485374756ae89f6cf",
"_count": 1
},
{
"id": "01927bd855bc7158b9e21db20aa058de",
"_count": 1
},
{
"id": "0191a182c8d47ec39cc59192ff5acc85",
"_count": 1
},
{
"id": "0191a182e39273dfa4ed66e183eb8be9",
"_count": 1
},
{
"id": "0191a1830fa3739ba5863c0661ef7dec",
"_count": 1
},
{
"id": "0191bb8a2168745f9be186edbfa83923",
"_count": 1
},
{
"id": "01927bd86f687321803a65d6dd9cee76",
"_count": 1
}
],
"taxId": "01916a872b267347be3d655cfb58e789",
"tags": [],
"parentId": null,
"coverId": null,
"childCount": 0,
"categories": [
{
"id": "0191a17ecabc7458bcdf93a1dfdb4dfb",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "SHOP"
}
},
{
"id": "0191a182e39273dfa4ed66e183eb8be9",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kolloide"
}
},
{
"id": "0191bb8a2168745f9be186edbfa83923",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alle Produkte"
}
},
{
"id": "0191a1830fa3739ba5863c0661ef7dec",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kolloide-Minis"
}
},
{
"id": "01919397d27f707fa87aee0385e95a41",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lebe Natur Home"
}
},
{
"id": "0191a18015cb74eba8b8e7277f09b81c",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kolloide & Monos"
}
},
{
"id": "01927bd855bc7158b9e21db20aa058de",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Weitere Produkte"
}
},
{
"id": "0191bb8969ec708485374756ae89f6cf",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Produkt\u00fcbersicht"
}
},
{
"id": "01927bd86f687321803a65d6dd9cee76",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alle weiteren Produkte"
}
},
{
"id": "0191a182c8d47ec39cc59192ff5acc85",
"_count": 1,
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Alle Kolloide & Monoatomaren Werkstoffe"
}
}
],
"manufacturer": {
"id": "1d2efba59e2e9bf96bcfa8fe2efb3ea0",
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Tec2Future"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"01919397d27f707fa87aee0385e95a41",
"0191a17ecabc7458bcdf93a1dfdb4dfb",
"0191a18015cb74eba8b8e7277f09b81c",
"0191a182c8d47ec39cc59192ff5acc85",
"0191a182e39273dfa4ed66e183eb8be9",
"0191a1830fa3739ba5863c0661ef7dec",
"0191bb8969ec708485374756ae89f6cf",
"0191bb8a2168745f9be186edbfa83923",
"01927bd855bc7158b9e21db20aa058de",
"01927bd86f687321803a65d6dd9cee76"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"Tags": "Kolloide nachf\u00fcllen, Kolloide umf\u00fcllen, praktische Reisegr\u00f6\u00dfe Kolloide, Nachf\u00fcllflasche Kolloide, Kolloide mitnehmen, Kolloide f\u00fcr die Handtasche, 30 ml Flasche mit Spr\u00fchaufsatz, kleine Flasche f\u00fcr Kolloide,",
"Details": "\u2022 Blauglasflasche mit Spr\u00fchaufsatz 30 ml leer.",
"product_group": false,
"short_description": "30 ml Flasche f\u00fcr Kolloide zum Nachf\u00fcllen. Praktische Reisegr\u00f6\u00dfe, f\u00fcr unterwegs. Zubeh\u00f6r. Sicher und unkompliziert umf\u00fcllen.",
"product_pre_ordered": false,
"lebe_product_form_info": "1 FL \u00e0 30 ml"
}
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Zubeh\u00f6r Flasche inkl. Spr\u00fchaufsatz 30 ml"
},
"description": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "F\u00fcr den Umf\u00fcllprozess in kleinere Spr\u00fchflaschen folgen Sie einfach diesen Schritten:1. Tauchen Sie den Glasbeh\u00e4lter der kleinen Flasche \u2013 ohne den Spr\u00fchaufsatz \u2013 f\u00fcr kurze Zeit in maximal 120 \u00b0C hei\u00dfes Wasser. Dies dient dazu, etwaige Spannungen aus dem Glas zu nehmen und es auf die Umf\u00fcllung vorzubereiten.2. Nachdem der Beh\u00e4lter dem hei\u00dfen Wasser entnommen wurde, lassen Sie ihn vollst\u00e4ndig trocknen. Eine r\u00fcckstandslose Trocknung ist essentiell, um die Qualit\u00e4t der kolloidalen L\u00f6sung beim Umf\u00fcllen zu bewahren.3. Sobald die Flasche trocken ist, k\u00f6nnen Sie die Kolloide sicher und unkompliziert umf\u00fcllen. Diese Vorgehensweise stellt sicher, dass Sie Ihre Kolloid-L\u00f6sungen auch f\u00fcr den Transport klein verpacken k\u00f6nnen, ohne Abstriche bei der Qualit\u00e4t zu machen.Mit dieser Anleitung k\u00f6nnen Sie Ihre gew\u00fcnschten Kolloide jederzeit in eine handlichere Form \u00fcberf\u00fchren und sie so \u00fcberallhin mitnehmen."
},
"metaTitle": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kolloide nachf\u00fcllen | 30 ml Spr\u00fchflasche f\u00fcr unterwegs | Zubeh\u00f6r"
},
"metaDescription": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "30 ml Flasche f\u00fcr Kolloide zum Nachf\u00fcllen. Praktische Reisegr\u00f6\u00dfe, f\u00fcr unterwegs. Zubeh\u00f6r. Sicher und unkompliziert umf\u00fcllen. Im Onlineshop sofort verf\u00fcgbar."
},
"customSearchKeywords": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": [
"Kolloide nachf\u00fcllen",
" Kolloide umf\u00fcllen",
" praktische Reisegr\u00f6\u00dfe Kolloide",
" Nachf\u00fcllflasche Kolloide",
" Kolloide mitnehmen",
" Kolloide f\u00fcr die Handtasche",
" 30 ml Flasche mit Spr\u00fchaufsatz",
" kleine Flasche f\u00fcr Kolloide",
""
]
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.66667,
"warehouseGroups": [
{
"id": null,
"_count": 0
}
],
"completion": [
"test-21201",
"zubeh\u00f6r",
"flasche",
"inkl.",
"spr\u00fchaufsatz",
"kolloide",
"nachf\u00fcllen",
"spr\u00fchflasche",
"f\u00fcr",
"unterwegs",
"zubeh\u00f6r flasche inkl. spr\u00fchaufsatz 30 ml",
"kolloide nachf\u00fcllen | 30 ml spr\u00fchflasche f\u00fcr unterwegs | zubeh\u00f6r"
]
},
"fields": {
"displayGroup": [
"b05efe5a745a096b402d839e8ad3fa31"
]
},
"sort": [
"false",
"zubeh\u00f6r flasche inkl. spr\u00fchaufsatz 30 ml",
"01926cb3547772a18b1b2bf814db9f61"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.70 ms |
Request:
{"index":"sw_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":"01916a8b94f873b8abf36daf28eb865c"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0191a1830fa3739ba5863c0661ef7dec"}}}},{"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_rule01916a872aa67073a439dac37fda65ce_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872b06731f944de6ce7d37a1ea_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a87582c7066ac933f518487bb58_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872bc671468a07d17a479d67ca_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01926bff81cd7a28a9bef5237df79775_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01936c370d0f77298568834e2375435b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01938c23a6677e1abf55445326ad0934_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_rule01916a872bcc7376bc9463a879514eff_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1},{"key":"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net","factor":1}],"decimals":1000000,"round":false,"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
|