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 (
    61465, 64780, 61692, 61484, 61525, 61529, 
    61071, 61695, 61344, 62019, 62229, 
    61198
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00185

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": 152,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61465,64780,61692,61484,61525,61529,61071,61695,61344,62019,62229,61198)"
        }
      }
    },
    "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
14185 61071 product 0 24980 A 0 D 0 0
16342 61465 product 0 27862 A 0 D 0 0
17246 61692 product 0 28813 A 0 D 0 0
20675 62229 product 0 32504 A 0 D 0 0
29786 62019 product 0 42009 A 0 D 0 0
29899 61344 product 0 42122 A 0 D 0 0
30986 61198 product 0 43219 A 0 D 0 0
39599 64780 product 0 51832 A 0 D 0 0
64040 61529 product 0 76273 A 0 C 0 0
64041 61529 product 0 76274 A 0 C 0 0
64264 61529 product 0 76497 A 0 C 0 0
64680 61695 product 0 76913 A 0 D 0 0
65061 61484 product 0 77294 A 0 D 0 0
66825 61525 product 0 79058 A 0 C 0 0
66827 61525 product 0 79060 A 0 C 0 0
66828 61525 product 0 79061 A 0 C 0 0
72613 62229 product 0 84846 A 0 C 0 0
16392 61484 product 0 27912 A 1 D 0 0
17247 61692 product 0 28814 A 1 D 0 0
17253 61695 product 0 28820 A 1 D 0 0
20681 62229 product 0 32510 A 1 C 0 0
30989 61198 product 0 43222 A 1 D 0 0
64069 61071 product 0 76302 A 1 D 0 0
65492 61465 product 0 77725 A 1 D 0 0
66322 61344 product 0 78555 A 1 D 0 0
66665 64780 product 0 78898 A 1 D 0 0
72672 62019 product 0 84905 A 1 D 0 0
16523 61465 product 0 28064 A 2 D 0 0
17252 61695 product 0 28819 A 2 D 0 0
22450 61344 product 0 34348 A 2 D 0 0
30988 61198 product 0 43221 A 2 D 0 0
35911 62229 product 0 48144 A 2 C 0 0
64068 61071 product 0 76301 A 2 D 0 0
64265 61529 product 0 76498 A 2 C 0 0
64643 61692 product 0 76876 A 2 D 0 0
64829 62019 product 0 77062 A 2 D 0 0
65063 61484 product 0 77296 A 2 D 0 0
66663 64780 product 0 78896 A 2 D 0 0
17249 61692 product 0 28816 A 3 D 0 0
19193 62019 product 0 30905 A 3 D 0 0
30617 61344 product 0 42849 A 3 D 0 0
30987 61198 product 0 43220 A 3 D 0 0
58547 62229 product 0 70780 A 3 C 0 0
64070 61071 product 0 76303 A 3 D 0 0
64678 61695 product 0 76911 A 3 D 0 0
65062 61484 product 0 77295 A 3 D 0 0
65493 61465 product 0 77726 A 3 D 0 0
66664 64780 product 0 78897 A 3 D 0 0
17248 61692 product 0 28815 A 4 D 0 0
22573 61344 product 0 34471 A 4 D 0 0
22785 62229 product 0 34689 A 4 C 0 0
28577 61529 product 0 40776 A 4 C 0 0
42515 61198 product 0 54748 A 4 D 0 0
64066 61071 product 0 76299 A 4 D 0 0
64679 61695 product 0 76912 A 4 D 0 0
65064 61484 product 0 77297 A 4 D 0 0
65115 61529 product 0 77348 A 4 C 0 0
65495 61465 product 0 77728 A 4 D 0 0
66999 64780 product 0 79232 A 4 D 0 0
28811 61198 product 0 41010 A 5 C 0 0
53838 62229 product 0 66071 A 5 C 0 0
60332 61695 product 0 72565 A 5 D 0 0
64067 61071 product 0 76300 A 5 D 0 0
64645 61692 product 0 76878 A 5 D 0 0
65065 61484 product 0 77298 A 5 D 0 0
65490 61465 product 0 77723 A 5 D 0 0
66321 61344 product 0 78554 A 5 D 0 0
66667 64780 product 0 78900 A 5 D 0 0
18737 61071 product 0 30415 A 6 D 0 0
21223 62229 product 0 33104 A 6 D 0 0
22574 61344 product 0 34472 A 6 D 0 0
45912 61198 product 0 58145 A 6 C 1 1781
58095 64780 product 0 70328 A 6 C 0 0
64644 61692 product 0 76877 A 6 D 0 0
65494 61465 product 0 77727 A 6 D 0 0
18738 61071 product 0 30416 A 7 D 0 0
20680 62229 product 0 32509 A 7 D 0 0
30618 61344 product 0 42850 A 7 D 0 0
50063 61484 product 0 62296 A 7 C 0 0
57168 61692 product 0 69401 A 7 C 1 1781
59067 61198 product 0 71300 A 7 C 0 0
62192 64780 product 0 74425 A 7 C 0 0
69128 61465 product 0 81361 A 7 C 0 0
21221 62229 product 0 33102 A 8 D 0 0
31754 61484 product 0 43987 A 8 C 0 0
48376 61198 product 0 60609 A 8 C 0 0
48961 61071 product 0 61194 A 8 C 0 0
57166 61692 product 0 69399 A 8 C 0 0
57187 61465 product 0 69420 A 8 C 0 0
61456 61344 product 0 73689 A 8 C 0 0
62193 64780 product 0 74426 A 8 C 0 0
20673 62229 product 0 32502 A 9 D 0 0
31753 61484 product 0 43986 A 9 C 0 0
45364 61344 product 0 57597 A 9 C 0 0
57167 61692 product 0 69400 A 9 C 0 0
61459 64780 product 0 73692 A 9 C 0 0
62859 61198 product 0 75092 A 9 C 0 0
62894 61465 product 0 75127 A 9 C 0 0
68537 61071 product 0 80770 A 9 C 0 0
21222 62229 product 0 33103 A 10 D 0 0
30254 61465 product 0 42477 A 10 C 0 0
39602 64780 product 0 51835 A 10 C 0 0
45911 61198 product 0 58144 A 10 C 1 1781
50711 61692 product 0 62944 A 10 C 0 0
59065 61071 product 0 71298 A 10 C 0 0
60866 61344 product 0 73099 A 10 C 0 0
64126 61484 product 0 76359 A 10 D 0 0
20676 62229 product 0 32505 A 11 D 0 0
31952 61344 product 0 44185 A 11 C 0 0
44343 61071 product 0 56576 A 11 C 0 0
50055 61198 product 0 62288 A 11 C 0 0
50712 61692 product 0 62945 A 11 C 0 0
57188 61465 product 0 69421 A 11 C 0 0
61460 64780 product 0 73693 A 11 C 0 0
64127 61484 product 0 76360 A 11 C 0 0
69180 61692 product 0 81413 A 11 C 0 0
69181 61692 product 0 81414 A 11 C 0 0
20474 61465 product 0 32297 A 12 C 0 0
20679 62229 product 0 32508 A 12 D 0 0
31951 61344 product 0 44184 A 12 C 0 0
58096 64780 product 0 70329 A 12 C 0 0
59064 61071 product 0 71297 A 12 C 0 0
60783 61198 product 0 73016 A 12 C 0 0
64125 61484 product 0 76358 A 12 C 0 0
20473 61465 product 0 32296 A 13 C 0 0
20678 62229 product 0 32507 A 13 D 0 0
39601 64780 product 0 51834 A 13 C 0 0
44352 61071 product 0 56585 A 13 C 0 0
45910 61198 product 0 58143 A 13 C 0 0
48378 61344 product 0 60611 A 13 C 0 0
20677 62229 product 0 32506 A 14 D 0 0
21191 61465 product 0 33072 A 14 C 0 0
48377 61198 product 0 60610 A 14 C 0 0
48380 61344 product 0 60613 A 14 C 0 0
66996 61071 product 0 79229 A 14 C 0 0
20674 62229 product 0 32503 A 15 D 0 0
49316 61465 product 0 61549 A 15 C 0 0
50056 61198 product 0 62289 A 15 C 0 0
32586 62229 product 0 44819 A 16 D 0 0
59066 61198 product 0 71299 A 16 C 0 0
66464 61465 product 0 78697 A 16 C 0 0
53714 61198 product 0 65947 A 17 C 0 0
47773 61198 product 0 60006 A 18 C 0 0
49912 62229 product 0 62145 A 18 C 0 0
38479 62229 product 0 50712 A 19 C 0 0
47772 61198 product 0 60005 A 19 C 0 0
49913 62229 product 0 62146 A 20 C 0 0
62155 61198 product 0 74388 A 20 C 0 0
58548 62229 product 0 70781 A 21 C 0 0
66844 61198 product 0 79077 A 21 C 0 0
58985 62229 product 0 71218 A 22 C 0 0
66845 61198 product 0 79078 A 22 C 0 0