SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    10447, 10460, 10400, 10397, 10399, 10403, 
    10402, 10401, 10404, 10356, 10351, 
    10368, 10009, 10012, 10474, 10420, 
    10387, 10354, 10428, 10453, 10471, 
    10365, 10398, 10463, 10406, 10436, 
    10480, 10486, 10545, 10350, 10412, 
    10488, 10384, 10449, 10452, 10462, 
    10461, 10472, 10482, 10553, 10381, 
    10013, 10371, 10373, 10394, 10466, 
    10467, 10551, 10011, 10370, 10372, 
    10388, 10457, 10459, 10475, 10555, 
    10007, 10008, 10010, 10352, 10353, 
    10357, 10358, 10378, 10379, 10383, 
    10392, 10393, 10405, 10411, 10414, 
    10425, 10427, 10470, 10359, 10361, 
    10376, 10390, 10426, 10429
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00077

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "0.35"
    },
    "table": {
      "table_name": "cscart_ab__video_gallery",
      "access_type": "ref",
      "possible_keys": [
        "status",
        "product_id"
      ],
      "key": "status",
      "used_key_parts": [
        "status"
      ],
      "key_length": "3",
      "ref": [
        "const"
      ],
      "rows_examined_per_scan": 1,
      "rows_produced_per_join": 1,
      "filtered": "100.00",
      "cost_info": {
        "read_cost": "0.25",
        "eval_cost": "0.10",
        "prefix_cost": "0.35",
        "data_read_per_join": "96"
      },
      "used_columns": [
        "video_id",
        "product_id",
        "status",
        "storefront_id"
      ],
      "attached_condition": "((`softwarepirmam_hewadelivard_cscart_4`.`cscart_ab__video_gallery`.`product_id` in (10447,10460,10400,10397,10399,10403,10402,10401,10404,10356,10351,10368,10009,10012,10474,10420,10387,10354,10428,10453,10471,10365,10398,10463,10406,10436,10480,10486,10545,10350,10412,10488,10384,10449,10452,10462,10461,10472,10482,10553,10381,10013,10371,10373,10394,10466,10467,10551,10011,10370,10372,10388,10457,10459,10475,10555,10007,10008,10010,10352,10353,10357,10358,10378,10379,10383,10392,10393,10405,10411,10414,10425,10427,10470,10359,10361,10376,10390,10426,10429)) and (`softwarepirmam_hewadelivard_cscart_4`.`cscart_ab__video_gallery`.`storefront_id` in (1,0)))"
    }
  }
}