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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'product' 
  AND cscart_images_links.type = 'A' 
  AND cscart_images_links.object_id IN (
    430, 9470, 10705, 750, 10195, 426, 10670, 
    9457, 10157, 9938, 8862, 8860
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00169

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		47	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
12444	8862	product	8348	A	0
12445	8862	product	8349	A	0
12473	8860	product	8379	A	0
12476	8862	product	8382	A	0
12477	8862	product	8383	A	0
12478	8862	product	8384	A	0
12479	8862	product	8385	A	0
12480	8862	product	8386	A	0
12481	8862	product	8387	A	0
12482	8862	product	8388	A	0
12483	8862	product	8389	A	0
12484	8862	product	8390	A	0
12799	9470	product	8712	A	0
12801	9470	product	8714	A	0
30907	430	product	26485	A	0
31016	750	product	26594	A	0
31635	10670	product	27213	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
32484	10195	product	28062	A	0
32503	9457	product	28081	A	0
32522	10705	product	28100	A	0
32538	426	product	28116	A	0
12438	8860	product	8340	A	1
25434	9938	product	21021	A	1
27650	10195	product	23225	A	1
30911	430	product	26489	A	1
31017	750	product	26595	A	1
31842	10705	product	27420	A	1
32504	9457	product	28082	A	1
32539	426	product	28117	A	1
12461	8860	product	8367	A	2
25435	9938	product	21022	A	2
29372	9457	product	24949	A	2
31018	750	product	26596	A	2
31203	430	product	26781	A	2
31630	10670	product	27208	A	2
31836	10705	product	27414	A	2
32509	10195	product	28087	A	2
32541	426	product	28119	A	2
1942	750	product	1887	A	3
12437	8860	product	8339	A	3
25454	9938	product	21041	A	3
29368	9457	product	24945	A	3
30908	430	product	26486	A	3
31631	10670	product	27209	A	3
31834	10705	product	27412	A	3
32508	10195	product	28086	A	3
32540	426	product	28118	A	3
1943	750	product	1888	A	4
12474	8860	product	8380	A	4
25455	9938	product	21042	A	4
30909	430	product	26487	A	4
31632	10670	product	27210	A	4
31837	10705	product	27415	A	4
32501	9457	product	28079	A	4
32510	10195	product	28088	A	4
32544	426	product	28122	A	4
1941	750	product	1886	A	5
12462	8860	product	8368	A	5
25456	9938	product	21043	A	5
27632	10195	product	23207	A	5
30910	430	product	26488	A	5
31628	10670	product	27206	A	5
31839	10705	product	27417	A	5
32502	9457	product	28080	A	5
1121	430	product	1098	A	6
12463	8860	product	8369	A	6
27647	10195	product	23222	A	6
31838	10705	product	27416	A	6
32505	9457	product	28083	A	6
32542	426	product	28120	A	6
12464	8860	product	8370	A	7
25494	430	product	21069	A	7
27607	750	product	23182	A	7
31210	10195	product	26788	A	7
31403	430	product	26981	A	7
31404	430	product	26982	A	7
31634	10670	product	27212	A	7
31823	10705	product	27401	A	7
32506	9457	product	28084	A	7
32543	426	product	28121	A	7
12465	8860	product	8371	A	8
27602	426	product	23177	A	8
27606	750	product	23181	A	8
31208	10195	product	26786	A	8
31826	10705	product	27404	A	8
32507	9457	product	28085	A	8
12466	8860	product	8372	A	9
25433	750	product	21020	A	9
25492	9470	product	21067	A	9
27651	426	product	23226	A	9
31209	10195	product	26787	A	9
31827	10705	product	27405	A	9
12467	8860	product	8373	A	10
27636	10195	product	23211	A	10
28300	426	product	23875	A	10
31828	10705	product	27406	A	10
12468	8860	product	8374	A	11
27637	10195	product	23212	A	11
31385	426	product	26963	A	11
31829	10705	product	27407	A	11
12469	8860	product	8375	A	12
27638	10195	product	23213	A	12
28299	426	product	23874	A	12
31832	10705	product	27410	A	12
12470	8860	product	8376	A	13
28301	426	product	23876	A	13
31830	10705	product	27408	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