Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    10102, 
    10643, 
    10178, 
    10177, 
    10606, 
    10644, 
    10101, 
    10175, 
    10100, 
    15962, 
    15961, 
    15960, 
    15959, 
    10094, 
    10093, 
    9813, 
    10097, 
    9760, 
    9759, 
    9934, 
    9933, 
    9932, 
    9931, 
    9936, 
    9947, 
    9953, 
    9952, 
    10074, 
    10096, 
    10075, 
    10602, 
    10087, 
    10130, 
    10603, 
    10135, 
    10134, 
    10139, 
    10138, 
    10137, 
    10141, 
    10143, 
    10142, 
    12628, 
    12627, 
    12629, 
    10095, 
    10195, 
    10194, 
    10193, 
    10190, 
    10496, 
    10198, 
    10202, 
    10201, 
    10200, 
    10227, 
    10226, 
    10651, 
    9945, 
    10642, 
    10601, 
    9727, 
    9728, 
    9729, 
    9730, 
    9731, 
    9732, 
    9733, 
    10181, 
    9734, 
    9735, 
    9724, 
    10655, 
    10654, 
    10605, 
    10604, 
    9873, 
    10653, 
    10646, 
    10645, 
    10647, 
    10648, 
    10649, 
    10726, 
    10650, 
    9789, 
    10547, 
    9796, 
    9874, 
    9875, 
    9879, 
    9887, 
    9941, 
    9942, 
    9943, 
    9944, 
    10744, 
    10745, 
    10746, 
    10739, 
    10740, 
    10741, 
    10742, 
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10688, 
    10727, 
    10728, 
    10729, 
    10730, 
    10731, 
    10732, 
    10733, 
    10713, 
    10714, 
    10715, 
    10716, 
    10717, 
    10718, 
    10719, 
    10720, 
    10721, 
    10722, 
    10723, 
    10704
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00092

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ab__video_gallery",
      "access_type": "ALL",
      "possible_keys": ["status", "product_id"],
      "rows": 77,
      "filtered": 100,
      "attached_condition": "cscart_ab__video_gallery.product_id in (10102,10643,10178,10177,10606,10644,10101,10175,10100,15962,15961,15960,15959,10094,10093,9813,10097,9760,9759,9934,9933,9932,9931,9936,9947,9953,9952,10074,10096,10075,10602,10087,10130,10603,10135,10134,10139,10138,10137,10141,10143,10142,12628,12627,12629,10095,10195,10194,10193,10190,10496,10198,10202,10201,10200,10227,10226,10651,9945,10642,10601,9727,9728,9729,9730,9731,9732,9733,10181,9734,9735,9724,10655,10654,10605,10604,9873,10653,10646,10645,10647,10648,10649,10726,10650,9789,10547,9796,9874,9875,9879,9887,9941,9942,9943,9944,10744,10745,10746,10739,10740,10741,10742,10734,10735,10736,10737,10738,10688,10727,10728,10729,10730,10731,10732,10733,10713,10714,10715,10716,10717,10718,10719,10720,10721,10722,10723,10704) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}

Result

video_id	product_id
131	9875
132	9887
133	9879
134	9942
135	9796
136	9941
138	9943
144	9874
152	9944