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 (
    99122, 99121, 99120, 99119, 99106, 99104, 
    99099, 99052, 98970, 98764, 98763, 
    98762, 98761, 98760, 98759, 98758, 
    98757, 98756, 98755, 98754
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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 101792 98754 product 105315 M 0
0 101793 98755 product 105316 M 0
0 101794 98756 product 105317 M 0
0 101795 98757 product 105318 M 0
0 101796 98758 product 105319 M 0
0 101797 98759 product 105320 M 0
0 101798 98760 product 105321 M 0
0 101799 98761 product 105322 M 0
0 101800 98762 product 105323 M 0
0 101801 98763 product 105324 M 0
0 101802 98764 product 105325 M 0
0 102010 98970 product 105533 M 0
0 102092 99052 product 105615 M 0
0 102138 99099 product 105661 M 0
0 102143 99104 product 105666 M 0
0 102145 99106 product 105668 M 0
0 102158 99119 product 105681 M 0
0 102159 99120 product 105682 M 0
0 102160 99121 product 105683 M 0
0 102161 99122 product 105684 M 0