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 (
    20702, 
    20703, 
    20704, 
    20705, 
    20706, 
    20707, 
    20708, 
    20709, 
    20710, 
    20711, 
    20714, 
    20715, 
    20716, 
    20717, 
    20718, 
    20719, 
    20720, 
    20721, 
    20722, 
    20790, 
    20791, 
    20792, 
    20793, 
    20794, 
    20795, 
    20796, 
    20797, 
    20798, 
    20799, 
    20800, 
    20801, 
    20802, 
    20803, 
    20804, 
    20805, 
    20806, 
    20807, 
    20808, 
    20809, 
    20810, 
    21010, 
    21011, 
    21012, 
    21013, 
    21014, 
    21015, 
    21016, 
    21017, 
    21018, 
    21019, 
    21022, 
    21023, 
    21024, 
    21025, 
    21026, 
    23833, 
    21028, 
    21029, 
    23834, 
    21054, 
    21055, 
    21056, 
    21057, 
    21058, 
    21059, 
    21060, 
    21061, 
    21062, 
    21063, 
    21066, 
    21067, 
    21068, 
    21069, 
    21070, 
    23840, 
    21072, 
    21073, 
    23839, 
    21252, 
    23816, 
    21256, 
    21257, 
    21258, 
    21259, 
    21260, 
    21261, 
    21265, 
    21268, 
    21318, 
    21322, 
    21323, 
    21324, 
    21325, 
    21326, 
    21327, 
    23818, 
    21406, 
    21407, 
    21409, 
    21410, 
    21411, 
    21412, 
    21413, 
    21414, 
    21415, 
    21418, 
    21419, 
    21421, 
    21422, 
    21473, 
    21474, 
    21476, 
    21477, 
    21478, 
    21479, 
    21480, 
    21481, 
    21482, 
    21485, 
    21486, 
    21488, 
    21489, 
    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, 
    23849, 
    23853, 
    23854, 
    23855, 
    23883, 
    23884, 
    23859
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00351

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		176	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