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 (
    60602, 64366, 64369, 64908, 62447, 62582, 
    63852, 62664, 61531, 60603, 62839, 
    61467
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00108

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 (60602,64366,64369,64908,62447,62582,63852,62664,61531,60603,62839,61467)"
        }
      }
    },
    "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
16329 61467 product 0 27849 M 0 D 0 0 vonbraunedit.jpg Von Braun 4-Light Chandelier, 975-Galvanized 600 600 27849
16714 61531 product 0 28281 M 0 D 0 0 chateau-cord-400-barn-red-CSB.jpg Chateau Food Warmer Pendant, 400-Barn Red, Black Jacketed Cord 1000 1000 28281
17752 60603 product 0 29380 M 0 D 0 0 wilcox-16in-975-galvanized-CSR-red-cord-studio-cable-dbw.jpg 16" Wilcox Studio Light, 975-Galvanized, CSR-Red Cloth Cord 1000 1000 29380
17870 60602 product 0 29499 M 0 D 0 0 _original-STUDIO-CABLE-16in-998-weathered-brass-CSB.jpg 16" The Originalâ„¢ Studio Light, 998-Natural Weathered Brass, CSB-Black Cloth Cord 1000 1000 29499
21813 62447 product 0 33695 M 0 D 0 0 Bomber-Chandelier-3-Light-Straight-Arm-300-dark-green-18in-arm.jpg Bomber 3-Light, 300-Dark Green, 18" Arms 1000 1000 33695
22170 62582 product 0 34062 M 0 D 0 0 outback-stem-16in-490-magenta-100-black-TGG-RIB.jpg 16" Outback, 490-Magenta, Guard in 100-Black, RIB-Ribbed Glass 1000 1000 34062
22686 62664 product 0 34584 M 0 D 0 0 marathon-soho-4-Light-Chandelier-705-navy.jpg Canal SoHo 4-Light, 705-Navy 1000 1000 34584
23014 62839 product 0 34925 M 0 D 0 0 3-cluster-pendant-indy-industrial-black-CSBW-black-and-white-torch-bulb.jpg 3-Light Indy Industrial Chandelier, Black Sockets, Black Canopy, CSBW-Black & White Cloth Cord, 30W Hairpin Edison Bulbs 600 600 34925
27849 63852 product 0 40028 M 0 D 0 0 3-pendant-chandelier-red-red-white-cord.jpg Downtown 3-Light Pendant Chandelier, 400-Barn Red, CSRW-Red & White Cloth Cord, Edison-Style 1910 Era Bulbs 600 600 40028
30695 64369 product 0 42927 M 0 D 0 0 venice-chain-large-white-stacked-slot.jpg Large Venice Chain Hung Pendant, 200-White, White Chain with CSUW-Blue & White Cloth Cord, SMK-Smoke Crackle Glass, Shown with Edison Bulb 1000 1000 42927
30718 64366 product 0 42950 M 0 D 0 0 milan-stem-small-jadite-no-slot.jpg Small Milan Stem Mount Pendant, 311-Jadite PTMP, No Slot 1000 1000 42950
47897 64908 product 0 60130 M 0 D 0 0 schoolhouse-drum-flush-semi-opaque-stripe-PB8-copper-weathered-black_fx3h-y9.jpg Drum Semi-Flush, 996-Natural Weathered Copper, Four Painted Band, 100-Black 1000 1000 60130