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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    10011, 9933, 10121, 9852, 10364, 725, 
    10389, 8376, 10069, 10122
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00085

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		10	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
11227	8376	product	8048	M	fakro_zsz_00.png		499	673	8048
11241	725	product	26238	M	fkr_arf_002.jpg	Store occultant FAKRO SOLAIRE	1200	900	26238
13618	9852	product	9205	M	velux_fhl.png		301	305	9205
25785	10011	product	21360	M	fakro_ame.PNG		566	622	21360
26128	10069	product	21703	M	ZSD-packshot-01_1.jpg		1000	1000	21703
27132	9933	product	22707	M	fakro_ARP.jpg		1200	900	22707
27140	10121	product	22715	M	ZST-01_1_1.jpg		1000	1000	22715
27147	10122	product	22722	M	drazek-zsz-do-markiz-6.jpg		1152	864	22722
28557	10364	product	24132	M	fuehrungsrolle_skylight.jpg		427	389	24132
29561	10389	product	25138	M	ZBB-01_1.png		1000	1000	25138