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 (
    99157, 99156, 99155, 99154, 99153, 99152, 
    99151, 99150, 99149, 99148, 99147, 
    99146, 99145, 99144, 99143, 99142, 
    99141, 99140, 99139, 99138
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00092

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 5054286174882.jpg 1000 1000 102178 99138 product 105701 M 0 105701
0 5054286174882_rsia-93.jpg 1000 1000 102179 99139 product 105702 M 0 105702
0 5054286174882_21mo-98.jpg 1000 1000 102180 99140 product 105703 M 0 105703
0 5054286174882_u796-uo.jpg 1000 1000 102181 99141 product 105704 M 0 105704
0 5054286174882_m7rd-jz.jpg 1000 1000 102182 99142 product 105705 M 0 105705
0 5054286174882_vq8e-zh.jpg 1000 1000 102183 99143 product 105706 M 0 105706
0 5054286174882_bys2-bz.jpg 1000 1000 102184 99144 product 105707 M 0 105707
0 5054286174882_1o3y-0t.jpg 1000 1000 102185 99145 product 105708 M 0 105708
0 5054286174882_n8tw-8z.jpg 1000 1000 102186 99146 product 105709 M 0 105709
0 5054286174882_mizo-ff.jpg 1000 1000 102187 99147 product 105710 M 0 105710
0 5054286174882_8xmb-lg.jpg 1000 1000 102188 99148 product 105711 M 0 105711
0 5054286174882_jtju-rc.jpg 1000 1000 102189 99149 product 105712 M 0 105712
0 5054286174882_sujk-d9.jpg 1000 1000 102190 99150 product 105713 M 0 105713
0 5054286174882_st1e-hs.jpg 1000 1000 102191 99151 product 105714 M 0 105714
0 5054286174882_3qlq-2v.jpg 1000 1000 102192 99152 product 105715 M 0 105715
0 5054286174882_8q8k-7z.jpg 1000 1000 102193 99153 product 105716 M 0 105716
0 5054286174882_o1xw-mc.jpg 1000 1000 102194 99154 product 105717 M 0 105717
0 5054286174882_hcu4-ls.jpg 1000 1000 102195 99155 product 105718 M 0 105718
0 5054286174882_smww-dt.jpg 1000 1000 102196 99156 product 105719 M 0 105719
0 5054286174882_u276-ps.jpg 1000 1000 102197 99157 product 105720 M 0 105720