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 (
    111794, 111793, 109129, 109032, 109031, 
    109011, 108892, 108891, 108790, 108632, 
    108618, 109040, 108675, 108674, 108610, 
    108901, 108900, 108884, 108883, 108554
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00044

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 111705 108554 product 115228 M 0
0 111763 108610 product 115286 M 0
0 111771 108618 product 115294 M 0
0 111785 108632 product 115308 M 0
0 111827 108674 product 115350 M 0
0 111828 108675 product 115351 M 0
0 111943 108790 product 115466 M 0
0 112036 108883 product 115559 M 0
0 112037 108884 product 115560 M 0
0 112044 108891 product 115567 M 0
0 112045 108892 product 115568 M 0
0 112053 108900 product 115576 M 0
0 112054 108901 product 115577 M 0
0 112164 109011 product 115687 M 0
0 112184 109031 product 115707 M 0
0 112185 109032 product 115708 M 0
0 112193 109040 product 115716 M 0
0 112282 109129 product 115805 M 0
0 114961 111793 product 118484 M 0
0 114962 111794 product 118485 M 0