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 (
    65660, 65883, 65938, 65884, 65892, 65896, 
    65895, 65937, 65888, 65956, 65838, 
    65890
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00118

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": 105,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65660,65883,65938,65884,65892,65896,65895,65937,65888,65956,65838,65890)"
        }
      }
    },
    "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
67231 65660 product 0 79464 A 0 D 0 0
67240 65660 product 0 79473 A 0 D 0 0
72013 65884 product 0 84246 A 0 D 0 0
72015 65884 product 0 84248 A 0 D 0 0
72026 65883 product 0 84259 A 0 D 0 0
72726 65838 product 0 84959 A 0 D 0 0
72728 65888 product 0 84961 A 0 D 0 0
72743 65890 product 0 84976 A 0 D 0 0
72785 65892 product 0 85018 A 0 D 0 0
72786 65892 product 0 85019 A 0 D 0 0
72793 65892 product 0 85026 A 0 D 0 0
72944 65895 product 0 85177 A 0 D 0 0
72953 65896 product 0 85186 A 0 D 0 0
72954 65896 product 0 85187 A 0 D 0 0
72955 65896 product 0 85188 A 0 D 0 0
72956 65896 product 0 85189 A 0 D 0 0
72957 65896 product 0 85190 A 0 D 0 0
72958 65896 product 0 85191 A 0 D 0 0
72959 65896 product 0 85192 A 0 D 0 0
72960 65896 product 0 85193 A 0 D 0 0
72961 65896 product 0 85194 A 0 D 0 0
72975 65896 product 0 85208 A 0 C 0 0
72976 65896 product 0 85209 A 0 C 0 0
72977 65896 product 0 85210 A 0 C 0 0
72978 65896 product 0 85211 A 0 C 0 0
73526 65937 product 0 85759 A 0 D 0 0
73593 65938 product 0 85826 A 0 D 0 0
73902 65956 product 0 86135 A 0 D 0 0
67232 65660 product 0 79465 A 1 D 0 0
72011 65883 product 0 84244 A 1 D 0 0
72029 65884 product 0 84262 A 1 D 0 0
72720 65838 product 0 84953 A 1 D 0 0
72727 65888 product 0 84960 A 1 D 0 0
72794 65890 product 0 85027 A 1 D 0 0
72945 65895 product 0 85178 A 1 D 0 0
73530 65937 product 0 85763 A 1 D 0 0
73596 65938 product 0 85829 A 1 D 0 0
73903 65956 product 0 86136 A 1 D 0 0
72008 65883 product 0 84241 A 2 D 0 0
72725 65838 product 0 84958 A 2 D 0 0
72730 65888 product 0 84963 A 2 D 0 0
72746 65890 product 0 84979 A 2 D 0 0
72946 65895 product 0 85179 A 2 D 0 0
73527 65937 product 0 85760 A 2 D 0 0
73592 65938 product 0 85825 A 2 D 0 0
73904 65956 product 0 86137 A 2 D 0 0
67235 65660 product 0 79468 A 3 D 0 0
72019 65884 product 0 84252 A 3 D 0 0
72721 65838 product 0 84954 A 3 D 0 0
72729 65888 product 0 84962 A 3 D 0 0
72744 65890 product 0 84977 A 3 D 0 0
72947 65895 product 0 85180 A 3 D 0 0
73531 65937 product 0 85764 A 3 D 0 0
73595 65938 product 0 85828 A 3 D 0 0
73905 65956 product 0 86138 A 3 D 0 0
67236 65660 product 0 79469 A 4 D 0 0
72014 65884 product 0 84247 A 4 D 0 0
72724 65838 product 0 84957 A 4 D 0 0
72948 65895 product 0 85181 A 4 D 0 0
73533 65937 product 0 85766 A 4 D 0 0
73598 65938 product 0 85831 A 4 D 0 0
73906 65956 product 0 86139 A 4 D 0 0
67237 65660 product 0 79470 A 5 D 0 0
72018 65884 product 0 84251 A 5 D 0 0
72722 65838 product 0 84955 A 5 D 0 0
72949 65895 product 0 85182 A 5 D 0 0
73528 65937 product 0 85761 A 5 D 0 0
73594 65938 product 0 85827 A 5 D 0 0
73907 65956 product 0 86140 A 5 D 0 0
67239 65660 product 0 79472 A 6 D 0 0
72017 65884 product 0 84250 A 6 D 0 0
72723 65838 product 0 84956 A 6 D 0 0
72951 65895 product 0 85184 A 6 D 0 0
73532 65937 product 0 85765 A 6 D 0 0
73597 65938 product 0 85830 A 6 D 0 0
73908 65956 product 0 86141 A 6 D 0 0
67238 65660 product 0 79471 A 7 D 0 0
67584 65660 product 0 79817 A 7 C 0 0
72790 65838 product 0 85023 A 7 C 0 0
72950 65895 product 0 85183 A 7 D 0 0
73529 65937 product 0 85762 A 7 D 0 0
73641 65938 product 0 85874 A 7 D 0 0
73909 65956 product 0 86142 A 7 D 0 0
72791 65838 product 0 85024 A 8 C 0 0
72952 65895 product 0 85185 A 8 D 0 0
73599 65938 product 0 85832 A 8 C 0 0
73642 65937 product 0 85875 A 8 D 0 0
73910 65956 product 0 86143 A 8 D 0 0
72792 65838 product 0 85025 A 9 C 0 0
72979 65895 product 0 85212 A 9 C 0 0
73534 65937 product 0 85767 A 9 D 0 0
73601 65938 product 0 85834 A 9 C 0 0
73911 65956 product 0 86144 A 9 D 0 0
72980 65895 product 0 85213 A 10 C 0 0
73576 65937 product 0 85809 A 10 C 0 0
73600 65938 product 0 85833 A 10 C 0 0
73912 65956 product 0 86145 A 10 D 0 0
72983 65895 product 0 85216 A 11 D 0 0
73575 65937 product 0 85808 A 11 C 0 0
73922 65956 product 0 86155 A 11 D 0 0
72981 65895 product 0 85214 A 12 C 0 0
73577 65937 product 0 85810 A 12 C 0 0
73919 65956 product 0 86152 A 12 C 0 0
73535 65937 product 0 85768 A 13 C 0 0
73920 65956 product 0 86153 A 13 C 0 0