Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    13018, 
    13017, 
    13016, 
    13015, 
    13014, 
    13013, 
    13012, 
    13011, 
    13010, 
    13009, 
    13008, 
    13007, 
    13006, 
    13005, 
    13004, 
    13003, 
    13002, 
    13001, 
    13000, 
    12999, 
    10812, 
    10811, 
    10810, 
    10809, 
    10808, 
    10807, 
    10806, 
    10805, 
    10804, 
    10803, 
    10802, 
    10801, 
    10800, 
    10799, 
    10798, 
    10797, 
    10796, 
    10795, 
    10794, 
    10793, 
    10792, 
    10791, 
    10790, 
    10789, 
    10788, 
    10787, 
    10786, 
    10785, 
    10784, 
    10783, 
    10782, 
    10781, 
    10780, 
    10779, 
    10778, 
    10777, 
    10776, 
    10775, 
    10774, 
    10773, 
    10772, 
    10771, 
    10770, 
    10769, 
    10768, 
    10767, 
    10766, 
    10765, 
    10764, 
    10763, 
    10762, 
    10761, 
    10760, 
    10759, 
    10758, 
    10757, 
    10756, 
    10755, 
    10754, 
    10753, 
    10752, 
    10751, 
    10750, 
    10749, 
    10748, 
    10747, 
    15736, 
    15737, 
    15738, 
    15739, 
    15740, 
    15741, 
    15742, 
    15743, 
    15745, 
    15746, 
    15744, 
    12632, 
    12633, 
    10179, 
    10180, 
    10523, 
    10073, 
    10077, 
    10076, 
    10086, 
    10085, 
    10084, 
    10083, 
    10082, 
    10081, 
    10080, 
    10079, 
    10584, 
    10594, 
    12574, 
    10168, 
    10167, 
    12703, 
    15968, 
    15938, 
    10053, 
    10041, 
    9904, 
    9905, 
    15966, 
    15965, 
    9940
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00118

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 (13018,13017,13016,13015,13014,13013,13012,13011,13010,13009,13008,13007,13006,13005,13004,13003,13002,13001,13000,12999,10812,10811,10810,10809,10808,10807,10806,10805,10804,10803,10802,10801,10800,10799,10798,10797,10796,10795,10794,10793,10792,10791,10790,10789,10788,10787,10786,10785,10784,10783,10782,10781,10780,10779,10778,10777,10776,10775,10774,10773,10772,10771,10770,10769,10768,10767,10766,10765,10764,10763,10762,10761,10760,10759,10758,10757,10756,10755,10754,10753,10752,10751,10750,10749,10748,10747,15736,15737,15738,15739,15740,15741,15742,15743,15745,15746,15744,12632,12633,10179,10180,10523,10073,10077,10076,10086,10085,10084,10083,10082,10081,10080,10079,10584,10594,12574,10168,10167,12703,15968,15938,10053,10041,9904,9905,15966,15965,9940) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}

Result

video_id	product_id
74	10179
75	10180
76	10523
77	10076
78	10073
79	10077
80	10085
81	10082
82	10086
83	10083
84	10084
85	10584
86	10081
87	10594
88	10079
89	10080
90	15744
91	15737
92	15746
93	15745
94	15739
95	15743
96	15740
97	15741
98	15738
99	15742
100	15736