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 (
    65082, 65503, 65087, 65501, 65500, 65502, 
    65938, 65884, 65836
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00103

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": 79,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65082,65503,65087,65501,65500,65502,65938,65884,65836)"
        }
      }
    },
    "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
59498 65501 product 0 71731 A 0 D 0 0
59523 65502 product 0 71756 A 0 D 0 0
59530 65503 product 0 71763 A 0 D 0 0
59533 65503 product 0 71766 A 0 D 0 0
59535 65503 product 0 71768 A 0 D 0 0
63615 65082 product 0 75848 A 0 D 0 0
63655 65500 product 0 75888 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
73593 65938 product 0 85826 A 0 D 0 0
73892 65836 product 0 86125 A 0 D 0 0
52458 65082 product 0 64691 A 1 D 0 0
59499 65501 product 0 71732 A 1 D 0 0
59518 65502 product 0 71751 A 1 D 0 0
63654 65500 product 0 75887 A 1 D 0 0
64812 65087 product 0 77045 A 1 D 0 0
72029 65884 product 0 84262 A 1 D 0 0
73596 65938 product 0 85829 A 1 D 0 0
73887 65836 product 0 86120 A 1 D 0 0
59521 65502 product 0 71754 A 2 D 0 0
60010 65501 product 0 72243 A 2 D 0 0
63656 65500 product 0 75889 A 2 D 0 0
64816 65087 product 0 77049 A 2 D 0 0
71048 65082 product 0 83281 A 2 D 0 0
73592 65938 product 0 85825 A 2 D 0 0
73896 65836 product 0 86129 A 2 D 0 0
59503 65501 product 0 71736 A 3 D 0 0
59524 65502 product 0 71757 A 3 D 0 0
60009 65500 product 0 72242 A 3 D 0 0
63617 65082 product 0 75850 A 3 D 0 0
72019 65884 product 0 84252 A 3 D 0 0
73595 65938 product 0 85828 A 3 D 0 0
73888 65836 product 0 86121 A 3 D 0 0
59508 65501 product 0 71741 A 4 D 0 0
60043 65502 product 0 72276 A 4 C 0 0
63658 65500 product 0 75891 A 4 D 0 0
64817 65087 product 0 77050 A 4 D 0 0
71047 65082 product 0 83280 A 4 D 0 0
72014 65884 product 0 84247 A 4 D 0 0
73598 65938 product 0 85831 A 4 D 0 0
73894 65836 product 0 86127 A 4 D 0 0
52486 65087 product 0 64719 A 5 D 0 0
59484 65500 product 0 71717 A 5 D 0 0
59510 65501 product 0 71743 A 5 D 0 0
63614 65082 product 0 75847 A 5 D 0 0
72018 65884 product 0 84251 A 5 D 0 0
73594 65938 product 0 85827 A 5 D 0 0
73886 65836 product 0 86119 A 5 D 0 0
63618 65082 product 0 75851 A 6 D 0 0
63657 65500 product 0 75890 A 6 D 0 0
68735 65501 product 0 80968 A 6 C 0 0
72017 65884 product 0 84250 A 6 D 0 0
73597 65938 product 0 85830 A 6 D 0 0
73889 65836 product 0 86122 A 6 D 0 0
52456 65082 product 0 64689 A 7 D 0 0
68734 65501 product 0 80967 A 7 C 0 0
73641 65938 product 0 85874 A 7 D 0 0
73890 65836 product 0 86123 A 7 D 0 0
63616 65082 product 0 75849 A 8 D 0 0
68736 65501 product 0 80969 A 8 C 0 0
73599 65938 product 0 85832 A 8 C 0 0
73895 65836 product 0 86128 A 8 D 0 0
63701 65082 product 0 75934 A 9 C 0 0
68737 65501 product 0 80970 A 9 C 0 0
73601 65938 product 0 85834 A 9 C 0 0
73897 65836 product 0 86130 A 9 D 0 0
63702 65082 product 0 75935 A 10 C 0 0
73600 65938 product 0 85833 A 10 C 0 0
73891 65836 product 0 86124 A 10 D 0 0
63703 65082 product 0 75936 A 11 C 0 0
73893 65836 product 0 86126 A 11 D 0 0
73921 65836 product 0 86154 A 12 D 0 0
73900 65836 product 0 86133 A 13 C 0 0
73898 65836 product 0 86131 A 14 C 0 0
73899 65836 product 0 86132 A 15 C 0 0
73901 65836 product 0 86134 A 16 C 0 0
73923 65836 product 0 86156 A 16 D 0 0
73924 65836 product 0 86157 A 16 D 0 0
73925 65836 product 0 86158 A 16 D 0 0