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 (
    91821, 92682, 89223, 92807, 92769, 92768, 
    92767, 92760, 92759, 92757, 92256, 
    92572, 92523, 92280, 92259, 92237, 
    92674, 92571, 92524, 92460
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00060

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 Frantic_sleeve__Inner_City_Sumo_-_Look_Back_1MB.jpg 3000 3000 94668 91821 product 98191 M 0 98191
0 5054285594780.jpg 1000 1000 95091 92237 product 98614 M 0 98614
0 5054285591574.jpg 1000 1000 95110 92256 product 98633 M 0 98633
0 5054285593554.jpg 1000 1000 95113 92259 product 98636 M 0 98636
0 Fireball_Recordings_335.jpg 3000 3000 95134 92280 product 98657 M 0 98657
0 SS089.png 1400 1400 95316 92460 product 98839 M 0 98839
0 paper_tiger.jpg 1080 1080 95381 92523 product 98904 M 0 98904
0 Bryn_Whiting_-_The_Devils_Opinion.png 1600 1600 95382 92524 product 98905 M 0 98905
0 Band_Saw_Suzy.jpg 1000 1000 95429 92571 product 98952 M 0 98952
0 Vicious_Circle_Recordings_303_Artwork.jpg 3000 3000 95430 92572 product 98953 M 0 98953
0 VRC001_Cover_LinkinSpeaks_RossFarley.png 800 800 95533 92674 product 99056 M 0 99056
0 0BFCD672-D883-48F2-B40D-68E0C3C87CA9.png 3000 3000 95540 92682 product 99063 M 0 99063
0 State_of_Motion.jpg 1000 1000 95615 92757 product 99138 M 0 99138
0 Weekend_Mix.jpg 800 800 95617 92759 product 99140 M 0 99140
0 Lo_Pan_Joyful_Destruction.jpg 1750 1750 95618 92760 product 99141 M 0 99141
0 Hayz___Rick_James_EP.png 1600 1600 95625 92767 product 99148 M 0 99148
0 Hayz___Rick_James_EP_7ljq-zw.png 1600 1600 95626 92768 product 99149 M 0 99149
0 Hayz___Rick_James_EP_pgmu-rj.png 1600 1600 95627 92769 product 99150 M 0 99150
0 FR120_-_Random_But_Raw_-_Drone_On.jpg 2000 2000 95665 92807 product 99188 M 0 99188
0 RRR_sleaveV2_012.jpg 1500 1500 95742 89223 product 99265 M 0 99265