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 (
    69657, 
    66613, 
    66677, 
    64871, 
    66508, 
    67004, 
    69641, 
    64895, 
    69766, 
    69574, 
    65454, 
    65777, 
    65893, 
    65160, 
    65063, 
    65831, 
    66637, 
    66500, 
    64975, 
    65822, 
    67836, 
    65540, 
    65721, 
    66086, 
    67788, 
    66150, 
    67812, 
    65801, 
    66708, 
    64634, 
    69789, 
    65970, 
    69701, 
    64872, 
    65979, 
    64815, 
    65040, 
    69693, 
    66246, 
    66380, 
    69220, 
    69195, 
    69244, 
    69228, 
    69813, 
    69725, 
    69624, 
    65508, 
    68371, 
    65103, 
    69333, 
    67203, 
    65500, 
    68387, 
    67252, 
    66492, 
    65953, 
    67235, 
    67926, 
    66676, 
    69757, 
    65087, 
    69749, 
    65023, 
    65390, 
    65319, 
    65809, 
    68714, 
    69829, 
    67155, 
    66656, 
    66420, 
    64692, 
    69268, 
    67872, 
    65302, 
    67283, 
    67028, 
    64535, 
    64751, 
    67828, 
    66629, 
    67396, 
    64543, 
    64855, 
    65961, 
    67953, 
    65479, 
    65785, 
    67123, 
    67107, 
    67853, 
    65463, 
    64651, 
    67339, 
    66598, 
    64807, 
    67804, 
    67091, 
    65713, 
    65492, 
    66302, 
    67299, 
    69869, 
    66254, 
    69566, 
    66580, 
    64676, 
    69550, 
    69349, 
    65564, 
    69292, 
    67251, 
    68135, 
    66564, 
    69400, 
    69741, 
    64511, 
    67267, 
    65745, 
    67764, 
    67934, 
    67115, 
    68411, 
    66310, 
    65358, 
    66532, 
    65143, 
    69781, 
    65934, 
    64935, 
    64567, 
    68866, 
    65271, 
    65334, 
    65793, 
    65471, 
    67388, 
    69861, 
    65422, 
    69616, 
    66657, 
    69341, 
    65516, 
    69590, 
    67888, 
    69733, 
    64735, 
    64919, 
    67748, 
    66190, 
    66198, 
    69236, 
    66436, 
    67163, 
    67380, 
    69558, 
    69373, 
    64959, 
    65367, 
    68331, 
    68781, 
    65532, 
    69316, 
    64700, 
    69276, 
    69357, 
    66460, 
    68339, 
    67347, 
    69365, 
    69845, 
    64727, 
    64791, 
    65769, 
    66094, 
    69717, 
    69709, 
    69821, 
    66372, 
    65697, 
    65729, 
    64527, 
    68355, 
    64660, 
    68181, 
    67372, 
    64783, 
    67219, 
    68403, 
    66428, 
    66262, 
    66476, 
    67331, 
    64519, 
    68478, 
    66078, 
    65263, 
    67044, 
    64775, 
    67796, 
    65524, 
    67880, 
    64551, 
    65207, 
    66356, 
    67756, 
    65199, 
    69284, 
    67099, 
    66444, 
    65151, 
    65279, 
    65572, 
    66540, 
    67012, 
    64743, 
    67307, 
    65159, 
    67315, 
    69381, 
    67147, 
    67275, 
    67060, 
    64863, 
    65015, 
    66158, 
    67227, 
    66405, 
    64831, 
    66206, 
    65031, 
    64847, 
    66988, 
    67131, 
    69853, 
    66102, 
    66222, 
    65239, 
    68363, 
    68395, 
    67179, 
    69260, 
    64839, 
    68626, 
    64642, 
    66980, 
    67052, 
    68938, 
    67291, 
    67243, 
    66524, 
    69649, 
    68161, 
    69773, 
    66700, 
    67404, 
    65120, 
    67364, 
    67076, 
    66445, 
    65978, 
    69837, 
    65548, 
    64823, 
    66278, 
    66316, 
    64999, 
    67918, 
    66126, 
    66348, 
    65007, 
    65111, 
    66230, 
    64708, 
    68379, 
    67068, 
    64576, 
    67171, 
    64759, 
    69633, 
    66270, 
    67187, 
    67772, 
    64936, 
    65556, 
    65366, 
    65064, 
    66166, 
    67323, 
    65039, 
    65342, 
    66110, 
    66182, 
    69084, 
    64668, 
    66142, 
    65310, 
    66996, 
    64991, 
    64799, 
    64903, 
    65247, 
    69805, 
    66597, 
    67211, 
    64559, 
    66317, 
    65095, 
    65318, 
    67820, 
    66294, 
    65382, 
    64927, 
    66516, 
    64767, 
    66484, 
    68090, 
    69308, 
    66134, 
    66238, 
    68072, 
    67139, 
    69300, 
    65055, 
    66332, 
    66118, 
    65406, 
    66556, 
    65737, 
    67355, 
    69582, 
    65135, 
    66396, 
    65842, 
    64719, 
    66692, 
    66727, 
    69203, 
    66468, 
    67020, 
    67036, 
    65231, 
    67195, 
    67780, 
    64887, 
    66548, 
    64911, 
    64976, 
    68323, 
    65223, 
    66340, 
    65398, 
    65119, 
    66357, 
    65183, 
    65350, 
    64684, 
    65407, 
    69252, 
    66174, 
    69389, 
    69211, 
    65753, 
    64951, 
    69598, 
    66404, 
    69009, 
    65175, 
    65856, 
    66388, 
    66621, 
    65255, 
    65215, 
    69187, 
    65191, 
    64967, 
    69324, 
    67363, 
    68347, 
    65430, 
    65079, 
    65287, 
    66572, 
    65705, 
    66279, 
    65761, 
    65580, 
    69606, 
    65446, 
    65438, 
    66214
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00252

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "274.41"
    },
    "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": 392,
      "rows_produced_per_join": 392,
      "filtered": "100.00",
      "index_condition": "((`chocoramo`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`chocoramo`.`cscart_product_review_prepared_data`.`product_id` in (69657,66613,66677,64871,66508,67004,69641,64895,69766,69574,65454,65777,65893,65160,65063,65831,66637,66500,64975,65822,67836,65540,65721,66086,67788,66150,67812,65801,66708,64634,69789,65970,69701,64872,65979,64815,65040,69693,66246,66380,69220,69195,69244,69228,69813,69725,69624,65508,68371,65103,69333,67203,65500,68387,67252,66492,65953,67235,67926,66676,69757,65087,69749,65023,65390,65319,65809,68714,69829,67155,66656,66420,64692,69268,67872,65302,67283,67028,64535,64751,67828,66629,67396,64543,64855,65961,67953,65479,65785,67123,67107,67853,65463,64651,67339,66598,64807,67804,67091,65713,65492,66302,67299,69869,66254,69566,66580,64676,69550,69349,65564,69292,67251,68135,66564,69400,69741,64511,67267,65745,67764,67934,67115,68411,66310,65358,66532,65143,69781,65934,64935,64567,68866,65271,65334,65793,65471,67388,69861,65422,69616,66657,69341,65516,69590,67888,69733,64735,64919,67748,66190,66198,69236,66436,67163,67380,69558,69373,64959,65367,68331,68781,65532,69316,64700,69276,69357,66460,68339,67347,69365,69845,64727,64791,65769,66094,69717,69709,69821,66372,65697,65729,64527,68355,64660,68181,67372,64783,67219,68403,66428,66262,66476,67331,64519,68478,66078,65263,67044,64775,67796,65524,67880,64551,65207,66356,67756,65199,69284,67099,66444,65151,65279,65572,66540,67012,64743,67307,65159,67315,69381,67147,67275,67060,64863,65015,66158,67227,66405,64831,66206,65031,64847,66988,67131,69853,66102,66222,65239,68363,68395,67179,69260,64839,68626,64642,66980,67052,68938,67291,67243,66524,69649,68161,69773,66700,67404,65120,67364,67076,66445,65978,69837,65548,64823,66278,66316,64999,67918,66126,66348,65007,65111,66230,64708,68379,67068,64576,67171,64759,69633,66270,67187,67772,64936,65556,65366,65064,66166,67323,65039,65342,66110,66182,69084,64668,66142,65310,66996,64991,64799,64903,65247,69805,66597,67211,64559,66317,65095,65318,67820,66294,65382,64927,66516,64767,66484,68090,69308,66134,66238,68072,67139,69300,65055,66332,66118,65406,66556,65737,67355,69582,65135,66396,65842,64719,66692,66727,69203,66468,67020,67036,65231,67195,67780,64887,66548,64911,64976,68323,65223,66340,65398,65119,66357,65183,65350,64684,65407,69252,66174,69389,69211,65753,64951,69598,66404,69009,65175,65856,66388,66621,65255,65215,69187,65191,64967,69324,67363,68347,65430,65079,65287,66572,65705,66279,65761,65580,69606,65446,65438,66214)))",
      "cost_info": {
        "read_cost": "235.21",
        "eval_cost": "39.20",
        "prefix_cost": "274.41",
        "data_read_per_join": "6K"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ]
    }
  }
}

