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 (
    87227, 87226, 87225, 87224, 87223, 87222, 
    87221, 87220, 87219, 87218, 87217, 
    87216, 87000, 86999, 86998, 86997, 
    86996, 86995, 86994, 86993, 86506, 
    86447, 86446, 86445, 86444, 86384, 
    86383, 86382, 86381, 86380, 86379, 
    86378, 86377, 86376, 86375, 86374, 
    87116, 86470, 86469, 86468
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00069

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 40 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 89103 86374 product 92626 M 0
0 89104 86375 product 92627 M 0
0 89105 86376 product 92628 M 0
0 89106 86377 product 92629 M 0
0 89107 86378 product 92630 M 0
0 89108 86379 product 92631 M 0
0 89109 86380 product 92632 M 0
0 89110 86381 product 92633 M 0
0 89111 86382 product 92634 M 0
0 89112 86383 product 92635 M 0
0 89113 86384 product 92636 M 0
0 89173 86444 product 92696 M 0
0 89174 86445 product 92697 M 0
0 89175 86446 product 92698 M 0
0 89176 86447 product 92699 M 0
0 89197 86468 product 92720 M 0
0 89198 86469 product 92721 M 0
0 89199 86470 product 92722 M 0
0 89235 86506 product 92758 M 0
0 89748 86993 product 93271 M 0
0 89749 86994 product 93272 M 0
0 89750 86995 product 93273 M 0
0 89751 86996 product 93274 M 0
0 89752 86997 product 93275 M 0
0 89753 86998 product 93276 M 0
0 89754 86999 product 93277 M 0
0 89755 87000 product 93278 M 0
0 89871 87116 product 93394 M 0
0 89971 87216 product 93494 M 0
0 89972 87217 product 93495 M 0
0 89973 87218 product 93496 M 0
0 89974 87219 product 93497 M 0
0 89975 87220 product 93498 M 0
0 89976 87221 product 93499 M 0
0 89977 87222 product 93500 M 0
0 89978 87223 product 93501 M 0
0 89979 87224 product 93502 M 0
0 89980 87225 product 93503 M 0
0 89981 87226 product 93504 M 0
0 89982 87227 product 93505 M 0