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_with_include_self_filter": {
"aggs": {
"continuum_price_stats": {
"stats": {
"field": "lowest_public_price_with_vat"
}
}
},
"filter": {
"match_all": {}
}
},
"largeur": {
"aggs": {
"largeur_nested": {
"aggs": {
"largeur_nested_filtered": {
"aggs": {
"largeur_reverse_nested": {
"aggs": {
"largeur_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"largeur_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Largeur"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"longueur": {
"aggs": {
"longueur_nested": {
"aggs": {
"longueur_nested_filtered": {
"aggs": {
"longueur_reverse_nested": {
"aggs": {
"longueur_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"longueur_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Longueur"
}
}
}
},
"nested": {
"path": "articles.characteristics"
}
},
"nombre-de-cuves": {
"aggs": {
"nombre-de-cuves_nested": {
"aggs": {
"nombre-de-cuves_nested_filtered": {
"aggs": {
"nombre-de-cuves_reverse_nested": {
"aggs": {
"nombre-de-cuves_reverse_nested_parent_filter": {
"filter": {
"match_all": {}
}
}
},
"reverse_nested": {}
},
"nombre-de-cuves_unit": {
"terms": {
"field": "articles.characteristics.unit.untouched",
"size": 1
}
}
},
"terms": {
"field": "articles.characteristics.value.untouched",
"size": 1000
}
}
},
"filter": {
"term": {
"articles.characteristics.name.untouched": "Nombre de cuves"
}
}
}
},
"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": "4fb38f5aa0eeb713707284"
}
}
],
"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": "FRANKE"
},
{
"doc_count": 1,
"key": "MODERNA"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"categories": {
"buckets": [
{
"doc_count": 28,
"key": "4fb38f5aa0eeb713707284"
},
{
"doc_count": 28,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 28,
"key": "e7513fad3e41f597b1786f1f6294e57e"
},
{
"doc_count": 28,
"key": "root"
},
{
"doc_count": 1,
"key": "4f75b5c9625f9523338350"
},
{
"doc_count": 1,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 1,
"key": "store_root"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
},
"continuum_price": {
"buckets": {
"*-*": {
"doc_count": 28
}
}
},
"continuum_price_stats": {
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
},
"continuum_price_stats_with_include_self_filter": {
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
},
"largeur": {
"doc_count": 634,
"largeur_nested": {
"doc_count": 0,
"largeur_nested_filtered": {
"buckets": [],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"longueur": {
"doc_count": 634,
"longueur_nested": {
"doc_count": 6,
"longueur_nested_filtered": {
"buckets": [
{
"doc_count": 2,
"key": "1000",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 2,
"key": "1160",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 2,
"key": "860",
"longueur_reverse_nested": {
"doc_count": 1,
"longueur_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"longueur_unit": {
"buckets": [
{
"doc_count": 2,
"key": "mm"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
}
},
"nombre-de-cuves": {
"doc_count": 634,
"nombre-de-cuves_nested": {
"doc_count": 72,
"nombre-de-cuves_nested_filtered": {
"buckets": [
{
"doc_count": 51,
"key": "1",
"nombre-de-cuves_reverse_nested": {
"doc_count": 20,
"nombre-de-cuves_reverse_nested_parent_filter": {
"doc_count": 20
}
},
"nombre-de-cuves_unit": {
"buckets": [
{
"doc_count": 51,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 15,
"key": "2",
"nombre-de-cuves_reverse_nested": {
"doc_count": 7,
"nombre-de-cuves_reverse_nested_parent_filter": {
"doc_count": 7
}
},
"nombre-de-cuves_unit": {
"buckets": [
{
"doc_count": 15,
"key": ""
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
{
"doc_count": 6,
"key": "1.5",
"nombre-de-cuves_reverse_nested": {
"doc_count": 1,
"nombre-de-cuves_reverse_nested_parent_filter": {
"doc_count": 1
}
},
"nombre-de-cuves_unit": {
"buckets": [
{
"doc_count": 6,
"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": 5,
"key": "Fond de rayon Sanitaire"
},
{
"doc_count": 1,
"key": "Fond de rayon Sanitaire 2"
}
],
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0
}
},
"hits": {
"hits": [
{
"_id": "p-59490",
"_index": "catalog_2025_01",
"_score": 20.601887,
"_source": {
"catalog_code": "ad5bfb19fb5e43cdf83ea8b5321b8ca4"
},
"_type": "product"
},
{
"_id": "p-71058",
"_index": "catalog_2025_01",
"_score": 19.884016,
"_source": {
"catalog_code": "id_229139"
},
"_type": "product"
},
{
"_id": "p-31516",
"_index": "catalog_2025_01",
"_score": 18.941511,
"_source": {
"catalog_code": "5601887df16eb44665e392358308d112"
},
"_type": "product"
},
{
"_id": "p-123208",
"_index": "catalog_2025_01",
"_score": 18.925825,
"_source": {
"catalog_code": "id_611292"
},
"_type": "product"
},
{
"_id": "p-97731",
"_index": "catalog_2025_01",
"_score": 18.176092,
"_source": {
"catalog_code": "7e392db458fb5a3d241a7eec1373d8ab_615804fc62704"
},
"_type": "product"
},
{
"_id": "p-98535",
"_index": "catalog_2025_01",
"_score": 17.965279,
"_source": {
"catalog_code": "b69cc469ce901b9456ede2472bef0fe3_6180f22475ece"
},
"_type": "product"
},
{
"_id": "p-31514",
"_index": "catalog_2025_01",
"_score": 17.8173,
"_source": {
"catalog_code": "9bbac890d051c2f254567799136e7acd"
},
"_type": "product"
},
{
"_id": "p-120245",
"_index": "catalog_2025_01",
"_score": 17.375175,
"_source": {
"catalog_code": "19fdfa7ac7533f03c2effe472caa3d10_66fcd370d8a2b"
},
"_type": "product"
},
{
"_id": "p-71053",
"_index": "catalog_2025_01",
"_score": 16.929419,
"_source": {
"catalog_code": "id_459440"
},
"_type": "product"
},
{
"_id": "p-59491",
"_index": "catalog_2025_01",
"_score": 16.92428,
"_source": {
"catalog_code": "e9dcc19748e1fc53a2de8478daafee2a"
},
"_type": "product"
},
{
"_id": "p-92205",
"_index": "catalog_2025_01",
"_score": 16.892094,
"_source": {
"catalog_code": "f75135c608a2b2ce4792c11cf47faf90_5fa10e3988720"
},
"_type": "product"
},
{
"_id": "p-71040",
"_index": "catalog_2025_01",
"_score": 16.852785,
"_source": {
"catalog_code": "id_229122"
},
"_type": "product"
},
{
"_id": "p-120244",
"_index": "catalog_2025_01",
"_score": 16.69357,
"_source": {
"catalog_code": "ff6bea32971d63284508a373f3b244d8_66fcd3708a59c"
},
"_type": "product"
},
{
"_id": "p-92204",
"_index": "catalog_2025_01",
"_score": 16.653212,
"_source": {
"catalog_code": "43765f3accd60a9755e6c816d19e2072_5fa10e374e856"
},
"_type": "product"
},
{
"_id": "p-107410",
"_index": "catalog_2025_01",
"_score": 16.176247,
"_source": {
"catalog_code": "d3b2e5ed665c00bb08159ec0a904cea8_634f9271b02d0"
},
"_type": "product"
},
{
"_id": "p-97730",
"_index": "catalog_2025_01",
"_score": 16.176092,
"_source": {
"catalog_code": "9fcd887363400734cc5507ae0cc49990_615804fa72c6a"
},
"_type": "product"
},
{
"_id": "p-107446",
"_index": "catalog_2025_01",
"_score": 16.17205,
"_source": {
"catalog_code": "760f7754e09ed523245a6547ce7e5563_63538706e3d1c"
},
"_type": "product"
},
{
"_id": "p-107447",
"_index": "catalog_2025_01",
"_score": 16.172014,
"_source": {
"catalog_code": "63ff6e09354b2eada2b0ccb08bf81b68_63538707204df"
},
"_type": "product"
},
{
"_id": "p-107448",
"_index": "catalog_2025_01",
"_score": 16.172009,
"_source": {
"catalog_code": "8191c0021374e741cbcf1b3416ca0418_635387077f3d5"
},
"_type": "product"
},
{
"_id": "p-107449",
"_index": "catalog_2025_01",
"_score": 16.170639,
"_source": {
"catalog_code": "d597527381225fe7c68c0e45c89b5257_63538707ef763"
},
"_type": "product"
},
{
"_id": "p-107450",
"_index": "catalog_2025_01",
"_score": 16.163767,
"_source": {
"catalog_code": "50ed236874ae076fca58febea0633d56_63538708387b0"
},
"_type": "product"
},
{
"_id": "p-107408",
"_index": "catalog_2025_01",
"_score": 16.162561,
"_source": {
"catalog_code": "9b4104d14e7d03ce4755a365f228fcee_634f927045535"
},
"_type": "product"
},
{
"_id": "p-107409",
"_index": "catalog_2025_01",
"_score": 16.16256,
"_source": {
"catalog_code": "83a4124d776646d23889b07838fae5ae_634f9270c2c93"
},
"_type": "product"
},
{
"_id": "p-107451",
"_index": "catalog_2025_01",
"_score": 16.162558,
"_source": {
"catalog_code": "5441d8bb71ce04d425f4a420eb824005_6353870ab0f81"
},
"_type": "product"
},
{
"_id": "p-107466",
"_index": "catalog_2025_01",
"_score": 16.15185,
"_source": {
"catalog_code": "716d82bd061ab360313e90fbcee57cc4_6353871252229"
},
"_type": "product"
},
{
"_id": "p-107467",
"_index": "catalog_2025_01",
"_score": 16.151842,
"_source": {
"catalog_code": "507a30b7f69f41959aa390fb7ccb932c_635387128f211"
},
"_type": "product"
},
{
"_id": "p-107452",
"_index": "catalog_2025_01",
"_score": 16.1479,
"_source": {
"catalog_code": "d6d58a8e16c5504b88a1c51396d41c29_6353870b7da89"
},
"_type": "product"
},
{
"_id": "p-71073",
"_index": "catalog_2025_01",
"_score": 16.0,
"_source": {
"catalog_code": "id_009854"
},
"_type": "product"
}
],
"max_score": 20.601887,
"total": 28
},
"timed_out": false,
"took": 3
}
flattened ui facets
[
{
"buckets": [
{
"doc_count": 1,
"key": "1000"
},
{
"doc_count": 1,
"key": "1160"
},
{
"doc_count": 1,
"key": "860"
}
],
"name": "longueur",
"unit": "mm"
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
}
],
"name": "continuum_price_stats_with_include_self_filter",
"unit": null
},
{
"buckets": [
{
"doc_count": 5,
"key": "Fond de rayon Sanitaire"
},
{
"doc_count": 1,
"key": "Fond de rayon Sanitaire 2"
}
],
"name": "offers",
"unit": null
},
{
"buckets": [],
"name": "largeur",
"unit": null
},
{
"buckets": [
{
"doc_count": 28,
"key": "4fb38f5aa0eeb713707284"
},
{
"doc_count": 28,
"key": "543e3b8b3746b410428977"
},
{
"doc_count": 28,
"key": "e7513fad3e41f597b1786f1f6294e57e"
},
{
"doc_count": 28,
"key": "root"
},
{
"doc_count": 1,
"key": "4f75b5c9625f9523338350"
},
{
"doc_count": 1,
"key": "539ab2c0c06da833776716"
},
{
"doc_count": 1,
"key": "store_root"
}
],
"name": "categories",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
}
],
"name": "continuum_price_stats",
"unit": null
},
{
"buckets": [
{
"doc_count": 27,
"key": "FRANKE"
},
{
"doc_count": 1,
"key": "MODERNA"
}
],
"name": "brand",
"unit": null
},
{
"buckets": [
{
"doc_count": 20,
"key": "1"
},
{
"doc_count": 7,
"key": "2"
},
{
"doc_count": 1,
"key": "1.5"
}
],
"name": "nombre-de-cuves",
"unit": null
},
{
"buckets": [
{
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
},
{
"continuum_price_stats": {
"avg": 424.4125714285714,
"count": 28,
"max": 926.904,
"min": 127.296,
"sum": 11883.552
},
"doc_count": 28
}
],
"name": "continuum_price",
"unit": null
}
]
flattened suggestions
[]