Result

product_id average_rating reviews_count
64511 0
64519 0
64527 0
64535 0
64543 0
64551 0
64559 0
64567 0
64576 0
64634 0
64642 0
64651 0
64660 0
64668 0
64676 0
64684 0
64692 0
64700 0
64708 0
64719 0
64727 0
64735 0
64743 0
64751 0
64759 0
64767 0
64775 0
64783 0
64791 0
64799 0
64807 0
64815 0
64823 0
64831 0
64839 0
64847 0
64855 0
64863 0
64871 0
64872 0
64887 0
64895 0
64903 0
64911 0
64919 0
64927 0
64935 0
64936 0
64951 0
64959 0
64967 0
64975 0
64976 0
64991 0
64999 0
65007 0
65015 0
65023 0
65031 0
65039 0
65040 0
65055 0
65063 0
65064 0
65079 0
65087 0
65095 0
65103 0
65111 0
65119 0
65120 0
65135 0
65143 0
65151 0
65159 0
65160 0
65175 0
65183 0
65191 0
65199 0
65207 0
65215 0
65223 0
65231 0
65239 0
65247 0
65255 0
65263 0
65271 0
65279 0
65287 0
65302 0
65310 0
65318 0
65319 0
65334 0
65342 0
65350 0
65358 0
65366 0
65367 0
65382 0
65390 0
65398 0
65406 0
65407 0
65422 0
65430 0
65438 0
65446 0
65454 0
65463 0
65471 0
65479 0
65492 0
65500 0
65508 0
65516 0
65524 0
65532 0
65540 0
65548 0
65556 0
65564 0
65572 0
65580 0
65697 0
65705 0
65713 0
65721 0
65729 0
65737 0
65745 0
65753 0
65761 0
65769 0
65777 0
65785 0
65793 0
65801 0
65809 0
65822 0
65831 0
65842 0
65856 0
65893 0
65934 0
65953 0
65961 0
65970 0
65978 0
65979 0
66078 0
66086 0
66094 0
66102 0
66110 0
66118 0
66126 0
66134 0
66142 0
66150 0
66158 0
66166 0
66174 0
66182 0
66190 0
66198 0
66206 0
66214 0
66222 0
66230 0
66238 0
66246 0
66254 0
66262 0
66270 0
66278 0
66279 0
66294 0
66302 0
66310 0
66316 0
66317 0
66332 0
66340 0
66348 0
66356 0
66357 0
66372 0
66380 0
66388 0
66396 0
66404 0
66405 0
66420 0
66428 0
66436 0
66444 0
66445 0
66460 0
66468 0
66476 0
66484 0
66492 0
66500 0
66508 0
66516 0
66524 0
66532 0
66540 0
66548 0
66556 0
66564 0
66572 0
66580 0
66597 0
66598 0
66613 0
66621 0
66629 0
66637 0
66656 0
66657 0
66676 0
66677 0
66692 0
66700 0
66708 0
66727 0
66980 0
66988 0
66996 0
67004 0
67012 0
67020 0
67028 0
67036 0
67044 0
67052 0
67060 0
67068 0
67076 0
67091 0
67099 0
67107 0
67115 0
67123 0
67131 0
67139 0
67147 0
67155 0
67163 0
67171 0
67179 0
67187 0
67195 0
67203 0
67211 0
67219 0
67227 0
67235 0
67243 0
67251 0
67252 0
67267 0
67275 0
67283 0
67291 0
67299 0
67307 0
67315 0
67323 0
67331 0
67339 0
67347 0
67355 0
67364 0
67372 0
67380 0
67388 0
67396 0
67404 0
67748 0
67756 0
67764 0
67772 0
67780 0
67788 0
67796 0
67804 0
67812 0
67820 0
67828 0
67836 0
67853 0
67872 0
67880 0
67888 0
67918 0
67926 0
67934 0
67953 0
68072 0
68090 0
68135 0
68161 0
68181 0
68323 0
68331 0
68339 0
68347 0
68355 0
68363 0
68371 0
68379 0
68387 0
68395 0
68403 0
68411 0
68478 0
68626 0
68714 0
68781 0
68866 0
68938 0
69009 0
69084 0
69187 0
69195 0
69203 0
69211 0
69220 0
69228 0
69236 0
69244 0
69252 0
69260 0
69268 0
69276 0
69284 0
69292 0
69300 0
69308 0
69316 0
69324 0
69333 0
69341 0
69349 0
69357 0
69365 0
69373 0
69381 0
69389 0
69400 0
69550 0
69558 0
69566 0
69574 0
69582 0
69590 0
69598 0
69606 0
69616 0
69624 0
69633 0
69641 0
69649 0
69657 0
69693 0
69701 0
69709 0
69717 0
69725 0
69733 0
69741 0
69749 0
69757 0
69766 0
69773 0
69781 0
69789 0
69805 0
69813 0
69821 0
69829 0
69837 0
69845 0
69853 0
69861 0
69869 0