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 (
    92910, 92680, 94278, 94277, 94276, 94207, 
    94191, 94140, 93939, 93932, 93760, 
    93525, 93451, 93346, 94187, 94185, 
    94184, 94183, 93378, 94141
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00051

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_340.jpg 3000 3000 95538 92680 product 99061 M 0 99061
0 Vicious-Circle-Recordings-308-Artwork.jpg 3000 3000 95774 92910 product 99297 M 0 99297
0 5054285685242.jpg 1000 1000 96217 93346 product 99740 M 0 99740
0 5054285689813.jpg 1000 1000 96249 93378 product 99772 M 0 99772
0 TBHH031_Tom_Stock__Damien_Blanes_-_Bumper_Artwork-min.jpg 3000 3000 96322 93451 product 99845 M 0 99845
0 5054285707081.jpg 1000 1000 96400 93525 product 99923 M 0 99923
0 TGR076_-_Brow_-_Hoi_Polloi.jpg 1600 1600 96636 93760 product 100159 M 0 100159
0 twistedtraxx_tn5i-ku__2_.jpg 280 280 96810 93932 product 100333 M 0 100333
0 TTLFD003-Dark_Suspects-Diva_Final_PNG-01_0qem-ng.png 1080 1080 97019 94140 product 100542 M 0 100542
0 Ender_Blender.jpg 1400 1400 97020 94141 product 100543 M 0 100543
0 Tommy.png 2000 2000 97062 94183 product 100585 M 0 100585
0 NITROX119_-_Valex_-_James_Nardi_-_Freaks_Among_Monsters__Dark_Suspects_Remix__-_Nitrox.jpg 3600 3600 97063 94184 product 100586 M 0 100586
0 NITROX120_-_Valex_-_James_Nardi_-_Freaks_Among_Monsters__Brendan_Ashley_Remix__-_Nitrox.jpg 3600 3600 97064 94185 product 100587 M 0 100587
0 Monster17.jpg 1750 1750 97066 94187 product 100589 M 0 100589
0 M-Series_Vs_BASE22_-_Give_It_Up.png 1080 1080 97070 94191 product 100593 M 0 100593
0 VRF004_Cover_These_Eyes__Slenderman.png 800 800 97091 94207 product 100614 M 0 100614
0 FR125_-_Paul_Luffman___Random_But_Raw_-_Frack_Off__Nikkdbubble_Remix_.jpg 2000 2000 97156 94276 product 100679 M 0 100679
0 162263359_256337272906123_8224131219016806682_o.jpg 2048 2048 97157 93939 product 100680 M 0 100680
0 received_451685602815421.jpeg 2000 2000 97158 94278 product 100681 M 0 100681
0 Operatic.jpg 1080 1080 97171 94277 product 100694 M 0 100694