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 (
    110209, 110208, 110207, 110206, 110205, 
    110204, 110203, 110202, 110201, 110200, 
    110199, 110198, 110693, 110692, 110189, 
    110154, 110145, 110543, 110524, 110490
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00065

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 5054286947981.jpg 1399 1400 113305 110145 product 116828 M 0 116828
0 5054286934882.jpg 1400 1400 113314 110154 product 116837 M 0 116837
0 5054286899402.jpg 1400 1400 113349 110189 product 116872 M 0 116872
0 5054286881896.jpg 1400 1400 113359 110198 product 116882 M 0 116882
0 5054286881896_re8k-i9.jpg 1400 1400 113360 110199 product 116883 M 0 116883
0 5054286881896_ppsf-af.jpg 1400 1400 113361 110200 product 116884 M 0 116884
0 5054286881896_t11c-to.jpg 1400 1400 113362 110201 product 116885 M 0 116885
0 5054286881896_3ja6-ku.jpg 1400 1400 113363 110202 product 116886 M 0 116886
0 5054286881896_ri47-vn.jpg 1400 1400 113364 110203 product 116887 M 0 116887
0 5054286881896_h6d5-zg.jpg 1400 1400 113365 110204 product 116888 M 0 116888
0 5054286881896_4c78-k6.jpg 1400 1400 113366 110205 product 116889 M 0 116889
0 5054286881896_9a3l-hp.jpg 1400 1400 113367 110206 product 116890 M 0 116890
0 5054286881896_liq7-bl.jpg 1400 1400 113368 110207 product 116891 M 0 116891
0 5054286881896_foni-63.jpg 1400 1400 113369 110208 product 116892 M 0 116892
0 5054286881896_nt0z-1h.jpg 1400 1400 113370 110209 product 116893 M 0 116893
0 5054286994916_4omt-fn.jpg 1400 1400 113652 110490 product 117175 M 0 117175
0 5054287000692.jpg 1400 1400 113686 110524 product 117209 M 0 117209
0 5054287003822.jpg 1400 1400 113705 110543 product 117228 M 0 117228
0 5054287018109.jpg 1400 1400 113857 110692 product 117380 M 0 117380
0 5054287018109_g2n8-an.jpg 1400 1400 113858 110693 product 117381 M 0 117381