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 (63810, 64766, 64767, 63137) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00074

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": 25,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (63810,64766,64767,63137)"
        }
      }
    },
    "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
24411 63137 product 0 36392 A 0 D 0 0 Canal-soho-Chandelier-Linear-3-Light-490-magenta-100-black.jpg Canal SoHo 3-Light, 490-Magenta, Mounting in 100-Black 1000 1000 36392
27411 63810 product 0 39588 A 0 D 0 0 Parson-5-Arm-Barn-Red-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 400-Barn Red, Nostalgic Edison 1890 Era Bulbs 1000 1000 39588
27413 63810 product 0 39590 A 0 D 0 0 Parson-5-Arm-Delphite-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 715-Delphite Blue PTMP, Nostalgic Edison 1890 Era Bulbs 1000 1000 39590
27414 63810 product 0 39591 A 0 D 0 0 Parson-5-Arm-Magenta-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 490-Magenta, Nostalgic Edison 1890 Era Bulbs 1000 1000 39591
30074 63810 product 0 42297 A 0 D 0 0 Parson-5-Arm-Brass-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 997-Natural Raw Brass, Nostalgic Edison 1890 Era Bulbs 1000 1000 42297
30154 63810 product 0 42377 A 0 D 0 0 Parson-5-Arm-Black-Chandelier-1890-Era-Bulb.jpg Parson Adjustable Arm Chandelier, 100-Black, Nostalgic Edison 1890 Era Bulbs 1000 1000 42377
40944 64766 product 0 53177 A 0 D 0 0 Parabolic-Linear-Chandelier-Oil-Rubbed-Bronze-Weathered-Copper-Edison-Bulb.jpg Parabolic Linear 8-Light Chandelier, 996-Natural Weathered Copper, Mounting in 615-Oil-Rubbed Bronze | Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53177
40948 64767 product 0 53181 A 0 D 0 0 Parabolic-Linear-Chandelier-12-Light-Teal-Edison-Bulb.jpg Parabolic Linear 12-Light Chandelier, 390-Teal | Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53181
24410 63137 product 0 36391 A 1 D 0 0 Canal-soho-Chandelier-Linear-3-Light-300-dark-green.jpg Canal SoHo 3-Light, 300-Dark Green 1000 1000 36391
40947 64766 product 0 53180 A 1 D 0 0 Parabolic-Linear-Chandelier-8-Light-8-Light-Galvanized-Barn-Red-Edison-Bulb.jpg Parabolic Linear 8-Light Chandelier, 400-Barn Red, Mounting in 975-Galvanized | Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53180
40949 64767 product 0 53182 A 1 D 0 0 Parabolic-Linear-Chandelier-12-Light-Barn-Red-Edison-Bulb.jpg Parabolic Linear 12-Light Chandelier, 400-Barn Red | Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53182
40943 64767 product 0 53176 A 2 C 0 0 iStock-841565654-residential-parabolic-chandelier-bronze-oil-rubbed-bronze-bar-living-room.jpg Parabolic Linear 12-Light Chandelier, 600-Bronze 1000 667 53176
40945 64766 product 0 53178 A 2 D 0 0 Parabolic-Linear-Chandelier-8-Light-Delphite-Half-Chrome-Bulb.jpg Parabolic Linear 8-Light Chandelier, 715-Delphite Blue | Shown with Nostalgic Edison-Style Victorian Bulbs| Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53178
64057 63137 product 0 76290 A 2 D 0 0 Canal-soho-Chandelier-Linear-3-Light-705-navy-975-galvanized.jpg Canal SoHo 3-Light, 705-Navy, Mounting in 975-Galvanized, Hang Straight Canopy 1000 1000 76290
24412 63137 product 0 36393 A 3 D 0 0 Canal-soho-Chandelier-Linear-3-Light-100-black.jpg Canal SoHo 3-Light, 100-Black, Heavy Duty Canopy 1000 1000 36393
40942 64767 product 0 53175 A 3 C 0 0 iStock-944581626-residential-kitchen-parabolic-chandelier-12-light-copper.jpg Parabolic Linear 12-Light Chandelier, 995-Natural Raw Copper, Mounting in 200-White 1000 667 53175
40946 64766 product 0 53179 A 3 D 0 0 Parabolic-Linear-Chandelier-8-Light-Oil-Rubbed-Bronze-Weathered-Brass-Edison-Bulb.jpg Parabolic Linear 8-Light Chandelier, 998-Weathered Brass, Mounting in 600-Bronze | Shown with Nostalgic Edison-Style Victorian Bulbs 1000 1000 53179
24409 63137 product 0 36390 A 4 D 0 0 Canal-soho-Chandelier-Linear-3-Light-400-barn-red.jpg Canal SoHo 3-Light, 400-Barn Red 1000 1000 36390
40938 64766 product 0 53171 A 4 C 0 0 iStock-865710540-residential-kitchen-bar-living-room-parabolic-chandelier-galvanized.jpg Parabolic Linear 8-Light Chandelier, 975-Galvanized 1000 667 53171
40941 64767 product 0 53174 A 4 C 0 0 2V3A0261-Fenway-hotel-commercial-parabolic-concierge-front-desk-12-light-custom-chandelier.jpg Parabolic Linear 12-Light Chandelier, 998-Natural Weathered Brass with Custom White Interior, Mounting in 100-Black 900 1222 53174
67475 63137 product 0 79708 A 4 C 0 0 109-residential-interior-lighting-kitchen-island-Canal-SoHo-3-Light-Chandelier-307-Emerald-Green-18in-Stem.jpg Canal SoHo 3-Light, 307-Emerald Green, 18" Stem | Photo Courtesy of Southbound Stays 6016 4016 79708
67476 63137 product 0 79709 A 4 C 0 0 Closeup-residential-interior-lighting-kitchen-Canal-SoHo-3-Light-Chandelier-307-Emerald-Green-18in-Stem-Conoco-Stem-Loop-Pendant-12in-307-Emerald-Green-Black-Cotton-Twist.jpg Canal SoHo 3-Light, 307-Emerald Green, 18" Stem | Photo Courtesy of Southbound Stays 6021 4020 79709
67477 63137 product 0 79710 A 4 C 0 0 residential-interior-lighting-kitchen-Canal-SoHo-3-Light-Chandelier-307-Emerald-Green-18in-Stem-Conoco-Stem-Loop-Pendant-12in-307-Emerald-Green-Black-Cotton-Twist-18in-stem.jpg Canal SoHo 3-Light, 307-Emerald Green, 18" Stem | Photo Courtesy of Southbound Stays 6016 4016 79710
67478 63137 product 0 79711 A 4 C 0 0 Kitchen_IntoDining-residential-interior-lighting-kitchen-island-Canal-SoHo-3-Light-Chandelier-307-Emerald-Green-18in-Stem.jpg Canal SoHo 3-Light, 307-Emerald Green, 18" Stem | Photo Courtesy of Southbound Stays 6023 4020 79711
40940 64766 product 0 53173 A 5 C 0 0 residential-dining-room-parabolic-chandelier-8-light-porcelain-green-black.jpg Parabolic Linear 8-Light Chandelier, 307-Emerald Green, Mounting in 100-Black 1000 667 53173