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.image_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 (
    110359, 110330, 110326, 110421, 110420, 
    110418, 110417, 110416, 110415, 110414, 
    110413, 110412, 110411, 110410, 110409, 
    110408, 110407, 110406, 110405, 110404
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00048

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.image_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 113488 110326 product 117011 M 0
0 113492 110330 product 117015 M 0
0 113521 110359 product 117044 M 0
0 113565 110404 product 117088 M 0
0 113566 110405 product 117089 M 0
0 113567 110406 product 117090 M 0
0 113568 110407 product 117091 M 0
0 113569 110408 product 117092 M 0
0 113570 110409 product 117093 M 0
0 113571 110410 product 117094 M 0
0 113572 110411 product 117095 M 0
0 113573 110412 product 117096 M 0
0 113574 110413 product 117097 M 0
0 113575 110414 product 117098 M 0
0 113576 110415 product 117099 M 0
0 113577 110416 product 117100 M 0
0 113578 110417 product 117101 M 0
0 113579 110418 product 117102 M 0
0 113581 110420 product 117104 M 0
0 113582 110421 product 117105 M 0