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 (
    18411, 
    18412, 
    18425, 
    18413, 
    18414, 
    18424, 
    18415, 
    18416, 
    18417, 
    18418, 
    18419, 
    18420, 
    18421, 
    18422, 
    18423, 
    19656, 
    19657, 
    19670, 
    19658, 
    19659, 
    19669, 
    19660, 
    19661, 
    19662, 
    19668, 
    19663, 
    19664, 
    19665, 
    19666, 
    19667, 
    19712, 
    19713, 
    19726, 
    19714, 
    19715, 
    19725, 
    19716, 
    19717, 
    19718, 
    19724, 
    19719, 
    19720, 
    19721, 
    19722, 
    19723, 
    22429, 
    22430, 
    22431, 
    22432, 
    22433, 
    22434, 
    22435, 
    23687, 
    23904, 
    23905, 
    23906, 
    23907, 
    23908, 
    23909, 
    23910, 
    23911, 
    23912, 
    23913, 
    23914, 
    23915, 
    23916, 
    23917, 
    23918, 
    24286, 
    24285, 
    24284, 
    24283, 
    24276, 
    24275, 
    24277, 
    24282, 
    24281, 
    24280, 
    24279, 
    24278, 
    24274, 
    24288, 
    24287, 
    23603, 
    21252, 
    23816, 
    21256, 
    21257, 
    21258, 
    21259, 
    21260, 
    21261, 
    21265, 
    21268, 
    21473, 
    21474, 
    21476, 
    21477, 
    21478, 
    21479, 
    21480, 
    21481, 
    21482, 
    21485, 
    21486, 
    21488, 
    21489, 
    23849, 
    23853, 
    23854, 
    23855, 
    23883, 
    23884, 
    23859, 
    19636, 
    19638, 
    19639, 
    19640, 
    19641, 
    19642, 
    19637, 
    22413, 
    22414, 
    22415, 
    22416, 
    22417, 
    22418, 
    22419, 
    22420, 
    22421, 
    22422, 
    22423, 
    22424, 
    22425, 
    22426, 
    22427, 
    23587, 
    23588, 
    23589, 
    23590, 
    23591, 
    23688, 
    23592, 
    23593, 
    23594, 
    23595, 
    23596, 
    23597, 
    23598, 
    23599, 
    23673, 
    23674, 
    23675, 
    23676, 
    23677, 
    23678, 
    23679, 
    23680, 
    23681, 
    23682, 
    23683, 
    23684
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00356

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 162 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