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 (62229, 63513, 64353, 64865) 
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": 73,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (62229,63513,64353,64865)"
        }
      }
    },
    "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
20675 62229 product 0 32504 A 0 D 0 0
26495 63513 product 0 38662 A 0 D 0 0
30507 64353 product 0 42739 A 0 D 0 0
49005 64865 product 0 61238 A 0 D 0 0
49006 64865 product 0 61239 A 0 D 0 0
49007 64865 product 0 61240 A 0 D 0 0
49008 64865 product 0 61241 A 0 D 0 0
55508 64865 product 0 67741 A 0 C 0 0
55515 64865 product 0 67748 A 0 C 0 0
55516 64865 product 0 67749 A 0 C 0 0
66340 64865 product 0 78573 A 0 C 0 0
66341 64865 product 0 78574 A 0 C 0 0
66342 64865 product 0 78575 A 0 C 0 0
67102 64865 product 0 79335 A 0 C 0 0
72613 62229 product 0 84846 A 0 C 0 0
20681 62229 product 0 32510 A 1 C 0 0
26499 63513 product 0 38666 A 1 D 0 0
30511 64353 product 0 42743 A 1 D 0 0
30080 63513 product 0 42303 A 2 D 0 0
30508 64353 product 0 42740 A 2 D 0 0
35911 62229 product 0 48144 A 2 C 0 0
26590 63513 product 0 38759 A 3 D 0 0
30509 64353 product 0 42741 A 3 D 0 0
58547 62229 product 0 70780 A 3 C 0 0
22785 62229 product 0 34689 A 4 C 0 0
26501 63513 product 0 38668 A 4 D 0 0
30510 64353 product 0 42742 A 4 D 0 0
26496 63513 product 0 38663 A 5 D 0 0
32588 64353 product 0 44821 A 5 D 0 0
53838 62229 product 0 66071 A 5 C 0 0
21223 62229 product 0 33104 A 6 D 0 0
26500 63513 product 0 38667 A 6 D 0 0
32603 64353 product 0 44836 A 6 D 0 0
20680 62229 product 0 32509 A 7 D 0 0
30517 64353 product 0 42749 A 7 C 0 0
32482 63513 product 0 44715 A 7 C 0 0
21221 62229 product 0 33102 A 8 D 0 0
32481 63513 product 0 44714 A 8 C 0 0
49907 64353 product 0 62140 A 8 C 0 0
20673 62229 product 0 32502 A 9 D 0 0
48405 64353 product 0 60638 A 9 C 0 0
51661 63513 product 0 63894 A 9 C 0 0
21222 62229 product 0 33103 A 10 D 0 0
48406 64353 product 0 60639 A 10 C 0 0
60776 63513 product 0 73009 A 10 C 0 0
20676 62229 product 0 32505 A 11 D 0 0
30277 63513 product 0 42500 A 11 C 0 0
49909 64353 product 0 62142 A 11 C 0 0
20679 62229 product 0 32508 A 12 D 0 0
32451 64353 product 0 44684 A 12 C 0 0
60773 63513 product 0 73006 A 12 C 0 0
20678 62229 product 0 32507 A 13 D 0 0
30276 63513 product 0 42499 A 13 C 0 0
49908 64353 product 0 62141 A 13 C 0 0
20677 62229 product 0 32506 A 14 D 0 0
30081 63513 product 0 42304 A 14 C 0 0
31960 64353 product 0 44193 A 14 C 0 0
20674 62229 product 0 32503 A 15 D 0 0
33281 63513 product 0 45514 A 15 C 0 0
58532 64353 product 0 70765 A 15 C 0 0
32586 62229 product 0 44819 A 16 D 0 0
51660 63513 product 0 63893 A 16 C 0 0
58533 64353 product 0 70766 A 16 C 0 0
60774 63513 product 0 73007 A 17 C 0 0
49912 62229 product 0 62145 A 18 C 0 0
60775 63513 product 0 73008 A 18 C 0 0
38479 62229 product 0 50712 A 19 C 0 0
63842 63513 product 0 76075 A 19 D 0 0
49913 62229 product 0 62146 A 20 C 0 0
61172 63513 product 0 73405 A 20 C 0 0
58548 62229 product 0 70781 A 21 C 0 0
61171 63513 product 0 73404 A 21 C 0 0
58985 62229 product 0 71218 A 22 C 0 0