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 (
    104633, 104632, 104631, 104630, 104629, 
    104628, 104627, 104626, 104625, 104624, 
    104623, 104622, 104621, 104620, 104619, 
    104618, 104617, 104616, 104615, 104614
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00049

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 5054286510192_2ga4-7z.jpg 1000 1000 107716 104614 product 111239 M 0 111239
0 5054286510192_n0bo-ft.jpg 1000 1000 107717 104615 product 111240 M 0 111240
0 5054286510192_vf9n-qu.jpg 1000 1000 107718 104616 product 111241 M 0 111241
0 5054286510192_w4f2-m4.jpg 1000 1000 107719 104617 product 111242 M 0 111242
0 5054286510192_9tzi-y4.jpg 1000 1000 107720 104618 product 111243 M 0 111243
0 5054286510192_reio-o6.jpg 1000 1000 107721 104619 product 111244 M 0 111244
0 5054286510192_fcyu-5b.jpg 1000 1000 107722 104620 product 111245 M 0 111245
0 5054286510192_dewh-sk.jpg 1000 1000 107723 104621 product 111246 M 0 111246
0 5054286510192_eawq-7a.jpg 1000 1000 107724 104622 product 111247 M 0 111247
0 5054286510192_mhn5-9g.jpg 1000 1000 107725 104623 product 111248 M 0 111248
0 5054286510192_01rb-jh.jpg 1000 1000 107726 104624 product 111249 M 0 111249
0 5054286510192_75yt-5t.jpg 1000 1000 107727 104625 product 111250 M 0 111250
0 5054286510192_euzw-i0.jpg 1000 1000 107728 104626 product 111251 M 0 111251
0 5054286510192_oqot-lm.jpg 1000 1000 107729 104627 product 111252 M 0 111252
0 5054286510192_u2tq-a1.jpg 1000 1000 107730 104628 product 111253 M 0 111253
0 5054286510192_48xt-dp.jpg 1000 1000 107731 104629 product 111254 M 0 111254
0 5054286510192_8kb1-co.jpg 1000 1000 107732 104630 product 111255 M 0 111255
0 5054286510192_vfqq-dk.jpg 1000 1000 107733 104631 product 111256 M 0 111256
0 5054286510192_o9zh-u2.jpg 1000 1000 107734 104632 product 111257 M 0 111257
0 5054286510192_fu1w-qu.jpg 1000 1000 107735 104633 product 111258 M 0 111258