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 (
    7351, 
    7347, 
    7402, 
    7357, 
    7295, 
    7293, 
    7353, 
    7286, 
    7378, 
    7383, 
    7329, 
    7324, 
    7310, 
    7300, 
    7360, 
    7352, 
    7390, 
    7355, 
    7289, 
    7637, 
    7322, 
    7399, 
    7325, 
    7327, 
    7294, 
    7376, 
    7284, 
    7366, 
    7400, 
    7339, 
    7367, 
    7321, 
    7398, 
    7362, 
    7381, 
    7285, 
    7375, 
    7404, 
    7391, 
    7369, 
    7371, 
    7298, 
    7349, 
    7401, 
    7345, 
    7308, 
    7317, 
    7384, 
    7307, 
    7297, 
    7389, 
    7361, 
    7312, 
    7341, 
    7385, 
    7301, 
    7320, 
    7342, 
    7387, 
    7377, 
    7305, 
    7335, 
    7356, 
    7414, 
    7374, 
    7463, 
    7382, 
    7309, 
    7332, 
    7443, 
    7393, 
    7397, 
    7350, 
    7303, 
    7372, 
    7388, 
    7624, 
    7598, 
    7441, 
    7653, 
    7336, 
    7330, 
    7470, 
    7512, 
    7442, 
    7407, 
    7487, 
    7482, 
    7368, 
    7316, 
    7318, 
    7408, 
    7490, 
    7405, 
    7358, 
    7413, 
    7344, 
    7432, 
    7423, 
    7299, 
    7396, 
    7343, 
    7333, 
    7416, 
    7370, 
    7525, 
    7334, 
    7380, 
    7450, 
    7306, 
    7292, 
    7439, 
    7337, 
    7323, 
    7508, 
    7326, 
    7363, 
    7444, 
    7418, 
    7451, 
    7526, 
    7455, 
    7340, 
    7498, 
    7395, 
    7489, 
    7424, 
    7538, 
    7445, 
    7519, 
    7465, 
    7534, 
    7469, 
    7514, 
    7436, 
    7475, 
    7503, 
    7518, 
    7379, 
    7406, 
    7515, 
    7338, 
    7464, 
    7471, 
    7426, 
    7433, 
    57894, 
    27754, 
    7403, 
    7447, 
    7581, 
    7348, 
    7457, 
    7570, 
    7373, 
    7532, 
    7520, 
    7328, 
    7430, 
    7507, 
    7548, 
    7431, 
    7425, 
    7630, 
    7446, 
    7427, 
    7497, 
    7591, 
    7419, 
    7494, 
    7501, 
    7651, 
    7495, 
    7364, 
    7453, 
    7354, 
    7410, 
    7505, 
    7448, 
    7540, 
    7554, 
    7516, 
    7467, 
    7319, 
    7504, 
    7510, 
    7524, 
    7579, 
    7331, 
    7304, 
    7359, 
    7477, 
    7473, 
    7484, 
    7549, 
    7648, 
    7597, 
    7513, 
    7492, 
    7428, 
    7522, 
    7311, 
    7434, 
    7523, 
    7608, 
    7485, 
    7449, 
    7506, 
    7542, 
    7417, 
    7627, 
    7527, 
    7537, 
    7511, 
    7456, 
    7458, 
    7493, 
    7544, 
    7562, 
    7566, 
    7461, 
    7476, 
    7496, 
    7571, 
    7420, 
    7472, 
    7435, 
    7486, 
    7543, 
    7558, 
    7575, 
    7587, 
    7631, 
    7645, 
    7452, 
    7491, 
    7553, 
    7480, 
    7574, 
    70256, 
    7605, 
    70303, 
    70305, 
    7578, 
    70306, 
    71347
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "172.21"
    },
    "table": {
      "table_name": "cscart_product_review_prepared_data",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "storefront_id"
      ],
      "key_length": "7",
      "rows_examined_per_scan": 246,
      "rows_produced_per_join": 246,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`cscartdb`.`cscart_product_review_prepared_data`.`product_id` in (7351,7347,7402,7357,7295,7293,7353,7286,7378,7383,7329,7324,7310,7300,7360,7352,7390,7355,7289,7637,7322,7399,7325,7327,7294,7376,7284,7366,7400,7339,7367,7321,7398,7362,7381,7285,7375,7404,7391,7369,7371,7298,7349,7401,7345,7308,7317,7384,7307,7297,7389,7361,7312,7341,7385,7301,7320,7342,7387,7377,7305,7335,7356,7414,7374,7463,7382,7309,7332,7443,7393,7397,7350,7303,7372,7388,7624,7598,7441,7653,7336,7330,7470,7512,7442,7407,7487,7482,7368,7316,7318,7408,7490,7405,7358,7413,7344,7432,7423,7299,7396,7343,7333,7416,7370,7525,7334,7380,7450,7306,7292,7439,7337,7323,7508,7326,7363,7444,7418,7451,7526,7455,7340,7498,7395,7489,7424,7538,7445,7519,7465,7534,7469,7514,7436,7475,7503,7518,7379,7406,7515,7338,7464,7471,7426,7433,57894,27754,7403,7447,7581,7348,7457,7570,7373,7532,7520,7328,7430,7507,7548,7431,7425,7630,7446,7427,7497,7591,7419,7494,7501,7651,7495,7364,7453,7354,7410,7505,7448,7540,7554,7516,7467,7319,7504,7510,7524,7579,7331,7304,7359,7477,7473,7484,7549,7648,7597,7513,7492,7428,7522,7311,7434,7523,7608,7485,7449,7506,7542,7417,7627,7527,7537,7511,7456,7458,7493,7544,7562,7566,7461,7476,7496,7571,7420,7472,7435,7486,7543,7558,7575,7587,7631,7645,7452,7491,7553,7480,7574,70256,7605,70303,70305,7578,70306,71347)))",
      "cost_info": {
        "read_cost": "147.61",
        "eval_cost": "24.60",
        "prefix_cost": "172.21",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ]
    }
  }
}

Result

product_id average_rating reviews_count
7286 0
7289 0
7292 0
7299 0
7304 0
7306 0
7318 0
7322 0
7325 0
7326 0
7328 0
7333 0
7340 0
7344 0
7350 0
7355 0
7356 0
7364 0
7367 0
7368 0
7370 0
7372 0
7374 0
7383 0
7385 0
7388 0
7403 0
7408 0
7414 0
7423 0
7424 0
7427 0
7432 0
7433 0
7436 0
7447 0
7448 0
7451 0
7463 0
7464 0
7467 0
7469 0
7470 0
7471 0
7475 0
7515 0
7520 0
7532 0
7540 0
7570 0
7581 0
7597 0
7598 0
7627 0
7651 0
27754 0
57894 0
70256 0