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 (
    61075, 61083, 61071, 61694, 61081, 61697, 
    61558, 61684, 65455
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00155

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": 99,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61075,61083,61071,61694,61081,61697,61558,61684,65455)"
        }
      }
    },
    "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
14210 61075 product 0 25005 A 0 D 0 0
17222 61697 product 0 28789 A 0 D 0 0
64037 61081 product 0 76270 A 0 D 0 0
64044 61083 product 0 76277 A 0 D 0 0
64076 61694 product 0 76309 A 0 D 0 0
64082 65455 product 0 76315 A 0 D 0 0
64089 61684 product 0 76322 A 0 D 0 0
64091 61558 product 0 76324 A 0 D 0 0
16748 61558 product 0 28312 A 1 D 0 0
17241 61697 product 0 28808 A 1 D 0 0
39608 61083 product 0 51841 A 1 D 0 0
64038 61081 product 0 76271 A 1 D 0 0
64065 61075 product 0 76298 A 1 D 0 0
64069 61071 product 0 76302 A 1 D 0 0
64078 61694 product 0 76311 A 1 D 0 0
64083 65455 product 0 76316 A 1 D 0 0
64090 61684 product 0 76323 A 1 D 0 0
17077 61684 product 0 28610 A 2 D 0 0
17242 61694 product 0 28809 A 2 D 0 0
18735 61083 product 0 30413 A 2 D 0 0
36934 61081 product 0 49167 A 2 D 0 0
36974 61075 product 0 49207 A 2 D 0 0
64068 61071 product 0 76301 A 2 D 0 0
64072 61697 product 0 76305 A 2 D 0 0
64081 65455 product 0 76314 A 2 D 0 0
64093 61558 product 0 76326 A 2 D 0 0
17075 61684 product 0 28608 A 3 D 0 0
17244 61694 product 0 28811 A 3 D 0 0
18257 61081 product 0 29892 A 3 D 0 0
36976 61075 product 0 49209 A 3 D 0 0
64043 61083 product 0 76276 A 3 D 0 0
64070 61071 product 0 76303 A 3 D 0 0
64074 61697 product 0 76307 A 3 D 0 0
64080 65455 product 0 76313 A 3 D 0 0
64094 61558 product 0 76327 A 3 D 0 0
17076 61684 product 0 28609 A 4 D 0 0
17223 61697 product 0 28790 A 4 D 0 0
36932 61081 product 0 49165 A 4 D 0 0
39607 61083 product 0 51840 A 4 D 0 0
64063 61075 product 0 76296 A 4 D 0 0
64066 61071 product 0 76299 A 4 D 0 0
64077 61694 product 0 76310 A 4 D 0 0
64086 65455 product 0 76319 A 4 D 0 0
14422 61083 product 0 25273 A 5 D 0 0
17243 61694 product 0 28810 A 5 D 0 0
64039 61081 product 0 76272 A 5 D 0 0
64064 61075 product 0 76297 A 5 D 0 0
64067 61071 product 0 76300 A 5 D 0 0
64073 61697 product 0 76306 A 5 D 0 0
64084 65455 product 0 76317 A 5 D 0 0
64087 61684 product 0 76320 A 5 D 0 0
17220 61684 product 0 28787 A 6 D 0 0
18736 61083 product 0 30414 A 6 D 0 0
18737 61071 product 0 30415 A 6 D 0 0
36933 61081 product 0 49166 A 6 D 0 0
36975 61075 product 0 49208 A 6 D 0 0
61951 61694 product 0 74184 A 6 C 0 0
64075 61697 product 0 76308 A 6 D 0 0
64085 65455 product 0 76318 A 6 D 0 0
67109 65455 product 0 79342 A 6 C 0 0
18738 61071 product 0 30416 A 7 D 0 0
36977 61075 product 0 49210 A 7 D 0 0
59278 61697 product 0 71511 A 7 C 0 0
61952 61694 product 0 74185 A 7 C 0 0
64042 61083 product 0 76275 A 7 D 0 0
64088 61684 product 0 76321 A 7 D 0 0
65388 61081 product 0 77621 A 7 C 0 0
14280 61075 product 0 25075 A 8 D 0 0
14424 61083 product 0 25275 A 8 C 0 0
17634 61684 product 0 29259 A 8 D 0 0
48961 61071 product 0 61194 A 8 C 0 0
57360 61081 product 0 69593 A 8 C 0 0
59277 61697 product 0 71510 A 8 C 0 0
61953 61694 product 0 74186 A 8 C 0 0
51426 61697 product 0 63659 A 9 C 0 0
55143 61075 product 0 67376 A 9 C 0 0
55543 61081 product 0 67776 A 9 C 0 0
61954 61694 product 0 74187 A 9 C 0 0
68537 61071 product 0 80770 A 9 C 0 0
55144 61075 product 0 67377 A 10 C 0 0
56406 61081 product 0 68639 A 10 C 0 0
59065 61071 product 0 71298 A 10 C 0 0
61982 61697 product 0 74215 A 10 C 0 0
44343 61071 product 0 56576 A 11 C 0 0
55145 61075 product 0 67378 A 11 C 0 0
57233 61697 product 0 69466 A 11 C 0 0
57358 61081 product 0 69591 A 11 C 0 0
51425 61697 product 0 63658 A 12 C 0 0
55544 61081 product 0 67777 A 12 C 0 0
59064 61071 product 0 71297 A 12 C 0 0
65389 61081 product 0 77622 A 12 C 0 0
44352 61071 product 0 56585 A 13 C 0 0
57009 61081 product 0 69242 A 13 C 0 0
59276 61697 product 0 71509 A 13 C 0 0
47355 61697 product 0 59588 A 14 C 0 0
66996 61071 product 0 79229 A 14 C 0 0
47356 61697 product 0 59589 A 15 C 0 0
51427 61697 product 0 63660 A 16 C 0 0