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 (
    106113, 106112, 106111, 106110, 106109, 
    106108, 106107, 106106, 106105, 106104, 
    106103, 106102, 106100, 106043, 106042, 
    106041, 106511, 106510, 106509, 106029
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00058

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 5054286547198.jpg 1000 1000 109163 106029 product 112686 M 0 112686
0 5054286543367.jpg 1000 1000 109175 106041 product 112698 M 0 112698
0 5054286543367_hll3-z1.jpg 1000 1000 109176 106042 product 112699 M 0 112699
0 5054286543367_ktva-ay.jpg 1000 1000 109177 106043 product 112700 M 0 112700
0 5054286552239.jpg 1000 1000 109236 106100 product 112759 M 0 112759
0 5054286570981.jpg 1000 1000 109238 106102 product 112761 M 0 112761
0 5054286570981_2178-s4.jpg 1000 1000 109239 106103 product 112762 M 0 112762
0 5054286570981_u8da-a4.jpg 1000 1000 109240 106104 product 112763 M 0 112763
0 5054286570981_ftz2-l1.jpg 1000 1000 109241 106105 product 112764 M 0 112764
0 5054286570981_8o0i-g0.jpg 1000 1000 109242 106106 product 112765 M 0 112765
0 5054286570981_i1d8-0r.jpg 1000 1000 109243 106107 product 112766 M 0 112766
0 5054286570981_8vpp-ku.jpg 1000 1000 109244 106108 product 112767 M 0 112767
0 5054286570981_kdx5-9m.jpg 1000 1000 109245 106109 product 112768 M 0 112768
0 5054286570981_zspn-0t.jpg 1000 1000 109246 106110 product 112769 M 0 112769
0 5054286570981_8lj7-x7.jpg 1000 1000 109247 106111 product 112770 M 0 112770
0 5054286570981_gz61-cq.jpg 1000 1000 109248 106112 product 112771 M 0 112771
0 5054286570981_3wvp-mb.jpg 1000 1000 109249 106113 product 112772 M 0 112772
0 5054286626305.jpg 1000 1000 109645 106509 product 113168 M 0 113168
0 5054286626305_bhup-mn.jpg 1000 1000 109646 106510 product 113169 M 0 113169
0 5054286626305_hawm-64.jpg 1000 1000 109647 106511 product 113170 M 0 113170