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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    168236, 168237, 168238, 168239, 168280, 
    168281, 168282, 168283, 168284, 168285, 
    168286, 168287, 168288, 168289, 168290, 
    168291, 168292, 168293, 168294, 168295, 
    168296, 168297, 168298, 168299, 168300, 
    168301, 168302, 168303, 168304, 168305, 
    168306, 168307, 168308, 168309, 168310, 
    168311, 168312, 168313, 168314, 168315, 
    168316, 168317, 168318, 168319, 168320, 
    168321, 168322, 168323, 168324, 168325, 
    168786, 168787, 168788, 168789, 168790, 
    168791, 168792, 168793, 168836, 168837, 
    168838, 168839, 168840, 168841, 168970, 
    168971, 168972, 168973, 169350, 169351, 
    169352, 169353, 169354, 169355, 169356, 
    169357, 169358, 169359, 169360, 169361
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where