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 (
    17, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 
    190, 189, 3438, 3439, 3440, 3441, 121590, 
    136148, 156245, 169350, 125861, 122330, 
    152282, 146567, 139654, 133778, 149640, 
    159133, 146242, 165619, 121896
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0274808,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_review_prepared_data",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "loops": 1,
          "rows": 102,
          "cost": 0.0274808,
          "filtered": 31.37254906,
          "attached_condition": "cscart_product_review_prepared_data.storefront_id = 0 and cscart_product_review_prepared_data.product_id in (17,180,18,16,4,5,23,24,1,22,149,190,189,3438,3439,3440,3441,121590,136148,156245,169350,125861,122330,152282,146567,139654,133778,149640,159133,146242,165619,121896)"
        }
      }
    ]
  }
}