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 (
    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.00057

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 115013 111845 product 118536 M 0
0 115026 111858 product 118549 M 0
0 115027 111859 product 118550 M 0
0 115028 111860 product 118551 M 0
0 115029 111861 product 118552 M 0
0 115031 111863 product 118554 M 0
0 115046 111878 product 118569 M 0
0 115048 111880 product 118571 M 0
0 115049 111881 product 118572 M 0
0 115050 111882 product 118573 M 0
0 115179 112010 product 118702 M 0
0 115186 112017 product 118709 M 0
0 115538 112369 product 119061 M 0
0 115539 112370 product 119062 M 0
0 115540 112371 product 119063 M 0
0 115720 112552 product 119243 M 0
0 117864 114689 product 121387 M 0
0 117865 114690 product 121388 M 0
0 117866 114691 product 121389 M 0
0 117867 114692 product 121390 M 0