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 (
    9966, 10092, 9952, 9954, 9956, 9968, 
    9971, 9933, 12832, 26571, 12034, 26594, 
    12750, 13165, 12033, 12084, 26563, 
    12082, 13191, 26589, 12090, 27008, 
    9920, 12751, 12092, 12091, 26591, 26532, 
    12685, 12969, 12025, 26578, 13044, 
    26557, 12749, 10022, 26573, 26576, 
    12024, 26535, 26607, 12023, 36434, 
    13043, 13042, 12063, 12831, 26572, 
    26605, 26604
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00076

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "35.01"
    },
    "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": 50,
      "rows_produced_per_join": 50,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`cscartdb`.`cscart_product_review_prepared_data`.`product_id` in (9966,10092,9952,9954,9956,9968,9971,9933,12832,26571,12034,26594,12750,13165,12033,12084,26563,12082,13191,26589,12090,27008,9920,12751,12092,12091,26591,26532,12685,12969,12025,26578,13044,26557,12749,10022,26573,26576,12024,26535,26607,12023,36434,13043,13042,12063,12831,26572,26605,26604)))",
      "cost_info": {
        "read_cost": "30.01",
        "eval_cost": "5.00",
        "prefix_cost": "35.01",
        "data_read_per_join": "800"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ]
    }
  }
}