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.image_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 (
    65703, 65684, 65705, 65704, 65686, 65701, 
    65698, 65700, 65691, 65685, 65688, 
    65694
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00134

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": 69,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65703,65684,65705,65704,65686,65701,65698,65700,65691,65685,65688,65694)"
        }
      }
    },
    "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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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
66913 65684 product 0 79146 A 0 D 0 0
66921 65686 product 0 79154 A 0 D 0 0
67047 65698 product 0 79280 A 0 D 0 0
67048 65698 product 0 79281 A 0 D 0 0
67049 65698 product 0 79282 A 0 D 0 0
67057 65691 product 0 79290 A 0 D 0 0
67074 65685 product 0 79307 A 0 D 0 0
67081 65688 product 0 79314 A 0 D 0 0
67082 65688 product 0 79315 A 0 D 0 0
67083 65688 product 0 79316 A 0 D 0 0
67093 65694 product 0 79326 A 0 D 0 0
67094 65694 product 0 79327 A 0 D 0 0
67095 65694 product 0 79328 A 0 D 0 0
67248 65688 product 0 79481 A 0 C 0 0
67269 65705 product 0 79502 A 0 D 0 0
67273 65700 product 0 79506 A 0 D 0 0
67277 65703 product 0 79510 A 0 D 0 0
67278 65703 product 0 79511 A 0 D 0 0
67279 65703 product 0 79512 A 0 D 0 0
67283 65701 product 0 79516 A 0 D 0 0
67287 65704 product 0 79520 A 0 D 0 0
67977 65703 product 0 80210 A 0 C 0 0
67978 65703 product 0 80211 A 0 C 0 0
68596 65703 product 0 80829 A 0 C 0 0
68597 65703 product 0 80830 A 0 C 0 0
66908 65684 product 0 79141 A 1 D 0 0
66915 65685 product 0 79148 A 1 D 0 0
67058 65691 product 0 79291 A 1 D 0 0
67071 65686 product 0 79304 A 1 D 0 0
67270 65705 product 0 79503 A 1 D 0 0
67274 65700 product 0 79507 A 1 D 0 0
67281 65701 product 0 79514 A 1 D 0 0
67286 65704 product 0 79519 A 1 D 0 0
67059 65691 product 0 79292 A 2 D 0 0
67072 65686 product 0 79305 A 2 D 0 0
67073 65684 product 0 79306 A 2 D 0 0
67075 65685 product 0 79308 A 2 D 0 0
67271 65705 product 0 79504 A 2 D 0 0
67275 65700 product 0 79508 A 2 D 0 0
67282 65701 product 0 79515 A 2 D 0 0
67285 65704 product 0 79518 A 2 D 0 0
68586 65701 product 0 80819 A 2 C 0 0
68587 65701 product 0 80820 A 2 C 0 0
68588 65701 product 0 80821 A 2 C 0 0
68589 65701 product 0 80822 A 2 C 0 0
66923 65686 product 0 79156 A 3 C 0 0
67122 65700 product 0 79355 A 3 C 0 0
67176 65705 product 0 79409 A 3 C 0 0
67258 65685 product 0 79491 A 3 C 0 0
68019 65684 product 0 80252 A 3 C 0 0
66910 65684 product 0 79143 A 4 C 0 0
66922 65686 product 0 79155 A 4 C 0 0
67177 65705 product 0 79410 A 4 C 0 0
67241 65686 product 0 79474 A 4 C 0 0
67242 65686 product 0 79475 A 4 C 0 0
67257 65685 product 0 79490 A 4 C 0 0
68551 65700 product 0 80784 A 4 C 0 0
67244 65684 product 0 79477 A 5 C 0 0
67255 65685 product 0 79488 A 5 C 0 0
68553 65700 product 0 80786 A 5 C 0 0
68590 65705 product 0 80823 A 5 C 0 0
67178 65705 product 0 79411 A 6 C 0 0
67243 65684 product 0 79476 A 6 C 0 0
67256 65685 product 0 79489 A 6 C 0 0
68552 65700 product 0 80785 A 6 C 0 0
68598 65705 product 0 80831 A 6 C 0 0
68599 65700 product 0 80832 A 6 C 0 0
67245 65684 product 0 79478 A 7 C 0 0
67246 65684 product 0 79479 A 8 C 0 0