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 (
    98240, 98239, 98238, 98237, 98236, 98234, 
    98233, 98218, 97607, 98225, 98224, 
    98217, 98200, 98179, 98176, 98165, 
    98078, 97968, 97967, 97537
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00060

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 5054285935880.jpg 1000 1000 100548 97537 product 104071 M 0 104071
0 5054286033974.jpg 1000 1000 100617 97607 product 104140 M 0 104140
0 Toolbox014_necessary_evil.jpg 1440 1440 100987 97967 product 104510 M 0 104510
0 GAR014_this_dream.png 2000 2000 100988 97968 product 104511 M 0 104511
0 TTLFD011-Kazzy_Eff_-_Baby_I_PNG-01.png 1080 1080 101097 98078 product 104620 M 0 104620
0 TRI007_-_TriBeaut_-_Good_Habits.jpg 3000 3000 101187 98165 product 104710 M 0 104710
0 TB20R001.jpeg 3239 3239 101198 98176 product 104721 M 0 104721
0 PicsArt_08-02-03.31.41.jpg 2289 2289 101204 98179 product 104727 M 0 104727
0 48.jpg 800 800 101225 98200 product 104748 M 0 104748
0 TMP0183.png 2160 2160 101243 98217 product 104766 M 0 104766
0 ESP_Logo_Purple_9gml-d3.png 400 400 101244 98218 product 104767 M 0 104767
0 LOGO_SQUARE_Cropped_LARGE.jpg 3000 3000 101257 98224 product 104780 M 0 104780
0 LOGO_SQUARE_Cropped_LARGE_k614-z1.jpg 3000 3000 101258 98225 product 104781 M 0 104781
0 Ben_Vennard_-_Hi-Five_EP.png 2000 2000 101266 98233 product 104789 M 0 104789
0 Ben_Vennard_-_Hi-Five_EP_ejiv-cs.png 2000 2000 101267 98234 product 104790 M 0 104790
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1.jpg 3000 3000 101268 98236 product 104791 M 0 104791
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_mvqu-lr.jpg 3000 3000 101269 98237 product 104792 M 0 104792
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_x6dg-mi.jpg 3000 3000 101270 98238 product 104793 M 0 104793
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_nat6-db.jpg 3000 3000 101271 98239 product 104794 M 0 104794
0 DSBC01_-_Digital_Snail_Back_Catalogue_Bundle_1_vygh-xc.jpg 3000 3000 101272 98240 product 104795 M 0 104795