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 (
    4890, 8761, 9563, 9564, 9565, 9566, 9567, 
    9568, 9569, 9570, 9571, 9572, 9573, 
    9574, 9575, 9576, 9577, 9578, 9579, 
    9580, 9581, 9582, 9583, 9584, 9585, 
    9586, 9587, 9588, 9589, 9590, 9591, 
    9592, 9593, 9594, 9595, 9596, 9597, 
    9598, 9599, 9600, 9601, 9602, 9603, 
    9604, 9605, 9606, 9607, 9608, 9609, 
    9610, 9611, 9612, 9613, 9614, 9615, 
    9616, 9617, 9618, 9619, 9620, 9621, 
    9622, 9623, 9624, 9625, 9626, 9627, 
    9628, 9629, 9630, 9631, 9632, 9633, 
    9634, 9635, 9636, 9637, 9638, 9639, 
    9640, 9641, 10049, 10050, 10051, 10052, 
    10053, 10054, 10055, 10056, 10057, 
    10058, 10059, 10060, 10061, 10062, 
    10063
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00031

JSON explain

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