SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    2788, 2612, 15385, 2608, 2609, 2561, 
    2610, 2611, 2571, 2317, 2318, 12754, 
    11610, 11606, 11818, 11607, 11608, 
    14076, 14077, 11135, 12977, 12677, 
    12654, 2763
  ) 
  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 (2788,2612,15385,2608,2609,2561,2610,2611,2571,2317,2318,12754,11610,11606,11818,11607,11608,14076,14077,11135,12977,12677,12654,2763)"
    }
  }
}