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 (
    79240, 79238, 79236, 79234, 79341, 79340, 
    83864, 79346, 83852, 79345, 78379, 
    78378, 78376, 78374, 78372, 79222, 
    78202, 79224, 79311, 79310
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00090

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 81060 78202 product 84583 M 0
0 81230 78372 product 84753 M 0
0 81232 78374 product 84755 M 0
0 81234 78376 product 84757 M 0
0 81236 78378 product 84759 M 0
0 81237 78379 product 84760 M 0
0 82089 79222 product 85612 M 0
0 82091 79224 product 85614 M 0
0 82101 79234 product 85624 M 0
0 82103 79236 product 85626 M 0
0 82105 79238 product 85628 M 0
0 82107 79240 product 85630 M 0
0 82177 79310 product 85700 M 0
0 82178 79311 product 85701 M 0
0 82207 79340 product 85730 M 0
0 82208 79341 product 85731 M 0
0 82212 79345 product 85735 M 0
0 82213 79346 product 85736 M 0
0 86772 83852 product 90295 M 0
0 86784 83864 product 90307 M 0