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 (
    91112, 
    91113, 
    91114, 
    91115, 
    91116, 
    91117, 
    91118, 
    91119, 
    91120, 
    91121, 
    91122, 
    91123, 
    91176, 
    91177, 
    91178, 
    91179, 
    91318, 
    91319, 
    91490, 
    91491, 
    91554, 
    91555, 
    91590, 
    91591, 
    91592, 
    91593, 
    91722, 
    91723, 
    91736, 
    91737, 
    91746, 
    91747, 
    91760, 
    91761, 
    91922, 
    91923, 
    91940, 
    91941, 
    91942, 
    91943, 
    91944, 
    91945, 
    91946, 
    91947, 
    91948, 
    91949, 
    91950, 
    91951, 
    91990, 
    91991, 
    91994, 
    91995, 
    92038, 
    92039, 
    92040, 
    92041, 
    92052, 
    92053, 
    92088, 
    92089, 
    92096, 
    92097, 
    92146, 
    92147, 
    92148, 
    92149, 
    92150, 
    92151, 
    92152, 
    92153, 
    92168, 
    92169, 
    92182, 
    92183, 
    92200, 
    92201, 
    92202, 
    92203, 
    92204, 
    92205, 
    92206, 
    92207, 
    92208, 
    92209, 
    92262, 
    92263, 
    92342, 
    92343, 
    92372, 
    92373, 
    92374, 
    92375, 
    92376, 
    92377, 
    92378, 
    92379, 
    92408, 
    92409, 
    92436, 
    92437, 
    92442, 
    92443, 
    92444, 
    92445, 
    92448, 
    92449, 
    92450, 
    92451, 
    92452, 
    92453, 
    92454, 
    92455, 
    92456, 
    92457, 
    92458, 
    92459, 
    92460, 
    92461, 
    92462, 
    92463, 
    92464, 
    92465, 
    92466, 
    92467, 
    92468, 
    92469, 
    92470, 
    92471, 
    92472, 
    92473, 
    92474, 
    92475, 
    92476, 
    92477, 
    92492, 
    92493, 
    92494, 
    92495, 
    92496, 
    92497, 
    92498, 
    92499, 
    92522, 
    92523, 
    92524, 
    92525, 
    92526, 
    92527, 
    93258, 
    93259, 
    106806, 
    106807, 
    172988, 
    172989, 
    172990, 
    172991, 
    172992, 
    172993, 
    211194, 
    211195
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00104

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