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 (
    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, 
    20812, 
    20813, 
    20816, 
    20818, 
    20819, 
    20820, 
    20821, 
    20823, 
    20824, 
    20825, 
    20826, 
    20827, 
    20828, 
    20829, 
    20830, 
    20831, 
    20832, 
    20944, 
    20945, 
    20946, 
    20947, 
    20948, 
    20949, 
    20950, 
    20951, 
    20952, 
    20953, 
    20956, 
    20957, 
    20958, 
    20959, 
    20960, 
    23842, 
    20962, 
    20963, 
    23841, 
    22855, 
    23820, 
    22859, 
    22860, 
    22861, 
    22862, 
    22863, 
    22864, 
    22868, 
    22871, 
    21099, 
    21100, 
    21102, 
    21103, 
    21104, 
    21105, 
    21106, 
    21107, 
    21109, 
    21110, 
    21111, 
    21112, 
    21113, 
    21114, 
    21115, 
    21116, 
    21117, 
    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, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    19576, 
    19578, 
    19579, 
    19580, 
    19581, 
    19582, 
    19577, 
    19600, 
    19602, 
    19603, 
    19604, 
    19605, 
    19606, 
    19601, 
    20476, 
    20477, 
    20478, 
    20479, 
    20480, 
    20481, 
    20482, 
    20483, 
    20484, 
    20485, 
    20487, 
    20488, 
    20489, 
    20490, 
    20491, 
    20492, 
    20493, 
    20494, 
    20495, 
    20496, 
    20497
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00352

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