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, 64917, 63103, 64928, 62365, 62658, 
    64993, 62428, 64363, 62334, 62412, 
    62420
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00075

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,64917,63103,64928,62365,62658,64993,62428,64363,62334,62412,62420)"
        }
      }
    },
    "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
21422 62365 product 0 33303 M 0 D 0 0 Flush-Mount-Industrial-Guard-490-magenta-WGG-RIB.jpg Flush Mount LED Guard Sconce, 490-Magenta, WGG-Wire Guard, RIB-Ribbed Glass 1000 1000 33303
21595 62412 product 0 33476 M 0 D 0 0 sydney-flush-16in-100-black-CLR.jpg 16" Sydney LED, 100-Black, CLR-Clear Glass 1000 1000 33476
21620 62420 product 0 33501 M 0 D 0 0 brisbane-flush-mount-14in-705-CLR.jpg 14" Brisbane LED, 705-Navy, CLR-Clear Glass 1000 1000 33501
21644 62428 product 0 33525 M 0 D 0 0 Wallaby-flush-12in-700-royal-blue-RIB.jpg 12" Wallaby LED, 700-Royal Blue, RIB-Ribbed Glass 1000 1000 33525
22622 62658 product 0 34520 M 0 D 0 0 outback-flush-mount-12in-995-raw-copper-100-black-TGG-RIB_zk1e-t8.jpg 12" Outback LED, 995-Natural Raw Copper, Guard in 100-Black, RIB-Ribbed Glass 1000 1000 34520
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
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
46652 64917 product 0 58885 M 0 D 0 0 led-original-stem-16in-500-buttery-yellow-HSC-975-galvanized.jpg 16" The Originalâ„¢ LED, 500-Buttery Yellow, Mounting in 975-Galvanized, Hang Straight Canopy 1000 1000 58885
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
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