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 (
    8303, 8665, 9880, 8281, 8286, 9818, 8371, 
    8364, 9883, 8666, 8300, 8365
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00099

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	image_x	image_y	images_image_id
10506	8281	product	7358	M	rodos1.jpg	1000	562	7358
10520	8286	product	7372	M	calabria1.jpg	1920	1080	7372
10534	8300	product	7386	M	Monsanto-1.jpg	1920	1080	7386
10536	8303	product	7388	M	nepal1.jpg	1920	1080	7388
11067	8364	product	7881	M	stegu_ak_grunt.jpg	600	534	7881
11068	8371	product	7882	M	stegu_ak_impregnat_stone.jpg	600	534	7882
11572	8665	product	8069	M	Grenada-1.jpg	1920	1080	8069
11580	8666	product	8077	M	grenada2.jpg	1920	1080	8077
13338	9818	product	8925	M	timber1.jpg	1920	1080	8925
25200	9880	product	20787	M	grenada5.jpg	1920	1080	20787
25206	9883	product	20793	M	stegu-amster-grey.jpg	640	480	20793
28354	8365	product	23929	M	stegu_powerelastik_000.jpg	716	610	23929