SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    5094, 5075, 5074, 5068, 5350, 5082, 4708, 
    4707, 4706, 4652, 4627, 4628, 4651, 
    4677, 4679, 4678, 5070, 4344, 5071, 
    19544, 5347, 4637, 4671, 4638
  ) 
  AND status = "A"

Query time 0.00031

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 (5094,5075,5074,5068,5350,5082,4708,4707,4706,4652,4627,4628,4651,4677,4679,4678,5070,4344,5071,19544,5347,4637,4671,4638)"
    }
  }
}