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 (
    93222, 93224, 93165, 92338, 92337, 93157, 
    93156, 93104, 93103, 93058, 93036, 
    92955, 92835, 92833, 92522, 92521, 
    92504, 92502, 92344, 92281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00063

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 Fireball_Recordings_336.jpg 3000 3000 95135 92281 product 98658 M 0 98658
0 5054285606230.jpg 1000 1000 95193 92337 product 98716 M 0 98716
0 5054285606230_s11h-hd.jpg 1000 1000 95194 92338 product 98717 M 0 98717
0 thumbnail_Encoded_sleeveENC89_Adam-Butler_Technik.jpg 1280 1280 95200 92344 product 98723 M 0 98723
0 5054285619940.jpg 1000 1000 95360 92502 product 98883 M 0 98883
0 Vicious_Circle_Recordings_304_Artwork.jpg 3000 3000 95362 92504 product 98885 M 0 98885
0 WLHH023.jpg 1024 1024 95379 92521 product 98902 M 0 98902
0 WLHH023_8kgj-h5.jpg 1024 1024 95380 92522 product 98903 M 0 98903
0 HWR017.jpg 1000 1000 95692 92833 product 99215 M 0 99215
0 TMP0169.png 1080 1080 95694 92835 product 99217 M 0 99217
0 VR002_Cover_DrowningintheNight_Slenderman_RossFarleyvs.RBR.png 800 800 95872 92955 product 99395 M 0 99395
0 TRI002_-_TriBeaut_-_Wet_Dreams.jpg 3000 3000 95903 93036 product 99426 M 0 99426
0 PicsArt_01-28-06.15.51.jpg 1080 1080 95925 93058 product 99448 M 0 99448
0 KK001_Killing_People.jpg 1750 1750 95971 93103 product 99494 M 0 99494
0 145412080_257842102576693_5523011880340640045_n.png 1080 1080 95972 93104 product 99495 M 0 99495
0 Durango_Bandit_Bill.jpg 800 800 96024 93157 product 99547 M 0 99547
0 TTLFD001-Jonni_Bryant-Believe_in_youV4FinalJPEG.jpg 1078 1080 96025 93156 product 99548 M 0 99548
0 The_Sopranos_-_Underground_Sounds.png 1600 1600 96034 93165 product 99557 M 0 99557
0 RRR_sleaveV2_008_3.jpg 1500 1500 96091 93222 product 99614 M 0 99614
0 ESP_Purple.png 400 400 96093 93224 product 99616 M 0 99616