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 (
    65096, 64768, 64771, 64765, 64769, 64274, 
    65067, 64847, 65649, 65101, 65103, 
    65102
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00171

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": 132,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65096,64768,64771,64765,64769,64274,65067,64847,65649,65101,65103,65102)"
        }
      }
    },
    "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
38639 64765 product 0 50872 A 0 D 0 0
38719 64768 product 0 50952 A 0 D 0 0
41719 64847 product 0 53952 A 0 D 0 0
51770 65067 product 0 64003 A 0 D 0 0
62209 65101 product 0 74442 A 0 D 0 0
62210 65101 product 0 74443 A 0 D 0 0
62211 65101 product 0 74444 A 0 D 0 0
62212 65101 product 0 74445 A 0 D 0 0
62213 65101 product 0 74446 A 0 D 0 0
62216 65103 product 0 74449 A 0 D 0 0
62223 65102 product 0 74456 A 0 D 0 0
65010 64769 product 0 77243 A 0 D 0 0
65020 64771 product 0 77253 A 0 D 0 0
65518 65649 product 0 77751 A 0 D 0 0
68776 65101 product 0 81009 A 0 D 0 0
68777 65101 product 0 81010 A 0 D 0 0
68975 65101 product 0 81208 A 0 D 0 0
69571 64274 product 0 81804 A 0 D 0 0
71117 65096 product 0 83350 A 0 D 0 0
29358 64274 product 0 41578 A 1 D 0 0
38642 64765 product 0 50875 A 1 D 0 0
38717 64768 product 0 50950 A 1 D 0 0
52634 65096 product 0 64867 A 1 D 0 0
62220 65102 product 0 74453 A 1 D 0 0
65012 64769 product 0 77245 A 1 D 0 0
65515 65649 product 0 77748 A 1 D 0 0
68769 65103 product 0 81002 A 1 D 0 0
29357 64274 product 0 41577 A 2 D 0 0
38640 64765 product 0 50873 A 2 D 0 0
51771 65067 product 0 64004 A 2 D 0 0
52639 65096 product 0 64872 A 2 D 0 0
62215 65103 product 0 74448 A 2 D 0 0
62221 65102 product 0 74454 A 2 D 0 0
65024 64771 product 0 77257 A 2 D 0 0
65512 65649 product 0 77745 A 2 D 0 0
72704 64768 product 0 84937 A 2 D 0 0
72706 64769 product 0 84939 A 2 D 0 0
30212 64274 product 0 42435 A 3 D 0 0
38643 64765 product 0 50876 A 3 D 0 0
38718 64768 product 0 50951 A 3 D 0 0
41708 64847 product 0 53941 A 3 D 0 0
51790 65067 product 0 64023 A 3 D 0 0
52631 65096 product 0 64864 A 3 D 0 0
62218 65103 product 0 74451 A 3 D 0 0
65007 64769 product 0 77240 A 3 D 0 0
65023 64771 product 0 77256 A 3 D 0 0
65516 65649 product 0 77749 A 3 D 0 0
68775 65102 product 0 81008 A 3 D 0 0
38641 64765 product 0 50874 A 4 D 0 0
38725 64768 product 0 50958 A 4 D 0 0
51789 65067 product 0 64022 A 4 D 0 0
52630 65096 product 0 64863 A 4 D 0 0
62217 65103 product 0 74450 A 4 D 0 0
62222 65102 product 0 74455 A 4 D 0 0
65009 64769 product 0 77242 A 4 D 0 0
65021 64771 product 0 77254 A 4 D 0 0
69569 64274 product 0 81802 A 4 D 0 0
38645 64765 product 0 50878 A 5 D 0 0
38716 64768 product 0 50949 A 5 D 0 0
38730 64769 product 0 50963 A 5 D 0 0
51788 65067 product 0 64021 A 5 D 0 0
52629 65096 product 0 64862 A 5 D 0 0
65025 64771 product 0 77258 A 5 D 0 0
65513 65649 product 0 77746 A 5 D 0 0
68774 65102 product 0 81007 A 5 D 0 0
69570 64274 product 0 81803 A 5 D 0 0
38647 64765 product 0 50880 A 6 D 0 0
38720 64768 product 0 50953 A 6 D 0 0
41709 64847 product 0 53942 A 6 D 0 0
51795 65067 product 0 64028 A 6 C 0 0
52633 65096 product 0 64866 A 6 D 0 0
62224 65102 product 0 74457 A 6 D 0 0
65011 64769 product 0 77244 A 6 D 0 0
65022 64771 product 0 77255 A 6 D 0 0
65517 65649 product 0 77750 A 6 D 0 0
69572 64274 product 0 81805 A 6 D 0 0
52650 65096 product 0 64883 A 7 D 0 0
65008 64769 product 0 77241 A 7 D 0 0
65026 64771 product 0 77259 A 7 D 0 0
67611 64765 product 0 79844 A 7 C 0 0
68020 64847 product 0 80253 A 7 C 0 0
68764 64274 product 0 80997 A 7 C 0 0
40798 64765 product 0 53031 A 8 C 0 0
49855 64769 product 0 62088 A 8 C 0 0
52641 65096 product 0 64874 A 8 C 0 0
61482 64768 product 0 73715 A 8 C 0 0
63843 64847 product 0 76076 A 8 C 0 0
64225 64274 product 0 76458 A 8 C 0 0
66993 64771 product 0 79226 A 8 C 0 0
56279 64274 product 0 68512 A 9 C 0 0
61361 64771 product 0 73594 A 9 C 0 0
61484 64765 product 0 73717 A 9 C 0 0
63844 64847 product 0 76077 A 9 C 0 0
72563 65096 product 0 84796 A 9 C 0 0
38762 64771 product 0 50995 A 10 C 0 0
61418 64274 product 0 73651 A 10 C 0 0
61485 64765 product 0 73718 A 10 C 0 0
62358 65096 product 0 74591 A 10 C 0 0
32330 64274 product 0 44563 A 11 C 0 0
38763 64771 product 0 50996 A 11 C 0 0
40799 64765 product 0 53032 A 11 C 0 0
52642 65096 product 0 64875 A 11 C 0 0
30961 64274 product 0 43194 A 12 C 0 0
54137 65096 product 0 66370 A 12 C 0 0
61362 64771 product 0 73595 A 12 C 0 0
61483 64765 product 0 73716 A 12 C 0 0
65381 64847 product 0 77614 A 12 C 0 0
31646 64274 product 0 43879 A 13 C 0 0
38766 64771 product 0 50999 A 13 C 0 0
48877 64765 product 0 61110 A 13 C 0 0
52643 65096 product 0 64876 A 13 C 0 0
65382 64847 product 0 77615 A 13 C 0 0
35930 64274 product 0 48163 A 14 C 0 0
40797 64765 product 0 53030 A 14 C 0 0
48371 64771 product 0 60604 A 14 C 0 0
52632 65096 product 0 64865 A 14 C 0 0
65383 64847 product 0 77616 A 14 C 0 0
33330 64274 product 0 45563 A 15 C 0 0
46717 64765 product 0 58950 A 15 C 0 0
52644 65096 product 0 64877 A 15 C 0 0
67571 64847 product 0 79804 A 15 C 0 0
40800 64765 product 0 53033 A 16 C 0 0
52645 65096 product 0 64878 A 16 C 0 0
56280 64274 product 0 68513 A 16 C 1 1781
52653 65096 product 0 64886 A 17 C 0 0
61487 64765 product 0 73720 A 17 C 0 0
46718 64765 product 0 58951 A 18 C 0 0
65002 65096 product 0 77235 A 18 C 0 0
61486 64765 product 0 73719 A 19 C 0 0
65274 65096 product 0 77507 A 19 C 0 0
65275 65096 product 0 77508 A 20 C 0 0
65703 65096 product 0 77936 A 21 D 0 0