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 (
    126234, 126235, 126236, 126237, 126238, 
    126239, 126240, 126241, 126242, 126243, 
    126244, 126245, 126246, 126247, 126248, 
    126249, 126250, 126251, 126252, 126253, 
    126254, 126255, 126256, 126257, 126258, 
    126259, 126260, 126261, 126262, 126263, 
    126264, 126265, 126266, 126267, 126268, 
    126269, 126270, 126271, 126272, 126273, 
    128000, 128001, 128268, 128269, 128580, 
    128581, 128592, 128593, 128792, 128793, 
    129258, 129259, 129262, 129263, 129362, 
    129363, 129380, 129381, 129422, 129423, 
    129452, 129453, 129456, 129457, 129476, 
    129477, 129562, 129563, 129566, 129567, 
    129568, 129569, 129570, 129571, 129778, 
    129779, 129780, 129781, 129782, 129783
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00044

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.image_id 1
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 108 toolboxdigitalshop_dev.cscart_images.image_id,const,const 1 Using where