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": "FISCHER"
}
}
],
"must": {
"match_all": {}
}
}
},
"score_mode": "sum"
}
},
"size": 40
}
es raw result
{
"_shards": {
"failed": 0,
"successful": 5,
"total": 5
},
"aggregations": {
"brand": {
"buckets": [
{
"doc_count": 98,
"key": "FISCHER"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 98,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 98,
"key": "root"
},
{
"doc_count": 56,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 33,
"key": "store_root"
},
{
"doc_count": 32,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 30,
"key": "58736d52850e6399573241"
},
{
"doc_count": 19,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 18,
"key": "5b18fe78c8697494994138"
},
{
"doc_count": 16,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 13,
"key": "528b66a71cff5440415577"
},
{
"doc_count": 11,
"key": "529ef8f37a26c293163321"
},
{
"doc_count": 7,
"key": "528b6b03ec23a860803383"
},
{
"doc_count": 7,
"key": "529dd91058dfb108749254"
},
{
"doc_count": 6,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 4,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 4,
"key": "528a48e828677498672577"
},
{
"doc_count": 4,
"key": "528b64b082caa404938044"
},
{
"doc_count": 4,
"key": "528b6ad00b324317278059"
},
{
"doc_count": 4,
"key": "84b64b02065316b46d656786c558cb5b"
},
{
"doc_count": 3,
"key": "528b674388163131253266"
},
{
"doc_count": 3,
"key": "559bf314afd67895325308"
},
{
"doc_count": 3,
"key": "7f7f3b541da499af9b8ea0358f54938a"
},
{
"doc_count": 2,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 2,
"key": "id_c_c03_25_c03b5"
},
{
"doc_count": 2,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 1,
"key": "4b8d255e2b235801788415"
},
{
"doc_count": 1,
"key": "4bf0f7f76be1a918683287"
},
{
"doc_count": 1,
"key": "4e4fee881e7eef76e9f5e8899cfe2422"
},
{
"doc_count": 1,
"key": "508e99119e6b5297679035"
},
{
"doc_count": 1,
"key": "50bf5b771b853802169980"
},
{
"doc_count": 1,
"key": "519f170446646863753645"
},
{
"doc_count": 1,
"key": "52272e6a839e9515883790"
},
{
"doc_count": 1,
"key": "528b674b8563a692169668"
},
{
"doc_count": 1,
"key": "53fee3119466b269109579"
},
{
"doc_count": 1,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 1,
"key": "543e655564eac886635537"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_25_c03a9"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 87
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
},
"offers": {
"buckets": [
{
"doc_count": 28,
"key": "Livraison gratuite"
},
{
"doc_count": 16,
"key": "Destockage"
},
{
"doc_count": 14,
"key": "Notre s\u00e9lection"
},
{
"doc_count": 1,
"key": "Fabrication Fran\u00e7aise"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"stores": {
"buckets": [
{
"doc_count": 98,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 98,
"key": "root"
},
{
"doc_count": 56,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 33,
"key": "store_root"
},
{
"doc_count": 32,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 30,
"key": "58736d52850e6399573241"
},
{
"doc_count": 19,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 18,
"key": "5b18fe78c8697494994138"
},
{
"doc_count": 16,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 13,
"key": "528b66a71cff5440415577"
},
{
"doc_count": 11,
"key": "529ef8f37a26c293163321"
},
{
"doc_count": 7,
"key": "528b6b03ec23a860803383"
},
{
"doc_count": 7,
"key": "529dd91058dfb108749254"
},
{
"doc_count": 6,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 4,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 4,
"key": "528a48e828677498672577"
},
{
"doc_count": 4,
"key": "528b64b082caa404938044"
},
{
"doc_count": 4,
"key": "528b6ad00b324317278059"
},
{
"doc_count": 4,
"key": "84b64b02065316b46d656786c558cb5b"
},
{
"doc_count": 3,
"key": "528b674388163131253266"
},
{
"doc_count": 3,
"key": "559bf314afd67895325308"
},
{
"doc_count": 3,
"key": "7f7f3b541da499af9b8ea0358f54938a"
},
{
"doc_count": 2,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 2,
"key": "id_c_c03_25_c03b5"
},
{
"doc_count": 2,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 1,
"key": "4b8d255e2b235801788415"
},
{
"doc_count": 1,
"key": "4bf0f7f76be1a918683287"
},
{
"doc_count": 1,
"key": "4e4fee881e7eef76e9f5e8899cfe2422"
},
{
"doc_count": 1,
"key": "508e99119e6b5297679035"
},
{
"doc_count": 1,
"key": "50bf5b771b853802169980"
},
{
"doc_count": 1,
"key": "519f170446646863753645"
},
{
"doc_count": 1,
"key": "52272e6a839e9515883790"
},
{
"doc_count": 1,
"key": "528b674b8563a692169668"
},
{
"doc_count": 1,
"key": "53fee3119466b269109579"
},
{
"doc_count": 1,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 1,
"key": "543e655564eac886635537"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_25_c03a9"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
"hits": {
"hits": [
{
"_id": "46193",
"_index": "catalog_2023_02",
"_score": 24.177887,
"_source": {},
"_type": "product"
},
{
"_id": "33409",
"_index": "catalog_2023_02",
"_score": 22.717896,
"_source": {},
"_type": "product"
},
{
"_id": "33363",
"_index": "catalog_2023_02",
"_score": 21.934134,
"_source": {},
"_type": "product"
},
{
"_id": "33412",
"_index": "catalog_2023_02",
"_score": 21.628344,
"_source": {},
"_type": "product"
},
{
"_id": "4743",
"_index": "catalog_2023_02",
"_score": 21.470577,
"_source": {},
"_type": "product"
},
{
"_id": "33407",
"_index": "catalog_2023_02",
"_score": 21.4643,
"_source": {},
"_type": "product"
},
{
"_id": "33413",
"_index": "catalog_2023_02",
"_score": 21.352842,
"_source": {},
"_type": "product"
},
{
"_id": "33415",
"_index": "catalog_2023_02",
"_score": 20.923056,
"_source": {},
"_type": "product"
},
{
"_id": "4723",
"_index": "catalog_2023_02",
"_score": 20.893692,
"_source": {},
"_type": "product"
},
{
"_id": "9740",
"_index": "catalog_2023_02",
"_score": 20.816055,
"_source": {},
"_type": "product"
},
{
"_id": "33414",
"_index": "catalog_2023_02",
"_score": 19.943293,
"_source": {},
"_type": "product"
},
{
"_id": "33410",
"_index": "catalog_2023_02",
"_score": 19.182848,
"_source": {},
"_type": "product"
},
{
"_id": "48458",
"_index": "catalog_2023_02",
"_score": 18.813347,
"_source": {},
"_type": "product"
},
{
"_id": "4728",
"_index": "catalog_2023_02",
"_score": 18.752386,
"_source": {},
"_type": "product"
},
{
"_id": "9544",
"_index": "catalog_2023_02",
"_score": 18.683025,
"_source": {},
"_type": "product"
},
{
"_id": "33411",
"_index": "catalog_2023_02",
"_score": 18.62839,
"_source": {},
"_type": "product"
},
{
"_id": "109400",
"_index": "catalog_2023_02",
"_score": 18.577318,
"_source": {},
"_type": "product"
},
{
"_id": "4767",
"_index": "catalog_2023_02",
"_score": 18.554943,
"_source": {},
"_type": "product"
},
{
"_id": "82427",
"_index": "catalog_2023_02",
"_score": 18.335659,
"_source": {},
"_type": "product"
},
{
"_id": "48279",
"_index": "catalog_2023_02",
"_score": 18.267757,
"_source": {},
"_type": "product"
},
{
"_id": "48278",
"_index": "catalog_2023_02",
"_score": 18.152365,
"_source": {},
"_type": "product"
},
{
"_id": "33364",
"_index": "catalog_2023_02",
"_score": 18.111263,
"_source": {},
"_type": "product"
},
{
"_id": "86565",
"_index": "catalog_2023_02",
"_score": 18.061453,
"_source": {},
"_type": "product"
},
{
"_id": "4707",
"_index": "catalog_2023_02",
"_score": 18.059412,
"_source": {},
"_type": "product"
},
{
"_id": "6743",
"_index": "catalog_2023_02",
"_score": 17.962038,
"_source": {},
"_type": "product"
},
{
"_id": "56460",
"_index": "catalog_2023_02",
"_score": 17.920124,
"_source": {},
"_type": "product"
},
{
"_id": "33408",
"_index": "catalog_2023_02",
"_score": 17.840733,
"_source": {},
"_type": "product"
},
{
"_id": "82429",
"_index": "catalog_2023_02",
"_score": 17.737192,
"_source": {},
"_type": "product"
},
{
"_id": "9739",
"_index": "catalog_2023_02",
"_score": 17.693727,
"_source": {},
"_type": "product"
},
{
"_id": "82402",
"_index": "catalog_2023_02",
"_score": 17.580069,
"_source": {},
"_type": "product"
},
{
"_id": "48457",
"_index": "catalog_2023_02",
"_score": 17.556303,
"_source": {},
"_type": "product"
},
{
"_id": "4716",
"_index": "catalog_2023_02",
"_score": 17.521791,
"_source": {},
"_type": "product"
},
{
"_id": "4717",
"_index": "catalog_2023_02",
"_score": 17.515543,
"_source": {},
"_type": "product"
},
{
"_id": "99428",
"_index": "catalog_2023_02",
"_score": 17.50515,
"_source": {},
"_type": "product"
},
{
"_id": "24237",
"_index": "catalog_2023_02",
"_score": 17.504063,
"_source": {},
"_type": "product"
},
{
"_id": "110019",
"_index": "catalog_2023_02",
"_score": 17.49006,
"_source": {},
"_type": "product"
},
{
"_id": "82423",
"_index": "catalog_2023_02",
"_score": 17.4014,
"_source": {},
"_type": "product"
},
{
"_id": "33362",
"_index": "catalog_2023_02",
"_score": 17.362482,
"_source": {},
"_type": "product"
},
{
"_id": "29306",
"_index": "catalog_2023_02",
"_score": 17.345985,
"_source": {},
"_type": "product"
},
{
"_id": "56595",
"_index": "catalog_2023_02",
"_score": 17.31767,
"_source": {},
"_type": "product"
}
],
"max_score": 24.177887,
"total": 98
},
"timed_out": false,
"took": 5
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 98,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 98,
"key": "root"
},
{
"doc_count": 56,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 33,
"key": "store_root"
},
{
"doc_count": 32,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 30,
"key": "58736d52850e6399573241"
},
{
"doc_count": 19,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 18,
"key": "5b18fe78c8697494994138"
},
{
"doc_count": 16,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 13,
"key": "528b66a71cff5440415577"
},
{
"doc_count": 11,
"key": "529ef8f37a26c293163321"
},
{
"doc_count": 7,
"key": "528b6b03ec23a860803383"
},
{
"doc_count": 7,
"key": "529dd91058dfb108749254"
},
{
"doc_count": 6,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 4,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 4,
"key": "528a48e828677498672577"
},
{
"doc_count": 4,
"key": "528b64b082caa404938044"
},
{
"doc_count": 4,
"key": "528b6ad00b324317278059"
},
{
"doc_count": 4,
"key": "84b64b02065316b46d656786c558cb5b"
},
{
"doc_count": 3,
"key": "528b674388163131253266"
},
{
"doc_count": 3,
"key": "559bf314afd67895325308"
},
{
"doc_count": 3,
"key": "7f7f3b541da499af9b8ea0358f54938a"
},
{
"doc_count": 2,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 2,
"key": "id_c_c03_25_c03b5"
},
{
"doc_count": 2,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 1,
"key": "4b8d255e2b235801788415"
},
{
"doc_count": 1,
"key": "4bf0f7f76be1a918683287"
},
{
"doc_count": 1,
"key": "4e4fee881e7eef76e9f5e8899cfe2422"
},
{
"doc_count": 1,
"key": "508e99119e6b5297679035"
},
{
"doc_count": 1,
"key": "50bf5b771b853802169980"
},
{
"doc_count": 1,
"key": "519f170446646863753645"
},
{
"doc_count": 1,
"key": "52272e6a839e9515883790"
},
{
"doc_count": 1,
"key": "528b674b8563a692169668"
},
{
"doc_count": 1,
"key": "53fee3119466b269109579"
},
{
"doc_count": 1,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 1,
"key": "543e655564eac886635537"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_25_c03a9"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 98,
"key": "FISCHER"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [
{
"doc_count": 28,
"key": "Livraison gratuite"
},
{
"doc_count": 16,
"key": "Destockage"
},
{
"doc_count": 14,
"key": "Notre s\u00e9lection"
},
{
"doc_count": 1,
"key": "Fabrication Fran\u00e7aise"
}
],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
},
{
"continuum_price_stats": {
"avg": 28.919862068965514,
"count": 87,
"max": 278.76,
"min": 0.528,
"sum": 2516.028
},
"doc_count": 98
}
],
"name": "continuum_price",
"unit": null
},
{
"buckets": [
{
"doc_count": 98,
"key": "4bf0f7deefa77878491505"
},
{
"doc_count": 98,
"key": "root"
},
{
"doc_count": 56,
"key": "573c8cf57c62f004942971"
},
{
"doc_count": 33,
"key": "store_root"
},
{
"doc_count": 32,
"key": "4bf0f80cb4264655320711"
},
{
"doc_count": 30,
"key": "58736d52850e6399573241"
},
{
"doc_count": 19,
"key": "5b17d35030e56738655811"
},
{
"doc_count": 18,
"key": "5b18fe78c8697494994138"
},
{
"doc_count": 16,
"key": "5b0fe77e725e8952646116"
},
{
"doc_count": 13,
"key": "528b66a71cff5440415577"
},
{
"doc_count": 11,
"key": "529ef8f37a26c293163321"
},
{
"doc_count": 7,
"key": "528b6b03ec23a860803383"
},
{
"doc_count": 7,
"key": "529dd91058dfb108749254"
},
{
"doc_count": 6,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 4,
"key": "508e98d9bc83c199173592"
},
{
"doc_count": 4,
"key": "528a48e828677498672577"
},
{
"doc_count": 4,
"key": "528b64b082caa404938044"
},
{
"doc_count": 4,
"key": "528b6ad00b324317278059"
},
{
"doc_count": 4,
"key": "84b64b02065316b46d656786c558cb5b"
},
{
"doc_count": 3,
"key": "528b674388163131253266"
},
{
"doc_count": 3,
"key": "559bf314afd67895325308"
},
{
"doc_count": 3,
"key": "7f7f3b541da499af9b8ea0358f54938a"
},
{
"doc_count": 2,
"key": "528b8ad50d3a3638895625"
},
{
"doc_count": 2,
"key": "id_c_c03_25_c03b5"
},
{
"doc_count": 2,
"key": "id_c_c03_4_c03a4_14"
},
{
"doc_count": 1,
"key": "4b8d255e2b235801788415"
},
{
"doc_count": 1,
"key": "4bf0f7f76be1a918683287"
},
{
"doc_count": 1,
"key": "4e4fee881e7eef76e9f5e8899cfe2422"
},
{
"doc_count": 1,
"key": "508e99119e6b5297679035"
},
{
"doc_count": 1,
"key": "50bf5b771b853802169980"
},
{
"doc_count": 1,
"key": "519f170446646863753645"
},
{
"doc_count": 1,
"key": "52272e6a839e9515883790"
},
{
"doc_count": 1,
"key": "528b674b8563a692169668"
},
{
"doc_count": 1,
"key": "53fee3119466b269109579"
},
{
"doc_count": 1,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 1,
"key": "543e655564eac886635537"
},
{
"doc_count": 1,
"key": "5dde52ae53ba1174894056"
},
{
"doc_count": 1,
"key": "id_c_c03_25_c03a9"
}
],
"name": "stores",
"unit": null
}
]
flattened suggestions
[]