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 (
    98339, 97666, 98898, 89236, 98794, 98793, 
    98791, 98393, 98772, 98771, 98769, 
    98736, 98734, 98672, 98622, 98523, 
    98170, 92934, 98770, 98161
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00081

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 RRR_sleave_cbkz-a5.png 1500 1500 92039 89236 product 95562 M 0 95562
0 Vicious-Circle-Recordings-332-Artwork.jpg 3000 3000 95798 92934 product 99321 M 0 99321
0 5054286061410.jpg 1000 1000 101183 98161 product 104706 M 0 104706
0 5054286046363.jpg 1000 1000 101192 98170 product 104715 M 0 104715
0 DS037.jpg 3000 3000 101370 97666 product 104893 M 0 104893
0 5054286084945.jpg 1000 1000 101375 98339 product 104898 M 0 104898
0 5054286110095.jpg 1000 1000 101429 98393 product 104952 M 0 104952
0 O-My_3000x3000.jpg 3000 3000 101598 98523 product 105121 M 0 105121
0 TB20R005.jpeg 3239 3239 101662 98622 product 105185 M 0 105185
0 GAR016_flying_high_NEW.png 2000 2000 101710 98672 product 105233 M 0 105233
0 Bezerk_Logo.jpeg 300 300 101773 98736 product 105296 M 0 105296
0 Teck_071.jpg 2048 2048 101808 98770 product 105331 M 0 105331
0 51.jpg 800 800 101809 98771 product 105332 M 0 105332
0 52.jpg 800 800 101810 98772 product 105333 M 0 105333
0 gazFD.jpeg 768 768 101811 98734 product 105334 M 0 105334
0 Jud_EP.png 1600 1600 101830 98791 product 105353 M 0 105353
0 Jud_EP_ijau-kn.png 1600 1600 101832 98793 product 105355 M 0 105355
0 Hard_to_breathe_sleeve.png 1327 1327 101833 98794 product 105356 M 0 105356
0 pdr53.jpg 800 800 101938 98898 product 105461 M 0 105461
0 toadz_remix_.jpg 2048 2048 103571 98769 product 107094 M 0 107094