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 (
    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.00059

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 5054286460602.jpg 1000 1000 107562 104462 product 111085 M 0 111085
0 5054286489276.jpg 1000 1000 107603 104502 product 111126 M 0 111126
0 5054286489276_azvf-o3.jpg 1000 1000 107604 104503 product 111127 M 0 111127
0 5054286500933.jpg 1000 1000 107649 104547 product 111172 M 0 111172
0 5054286488941.jpg 1000 1000 107664 104563 product 111187 M 0 111187
0 5054286488941_w4ch-25.jpg 1000 1000 107665 104564 product 111188 M 0 111188
0 5054286488941_ub5e-gg.jpg 1000 1000 107666 104565 product 111189 M 0 111189
0 5054286488941_b9o8-ld.jpg 1000 1000 107667 104566 product 111190 M 0 111190
0 5028386719533_bng4-y3.jpg 1000 1000 108529 105399 product 112052 M 0 112052
0 5028386719533_hyzd-s5.jpg 1000 1000 108530 105400 product 112053 M 0 112053
0 5028386719533_ry3y-eo.jpg 1000 1000 108531 105401 product 112054 M 0 112054
0 5028386719533_spy8-rb.jpg 1000 1000 108532 105402 product 112055 M 0 112055
0 5028386719533_b2cg-sa.jpg 1000 1000 108533 105403 product 112056 M 0 112056
0 5028386719533_e824-6n.jpg 1000 1000 108534 105404 product 112057 M 0 112057
0 5028386719533_6w1n-q3.jpg 1000 1000 108535 105405 product 112058 M 0 112058
0 5054286537496.jpg 1000 1000 108590 105460 product 112113 M 0 112113
0 5054286537496_errt-h4.jpg 1000 1000 108591 105461 product 112114 M 0 112114
0 5054286537496_vdzg-4c.jpg 1000 1000 108592 105462 product 112115 M 0 112115
0 5054286541400.jpg 1000 1000 108642 105512 product 112165 M 0 112165
0 5054286546917.jpg 1000 1000 108678 105544 product 112201 M 0 112201