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 (
    20505, 
    20500, 
    20501, 
    20502, 
    20503, 
    20504, 
    20855, 
    20856, 
    20857, 
    20858, 
    20859, 
    20860, 
    20861, 
    20862, 
    20863, 
    20864, 
    20865, 
    20866, 
    20867, 
    20868, 
    20869, 
    20870, 
    20871, 
    20872, 
    20873, 
    20874, 
    20875, 
    20876, 
    20768, 
    20769, 
    20770, 
    20771, 
    20772, 
    20773, 
    20774, 
    20775, 
    20776, 
    20777, 
    20779, 
    20780, 
    20781, 
    20782, 
    20783, 
    20784, 
    20944, 
    20945, 
    20946, 
    20947, 
    20948, 
    20949, 
    20950, 
    20951, 
    20952, 
    20953, 
    20956, 
    20957, 
    20958, 
    20959, 
    20960, 
    23842, 
    20962, 
    20963, 
    23841, 
    20966, 
    20967, 
    20968, 
    20969, 
    20970, 
    20971, 
    20972, 
    20973, 
    20974, 
    20975, 
    20978, 
    20979, 
    20980, 
    20981, 
    20982, 
    23837, 
    20984, 
    20985, 
    23838, 
    20988, 
    20989, 
    20990, 
    20991, 
    20992, 
    20993, 
    20994, 
    20995, 
    20996, 
    20997, 
    21000, 
    21001, 
    21002, 
    21003, 
    21004, 
    21495, 
    21496, 
    21498, 
    21499, 
    21500, 
    21501, 
    21502, 
    21503, 
    21504, 
    21507, 
    21508, 
    21510, 
    21511, 
    23827, 
    21234, 
    21235, 
    21236, 
    21237, 
    21238, 
    21239, 
    21243, 
    21246, 
    21143, 
    21144, 
    21146, 
    21147, 
    21148, 
    21149, 
    21150, 
    21151, 
    21154, 
    21155, 
    21156, 
    21157, 
    21158, 
    21159, 
    21161, 
    21187, 
    21188, 
    21190, 
    21191, 
    21192, 
    21193, 
    21194, 
    21195, 
    21198, 
    21199, 
    21200, 
    21201, 
    21202, 
    23828, 
    21432, 
    23829, 
    21434, 
    21435, 
    21436, 
    21437, 
    21441, 
    20476, 
    20477, 
    20478, 
    20479, 
    20480, 
    20481, 
    20482, 
    20483, 
    20484, 
    20485, 
    20487, 
    20488, 
    20489, 
    20490, 
    20491, 
    20492, 
    20493, 
    20494, 
    20495, 
    20496, 
    20497, 
    20626, 
    20627, 
    20628, 
    20629, 
    20630, 
    20631, 
    20632, 
    20633, 
    20634, 
    20635, 
    20636, 
    20637, 
    20638, 
    20639, 
    20640, 
    20641, 
    20642, 
    20643, 
    20644, 
    20645, 
    20646, 
    20647
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00428

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