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 (
    101823, 101822, 101821, 101820, 101819, 
    101818, 101817, 101816, 101815, 101814, 
    101813, 101714, 101713, 101643, 101642, 
    101641, 101640, 101639, 101218, 101217
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00052

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 5054286354079_7dsq-vf.jpg 1000 1000 104297 101217 product 107820 M 0 107820
0 5054286354079_h4r9-sh.jpg 1000 1000 104298 101218 product 107821 M 0 107821
0 5054286398509.jpg 1000 1000 104725 101639 product 108248 M 0 108248
0 5054286398509_hn1x-ii.jpg 1000 1000 104726 101640 product 108249 M 0 108249
0 5054286398509_394q-cx.jpg 1000 1000 104727 101641 product 108250 M 0 108250
0 5054286398509_den5-am.jpg 1000 1000 104728 101642 product 108251 M 0 108251
0 5054286399469.jpg 1000 1000 104729 101643 product 108252 M 0 108252
0 5054286414841.jpg 1000 1000 104804 101713 product 108327 M 0 108327
0 5054286414841_cl94-ms.jpg 1000 1000 104805 101714 product 108328 M 0 108328
0 5054286412540.jpg 1000 1000 104903 101813 product 108426 M 0 108426
0 5054286412540_doz9-xf.jpg 1000 1000 104904 101814 product 108427 M 0 108427
0 5054286412540_ttq1-f2.jpg 1000 1000 104905 101815 product 108428 M 0 108428
0 5054286412540_xtss-xr.jpg 1000 1000 104906 101816 product 108429 M 0 108429
0 5054286412540_nvu3-rx.jpg 1000 1000 104907 101817 product 108430 M 0 108430
0 5054286412540_wkrw-r2.jpg 1000 1000 104908 101818 product 108431 M 0 108431
0 5054286412540_alex-d8.jpg 1000 1000 104909 101819 product 108432 M 0 108432
0 5054286412540_dvfn-w3.jpg 1000 1000 104910 101820 product 108433 M 0 108433
0 5054286412540_a9w4-z2.jpg 1000 1000 104911 101821 product 108434 M 0 108434
0 5054286412540_ekxu-zf.jpg 1000 1000 104912 101822 product 108435 M 0 108435
0 5054286412540_lhy7-hx.jpg 1000 1000 104913 101823 product 108436 M 0 108436