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 (65299, 65300, 65301, 65425) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00086

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": 32,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65299,65300,65301,65425)"
        }
      }
    },
    "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
56544 65299 product 0 68777 A 0 D 0 0 aero-flush-mount-12in-997-raw-brass-200-white.jpg 12" Aero, 997-Natural Raw Brass, Mounting in 200-White 1000 1000 68777
59108 65300 product 0 71341 A 0 D 0 0 conoco-flush-mount-15in-480-blush-pink-975-galvanized.jpg 15" Conoco, 480-Blush Pink, Mounting in 975-Galvanized, Nostalgic Edison-Style 1910 Era 60 Watt Light Bulb 1000 1000 71341
59131 65425 product 0 71364 A 0 D 0 0 marathon-flush-mount-16in-307-emerald-WC.jpg 16" Marathon, 307-Emerald Green, Wire Cage 1000 1000 71364
63560 65301 product 0 75793 A 0 D 0 0 dominion-flush-mount-16in-995-raw-copper-100-black-TGG-RIB_322h-eb.jpg 16" Dominion, 995-Natural Raw Copper, TGG-Heavy Duty Cast Guard, 100-Black, RIB-Ribbed Glass, Mounting in 100-Black 1000 1000 75793
56548 65299 product 0 68781 A 1 D 0 0 aero-flush-mount-16in-200-white-TGG-100-Black-FST.jpg 16" Aero, 200-White, TGG-Heavy Duty Cast Guard, 100-Black, FST-Frosted Glass, Mounting in 100-Black 1000 1000 68781
56614 65301 product 0 68847 A 1 D 0 0 dominion-flush-mount-14in-350-vintage-green.jpg 14" Dominion, 350-Porcelain Vintage Green 1000 1000 68847
59106 65300 product 0 71339 A 1 D 0 0 conoco-flush-mount-12in-100-black.jpg 12" Conoco, 100-Black, Nostalgic Edison-Style Victorian 40 Watt Light Bulb 1000 1000 71339
59128 65425 product 0 71361 A 1 D 0 0 marathon-flush-mount-12in-997-brass-100-black.jpg 12" Marathon, 997-Natural Raw Brass, Mounting in 100-Black, Shown with LED Edison A19 Bulb 1000 1000 71361
56547 65299 product 0 68780 A 2 D 0 0 aero-flush-mount-14in-705-navy.jpg 14" Aero, 705-Navy 1000 1000 68780
56560 65300 product 0 68793 A 2 D 0 0 conoco-flush-mount-10in-250-white-100-black.jpg 10" Conoco, 250-Porcelain White, Mounting in 150-Black, Nostalgic Edison-Style 1910 Era 60 Watt Light Bulb 1000 1000 68793
59129 65425 product 0 71362 A 2 D 0 0 marathon-flush-mount-14in-250-white.jpg 14" Marathon, 250-Porcelain White, Shown with Nostalgic Edison 40W G30 Bulb 1000 1000 71362
63559 65301 product 0 75792 A 2 D 0 0 dominion-flush-mount-16in-975-galvanized-WC.jpg 16" Dominion, 975-Galvanized, Wire Cage 1000 1000 75792
56561 65300 product 0 68794 A 3 D 0 0 conoco-flush-mount-10in-765-delphite.jpg 10" Conoco, 765-Porcelain Delphite, Nostalgic Edison-Style Victorian 40 Watt Light Bulb 1000 1000 68794
56615 65301 product 0 68848 A 3 D 0 0 dominion-flush-mount-14in-400-barn-red-TGG-FST.jpg 14" Dominion, 400-Barn Red, TGG-Heavy Duty Cast Guard, FST-Frosted Glass 1000 1000 68848
59079 65299 product 0 71312 A 3 D 0 0 aero-flush-mount-16in-975-galvanized.jpg 16" Aero, 975-Galvanized 1000 1000 71312
59127 65425 product 0 71360 A 3 D 0 0 marathon-flush-mount-12in-400-barn-red.jpg 12" Marathon, 400-Barn Red, Shown with LED Edison G25 Bulb 1000 1000 71360
56546 65299 product 0 68779 A 4 D 0 0 aero-flush-mount-14in-300-dark-green-WC-975-galvanized.jpg 14" Aero, 300-Dark Green, Wire Cage, 975-Galvanized 1000 1000 68779
56612 65301 product 0 68845 A 4 D 0 0 dominion-flush-mount-12in-100-black.jpg 12" Dominion, 100-Black 1000 1000 68845
59107 65300 product 0 71340 A 4 D 0 0 conoco-flush-mount-12in-400-barn-red.jpg 12" Conoco, 400-Barn Red, Nostalgic Edison-Style 1910 Era 60 Watt Light Bulb 1000 1000 71340
59130 65425 product 0 71363 A 4 D 0 0 marathon-flush-mount-14in-500-buttery-yellow-200-white.jpg 14" Marathon, 500-Buttery Yellow, Mounting in 200-White, Shown with LED Edison S14 Bulb 1000 1000 71363
56562 65300 product 0 68795 A 5 D 0 0 conoco-flush-mount-10in-975-galvanized.jpg 10" Conoco, 975-Galvanized, Nostalgic Edison-Style Victorian 40 Watt Light Bulb 1000 1000 68795
59078 65299 product 0 71311 A 5 D 0 0 aero-flush-mount-14in-500-buttery-yellow.jpg 14" Aero, 500-Buttery Yellow 1000 1000 71311
59118 65301 product 0 71351 A 5 D 0 0 dominion-flush-mount-16in-200-white-CGG-100-black-FST.jpg 16" Dominion, 200-White, CGG-Standard Cast Guard, 100-Black, FST-Frosted Glass, Mounting in 100-Black 1000 1000 71351
64010 65425 product 0 76243 A 5 D 0 0 marathon-flush-mount-16in-975-galvanized-CGG-FST-400-Barn-Red.jpg 16" Marathon, 975-Galvanized, CGG-Standard Cast Guard, 400-Barn Red, FST-Frosted Glass 1000 1000 76243
56616 65301 product 0 68849 A 6 D 0 0 dominion-flush-mount-14in-480-blush-pink.jpg 14" Dominion, 480-Blush Pink, Mounting in 975-Galvanized 1000 1000 68849
59077 65299 product 0 71310 A 6 D 0 0 aero-flush-mount-12in-400-barn-red.jpg 12" Aero, 400-Barn Red 1000 1000 71310
64009 65425 product 0 76242 A 6 D 0 0 marathon-flush-mount-16in-705-Navy.jpg 16" Marathon, 705-Navy, Shown with Globe LED Tala Lamp 1000 1000 76242
65068 65300 product 0 77301 A 6 D 0 0 conoco-flush-mount-15in-500-buttery-yellow-200-white.jpg 15" Conoco, 500-Buttery Yellow, Mounting in 200-White, Nostalgic Edison-Style Victorian 40 Watt Light Bulb 1000 1000 77301
65730 65425 product 0 77963 A 6 C 0 0 BarnLight1-residential-interior-lighting-kitchen-dining-Downtown-Minimalist-6-Light-Chandelier-480-Blush-Pink-SWH-Marathon-Flush-Mount-16in-480-Blush-Pink.jpg 16" Marathon, 480-Blush Pink 2048 1365 77963
59119 65301 product 0 71352 A 7 D 0 0 dominion-flush-mount-16in-705-navy-CGG-RIB.jpg 16" Dominion, 705-Navy, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 71352
63561 65301 product 0 75794 A 8 D 0 0 dominion-flush-mount-16in-997-raw-brass-200-white.jpg 16" Dominion, 997-Natural Raw Brass, Mounting in 200-White 1000 1000 75794
56613 65301 product 0 68846 A 9 D 0 0 dominion-flush-mount-12in-370-mint-200-white-CGG-FST.jpg 12" Dominion, 370-Mint, CGG-Standard Cast Guard, FST-Frosted Glass, Mounting in 200-White 1000 1000 68846