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 (
    106206, 106040, 105969, 105968, 105777, 
    105776, 105766, 105765, 105721, 105720, 
    105719, 105718, 105717, 104776, 104722, 
    105613, 105612, 105611, 105488, 105487
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00063

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 5054286417538.jpg 1000 1000 107827 104722 product 111350 M 0 111350
0 5054286521112.jpg 1000 1000 107881 104776 product 111404 M 0 111404
0 5054286526735_p77z-5y.jpg 1000 1000 108617 105487 product 112140 M 0 112140
0 5054286526735_05et-tl.jpg 1000 1000 108618 105488 product 112141 M 0 112141
0 5054286549970.jpg 1000 1000 108745 105611 product 112268 M 0 112268
0 5054286549970_zgjw-1e.jpg 1000 1000 108746 105612 product 112269 M 0 112269
0 5054286549970_wrgx-n5.jpg 1000 1000 108747 105613 product 112270 M 0 112270
0 5054286555179.jpg 1000 1000 108851 105717 product 112374 M 0 112374
0 5054286555179_mlft-lf.jpg 1000 1000 108852 105718 product 112375 M 0 112375
0 5054286555179_60wg-6u.jpg 1000 1000 108853 105719 product 112376 M 0 112376
0 5054286555179_e8v5-9n.jpg 1000 1000 108854 105720 product 112377 M 0 112377
0 5054286555179_h96w-co.jpg 1000 1000 108855 105721 product 112378 M 0 112378
0 5054286554684.jpg 1000 1000 108899 105765 product 112422 M 0 112422
0 5054286554684_5x2s-el.jpg 1000 1000 108900 105766 product 112423 M 0 112423
0 5054286554523.jpg 1000 1000 108910 105776 product 112433 M 0 112433
0 5054286554523_1hx4-2k.jpg 1000 1000 108911 105777 product 112434 M 0 112434
0 5054286564461.jpg 1000 1000 109102 105968 product 112625 M 0 112625
0 5054286564461_9hzl-4p.jpg 1000 1000 109103 105969 product 112626 M 0 112626
0 5054286576952.jpg 1000 1000 109174 106040 product 112697 M 0 112697
0 5054286588771.jpg 1000 1000 109342 106206 product 112865 M 0 112865