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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    430, 9470, 750, 426, 10157, 8860, 8878, 
    8861, 10076, 8864, 8880, 524
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00152

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		43	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	position
12442	8861	product	8345	A	0
12448	8864	product	8354	A	0
12473	8860	product	8379	A	0
12490	8878	product	8397	A	0
12507	8880	product	8416	A	0
12508	8880	product	8417	A	0
12509	8880	product	8418	A	0
12510	8880	product	8419	A	0
12511	8880	product	8420	A	0
12512	8880	product	8421	A	0
12799	9470	product	8712	A	0
12801	9470	product	8714	A	0
26005	10076	product	21580	A	0
30907	430	product	26485	A	0
31016	750	product	26594	A	0
31308	524	product	26886	A	0
32468	9470	product	28046	A	0
32471	10157	product	28049	A	0
32472	10157	product	28050	A	0
32473	10157	product	28051	A	0
32474	10157	product	28052	A	0
32475	10157	product	28053	A	0
32476	10157	product	28054	A	0
32477	10157	product	28055	A	0
32538	426	product	28116	A	0
12438	8860	product	8340	A	1
12443	8861	product	8346	A	1
12449	8864	product	8355	A	1
12492	8878	product	8399	A	1
27136	10076	product	22711	A	1
30911	430	product	26489	A	1
31017	750	product	26595	A	1
32492	524	product	28070	A	1
32539	426	product	28117	A	1
12450	8864	product	8356	A	2
12452	8861	product	8358	A	2
12461	8860	product	8367	A	2
12493	8878	product	8400	A	2
27137	10076	product	22712	A	2
31018	750	product	26596	A	2
31203	430	product	26781	A	2
32493	524	product	28071	A	2
32541	426	product	28119	A	2
1942	750	product	1887	A	3
12437	8860	product	8339	A	3
12456	8861	product	8362	A	3
12533	8864	product	8446	A	3
30908	430	product	26486	A	3
32494	524	product	28072	A	3
32540	426	product	28118	A	3
1943	750	product	1888	A	4
12454	8861	product	8360	A	4
12474	8860	product	8380	A	4
12535	8864	product	8448	A	4
30909	430	product	26487	A	4
32495	524	product	28073	A	4
32544	426	product	28122	A	4
1941	750	product	1886	A	5
12455	8861	product	8361	A	5
12462	8860	product	8368	A	5
12494	8878	product	8401	A	5
12536	8864	product	8449	A	5
26010	10076	product	21585	A	5
30910	430	product	26488	A	5
31309	524	product	26887	A	5
31367	10076	product	26945	A	5
31368	10076	product	26946	A	5
31369	10076	product	26947	A	5
31370	10076	product	26948	A	5
31371	10076	product	26949	A	5
31372	10076	product	26950	A	5
31373	10076	product	26951	A	5
1121	430	product	1098	A	6
12453	8861	product	8359	A	6
12463	8860	product	8369	A	6
12491	8878	product	8398	A	6
12534	8864	product	8447	A	6
32542	426	product	28120	A	6
12457	8861	product	8363	A	7
12464	8860	product	8370	A	7
12496	8878	product	8403	A	7
25494	430	product	21069	A	7
27607	750	product	23182	A	7
31403	430	product	26981	A	7
31404	430	product	26982	A	7
32543	426	product	28121	A	7
12458	8861	product	8364	A	8
12465	8860	product	8371	A	8
12498	8878	product	8405	A	8
27602	426	product	23177	A	8
27606	750	product	23181	A	8
12459	8861	product	8365	A	9
12466	8860	product	8372	A	9
12499	8878	product	8406	A	9
25433	750	product	21020	A	9
25492	9470	product	21067	A	9
27651	426	product	23226	A	9
12460	8861	product	8366	A	10
12467	8860	product	8373	A	10
12500	8878	product	8407	A	10
28300	426	product	23875	A	10
31355	8878	product	26933	A	10
31356	8878	product	26934	A	10
12468	8860	product	8374	A	11
31385	426	product	26963	A	11
12469	8860	product	8375	A	12
28299	426	product	23874	A	12
12470	8860	product	8376	A	13
28301	426	product	23876	A	13
12471	8860	product	8377	A	14
31381	426	product	26959	A	14
31382	426	product	26960	A	15
1202	426	product	1179	A	16
1203	426	product	1180	A	17
31595	426	product	27173	A	18