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 (
    104382, 104381, 104380, 104379, 102165, 
    102164, 102163, 102162, 102161, 102160, 
    102159, 102158, 102157, 102156, 102155, 
    102154, 102150, 104598, 102142, 102141
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00057

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 5054286442714_sou2-pl.jpg 1000 1000 105235 102141 product 108758 M 0 108758
0 5054286431183.jpg 1000 1000 105236 102142 product 108759 M 0 108759
0 5054286449300.jpg 1000 1000 105244 102150 product 108767 M 0 108767
0 5054286415015.jpg 1000 1000 105248 102154 product 108771 M 0 108771
0 5054286415015_mux7-sz.jpg 1000 1000 105249 102155 product 108772 M 0 108772
0 5054286415015_ty47-4v.jpg 1000 1000 105250 102156 product 108773 M 0 108773
0 5054286415015_7qtp-fv.jpg 1000 1000 105251 102157 product 108774 M 0 108774
0 5054286415015_y18e-fq.jpg 1000 1000 105252 102158 product 108775 M 0 108775
0 5054286415015_gmiv-9w.jpg 1000 1000 105253 102159 product 108776 M 0 108776
0 5054286415015_5rz1-54.jpg 1000 1000 105254 102160 product 108777 M 0 108777
0 5054286415015_06ny-c9.jpg 1000 1000 105255 102161 product 108778 M 0 108778
0 5054286415312.jpg 1000 1000 105256 102162 product 108779 M 0 108779
0 5054286415312_tsgi-sd.jpg 1000 1000 105257 102163 product 108780 M 0 108780
0 5054286441694.jpg 1000 1000 105258 102164 product 108781 M 0 108781
0 5054286441694_ek1j-1d.jpg 1000 1000 105259 102165 product 108782 M 0 108782
0 5054286491613.jpg 1000 1000 107478 104379 product 111001 M 0 111001
0 5054286491613_q2bf-ft.jpg 1000 1000 107479 104380 product 111002 M 0 111002
0 5054286491613_w7ae-0d.jpg 1000 1000 107480 104381 product 111003 M 0 111003
0 5054286491613_g8fg-tl.jpg 1000 1000 107481 104382 product 111004 M 0 111004
0 5054286510130.jpg 1000 1000 107700 104598 product 111223 M 0 111223