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 (
    111613, 111612, 110723, 111844, 111901, 
    111557, 111556, 110718, 110713, 110712, 
    110711, 124915, 111871, 110687, 110686, 
    110620, 110617, 110651, 112015, 111664
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00087

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 5054286996859.jpg 1400 1400 113782 110617 product 117305 M 0 117305
0 5054287009039.jpg 1400 1400 113785 110620 product 117308 M 0 117308
0 5054287015085.jpg 1400 1400 113816 110651 product 117339 M 0 117339
0 5054287016754.jpg 1400 1400 113851 110686 product 117374 M 0 117374
0 5054287016754_4gj5-wn.jpg 1400 1400 113852 110687 product 117375 M 0 117375
0 5054286997085.jpg 1400 1400 113878 110711 product 117401 M 0 117401
0 5054286997085_wyau-ms.jpg 1400 1400 113879 110712 product 117402 M 0 117402
0 5054286997092.jpg 1400 1400 113880 110713 product 117403 M 0 117403
0 5054287008599_tuga-hk.jpg 1400 1400 113885 110718 product 117408 M 0 117408
0 5054287011636.jpg 1400 1400 113890 110723 product 117413 M 0 117413
0 5054287018239.jpg 1400 1400 114723 111556 product 118246 M 0 118246
0 5054287018239_f9px-ew.jpg 1400 1400 114724 111557 product 118247 M 0 118247
0 5054287032532.jpg 600 600 114779 111612 product 118302 M 0 118302
0 5054287032532_ve7b-t8.jpg 600 600 114780 111613 product 118303 M 0 118303
0 5054287032501_8xrt-nr.jpg 600 600 114831 111664 product 118354 M 0 118354
0 5054287045600.jpg 600 600 115012 111844 product 118535 M 0 118535
0 5054287047918.jpg 600 600 115039 111871 product 118562 M 0 118562
0 5054287053056.jpg 1000 1000 115069 111901 product 118592 M 0 118592
0 5054287063444.jpg 1000 1000 115184 112015 product 118707 M 0 118707
0 5059801084660.jpg 1000 1000 128269 124915 product 131792 M 0 131792