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 (
    87149, 87148, 87147, 87146, 87478, 87461, 
    87267, 87013, 87012, 86982, 87168, 
    87437, 87163, 87162, 87438, 87288, 
    87287, 87025, 87022, 86884, 88075, 
    88074, 88073, 88072, 87072, 87071, 
    87070, 86983, 86835, 86603, 86602, 
    86601, 87357, 86850, 86849, 86848, 
    86847, 86846, 86845, 86693
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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 89334 86601 product 92857 M 0
0 89335 86602 product 92858 M 0
0 89336 86603 product 92859 M 0
0 89426 86693 product 92949 M 0
0 89568 86835 product 93091 M 0
0 89578 86845 product 93101 M 0
0 89579 86846 product 93102 M 0
0 89580 86847 product 93103 M 0
0 89581 86848 product 93104 M 0
0 89582 86849 product 93105 M 0
0 89583 86850 product 93106 M 0
0 89617 86884 product 93140 M 0
0 89737 86982 product 93260 M 0
0 89738 86983 product 93261 M 0
0 89767 87012 product 93290 M 0
0 89768 87013 product 93291 M 0
0 89777 87022 product 93300 M 0
0 89780 87025 product 93303 M 0
0 89825 87070 product 93348 M 0
0 89826 87071 product 93349 M 0
0 89827 87072 product 93350 M 0
0 89901 87146 product 93424 M 0
0 89902 87147 product 93425 M 0
0 89903 87148 product 93426 M 0
0 89904 87149 product 93427 M 0
0 89917 87162 product 93440 M 0
0 89918 87163 product 93441 M 0
0 89923 87168 product 93446 M 0
0 90022 87267 product 93545 M 0
0 90042 87287 product 93565 M 0
0 90043 87288 product 93566 M 0
0 90112 87357 product 93635 M 0
0 90192 87437 product 93715 M 0
0 90193 87438 product 93716 M 0
0 90216 87461 product 93739 M 0
0 90233 87478 product 93756 M 0
0 90843 88072 product 94366 M 0
0 90844 88073 product 94367 M 0
0 90845 88074 product 94368 M 0
0 90846 88075 product 94369 M 0