SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    592, 593, 827, 828, 829, 830, 831, 832, 
    833, 834, 835, 837, 838, 839, 840, 841, 
    842, 843, 844, 845, 846, 847, 848, 849, 
    850, 851, 852, 853, 854, 855, 856, 857, 
    858, 859, 860, 861, 862, 863, 864, 865, 
    866, 867, 868, 869, 870, 871, 872, 873, 
    874, 875, 876, 877, 878
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00036

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.20"
    },
    "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": "1.00",
        "eval_cost": "0.20",
        "prefix_cost": "1.20",
        "data_read_per_join": "96"
      },
      "used_columns": [
        "video_id",
        "product_id",
        "status",
        "storefront_id"
      ],
      "attached_condition": "((`cscart`.`cscart_ab__video_gallery`.`product_id` in (592,593,827,828,829,830,831,832,833,834,835,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878)) and (`cscart`.`cscart_ab__video_gallery`.`storefront_id` in (1,0)))"
    }
  }
}