| 1 |
4.35 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":"d86a58967d480779f43bc495caf590b2"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"kplngiPositions.position":{"nested":{"path":"kplngiPositions","filter":{"term":{"kplngiPositions.categoryId":"d86a58967d480779f43bc495caf590b2"}}},"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": 354,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "0f7b5853c495f6107a0df5df69ac0909",
"_score": null,
"_source": {
"autoIncrement": 3681.0,
"id": "0f7b5853c495f6107a0df5df69ac0909"
},
"fields": {
"displayGroup": [
"f0760f057954dc21e14357d71eaaa0a5"
]
},
"sort": [
90,
"0f7b5853c495f6107a0df5df69ac0909"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "23ece2809da8ffa082c8e304fd11865c",
"_score": null,
"_source": {
"autoIncrement": 3751.0,
"id": "23ece2809da8ffa082c8e304fd11865c"
},
"fields": {
"displayGroup": [
"eae7886520e6f8ca0130be670ac8f5b5"
]
},
"sort": [
88,
"23ece2809da8ffa082c8e304fd11865c"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "084730b5c15a8ba50cced1dbc724c606",
"_score": null,
"_source": {
"autoIncrement": 3774.0,
"id": "084730b5c15a8ba50cced1dbc724c606"
},
"fields": {
"displayGroup": [
"d2cfce5de0bbcf0f77a9856365679f54"
]
},
"sort": [
86,
"084730b5c15a8ba50cced1dbc724c606"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "015d639df6e6cd912045469d67fc0a53",
"_score": null,
"_source": {
"autoIncrement": 3648.0,
"id": "015d639df6e6cd912045469d67fc0a53"
},
"fields": {
"displayGroup": [
"dbfe3fc5bc2cf85bbea66a8fc61c8938"
]
},
"sort": [
85,
"015d639df6e6cd912045469d67fc0a53"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "01c6cef9a71f90bab51343fe1b0018d4",
"_score": null,
"_source": {
"autoIncrement": 3707.0,
"id": "01c6cef9a71f90bab51343fe1b0018d4"
},
"fields": {
"displayGroup": [
"00a14ec0b854696da63eedd3e66dd4c6"
]
},
"sort": [
84,
"01c6cef9a71f90bab51343fe1b0018d4"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "07b698c7069d8745f7c29489f5ff79ef",
"_score": null,
"_source": {
"autoIncrement": 3981.0,
"id": "07b698c7069d8745f7c29489f5ff79ef"
},
"fields": {
"displayGroup": [
"40dfb0b7f57f49ca391fd607eecf35e6"
]
},
"sort": [
55,
"07b698c7069d8745f7c29489f5ff79ef"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018d54845969701289e095389a3b643f",
"_score": null,
"_source": {
"autoIncrement": 10096.0,
"id": "018d54845969701289e095389a3b643f"
},
"fields": {
"displayGroup": [
"198c20a813f5e9cb2088130b2c9927dc"
]
},
"sort": [
0,
"018d54845969701289e095389a3b643f"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018d54d5d828726fa65e1de010af64e5",
"_score": null,
"_source": {
"autoIncrement": 10102.0,
"id": "018d54d5d828726fa65e1de010af64e5"
},
"fields": {
"displayGroup": [
"e8f779df142f4e69c5b9faab1ac66d3b"
]
},
"sort": [
0,
"018d54d5d828726fa65e1de010af64e5"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018d55057d6972bdb5c938c33b51524b",
"_score": null,
"_source": {
"autoIncrement": 10109.0,
"id": "018d55057d6972bdb5c938c33b51524b"
},
"fields": {
"displayGroup": [
"73ef6a535fd0f1ff5e5593373dd6c3b1"
]
},
"sort": [
0,
"018d55057d6972bdb5c938c33b51524b"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018f0ac1049d707d974f9fa5a9aa9045",
"_score": null,
"_source": {
"autoIncrement": 10750.0,
"id": "018f0ac1049d707d974f9fa5a9aa9045"
},
"fields": {
"displayGroup": [
"df0d741747781b060392d212a945a007"
]
},
"sort": [
0,
"018f0ac1049d707d974f9fa5a9aa9045"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018f0ac3ad6671e182bba8ab3a238ce2",
"_score": null,
"_source": {
"autoIncrement": 10759.0,
"id": "018f0ac3ad6671e182bba8ab3a238ce2"
},
"fields": {
"displayGroup": [
"54fa48dfb1393f29653b9f1a42d8a19d"
]
},
"sort": [
0,
"018f0ac3ad6671e182bba8ab3a238ce2"
]
},
{
"_index": "a1_product_1755155181",
"_type": "_doc",
"_id": "018f0b07ecf4722c84a9cbdcaeebb0a5",
"_score": null,
"_source": {
"autoIncrement": 10772.0,
"id": "018f0b07ecf4722c84a9cbdcaeebb0a5"
},
"fields": {
"displayGroup": [
"f2917e38df59d1830d30eb1b3fa6146b"
]
},
"sort": [
0,
"018f0b07ecf4722c84a9cbdcaeebb0a5"
]
}
]
},
"aggregations": {
"total-count": {
"value": 25
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.70 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":"d86a58967d480779f43bc495caf590b2"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"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": 354,
"rating": {
"value": 0.0
}
},
"price": {
"count": 354,
"min": 12.53,
"max": 298.54,
"avg": 54.499802259887005,
"sum": 19292.93
},
"options": {
"doc_count": 746,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "26a5279743f021d0d1b85cc383de3af0",
"doc_count": 100
},
{
"key": "d6dfd93ea77f7e3b54d0ad6ca67bff5d",
"doc_count": 98
},
{
"key": "faa7d4e361876c7bedf31c39aaf356a6",
"doc_count": 96
},
{
"key": "53ec464a86f06bec0b9c6101e838a2d4",
"doc_count": 39
},
{
"key": "8b9cdf2b00bd3936bb0d842e04b927a5",
"doc_count": 39
},
{
"key": "a6696d4a086ede23c7589074dac64552",
"doc_count": 39
},
{
"key": "c390876317a3a10d5bf287debd9e5844",
"doc_count": 39
},
{
"key": "e0f5a5b635f5714bec504948d6763e45",
"doc_count": 39
},
{
"key": "e485d62fd73823ea2d22cfb95a014320",
"doc_count": 39
},
{
"key": "e6e29e823b4375d7e713f6dd805b303e",
"doc_count": 39
},
{
"key": "018f0abebb5872439ef453ae123e20d8",
"doc_count": 37
},
{
"key": "de6b78e5a601918dea6802bd0e805423",
"doc_count": 19
},
{
"key": "018f0ac2207d776e9e6beda1216354ef",
"doc_count": 15
},
{
"key": "e45424b8dbafa27cf36394eb93fbb18e",
"doc_count": 15
},
{
"key": "018f0ac23d857632903b6cc83c2388f9",
"doc_count": 13
},
{
"key": "40f887a54c2240cc1ef7e7d4d02b7248",
"doc_count": 7
},
{
"key": "5990eb2d7fad239d2c5782928f3139e5",
"doc_count": 7
},
{
"key": "c5941850cf2ca0ea8cc9f370594d675b",
"doc_count": 7
},
{
"key": "018d550373a97efb9506d0da93f50565",
"doc_count": 5
},
{
"key": "018d5503aa397c7b97ace208782dfc72",
"doc_count": 5
},
{
"key": "19e2a00def47f990c3f0f36b84c8567a",
"doc_count": 5
},
{
"key": "81aad1f70847c8dadb8590845d0cc193",
"doc_count": 5
},
{
"key": "cfd9c1ab94de856e9ee248251a258197",
"doc_count": 5
},
{
"key": "4a61e71c8588465781541865789f526d",
"doc_count": 4
},
{
"key": "bfc6407b0a0fca01002c1cb1f3af9f30",
"doc_count": 3
},
{
"key": "018f0aafa9db7d2faa8b567393af4698",
"doc_count": 2
},
{
"key": "ae985f9901129012ad86e488e4512092",
"doc_count": 2
},
{
"key": "f01436c53a742dcaf565191843c9ba04",
"doc_count": 2
},
{
"key": "018f0a6341d97cf19334235502665653",
"doc_count": 1
},
{
"key": "018f0a6372307c9fa1554933d10aa60f",
"doc_count": 1
},
{
"key": "018f0a639e50762eb000a4de3b41df77",
"doc_count": 1
},
{
"key": "018f0a63c92075ac88e459f357536ed1",
"doc_count": 1
},
{
"key": "018f0a63f5787ecca65d7bf90270cd34",
"doc_count": 1
},
{
"key": "018f0a642700785ebd11a484a82612d7",
"doc_count": 1
},
{
"key": "018f0a6465587c488a9f0dd603403a68",
"doc_count": 1
},
{
"key": "018f0a648b587c60b2494e29e974ea2d",
"doc_count": 1
},
{
"key": "0bde299bfea044f18351ea484d3646fe",
"doc_count": 1
},
{
"key": "226ef05f54f54612899545b7ebbec3ec",
"doc_count": 1
},
{
"key": "3e78be50caa14e37bd2a50bc6aa4db98",
"doc_count": 1
},
{
"key": "59bb688e854a4fffbf567be993956f5c",
"doc_count": 1
},
{
"key": "7a56ea9eebb54b4e8adf9e900581d2f6",
"doc_count": 1
},
{
"key": "89dbda15e64443c3a9e01473d9bac7b7",
"doc_count": 1
},
{
"key": "9977a7a4621c4cafb4de4b5c059af0ad",
"doc_count": 1
},
{
"key": "bf76b5722d46402fa036f582fe965eba",
"doc_count": 1
},
{
"key": "ceed6bd600cf4ba296a3f93f1aac8ca2",
"doc_count": 1
},
{
"key": "e111e85e26d642219d6b9093f5914ea6",
"doc_count": 1
},
{
"key": "ebcd25e386cf4bfa879a2bef264d7a2d",
"doc_count": 1
},
{
"key": "f2599cab85e069abf0c0f86be12cb098",
"doc_count": 1
},
{
"key": "feb2d9715355c69766a9373cdc802f97",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 148,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "28c8207c042dd6ebbcf338b44018e8e1",
"doc_count": 43
},
{
"key": "6bfd27b071bb59a11fa0aa5124f4146c",
"doc_count": 42
},
{
"key": "e45424b8dbafa27cf36394eb93fbb18e",
"doc_count": 42
},
{
"key": "8b9cdf2b00bd3936bb0d842e04b927a5",
"doc_count": 21
}
]
}
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|