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 (
    61329, 61954, 62862, 62977, 64875, 64876, 
    64902, 64903, 64908, 64909, 65531, 
    65532, 65533
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00189

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": 137,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61329,61954,62862,62977,64875,64876,64902,64903,64908,64909,65531,65532,65533)"
        }
      }
    },
    "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
15390 61329 product 0 26837 A 0 D 0 0
19072 61954 product 0 30779 A 0 D 0 0
23751 62977 product 0 35682 A 0 D 0 0
31723 62862 product 0 43956 A 0 D 0 0
46914 64903 product 0 59147 A 0 D 0 0
46921 64876 product 0 59154 A 0 D 0 0
47898 64908 product 0 60131 A 0 D 0 0
47899 64908 product 0 60132 A 0 D 0 0
47927 64875 product 0 60160 A 0 D 0 0
63329 65531 product 0 75562 A 0 D 0 0
63337 65532 product 0 75570 A 0 D 0 0
63345 65533 product 0 75578 A 0 D 0 0
23659 62977 product 0 35587 A 1 D 0 0
31711 61329 product 0 43944 A 1 D 0 0
31724 62862 product 0 43957 A 1 D 0 0
46904 64909 product 0 59137 A 1 D 0 0
46915 64903 product 0 59148 A 1 D 0 0
46922 64876 product 0 59155 A 1 D 0 0
47814 64902 product 0 60047 A 1 D 0 0
47900 64908 product 0 60133 A 1 D 0 0
47929 64875 product 0 60162 A 1 D 0 0
63330 65531 product 0 75563 A 1 D 0 0
63341 65532 product 0 75574 A 1 D 0 0
63346 65533 product 0 75579 A 1 D 0 0
63651 61954 product 0 75884 A 1 D 0 0
19100 61954 product 0 30807 A 2 D 0 0
23225 62862 product 0 35140 A 2 D 0 0
29821 62977 product 0 42044 A 2 D 0 0
31710 61329 product 0 43943 A 2 D 1 1781
46905 64909 product 0 59138 A 2 D 0 0
46916 64903 product 0 59149 A 2 D 0 0
46923 64876 product 0 59156 A 2 D 0 0
47815 64902 product 0 60048 A 2 D 0 0
47930 64875 product 0 60163 A 2 D 0 0
63332 65531 product 0 75565 A 2 D 0 0
63338 65532 product 0 75571 A 2 D 0 0
63351 65533 product 0 75584 A 2 D 0 0
15394 61329 product 0 26841 A 3 D 0 0
23227 62862 product 0 35142 A 3 D 0 0
31668 62977 product 0 43901 A 3 D 0 0
31676 61954 product 0 43909 A 3 D 0 0
46906 64909 product 0 59139 A 3 D 0 0
46917 64903 product 0 59150 A 3 D 0 0
46924 64876 product 0 59157 A 3 D 0 0
47816 64902 product 0 60049 A 3 D 0 0
47901 64908 product 0 60134 A 3 D 0 0
47932 64875 product 0 60165 A 3 D 0 0
63331 65531 product 0 75564 A 3 D 0 0
63340 65532 product 0 75573 A 3 D 0 0
63348 65533 product 0 75581 A 3 D 0 0
15392 61329 product 0 26839 A 4 D 0 0
23224 62862 product 0 35139 A 4 D 0 0
23791 62977 product 0 35722 A 4 D 0 0
31678 61954 product 0 43911 A 4 D 0 0
46908 64909 product 0 59141 A 4 D 0 0
46918 64903 product 0 59151 A 4 D 0 0
46925 64876 product 0 59158 A 4 D 0 0
47819 64902 product 0 60052 A 4 D 0 0
47904 64908 product 0 60137 A 4 D 0 0
47933 64875 product 0 60166 A 4 D 0 0
63333 65531 product 0 75566 A 4 D 0 0
63342 65532 product 0 75575 A 4 D 0 0
63347 65533 product 0 75580 A 4 D 0 0
23226 62862 product 0 35141 A 5 D 0 0
31669 62977 product 0 43902 A 5 D 0 0
31677 61954 product 0 43910 A 5 D 0 0
46909 64909 product 0 59142 A 5 D 0 0
47817 64902 product 0 60050 A 5 D 0 0
47931 64875 product 0 60164 A 5 D 0 0
61196 64903 product 0 73429 A 5 D 0 0
61198 64902 product 0 73431 A 5 D 0 0
61199 64902 product 0 73432 A 5 D 0 0
63334 65531 product 0 75567 A 5 D 0 0
63339 65532 product 0 75572 A 5 D 0 0
63349 65533 product 0 75582 A 5 D 0 0
64102 64908 product 0 76335 A 5 D 0 0
68544 64876 product 0 80777 A 5 C 0 0
71116 61329 product 0 83349 A 5 D 0 0
15391 61329 product 0 26838 A 6 D 0 0
31679 61954 product 0 43912 A 6 D 0 0
31725 62862 product 0 43958 A 6 D 0 0
47902 64908 product 0 60135 A 6 D 0 0
58321 62977 product 0 70554 A 6 C 0 0
60053 64875 product 0 72286 A 6 C 0 0
61195 64903 product 0 73428 A 6 D 0 0
61441 64876 product 0 73674 A 6 C 0 0
63335 65531 product 0 75568 A 6 D 0 0
63343 65532 product 0 75576 A 6 D 0 0
63350 65533 product 0 75583 A 6 D 0 0
63352 65531 product 0 75585 A 6 C 0 0
63353 65533 product 0 75586 A 6 C 0 0
64292 64909 product 0 76525 A 6 C 0 0
65272 64903 product 0 77505 A 6 C 0 0
65273 64903 product 0 77506 A 6 C 0 0
65336 64903 product 0 77569 A 6 C 0 0
66836 62862 product 0 79069 A 6 C 0 0
53791 61329 product 0 66024 A 7 C 1 0
60054 64875 product 0 72287 A 7 C 0 0
61442 64876 product 0 73675 A 7 C 0 0
61916 65532 product 0 74149 A 7 C 0 0
64107 64908 product 0 76340 A 7 C 0 0
64226 61954 product 0 76459 A 7 C 0 0
65908 64909 product 0 78141 A 7 C 0 0
67911 62977 product 0 80144 A 7 C 0 0
28322 62977 product 0 40515 A 8 C 0 0
58916 64908 product 0 71149 A 8 C 0 0
60055 64875 product 0 72288 A 8 C 0 0
60781 61954 product 0 73014 A 8 C 0 0
61443 64876 product 0 73676 A 8 C 0 0
61787 61329 product 0 74020 A 8 C 0 0
61917 65532 product 0 74150 A 8 C 0 0
64293 64909 product 0 76526 A 8 C 0 0
60056 64909 product 0 72289 A 9 C 0 0
60779 61329 product 0 73012 A 9 C 0 0
61667 61954 product 0 73900 A 9 C 0 0
61918 65532 product 0 74151 A 9 C 0 0
62183 64908 product 0 74416 A 9 C 0 0
63354 62977 product 0 75587 A 9 C 0 0
53792 61329 product 0 66025 A 10 C 1 0
55242 62977 product 0 67475 A 10 C 0 0
60780 61954 product 0 73013 A 10 C 0 0
61919 65532 product 0 74152 A 10 C 0 0
63155 64908 product 0 75388 A 10 C 0 0
31675 61954 product 0 43908 A 11 C 0 0
63156 64908 product 0 75389 A 11 C 0 0
67912 62977 product 0 80145 A 11 C 0 0
32629 61954 product 0 44862 A 12 C 0 0
53738 61329 product 0 65971 A 12 C 1 0
32628 61954 product 0 44861 A 13 C 0 0
61788 61329 product 0 74021 A 13 C 0 0
56109 61954 product 0 68342 A 14 C 0 0
62188 61954 product 0 74421 A 15 C 0 0
59676 61329 product 0 71909 A 17 C 0 0
57076 61329 product 0 69309 A 19 C 0 0
57206 61329 product 0 69439 A 21 C 1 0
18201 61329 product 0 29830 A 22 C 1 1782
56277 61329 product 0 68510 A 23 C 1 0