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

Query time 0.00076

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": 12,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A'",
          "attached_condition": "cscart_images_links.object_id <=> 62623 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
66429 62623 product 0 78662 A 0 D 0 0 brisbane-chain-16in-100-black-200-white-rib-CSBW.jpg 16" Brisbane, 100-Black, Guard in 200-White, RIB-Ribbed Glass, Mounting in 200-White, CSBW-Black & White Cloth Cord 1000 1000 78662
66432 62623 product 0 78665 A 1 D 0 0 brisbane-chain-full-build-12in-307-emerald-green-CSGW-CLR.jpg 12" Brisbane, 307-Emerald Green, CLR-Clear Glass, CSGW-Gold & White Cloth Cord 1000 1000 78665
22652 62623 product 0 34550 A 2 D 0 0 brisbane-chain-12in-997-raw-brass-100-black-CLR-CSGW.jpg 12" Brisbane, 997-Natural Raw Brass, Guard in 100-Black, CLR-Clear Glass, Mounting in 100-Black, CSGW-Gold & White Cloth Cord 1000 1000 34550
66430 62623 product 0 78663 A 3 D 0 0 brisbane-chain-16in-200-white-rib-975-galvanized-CSW.jpg 16" Brisbane, 200-White, RIB-Ribbed Glass, Mounting in 975-Galvanized, CSW-White Cloth Cord 1000 1000 78663
29479 62623 product 0 41699 A 4 D 0 0 brisbane-chain-14in-705-navy-CRD-CLR.jpg 14" Brisbane, 705-Navy, CLR-Clear Glass, CSR-Red Cloth Cord 1000 1000 41699
66431 62623 product 0 78664 A 5 D 0 0 brisbane-chain-16in-390-teal-975-galvanized-CSBG-CLR.jpg 16" Brisbane, 390-Teal, Guard in 975-Galvanized, CLR-Clear Glass, Mounting in 975-Galvanized, CSBG-Black & Gold Cloth Cord 1000 1000 78664
22653 62623 product 0 34551 A 6 D 0 0 brisbane-chain-14in-400-barn-red-CRZ-CLR.jpg 14" Brisbane, 400-Barn Red, CLR-Clear Glass, CRZ-Red Chevron Cord 1000 1000 34551
58266 62623 product 0 70499 A 7 C 0 0 Brisbane_Chain_Hung_Pendant_-_200_White_Barn_Light_Electric_-_Exterior_Porch_Dining_Lighting.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 993 70499
58267 62623 product 0 70500 A 8 C 0 0 Brisbane_Chain_Hung_Pendants_-_200_White_Barn_Light_Electric_-_Modern_Porch_Lighting_Decor.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 1000 70500
58268 62623 product 0 70501 A 9 C 0 0 Brisbane_Chain_Hung_Pendant_Lights_-_200_White_Barn_Light_Electric_-_Modern_Lighting_Decor.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 2250 70501
58269 62623 product 0 70502 A 10 C 0 0 Brisbane_Chain_Hung_Pendant_Lights_-_200_White_Barn_Light_Electric_-_Modern_Exterior_Lighting.jpg 14” Brisbane, 200-White, 3’ Chain in 200-White, SWH-Standard White Cord, Clear Glass | Photo Courtesy of Pedro Porro Design 1500 983 70502
62173 62623 product 0 74406 A 11 C 0 0 Brisbane_Chain_Hung_Pendant_16in_600_Bronze_SBK_ClearGlass.jpg 16" Brisbane, 600-Bronze, CLR-Clear Glass, SBK-Standard Black Cord 1500 1125 74406