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 (
    104503, 104502, 104566, 104565, 104564, 
    104563, 105544, 104462, 105512, 105462, 
    105461, 105460, 104547, 105405, 105404, 
    105403, 105402, 105401, 105400, 105399
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00040

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 107562 104462 product 111085 M 0
0 107603 104502 product 111126 M 0
0 107604 104503 product 111127 M 0
0 107649 104547 product 111172 M 0
0 107664 104563 product 111187 M 0
0 107665 104564 product 111188 M 0
0 107666 104565 product 111189 M 0
0 107667 104566 product 111190 M 0
0 108529 105399 product 112052 M 0
0 108530 105400 product 112053 M 0
0 108531 105401 product 112054 M 0
0 108532 105402 product 112055 M 0
0 108533 105403 product 112056 M 0
0 108534 105404 product 112057 M 0
0 108535 105405 product 112058 M 0
0 108590 105460 product 112113 M 0
0 108591 105461 product 112114 M 0
0 108592 105462 product 112115 M 0
0 108642 105512 product 112165 M 0
0 108678 105544 product 112201 M 0