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 (
    64622, 60741, 64623, 64626, 60747, 62254, 
    60730, 62260, 60740, 61387, 60742, 
    61171
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00112

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": 81,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64622,60741,64623,64626,60747,62254,60730,62260,60740,61387,60742,61171)"
        }
      }
    },
    "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
33624 60742 product 0 45857 A 0 D 0 0
53865 62260 product 0 66098 A 0 D 0 0
57273 60747 product 0 69506 A 0 D 0 0
61180 60740 product 0 73413 A 0 D 0 0
62310 61171 product 0 74543 A 0 D 0 0
62316 61387 product 0 74549 A 0 D 0 0
62338 60730 product 0 74571 A 0 D 0 0
70450 64622 product 0 82683 A 0 D 0 0
70451 64623 product 0 82684 A 0 D 0 0
70455 64626 product 0 82688 A 0 D 0 0
32576 64623 product 0 44809 A 1 D 0 0
32577 64622 product 0 44810 A 1 D 0 0
33630 60747 product 0 45863 A 1 C 0 0
33653 60740 product 0 45886 A 1 D 0 0
53866 62260 product 0 66099 A 1 D 0 0
61182 60742 product 0 73415 A 1 D 0 0
62311 61171 product 0 74544 A 1 D 0 0
62317 61387 product 0 74550 A 1 D 0 0
62339 60730 product 0 74572 A 1 D 0 0
57238 60747 product 0 69471 A 2 C 0 0
57326 62260 product 0 69559 A 2 D 0 0
59021 64623 product 0 71254 A 2 D 0 0
61728 60740 product 0 73961 A 2 D 0 0
62312 61171 product 0 74545 A 2 D 0 0
62318 61387 product 0 74551 A 2 D 0 0
62340 60730 product 0 74573 A 2 D 0 0
64761 60742 product 0 76994 A 2 D 0 0
33692 60740 product 0 45925 A 3 D 0 0
33721 60742 product 0 45954 A 3 D 0 0
33740 60730 product 0 45973 A 3 C 0 0
57055 62260 product 0 69288 A 3 C 0 0
59026 64623 product 0 71259 A 3 D 0 0
65718 61171 product 0 77951 A 3 C 0 0
68024 61387 product 0 80257 A 3 D 0 0
33678 60747 product 0 45911 A 4 C 0 0
52283 61171 product 0 64516 A 4 C 0 0
55619 60730 product 0 67852 A 4 C 0 0
57056 62260 product 0 69289 A 4 C 0 0
57268 60740 product 0 69501 A 4 D 0 0
67566 60742 product 0 79799 A 4 C 0 0
68022 61387 product 0 80255 A 4 D 0 0
56391 61171 product 0 68624 A 5 C 0 0
56444 60730 product 0 68677 A 5 C 0 0
57057 62260 product 0 69290 A 5 C 0 0
61729 60740 product 0 73962 A 5 D 0 0
68023 61387 product 0 80256 A 5 D 0 0
56392 61171 product 0 68625 A 6 C 0 0
56393 60740 product 0 68626 A 6 D 0 0
59547 62260 product 0 71780 A 6 C 0 0
62799 60730 product 0 75032 A 6 C 0 0
65620 60742 product 0 77853 A 6 C 0 0
68025 61387 product 0 80258 A 6 D 0 0
33629 61171 product 0 45862 A 7 C 0 0
47578 60740 product 0 59811 A 7 C 0 0
57058 62260 product 0 69291 A 7 C 0 0
57239 60747 product 0 69472 A 7 C 0 0
57245 60730 product 0 69478 A 7 C 0 0
60373 60742 product 0 72606 A 7 C 0 0
68016 61387 product 0 80249 A 7 C 0 0
33677 60742 product 0 45910 A 8 C 0 0
56134 60740 product 0 68367 A 8 C 0 0
57242 60747 product 0 69475 A 8 C 0 0
60111 61171 product 0 72344 A 8 C 0 0
62798 60730 product 0 75031 A 8 C 0 0
57240 60747 product 0 69473 A 9 C 0 0
58294 60742 product 0 70527 A 9 C 0 0
60112 61171 product 0 72345 A 9 C 0 0
61803 60740 product 0 74036 A 9 C 0 0
62800 60730 product 0 75033 A 9 C 0 0
57231 60740 product 0 69464 A 10 C 0 0
57393 60742 product 0 69626 A 10 C 0 0
60017 60747 product 0 72250 A 10 C 0 0
60110 61171 product 0 72343 A 10 C 0 0
58976 60740 product 0 71209 A 11 C 0 0
60113 61171 product 0 72346 A 11 C 0 0
61176 60747 product 0 73409 A 11 C 0 0
61883 60747 product 0 74116 A 11 C 0 0
66750 60742 product 0 78983 A 11 C 0 0
61802 60740 product 0 74035 A 12 C 0 0