| 1 |
4.62 ms |
Request:
{"index":"a1_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":"d044ef8e72334e51bc89aea39e978935"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"2a919314776a926139c7843b2dc92b02"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"sales":{"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":0,"size":12,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 2,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 96,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "91bbacbf5961e520c0836292e95295af",
"_score": null,
"_source": {
"autoIncrement": 6723.0,
"id": "91bbacbf5961e520c0836292e95295af"
},
"fields": {
"displayGroup": [
"98adefcb97f21e276ffc433bc7ce5916"
]
},
"sort": [
21,
"91bbacbf5961e520c0836292e95295af"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "9aa8aa38687b9c9238f1532f476e7a85",
"_score": null,
"_source": {
"autoIncrement": 3419.0,
"id": "9aa8aa38687b9c9238f1532f476e7a85"
},
"fields": {
"displayGroup": [
"7d873e7220c9dfb695dcde925a2d92b4"
]
},
"sort": [
14,
"9aa8aa38687b9c9238f1532f476e7a85"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "b860b49ac1c24cc7957fc9cbc8317b54",
"_score": null,
"_source": {
"autoIncrement": 8363.0,
"id": "b860b49ac1c24cc7957fc9cbc8317b54"
},
"fields": {
"displayGroup": [
"95e224f6103b06f3d402bffb1c69e40e"
]
},
"sort": [
14,
"b860b49ac1c24cc7957fc9cbc8317b54"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "f2c007e34a9e423b9d535954ea378ba6",
"_score": null,
"_source": {
"autoIncrement": 8387.0,
"id": "f2c007e34a9e423b9d535954ea378ba6"
},
"fields": {
"displayGroup": [
"50bbe99e03ef5c5fa2d17e4fb90bed7a"
]
},
"sort": [
13,
"f2c007e34a9e423b9d535954ea378ba6"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "f63f4c988b8e29dcaecf2a9dc7768ad3",
"_score": null,
"_source": {
"autoIncrement": 6657.0,
"id": "f63f4c988b8e29dcaecf2a9dc7768ad3"
},
"fields": {
"displayGroup": [
"b860d968983a285b37913eb1cf29b2bc"
]
},
"sort": [
11,
"f63f4c988b8e29dcaecf2a9dc7768ad3"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "9fcbfa24b04c23527549412b3f28e58e",
"_score": null,
"_source": {
"autoIncrement": 6708.0,
"id": "9fcbfa24b04c23527549412b3f28e58e"
},
"fields": {
"displayGroup": [
"e816120955e108aa9a2e87a992ccec90"
]
},
"sort": [
8,
"9fcbfa24b04c23527549412b3f28e58e"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "51cb04611e19c7e7ecbe516a9d5ad498",
"_score": null,
"_source": {
"autoIncrement": 3315.0,
"id": "51cb04611e19c7e7ecbe516a9d5ad498"
},
"fields": {
"displayGroup": [
"7b63e8f509f51e427f3524298d5e867c"
]
},
"sort": [
6,
"51cb04611e19c7e7ecbe516a9d5ad498"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "614480ad9003440b90c28ae95bdffbd7",
"_score": null,
"_source": {
"autoIncrement": 8085.0,
"id": "614480ad9003440b90c28ae95bdffbd7"
},
"fields": {
"displayGroup": [
"948729792b66dee4931afd1e3b889995"
]
},
"sort": [
4,
"614480ad9003440b90c28ae95bdffbd7"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "07b0acc92a2a4772afb7b85154810d1a",
"_score": null,
"_source": {
"autoIncrement": 8100.0,
"id": "07b0acc92a2a4772afb7b85154810d1a"
},
"fields": {
"displayGroup": [
"6382011a707c91f18c1da0f86883beed"
]
},
"sort": [
1,
"07b0acc92a2a4772afb7b85154810d1a"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "123d1c798df64b13a7d6b6ae0e7e69a9",
"_score": null,
"_source": {
"autoIncrement": 7676.0,
"id": "123d1c798df64b13a7d6b6ae0e7e69a9"
},
"fields": {
"displayGroup": [
"94fb6956a26292d0d18e286f42169249"
]
},
"sort": [
1,
"123d1c798df64b13a7d6b6ae0e7e69a9"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "6626a62d81d54a45b7b377364c9440f2",
"_score": null,
"_source": {
"autoIncrement": 7675.0,
"id": "6626a62d81d54a45b7b377364c9440f2"
},
"fields": {
"displayGroup": [
"ea8ac21de5a1b4358be2fa382955a4eb"
]
},
"sort": [
0,
"6626a62d81d54a45b7b377364c9440f2"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "8969f6d0c4be4cc79849f912212ae2da",
"_score": null,
"_source": {
"autoIncrement": 7674.0,
"id": "8969f6d0c4be4cc79849f912212ae2da"
},
"fields": {
"displayGroup": [
"73cf8a8b72a2009c47c80caa26259b03"
]
},
"sort": [
0,
"8969f6d0c4be4cc79849f912212ae2da"
]
}
]
},
"aggregations": {
"total-count": {
"value": 15
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
2.22 ms |
Request:
{"index":"a1_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":"d044ef8e72334e51bc89aea39e978935"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"2a919314776a926139c7843b2dc92b02"}}}},{"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_rule018f6277a68670f4881dd07a8f4ae4c2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0195b7a60fcc7b3cb4c51f1dbd748e6e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule491520caf52346669a5962312d72fd9e_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule1a426e71491641cc9b687999aaaa6b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule3e0a13a80e5b495da8ee827d72e41306_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule13da6b4a200c4eb5a22f5c53b6a3f881_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5ecc436611a64278b2aeb92bd879c310_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e75503e3340498399f4050d00ede2f5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleda68e5f98ff6434587b645adf935fcbf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule22d20322c7a6ee622a1ec5f05338b641_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleecdf1c740be1462f8bc462efb19e14b3_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule09621eb001944bc48ed42ff87bfae0fb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule362f941a4d154b53a95f6e9e5e2dd2d2_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule5f394addafe04724b34edcaa91b3f971_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"}
{
"took": 0,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"max_score": null,
"hits": []
},
"aggregations": {
"shipping-free-filter": {
"doc_count": 0,
"shipping-free": {
"value": null
}
},
"rating-exists": {
"doc_count": 96,
"rating": {
"value": 5.0
}
},
"price": {
"count": 96,
"min": 63.75,
"max": 656.74,
"avg": 232.27697916666668,
"sum": 22298.59
},
"options": {
"doc_count": 215,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "faa7d4e361876c7bedf31c39aaf356a6",
"doc_count": 46
},
{
"key": "26a5279743f021d0d1b85cc383de3af0",
"doc_count": 17
},
{
"key": "f26ffa24737d2ef3f4448bc818055c0a",
"doc_count": 12
},
{
"key": "478f5bf6d7fdd995d348d85f3fdd0ca9",
"doc_count": 11
},
{
"key": "e0ff64faa73f8bb53ccc43a80c669163",
"doc_count": 11
},
{
"key": "9ff743aa30237a1aebe36287c4bac123",
"doc_count": 6
},
{
"key": "c16d368e0af6d51dfd96cbaa8818e04b",
"doc_count": 6
},
{
"key": "dc8698f395ed47f18db9853112cf9642",
"doc_count": 6
},
{
"key": "8facf610ff694fc29e3aac7941b60322",
"doc_count": 5
},
{
"key": "bf76b5722d46402fa036f582fe965eba",
"doc_count": 5
},
{
"key": "34b5b2de1b8fe0b6cbea38b4b683b3dc",
"doc_count": 4
},
{
"key": "50dabf9e4dd5652e4b648c4ca7aca0db",
"doc_count": 4
},
{
"key": "53ec464a86f06bec0b9c6101e838a2d4",
"doc_count": 4
},
{
"key": "5c3745fb74c71ddcf052570a45fe5c4c",
"doc_count": 4
},
{
"key": "8a69351444e527b998794bce9b6d57aa",
"doc_count": 4
},
{
"key": "a6696d4a086ede23c7589074dac64552",
"doc_count": 4
},
{
"key": "c390876317a3a10d5bf287debd9e5844",
"doc_count": 4
},
{
"key": "e0f5a5b635f5714bec504948d6763e45",
"doc_count": 4
},
{
"key": "e485d62fd73823ea2d22cfb95a014320",
"doc_count": 4
},
{
"key": "e6e29e823b4375d7e713f6dd805b303e",
"doc_count": 4
},
{
"key": "f94ca398f4bee48afb986112cfd7065b",
"doc_count": 4
},
{
"key": "2a6764c31abae6f7acef6f20b06b8243",
"doc_count": 3
},
{
"key": "7117af1851fa86e42ae2bdefc2d7460d",
"doc_count": 3
},
{
"key": "78636c84542eebfbb032d4fd7a3e4fc6",
"doc_count": 3
},
{
"key": "7ab301fe46184ed9cf768f50c0a896f3",
"doc_count": 3
},
{
"key": "7b38ee40e7f6be0365b4dae070ad5aa3",
"doc_count": 3
},
{
"key": "ab4d9e75e1cfcdae7b0b482bbf1810ee",
"doc_count": 3
},
{
"key": "197d564fb1eed8ba1b4d09725aff95ff",
"doc_count": 2
},
{
"key": "8b9cdf2b00bd3936bb0d842e04b927a5",
"doc_count": 2
},
{
"key": "8e465f6e0be54726aa57d0c01c7b659c",
"doc_count": 2
},
{
"key": "9e2f5067c32396ed2f0ce46be51d9e75",
"doc_count": 2
},
{
"key": "c5941850cf2ca0ea8cc9f370594d675b",
"doc_count": 2
},
{
"key": "e08c1232d36940e49677362b9f9334e9",
"doc_count": 2
},
{
"key": "ec16520bfa04d126842bd7d6e7e88bdb",
"doc_count": 2
},
{
"key": "ef3302123a5e308d7faeb172e19ab106",
"doc_count": 2
},
{
"key": "0ac059f54d83de457212e748ad1ef41c",
"doc_count": 1
},
{
"key": "17bb9aa6bc9ea578fcbd164cfc6e19bd",
"doc_count": 1
},
{
"key": "19e2a00def47f990c3f0f36b84c8567a",
"doc_count": 1
},
{
"key": "1ab7f72629e8dbaccaae484ef157c575",
"doc_count": 1
},
{
"key": "401be8535c3f3f76a8f59083981113c3",
"doc_count": 1
},
{
"key": "40f887a54c2240cc1ef7e7d4d02b7248",
"doc_count": 1
},
{
"key": "5990eb2d7fad239d2c5782928f3139e5",
"doc_count": 1
},
{
"key": "6e3425d51417a94ef3a131c44514294d",
"doc_count": 1
},
{
"key": "cfd9c1ab94de856e9ee248251a258197",
"doc_count": 1
},
{
"key": "d3f41a74d2a64431152115e6c5bace58",
"doc_count": 1
},
{
"key": "e5fb02b494a10378b915a6a74f436fcb",
"doc_count": 1
},
{
"key": "f01436c53a742dcaf565191843c9ba04",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 0,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "d53e599e80968af416d50285bb2ca305",
"doc_count": 90
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|