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.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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    8312, 10699, 8352, 9463, 8313, 10071, 
    8314, 414, 10073, 8373, 10072, 1628
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00133

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		12	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	3	mahm3t_cs443.cscart_images_links.detailed_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	image_path	alt	image_x	image_y	images_image_id
1023	414	product	1000	M	stuerze.jpg		1000	420	1000
3558	1628	product	2999	M	por_pallete.jpg		272	185	2999
10953	8313	product	7805	M	porenbeton_solbet_14h5-6e.jpg		644	548	7805
10954	8312	product	7806	M	porenbeton_solbet.jpg		644	548	7806
10998	8352	product	7819	M	u-schale.jpg		542	480	7819
11139	8373	product	7954	M	kleber138670935552a7816b6aa1b.jpg		333	296	7954
11226	8314	product	8047	M	porenbeton_solbet.jpg		644	548	8047
12780	9463	product	8693	M	ytong_z6qi-4v.png	ytong	387	289	8693
25996	10071	product	21571	M	ytong.png		387	289	21571
25997	10072	product	21572	M	ytong_mt7e-5l.png		387	289	21572
25998	10073	product	21573	M	ytong_c25g-5t.png		387	289	21573
31779	10699	product	27357	M	porenbeton_solbet.jpg		644	548	27357