SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 (
    7711, 7712, 7713, 7714, 7715, 7716, 7717, 
    7718, 7719, 7720, 7721, 7722, 7723, 
    7724, 7725, 7726, 7727, 7728, 7729, 
    7730, 7731, 7732, 7733, 7734, 7735, 
    7736, 7737, 7738, 7739, 7740, 7741, 
    7742, 7743, 7744, 7745, 7746, 7747, 
    7748, 7749, 7750, 7751, 7752, 7753, 
    7754, 7755, 7756, 7757, 7758, 7759, 
    7760, 7761, 15950, 15951, 15952, 15953, 
    15954, 15955, 15956, 15957, 15958, 
    15959, 15960, 15961, 15962, 15963, 
    15964, 15965, 15966, 15459, 15460, 
    15461, 15462, 15463, 15464, 15465, 
    15466, 15467, 15468, 15469, 15470, 
    15471, 15472, 15473, 15474, 15475, 
    15476, 15477, 15478, 15479, 15480, 
    15481, 15482, 15488, 15489, 15490, 
    15486, 15487, 16435, 16436, 16437, 
    16438, 16439, 16440
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00231

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 103 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.image_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where