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 (
    99122, 99121, 99120, 99119, 99106, 99104, 
    99099, 99052, 98970, 98764, 98763, 
    98762, 98761, 98760, 98759, 98758, 
    98757, 98756, 98755, 98754
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00054

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 5054286141877_zaq8-9h.jpg 1000 1000 101792 98754 product 105315 M 0 105315
0 5054286141877_27r7-ze.jpg 1000 1000 101793 98755 product 105316 M 0 105316
0 5054286141877_d63c-2d.jpg 1000 1000 101794 98756 product 105317 M 0 105317
0 5054286141877_h9n1-l7.jpg 1000 1000 101795 98757 product 105318 M 0 105318
0 5054286141877_61uq-rs.jpg 1000 1000 101796 98758 product 105319 M 0 105319
0 5054286141877_mrhw-vy.jpg 1000 1000 101797 98759 product 105320 M 0 105320
0 5054286141877_n7m0-a6.jpg 1000 1000 101798 98760 product 105321 M 0 105321
0 5054286141877_bhik-j3.jpg 1000 1000 101799 98761 product 105322 M 0 105322
0 5054286141877_vr1x-8f.jpg 1000 1000 101800 98762 product 105323 M 0 105323
0 5054286141877_pf7v-5a.jpg 1000 1000 101801 98763 product 105324 M 0 105324
0 5054286141877_so4d-7g.jpg 1000 1000 101802 98764 product 105325 M 0 105325
0 hoover_freaks.png 2000 2000 102010 98970 product 105533 M 0 105533
0 FSD001_Base22_-_Machines_Take_Kontrol.jpg 1500 1500 102092 99052 product 105615 M 0 105615
0 TBHH036_Shenton___Baseglitz_-_Biblical_Artwork-min.jpg 3000 3000 102138 99099 product 105661 M 0 105661
0 Frantic_sleeve_FD057-Mobi-D---Within-Us_1MB.jpg 3000 3000 102143 99104 product 105666 M 0 105666
0 Emmanating_Records_EM007_ARTWORK_toolbox.png 500 500 102145 99106 product 105668 M 0 105668
0 PicsArt_08-27-07.35.58.jpg 1440 1440 102158 99119 product 105681 M 0 105681
0 Dark_Cloud_.jpg 2048 2048 102159 99120 product 105682 M 0 105682
0 IA019.jpg 1600 1600 102160 99121 product 105683 M 0 105683
0 ambiguous.jpg 1282 1262 102161 99122 product 105684 M 0 105684