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 (
    87627, 87626, 87625, 87624, 87623, 87622, 
    87621, 87620, 88579, 88170, 87964, 
    87680, 88790, 88789, 88788, 87400, 
    87316, 87315, 87314, 87313
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 90068 87313 product 93591 M 0
0 90069 87314 product 93592 M 0
0 90070 87315 product 93593 M 0
0 90071 87316 product 93594 M 0
0 90155 87400 product 93678 M 0
0 90391 87620 product 93914 M 0
0 90392 87621 product 93915 M 0
0 90393 87622 product 93916 M 0
0 90394 87623 product 93917 M 0
0 90395 87624 product 93918 M 0
0 90396 87625 product 93919 M 0
0 90397 87626 product 93920 M 0
0 90398 87627 product 93921 M 0
0 90451 87680 product 93974 M 0
0 90735 87964 product 94258 M 0
0 90940 88170 product 94463 M 0
0 91378 88579 product 94901 M 0
0 91587 88788 product 95110 M 0
0 91588 88789 product 95111 M 0
0 91589 88790 product 95112 M 0