Debug
es raw query
{
"_source": [
"_id"
],
"aggregations": {
"brand": {
"terms": {
"field": "brand.untouched",
"size": 1000
}
},
"categories": {
"terms": {
"field": "categories_parents_catalog_codes",
"size": 1000
}
},
"continuum_price": {
"range": {
"field": "lowest_public_price_with_vat",
"keyed": true,
"ranges": [
{
"gte": 0
}
]
}
},
"continuum_price_stats": {
"aggs": {
"continuum_price_stats": {
"stats": {
"field": "lowest_public_price_with_vat"
}
}
},
"filter": {
"match_all": {}
}
},
"continuum_price_stats_with_include_self_filter": {
"aggs": {
"continuum_price_stats": {
"stats": {
"field": "lowest_public_price_with_vat"
}
}
},
"filter": {
"match_all": {}
}
},
"offers": {
"terms": {
"field": "offers.untouched",
"size": 1000
}
},
"stores": {
"terms": {
"field": "categories_parents_catalog_codes",
"size": 1000
}
}
},
"from": 0,
"query": {
"function_score": {
"functions": [
{
"field_value_factor": {
"factor": 2,
"field": "availability",
"modifier": "square"
}
},
{
"gauss": {
"first_published_at": {
"decay": 0.5,
"offset": "30d",
"scale": "90d"
}
}
},
{
"field_value_factor": {
"factor": 1,
"field": "availability"
},
"filter": {
"term": {
"discount": 1
}
}
},
{
"field_value_factor": {
"factor": 1,
"field": "sales_stat.ct_last_month",
"modifier": "log1p"
}
},
{
"field_value_factor": {
"factor": 0.75,
"field": "sales_stat.ct_last_three_months",
"modifier": "log1p"
}
},
{
"field_value_factor": {
"factor": 0.5,
"field": "sales_stat.ct_last_year",
"modifier": "log1p"
}
},
{
"field_value_factor": {
"factor": 0.3,
"field": "comments_stat.ct",
"modifier": "log1p"
}
},
{
"field_value_factor": {
"factor": 0.1,
"field": "comments_stat.avg_note",
"modifier": "log1p"
}
}
],
"query": {
"bool": {
"filter": [
{
"term": {
"categories_parents_catalog_codes": "4bf0f7deefa77878491505"
}
},
{
"term": {
"brand.untouched": "SPAX"
}
}
],
"must": {
"match_all": {}
}
}
},
"score_mode": "sum"
}
},
"size": 40
}
es raw result
{
"_shards": {
"failed": 0,
"successful": 5,
"total": 5
},
"aggregations": {
"brand": {
"buckets": [
{
"doc_count": 55,
"key": "SPAX"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 55,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 55,
"key": "root"
},
{
"doc_count": 45,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 41,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 14,
"key": "6274c094a9d9e966383468"
},
{
"doc_count": 14,
"key": "store_root"
},
{
"doc_count": 13,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 13,
"key": "528a3ea0c7172142573557"
},
{
"doc_count": 2,
"key": "4fa148531003c697016663"
},
{
"doc_count": 2,
"key": "5af546e744ec6120146905"
},
{
"doc_count": 2,
"key": "5af5583b408d1290923337"
},
{
"doc_count": 2,
"key": "5af559f1c8897092340495"
},
{
"doc_count": 2,
"key": "id_c_c02_14"
},
{
"doc_count": 1,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_10_c03a7_408"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 52
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
},
"offers": {
"buckets": [
{
"doc_count": 2,
"key": "entretien terrasse"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"stores": {
"buckets": [
{
"doc_count": 55,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 55,
"key": "root"
},
{
"doc_count": 45,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 41,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 14,
"key": "6274c094a9d9e966383468"
},
{
"doc_count": 14,
"key": "store_root"
},
{
"doc_count": 13,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 13,
"key": "528a3ea0c7172142573557"
},
{
"doc_count": 2,
"key": "4fa148531003c697016663"
},
{
"doc_count": 2,
"key": "5af546e744ec6120146905"
},
{
"doc_count": 2,
"key": "5af5583b408d1290923337"
},
{
"doc_count": 2,
"key": "5af559f1c8897092340495"
},
{
"doc_count": 2,
"key": "id_c_c02_14"
},
{
"doc_count": 1,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_10_c03a7_408"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
"hits": {
"hits": [
{
"_id": "67264",
"_index": "catalog_2023_02",
"_score": 22.9256,
"_source": {},
"_type": "product"
},
{
"_id": "108757",
"_index": "catalog_2023_02",
"_score": 21.340303,
"_source": {},
"_type": "product"
},
{
"_id": "61097",
"_index": "catalog_2023_02",
"_score": 20.438543,
"_source": {},
"_type": "product"
},
{
"_id": "4569",
"_index": "catalog_2023_02",
"_score": 20.168358,
"_source": {},
"_type": "product"
},
{
"_id": "27978",
"_index": "catalog_2023_02",
"_score": 19.712334,
"_source": {},
"_type": "product"
},
{
"_id": "24879",
"_index": "catalog_2023_02",
"_score": 19.696379,
"_source": {},
"_type": "product"
},
{
"_id": "4570",
"_index": "catalog_2023_02",
"_score": 19.500246,
"_source": {},
"_type": "product"
},
{
"_id": "37915",
"_index": "catalog_2023_02",
"_score": 19.47336,
"_source": {},
"_type": "product"
},
{
"_id": "36474",
"_index": "catalog_2023_02",
"_score": 19.326584,
"_source": {},
"_type": "product"
},
{
"_id": "4663",
"_index": "catalog_2023_02",
"_score": 19.196121,
"_source": {},
"_type": "product"
},
{
"_id": "75388",
"_index": "catalog_2023_02",
"_score": 19.001387,
"_source": {},
"_type": "product"
},
{
"_id": "7141",
"_index": "catalog_2023_02",
"_score": 18.849463,
"_source": {},
"_type": "product"
},
{
"_id": "4572",
"_index": "catalog_2023_02",
"_score": 18.81758,
"_source": {},
"_type": "product"
},
{
"_id": "4573",
"_index": "catalog_2023_02",
"_score": 18.43281,
"_source": {},
"_type": "product"
},
{
"_id": "78047",
"_index": "catalog_2023_02",
"_score": 18.13306,
"_source": {},
"_type": "product"
},
{
"_id": "91352",
"_index": "catalog_2023_02",
"_score": 18.10958,
"_source": {},
"_type": "product"
},
{
"_id": "98464",
"_index": "catalog_2023_02",
"_score": 18.006039,
"_source": {},
"_type": "product"
},
{
"_id": "56161",
"_index": "catalog_2023_02",
"_score": 17.998913,
"_source": {},
"_type": "product"
},
{
"_id": "10222",
"_index": "catalog_2023_02",
"_score": 17.679882,
"_source": {},
"_type": "product"
},
{
"_id": "7351",
"_index": "catalog_2023_02",
"_score": 17.40654,
"_source": {},
"_type": "product"
},
{
"_id": "91347",
"_index": "catalog_2023_02",
"_score": 17.399328,
"_source": {},
"_type": "product"
},
{
"_id": "98516",
"_index": "catalog_2023_02",
"_score": 17.210854,
"_source": {},
"_type": "product"
},
{
"_id": "108758",
"_index": "catalog_2023_02",
"_score": 17.146236,
"_source": {},
"_type": "product"
},
{
"_id": "98514",
"_index": "catalog_2023_02",
"_score": 17.146128,
"_source": {},
"_type": "product"
},
{
"_id": "49277",
"_index": "catalog_2023_02",
"_score": 17.146128,
"_source": {},
"_type": "product"
},
{
"_id": "98462",
"_index": "catalog_2023_02",
"_score": 16.942009,
"_source": {},
"_type": "product"
},
{
"_id": "49528",
"_index": "catalog_2023_02",
"_score": 16.931013,
"_source": {},
"_type": "product"
},
{
"_id": "98513",
"_index": "catalog_2023_02",
"_score": 16.845098,
"_source": {},
"_type": "product"
},
{
"_id": "49275",
"_index": "catalog_2023_02",
"_score": 16.835056,
"_source": {},
"_type": "product"
},
{
"_id": "27977",
"_index": "catalog_2023_02",
"_score": 16.681242,
"_source": {},
"_type": "product"
},
{
"_id": "98517",
"_index": "catalog_2023_02",
"_score": 16.640978,
"_source": {},
"_type": "product"
},
{
"_id": "98512",
"_index": "catalog_2023_02",
"_score": 16.640978,
"_source": {},
"_type": "product"
},
{
"_id": "93396",
"_index": "catalog_2023_02",
"_score": 16.591064,
"_source": {},
"_type": "product"
},
{
"_id": "31566",
"_index": "catalog_2023_02",
"_score": 16.477121,
"_source": {},
"_type": "product"
},
{
"_id": "4568",
"_index": "catalog_2023_02",
"_score": 16.466125,
"_source": {},
"_type": "product"
},
{
"_id": "53462",
"_index": "catalog_2023_02",
"_score": 16.466125,
"_source": {},
"_type": "product"
},
{
"_id": "46368",
"_index": "catalog_2023_02",
"_score": 16.459393,
"_source": {},
"_type": "product"
},
{
"_id": "98515",
"_index": "catalog_2023_02",
"_score": 16.30103,
"_source": {},
"_type": "product"
},
{
"_id": "7142",
"_index": "catalog_2023_02",
"_score": 16.290035,
"_source": {},
"_type": "product"
},
{
"_id": "56159",
"_index": "catalog_2023_02",
"_score": 16.290035,
"_source": {},
"_type": "product"
}
],
"max_score": 22.9256,
"total": 55
},
"timed_out": false,
"took": 6
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 55,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 55,
"key": "root"
},
{
"doc_count": 45,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 41,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 14,
"key": "6274c094a9d9e966383468"
},
{
"doc_count": 14,
"key": "store_root"
},
{
"doc_count": 13,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 13,
"key": "528a3ea0c7172142573557"
},
{
"doc_count": 2,
"key": "4fa148531003c697016663"
},
{
"doc_count": 2,
"key": "5af546e744ec6120146905"
},
{
"doc_count": 2,
"key": "5af5583b408d1290923337"
},
{
"doc_count": 2,
"key": "5af559f1c8897092340495"
},
{
"doc_count": 2,
"key": "id_c_c02_14"
},
{
"doc_count": 1,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_10_c03a7_408"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 55,
"key": "SPAX"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [
{
"doc_count": 2,
"key": "entretien terrasse"
}
],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
},
{
"continuum_price_stats": {
"avg": 53.682461538461524,
"count": 52,
"max": 370.248,
"min": 5.94,
"sum": 2791.4879999999994
},
"doc_count": 55
}
],
"name": "continuum_price",
"unit": null
},
{
"buckets": [
{
"doc_count": 55,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 55,
"key": "root"
},
{
"doc_count": 45,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 41,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 14,
"key": "6274c094a9d9e966383468"
},
{
"doc_count": 14,
"key": "store_root"
},
{
"doc_count": 13,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 13,
"key": "528a3ea0c7172142573557"
},
{
"doc_count": 2,
"key": "4fa148531003c697016663"
},
{
"doc_count": 2,
"key": "5af546e744ec6120146905"
},
{
"doc_count": 2,
"key": "5af5583b408d1290923337"
},
{
"doc_count": 2,
"key": "5af559f1c8897092340495"
},
{
"doc_count": 2,
"key": "id_c_c02_14"
},
{
"doc_count": 1,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_10_c03a7_408"
}
],
"name": "stores",
"unit": null
}
]
flattened suggestions
[]