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 (
    89607, 89606, 89605, 89604, 89603, 89602, 
    89601, 89600, 90393, 90163, 90070, 
    90069, 90068, 89588, 89587, 89535, 
    89534, 90287, 89533, 90328, 90327, 
    89543, 89530, 89529, 89528, 89517, 
    89487, 89486, 90303, 90302, 90301, 
    90300, 90299, 90298, 90297, 90296, 
    90295, 90294, 90293, 90292
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 92309 89486 product 95832 M 0
0 92310 89487 product 95833 M 0
0 92340 89517 product 95863 M 0
0 92351 89528 product 95874 M 0
0 92352 89529 product 95875 M 0
0 92353 89530 product 95876 M 0
0 92356 89533 product 95879 M 0
0 92357 89534 product 95880 M 0
0 92358 89535 product 95881 M 0
0 92366 89543 product 95889 M 0
0 92410 89587 product 95933 M 0
0 92411 89588 product 95934 M 0
0 92423 89600 product 95946 M 0
0 92424 89601 product 95947 M 0
0 92425 89602 product 95948 M 0
0 92426 89603 product 95949 M 0
0 92427 89604 product 95950 M 0
0 92428 89605 product 95951 M 0
0 92429 89606 product 95952 M 0
0 92430 89607 product 95953 M 0
0 92893 90068 product 96416 M 0
0 92894 90069 product 96417 M 0
0 92895 90070 product 96418 M 0
0 92989 90163 product 96512 M 0
0 93117 90287 product 96640 M 0
0 93122 90292 product 96645 M 0
0 93123 90293 product 96646 M 0
0 93124 90294 product 96647 M 0
0 93125 90295 product 96648 M 0
0 93126 90296 product 96649 M 0
0 93127 90297 product 96650 M 0
0 93128 90298 product 96651 M 0
0 93129 90299 product 96652 M 0
0 93130 90300 product 96653 M 0
0 93131 90301 product 96654 M 0
0 93132 90302 product 96655 M 0
0 93133 90303 product 96656 M 0
0 93158 90327 product 96681 M 0
0 93159 90328 product 96682 M 0
0 93225 90393 product 96748 M 0