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 = 64824 
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": 26,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A'",
          "attached_condition": "cscart_images_links.object_id <=> 64824 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
40927 64824 product 0 53160 A 0 D 0 0 ivanhoe_mig_355_jadte.jpg Mig Pendant, 311-Jadite, SBK-Standard Black Cord 600 684 53160
40913 64824 product 0 53146 A 1 D 0 0 mig-retro-blue.jpg Mig Pendant, 775-Blue 600 600 53146
40914 64824 product 0 53147 A 3 D 0 0 mig-retro-brown.jpg Mig Pendant, 675-Brown, SBK-Standard Black Cord 600 600 53147
40916 64824 product 0 53149 A 4 D 0 0 mig-retro-jadite.jpg Mig Pendant, 376-Jadite, SBK-Standard Black Cord 600 600 53149
40915 64824 product 0 53148 A 5 D 0 0 mig-retro-green.jpg Mig Pendant, 375-Dark Green, SBK-Standard Black Cord 600 600 53148
40926 64824 product 0 53159 A 6 D 0 0 ivanhoe_mig_250_white.jpg Mig Pendant, 200-White, SBK-Standard Black Cord 600 684 53159
40917 64824 product 0 53150 A 7 D 0 0 mig-retro-red.jpg Mig Pendant, 475-Red, SBK-Standard Black Cord 600 600 53150
40925 64824 product 0 53158 A 8 D 0 0 Green_Porcelain_Mig-resize.jpg Mig Pendant, 350-Vintage Green, SBK-Standard Black Cord 1315 1315 53158
40919 64824 product 0 53152 A 9 D 0 0 mig-retro-orange.jpg Mig Pendant, 476-Burnt Orange, SBK-Standard Black Cord 600 600 53152
40918 64824 product 0 53151 A 12 D 0 0 mig-retro-yellow.jpg Mig Pendant, 575-Yellow, SBK-Standard Black Cord 600 600 53151
56633 64824 product 0 68866 A 14 C 0 0 mig_pendant_light_550_porcelain_yellow_SBK.jpg Mig Pendant, 550-Yellow, SBK-Standard Black Cord | Photo Courtesy of fc STUDIO inc and Katrina Wittcamp Photography 1500 2087 68866
40980 64824 product 0 53213 A 15 C 0 0 mig-black.jpg (3) Mig Pendants, 875-Grey Retro Spray, CSB-Black Cloth Cord | Photo Courtesy of John Colaneri 1500 1000 53213
56634 64824 product 0 68867 A 16 C 0 0 mig_pendant_light_550_porcelain_yellow_SBK2.jpg Mig Pendant, 550-Yellow, SBK-Standard Black Cord | Photo Courtesy of fc STUDIO inc and Katrina Wittcamp Photography 1500 1000 68867
40922 64824 product 0 53155 A 17 C 0 0 migs-red-brown-jadite-bluejpg.jpg (6) Mig Pendants, (2) 475-Red, (2) 775-Blue, (1) 376-Jadite, (1) 675-Brown 1500 2000 53155
62892 64824 product 0 75125 A 19 C 0 0 4M5A1221-Commercial-Interior-Restaurant-BBQ-Mig-Cord-475-Red-Retro-Spray.jpg Mig Pendant, 475-Red Retro Spray, SBK-Standard Black Cord 1500 2250 75125
40931 64824 product 0 53164 A 20 C 0 0 ivanhoe_mig_porcelain_pendant_delphite_blue.jpg Mig Pendant, 715-Delphite Blue, CSUW-Blue & White Cloth Cord | Customer Submission 1280 855 53164
40920 64824 product 0 53153 A 21 C 0 0 industrial_ceiling_lights__768x1024_.jpg (2) Mig Pendants, 875-Grey, SBK-Standard Black Cord | Photo Courtesy of Candent Design 768 1024 53153
40921 64824 product 0 53154 A 22 C 0 0 The_Mig_Retro_Industrial_Steel_Pendant.jpg (2) Mig Pendants, 875-Grey, SBK-Standard Black Cord | Photo Courtesy of Candent Design 922 692 53154
40934 64824 product 0 53167 A 23 C 0 0 mig_pendant_porch.jpg Mig Pendant, 200-White | Tybee Island, GA 600 840 53167
40932 64824 product 0 53165 A 24 C 0 0 reynolds-jamie-ivanhoe_mig_yellow_chevron_room_2.jpg Mig Pendant, 570-Sunflower | Photo Courtesy of Jamie Reynolds 500 332 53165
40933 64824 product 0 53166 A 25 C 0 0 mig_pendant_lighting_restaurant_lights-768x576.jpg Mig Pendant, 715-Delphite Blue, CSUW-Blue & White Cloth Cord | Customer Submission 768 576 53166
40977 64824 product 0 53210 A 26 C 0 0 DSC00348__680x1024_.jpg Mig Pendant, 575-Yellow, SBK-Standard Black Cord 680 1024 53210
62893 64824 product 0 75126 A 27 C 0 0 DSCF1840-Commercial-Interior-Restaurant-BBQ-Mig-Cord-475-Red-Retro-Spray.jpg Mig Pendant, 475-Red Retro Spray, SBK-Standard Black Cord 1500 2250 75126
60081 64824 product 0 72314 A 28 C 0 0 Mig_Pendant_Light_-_Barn_Light_Electric_-_Farmhouse_Kitchen_Lighting.jpg Mig Pendant, 475-Red Retro Spray, SBK-Standard Black Cord | Photo Courtesy of Kelley Ash and Hovel Design Studio 962 962 72314
40979 64824 product 0 53212 A 29 C 0 0 54af49eb3f064be81410755dce01cc28.jpg (4) Mig Pendants, 875-Grey, CSB - Black Cloth Cord 564 423 53212
40981 64824 product 0 53214 A 30 C 0 0 vintage_industrial_lighting_mig_pendants.jpg Mig Pendant, 875-Grey, Red & White Chevron Twist-TRW 720 479 53214