Sandbox

SELECT 
  video_id, 
  product_id 
FROM 
  cscart_ab__video_gallery 
WHERE 
  product_id IN (
    9744, 
    9658, 
    9943, 
    9589, 
    9730, 
    8461, 
    9647, 
    9928, 
    9756, 
    9573, 
    9672, 
    9955, 
    9616, 
    9743, 
    8945, 
    9657, 
    9942, 
    9587, 
    9686, 
    8459, 
    9927, 
    9754, 
    9671, 
    9954, 
    9633, 
    9612, 
    8941, 
    9656, 
    9585, 
    9685, 
    8458, 
    10202, 
    9645, 
    9926, 
    9753, 
    9569, 
    9953, 
    9629, 
    9611, 
    9655, 
    9925, 
    9584, 
    9683, 
    8457, 
    10030, 
    9643, 
    9568, 
    9668, 
    9952, 
    9630, 
    9610, 
    9738, 
    8939, 
    9654, 
    9937, 
    9923, 
    9582, 
    9682, 
    8308, 
    9961, 
    9750, 
    9666, 
    9632, 
    9737, 
    8936, 
    9924, 
    9581, 
    9681, 
    8307, 
    9641, 
    9565, 
    9665, 
    9950, 
    9627, 
    9606, 
    8933, 
    9652, 
    9934, 
    9922, 
    9578, 
    9960, 
    9640, 
    9748, 
    9564, 
    9664, 
    9949, 
    9626, 
    9604, 
    9735, 
    8687, 
    9651, 
    9933, 
    9921, 
    9577, 
    9959, 
    9562, 
    9662, 
    9947, 
    9625, 
    9600, 
    9734, 
    9650, 
    9932, 
    9576, 
    9677, 
    7493, 
    9958, 
    9638, 
    9746, 
    8999, 
    9945, 
    9623, 
    9599, 
    8463, 
    9931, 
    9758, 
    9575, 
    9676, 
    6883, 
    9956, 
    9745, 
    8983, 
    9660, 
    9944, 
    9621, 
    9732, 
    8462, 
    9648, 
    9930, 
    9757, 
    9574, 
    9673, 
    9957, 
    9635, 
    8982, 
    9619, 
    9634, 
    9646, 
    9572, 
    9741, 
    9940, 
    9670, 
    9740, 
    8940, 
    9939, 
    9752, 
    9642, 
    9566, 
    9951, 
    9607, 
    9653, 
    9935, 
    9962, 
    9749, 
    9736, 
    9680, 
    8235, 
    9678, 
    8213, 
    9639, 
    9747, 
    8686, 
    9920, 
    9661, 
    9733, 
    9649, 
    9636, 
    9591
  ) 
  AND status = "A" 
  AND storefront_id IN (1, 0)

Query time 0.01132

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 (9744,9658,9943,9589,9730,8461,9647,9928,9756,9573,9672,9955,9616,9743,8945,9657,9942,9587,9686,8459,9927,9754,9671,9954,9633,9612,8941,9656,9585,9685,8458,10202,9645,9926,9753,9569,9953,9629,9611,9655,9925,9584,9683,8457,10030,9643,9568,9668,9952,9630,9610,9738,8939,9654,9937,9923,9582,9682,8308,9961,9750,9666,9632,9737,8936,9924,9581,9681,8307,9641,9565,9665,9950,9627,9606,8933,9652,9934,9922,9578,9960,9640,9748,9564,9664,9949,9626,9604,9735,8687,9651,9933,9921,9577,9959,9562,9662,9947,9625,9600,9734,9650,9932,9576,9677,7493,9958,9638,9746,8999,9945,9623,9599,8463,9931,9758,9575,9676,6883,9956,9745,8983,9660,9944,9621,9732,8462,9648,9930,9757,9574,9673,9957,9635,8982,9619,9634,9646,9572,9741,9940,9670,9740,8940,9939,9752,9642,9566,9951,9607,9653,9935,9962,9749,9736,9680,8235,9678,8213,9639,9747,8686,9920,9661,9733,9649,9636,9591) and cscart_ab__video_gallery.storefront_id in (1,0)"
        }
      }
    ]
  }
}