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 (
    138368, 138369, 138370, 138371, 138384, 
    138385, 138546, 138547, 138548, 138549, 
    138590, 138591, 138640, 138641, 138818, 
    138819, 138820, 138821, 138822, 138823, 
    138824, 138825, 138826, 138827, 138828, 
    138829, 138830, 138831, 138832, 138833, 
    138834, 138835, 138914, 138915, 139642, 
    139643, 139786, 139787, 139906, 139907, 
    140086, 140087, 140088, 140089, 140090, 
    140091, 140092, 140093, 140094, 140095, 
    140096, 140097, 140098, 140099, 140100, 
    140101, 140102, 140103, 140104, 140105, 
    140106, 140107, 140108, 140109, 140110, 
    140111, 140112, 140113, 140114, 140115, 
    140116, 140117, 140118, 140119, 140120, 
    140121, 140122, 140123, 140124, 140125
  ) 
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.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where