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 (
    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.00061

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 5054285401798_8a8q-vc.jpg 1000 1000 92412 89589 product 95935 M 0 95935
0 5054285401798_wvt1-v5.jpg 1000 1000 92413 89590 product 95936 M 0 95936
0 5054285394656.jpg 1000 1000 92503 89680 product 96026 M 0 96026
0 5054285297537.jpg 1000 1000 92509 89686 product 96032 M 0 96032
0 5054285297537_doe5-sy.jpg 1000 1000 92510 89687 product 96033 M 0 96033
0 5054285297537_emkp-44.jpg 1000 1000 92511 89688 product 96034 M 0 96034
0 5054285297537_i37d-tt.jpg 1000 1000 92512 89689 product 96035 M 0 96035
0 5054285378786.jpg 1000 1000 92517 89694 product 96040 M 0 96040
0 5054285391402.jpg 1000 1000 92747 89922 product 96270 M 0 96270
0 5054285424735.jpg 1000 1000 92751 89927 product 96274 M 0 96274
0 5054285424735_e8zi-vr.jpg 1000 1000 92752 89928 product 96275 M 0 96275
0 5054285432044.jpg 1000 1000 92901 90077 product 96424 M 0 96424
0 5054285432044_gamv-ly.jpg 1000 1000 92903 90079 product 96426 M 0 96426
0 5054285432044_vjcq-qh.jpg 1000 1000 92904 90080 product 96427 M 0 96427
0 5054285444238.jpg 1000 1000 92988 90162 product 96511 M 0 96511
0 5054285459102.jpg 1000 1000 93369 90536 product 96892 M 0 96892
0 5054285475119.jpg 1000 1000 93447 90614 product 96970 M 0 96970
0 5054285475119_4eej-ki.jpg 1000 1000 93448 90615 product 96971 M 0 96971
0 5054285475102.jpg 1000 1000 93457 90624 product 96980 M 0 96980
0 UNLOCKED_COVER_ART.png 1400 1400 93733 90895 product 97256 M 0 97256