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 (
    61051, 61464, 61520, 61526, 61339, 61074, 
    61452, 59797, 61524, 61413, 61516, 
    64353
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00095

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 (61051,61464,61520,61526,61339,61074,61452,59797,61524,61413,61516,64353)"
        }
      }
    },
    "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
6086 59797 product 0 10402 M 0 D 0 0 tanker-dino-stem-pendant-975-galvanized-12in-shade-12instem.jpg Dino Industrial Tanker Warehouse Pendant, 12" Flex Tube 1000 1000 10402
14076 61051 product 0 24857 M 0 D 0 0 Laramie-Gooseneck-16in-975-galvanized-G22.jpg 16" Laramie, 975-Galvanized, G22 Gooseneck Arm 1000 1000 24857
14300 61074 product 0 25103 M 0 D 0 0 Lafayette-SoHo-Studio-Cable-307-emerald.jpg Lafayette SoHo, 307-Emerald Green, Shade Top in 975-Galvanized 1000 1000 25103
15720 61339 product 0 27199 M 0 D 0 0 sydney-gooseneck-14in-995-raw-brass-100-black-FST-G19.jpg 14" Sydney, 995-Natural Raw Copper, With Cap Option, Guard in 100-Black, FST-Frosted Glass, G19 Gooseneck, 100-Black 1000 1000 27199
16049 61413 product 0 27569 M 0 D 0 0 atomic-topless-double-industrial-sconce-705-navy-CGG-FST.jpg Atomic Topless Double Industrial Guard Sconce, 705-Navy, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 27569
16307 61464 product 0 27827 M 0 D 0 0 Polaris-4-Light-Chandelier-flared-700-royal-blue-CGG-RIB.jpg Polars 4-Light Chandelier, 700-Royal Blue, Flared Shade, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 27827
16343 61452 product 0 27863 M 0 D 0 0 the_bottom_line_cgg_975_galvanized_ribbed_glass_6uxa-89.jpg Foundry 4-Light Chandelier, 975-Galvanized, Warehouse Shade, CGG-Standard Cast Guard, RIB-Ribbed Glass 600 600 27863
16623 61516 product 0 28179 M 0 D 0 0 mini_astro_pendant_975_galv.jpg Mini Eclipse Pendant, 975-Galvanized | SBK-Standard Black Cord 600 600 28179
16696 61524 product 0 28262 M 0 D 0 0 original_400_barn_red_tgg_edit.jpg 12" The Originalâ„¢ Industrial Guard Post Mount, 400-Barn Red, FST-Frosted Glass 600 600 28262
16698 61526 product 0 28264 M 0 D 0 0 old_dixie_100_black_tgg_edit.jpg 13" Bomber Industrial Guard Post Mount, 100-Black, RIB-Ribbed Glass 600 600 28264
16712 61520 product 0 28278 M 0 D 0 0 Barn_Light_Mini_Artesia_Pendant_-_Barn_Light_Electric_-_Galvanized_Pendant_Lighting.jpg Mini Artesia Pendant, 975-Galvanized, TBK-Black Cotton Twist Cord 3960 3990 28278
30506 64353 product 0 42738 M 0 D 0 0 Downtown-Swing-Arm-Sconce-Black-Tala-Bulb-6W-2700k-Oblo.jpg The Downtown Swing Arm Sconce, 100-Black, G69 Arm | Shown with Oblo Tala Lamp 1000 1000 42738