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 (
    65531, 65463, 65701, 65298, 65563, 65698, 
    65461, 65426, 65299, 65521, 65560, 
    65796
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00111

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": 75,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65531,65463,65701,65298,65563,65698,65461,65426,65299,65521,65560,65796)"
        }
      }
    },
    "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
56486 65298 product 0 68719 A 0 D 0 0
56544 65299 product 0 68777 A 0 D 0 0
59094 65463 product 0 71327 A 0 D 0 0
62501 65560 product 0 74734 A 0 D 0 0
62502 65560 product 0 74735 A 0 D 0 0
62503 65560 product 0 74736 A 0 D 0 0
62504 65560 product 0 74737 A 0 D 0 0
62541 65563 product 0 74774 A 0 D 0 0
62542 65563 product 0 74775 A 0 D 0 0
62543 65563 product 0 74776 A 0 D 0 0
62544 65563 product 0 74777 A 0 D 0 0
62545 65563 product 0 74778 A 0 D 0 0
62764 65560 product 0 74997 A 0 C 0 0
62765 65563 product 0 74998 A 0 C 0 0
63329 65531 product 0 75562 A 0 D 0 0
63641 65426 product 0 75874 A 0 D 0 0
63852 65521 product 0 76085 A 0 D 0 0
63853 65521 product 0 76086 A 0 D 0 0
63854 65521 product 0 76087 A 0 D 0 0
67047 65698 product 0 79280 A 0 D 0 0
67048 65698 product 0 79281 A 0 D 0 0
67049 65698 product 0 79282 A 0 D 0 0
67283 65701 product 0 79516 A 0 D 0 0
69459 65796 product 0 81692 A 0 D 0 0
56548 65299 product 0 68781 A 1 D 0 0
59090 65463 product 0 71323 A 1 D 0 0
59105 65461 product 0 71338 A 1 D 0 0
63330 65531 product 0 75563 A 1 D 0 0
63587 65298 product 0 75820 A 1 D 0 0
63639 65426 product 0 75872 A 1 D 0 0
67281 65701 product 0 79514 A 1 D 0 0
69462 65796 product 0 81695 A 1 D 0 0
56485 65298 product 0 68718 A 2 D 0 0
56547 65299 product 0 68780 A 2 D 0 0
59101 65461 product 0 71334 A 2 D 0 0
63332 65531 product 0 75565 A 2 D 0 0
63638 65426 product 0 75871 A 2 D 0 0
64496 65463 product 0 76729 A 2 D 0 0
67282 65701 product 0 79515 A 2 D 0 0
68586 65701 product 0 80819 A 2 C 0 0
68587 65701 product 0 80820 A 2 C 0 0
68588 65701 product 0 80821 A 2 C 0 0
68589 65701 product 0 80822 A 2 C 0 0
69460 65796 product 0 81693 A 2 D 0 0
56490 65298 product 0 68723 A 3 D 0 0
59079 65299 product 0 71312 A 3 D 0 0
59093 65463 product 0 71326 A 3 D 0 0
63331 65531 product 0 75564 A 3 D 0 0
63642 65426 product 0 75875 A 3 D 0 0
64775 65461 product 0 77008 A 3 D 0 0
69461 65796 product 0 81694 A 3 D 0 0
56488 65298 product 0 68721 A 4 D 0 0
56546 65299 product 0 68779 A 4 D 0 0
59091 65463 product 0 71324 A 4 D 0 0
63333 65531 product 0 75566 A 4 D 0 0
63644 65426 product 0 75877 A 4 D 0 0
69463 65796 product 0 81696 A 4 D 0 0
56487 65298 product 0 68720 A 5 D 0 0
59078 65299 product 0 71311 A 5 D 0 0
59092 65463 product 0 71325 A 5 D 0 0
59103 65461 product 0 71336 A 5 D 0 0
63334 65531 product 0 75567 A 5 D 0 0
63640 65426 product 0 75873 A 5 D 0 0
69464 65796 product 0 81697 A 5 D 0 0
59077 65299 product 0 71310 A 6 D 0 0
59089 65463 product 0 71322 A 6 D 0 0
63335 65531 product 0 75568 A 6 D 0 0
63352 65531 product 0 75585 A 6 C 0 0
63585 65298 product 0 75818 A 6 D 0 0
63643 65426 product 0 75876 A 6 D 0 0
64774 65461 product 0 77007 A 6 D 0 0
69465 65796 product 0 81698 A 6 D 0 0
56525 65298 product 0 68758 A 7 D 0 0
63586 65298 product 0 75819 A 8 D 0 0
65595 65298 product 0 77828 A 8 C 0 0