Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    10734, 
    10735, 
    10736, 
    10737, 
    10738, 
    10668, 
    10669, 
    10670, 
    10671, 
    10672, 
    10673, 
    10674, 
    10675, 
    10676, 
    10677, 
    10678, 
    10679, 
    10680, 
    10681, 
    10682, 
    10683, 
    10684, 
    10685, 
    10686, 
    10607, 
    10608, 
    10609, 
    10610, 
    10611, 
    10612, 
    10613, 
    10614, 
    10615, 
    10616, 
    10617, 
    10618, 
    10619, 
    10620, 
    10621, 
    10622, 
    10623, 
    10624, 
    9814, 
    9815, 
    9816, 
    9817, 
    9818, 
    15732, 
    9820, 
    9821, 
    9822, 
    9823, 
    9824, 
    9825, 
    9826, 
    9827, 
    9828, 
    9829, 
    9830, 
    10241, 
    10242, 
    10243, 
    10244, 
    10245, 
    10246, 
    10247, 
    10248, 
    10249, 
    10250, 
    10251, 
    10252, 
    10253, 
    10254, 
    10255, 
    10256, 
    10257, 
    10258, 
    10259, 
    10260, 
    10261, 
    10425, 
    10426, 
    10427, 
    10428, 
    10429, 
    10430, 
    10431, 
    10432, 
    10433, 
    10434, 
    10435, 
    10436, 
    10437, 
    10438, 
    10439, 
    10440, 
    10441, 
    10442, 
    10443, 
    10444, 
    10522, 
    9803, 
    9805, 
    9797, 
    9800, 
    9799, 
    9798, 
    9801, 
    9802, 
    9806, 
    9804, 
    9809, 
    9810, 
    9811, 
    9812, 
    9807, 
    9808, 
    9905, 
    10168, 
    10041, 
    10643, 
    10606, 
    10094, 
    10097, 
    12703, 
    10177, 
    10175, 
    9813
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00110

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 (10734,10735,10736,10737,10738,10668,10669,10670,10671,10672,10673,10674,10675,10676,10677,10678,10679,10680,10681,10682,10683,10684,10685,10686,10607,10608,10609,10610,10611,10612,10613,10614,10615,10616,10617,10618,10619,10620,10621,10622,10623,10624,9814,9815,9816,9817,9818,15732,9820,9821,9822,9823,9824,9825,9826,9827,9828,9829,9830,10241,10242,10243,10244,10245,10246,10247,10248,10249,10250,10251,10252,10253,10254,10255,10256,10257,10258,10259,10260,10261,10425,10426,10427,10428,10429,10430,10431,10432,10433,10434,10435,10436,10437,10438,10439,10440,10441,10442,10443,10444,10522,9803,9805,9797,9800,9799,9798,9801,9802,9806,9804,9809,9810,9811,9812,9807,9808,9905,10168,10041,10643,10606,10094,10097,12703,10177,10175,9813) and cscart_ab__video_gallery.`status` = 'A' and cscart_ab__video_gallery.storefront_id in (1,0)"
    }
  }
}