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 (
    64357, 63515, 61417, 64773, 60981, 62056, 
    63231, 64274, 63776, 63234, 63816, 
    61080
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00193

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": 125,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64357,63515,61417,64773,60981,62056,63231,64274,63776,63234,63816,61080)"
        }
      }
    },
    "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
13539 60981 product 0 23989 A 0 D 0 0
18090 60981 product 0 29719 A 0 D 0 0
19697 62056 product 0 31486 A 0 D 0 0
24954 63231 product 0 37030 A 0 D 0 0
27283 63776 product 0 39460 A 0 D 0 0
27494 63816 product 0 39671 A 0 D 0 0
30082 63515 product 0 42305 A 0 D 0 0
30557 64357 product 0 42789 A 0 D 0 0
36998 61080 product 0 49231 A 0 D 0 0
38970 64773 product 0 51203 A 0 D 0 0
53588 60981 product 0 65821 A 0 C 0 0
53589 60981 product 0 65822 A 0 C 0 0
57403 63776 product 0 69636 A 0 C 0 0
57404 63776 product 0 69637 A 0 C 0 0
57405 63776 product 0 69638 A 0 C 0 0
57406 63776 product 0 69639 A 0 C 0 0
61372 60981 product 0 73605 A 0 C 0 0
65326 63234 product 0 77559 A 0 D 0 0
66470 63234 product 0 78703 A 0 C 0 0
69571 64274 product 0 81804 A 0 D 0 0
21213 61417 product 0 33094 A 1 D 0 0
24962 63234 product 0 37038 A 1 D 0 0
29358 64274 product 0 41578 A 1 D 0 0
29464 62056 product 0 41684 A 1 D 0 0
30266 63515 product 0 42489 A 1 C 0 0
30556 64357 product 0 42788 A 1 D 0 0
38972 64773 product 0 51205 A 1 D 0 0
64215 61080 product 0 76448 A 1 D 0 0
65392 63231 product 0 77625 A 1 D 0 0
68286 63816 product 0 80519 A 1 C 0 0
19261 61417 product 0 30973 A 2 D 0 0
19698 62056 product 0 31487 A 2 D 0 0
26492 63515 product 0 38659 A 2 D 0 0
29357 64274 product 0 41577 A 2 D 0 0
30558 64357 product 0 42790 A 2 D 0 0
36997 61080 product 0 49230 A 2 D 0 0
52007 63816 product 0 64240 A 2 C 0 0
65328 63234 product 0 77561 A 2 D 0 0
65391 63231 product 0 77624 A 2 D 0 0
66034 64773 product 0 78267 A 2 D 0 0
26493 63515 product 0 38660 A 3 D 0 0
27799 63816 product 0 39976 A 3 C 0 0
29483 62056 product 0 41703 A 3 D 0 0
30212 64274 product 0 42435 A 3 D 0 0
30559 64357 product 0 42791 A 3 D 0 0
38980 64773 product 0 51213 A 3 D 0 0
64214 61080 product 0 76447 A 3 D 0 0
65325 63234 product 0 77558 A 3 D 0 0
65393 63231 product 0 77626 A 3 D 0 0
26506 63515 product 0 38673 A 4 D 0 0
27495 63816 product 0 39672 A 4 D 0 0
32150 63231 product 0 44383 A 4 D 0 0
32153 63234 product 0 44386 A 4 D 0 0
37000 61080 product 0 49233 A 4 D 0 0
37849 64357 product 0 50082 A 4 C 0 0
38976 64773 product 0 51209 A 4 D 0 0
60943 62056 product 0 73176 A 4 D 0 0
69569 64274 product 0 81802 A 4 D 0 0
19699 62056 product 0 31488 A 5 D 0 0
23130 61417 product 0 35041 A 5 D 0 0
27498 63816 product 0 39675 A 5 D 0 0
30084 63515 product 0 42307 A 5 C 0 0
36999 61080 product 0 49232 A 5 D 0 0
38982 64773 product 0 51215 A 5 D 0 0
61964 64357 product 0 74197 A 5 C 0 0
65327 63234 product 0 77560 A 5 D 0 0
65394 63231 product 0 77627 A 5 D 0 0
66468 63234 product 0 78701 A 5 C 0 0
69570 64274 product 0 81803 A 5 D 0 0
14230 61080 product 0 25025 A 6 D 0 0
27497 63816 product 0 39674 A 6 D 0 0
30083 63515 product 0 42306 A 6 D 0 0
38470 63231 product 0 50703 A 6 C 0 0
38975 64773 product 0 51208 A 6 D 0 0
58931 64357 product 0 71164 A 6 C 0 0
60944 62056 product 0 73177 A 6 D 0 0
69572 64274 product 0 81805 A 6 D 0 0
26507 63515 product 0 38674 A 7 D 0 0
28326 61417 product 0 40519 A 7 C 0 0
38974 64773 product 0 51207 A 7 C 0 0
52008 63816 product 0 64241 A 7 C 0 0
55739 63231 product 0 67972 A 7 C 0 0
60293 61080 product 0 72526 A 7 C 0 0
60942 62056 product 0 73175 A 7 D 0 0
61965 64357 product 0 74198 A 7 C 0 0
68764 64274 product 0 80997 A 7 C 0 0
26508 63515 product 0 38675 A 8 D 0 0
38471 63231 product 0 50704 A 8 C 0 0
52009 63816 product 0 64242 A 8 D 0 0
58496 62056 product 0 70729 A 8 C 0 0
58932 64357 product 0 71165 A 8 C 0 0
61837 61080 product 0 74070 A 8 C 0 0
64225 64274 product 0 76458 A 8 C 0 0
64549 64773 product 0 76782 A 8 C 0 0
28312 61417 product 0 40505 A 9 C 0 0
38978 64773 product 0 51211 A 9 C 0 0
56279 64274 product 0 68512 A 9 C 0 0
58770 63231 product 0 71003 A 9 C 0 0
60292 61080 product 0 72525 A 9 C 0 0
61966 64357 product 0 74199 A 9 C 0 0
40471 63231 product 0 52704 A 10 C 0 0
44118 61417 product 0 56351 A 10 C 0 0
46670 64773 product 0 58903 A 10 C 0 0
60294 61080 product 0 72527 A 10 C 0 0
61418 64274 product 0 73651 A 10 C 0 0
61967 64357 product 0 74200 A 10 C 0 0
65482 61417 product 0 77715 A 10 C 0 0
65723 64357 product 0 77956 A 10 C 0 0
65724 64357 product 0 77957 A 10 C 0 0
66829 64357 product 0 79062 A 10 C 0 0
67209 64357 product 0 79442 A 10 C 0 0
32330 64274 product 0 44563 A 11 C 0 0
46019 61080 product 0 58252 A 11 C 0 0
63070 64773 product 0 75303 A 11 C 0 0
30961 64274 product 0 43194 A 12 C 0 0
46020 61080 product 0 58253 A 12 C 0 0
66277 64773 product 0 78510 A 12 C 0 0
31646 64274 product 0 43879 A 13 C 0 0
57243 64773 product 0 69476 A 13 C 0 0
35930 64274 product 0 48163 A 14 C 0 0
50270 64773 product 0 62503 A 14 C 0 0
33330 64274 product 0 45563 A 15 C 0 0
38977 64773 product 0 51210 A 15 C 0 0
56280 64274 product 0 68513 A 16 C 1 1781
58541 64773 product 0 70774 A 16 C 0 0