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 (
    101756, 101755, 101754, 101753, 101752, 
    101751, 101750, 101749, 101748, 101747, 
    101716, 101715, 101469, 101468, 101373, 
    101372, 101954, 101943, 101360, 101359
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00044

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 104442 101359 product 107965 M 0
0 104443 101360 product 107966 M 0
0 104455 101372 product 107978 M 0
0 104456 101373 product 107979 M 0
0 104552 101468 product 108075 M 0
0 104553 101469 product 108076 M 0
0 104806 101715 product 108329 M 0
0 104807 101716 product 108330 M 0
0 104837 101747 product 108360 M 0
0 104838 101748 product 108361 M 0
0 104839 101749 product 108362 M 0
0 104840 101750 product 108363 M 0
0 104841 101751 product 108364 M 0
0 104842 101752 product 108365 M 0
0 104843 101753 product 108366 M 0
0 104844 101754 product 108367 M 0
0 104845 101755 product 108368 M 0
0 104846 101756 product 108369 M 0
0 105030 101943 product 108553 M 0
0 105041 101954 product 108564 M 0