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 (
    98260, 98259, 98258, 98257, 98256, 98255, 
    98254, 98253, 98252, 98251, 98250, 
    98249, 98248, 98247, 98246, 98245, 
    98244, 98243, 98242, 98241
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00061

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 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_2hcv-pw.jpg 3000 3000 101273 98241 product 104796 M 0 104796
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_vya2-mk.jpg 3000 3000 101274 98242 product 104797 M 0 104797
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_5dx0-mi.jpg 3000 3000 101275 98243 product 104798 M 0 104798
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_tku7-zy.jpg 3000 3000 101276 98244 product 104799 M 0 104799
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_to5j-5o.jpg 3000 3000 101277 98245 product 104800 M 0 104800
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_ussy-ec.jpg 3000 3000 101278 98246 product 104801 M 0 104801
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_dfl7-mk.jpg 3000 3000 101279 98247 product 104802 M 0 104802
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_lt8p-q7.jpg 3000 3000 101280 98248 product 104803 M 0 104803
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_shga-hf.jpg 3000 3000 101281 98249 product 104804 M 0 104804
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_q927-yg.jpg 3000 3000 101282 98250 product 104805 M 0 104805
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_uz5p-d7.jpg 3000 3000 101283 98251 product 104806 M 0 104806
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2.jpg 3000 3000 101284 98252 product 104807 M 0 104807
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_y94k-k3.jpg 3000 3000 101285 98253 product 104808 M 0 104808
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_xuuo-27.jpg 3000 3000 101286 98254 product 104809 M 0 104809
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_q3j9-zi.jpg 3000 3000 101287 98255 product 104810 M 0 104810
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_9sxr-fc.jpg 3000 3000 101288 98256 product 104811 M 0 104811
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_b66t-j1.jpg 3000 3000 101289 98257 product 104812 M 0 104812
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_xx0r-z8.jpg 3000 3000 101290 98258 product 104813 M 0 104813
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_ufv4-th.jpg 3000 3000 101291 98259 product 104814 M 0 104814
0 DSBC02_-_Digital_Snail_Back_Catalogue_Bundle_2_wrfg-mv.jpg 3000 3000 101292 98260 product 104815 M 0 104815