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 (
    163042, 163043, 163172, 163173, 163174, 
    163175, 163176, 163177, 163178, 163179, 
    163240, 163241, 163242, 163243, 163250, 
    163251, 163292, 163293, 163334, 163335, 
    164146, 164147, 164162, 164163, 164372, 
    164373, 164374, 164375, 164376, 164377, 
    164378, 164379, 164380, 164381, 164382, 
    164383, 164384, 164385, 164386, 164387, 
    164388, 164389, 164390, 164391, 164392, 
    164393, 164394, 164395, 164396, 164397, 
    164590, 164591, 164592, 164593, 164594, 
    164595, 164596, 164597, 164598, 164599, 
    164600, 164601, 164602, 164603, 164604, 
    164605, 164606, 164607, 164608, 164609, 
    164610, 164611, 164612, 164613, 164816, 
    164817, 164818, 164819, 164820, 164821
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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