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 (
    109734, 109733, 109732, 109731, 109730, 
    109729, 109728, 109727, 109726, 109725, 
    109724, 109723, 109722, 109721, 109720, 
    109719, 109718, 109717, 109716, 109674
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00060

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 5054286887577_r3l9-z5.jpg 1400 1400 112831 109674 product 116354 M 0 116354
0 5054286927976.jpg 1400 1400 112874 109716 product 116397 M 0 116397
0 5054286927976_32o4-fs.jpg 1400 1400 112875 109717 product 116398 M 0 116398
0 5054286927976_wg53-fw.jpg 1400 1400 112876 109718 product 116399 M 0 116399
0 5054286927976_tt67-rd.jpg 1400 1400 112877 109719 product 116400 M 0 116400
0 5054286927976_b9ga-6a.jpg 1400 1400 112878 109720 product 116401 M 0 116401
0 5054286927976_rayd-mg.jpg 1400 1400 112879 109721 product 116402 M 0 116402
0 5054286927976_gvp2-q2.jpg 1400 1400 112880 109722 product 116403 M 0 116403
0 5054286927976_tk7k-mk.jpg 1400 1400 112881 109723 product 116404 M 0 116404
0 5054286927976_9b33-qv.jpg 1400 1400 112882 109724 product 116405 M 0 116405
0 5054286927976_jgap-6u.jpg 1400 1400 112883 109725 product 116406 M 0 116406
0 5054286927976_iqc4-bs.jpg 1400 1400 112884 109726 product 116407 M 0 116407
0 5054286927976_64cb-lf.jpg 1400 1400 112885 109727 product 116408 M 0 116408
0 5054286927976_6jqu-qq.jpg 1400 1400 112886 109728 product 116409 M 0 116409
0 5054286927976_fw8l-u7.jpg 1400 1400 112887 109729 product 116410 M 0 116410
0 5054286927976_wnyw-ce.jpg 1400 1400 112888 109730 product 116411 M 0 116411
0 5054286927976_h6o1-qu.jpg 1400 1400 112889 109731 product 116412 M 0 116412
0 5054286927976_sywl-xz.jpg 1400 1400 112890 109732 product 116413 M 0 116413
0 5054286927976_4nxk-m8.jpg 1400 1400 112891 109733 product 116414 M 0 116414
0 5054286927976_qoqp-2m.jpg 1400 1400 112892 109734 product 116415 M 0 116415