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

Query time 0.00092

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": 17,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A'",
          "attached_condition": "cscart_images_links.object_id <=> 62174 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
30638 62174 product 0 42870 A 0 D 0 0 Brisbane-Gooseneck-12in-997-raw-brass-100-black-G15-CLR.jpg 12" Brisbane, 997-Natural Raw Brass, With Cap Option, Guard in 100-Black, CLR-Clear Glass, G15 Gooseneck Arm, Mounting in 100-Black 1000 1000 42870
66350 62174 product 0 78583 A 1 D 0 0 Brisbane-Gooseneck-16in-700-royal-200-white-G24-RIB.jpg 16" Brisbane, 700-Royal Blue, Guard in 200-White, RIB-Ribbed Glass, G24 Gooseneck Arm, Mounting in 200-White 1000 1000 78583
20233 62174 product 0 32049 A 2 D 0 0 Brisbane-Gooseneck-12in-490-magenta-100-black-G19-CLR.jpg 12" Brisbane, 490-Magenta, Guard in 100-Black, CLR-Clear Glass, G19 Gooseneck Arm, Mounting in 100-Black 1000 1000 32049
20232 62174 product 0 32048 A 3 D 0 0 Brisbane-Gooseneck-12in-100-black--975-galvanized-G12-CLR.jpg 12" Brisbane, 100-Black, CLR-Clear Glass, G12 Gooseneck Arm, Mounting in 975-Galvanized 1000 1000 32048
66348 62174 product 0 78581 A 4 D 0 0 Brisbane-Gooseneck-14in-200-white-100-black-CLR.jpg 14" Brisbane, 200-White, Guard in 100-Black, CLR-Clear Glass, G8 Gooseneck Arm, Mounting in 100-Black 1000 1000 78581
66351 62174 product 0 78584 A 5 D 0 0 Brisbane-Gooseneck-16in-705-navy-500-buttery-yellow-G65-RIB.jpg 16" Brisbane, 705-Navy, Guard in 500-Buttery Yellow, RIB-Ribbed Glass, G65 Gooseneck Arm 1000 1000 78584
66349 62174 product 0 78582 A 6 D 0 0 Brisbane-Gooseneck-14in-500-buttery-yellow-390-teal-G11-CLR.jpg 14" Brisbane, 500-Buttery Yellow, Guard in 390-Teal, CLR-Clear Glass, G11 Gooseneck Arm 1000 1000 78582
68018 62174 product 0 80251 A 7 C 0 0 image0-residential-exterior-lighting-barn-Brisbane-Gooseneck-14in-100-Black-G15arm-No-Cap-Clear-Glass.jpeg 14" Brisbane, 100-Black, G15 Arm, No Cap, Clear Glass | Customer Submission 2901 3307 80251
68749 62174 product 0 80982 A 8 C 0 0 IMG_8843-residential-interior-lighting-on-Brisbane-Gooseneck-14in-615-Oil-Rubbed-Bronze-G26arm-With-Cap-975-Galvanized-Ribbed-Glass.jpg 14" Brisbane, 615-Oil Rubbed Bronze, G26 Arm, With Cap, 975-Galvanized, Ribbed Glass | Customer Submission 3024 4032 80982
65041 62174 product 0 77274 A 9 C 0 0 PXL_20220606_residential-interior-bathroom-vanity-lighting-on-Brisbane-Gooseneck-14in-390-Teal-G11arm-No-Cap-Frosted-Glass.jpg 14" Brisbane Gooseneck, 390-Teal, G11 Arm, No Cap, Frosted Glass 3024 4032 77274
64059 62174 product 0 76292 A 10 C 0 0 IMG-0885-residential-interior-lighting-Brisbane-Gooseneck-14in-420-Orange-570-Sunflower-Guard-Cap-Clear-Glass.jpg 14" Brisbane Gooseneck, 420-Orange, 570-Sunflower Guard Cap, Clear Glass | Photo Courtesy of Homeowner 2448 3264 76292
59580 62174 product 0 71813 A 11 C 0 0 Brisbane_Gooseneck_Light_-_Barn_Light_Electric_-_Kids_Bathroom_Vanity_Lighting.jpg 12” Brisbane, 705-Navy Shade with 975-Galvanized Guard Finish, G3 Gooseneck Arm in 705-Navy, Frosted Glass | Photo Courtesy of Digs Design Company, Greg Premru Photography and Whitla Brothers Builders 3000 4500 71813
30639 62174 product 0 42871 A 12 C 0 0 gooseneck_lights-576x768.jpg 14" Brisbane, 600-Bronze with 400-Barn Red Guard, No Cap, CLR-Clear Glass, G22 Gooseneck Arm 576 768 42871
42520 62174 product 0 54753 A 13 C 0 0 MicrosoftTeams-image.png 12” Brisbane, 300-Dark Green, With Cap, G13 Gooseneck Arm 768 576 54753
42521 62174 product 0 54754 A 14 C 0 0 MicrosoftTeams-image__1_.png 12” Brisbane, 390-Teal, G16 Gooseneck Arm in 975-Galvanized Finish 768 584 54754
51668 62174 product 0 63901 A 15 C 0 0 20161209_141523.jpg 16” Brisbane, 600-Bronze with 400-Barn Red Guard, G22 Gooseneck Arm, Ribbed Glass | Photo Courtesy of Nathaniel Sides 4032 3024 63901
68207 62174 product 0 80440 A 16 C 0 0 image13-residential-exterior-lighting-on-garage-Brisbane-Industrial-Gooseneck-14in-200-White-G11-Clear-Glass-Dusk-to-Dawn-Photocell.jpeg 14" Brisbane, 200-White, G11 Arm, Clear Glass, Dawn to Dusk Photocell | Customer Submission 3719 3011 80440