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 (
    112148, 111842, 111841, 111840, 111839, 
    112382, 111756, 111755, 111754, 111753, 
    111751, 111750, 111749, 111748, 111747, 
    111746, 111745, 111744, 111743, 111742
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 5054286999362_zqjv-yn.jpg 1400 1400 114909 111742 product 118432 M 0 118432
0 5054286999362_b1jq-iw.jpg 1400 1400 114910 111743 product 118433 M 0 118433
0 5054286999362_qbz1-08.jpg 1400 1400 114911 111744 product 118434 M 0 118434
0 5054286999362_ap3e-gu.jpg 1400 1400 114912 111745 product 118435 M 0 118435
0 5054286999362_ldxe-gm.jpg 1400 1400 114913 111746 product 118436 M 0 118436
0 5054286999362_o9mp-vp.jpg 1400 1400 114914 111747 product 118437 M 0 118437
0 5054286999362_nyz6-pn.jpg 1400 1400 114915 111748 product 118438 M 0 118438
0 5054286999362_bqi9-vn.jpg 1400 1400 114916 111749 product 118439 M 0 118439
0 5054286999362_fic5-xx.jpg 1400 1400 114917 111750 product 118440 M 0 118440
0 5054286999362_4qbx-vm.jpg 1400 1400 114918 111751 product 118441 M 0 118441
0 5054286999362_6s4u-f1.jpg 1400 1400 114920 111753 product 118443 M 0 118443
0 5054286999362_ztqi-42.jpg 1400 1400 114921 111754 product 118444 M 0 118444
0 5054286999362_7zkq-yo.jpg 1400 1400 114922 111755 product 118445 M 0 118445
0 5054286999362_wzo9-iv.jpg 1400 1400 114923 111756 product 118446 M 0 118446
0 5054287037520.jpg 1400 1400 115007 111839 product 118530 M 0 118530
0 5054287037520_s1rw-uh.jpg 1400 1400 115008 111840 product 118531 M 0 118531
0 5054287037520_ord4-an.jpg 1400 1400 115009 111841 product 118532 M 0 118532
0 5054287037520_mjah-oi.jpg 1400 1400 115010 111842 product 118533 M 0 118533
0 5054287074242.jpg 1000 1000 115317 112148 product 118840 M 0 118840
0 5054287087648.jpg 1000 1000 115549 112382 product 119072 M 0 119072