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 (
    2093, 2094, 1546, 1601, 2392, 371, 449, 
    1540, 2404, 2082, 2405, 1516
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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": 53,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'product' and cscart_images_links.`type` = 'A' and cscart_images_links.object_id in (2093,2094,1546,1601,2392,371,449,1540,2404,2082,2405,1516)"
        }
      }
    },
    "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 10817 449 product 9024 A 1
0 10843 1546 product 9050 A 1
0 10996 2405 product 9203 A 2
0 10869 2094 product 9076 A 4
0 10927 2392 product 9134 A 4
0 10991 2404 product 9198 A 4
0 10818 449 product 9025 A 5
0 10847 2093 product 9054 A 5
0 10928 2392 product 9135 A 5
0 10992 2404 product 9199 A 5
0 10997 2405 product 9204 A 5
0 10708 1601 product 8915 A 6
0 10736 371 product 8943 A 6
0 10848 2093 product 9055 A 6
0 10875 1540 product 9082 A 6
0 10929 2392 product 9136 A 6
0 10993 2404 product 9200 A 6
0 10998 2405 product 9205 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 10819 449 product 9026 A 7
0 10844 1546 product 9051 A 7
0 10849 2093 product 9056 A 7
0 10876 1540 product 9083 A 7
0 10930 2392 product 9137 A 7
0 10994 2404 product 9201 A 7
0 10999 2405 product 9206 A 7
0 10710 1601 product 8917 A 8
0 10727 2082 product 8934 A 8
0 10738 371 product 8945 A 8
0 10763 1516 product 8970 A 8
0 10845 1546 product 9052 A 8
0 10850 2093 product 9057 A 8
0 10877 1540 product 9084 A 8
0 10931 2392 product 9138 A 8
0 11000 2405 product 9207 A 8
0 10711 1601 product 8918 A 9
0 10728 2082 product 8935 A 9
0 10764 1516 product 8971 A 9
0 10851 2093 product 9058 A 9
0 10870 2094 product 9077 A 9
0 10878 1540 product 9085 A 9
0 10932 2392 product 9139 A 9
0 11001 2405 product 9208 A 9
0 10712 1601 product 8919 A 10
0 10729 2082 product 8936 A 10
0 10765 1516 product 8972 A 10
0 10852 2093 product 9059 A 10
0 10871 2094 product 9078 A 10
0 10730 2082 product 8937 A 11
0 10766 1516 product 8973 A 11
0 10853 2093 product 9060 A 11
0 10872 2094 product 9079 A 11
0 10873 2094 product 9080 A 12