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.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 (
    162714, 162715, 162716, 162717, 162718, 
    162719, 162720, 162721, 162722, 162723, 
    162724, 162725, 162726, 162727, 162728, 
    162729, 162730, 162731, 162732, 162733, 
    162734, 162735, 162852, 162853, 162854, 
    162855, 162856, 162857, 162858, 162859, 
    162900, 162901, 162902, 162903, 162904, 
    162905, 162974, 162975, 163914, 163915, 
    163916, 163917, 163918, 163919, 163920, 
    163921, 163922, 163923, 163924, 163925, 
    163926, 163927, 163928, 163929, 164154, 
    164155, 164348, 164349, 164350, 164351, 
    164352, 164353, 164354, 164355, 164356, 
    164357, 164358, 164359, 164360, 164361, 
    164362, 164363, 164364, 164365, 164366, 
    164367, 164368, 164369, 164370, 164371
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

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 80 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where