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 (
    99468, 99905, 99309, 98768, 98767, 98732, 
    98731, 98730, 98729, 1660, 99167, 99166, 
    99165, 99164, 99163, 99162, 99161, 
    99160, 99159, 99158
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00055

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 twistedtraxx_jsmp-jc.png 263 263 72474 1660 product 75997 M 0 75997
0 5054285941720.jpg 1000 1000 101767 98729 product 105290 M 0 105290
0 5054285941720_e5tp-qg.jpg 1000 1000 101768 98730 product 105291 M 0 105291
0 5054285941720_9zs7-he.jpg 1000 1000 101769 98731 product 105292 M 0 105292
0 5054285941720_91bi-1y.jpg 1000 1000 101770 98732 product 105293 M 0 105293
0 5054286145585.jpg 1000 1000 101805 98767 product 105328 M 0 105328
0 5054286145585_n1lm-qt.jpg 1000 1000 101806 98768 product 105329 M 0 105329
0 5054286174882_xtuv-fa.jpg 1000 1000 102198 99158 product 105721 M 0 105721
0 5054286174882_4f4j-9s.jpg 1000 1000 102199 99159 product 105722 M 0 105722
0 5054286174882_pg8q-zy.jpg 1000 1000 102200 99160 product 105723 M 0 105723
0 5054286174882_nhsq-5h.jpg 1000 1000 102201 99161 product 105724 M 0 105724
0 5054286174882_boxi-wp.jpg 1000 1000 102202 99162 product 105725 M 0 105725
0 5054286174882_83y8-u7.jpg 1000 1000 102203 99163 product 105726 M 0 105726
0 5054286174882_fxkd-46.jpg 1000 1000 102204 99164 product 105727 M 0 105727
0 5054286174882_we0p-og.jpg 1000 1000 102205 99165 product 105728 M 0 105728
0 5054286174882_bu25-4x.jpg 1000 1000 102206 99166 product 105729 M 0 105729
0 5054286174882_v9r7-dy.jpg 1000 1000 102207 99167 product 105730 M 0 105730
0 5054286186168.jpg 1000 1000 102351 99309 product 105874 M 0 105874
0 3000x3000_COVER_-_BRING_DOWN_THE_HOUSE_-_LKR010.jpg 3000 3000 102510 99468 product 106033 M 0 106033
0 5054286240532.jpg 1000 1000 102975 99905 product 106498 M 0 106498