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 (
    111794, 111793, 109129, 109032, 109031, 
    109011, 108892, 108891, 108790, 108632, 
    108618, 109040, 108675, 108674, 108610, 
    108901, 108900, 108884, 108883, 108554
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00047

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 5054286798132.jpg 1400 1400 111705 108554 product 115228 M 0 115228
0 5054286821229.jpg 1400 1400 111763 108610 product 115286 M 0 115286
0 5054286823315.jpg 1400 1400 111771 108618 product 115294 M 0 115294
0 5054286834731.jpg 1400 1400 111785 108632 product 115308 M 0 115308
0 5054286840947.jpg 1400 1400 111827 108674 product 115350 M 0 115350
0 5054286837503.jpg 1400 1400 111828 108675 product 115351 M 0 115351
0 5054286864165.jpg 1400 1400 111943 108790 product 115466 M 0 115466
0 5054286840855.jpg 1400 1400 112036 108883 product 115559 M 0 115559
0 5054286840855_upzu-7s.jpg 1400 1400 112037 108884 product 115560 M 0 115560
0 5054286840862.jpg 1400 1400 112044 108891 product 115567 M 0 115567
0 5054286840862_3aet-om.jpg 1400 1400 112045 108892 product 115568 M 0 115568
0 5054286844440.jpg 1400 1400 112053 108900 product 115576 M 0 115576
0 5054286844440_fel6-09.jpg 1400 1400 112054 108901 product 115577 M 0 115577
0 5054286844457.jpg 1400 1400 112164 109011 product 115687 M 0 115687
0 5054286873099.jpg 1400 1400 112184 109031 product 115707 M 0 115707
0 5054286873099_kooa-k5.jpg 1400 1400 112185 109032 product 115708 M 0 115708
0 5054286873082.jpg 1400 1400 112193 109040 product 115716 M 0 115716
0 5054286883203.jpg 1400 1400 112282 109129 product 115805 M 0 115805
0 5054286810261.jpg 1400 1400 114961 111793 product 118484 M 0 118484
0 5054286810261_pw1p-pm.jpg 1400 1400 114962 111794 product 118485 M 0 118485