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 (
    90052, 89929, 89312, 89311, 89310, 89309, 
    89985, 89944, 89943, 89402, 89191, 
    89173, 89172, 89551, 89037, 89483, 
    89445, 89443, 88978, 88914
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00057

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 5054285326923.jpg 1000 1000 91713 88914 product 95236 M 0 95236
0 RRR_sleaveV2_005_9n8n-z6.jpg 1000 1000 91779 88978 product 95302 M 0 95302
0 5054285157282.jpg 1000 1000 91839 89037 product 95362 M 0 95362
0 5054285353615.jpg 1000 1000 91975 89172 product 95498 M 0 95498
0 5054285353615_ir5y-dh.jpg 1000 1000 91976 89173 product 95499 M 0 95499
0 5054285353004.jpg 1000 1000 91994 89191 product 95517 M 0 95517
0 5054285035801.jpg 1000 1000 92117 89309 product 95640 M 0 95640
0 5054285035801_rhou-3h.jpg 1000 1000 92118 89310 product 95641 M 0 95641
0 5054285035801_q0mi-ff.jpg 1000 1000 92119 89311 product 95642 M 0 95642
0 5054285035801_rf8b-z7.jpg 1000 1000 92120 89312 product 95643 M 0 95643
0 5054285378717.jpg 1000 1000 92211 89402 product 95734 M 0 95734
0 5054285388105.jpg 1000 1000 92266 89443 product 95789 M 0 95789
0 5054285388075.jpg 1000 1000 92268 89445 product 95791 M 0 95791
0 5054285388273.jpg 1000 1000 92306 89483 product 95829 M 0 95829
0 5054285398234.jpg 1000 1000 92374 89551 product 95897 M 0 95897
0 5054285425756.jpg 1000 1000 92753 89929 product 96276 M 0 96276
0 5054285425312.jpg 1000 1000 92767 89943 product 96290 M 0 96290
0 5054285425558.jpg 1000 1000 92768 89944 product 96291 M 0 96291
0 I_don't_mind.jpg 3000 3000 92810 89985 product 96333 M 0 96333
0 5054285432266_3l72-yc.jpg 1000 1000 92877 90052 product 96400 M 0 96400