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 (
    92499, 92498, 92486, 91950, 91930, 91909, 
    1417, 92477, 91779, 91778, 91777, 91776, 
    91775, 91774, 91773, 91772, 91771, 
    91770, 91769, 91768
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 72245 1417 product 75768 M 0
0 94615 91768 product 98138 M 0
0 94616 91769 product 98139 M 0
0 94617 91770 product 98140 M 0
0 94618 91771 product 98141 M 0
0 94619 91772 product 98142 M 0
0 94620 91773 product 98143 M 0
0 94621 91774 product 98144 M 0
0 94622 91775 product 98145 M 0
0 94623 91776 product 98146 M 0
0 94624 91777 product 98147 M 0
0 94625 91778 product 98148 M 0
0 94626 91779 product 98149 M 0
0 94756 91909 product 98279 M 0
0 94777 91930 product 98300 M 0
0 94797 91950 product 98320 M 0
0 95334 92477 product 98857 M 0
0 95344 92486 product 98867 M 0
0 95356 92498 product 98879 M 0
0 95357 92499 product 98880 M 0