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 (
    109341, 109340, 109300, 109299, 109273, 
    109272, 109239, 109131, 109130, 110903, 
    110902, 109343, 109342, 109339, 109307, 
    109306, 109240, 109116, 109070, 109069
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 5054286845133.jpg 1400 1400 112222 109069 product 115745 M 0 115745
0 5054286845133_p3km-ef.jpg 1400 1400 112223 109070 product 115746 M 0 115746
0 5054286881599.jpg 1400 1400 112269 109116 product 115792 M 0 115792
0 5054286870593.jpg 1400 1400 112283 109130 product 115806 M 0 115806
0 5054286870593_th3a-7v.jpg 1400 1400 112284 109131 product 115807 M 0 115807
0 5054286892601.jpg 1400 1400 112392 109239 product 115915 M 0 115915
0 5054286890546.jpg 1400 1400 112393 109240 product 115916 M 0 115916
0 5054286892625.jpg 1400 1400 112425 109272 product 115948 M 0 115948
0 5054286892625_ni2t-zn.jpg 1400 1400 112426 109273 product 115949 M 0 115949
0 5054286892915.jpg 1400 1400 112452 109299 product 115975 M 0 115975
0 5054286892915_o2m4-7x.jpg 1400 1400 112453 109300 product 115976 M 0 115976
0 5054286892588.jpg 1400 1400 112459 109306 product 115982 M 0 115982
0 5054286892588_8anb-lt.jpg 1400 1400 112460 109307 product 115983 M 0 115983
0 5054286893028.jpg 1400 1400 112492 109339 product 116015 M 0 116015
0 5054286893080.jpg 1400 1400 112493 109340 product 116016 M 0 116016
0 5054286893080_8i35-wh.jpg 1400 1400 112494 109341 product 116017 M 0 116017
0 5054286892892.jpg 1400 1400 112495 109342 product 116018 M 0 116018
0 5054286892892_8bve-yp.jpg 1400 1400 112496 109343 product 116019 M 0 116019
0 9358782414807.jpg 3000 3000 114069 110902 product 117592 M 0 117592
0 9358782414807_1fpb-cg.jpg 3000 3000 114070 110903 product 117593 M 0 117593