Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    13101, 
    12498, 
    12496, 
    12510, 
    12519, 
    12516, 
    12530, 
    12526, 
    12531, 
    12509, 
    12517, 
    12523, 
    12532, 
    12525, 
    12515, 
    12529, 
    12503, 
    13100, 
    12507, 
    12522, 
    12508, 
    12506, 
    12500, 
    12499, 
    12513, 
    12514, 
    13099, 
    12521, 
    12527, 
    12511, 
    12512, 
    12528, 
    12520, 
    12497, 
    12505, 
    12502, 
    12504, 
    10847, 
    13152, 
    10846, 
    10845, 
    10844, 
    10843, 
    10842, 
    10841, 
    10840, 
    10839, 
    10838, 
    10837, 
    10836, 
    10835, 
    10834, 
    10833, 
    10832, 
    10831, 
    10830, 
    10829, 
    10828, 
    10827, 
    12642, 
    12648, 
    12651, 
    12645, 
    12644, 
    12650, 
    12649, 
    12643, 
    12640, 
    12647, 
    15800, 
    12639, 
    12641, 
    12638, 
    12637, 
    12634, 
    12635, 
    12636, 
    12654, 
    12653, 
    12652, 
    12656, 
    12655, 
    12646, 
    12631, 
    12998, 
    12997, 
    12996, 
    12995, 
    10826, 
    10825, 
    10824, 
    10823, 
    10822, 
    10821, 
    10820, 
    10819, 
    10818, 
    10817, 
    10816, 
    10815, 
    10814, 
    10813, 
    13044, 
    13043, 
    13042, 
    13041, 
    13040, 
    13039, 
    13038, 
    13037, 
    13036, 
    13035, 
    13034, 
    13033, 
    13032, 
    13031, 
    13030, 
    13029, 
    13028, 
    13027, 
    13026, 
    13025, 
    13024, 
    13023, 
    13022, 
    13021, 
    13020, 
    13019
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00073

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": 100,
      "attached_condition": "cscart_ab__video_gallery.product_id in (13101,12498,12496,12510,12519,12516,12530,12526,12531,12509,12517,12523,12532,12525,12515,12529,12503,13100,12507,12522,12508,12506,12500,12499,12513,12514,13099,12521,12527,12511,12512,12528,12520,12497,12505,12502,12504,10847,13152,10846,10845,10844,10843,10842,10841,10840,10839,10838,10837,10836,10835,10834,10833,10832,10831,10830,10829,10828,10827,12642,12648,12651,12645,12644,12650,12649,12643,12640,12647,15800,12639,12641,12638,12637,12634,12635,12636,12654,12653,12652,12656,12655,12646,12631,12998,12997,12996,12995,10826,10825,10824,10823,10822,10821,10820,10819,10818,10817,10816,10815,10814,10813,13044,13043,13042,13041,13040,13039,13038,13037,13036,13035,13034,13033,13032,13031,13030,13029,13028,13027,13026,13025,13024,13023,13022,13021,13020,13019) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}

Result

video_id	product_id
137	10813
139	10818
140	10817
141	10822
142	10814
143	10823
145	10816
146	10825
147	10826
148	10815
149	10820
150	10819
151	10821
153	10824