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 (
    62435, 61399, 60975, 59407, 60601, 62039, 
    62841, 64182, 63853, 60604, 64357, 
    63515
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

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 (62435,61399,60975,59407,60601,62039,62841,64182,63853,60604,64357,63515)"
        }
      }
    },
    "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
3363 59407 product 0 6618 M 0 D 0 0 Retro-Renovation-Porcelain-Galvanized-Pendant-Tala-Bulb-6W-2500k-Globe-alt.jpg Retro Renovation Porcelain & Galvanized Pendant | Shown with Globe Tala Lamp 1000 1000 6618
11425 60601 product 0 19810 M 0 D 0 0 union-studio-cable-14in-307-emerald-CSB.jpg 14" Union, 307-Emerald Green, CSB-Black Cloth Cord 1000 1000 19810
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
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
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
26491 63515 product 0 38658 M 0 D 0 0 downtown-wall-sconce-red-red-white-chevron-cord-web2.jpg Downtown Minimalist Knuckled Plug-In Sconce, 400-Barn Red, CRZ-Red Chevron Cord, Nostalgic Edison-Style Victorian 25W Bulb 600 600 38658
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
28956 64182 product 0 41176 M 0 D 0 0 16-in-seaside-single-post-mount-355-jadite-galv-post.jpg 16" Seaside Radial Wave, 355-Porcelain Jadite, Single Post Mount, 975-Galvanized, Smooth Direct Burial Pole, 975-Galvanized 600 600 41176
30560 64357 product 0 42792 M 0 D 0 0 bullet-gooseneck-g15-sunflower-yellow.jpg Bullet Gooseneck LED Sign Light, 570-Sunflower, G15 Gooseneck Arm 1000 1000 42792
32469 60604 product 0 44702 M 0 D 0 0 bomber-studio-cable-15in-480-blush-pink-CMG.jpg 15" Bomber, 480-Blush Pink, Wire Cage, 975-Galvanized, CMG-Grey Cloth Cord 1000 1000 44702
47905 62435 product 0 60138 M 0 D 0 0 Wilcox-Uplight-Chain-Hung-Navy-Galvanized-Gold-White-Cord_twr9-3s.jpg 12" Wilcox Uplight, 705-Navy Shade Finish, 975-Galvanized Chain Finish with Gold & White Cloth Cord 1000 1000 60138