Sandbox

SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 = 'category' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    480, 263, 926, 923, 928, 903, 948, 949, 
    950, 951, 952, 953, 954, 955, 956, 957, 
    959, 958, 960, 901
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00086

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	3	mahm3t_cs443.cscart_images_links.image_id	1	Using where
1	SIMPLE	cscart_common_descriptions	eq_ref	PRIMARY	PRIMARY	107	mahm3t_cs443.cscart_images.image_id,const,const	1	Using where

Result

pair_id	object_id	object_type	detailed_id	type
32601	480	category	28179	M
32602	263	category	28180	M
32603	926	category	28181	M
32604	923	category	28182	M
32605	928	category	28183	M
32606	903	category	28184	M
32607	948	category	28185	M
32608	949	category	28186	M
32609	950	category	28187	M
32610	951	category	28188	M
32611	952	category	28189	M
32612	953	category	28190	M
32613	954	category	28191	M
32614	955	category	28192	M
32615	956	category	28193	M
32616	957	category	28194	M
32617	959	category	28195	M
32618	958	category	28196	M