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 (
    111857, 111856, 111855, 111854, 111853, 
    111852, 111851, 111850, 111849, 111848, 
    111847, 111846, 111831, 111830, 111829, 
    111828, 111801, 111797, 111792, 111791
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00067

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 5054287001095.jpg 1400 1400 114959 111791 product 118482 M 0 118482
0 5054287001095_2aby-pq.jpg 1400 1400 114960 111792 product 118483 M 0 118483
0 5054287030736.jpg 600 600 114965 111797 product 118488 M 0 118488
0 5054286971634.jpg 1400 1400 114969 111801 product 118492 M 0 118492
0 5054287005925.jpg 1400 1400 114996 111828 product 118519 M 0 118519
0 5054287005925_2h2u-ta.jpg 1400 1400 114997 111829 product 118520 M 0 118520
0 5054287005925_yj9b-g6.jpg 1400 1400 114998 111830 product 118521 M 0 118521
0 5054287005925_kzpt-0e.jpg 1400 1400 114999 111831 product 118522 M 0 118522
0 5054287033201.jpg 600 600 115014 111846 product 118537 M 0 118537
0 5054287033201_o0nv-wt.jpg 600 600 115015 111847 product 118538 M 0 118538
0 5054287033201_x5p7-bn.jpg 600 600 115016 111848 product 118539 M 0 118539
0 5054287033201_d0ri-4v.jpg 600 600 115017 111849 product 118540 M 0 118540
0 5054287033201_7cle-8n.jpg 600 600 115018 111850 product 118541 M 0 118541
0 5054287033201_a4rg-z6.jpg 600 600 115019 111851 product 118542 M 0 118542
0 5054287033201_kpnm-2m.jpg 600 600 115020 111852 product 118543 M 0 118543
0 5054287033201_t94l-xq.jpg 600 600 115021 111853 product 118544 M 0 118544
0 5054287033201_v5yl-3y.jpg 600 600 115022 111854 product 118545 M 0 118545
0 5054287033201_r3em-7s.jpg 600 600 115023 111855 product 118546 M 0 118546
0 5054287033201_p9zw-sz.jpg 600 600 115024 111856 product 118547 M 0 118547
0 5054287033201_kyuu-om.jpg 600 600 115025 111857 product 118548 M 0 118548