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 (62226, 63384, 62984, 64275, 63813) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00151

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": 88,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62226,63384,62984,64275,63813)"
        }
      }
    },
    "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
23742 62984 product 0 35673 A 0 D 0 0
27451 63813 product 0 39628 A 0 D 0 0
31649 63384 product 0 43882 A 0 D 0 0
48108 62226 product 0 60341 A 0 D 0 0
69566 64275 product 0 81799 A 0 D 0 0
23741 62984 product 0 35672 A 1 D 0 0
25729 63384 product 0 37866 A 1 D 0 0
27488 63813 product 0 39665 A 1 C 0 0
29369 64275 product 0 41589 A 1 D 0 0
29930 62226 product 0 42153 A 1 D 0 0
20686 62226 product 0 32515 A 2 D 0 0
23743 62984 product 0 35674 A 2 D 0 0
27462 63813 product 0 39639 A 2 D 0 0
30991 63384 product 0 43224 A 2 D 0 0
69568 64275 product 0 81801 A 2 D 0 0
20687 62226 product 0 32516 A 3 D 0 0
27465 63813 product 0 39642 A 3 D 0 0
31650 63384 product 0 43883 A 3 D 0 0
64338 62984 product 0 76571 A 3 C 0 0
69565 64275 product 0 81798 A 3 D 0 0
27464 63813 product 0 39641 A 4 D 0 0
29197 62984 product 0 41417 A 4 C 0 0
29366 64275 product 0 41586 A 4 D 0 0
29928 62226 product 0 42151 A 4 D 0 0
30992 63384 product 0 43225 A 4 D 0 0
20649 62226 product 0 32478 A 5 D 0 0
28572 63813 product 0 40771 A 5 C 0 0
29348 64275 product 0 41568 A 5 D 0 0
30993 63384 product 0 43226 A 5 D 0 0
62269 62984 product 0 74502 A 5 C 0 0
27467 63813 product 0 39644 A 6 D 0 0
29196 62984 product 0 41416 A 6 C 0 0
48110 62226 product 0 60343 A 6 D 0 0
59060 63384 product 0 71293 A 6 D 0 0
69567 64275 product 0 81800 A 6 D 0 0
27466 63813 product 0 39643 A 7 D 0 0
29929 62226 product 0 42152 A 7 D 0 0
30995 63384 product 0 43228 A 7 D 0 0
31984 64275 product 0 44217 A 7 C 0 0
62270 62984 product 0 74503 A 7 C 0 0
20646 62226 product 0 32475 A 8 D 0 0
27452 63813 product 0 39629 A 8 D 0 0
30996 63384 product 0 43229 A 8 D 0 0
31983 64275 product 0 44216 A 8 C 0 0
27463 63813 product 0 39640 A 9 D 0 0
30997 63384 product 0 43230 A 9 D 0 0
48111 62226 product 0 60344 A 9 D 0 0
62807 64275 product 0 75040 A 9 C 0 0
20648 62226 product 0 32477 A 10 D 0 0
27435 63813 product 0 39612 A 10 D 0 0
30994 63384 product 0 43227 A 10 D 0 0
62808 64275 product 0 75041 A 10 C 0 0
27436 63813 product 0 39613 A 11 D 0 0
48109 62226 product 0 60342 A 11 D 0 0
52019 63813 product 0 64252 A 11 C 0 0
52020 63813 product 0 64253 A 11 C 0 0
61711 63384 product 0 73944 A 11 C 0 0
66854 63813 product 0 79087 A 11 C 0 0
31972 63384 product 0 44205 A 12 C 0 0
47940 62226 product 0 60173 A 12 C 0 0
52349 62226 product 0 64582 A 13 C 0 0
59481 63384 product 0 71714 A 13 C 0 0
47943 62226 product 0 60176 A 14 C 0 0
59480 63384 product 0 71713 A 14 C 0 0
47941 62226 product 0 60174 A 15 C 0 0
61712 63384 product 0 73945 A 15 C 0 0
36575 63384 product 0 48808 A 16 C 0 0
55633 62226 product 0 67866 A 16 C 0 0
32872 63384 product 0 45105 A 17 C 1 1781
61710 62226 product 0 73943 A 17 C 0 0
31971 63384 product 0 44204 A 18 C 0 0
60282 62226 product 0 72515 A 18 C 0 0
32871 63384 product 0 45104 A 19 C 0 0
47942 62226 product 0 60175 A 19 C 0 0
36576 63384 product 0 48809 A 20 C 0 0
55632 62226 product 0 67865 A 20 C 0 0
60281 62226 product 0 72514 A 21 C 0 0
69140 63384 product 0 81373 A 21 C 0 0
49849 63384 product 0 62082 A 22 C 0 0
52348 62226 product 0 64581 A 22 C 0 0
36577 63384 product 0 48810 A 23 C 0 0
52552 62226 product 0 64785 A 23 C 0 0
48113 62226 product 0 60346 A 24 C 0 0
51716 63384 product 0 63949 A 24 C 0 0
60815 62226 product 0 73048 A 25 C 0 0
62272 63384 product 0 74505 A 25 C 0 0
48112 62226 product 0 60345 A 26 C 0 0
68371 62226 product 0 80604 A 26 C 0 0