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 = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    21886, 
    21887, 
    18539, 
    18544, 
    18551, 
    18542, 
    18543, 
    18540, 
    18541, 
    18545, 
    18546, 
    18547, 
    18548, 
    18549, 
    18550, 
    18552, 
    18553, 
    18554, 
    18555, 
    18556, 
    18563, 
    18557, 
    18564, 
    18558, 
    18565, 
    18559, 
    18566, 
    18560, 
    18567, 
    18561, 
    18562, 
    18568, 
    18574, 
    18569, 
    18575, 
    18570, 
    18576, 
    18571, 
    18577, 
    18572, 
    18573, 
    18578, 
    18579, 
    18580, 
    18584, 
    18585, 
    18581, 
    18586, 
    18582, 
    18583, 
    18587, 
    18592, 
    18588, 
    18593, 
    18589, 
    18594, 
    18590, 
    18591, 
    24307, 
    24308, 
    24309, 
    24310, 
    24311, 
    24312, 
    24313, 
    12642, 
    24136, 
    23691, 
    15431, 
    15432, 
    15433, 
    15435, 
    17701, 
    17702, 
    18188, 
    17703, 
    17704, 
    17705, 
    17706, 
    17707, 
    17708, 
    17709, 
    17710, 
    17711, 
    17712, 
    17713, 
    17714, 
    22482, 
    22483, 
    22485, 
    22486, 
    22488, 
    22489, 
    22490, 
    22491, 
    22492, 
    22493, 
    22495, 
    22496, 
    22497, 
    23704, 
    23705, 
    23706, 
    23709, 
    23707, 
    23708, 
    23904, 
    23905, 
    23906, 
    23907, 
    23908, 
    23909, 
    23910, 
    23911, 
    23912, 
    23913, 
    23914, 
    23915, 
    23916, 
    23917, 
    23918, 
    24286, 
    24285, 
    24284, 
    24283, 
    24276, 
    24275, 
    24277, 
    24282, 
    24281, 
    24280, 
    24279, 
    24278, 
    24274, 
    24288, 
    24287, 
    19233, 
    19234, 
    19236, 
    19237, 
    19238, 
    19239, 
    19240, 
    19241, 
    19242, 
    19244, 
    19245, 
    19246, 
    24306, 
    19249, 
    19250, 
    19251, 
    19252, 
    23618, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22118, 
    22119, 
    22120, 
    22121, 
    22122, 
    22123, 
    22124, 
    22125, 
    22126, 
    22506, 
    22127, 
    22128, 
    22129, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    22498, 
    22499, 
    22501, 
    22502, 
    24195, 
    22507, 
    22508, 
    22510, 
    22511, 
    24197
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00491

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		216	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	image_id	type
26311	15431	variant_image	21886	V
26313	15433	variant_image	21888	V
26315	15435	variant_image	21890	V
30373	21870	variant_image	25950	V
30374	21871	variant_image	25951	V
30375	21872	variant_image	25952	V
30376	21873	variant_image	25953	V
30377	21874	variant_image	25954	V
30378	21875	variant_image	25955	V
30379	21876	variant_image	25956	V
30380	21877	variant_image	25957	V
30381	21878	variant_image	25958	V
30382	21879	variant_image	25959	V
30383	21880	variant_image	25960	V
30384	21881	variant_image	25961	V
30385	21882	variant_image	25962	V
30386	21883	variant_image	25963	V
30387	21884	variant_image	25964	V
30388	21885	variant_image	25965	V
30399	21886	variant_image	25976	V
30400	21887	variant_image	25977	V
30796	22498	variant_image	26374	V
30797	22499	variant_image	26375	V
30799	22501	variant_image	26377	V
30800	22502	variant_image	26378	V
30804	22507	variant_image	26382	V
30805	22508	variant_image	26383	V
30807	22510	variant_image	26385	V
30808	22511	variant_image	26386	V
31880	15432	variant_image	27458	V
31900	23704	variant_image	27478	V
31901	23705	variant_image	27479	V
31902	23706	variant_image	27480	V
31903	23707	variant_image	27481	V
31904	23708	variant_image	27482	V
31929	23709	variant_image	27507	V
32481	24195	variant_image	28059	V
32485	24197	variant_image	28063	V