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 (
    61081, 62246, 60906, 62040, 61425, 62167, 
    62023, 64273, 30013, 61697, 60484, 
    30012
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00116

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 (61081,62246,60906,62040,61425,62167,62023,64273,30013,61697,60484,30012)"
        }
      }
    },
    "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
13082 60484 product 0 23106 M 0 D 0 0 static-industrial-guard-sconce-705-navy-CGG-RIB.jpg Industrial Static Sconce, 705-Navy, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 23106
13141 60906 product 0 23223 M 0 D 0 0 austin-sconce-10in-975-galvanized.jpg 10" Austin Wall Sconce, 975-Galvanized 1000 1000 23223
14233 61081 product 0 25028 M 0 D 0 0 Canal-SoHo-Sconce-975-galvanized-490-magenta.jpg Canal SoHo Sconce, 490-Magenta, Mounting in 975-Galvanized 1000 1000 25028
16216 61425 product 0 27736 M 0 D 0 0 Industrial-Gooseneck-CGG-Warehouse-311-jadite-G11.jpg Industrial Guard Gooseneck Light, 311-Jadite, Warehouse Shade, CGG-Standard Cast Guard, FST-Frosted Glass, G11 Gooseneck Arm 1000 1000 27736
17240 61697 product 0 28807 M 0 D 0 0 canal-gooseneck-400-barn-red-g35.jpg Canal Gooseneck Light, 400-Barn Red, G35 Gooseneck Arm 1000 1000 28807
18237 30013 product 0 29872 M 0 D 0 0 anchorage-wall-mountlight-round-white.jpg Anchorage Bulkhead Wall Mount Light Fixture Large Size, 200-White Finish 600 600 29872
19248 30012 product 0 30960 M 0 D 0 0 amidships-bulkhead-wall-mount-oval-galv.jpg Amidships Bulkhead Wall Mount Light Fixture | Large, 975-Galvanized 600 600 30960
19359 62040 product 0 31081 M 0 D 0 0 Dual-Arm-Sign-Light-warehouse_black-side.jpg The Originalâ„¢ Dual Arm Sign Light, 14" Shades, 100-Black, 12" Arm Projection 600 600 31081
20277 62167 product 0 32093 M 0 D 0 0 wallaby-gooseneck-16in-100-black-490-magenta-FST-G26-alt.jpg 16" Wallaby, 100-Black, Guard in 490-Magenta, FST-Frosted Glass, G26 Gooseneck Arm 1000 1000 32093
20966 62246 product 0 32802 M 0 D 0 0 downtown-minimalist-plug-in-sconce-black-black-white-cord.jpg Downtown Minimalist Plug-In Sconce, 100-Black, CSBW-Black & White Cloth Cord, 1890 Era 40w Edison-Style Bulb 600 600 32802
29349 64273 product 0 41569 M 0 D 0 0 Fargo-swing-arm-plug-in-black-socket-975-galvanized-standard-black-cord.jpg Fargo Swing Arm Sconce, 975-Galvanized, Black Socket with Knob Switch, Arm in 975-Galvanized, SBK-Standard Black Cord, Nostalgic Edison-Style 40W 1910 Era Bulb 1000 1000 41569
30171 62023 product 0 42394 M 0 D 0 0 Chestnut-Bantam-Sconce-8in-390-teal.jpg 8" Bantam Chestnut, 390-Teal 1000 1000 42394