Coffre et boîte à clé

Affiner la sélection (0)

Catégories

Marques

Offres

Prix (€)

  • Min: 2

    Max: 6077

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

es raw result

{
    "_shards": {
        "failed": 0,
        "successful": 5,
        "total": 5
    },
    "aggregations": {
        "brand": {
            "buckets": [
                {
                    "doc_count": 63,
                    "key": "BURG WACHTER"
                },
                {
                    "doc_count": 25,
                    "key": "FTH THIRARD"
                },
                {
                    "doc_count": 13,
                    "key": "MASTER LOCK"
                },
                {
                    "doc_count": 9,
                    "key": "YALE"
                },
                {
                    "doc_count": 8,
                    "key": "ABUS"
                },
                {
                    "doc_count": 4,
                    "key": "MONIN"
                },
                {
                    "doc_count": 2,
                    "key": "BRICOZOR"
                },
                {
                    "doc_count": 2,
                    "key": "RENZ"
                },
                {
                    "doc_count": 1,
                    "key": "BOURG INDUSTRIES"
                },
                {
                    "doc_count": 1,
                    "key": "COUILLET"
                },
                {
                    "doc_count": 1,
                    "key": "Igloohome"
                },
                {
                    "doc_count": 1,
                    "key": "JPM"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "categories": {
            "buckets": [
                {
                    "doc_count": 136,
                    "key": "4bf0f7deefa77878491505"
                },
                {
                    "doc_count": 136,
                    "key": "5afedb03ac99f495872437"
                },
                {
                    "doc_count": 136,
                    "key": "root"
                },
                {
                    "doc_count": 55,
                    "key": "id_b_b09_b09a7_73"
                },
                {
                    "doc_count": 45,
                    "key": "527cb20711d60758541247"
                },
                {
                    "doc_count": 24,
                    "key": "id_b_b09_b09a7_129"
                },
                {
                    "doc_count": 7,
                    "key": "store_root"
                },
                {
                    "doc_count": 4,
                    "key": "551cf703a4267300482723"
                },
                {
                    "doc_count": 4,
                    "key": "id_b_b09_b09b2_17"
                },
                {
                    "doc_count": 3,
                    "key": "559bf314afd67895325308"
                },
                {
                    "doc_count": 3,
                    "key": "58736d52850e6399573241"
                },
                {
                    "doc_count": 2,
                    "key": "id_b_b09_b09b2_423"
                },
                {
                    "doc_count": 1,
                    "key": "50a525ae16f54096291282"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "continuum_price": {
            "buckets": {
                "*-*": {
                    "doc_count": 120
                }
            }
        },
        "continuum_price_stats": {
            "continuum_price_stats": {
                "avg": 321.22239999999994,
                "count": 120,
                "max": 6076.836,
                "min": 2.664,
                "sum": 38546.687999999995
            },
            "doc_count": 136
        },
        "continuum_price_stats_with_include_self_filter": {
            "continuum_price_stats": {
                "avg": 321.22239999999994,
                "count": 120,
                "max": 6076.836,
                "min": 2.664,
                "sum": 38546.687999999995
            },
            "doc_count": 136
        },
        "offers": {
            "buckets": [
                {
                    "doc_count": 4,
                    "key": "Destockage"
                },
                {
                    "doc_count": 3,
                    "key": "Fabrication Fran\u00e7aise"
                },
                {
                    "doc_count": 2,
                    "key": "Livraison gratuite"
                },
                {
                    "doc_count": 1,
                    "key": "Notre s\u00e9lection"
                },
                {
                    "doc_count": 1,
                    "key": "Quincailerie B"
                },
                {
                    "doc_count": 1,
                    "key": "Quincaillerie A"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        }
    },
    "hits": {
        "hits": [
            {
                "_id": "6704",
                "_index": "catalog_2023_02",
                "_score": 19.07063,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "26135",
                "_index": "catalog_2023_02",
                "_score": 18.381702,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3146",
                "_index": "catalog_2023_02",
                "_score": 18.193125,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "82764",
                "_index": "catalog_2023_02",
                "_score": 18.117996,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "92827",
                "_index": "catalog_2023_02",
                "_score": 18.015675,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "82763",
                "_index": "catalog_2023_02",
                "_score": 17.944483,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "114427",
                "_index": "catalog_2023_02",
                "_score": 17.921797,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3194",
                "_index": "catalog_2023_02",
                "_score": 17.869818,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "82451",
                "_index": "catalog_2023_02",
                "_score": 17.428337,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3192",
                "_index": "catalog_2023_02",
                "_score": 17.186285,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "107766",
                "_index": "catalog_2023_02",
                "_score": 16.94224,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "71917",
                "_index": "catalog_2023_02",
                "_score": 16.942009,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "69773",
                "_index": "catalog_2023_02",
                "_score": 16.931013,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103748",
                "_index": "catalog_2023_02",
                "_score": 16.853796,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113651",
                "_index": "catalog_2023_02",
                "_score": 16.846107,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "35058",
                "_index": "catalog_2023_02",
                "_score": 16.80618,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3190",
                "_index": "catalog_2023_02",
                "_score": 16.760422,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "92826",
                "_index": "catalog_2023_02",
                "_score": 16.72016,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59710",
                "_index": "catalog_2023_02",
                "_score": 16.681242,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3193",
                "_index": "catalog_2023_02",
                "_score": 16.591064,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113569",
                "_index": "catalog_2023_02",
                "_score": 16.48785,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59709",
                "_index": "catalog_2023_02",
                "_score": 16.477121,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "3187",
                "_index": "catalog_2023_02",
                "_score": 16.466125,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "10035",
                "_index": "catalog_2023_02",
                "_score": 16.466125,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93829",
                "_index": "catalog_2023_02",
                "_score": 16.449064,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93831",
                "_index": "catalog_2023_02",
                "_score": 16.449059,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103749",
                "_index": "catalog_2023_02",
                "_score": 16.441793,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103739",
                "_index": "catalog_2023_02",
                "_score": 16.441788,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103513",
                "_index": "catalog_2023_02",
                "_score": 16.441782,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93827",
                "_index": "catalog_2023_02",
                "_score": 16.441769,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103746",
                "_index": "catalog_2023_02",
                "_score": 16.434671,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103747",
                "_index": "catalog_2023_02",
                "_score": 16.43467,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103750",
                "_index": "catalog_2023_02",
                "_score": 16.43441,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103744",
                "_index": "catalog_2023_02",
                "_score": 16.426981,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "103745",
                "_index": "catalog_2023_02",
                "_score": 16.426975,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113653",
                "_index": "catalog_2023_02",
                "_score": 16.426971,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113654",
                "_index": "catalog_2023_02",
                "_score": 16.426968,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "83878",
                "_index": "catalog_2023_02",
                "_score": 16.419128,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113648",
                "_index": "catalog_2023_02",
                "_score": 16.406033,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "113647",
                "_index": "catalog_2023_02",
                "_score": 16.40603,
                "_source": {},
                "_type": "product"
            }
        ],
        "max_score": 19.07063,
        "total": 136
    },
    "timed_out": false,
    "took": 5
}

flattened ui facets

[
    {
        "buckets": [
            {
                "doc_count": 136,
                "key": "4bf0f7deefa77878491505"
            },
            {
                "doc_count": 136,
                "key": "5afedb03ac99f495872437"
            },
            {
                "doc_count": 136,
                "key": "root"
            },
            {
                "doc_count": 55,
                "key": "id_b_b09_b09a7_73"
            },
            {
                "doc_count": 45,
                "key": "527cb20711d60758541247"
            },
            {
                "doc_count": 24,
                "key": "id_b_b09_b09a7_129"
            },
            {
                "doc_count": 7,
                "key": "store_root"
            },
            {
                "doc_count": 4,
                "key": "551cf703a4267300482723"
            },
            {
                "doc_count": 4,
                "key": "id_b_b09_b09b2_17"
            },
            {
                "doc_count": 3,
                "key": "559bf314afd67895325308"
            },
            {
                "doc_count": 3,
                "key": "58736d52850e6399573241"
            },
            {
                "doc_count": 2,
                "key": "id_b_b09_b09b2_423"
            },
            {
                "doc_count": 1,
                "key": "50a525ae16f54096291282"
            }
        ],
        "name": "categories",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 321.22239999999994,
                    "count": 120,
                    "max": 6076.836,
                    "min": 2.664,
                    "sum": 38546.687999999995
                },
                "doc_count": 136
            }
        ],
        "name": "continuum_price_stats",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 63,
                "key": "BURG WACHTER"
            },
            {
                "doc_count": 25,
                "key": "FTH THIRARD"
            },
            {
                "doc_count": 13,
                "key": "MASTER LOCK"
            },
            {
                "doc_count": 9,
                "key": "YALE"
            },
            {
                "doc_count": 8,
                "key": "ABUS"
            },
            {
                "doc_count": 4,
                "key": "MONIN"
            },
            {
                "doc_count": 2,
                "key": "BRICOZOR"
            },
            {
                "doc_count": 2,
                "key": "RENZ"
            },
            {
                "doc_count": 1,
                "key": "BOURG INDUSTRIES"
            },
            {
                "doc_count": 1,
                "key": "COUILLET"
            },
            {
                "doc_count": 1,
                "key": "Igloohome"
            },
            {
                "doc_count": 1,
                "key": "JPM"
            }
        ],
        "name": "brand",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 321.22239999999994,
                    "count": 120,
                    "max": 6076.836,
                    "min": 2.664,
                    "sum": 38546.687999999995
                },
                "doc_count": 136
            }
        ],
        "name": "continuum_price_stats_with_include_self_filter",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 4,
                "key": "Destockage"
            },
            {
                "doc_count": 3,
                "key": "Fabrication Fran\u00e7aise"
            },
            {
                "doc_count": 2,
                "key": "Livraison gratuite"
            },
            {
                "doc_count": 1,
                "key": "Notre s\u00e9lection"
            },
            {
                "doc_count": 1,
                "key": "Quincailerie B"
            },
            {
                "doc_count": 1,
                "key": "Quincaillerie A"
            }
        ],
        "name": "offers",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 321.22239999999994,
                    "count": 120,
                    "max": 6076.836,
                    "min": 2.664,
                    "sum": 38546.687999999995
                },
                "doc_count": 136
            },
            {
                "continuum_price_stats": {
                    "avg": 321.22239999999994,
                    "count": 120,
                    "max": 6076.836,
                    "min": 2.664,
                    "sum": 38546.687999999995
                },
                "doc_count": 136
            }
        ],
        "name": "continuum_price",
        "unit": null
    }
]

flattened suggestions

[]