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 (
    32019, 
    32119, 
    32177, 
    32142, 
    32153, 
    32036, 
    32195, 
    32199, 
    32164, 
    32121, 
    32257, 
    32116, 
    32127, 
    32002, 
    32151, 
    32000, 
    32175, 
    32230, 
    32176, 
    31951, 
    32236, 
    32220, 
    31974, 
    32173, 
    32024, 
    32251, 
    32135, 
    32183, 
    31954, 
    32137, 
    32004, 
    32240, 
    31985, 
    32034, 
    32191, 
    32005, 
    32238, 
    32250, 
    32088, 
    31934, 
    32237, 
    32032, 
    32201, 
    32197, 
    32033, 
    32131, 
    32009, 
    32185, 
    32204, 
    32027, 
    32294, 
    31984, 
    32120, 
    32205, 
    32182, 
    32155, 
    32156, 
    31927, 
    32110, 
    32208, 
    31944, 
    31950, 
    31962, 
    32087, 
    32228, 
    31976, 
    32162, 
    32161, 
    32295, 
    32262, 
    32165, 
    32192, 
    32108, 
    32296, 
    32303, 
    31948, 
    32130, 
    32020, 
    32150, 
    32167, 
    31981, 
    32022, 
    32030, 
    32041, 
    32227, 
    31983, 
    31940, 
    32293, 
    32095, 
    31994, 
    32255, 
    32082, 
    32217, 
    31972, 
    32169, 
    32070, 
    31942, 
    32073, 
    32013, 
    31953, 
    31971, 
    32076, 
    32099, 
    32122, 
    31932, 
    31957, 
    32168, 
    32180, 
    31959, 
    32016, 
    32212, 
    32051, 
    32247, 
    31947, 
    31931, 
    32113, 
    32149, 
    31928, 
    32198, 
    32049, 
    32299, 
    32145, 
    31930, 
    32279, 
    32297, 
    31977, 
    32112, 
    31929, 
    31961, 
    32174, 
    32301, 
    32115, 
    32055, 
    32053, 
    32179, 
    32181, 
    31926, 
    31992, 
    32071, 
    32081, 
    32097, 
    31956, 
    31975, 
    32042, 
    32152, 
    32235, 
    32011, 
    32107, 
    32109, 
    32264, 
    31941, 
    31964, 
    31966, 
    31970, 
    31982, 
    31986, 
    31999, 
    32023, 
    32038, 
    32047, 
    32050, 
    32080, 
    32083, 
    32084, 
    32093, 
    32100, 
    32114, 
    32124, 
    32190, 
    32219, 
    32252, 
    32218, 
    31922, 
    31923, 
    31924, 
    31936, 
    31938, 
    31939, 
    31955, 
    31969, 
    31989, 
    31998, 
    32015, 
    32018, 
    32025, 
    32029, 
    32039, 
    32040, 
    32056, 
    32057, 
    32063, 
    32065, 
    32072, 
    32074, 
    32079, 
    32090, 
    32091, 
    32094, 
    32096, 
    32103, 
    32126, 
    32143, 
    32147, 
    32160, 
    32186, 
    32203, 
    32221, 
    32223, 
    32232, 
    32234, 
    32243, 
    32246, 
    32258, 
    32263, 
    31925, 
    31933, 
    31949, 
    31963, 
    31965, 
    31968, 
    31973, 
    31979, 
    31997, 
    32007, 
    32008, 
    32021, 
    32048, 
    32052, 
    32058, 
    32059, 
    32062, 
    32064, 
    32066, 
    32067, 
    32068, 
    32075, 
    32077, 
    32078, 
    32085, 
    32089, 
    32092, 
    32101, 
    32104, 
    32106, 
    32111, 
    32118, 
    32123, 
    32134, 
    32141, 
    32194, 
    32200, 
    32207, 
    32209, 
    32210, 
    32211, 
    32215, 
    32224, 
    32225, 
    32229, 
    32242, 
    32253, 
    31921, 
    31937, 
    31952, 
    32001, 
    32014, 
    32069, 
    32086, 
    32102, 
    32105, 
    32128, 
    32132, 
    32154, 
    32184, 
    32213, 
    32239, 
    32244, 
    32292, 
    31990, 
    31991, 
    31996, 
    32054, 
    32117, 
    32133, 
    32226, 
    32163, 
    32010
  ) 
  AND cscart_product_review_prepared_data.storefront_id = 0

