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 (
    110125, 110123, 110441, 110065, 110387, 
    110143, 110062, 110060, 110058, 110057, 
    110056, 110055, 110157, 110118, 110030, 
    110029, 109951, 109950, 109948, 109947
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00068

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 5054286933038.jpg 1400 1400 113107 109947 product 116630 M 0 116630
0 5054286943860.jpg 1400 1400 113108 109948 product 116631 M 0 116631
0 5054286942085.jpg 1400 1400 113110 109950 product 116633 M 0 116633
0 5054286942085_nb2y-hv.jpg 1400 1400 113111 109951 product 116634 M 0 116634
0 5054286947530.jpg 1400 1400 113189 110029 product 116712 M 0 116712
0 5054286947530_2phv-cn.jpg 1400 1400 113190 110030 product 116713 M 0 116713
0 5054286942122.jpg 1400 1400 113215 110055 product 116738 M 0 116738
0 5054286942122_pw5x-vv.jpg 1400 1400 113216 110056 product 116739 M 0 116739
0 5054286942108.jpg 1400 1400 113217 110057 product 116740 M 0 116740
0 5054286933045.jpg 1400 1400 113218 110058 product 116741 M 0 116741
0 5054286894988.jpg 1400 1400 113220 110060 product 116743 M 0 116743
0 5054286933342.jpg 1400 1400 113222 110062 product 116745 M 0 116745
0 5054286933076.jpg 1400 1400 113225 110065 product 116748 M 0 116748
0 5054286958772.jpg 1400 1400 113278 110118 product 116801 M 0 116801
0 5054286942115.jpg 1400 1400 113283 110123 product 116806 M 0 116806
0 5054286943877.jpg 1400 1400 113285 110125 product 116808 M 0 116808
0 5054286957324_zp1s-m1.jpg 1400 1400 113303 110143 product 116826 M 0 116826
0 5054286961550.jpg 1400 1400 113317 110157 product 116840 M 0 116840
0 5054286987734.jpg 1400 1400 113549 110387 product 117072 M 0 117072
0 5054286993285.jpg 1400 1400 113603 110441 product 117126 M 0 117126