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 (
    122285, 122284, 122283, 122282, 109540, 
    109539, 109538, 109537, 109536, 109535, 
    109534, 109533, 109532, 109531, 109530, 
    109529, 109528, 109270, 109808, 109735
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00073

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 5054286852148.jpg 1400 1400 112423 109270 product 115946 M 0 115946
0 5054286907527_m1ic-ov.jpg 1400 1400 112683 109528 product 116206 M 0 116206
0 5054286907527_mhaa-51.jpg 1400 1400 112684 109529 product 116207 M 0 116207
0 5054286907527_ik1g-5g.jpg 1400 1400 112685 109530 product 116208 M 0 116208
0 5054286907527_ubru-qy.jpg 1400 1400 112686 109531 product 116209 M 0 116209
0 5054286907527_vvil-er.jpg 1400 1400 112687 109532 product 116210 M 0 116210
0 5054286907527_2ti0-zb.jpg 1400 1400 112688 109533 product 116211 M 0 116211
0 5054286907527_u2dk-s5.jpg 1400 1400 112689 109534 product 116212 M 0 116212
0 5054286907527_kphu-g5.jpg 1400 1400 112690 109535 product 116213 M 0 116213
0 5054286907527_0u2c-ri.jpg 1400 1400 112691 109536 product 116214 M 0 116214
0 5054286907527_i8mu-ht.jpg 1400 1400 112692 109537 product 116215 M 0 116215
0 5054286907527_pccu-cs.jpg 1400 1400 112693 109538 product 116216 M 0 116216
0 5054286907527_u0sg-ol.jpg 1400 1400 112694 109539 product 116217 M 0 116217
0 5054286907527_9wsa-pm.jpg 1400 1400 112695 109540 product 116218 M 0 116218
0 5054286927976_5ks0-4p.jpg 1400 1400 112893 109735 product 116416 M 0 116416
0 5054286935261.jpg 1400 1400 112967 109808 product 116490 M 0 116490
0 5054288017941_pfuh-zp.jpg 1400 1400 125558 122282 product 129081 M 0 129081
0 5054288017941_55df-xe.jpg 1400 1400 125559 122283 product 129082 M 0 129082
0 5054288017941_vdcf-wb.jpg 1400 1400 125560 122284 product 129083 M 0 129083
0 5054288017941_lm97-5o.jpg 1400 1400 125561 122285 product 129084 M 0 129084