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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    10012, 718, 9967, 9844, 710, 720, 9931, 
    9840, 719, 715, 10946, 9964
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

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
1909	710	product	1854	M	ZWR7_1.jpg		1000	1000	1854
1913	715	product	1858	M	fkr_zwl_000.jpg		889	652	1858
1916	718	product	1861	M	fakro_zwma.jpg	FAKRO ZWMA adaptive module e.g. KNX/EIB to Z-Wave	800	534	1861
1917	719	product	1862	M	zwmp.png		109	79	1862
1918	720	product	1863	M	zwd.png		108	132	1863
13613	9840	product	9200	M	velux_rfl.png		301	305	9200
13615	9844	product	9202	M	velux_dkl.png		301	305	9202
25431	9931	product	21018	M	fakro_arf.jpg		848	564	21018
25568	9964	product	21143	M	fakro_zws.png		878	723	21143
25573	9967	product	21148	M	ZBB-01_1.png		1000	1000	21148
25786	10012	product	21361	M	fakro_amz_zwave.PNG		516	564	21361
32003	10946	product	27581	M	Water_flow_GBL_rgxg-b5.png		454	226	27581