SELECT 
  video_id, 
  product_id 
FROM 
  q_ab__video_gallery 
WHERE 
  product_id IN (
    3024, 3144, 3145, 3146, 3195, 3368, 3369, 
    3370, 3199, 3377, 3378, 3379, 3203, 
    3381, 3382, 3383, 3384, 3385, 3386, 
    3387, 3388, 3389, 3390, 3391, 3392, 
    3393, 3394, 3395, 3396, 3397, 3398, 
    3399, 3400, 3401, 3402, 3403, 3404, 
    3405, 3406, 3407, 3408, 3409, 3410, 
    3411, 3412, 3413, 3414, 3415, 3416, 
    3417, 3418, 3419, 3420, 3421, 3422, 
    3423, 3424, 3248, 3426, 3427, 3428, 
    3429, 3430, 3431, 3432, 3433, 3434, 
    3435, 3436, 3437, 3438, 3439
  )

Query time 0.00053

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.80"
    },
    "table": {
      "table_name": "q_ab__video_gallery",
      "access_type": "index",
      "possible_keys": [
        "product_id"
      ],
      "key": "product_id",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 24,
      "rows_produced_per_join": 24,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "1.00",
        "eval_cost": "4.80",
        "prefix_cost": "5.80",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "video_id",
        "product_id"
      ],
      "attached_condition": "(`portal`.`q_ab__video_gallery`.`product_id` in (3024,3144,3145,3146,3195,3368,3369,3370,3199,3377,3378,3379,3203,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3248,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439))"
    }
  }
}