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 (
    64276, 64757, 64944, 64756, 65099, 65095, 
    64759, 64758, 64848, 63814, 65300
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00161

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": 103,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64276,64757,64944,64756,65099,65095,64759,64758,64848,63814,65300)"
        }
      }
    },
    "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
27445 63814 product 0 39622 A 0 D 0 0
27469 63814 product 0 39646 A 0 D 0 0
27470 63814 product 0 39647 A 0 D 0 0
27471 63814 product 0 39648 A 0 D 0 0
27472 63814 product 0 39649 A 0 D 0 0
27473 63814 product 0 39650 A 0 D 0 0
29361 64276 product 0 41581 A 0 D 0 0
38466 64756 product 0 50699 A 0 D 0 0
38493 64758 product 0 50726 A 0 D 0 0
38504 64759 product 0 50737 A 0 D 0 0
41720 64848 product 0 53953 A 0 D 0 0
49272 64944 product 0 61505 A 0 D 0 0
52602 65095 product 0 64835 A 0 D 0 0
52603 65095 product 0 64836 A 0 D 0 0
52604 65095 product 0 64837 A 0 D 0 0
52605 65095 product 0 64838 A 0 D 0 0
52606 65095 product 0 64839 A 0 D 0 0
52612 65095 product 0 64845 A 0 D 0 0
52613 65095 product 0 64846 A 0 D 0 0
53568 65099 product 0 65801 A 0 D 0 0
59108 65300 product 0 71341 A 0 D 0 0
67494 64756 product 0 79727 A 0 C 0 0
67495 64756 product 0 79728 A 0 C 0 0
27446 63814 product 0 39623 A 1 D 0 0
29365 64276 product 0 41585 A 1 D 0 0
38473 64756 product 0 50706 A 1 D 0 0
38492 64758 product 0 50725 A 1 D 0 0
41726 64848 product 0 53959 A 1 D 0 0
49019 64944 product 0 61252 A 1 D 0 0
53561 65099 product 0 65794 A 1 D 0 0
59106 65300 product 0 71339 A 1 D 0 0
65067 64759 product 0 77300 A 1 D 0 0
27437 63814 product 0 39614 A 2 D 0 0
38475 64756 product 0 50708 A 2 D 0 0
38484 64757 product 0 50717 A 2 D 0 0
38491 64758 product 0 50724 A 2 D 0 0
38500 64759 product 0 50733 A 2 D 0 0
41723 64848 product 0 53956 A 2 D 0 0
50911 64944 product 0 63144 A 2 D 0 0
53560 65099 product 0 65793 A 2 D 0 0
56560 65300 product 0 68793 A 2 D 0 0
69559 64276 product 0 81792 A 2 D 0 0
27438 63814 product 0 39615 A 3 D 0 0
27468 63814 product 0 39645 A 3 D 0 0
38468 64756 product 0 50701 A 3 D 0 0
38485 64757 product 0 50718 A 3 D 0 0
38496 64758 product 0 50729 A 3 D 0 0
38503 64759 product 0 50736 A 3 D 0 0
49271 64944 product 0 61504 A 3 D 0 0
53572 65099 product 0 65805 A 3 D 0 0
56561 65300 product 0 68794 A 3 D 0 0
65071 64848 product 0 77304 A 3 D 0 0
69556 64276 product 0 81789 A 3 D 0 0
38472 64756 product 0 50705 A 4 D 0 0
38487 64757 product 0 50720 A 4 D 0 0
38494 64758 product 0 50727 A 4 D 0 0
38498 64759 product 0 50731 A 4 D 0 0
41724 64848 product 0 53957 A 4 D 0 0
49020 64944 product 0 61253 A 4 D 0 0
53577 65099 product 0 65810 A 4 D 0 0
59107 65300 product 0 71340 A 4 D 0 0
69557 64276 product 0 81790 A 4 D 0 0
38474 64756 product 0 50707 A 5 D 0 0
38497 64758 product 0 50730 A 5 D 0 0
38502 64759 product 0 50735 A 5 D 0 0
41725 64848 product 0 53958 A 5 D 0 0
53563 65099 product 0 65796 A 5 D 0 0
56562 65300 product 0 68795 A 5 D 0 0
59003 64944 product 0 71236 A 5 C 0 0
65069 64757 product 0 77302 A 5 D 0 0
69558 64276 product 0 81791 A 5 D 0 0
38467 64756 product 0 50700 A 6 D 0 0
38488 64757 product 0 50721 A 6 D 0 0
38499 64759 product 0 50732 A 6 D 0 0
53562 65099 product 0 65795 A 6 D 0 0
59004 64944 product 0 71237 A 6 C 0 0
65066 64758 product 0 77299 A 6 D 0 0
65068 65300 product 0 77301 A 6 D 0 0
65070 64848 product 0 77303 A 6 D 0 0
41721 64848 product 0 53954 A 7 C 0 0
49334 64944 product 0 61567 A 7 C 0 0
57127 64757 product 0 69360 A 7 C 0 0
67479 64848 product 0 79712 A 7 C 0 0
67480 64848 product 0 79713 A 7 C 0 0
67496 64759 product 0 79729 A 7 C 0 0
46510 64757 product 0 58743 A 8 C 0 0
54136 64759 product 0 66369 A 8 C 0 0
55434 64944 product 0 67667 A 8 C 0 0
62357 64756 product 0 74590 A 8 C 0 0
53835 64756 product 0 66068 A 9 C 0 0
54134 64759 product 0 66367 A 9 C 0 0
55435 64944 product 0 67668 A 9 C 0 0
57125 64757 product 0 69358 A 9 C 0 0
66442 65099 product 0 78675 A 9 C 0 0
55433 64944 product 0 67666 A 10 C 0 0
60038 64756 product 0 72271 A 10 C 0 0
60057 64759 product 0 72290 A 10 C 0 0
45078 64756 product 0 57311 A 11 C 0 0
60058 64759 product 0 72291 A 11 C 0 0
45077 64756 product 0 57310 A 12 C 0 0
46509 64756 product 0 58742 A 13 C 0 0
38505 64756 product 0 50738 A 14 C 0 0
66460 64756 product 0 78693 A 15 C 0 0