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.detailed_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 (
    89286, 89010, 89009, 89008, 89007, 88970, 
    88969, 88928, 88925, 110658, 89204, 
    89203, 89006, 89005, 89004, 88697, 
    89289, 88426, 88351, 88350
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00084

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.detailed_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 5054285248478_xrfq-nf.jpg 1000 1000 91143 88350 product 94666 M 0 94666
0 5054285248478_6ij7-dd.jpg 1000 1000 91144 88351 product 94667 M 0 94667
0 5054285299074.jpg 1000 1000 91224 88426 product 94747 M 0 94747
0 5054284659466_bodx-wj.jpg 1000 1000 91496 88697 product 95019 M 0 95019
0 5054285151389.jpg 1000 1000 91724 88925 product 95247 M 0 95247
0 5054285328040.jpg 1000 1000 91729 88928 product 95252 M 0 95252
0 5054285300466.jpg 1000 1000 91770 88969 product 95293 M 0 95293
0 5054285335529.jpg 1000 1000 91771 88970 product 95294 M 0 95294
0 5054285349489.jpg 1000 1000 91806 89004 product 95329 M 0 95329
0 5054285349489_ujuc-27.jpg 1000 1000 91807 89005 product 95330 M 0 95330
0 5054285349489_lh3l-c7.jpg 1000 1000 91808 89006 product 95331 M 0 95331
0 5054285349496.jpg 1000 1000 91809 89007 product 95332 M 0 95332
0 5054285349496_7ezw-8s.jpg 1000 1000 91810 89008 product 95333 M 0 95333
0 5054285349496_v5ec-o1.jpg 1000 1000 91811 89009 product 95334 M 0 95334
0 5054285349496_iu2d-pz.jpg 1000 1000 91812 89010 product 95335 M 0 95335
0 5054285363416.jpg 1000 1000 92006 89203 product 95529 M 0 95529
0 5054285363416_umi7-gh.jpg 1000 1000 92007 89204 product 95530 M 0 95530
0 5054285373248.jpg 1000 1000 92094 89286 product 95617 M 0 95617
0 5054285371367.jpg 1000 1000 92097 89289 product 95620 M 0 95620
0 9355974274201.jpg 3000 3000 113823 110658 product 117346 M 0 117346