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 (
    63240, 63758, 62654, 62583, 62387, 64927, 
    64979, 64933, 62657, 64983, 64980, 
    62395
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00098

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": 87,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (63240,63758,62654,62583,62387,64927,64979,64933,62657,64983,64980,62395)"
        }
      }
    },
    "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
21492 62387 product 0 33373 A 0 D 0 0
22593 62657 product 0 34491 A 0 D 0 0
22650 62654 product 0 34548 A 0 D 0 0
22651 62654 product 0 34549 A 0 D 0 0
27210 63758 product 0 39387 A 0 D 0 0
47665 64927 product 0 59898 A 0 D 0 0
47769 64933 product 0 60002 A 0 D 0 0
63973 64979 product 0 76206 A 0 D 0 0
63979 64980 product 0 76212 A 0 D 0 0
64119 62654 product 0 76352 A 0 D 0 0
65094 64983 product 0 77327 A 0 D 0 0
65329 63240 product 0 77562 A 0 D 0 0
65332 63240 product 0 77565 A 0 D 0 0
65413 62395 product 0 77646 A 0 D 0 0
66433 62654 product 0 78666 A 0 D 0 0
66434 62654 product 0 78667 A 0 D 0 0
66435 62654 product 0 78668 A 0 D 0 0
66436 62654 product 0 78669 A 0 D 0 0
66971 62583 product 0 79204 A 0 D 0 0
21524 62395 product 0 33405 A 1 D 0 0
21670 62387 product 0 33551 A 1 D 0 0
22594 62657 product 0 34492 A 1 D 0 0
24983 63240 product 0 37059 A 1 D 0 0
27209 63758 product 0 39386 A 1 D 0 0
29723 62583 product 0 41946 A 1 D 0 0
50124 64979 product 0 62357 A 1 D 0 0
50186 64980 product 0 62419 A 1 D 0 0
50241 64983 product 0 62474 A 1 D 0 0
63111 64933 product 0 75344 A 1 D 0 0
27212 63758 product 0 39389 A 2 D 0 0
47668 64927 product 0 59901 A 2 D 0 0
50125 64979 product 0 62358 A 2 D 0 0
63980 64980 product 0 76213 A 2 D 0 0
65095 64983 product 0 77328 A 2 D 0 0
65333 63240 product 0 77566 A 2 D 0 0
65416 62395 product 0 77649 A 2 D 0 0
65489 62387 product 0 77722 A 2 D 0 0
66809 62657 product 0 79042 A 2 D 0 0
66969 62583 product 0 79202 A 2 D 0 0
22592 62657 product 0 34490 A 3 D 0 0
24396 62395 product 0 36377 A 3 D 0 0
27214 63758 product 0 39391 A 3 D 0 0
29722 62583 product 0 41945 A 3 D 0 0
32154 63240 product 0 44387 A 3 D 0 0
47770 64933 product 0 60003 A 3 D 0 0
50123 64979 product 0 62356 A 3 D 0 0
50187 64980 product 0 62420 A 3 D 0 0
62910 64927 product 0 75143 A 3 D 0 0
65093 64983 product 0 77326 A 3 D 0 0
65486 62387 product 0 77719 A 3 D 0 0
24397 62395 product 0 36378 A 4 D 0 0
27208 63758 product 0 39385 A 4 D 0 0
47771 64933 product 0 60004 A 4 D 0 0
62911 64927 product 0 75144 A 4 D 0 0
63971 64979 product 0 76204 A 4 D 0 0
63978 64980 product 0 76211 A 4 D 0 0
65331 63240 product 0 77564 A 4 D 0 0
65488 62387 product 0 77721 A 4 D 0 0
66810 62657 product 0 79043 A 4 D 0 0
66970 62583 product 0 79203 A 4 D 0 0
22178 62583 product 0 34070 A 5 D 0 0
27211 63758 product 0 39388 A 5 D 0 0
47667 64927 product 0 59900 A 5 D 0 0
63108 64933 product 0 75341 A 5 D 0 0
63970 64979 product 0 76203 A 5 D 0 0
65330 63240 product 0 77563 A 5 D 0 0
65415 62395 product 0 77648 A 5 D 0 0
65487 62387 product 0 77720 A 5 D 0 0
66812 62657 product 0 79045 A 5 D 0 0
27213 63758 product 0 39390 A 6 D 0 0
63972 64979 product 0 76205 A 6 D 0 0
63981 64980 product 0 76214 A 6 D 0 0
64504 62583 product 0 76737 A 6 C 0 0
65414 62395 product 0 77647 A 6 D 0 0
66811 62657 product 0 79044 A 6 D 0 0
68220 62657 product 0 80453 A 6 C 0 0
46462 63758 product 0 58695 A 7 C 0 0
63109 64933 product 0 75342 A 7 D 0 0
63969 64979 product 0 76202 A 7 D 0 0
64505 62583 product 0 76738 A 7 C 0 0
46463 63758 product 0 58696 A 8 C 0 0
63110 64933 product 0 75343 A 8 D 0 0
63937 64979 product 0 76170 A 8 C 0 0
64506 62583 product 0 76739 A 8 C 0 0
46464 63758 product 0 58697 A 9 C 0 0
58919 64979 product 0 71152 A 9 C 0 0
64507 62583 product 0 76740 A 9 C 0 0