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 = 'se' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    20878, 
    20879, 
    20880, 
    20881, 
    20882, 
    20883, 
    20884, 
    20885, 
    20886, 
    20887, 
    20889, 
    20890, 
    20891, 
    20892, 
    20893, 
    20894, 
    20900, 
    20901, 
    20902, 
    20903, 
    20904, 
    20905, 
    20906, 
    20907, 
    20908, 
    20909, 
    20912, 
    20913, 
    20914, 
    20915, 
    20916, 
    23845, 
    23843, 
    23846, 
    23844, 
    22811, 
    22812, 
    22814, 
    22815, 
    22816, 
    22817, 
    22818, 
    22819, 
    22820, 
    22823, 
    22824, 
    22826, 
    22827, 
    22855, 
    23820, 
    22859, 
    22860, 
    22861, 
    22862, 
    22863, 
    22864, 
    22868, 
    22871, 
    21077, 
    21078, 
    21080, 
    21081, 
    21082, 
    21083, 
    21084, 
    21085, 
    21087, 
    21088, 
    21089, 
    21090, 
    21091, 
    21092, 
    23847, 
    21094, 
    21095, 
    21099, 
    21100, 
    21102, 
    21103, 
    21104, 
    21105, 
    21106, 
    21107, 
    21109, 
    21110, 
    21111, 
    21112, 
    21113, 
    21114, 
    21115, 
    21116, 
    21117, 
    23821, 
    22881, 
    23822, 
    22883, 
    22884, 
    22885, 
    23823, 
    22890, 
    23830, 
    22837, 
    23831, 
    22839, 
    22840, 
    22841, 
    22842, 
    22846, 
    22930, 
    22926, 
    23994, 
    22920, 
    22933, 
    22932, 
    22931, 
    22929, 
    22928, 
    23995, 
    22924, 
    22923, 
    23996, 
    22922, 
    22921, 
    22934, 
    22935, 
    23991, 
    22937, 
    22938, 
    22939, 
    22940, 
    22941, 
    22942, 
    23992, 
    22944, 
    22945, 
    23993, 
    22946, 
    22947, 
    20536, 
    20537, 
    20538, 
    20539, 
    20540, 
    20541, 
    20542, 
    20543, 
    20544, 
    20545, 
    20546, 
    20547, 
    20548, 
    20549, 
    20550, 
    20551, 
    20552, 
    20553, 
    20554, 
    20555, 
    20556, 
    20557, 
    20566, 
    20567, 
    20568, 
    20569, 
    20570, 
    20571, 
    20572, 
    20573, 
    20574, 
    20576, 
    20577, 
    20578, 
    20579, 
    20581, 
    20582, 
    20583, 
    20584, 
    20585, 
    20586, 
    20587
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00358

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