Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    11703, 
    13091, 
    18018, 
    11964, 
    8159, 
    12888, 
    11826, 
    11852, 
    13351, 
    12224, 
    13396, 
    12208, 
    11681, 
    12963, 
    12951, 
    11919, 
    6943, 
    12486, 
    8890, 
    11814, 
    13209, 
    11739, 
    13170, 
    13412, 
    12077, 
    19519, 
    12950, 
    11923, 
    11866, 
    13226, 
    12381, 
    13399, 
    11694, 
    13090, 
    18099, 
    11946, 
    8068, 
    12887, 
    11824, 
    11850, 
    13382, 
    12223, 
    13397, 
    12166, 
    11680, 
    12962, 
    12947, 
    11879, 
    6940, 
    12485, 
    8062, 
    11815, 
    13207, 
    11738, 
    13169, 
    13413, 
    12076, 
    18071, 
    12949, 
    11922, 
    11862, 
    13227, 
    12379, 
    13400, 
    11692, 
    13089, 
    18100, 
    11945, 
    8031, 
    12525, 
    11822, 
    11827, 
    13383, 
    12222, 
    13398, 
    12165, 
    11679, 
    12961, 
    12890, 
    11878, 
    6887, 
    12484, 
    8009, 
    11807, 
    13205, 
    11737, 
    13168, 
    13452, 
    12075, 
    9980, 
    12948, 
    11920, 
    11861, 
    13230, 
    13403, 
    12221, 
    11690, 
    13087, 
    18101, 
    11944, 
    7995, 
    12523, 
    11805, 
    11825, 
    13386, 
    13401, 
    12164, 
    11678, 
    12960, 
    12524, 
    11877, 
    6864, 
    12482, 
    13222, 
    11806, 
    13204, 
    11736, 
    13155, 
    13487, 
    12073, 
    9271, 
    12946, 
    11875, 
    11860, 
    13240, 
    12231, 
    13404, 
    12220, 
    11689, 
    13077, 
    18136, 
    11943, 
    7896, 
    12521, 
    11747, 
    11823, 
    13388, 
    13402, 
    12085, 
    11677, 
    12959, 
    12522, 
    11876, 
    6858, 
    12483, 
    13228, 
    11751, 
    13203, 
    11735, 
    13099, 
    13488, 
    12074, 
    9252, 
    12944, 
    11874, 
    11859, 
    13241, 
    12230, 
    13405, 
    12219, 
    11688, 
    13076, 
    13134, 
    11942, 
    7778, 
    12520, 
    11742, 
    11821, 
    13389, 
    13202, 
    13406, 
    12084, 
    11676, 
    12958, 
    12518, 
    11873, 
    13219, 
    12481, 
    13229, 
    11746, 
    13498, 
    11734, 
    13097, 
    13495, 
    12052, 
    8903, 
    12894, 
    11867, 
    11858, 
    13262, 
    12229, 
    12218, 
    11687, 
    13075, 
    13098, 
    11941, 
    7658, 
    12519, 
    11693, 
    13390, 
    13195, 
    13407, 
    12083, 
    11675, 
    12956, 
    12487, 
    11872, 
    13220, 
    12480, 
    13349, 
    11745, 
    11733, 
    13096, 
    13496, 
    12051, 
    8892, 
    12893, 
    11865, 
    11857, 
    13263, 
    12228, 
    12217, 
    11686, 
    13074, 
    13095, 
    11926, 
    7541, 
    12517, 
    11691, 
    11819, 
    13391, 
    13194, 
    13408, 
    12081, 
    11674, 
    12955, 
    12422, 
    11871, 
    13221, 
    12479, 
    13384, 
    11744, 
    11732, 
    13094, 
    13497, 
    12032, 
    8889, 
    12892, 
    11864, 
    11856, 
    13264, 
    12227, 
    12216, 
    11685, 
    13012, 
    11925, 
    18703, 
    12516, 
    11684, 
    11818, 
    13392, 
    13192, 
    13409, 
    12080, 
    11673, 
    12954, 
    12380, 
    11870, 
    13223, 
    12423, 
    13385, 
    11743, 
    11731, 
    13093, 
    13685, 
    12031, 
    8516, 
    12891, 
    11863, 
    11855, 
    13347, 
    12226, 
    13393, 
    12214, 
    11683, 
    12965, 
    13073, 
    11924, 
    7278, 
    12490, 
    9699, 
    11817, 
    18422, 
    13189, 
    13410, 
    12079, 
    11672, 
    12953, 
    12215, 
    11869, 
    13224, 
    12421, 
    13387, 
    11741, 
    11710, 
    13092, 
    13686, 
    11965, 
    8377, 
    12889, 
    11853, 
    11854, 
    13350, 
    12225, 
    13394, 
    12209, 
    11682, 
    12964, 
    12957, 
    11921, 
    7161, 
    12489, 
    8893, 
    11816, 
    11851, 
    13171, 
    13411, 
    12078, 
    11671, 
    12952, 
    11947, 
    11868, 
    13225, 
    12382, 
    13395, 
    11740, 
    12364, 
    11820, 
    13088
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.00087

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 (11703,13091,18018,11964,8159,12888,11826,11852,13351,12224,13396,12208,11681,12963,12951,11919,6943,12486,8890,11814,13209,11739,13170,13412,12077,19519,12950,11923,11866,13226,12381,13399,11694,13090,18099,11946,8068,12887,11824,11850,13382,12223,13397,12166,11680,12962,12947,11879,6940,12485,8062,11815,13207,11738,13169,13413,12076,18071,12949,11922,11862,13227,12379,13400,11692,13089,18100,11945,8031,12525,11822,11827,13383,12222,13398,12165,11679,12961,12890,11878,6887,12484,8009,11807,13205,11737,13168,13452,12075,9980,12948,11920,11861,13230,13403,12221,11690,13087,18101,11944,7995,12523,11805,11825,13386,13401,12164,11678,12960,12524,11877,6864,12482,13222,11806,13204,11736,13155,13487,12073,9271,12946,11875,11860,13240,12231,13404,12220,11689,13077,18136,11943,7896,12521,11747,11823,13388,13402,12085,11677,12959,12522,11876,6858,12483,13228,11751,13203,11735,13099,13488,12074,9252,12944,11874,11859,13241,12230,13405,12219,11688,13076,13134,11942,7778,12520,11742,11821,13389,13202,13406,12084,11676,12958,12518,11873,13219,12481,13229,11746,13498,11734,13097,13495,12052,8903,12894,11867,11858,13262,12229,12218,11687,13075,13098,11941,7658,12519,11693,13390,13195,13407,12083,11675,12956,12487,11872,13220,12480,13349,11745,11733,13096,13496,12051,8892,12893,11865,11857,13263,12228,12217,11686,13074,13095,11926,7541,12517,11691,11819,13391,13194,13408,12081,11674,12955,12422,11871,13221,12479,13384,11744,11732,13094,13497,12032,8889,12892,11864,11856,13264,12227,12216,11685,13012,11925,18703,12516,11684,11818,13392,13192,13409,12080,11673,12954,12380,11870,13223,12423,13385,11743,11731,13093,13685,12031,8516,12891,11863,11855,13347,12226,13393,12214,11683,12965,13073,11924,7278,12490,9699,11817,18422,13189,13410,12079,11672,12953,12215,11869,13224,12421,13387,11741,11710,13092,13686,11965,8377,12889,11853,11854,13350,12225,13394,12209,11682,12964,12957,11921,7161,12489,8893,11816,11851,13171,13411,12078,11671,12952,11947,11868,13225,12382,13395,11740,12364,11820,13088) and cscart_ab__video_gallery.storefront_id in (1,0)"
        }
      }
    ]
  }
}