Trappes de visite

Affiner la sélection (0)

Catégories

Marques

Offres

Prix (€)

  • Min: 7

    Max: 226

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

es raw result

{
    "_shards": {
        "failed": 0,
        "successful": 5,
        "total": 5
    },
    "aggregations": {
        "brand": {
            "buckets": [
                {
                    "doc_count": 3,
                    "key": "BRICOZOR"
                },
                {
                    "doc_count": 3,
                    "key": "NICOLL"
                },
                {
                    "doc_count": 1,
                    "key": "MERMIER"
                },
                {
                    "doc_count": 1,
                    "key": "RAWL"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "categories": {
            "buckets": [
                {
                    "doc_count": 8,
                    "key": "4bf0f7deefa77878491505"
                },
                {
                    "doc_count": 8,
                    "key": "521325c0e6caf784331911"
                },
                {
                    "doc_count": 8,
                    "key": "root"
                },
                {
                    "doc_count": 1,
                    "key": "559bf314afd67895325308"
                },
                {
                    "doc_count": 1,
                    "key": "store_root"
                }
            ],
            "doc_count_error_upper_bound": 0,
            "sum_other_doc_count": 0
        },
        "continuum_price": {
            "buckets": {
                "*-*": {
                    "doc_count": 8
                }
            }
        },
        "continuum_price_stats": {
            "continuum_price_stats": {
                "avg": 78.99749999999999,
                "count": 8,
                "max": 225.828,
                "min": 7.236,
                "sum": 631.9799999999999
            },
            "doc_count": 8
        },
        "continuum_price_stats_with_include_self_filter": {
            "continuum_price_stats": {
                "avg": 78.99749999999999,
                "count": 8,
                "max": 225.828,
                "min": 7.236,
                "sum": 631.9799999999999
            },
            "doc_count": 8
        },
        "offers": {
            "buckets": [
                {
                    "doc_count": 1,
                    "key": "Fabrication Fran\u00e7aise"
                },
                {
                    "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": "2336",
                "_index": "catalog_2023_02",
                "_score": 20.436148,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "93418",
                "_index": "catalog_2023_02",
                "_score": 18.687975,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59259",
                "_index": "catalog_2023_02",
                "_score": 17.28146,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "32816",
                "_index": "catalog_2023_02",
                "_score": 17.203033,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59872",
                "_index": "catalog_2023_02",
                "_score": 16.835056,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59870",
                "_index": "catalog_2023_02",
                "_score": 16.72016,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "2268",
                "_index": "catalog_2023_02",
                "_score": 16.681242,
                "_source": {},
                "_type": "product"
            },
            {
                "_id": "59871",
                "_index": "catalog_2023_02",
                "_score": 16.176092,
                "_source": {},
                "_type": "product"
            }
        ],
        "max_score": 20.436148,
        "total": 8
    },
    "timed_out": false,
    "took": 2
}

flattened ui facets

[
    {
        "buckets": [
            {
                "doc_count": 8,
                "key": "4bf0f7deefa77878491505"
            },
            {
                "doc_count": 8,
                "key": "521325c0e6caf784331911"
            },
            {
                "doc_count": 8,
                "key": "root"
            },
            {
                "doc_count": 1,
                "key": "559bf314afd67895325308"
            },
            {
                "doc_count": 1,
                "key": "store_root"
            }
        ],
        "name": "categories",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 78.99749999999999,
                    "count": 8,
                    "max": 225.828,
                    "min": 7.236,
                    "sum": 631.9799999999999
                },
                "doc_count": 8
            }
        ],
        "name": "continuum_price_stats",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 3,
                "key": "BRICOZOR"
            },
            {
                "doc_count": 3,
                "key": "NICOLL"
            },
            {
                "doc_count": 1,
                "key": "MERMIER"
            },
            {
                "doc_count": 1,
                "key": "RAWL"
            }
        ],
        "name": "brand",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 78.99749999999999,
                    "count": 8,
                    "max": 225.828,
                    "min": 7.236,
                    "sum": 631.9799999999999
                },
                "doc_count": 8
            }
        ],
        "name": "continuum_price_stats_with_include_self_filter",
        "unit": null
    },
    {
        "buckets": [
            {
                "doc_count": 1,
                "key": "Fabrication Fran\u00e7aise"
            },
            {
                "doc_count": 1,
                "key": "Quincailerie B"
            },
            {
                "doc_count": 1,
                "key": "Quincaillerie A"
            }
        ],
        "name": "offers",
        "unit": null
    },
    {
        "buckets": [
            {
                "continuum_price_stats": {
                    "avg": 78.99749999999999,
                    "count": 8,
                    "max": 225.828,
                    "min": 7.236,
                    "sum": 631.9799999999999
                },
                "doc_count": 8
            },
            {
                "continuum_price_stats": {
                    "avg": 78.99749999999999,
                    "count": 8,
                    "max": 225.828,
                    "min": 7.236,
                    "sum": 631.9799999999999
                },
                "doc_count": 8
            }
        ],
        "name": "continuum_price",
        "unit": null
    }
]

flattened suggestions

[]