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 (
    95010, 95009, 93344, 95875, 95866, 95836, 
    95164, 92917, 95835, 95801, 95800, 
    95852, 95744, 95743, 95742, 95741, 
    95701, 95547, 95538, 95302
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00057

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 95781 92917 product 99304 M 0
0 96214 93344 product 99737 M 0
0 97901 95009 product 101424 M 0
0 97902 95010 product 101425 M 0
0 98058 95164 product 101581 M 0
0 98198 95302 product 101721 M 0
0 98460 95538 product 101983 M 0
0 98469 95547 product 101992 M 0
0 98623 95701 product 102146 M 0
0 98664 95741 product 102187 M 0
0 98665 95742 product 102188 M 0
0 98666 95743 product 102189 M 0
0 98667 95744 product 102190 M 0
0 98724 95800 product 102247 M 0
0 98725 95801 product 102248 M 0
0 98759 95835 product 102282 M 0
0 98760 95836 product 102283 M 0
0 98776 95852 product 102299 M 0
0 98790 95866 product 102313 M 0
0 98844 95875 product 102367 M 0