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 (61198, 61520) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00094

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": 27,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61198,61520)"
        }
      }
    },
    "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
30986 61198 product 0 43219 A 0 D 0 0 image001.jpg Barn Light Mini Artesia Wall Sconce, 100-Black, G37 Mini Gooseneck Arm | Shown with Nostalgic Edison Bulb 1000 1000 43219
60335 61520 product 0 72568 A 0 D 0 0 Barn_Light_Mini_Artesia_Pendant_-_Barn_Light_Electric_-_Pendant_Lighting.jpg Mini Artesia Pendant, 500-Buttery Yellow, TBK-Black Cotton Twist Cord 3960 3990 72568
60337 61520 product 0 72570 A 0 D 0 0 Barn_Light_Mini_Artesia_Pendant_-_Barn_Light_Electric_-_Cord_Pendant_Lighting.jpg Mini Artesia Pendant, 400-Barn Red, TBW-Red and Black Twist Cord 3960 3990 72570
60338 61520 product 0 72571 A 0 D 0 0 Barn_Light_Mini_Artesia_Pendant_-_Barn_Light_Electric_-_American_Made_Cord_Pendant_Lighting.jpg Mini Artesia Pendant, 750-Navy, CSGW-Gold & White Cloth Cord 3960 3990 72571
63598 61520 product 0 75831 A 0 C 0 0 residential-inteior-kitchen-lighting-mini-artesia-pendant-500-buttery-yellow-standard-black-cord.jpg Mini Artesia Pendant, 500-Buttery Yellow, SBK-Standard Black Cord | Photo Courtesy of Homeowner 1500 1699 75831
30989 61198 product 0 43222 A 1 D 0 0 Artesia.jpg Barn Light Mini Artesia Sconce, 500-Buttery Yellow, G38 Mini Gooseneck Arm 1000 1000 43222
30988 61198 product 0 43221 A 2 D 0 0 Artesia-angled-sconce-barn-red-mini-shade-g33-arm-bulb.jpg Barn Light Mini Artesia Sconce, 400-Barn Red, G33 Mini Gooseneck Arm | Shown with Nostalgic Edison Bulb 1000 1000 43221
30987 61198 product 0 43220 A 3 D 0 0 Artesia-angled-sconce-blush-pink-mini-shade-g48-arm-bulb.jpg Barn Light Mini Artesia Sconce, 480-Blush Pink, G48 Mini Gooseneck Arm | Shown with Nostalgic Edison Bulb 1000 1000 43220
42515 61198 product 0 54748 A 4 D 0 0 Mini-Artesia-Teal.jpg Barn Light Mini Artesia Sconce, 390-Teal, G33 Mini Straight Arm Gooseneck Arm | 1000 1000 54748
28811 61198 product 0 41010 A 5 C 0 0 mini_barn_wall_sconces-768x512.jpg Barn Light Mini Artesia Wall Sconces, 6" Shade, 975-Galvanized G33 Straight Arm (Shown with 12" Sky Chief Stem Mount Light, Flush Mount) | Customer Submission 768 512 41010
45912 61198 product 0 58145 A 6 C 1 1781 mini_artesia_wall_sconce_galvanized_G33mini_straight_arm4.jpg (3) Barn Light Mini Artesia Sconces, 975-Galvanized, G33 Mini Straight Gooseneck Arms | 1500 2000 58145
59067 61198 product 0 71300 A 7 C 0 0 Barn_Light_Mini_Artesia_Wall_Sconce_-_Barn_Light_Electric_-_Industrial_Kitchen_Sink_Lighting.jpg Barn Light Mini Artesia Sconce, 100-Black, G33 Mini Straight Arm Gooseneck Arm (Also pictured: (2) Canal SoHo Pendants in 420-Orange) | Photo Courtesy of Workroom Design Studio and Lynn Graves Photography 1200 1800 71300
48376 61198 product 0 60609 A 8 C 0 0 wall_sconce_lights_american_made.jpg Barn Light Mini Artesia Sconce, 975-Galvanized, G33 Mini Gooseneck Arm | Photo Courtesy of Homeowner 1075 715 60609
62859 61198 product 0 75092 A 9 C 0 0 IMG_4855-residential-interior-laundry-lighting-mini-artesia-wall-sconce-106-Matte-Black-G38-arm-Parobolic-3-light-Chandelier-106-Matte-Black-36in-stem_3diz-m2.jpeg Barn Light Mini Artesia Wall Sconce, 106-Matte Black, G38 Arm (Also Shown: Parabolic 3-Light Chandelier) | Photo Courtesy of Atlantic Builders Custom Homes 1500 2000 75092
45911 61198 product 0 58144 A 10 C 1 1781 mini_artesia_wall_sconce_black_G37_mini_gooseneck3.jpg Barn Light Mini Artesia Sconce, 100-Black Finish, G37 Mini Straight Arm Gooseneck Arm | Photo Courtesy of Sasha from Small Town Farmhouse (www.smalltownfarmhouse.com) 1500 2001 58144
50055 61198 product 0 62288 A 11 C 0 0 mini_artesia_wall_sconce_black_G33_arm2.jpg Barn Light Mini Artesia Sconce, 100-Black, G33 Mini Straight Arm Gooseneck Arm | Photo Courtesy of Louise Swelstad 1500 1500 62288
60783 61198 product 0 73016 A 12 C 0 0 Barn_Light_Mini_Artesia_Wall_Sconce_-_Barn_Light_Electric_-_Farmhouse_Bathroom_Lighting.JPG Barn Light Mini Artesia Sconce, 615-Oil-Rubbed Bronze, G33 Mini Straight Arm Gooseneck Arm | Photo Courtesy of Hannah Duffey 1242 1207 73016
45910 61198 product 0 58143 A 13 C 0 0 Screen_Shot_2019-10-15_at_11.01.35_AM.png (3) Barn Light Mini Artesia Sconces, 975-Galvanized Finish, G33 Mini Straight Gooseneck Arms | Photo Courtesy of Sasha from Small Town Farmhouse (www.smalltownfarmhouse.com) 639 824 58143
48377 61198 product 0 60610 A 14 C 0 0 galvanized_wall_sconce_lighting.jpg Barn Light Mini Artesia Sconce, 975-Galvanized, G33 Mini Gooseneck Arm | Photo Courtesy of Homeowner 1066 710 60610
50056 61198 product 0 62289 A 15 C 0 0 mini_artesia_wall_sconce_black_G33arm.jpg Barn Light Mini Artesia Sconce, 100-Black, G33 Mini Straight Arm Gooseneck Arm | Photo Courtesy of Louise Swelstad 1536 2048 62289
59066 61198 product 0 71299 A 16 C 0 0 Canal_SoHo_Pendant_Light_-_Barn_Light_Electric_-_Industrial_Kitchen_Lighting_uzpe-nu.jpg Barn Light Mini Artesia Sconce, 100-Black, G33 Mini Straight Arm Gooseneck Arm (Also pictured: (2) Canal SoHo Pendants in 420-Orange) | Photo Courtesy of Workroom Design Studio and Lynn Graves Photography 1200 1800 71299
53714 61198 product 0 65947 A 17 C 0 0 BarnLight-Mini-Artesia-Wall-Sconce-Oil-Rubbed-Bronze.jpg Barn Light Mini Artesia Sconce, 615-Oil-Rubbed Bronze, G38 Mini Gooseneck Arm 1500 2250 65947
47773 61198 product 0 60006 A 18 C 0 0 barnlight-mini-artesia-wall-sconce-watermelon-bathroom.jpg Barn Light Mini Artesia Sconce, 490-Magenta Powder Coat, G33 Mini Straight Arm Gooseneck Arm | Photo Courtesy of MB Designs 1500 1000 60006
47772 61198 product 0 60005 A 19 C 0 0 barn-light-mini-artesia-wall-sconces-industrial-grey-bathroom-closeup.jpg Barn Light Mini Artesia Sconce, 800-Industrial Grey, G33 Mini Straight Arm Gooseneck Arm | Photo Courtesy of MB Designs 1500 1000 60005
62155 61198 product 0 74388 A 20 C 0 0 Barn_Light_Mini_Artesia_Wall_Sconce_390-Teal_G37arm__1_.jpeg Barn Light Mini Artesia Sconce, 390-Teal, G37 Arm 1500 2000 74388
66844 61198 product 0 79077 A 21 C 0 0 commercial-interior-lighting-on-retail-Barn-Light-Mini-Artesia-Wall-Sconce-495-Sherbet-OrangeG33arm-Life-Is-Good_wdqp-dq.jpg Barn Light Mini Artesia Wall Sconce, 795-Sherbert Orange, G33 Arm | Photo Courtesy of Life is Good 1500 1811 79077
66845 61198 product 0 79078 A 22 C 0 0 commercial-interior-lighting-on-retail-Barn-Light-Mini-Artesia-Wall-Sconce-495-Sherbet-OrangeG33arm-Life-Is-Good.jpg Barn Light Mini Artesia Wall Sconce, 795-Sherbert Orange, G33 Arm | Photo Courtesy of Life is Good 1500 1637 79078