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.image_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 = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    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, 
    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, 
    21032, 
    21033, 
    21034, 
    21036, 
    21037, 
    21038, 
    21039, 
    21040, 
    21041, 
    21045, 
    21046, 
    21047, 
    21050, 
    21051, 
    21054, 
    21055, 
    21056, 
    21057, 
    21058, 
    21059, 
    21060, 
    21061, 
    21062, 
    21063, 
    21066, 
    21067, 
    21068, 
    21069, 
    21070, 
    23840, 
    21072, 
    21073, 
    23839, 
    21165, 
    21166, 
    21168, 
    21169, 
    21170, 
    21171, 
    21172, 
    21173, 
    21176, 
    21177, 
    21178, 
    21179, 
    21180, 
    21181, 
    21183, 
    23824, 
    21344, 
    23825, 
    21346, 
    21347, 
    21348, 
    23826, 
    21353, 
    19624, 
    19626, 
    19627, 
    19628, 
    19629, 
    19630, 
    19625, 
    22966, 
    22962, 
    23973, 
    22956, 
    22969, 
    22968, 
    22967, 
    22965, 
    22964, 
    22963, 
    23974, 
    22960, 
    22959, 
    23975, 
    22958, 
    22957, 
    22984, 
    22980, 
    23976, 
    22974, 
    22987, 
    22986, 
    22985, 
    22983, 
    22982, 
    22981, 
    23977, 
    22978, 
    22977, 
    23978, 
    22976, 
    22975
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00391

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		178	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	3	mahm3t_cs443.cscart_images_links.image_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