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 (
    1825, 1826, 1827, 1828, 1829, 1830, 1831, 
    1300, 1301, 1302, 1304, 1303, 1812, 
    1808, 1807, 1813, 1836, 1860, 1861, 
    1837, 1851, 1853, 1838, 1839
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.0149298,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_review_prepared_data",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "loops": 1,
          "rows": 25,
          "cost": 0.0149298,
          "filtered": 96,
          "attached_condition": "cscart_product_review_prepared_data.storefront_id = 0 and cscart_product_review_prepared_data.product_id in (1825,1826,1827,1828,1829,1830,1831,1300,1301,1302,1304,1303,1812,1808,1807,1813,1836,1860,1861,1837,1851,1853,1838,1839)"
        }
      }
    ]
  }
}