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 (
    22930, 22926, 23994, 22920, 22933, 22932, 
    22931, 22929, 22928, 23995, 22924, 
    22923, 23996, 22922, 22921, 22934, 
    22935, 23991, 22937, 22938, 22939, 
    22940, 22941, 22942, 23992, 22944, 
    22945, 23993, 22946, 22947, 22966, 
    22962, 23973, 22956, 22969, 22968, 
    22967, 22965, 22964, 22963, 23974, 
    22960, 22959, 23975, 22958, 22957, 
    22984, 22980, 23976, 22974, 22987, 
    22986, 22985, 22983, 22982, 22981, 
    23977, 22978, 22977, 23978, 22976, 
    22975, 23928, 23929, 23930, 23931, 
    23932, 23933, 23934, 23935, 23937, 
    23938, 23939, 23940, 23984, 23983, 
    23981, 23980, 23982, 23979, 23990, 
    23989, 23988, 23987, 23986, 23985
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00195

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links range object_id object_id 81 86 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where