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 (
    95818, 95817, 95816, 95815, 95814, 95813, 
    95812, 95811, 95810, 95809, 95808, 
    95807, 95806, 95805, 95804, 95803, 
    95874, 95867, 95638, 95637
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00067

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 98559 95637 product 102082 M 0
0 98560 95638 product 102083 M 0
0 98727 95803 product 102250 M 0
0 98728 95804 product 102251 M 0
0 98729 95805 product 102252 M 0
0 98730 95806 product 102253 M 0
0 98731 95807 product 102254 M 0
0 98732 95808 product 102255 M 0
0 98733 95809 product 102256 M 0
0 98734 95810 product 102257 M 0
0 98735 95811 product 102258 M 0
0 98736 95812 product 102259 M 0
0 98737 95813 product 102260 M 0
0 98738 95814 product 102261 M 0
0 98739 95815 product 102262 M 0
0 98740 95816 product 102263 M 0
0 98741 95817 product 102264 M 0
0 98742 95818 product 102265 M 0
0 98791 95867 product 102314 M 0
0 98805 95874 product 102328 M 0