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 (
    109465, 109886, 109742, 109741, 109740, 
    109739, 109448, 109447, 109446, 109445, 
    109444, 109376, 122293, 122292, 122291, 
    122290, 122289, 122288, 122287, 122286
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00100

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 5054286891734.jpg 1399 1400 112531 109376 product 116054 M 0 116054
0 5054286892861.jpg 1400 1400 112599 109444 product 116122 M 0 116122
0 5054286892861_3gyc-b2.jpg 1400 1400 112600 109445 product 116123 M 0 116123
0 5054286889809.jpg 1400 1400 112601 109446 product 116124 M 0 116124
0 5054286889809_67xf-le.jpg 1400 1400 112602 109447 product 116125 M 0 116125
0 5054286889809_hocd-cq.jpg 1400 1400 112603 109448 product 116126 M 0 116126
0 5054286819998_tvgz-c9.jpg 1400 1400 112620 109465 product 116143 M 0 116143
0 5054286922582.jpg 1400 1400 112897 109739 product 116420 M 0 116420
0 5054286922582_hn3n-zp.jpg 1400 1400 112898 109740 product 116421 M 0 116421
0 5054286922582_8o0g-eb.jpg 1400 1400 112899 109741 product 116422 M 0 116422
0 5054286922582_zwbq-az.jpg 1400 1400 112900 109742 product 116423 M 0 116423
0 5054286942443.jpg 1400 1400 113046 109886 product 116569 M 0 116569
0 5054288017941_bk6k-n8.jpg 1400 1400 125562 122286 product 129085 M 0 129085
0 5054288017941_raxr-2e.jpg 1400 1400 125563 122287 product 129086 M 0 129086
0 5054288017941_fg68-c0.jpg 1400 1400 125564 122288 product 129087 M 0 129087
0 5054288017941_968n-lg.jpg 1400 1400 125565 122289 product 129088 M 0 129088
0 5054288017941_4li2-r8.jpg 1400 1400 125566 122290 product 129089 M 0 129089
0 5054288017941_rcdr-wp.jpg 1400 1400 125567 122291 product 129090 M 0 129090
0 5054288017941_mhdn-vk.jpg 1400 1400 125568 122292 product 129091 M 0 129091
0 5054288017941_cxae-e8.jpg 1400 1400 125569 122293 product 129092 M 0 129092