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, 
    13994, 
    14010, 
    14002, 
    14033, 
    14024, 
    14005, 
    14025, 
    14021, 
    14028, 
    14003, 
    14011, 
    14012, 
    13998, 
    14000, 
    14032, 
    14027, 
    14034, 
    15152, 
    15151, 
    14038, 
    14039, 
    15309, 
    14040, 
    14041, 
    14215, 
    14042, 
    14043, 
    14044, 
    14045, 
    14046, 
    14047, 
    15373, 
    14048, 
    14049, 
    14050, 
    15746, 
    15747, 
    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, 
    20386, 
    20388, 
    20390, 
    20724, 
    20725, 
    20726, 
    20728, 
    20729, 
    20730, 
    20731, 
    20732, 
    20733, 
    20738, 
    20739, 
    20742, 
    20743, 
    20834, 
    20835, 
    20836, 
    20837, 
    20838, 
    20839, 
    20840, 
    20841, 
    20842, 
    20843, 
    20844, 
    20845, 
    20846, 
    20847, 
    20848, 
    20849, 
    20850, 
    20851, 
    20852, 
    20853, 
    20854, 
    20988, 
    20989, 
    20990, 
    20991, 
    20992, 
    20993, 
    20994, 
    20995, 
    20996, 
    20997, 
    21000, 
    21001, 
    21002, 
    21003, 
    21004, 
    21032, 
    21033, 
    21034, 
    21036, 
    21037, 
    21038, 
    21039, 
    21040, 
    21041, 
    21045, 
    21046, 
    21047, 
    21050, 
    21051, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    23824, 
    21344, 
    23825, 
    21346, 
    21347, 
    21348, 
    23826, 
    21353, 
    21832, 
    21833, 
    21834, 
    21835, 
    21836, 
    21837, 
    21838, 
    21839, 
    21840, 
    21841, 
    21842, 
    21843, 
    21844, 
    21845, 
    21846, 
    22984, 
    22980, 
    23976, 
    22974, 
    22987, 
    22986, 
    22985, 
    22983, 
    22982, 
    22981, 
    23977, 
    22978, 
    22977, 
    23978, 
    22976, 
    22975, 
    15386, 
    15387, 
    15389, 
    15393, 
    15396, 
    15397, 
    15400, 
    15401, 
    15402, 
    15403, 
    15406, 
    15407, 
    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.00932

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		251	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
26275	15386	variant_image	21850	V
26276	15387	variant_image	21851	V
26278	15389	variant_image	21853	V
26282	15393	variant_image	21857	V
26285	15396	variant_image	21860	V
26286	15397	variant_image	21861	V
26289	15400	variant_image	21864	V
26290	15401	variant_image	21865	V
26291	15402	variant_image	21866	V
26292	15403	variant_image	21867	V
26295	15406	variant_image	21870	V
26296	15407	variant_image	21871	V
27133	15152	variant_image	22708	V
27134	15151	variant_image	22709	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