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 (
    103754, 103755, 104964, 104965, 105410, 
    105411, 105528, 105529, 105674, 105675, 
    105784, 105785, 105932, 105933, 106036, 
    106037, 106038, 106039, 106040, 106041, 
    106042, 106043, 106044, 106045, 106046, 
    106047, 106048, 106049, 106050, 106051, 
    106052, 106053, 106054, 106055, 106056, 
    106057, 106058, 106059, 106060, 106061, 
    106062, 106063, 106064, 106065, 106066, 
    106067, 106068, 106069, 106070, 106071, 
    106072, 106073, 106074, 106075, 106076, 
    106077, 106078, 106079, 106080, 106081, 
    106082, 106083, 106084, 106085, 106086, 
    106087, 106088, 106089, 106090, 106091, 
    106092, 106093, 106094, 106095, 106096, 
    106097, 106098, 106099, 106388, 106389
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00056

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