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 (
    64181, 60659, 63234, 63816, 61565, 62061, 
    61684, 63346, 61080, 63827, 64180, 
    60799
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00120

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": 119,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (64181,60659,63234,63816,61565,62061,61684,63346,61080,63827,64180,60799)"
        }
      }
    },
    "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
12968 60799 product 0 22886 A 0 D 0 0
16873 61565 product 0 28459 A 0 D 0 0
19730 62061 product 0 31519 A 0 D 0 0
25530 63346 product 0 37667 A 0 D 0 0
27494 63816 product 0 39671 A 0 D 0 0
27612 63827 product 0 39789 A 0 D 0 0
28932 64180 product 0 41152 A 0 D 0 0
28938 64181 product 0 41158 A 0 D 0 0
36998 61080 product 0 49231 A 0 D 0 0
63399 60659 product 0 75632 A 0 D 0 0
64089 61684 product 0 76322 A 0 D 0 0
65326 63234 product 0 77559 A 0 D 0 0
66470 63234 product 0 78703 A 0 C 0 0
16872 61565 product 0 28458 A 1 D 0 0
19729 62061 product 0 31518 A 1 D 0 0
24962 63234 product 0 37038 A 1 D 0 0
27611 63827 product 0 39788 A 1 D 0 0
28933 64180 product 0 41153 A 1 D 0 0
28945 64181 product 0 41165 A 1 D 0 0
57005 63346 product 0 69238 A 1 C 0 0
63401 60659 product 0 75634 A 1 D 0 0
64090 61684 product 0 76323 A 1 D 0 0
64215 61080 product 0 76448 A 1 D 0 0
64477 60799 product 0 76710 A 1 D 0 0
68286 63816 product 0 80519 A 1 C 0 0
17077 61684 product 0 28610 A 2 D 0 0
27614 63827 product 0 39791 A 2 D 0 0
28934 64180 product 0 41154 A 2 D 0 0
28946 64181 product 0 41166 A 2 D 0 0
36997 61080 product 0 49230 A 2 D 0 0
52007 63816 product 0 64240 A 2 C 0 0
57004 63346 product 0 69237 A 2 C 0 0
61354 63346 product 0 73587 A 2 C 0 0
64161 62061 product 0 76394 A 2 D 0 0
64472 60799 product 0 76705 A 2 D 0 0
64654 61565 product 0 76887 A 2 D 0 0
65328 63234 product 0 77561 A 2 D 0 0
12964 60659 product 0 22878 A 3 D 0 0
17075 61684 product 0 28608 A 3 D 0 0
27609 63827 product 0 39786 A 3 D 0 0
27799 63816 product 0 39976 A 3 C 0 0
28935 64180 product 0 41155 A 3 D 0 0
28947 64181 product 0 41167 A 3 D 0 0
64162 62061 product 0 76395 A 3 D 0 0
64214 61080 product 0 76447 A 3 D 0 0
64475 60799 product 0 76708 A 3 D 0 0
64656 61565 product 0 76889 A 3 D 0 0
65325 63234 product 0 77558 A 3 D 0 0
17076 61684 product 0 28609 A 4 D 0 0
19731 62061 product 0 31520 A 4 D 0 0
27495 63816 product 0 39672 A 4 D 0 0
27608 63827 product 0 39785 A 4 D 0 0
28948 64181 product 0 41168 A 4 D 0 0
32153 63234 product 0 44386 A 4 D 0 0
37000 61080 product 0 49233 A 4 D 0 0
63400 60659 product 0 75633 A 4 D 0 0
64653 61565 product 0 76886 A 4 D 0 0
16874 61565 product 0 28460 A 5 D 0 0
27498 63816 product 0 39675 A 5 D 0 0
27613 63827 product 0 39790 A 5 D 0 0
28937 64180 product 0 41157 A 5 D 0 0
28949 64181 product 0 41169 A 5 D 0 0
29810 62061 product 0 42033 A 5 D 0 0
36999 61080 product 0 49232 A 5 D 0 0
63397 60659 product 0 75630 A 5 D 0 0
64087 61684 product 0 76320 A 5 D 0 0
64476 60799 product 0 76709 A 5 D 0 0
65327 63234 product 0 77560 A 5 D 0 0
66468 63234 product 0 78701 A 5 C 0 0
14230 61080 product 0 25025 A 6 D 0 0
17220 61684 product 0 28787 A 6 D 0 0
27497 63816 product 0 39674 A 6 D 0 0
27617 63827 product 0 39794 A 6 D 0 0
29809 62061 product 0 42032 A 6 D 0 0
58270 64180 product 0 70503 A 6 C 0 0
63395 60659 product 0 75628 A 6 D 0 0
64280 64181 product 0 76513 A 6 C 0 0
64473 60799 product 0 76706 A 6 D 0 0
64655 61565 product 0 76888 A 6 D 0 0
65074 61565 product 0 77307 A 6 C 0 0
68681 61565 product 0 80914 A 6 C 0 0
68682 61565 product 0 80915 A 6 C 0 0
68683 61565 product 0 80916 A 6 C 0 0
52008 63816 product 0 64241 A 7 C 0 0
55533 62061 product 0 67766 A 7 C 0 0
56084 64181 product 0 68317 A 7 C 0 0
58479 64180 product 0 70712 A 7 C 0 0
60293 61080 product 0 72526 A 7 C 0 0
61852 60799 product 0 74085 A 7 C 0 0
64088 61684 product 0 76321 A 7 D 0 0
66029 62061 product 0 78262 A 7 C 0 0
66030 62061 product 0 78263 A 7 C 0 0
68373 63827 product 0 80606 A 7 C 0 0
17634 61684 product 0 29259 A 8 D 0 0
52009 63816 product 0 64242 A 8 D 0 0
58534 64181 product 0 70767 A 8 C 0 0
60752 64180 product 0 72985 A 8 C 0 0
61837 61080 product 0 74070 A 8 C 0 0
61853 60799 product 0 74086 A 8 C 0 0
68374 63827 product 0 80607 A 8 C 0 0
56085 64181 product 0 68318 A 9 C 0 0
58478 64180 product 0 70711 A 9 C 0 0
60292 61080 product 0 72525 A 9 C 0 0
61431 63827 product 0 73664 A 9 C 0 0
61854 60799 product 0 74087 A 9 C 0 0
56086 64181 product 0 68319 A 10 C 0 0
60294 61080 product 0 72527 A 10 C 0 0
60751 64180 product 0 72984 A 10 C 0 0
61432 63827 product 0 73665 A 10 C 0 0
68673 63827 product 0 80906 A 10 C 0 0
46019 61080 product 0 58252 A 11 C 0 0
57456 64181 product 0 69689 A 11 C 0 0
60753 64180 product 0 72986 A 11 C 0 0
46020 61080 product 0 58253 A 12 C 0 0
58536 64181 product 0 70769 A 12 C 0 0
65006 64180 product 0 77239 A 12 C 0 0
57458 64181 product 0 69691 A 13 C 0 0
65526 64180 product 0 77759 A 13 C 0 0
65527 64180 product 0 77760 A 14 C 0 0