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.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 (
    127190, 127191, 127192, 127193, 127194, 
    127195, 127196, 127197, 127198, 127199, 
    127200, 127201, 127204, 127205, 127206, 
    127207, 127208, 127209, 127268, 127269, 
    128478, 128479, 128480, 128481, 128482, 
    128483, 128484, 128485, 128486, 128487, 
    128488, 128489, 128490, 128491, 128492, 
    128493, 128494, 128495, 128496, 128497, 
    128498, 128499, 128500, 128501, 128502, 
    128503, 128504, 128505, 128506, 128507, 
    128508, 128509, 128510, 128511, 128512, 
    128513, 128514, 128515, 128516, 128517, 
    128518, 128519, 128520, 128521, 128522, 
    128523, 128524, 128525, 128526, 128527, 
    128528, 128529, 128530, 128531, 128532, 
    128533, 128534, 128535, 128536, 128537
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00104

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 80 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 4 toolboxdigitalshop_dev.cscart_images_links.detailed_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where