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 (
    61051, 61464, 61520, 61526, 61339, 61074, 
    61452, 59797, 61524, 61413, 61516, 
    64353
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00119

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": 110,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61051,61464,61520,61526,61339,61074,61452,59797,61524,61413,61516,64353)"
        }
      }
    },
    "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
16079 61413 product 0 27599 A 0 D 0 0
16344 61452 product 0 27864 A 0 D 0 0
16624 61516 product 0 28180 A 0 D 0 0
16630 61516 product 0 28186 A 0 D 0 0
16710 61516 product 0 28276 A 0 D 0 0
17782 61339 product 0 29410 A 0 D 0 0
30507 64353 product 0 42739 A 0 D 0 0
60335 61520 product 0 72568 A 0 D 0 0
60337 61520 product 0 72570 A 0 D 0 0
60338 61520 product 0 72571 A 0 D 0 0
62181 61526 product 0 74414 A 0 C 0 0
63145 59797 product 0 75378 A 0 D 0 0
63598 61520 product 0 75831 A 0 C 0 0
63619 61526 product 0 75852 A 0 C 0 0
63845 61524 product 0 76078 A 0 C 0 0
64219 61074 product 0 76452 A 0 D 0 0
65263 61464 product 0 77496 A 0 D 0 0
14077 61051 product 0 24858 A 1 D 0 0
16337 61464 product 0 27857 A 1 D 0 0
16345 61452 product 0 27865 A 1 D 0 0
17783 61339 product 0 29411 A 1 D 0 0
21176 61524 product 0 33017 A 1 C 0 0
30511 64353 product 0 42743 A 1 D 0 0
63147 59797 product 0 75380 A 1 D 0 0
64220 61074 product 0 76453 A 1 D 0 0
65627 61413 product 0 77860 A 1 D 0 0
66489 61524 product 0 78722 A 1 C 0 0
16346 61452 product 0 27866 A 2 D 0 0
30508 64353 product 0 42740 A 2 D 0 0
63146 59797 product 0 75379 A 2 D 0 0
64223 61074 product 0 76456 A 2 D 0 0
65264 61464 product 0 77497 A 2 D 0 0
65622 61413 product 0 77855 A 2 D 0 0
66266 61339 product 0 78499 A 2 D 0 0
15722 61339 product 0 27201 A 3 D 0 0
21201 61413 product 0 33082 A 3 D 0 0
30509 64353 product 0 42741 A 3 D 0 0
32159 61464 product 0 44392 A 3 D 0 0
57185 61452 product 0 69418 A 3 C 0 0
64222 61074 product 0 76455 A 3 D 0 0
16052 61413 product 0 27572 A 4 D 0 0
18741 61074 product 0 30419 A 4 D 0 0
30510 64353 product 0 42742 A 4 D 0 0
32163 61452 product 0 44396 A 4 C 0 0
65265 61464 product 0 77498 A 4 D 0 0
66267 61339 product 0 78500 A 4 D 0 0
14079 61051 product 0 24860 A 5 D 0 0
16050 61413 product 0 27570 A 5 D 0 0
29719 61339 product 0 41942 A 5 D 0 0
32588 64353 product 0 44821 A 5 D 0 0
57186 61452 product 0 69419 A 5 C 0 0
64221 61074 product 0 76454 A 5 D 0 0
65262 61464 product 0 77495 A 5 D 0 0
28585 61074 product 0 40784 A 6 C 0 0
32603 64353 product 0 44836 A 6 D 0 0
35865 61464 product 0 48098 A 6 C 0 0
51994 61051 product 0 64227 A 6 C 0 0
59427 61452 product 0 71660 A 6 C 0 0
65628 61413 product 0 77861 A 6 D 0 0
66268 61339 product 0 78501 A 6 D 0 0
21202 61413 product 0 33083 A 7 D 0 0
30517 64353 product 0 42749 A 7 C 0 0
32158 61452 product 0 44391 A 7 C 0 0
53584 61339 product 0 65817 A 7 C 0 0
63698 61051 product 0 75931 A 7 C 0 0
64224 61074 product 0 76457 A 7 D 0 0
31956 61339 product 0 44189 A 8 C 0 0
49907 64353 product 0 62140 A 8 C 0 0
63713 61413 product 0 75946 A 8 C 0 0
64060 61051 product 0 76293 A 8 C 0 0
48405 64353 product 0 60638 A 9 C 0 0
52006 61413 product 0 64239 A 9 C 0 0
53585 61339 product 0 65818 A 9 C 0 0
63699 61051 product 0 75932 A 9 C 0 0
48406 64353 product 0 60639 A 10 C 0 0
54141 61413 product 0 66374 A 10 C 0 0
60311 61051 product 0 72544 A 10 C 0 0
31955 61339 product 0 44188 A 11 C 0 0
49909 64353 product 0 62142 A 11 C 0 0
60040 61413 product 0 72273 A 11 C 0 0
60310 61051 product 0 72543 A 11 C 0 0
28575 61413 product 0 40774 A 12 C 0 0
32451 64353 product 0 44684 A 12 C 0 0
53587 61339 product 0 65820 A 12 C 0 0
58283 61051 product 0 70516 A 12 C 0 0
28314 61051 product 0 40507 A 13 C 0 0
49908 64353 product 0 62141 A 13 C 0 0
53586 61339 product 0 65819 A 13 C 0 0
62895 61413 product 0 75128 A 13 C 0 0
31960 64353 product 0 44193 A 14 C 0 0
32490 61051 product 0 44723 A 14 C 0 0
44346 61413 product 0 56579 A 14 C 0 0
63160 61339 product 0 75393 A 14 C 0 0
51995 61051 product 0 64228 A 15 C 0 0
57077 61413 product 0 69310 A 15 C 0 0
58532 64353 product 0 70765 A 15 C 0 0
30267 61051 product 0 42490 A 16 C 0 0
46024 61413 product 0 58257 A 16 C 0 0
58533 64353 product 0 70766 A 16 C 0 0
18204 61413 product 0 29833 A 17 C 0 0
32489 61051 product 0 44722 A 17 C 0 0
46809 61413 product 0 59042 A 18 C 0 0
60313 61051 product 0 72546 A 18 C 0 0
46810 61413 product 0 59043 A 19 C 0 0
58960 61051 product 0 71193 A 19 C 0 0
49181 61413 product 0 61414 A 20 C 0 0
56899 61413 product 0 69132 A 21 C 0 0
54155 61413 product 0 66388 A 22 C 0 0
68545 61413 product 0 80778 A 22 C 0 0
69174 61413 product 0 81407 A 22 C 0 0