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 (
    64682, 62040, 64363, 64356, 62038, 64772, 
    64362, 62039, 64357, 64773, 64774
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00171

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": 220,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64682,62040,64363,64356,62038,64772,64362,62039,64357,64773,64774)"
        }
      }
    },
    "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
19349 62039 product 0 31071 A 0 D 0 0
19354 62040 product 0 31076 A 0 D 0 0
30535 64356 product 0 42767 A 0 D 0 0
30557 64357 product 0 42789 A 0 D 0 0
30656 64362 product 0 42888 A 0 D 0 0
30756 64363 product 0 42988 A 0 D 0 0
38970 64773 product 0 51203 A 0 D 0 0
39017 64774 product 0 51250 A 0 D 0 0
66142 62038 product 0 78375 A 0 D 0 0
19346 62038 product 0 31068 A 1 D 0 0
19352 62039 product 0 31074 A 1 D 0 0
19355 62040 product 0 31077 A 1 D 0 0
30536 64356 product 0 42768 A 1 D 0 0
30556 64357 product 0 42788 A 1 D 0 0
30657 64362 product 0 42889 A 1 D 0 0
38929 64772 product 0 51162 A 1 D 0 0
38972 64773 product 0 51205 A 1 D 0 0
58523 64363 product 0 70756 A 1 D 0 0
60899 64682 product 0 73132 A 1 D 0 0
64291 64774 product 0 76524 A 1 D 0 0
19348 62039 product 0 31070 A 2 D 0 0
19356 62040 product 0 31078 A 2 D 0 0
30558 64357 product 0 42790 A 2 D 0 0
30658 64362 product 0 42890 A 2 D 0 0
30757 64363 product 0 42989 A 2 D 0 0
30945 64356 product 0 43177 A 2 D 0 0
39020 64774 product 0 51253 A 2 D 0 0
66034 64773 product 0 78267 A 2 D 0 0
66145 62038 product 0 78378 A 2 D 0 0
19345 62038 product 0 31067 A 3 D 0 0
19350 62039 product 0 31072 A 3 D 0 0
30538 64356 product 0 42770 A 3 D 0 0
30559 64357 product 0 42791 A 3 D 0 0
30659 64362 product 0 42891 A 3 D 0 0
30758 64363 product 0 42990 A 3 D 0 0
38902 64772 product 0 51135 A 3 D 0 0
38980 64773 product 0 51213 A 3 D 0 0
39018 64774 product 0 51251 A 3 D 0 0
58500 62040 product 0 70733 A 3 C 0 0
19347 62038 product 0 31069 A 4 D 0 0
19353 62039 product 0 31075 A 4 D 0 0
30754 64362 product 0 42986 A 4 D 0 0
30759 64363 product 0 42991 A 4 D 0 0
37849 64357 product 0 50082 A 4 C 0 0
38906 64772 product 0 51139 A 4 D 0 0
38976 64773 product 0 51209 A 4 D 0 0
39019 64774 product 0 51252 A 4 D 0 0
60908 64682 product 0 73141 A 4 D 0 0
65311 62040 product 0 77544 A 4 C 0 0
67872 64363 product 0 80105 A 4 C 0 0
67873 64363 product 0 80106 A 4 C 0 0
30540 64356 product 0 42772 A 5 D 0 0
38909 64772 product 0 51142 A 5 D 0 0
38982 64773 product 0 51215 A 5 D 0 0
61964 64357 product 0 74197 A 5 C 0 0
64290 64774 product 0 76523 A 5 D 0 0
65726 62040 product 0 77959 A 5 C 0 0
66008 62039 product 0 78241 A 5 D 0 0
66143 62038 product 0 78376 A 5 D 0 0
68122 64362 product 0 80355 A 5 C 0 0
38927 64772 product 0 51160 A 6 D 0 0
38975 64773 product 0 51208 A 6 D 0 0
58931 64357 product 0 71164 A 6 C 0 0
59068 64362 product 0 71301 A 6 C 0 0
60898 64682 product 0 73131 A 6 D 0 0
63936 62040 product 0 76169 A 6 C 0 0
66004 62039 product 0 78237 A 6 D 0 0
66144 62038 product 0 78377 A 6 D 0 0
38928 64772 product 0 51161 A 7 D 0 0
38974 64773 product 0 51207 A 7 C 0 0
59070 64362 product 0 71303 A 7 C 0 0
60903 64682 product 0 73136 A 7 D 0 0
61965 64357 product 0 74198 A 7 C 0 0
62803 64774 product 0 75036 A 7 C 0 0
66006 62039 product 0 78239 A 7 D 0 0
66067 62040 product 0 78300 A 7 C 0 0
68381 62038 product 0 80614 A 7 C 0 0
28798 62040 product 0 40997 A 8 C 0 0
38931 64772 product 0 51164 A 8 C 0 0
54152 62038 product 0 66385 A 8 C 0 0
58932 64357 product 0 71165 A 8 C 0 0
60810 64774 product 0 73043 A 8 C 0 0
60904 64682 product 0 73137 A 8 D 0 0
64549 64773 product 0 76782 A 8 C 0 0
66009 62039 product 0 78242 A 8 D 0 0
38978 64773 product 0 51211 A 9 C 0 0
54153 62038 product 0 66386 A 9 C 0 0
56135 64772 product 0 68368 A 9 C 0 0
60812 64774 product 0 73045 A 9 C 0 0
60905 64682 product 0 73138 A 9 D 0 0
61966 64357 product 0 74199 A 9 C 0 0
63672 62040 product 0 75905 A 9 C 0 0
66007 62039 product 0 78240 A 9 D 0 0
67862 64356 product 0 80095 A 9 C 0 0
28329 62038 product 0 40522 A 10 C 0 0
46670 64773 product 0 58903 A 10 C 0 0
54131 64356 product 0 66364 A 10 C 0 0
54156 64772 product 0 66389 A 10 C 0 0
59280 64774 product 0 71513 A 10 C 0 0
60902 64682 product 0 73135 A 10 D 0 0
61967 64357 product 0 74200 A 10 C 0 0
64483 62040 product 0 76716 A 10 C 0 0
65723 64357 product 0 77956 A 10 C 0 0
65724 64357 product 0 77957 A 10 C 0 0
66010 62039 product 0 78243 A 10 D 0 0
66068 62040 product 0 78301 A 10 C 0 0
66829 64357 product 0 79062 A 10 C 0 0
67209 64357 product 0 79442 A 10 C 0 0
68593 62040 product 0 80826 A 10 C 0 0
38913 64772 product 0 51146 A 11 C 0 0
58290 62038 product 0 70523 A 11 C 0 0
59281 64774 product 0 71514 A 11 C 0 0
60906 64682 product 0 73139 A 11 D 0 0
63070 64773 product 0 75303 A 11 C 0 0
66005 62039 product 0 78238 A 11 D 0 0
38904 64772 product 0 51137 A 12 C 0 0
58557 64774 product 0 70790 A 12 C 0 0
60910 64682 product 0 73143 A 12 D 0 0
62891 62039 product 0 75124 A 12 C 0 0
65005 62038 product 0 77238 A 12 C 0 0
66277 64773 product 0 78510 A 12 C 0 0
38910 64772 product 0 51143 A 13 C 0 0
57243 64773 product 0 69476 A 13 C 0 0
59279 64774 product 0 71512 A 13 C 0 0
60912 64682 product 0 73145 A 13 D 0 0
64998 62038 product 0 77231 A 13 C 0 0
65613 62039 product 0 77846 A 13 C 0 0
19386 62039 product 0 31116 A 14 C 0 0
38903 64772 product 0 51136 A 14 C 0 0
50270 64773 product 0 62503 A 14 C 0 0
60907 64682 product 0 73140 A 14 D 0 0
61220 64774 product 0 73453 A 14 C 0 0
38977 64773 product 0 51210 A 15 C 0 0
61217 64774 product 0 73450 A 15 C 0 0
65614 62039 product 0 77847 A 15 C 0 0
38932 64772 product 0 51165 A 16 C 0 0
39022 64774 product 0 51255 A 16 C 0 0
58541 64773 product 0 70774 A 16 C 0 0
61358 64682 product 0 73591 A 16 D 0 0
39023 64774 product 0 51256 A 17 C 0 0
53511 64772 product 0 65744 A 17 C 0 0
60909 64682 product 0 73142 A 17 D 0 0
54159 64772 product 0 66392 A 18 C 0 0
60941 64682 product 0 73174 A 18 D 0 0
61219 64774 product 0 73452 A 18 C 0 0
38905 64772 product 0 51138 A 19 C 0 0
60811 64774 product 0 73044 A 19 C 0 0
61164 64682 product 0 73397 A 19 D 0 0
33548 64682 product 0 45781 A 20 D 0 0
38911 64772 product 0 51144 A 20 C 0 0
60813 64774 product 0 73046 A 20 C 0 0
39021 64774 product 0 51254 A 21 C 0 0
49985 64774 product 0 62218 A 22 C 0 0
66823 64772 product 0 79056 A 22 C 0 0
61449 64774 product 0 73682 A 23 C 0 0
66824 64772 product 0 79057 A 23 C 0 0
64024 64774 product 0 76257 A 24 C 0 0
66972 64774 product 0 79205 A 24 D 0 0
67110 64772 product 0 79343 A 24 C 0 0
72565 64682 product 0 84798 A 25 C 0 0
53845 64682 product 0 66078 A 26 C 0 0
39250 64682 product 0 51483 A 27 C 0 0
60952 64682 product 0 73185 A 28 C 0 0
33557 64682 product 0 45790 A 29 C 0 0
58490 64682 product 0 70723 A 30 C 0 0
60371 64682 product 0 72604 A 31 C 0 0
47274 64682 product 0 59507 A 32 C 0 0
64546 64682 product 0 76779 A 33 C 0 0
57099 64682 product 0 69332 A 34 C 0 0
57658 64682 product 0 69891 A 37 C 0 0
54120 64682 product 0 66353 A 38 C 0 0
50058 64682 product 0 62291 A 39 C 0 0
33542 64682 product 0 45775 A 40 C 0 0
61804 64682 product 0 74037 A 41 C 0 0
61230 64682 product 0 73463 A 42 C 0 0
61494 64682 product 0 73727 A 43 C 0 0
36637 64682 product 0 48870 A 45 C 0 0
33551 64682 product 0 45784 A 46 C 0 0
36565 64682 product 0 48798 A 47 C 0 0
64544 64682 product 0 76777 A 48 C 0 0
60369 64682 product 0 72602 A 50 C 0 0
61226 64682 product 0 73459 A 51 C 0 0
60953 64682 product 0 73186 A 52 C 0 0
58491 64682 product 0 70724 A 53 C 0 0
33560 64682 product 0 45793 A 54 C 0 0
33556 64682 product 0 45789 A 55 C 0 0
33558 64682 product 0 45791 A 56 C 0 0
61805 64682 product 0 74038 A 57 C 0 0
33563 64682 product 0 45796 A 58 C 0 0
33562 64682 product 0 45795 A 59 C 0 0
33555 64682 product 0 45788 A 60 C 0 0
61228 64682 product 0 73461 A 61 C 0 0
38480 64682 product 0 50713 A 62 C 0 0
33535 64682 product 0 45768 A 63 C 0 0
33554 64682 product 0 45787 A 65 C 0 0
58492 64682 product 0 70725 A 67 C 0 0
55879 64682 product 0 68112 A 68 C 0 0
33553 64682 product 0 45786 A 69 C 0 0
33559 64682 product 0 45792 A 70 C 0 0
35335 64682 product 0 47568 A 71 C 0 0
60027 64682 product 0 72260 A 72 C 0 0
39252 64682 product 0 51485 A 73 C 0 0
66833 64682 product 0 79066 A 74 C 0 0
60024 64682 product 0 72257 A 75 C 0 0
60028 64682 product 0 72261 A 77 C 0 0
61495 64682 product 0 73728 A 78 C 0 0
66994 64682 product 0 79227 A 79 C 0 0
39251 64682 product 0 51484 A 80 C 0 0
55885 64682 product 0 68118 A 83 C 0 0
60026 64682 product 0 72259 A 84 C 0 0
65632 64682 product 0 77865 A 85 C 0 0
66834 64682 product 0 79067 A 87 C 0 0
33546 64682 product 0 45779 A 88 C 0 0
33552 64682 product 0 45785 A 89 C 0 0
66835 64682 product 0 79068 A 90 C 0 0
33550 64682 product 0 45783 A 91 C 0 0
66495 64682 product 0 78728 A 92 C 0 0
33538 64682 product 0 45771 A 93 C 0 0
66496 64682 product 0 78729 A 94 C 0 0
66995 64682 product 0 79228 A 95 C 0 0