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 (
    89019, 89018, 89017, 89016, 89015, 89014, 
    88971, 89484, 89444, 89278, 88869, 
    88868, 89442, 89441, 89440, 89439, 
    89438, 89139, 89138, 89137, 89136, 
    89135, 89134, 89133, 89132, 89131, 
    89130, 89129, 89128, 89127, 89126, 
    89125, 89124, 89123, 89122, 88918, 
    88726, 88725, 88724, 88723
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00126

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 91522 88723 product 95045 M 0
0 91523 88724 product 95046 M 0
0 91524 88725 product 95047 M 0
0 91525 88726 product 95048 M 0
0 91667 88868 product 95190 M 0
0 91668 88869 product 95191 M 0
0 91717 88918 product 95240 M 0
0 91772 88971 product 95295 M 0
0 91816 89014 product 95339 M 0
0 91817 89015 product 95340 M 0
0 91818 89016 product 95341 M 0
0 91819 89017 product 95342 M 0
0 91820 89018 product 95343 M 0
0 91821 89019 product 95344 M 0
0 91925 89122 product 95448 M 0
0 91926 89123 product 95449 M 0
0 91927 89124 product 95450 M 0
0 91928 89125 product 95451 M 0
0 91929 89126 product 95452 M 0
0 91930 89127 product 95453 M 0
0 91931 89128 product 95454 M 0
0 91932 89129 product 95455 M 0
0 91933 89130 product 95456 M 0
0 91934 89131 product 95457 M 0
0 91935 89132 product 95458 M 0
0 91936 89133 product 95459 M 0
0 91937 89134 product 95460 M 0
0 91938 89135 product 95461 M 0
0 91939 89136 product 95462 M 0
0 91940 89137 product 95463 M 0
0 91941 89138 product 95464 M 0
0 91942 89139 product 95465 M 0
0 92081 89278 product 95604 M 0
0 92261 89438 product 95784 M 0
0 92262 89439 product 95785 M 0
0 92263 89440 product 95786 M 0
0 92264 89441 product 95787 M 0
0 92265 89442 product 95788 M 0
0 92267 89444 product 95790 M 0
0 92307 89484 product 95830 M 0