| 1 |
4.14 ms |
Request:
{"index":"gzautoteile_product","search_type":"query_then_fetch","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":"018ecdf9873a71dfab55f3f644e66628"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0193303ee96770249d3d6085bff06647"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"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":"name","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"]}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "gzautoteile_product_1741095151",
"_id": "0195211efa1273e4a54f4ddf2d7ff2b3",
"_score": null,
"_source": {
"id": "0195211efa1273e4a54f4ddf2d7ff2b3",
"autoIncrement": 582574.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": true,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "018ecdf9873a71dfab55f3f644e66628"
},
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0192947355567955b1a20a2f6fdc6827"
},
{
"_count": 1,
"visibility": 30,
"salesChannelId": "98432def39fc4624b33213a56b8c944d"
}
],
"availableStock": 2,
"productNumber": "FEBI BILSTEIN 105687",
"ean": "4054224056875",
"displayGroup": "bd41f843e6e84cdbb7603805e7d00d1d",
"sales": 0,
"stock": 2,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "019348aed61072719339ab17226aacdc",
"manufacturerNumber": "105687",
"releaseDate": null,
"createdAt": "2025-02-20T02:11:07+00:00",
"categoryTree": [
"018ecdf7dfdc721cbe98c74e7d49392c",
"0193303e841e71b48489a642832c539b",
"0193303ee5917298a1a42b7f410f7c7c",
"0193303ee77172fa9f79bb407b178ed4",
"0193303ee96770249d3d6085bff06647"
],
"categoriesRo": [
{
"id": "018ecdf7dfdc721cbe98c74e7d49392c",
"_count": 1
},
{
"id": "0193303e841e71b48489a642832c539b",
"_count": 1
},
{
"id": "0193303ee5917298a1a42b7f410f7c7c",
"_count": 1
},
{
"id": "0193303ee77172fa9f79bb407b178ed4",
"_count": 1
},
{
"id": "0193303ee96770249d3d6085bff06647",
"_count": 1
}
],
"taxId": "018ecdf7dfdb70868d8f0dae2bf0a311",
"tags": [],
"parentId": null,
"coverId": "0195232a49a77069a9b6ff72a33f6351",
"childCount": 0,
"categories": [
{
"id": "0193303ee77172fa9f79bb407b178ed4",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Kapaklar",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Abdeckungen"
}
},
{
"id": "0193303ee96770249d3d6085bff06647",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "D\u0131\u015f aynalar ve aksesuarlar",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Au\u00dfenspiegel & Zubeh\u00f6r"
}
}
],
"manufacturer": {
"id": "019348aed61072719339ab17226aacdc",
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FEBI BILSTEIN"
},
"_count": 1
},
"properties": [
{
"id": "01937836bff9736eaadebefb65074b9b",
"_count": 1,
"groupId": "01929f5d4cf871b78acbe0249405b1c4",
"group": {
"id": "01929f5d4cf871b78acbe0249405b1c4",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Elektrikli",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "elektrisch"
}
},
{
"id": "01937838d294739e98ddd0f8ebf850b9",
"_count": 1,
"groupId": "01929f5d4b4c737ea2b7207c1efbec35",
"group": {
"id": "01929f5d4b4c737ea2b7207c1efbec35",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Sa\u011f",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "rechts"
}
}
],
"options": [],
"categoryIds": [
"0193303ee77172fa9f79bb407b178ed4",
"0193303ee96770249d3d6085bff06647"
],
"optionIds": [],
"propertyIds": [
"01937836bff9736eaadebefb65074b9b",
"01937838d294739e98ddd0f8ebf850b9"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"01922ea6b4d573f39e7a62b9dfe4acf3": {
"tecdoc_oe": [
"MERCEDES-BENZ A000 811 11 22 A0008111122",
"MERCEDES-BENZ 000 811 11 22 0008111122",
"VW 2E1 857 516 B 2E1857516B"
],
"tecdoc_mpn": "105687",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"VAN WEZEL 2973804 2973804",
"VAN WEZEL 2973806 2973806",
"VAN WEZEL 2973814 2973814",
"VAN WEZEL 2973816 2973816",
"VAN WEZEL 3077822 3077822",
"VAN WEZEL 3077824 3077824",
"VAN WEZEL 3077826 3077826",
"VAN WEZEL 3077828 3077828",
"VAN WEZEL 3077842 3077842",
"VAN WEZEL 3083808 3083808",
"VAN WEZEL 3083826 3083826",
"VAN WEZEL 5862824 5862824",
"VAN WEZEL 5862826 5862826",
"MEKRA 13.5890.210.199 135890210199",
"KLOKKERHOLM 35471026 35471026",
"KLOKKERHOLM 35471046 35471046",
"KLOKKERHOLM 35471052 35471052",
"KLOKKERHOLM 35481040 35481040",
"KLOKKERHOLM 35481042 35481042",
"KLOKKERHOLM 35481044 35481044",
"KLOKKERHOLM 35481046 35481046",
"KLOKKERHOLM 35481048 35481048",
"KLOKKERHOLM 35481050 35481050",
"JOHNS 50 64 37-90 50643790",
"JOHNS 50 64 38-1 5064381",
"JOHNS 50 64 38-15 50643815",
"JOHNS 50 64 38-16 50643816",
"JOHNS 50 64 38-21 50643821",
"JOHNS 50 64 38-25 50643825",
"JOHNS 50 64 38-26 50643826",
"JOHNS 50 64 38-90 50643890",
"ALKAR 6344994 6344994",
"ALKAR 9202994 9202994",
"ALKAR 9226994 9226994",
"ALKAR 9230021 9230021",
"ALKAR 9232994 9232994",
"ALKAR 9234021 9234021",
"ALKAR 9238021 9238021",
"ALKAR 9240994 9240994",
"ALKAR 9242021 9242021",
"ALKAR 9242994 9242994",
"ALKAR 9246021 9246021",
"TYC 321-0103 3210103",
"TYC 321-0103-2 32101032",
"TYC 321-0105 3210105",
"TYC 321-0109 3210109",
"TYC 321-0111 3210111",
"TYC 321-0143 3210143",
"TYC 321-0145 3210145",
"TYC 321-0171 3210171",
"TYC 321-0173 3210173",
"APEC AMH2024 AMH2024",
"APEC AMR2034 AMR2034",
"APEC AMR2036 AMR2036",
"DIEDERICHS 1663028 1663028",
"PRASCO VG9527313 VG9527313",
"DT Spare Parts 4.66987 466987",
"EQUAL QUALITY RD03164 RD03164",
"ELTA AUTOMOTIVE EM0403 EM0403",
"BSG BSG 90-900-010 BSG90900010",
"AUGER 82902 82902",
"BLIC 5402-02-2001820P 5402022001820P",
"BLIC 5402-02-2001822P 5402022001822P",
"BLIC 5402-02-2002888P 5402022002888P",
"BLIC 5402-04-9221990P 5402049221990P",
"BLIC 5403-03-10010P 54030310010P",
"BLIC 6102-02-1216992P 6102021216992P",
"BLIC 6103-02-047350P 610302047350P",
"SAMPA 205.044 205044",
"ABAKUS 2436C02 2436C02",
"SPILU 53986 53986",
"SPILU 53988 53988",
"SPILU 56578 56578",
"SPILU 57665 57665",
"IMEX IMX 001000 811 11 22 IMX0010008111122",
"IPARLUX 21509316 21509316",
"IPARLUX 27509312 27509312",
"IPARLUX 27509326 27509326",
"IPARLUX 41509322 41509322",
"ZEKKERT SP-4043 SP4043",
"ZEKKERT SP-4079 SP4079",
"FAST FT88340 FT88340",
"OREX 182261 182261",
"OREX 182262 182262",
"JUMASA 54022055 54022055",
"JUMASA 54025540 54025540",
"JUMASA 54525540 54525540",
"JUMASA 57022055 57022055",
"4U Autoparts 41005MR 41005MR",
"4U Autoparts 60378VV 60378VV",
"Stark SKAA-2230039 SKAA2230039",
"RIDEX 23A0040 23A0040",
"RIDEX 50O0006 50O0006",
"FREY 798904401 798904401",
"STORM QUALITY PARTS 5009002 5009002",
"Professional Parts 35471052 35471052",
"MCS 331811 331811",
"MCS 333614 333614",
"MCS 333618 333618",
"MCS 333620 333620",
"MCS 333622 333622",
"MCS 333624 333624",
"MCS 337012523 337012523",
"MCS 337012525 337012525",
"MCS 337012591 337012591"
]
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"tecdoc_oe": [
"MERCEDES-BENZ A000 811 11 22 A0008111122",
"MERCEDES-BENZ 000 811 11 22 0008111122",
"VW 2E1 857 516 B 2E1857516B"
],
"tecdoc_mpn": "105687",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"VAN WEZEL 2973804 2973804",
"VAN WEZEL 2973806 2973806",
"VAN WEZEL 2973814 2973814",
"VAN WEZEL 2973816 2973816",
"VAN WEZEL 3077822 3077822",
"VAN WEZEL 3077824 3077824",
"VAN WEZEL 3077826 3077826",
"VAN WEZEL 3077828 3077828",
"VAN WEZEL 3077842 3077842",
"VAN WEZEL 3083808 3083808",
"VAN WEZEL 3083826 3083826",
"VAN WEZEL 5862824 5862824",
"VAN WEZEL 5862826 5862826",
"MEKRA 13.5890.210.199 135890210199",
"KLOKKERHOLM 35471026 35471026",
"KLOKKERHOLM 35471046 35471046",
"KLOKKERHOLM 35471052 35471052",
"KLOKKERHOLM 35481040 35481040",
"KLOKKERHOLM 35481042 35481042",
"KLOKKERHOLM 35481044 35481044",
"KLOKKERHOLM 35481046 35481046",
"KLOKKERHOLM 35481048 35481048",
"KLOKKERHOLM 35481050 35481050",
"JOHNS 50 64 37-90 50643790",
"JOHNS 50 64 38-1 5064381",
"JOHNS 50 64 38-15 50643815",
"JOHNS 50 64 38-16 50643816",
"JOHNS 50 64 38-21 50643821",
"JOHNS 50 64 38-25 50643825",
"JOHNS 50 64 38-26 50643826",
"JOHNS 50 64 38-90 50643890",
"ALKAR 6344994 6344994",
"ALKAR 9202994 9202994",
"ALKAR 9226994 9226994",
"ALKAR 9230021 9230021",
"ALKAR 9232994 9232994",
"ALKAR 9234021 9234021",
"ALKAR 9238021 9238021",
"ALKAR 9240994 9240994",
"ALKAR 9242021 9242021",
"ALKAR 9242994 9242994",
"ALKAR 9246021 9246021",
"TYC 321-0103 3210103",
"TYC 321-0103-2 32101032",
"TYC 321-0105 3210105",
"TYC 321-0109 3210109",
"TYC 321-0111 3210111",
"TYC 321-0143 3210143",
"TYC 321-0145 3210145",
"TYC 321-0171 3210171",
"TYC 321-0173 3210173",
"APEC AMH2024 AMH2024",
"APEC AMR2034 AMR2034",
"APEC AMR2036 AMR2036",
"DIEDERICHS 1663028 1663028",
"PRASCO VG9527313 VG9527313",
"DT Spare Parts 4.66987 466987",
"EQUAL QUALITY RD03164 RD03164",
"ELTA AUTOMOTIVE EM0403 EM0403",
"BSG BSG 90-900-010 BSG90900010",
"AUGER 82902 82902",
"BLIC 5402-02-2001820P 5402022001820P",
"BLIC 5402-02-2001822P 5402022001822P",
"BLIC 5402-02-2002888P 5402022002888P",
"BLIC 5402-04-9221990P 5402049221990P",
"BLIC 5403-03-10010P 54030310010P",
"BLIC 6102-02-1216992P 6102021216992P",
"BLIC 6103-02-047350P 610302047350P",
"SAMPA 205.044 205044",
"ABAKUS 2436C02 2436C02",
"SPILU 53986 53986",
"SPILU 53988 53988",
"SPILU 56578 56578",
"SPILU 57665 57665",
"IMEX IMX 001000 811 11 22 IMX0010008111122",
"IPARLUX 21509316 21509316",
"IPARLUX 27509312 27509312",
"IPARLUX 27509326 27509326",
"IPARLUX 41509322 41509322",
"ZEKKERT SP-4043 SP4043",
"ZEKKERT SP-4079 SP4079",
"FAST FT88340 FT88340",
"OREX 182261 182261",
"OREX 182262 182262",
"JUMASA 54022055 54022055",
"JUMASA 54025540 54025540",
"JUMASA 54525540 54525540",
"JUMASA 57022055 57022055",
"4U Autoparts 41005MR 41005MR",
"4U Autoparts 60378VV 60378VV",
"Stark SKAA-2230039 SKAA2230039",
"RIDEX 23A0040 23A0040",
"RIDEX 50O0006 50O0006",
"FREY 798904401 798904401",
"STORM QUALITY PARTS 5009002 5009002",
"Professional Parts 35471052 35471052",
"MCS 331811 331811",
"MCS 333614 333614",
"MCS 333618 333618",
"MCS 333620 333620",
"MCS 333622 333622",
"MCS 333624 333624",
"MCS 337012523 337012523",
"MCS 337012525 337012525",
"MCS 337012591 337012591"
]
}
},
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "FEBI BILSTEIN 105687 Muhafaza, d\u0131\u015f ayna",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FEBI BILSTEIN 105687 Abdeckung, Au\u00dfenspiegel"
},
"description": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "\u00c7ift halindeki \u00fcr\u00fcn numaras\u0131: 102570 | Uzunluk: 344 mm | Geni\u015flik: 218 mm | Kal\u0131nl\u0131k\/Kuvvet: 82 mm | \u0130\u015fletme t\u00fcr\u00fc: Elektrikli | Montaj taraf\u0131: Sa\u011f | A\u011f\u0131rl\u0131k: 0,4 kg",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "paarige Artikelnummer: 102570 | L\u00e4nge: 344 mm | Breite: 218 mm | Dicke\/St\u00e4rke: 82 mm | Betriebsart: elektrisch | Einbauposition: rechts | Gewicht: 0,4 kg"
},
"metaTitle": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": [
"Muhafaza, d\u0131\u015f dikiz aynas\u0131"
],
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 19.86,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 16.69
},
"fields": {
"displayGroup": [
"bd41f843e6e84cdbb7603805e7d00d1d"
]
},
"sort": [
"febi bilstein 105687 abdeckung, au\u00dfenspiegel",
"0195211efa1273e4a54f4ddf2d7ff2b3"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
5.27 ms |
Request:
{"index":"gzautoteile_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":"018ecdf9873a71dfab55f3f644e66628"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"0193303ee96770249d3d6085bff06647"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}},{"bool":{"must_not":[{"bool":{"must":[{"term":{"isCloseout":true}},{"term":{"available":false}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule018ecdf7dfcf734e88063baf7883edbf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7dfd8736e957028c59fd5078a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7e8f9711a8f9eb33ae57bac05_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule018ecdf7dfee72db9c430bb49724d987_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019294672b8d7d4b902c0eb9869c6e7c_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
|