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 (
    69618, 69616, 69615, 69459, 69449, 69401, 
    69350, 69507, 69506, 69505, 69503, 
    69447, 69410, 68998, 68698, 67810, 
    67809, 67808, 67807, 67806, 67805, 
    67804, 67803, 67802, 67801, 67800, 
    67799, 67798, 67797, 67796, 67795, 
    67794, 67793, 67792, 67791, 69107, 
    69432, 69348, 69005, 68836
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00080

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 40 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 70057 67791 product 73580 M 0
0 70058 67792 product 73581 M 0
0 70059 67793 product 73582 M 0
0 70060 67794 product 73583 M 0
0 70061 67795 product 73584 M 0
0 70062 67796 product 73585 M 0
0 70063 67797 product 73586 M 0
0 70064 67798 product 73587 M 0
0 70065 67799 product 73588 M 0
0 70066 67800 product 73589 M 0
0 70067 67801 product 73590 M 0
0 70068 67802 product 73591 M 0
0 70069 67803 product 73592 M 0
0 70070 67804 product 73593 M 0
0 70071 67805 product 73594 M 0
0 70072 67806 product 73595 M 0
0 70073 67807 product 73596 M 0
0 70074 67808 product 73597 M 0
0 70075 67809 product 73598 M 0
0 70076 67810 product 73599 M 0
0 70967 68698 product 74490 M 0
0 71106 68836 product 74629 M 0
0 71268 68998 product 74791 M 0
0 71276 69005 product 74799 M 0
0 71378 69107 product 74901 M 0
0 71622 69348 product 75145 M 0
0 71624 69350 product 75147 M 0
0 71675 69401 product 75198 M 0
0 71707 69432 product 75230 M 0
0 71722 69447 product 75245 M 0
0 71724 69449 product 75247 M 0
0 71734 69459 product 75257 M 0
0 71778 69503 product 75301 M 0
0 71780 69505 product 75303 M 0
0 71781 69506 product 75304 M 0
0 71782 69507 product 75305 M 0
0 71824 69410 product 75347 M 0
0 71891 69615 product 75414 M 0
0 71892 69616 product 75415 M 0
0 71895 69618 product 75418 M 0