Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    15943, 
    15951, 
    15952, 
    15956, 
    15958, 
    15959, 
    15944, 
    15960, 
    15961, 
    15962, 
    15966, 
    15957, 
    15965, 
    15945, 
    15968, 
    15946, 
    15947, 
    15949, 
    15950, 
    12520, 
    12497, 
    12528, 
    12512, 
    12511, 
    12527, 
    10580, 
    10579, 
    9936, 
    9931, 
    12521, 
    12504, 
    12502, 
    12505, 
    13099, 
    12514, 
    12513, 
    9759, 
    10496, 
    10560, 
    10561, 
    10581, 
    10102, 
    9940, 
    10578, 
    10143, 
    9947, 
    10567, 
    10568, 
    10565, 
    9933, 
    12499, 
    12500, 
    10200, 
    10201, 
    10566, 
    10545, 
    10227, 
    10552, 
    12506, 
    10693, 
    12508, 
    9953, 
    12522, 
    12507, 
    12498, 
    13101, 
    13100, 
    10699, 
    10695, 
    10195, 
    10576, 
    10696, 
    9760, 
    10583, 
    10701, 
    10582, 
    10139, 
    12503, 
    10575, 
    9932, 
    10075, 
    10135, 
    9952, 
    10074, 
    10573, 
    10577, 
    10651, 
    10642, 
    12529, 
    12515, 
    12525, 
    12532, 
    12523, 
    10198, 
    10557, 
    10202, 
    10556, 
    10101, 
    10558, 
    10142, 
    10134, 
    10141, 
    10053, 
    10138, 
    10130, 
    9934, 
    10563, 
    10569, 
    10572, 
    10602, 
    10603, 
    10137, 
    12517, 
    12531, 
    12526, 
    12509, 
    10226, 
    10551, 
    10550, 
    10193, 
    10659, 
    10664, 
    10666, 
    10661, 
    10663, 
    10190, 
    10657, 
    10658
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00082

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 (15943,15951,15952,15956,15958,15959,15944,15960,15961,15962,15966,15957,15965,15945,15968,15946,15947,15949,15950,12520,12497,12528,12512,12511,12527,10580,10579,9936,9931,12521,12504,12502,12505,13099,12514,12513,9759,10496,10560,10561,10581,10102,9940,10578,10143,9947,10567,10568,10565,9933,12499,12500,10200,10201,10566,10545,10227,10552,12506,10693,12508,9953,12522,12507,12498,13101,13100,10699,10695,10195,10576,10696,9760,10583,10701,10582,10139,12503,10575,9932,10075,10135,9952,10074,10573,10577,10651,10642,12529,12515,12525,12532,12523,10198,10557,10202,10556,10101,10558,10142,10134,10141,10053,10138,10130,9934,10563,10569,10572,10602,10603,10137,12517,12531,12526,12509,10226,10551,10550,10193,10659,10664,10666,10661,10663,10190,10657,10658) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}