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, 
    23381, 
    23382, 
    23379, 
    23380, 
    23384, 
    23385, 
    23386, 
    23387, 
    23388, 
    23389, 
    23391, 
    23392, 
    23393, 
    23394, 
    23395, 
    23402, 
    23396, 
    23403, 
    23397, 
    23404, 
    23398, 
    23405, 
    23399, 
    23406, 
    23400, 
    23401, 
    23407, 
    23413, 
    23408, 
    23414, 
    23409, 
    23415, 
    23410, 
    23416, 
    23411, 
    23412, 
    23417, 
    23418, 
    23419, 
    23423, 
    23424, 
    23420, 
    23425, 
    23421, 
    23422, 
    23426, 
    23431, 
    23427, 
    23432, 
    23428, 
    23433, 
    23429, 
    23430, 
    21473, 
    21474, 
    21476, 
    21477, 
    21478, 
    21479, 
    21480, 
    21481, 
    21482, 
    21485, 
    21486, 
    21488, 
    21489, 
    21099, 
    21100, 
    21102, 
    21103, 
    21104, 
    21105, 
    21106, 
    21107, 
    21109, 
    21110, 
    21111, 
    21112, 
    21113, 
    21114, 
    21115, 
    21116, 
    21117, 
    21870, 
    21871, 
    21872, 
    21873, 
    21874, 
    21875, 
    21876, 
    21877, 
    21878, 
    21879, 
    21880, 
    21881, 
    21882, 
    21883, 
    21884, 
    21885, 
    23306, 
    23316, 
    23308, 
    23307, 
    23317, 
    23310, 
    23311, 
    23312, 
    23313, 
    23314, 
    23315, 
    23309, 
    23318, 
    23319, 
    23320, 
    23321
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.09895

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		225	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
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
30982	23306	variant_image	26560	V
30983	23316	variant_image	26561	V
30984	23308	variant_image	26562	V
30985	23307	variant_image	26563	V
30986	23317	variant_image	26564	V
30987	23310	variant_image	26565	V
30988	23311	variant_image	26566	V
30989	23312	variant_image	26567	V
30990	23313	variant_image	26568	V
30991	23314	variant_image	26569	V
30992	23315	variant_image	26570	V
30993	23309	variant_image	26571	V
30994	23318	variant_image	26572	V
30995	23319	variant_image	26573	V
30996	23320	variant_image	26574	V
30997	23321	variant_image	26575	V