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 (
    98260, 98259, 98258, 98257, 98256, 98255, 
    98254, 98253, 98252, 98251, 98250, 
    98249, 98248, 98247, 98246, 98245, 
    98244, 98243, 98242, 98241
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00040

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 101273 98241 product 104796 M 0
0 101274 98242 product 104797 M 0
0 101275 98243 product 104798 M 0
0 101276 98244 product 104799 M 0
0 101277 98245 product 104800 M 0
0 101278 98246 product 104801 M 0
0 101279 98247 product 104802 M 0
0 101280 98248 product 104803 M 0
0 101281 98249 product 104804 M 0
0 101282 98250 product 104805 M 0
0 101283 98251 product 104806 M 0
0 101284 98252 product 104807 M 0
0 101285 98253 product 104808 M 0
0 101286 98254 product 104809 M 0
0 101287 98255 product 104810 M 0
0 101288 98256 product 104811 M 0
0 101289 98257 product 104812 M 0
0 101290 98258 product 104813 M 0
0 101291 98259 product 104814 M 0
0 101292 98260 product 104815 M 0