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 (
    90895, 90615, 90614, 90624, 90536, 90162, 
    89928, 89927, 89922, 89694, 89689, 
    89688, 89687, 89686, 89680, 89590, 
    89589, 90080, 90079, 90077
  ) 
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 20 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 92412 89589 product 95935 M 0
0 92413 89590 product 95936 M 0
0 92503 89680 product 96026 M 0
0 92509 89686 product 96032 M 0
0 92510 89687 product 96033 M 0
0 92511 89688 product 96034 M 0
0 92512 89689 product 96035 M 0
0 92517 89694 product 96040 M 0
0 92747 89922 product 96270 M 0
0 92751 89927 product 96274 M 0
0 92752 89928 product 96275 M 0
0 92901 90077 product 96424 M 0
0 92903 90079 product 96426 M 0
0 92904 90080 product 96427 M 0
0 92988 90162 product 96511 M 0
0 93369 90536 product 96892 M 0
0 93447 90614 product 96970 M 0
0 93448 90615 product 96971 M 0
0 93457 90624 product 96980 M 0
0 93733 90895 product 97256 M 0