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 (
    104248, 104288, 104287, 102289, 102288, 
    102287, 102286, 102285, 102284, 102283, 
    102282, 102278, 104481, 104480, 104479, 
    104478, 104477, 104476, 104475, 104474
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00140

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 5054286425670.jpg 1000 1000 105374 102278 product 108897 M 0 108897
0 5054286415039.jpg 1000 1000 105378 102282 product 108901 M 0 108901
0 5054286415039_lyuv-kw.jpg 1000 1000 105379 102283 product 108902 M 0 108902
0 5054286415039_5si7-ln.jpg 1000 1000 105380 102284 product 108903 M 0 108903
0 5054286415039_f22p-nt.jpg 1000 1000 105381 102285 product 108904 M 0 108904
0 5054286415039_tfdl-h8.jpg 1000 1000 105382 102286 product 108905 M 0 108905
0 5054286415039_ym67-dj.jpg 1000 1000 105383 102287 product 108906 M 0 108906
0 5054286415039_cpyb-jw.jpg 1000 1000 105384 102288 product 108907 M 0 108907
0 5054286415039_bn23-sb.jpg 1000 1000 105385 102289 product 108908 M 0 108908
0 5054286443735.jpg 1000 1000 107344 104248 product 110867 M 0 110867
0 5054286484127.jpg 1000 1000 107385 104287 product 110908 M 0 110908
0 5054286484127_oxpo-9v.jpg 1000 1000 107386 104288 product 110909 M 0 110909
0 5054286489047_ozvi-sa.jpg 1000 1000 107574 104474 product 111097 M 0 111097
0 5054286489047_jrag-ku.jpg 1000 1000 107575 104475 product 111098 M 0 111098
0 5054286489047_4w4y-ly.jpg 1000 1000 107576 104476 product 111099 M 0 111099
0 5054286489047_mgh4-3c.jpg 1000 1000 107577 104477 product 111100 M 0 111100
0 5054286489047_rmvz-xx.jpg 1000 1000 107578 104478 product 111101 M 0 111101
0 5054286489047_jcrg-vz.jpg 1000 1000 107579 104479 product 111102 M 0 111102
0 5054286489047_dwh7-ew.jpg 1000 1000 107580 104480 product 111103 M 0 111103
0 5054286489047_m62d-dm.jpg 1000 1000 107581 104481 product 111104 M 0 111104