SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    10511, 10510, 10509, 10508, 10507, 10506, 
    10505, 10504, 10503, 10502, 10501, 
    10500, 10499, 10498, 10497, 9839, 12702, 
    9841, 9848, 9840
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00046

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_ab__video_gallery",
      "access_type": "ALL",
      "possible_keys": ["status", "product_id"],
      "rows": 77,
      "filtered": 25.97402573,
      "attached_condition": "cscart_ab__video_gallery.product_id in (10511,10510,10509,10508,10507,10506,10505,10504,10503,10502,10501,10500,10499,10498,10497,9839,12702,9841,9848,9840) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}

Result

video_id product_id
114 10511
115 10510
117 10509
118 10508
119 10506
120 10505
121 10504
122 10500
123 10501
125 10498
126 10507
127 10502
128 10497
129 10499
130 10503