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 (
    15210, 
    15211, 
    15212, 
    15213, 
    15214, 
    15215, 
    15216, 
    13248, 
    13270, 
    13249, 
    13271, 
    13250, 
    13272, 
    13251, 
    13273, 
    13252, 
    13274, 
    13253, 
    13275, 
    13254, 
    13276, 
    13255, 
    13277, 
    13256, 
    13278, 
    13257, 
    13279, 
    13258, 
    13280, 
    13882, 
    13260, 
    13282, 
    13261, 
    13283, 
    13262, 
    13284, 
    13263, 
    13285, 
    13264, 
    13286, 
    13265, 
    13287, 
    13266, 
    13288, 
    13267, 
    13289, 
    13268, 
    13290, 
    13269, 
    13291, 
    18321, 
    18322, 
    18323, 
    18324, 
    18325, 
    18326, 
    18327, 
    18328, 
    18329, 
    18330, 
    18331, 
    18332, 
    18334, 
    18335, 
    18336, 
    19688, 
    19689, 
    19702, 
    19690, 
    19691, 
    19701, 
    19692, 
    19693, 
    19694, 
    19700, 
    19695, 
    19696, 
    19697, 
    19698, 
    19699, 
    20702, 
    20703, 
    20704, 
    20705, 
    20706, 
    20707, 
    20708, 
    20709, 
    20710, 
    20711, 
    20714, 
    20715, 
    20716, 
    20717, 
    20718, 
    20719, 
    20720, 
    20721, 
    20722, 
    21054, 
    21055, 
    21056, 
    21057, 
    21058, 
    21059, 
    21060, 
    21061, 
    21062, 
    21063, 
    21066, 
    21067, 
    21068, 
    21069, 
    21070, 
    23840, 
    21072, 
    21073, 
    23839, 
    21121, 
    21122, 
    21124, 
    21125, 
    21126, 
    21127, 
    21128, 
    21129, 
    21131, 
    21132, 
    21133, 
    21134, 
    21135, 
    21136, 
    21137, 
    21138, 
    21139, 
    21165, 
    21166, 
    21168, 
    21169, 
    21170, 
    21171, 
    21172, 
    21173, 
    21176, 
    21177, 
    21178, 
    21179, 
    21180, 
    21181, 
    21183, 
    21209, 
    21210, 
    21212, 
    21213, 
    21214, 
    21215, 
    21216, 
    21217, 
    21220, 
    21221, 
    21222, 
    21223, 
    21224, 
    21225, 
    21227, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    19624, 
    19626, 
    19627, 
    19628, 
    19629, 
    19630, 
    19625, 
    22966, 
    22962, 
    23973, 
    22956, 
    22969, 
    22968, 
    22967, 
    22965, 
    22964, 
    22963, 
    23974, 
    22960, 
    22959, 
    23975, 
    22958, 
    22957, 
    13595, 
    13596, 
    13602
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00490

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		211	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
15165	13595	variant_image	10752	V
15166	13596	variant_image	10753	V
15172	13602	variant_image	10759	V