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 (
    96060, 95699, 95231, 93055, 89231, 96061, 
    95337, 92918, 96004, 96003, 96002, 
    95999, 95972, 95837, 95802, 95740, 
    95700, 95697, 95062, 95040
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

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 95782 92918 product 99305 M 0
0 95922 93055 product 99445 M 0
0 97932 95040 product 101455 M 0
0 97954 95062 product 101477 M 0
0 98127 95231 product 101650 M 0
0 98233 95337 product 101756 M 0
0 98619 95697 product 102142 M 0
0 98621 95699 product 102144 M 0
0 98622 95700 product 102145 M 0
0 98663 95740 product 102186 M 0
0 98726 95802 product 102249 M 0
0 98761 95837 product 102284 M 0
0 98851 89231 product 102374 M 0
0 98945 95972 product 102468 M 0
0 98972 95999 product 102495 M 0
0 98975 96002 product 102498 M 0
0 98977 96003 product 102500 M 0
0 98978 96004 product 102501 M 0
0 99034 96060 product 102557 M 0
0 99060 96061 product 102583 M 0