Affichage et signalisation

Affiner la sélection (0)

Catégories

Marques

Offres

Prix (€)

  • Min: 1

    Max: 465

Derniers produits vus

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
            }
        }
    },
    "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": "id_b_b09_b09a2"
                            }
                        }
                    ],
                    "must": {
                        "match_all": {}
                    }
                }
            },
            "score_mode": "sum"
        }
    },
    "size": 40
}

es raw result

{
    "_shards": {
        "failed": 0,
        "successful": 5,
        "total": 5
    },
    "aggregations": {
        "brand": {
            "buckets": [
                {
                    "doc_count": 26,
                    "key": "NOVAP"
                },
                {
                    "doc_count": 20,
                    "key": "WATTELEZ"
                },
                {
                    "doc_count": 4,
                    "key": "EDDING"
                },
                {
                    "doc_count": 4,
                    "key": "VISO"
                },
                {
                    "doc_count": 2,
                    "key": "BRICOZOR"
                },
                {
                    "doc_count": 2,
                    "key": "NORMBAU"
                },
                {
                    "doc_count": 1,
                    "key": "ARELEC"
                },
                {
                    "doc_count": 1,
                    "key": "BILCOCQ"
                },
                {
                    "doc_count": 1,
                    "key": "CHAUBEYRE"
                },
                {
                    "doc_count": 1,
                    "key": "DECAYEUX"
                },
                {
                    "doc_count": 1,
                    "key": "FTH THIRARD"
                },
                {
                    "doc_count": 1,
                    "key": "LEGRAND"
                },
                {
                    "doc_count": 1,
                    "key": "SOCONA"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "categories": {
            "buckets": [
                {
                    "doc_count": 65,
                    "key": "4bf0f7deefa77878491505"
                },
                {
                    "doc_count": 65,
                    "key": "id_b_b09_b09a2"
                },
                {
                    "doc_count": 65,
                    "key": "root"
                },
                {
                    "doc_count": 29,
                    "key": "4b7d0f9d989a9107034442"
                },
                {
                    "doc_count": 16,
                    "key": "store_root"
                },
                {
                    "doc_count": 15,
                    "key": "559bf314afd67895325308"
                },
                {
                    "doc_count": 3,
                    "key": "id_b_b09_b09a7_255"
                },
                {
                    "doc_count": 1,
                    "key": "4b8d255e2b235801788415"
                },
                {
                    "doc_count": 1,
                    "key": "4bf0f7f76be1a918683287"
                },
                {
                    "doc_count": 1,
                    "key": "4bf0f949557f4254696778"
                },
                {
                    "doc_count": 1,
                    "key": "534fbfaee0170513954769"
                },
                {
                    "doc_count": 1,
                    "key": "54525ac73a31a317973174"
                },
                {
                    "doc_count": 1,
                    "key": "57d13bdb40163936514093"
                },
                {
                    "doc_count": 1,
                    "key": "6274c094a9d9e966383468"
                },
                {
                    "doc_count": 1,
                    "key": "id_b_b09_b09b9"
                },
                {
                    "doc_count": 1,
                    "key": "id_b_b09_b09b9_188"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "continuum_price": {
            "buckets": {
                "*-*": {
                    "doc_count": 61
                }
            }
        },
        "continuum_price_stats": {
            "continuum_price_stats": {
                "avg": 75.25003278688526,
                "count": 61,
                "max": 464.496,
                "min": 1.356,
                "sum": 4590.252
            },
            "doc_count": 65
        },
        "continuum_price_stats_with_include_self_filter": {
            "continuum_price_stats": {
                "avg": 75.25003278688526,
                "count": 61,
                "max": 464.496,
                "min": 1.356,
                "sum": 4590.252
            },
            "doc_count": 65
        },
        "offers": {
            "buckets": [
                {
                    "doc_count": 26,
                    "key": "Fabrication Fran\u00e7aise"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        }
    },
    "hits": {
        "hits": [
            {
                "_id": "91590",
                "_index": "catalog_2023_02",
                "_score": 19.47321,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3056",
                "_index": "catalog_2023_02",
                "_score": 17.801918,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93729",
                "_index": "catalog_2023_02",
                "_score": 17.77815,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "100425",
                "_index": "catalog_2023_02",
                "_score": 17.647017,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3493",
                "_index": "catalog_2023_02",
                "_score": 17.261024,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "5557",
                "_index": "catalog_2023_02",
                "_score": 17.232042,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "5562",
                "_index": "catalog_2023_02",
                "_score": 17.146128,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "96632",
                "_index": "catalog_2023_02",
                "_score": 17.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "91588",
                "_index": "catalog_2023_02",
                "_score": 17.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "111955",
                "_index": "catalog_2023_02",
                "_score": 17.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "111654",
                "_index": "catalog_2023_02",
                "_score": 17.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3500",
                "_index": "catalog_2023_02",
                "_score": 16.942009,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "94002",
                "_index": "catalog_2023_02",
                "_score": 16.909822,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93971",
                "_index": "catalog_2023_02",
                "_score": 16.72016,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3499",
                "_index": "catalog_2023_02",
                "_score": 16.679201,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "5564",
                "_index": "catalog_2023_02",
                "_score": 16.658964,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3504",
                "_index": "catalog_2023_02",
                "_score": 16.653212,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3505",
                "_index": "catalog_2023_02",
                "_score": 16.640978,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "38885",
                "_index": "catalog_2023_02",
                "_score": 16.50515,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "94014",
                "_index": "catalog_2023_02",
                "_score": 16.419128,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93973",
                "_index": "catalog_2023_02",
                "_score": 16.39794,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "96633",
                "_index": "catalog_2023_02",
                "_score": 16.30103,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "96634",
                "_index": "catalog_2023_02",
                "_score": 16.30103,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3498",
                "_index": "catalog_2023_02",
                "_score": 16.290035,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "83555",
                "_index": "catalog_2023_02",
                "_score": 16.176092,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "91597",
                "_index": "catalog_2023_02",
                "_score": 16.176092,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "89133",
                "_index": "catalog_2023_02",
                "_score": 16.000042,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "48208",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "5558",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "31257",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59161",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "24280",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "78711",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "92215",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "100025",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "38882",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "31258",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "100022",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "78710",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "94003",
                "_index": "catalog_2023_02",
                "_score": 16.0,
                "_source": {},
                "_type": "product"
            }
        ],
        "max_score": 19.47321,
        "total": 65
    },
    "timed_out": false,
    "took": 5
}

flattened ui facets

[
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 75.25003278688526,
                    "count": 61,
                    "max": 464.496,
                    "min": 1.356,
                    "sum": 4590.252
                },
                "doc_count": 65
            },
            {
                "continuum_price_stats": {
                    "avg": 75.25003278688526,
                    "count": 61,
                    "max": 464.496,
                    "min": 1.356,
                    "sum": 4590.252
                },
                "doc_count": 65
            }
        ],
        "name": "continuum_price",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 75.25003278688526,
                    "count": 61,
                    "max": 464.496,
                    "min": 1.356,
                    "sum": 4590.252
                },
                "doc_count": 65
            }
        ],
        "name": "continuum_price_stats_with_include_self_filter",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 65,
                "key": "4bf0f7deefa77878491505"
            },
            {
                "doc_count": 65,
                "key": "id_b_b09_b09a2"
            },
            {
                "doc_count": 65,
                "key": "root"
            },
            {
                "doc_count": 29,
                "key": "4b7d0f9d989a9107034442"
            },
            {
                "doc_count": 16,
                "key": "store_root"
            },
            {
                "doc_count": 15,
                "key": "559bf314afd67895325308"
            },
            {
                "doc_count": 3,
                "key": "id_b_b09_b09a7_255"
            },
            {
                "doc_count": 1,
                "key": "4b8d255e2b235801788415"
            },
            {
                "doc_count": 1,
                "key": "4bf0f7f76be1a918683287"
            },
            {
                "doc_count": 1,
                "key": "4bf0f949557f4254696778"
            },
            {
                "doc_count": 1,
                "key": "534fbfaee0170513954769"
            },
            {
                "doc_count": 1,
                "key": "54525ac73a31a317973174"
            },
            {
                "doc_count": 1,
                "key": "57d13bdb40163936514093"
            },
            {
                "doc_count": 1,
                "key": "6274c094a9d9e966383468"
            },
            {
                "doc_count": 1,
                "key": "id_b_b09_b09b9"
            },
            {
                "doc_count": 1,
                "key": "id_b_b09_b09b9_188"
            }
        ],
        "name": "categories",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 75.25003278688526,
                    "count": 61,
                    "max": 464.496,
                    "min": 1.356,
                    "sum": 4590.252
                },
                "doc_count": 65
            }
        ],
        "name": "continuum_price_stats",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 26,
                "key": "Fabrication Fran\u00e7aise"
            }
        ],
        "name": "offers",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 26,
                "key": "NOVAP"
            },
            {
                "doc_count": 20,
                "key": "WATTELEZ"
            },
            {
                "doc_count": 4,
                "key": "EDDING"
            },
            {
                "doc_count": 4,
                "key": "VISO"
            },
            {
                "doc_count": 2,
                "key": "BRICOZOR"
            },
            {
                "doc_count": 2,
                "key": "NORMBAU"
            },
            {
                "doc_count": 1,
                "key": "ARELEC"
            },
            {
                "doc_count": 1,
                "key": "BILCOCQ"
            },
            {
                "doc_count": 1,
                "key": "CHAUBEYRE"
            },
            {
                "doc_count": 1,
                "key": "DECAYEUX"
            },
            {
                "doc_count": 1,
                "key": "FTH THIRARD"
            },
            {
                "doc_count": 1,
                "key": "LEGRAND"
            },
            {
                "doc_count": 1,
                "key": "SOCONA"
            }
        ],
        "name": "brand",
        "unit": null
    }
]

flattened suggestions

[]