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 (
    64657, 64857, 60745, 61430, 64904, 64794, 
    65091, 62240, 64786, 64790, 65481, 
    64849
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00134

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": 100,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64657,64857,60745,61430,64904,64794,65091,62240,64786,64790,65481,64849)"
        }
      }
    },
    "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
17852 61430 product 0 29481 A 0 D 0 0
39643 64786 product 0 51876 A 0 D 0 0
39681 64790 product 0 51914 A 0 D 0 0
39703 64794 product 0 51936 A 0 D 0 0
42569 64849 product 0 54802 A 0 D 0 0
46519 64857 product 0 58752 A 0 D 0 0
46901 62240 product 0 59134 A 0 D 0 0
47838 64904 product 0 60071 A 0 D 0 0
47839 64904 product 0 60072 A 0 D 0 0
47875 64904 product 0 60108 A 0 D 0 0
47876 64904 product 0 60109 A 0 D 0 0
47877 64904 product 0 60110 A 0 D 0 0
55910 65091 product 0 68143 A 0 D 0 0
57250 64657 product 0 69483 A 0 D 0 0
61378 65481 product 0 73611 A 0 D 0 0
61383 65481 product 0 73616 A 0 D 0 0
62289 60745 product 0 74522 A 0 D 0 0
16153 61430 product 0 27673 A 1 D 0 0
20856 62240 product 0 32692 A 1 D 0 0
42570 64849 product 0 54803 A 1 D 0 0
46520 64857 product 0 58753 A 1 D 0 0
55909 65091 product 0 68142 A 1 D 0 0
56723 64657 product 0 68956 A 1 D 0 0
59586 62240 product 0 71819 A 1 D 0 0
61379 65481 product 0 73612 A 1 D 0 0
62290 60745 product 0 74523 A 1 D 0 0
66564 64794 product 0 78797 A 1 D 0 0
66603 64790 product 0 78836 A 1 D 0 0
66690 64786 product 0 78923 A 1 D 0 0
32632 61430 product 0 44865 A 2 D 0 0
39682 64790 product 0 51915 A 2 D 0 0
39701 64794 product 0 51934 A 2 D 0 0
42574 64849 product 0 54807 A 2 D 0 0
46521 64857 product 0 58754 A 2 D 0 0
55906 65091 product 0 68139 A 2 D 0 0
57249 64657 product 0 69482 A 2 D 0 0
61382 65481 product 0 73615 A 2 D 0 0
62291 60745 product 0 74524 A 2 D 0 0
66693 64786 product 0 78926 A 2 D 0 0
16154 61430 product 0 27674 A 3 D 0 0
33581 60745 product 0 45814 A 3 C 0 0
39683 64790 product 0 51916 A 3 D 0 0
42573 64849 product 0 54806 A 3 D 0 0
46522 64857 product 0 58755 A 3 D 0 0
55905 65091 product 0 68138 A 3 D 0 0
56725 64657 product 0 68958 A 3 D 0 0
61386 65481 product 0 73619 A 3 D 0 0
66692 64786 product 0 78925 A 3 D 0 0
36566 60745 product 0 48799 A 4 C 0 0
39641 64786 product 0 51874 A 4 D 0 0
42571 64849 product 0 54804 A 4 D 0 0
46523 64857 product 0 58756 A 4 D 0 0
55904 65091 product 0 68137 A 4 D 0 0
56727 64657 product 0 68960 A 4 D 0 0
61381 65481 product 0 73614 A 4 D 0 0
66563 64794 product 0 78796 A 4 D 0 0
66600 64790 product 0 78833 A 4 D 0 0
39700 64794 product 0 51933 A 5 D 0 0
42572 64849 product 0 54805 A 5 D 0 0
47271 64857 product 0 59504 A 5 D 0 0
55907 65091 product 0 68140 A 5 D 0 0
56041 60745 product 0 68274 A 5 C 0 0
57247 64657 product 0 69480 A 5 D 0 0
61384 65481 product 0 73617 A 5 D 0 0
66601 64790 product 0 78834 A 5 D 0 0
66691 64786 product 0 78924 A 5 D 0 0
39642 64786 product 0 51875 A 6 D 0 0
42577 64849 product 0 54810 A 6 D 0 0
46524 64857 product 0 58757 A 6 D 0 0
55908 65091 product 0 68141 A 6 D 0 0
57251 64657 product 0 69484 A 6 D 0 0
61231 60745 product 0 73464 A 6 C 0 0
61392 65481 product 0 73625 A 6 D 0 0
66562 64794 product 0 78795 A 6 D 0 0
66602 64790 product 0 78835 A 6 D 0 0
33583 60745 product 0 45816 A 7 C 0 0
46525 64857 product 0 58758 A 7 D 0 0
53351 64849 product 0 65584 A 7 C 0 0
57281 64657 product 0 69514 A 7 D 0 0
61380 65481 product 0 73613 A 7 D 0 0
61434 64790 product 0 73667 A 7 C 0 0
43912 64849 product 0 56145 A 8 C 0 0
46526 64857 product 0 58759 A 8 D 0 0
56402 60745 product 0 68635 A 8 C 0 0
53363 64849 product 0 65596 A 9 C 0 0
58497 60745 product 0 70730 A 9 C 0 0
61391 65481 product 0 73624 A 9 D 0 0
66929 64849 product 0 79162 A 9 C 0 0
66930 64849 product 0 79163 A 9 C 0 0
69186 64857 product 0 81419 A 9 C 0 0
46516 64857 product 0 58749 A 10 C 0 0
61385 65481 product 0 73618 A 10 D 0 0
61390 65481 product 0 73623 A 11 D 0 0
61387 65481 product 0 73620 A 12 D 0 0
61388 65481 product 0 73621 A 13 D 0 0
61389 65481 product 0 73622 A 14 D 0 0
61409 65481 product 0 73642 A 15 C 0 0
61410 65481 product 0 73643 A 16 C 0 0
62402 65481 product 0 74635 A 17 C 0 0
64855 65481 product 0 77088 A 18 C 0 0