| 1 |
1086.09 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018997a5d719700599784b62907984d6"}}}},{"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":16,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1083,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 1042,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_all4team_product_1716336301",
"_id": "018af45d9e2d724eac7fe5624bd3eec6",
"_score": null,
"_source": {
"autoIncrement": 1130929.0,
"id": "018af45d9e2d724eac7fe5624bd3eec6"
},
"fields": {
"displayGroup": [
"938b905d705a768fe3a03a0fd056d92d"
]
},
"sort": [
0,
"018af45d9e2d724eac7fe5624bd3eec6"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bce8a7a2473a0bbf92a3559393f48",
"_score": null,
"_source": {
"autoIncrement": 1136001.0,
"id": "018bce8a7a2473a0bbf92a3559393f48"
},
"fields": {
"displayGroup": [
"2b9530d7c89b50eca0c3153e40aae252"
]
},
"sort": [
0,
"018bce8a7a2473a0bbf92a3559393f48"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bcfce4e44715ea1aa46cc2eac222c",
"_score": null,
"_source": {
"autoIncrement": 1136095.0,
"id": "018bcfce4e44715ea1aa46cc2eac222c"
},
"fields": {
"displayGroup": [
"3e8715fa322ba05585f5ca4c259a6a1c"
]
},
"sort": [
0,
"018bcfce4e44715ea1aa46cc2eac222c"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd020f6b373e790e15a0287eaddbb",
"_score": null,
"_source": {
"autoIncrement": 1136122.0,
"id": "018bd020f6b373e790e15a0287eaddbb"
},
"fields": {
"displayGroup": [
"ca4655244a19042b0f2c259b8f5b50bc"
]
},
"sort": [
0,
"018bd020f6b373e790e15a0287eaddbb"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018bd027cdef713d8654e02c49a4dd22",
"_score": null,
"_source": {
"autoIncrement": 1136244.0,
"id": "018bd027cdef713d8654e02c49a4dd22"
},
"fields": {
"displayGroup": [
"fde305326341cbe9df3c59111108b654"
]
},
"sort": [
0,
"018bd027cdef713d8654e02c49a4dd22"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c7f071b6471cca4c783132dc964cf",
"_score": null,
"_source": {
"autoIncrement": 1162487.0,
"id": "018c7f071b6471cca4c783132dc964cf"
},
"fields": {
"displayGroup": [
"6050b99e7cbcff459feaca846c8c34d0"
]
},
"sort": [
0,
"018c7f071b6471cca4c783132dc964cf"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80c5533272b6be5f39b1381d7e03",
"_score": null,
"_source": {
"autoIncrement": 1164654.0,
"id": "018c80c5533272b6be5f39b1381d7e03"
},
"fields": {
"displayGroup": [
"a04cb2ef8534114a5d8c1093a0867212"
]
},
"sort": [
0,
"018c80c5533272b6be5f39b1381d7e03"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80c6f3a071e2b208e7dc3ce61564",
"_score": null,
"_source": {
"autoIncrement": 1164683.0,
"id": "018c80c6f3a071e2b208e7dc3ce61564"
},
"fields": {
"displayGroup": [
"94602a96361d2ab1585a9e162207d762"
]
},
"sort": [
0,
"018c80c6f3a071e2b208e7dc3ce61564"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80d9e32970bb9b7969fe95402f92",
"_score": null,
"_source": {
"autoIncrement": 1164884.0,
"id": "018c80d9e32970bb9b7969fe95402f92"
},
"fields": {
"displayGroup": [
"8c0aa7e93987e838d8dd5a2ae7463265"
]
},
"sort": [
0,
"018c80d9e32970bb9b7969fe95402f92"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80de404271d8861cdb210275e430",
"_score": null,
"_source": {
"autoIncrement": 1164924.0,
"id": "018c80de404271d8861cdb210275e430"
},
"fields": {
"displayGroup": [
"aa05f56a4b7dad60e8edfbbdae55af6a"
]
},
"sort": [
0,
"018c80de404271d8861cdb210275e430"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80df35ef73d2b0120a941cfe6e34",
"_score": null,
"_source": {
"autoIncrement": 1164945.0,
"id": "018c80df35ef73d2b0120a941cfe6e34"
},
"fields": {
"displayGroup": [
"e8866e6c8d372d674fd7e8348dafb611"
]
},
"sort": [
0,
"018c80df35ef73d2b0120a941cfe6e34"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80e3bd74724e92e442b44d6c3581",
"_score": null,
"_source": {
"autoIncrement": 1164999.0,
"id": "018c80e3bd74724e92e442b44d6c3581"
},
"fields": {
"displayGroup": [
"a7a6976439c5dbb63e8c98e7e4d12f3c"
]
},
"sort": [
0,
"018c80e3bd74724e92e442b44d6c3581"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80e5f48a7255baa27e885ef2ed10",
"_score": null,
"_source": {
"autoIncrement": 1165036.0,
"id": "018c80e5f48a7255baa27e885ef2ed10"
},
"fields": {
"displayGroup": [
"0c0a6aa13f48ba7d6f618e06a16482af"
]
},
"sort": [
0,
"018c80e5f48a7255baa27e885ef2ed10"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80e65a627070a7eeddef7b56f63f",
"_score": null,
"_source": {
"autoIncrement": 1165046.0,
"id": "018c80e65a627070a7eeddef7b56f63f"
},
"fields": {
"displayGroup": [
"bdc97f0efe66ecd51b5d6635a274c94d"
]
},
"sort": [
0,
"018c80e65a627070a7eeddef7b56f63f"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80e6ca0f72b38d9d8d416e63e29e",
"_score": null,
"_source": {
"autoIncrement": 1165057.0,
"id": "018c80e6ca0f72b38d9d8d416e63e29e"
},
"fields": {
"displayGroup": [
"efd4934ae62afbd3e4d6389fa0ecb3a8"
]
},
"sort": [
0,
"018c80e6ca0f72b38d9d8d416e63e29e"
]
},
{
"_index": "sw_all4team_product_1716336301",
"_id": "018c80e88fdb73b881863ece7389e1ae",
"_score": null,
"_source": {
"autoIncrement": 1165091.0,
"id": "018c80e88fdb73b881863ece7389e1ae"
},
"fields": {
"displayGroup": [
"91e50e4f6b852e933c804ecd7cf1986f"
]
},
"sort": [
0,
"018c80e88fdb73b881863ece7389e1ae"
]
}
]
},
"aggregations": {
"total-count": {
"value": 98
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
11.64 ms |
Request:
{"index":"sw_all4team_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":"a4d331012b00410ab817a4dd8c7bc7f0"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"018997a5d719700599784b62907984d6"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"aggregations":{"manufacturer":{"terms":{"field":"manufacturerId","size":10000}},"price":{"stats":{"script":{"id":"cheapest_price","params":{"accessors":[{"key":"cheapest_price_rule1eac567d7d314563bfa3305e2e8446bb_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule9628985660b5415c9ee8f65bade111bf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleeb63558ebb734bde8518103eff3442cf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule8444b9bcc809444aa5a3fe1f3260a9cc_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule43a89e1a4b454d078913ef45f83aafdf_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6e3190c99cf44a80a3b9407e5e813c45_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": 9,
"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": 1042,
"rating": {
"value": 0.0
}
},
"price": {
"count": 1042,
"min": 35.96,
"max": 208.0,
"avg": 120.06947216890596,
"sum": 125112.39000000001
},
"options": {
"doc_count": 2084,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "018d79675466735989015568610f58b3",
"doc_count": 80
},
{
"key": "018d7967562073d29d87ac0d1805a758",
"doc_count": 80
},
{
"key": "2055b8652dba4a38bb12157ef8bd8e7c",
"doc_count": 69
},
{
"key": "c4ca7c83d7b9434dba35d808f3cb587b",
"doc_count": 69
},
{
"key": "6f242ff7ed204f40be74447de407e8b9",
"doc_count": 67
},
{
"key": "24825ae0f7ff41bdbddc49e34931df58",
"doc_count": 64
},
{
"key": "d32f5d7c6ff24f32ac2cef76583b3ff3",
"doc_count": 61
},
{
"key": "e1b2548665464da9b4f051e46c78427f",
"doc_count": 61
},
{
"key": "018d796752da71d4bc16000988e14500",
"doc_count": 60
},
{
"key": "018dcc33ef3e71b98f00b79ebc1d3165",
"doc_count": 60
},
{
"key": "018dcc33f84c71f49a5cfac761b33f39",
"doc_count": 60
},
{
"key": "98d6bcd6d5da4c45a80c847b8f441853",
"doc_count": 60
},
{
"key": "528d738a30b847248434b14e905cd91c",
"doc_count": 59
},
{
"key": "799eeec01566421399f0186a0c1929ae",
"doc_count": 59
},
{
"key": "2ef77dd834ab4ad8bf116883a3624328",
"doc_count": 58
},
{
"key": "f166e204f18a46cd947eb253dc245521",
"doc_count": 57
},
{
"key": "c36af3803d914e8bb422246a1b400a68",
"doc_count": 56
},
{
"key": "fb2bcb1d04544f8e91cab9caadccd0e2",
"doc_count": 55
},
{
"key": "01909baa4d9072658b9722deb8eea0a6",
"doc_count": 49
},
{
"key": "01901bd3339372b696de1abd019141c9",
"doc_count": 47
},
{
"key": "01909baa289473c988f5798b39a2ba9c",
"doc_count": 45
},
{
"key": "018d7967553a72ca97faf14b9d69a419",
"doc_count": 40
},
{
"key": "018d7967fbc47234a7737c0c64fb6b7a",
"doc_count": 39
},
{
"key": "97610a9e8a0f4970a7be7eec0bac0378",
"doc_count": 39
},
{
"key": "b5a3d8c7138344dda67987a4eff4cb1c",
"doc_count": 39
},
{
"key": "7189e238f66c4db8831ad403f65df75e",
"doc_count": 38
},
{
"key": "a5d7196c2514479f857621c32bb84608",
"doc_count": 36
},
{
"key": "018c690369a9714988c0ae7e113fee13",
"doc_count": 34
},
{
"key": "01909baa8a5e71d19a057b33fe293e3d",
"doc_count": 34
},
{
"key": "c0088ccb433c49aaadfc61d1966f804c",
"doc_count": 34
},
{
"key": "01909baa426d72e6a4ee1d0950c74af3",
"doc_count": 32
},
{
"key": "64a44b3d85144a88b890b250e7030d5f",
"doc_count": 31
},
{
"key": "018d7967fafa739ca534d305df0a5e14",
"doc_count": 30
},
{
"key": "0190020586ce702ab69a9dbdbddfffac",
"doc_count": 27
},
{
"key": "963c02f9686c41b78991f4dfa5ab9df0",
"doc_count": 24
},
{
"key": "c2725e1f949d43afafbd92ebcdce5798",
"doc_count": 24
},
{
"key": "018c69038764708789affe7ed0a20b95",
"doc_count": 21
},
{
"key": "01909baa8de17351bcc7515ba3f6e4d4",
"doc_count": 21
},
{
"key": "018d796753a4710b85d12880bdf47b61",
"doc_count": 20
},
{
"key": "01900205879f7248867868c412fc658d",
"doc_count": 20
},
{
"key": "01909baa6cbc71deaaf0a7271455cdca",
"doc_count": 20
},
{
"key": "fefc7b01e0504b2fb7aa23b3115fe4f8",
"doc_count": 19
},
{
"key": "019091974b0f73d88d5927c8ac9dc0f6",
"doc_count": 18
},
{
"key": "018c690374bb738aa0421895b19398ff",
"doc_count": 17
},
{
"key": "b4bcc055f4b34f45ac8470f8a86812a3",
"doc_count": 14
},
{
"key": "0190da3aa17072389aa7eb2bb7f19c1e",
"doc_count": 13
},
{
"key": "cc4753803ac847488249766b9d781a1c",
"doc_count": 12
},
{
"key": "01909baa8d2f73ff99d303a16c1c9075",
"doc_count": 11
},
{
"key": "018dcc33b77c727da1e18a8cf002c746",
"doc_count": 10
},
{
"key": "c724ee9bd7754d9a910e8d5b9fa1b3ca",
"doc_count": 10
},
{
"key": "209a3a1ec0e146688922fb9d78b72f61",
"doc_count": 8
},
{
"key": "553f8a96a4a7482492b9366a809808ff",
"doc_count": 8
},
{
"key": "0190bff52322723e85a8d0f6d7aaa9d4",
"doc_count": 7
},
{
"key": "01905399025b7153ad0c9bfb1f993ecd",
"doc_count": 6
},
{
"key": "01909baa4b84707f9692c31e85b5aa7e",
"doc_count": 5
},
{
"key": "36791028e5ef45ecbaf35597ff8a28af",
"doc_count": 5
},
{
"key": "018ae4b0ca6a7172935b998966ab255f",
"doc_count": 3
},
{
"key": "01909baa7787700aa1a69f48d387f0d4",
"doc_count": 3
},
{
"key": "01909baa8bc972fabf1db7d9d31404f1",
"doc_count": 3
},
{
"key": "01912bdec4c1700b88d322bab69c6f84",
"doc_count": 3
},
{
"key": "b9098912ba704078bf6482acae250e23",
"doc_count": 3
},
{
"key": "018b1d84e12872bfaa582e09412439e5",
"doc_count": 2
},
{
"key": "018c6903afdd7108bb99b8138b771842",
"doc_count": 2
},
{
"key": "04fba7aa2b5e4d4ba49f6e2464da8644",
"doc_count": 2
},
{
"key": "189e0d4708a24426bd8480e503c94688",
"doc_count": 2
},
{
"key": "a132823eaf34421c82c307567af7ec32",
"doc_count": 2
},
{
"key": "018991241ae7715b941e3918af6f802d",
"doc_count": 1
},
{
"key": "018c69039e59723282973c592da64656",
"doc_count": 1
},
{
"key": "018c6903dbc1708ebca55ceac7a01ff9",
"doc_count": 1
},
{
"key": "018c6903f3f971758444c23fcbd4b6e9",
"doc_count": 1
},
{
"key": "018c6905b7ba709792acc4a09abf660b",
"doc_count": 1
},
{
"key": "018d7968347b72d48174ede3be50eded",
"doc_count": 1
},
{
"key": "01909baa7830735b8922c00ab7cb2dfc",
"doc_count": 1
},
{
"key": "019afb4baa7a4bb99438f94850b0bd02",
"doc_count": 1
},
{
"key": "25148b6f5f0d491d8c6f8797b4c6543d",
"doc_count": 1
},
{
"key": "5c23066550c842a1af8ee4c4991dad06",
"doc_count": 1
},
{
"key": "6d52ade7717943d98cc7291f3dc49429",
"doc_count": 1
},
{
"key": "7b2fa4e44614444b929ed07b341af60b",
"doc_count": 1
},
{
"key": "7bbdfaf83d4d4a4fa47fa60b8755abe8",
"doc_count": 1
},
{
"key": "a3c0ad99cd1742e485ac4f5f5773c6e0",
"doc_count": 1
},
{
"key": "a4e97b2e7eb04de18ec3211fbe84d132",
"doc_count": 1
},
{
"key": "d057831af7b84e9bac3494c4626fd098",
"doc_count": 1
},
{
"key": "fbd0766f0ed84f27b87c1475956d6830",
"doc_count": 1
}
]
}
},
"properties": {
"doc_count": 3830,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0189641274787261940e7deefdf7df10",
"doc_count": 672
},
{
"key": "018963e5f13871739bde1b0eb26bb21b",
"doc_count": 566
},
{
"key": "01896411e3007292bbf291a9837a8cc8",
"doc_count": 409
},
{
"key": "018963e5f53b7292b003bf6803f624b7",
"doc_count": 408
},
{
"key": "01896411e11071498f66a862f5383700",
"doc_count": 306
},
{
"key": "018963ea3aba7042895b047285c1402e",
"doc_count": 290
},
{
"key": "018963ea1812737fb7f416641565cd24",
"doc_count": 210
},
{
"key": "01896411e3af718192fb7f9ee45ad6fb",
"doc_count": 158
},
{
"key": "018bbe147153736fbaa17cb7d91264a8",
"doc_count": 138
},
{
"key": "018963ea20b670278236dc7103bcceb8",
"doc_count": 120
},
{
"key": "018963ea336b7003ba1d74549036192d",
"doc_count": 84
},
{
"key": "018dcc3373f47133833772ee8dfc3fe4",
"doc_count": 79
},
{
"key": "018963ea415c7217b4dc8cb62572ed16",
"doc_count": 64
},
{
"key": "018963e5f06f716dadb0fe95b3c53d22",
"doc_count": 62
},
{
"key": "01896412d947725f982fc682b748509d",
"doc_count": 46
},
{
"key": "018963ea1a0071e3b903843432a2818e",
"doc_count": 40
},
{
"key": "018963ea3609712896e2d21c3a2d91ab",
"doc_count": 34
},
{
"key": "0189641273cb72ef99ebded9d2fde054",
"doc_count": 34
},
{
"key": "018963ea200e72729f584195f4b57171",
"doc_count": 24
},
{
"key": "018963ea2bce70d7876c75f434e017d1",
"doc_count": 22
},
{
"key": "018e189e519d727da799335a95ed6e51",
"doc_count": 20
},
{
"key": "018f05bdaf8f701b8421f409a878c944",
"doc_count": 20
},
{
"key": "01896412726f738286e29c074c21499b",
"doc_count": 13
},
{
"key": "018abc1fb8d371e781e6c47ddfe830f7",
"doc_count": 3
},
{
"key": "018abc1fc19170718d643452f6d9a067",
"doc_count": 3
},
{
"key": "018963ea24c172519a11176e570bcae4",
"doc_count": 2
},
{
"key": "018bbe13b6c57304b719d27003780cfe",
"doc_count": 2
},
{
"key": "018963ea3964707fbbfb35b2b8e8084b",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "57f85a1341f34ad284dc91714711a009",
"doc_count": 582
},
{
"key": "d8ac016c293145ff9d20f96184a4ad02",
"doc_count": 423
},
{
"key": "6f10e4ac0c444f1a91667bad688d924f",
"doc_count": 37
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|