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 (
    105602, 105601, 106552, 106551, 105974, 
    105973, 105972, 105971, 105595, 105543, 
    106354, 106322, 106192, 106191, 106190, 
    106189, 106188, 106187, 105542, 105505
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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 108635 105505 product 112158 M 0
0 108676 105542 product 112199 M 0
0 108677 105543 product 112200 M 0
0 108729 105595 product 112252 M 0
0 108735 105601 product 112258 M 0
0 108736 105602 product 112259 M 0
0 109105 105971 product 112628 M 0
0 109106 105972 product 112629 M 0
0 109107 105973 product 112630 M 0
0 109108 105974 product 112631 M 0
0 109323 106187 product 112846 M 0
0 109324 106188 product 112847 M 0
0 109325 106189 product 112848 M 0
0 109326 106190 product 112849 M 0
0 109327 106191 product 112850 M 0
0 109328 106192 product 112851 M 0
0 109458 106322 product 112981 M 0
0 109490 106354 product 113013 M 0
0 109688 106551 product 113211 M 0
0 109689 106552 product 113212 M 0