SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    6730, 7172, 6924, 7084, 6814, 6683, 7411, 
    6684, 6685, 6686, 6687, 6688, 6689, 
    6690, 6693, 11052, 6694, 6912, 6691, 
    6913, 6682, 6695, 6696, 11104, 6692, 
    8688, 6697, 8000, 6698, 6699, 6700, 
    6701, 6702, 6703, 6704, 6705, 6707, 
    6708, 6709, 6710, 6714, 6706, 6716, 
    6717, 6718, 6715, 6719, 6720, 6721, 
    6711, 6723, 6722, 6724, 6712, 6725, 
    6726, 6727, 6728, 6729, 6731, 6732, 
    8742, 6733, 6734, 6735, 6736, 6713, 
    6737, 6738, 6739, 6740, 6741, 6742, 
    6748, 8801, 8802, 11103, 6744, 6745, 
    6746, 6747, 10992, 6749, 6750, 8743, 
    6751, 6752, 6753, 6754, 6755, 6756, 
    6757, 6758, 6759, 6760, 6915, 6916, 
    6761, 6762, 11378
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00062

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_ab__video_gallery",
          "access_type": "ref",
          "possible_keys": ["status", "product_id"],
          "key": "status",
          "key_length": "3",
          "used_key_parts": ["status"],
          "ref": ["const"],
          "rows": 2,
          "filtered": 100,
          "index_condition": "cscart_ab__video_gallery.`status` = 'A'",
          "attached_condition": "cscart_ab__video_gallery.product_id in (6730,7172,6924,7084,6814,6683,7411,6684,6685,6686,6687,6688,6689,6690,6693,11052,6694,6912,6691,6913,6682,6695,6696,11104,6692,8688,6697,8000,6698,6699,6700,6701,6702,6703,6704,6705,6707,6708,6709,6710,6714,6706,6716,6717,6718,6715,6719,6720,6721,6711,6723,6722,6724,6712,6725,6726,6727,6728,6729,6731,6732,8742,6733,6734,6735,6736,6713,6737,6738,6739,6740,6741,6742,6748,8801,8802,11103,6744,6745,6746,6747,10992,6749,6750,8743,6751,6752,6753,6754,6755,6756,6757,6758,6759,6760,6915,6916,6761,6762,11378) and cscart_ab__video_gallery.storefront_id in (1,0)"
        }
      }
    ]
  }
}