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 (
    105398, 105397, 105396, 105395, 105394, 
    105393, 105392, 105391, 104328, 104286, 
    104277, 104276, 104275, 104273, 104272, 
    104271, 104270, 104251, 104250, 104249
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00036

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 107345 104249 product 110868 M 0
0 107346 104250 product 110869 M 0
0 107347 104251 product 110870 M 0
0 107368 104270 product 110891 M 0
0 107369 104271 product 110892 M 0
0 107370 104272 product 110893 M 0
0 107371 104273 product 110894 M 0
0 107373 104275 product 110896 M 0
0 107374 104276 product 110897 M 0
0 107375 104277 product 110898 M 0
0 107384 104286 product 110907 M 0
0 107426 104328 product 110949 M 0
0 108521 105391 product 112044 M 0
0 108522 105392 product 112045 M 0
0 108523 105393 product 112046 M 0
0 108524 105394 product 112047 M 0
0 108525 105395 product 112048 M 0
0 108526 105396 product 112049 M 0
0 108527 105397 product 112050 M 0
0 108528 105398 product 112051 M 0