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 (
    64744, 64745, 64749, 64747, 64746, 65301
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00144

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": 86,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64744,64745,64749,64747,64746,65301)"
        }
      }
    },
    "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
37720 64744 product 0 49953 A 0 D 0 0
37725 64745 product 0 49958 A 0 D 0 0
37736 64746 product 0 49969 A 0 D 0 0
37781 64749 product 0 50014 A 0 D 0 0
63087 64747 product 0 75320 A 0 D 0 0
63560 65301 product 0 75793 A 0 D 0 0
65895 64749 product 0 78128 A 0 C 0 0
65897 64749 product 0 78130 A 0 C 0 0
37707 64744 product 0 49940 A 1 D 0 0
37728 64745 product 0 49961 A 1 D 0 0
37737 64746 product 0 49970 A 1 D 0 0
47892 64749 product 0 60125 A 1 D 0 0
56614 65301 product 0 68847 A 1 D 0 0
63088 64747 product 0 75321 A 1 D 0 0
37735 64745 product 0 49968 A 2 D 0 0
37747 64746 product 0 49980 A 2 D 0 0
37750 64747 product 0 49983 A 2 D 0 0
37782 64749 product 0 50015 A 2 D 0 0
63099 64744 product 0 75332 A 2 D 0 0
63559 65301 product 0 75792 A 2 D 0 0
37708 64744 product 0 49941 A 3 D 0 0
37740 64746 product 0 49973 A 3 D 0 0
37749 64747 product 0 49982 A 3 D 0 0
56615 65301 product 0 68848 A 3 D 0 0
63118 64749 product 0 75351 A 3 D 0 0
37710 64744 product 0 49943 A 4 D 0 0
37730 64745 product 0 49963 A 4 D 0 0
37751 64747 product 0 49984 A 4 D 0 0
47894 64749 product 0 60127 A 4 D 0 0
56612 65301 product 0 68845 A 4 D 0 0
37711 64744 product 0 49944 A 5 D 0 0
37733 64745 product 0 49966 A 5 D 0 0
47884 64749 product 0 60117 A 5 D 0 0
59118 65301 product 0 71351 A 5 D 0 0
63077 64746 product 0 75310 A 5 D 0 0
37719 64744 product 0 49952 A 6 D 0 0
37732 64745 product 0 49965 A 6 D 0 0
37738 64746 product 0 49971 A 6 D 0 0
37752 64747 product 0 49985 A 6 D 0 0
56616 65301 product 0 68849 A 6 D 0 0
37709 64744 product 0 49942 A 7 D 0 0
59119 65301 product 0 71352 A 7 D 0 0
63074 64746 product 0 75307 A 7 D 0 0
63117 64749 product 0 75350 A 7 D 0 0
37726 64745 product 0 49959 A 8 D 0 0
37746 64746 product 0 49979 A 8 D 0 0
37756 64747 product 0 49989 A 8 D 0 0
63100 64744 product 0 75333 A 8 D 0 0
63561 65301 product 0 75794 A 8 D 0 0
37727 64745 product 0 49960 A 9 D 0 0
37753 64747 product 0 49986 A 9 D 0 0
56613 65301 product 0 68846 A 9 D 0 0
63073 64746 product 0 75306 A 9 D 0 0
63098 64744 product 0 75331 A 9 D 0 0
63116 64749 product 0 75349 A 9 D 0 0
37712 64744 product 0 49945 A 10 D 0 0
37757 64747 product 0 49990 A 10 D 0 0
56313 64745 product 0 68546 A 10 C 0 0
59054 64749 product 0 71287 A 10 D 0 0
63075 64746 product 0 75308 A 10 D 0 0
55997 64744 product 0 68230 A 11 C 0 0
56314 64745 product 0 68547 A 11 C 0 0
60046 64749 product 0 72279 A 11 C 0 0
62362 64747 product 0 74595 A 11 C 0 0
63076 64746 product 0 75309 A 11 D 0 0
68677 64745 product 0 80910 A 11 C 0 0
68678 64745 product 0 80911 A 11 C 0 0
60045 64749 product 0 72278 A 12 C 0 0
61870 64747 product 0 74103 A 12 C 0 0
54123 64749 product 0 66356 A 13 C 0 0
55441 64744 product 0 67674 A 13 C 0 0
54121 64749 product 0 66354 A 14 C 0 0
55442 64744 product 0 67675 A 14 C 0 0
65078 64747 product 0 77311 A 14 C 0 0
54122 64749 product 0 66355 A 15 C 0 0
61505 64744 product 0 73738 A 15 C 0 0
65079 64747 product 0 77312 A 15 C 0 0
37713 64744 product 0 49946 A 16 C 0 0
65080 64747 product 0 77313 A 16 C 0 0
55443 64744 product 0 67676 A 17 C 0 0
57390 64744 product 0 69623 A 18 C 0 0
61869 64744 product 0 74102 A 19 C 0 0
37717 64744 product 0 49950 A 20 C 0 0
37714 64744 product 0 49947 A 21 C 0 0
56900 64744 product 0 69133 A 22 C 0 0
37715 64744 product 0 49948 A 23 C 0 0