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 = 62435 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00089

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": "ref",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "ref": ["const", "const", "const"],
          "rows": 13,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A'",
          "attached_condition": "cscart_images_links.object_id <=> 62435 and cscart_images_links.object_type <=> 'product' and cscart_images_links.`type` <=> 'A'"
        }
      }
    },
    "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
21773 62435 product 0 33655 A 0 D 0 0 uplight-14-inch-chain-hung-pendant-400-red-red-white-cloth_wire-cage.jpg 14" Wilcox Uplight, 400-Barn Red Shade and Chain Finish, Red & White Cloth Cord, Wire Cage in 975-Galvanized 600 600 33655
21777 62435 product 0 33659 A 1 D 0 0 Wilcox-Uplight-Chain-Hung-Green-White-Cord.jpg 16" Wilcox Uplight, 300-Dark Green Shade Finish, 200-White Chain Finish & Standard White Cord 1000 1000 33659
21778 62435 product 0 33660 A 2 D 0 0 Wilcox-Uplight-Chain-Hung-Bronze-Black-Cord.jpg 18" Wilcox Uplight, 600-Bronze Shade Finish, 100-Black Chain Finish & Standard Black Cord 1000 1000 33660
21775 62435 product 0 33657 A 3 D 0 0 uplight-12-inch-chain-hung-pendant-100-black-black-pink-cloth.jpg 12" Wilcox Uplight, 100-Black Shade and Chain Finish, Black & Pink Cloth Cord 600 600 33657
21776 62435 product 0 33658 A 4 D 0 0 uplight-16-inch-chain-hung-pendant-975-galvanized-black-gold-cloth.jpg 16" Wilcox Uplight, 975-Galvanized Shade and Chain Finish, Black & Gold Cloth Cord 600 600 33658
21774 62435 product 0 33656 A 5 D 0 0 uplight-14_-inch-chain-hung-pendant-200-white-blue-white-cloth.jpg 14" Wilcox Uplight, 200-White Shade and Chain Finish, Blue & White Cloth Cord 600 600 33656
47879 62435 product 0 60112 A 6 D 0 0 Wilcox-Uplight-Chain-Hung-Industrial-Grey-Barn-Red-Brown-Cord.jpg 18” Wilcox Uplight, 800-Industrial Grey Shade Finish, 400-Barn Red Chain Finish, Brown & Black Chevron Cord 1000 1000 60112
67869 62435 product 0 80102 A 7 C 0 0 PXL_20230324_140031482-commercial-interior-lighting-on-restaurant-Wilcox-Uplight-Chain-Hung-Pendant-20in-570-Sunflower-SBK.jpg 20" Wilcox Uplight Chain Hung Pendant, 570- Sunflower, Standard Black Cord | Photo Courtesy of Wafel & Dinges 3024 4032 80102
60049 62435 product 0 72282 A 8 C 0 0 Wilcox_Uplight_Chain_Hung_Pendant_-_200_White_Barn_Light_Electric_-_Modern_Farmhouse_Kitchen_Lighting.jpg 18” Wilcox Uplight, 200-White, CMG-Grey Cloth Cord, White Chain | Photo Courtesy of Ashley Schoenith - Heirloomed Collection 1500 2250 72282
60050 62435 product 0 72283 A 9 C 0 0 Wilcox_Uplight_Chain_Hung_Pendant_-_200_White_Barn_Light_Electric_-_Farmhouse_Kitchen_Lighting.jpg 18” Wilcox Uplight, 200-White, CMG-Grey Cloth Cord, White Chain | Photo Courtesy of Ashley Schoenith - Heirloomed Collection 1500 2250 72283
57027 62435 product 0 69260 A 10 C 0 0 Wilcox_Uplight_Chain_Hung_Pendant_-_Barn_Light_Electric_-_Farmhouse_Barn_Lighting.png 18” Wilcox Uplight, 105-Textured Black, SBK-Standard Black Cord | Photo Courtesy of Homeowner 428 576 69260
60051 62435 product 0 72284 A 11 C 0 0 Wilcox_Uplight_Chain_Hung_Pendant_-_Barn_Light_Electric_-_200_White_Farmhouse_Kitchen_Lighting.jpg 18” Wilcox Uplight, 200-White, CMG-Grey Cloth Cord, White Chain (Also pictured: Dominion Wall Sconce) | Photo Courtesy of Ashley Schoenith - Heirloomed Collection 1500 2250 72284
60052 62435 product 0 72285 A 12 C 0 0 Wilcox_Uplight_Chain_Hung_Pendant_-_200_White_Barn_Light_Electric_-_Kitchen_Lighting.jpg 18” Wilcox Uplight, 200-White, CMG-Grey Cloth Cord, White Chain (Also pictured: Dominion Wall Sconce) | Photo Courtesy of Ashley Schoenith - Heirloomed Collection 1500 1000 72285