SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    63384, 64356, 62020, 63510, 61621, 60976, 
    62038, 64772, 64362, 61399, 60975, 
    62039
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00121

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 12,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (63384,64356,62020,63510,61621,60976,62038,64772,64362,61399,60975,62039)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["cscart_migrate.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
13547 60976 product 0 24005 M 0 D 0 0 10_inch_austin_double_vanity_gooseneck_975_galvanized.jpg Austin Gooseneck Double Vanity Light, 10" Shades, 975-Galvanized 600 600 24005
15967 61399 product 0 27485 M 0 D 0 0 original-gooseneck-LED-28in-Sherbert-Orange-495-G8-100-Black.jpg 28" The Originalâ„¢ Gooseneck LED, 495-Sherbet Orange, G8 Gooseneck Arm, 100-Black 1000 1000 27485
18083 60975 product 0 29712 M 0 D 0 0 10_inch_austin_double_vanity_sconce_300_dark_green_2.jpg 10" Austin 2-Light Vanity Sconce, 300-Dark Green 600 600 29712
19202 62020 product 0 30914 M 0 D 0 0 Chestnut-Gooseneck-16in-400-barn-red-G22-WC-975-galvanized.jpg 16" Chestnut, 400-Barn Red, Wire Cage, 975-Galvanized, G22 Gooseneck Arm 1000 1000 30914
19344 62038 product 0 31066 M 0 D 0 0 Emblem-Dual-Arm-10in-400-barn-red.jpg Dual Arm Emblem Sign Light, 10" Shades, 400-Barn Red 1000 1000 31066
19351 62039 product 0 31073 M 0 D 0 0 fire-chief-Dual-Arm-10in-800-industrial-grey.jpg Dual Arm Fire Chief Sign Light, 10" Shades, 800-Industrial Grey, Swivel Knuckles 1000 1000 31073
23150 61621 product 0 35061 M 0 D 0 0 schoolhouse-primary-vanity-3-light-small-glass-opaque-400-barn-red-triple-painted-band.jpg Primary 3-Light Schoolhouse Vanity Light, Opaque Glass, 400-Barn Red Fitter & Mounting Finish, Triple Painted Band 1000 1000 35061
25727 63384 product 0 37864 M 0 D 0 0 Getty-medium-size-sconce-sunflower-mini-shade-black-g47-arm-bulb.jpg 8" Gladstone Dome Shade Sconce, 570-Sunflower, Mounting in 100-Black, No Switch 1000 1000 37864
26502 63510 product 0 38669 M 0 D 0 0 downtown-2-light-sconce-galvanized-brass-raw-web1498153412594c01c4a7fb3.jpg Downtown Minimalist Double Sconce, Mounting in 975-Galvanized, Cups in 997-Natural Raw Brass, Nostalgic Edison-Style 1890 Era 40W Bulb 600 600 38669
30534 64356 product 0 42766 M 0 D 0 0 bullet-sign-light_barn-red.jpg Bullet Dual LED Sign Light, 400-Barn Red 1000 1000 42766
30753 64362 product 0 42985 M 0 D 0 0 bullet-stem-galvanized1.jpg Bullet Stem Mount LED Sign Light, 975-Galvanized, 6" Stem 1000 1000 42985
38914 64772 product 0 51147 M 0 D 0 0 Fire-Chief-gooseneck-14in-100-black-G8.jpg 14" Fire Chief, 100-Black, G8 Gooseneck Arm 1000 1000 51147