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 (
    109698, 109440, 109439, 109438, 109437, 
    109436, 109435, 109434, 109433, 109432, 
    109431, 109430, 109429, 109364, 109082, 
    109081, 109075, 109074, 109073, 109068
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 5054286817468_fs11-9o.jpg 1400 1400 112221 109068 product 115744 M 0 115744
0 5054286869740.jpg 1400 1400 112226 109073 product 115749 M 0 115749
0 5054286869740_xo9m-2k.jpg 1400 1400 112227 109074 product 115750 M 0 115750
0 5054286869740_hq1w-hb.jpg 1400 1400 112228 109075 product 115751 M 0 115751
0 5054286860242.jpg 1400 1400 112234 109081 product 115757 M 0 115757
0 5054286862079.jpg 1400 1400 112235 109082 product 115758 M 0 115758
0 5054286897026.jpg 1400 1400 112517 109364 product 116040 M 0 116040
0 5054286894513.jpg 1400 1400 112584 109429 product 116107 M 0 116107
0 5054286894513_gea1-au.jpg 1400 1400 112585 109430 product 116108 M 0 116108
0 5054286894513_8cr3-nq.jpg 1400 1400 112586 109431 product 116109 M 0 116109
0 5054286894513_t7j3-ei.jpg 1400 1400 112587 109432 product 116110 M 0 116110
0 5054286894513_d2k1-2j.jpg 1400 1400 112588 109433 product 116111 M 0 116111
0 5054286894513_avzf-1s.jpg 1400 1400 112589 109434 product 116112 M 0 116112
0 5054286894513_xfwn-xt.jpg 1400 1400 112590 109435 product 116113 M 0 116113
0 5054286894513_6o6i-f1.jpg 1400 1400 112591 109436 product 116114 M 0 116114
0 5054286894513_khhh-0v.jpg 1400 1400 112592 109437 product 116115 M 0 116115
0 5054286894513_mig3-lw.jpg 1400 1400 112593 109438 product 116116 M 0 116116
0 5054286894513_6h44-7r.jpg 1400 1400 112594 109439 product 116117 M 0 116117
0 5054286894513_q094-iz.jpg 1400 1400 112595 109440 product 116118 M 0 116118
0 5054286927990.jpg 1400 1400 112855 109698 product 116378 M 0 116378