SELECT 
  cscart_product_review_prepared_data.product_id AS product_id, 
  cscart_product_review_prepared_data.average_rating AS average_rating, 
  cscart_product_review_prepared_data.reviews_count AS reviews_count 
FROM 
  cscart_product_review_prepared_data 
WHERE 
  cscart_product_review_prepared_data.product_id IN (
    40617, 40645, 40646, 54711, 40650, 40647, 
    40675, 40684, 40668, 40614, 40676, 
    40644, 40659, 40618, 40683, 40685, 
    40664, 40642, 40655, 40678, 40605, 
    40686, 40649, 40677, 40660, 40609, 
    40656, 40670, 40682, 40710, 40711, 
    55943, 40657, 40648, 40663, 40613, 
    70304
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00065

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "25.91"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "storefront_id"
      ],
      "key_length": "7",
      "rows_examined_per_scan": 37,
      "rows_produced_per_join": 37,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`cscartdb`.`cscart_product_review_prepared_data`.`product_id` in (40617,40645,40646,54711,40650,40647,40675,40684,40668,40614,40676,40644,40659,40618,40683,40685,40664,40642,40655,40678,40605,40686,40649,40677,40660,40609,40656,40670,40682,40710,40711,55943,40657,40648,40663,40613,70304)))",
      "cost_info": {
        "read_cost": "22.21",
        "eval_cost": "3.70",
        "prefix_cost": "25.91",
        "data_read_per_join": "592"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ]
    }
  }
}