| 1 |
20.05 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":"0193303f2e3c70699d41f6f69eda2208"}}}},{"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": 17,
"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": "019521e1539e7307ad557c98d7a18654",
"_score": null,
"_source": {
"id": "019521e1539e7307ad557c98d7a18654",
"autoIncrement": 592333.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": 4,
"productNumber": "FEBI BILSTEIN 33768",
"ean": "4027816337683",
"displayGroup": "c3e0e0ecacac49e441b49e6f2b96d005",
"sales": 0,
"stock": 4,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "019348aed61072719339ab17226aacdc",
"manufacturerNumber": "33768",
"releaseDate": null,
"createdAt": "2025-02-20T05:48:42+00:00",
"categoryTree": [
"018ecdf7dfdc721cbe98c74e7d49392c",
"0193303e841e71b48489a642832c539b",
"0193303f2c587041b222efa7aea57996",
"0193303f2e3c70699d41f6f69eda2208"
],
"categoriesRo": [
{
"id": "018ecdf7dfdc721cbe98c74e7d49392c",
"_count": 1
},
{
"id": "0193303e841e71b48489a642832c539b",
"_count": 1
},
{
"id": "0193303f2c587041b222efa7aea57996",
"_count": 1
},
{
"id": "0193303f2e3c70699d41f6f69eda2208",
"_count": 1
}
],
"taxId": "018ecdf7dfdb70868d8f0dae2bf0a311",
"tags": [],
"parentId": null,
"coverId": "0195232d8bb77236809a8829feb767a5",
"childCount": 0,
"categories": [
{
"id": "0193303f2e3c70699d41f6f69eda2208",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "\u00d6n cam silecek kollar\u0131",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Scheibenwischerarme"
}
}
],
"manufacturer": {
"id": "019348aed61072719339ab17226aacdc",
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FEBI BILSTEIN"
},
"_count": 1
},
"properties": [
{
"id": "01937836a9e773fb9d63bb5498742496",
"_count": 1,
"groupId": "01929f5d4d35723f9c83d245d62e893b",
"group": {
"id": "01929f5d4d35723f9c83d245d62e893b",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Plastik",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kunststoff"
}
},
{
"id": "0193783d8e1272dba227d0482a80be5a",
"_count": 1,
"groupId": "01929f5d4b4c737ea2b7207c1efbec35",
"group": {
"id": "01929f5d4b4c737ea2b7207c1efbec35",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Arka",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "hinten"
}
}
],
"options": [],
"categoryIds": [
"0193303f2e3c70699d41f6f69eda2208"
],
"optionIds": [],
"propertyIds": [
"01937836a9e773fb9d63bb5498742496",
"0193783d8e1272dba227d0482a80be5a"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"01922ea6b4d573f39e7a62b9dfe4acf3": {
"tecdoc_oe": [
"OPEL 12 73 389 1273389",
"VAUXHALL 009130603 009130603",
"VAUXHALL 09130603 09130603",
"VAUXHALL 9130603 9130603",
"CHEVROLET 09130603 09130603",
"CHEVROLET 9130603 9130603",
"GENERAL MOTORS 009130603 009130603",
"GENERAL MOTORS 09130603 09130603",
"GENERAL MOTORS 9130603 9130603"
],
"tecdoc_mpn": "33768",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"MAGNETI MARELLI 000700041400 000700041400",
"QUINTON HAZELL QDR106 QDR106",
"SWAG 40 93 3768 40933768",
"METZGER 2190021 2190021",
"METZGER 2190269 2190269",
"MAPCO 104940 104940",
"BUGIAD BMC19396 BMC19396",
"VAICO V40-0816 V400816",
"VAICO V40-1830 V401830",
"JP GROUP 1298300300 1298300300",
"TOPRAN 207 588 207588",
"AUTOMEGA 100089110 100089110",
"OPEN PARTS WBR7004.00 WBR700400",
"MAXGEAR 39-0216 390216",
"MAXGEAR 39-0725 390725",
"CAUTEX 752597 752597",
"ASHUKI by Palidium ASHR18-400 ASHR18400",
"AUTOMOTOR France PWB1400 PWB1400",
"ELTA AUTOMOTIVE EW7155 EW7155",
"ELTA AUTOMOTIVE EW7158 EW7158",
"ELTA AUTOMOTIVE EW7164 EW7164",
"CASCO CWA77301AS CWA77301AS",
"KAMOKA 29015 29015",
"LUCAS LWCR155 LWCR155",
"LUCAS LWCR158 LWCR158",
"LUCAS LWCR164 LWCR164",
"KRAFT AUTOMOTIVE 0701512 0701512",
"KRAFT AUTOMOTIVE 0711502 0711502",
"PATRON PWA018 PWA018",
"PATRON PWB410-RA PWB410RA",
"PATRON PWB410-R-E PWB410RE",
"ASAM AUTOMOTIVE 65219 65219",
"DOGA OR017 OR017",
"SANDO SWA77301.0 SWA773010",
"STELLOX 105 400-SX 105400SX",
"ABAKUS 103-00-072 10300072",
"ABAKUS 103-00-072-C 10300072C",
"ABAKUS 103-00-072-P 10300072P",
"ABAKUS 103-01-007 10301007",
"Metalcaucho 68093 68093",
"STC T468093 T468093",
"OSSCA 12862 12862",
"TREVI AUTOMOTIVE RA244 RA244",
"FARE SA 21697 21697",
"LGK 043085301LGK 043085301LGK",
"Technika AR40 AR40",
"REAL 27981103BN 27981103BN",
"NTY EWB-PL-000 EWBPL000",
"NTY EWB-PL-005 EWBPL005",
"Stark SKWA-0930052 SKWA0930052",
"Stark SKWA-0930131 SKWA0930131",
"Stark SKWIB-0940015 SKWIB0940015",
"RIDEX 298W0016 298W0016",
"RIDEX 301W0052 301W0052",
"RIDEX 301W0131 301W0131",
"AE TOPLIGHT TRA-O1A9 TRAO1A9",
"GOOM WI-0086 WI0086",
"AIC 52321 52321",
"KRAFTVOLL GERMANY 21030148 21030148",
"MEHA AUTOMOTIVE MH89066 MH89066",
"MEHA AUTOMOTIVE MH89077 MH89077",
"FLAMAR BLF210377HQ BLF210377HQ",
"Aslyx AS-570093 AS570093",
"A.Z. Meisterteile AZMT-42-061-1063 AZMT420611063",
"A.Z. Meisterteile AZMT-49-033-1032 AZMT490331032",
"YSPARTS RWT0007 RWT0007",
"BOGAP L5513101 L5513101",
"YTT Y2043 Y2043",
"RECOFICIAL RECSWA77301.0 RECSWA773010",
"PLYOM P752597 P752597",
"alp ALP-006422 ALP006422",
"FARE-CO 21697 21697",
"FARE-RCH 21697 21697",
"ITAB AUTOMOTIVE 34077301AV 34077301AV",
"PMA PWR1015 PWR1015"
]
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"tecdoc_oe": [
"OPEL 12 73 389 1273389",
"VAUXHALL 009130603 009130603",
"VAUXHALL 09130603 09130603",
"VAUXHALL 9130603 9130603",
"CHEVROLET 09130603 09130603",
"CHEVROLET 9130603 9130603",
"GENERAL MOTORS 009130603 009130603",
"GENERAL MOTORS 09130603 09130603",
"GENERAL MOTORS 9130603 9130603"
],
"tecdoc_mpn": "33768",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"MAGNETI MARELLI 000700041400 000700041400",
"QUINTON HAZELL QDR106 QDR106",
"SWAG 40 93 3768 40933768",
"METZGER 2190021 2190021",
"METZGER 2190269 2190269",
"MAPCO 104940 104940",
"BUGIAD BMC19396 BMC19396",
"VAICO V40-0816 V400816",
"VAICO V40-1830 V401830",
"JP GROUP 1298300300 1298300300",
"TOPRAN 207 588 207588",
"AUTOMEGA 100089110 100089110",
"OPEN PARTS WBR7004.00 WBR700400",
"MAXGEAR 39-0216 390216",
"MAXGEAR 39-0725 390725",
"CAUTEX 752597 752597",
"ASHUKI by Palidium ASHR18-400 ASHR18400",
"AUTOMOTOR France PWB1400 PWB1400",
"ELTA AUTOMOTIVE EW7155 EW7155",
"ELTA AUTOMOTIVE EW7158 EW7158",
"ELTA AUTOMOTIVE EW7164 EW7164",
"CASCO CWA77301AS CWA77301AS",
"KAMOKA 29015 29015",
"LUCAS LWCR155 LWCR155",
"LUCAS LWCR158 LWCR158",
"LUCAS LWCR164 LWCR164",
"KRAFT AUTOMOTIVE 0701512 0701512",
"KRAFT AUTOMOTIVE 0711502 0711502",
"PATRON PWA018 PWA018",
"PATRON PWB410-RA PWB410RA",
"PATRON PWB410-R-E PWB410RE",
"ASAM AUTOMOTIVE 65219 65219",
"DOGA OR017 OR017",
"SANDO SWA77301.0 SWA773010",
"STELLOX 105 400-SX 105400SX",
"ABAKUS 103-00-072 10300072",
"ABAKUS 103-00-072-C 10300072C",
"ABAKUS 103-00-072-P 10300072P",
"ABAKUS 103-01-007 10301007",
"Metalcaucho 68093 68093",
"STC T468093 T468093",
"OSSCA 12862 12862",
"TREVI AUTOMOTIVE RA244 RA244",
"FARE SA 21697 21697",
"LGK 043085301LGK 043085301LGK",
"Technika AR40 AR40",
"REAL 27981103BN 27981103BN",
"NTY EWB-PL-000 EWBPL000",
"NTY EWB-PL-005 EWBPL005",
"Stark SKWA-0930052 SKWA0930052",
"Stark SKWA-0930131 SKWA0930131",
"Stark SKWIB-0940015 SKWIB0940015",
"RIDEX 298W0016 298W0016",
"RIDEX 301W0052 301W0052",
"RIDEX 301W0131 301W0131",
"AE TOPLIGHT TRA-O1A9 TRAO1A9",
"GOOM WI-0086 WI0086",
"AIC 52321 52321",
"KRAFTVOLL GERMANY 21030148 21030148",
"MEHA AUTOMOTIVE MH89066 MH89066",
"MEHA AUTOMOTIVE MH89077 MH89077",
"FLAMAR BLF210377HQ BLF210377HQ",
"Aslyx AS-570093 AS570093",
"A.Z. Meisterteile AZMT-42-061-1063 AZMT420611063",
"A.Z. Meisterteile AZMT-49-033-1032 AZMT490331032",
"YSPARTS RWT0007 RWT0007",
"BOGAP L5513101 L5513101",
"YTT Y2043 Y2043",
"RECOFICIAL RECSWA77301.0 RECSWA773010",
"PLYOM P752597 P752597",
"alp ALP-006422 ALP006422",
"FARE-CO 21697 21697",
"FARE-RCH 21697 21697",
"ITAB AUTOMOTIVE 34077301AV 34077301AV",
"PMA PWR1015 PWR1015"
]
}
},
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "FEBI BILSTEIN 33768 Silecek kolu, cam temizleme sistemi febi Plus",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FEBI BILSTEIN 33768 Wischarm, Scheibenreinigung febi Plus"
},
"description": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "Malzeme: Plastik | Montaj taraf\u0131: Arka | A\u011f\u0131rl\u0131k: 0,170 kg",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Material: Kunststoff | Einbauposition: hinten | Gewicht: 0,170 kg"
},
"metaTitle": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": [
"Silecek Kolu, \u00f6n cam y\u0131kama"
],
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 29.13,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 24.48,
"tecdocTypeLinks": [
{
"typeId": "01929f328a1572b49c189f2ff1c81e88",
"properties": []
},
{
"typeId": "01929f328c6770419c0ca3a6df661295",
"properties": []
},
{
"typeId": "01929f328c73728797b44d427fa6300f",
"properties": []
},
{
"typeId": "01929f329b6c71b4a217658ff727781c",
"properties": []
},
{
"typeId": "01929f32a9ce700eb227d28d96aa1352",
"properties": []
},
{
"typeId": "01929f32a9d27267a0e115aceda5c7fc",
"properties": []
},
{
"typeId": "01929f32bdd771b29588b7db88daea8d",
"properties": []
},
{
"typeId": "01929f32be7172baad4edf9c9076576c",
"properties": []
},
{
"typeId": "01929f3374d772efb1602f795b9150d0",
"properties": []
},
{
"typeId": "01929f3374de71e8bc5453f95b5b0763",
"properties": []
},
{
"typeId": "01929f3374e672fb8bf22814186b1beb",
"properties": []
},
{
"typeId": "01929f3374ed70afa1f196adcad65a7e",
"properties": []
},
{
"typeId": "01929f337b807033b0bbeb6990b81f24",
"properties": []
},
{
"typeId": "01929f337b87707ab7c15cfc5970c803",
"properties": []
},
{
"typeId": "01929f337b8f706fabe47729d89ce98a",
"properties": []
},
{
"typeId": "01929f339a8b73d780c91e4eff686226",
"properties": []
},
{
"typeId": "01929f33a47773c38ffb339ce75a07dc",
"properties": []
},
{
"typeId": "01929f33a9d271dfb637c61f8d002abb",
"properties": []
},
{
"typeId": "01929f33ca19733ca38e5da5a8b732be",
"properties": []
},
{
"typeId": "01929f33e5f371c1975a38ce657aff87",
"properties": []
},
{
"typeId": "01929f33f75e7116a7cba72c60db3f0e",
"properties": []
},
{
"typeId": "01929f33f77972548c444e5697429819",
"properties": []
},
{
"typeId": "01929f340fab73ae88a359c0d1028ff6",
"properties": []
},
{
"typeId": "01929f34245b72f1b447cd7bb9411dea",
"properties": []
},
{
"typeId": "01929f34246e73288d78d1364ed66bcb",
"properties": []
},
{
"typeId": "01929f34247771859e488c6a7b263d9e",
"properties": []
},
{
"typeId": "01929f343c6d73fdbfd158bd1289090f",
"properties": []
}
]
},
"fields": {
"displayGroup": [
"c3e0e0ecacac49e441b49e6f2b96d005"
]
},
"sort": [
"febi bilstein 33768 wischarm, scheibenreinigung febi plus",
"019521e1539e7307ad557c98d7a18654"
]
}
]
},
"aggregations": {
"total-count": {
"value": 1
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
6.77 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":"0193303f2e3c70699d41f6f69eda2208"}}}},{"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
|