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 (
    100759, 100758, 100757, 100756, 100755, 
    100727, 100648, 100647, 100645, 99651, 
    98893, 92945, 100368, 100629, 100176, 
    100627, 100625, 100624, 100623, 100596
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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 95809 92945 product 99332 M 0
0 101932 98893 product 105455 M 0
0 102697 99651 product 106220 M 0
0 103250 100176 product 106773 M 0
0 103445 100368 product 106968 M 0
0 103678 100596 product 107201 M 0
0 103705 100623 product 107228 M 0
0 103706 100624 product 107229 M 0
0 103707 100625 product 107230 M 0
0 103709 100627 product 107232 M 0
0 103711 100629 product 107234 M 0
0 103727 100645 product 107250 M 0
0 103785 100647 product 107308 M 0
0 103786 100648 product 107309 M 0
0 103811 100727 product 107334 M 0
0 103838 100755 product 107361 M 0
0 103839 100756 product 107362 M 0
0 103840 100757 product 107363 M 0
0 103841 100758 product 107364 M 0
0 103842 100759 product 107365 M 0