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, 
    22807, 
    22808, 
    22809, 
    16015, 
    16003, 
    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, 
    19506, 
    19484, 
    19485, 
    19486, 
    19487, 
    19488, 
    19489, 
    19490, 
    19491, 
    19492, 
    19493, 
    19494, 
    19495, 
    19496, 
    19497, 
    19498, 
    19500, 
    19501, 
    19502, 
    19503, 
    19504, 
    19505, 
    22741, 
    22742, 
    22743, 
    22744, 
    22745, 
    22746, 
    22747, 
    22748, 
    22749, 
    22750, 
    22751, 
    22752, 
    22753, 
    22754, 
    22755, 
    22756, 
    22757, 
    22758, 
    22759, 
    22760, 
    22761, 
    24307, 
    24308, 
    24309, 
    24310, 
    24311, 
    24312, 
    24313, 
    22739, 
    22740, 
    23325, 
    23326, 
    23323, 
    23324, 
    23328, 
    23329, 
    23330, 
    23331, 
    23332, 
    23333, 
    23335, 
    23336, 
    23337, 
    23338, 
    23339, 
    23346, 
    23340, 
    23347, 
    23341, 
    23348, 
    23342, 
    23349, 
    23343, 
    23350, 
    23344, 
    23345, 
    23351, 
    23357, 
    23352, 
    23358, 
    23353, 
    23359, 
    23354, 
    23360, 
    23355, 
    23356, 
    23361, 
    23362, 
    23363, 
    23367, 
    23368, 
    23364, 
    23369, 
    23365, 
    23366, 
    23370, 
    23375, 
    23371, 
    23376, 
    23372, 
    23377, 
    23373, 
    23374, 
    14710, 
    14711, 
    15924, 
    14712, 
    14713, 
    14714, 
    14715, 
    14716, 
    14718, 
    22801, 
    22802, 
    22803, 
    22804, 
    22805, 
    22806, 
    17657, 
    17658, 
    17659, 
    17660, 
    17661, 
    17662, 
    17663, 
    17664, 
    17665, 
    17666, 
    17667, 
    17668, 
    17669, 
    17670, 
    17671, 
    17672, 
    17673, 
    17674, 
    17675, 
    17676, 
    17677, 
    17678, 
    17679, 
    17680, 
    17681, 
    17682, 
    17683, 
    17684, 
    17685, 
    17686, 
    17687, 
    17688, 
    17689, 
    17690, 
    17691, 
    17692, 
    17693, 
    17694, 
    17695, 
    17696, 
    17697, 
    17698, 
    17699, 
    17700, 
    19233, 
    19234, 
    19236, 
    19237, 
    19238, 
    19239, 
    19240, 
    19241, 
    19242, 
    19244, 
    19245, 
    19246, 
    24306, 
    19249, 
    19250, 
    19251, 
    19252, 
    23618, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    23290, 
    23291, 
    23302, 
    23300, 
    23293, 
    23292, 
    23294, 
    23295, 
    23296, 
    23297, 
    23298, 
    23299, 
    23301, 
    23303, 
    23304, 
    23305, 
    22731, 
    22732, 
    22734, 
    22735, 
    24196
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00611

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		293	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
27932	16003	variant_image	23507	V
27944	16015	variant_image	23519	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
30868	22731	variant_image	26446	V
30869	22732	variant_image	26447	V
30871	22734	variant_image	26449	V
30872	22735	variant_image	26450	V
30998	23290	variant_image	26576	V
30999	23291	variant_image	26577	V
31000	23302	variant_image	26578	V
31001	23300	variant_image	26579	V
31002	23293	variant_image	26580	V
31003	23292	variant_image	26581	V
31004	23294	variant_image	26582	V
31005	23295	variant_image	26583	V
31006	23296	variant_image	26584	V
31007	23297	variant_image	26585	V
31008	23298	variant_image	26586	V
31009	23299	variant_image	26587	V
31010	23301	variant_image	26588	V
31011	23303	variant_image	26589	V
31012	23304	variant_image	26590	V
31013	23305	variant_image	26591	V
32488	24196	variant_image	28066	V