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 (
    92732, 92731, 92730, 92729, 92728, 92726, 
    92725, 92723, 92721, 92720, 92719, 
    92718, 92717, 92716, 92715, 92713, 
    92712, 92711, 92710, 92709
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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 5054285636862_udrt-o9.jpg 1400 1400 95567 92709 product 99090 M 0 99090
0 5054285636862_vsho-7b.jpg 1400 1400 95568 92710 product 99091 M 0 99091
0 5054285636862_qrqn-4g.jpg 1400 1400 95569 92711 product 99092 M 0 99092
0 5054285636862_vv2x-wr.jpg 1400 1400 95570 92712 product 99093 M 0 99093
0 5054285636862_7uen-k6.jpg 1400 1400 95571 92713 product 99094 M 0 99094
0 5054285636862_s74i-91.jpg 1400 1400 95573 92715 product 99096 M 0 99096
0 5054285636862_aovg-1d.jpg 1400 1400 95574 92716 product 99097 M 0 99097
0 5054285636862_cyow-c5.jpg 1400 1400 95575 92717 product 99098 M 0 99098
0 5054285636862_ngw5-qb.jpg 1400 1400 95576 92718 product 99099 M 0 99099
0 5054285636862_aplz-mm.jpg 1400 1400 95577 92719 product 99100 M 0 99100
0 5054285636862_idgu-4o.jpg 1400 1400 95578 92720 product 99101 M 0 99101
0 5054285636862_ug5x-t4.jpg 1400 1400 95579 92721 product 99102 M 0 99102
0 5054285636862_5uia-9q.jpg 1400 1400 95581 92723 product 99104 M 0 99104
0 5054285636862_m4bj-zo.jpg 1400 1400 95583 92725 product 99106 M 0 99106
0 5054285636862_rcbg-oq.jpg 1400 1400 95584 92726 product 99107 M 0 99107
0 5054285636862_nvfr-ik.jpg 1400 1400 95586 92728 product 99109 M 0 99109
0 5054285636862_o8gu-j6.jpg 1400 1400 95587 92729 product 99110 M 0 99110
0 5054285636862_3i4w-jb.jpg 1400 1400 95588 92730 product 99111 M 0 99111
0 5054285636862_lnjd-ab.jpg 1400 1400 95589 92731 product 99112 M 0 99112
0 5054285636862_gzio-b9.jpg 1400 1400 95590 92732 product 99113 M 0 99113