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 (
    62424, 63237, 64960, 62418, 62333, 64374, 
    64468, 64375, 64932, 62704, 61273, 
    64470
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00107

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": 92,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62424,63237,64960,62418,62333,64374,64468,64375,64932,62704,61273,64470)"
        }
      }
    },
    "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
21282 62333 product 0 33163 A 0 D 0 0
21612 62418 product 0 33493 A 0 D 0 0
30642 62418 product 0 42874 A 0 D 0 0
30711 64375 product 0 42943 A 0 D 0 0
30712 64375 product 0 42944 A 0 D 0 0
30744 64374 product 0 42976 A 0 D 0 0
30746 64375 product 0 42978 A 0 D 0 0
30747 64375 product 0 42979 A 0 D 0 0
31184 64470 product 0 43417 A 0 D 0 0
31190 64468 product 0 43423 A 0 D 0 0
49522 64960 product 0 61755 A 0 D 0 0
63103 64932 product 0 75336 A 0 D 0 0
63104 64932 product 0 75337 A 0 D 0 0
64832 62704 product 0 77065 A 0 D 0 0
64846 61273 product 0 77079 A 0 D 0 0
65398 63237 product 0 77631 A 0 D 0 0
66173 62424 product 0 78406 A 0 D 0 0
66451 62418 product 0 78684 A 0 D 0 0
66452 62418 product 0 78685 A 0 D 0 0
66453 62418 product 0 78686 A 0 D 0 0
66454 62418 product 0 78687 A 0 D 0 0
66455 62418 product 0 78688 A 0 D 0 0
66456 62418 product 0 78689 A 0 D 0 0
66457 62418 product 0 78690 A 0 D 0 0
21631 62424 product 0 33512 A 1 D 0 0
24970 63237 product 0 37046 A 1 D 0 0
31193 64468 product 0 43426 A 1 D 0 0
47762 64932 product 0 59995 A 1 D 0 0
49523 64960 product 0 61756 A 1 D 0 0
64848 61273 product 0 77081 A 1 D 0 0
68117 64374 product 0 80350 A 1 D 0 0
71038 62333 product 0 83271 A 1 D 0 0
72673 62704 product 0 84906 A 1 D 0 0
21283 62333 product 0 33164 A 2 D 0 0
31185 64470 product 0 43418 A 2 D 0 0
31191 64468 product 0 43424 A 2 D 0 0
32152 63237 product 0 44385 A 2 D 0 0
47763 64932 product 0 59996 A 2 D 0 0
62845 64960 product 0 75078 A 2 D 0 0
64833 62704 product 0 77066 A 2 D 0 0
66169 62424 product 0 78402 A 2 D 0 0
68113 64374 product 0 80346 A 2 D 0 0
72668 61273 product 0 84901 A 2 D 0 0
24492 62333 product 0 36473 A 3 D 0 0
31186 64470 product 0 43419 A 3 D 0 0
31194 64468 product 0 43427 A 3 D 0 0
31195 64468 product 0 43428 A 3 D 0 0
56236 62704 product 0 68469 A 3 C 0 0
63102 64932 product 0 75335 A 3 D 0 0
64854 61273 product 0 77087 A 3 D 0 0
65396 63237 product 0 77629 A 3 D 0 0
66172 62424 product 0 78405 A 3 D 0 0
68115 64374 product 0 80348 A 3 D 0 0
31183 64470 product 0 43416 A 4 D 0 0
31192 64468 product 0 43425 A 4 D 0 0
32168 62333 product 0 44401 A 4 D 0 0
47761 64932 product 0 59994 A 4 D 0 0
56261 62704 product 0 68494 A 4 C 1 1781
62847 64960 product 0 75080 A 4 D 0 0
64914 64468 product 0 77147 A 4 C 0 0
64915 64468 product 0 77148 A 4 C 0 0
66170 62424 product 0 78403 A 4 D 0 0
68114 64374 product 0 80347 A 4 D 0 0
69177 61273 product 0 81410 A 4 C 0 0
21284 62333 product 0 33165 A 5 D 0 0
55620 61273 product 0 67853 A 5 C 0 0
62848 64960 product 0 75081 A 5 D 0 0
63101 64932 product 0 75334 A 5 D 0 0
65380 64932 product 0 77613 A 5 C 0 0
65395 63237 product 0 77628 A 5 D 0 0
66171 62424 product 0 78404 A 5 D 0 0
66678 64932 product 0 78911 A 5 C 0 0
66679 64932 product 0 78912 A 5 C 0 0
66681 64932 product 0 78914 A 5 C 0 0
66685 62704 product 0 78918 A 5 C 0 0
68116 64374 product 0 80349 A 5 D 0 0
56005 64960 product 0 68238 A 6 C 0 0
65399 63237 product 0 77632 A 6 D 0 0
65577 62333 product 0 77810 A 6 D 0 0
66174 62424 product 0 78407 A 6 D 0 0
66686 62704 product 0 78919 A 6 C 0 0
68118 64374 product 0 80351 A 6 D 0 0
69176 61273 product 0 81409 A 6 C 0 0
55618 61273 product 0 67851 A 7 C 0 0
64388 64374 product 0 76621 A 7 C 0 0
65578 62333 product 0 77811 A 7 D 0 0
32170 62333 product 0 44403 A 8 C 0 0
64387 64374 product 0 76620 A 8 C 0 0
68672 62418 product 0 80905 A 8 C 0 0
68686 62418 product 0 80919 A 8 C 0 0
64386 64374 product 0 76619 A 9 C 0 0
65615 62333 product 0 77848 A 9 C 0 0