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

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 107716 104614 product 111239 M 0
0 107717 104615 product 111240 M 0
0 107718 104616 product 111241 M 0
0 107719 104617 product 111242 M 0
0 107720 104618 product 111243 M 0
0 107721 104619 product 111244 M 0
0 107722 104620 product 111245 M 0
0 107723 104621 product 111246 M 0
0 107724 104622 product 111247 M 0
0 107725 104623 product 111248 M 0
0 107726 104624 product 111249 M 0
0 107727 104625 product 111250 M 0
0 107728 104626 product 111251 M 0
0 107729 104627 product 111252 M 0
0 107730 104628 product 111253 M 0
0 107731 104629 product 111254 M 0
0 107732 104630 product 111255 M 0
0 107733 104631 product 111256 M 0
0 107734 104632 product 111257 M 0
0 107735 104633 product 111258 M 0