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 (
    94340, 95201, 94314, 94294, 94293, 94292, 
    94290, 94289, 94288, 94287, 94258, 
    94257, 94250, 94249, 94248, 94247, 
    94246, 94245, 94244, 94243, 94242, 
    94241, 94240, 94239, 94238, 94237, 
    94236, 94235, 94234, 94233, 94232, 
    94229, 94228, 94224, 94223, 94222, 
    94221, 94220, 94219, 94218
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00091

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 40 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 97098 94218 product 100621 M 0
0 97099 94219 product 100622 M 0
0 97100 94220 product 100623 M 0
0 97101 94221 product 100624 M 0
0 97102 94222 product 100625 M 0
0 97103 94223 product 100626 M 0
0 97104 94224 product 100627 M 0
0 97108 94228 product 100631 M 0
0 97109 94229 product 100632 M 0
0 97112 94232 product 100635 M 0
0 97113 94233 product 100636 M 0
0 97114 94234 product 100637 M 0
0 97115 94235 product 100638 M 0
0 97116 94236 product 100639 M 0
0 97117 94237 product 100640 M 0
0 97118 94238 product 100641 M 0
0 97119 94239 product 100642 M 0
0 97120 94240 product 100643 M 0
0 97121 94241 product 100644 M 0
0 97122 94242 product 100645 M 0
0 97123 94243 product 100646 M 0
0 97124 94244 product 100647 M 0
0 97125 94245 product 100648 M 0
0 97126 94246 product 100649 M 0
0 97127 94247 product 100650 M 0
0 97128 94248 product 100651 M 0
0 97129 94249 product 100652 M 0
0 97130 94250 product 100653 M 0
0 97137 94257 product 100660 M 0
0 97138 94258 product 100661 M 0
0 97167 94287 product 100690 M 0
0 97168 94288 product 100691 M 0
0 97169 94289 product 100692 M 0
0 97170 94290 product 100693 M 0
0 97174 94292 product 100697 M 0
0 97175 94293 product 100698 M 0
0 97176 94294 product 100699 M 0
0 97196 94314 product 100719 M 0
0 97224 94340 product 100747 M 0
0 98095 95201 product 101618 M 0