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 (
    65626, 65466, 65803, 65564, 65459, 65469, 
    65468, 65814, 65815, 65720, 65732, 
    65479
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00103

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": 83,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (65626,65466,65803,65564,65459,65469,65468,65814,65815,65720,65732,65479)"
        }
      }
    },
    "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
59168 65459 product 0 71401 A 0 D 0 0
63209 65564 product 0 75442 A 0 D 0 0
64277 65564 product 0 76510 A 0 D 0 0
64278 65564 product 0 76511 A 0 D 0 0
64279 65564 product 0 76512 A 0 D 0 0
66529 65466 product 0 78762 A 0 D 0 0
66530 65466 product 0 78763 A 0 D 0 0
66531 65466 product 0 78764 A 0 D 0 0
66532 65466 product 0 78765 A 0 D 0 0
66533 65466 product 0 78766 A 0 D 0 0
66534 65466 product 0 78767 A 0 D 0 0
66535 65466 product 0 78768 A 0 D 0 0
66582 65479 product 0 78815 A 0 D 0 0
66591 65468 product 0 78824 A 0 D 0 0
66857 65469 product 0 79090 A 0 D 0 0
68052 65732 product 0 80285 A 0 D 0 0
68569 65720 product 0 80802 A 0 D 0 0
69275 65803 product 0 81508 A 0 D 0 0
69348 65814 product 0 81581 A 0 D 0 0
69397 65815 product 0 81630 A 0 D 0 0
59172 65459 product 0 71405 A 1 D 0 0
66581 65479 product 0 78814 A 1 D 0 0
66592 65468 product 0 78825 A 1 D 0 0
66862 65469 product 0 79095 A 1 D 0 0
68047 65732 product 0 80280 A 1 D 0 0
68566 65720 product 0 80799 A 1 D 0 0
69273 65803 product 0 81506 A 1 D 0 0
69353 65814 product 0 81586 A 1 D 0 0
69403 65815 product 0 81636 A 1 D 0 0
59169 65459 product 0 71402 A 2 D 0 0
63211 65564 product 0 75444 A 2 D 0 0
66587 65479 product 0 78820 A 2 D 0 0
66589 65468 product 0 78822 A 2 D 0 0
66860 65469 product 0 79093 A 2 D 0 0
68051 65732 product 0 80284 A 2 D 0 0
68567 65720 product 0 80800 A 2 D 0 0
69274 65803 product 0 81507 A 2 D 0 0
69350 65814 product 0 81583 A 2 D 0 0
69400 65815 product 0 81633 A 2 D 0 0
59170 65459 product 0 71403 A 3 D 0 0
66584 65479 product 0 78817 A 3 D 0 0
66590 65468 product 0 78823 A 3 D 0 0
66858 65469 product 0 79091 A 3 D 0 0
68048 65732 product 0 80281 A 3 D 0 0
68572 65720 product 0 80805 A 3 D 0 0
69276 65803 product 0 81509 A 3 D 0 0
69349 65814 product 0 81582 A 3 D 0 0
69398 65815 product 0 81631 A 3 D 0 0
59171 65459 product 0 71404 A 4 D 0 0
63210 65564 product 0 75443 A 4 D 0 0
66586 65479 product 0 78819 A 4 D 0 0
66595 65468 product 0 78828 A 4 D 0 0
66856 65469 product 0 79089 A 4 D 0 0
68049 65732 product 0 80282 A 4 D 0 0
68570 65720 product 0 80803 A 4 D 0 0
69286 65803 product 0 81519 A 4 D 0 0
69347 65814 product 0 81580 A 4 D 0 0
69399 65815 product 0 81632 A 4 D 0 0
66583 65479 product 0 78816 A 5 D 0 0
66594 65468 product 0 78827 A 5 D 0 0
66859 65469 product 0 79092 A 5 D 0 0
68053 65732 product 0 80286 A 5 D 0 0
68568 65720 product 0 80801 A 5 D 0 0
69272 65803 product 0 81505 A 5 D 0 0
69352 65814 product 0 81585 A 5 D 0 0
69402 65815 product 0 81635 A 5 D 0 0
64276 65564 product 0 76509 A 6 D 0 0
66585 65479 product 0 78818 A 6 D 0 0
66593 65468 product 0 78826 A 6 D 0 0
66861 65469 product 0 79094 A 6 D 0 0
68050 65732 product 0 80283 A 6 D 0 0
68571 65720 product 0 80804 A 6 D 0 0
69277 65803 product 0 81510 A 6 D 0 0
69351 65814 product 0 81584 A 6 D 0 0
69401 65815 product 0 81634 A 6 D 0 0
66863 65469 product 0 79096 A 7 D 0 0
68130 65732 product 0 80363 A 7 C 0 0
68561 65720 product 0 80794 A 7 C 0 0
69422 65732 product 0 81655 A 7 C 0 0
68562 65720 product 0 80795 A 8 C 0 0
68584 65720 product 0 80817 A 9 C 0 0
68585 65720 product 0 80818 A 10 C 0 0