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": "655228bd826f1540518910"
}
}
],
"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": 23,
"key": "CODITAL"
},
{
"doc_count": 8,
"key": "GEBO"
},
{
"doc_count": 1,
"key": "ATLANTIC"
},
{
"doc_count": 1,
"key": "SFERACO"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 33,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 33,
"key": "508e9475abc79409512645"
},
{
"doc_count": 33,
"key": "655228bd826f1540518910"
},
{
"doc_count": 33,
"key": "root"
},
{
"doc_count": 29,
"key": "593006b0b2e8f397473129"
},
{
"doc_count": 23,
"key": "6555ea160d2ea356634000"
},
{
"doc_count": 8,
"key": "593007288901a600399332"
},
{
"doc_count": 6,
"key": "65522841b4bb1912585601"
},
{
"doc_count": 5,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 5,
"key": "store_root"
},
{
"doc_count": 1,
"key": "4bf0f949557f4254696778"
},
{
"doc_count": 1,
"key": "512f167cea2a9428552561"
},
{
"doc_count": 1,
"key": "b710fe5c441ace57ec01bd863bf24778"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 33
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
},
"continuum_price_stats_filtered": {
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
},
"delivery24h": {
"buckets": [
{
"doc_count": 32,
"key": 1
},
{
"doc_count": 1,
"key": 0
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"diametre": {
"diametre_nested": {
"diametre_nested_filtered": {
"buckets": [
{
"diametre_reverse_nested": {
"diametre_reverse_nested_parent_filter": {
"doc_count": 1
},
"doc_count": 1
},
"diametre_unit": {
"buckets": [
{
"doc_count": 7,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 7,
"key": "38-43"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"doc_count": 7
},
"doc_count": 967
},
"filetage": {
"doc_count": 967,
"filetage_nested": {
"doc_count": 187,
"filetage_nested_filtered": {
"buckets": [
{
"doc_count": 30,
"filetage_reverse_nested": {
"doc_count": 28,
"filetage_reverse_nested_parent_filter": {
"doc_count": 28
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 30,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "26x34"
},
{
"doc_count": 29,
"filetage_reverse_nested": {
"doc_count": 28,
"filetage_reverse_nested_parent_filter": {
"doc_count": 28
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 29,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "20x27"
},
{
"doc_count": 28,
"filetage_reverse_nested": {
"doc_count": 28,
"filetage_reverse_nested_parent_filter": {
"doc_count": 28
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 28,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "15x21"
},
{
"doc_count": 27,
"filetage_reverse_nested": {
"doc_count": 25,
"filetage_reverse_nested_parent_filter": {
"doc_count": 25
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 27,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "33x42"
},
{
"doc_count": 26,
"filetage_reverse_nested": {
"doc_count": 25,
"filetage_reverse_nested_parent_filter": {
"doc_count": 25
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 26,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "40x49"
},
{
"doc_count": 24,
"filetage_reverse_nested": {
"doc_count": 23,
"filetage_reverse_nested_parent_filter": {
"doc_count": 23
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 24,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "50x60"
},
{
"doc_count": 19,
"filetage_reverse_nested": {
"doc_count": 19,
"filetage_reverse_nested_parent_filter": {
"doc_count": 19
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 19,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "12x17"
},
{
"doc_count": 3,
"filetage_reverse_nested": {
"doc_count": 3,
"filetage_reverse_nested_parent_filter": {
"doc_count": 3
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 3,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "66x76"
},
{
"doc_count": 1,
"filetage_reverse_nested": {
"doc_count": 1,
"filetage_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"filetage_unit": {
"buckets": [
{
"doc_count": 1,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"key": "80x90"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"matiere": {
"doc_count": 967,
"matiere_nested": {
"doc_count": 12,
"matiere_nested_filtered": {
"buckets": [
{
"doc_count": 7,
"key": "Fonte",
"matiere_reverse_nested": {
"doc_count": 1,
"matiere_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 7,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 5,
"key": "Acier galvanis\u00e9",
"matiere_reverse_nested": {
"doc_count": 1,
"matiere_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"matiere_unit": {
"buckets": [
{
"doc_count": 5,
"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-7889",
"_index": "catalog_2025_01",
"_score": 23.589369,
"_source": {
"catalog_code": "z947"
},
"_type": "product"
},
{
"_id": "p-113033",
"_index": "catalog_2025_01",
"_score": 21.812712,
"_source": {
"catalog_code": "id_Z14054"
},
"_type": "product"
},
{
"_id": "p-7890",
"_index": "catalog_2025_01",
"_score": 20.587343,
"_source": {
"catalog_code": "z952"
},
"_type": "product"
},
{
"_id": "p-112916",
"_index": "catalog_2025_01",
"_score": 20.1297,
"_source": {
"catalog_code": "id_Z15139"
},
"_type": "product"
},
{
"_id": "p-7871",
"_index": "catalog_2025_01",
"_score": 19.946766,
"_source": {
"catalog_code": "z296"
},
"_type": "product"
},
{
"_id": "p-7874",
"_index": "catalog_2025_01",
"_score": 19.881586,
"_source": {
"catalog_code": "z299"
},
"_type": "product"
},
{
"_id": "p-7864",
"_index": "catalog_2025_01",
"_score": 19.78759,
"_source": {
"catalog_code": "z289"
},
"_type": "product"
},
{
"_id": "p-7870",
"_index": "catalog_2025_01",
"_score": 19.732828,
"_source": {
"catalog_code": "z295"
},
"_type": "product"
},
{
"_id": "p-112998",
"_index": "catalog_2025_01",
"_score": 19.601469,
"_source": {
"catalog_code": "id_Z15132"
},
"_type": "product"
},
{
"_id": "p-113031",
"_index": "catalog_2025_01",
"_score": 19.492115,
"_source": {
"catalog_code": "id_Z15031"
},
"_type": "product"
},
{
"_id": "p-7904",
"_index": "catalog_2025_01",
"_score": 19.400793,
"_source": {
"catalog_code": "z317"
},
"_type": "product"
},
{
"_id": "p-7905",
"_index": "catalog_2025_01",
"_score": 19.113441,
"_source": {
"catalog_code": "z318"
},
"_type": "product"
},
{
"_id": "p-7877",
"_index": "catalog_2025_01",
"_score": 18.888908,
"_source": {
"catalog_code": "z302"
},
"_type": "product"
},
{
"_id": "p-7867",
"_index": "catalog_2025_01",
"_score": 18.76522,
"_source": {
"catalog_code": "z292"
},
"_type": "product"
},
{
"_id": "p-7894",
"_index": "catalog_2025_01",
"_score": 18.704615,
"_source": {
"catalog_code": "z950"
},
"_type": "product"
},
{
"_id": "p-7887",
"_index": "catalog_2025_01",
"_score": 18.549788,
"_source": {
"catalog_code": "z513"
},
"_type": "product"
},
{
"_id": "p-7880",
"_index": "catalog_2025_01",
"_score": 18.163162,
"_source": {
"catalog_code": "z305"
},
"_type": "product"
},
{
"_id": "p-112990",
"_index": "catalog_2025_01",
"_score": 18.137575,
"_source": {
"catalog_code": "id_Z15088"
},
"_type": "product"
},
{
"_id": "p-7873",
"_index": "catalog_2025_01",
"_score": 17.961777,
"_source": {
"catalog_code": "z298"
},
"_type": "product"
},
{
"_id": "p-7882",
"_index": "catalog_2025_01",
"_score": 17.419128,
"_source": {
"catalog_code": "z307"
},
"_type": "product"
},
{
"_id": "p-7868",
"_index": "catalog_2025_01",
"_score": 17.38021,
"_source": {
"catalog_code": "z293"
},
"_type": "product"
},
{
"_id": "p-113009",
"_index": "catalog_2025_01",
"_score": 17.339252,
"_source": {
"catalog_code": "id_Z15133"
},
"_type": "product"
},
{
"_id": "p-7869",
"_index": "catalog_2025_01",
"_score": 17.243038,
"_source": {
"catalog_code": "z294"
},
"_type": "product"
},
{
"_id": "p-7879",
"_index": "catalog_2025_01",
"_score": 17.144575,
"_source": {
"catalog_code": "z304"
},
"_type": "product"
},
{
"_id": "p-7876",
"_index": "catalog_2025_01",
"_score": 17.134815,
"_source": {
"catalog_code": "z301"
},
"_type": "product"
},
{
"_id": "p-7888",
"_index": "catalog_2025_01",
"_score": 17.120573,
"_source": {
"catalog_code": "z954"
},
"_type": "product"
},
{
"_id": "p-7881",
"_index": "catalog_2025_01",
"_score": 16.681242,
"_source": {
"catalog_code": "z306"
},
"_type": "product"
},
{
"_id": "p-113037",
"_index": "catalog_2025_01",
"_score": 16.681242,
"_source": {
"catalog_code": "id_Z15152"
},
"_type": "product"
},
{
"_id": "p-113030",
"_index": "catalog_2025_01",
"_score": 16.591064,
"_source": {
"catalog_code": "id_Z15052"
},
"_type": "product"
},
{
"_id": "p-7893",
"_index": "catalog_2025_01",
"_score": 16.466125,
"_source": {
"catalog_code": "z953"
},
"_type": "product"
},
{
"_id": "p-60979",
"_index": "catalog_2025_01",
"_score": 16.0,
"_source": {
"catalog_code": "5979fd5311550"
},
"_type": "product"
},
{
"_id": "p-7891",
"_index": "catalog_2025_01",
"_score": 16.0,
"_source": {
"catalog_code": "z946"
},
"_type": "product"
},
{
"_id": "p-7892",
"_index": "catalog_2025_01",
"_score": 4.0,
"_source": {
"catalog_code": "z948"
},
"_type": "product"
}
],
"max_score": 23.589369,
"total": 33
},
"timed_out": false,
"took": 2
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 28,
"key": "26x34"
},
{
"doc_count": 28,
"key": "20x27"
},
{
"doc_count": 28,
"key": "15x21"
},
{
"doc_count": 25,
"key": "33x42"
},
{
"doc_count": 25,
"key": "40x49"
},
{
"doc_count": 23,
"key": "50x60"
},
{
"doc_count": 19,
"key": "12x17"
},
{
"doc_count": 3,
"key": "66x76"
},
{
"doc_count": 1,
"key": "80x90"
}
],
"name": "filetage",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [],
"name": "offers",
"unit": null
},
{
"buckets": [
{
"doc_count": 32,
"key": 1
},
{
"doc_count": 1,
"key": 0
}
],
"name": "delivery24h",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
}
],
"name": "continuum_price_stats_filtered",
"unit": null
},
{
"buckets": [
{
"doc_count": 1,
"key": "38-43"
}
],
"name": "diametre",
"unit": "mm"
},
{
"buckets": [
{
"doc_count": 33,
"key": "4bf0f9846eff4789923536"
},
{
"doc_count": 33,
"key": "508e9475abc79409512645"
},
{
"doc_count": 33,
"key": "655228bd826f1540518910"
},
{
"doc_count": 33,
"key": "root"
},
{
"doc_count": 29,
"key": "593006b0b2e8f397473129"
},
{
"doc_count": 23,
"key": "6555ea160d2ea356634000"
},
{
"doc_count": 8,
"key": "593007288901a600399332"
},
{
"doc_count": 6,
"key": "65522841b4bb1912585601"
},
{
"doc_count": 5,
"key": "5cdc0d203bb99832434778"
},
{
"doc_count": 5,
"key": "store_root"
},
{
"doc_count": 1,
"key": "4bf0f949557f4254696778"
},
{
"doc_count": 1,
"key": "512f167cea2a9428552561"
},
{
"doc_count": 1,
"key": "b710fe5c441ace57ec01bd863bf24778"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 23,
"key": "CODITAL"
},
{
"doc_count": 8,
"key": "GEBO"
},
{
"doc_count": 1,
"key": "ATLANTIC"
},
{
"doc_count": 1,
"key": "SFERACO"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"doc_count": 1,
"key": "Fonte"
},
{
"doc_count": 1,
"key": "Acier galvanis\u00e9"
}
],
"name": "matiere",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
},
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
},
{
"continuum_price_stats": {
"avg": 17.97709090909091,
"count": 33,
"max": 179.004,
"min": 0.804,
"sum": 593.244
},
"doc_count": 33
}
],
"name": "continuum_price",
"unit": null
}
]
flattened suggestions
[]