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 (
    64726, 63231, 61070, 61453, 64294, 64687, 
    62189, 64682
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00156

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": 187,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64726,63231,61070,61453,64294,64687,62189,64682)"
        }
      }
    },
    "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
21799 62189 product 0 33681 A 0 C 0 0
24954 63231 product 0 37030 A 0 D 0 0
29532 64294 product 0 41752 A 0 D 0 0
29534 64294 product 0 41754 A 0 D 0 0
33781 64687 product 0 46014 A 0 D 0 0
37232 64726 product 0 49465 A 0 D 0 0
42439 61070 product 0 54672 A 0 D 0 0
65462 61453 product 0 77695 A 0 D 0 0
30934 62189 product 0 43166 A 1 C 0 0
33775 64687 product 0 46008 A 1 D 0 0
60899 64682 product 0 73132 A 1 D 0 0
62836 64726 product 0 75069 A 1 D 0 0
64208 61070 product 0 76441 A 1 D 0 0
65392 63231 product 0 77625 A 1 D 0 0
65465 61453 product 0 77698 A 1 D 0 0
33328 62189 product 0 45561 A 2 C 0 0
33837 64687 product 0 46070 A 2 D 0 0
37241 64726 product 0 49474 A 2 D 0 0
39617 61070 product 0 51850 A 2 D 0 0
65391 63231 product 0 77624 A 2 D 0 0
65460 61453 product 0 77693 A 2 D 0 0
37235 64726 product 0 49468 A 3 D 0 0
39615 61070 product 0 51848 A 3 D 0 0
58471 62189 product 0 70704 A 3 C 0 0
65393 63231 product 0 77626 A 3 D 0 0
65463 61453 product 0 77696 A 3 D 0 0
67654 64687 product 0 79887 A 3 C 0 0
16323 61453 product 0 27843 A 4 D 0 0
32150 63231 product 0 44383 A 4 D 0 0
37233 64726 product 0 49466 A 4 D 0 0
52615 64687 product 0 64848 A 4 C 0 0
60908 64682 product 0 73141 A 4 D 0 0
62041 62189 product 0 74274 A 4 C 0 0
64205 61070 product 0 76438 A 4 D 0 0
39200 64726 product 0 51433 A 5 D 0 0
46791 64687 product 0 59024 A 5 C 0 0
64206 61070 product 0 76439 A 5 D 0 0
65394 63231 product 0 77627 A 5 D 0 0
65461 61453 product 0 77694 A 5 D 0 0
37242 64726 product 0 49475 A 6 D 0 0
38470 63231 product 0 50703 A 6 C 0 0
54163 64687 product 0 66396 A 6 C 0 0
60898 64682 product 0 73131 A 6 D 0 0
64207 61070 product 0 76440 A 6 D 0 0
65464 61453 product 0 77697 A 6 D 0 0
28593 61453 product 0 40792 A 7 C 0 0
37250 64726 product 0 49483 A 7 D 0 0
50702 61070 product 0 62935 A 7 C 0 0
53841 64687 product 0 66074 A 7 C 0 0
55739 63231 product 0 67972 A 7 C 0 0
60903 64682 product 0 73136 A 7 D 0 0
28594 61453 product 0 40793 A 8 C 0 0
37251 64726 product 0 49484 A 8 D 0 0
38471 63231 product 0 50704 A 8 C 0 0
50703 61070 product 0 62936 A 8 C 0 0
54164 64687 product 0 66397 A 8 C 0 0
60904 64682 product 0 73137 A 8 D 0 0
49042 61453 product 0 61275 A 9 C 0 0
50704 61070 product 0 62937 A 9 C 0 0
53840 64687 product 0 66073 A 9 C 0 0
58770 63231 product 0 71003 A 9 C 0 0
60905 64682 product 0 73138 A 9 D 0 0
62827 64726 product 0 75060 A 9 D 0 0
31958 61453 product 0 44191 A 10 C 0 0
40471 63231 product 0 52704 A 10 C 0 0
40823 61070 product 0 53056 A 10 C 0 0
46792 64687 product 0 59025 A 10 C 0 0
60902 64682 product 0 73135 A 10 D 0 0
68218 64726 product 0 80451 A 10 C 0 0
20472 61070 product 0 32295 A 11 C 0 0
31957 61453 product 0 44190 A 11 C 0 0
52616 64687 product 0 64849 A 11 C 0 0
60906 64682 product 0 73139 A 11 D 0 0
68219 64726 product 0 80452 A 11 C 0 0
32449 61070 product 0 44682 A 12 C 0 0
33779 64687 product 0 46012 A 12 C 0 0
60910 64682 product 0 73143 A 12 D 0 0
67973 64726 product 0 80206 A 12 C 0 0
33783 64687 product 0 46016 A 13 C 0 0
46280 61070 product 0 58513 A 13 C 0 0
60912 64682 product 0 73145 A 13 D 0 0
63706 64726 product 0 75939 A 13 C 0 0
33777 64687 product 0 46010 A 14 C 0 0
46281 61070 product 0 58514 A 14 C 0 0
57171 64726 product 0 69404 A 14 C 0 0
60907 64682 product 0 73140 A 14 D 0 0
46018 64687 product 0 58251 A 15 C 0 0
63704 64726 product 0 75937 A 15 C 0 0
50956 64687 product 0 63189 A 16 C 0 0
60283 64726 product 0 72516 A 16 C 0 0
61358 64682 product 0 73591 A 16 D 0 0
60909 64682 product 0 73142 A 17 D 0 0
67459 64726 product 0 79692 A 17 C 0 0
52024 64726 product 0 64257 A 18 C 0 0
60941 64682 product 0 73174 A 18 D 0 0
46273 64726 product 0 58506 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
61988 64726 product 0 74221 A 20 C 0 0
61365 64726 product 0 73598 A 21 C 0 0
57170 64726 product 0 69403 A 22 C 0 0
61363 64726 product 0 73596 A 23 C 0 0
62418 64726 product 0 74651 A 24 C 0 0
46667 64726 product 0 58900 A 25 C 0 0
72565 64682 product 0 84798 A 25 C 0 0
53845 64682 product 0 66078 A 26 C 0 0
53852 64726 product 0 66085 A 26 C 0 0
39250 64682 product 0 51483 A 27 C 0 0
57174 64726 product 0 69407 A 27 C 0 0
56117 64726 product 0 68350 A 28 C 0 0
60952 64682 product 0 73185 A 28 C 0 0
33557 64682 product 0 45790 A 29 C 0 0
37245 64726 product 0 49478 A 29 C 0 0
53858 64726 product 0 66091 A 30 C 0 0
58490 64682 product 0 70723 A 30 C 0 0
57173 64726 product 0 69406 A 31 C 0 0
60371 64682 product 0 72604 A 31 C 0 0
47274 64682 product 0 59507 A 32 C 0 0
53853 64726 product 0 66086 A 32 C 0 0
56054 64726 product 0 68287 A 33 C 0 0
64546 64682 product 0 76779 A 33 C 0 0
52023 64726 product 0 64256 A 34 C 0 0
57099 64682 product 0 69332 A 34 C 0 0
53839 64726 product 0 66072 A 35 C 0 0
50183 64726 product 0 62416 A 36 C 0 0
37244 64726 product 0 49477 A 37 C 0 0
57658 64682 product 0 69891 A 37 C 0 0
49910 64726 product 0 62143 A 38 C 0 0
54120 64682 product 0 66353 A 38 C 0 0
50058 64682 product 0 62291 A 39 C 0 0
65916 64726 product 0 78149 A 39 C 0 0
33542 64682 product 0 45775 A 40 C 0 0
61364 64726 product 0 73597 A 40 C 0 0
37253 64726 product 0 49486 A 41 C 0 0
61804 64682 product 0 74037 A 41 C 0 0
37246 64726 product 0 49479 A 42 C 0 0
61230 64682 product 0 73463 A 42 C 0 0
46272 64726 product 0 58505 A 43 C 0 0
61494 64682 product 0 73727 A 43 C 0 0
37243 64726 product 0 49476 A 44 C 0 0
36637 64682 product 0 48870 A 45 C 0 0
37238 64726 product 0 49471 A 45 C 0 0
33551 64682 product 0 45784 A 46 C 0 0
37252 64726 product 0 49485 A 46 C 0 0
36565 64682 product 0 48798 A 47 C 0 0
65075 64726 product 0 77308 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