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 (
    87311, 87310, 87309, 87308, 87307, 87306, 
    87660, 87619, 88817, 88816, 88815, 
    87791, 87923, 87293, 87292, 88787, 
    87884, 87017, 87994, 87888
  ) 
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 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 89772 87017 product 93295 M 0
0 90047 87292 product 93570 M 0
0 90048 87293 product 93571 M 0
0 90061 87306 product 93584 M 0
0 90062 87307 product 93585 M 0
0 90063 87308 product 93586 M 0
0 90064 87309 product 93587 M 0
0 90065 87310 product 93588 M 0
0 90066 87311 product 93589 M 0
0 90390 87619 product 93913 M 0
0 90431 87660 product 93954 M 0
0 90562 87791 product 94085 M 0
0 90655 87884 product 94178 M 0
0 90659 87888 product 94182 M 0
0 90694 87923 product 94217 M 0
0 90765 87994 product 94288 M 0
0 91586 88787 product 95109 M 0
0 91614 88815 product 95137 M 0
0 91615 88816 product 95138 M 0
0 91616 88817 product 95139 M 0