SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 = 'ru' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    2094, 1546, 1601, 371, 358, 449, 1540, 
    2082, 1516, 1545, 352, 2092
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.01139

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": 48,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (2094,1546,1601,371,358,449,1540,2082,1516,1545,352,2092)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "4",
      "used_key_parts": ["image_id"],
      "ref": ["noframes_kz_new.cscart_images_links.image_id"],
      "rows": 1,
      "filtered": 100
    },
    "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": ["noframes_kz_new.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 = 'ru' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result

image_id image_path image_x image_y is_high_res rf_original pair_id object_id object_type detailed_id type position alt images_image_id
0 10782 1545 product 8989 A 1
0 10817 449 product 9024 A 1
0 10843 1546 product 9050 A 1
0 10869 2094 product 9076 A 4
0 10818 449 product 9025 A 5
0 10708 1601 product 8915 A 6
0 10736 371 product 8943 A 6
0 10875 1540 product 9082 A 6
0 10709 1601 product 8916 A 7
0 10726 2082 product 8933 A 7
0 10737 371 product 8944 A 7
0 10762 1516 product 8969 A 7
0 10768 2092 product 8975 A 7
0 10783 1545 product 8990 A 7
0 10819 449 product 9026 A 7
0 10844 1546 product 9051 A 7
0 10876 1540 product 9083 A 7
0 10710 1601 product 8917 A 8
0 10727 2082 product 8934 A 8
0 10738 371 product 8945 A 8
0 10744 358 product 8951 A 8
0 10763 1516 product 8970 A 8
0 10769 2092 product 8976 A 8
0 10784 1545 product 8991 A 8
0 10790 352 product 8997 A 8
0 10845 1546 product 9052 A 8
0 10877 1540 product 9084 A 8
0 10711 1601 product 8918 A 9
0 10728 2082 product 8935 A 9
0 10745 358 product 8952 A 9
0 10764 1516 product 8971 A 9
0 10770 2092 product 8977 A 9
0 10791 352 product 8998 A 9
0 10870 2094 product 9077 A 9
0 10878 1540 product 9085 A 9
0 10712 1601 product 8919 A 10
0 10729 2082 product 8936 A 10
0 10746 358 product 8953 A 10
0 10765 1516 product 8972 A 10
0 10771 2092 product 8978 A 10
0 10792 352 product 8999 A 10
0 10871 2094 product 9078 A 10
0 10730 2082 product 8937 A 11
0 10766 1516 product 8973 A 11
0 10772 2092 product 8979 A 11
0 10793 352 product 9000 A 11
0 10872 2094 product 9079 A 11
0 10773 2092 product 8980 A 12
0 10873 2094 product 9080 A 12