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 (
    220173, 339556, 254330, 339744, 339676, 
    339576, 339461, 391686, 339748, 392163, 
    387088, 339667, 339645, 151062, 339684, 
    151100, 254331, 339583, 387086, 339588, 
    339708, 387055, 339826, 339454, 339547, 
    339553, 339633, 387090, 339580, 339548, 
    339657, 339777, 339632, 339649, 339711, 
    339743, 339719, 339647, 339716, 339773, 
    339776, 387065, 339474, 339756, 339745, 
    339471, 387054, 265037, 339577, 339848, 
    339666, 339552, 339665, 339669, 339767, 
    339670, 387066, 339833, 339698, 339703, 
    220171, 339557, 339544, 339646, 339651, 
    339749, 339824, 339455, 339628, 339591, 
    387052, 339784, 339549, 339565, 339673, 
    339614, 339789, 339575, 339662, 265040, 
    339595, 339834, 339853, 339653, 339658, 
    339818, 339626, 339631, 339717, 339852, 
    339559, 339470, 339545, 339487, 339542, 
    339822, 339579, 339567, 271697, 339850
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00049

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.87"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 19,
      "rows_produced_per_join": 19,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "2.07",
        "eval_cost": "3.80",
        "prefix_cost": "5.87",
        "data_read_per_join": "304"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ],
      "attached_condition": "((`webmarco`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`webmarco`.`cscart_product_review_prepared_data`.`product_id` in (220173,339556,254330,339744,339676,339576,339461,391686,339748,392163,387088,339667,339645,151062,339684,151100,254331,339583,387086,339588,339708,387055,339826,339454,339547,339553,339633,387090,339580,339548,339657,339777,339632,339649,339711,339743,339719,339647,339716,339773,339776,387065,339474,339756,339745,339471,387054,265037,339577,339848,339666,339552,339665,339669,339767,339670,387066,339833,339698,339703,220171,339557,339544,339646,339651,339749,339824,339455,339628,339591,387052,339784,339549,339565,339673,339614,339789,339575,339662,265040,339595,339834,339853,339653,339658,339818,339626,339631,339717,339852,339559,339470,339545,339487,339542,339822,339579,339567,271697,339850)))"
    }
  }
}