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 (
    908, 3090, 2372, 2752, 1143, 2359, 2559, 
    2363, 2845, 2822, 2603, 3136, 2253, 
    2367, 2854, 2751, 2809, 2255, 2587, 
    2927, 2729, 2761, 3140, 1542, 2374, 
    2694, 3026, 3142, 853, 2812, 3096, 1540, 
    1544, 2736, 4887, 2723, 2829, 2742, 
    3556, 2251
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00128

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.00"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 5,
      "rows_produced_per_join": 5,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.50",
        "eval_cost": "0.50",
        "prefix_cost": "1.00",
        "data_read_per_join": "80"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ],
      "attached_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_product_review_prepared_data`.`product_id` in (908,3090,2372,2752,1143,2359,2559,2363,2845,2822,2603,3136,2253,2367,2854,2751,2809,2255,2587,2927,2729,2761,3140,1542,2374,2694,3026,3142,853,2812,3096,1540,1544,2736,4887,2723,2829,2742,3556,2251)))"
    }
  }
}