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 (
    112148, 111842, 111841, 111840, 111839, 
    112382, 111756, 111755, 111754, 111753, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00047

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 114909 111742 product 118432 M 0
0 114910 111743 product 118433 M 0
0 114911 111744 product 118434 M 0
0 114912 111745 product 118435 M 0
0 114913 111746 product 118436 M 0
0 114914 111747 product 118437 M 0
0 114915 111748 product 118438 M 0
0 114916 111749 product 118439 M 0
0 114917 111750 product 118440 M 0
0 114918 111751 product 118441 M 0
0 114920 111753 product 118443 M 0
0 114921 111754 product 118444 M 0
0 114922 111755 product 118445 M 0
0 114923 111756 product 118446 M 0
0 115007 111839 product 118530 M 0
0 115008 111840 product 118531 M 0
0 115009 111841 product 118532 M 0
0 115010 111842 product 118533 M 0
0 115317 112148 product 118840 M 0
0 115549 112382 product 119072 M 0