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 (
    108078, 108077, 108058, 108056, 108417, 
    108060, 108850, 108963, 108962, 108386, 
    108063, 107976, 108380, 108171, 108128, 
    107947, 108896, 108895, 112381, 108982
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00065

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 5054286738824.jpg 1000 1000 111092 107947 product 114615 M 0 114615
0 5054286757306.jpg 1000 1000 111121 107976 product 114644 M 0 114644
0 5054286782957_9qe5-s8.jpg 1400 1400 111201 108056 product 114724 M 0 114724
0 5054286782957_yfg8-n8.jpg 1400 1400 111203 108058 product 114726 M 0 114726
0 5054286782285.jpg 1400 1400 111205 108060 product 114728 M 0 114728
0 5054286782995.jpg 1400 1400 111208 108063 product 114731 M 0 114731
0 5054286746485.jpg 1000 1000 111222 108077 product 114745 M 0 114745
0 5054286778615.jpg 1400 1400 111223 108078 product 114746 M 0 114746
0 5054286785927.jpg 1400 1400 111273 108128 product 114796 M 0 114796
0 5054286794745.jpg 1400 1400 111318 108171 product 114841 M 0 114841
0 5054286813286.jpg 1400 1400 111530 108380 product 115053 M 0 115053
0 5054286811497.jpg 1400 1400 111536 108386 product 115059 M 0 115059
0 5054286818069.jpg 1400 1400 111567 108417 product 115090 M 0 115090
0 5054286798804.jpg 1400 1400 112003 108850 product 115526 M 0 115526
0 5054286740933.jpg 1000 1000 112048 108895 product 115571 M 0 115571
0 5054286740933_2yip-22.jpg 1000 1000 112049 108896 product 115572 M 0 115572
0 5054286766360.jpg 1000 1000 112115 108962 product 115638 M 0 115638
0 5054286766360_p57i-zf.jpg 1000 1000 112116 108963 product 115639 M 0 115639
0 5054286740926.jpg 1000 1000 112135 108982 product 115658 M 0 115658
0 5054287088027.jpg 1000 1000 115548 112381 product 119071 M 0 119071