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.image_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.00058

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.image_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 95788 92924 product 99311 M 0
0 95789 92925 product 99312 M 0
0 99573 96594 product 103096 M 0
0 99718 96737 product 103241 M 0
0 99968 96985 product 103491 M 0
0 99972 96989 product 103495 M 0
0 100008 97024 product 103531 M 0
0 100018 97033 product 103541 M 0
0 100177 97171 product 103700 M 0
0 100211 97205 product 103734 M 0
0 100247 97240 product 103770 M 0
0 100411 97403 product 103934 M 0
0 100413 97406 product 103936 M 0
0 100414 97407 product 103937 M 0
0 100426 97419 product 103949 M 0
0 100444 97437 product 103967 M 0
0 100446 97439 product 103969 M 0
0 100474 97465 product 103997 M 0
0 100518 97509 product 104041 M 0
0 100541 97530 product 104064 M 0