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 (
    82630, 
    82631, 
    82660, 
    82661, 
    82744, 
    82745, 
    82818, 
    82819, 
    82990, 
    82991, 
    82992, 
    82993, 
    83058, 
    83059, 
    83074, 
    83075, 
    83088, 
    83089, 
    83090, 
    83091, 
    83092, 
    83093, 
    83094, 
    83095, 
    83096, 
    83097, 
    83100, 
    83101, 
    83108, 
    83109, 
    83110, 
    83111, 
    83118, 
    83119, 
    83120, 
    83121, 
    83122, 
    83123, 
    83124, 
    83125, 
    83126, 
    83127, 
    83128, 
    83129, 
    83130, 
    83131, 
    83250, 
    83251, 
    83252, 
    83253, 
    83254, 
    83255, 
    83300, 
    83301, 
    83302, 
    83303, 
    83304, 
    83305, 
    83306, 
    83307, 
    83308, 
    83309, 
    83310, 
    83311, 
    83312, 
    83313, 
    83314, 
    83315, 
    83316, 
    83317, 
    83318, 
    83319, 
    83320, 
    83321, 
    83322, 
    83323, 
    83324, 
    83325, 
    83332, 
    83333, 
    83346, 
    83347, 
    83430, 
    83431, 
    83432, 
    83433, 
    83434, 
    83435, 
    83436, 
    83437, 
    83438, 
    83439, 
    83440, 
    83441, 
    83442, 
    83443, 
    83444, 
    83445, 
    83446, 
    83447, 
    83448, 
    83449, 
    83450, 
    83451, 
    83452, 
    83453, 
    83454, 
    83455, 
    83458, 
    83459, 
    83612, 
    83613, 
    83618, 
    83619, 
    83620, 
    83621, 
    83622, 
    83623, 
    83624, 
    83625, 
    83626, 
    83627, 
    83628, 
    83629, 
    83630, 
    83631, 
    83632, 
    83633, 
    83634, 
    83635, 
    83636, 
    83637, 
    83638, 
    83639, 
    83640, 
    83641, 
    83642, 
    83643, 
    83644, 
    83645, 
    83646, 
    83647, 
    83648, 
    83649, 
    83682, 
    83683, 
    83686, 
    83687, 
    83688, 
    83689, 
    83714, 
    83715, 
    84108, 
    84109, 
    84178, 
    84179, 
    91472, 
    91473, 
    91476, 
    91477
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00078

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