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 (
    108922, 97567, 98182, 108918, 97536, 
    97674, 97673, 97551, 97508, 109006, 
    97467, 97466, 97711, 97710, 97700, 
    97699, 97289, 97287, 97279, 97531
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 5054285917718.jpg 1000 1000 100286 97279 product 103809 M 0 103809
0 5054286000655.jpg 1000 1000 100294 97287 product 103817 M 0 103817
0 5054286005308.jpg 1000 1000 100296 97289 product 103819 M 0 103819
0 5054285979679.jpg 1000 1000 100475 97466 product 103998 M 0 103998
0 5054285979679_nqhs-xh.jpg 1000 1000 100476 97467 product 103999 M 0 103999
0 5054286008088.jpg 1000 1000 100517 97508 product 104040 M 0 104040
0 5054286024132.jpg 1000 1000 100542 97531 product 104065 M 0 104065
0 5054285925850.jpg 1000 1000 100547 97536 product 104070 M 0 104070
0 5054286028444.jpg 1000 1000 100562 97551 product 104085 M 0 104085
0 5054285939871.jpg 1000 1000 100577 97567 product 104100 M 0 104100
0 5054286039747.jpg 1000 1000 100682 97673 product 104205 M 0 104205
0 5054286039747_3q2e-u4.jpg 1000 1000 100683 97674 product 104206 M 0 104206
0 5054286029342.jpg 1000 1000 100716 97699 product 104239 M 0 104239
0 5054286029342_kycv-to.jpg 1000 1000 100717 97700 product 104240 M 0 104240
0 5054286046561.jpg 1000 1000 100727 97710 product 104250 M 0 104250
0 5054286046561_96lp-hi.jpg 1000 1000 100728 97711 product 104251 M 0 104251
0 5054286085690.jpg 1000 1000 101207 98182 product 104730 M 0 104730
0 9145563331329.jpg 1000 1000 112071 108918 product 115594 M 0 115594
0 9505791744436.jpg 1000 1000 112075 108922 product 115598 M 0 115598
0 9503918151730.jpg 1000 1000 112159 109006 product 115682 M 0 115682