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 (
    112062, 112061, 112060, 112059, 112058, 
    112057, 112056, 112055, 112054, 112052, 
    112051, 112435, 112434, 112290, 112289, 
    112536, 112535, 112534, 112533, 112532
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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 5054287026531.jpg 1400 1400 115220 112051 product 118743 M 0 118743
0 5054287026531_ryyl-m1.jpg 1400 1400 115221 112052 product 118744 M 0 118744
0 5054287006052.jpg 1400 1400 115223 112054 product 118746 M 0 118746
0 5054287058228.jpg 1000 1000 115224 112055 product 118747 M 0 118747
0 5054287058228_k2hm-bl.jpg 1000 1000 115225 112056 product 118748 M 0 118748
0 5054287058228_sa88-m0.jpg 1000 1000 115226 112057 product 118749 M 0 118749
0 5054287058228_llze-h2.jpg 1000 1000 115227 112058 product 118750 M 0 118750
0 5054287058228_t29x-bz.jpg 1000 1000 115228 112059 product 118751 M 0 118751
0 5054287058228_3xs1-mm.jpg 1000 1000 115229 112060 product 118752 M 0 118752
0 5054287058228_pyjs-rx.jpg 1000 1000 115230 112061 product 118753 M 0 118753
0 5054287058228_k8v3-i7.jpg 1000 1000 115231 112062 product 118754 M 0 118754
0 5028386720737.jpg 1000 1000 115458 112289 product 118981 M 0 118981
0 5028386720737_xixl-eu.jpg 1000 1000 115459 112290 product 118982 M 0 118982
0 5054287088478.jpg 1000 1000 115602 112434 product 119125 M 0 119125
0 5054287088478_hq6x-vt.jpg 1000 1000 115603 112435 product 119126 M 0 119126
0 5054287101238_ywcc-l0.jpg 1000 1000 115700 112532 product 119223 M 0 119223
0 5054287101238_kcn3-70.jpg 1000 1000 115701 112533 product 119224 M 0 119224
0 5054287101238_w9h7-0j.jpg 1000 1000 115702 112534 product 119225 M 0 119225
0 5054287101238_h8uw-s2.jpg 1000 1000 115703 112535 product 119226 M 0 119226
0 5054287101238_0bq0-dt.jpg 1000 1000 115704 112536 product 119227 M 0 119227