Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    7172, 
    6924, 
    6730, 
    6705, 
    10992, 
    6710, 
    6804, 
    6914, 
    6757, 
    6742, 
    8000, 
    6696, 
    6787, 
    6770, 
    6727, 
    6912, 
    11378, 
    6773, 
    6739, 
    6704, 
    10778, 
    6708, 
    6803, 
    6809, 
    6756, 
    6741, 
    7914, 
    6693, 
    6786, 
    6767, 
    6726, 
    6913, 
    11211, 
    6774, 
    6735, 
    6703, 
    10640, 
    6709, 
    6800, 
    6807, 
    6753, 
    6738, 
    7411, 
    6692, 
    6785, 
    6766, 
    6725, 
    6814, 
    8865, 
    6772, 
    6733, 
    6695, 
    10246, 
    6707, 
    6799, 
    6802, 
    6752, 
    6737, 
    6690, 
    6784, 
    6764, 
    6723, 
    6813, 
    8742, 
    6771, 
    6724, 
    6694, 
    10195, 
    6706, 
    6797, 
    6801, 
    6750, 
    6736, 
    7084, 
    6689, 
    6782, 
    6763, 
    6722, 
    6812, 
    8743, 
    6768, 
    6720, 
    6691, 
    9495, 
    6702, 
    6798, 
    6793, 
    6749, 
    6734, 
    6921, 
    6688, 
    6781, 
    6759, 
    11375, 
    6721, 
    6811, 
    8680, 
    6765, 
    6718, 
    6682, 
    8802, 
    6700, 
    6796, 
    6791, 
    6748, 
    6732, 
    6923, 
    6687, 
    6779, 
    6755, 
    11104, 
    6719, 
    6810, 
    6920, 
    6762, 
    6717, 
    8801, 
    6701, 
    6795, 
    6789, 
    6747, 
    6731, 
    6686, 
    6778, 
    6754, 
    11103, 
    6716, 
    6808, 
    6922, 
    6761, 
    6715, 
    8688, 
    6699, 
    6794, 
    6783, 
    6746, 
    6915, 
    6685, 
    6776, 
    6751, 
    6712, 
    11059, 
    6714, 
    6806, 
    6918, 
    6760, 
    8241, 
    6698, 
    6790, 
    6780, 
    6745, 
    6729, 
    6916, 
    6684, 
    6777, 
    6744, 
    6713, 
    11052, 
    6711, 
    6805, 
    6919, 
    6758, 
    8008, 
    6697, 
    6788, 
    6769, 
    6743, 
    6728, 
    6917, 
    6683, 
    6775, 
    6740
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00089

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_ab__video_gallery",
          "access_type": "ref",
          "possible_keys": ["status", "product_id"],
          "key": "status",
          "key_length": "3",
          "used_key_parts": ["status"],
          "ref": ["const"],
          "rows": 2,
          "filtered": 100,
          "index_condition": "cscart_ab__video_gallery.`status` = 'A'",
          "attached_condition": "cscart_ab__video_gallery.product_id in (7172,6924,6730,6705,10992,6710,6804,6914,6757,6742,8000,6696,6787,6770,6727,6912,11378,6773,6739,6704,10778,6708,6803,6809,6756,6741,7914,6693,6786,6767,6726,6913,11211,6774,6735,6703,10640,6709,6800,6807,6753,6738,7411,6692,6785,6766,6725,6814,8865,6772,6733,6695,10246,6707,6799,6802,6752,6737,6690,6784,6764,6723,6813,8742,6771,6724,6694,10195,6706,6797,6801,6750,6736,7084,6689,6782,6763,6722,6812,8743,6768,6720,6691,9495,6702,6798,6793,6749,6734,6921,6688,6781,6759,11375,6721,6811,8680,6765,6718,6682,8802,6700,6796,6791,6748,6732,6923,6687,6779,6755,11104,6719,6810,6920,6762,6717,8801,6701,6795,6789,6747,6731,6686,6778,6754,11103,6716,6808,6922,6761,6715,8688,6699,6794,6783,6746,6915,6685,6776,6751,6712,11059,6714,6806,6918,6760,8241,6698,6790,6780,6745,6729,6916,6684,6777,6744,6713,11052,6711,6805,6919,6758,8008,6697,6788,6769,6743,6728,6917,6683,6775,6740) and cscart_ab__video_gallery.storefront_id in (1,0)"
        }
      }
    ]
  }
}