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 (
    515, 514, 513, 512, 511, 510, 509, 508, 
    507, 506, 505, 504, 503, 502, 501, 499, 
    500, 498, 497, 496, 495, 494, 493, 492, 
    491, 490, 489, 488, 487, 486, 485, 484, 
    483, 482, 481, 480, 479, 478, 477, 476, 
    475, 474, 473, 472, 471, 470, 469, 468
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "12.56"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 52,
      "rows_produced_per_join": 48,
      "filtered": "92.31",
      "cost_info": {
        "read_cost": "2.97",
        "eval_cost": "9.60",
        "prefix_cost": "12.57",
        "data_read_per_join": "768"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ],
      "attached_condition": "((`danishecarter_latest`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`danishecarter_latest`.`cscart_product_review_prepared_data`.`product_id` in (515,514,513,512,511,510,509,508,507,506,505,504,503,502,501,499,500,498,497,496,495,494,493,492,491,490,489,488,487,486,485,484,483,482,481,480,479,478,477,476,475,474,473,472,471,470,469,468)))"
    }
  }
}