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 (
    163974, 163975, 164058, 164059, 164086, 
    164087, 164088, 164089, 164090, 164091, 
    164234, 164235, 164236, 164237, 164258, 
    164259, 164630, 164631, 164632, 164633, 
    164720, 164721, 164722, 164723, 164724, 
    164725, 164726, 164727, 164728, 164729, 
    164730, 164731, 164732, 164733, 164734, 
    164735, 164736, 164737, 164738, 164739, 
    164848, 164849, 165210, 165211, 165216, 
    165217, 165242, 165243, 165244, 165245, 
    165306, 165307, 165308, 165309, 165312, 
    165313, 165314, 165315, 165316, 165317, 
    165318, 165319, 165588, 165589, 165590, 
    165591, 165592, 165593, 166114, 166115, 
    166116, 166117, 166118, 166119, 166120, 
    166121, 166122, 166123, 166124, 166125
  ) 
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