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.detailed_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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    219169, 
    219170, 
    219171, 
    220133, 
    219172, 
    219173, 
    220238, 
    219398, 
    219399, 
    220318, 
    215376, 
    215377, 
    235107, 
    244462, 
    244463, 
    244464, 
    244465, 
    244466, 
    244467, 
    244468, 
    244469, 
    235077, 
    235078, 
    235079, 
    235080, 
    235081, 
    235082, 
    237317, 
    237318, 
    235083, 
    245070, 
    240990, 
    235084, 
    235085, 
    235086, 
    235087, 
    235088, 
    240991, 
    235089, 
    235090, 
    235091, 
    235092, 
    235093, 
    235094, 
    235095, 
    235096, 
    240992, 
    235097, 
    240993, 
    235098, 
    235099, 
    245071, 
    245072, 
    235108, 
    235100, 
    235101, 
    245073, 
    240994, 
    235102, 
    235103, 
    235104, 
    235105, 
    235106, 
    235123, 
    235109, 
    244470, 
    244471, 
    244472, 
    244473, 
    244474, 
    244475, 
    244476, 
    244477, 
    235151, 
    235124, 
    235125, 
    235126, 
    235127, 
    235128, 
    235129, 
    235150, 
    235130, 
    237319, 
    237320, 
    235131, 
    245074, 
    241095, 
    235132, 
    235133, 
    235134, 
    235135, 
    235136, 
    241096, 
    235137, 
    235138, 
    235139, 
    235140, 
    235141, 
    235142, 
    235143, 
    235144, 
    241097, 
    235145, 
    241098, 
    235146, 
    235147, 
    245075, 
    245076, 
    235152, 
    235148, 
    235149, 
    245077, 
    241099, 
    235245, 
    244486, 
    244487, 
    244488, 
    244489, 
    244490, 
    244491, 
    244492, 
    244493, 
    235271, 
    235246, 
    235247, 
    235248, 
    235249, 
    235250, 
    235251, 
    237321, 
    237322, 
    235252, 
    245082, 
    241000, 
    235253, 
    235254, 
    235255, 
    235256, 
    235257, 
    241001, 
    235258, 
    235259, 
    235260, 
    235261, 
    235262, 
    235263, 
    235264, 
    235265, 
    241002, 
    235266, 
    241003, 
    235267, 
    235268, 
    245083, 
    245084, 
    235272, 
    235269, 
    235270, 
    245085, 
    241004
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00208

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": 160,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219169,219170,219171,220133,219172,219173,220238,219398,219399,220318,215376,215377,235107,244462,244463,244464,244465,244466,244467,244468,244469,235077,235078,235079,235080,235081,235082,237317,237318,235083,245070,240990,235084,235085,235086,235087,235088,240991,235089,235090,235091,235092,235093,235094,235095,235096,240992,235097,240993,235098,235099,245071,245072,235108,235100,235101,245073,240994,235102,235103,235104,235105,235106,235123,235109,244470,244471,244472,244473,244474,244475,244476,244477,235151,235124,235125,235126,235127,235128,235129,235150,235130,237319,237320,235131,245074,241095,235132,235133,235134,235135,235136,241096,235137,235138,235139,235140,235141,235142,235143,235144,241097,235145,241098,235146,235147,245075,245076,235152,235148,235149,245077,241099,235245,244486,244487,244488,244489,244490,244491,244492,244493,235271,235246,235247,235248,235249,235250,235251,237321,237322,235252,245082,241000,235253,235254,235255,235256,235257,241001,235258,235259,235260,235261,235262,235263,235264,235265,241002,235266,241003,235267,235268,245083,245084,235272,235269,235270,245085,241004)"
        }
      }
    },
    "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.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_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