Debug
es raw query
{
"_source": [
"_id",
"catalog_code"
],
"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_filtered": {
"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": {}
}
},
"delivery24h": {
"terms": {
"field": "is_delivery_24h",
"size": 1000
}
},
"diametre": {
"aggs": {
"diametre_nested": {
"aggs": {
"diametre_nested_filtered": {
"aggs": {
"diametre_reverse_nested": {
"aggs": {
"diametre_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"diametre_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Diam\u00e8tre"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"filetage": {
"aggs": {
"filetage_nested": {
"aggs": {
"filetage_nested_filtered": {
"aggs": {
"filetage_reverse_nested": {
"aggs": {
"filetage_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"filetage_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Filetage"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"matiere": {
"aggs": {
"matiere_nested": {
"aggs": {
"matiere_nested_filtered": {
"aggs": {
"matiere_reverse_nested": {
"aggs": {
"matiere_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"matiere_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Mati\u00e8re"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"offers": {
"terms": {
"field": "offers.untouched",
"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": "655227f098f83061791891"
}
}
],
"must": {
"match_all": {}
}
}
},
"score_mode": "sum"
}
},
"size": 40
}
es raw result
{
"_shards": {
"failed": 0,
"skipped": 0,
"successful": 5,
"total": 5
},
"aggregations": {
"brand": {
"buckets": [
{
"doc_count": 27,
"key": "CODITAL"
},
{
"doc_count": 3,
"key": "GEBO"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 30,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 30,
"key": "508e9475abc79409512645"
},
{
"doc_count": 30,
"key": "593006b0b2e8f397473129"
},
{
"doc_count": 30,
"key": "655227f098f83061791891"
},
{
"doc_count": 30,
"key": "root"
},
{
"doc_count": 27,
"key": "6555ea160d2ea356634000"
},
{
"doc_count": 6,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 6,
"key": "store_root"
},
{
"doc_count": 3,
"key": "65522841b4bb1912585601"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 30
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
},
"continuum_price_stats_filtered": {
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
},
"delivery24h": {
"buckets": [
{
"doc_count": 30,
"key": 1
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"diametre": {
"diametre_nested": {
"diametre_nested_filtered": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 0
},
"doc_count": 839
},
"filetage": {
"doc_count": 839,
"filetage_nested": {
"doc_count": 200,
"filetage_nested_filtered": {
"buckets": [
{
"doc_count": 34,
"filetage_reverse_nested": {
"doc_count": 30,
"filetage_reverse_nested_parent_filter": {
"doc_count": 30
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 34,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "26x34"
},
{
"doc_count": 32,
"filetage_reverse_nested": {
"doc_count": 30,
"filetage_reverse_nested_parent_filter": {
"doc_count": 30
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 32,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "20x27"
},
{
"doc_count": 31,
"filetage_reverse_nested": {
"doc_count": 30,
"filetage_reverse_nested_parent_filter": {
"doc_count": 30
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 31,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "15x21"
},
{
"doc_count": 31,
"filetage_reverse_nested": {
"doc_count": 27,
"filetage_reverse_nested_parent_filter": {
"doc_count": 27
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 31,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "40x49"
},
{
"doc_count": 30,
"filetage_reverse_nested": {
"doc_count": 27,
"filetage_reverse_nested_parent_filter": {
"doc_count": 27
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 30,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "33x42"
},
{
"doc_count": 24,
"filetage_reverse_nested": {
"doc_count": 24,
"filetage_reverse_nested_parent_filter": {
"doc_count": 24
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 24,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "50x60"
},
{
"doc_count": 18,
"filetage_reverse_nested": {
"doc_count": 18,
"filetage_reverse_nested_parent_filter": {
"doc_count": 18
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 18,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "12x17"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"matiere": {
"doc_count": 839,
"matiere_nested": {
"doc_count": 39,
"matiere_nested_filtered": {
"buckets": [
{
"doc_count": 23,
"key": "Fonte",
"matiere_reverse_nested": {
"doc_count": 10,
"matiere_reverse_nested_parent_filter": {
"doc_count": 10
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 23,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 16,
"key": "Acier",
"matiere_reverse_nested": {
"doc_count": 6,
"matiere_reverse_nested_parent_filter": {
"doc_count": 6
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 16,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 9,
"key": "Acier Galvanis\u00e9",
"matiere_reverse_nested": {
"doc_count": 3,
"matiere_reverse_nested_parent_filter": {
"doc_count": 3
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 9,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"offers": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
"hits": {
"hits": [
{
"_id": "p-7872",
"_index": "catalog_2025_01",
"_score": 22.311687,
"_source": {
"catalog_code": "z297"
},
"_type": "product"
},
{
"_id": "p-7883",
"_index": "catalog_2025_01",
"_score": 21.96974,
"_source": {
"catalog_code": "z309"
},
"_type": "product"
},
{
"_id": "p-112908",
"_index": "catalog_2025_01",
"_score": 21.814735,
"_source": {
"catalog_code": "id_Z14159"
},
"_type": "product"
},
{
"_id": "p-112937",
"_index": "catalog_2025_01",
"_score": 21.456099,
"_source": {
"catalog_code": "id_Z14044"
},
"_type": "product"
},
{
"_id": "p-7884",
"_index": "catalog_2025_01",
"_score": 21.421232,
"_source": {
"catalog_code": "z310"
},
"_type": "product"
},
{
"_id": "p-29543",
"_index": "catalog_2025_01",
"_score": 21.398848,
"_source": {
"catalog_code": "z289.46"
},
"_type": "product"
},
{
"_id": "p-7878",
"_index": "catalog_2025_01",
"_score": 21.319218,
"_source": {
"catalog_code": "z303"
},
"_type": "product"
},
{
"_id": "p-112910",
"_index": "catalog_2025_01",
"_score": 20.964594,
"_source": {
"catalog_code": "id_Z14164"
},
"_type": "product"
},
{
"_id": "p-113032",
"_index": "catalog_2025_01",
"_score": 20.877277,
"_source": {
"catalog_code": "id_Z14072"
},
"_type": "product"
},
{
"_id": "p-112932",
"_index": "catalog_2025_01",
"_score": 20.476217,
"_source": {
"catalog_code": "id_Z14099"
},
"_type": "product"
},
{
"_id": "p-113029",
"_index": "catalog_2025_01",
"_score": 20.439518,
"_source": {
"catalog_code": "id_Z14108"
},
"_type": "product"
},
{
"_id": "p-7865",
"_index": "catalog_2025_01",
"_score": 20.334608,
"_source": {
"catalog_code": "z290"
},
"_type": "product"
},
{
"_id": "p-112909",
"_index": "catalog_2025_01",
"_score": 20.261465,
"_source": {
"catalog_code": "id_Z14192"
},
"_type": "product"
},
{
"_id": "p-112181",
"_index": "catalog_2025_01",
"_score": 19.601625,
"_source": {
"catalog_code": "54f2698e91710713650ee2e8f9b0aa14_651a5c900e0e5"
},
"_type": "product"
},
{
"_id": "p-113035",
"_index": "catalog_2025_01",
"_score": 19.58484,
"_source": {
"catalog_code": "id_Z14064"
},
"_type": "product"
},
{
"_id": "p-7875",
"_index": "catalog_2025_01",
"_score": 19.343216,
"_source": {
"catalog_code": "z300"
},
"_type": "product"
},
{
"_id": "p-7885",
"_index": "catalog_2025_01",
"_score": 19.044853,
"_source": {
"catalog_code": "z311"
},
"_type": "product"
},
{
"_id": "p-112926",
"_index": "catalog_2025_01",
"_score": 18.97618,
"_source": {
"catalog_code": "id_Z14122"
},
"_type": "product"
},
{
"_id": "p-113004",
"_index": "catalog_2025_01",
"_score": 18.747578,
"_source": {
"catalog_code": "id_Z14036"
},
"_type": "product"
},
{
"_id": "p-113010",
"_index": "catalog_2025_01",
"_score": 18.6372,
"_source": {
"catalog_code": "id_Z14022"
},
"_type": "product"
},
{
"_id": "p-112922",
"_index": "catalog_2025_01",
"_score": 18.545368,
"_source": {
"catalog_code": "id_Z14129"
},
"_type": "product"
},
{
"_id": "p-112935",
"_index": "catalog_2025_01",
"_score": 18.318169,
"_source": {
"catalog_code": "id_Z14030"
},
"_type": "product"
},
{
"_id": "p-7866",
"_index": "catalog_2025_01",
"_score": 18.293186,
"_source": {
"catalog_code": "z291"
},
"_type": "product"
},
{
"_id": "p-113006",
"_index": "catalog_2025_01",
"_score": 17.736874,
"_source": {
"catalog_code": "id_Z14144"
},
"_type": "product"
},
{
"_id": "p-7886",
"_index": "catalog_2025_01",
"_score": 17.447159,
"_source": {
"catalog_code": "z312"
},
"_type": "product"
},
{
"_id": "p-112182",
"_index": "catalog_2025_01",
"_score": 17.356981,
"_source": {
"catalog_code": "aede7a25b1a38017bfc7e948ea4267b0_651a5c9055508"
},
"_type": "product"
},
{
"_id": "p-7899",
"_index": "catalog_2025_01",
"_score": 17.273436,
"_source": {
"catalog_code": "z3627"
},
"_type": "product"
},
{
"_id": "p-113008",
"_index": "catalog_2025_01",
"_score": 17.181843,
"_source": {
"catalog_code": "id_Z14137"
},
"_type": "product"
},
{
"_id": "p-112911",
"_index": "catalog_2025_01",
"_score": 17.1181,
"_source": {
"catalog_code": "id_"
},
"_type": "product"
},
{
"_id": "p-112183",
"_index": "catalog_2025_01",
"_score": 16.834103,
"_source": {
"catalog_code": "028826b26eaf3e55e3bd128d2e33a2b6_651a5c90ad92b"
},
"_type": "product"
}
],
"max_score": 22.311687,
"total": 30
},
"timed_out": false,
"took": 3
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 30,
"key": "26x34"
},
{
"doc_count": 30,
"key": "20x27"
},
{
"doc_count": 30,
"key": "15x21"
},
{
"doc_count": 27,
"key": "40x49"
},
{
"doc_count": 27,
"key": "33x42"
},
{
"doc_count": 24,
"key": "50x60"
},
{
"doc_count": 18,
"key": "12x17"
}
],
"name": "filetage",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"doc_count": 30,
"key": 1
}
],
"name": "delivery24h",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
}
],
"name": "continuum_price_stats_filtered",
"unit": null
},
{
"buckets": [],
"name": "diametre",
"unit": null
},
{
"buckets": [
{
"doc_count": 30,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 30,
"key": "508e9475abc79409512645"
},
{
"doc_count": 30,
"key": "593006b0b2e8f397473129"
},
{
"doc_count": 30,
"key": "655227f098f83061791891"
},
{
"doc_count": 30,
"key": "root"
},
{
"doc_count": 27,
"key": "6555ea160d2ea356634000"
},
{
"doc_count": 6,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 6,
"key": "store_root"
},
{
"doc_count": 3,
"key": "65522841b4bb1912585601"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 27,
"key": "CODITAL"
},
{
"doc_count": 3,
"key": "GEBO"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"doc_count": 10,
"key": "Fonte"
},
{
"doc_count": 6,
"key": "Acier"
},
{
"doc_count": 3,
"key": "Acier Galvanis\u00e9"
}
],
"name": "matiere",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
},
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
},
{
"continuum_price_stats": {
"avg": 3.0347999999999997,
"count": 30,
"max": 17.004,
"min": 0.576,
"sum": 91.044
},
"doc_count": 30
}
],
"name": "continuum_price",
"unit": null
}
]
flattened suggestions
[]