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 (
    101603, 101602, 101601, 101599, 101598, 
    101596, 101595, 101594, 101593, 101592, 
    101591, 101590, 101585, 101583, 101582, 
    101544, 102132, 102131, 102130, 102129
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00071

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 5054286378266.jpg 1000 1000 104630 101544 product 108153 M 0 108153
0 5054286377245_l2rn-v7.jpg 1400 1400 104668 101582 product 108191 M 0 108191
0 5054286377245_wqdn-1w.jpg 1400 1400 104669 101583 product 108192 M 0 108192
0 5054286377245_ufo6-hv.jpg 1400 1400 104671 101585 product 108194 M 0 108194
0 5054286377245_cnm6-2l.jpg 1400 1400 104676 101590 product 108199 M 0 108199
0 5054286377245_62pc-ul.jpg 1400 1400 104677 101591 product 108200 M 0 108200
0 5054286377245_o3it-ks.jpg 1400 1400 104678 101592 product 108201 M 0 108201
0 5054286377245_b6kt-tl.jpg 1400 1400 104679 101593 product 108202 M 0 108202
0 5054286377245_trew-ac.jpg 1400 1400 104680 101594 product 108203 M 0 108203
0 5054286377245_4t0i-m0.jpg 1400 1400 104681 101595 product 108204 M 0 108204
0 5054286377245_lyxd-ax.jpg 1400 1400 104682 101596 product 108205 M 0 108205
0 5054286377245_9r91-qp.jpg 1400 1400 104684 101598 product 108207 M 0 108207
0 5054286377245_3s7y-1e.jpg 1400 1400 104685 101599 product 108208 M 0 108208
0 5054286377245_q3yi-05.jpg 1400 1400 104687 101601 product 108210 M 0 108210
0 5054286377245_2ql3-ha.jpg 1400 1400 104688 101602 product 108211 M 0 108211
0 5054286377245_p0jt-06.jpg 1400 1400 104689 101603 product 108212 M 0 108212
0 5054286453741_41me-vn.jpg 1000 1000 105223 102129 product 108746 M 0 108746
0 5054286453741_4519-1w.jpg 1000 1000 105224 102130 product 108747 M 0 108747
0 5054286453741_ya7i-mg.jpg 1000 1000 105225 102131 product 108748 M 0 108748
0 5054286453741_0d82-gy.jpg 1000 1000 105226 102132 product 108749 M 0 108749