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 = 'A' 
  AND cscart_images_links.object_id IN (61519, 61516) 
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": 21,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61519,61516)"
        }
      }
    },
    "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
16624 61516 product 0 28180 A 0 D 0 0 mini_astro_pendant_600_bronze.jpg Mini Eclipse Pendant, 600-Bronze, SBK-Standard Black Cord | Shown with Nostalgic Edison-Style Victorian 40 Watt Light Bulb 600 551 28180
16630 61516 product 0 28186 A 0 D 0 0 mini_astro_pendant_white_cord_400_barn_red_.jpg Mini Eclipse Pendant, 400-Barn Red, SBK-Standard White Cord 600 551 28186
16710 61516 product 0 28276 A 0 D 0 0 mini_astro_pendant_300_dark_green.jpg Mini Eclipse Pendant, 300-Dark Green, SBK-Standard Black Cord 600 551 28276
21228 61519 product 0 33109 A 0 D 0 0 Eclipse-angled-sconce-magenta-mini-shade-g33-arm-bulb.jpg Mini Eclipse Wall Sconce, 490-Magenta, G33 Mini Straight Arm | Shown with Nostalgic Edison Bulb 1000 1000 33109
21229 61519 product 0 33110 A 1 D 0 0 Eclipse-angled-sconce-blush-pink-mini-shade-g48-arm-bulb.jpg Mini Eclipse Wall Sconce, 480-Blush Pink, G48 Mini Gooseneck Arm | Shown with Nostalgic Edison Bulb 1000 1000 33110
60033 61519 product 0 72266 A 2 D 0 0 Barn_Light_Mini_Eclipse_Wall_Sconce_-_Barn_Light_Electric_-_Wall_Sconce_Lighting.jpg Mini Eclipse Wall Sconces, 100-Black, G37 Mini Gooseneck Arm 1000 1000 72266
32504 61519 product 0 44737 A 3 C 0 0 _DSC5211.jpg Mini Eclipse Wall Sconce, 975-Galvanized | Courtesy of Anne Nelson Interior Design 601 900 44737
48332 61519 product 0 60565 A 4 C 0 0 mini_eclipse_wall_sconce_galvanized_G38arm.jpg Mini Eclipse Wall Sconce, 975-Galvanized | Courtesy of Anne Nelson Interior Design 4809 3210 60565
61416 61519 product 0 73649 A 5 C 0 0 Downtown_Minimalist_Cord_Pendants_-_Barn_Light_Electric_-_Commercial_Apartment_Building_Mailroom_yuj9-hk.png Mini Eclipse Wall Sconce, 100-Black, G48 Mini Gooseneck Arms (Also pictured: Downtown Minimalist Cord Pendants) | Photo Courtesy of CID Design Group, (@cid_designgroup), Alta Purl and Laura Sumrak (@laurasumrak) 1400 2100 73649
58638 61519 product 0 70871 A 6 C 0 0 Barn_Light_Mini_Artesia_Wall_Sconce_-_Barn_Light_Electric_-_Red_Modern_Bathroom_Vanity_Light.jpg Mini Eclipse Wall Sconces, 400-Barn Red, G38 Gooseneck Arm, 40W G30 Thread Edison Bulb | Photo Courtesy of Bentley Waters Designs 1242 1500 70871
56139 61519 product 0 68372 A 7 C 0 0 mini_eclipse_wall_sconce_white_G38arm5.jpg Mini Eclipse Wall Sconce, 200-White, G38 Mini Gooseneck Arms | Photo Courtesy of Carly Page Summers and The Wayback Austin 3651 5476 68372
61417 61519 product 0 73650 A 8 C 0 0 Downtown_Minimalist_Cord_Pendants_-_Barn_Light_Electric_-_Commercial_Apartment_Building_Mailroom_3iuq-s2.png Mini Eclipse Wall Sconce, 100-Black, G48 Mini Gooseneck Arms (Also pictured: Downtown Minimalist Cord Pendants) | Photo Courtesy of CID Design Group, (@cid_designgroup), Alta Purl and Laura Sumrak (@laurasumrak) 1058 1136 73650
61720 61519 product 0 73953 A 9 C 0 0 Barn_Light_Mini_Eclipse_Wall_Sconce_-_Barn_Light_Electric_-_Bathroom_Lighting.jpg Mini Eclipse Wall Sconces, 975-Galvanized, G33 Mini Gooseneck Arms | Photo Courtesy of Traction Architecture and Ryan Gamma Photography 5778 8169 73953
56137 61519 product 0 68370 A 10 C 0 0 mini_eclipse_wall_sconce_white_G38arm14.jpg Mini Eclipse Wall Sconce, 200-White, G38 Mini Gooseneck Arms | Photo Courtesy of Carly Page Summers and The Wayback Austin 3562 3269 68370
30279 61519 product 0 42502 A 11 C 0 0 mini_wall_sconce_lights-512x768.jpg (2) Mini Eclipse Wall Sconces, 400-Barn Red, G33 Straight Arm | Customer Submission 512 768 42502
56138 61519 product 0 68371 A 12 C 0 0 mini_eclipse_wall_sconce_white_G38arm2.jpg Mini Eclipse Wall Sconce, 200-White, G38 Mini Gooseneck Arms | Photo Courtesy of Carly Page Summers and The Wayback Austin 3651 5477 68371
32442 61519 product 0 44675 A 13 C 0 0 Barn_Light_Electric_Mini_Eclipse_Wall_Sconce.jpg (2) Mini Eclipse Wall Sconces, 100-Black, G48 Mini Gooseneck Arms and Nostalgic Edison-Style 1910 Era Bulbs | Photo Courtesy of Nest Interior Decor 576 1024 44675
32443 61519 product 0 44676 A 14 C 0 0 Barn_Light_Electric_Mini_Eclipse_Wall_Sconce_jjc2-jq.jpg (2) Mini Eclipse Wall Sconces, 100-Black, G48 Mini Gooseneck Arms and Nostalgic Edison-Style 1910 Era Bulbs | Photo Courtesy of Nest Interior Decor 576 1024 44676
66476 61519 product 0 78709 A 14 C 0 0 IMG_5717-residential-interior-lighting-on-bedroom-nightstand-Barn-Light-Mini-Eclipse-Wall-Sconce-200-White-G33arm-60W-G40-White-Bulbs.jpg (2) Mini Eclipse Wall Sconce, 200-White, G33 Arm, 60W, G40 Watt, White Bulbs | Customer Submission 4032 3024 78709
66773 61519 product 0 79006 A 14 C 0 0 IMG_0474-residential-interior-lighting-kitchen-sink-view-Barn-Light-Mini-Eclipse-Wall-Sconce-200-White-G37arm.jpg Mini Eclipse Wall Sconce, 200-White, G37 Arm | Customer Submission 3005 3533 79006
66774 61519 product 0 79007 A 14 C 0 0 IMG_0479-residential-interior-lighting-kitchen-sink-view-Barn-Light-Mini-Eclipse-Wall-Sconce-200-White-G37arm.jpg Mini Eclipse Wall Sconce, 200-White, G37 Arm | Customer Submission 3024 3766 79007