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 (
    88894, 
    88895, 
    88906, 
    88907, 
    88908, 
    88909, 
    88910, 
    88911, 
    88912, 
    88913, 
    88914, 
    88915, 
    89004, 
    89005, 
    89050, 
    89051, 
    89066, 
    89067, 
    89068, 
    89069, 
    89078, 
    89079, 
    89080, 
    89081, 
    89128, 
    89129, 
    89130, 
    89131, 
    89132, 
    89133, 
    89134, 
    89135, 
    89144, 
    89145, 
    89206, 
    89207, 
    89214, 
    89215, 
    89220, 
    89221, 
    89242, 
    89243, 
    89244, 
    89245, 
    89246, 
    89247, 
    89298, 
    89299, 
    89300, 
    89301, 
    89404, 
    89405, 
    89406, 
    89407, 
    89408, 
    89409, 
    89410, 
    89411, 
    89412, 
    89413, 
    89414, 
    89415, 
    89416, 
    89417, 
    89418, 
    89419, 
    89420, 
    89421, 
    89422, 
    89423, 
    89424, 
    89425, 
    89426, 
    89427, 
    89428, 
    89429, 
    89430, 
    89431, 
    89436, 
    89437, 
    89438, 
    89439, 
    89440, 
    89441, 
    89442, 
    89443, 
    89444, 
    89445, 
    89446, 
    89447, 
    89448, 
    89449, 
    89450, 
    89451, 
    89452, 
    89453, 
    89454, 
    89455, 
    89456, 
    89457, 
    89458, 
    89459, 
    89518, 
    89519, 
    89520, 
    89521, 
    89524, 
    89525, 
    89534, 
    89535, 
    89536, 
    89537, 
    89752, 
    89753, 
    89754, 
    89755, 
    89756, 
    89757, 
    89764, 
    89765, 
    89794, 
    89795, 
    89870, 
    89871, 
    89898, 
    89899, 
    89900, 
    89901, 
    89902, 
    89903, 
    89904, 
    89905, 
    89906, 
    89907, 
    89942, 
    89943, 
    89944, 
    89945, 
    90004, 
    90005, 
    90006, 
    90007, 
    90008, 
    90009, 
    90010, 
    90011, 
    90012, 
    90013, 
    90014, 
    90015, 
    90016, 
    90017, 
    90018, 
    90019, 
    91478, 
    91479, 
    166818, 
    166819, 
    166820, 
    166821
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00073

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