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 (
    64852, 63103, 64928, 64993, 64363, 64966, 
    62334, 62341, 61301, 64356, 64992, 
    64962
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00070

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 (64852,63103,64928,64993,64363,64966,62334,62341,61301,64356,64992,64962)"
        }
      }
    },
    "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
21292 62334 product 0 33173 M 0 D 0 0 atomic-topless-double-industrial-sconce-307-emerald-TGG-RIB.jpg Atomic Topless LED Double Industrial Guard Sconce, 307-Emerald Green, TGG-Heavy Duty Cast Guard, RIB-Ribbed Glass 1000 1000 33173
21318 62341 product 0 33199 M 0 D 0 0 streamline-industrial-topless-guard-sconce-975-galvanized-TGG-FST.jpg Streamline LED Industrial Guard Sconce, 975-Galvanized, Topless Shade, TGG-Heavy Duty Cast Guard, FST-Frosted Glass 1000 1000 33199
22054 61301 product 0 33946 M 0 D 0 0 Austin-Wall-Sconce-LED-300-dark-green.jpg 10" Austin LED Sconce, 300-Dark Green 1000 1000 33946
24294 63103 product 0 36273 M 0 D 0 0 Cooper-Sconce-700-royal-blue.jpg Cooper LED Wall Sconce, 700-Royal Blue 1000 1000 36273
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
30755 64363 product 0 42987 M 0 D 0 0 bullet-flush-black.jpg Bullet Flush Mount LED Sign Light, 100-Black 1000 1000 42987
42038 64852 product 0 54271 M 0 D 0 0 original-gooseneck-LED-16in-100-Black-G15.jpg 16" The Originalâ„¢ LED Gooseneck, 100-Black, G15 Gooseneck Arm 1000 1000 54271
47712 64928 product 0 59945 M 0 D 0 0 Avalon-gooseneck-LED-16in-975-oil-galvanized-G22-wc.jpg 16" Avalon LED, 975-Galvanized, Wire Cage, G22 Gooseneck Arm 1000 1000 59945
49582 64962 product 0 61815 M 0 D 0 0 wilcox-gooseneck-LED-16in-300-dark-green-G6.jpg 16" Wilcox LED, 300-Dark Green, G6 Gooseneck Arm 1000 1000 61815
49719 64966 product 0 61952 M 0 D 0 0 Bomber-LED-gooseneck-17in-975-galvanized-G32.jpg 17" Bomber LED, 975-Galvanized, G32 Gooseneck Arm 1000 1000 61952
50374 64992 product 0 62607 M 0 D 0 0 emblem-gooseneck-LED-12in-975-galvanized-G22-Swivel-Knuckle.jpg 12" Emblem LED, 975-Galvanized, G22 Gooseneck Arm, Swivel Knuckle 1000 1000 62607
50429 64993 product 0 62662 M 0 D 0 0 Fire-Chief-gooseneck-LED-14in-975-galvanized-G32.jpg 14" Fire Chief LED, 975-Galvanized, G32 Gooseneck Arm 1000 1000 62662