SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    4970, 4963, 4974, 4978, 4956, 4962, 4959, 
    12457, 11777, 12268, 12270, 12271, 
    12272, 12275, 12276, 12255, 12257, 
    12258, 12259, 12260, 12261, 12262, 
    12269, 12263, 12264, 12265, 12266, 
    12267, 12273, 12274
  ) 
  AND status = "A"

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "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": 1,
      "filtered": 100,
      "index_condition": "cscart_ab__video_gallery.`status` = 'A'",
      "attached_condition": "cscart_ab__video_gallery.product_id in (4970,4963,4974,4978,4956,4962,4959,12457,11777,12268,12270,12271,12272,12275,12276,12255,12257,12258,12259,12260,12261,12262,12269,12263,12264,12265,12266,12267,12273,12274)"
    }
  }
}