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 (
    219927, 
    219928, 
    219929, 
    220114, 
    219894, 
    219895, 
    219896, 
    219897, 
    220318, 
    215376, 
    215377, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    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
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00357

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": 128,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (219927,219928,219929,220114,219894,219895,219896,219897,220318,215376,215377,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,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)"
        }
      }
    },
    "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