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 (
    64941, 62258, 60732, 60733, 60737, 64621, 
    61385, 64942, 60751, 60735, 64943, 
    64339, 63128, 60738, 62671, 64340, 
    61386, 64620, 64815, 65519, 65568, 
    65851, 65870, 65875
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00194

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": 112,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64941,62258,60732,60733,60737,64621,61385,64942,60751,60735,64943,64339,63128,60738,62671,64340,61386,64620,64815,65519,65568,65851,65870,65875)"
        }
      }
    },
    "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
33631 60733 product 0 45864 A 0 D 0 0
33719 61386 product 0 45952 A 0 C 0 0
48356 64943 product 0 60589 A 0 D 0 0
48358 64941 product 0 60591 A 0 D 0 0
48361 64942 product 0 60594 A 0 D 0 0
53868 62258 product 0 66101 A 0 D 0 0
53869 62258 product 0 66102 A 0 D 0 0
57047 62258 product 0 69280 A 0 C 0 0
57048 62258 product 0 69281 A 0 C 0 0
57049 62258 product 0 69282 A 0 C 0 0
57050 62258 product 0 69283 A 0 C 0 0
57327 62258 product 0 69560 A 0 D 0 0
60807 61385 product 0 73040 A 0 C 0 0
60855 65519 product 0 73088 A 0 D 0 0
60880 64943 product 0 73113 A 0 D 0 0
60881 64943 product 0 73114 A 0 D 0 0
60882 64943 product 0 73115 A 0 D 0 0
60883 64943 product 0 73116 A 0 D 0 0
60884 64941 product 0 73117 A 0 D 0 0
60885 64941 product 0 73118 A 0 D 0 0
60886 64941 product 0 73119 A 0 D 0 0
60887 64941 product 0 73120 A 0 D 0 0
61193 60732 product 0 73426 A 0 D 0 0
62275 60738 product 0 74508 A 0 D 0 0
62276 60738 product 0 74509 A 0 D 0 0
62277 60738 product 0 74510 A 0 D 0 0
62301 60751 product 0 74534 A 0 D 0 0
62322 64339 product 0 74555 A 0 D 0 0
62325 64340 product 0 74558 A 0 D 0 0
62328 60735 product 0 74561 A 0 D 0 0
62334 60737 product 0 74567 A 0 D 0 0
63136 62671 product 0 75369 A 0 D 0 0
63448 65568 product 0 75681 A 0 D 0 0
63449 65568 product 0 75682 A 0 D 0 0
63450 65568 product 0 75683 A 0 D 0 0
63455 65568 product 0 75688 A 0 D 0 0
63456 65568 product 0 75689 A 0 D 0 0
66146 61386 product 0 78379 A 0 C 0 0
70146 65851 product 0 82379 A 0 D 0 0
70185 65870 product 0 82418 A 0 D 0 0
70297 65875 product 0 82530 A 0 D 0 0
70454 64620 product 0 82687 A 0 D 0 0
70456 64621 product 0 82689 A 0 D 0 0
33633 60733 product 0 45866 A 1 D 0 0
59024 64620 product 0 71257 A 1 D 0 0
59779 64621 product 0 72012 A 1 C 0 0
60808 61385 product 0 73041 A 1 C 0 0
60852 65519 product 0 73085 A 1 D 0 0
60876 64942 product 0 73109 A 1 D 0 0
61732 60732 product 0 73965 A 1 C 0 0
62302 60751 product 0 74535 A 1 D 0 0
62323 64339 product 0 74556 A 1 D 0 0
62326 64340 product 0 74559 A 1 D 0 0
62329 60735 product 0 74562 A 1 D 0 0
62335 60737 product 0 74568 A 1 D 0 0
63135 62671 product 0 75368 A 1 D 0 0
33632 60733 product 0 45865 A 2 C 0 0
33722 61385 product 0 45955 A 2 C 0 0
57220 60733 product 0 69453 A 2 C 0 0
57279 60732 product 0 69512 A 2 C 0 0
59029 64620 product 0 71262 A 2 D 0 0
59784 64621 product 0 72017 A 2 C 0 0
60851 65519 product 0 73084 A 2 D 0 0
60877 64942 product 0 73110 A 2 D 0 0
62303 60751 product 0 74536 A 2 D 0 0
62324 64339 product 0 74557 A 2 D 0 0
62327 64340 product 0 74560 A 2 D 0 0
62330 60735 product 0 74563 A 2 D 0 0
62336 60737 product 0 74569 A 2 D 0 0
63138 62671 product 0 75371 A 2 D 0 0
68748 60733 product 0 80981 A 2 C 0 0
74003 64621 product 0 86236 A 2 D 0 0
74004 64621 product 0 86237 A 2 D 0 0
33744 64340 product 0 45977 A 3 C 0 0
33755 60751 product 0 45988 A 3 C 0 0
55877 61385 product 0 68110 A 3 C 0 0
56047 64339 product 0 68280 A 3 C 0 0
56124 60737 product 0 68357 A 3 C 0 0
59033 64620 product 0 71266 A 3 D 0 0
60854 65519 product 0 73087 A 3 D 0 0
60879 64942 product 0 73112 A 3 D 0 0
63137 62671 product 0 75370 A 3 D 0 0
33726 61385 product 0 45959 A 4 C 0 0
46459 62671 product 0 58692 A 4 D 0 0
49914 64339 product 0 62147 A 4 C 0 0
56125 60737 product 0 68358 A 4 C 0 0
56126 60735 product 0 68359 A 4 C 0 0
56386 64340 product 0 68619 A 4 C 0 0
59035 64620 product 0 71268 A 4 D 0 0
60853 65519 product 0 73086 A 4 D 0 0
60878 64942 product 0 73111 A 4 D 0 0
46465 62671 product 0 58698 A 5 D 0 0
52140 64339 product 0 64373 A 5 C 0 0
55878 61385 product 0 68111 A 5 C 0 0
56127 60735 product 0 68360 A 5 C 0 0
57032 64340 product 0 69265 A 5 C 0 0
22718 62671 product 0 34616 A 6 D 0 0
54233 64339 product 0 66466 A 6 C 0 0
56067 61385 product 0 68300 A 6 C 0 0
58493 64340 product 0 70726 A 6 C 0 0
54234 64339 product 0 66467 A 7 C 0 0
55536 61385 product 0 67769 A 7 C 0 0
60334 60735 product 0 72567 A 7 C 0 0
62407 64340 product 0 74640 A 7 C 0 0
56053 64339 product 0 68286 A 8 C 0 0
56051 64339 product 0 68284 A 9 C 0 0
58890 64339 product 0 71123 A 11 C 0 0
61882 64339 product 0 74115 A 12 C 0 0
60029 64339 product 0 72262 A 13 C 0 0
60030 64339 product 0 72263 A 14 C 0 0