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 (
    98021, 98020, 98019, 98018, 98017, 98016, 
    98015, 98014, 97917, 97758, 97671, 
    97663, 97471, 97470, 97469, 97468, 
    97292, 97291, 97178, 89232
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00066

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 UBT052__1__copy_3000x3000.jpg 3000 3000 100184 97178 product 103707 M 0 103707
0 5054285942710.jpg 1000 1000 100298 97291 product 103821 M 0 103821
0 5054285942710_xlif-x6.jpg 1000 1000 100299 97292 product 103822 M 0 103822
0 5054285895757.jpg 1000 1000 100477 97468 product 104000 M 0 104000
0 5054285895757_k3dj-0p.jpg 1000 1000 100478 97469 product 104001 M 0 104001
0 5054285895757_ej7u-gu.jpg 1000 1000 100479 97470 product 104002 M 0 104002
0 5054285895757_r6iy-rb.jpg 1000 1000 100480 97471 product 104003 M 0 104003
0 DS034_-_Gary_O'Connor_-_Go_With_The_Flow_-_Bass_Jumper_Remix.jpg 2500 2500 100673 97663 product 104196 M 0 104196
0 RRR025.jpg 1500 1500 100679 89232 product 104202 M 0 104202
0 GARH003_spirit_of_house.png 2000 2000 100775 97758 product 104298 M 0 104298
0 Emmanating_Records_EM005_ARTWORK_TOOLBOX.png 500 500 100937 97917 product 104460 M 0 104460
0 Timeless_Album.jpg 1500 1500 101034 98014 product 104557 M 0 104557
0 Timeless_Album_5j79-gy.jpg 1500 1500 101035 98015 product 104558 M 0 104558
0 Timeless_Album_i0yv-wk.jpg 1500 1500 101036 98016 product 104559 M 0 104559
0 Timeless_Album_g7f4-kb.jpg 1500 1500 101037 98017 product 104560 M 0 104560
0 Timeless_Album_lh6h-ii.jpg 1500 1500 101038 98018 product 104561 M 0 104561
0 Timeless_Album_i9sv-89.jpg 1500 1500 101039 98019 product 104562 M 0 104562
0 Timeless_Album_di4e-c0.jpg 1500 1500 101040 98020 product 104563 M 0 104563
0 Timeless_Album_hk4c-y1.jpg 1500 1500 101041 98021 product 104564 M 0 104564
0 TMP0182.jpg 2160 2160 101226 97671 product 104749 M 0 104749