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 (
    92732, 92731, 92730, 92729, 92728, 92726, 
    92725, 92723, 92721, 92720, 92719, 
    92718, 92717, 92716, 92715, 92713, 
    92712, 92711, 92710, 92709
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00049

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 95567 92709 product 99090 M 0
0 95568 92710 product 99091 M 0
0 95569 92711 product 99092 M 0
0 95570 92712 product 99093 M 0
0 95571 92713 product 99094 M 0
0 95573 92715 product 99096 M 0
0 95574 92716 product 99097 M 0
0 95575 92717 product 99098 M 0
0 95576 92718 product 99099 M 0
0 95577 92719 product 99100 M 0
0 95578 92720 product 99101 M 0
0 95579 92721 product 99102 M 0
0 95581 92723 product 99104 M 0
0 95583 92725 product 99106 M 0
0 95584 92726 product 99107 M 0
0 95586 92728 product 99109 M 0
0 95587 92729 product 99110 M 0
0 95588 92730 product 99111 M 0
0 95589 92731 product 99112 M 0
0 95590 92732 product 99113 M 0