| 1 |
47.26 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":"0193303ed27570aaa03b252d948f20ce"}}}},{"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": 45,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "gzautoteile_product_1741095151",
"_id": "0195213ce8c772aa92794eaca5099ffa",
"_score": null,
"_source": {
"id": "0195213ce8c772aa92794eaca5099ffa",
"autoIncrement": 584366.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": 7,
"productNumber": "FEBI BILSTEIN 15950",
"ean": "4027816159506",
"displayGroup": "198e13aa618d6095c29de8e2cd9ebe76",
"sales": 0,
"stock": 7,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "019348aed61072719339ab17226aacdc",
"manufacturerNumber": "15950",
"releaseDate": null,
"createdAt": "2025-02-20T02:47:32+00:00",
"categoryTree": [
"018ecdf7dfdc721cbe98c74e7d49392c",
"0193303e841e71b48489a642832c539b",
"0193303ec62371ccaa31c9ea02a114bb",
"0193303ed27570aaa03b252d948f20ce",
"0193303ed7cb700aa3c2b5e9442a2995"
],
"categoriesRo": [
{
"id": "018ecdf7dfdc721cbe98c74e7d49392c",
"_count": 1
},
{
"id": "0193303e841e71b48489a642832c539b",
"_count": 1
},
{
"id": "0193303ec62371ccaa31c9ea02a114bb",
"_count": 1
},
{
"id": "0193303ed27570aaa03b252d948f20ce",
"_count": 1
},
{
"id": "0193303ed7cb700aa3c2b5e9442a2995",
"_count": 1
}
],
"taxId": "018ecdf7dfdb70868d8f0dae2bf0a311",
"tags": [],
"parentId": null,
"coverId": "0195232a4ede7020b8edeafac785f650",
"childCount": 0,
"categories": [
{
"id": "0193303ed27570aaa03b252d948f20ce",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Koltuklar",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sitze"
}
},
{
"id": "0193303ed7cb700aa3c2b5e9442a2995",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Di\u011fer parcalar",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sonstige"
}
}
],
"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": "01937836ac0c7320b8195e5f25d78163",
"_count": 1,
"groupId": "01929f5d4ce77366b1a93eb675fccdd0",
"group": {
"id": "01929f5d4ce77366b1a93eb675fccdd0",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "siyah",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "schwarz"
}
},
{
"id": "0193783f168972d79bfc0631d958bbe0",
"_count": 1,
"groupId": "01929f5d4cf871b78acbe0249405b1c4",
"group": {
"id": "01929f5d4cf871b78acbe0249405b1c4",
"_count": 1
},
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Man\u00fcel",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "manuell"
}
}
],
"options": [],
"categoryIds": [
"0193303ed27570aaa03b252d948f20ce",
"0193303ed7cb700aa3c2b5e9442a2995"
],
"optionIds": [],
"propertyIds": [
"01937836a9e773fb9d63bb5498742496",
"01937836ac0c7320b8195e5f25d78163",
"0193783f168972d79bfc0631d958bbe0"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"01922ea6b4d573f39e7a62b9dfe4acf3": {
"tecdoc_oe": [
"VW 191 881 671 191881671",
"VW 191 881 671 C 191881671C"
],
"tecdoc_mpn": "15950",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"SWAG 32 91 5950 32915950",
"TOPRAN 102 924 102924",
"3RG 81726 81726",
"OSSCA 01627 01627",
"vika 88811590301 88811590301",
"BR\u00dcCK GERMANY 191881671 191881671"
]
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"tecdoc_oe": [
"VW 191 881 671 191881671",
"VW 191 881 671 C 191881671C"
],
"tecdoc_mpn": "15950",
"tecdoc_dlnr": "101",
"tecdoc_analog_com": [
"SWAG 32 91 5950 32915950",
"TOPRAN 102 924 102924",
"3RG 81726 81726",
"OSSCA 01627 01627",
"vika 88811590301 88811590301",
"BR\u00dcCK GERMANY 191881671 191881671"
]
}
},
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "FEBI BILSTEIN 15950 D\u00f6ner d\u00fc\u011fmesi, koltuk arkal\u0131\u011f\u0131 ayar\u0131",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "FEBI BILSTEIN 15950 Drehknopf, Sitzlehnenverstellung"
},
"description": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "Renk: siyah | Malzeme: Plastik | \u0130\u015fletme t\u00fcr\u00fc: Man\u00fcel | A\u011f\u0131rl\u0131k: 0,038 kg",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Farbe: schwarz | Material: Kunststoff | Betriebsart: manuell | Gewicht: 0,038 kg"
},
"metaTitle": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 2.23,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 1.87,
"tecdocTypeLinks": [
{
"typeId": "01929f32b99370328e21af9a4227dd92",
"properties": []
},
{
"typeId": "01929f32b997702b82cc7d5c030b3990",
"properties": []
},
{
"typeId": "01929f32b9a971a0beaf9dedec240c52",
"properties": []
},
{
"typeId": "01929f32b9bb710b9271fa4ede94537e",
"properties": []
},
{
"typeId": "01929f32b9da71bebeba22de4807ac01",
"properties": []
},
{
"typeId": "01929f32b9eb71699c570ed4557020ab",
"properties": []
},
{
"typeId": "01929f32b9f472459a12bc1618496243",
"properties": []
},
{
"typeId": "01929f32ba5173449840f59a6d07b664",
"properties": []
},
{
"typeId": "01929f32ba817151b0039b6c6813fe17",
"properties": []
},
{
"typeId": "01929f32bacc7090a2a3b13bd80ad03d",
"properties": []
},
{
"typeId": "01929f32bad173a98b10ade70a3445f0",
"properties": []
},
{
"typeId": "01929f335c5173da8265250d01581973",
"properties": []
},
{
"typeId": "01929f335c5871c1a9f20d3247aa742e",
"properties": []
},
{
"typeId": "01929f335c5f7084933a21c8685bb954",
"properties": []
},
{
"typeId": "01929f335c6672c9a60c111c19562384",
"properties": []
},
{
"typeId": "01929f335c6d70d595b390f62cd83d9a",
"properties": []
},
{
"typeId": "01929f335c74703b882dbdb38b0fa20e",
"properties": []
},
{
"typeId": "01929f335c7b715ab05b372ba39e0007",
"properties": []
},
{
"typeId": "01929f335c827143843109dbc87ee862",
"properties": []
},
{
"typeId": "01929f335c8970479f80a2192908429e",
"properties": []
},
{
"typeId": "01929f335c90708293453e2a2a389a84",
"properties": []
},
{
"typeId": "01929f335c9771c499a0d21c5c9cae6e",
"properties": []
},
{
"typeId": "01929f335c9e7359abf87546b625655f",
"properties": []
},
{
"typeId": "01929f33722c73b8ad71d3a49cf712ef",
"properties": []
},
{
"typeId": "01929f337234736791669dbd1cb1eb5d",
"properties": []
},
{
"typeId": "01929f3382687034a93f6cf9063a3b68",
"properties": []
},
{
"typeId": "01929f33827073d8a7c95654c8bf8442",
"properties": []
},
{
"typeId": "01929f33a23c7134bde8a6fd4b40dd54",
"properties": []
},
{
"typeId": "01929f33abc6721fbcb8bf6d447c0ca5",
"properties": []
},
{
"typeId": "01929f33f60372918d10caef9cb08f59",
"properties": []
},
{
"typeId": "01929f33f60c7306a49b35af6f82cfc5",
"properties": []
},
{
"typeId": "01929f33f62772329b2b23ba46b62005",
"properties": []
},
{
"typeId": "01929f33f630709582b4bfe906a56de2",
"properties": []
},
{
"typeId": "01929f33f64172c5a6ffc270ef9fb77a",
"properties": []
},
{
"typeId": "01929f33f653729193201400a68bf7bf",
"properties": []
},
{
"typeId": "01929f33fb0a739eb2c0e66d6bcb1823",
"properties": []
},
{
"typeId": "01929f33fb127360b256c7214c872eca",
"properties": []
},
{
"typeId": "01929f34013f73f1a57324c5d63143af",
"properties": []
},
{
"typeId": "01929f340ab270f4819783e6f092a0b9",
"properties": []
},
{
"typeId": "01929f34852c729380d19d7134afc5a9",
"properties": []
},
{
"typeId": "01929f34853770c9b4020a9b6ebd21e6",
"properties": []
},
{
"typeId": "01929f348542722f9bb49e7b8d6134d7",
"properties": []
},
{
"typeId": "01929f38d4e5735babdd4075f829df1b",
"properties": []
}
]
},
"fields": {
"displayGroup": [
"198e13aa618d6095c29de8e2cd9ebe76"
]
},
"sort": [
"febi bilstein 15950 drehknopf, sitzlehnenverstellung",
"0195213ce8c772aa92794eaca5099ffa"
]
},
{
"_index": "gzautoteile_product_1741095151",
"_id": "01952330f19d701189583a845f903244",
"_score": null,
"_source": {
"id": "01952330f19d701189583a845f903244",
"autoIncrement": 603082.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": 1,
"productNumber": "STABILUS 282768",
"ean": "4046577999008",
"displayGroup": "39ad71f8d07fa97712357207765a3e4d",
"sales": 0,
"stock": 1,
"weight": 1.0,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "019519537cf37055ac811bf9f08aa4b4",
"manufacturerNumber": "282768",
"releaseDate": null,
"createdAt": "2025-02-20T11:50:33+00:00",
"categoryTree": [
"018ecdf7dfdc721cbe98c74e7d49392c",
"0193303e841e71b48489a642832c539b",
"0193303ec62371ccaa31c9ea02a114bb",
"0193303ee5917298a1a42b7f410f7c7c",
"0193303ed27570aaa03b252d948f20ce",
"0193303eec0072b79b74956af8dfb192"
],
"categoriesRo": [
{
"id": "018ecdf7dfdc721cbe98c74e7d49392c",
"_count": 1
},
{
"id": "0193303e841e71b48489a642832c539b",
"_count": 1
},
{
"id": "0193303ec62371ccaa31c9ea02a114bb",
"_count": 1
},
{
"id": "0193303ee5917298a1a42b7f410f7c7c",
"_count": 1
},
{
"id": "0193303ed27570aaa03b252d948f20ce",
"_count": 1
},
{
"id": "0193303eec0072b79b74956af8dfb192",
"_count": 1
}
],
"taxId": "018ecdf7dfdb70868d8f0dae2bf0a311",
"tags": [],
"parentId": null,
"coverId": "01952331d0d17064bc3661b13a75d906",
"childCount": 0,
"categories": [
{
"id": "0193303ed27570aaa03b252d948f20ce",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Koltuklar",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Sitze"
}
},
{
"id": "0193303eec0072b79b74956af8dfb192",
"_count": 1,
"name": {
"01922ea6b4d573f39e7a62b9dfe4acf3": "Bagaj kapaklar\u0131",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Kofferraum- & Heckklappen"
}
}
],
"manufacturer": {
"id": "019519537cf37055ac811bf9f08aa4b4",
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STABILUS"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"0193303ed27570aaa03b252d948f20ce",
"0193303eec0072b79b74956af8dfb192"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": {
"01922ea6b4d573f39e7a62b9dfe4acf3": {
"tecdoc_oe": [
"SKODA 5QF 888 196 5QF888196",
"SKODA 5QF888196B 5QF888196B",
"SKODA 5QN88196A 5QN88196A",
"SKODA 82878109 82878109",
"VW 5QF888196B 5QF888196B"
],
"tecdoc_mpn": "282768",
"tecdoc_dlnr": "126",
"tecdoc_analog_com": [
"STABILUS 127420 127420",
"STABILUS 198898 198898",
"STABILUS 242599 242599",
"STABILUS 770808 770808",
"STABILUS 869291 869291",
"STABILUS 969203 969203",
"OPTIMAL AG-50875 AG50875"
]
},
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": {
"tecdoc_oe": [
"SKODA 5QF 888 196 5QF888196",
"SKODA 5QF888196B 5QF888196B",
"SKODA 5QN88196A 5QN88196A",
"SKODA 82878109 82878109",
"VW 5QF888196B 5QF888196B"
],
"tecdoc_mpn": "282768",
"tecdoc_dlnr": "126",
"tecdoc_analog_com": [
"STABILUS 127420 127420",
"STABILUS 198898 198898",
"STABILUS 242599 242599",
"STABILUS 770808 770808",
"STABILUS 869291 869291",
"STABILUS 969203 969203",
"OPTIMAL AG-50875 AG50875"
]
}
},
"name": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "STABILUS 282768 Gazl\u0131 amortis\u00f6r, koltuk ayarlamas\u0131",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "STABILUS 282768 Gasfeder, Sitzverstellung \/\/ LIFT-O-MAT"
},
"description": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": "\u0130tme kuvveti: 220 N | Uzunluk: 168 mm | Strok: 36,5 mm",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Ausschubkraft: 220 N | L\u00e4nge: 168 mm | Hub: 36,5 mm"
},
"metaTitle": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"018ecdf986f371efa7f9b15537433a0f": null,
"01922ea6b4d573f39e7a62b9dfe4acf3": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 24.89,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 20.92
},
"fields": {
"displayGroup": [
"39ad71f8d07fa97712357207765a3e4d"
]
},
"sort": [
"stabilus 282768 gasfeder, sitzverstellung \/\/ lift-o-mat",
"01952330f19d701189583a845f903244"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
7.08 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":"0193303ed27570aaa03b252d948f20ce"}}}},{"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
|