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 (
    100759, 100758, 100757, 100756, 100755, 
    100727, 100648, 100647, 100645, 99651, 
    98893, 92945, 100368, 100629, 100176, 
    100627, 100625, 100624, 100623, 100596
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00059

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-345-Artwork.jpg 3000 3000 95809 92945 product 99332 M 0 99332
0 OVD009.jpg 1600 1600 101932 98893 product 105455 M 0 105455
0 twistedtraxx_tn5i-ku__2__usns-gf.jpg 280 280 102697 99651 product 106220 M 0 106220
0 SML_COVER.jpg 1500 1500 103250 100176 product 106773 M 0 106773
0 5054286300069.jpg 1000 1000 103445 100368 product 106968 M 0 106968
0 5054286316923.jpg 1000 1000 103678 100596 product 107201 M 0 107201
0 IA028.jpg 1600 1600 103705 100623 product 107228 M 0 107228
0 PicsArt_11-04-07.37.51.jpg 1200 1200 103706 100624 product 107229 M 0 107229
0 Pin_Eyes.jpg 2048 2048 103707 100625 product 107230 M 0 107230
0 260765695_280609077414933_2966806400281199432_n.jpg 943 943 103709 100627 product 107232 M 0 107232
0 RRB004_sleave.png 1500 1500 103711 100629 product 107234 M 0 107234
0 TTLFD020_Sjaan_What_You_Need_-_Artwork_Sleeve.jpeg 1080 1080 103727 100645 product 107250 M 0 107250
0 Sleeve_Artwork_-_Kazzy_Eff___Martyn_B_-_Thumpz___Twangerz__Amended_.jpeg 1080 1080 103785 100647 product 107308 M 0 107308
0 Sleeve_Artwork_-_Kazzy_Eff___Martyn_B_-_Thumpz___Twangerz__Amended__4pln-d1.jpeg 1080 1080 103786 100648 product 107309 M 0 107309
0 GAR025_Panic_2.png 2000 2000 103811 100727 product 107334 M 0 107334
0 UBT056_copy_3000x3000.jpg 3000 3000 103838 100755 product 107361 M 0 107361
0 FR139_-_Random_But_Raw_-_Closed_Racquet.jpg 2000 2000 103839 100756 product 107362 M 0 107362
0 IA029__2_.jpg 1600 1600 103840 100757 product 107363 M 0 107363
0 PicsArt_11-10-08.01.19.jpg 1080 1080 103841 100758 product 107364 M 0 107364
0 242698700_1052777702220766_6790169844928971081_n.jpg 945 945 103842 100759 product 107365 M 0 107365