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, 
    148, 
    180, 
    187, 
    232, 
    230, 
    231, 
    18, 
    16, 
    4, 
    5, 
    23, 
    24, 
    170, 
    1, 
    22, 
    149, 
    227, 
    78, 
    79, 
    190, 
    189, 
    162, 
    159, 
    158, 
    245, 
    238, 
    239, 
    242, 
    243, 
    241, 
    240, 
    214, 
    217, 
    218, 
    207, 
    59, 
    58, 
    60, 
    199, 
    198, 
    94, 
    96, 
    201, 
    114, 
    192, 
    136, 
    130, 
    128, 
    126, 
    131, 
    177, 
    186, 
    185, 
    179, 
    11, 
    172, 
    134, 
    135, 
    195, 
    233, 
    168, 
    167, 
    169, 
    42, 
    39, 
    40, 
    205, 
    37, 
    152, 
    160, 
    74, 
    73, 
    71, 
    75, 
    72, 
    108, 
    237, 
    191, 
    235, 
    70, 
    122, 
    115, 
    156, 
    90, 
    175, 
    196, 
    43, 
    104, 
    76, 
    129, 
    127, 
    121, 
    103, 
    95, 
    182, 
    41, 
    56, 
    57, 
    30, 
    112, 
    246, 
    89, 
    197, 
    208, 
    173, 
    97, 
    229, 
    211, 
    210, 
    209, 
    67, 
    25, 
    116, 
    213, 
    215, 
    226, 
    200, 
    154, 
    53, 
    52, 
    111, 
    82, 
    84, 
    228, 
    85, 
    88, 
    26
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00068

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "11.60"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "ALL",
      "possible_keys": [
        "PRIMARY"
      ],
      "rows_examined_per_scan": 53,
      "rows_produced_per_join": 53,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "1.00",
        "eval_cost": "10.60",
        "prefix_cost": "11.60",
        "data_read_per_join": "848"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ],
      "attached_condition": "((`twebezli_Commercemodalpopup`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`twebezli_Commercemodalpopup`.`cscart_product_review_prepared_data`.`product_id` in (17,148,180,187,232,230,231,18,16,4,5,23,24,170,1,22,149,227,78,79,190,189,162,159,158,245,238,239,242,243,241,240,214,217,218,207,59,58,60,199,198,94,96,201,114,192,136,130,128,126,131,177,186,185,179,11,172,134,135,195,233,168,167,169,42,39,40,205,37,152,160,74,73,71,75,72,108,237,191,235,70,122,115,156,90,175,196,43,104,76,129,127,121,103,95,182,41,56,57,30,112,246,89,197,208,173,97,229,211,210,209,67,25,116,213,215,226,200,154,53,52,111,82,84,228,85,88,26)))"
    }
  }
}

Result

product_id average_rating reviews_count
1 4.00 3
5 3.67 3
23 3.00 1
78 4.00 1
148 4.33 3
149 4.67 3
167 5.00 1
172 4.00 1
228 3.00 2
238 4.00 1
239 3.00 1
241 5.00 3
242 3.50 2
245 4.67 3
246 5.00 3