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 (
    109465, 109886, 109742, 109741, 109740, 
    109739, 109448, 109447, 109446, 109445, 
    109444, 109376, 122293, 122292, 122291, 
    122290, 122289, 122288, 122287, 122286
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00051

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 112531 109376 product 116054 M 0
0 112599 109444 product 116122 M 0
0 112600 109445 product 116123 M 0
0 112601 109446 product 116124 M 0
0 112602 109447 product 116125 M 0
0 112603 109448 product 116126 M 0
0 112620 109465 product 116143 M 0
0 112897 109739 product 116420 M 0
0 112898 109740 product 116421 M 0
0 112899 109741 product 116422 M 0
0 112900 109742 product 116423 M 0
0 113046 109886 product 116569 M 0
0 125562 122286 product 129085 M 0
0 125563 122287 product 129086 M 0
0 125564 122288 product 129087 M 0
0 125565 122289 product 129088 M 0
0 125566 122290 product 129089 M 0
0 125567 122291 product 129090 M 0
0 125568 122292 product 129091 M 0
0 125569 122293 product 129092 M 0