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 (
    91827, 91796, 91825, 91824, 91823, 91808, 
    91807, 91806, 91805, 91804, 91803, 
    91639, 91600, 91537, 91535, 91425, 
    91025, 90894, 90888, 90881
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00062

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 5054285412275.jpg 1000 1000 93719 90881 product 97242 M 0 97242
0 5054285490136.jpg 1000 1000 93726 90888 product 97249 M 0 97249
0 5054285467411.jpg 1000 1000 93732 90894 product 97255 M 0 97255
0 5054285500224.jpg 1000 1000 93863 91025 product 97386 M 0 97386
0 5054285534120.jpg 1000 1000 94271 91425 product 97794 M 0 97794
0 miss1.jpg 1000 1000 94381 91535 product 97904 M 0 97904
0 Kaki008.png 1400 1400 94383 91537 product 97906 M 0 97906
0 LOGO_SQUARE_Cropped.jpg 375 375 94446 91600 product 97969 M 0 97969
0 VCR302.jpg 600 600 94485 91639 product 98008 M 0 98008
0 TGR072_Artwork.jpg 1600 1600 94643 91796 product 98166 M 0 98166
0 HFAS02A..jpg 3000 3000 94650 91803 product 98173 M 0 98173
0 Warm_it_Up_2.png 1080 1080 94651 91804 product 98174 M 0 98174
0 dip-3033-Time.jpg 796 797 94652 91805 product 98175 M 0 98175
0 Tara1Wake.jpg 1750 1750 94653 91806 product 98176 M 0 98176
0 Tara2Dust.jpg 1750 1750 94654 91807 product 98177 M 0 98177
0 Tara3Seance.jpg 1750 1750 94655 91808 product 98178 M 0 98178
0 The_Commander.jpg 1400 1400 94670 91823 product 98193 M 0 98193
0 Got_The_Flow.jpg 1400 1400 94671 91824 product 98194 M 0 98194
0 Run_For_Cover.jpg 1400 1400 94672 91825 product 98195 M 0 98195
0 dd151.jpg 1000 1000 94674 91827 product 98197 M 0 98197