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 (
    94011, 94010, 94009, 94008, 94007, 94006, 
    94851, 89228, 94777, 94772, 94133, 
    94760, 92912, 94726, 94708, 94707, 
    94706, 94687, 94570, 94569
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00072

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 Vicious-Circle-Recordings-310-Artwork.jpg 3000 3000 95776 92912 product 99299 M 0 99299
0 5054285721599.jpg 1000 1000 96886 94006 product 100409 M 0 100409
0 5054285721599_von2-me.jpg 1000 1000 96887 94007 product 100410 M 0 100410
0 5054285721599_akl0-6y.jpg 1000 1000 96888 94008 product 100411 M 0 100411
0 5054285721599_bap8-05.jpg 1000 1000 96889 94009 product 100412 M 0 100412
0 5054285721599_no1b-sl.jpg 1000 1000 96890 94010 product 100413 M 0 100413
0 5054285721599_mw3x-ii.jpg 1000 1000 96891 94011 product 100414 M 0 100414
0 036.jpg 1000 1000 97012 94133 product 100535 M 0 100535
0 RRR_sleaveV2_017.jpg 1500 1500 97221 89228 product 100744 M 0 100744
0 Vandalize___TRex_-_Gloria_Hole_Artwork.png 1080 1080 97457 94569 product 100980 M 0 100980
0 VRF005_Cover_Pathogen_Slenderman.png 800 800 97458 94570 product 100981 M 0 100981
0 FR127_-_Random_But_Raw___Sinobe_-_White_Glass__Dynamic_Intervention_Remix_.jpg 2000 2000 97575 94687 product 101098 M 0 101098
0 Tara_Go_Back_2.jpg 1750 1750 97594 94706 product 101117 M 0 101117
0 INDECISION_IA012_tekneak.jpg 1600 1600 97595 94707 product 101118 M 0 101118
0 INDECISION_IA012_Nervous_Energy.jpg 1600 1600 97596 94708 product 101119 M 0 101119
0 Havent_you_had_enough.jpg 1080 1080 97614 94726 product 101137 M 0 101137
0 SS091_copy.png 1400 1400 97648 94760 product 101171 M 0 101171
0 Positive_Thoughts.png 2000 2000 97660 94772 product 101183 M 0 101183
0 ESP_Turcois.png 400 400 97665 94777 product 101188 M 0 101188
0 Screenshot_2021-04-08-14-01-29-114.jpg 705 710 97742 94851 product 101265 M 0 101265