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 (
    110705, 110704, 110703, 110702, 110701, 
    110700, 110699, 110698, 110697, 124916, 
    112121, 112119, 112118, 112117, 112116, 
    112115, 112114, 112113, 112112, 112111
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00144

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 5054286972105.jpg 1400 1400 113864 110697 product 117387 M 0 117387
0 5054286972105_dzce-p2.jpg 1400 1400 113865 110698 product 117388 M 0 117388
0 5054286972105_wiqv-n9.jpg 1400 1400 113866 110699 product 117389 M 0 117389
0 5054287008346.jpg 1400 1400 113867 110700 product 117390 M 0 117390
0 5054287008346_bsgs-iw.jpg 1400 1400 113868 110701 product 117391 M 0 117391
0 5054287008346_j7ok-lo.jpg 1400 1400 113869 110702 product 117392 M 0 117392
0 5054287008346_2dun-xv.jpg 1400 1400 113870 110703 product 117393 M 0 117393
0 5054287008346_ode9-zp.jpg 1400 1400 113871 110704 product 117394 M 0 117394
0 5054287008346_uml7-b0.jpg 1400 1400 113872 110705 product 117395 M 0 117395
0 5054287071456_6dqk-mv.jpg 1400 1400 115280 112111 product 118803 M 0 118803
0 5054287071456_3vaz-us.jpg 1400 1400 115281 112112 product 118804 M 0 118804
0 5054287071456_lp9k-1h.jpg 1400 1400 115282 112113 product 118805 M 0 118805
0 5054287071456_wksn-ge.jpg 1400 1400 115283 112114 product 118806 M 0 118806
0 5054287071456_seuv-s3.jpg 1400 1400 115284 112115 product 118807 M 0 118807
0 5054287071456_r5a1-a6.jpg 1400 1400 115285 112116 product 118808 M 0 118808
0 5054287071456_5hxm-06.jpg 1400 1400 115286 112117 product 118809 M 0 118809
0 5054287071456_qmq6-62.jpg 1400 1400 115287 112118 product 118810 M 0 118810
0 5054287071456_8f4o-v9.jpg 1400 1400 115288 112119 product 118811 M 0 118811
0 5054287071456_gdu1-ae.jpg 1400 1400 115290 112121 product 118813 M 0 118813
0 5059801084660_uyzo-me.jpg 1000 1000 128270 124916 product 131793 M 0 131793