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 (62861, 64900, 61326, 64871) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00081

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": 59,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62861,64900,61326,64871)"
        }
      }
    },
    "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
15379 61326 product 0 26826 A 0 D 0 0
23212 62861 product 0 35127 A 0 D 0 0
47821 64900 product 0 60054 A 0 D 0 0
47945 64871 product 0 60178 A 0 D 0 0
15380 61326 product 0 26827 A 1 D 0 0
23213 62861 product 0 35128 A 1 D 0 0
47822 64900 product 0 60055 A 1 D 0 0
23214 62861 product 0 35129 A 2 D 0 0
31696 61326 product 0 43929 A 2 D 0 0
47823 64900 product 0 60056 A 2 D 0 0
47947 64871 product 0 60180 A 2 D 0 0
31701 61326 product 0 43934 A 3 D 0 0
31730 62861 product 0 43963 A 3 D 0 0
47828 64900 product 0 60061 A 3 D 0 0
47948 64871 product 0 60181 A 3 D 0 0
15378 61326 product 0 26825 A 4 D 0 0
31732 62861 product 0 43965 A 4 D 0 0
47824 64900 product 0 60057 A 4 D 0 0
47949 64871 product 0 60182 A 4 D 0 0
31731 62861 product 0 43964 A 5 D 0 0
45079 61326 product 0 57312 A 5 C 0 0
47951 64871 product 0 60184 A 5 D 0 0
31733 62861 product 0 43966 A 6 D 0 0
47825 64900 product 0 60058 A 6 D 0 0
47950 64871 product 0 60183 A 6 D 0 0
56274 61326 product 0 68507 A 6 C 0 0
47826 64900 product 0 60059 A 7 D 0 0
57079 61326 product 0 69312 A 7 C 0 0
59187 62861 product 0 71420 A 7 C 0 0
61197 64900 product 0 73430 A 7 D 0 0
67765 64900 product 0 79998 A 7 C 0 0
67766 64900 product 0 79999 A 7 C 0 0
67767 64900 product 0 80000 A 7 C 0 0
32437 61326 product 0 44670 A 8 C 0 0
59188 62861 product 0 71421 A 8 C 0 0
57046 61326 product 0 69279 A 9 C 0 0
59047 62861 product 0 71280 A 9 C 0 0
57078 61326 product 0 69311 A 10 C 0 0
59045 62861 product 0 71278 A 10 C 0 0
56275 61326 product 0 68508 A 11 C 0 0
59044 62861 product 0 71277 A 11 C 0 0
32506 61326 product 0 44739 A 12 C 0 0
59046 62861 product 0 71279 A 12 C 0 0
51667 61326 product 0 63900 A 13 C 0 0
59048 62861 product 0 71281 A 13 C 0 0
31974 61326 product 0 44207 A 14 C 0 0
32439 61326 product 0 44672 A 15 C 0 0
19264 61326 product 0 30976 A 16 C 0 0
31702 61326 product 0 43935 A 17 C 0 0
61427 61326 product 0 73660 A 18 C 0 0
32515 61326 product 0 44748 A 19 C 0 0
32525 61326 product 0 44758 A 20 C 0 0
18317 61326 product 0 29961 A 21 C 0 0
61428 61326 product 0 73661 A 22 C 0 0
35126 61326 product 0 47359 A 23 C 0 0
17200 61326 product 0 28757 A 24 C 0 0
32876 61326 product 0 45109 A 25 C 0 0
20719 61326 product 0 32548 A 26 C 0 0
28327 61326 product 0 40520 A 27 C 0 0