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 (
    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.00061

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 5054286959083.jpg 1400 1400 113488 110326 product 117011 M 0 117011
0 5054286949800_j1go-90.jpg 1400 1400 113492 110330 product 117015 M 0 117015
0 5054286899433.jpg 1400 1400 113521 110359 product 117044 M 0 117044
0 5054286987147_b114-s3.jpg 1400 1400 113565 110404 product 117088 M 0 117088
0 5054286987147_n65m-vy.jpg 1400 1400 113566 110405 product 117089 M 0 117089
0 5054286987147_hh7h-j9.jpg 1400 1400 113567 110406 product 117090 M 0 117090
0 5054286987147_bslf-ut.jpg 1400 1400 113568 110407 product 117091 M 0 117091
0 5054286987147_kjfc-vy.jpg 1400 1400 113569 110408 product 117092 M 0 117092
0 5054286987147_d2vn-hy.jpg 1400 1400 113570 110409 product 117093 M 0 117093
0 5054286987147_egnv-1o.jpg 1400 1400 113571 110410 product 117094 M 0 117094
0 5054286987147_k97x-qw.jpg 1400 1400 113572 110411 product 117095 M 0 117095
0 5054286987147_5xxj-p0.jpg 1400 1400 113573 110412 product 117096 M 0 117096
0 5054286987147_6pf9-qz.jpg 1400 1400 113574 110413 product 117097 M 0 117097
0 5054286987147_z9az-t9.jpg 1400 1400 113575 110414 product 117098 M 0 117098
0 5054286987147_s9o2-wp.jpg 1400 1400 113576 110415 product 117099 M 0 117099
0 5054286987147_ccvx-s6.jpg 1400 1400 113577 110416 product 117100 M 0 117100
0 5054286987147_g15e-vj.jpg 1400 1400 113578 110417 product 117101 M 0 117101
0 5054286987147_39bv-66.jpg 1400 1400 113579 110418 product 117102 M 0 117102
0 5054286987147_jaxf-x4.jpg 1400 1400 113581 110420 product 117104 M 0 117104
0 5054286987147_w3uh-s0.jpg 1400 1400 113582 110421 product 117105 M 0 117105