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 (
    92910, 92680, 94278, 94277, 94276, 94207, 
    94191, 94140, 93939, 93932, 93760, 
    93525, 93451, 93346, 94187, 94185, 
    94184, 94183, 93378, 94141
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00058

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 95538 92680 product 99061 M 0
0 95774 92910 product 99297 M 0
0 96217 93346 product 99740 M 0
0 96249 93378 product 99772 M 0
0 96322 93451 product 99845 M 0
0 96400 93525 product 99923 M 0
0 96636 93760 product 100159 M 0
0 96810 93932 product 100333 M 0
0 97019 94140 product 100542 M 0
0 97020 94141 product 100543 M 0
0 97062 94183 product 100585 M 0
0 97063 94184 product 100586 M 0
0 97064 94185 product 100587 M 0
0 97066 94187 product 100589 M 0
0 97070 94191 product 100593 M 0
0 97091 94207 product 100614 M 0
0 97156 94276 product 100679 M 0
0 97157 93939 product 100680 M 0
0 97158 94278 product 100681 M 0
0 97171 94277 product 100694 M 0