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 (
    106331, 106330, 106329, 106328, 106327, 
    106326, 106325, 106324, 106323, 106312, 
    106311, 106309, 106308, 106307, 106306, 
    106305, 106304, 106303, 106302, 106301
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00059

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 5054286602804_gwcs-mg.jpg 1000 1000 109436 106301 product 112959 M 0 112959
0 5054286602804_lq3g-d0.jpg 1000 1000 109437 106302 product 112960 M 0 112960
0 5054286602804_c7ii-nm.jpg 1000 1000 109438 106303 product 112961 M 0 112961
0 5054286602804_jux6-do.jpg 1000 1000 109439 106304 product 112962 M 0 112962
0 5054286602804_oenp-xs.jpg 1000 1000 109440 106305 product 112963 M 0 112963
0 5054286602804_ypxc-p6.jpg 1000 1000 109441 106306 product 112964 M 0 112964
0 5054286602804_f2dh-4g.jpg 1000 1000 109442 106307 product 112965 M 0 112965
0 5054286602804_rl2g-jw.jpg 1000 1000 109443 106308 product 112966 M 0 112966
0 5054286602804_7duz-h7.jpg 1000 1000 109444 106309 product 112967 M 0 112967
0 5054286603757.jpg 1000 1000 109446 106311 product 112969 M 0 112969
0 5054286603757_vuod-po.jpg 1000 1000 109447 106312 product 112970 M 0 112970
0 5054286605447.jpg 1000 1000 109459 106323 product 112982 M 0 112982
0 5054286605447_5ku7-ay.jpg 1000 1000 109460 106324 product 112983 M 0 112983
0 5054286605447_oqef-k8.jpg 1000 1000 109461 106325 product 112984 M 0 112984
0 5054286605447_g69y-o4.jpg 1000 1000 109462 106326 product 112985 M 0 112985
0 5054286605447_tai9-nv.jpg 1000 1000 109463 106327 product 112986 M 0 112986
0 5054286605447_otj2-4q.jpg 1000 1000 109464 106328 product 112987 M 0 112987
0 5054286605447_623m-qr.jpg 1000 1000 109465 106329 product 112988 M 0 112988
0 5054286605447_kcm6-y2.jpg 1000 1000 109466 106330 product 112989 M 0 112989
0 5054286605447_yhy5-p7.jpg 1000 1000 109467 106331 product 112990 M 0 112990