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.detailed_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.00055

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.detailed_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 5054286828549.jpg 1400 1400 113287 110127 product 116810 M 0 116810
0 5054286828549_jdma-xk.jpg 1400 1400 113288 110128 product 116811 M 0 116811
0 5054286951346.jpg 1400 1400 113294 110134 product 116817 M 0 116817
0 5054286943891.jpg 1400 1400 113347 110187 product 116870 M 0 116870
0 5054286943891_djw5-jz.jpg 1400 1400 113348 110188 product 116871 M 0 116871
0 5054286951377.jpg 1400 1400 113352 110192 product 116875 M 0 116875
0 5054286942191.jpg 1400 1400 113385 110224 product 116908 M 0 116908
0 5054286942191_i5jd-xj.jpg 1400 1400 113386 110225 product 116909 M 0 116909
0 5054286971085.jpg 1400 1400 113412 110251 product 116935 M 0 116935
0 5054286963424.jpg 1400 1400 113414 110253 product 116937 M 0 116937
0 5054286857297.jpg 1400 1400 113420 110259 product 116943 M 0 116943
0 5054286857297_yypw-bh.jpg 1400 1400 113421 110260 product 116944 M 0 116944
0 5054286948797.jpg 1400 1400 113438 110277 product 116961 M 0 116961
0 5054286976042.jpg 1400 1400 113483 110321 product 117006 M 0 117006
0 5054286983644.jpg 1400 1400 113506 110344 product 117029 M 0 117029
0 5054286986096.jpg 1400 1400 113509 110347 product 117032 M 0 117032
0 5054286986034.jpg 1400 1400 113514 110352 product 117037 M 0 117037
0 5054286986034_xzjx-zx.jpg 1400 1400 113515 110353 product 117038 M 0 117038
0 5054286984122.jpg 1400 1400 113517 110355 product 117040 M 0 117040
0 5054286993216.jpg 1400 1400 114803 111636 product 118326 M 0 118326