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 (
    92925, 96737, 97530, 97509, 97439, 97205, 
    97465, 92924, 97437, 97419, 97407, 
    97406, 97403, 97240, 97171, 97033, 
    97024, 96989, 96985, 96594
  ) 
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 Vicious-Circle-Recordings-323-Artwork.jpg 3000 3000 95788 92924 product 99311 M 0 99311
0 Vicious-Circle-Recordings-324-Artwork.jpg 3000 3000 95789 92925 product 99312 M 0 99312
0 5054285755679_igzu-ju.jpg 1000 1000 99573 96594 product 103096 M 0 103096
0 St17_Valkyrie.jpg 1181 1181 99718 96737 product 103241 M 0 103241
0 5054285983560.jpg 1000 1000 99968 96985 product 103491 M 0 103491
0 Toolbox013_beats_like_dis.jpg 1440 1440 99972 96989 product 103495 M 0 103495
0 046.jpg 1000 1000 100008 97024 product 103531 M 0 103531
0 WhatsApp_Image_2021-06-19_at_16.01.43.jpeg 1080 1080 100018 97033 product 103541 M 0 103541
0 015.jpg 2000 2000 100177 97171 product 103700 M 0 103700
0 5054286003373.jpg 1000 1000 100211 97205 product 103734 M 0 103734
0 Emmanating_Records_EM004_ARTWORK_Toolbox.png 500 500 100247 97240 product 103770 M 0 103770
0 206093369_5994618220549107_3224120717526320201_n.jpg 828 828 100411 97403 product 103934 M 0 103934
0 VRF010_Cover_LetTheGamesBegin_PaulHunter_PeterDavidson.png 800 800 100413 97406 product 103936 M 0 103936
0 HELL018_-_Power_Wank.jpg 3600 3600 100414 97407 product 103937 M 0 103937
0 Rick_James___GSR_-_Playin.png 1080 1080 100426 97419 product 103949 M 0 103949
0 Tara_N_V2.jpg 1600 1600 100444 97437 product 103967 M 0 103967
0 Monkey_Brains1.jpg 400 400 100446 97439 product 103969 M 0 103969
0 TimeBomb_image.JPG 3390 3390 100474 97465 product 103997 M 0 103997
0 Tainted.png 2000 2000 100518 97509 product 104041 M 0 104041
0 reinforcements.jpg 1400 1400 100541 97530 product 104064 M 0 104064