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 (65466, 65475, 65477, 65480) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00074

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": 27,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65466,65475,65477,65480)"
        }
      }
    },
    "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
66529 65466 product 0 78762 A 0 D 0 0 Bridgeport-flush-mount-16in-975-galvanized-CGG-FST-alt.jpg 16" Bridgeport, 975-Galvanized, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 78762
66530 65466 product 0 78763 A 0 D 0 0 Bridgeport-flush-mount-12in-300-dark-green-CGG-RIB-alt.jpg 12" Bridgeport, 300-Dark Green, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 78763
66531 65466 product 0 78764 A 0 D 0 0 Bridgeport-flush-mount-12in-490-magenta-100-black-WGG-RIB-alt.jpg 12" Bridgeport, 490-Magenta, WGG-Wire Guard, 100-Black, RIB-Ribbed Glass, Mounting in 100-Black 1000 1000 78764
66532 65466 product 0 78765 A 0 D 0 0 Bridgeport-flush-mount-12in-700-royal-blue-200-white-CGG-RIB-alt.jpg 12" Bridgeport, 700-Royal Blue, CGG-Standard Cast Guard, RIB-Ribbed Glass, Mounting in 200-White 1000 1000 78765
66533 65466 product 0 78766 A 0 D 0 0 Bridgeport-flush-mount-14in-200-white-CGG-RIB-alt.jpg 14" Bridgeport, 200-White, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 78766
66534 65466 product 0 78767 A 0 D 0 0 Bridgeport-flush-mount-16in-100-black-TGG-FST-alt.jpg 16" Bridgeport, 100-Black, TGG-Heavy Duty Cast Guard, FST-Frosted Glass 1000 1000 78767
66535 65466 product 0 78768 A 0 D 0 0 Bridgeport-flush-mount-16in-400-barn-red-CGG-FST-alt.jpg 16" Bridgeport, 400-Barn Red, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 78768
66865 65480 product 0 79098 A 0 D 0 0 syracuse-flush-12in-200-white-CGG-FST_153c-af.jpg 12" Syracuse LED, 200-White, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79098
66866 65480 product 0 79099 A 0 D 0 0 syracuse-flush-12in-500-buttery-yellow-975-galvanized-CGG-RIB_nwdt-64.jpg 12" Syracuse LED, 500-Buttery Yellow, Mounting in 975-Galvanized, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 79099
66867 65480 product 0 79100 A 0 D 0 0 syracuse-flush-mount-14in-400-barn-red-CGG-FST_uabk-g4.jpg 14" Syracuse LED, 400-Barn Red, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79100
66868 65480 product 0 79101 A 0 D 0 0 syracuse-flush-mount-14in-700-royal-blue-CGG-RIB_li4p-qb.jpg 14" Syracuse LED, 700-Royal Blue, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 79101
66869 65480 product 0 79102 A 0 D 0 0 syracuse-flush-mount-16in-350-vintage-green-975-galvanized-WGG-FST_uf5r-5z.jpg 16" Syracuse LED, 350-Porcelain Vintage Green, Mounting in 975-Galvanized, WGG-Wire Guard, FST-Frosted Glass 1000 1000 79102
66870 65480 product 0 79103 A 0 D 0 0 syracuse-flush-mount-16in-975-galvanized-TGG-RIB_ycva-jd.jpg 16" Syracuse LED, 975-Galvanized, TGG-Heavy Duty Cast Guard, RIB-Ribbed Glass 1000 1000 79103
66871 65480 product 0 79104 A 0 D 0 0 syracuse-flush-mount-18in-705-navy-490-magenta-CGG-RIB_w05m-3z.jpg 18" Syracuse LED, 705-Navy, Mounting in 490-Magenta, CGG-Standard Cast Guard, RIB-Ribbed Glass 1000 1000 79104
66943 65477 product 0 79176 A 0 D 0 0 rochester-flush-mount-14in-300-dark-green-CGG-FST_0bwu-3b.jpg 14" Rochester LED, 300-Dark Green, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79176
66961 65475 product 0 79194 A 0 D 0 0 chicago-flush-mount-12in-975-galvanized-CGG-FST_mg9i-cd.jpg 12" Chicago LED, 975-Galvanized, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79194
66944 65477 product 0 79177 A 1 D 0 0 rochester-flush-mount-14in-390-teal-975-galvanized-CGG-RIB_cxm6-bv.jpg 14" Rochester LED, 390-Teal, Mounting in 975-Galvanized, CGG-Standard Cast Guard, 975-Galvanized, RIB-Ribbed Glass 1000 1000 79177
66966 65475 product 0 79199 A 1 D 0 0 chicago-flush-mount-20in-390-teal-975-galvanized-CGG-FST_kmed-n1.jpg 20" Chicago LED, 390-Teal, Mounting in 975-Galvanized, CGG-Standard Cast Guard, 975-Galvanized, FST-Frosted Glass 1000 1000 79199
66947 65477 product 0 79180 A 2 D 0 0 rochester-flush-mount-18in-400-barn-red-CGG-FST_uc70-2a.jpg 18" Rochester, 400-Barn Red, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79180
66962 65475 product 0 79195 A 2 D 0 0 chicago-flush-mount-16in-400-barn-red-CGG-FST_43q0-a0.jpg 16" Chicago LED, 400-Barn Red, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79195
66946 65477 product 0 79179 A 3 D 0 0 rochester-flush-mount-16in-765-delphite-100-black-WGG-RIB_khlf-mw.jpg 16" Rochester, 765-Porcelain Delphite, Mounting in 150-Black, WGG-Wire Guard, RIB-Ribbed Glass 1000 1000 79179
66965 65475 product 0 79198 A 3 D 0 0 chicago-flush-mount-20in-100-black-TGG-RIB_fbuo-ij.jpg 20" Chicago LED, 100-Black, TGG-Heavy Duty Cast Guard, RIB-Ribbed Glass 1000 1000 79198
66942 65477 product 0 79175 A 4 D 0 0 rochester-flush-mount-12in-800-industrial-grey-400-barn-red-TGG-RIB_3kqf-y1.jpg 12" Rochester LED, 800-Industrial Guard, Mounting in 400-Barn Red, TGG-Heavy Duty Cast Guard, RIB-Ribbed Glass 1000 1000 79175
66963 65475 product 0 79196 A 4 D 0 0 chicago-flush-mount-16in-700-royal-blue-200-white-CGG-RIB_m00v-29.jpg 16" Chicago LED, 700-Royal Blue, Mounting in 200-White, CGG-Standard Cast Guard, 200-White, RIB-Ribbed Glass 1000 1000 79196
66948 65477 product 0 79181 A 5 D 0 0 rochester-flush-mount-18in-975-galvanized-TGG-FST_73k9-p4.jpg 18" Rochester, 975-Galvanized, TGG-Heavy Duty Cast Guard, FST-Frosted Glass 1000 1000 79181
66964 65475 product 0 79197 A 5 D 0 0 chicago-flush-mount-18in-350-vintage-green-100-black-WGG-RIB_sg3k-f9.jpg 18" Chicago LED, 350-Porcelain Vintage Green, WGG-Wire Guard, 150-Black, RIB-Ribbed Glass 1000 1000 79197
66945 65477 product 0 79178 A 6 D 0 0 rochester-flush-mount-16in-200-white-CGG-FST_z5rx-9d.jpg 16" Rochester, 200-White, CGG-Standard Cast Guard, FST-Frosted Glass 1000 1000 79178