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 = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    85913, 85912, 85911, 86694, 85855, 85819, 
    85809, 86655, 86584, 86583, 86582, 
    85751, 85702, 85701, 85691, 86647, 
    85891, 85890, 85889, 85888
  ) 
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 20 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

Result

image_id image_path image_x image_y pair_id object_id object_type detailed_id type position alt images_image_id
0 88637 85691 product 92160 M 0
0 88647 85701 product 92170 M 0
0 88648 85702 product 92171 M 0
0 88700 85751 product 92223 M 0
0 88758 85809 product 92281 M 0
0 88768 85819 product 92291 M 0
0 88804 85855 product 92327 M 0
0 88838 85888 product 92361 M 0
0 88839 85889 product 92362 M 0
0 88840 85890 product 92363 M 0
0 88841 85891 product 92364 M 0
0 88861 85911 product 92384 M 0
0 88862 85912 product 92385 M 0
0 88863 85913 product 92386 M 0
0 89315 86582 product 92838 M 0
0 89316 86583 product 92839 M 0
0 89317 86584 product 92840 M 0
0 89380 86647 product 92903 M 0
0 89388 86655 product 92911 M 0
0 89427 86694 product 92950 M 0