| 1 |
761.48 ms |
Request:
{"index":"sw_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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"251448b91bc742de85643f5fccd89051"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"positions.position":{"nested":{"path":"positions","filter":{"term":{"positions.salesChannelCategoryHash":"ed062d55a7e887998a42c73b568d224b"}}},"order":"ASC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":24,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 648,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 2,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1764941511",
"_id": "2a88d9b59d474c7e869d8071649be43c",
"_score": null,
"_source": {
"id": "2a88d9b59d474c7e869d8071649be43c",
"autoIncrement": 3.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": false,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
}
],
"availableStock": 10,
"productNumber": "SWDEMO10001",
"ean": null,
"displayGroup": "ad2fab7ad7babdd7322b341443c0033b",
"sales": 0,
"stock": 10,
"weight": 0.17,
"width": 0.0,
"length": 0.0,
"height": 0.0,
"manufacturerId": "7f24e96676e944b0a0addc20d56728cb",
"manufacturerNumber": null,
"releaseDate": "2025-08-11T12:50:23+00:00",
"createdAt": "2025-08-11T12:50:24+00:00",
"categoryTree": [
"01989916539d73129b95f629087f9d2b",
"a515ae260223466f8e37471d279e6406",
"2185182cbbd4462ea844abeb2a438b33",
"251448b91bc742de85643f5fccd89051"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "a515ae260223466f8e37471d279e6406",
"_count": 1
},
{
"id": "2185182cbbd4462ea844abeb2a438b33",
"_count": 1
},
{
"id": "251448b91bc742de85643f5fccd89051",
"_count": 1
}
],
"taxId": "01989916539c7054889e6a4a0f906d58",
"tags": [],
"parentId": null,
"coverId": "f0e28db1195847dc9acb8eb016473e0c",
"childCount": 0,
"categories": [
{
"id": "2185182cbbd4462ea844abeb2a438b33",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Herren",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men"
}
},
{
"id": "251448b91bc742de85643f5fccd89051",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics"
}
}
],
"manufacturer": {
"id": "7f24e96676e944b0a0addc20d56728cb",
"name": {
"01989916530973118fd8e27ff0e983c6": "Shopware Kleidung",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Fashion"
},
"_count": 1
},
"properties": [
{
"id": "6f9359239c994b48b7de282ee19a714d",
"_count": 1,
"groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
"group": {
"id": "1857bb30fe6448c88f8ad331cf6dfa0c",
"_count": 1
},
"name": {
"01989916530973118fd8e27ff0e983c6": "Kinder",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Children"
}
},
{
"id": "78c53f3f6dd14eb4927978415bfb74db",
"_count": 1,
"groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
"group": {
"id": "1857bb30fe6448c88f8ad331cf6dfa0c",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Man",
"01989916530973118fd8e27ff0e983c6": "Mann"
}
},
{
"id": "7cab88165ae5420f921232511b6e8f7d",
"_count": 1,
"groupId": "1857bb30fe6448c88f8ad331cf6dfa0c",
"group": {
"id": "1857bb30fe6448c88f8ad331cf6dfa0c",
"_count": 1
},
"name": {
"01989916530973118fd8e27ff0e983c6": "Frau",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Woman"
}
},
{
"id": "dc6f98beeca44852beb078a9e8e21e7d",
"_count": 1,
"groupId": "a67cdd9627cb488bb4cd91f3e8d66e32",
"group": {
"id": "a67cdd9627cb488bb4cd91f3e8d66e32",
"_count": 1
},
"name": {
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Plastic",
"01989916530973118fd8e27ff0e983c6": "Kunstoff"
}
}
],
"options": [],
"categoryIds": [
"2185182cbbd4462ea844abeb2a438b33",
"251448b91bc742de85643f5fccd89051"
],
"optionIds": [],
"propertyIds": [
"6f9359239c994b48b7de282ee19a714d",
"78c53f3f6dd14eb4927978415bfb74db",
"7cab88165ae5420f921232511b6e8f7d",
"dc6f98beeca44852beb078a9e8e21e7d"
],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": [],
"name": {
"01989916530973118fd8e27ff0e983c6": "Hauptartikel",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Men - Main product"
},
"description": {
"01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
},
"metaTitle": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 495.95,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 416.76,
"positions": [
{
"position": 1,
"categoryId": "251448b91bc742de85643f5fccd89051",
"salesChannelId": "default",
"salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b"
},
{
"position": 3,
"categoryId": "2185182cbbd4462ea844abeb2a438b33",
"salesChannelId": "default",
"salesChannelCategoryHash": "1ac4570192b6442f4de7e3ed26605c41"
},
{
"position": 5,
"categoryId": "a515ae260223466f8e37471d279e6406",
"salesChannelId": "default",
"salesChannelCategoryHash": "9edffd46ccf4bdf2dcd1dd79816d5fc0"
}
]
},
"fields": {
"displayGroup": [
"ad2fab7ad7babdd7322b341443c0033b"
]
},
"sort": [
1,
"2a88d9b59d474c7e869d8071649be43c"
]
},
{
"_index": "sw_product_1764941511",
"_id": "11dc680240b04f469ccba354cbf0b967",
"_score": null,
"_source": {
"id": "11dc680240b04f469ccba354cbf0b967",
"autoIncrement": 1.0,
"ratingAverage": 0.0,
"active": true,
"available": true,
"isCloseout": false,
"shippingFree": true,
"markAsTopseller": false,
"visibilities": [
{
"_count": 1,
"visibility": 30,
"salesChannelId": "0198991695bc70e7b39cb015d4b9eda4"
}
],
"availableStock": 10,
"productNumber": "SWDEMO10002",
"ean": null,
"displayGroup": "9cc83811832d4b1f1593acb545f36678",
"sales": 0,
"stock": 10,
"weight": 45.0,
"width": 590.0,
"length": 840.0,
"height": 600.0,
"manufacturerId": "cc1c20c365d34cfb88bfab3c3e81d350",
"manufacturerNumber": null,
"releaseDate": "2025-08-11T12:50:23+00:00",
"createdAt": "2025-08-11T12:50:24+00:00",
"categoryTree": [
"01989916539d73129b95f629087f9d2b",
"251448b91bc742de85643f5fccd89051"
],
"categoriesRo": [
{
"id": "01989916539d73129b95f629087f9d2b",
"_count": 1
},
{
"id": "251448b91bc742de85643f5fccd89051",
"_count": 1
}
],
"taxId": "01989916539c7054889e6a4a0f906d58",
"tags": [],
"parentId": null,
"coverId": "e648140ff1f04177b40128ac6b649d8a",
"childCount": 0,
"categories": [
{
"id": "251448b91bc742de85643f5fccd89051",
"_count": 1,
"name": {
"01989916530973118fd8e27ff0e983c6": "Freizeit & Elektro",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Free time & electronics"
}
}
],
"manufacturer": {
"id": "cc1c20c365d34cfb88bfab3c3e81d350",
"name": {
"01989916530973118fd8e27ff0e983c6": "Shopware Freizeit",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Shopware Freetime"
},
"_count": 1
},
"properties": [],
"options": [],
"categoryIds": [
"251448b91bc742de85643f5fccd89051"
],
"optionIds": [],
"propertyIds": [],
"tagIds": [],
"states": [
"is-physical"
],
"customFields": [],
"name": {
"01989916530973118fd8e27ff0e983c6": "Hauptprodukt mit erweiterten Preisen",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Main product with advanced prices"
},
"description": {
"01989916530973118fd8e27ff0e983c6": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.",
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet."
},
"metaTitle": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"metaDescription": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"customSearchKeywords": {
"01989916530973118fd8e27ff0e983c6": null,
"2fbb5fe2e29a4d70aa5854ce7ce3e20b": null
},
"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 750.0,
"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 630.25,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross": 950.0,
"cheapest_price_ruledefault_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_net": 798.3199999999999,
"positions": [
{
"position": 2,
"categoryId": "251448b91bc742de85643f5fccd89051",
"salesChannelId": "default",
"salesChannelCategoryHash": "ed062d55a7e887998a42c73b568d224b"
}
]
},
"fields": {
"displayGroup": [
"9cc83811832d4b1f1593acb545f36678"
]
},
"sort": [
2,
"11dc680240b04f469ccba354cbf0b967"
]
}
]
},
"aggregations": {
"total-count": {
"value": 2
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
235.80 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":"0198991695bc70e7b39cb015d4b9eda4"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"251448b91bc742de85643f5fccd89051"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"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_rule01989916538e72b183890fa62d207fcf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165398727ebc6e388b687252f3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule019899165de27144841265386485dc44_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3858957016644de4ae48c0500bf3ccc8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulee1378db7808a478f919e0d740d5d6c1a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0198991653b071658d610f622e27b218_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule28caae75a5624f0d985abd0eb32aa160_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
|