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 (61329, 61622, 61322, 61326) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00151

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": 88,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (61329,61622,61322,61326)"
        }
      }
    },
    "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
15379 61326 product 0 26826 A 0 D 0 0
15390 61329 product 0 26837 A 0 D 0 0
17080 61622 product 0 28613 A 0 D 0 0
63645 61322 product 0 75878 A 0 D 0 0
15374 61322 product 0 26821 A 1 D 0 0
15380 61326 product 0 26827 A 1 D 0 0
31711 61329 product 0 43944 A 1 D 0 0
63786 61622 product 0 76019 A 1 D 0 0
31663 61622 product 0 43896 A 2 D 0 0
31696 61326 product 0 43929 A 2 D 0 0
31703 61322 product 0 43936 A 2 D 0 0
31710 61329 product 0 43943 A 2 D 1 1781
15394 61329 product 0 26841 A 3 D 0 0
31701 61326 product 0 43934 A 3 D 0 0
31708 61322 product 0 43941 A 3 D 0 0
63783 61622 product 0 76016 A 3 D 0 0
15378 61326 product 0 26825 A 4 D 0 0
15392 61329 product 0 26839 A 4 D 0 0
31664 61622 product 0 43897 A 4 D 0 0
31706 61322 product 0 43939 A 4 D 0 0
31705 61322 product 0 43938 A 5 D 0 0
45079 61326 product 0 57312 A 5 C 0 0
63784 61622 product 0 76017 A 5 D 0 0
71116 61329 product 0 83349 A 5 D 0 0
15391 61329 product 0 26838 A 6 D 0 0
31704 61322 product 0 43937 A 6 D 0 0
56274 61326 product 0 68507 A 6 C 0 0
63785 61622 product 0 76018 A 6 D 0 0
53791 61329 product 0 66024 A 7 C 1 0
57079 61326 product 0 69312 A 7 C 0 0
32437 61326 product 0 44670 A 8 C 0 0
61787 61329 product 0 74020 A 8 C 0 0
67292 61622 product 0 79525 A 8 C 0 0
68743 61322 product 0 80976 A 8 C 0 0
57046 61326 product 0 69279 A 9 C 0 0
60779 61329 product 0 73012 A 9 C 0 0
67293 61622 product 0 79526 A 9 C 0 0
67296 61322 product 0 79529 A 9 C 0 0
32470 61322 product 0 44703 A 10 C 0 0
53792 61329 product 0 66025 A 10 C 1 0
57078 61326 product 0 69311 A 10 C 0 0
56275 61326 product 0 68508 A 11 C 0 0
61404 61322 product 0 73637 A 11 C 0 0
32506 61326 product 0 44739 A 12 C 0 0
53738 61329 product 0 65971 A 12 C 1 0
61790 61322 product 0 74023 A 12 C 0 0
51667 61326 product 0 63900 A 13 C 0 0
61403 61322 product 0 73636 A 13 C 0 0
61788 61329 product 0 74021 A 13 C 0 0
31974 61326 product 0 44207 A 14 C 0 0
60077 61322 product 0 72310 A 14 C 0 0
32439 61326 product 0 44672 A 15 C 0 0
56898 61322 product 0 69131 A 15 C 0 0
19264 61326 product 0 30976 A 16 C 0 0
61834 61322 product 0 74067 A 16 C 0 0
31702 61326 product 0 43935 A 17 C 0 0
59676 61329 product 0 71909 A 17 C 0 0
61405 61322 product 0 73638 A 17 C 0 0
60076 61322 product 0 72309 A 18 C 0 0
61427 61326 product 0 73660 A 18 C 0 0
32332 61322 product 0 44565 A 19 C 0 0
32515 61326 product 0 44748 A 19 C 0 0
57076 61329 product 0 69309 A 19 C 0 0
32525 61326 product 0 44758 A 20 C 0 0
61713 61322 product 0 73946 A 20 C 0 0
18317 61326 product 0 29961 A 21 C 0 0
57206 61329 product 0 69439 A 21 C 1 0
61833 61322 product 0 74066 A 21 C 0 0
18201 61329 product 0 29830 A 22 C 1 1782
61428 61326 product 0 73661 A 22 C 0 0
61789 61322 product 0 74022 A 22 C 0 0
31963 61322 product 0 44196 A 23 C 0 0
35126 61326 product 0 47359 A 23 C 0 0
56277 61329 product 0 68510 A 23 C 1 0
17200 61326 product 0 28757 A 24 C 0 0
31973 61322 product 0 44206 A 24 C 0 0
32876 61326 product 0 45109 A 25 C 0 0
64620 61322 product 0 76853 A 25 C 0 0
20719 61326 product 0 32548 A 26 C 0 0
32526 61322 product 0 44759 A 26 C 0 0
28327 61326 product 0 40520 A 27 C 0 0
32331 61322 product 0 44564 A 27 C 0 0
28332 61322 product 0 40525 A 28 C 0 0
16767 61322 product 0 28333 A 29 C 0 0
17201 61322 product 0 28758 A 30 C 0 0
60378 61322 product 0 72611 A 31 C 0 0
65478 61322 product 0 77711 A 32 C 0 0
65480 61322 product 0 77713 A 33 C 0 0