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 (
    65533, 65532, 65770, 65616, 65531, 65701, 
    65698, 65521, 65674, 65700, 65691, 
    65803
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00133

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": 87,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65533,65532,65770,65616,65531,65701,65698,65521,65674,65700,65691,65803)"
        }
      }
    },
    "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
63329 65531 product 0 75562 A 0 D 0 0
63337 65532 product 0 75570 A 0 D 0 0
63345 65533 product 0 75578 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
64902 65616 product 0 77135 A 0 D 0 0
64904 65616 product 0 77137 A 0 D 0 0
64908 65616 product 0 77141 A 0 D 0 0
64909 65616 product 0 77142 A 0 D 0 0
66362 65674 product 0 78595 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
67057 65691 product 0 79290 A 0 D 0 0
67273 65700 product 0 79506 A 0 D 0 0
67283 65701 product 0 79516 A 0 D 0 0
68349 65770 product 0 80582 A 0 D 0 0
69275 65803 product 0 81508 A 0 D 0 0
63330 65531 product 0 75563 A 1 D 0 0
63341 65532 product 0 75574 A 1 D 0 0
63346 65533 product 0 75579 A 1 D 0 0
66369 65674 product 0 78602 A 1 D 0 0
67058 65691 product 0 79291 A 1 D 0 0
67274 65700 product 0 79507 A 1 D 0 0
67281 65701 product 0 79514 A 1 D 0 0
68354 65770 product 0 80587 A 1 D 0 0
69273 65803 product 0 81506 A 1 D 0 0
63332 65531 product 0 75565 A 2 D 0 0
63338 65532 product 0 75571 A 2 D 0 0
63351 65533 product 0 75584 A 2 D 0 0
64905 65616 product 0 77138 A 2 D 0 0
66363 65674 product 0 78596 A 2 D 0 0
67059 65691 product 0 79292 A 2 D 0 0
67275 65700 product 0 79508 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
68992 65770 product 0 81225 A 2 D 0 0
69274 65803 product 0 81507 A 2 D 0 0
63331 65531 product 0 75564 A 3 D 0 0
63340 65532 product 0 75573 A 3 D 0 0
63348 65533 product 0 75581 A 3 D 0 0
64903 65616 product 0 77136 A 3 D 0 0
66365 65674 product 0 78598 A 3 D 0 0
67122 65700 product 0 79355 A 3 C 0 0
68351 65770 product 0 80584 A 3 D 0 0
69276 65803 product 0 81509 A 3 D 0 0
63333 65531 product 0 75566 A 4 D 0 0
63342 65532 product 0 75575 A 4 D 0 0
63347 65533 product 0 75580 A 4 D 0 0
64907 65616 product 0 77140 A 4 D 0 0
66367 65674 product 0 78600 A 4 D 0 0
68350 65770 product 0 80583 A 4 D 0 0
68551 65700 product 0 80784 A 4 C 0 0
69286 65803 product 0 81519 A 4 D 0 0
63334 65531 product 0 75567 A 5 D 0 0
63339 65532 product 0 75572 A 5 D 0 0
63349 65533 product 0 75582 A 5 D 0 0
66364 65674 product 0 78597 A 5 D 0 0
68353 65770 product 0 80586 A 5 D 0 0
68553 65700 product 0 80786 A 5 C 0 0
69272 65803 product 0 81505 A 5 D 0 0
63335 65531 product 0 75568 A 6 D 0 0
63343 65532 product 0 75576 A 6 D 0 0
63350 65533 product 0 75583 A 6 D 0 0
63352 65531 product 0 75585 A 6 C 0 0
63353 65533 product 0 75586 A 6 C 0 0
66366 65674 product 0 78599 A 6 D 0 0
68121 65674 product 0 80354 A 6 C 0 0
68352 65770 product 0 80585 A 6 D 0 0
68552 65700 product 0 80785 A 6 C 0 0
68599 65700 product 0 80832 A 6 C 0 0
69277 65803 product 0 81510 A 6 D 0 0
61916 65532 product 0 74149 A 7 C 0 0
64910 65616 product 0 77143 A 7 C 0 0
68356 65770 product 0 80589 A 7 C 0 0
61917 65532 product 0 74150 A 8 C 0 0
64911 65616 product 0 77144 A 8 C 0 0
68357 65770 product 0 80590 A 8 C 0 0
61918 65532 product 0 74151 A 9 C 0 0
64913 65616 product 0 77146 A 9 C 0 0
68358 65770 product 0 80591 A 9 C 0 0
61919 65532 product 0 74152 A 10 C 0 0
64912 65616 product 0 77145 A 10 C 0 0