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 (
    110277, 110260, 110259, 110253, 111636, 
    110353, 110352, 110347, 110225, 110224, 
    110355, 110192, 110188, 110187, 110344, 
    110321, 110251, 110134, 110128, 110127
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00041

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 113287 110127 product 116810 M 0
0 113288 110128 product 116811 M 0
0 113294 110134 product 116817 M 0
0 113347 110187 product 116870 M 0
0 113348 110188 product 116871 M 0
0 113352 110192 product 116875 M 0
0 113385 110224 product 116908 M 0
0 113386 110225 product 116909 M 0
0 113412 110251 product 116935 M 0
0 113414 110253 product 116937 M 0
0 113420 110259 product 116943 M 0
0 113421 110260 product 116944 M 0
0 113438 110277 product 116961 M 0
0 113483 110321 product 117006 M 0
0 113506 110344 product 117029 M 0
0 113509 110347 product 117032 M 0
0 113514 110352 product 117037 M 0
0 113515 110353 product 117038 M 0
0 113517 110355 product 117040 M 0
0 114803 111636 product 118326 M 0