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 (
    104382, 104381, 104380, 104379, 102165, 
    102164, 102163, 102162, 102161, 102160, 
    102159, 102158, 102157, 102156, 102155, 
    102154, 102150, 104598, 102142, 102141
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00063

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 105235 102141 product 108758 M 0
0 105236 102142 product 108759 M 0
0 105244 102150 product 108767 M 0
0 105248 102154 product 108771 M 0
0 105249 102155 product 108772 M 0
0 105250 102156 product 108773 M 0
0 105251 102157 product 108774 M 0
0 105252 102158 product 108775 M 0
0 105253 102159 product 108776 M 0
0 105254 102160 product 108777 M 0
0 105255 102161 product 108778 M 0
0 105256 102162 product 108779 M 0
0 105257 102163 product 108780 M 0
0 105258 102164 product 108781 M 0
0 105259 102165 product 108782 M 0
0 107478 104379 product 111001 M 0
0 107479 104380 product 111002 M 0
0 107480 104381 product 111003 M 0
0 107481 104382 product 111004 M 0
0 107700 104598 product 111223 M 0