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 (
    73566, 73567, 77858, 77859, 77860, 77861, 
    87738, 87739, 128246, 128247, 133890, 
    133891, 133892, 133893, 133894, 133895, 
    133896, 133897, 134290, 134291, 134314, 
    134315, 134944, 134945, 136472, 136473, 
    136504, 136505, 136510, 136511, 136512, 
    136513, 136514, 136515, 136516, 136517, 
    136822, 136823, 136998, 136999, 137006, 
    137007, 137008, 137009, 137014, 137015, 
    137084, 137085, 137086, 137087, 137204, 
    137205, 137242, 137243, 137246, 137247, 
    137248, 137249, 137272, 137273, 137308, 
    137309, 137310, 137311, 137336, 137337, 
    137460, 137461, 137462, 137463, 137464, 
    137465, 137466, 137467, 137566, 137567, 
    137568, 137569, 137570, 137571
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00058

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