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.detailed_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 (
    7694, 
    7695, 
    7696, 
    7697, 
    7698, 
    7699, 
    7700, 
    7701, 
    7702, 
    7703, 
    7704, 
    7705, 
    7706, 
    7707, 
    7708, 
    7709, 
    7710, 
    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, 
    7762, 
    7763, 
    7764, 
    7765, 
    7766, 
    7767, 
    7768, 
    7769, 
    7770, 
    7771, 
    7772, 
    7773, 
    7774, 
    7775, 
    7776, 
    7777, 
    7778, 
    15950, 
    15951, 
    15952, 
    15953, 
    15954, 
    15955, 
    15956, 
    15957, 
    15958, 
    15959, 
    15960, 
    15961, 
    15962, 
    15963, 
    15964, 
    15965, 
    15966, 
    16401, 
    16402, 
    16403, 
    16404, 
    16405, 
    16406, 
    16407, 
    16408, 
    16409, 
    16410, 
    16411, 
    16412, 
    16413, 
    16414, 
    16415, 
    16416, 
    16417, 
    7660, 
    7661, 
    7662, 
    7663, 
    7664, 
    15930, 
    7665, 
    7666, 
    7667, 
    15927, 
    15928, 
    15929, 
    23793, 
    23794, 
    23795, 
    23796, 
    23797, 
    23798, 
    23799, 
    23800, 
    23801, 
    23802, 
    23803, 
    23804, 
    23805, 
    23806
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00312

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 145 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_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