| 1 |
2.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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"07c9b9b8573d44f0889fffb325f8e76a"}}}},{"bool":{"must_not":[{"bool":{"must_not":[{"exists":{"field":"displayGroup"}}]}}]}}]}}]}},"sort":[{"_script":{"type":"number","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;\n }\n}\n\nif (params['order'] == 'asc') {\n return Double.MAX_VALUE;\n}\n\nreturn Double.MIN_VALUE;\n","lang":"painless","params":{"field":"customFields","languages":["2fbb5fe2e29a4d70aa5854ce7ce3e20b"],"suffix":"custom_product_rosland_set_year","order":"desc"}},"order":"DESC"}},{"id":{"order":"ASC"}}],"aggregations":{"total-count":{"cardinality":{"field":"displayGroup"}}},"from":36,"size":36,"collapse":{"field":"displayGroup"},"timeout":"5s"}}
{
"took": 1,
"timed_out": false,
"_shards": {
"total": 3,
"successful": 3,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 47,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "sw_product_1717666750",
"_id": "fd1241dfb0914c928f9fd7eeef6bc794",
"_score": null,
"_source": {
"id": "fd1241dfb0914c928f9fd7eeef6bc794",
"autoIncrement": 2830.0
},
"fields": {
"displayGroup": [
"98637312d6c8b43fb7c28c6e7855e33d"
]
},
"sort": [
2004.0,
"fd1241dfb0914c928f9fd7eeef6bc794"
]
},
{
"_index": "sw_product_1717666750",
"_id": "2a10fe09102b4efd92e7f8b83694e1f7",
"_score": null,
"_source": {
"id": "2a10fe09102b4efd92e7f8b83694e1f7",
"autoIncrement": 3692.0
},
"fields": {
"displayGroup": [
"045c2a1200109395aa8ec014fae65e78"
]
},
"sort": [
2003.0,
"2a10fe09102b4efd92e7f8b83694e1f7"
]
},
{
"_index": "sw_product_1717666750",
"_id": "40ce7f72f5294bb188e47fbea9e0c6d3",
"_score": null,
"_source": {
"id": "40ce7f72f5294bb188e47fbea9e0c6d3",
"autoIncrement": 2834.0
},
"fields": {
"displayGroup": [
"13fb35a5de7bc3ed28248c209d5942ee"
]
},
"sort": [
2003.0,
"40ce7f72f5294bb188e47fbea9e0c6d3"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9f4d82015fd04739a910e0094679321d",
"_score": null,
"_source": {
"id": "9f4d82015fd04739a910e0094679321d",
"autoIncrement": 2838.0
},
"fields": {
"displayGroup": [
"7ddbd86e1867e9fdbfaf082dc2e04bd6"
]
},
"sort": [
2003.0,
"9f4d82015fd04739a910e0094679321d"
]
},
{
"_index": "sw_product_1717666750",
"_id": "9fc9df7d7d1542d7b54146e30dc4db52",
"_score": null,
"_source": {
"id": "9fc9df7d7d1542d7b54146e30dc4db52",
"autoIncrement": 2835.0
},
"fields": {
"displayGroup": [
"5e7ce803dac8af05894805ee6a99bdf3"
]
},
"sort": [
2003.0,
"9fc9df7d7d1542d7b54146e30dc4db52"
]
},
{
"_index": "sw_product_1717666750",
"_id": "a30ca28a51d34a57b5695a529bbf4bff",
"_score": null,
"_source": {
"id": "a30ca28a51d34a57b5695a529bbf4bff",
"autoIncrement": 2836.0
},
"fields": {
"displayGroup": [
"dd4eedb4939b11ad805a351a6dcf7f9d"
]
},
"sort": [
2003.0,
"a30ca28a51d34a57b5695a529bbf4bff"
]
},
{
"_index": "sw_product_1717666750",
"_id": "f372ed95e3f54c0593e0f90c7d85143b",
"_score": null,
"_source": {
"id": "f372ed95e3f54c0593e0f90c7d85143b",
"autoIncrement": 2837.0
},
"fields": {
"displayGroup": [
"70abf7969e5de2ab65ca426a7518e69e"
]
},
"sort": [
2003.0,
"f372ed95e3f54c0593e0f90c7d85143b"
]
},
{
"_index": "sw_product_1717666750",
"_id": "636b6e4908c04230b237504b400708a8",
"_score": null,
"_source": {
"id": "636b6e4908c04230b237504b400708a8",
"autoIncrement": 946.0
},
"fields": {
"displayGroup": [
"ade1bfb78c99ec2c91d363036231c9ed"
]
},
"sort": [
2002.0,
"636b6e4908c04230b237504b400708a8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "fb7dd6597918416d9b357e6d902122a8",
"_score": null,
"_source": {
"id": "fb7dd6597918416d9b357e6d902122a8",
"autoIncrement": 947.0
},
"fields": {
"displayGroup": [
"7126c8dda38b6bf3dcca89647dc53f15"
]
},
"sort": [
2001.0,
"fb7dd6597918416d9b357e6d902122a8"
]
},
{
"_index": "sw_product_1717666750",
"_id": "bddd515d6b90436193545874a3d02038",
"_score": null,
"_source": {
"id": "bddd515d6b90436193545874a3d02038",
"autoIncrement": 2777.0
},
"fields": {
"displayGroup": [
"1d6743333f425eec05cac425d3457efd"
]
},
"sort": [
2000.0,
"bddd515d6b90436193545874a3d02038"
]
},
{
"_index": "sw_product_1717666750",
"_id": "8928c3c152984a5db2ee12850f157590",
"_score": null,
"_source": {
"id": "8928c3c152984a5db2ee12850f157590",
"autoIncrement": 948.0
},
"fields": {
"displayGroup": [
"b08b4411b9a2dcd15ba088b3f7392743"
]
},
"sort": [
1999.0,
"8928c3c152984a5db2ee12850f157590"
]
}
]
},
"aggregations": {
"total-count": {
"value": 47
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntitySearcher:search
|
| 2 |
1.17 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":"250c23c94a704f8ba1b4819c38901688"}}]}}}},{"term":{"active":true}}]}},{"nested":{"path":"categoriesRo","query":{"term":{"categoriesRo.id":"07c9b9b8573d44f0889fffb325f8e76a"}}}},{"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_rule64bf19224e314563aba24460dda765f8_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule89d3fe06bd7c478194fe9179a9602df5_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruled980a6dfc7774cd192e0b1a183764274_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbc995737796b164a7b5355b5d_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule01961afbca2673cf9fb2d67da0cd8a62_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d10e7293b705c1d0eee95b29_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule0197e9e4d446718a91aafc7b03ab341a_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rule6235b68395cd475f90278d41d7b1b36c_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_ruleac5af03b5965434681e7c4cb42720d2b_currencyb7d2554b0ce847cd82f3ac9bd1c0dfca_gross","factor":1},{"key":"cheapest_price_rulecc1de6f5416545d3a68a00f78e8f20f3_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": 47,
"rating": {
"value": 0.0
}
},
"price": {
"count": 47,
"min": 4.76,
"max": 303.56,
"avg": 52.74808510638297,
"sum": 2479.16
},
"options": {
"doc_count": 0,
"options": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": []
}
},
"properties": {
"doc_count": 693,
"properties": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "45018ee86cc84c47b8d18583215e11fb",
"doc_count": 47
},
{
"key": "59e1857b1afd4723bb1349a45de3c652",
"doc_count": 47
},
{
"key": "d3cfb18b53ee4a4486a2f4d64f53934f",
"doc_count": 47
},
{
"key": "de88ad12fea44d74b9c2a1f1edf7ecdf",
"doc_count": 47
},
{
"key": "c00d09ec51844aefa2781fcc00839644",
"doc_count": 46
},
{
"key": "0c189ea565ab4573a222115adc6b9258",
"doc_count": 45
},
{
"key": "b81318b1758e42bc8be1559a7f6df0bc",
"doc_count": 45
},
{
"key": "f7fcd5b43919408abc47ad22817057e8",
"doc_count": 35
},
{
"key": "256aa072d598469cbe2a99d63859b36e",
"doc_count": 20
},
{
"key": "674eeda781014bc7b35fe9b6e2849616",
"doc_count": 20
},
{
"key": "d7835742aa644750b59473d1d473ccf7",
"doc_count": 20
},
{
"key": "e216ce0edfdd40e4af8bbf624a6da3cf",
"doc_count": 20
},
{
"key": "f3addfa0aa8f492b93ef4d41f76ff1fd",
"doc_count": 20
},
{
"key": "bf2d854da22c41e0a79a72de4697db5b",
"doc_count": 11
},
{
"key": "05562f74e05a4ac8b043a602c3d29b33",
"doc_count": 9
},
{
"key": "2ed4db6360c14b399e9a8cf4a1dd9ae1",
"doc_count": 9
},
{
"key": "341ff6d6c80d4c1881746356222ce979",
"doc_count": 9
},
{
"key": "bcfd8dff179149088e720a4ff4527e56",
"doc_count": 9
},
{
"key": "c1d70719badf4382b9dabd1bb5a380bf",
"doc_count": 9
},
{
"key": "b0fd24cfb9784ab4a1236ab5ece09415",
"doc_count": 8
},
{
"key": "d4a351b83deb42719a00ef284e34b4ce",
"doc_count": 7
},
{
"key": "477ed0ba0c3c41cb824e1b100fa514e4",
"doc_count": 6
},
{
"key": "4f146b4ced904c95b0ff8ceaf78bfe3a",
"doc_count": 6
},
{
"key": "ce44d69a3e4e46ce9aa84b8515364889",
"doc_count": 6
},
{
"key": "60f3a33fb6e74ec0b6c83ace74194df5",
"doc_count": 5
},
{
"key": "79709bed515d4a1593cdc09df948021e",
"doc_count": 5
},
{
"key": "85007d00dbb3447c90183857550eb42a",
"doc_count": 5
},
{
"key": "b57d1d0eb833459bbda07a3adca6714c",
"doc_count": 5
},
{
"key": "beb3700040e8485a9994e2820548b7e6",
"doc_count": 5
},
{
"key": "c5c1e052273b4b278bd7b35d4b08f737",
"doc_count": 5
},
{
"key": "d05dd45890424f4faf761fc1f84c2e0c",
"doc_count": 5
},
{
"key": "d3d5f5b588c245969cee684bab181c26",
"doc_count": 5
},
{
"key": "df645bb76fa841758154beea7f0a25fb",
"doc_count": 5
},
{
"key": "fa4d302b3fd54418899166bcabe83011",
"doc_count": 5
},
{
"key": "083db8ec4567465892b2a20082470573",
"doc_count": 4
},
{
"key": "1c0d0618551a4fbd8e2c1f177fcbcf5c",
"doc_count": 4
},
{
"key": "2ba9657c9c574e9aa85f70814078ad7e",
"doc_count": 4
},
{
"key": "b4c86dbcd64f43be8b002a444f8debe9",
"doc_count": 4
},
{
"key": "bb62085cec734c48a25a9f07470cf013",
"doc_count": 4
},
{
"key": "2cfa71698f8846af805a68264beefa3c",
"doc_count": 3
},
{
"key": "b8dd631079d34d42b559a3eb42f6cfa6",
"doc_count": 3
},
{
"key": "20f303b36f324b76b6e0a82871ef411a",
"doc_count": 2
},
{
"key": "34916bf3da894f7180f7435dad3a858c",
"doc_count": 2
},
{
"key": "5b2854b6c9da458e8bf92359a79545e8",
"doc_count": 2
},
{
"key": "5b8f5b04a97b47e2b04efe565e99a70a",
"doc_count": 2
},
{
"key": "97e91b44c63045459a74bf3a7637a658",
"doc_count": 2
},
{
"key": "9a314d841d214d29ba8d05100e2bf1be",
"doc_count": 2
},
{
"key": "9a60f14fa86443ff98d00b82e1578dd0",
"doc_count": 2
},
{
"key": "abbcb2d5daef4e48b2de096d7861d858",
"doc_count": 2
},
{
"key": "ae8861666537407e96ac74cbd9c9ad62",
"doc_count": 2
},
{
"key": "bb2aca011dc44badab027fb55a1ec97b",
"doc_count": 2
},
{
"key": "0b764a915436467e9c6fe52c9c0c3871",
"doc_count": 1
},
{
"key": "1065f6b1603541e49f6f72351bbf25a4",
"doc_count": 1
},
{
"key": "16ef216bb1a641fc85d55aaa03d4f99f",
"doc_count": 1
},
{
"key": "1b24e300d88f4afd9d3e731155af6773",
"doc_count": 1
},
{
"key": "1b99b434aa1f4141b86f2680036dac30",
"doc_count": 1
},
{
"key": "1cb1dcb17dda4c91aad2af8e15eae7c9",
"doc_count": 1
},
{
"key": "326d89dca34944d78dc9377e0dd7f7f3",
"doc_count": 1
},
{
"key": "33a6b259d7944757808f958567245fb9",
"doc_count": 1
},
{
"key": "38a1c28f3faa4f938e817c9c73fbbd76",
"doc_count": 1
},
{
"key": "3968de550f954519a073fed7640da0f4",
"doc_count": 1
},
{
"key": "3f10af82ac584b82930bf40f2c824d24",
"doc_count": 1
},
{
"key": "46613dc878314820abbdf57592aab74d",
"doc_count": 1
},
{
"key": "46e7c7a0e190481ea70d0cc58b69869e",
"doc_count": 1
},
{
"key": "4c2c45ff951746bba56f28de20485951",
"doc_count": 1
},
{
"key": "50bede51bbaa4f4aba7003a45cf998b3",
"doc_count": 1
},
{
"key": "51ebe59299ac4057b371590d933448f3",
"doc_count": 1
},
{
"key": "64a1686ce2c241a3bfa4992fa70f2021",
"doc_count": 1
},
{
"key": "699db85cbd8e47f7a09d1b18e0c0020a",
"doc_count": 1
},
{
"key": "6c6e4b3b16dd490c869fec120d0c3658",
"doc_count": 1
},
{
"key": "8046c2026757422e8de8c94728320b90",
"doc_count": 1
},
{
"key": "87f94408a3f14a54beefaa41491bd998",
"doc_count": 1
},
{
"key": "8dedb3f255ff420ba88ac7fb25b2d50c",
"doc_count": 1
},
{
"key": "9270bfdb608f44aba87a8540c8d22a10",
"doc_count": 1
},
{
"key": "9861fdd7cd7f48188c9ab82dd0c9556a",
"doc_count": 1
},
{
"key": "98733cf7ab3949c9a2441b203474bada",
"doc_count": 1
},
{
"key": "992610eade794a98b43096715b0224b3",
"doc_count": 1
},
{
"key": "99587f4cfa6a4ccf83bec18aba48296d",
"doc_count": 1
},
{
"key": "a143792440454128811cdf655f4948d7",
"doc_count": 1
},
{
"key": "a8cb2303d74b4dc9984cfc9aca7bd5d1",
"doc_count": 1
},
{
"key": "abe8240a5c2c439995bf24d426750062",
"doc_count": 1
},
{
"key": "b0c9937a2b57415c94130771f0a195cb",
"doc_count": 1
},
{
"key": "b2c74771ddb84238a9b55acb7eb21c26",
"doc_count": 1
},
{
"key": "b4ef700d56064e7181222d88e3840ef9",
"doc_count": 1
},
{
"key": "b833cbf5848645cca4945840955cd43d",
"doc_count": 1
},
{
"key": "bc61601b0de04809aa7595b80d498864",
"doc_count": 1
},
{
"key": "bfeb3a8f47334625946a49780d00db95",
"doc_count": 1
},
{
"key": "c37689da165347f49209c68da31c5156",
"doc_count": 1
},
{
"key": "c88d4ee1a0ee4b319300ccbf8e3b8709",
"doc_count": 1
},
{
"key": "d203639f7b4541deab3c1d6440258dd4",
"doc_count": 1
},
{
"key": "d2d71b3e638345cf84df70f0bbb9e79f",
"doc_count": 1
},
{
"key": "d4a1739f69934f898d3684dc7882e6e5",
"doc_count": 1
},
{
"key": "d804c7d60d234da5be9b928f6dea57f6",
"doc_count": 1
},
{
"key": "da73ead1b1964a929f9369fb17e21c3b",
"doc_count": 1
},
{
"key": "de9dd8e6f87942da83e00cc6769b431f",
"doc_count": 1
},
{
"key": "e2e2bd2bb5594c099391cbdb7e9a256a",
"doc_count": 1
},
{
"key": "ef9422359a4c4da7b43ceacadc1cb1d7",
"doc_count": 1
},
{
"key": "ef9f4c4cd5514a7288f34df82446e8b4",
"doc_count": 1
},
{
"key": "efc6378f781f411f9252ed2dc4ee7a11",
"doc_count": 1
},
{
"key": "f7ded2974b4b4bf4b0830e85209f9cf9",
"doc_count": 1
}
]
}
},
"manufacturer": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "0c6346a583ce4d0c93a8911b89371b9a",
"doc_count": 47
}
]
}
}
}
Shopware\Elasticsearch\Framework\DataAbstractionLayer\ElasticsearchEntityAggregator:aggregate
|