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 (
    61446, 62843, 63852, 62839, 62841, 63853, 
    63854, 62840, 61448, 62845, 62847, 
    64947, 64849, 64850
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00086

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": 14,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'M' and cscart_images_links.object_id in (61446,62843,63852,62839,62841,63853,63854,62840,61448,62845,62847,64947,64849,64850)"
        }
      }
    },
    "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
16244 61448 product 0 27764 M 0 D 0 0 enterprise-3-light-flared-307-emerald-green-CGG-RIB-CSB.jpg Enterprise 3-Light Chandelier, 307-Emerald Green, Flared Shade, CGG-Standard Cast Guard, RIB-Ribbed Glass, CSB-Black Cloth Cord 1000 1000 27764
16308 61446 product 0 27828 M 0 D 0 0 Insider-2-Light-Topless-500-buttery-yellow-CGG-RIB-CSUW.jpg Insider 2-Light Chandelier, 500-Buttery Yellow, CGG-Standard Cast Guard, RIB-Ribbed Glass, CSUW-Blue & White Cloth Cord 1000 1000 27828
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
23023 62840 product 0 34934 M 0 D 0 0 3-cluster-pendant-ball-jar-300-dark_green-CSGW-gold-chevron-cloth-victorian-bulb.jpg 3-Light Ball Jar Chandelier, 300-Dark Green, CSGW-Gold & White Cloth Cord, 25W Victorian Edison Bulbs 600 600 34934
23028 62841 product 0 34939 M 0 D 0 0 3-cluster-pendant-galvanized-canopy-indy-porcelain-socket-TBK-black-twist-1890-bulb.jpg 3-Light Indy Porcelain Socket Chandelier, Galvanized Canopy, TBK-Black Cotton Twist Cord, 1890 Era 40w Edison Bulbs 480 480 34939
23035 62843 product 0 34946 M 0 D 0 0 3-cluster-pendant-downtown-minimalist-311-jadite-CRZ-red-chevron-cloth-1890-blub.jpg 3-Light Downtown Minimalist Chandelier, 311-Jadite, CRZ-Red Chevron Cord, 1890 Era 40W Edison Bulbs 600 600 34946
23044 62845 product 0 34955 M 0 D 0 0 industrial-multi-light-chandelier-topless-715-delphite-CGG-RIB-CMG-200.jpg Atomic Topless Multi-Light Chandelier, 715-Delphite, CGG-Standard Cast Guard, RIB-Ribbed Glass, CMG-Grey Cloth Cord 1000 1000 34955
23051 62847 product 0 34962 M 0 D 0 0 Lafayette-Multi-Light-Chandelier-765-delphite-CMG.jpg Lafayette Multi-Light, 715-Delphite, CMG-Grey Cloth Cord 1000 1000 34962
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
27853 63853 product 0 40032 M 0 D 0 0 4-pendant-chandelier-galvanized-blue-white-cord.jpg Downtown 4-Light Pendant Chandelier, 975-Galvanized, CSUW-Blue & White Cloth Cord, Edison-Style 1890 Era Bulbs 600 600 40032
27859 63854 product 0 40038 M 0 D 0 0 5-pendant-chandelier-black-pink-black-cord.jpg Downtown 5-Light Pendant Chandelier, 100-Black, CSBP-Black & Pink Cloth Cord, Edison-Style 1890 Era Bulbs 600 600 40038
41924 64849 product 0 54157 M 0 D 0 0 Mig-Multi-Light-Jadite-Retro-Jadite-Green-Bronze-Tan-Twist-Cord.jpg Mig Multi-Light Pendant, 376-Jadite, 675-Brown, 375-Dark Green, Canopy in 311-Jadite, TPT-Putty Cotton Twist Cord 1000 1000 54157
41950 64850 product 0 54183 M 0 D 0 0 Mig-2-Light-Chandelier-Galvanized-White-Red-Chevron-Cord_yruw-74.jpg Mig 2-Light Linear Pendant, 975-Galvanized, CRZ-Red Chevron Cord 1000 1000 54183
48971 64947 product 0 61204 M 0 D 0 0 Timber-Ore-Downtown-Minimalist-3-Light-Linear-Pendant-Ash-Teal-Gold-White-Cord-Elva-Tala-Bulb.jpg Downtown Minimalist Wooden Socket 3-Light Pendant, 390-Teal, Ash Wood, CSGW-Gold & White Cloth Cord, Shown with Elva Tala Bulbs 1000 1000 61204