Sandbox

SELECT 
  cscart_images.*, 
  cscart_images_links.*, 
  cscart_common_descriptions.description AS alt, 
  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 (
    81930, 
    81931, 
    81966, 
    81967, 
    81986, 
    81987, 
    82142, 
    82143, 
    82208, 
    82209, 
    82210, 
    82211, 
    82220, 
    82221, 
    82302, 
    82303, 
    82328, 
    82329, 
    82330, 
    82331, 
    82332, 
    82333, 
    82334, 
    82335, 
    82394, 
    82395, 
    82398, 
    82399, 
    82400, 
    82401, 
    82422, 
    82423, 
    82424, 
    82425, 
    82486, 
    82487, 
    82488, 
    82489, 
    82490, 
    82491, 
    82492, 
    82493, 
    82494, 
    82495, 
    82496, 
    82497, 
    82498, 
    82499, 
    82500, 
    82501, 
    82502, 
    82503, 
    82506, 
    82507, 
    82652, 
    82653, 
    82654, 
    82655, 
    82656, 
    82657, 
    82658, 
    82659, 
    82882, 
    82883, 
    82884, 
    82885, 
    82886, 
    82887, 
    82888, 
    82889, 
    82956, 
    82957, 
    82958, 
    82959, 
    82960, 
    82961, 
    82962, 
    82963, 
    82964, 
    82965, 
    82966, 
    82967, 
    82968, 
    82969, 
    82970, 
    82971, 
    82972, 
    82973, 
    82974, 
    82975, 
    82976, 
    82977, 
    82978, 
    82979, 
    82980, 
    82981, 
    82982, 
    82983, 
    82984, 
    82985, 
    82986, 
    82987, 
    82988, 
    82989, 
    82994, 
    82995, 
    82996, 
    82997, 
    82998, 
    82999, 
    83000, 
    83001, 
    83002, 
    83003, 
    83004, 
    83005, 
    83006, 
    83007, 
    83008, 
    83009, 
    83010, 
    83011, 
    83012, 
    83013, 
    83014, 
    83015, 
    83016, 
    83017, 
    83018, 
    83019, 
    83020, 
    83021, 
    83022, 
    83023, 
    83024, 
    83025, 
    83026, 
    83027, 
    83028, 
    83029, 
    83030, 
    83031, 
    83032, 
    83033, 
    83034, 
    83035, 
    83036, 
    83037, 
    83038, 
    83039, 
    83040, 
    83041, 
    83042, 
    83043, 
    83082, 
    83083, 
    83084, 
    83085, 
    83086, 
    83087
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00090

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		160	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	4	toolboxdigitalshop_dev.cscart_images_links.image_id	1
1	SIMPLE	cscart_common_descriptions	eq_ref	PRIMARY	PRIMARY	108	toolboxdigitalshop_dev.cscart_images.image_id,const,const	1	Using where