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 (
    101928, 101927, 101378, 101369, 101367, 
    101366, 101364, 106117, 101222, 101219, 
    101209, 101208, 105999, 101808, 101807, 
    101806, 101805, 101804, 101803, 101802
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00095

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 5054286326533.jpg 1000 1000 104288 101208 product 107811 M 0 107811
0 5054286326533_l1jj-sp.jpg 1000 1000 104289 101209 product 107812 M 0 107812
0 5054286178996.jpg 1000 1000 104299 101219 product 107822 M 0 107822
0 5054286178996_bvt2-wg.jpg 1000 1000 104302 101222 product 107825 M 0 107825
0 5054286353904.jpg 1000 1000 104447 101364 product 107970 M 0 107970
0 5054286096672_kyu0-cn.jpg 1000 1000 104449 101366 product 107972 M 0 107972
0 5054286096672_2hjg-tc.jpg 1000 1000 104450 101367 product 107973 M 0 107973
0 5054286365440.jpg 1000 1000 104452 101369 product 107975 M 0 107975
0 5054286356769.jpg 1000 1000 104461 101378 product 107984 M 0 107984
0 5054286410348_hj7j-r0.jpg 1000 1000 104892 101802 product 108415 M 0 108415
0 5054286410348_wcsn-nc.jpg 1000 1000 104893 101803 product 108416 M 0 108416
0 5054286410348_lwsc-2c.jpg 1000 1000 104894 101804 product 108417 M 0 108417
0 5054286410348_5gc9-nw.jpg 1000 1000 104895 101805 product 108418 M 0 108418
0 5054286410348_9ct0-5j.jpg 1000 1000 104896 101806 product 108419 M 0 108419
0 5054286410348_txyg-fo.jpg 1000 1000 104897 101807 product 108420 M 0 108420
0 5054286410348_gkge-6g.jpg 1000 1000 104898 101808 product 108421 M 0 108421
0 5054286427629.jpg 1000 1000 105014 101927 product 108537 M 0 108537
0 5054286427629_v84f-fy.jpg 1000 1000 105015 101928 product 108538 M 0 108538
0 5054286559689.jpg 1000 1000 109133 105999 product 112656 M 0 112656
0 5054286523550.jpg 1000 1000 109253 106117 product 112776 M 0 112776