slow_query.json

{
   "aggs": {
      "_filter_audience": {
         "aggs": {
            "audience": {
               "terms": {
                  "field": "audience"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
      "_filter_author": {
         "aggs": {
            "author": {
               "terms": {
                  "field": "author_ids"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
      "_filter_brand": {
         "aggs": {
            "brand": {
               "terms": {
                  "field": "brand"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
      "_filter_categories": {
         "aggs": {
            "categories": {
               "terms": {
                  "field": "category_ids"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
      
      "_filter_format": {
         "aggs": {
            "format": {
               "terms": {
                  "field": "format"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
      "_filter_language": {
         "aggs": {
            "language": {
               "terms": {
                  "field": "language"
               }
            }
         },
         "filter": {
            "match_all": {}
         }
      },
   },
   "explain": false,
   "fields": [
      "site_id"
   ],
   "from": 0,
   "query": {
      "filtered": {
         "filter": {
            "bool": {
               "must": [
                  {
                     "term": {
                        "department": 1
                     }
                  },
                  {
                     "term": {
                        "category_ids": 1
                     }
                  }
               ]
            }
         },
         "query": {
            "function_score": {
               "functions": [
                  {
                     "exp": {
                        "date_released": {
                           "decay": "0.5",
                           "offset": "26w",
                           "origin": "now/1d",
                           "scale": "180d"
                        }
                     }
                  },
                  {
                     "field_value_factor": {
                        "factor": 1,
                        "field": "num_purchases",
                        "missing": 0,
                        "modifier": "log1p"
                     }
                  },
                  {
                     "filter": {
                        "term": {
                           "has_image": true
                        }
                     },
                     "weight": 1.5
                  }
               ]
            }
         }
      }
   },
   "size": 30,
   "sort": [
      {
         "is_available": {
            "order": "desc"
         }
      },
      {
         "_score": {
            "order": "desc"
         }
      }
   ]
}