Sandbox

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 (
    827, 840, 842, 889, 1085, 1100, 1106, 
    1150, 1201, 1212, 1216, 1226, 1242, 
    1253, 1309, 1434, 1436, 1462, 1514, 
    1570, 1618, 1851, 1969, 1979, 2036, 
    2046, 2047, 2063, 2165, 2185, 2315, 
    2345
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00052

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}