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 (
    101756, 101755, 101754, 101753, 101752, 
    101751, 101750, 101749, 101748, 101747, 
    101716, 101715, 101469, 101468, 101373, 
    101372, 101954, 101943, 101360, 101359
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00096

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 5054286305439_mn9t-l8.jpg 1000 1000 104442 101359 product 107965 M 0 107965
0 5054286305439_jcur-hr.jpg 1000 1000 104443 101360 product 107966 M 0 107966
0 5054286350521.jpg 1000 1000 104455 101372 product 107978 M 0 107978
0 5054286350521_57a1-i5.jpg 1000 1000 104456 101373 product 107979 M 0 107979
0 5054286380696.jpg 1000 1000 104552 101468 product 108075 M 0 108075
0 5054286380696_l3t1-ju.jpg 1000 1000 104553 101469 product 108076 M 0 108076
0 5054286415336.jpg 1000 1000 104806 101715 product 108329 M 0 108329
0 5054286415336_6xdn-eg.jpg 1000 1000 104807 101716 product 108330 M 0 108330
0 5054286414636.jpg 1000 1000 104837 101747 product 108360 M 0 108360
0 5054286414636_nro6-oa.jpg 1000 1000 104838 101748 product 108361 M 0 108361
0 5054286414636_gtlb-5q.jpg 1000 1000 104839 101749 product 108362 M 0 108362
0 5054286414636_hma3-zg.jpg 1000 1000 104840 101750 product 108363 M 0 108363
0 5054286414636_bzm1-ix.jpg 1000 1000 104841 101751 product 108364 M 0 108364
0 5054286414636_729n-jv.jpg 1000 1000 104842 101752 product 108365 M 0 108365
0 5054286414636_rtiv-md.jpg 1000 1000 104843 101753 product 108366 M 0 108366
0 5054286414636_qdag-98.jpg 1000 1000 104844 101754 product 108367 M 0 108367
0 5054286414636_04ud-ms.jpg 1000 1000 104845 101755 product 108368 M 0 108368
0 5054286414636_e40h-99.jpg 1000 1000 104846 101756 product 108369 M 0 108369
0 5054286426554.jpg 1000 1000 105030 101943 product 108553 M 0 108553
0 5054286429630.jpg 1000 1000 105041 101954 product 108564 M 0 108564