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 (64706, 62056, 62062, 64694) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00102

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": 82,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64706,62056,62062,64694)"
        }
      }
    },
    "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
19697 62056 product 0 31486 A 0 D 0 0
19706 62062 product 0 31495 A 0 D 0 0
35673 64694 product 0 47906 A 0 D 0 0
36023 64706 product 0 48256 A 0 D 0 0
29464 62056 product 0 41684 A 1 D 0 0
62835 64694 product 0 75068 A 1 D 0 0
64152 62062 product 0 76385 A 1 D 0 0
19698 62056 product 0 31487 A 2 D 0 0
35680 64694 product 0 47913 A 2 D 0 0
64150 62062 product 0 76383 A 2 D 0 0
19734 62062 product 0 31523 A 3 D 0 0
29483 62056 product 0 41703 A 3 D 0 0
35678 64694 product 0 47911 A 3 D 0 0
36036 64706 product 0 48269 A 3 D 0 0
36030 64706 product 0 48263 A 4 D 0 0
60943 62056 product 0 73176 A 4 D 0 0
63848 64694 product 0 76081 A 4 D 0 0
64151 62062 product 0 76384 A 4 D 0 0
19699 62056 product 0 31488 A 5 D 0 0
35696 64694 product 0 47929 A 5 D 0 0
36032 64706 product 0 48265 A 5 D 0 0
64149 62062 product 0 76382 A 5 D 0 0
35676 64694 product 0 47909 A 6 D 0 0
36017 64706 product 0 48250 A 6 D 0 0
60944 62056 product 0 73177 A 6 D 0 0
64153 62062 product 0 76386 A 6 D 0 0
19707 62062 product 0 31496 A 7 D 0 0
35683 64694 product 0 47916 A 7 D 0 0
36021 64706 product 0 48254 A 7 D 0 0
60942 62056 product 0 73175 A 7 D 0 0
35674 64694 product 0 47907 A 8 D 0 0
58496 62056 product 0 70729 A 8 C 0 0
58977 62062 product 0 71210 A 8 C 0 0
63245 64706 product 0 75478 A 8 D 0 0
58978 62062 product 0 71211 A 9 C 0 0
63847 64694 product 0 76080 A 9 D 0 0
35675 64694 product 0 47908 A 10 D 0 0
36019 64706 product 0 48252 A 10 D 0 0
63850 64694 product 0 76083 A 11 D 0 0
69133 64706 product 0 81366 A 11 C 0 0
35677 64694 product 0 47910 A 12 D 0 0
56904 64706 product 0 69137 A 12 C 1 0
35679 64694 product 0 47912 A 13 D 0 0
62546 64706 product 0 74779 A 13 C 0 0
35693 64694 product 0 47926 A 14 D 0 0
35684 64694 product 0 47917 A 15 D 0 0
35681 64694 product 0 47914 A 16 D 0 0
58920 64706 product 0 71153 A 16 C 0 0
35694 64694 product 0 47927 A 17 D 0 0
68741 64694 product 0 80974 A 18 C 0 0
67987 64694 product 0 80220 A 19 C 0 0
59582 64706 product 0 71815 A 20 C 0 0
61835 64694 product 0 74068 A 20 C 0 0
60013 64706 product 0 72246 A 22 C 0 0
65292 64694 product 0 77525 A 23 C 0 0
65634 64694 product 0 77867 A 24 C 0 0
54231 64694 product 0 66464 A 25 C 0 0
59583 64706 product 0 71816 A 25 C 0 0
60014 64706 product 0 72247 A 26 C 0 0
49161 64694 product 0 61394 A 27 C 0 0
66276 64706 product 0 78509 A 27 C 0 0
35687 64694 product 0 47920 A 28 C 0 0
60015 64706 product 0 72248 A 28 C 0 0
54230 64694 product 0 66463 A 29 C 0 0
64867 64706 product 0 77100 A 30 C 0 0
61836 64694 product 0 74069 A 31 C 0 0
35690 64694 product 0 47923 A 32 C 0 0
39202 64694 product 0 51435 A 33 C 0 0
68372 64694 product 0 80605 A 34 C 0 0
54232 64694 product 0 66465 A 35 C 0 0
60277 64706 product 0 72510 A 35 C 0 0
35686 64694 product 0 47919 A 36 C 0 0
69134 64706 product 0 81367 A 36 C 0 0
49204 64694 product 0 61437 A 37 C 0 0
35685 64694 product 0 47918 A 38 C 0 0
62166 64706 product 0 74399 A 38 C 0 0
46572 64694 product 0 58805 A 39 C 0 0
62405 64706 product 0 74638 A 39 C 0 0
46571 64694 product 0 58804 A 40 C 0 0
46570 64694 product 0 58803 A 41 C 0 0
58160 64694 product 0 70393 A 42 C 0 0
61881 64694 product 0 74114 A 43 C 0 0