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.detailed_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.00097

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.detailed_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 5054286443735_9gkg-13.jpg 1000 1000 107345 104249 product 110868 M 0 110868
0 5054286443735_go9p-2f.jpg 1000 1000 107346 104250 product 110869 M 0 110869
0 5054286443735_pioi-9w.jpg 1000 1000 107347 104251 product 110870 M 0 110870
0 5054286451389.jpg 1000 1000 107368 104270 product 110891 M 0 110891
0 5054286451389_ve0u-vx.jpg 1000 1000 107369 104271 product 110892 M 0 110892
0 5054286451389_011a-gl.jpg 1000 1000 107370 104272 product 110893 M 0 110893
0 5054286451389_tx8x-js.jpg 1000 1000 107371 104273 product 110894 M 0 110894
0 5054286441151.jpg 1000 1000 107373 104275 product 110896 M 0 110896
0 5054286441151_jblz-rr.jpg 1000 1000 107374 104276 product 110897 M 0 110897
0 5054286460312.jpg 1000 1000 107375 104277 product 110898 M 0 110898
0 5054286344995.jpg 1000 1000 107384 104286 product 110907 M 0 110907
0 5054286431770.jpg 1000 1000 107426 104328 product 110949 M 0 110949
0 5028386719533.jpg 1000 1000 108521 105391 product 112044 M 0 112044
0 5028386719533_ni4l-2x.jpg 1000 1000 108522 105392 product 112045 M 0 112045
0 5028386719533_exit-40.jpg 1000 1000 108523 105393 product 112046 M 0 112046
0 5028386719533_3132-5k.jpg 1000 1000 108524 105394 product 112047 M 0 112047
0 5028386719533_g2gs-74.jpg 1000 1000 108525 105395 product 112048 M 0 112048
0 5028386719533_4bj7-gz.jpg 1000 1000 108526 105396 product 112049 M 0 112049
0 5028386719533_gt9a-8l.jpg 1000 1000 108527 105397 product 112050 M 0 112050
0 5028386719533_8tis-16.jpg 1000 1000 108528 105398 product 112051 M 0 112051