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 (
    111706, 111705, 111704, 111703, 111702, 
    111701, 111700, 111699, 111698, 111697, 
    111696, 111695, 111694, 111693, 111692, 
    111691, 111690, 111902, 111843, 111684
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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 5054287022830_tomd-b1.jpg 1400 1400 114851 111684 product 118374 M 0 118374
0 5054287022885.jpg 1400 1400 114857 111690 product 118380 M 0 118380
0 5054287022885_iy3p-ha.jpg 1400 1400 114858 111691 product 118381 M 0 118381
0 5054287022878.jpg 1400 1400 114859 111692 product 118382 M 0 118382
0 5054287022878_bhnm-6m.jpg 1400 1400 114860 111693 product 118383 M 0 118383
0 5054287032556.jpg 600 600 114861 111694 product 118384 M 0 118384
0 5054287032556_d92c-0c.jpg 600 600 114862 111695 product 118385 M 0 118385
0 5054287032556_plds-v5.jpg 600 600 114863 111696 product 118386 M 0 118386
0 5054287032556_p39a-ak.jpg 600 600 114864 111697 product 118387 M 0 118387
0 5054287032556_xfce-qb.jpg 600 600 114865 111698 product 118388 M 0 118388
0 5054287032556_xmme-xf.jpg 600 600 114866 111699 product 118389 M 0 118389
0 5054287032556_ga7l-rl.jpg 600 600 114867 111700 product 118390 M 0 118390
0 5054287032556_zlbj-me.jpg 600 600 114868 111701 product 118391 M 0 118391
0 5054287032556_7ees-ge.jpg 600 600 114869 111702 product 118392 M 0 118392
0 5054287032556_vdvv-jo.jpg 600 600 114870 111703 product 118393 M 0 118393
0 5054287032556_4lj4-lf.jpg 600 600 114871 111704 product 118394 M 0 118394
0 5054287032556_6v5v-ty.jpg 600 600 114872 111705 product 118395 M 0 118395
0 5054287032556_a1c2-41.jpg 600 600 114873 111706 product 118396 M 0 118396
0 5054287045624.jpg 600 600 115011 111843 product 118534 M 0 118534
0 5054287052196.jpg 1000 1000 115070 111902 product 118593 M 0 118593