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 (
    67592, 
    67593, 
    67626, 
    67627, 
    67628, 
    67629, 
    67630, 
    67631, 
    67632, 
    67633, 
    67634, 
    67635, 
    67636, 
    67637, 
    67638, 
    67639, 
    67640, 
    67641, 
    67642, 
    67643, 
    67644, 
    67645, 
    67646, 
    67647, 
    67648, 
    67649, 
    67650, 
    67651, 
    67652, 
    67653, 
    67662, 
    67663, 
    67680, 
    67681, 
    67682, 
    67683, 
    67684, 
    67685, 
    67686, 
    67687, 
    67970, 
    67971, 
    68392, 
    68393, 
    68394, 
    68395, 
    68396, 
    68397, 
    68398, 
    68399, 
    68400, 
    68401, 
    68402, 
    68403, 
    68404, 
    68405, 
    68406, 
    68407, 
    68408, 
    68409, 
    68410, 
    68411, 
    68412, 
    68413, 
    68414, 
    68415, 
    68416, 
    68417, 
    68418, 
    68419, 
    68634, 
    68635, 
    68636, 
    68637, 
    68638, 
    68639, 
    68640, 
    68641, 
    68642, 
    68643, 
    68644, 
    68645, 
    68646, 
    68647, 
    68648, 
    68649, 
    68650, 
    68651, 
    68652, 
    68653, 
    68654, 
    68655, 
    68656, 
    68657, 
    68658, 
    68659, 
    68660, 
    68661, 
    68662, 
    68663, 
    68664, 
    68665, 
    68666, 
    68667, 
    68668, 
    68669, 
    68670, 
    68671, 
    68672, 
    68673, 
    68728, 
    68729, 
    68730, 
    68731, 
    68732, 
    68733, 
    68734, 
    68735, 
    68736, 
    68737, 
    68738, 
    68739, 
    68740, 
    68741, 
    68742, 
    68743, 
    68744, 
    68745, 
    68746, 
    68747, 
    68748, 
    68749, 
    68750, 
    68751, 
    68752, 
    68753, 
    68754, 
    68755, 
    68756, 
    68757, 
    68758, 
    68759, 
    68760, 
    68761, 
    68762, 
    68763, 
    68764, 
    68765, 
    68766, 
    68767, 
    68768, 
    68769, 
    68770, 
    68771, 
    68772, 
    68773, 
    68774, 
    68775, 
    68776, 
    68777
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00097

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