SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    11310, 10203, 9836, 10204, 10899, 6833, 
    10465, 9603, 9235, 9164, 11308, 11312, 
    22273, 13179, 8735, 9055, 21533, 22369, 
    12135, 12130, 7340, 12133, 7008, 7765
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00057

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 (11310,10203,9836,10204,10899,6833,10465,9603,9235,9164,11308,11312,22273,13179,8735,9055,21533,22369,12135,12130,7340,12133,7008,7765) and cscart_ab__video_gallery.storefront_id in (1,0)"
        }
      }
    ]
  }
}