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 (
    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, 
    15365, 
    15366, 
    15363, 
    15364, 
    15362, 
    15367, 
    15368, 
    18411, 
    18412, 
    18425, 
    18413, 
    18414, 
    18424, 
    18415, 
    18416, 
    18417, 
    18418, 
    18419, 
    18420, 
    18421, 
    18422, 
    18423, 
    19656, 
    19657, 
    19670, 
    19658, 
    19659, 
    19669, 
    19660, 
    19661, 
    19662, 
    19668, 
    19663, 
    19664, 
    19665, 
    19666, 
    19667, 
    15718, 
    15719, 
    15720, 
    15721, 
    15722, 
    15723, 
    15724, 
    15725, 
    15726, 
    15727, 
    15728, 
    15729, 
    15730, 
    15731, 
    15732, 
    15733, 
    15734, 
    15735, 
    15736, 
    15737, 
    15738, 
    17679, 
    17680, 
    17681, 
    17682, 
    17683, 
    17684, 
    17685, 
    17686, 
    17687, 
    17688, 
    17689, 
    17690, 
    17691, 
    17692, 
    17693, 
    17694, 
    17695, 
    17696, 
    17697, 
    17698, 
    17699, 
    17700, 
    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, 
    23849, 
    23853, 
    23854, 
    23855, 
    23883, 
    23884, 
    23859, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    19588, 
    19590, 
    19591, 
    19592, 
    19593, 
    19594, 
    19589, 
    14783, 
    14784, 
    14810, 
    21278, 
    21280, 
    21281, 
    21282, 
    21287, 
    13704, 
    13707
  ) 
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		208	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

Result

pair_id	object_id	object_type	image_id	detailed_id	type	position	emo_md5	image_path	alt	image_x	image_y	images_image_id
24314	13704	variant_image	19901	0	V	0		velux_pal_7001p.png		272	272	19901
24317	13707	variant_image	19904	0	V	0		velux_pal_7057p.png		272	272	19904