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 (
    111882, 111881, 111880, 111878, 112552, 
    111863, 111845, 114692, 114691, 114690, 
    114689, 112371, 112370, 112369, 112017, 
    112010, 111861, 111860, 111859, 111858
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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 5054287036899.jpg 600 600 115013 111845 product 118536 M 0 118536
0 5054287033201_8xe1-n7.jpg 600 600 115026 111858 product 118549 M 0 118549
0 5054287033201_z47s-yl.jpg 600 600 115027 111859 product 118550 M 0 118550
0 5054287033201_v309-mo.jpg 600 600 115028 111860 product 118551 M 0 118551
0 5054287033201_3m3p-xl.jpg 600 600 115029 111861 product 118552 M 0 118552
0 5054287005819.jpg 1400 1400 115031 111863 product 118554 M 0 118554
0 5054287013388.jpg 1400 1400 115046 111878 product 118569 M 0 118569
0 5054287042258.jpg 1000 1000 115048 111880 product 118571 M 0 118571
0 5054287042258_hz4t-z6.jpg 1000 1000 115049 111881 product 118572 M 0 118572
0 5054287042302.jpg 1000 1000 115050 111882 product 118573 M 0 118573
0 5054287061136.jpg 1000 1000 115179 112010 product 118702 M 0 118702
0 5054287062577.jpg 1000 1000 115186 112017 product 118709 M 0 118709
0 5054287085668.jpg 1000 1000 115538 112369 product 119061 M 0 119061
0 5054287085668_o5ca-j3.jpg 1000 1000 115539 112370 product 119062 M 0 119062
0 5054287085668_w0d2-oq.jpg 1000 1000 115540 112371 product 119063 M 0 119063
0 5054287102846.jpg 1000 1000 115720 112552 product 119243 M 0 119243
0 5054287165919.jpg 1400 1400 117864 114689 product 121387 M 0 121387
0 5054287165919_6gt1-n9.jpg 1400 1400 117865 114690 product 121388 M 0 121388
0 5054287165919_j0y1-vs.jpg 1400 1400 117866 114691 product 121389 M 0 121389
0 5054287165919_tyt0-8y.jpg 1400 1400 117867 114692 product 121390 M 0 121390