SELECT 
  video_id, 
  product_id 
FROM 
  q_ab__video_gallery 
WHERE 
  product_id IN (
    3628, 3629, 3630, 3631, 3632, 3633, 3634, 
    3635, 3636, 3637, 3638, 3639, 3640, 
    3641, 3642, 3643, 3644, 3645, 3646, 
    3647, 3648, 3649, 3650, 3651, 3652, 
    3653, 3654, 3655, 3656, 3657, 3658, 
    3659
  )

Query time 0.00033

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 (3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,3642,3643,3644,3645,3646,3647,3648,3649,3650,3651,3652,3653,3654,3655,3656,3657,3658,3659))"
    }
  }
}