Query time 0.00150

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "200.91"
    },
    "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": 287,
      "rows_produced_per_join": 287,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_review_prepared_data`.`storefront_id` = 0) and (`cscartdb`.`cscart_product_review_prepared_data`.`product_id` in (32019,32119,32177,32142,32153,32036,32195,32199,32164,32121,32257,32116,32127,32002,32151,32000,32175,32230,32176,31951,32236,32220,31974,32173,32024,32251,32135,32183,31954,32137,32004,32240,31985,32034,32191,32005,32238,32250,32088,31934,32237,32032,32201,32197,32033,32131,32009,32185,32204,32027,32294,31984,32120,32205,32182,32155,32156,31927,32110,32208,31944,31950,31962,32087,32228,31976,32162,32161,32295,32262,32165,32192,32108,32296,32303,31948,32130,32020,32150,32167,31981,32022,32030,32041,32227,31983,31940,32293,32095,31994,32255,32082,32217,31972,32169,32070,31942,32073,32013,31953,31971,32076,32099,32122,31932,31957,32168,32180,31959,32016,32212,32051,32247,31947,31931,32113,32149,31928,32198,32049,32299,32145,31930,32279,32297,31977,32112,31929,31961,32174,32301,32115,32055,32053,32179,32181,31926,31992,32071,32081,32097,31956,31975,32042,32152,32235,32011,32107,32109,32264,31941,31964,31966,31970,31982,31986,31999,32023,32038,32047,32050,32080,32083,32084,32093,32100,32114,32124,32190,32219,32252,32218,31922,31923,31924,31936,31938,31939,31955,31969,31989,31998,32015,32018,32025,32029,32039,32040,32056,32057,32063,32065,32072,32074,32079,32090,32091,32094,32096,32103,32126,32143,32147,32160,32186,32203,32221,32223,32232,32234,32243,32246,32258,32263,31925,31933,31949,31963,31965,31968,31973,31979,31997,32007,32008,32021,32048,32052,32058,32059,32062,32064,32066,32067,32068,32075,32077,32078,32085,32089,32092,32101,32104,32106,32111,32118,32123,32134,32141,32194,32200,32207,32209,32210,32211,32215,32224,32225,32229,32242,32253,31921,31937,31952,32001,32014,32069,32086,32102,32105,32128,32132,32154,32184,32213,32239,32244,32292,31990,31991,31996,32054,32117,32133,32226,32163,32010)))",
      "cost_info": {
        "read_cost": "172.21",
        "eval_cost": "28.70",
        "prefix_cost": "200.91",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "product_id",
        "storefront_id",
        "average_rating",
        "reviews_count"
      ]
    }
  }
}

Result

product_id average_rating reviews_count
31921 0
31927 0
31934 0
31940 0
31942 0
31950 0
31956 0
31962 0
31971 0
31975 0
31977 0
31981 0
31983 0
31984 0
31985 0
31992 0
31994 0
32000 0
32002 0
32007 0
32009 0
32022 0
32024 0
32030 0
32032 0
32033 0
32041 0
32053 0
32070 0
32071 0
32075 0
32076 0
32079 0
32081 0
32082 0
32087 0
32088 0
32095 0
32097 0
32099 0
32107 0
32112 0
32113 0
32120 0
32149 0
32152 0
32155 0
32165 0
32175 0
32179 0
32180 0
32181 0
32186 0
32191 0
32192 0
32201 0
32204 0
32205 0
32208 0
32213 0
32219 0
32227 0
32228 0
32232 0
32235 0
32238 0
32243 0
32244 0
32255 0
32294 0