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 (
    109666, 109665, 109664, 109663, 109662, 
    109661, 109660, 109659, 109658, 109657, 
    110313, 110312, 110311, 110304, 110303, 
    110302, 110301, 110300, 110299, 110298
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 5054286899082.jpg 1400 1400 112814 109657 product 116337 M 0 116337
0 5054286899082_wsx3-7z.jpg 1400 1400 112815 109658 product 116338 M 0 116338
0 5054286899082_yp0a-ku.jpg 1400 1400 112816 109659 product 116339 M 0 116339
0 5054286899082_9sx2-bu.jpg 1400 1400 112817 109660 product 116340 M 0 116340
0 5054286899082_wa9x-0d.jpg 1400 1400 112818 109661 product 116341 M 0 116341
0 5054286899082_9533-bq.jpg 1400 1400 112819 109662 product 116342 M 0 116342
0 5054286899082_1c6b-ro.jpg 1400 1400 112820 109663 product 116343 M 0 116343
0 5054286899082_sgtu-6p.jpg 1400 1400 112821 109664 product 116344 M 0 116344
0 5054286899082_mse5-5n.jpg 1400 1400 112822 109665 product 116345 M 0 116345
0 5054286899082_bn4f-s5.jpg 1400 1400 112823 109666 product 116346 M 0 116346
0 5054286974512_caig-n2.jpg 1400 1400 113459 110298 product 116982 M 0 116982
0 5054286974512_zu3j-dw.jpg 1400 1400 113460 110299 product 116983 M 0 116983
0 5054286974512_0lg4-lj.jpg 1400 1400 113461 110300 product 116984 M 0 116984
0 5054286974512_0gfm-7s.jpg 1400 1400 113462 110301 product 116985 M 0 116985
0 5054286974512_i42r-40.jpg 1400 1400 113463 110302 product 116986 M 0 116986
0 5054286974512_teq3-lf.jpg 1400 1400 113464 110303 product 116987 M 0 116987
0 5054286974512_i8z4-tq.jpg 1400 1400 113465 110304 product 116988 M 0 116988
0 5054286966159.jpg 1400 1400 113472 110311 product 116995 M 0 116995
0 5054286966159_m0z0-q0.jpg 1400 1400 113473 110312 product 116996 M 0 116996
0 5054286966159_5jnw-wr.jpg 1400 1400 113474 110313 product 116997 M 0 116997