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 (
    110297, 110296, 110295, 110294, 110293, 
    110292, 110291, 109632, 109631, 109630, 
    109629, 109627, 110150, 110091, 109592, 
    110153, 110152, 110151, 109581, 110038
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00050

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 112736 109581 product 116259 M 0
0 112747 109592 product 116270 M 0
0 112782 109627 product 116305 M 0
0 112784 109629 product 116307 M 0
0 112785 109630 product 116308 M 0
0 112786 109631 product 116309 M 0
0 112787 109632 product 116310 M 0
0 113198 110038 product 116721 M 0
0 113251 110091 product 116774 M 0
0 113310 110150 product 116833 M 0
0 113311 110151 product 116834 M 0
0 113312 110152 product 116835 M 0
0 113313 110153 product 116836 M 0
0 113452 110291 product 116975 M 0
0 113453 110292 product 116976 M 0
0 113454 110293 product 116977 M 0
0 113455 110294 product 116978 M 0
0 113456 110295 product 116979 M 0
0 113457 110296 product 116980 M 0
0 113458 110297 product 116981 M 0