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 (
    127384, 127385, 127536, 127537, 127832, 
    127833, 127934, 127935, 127942, 127943, 
    127944, 127945, 127946, 127947, 127948, 
    127949, 127950, 127951, 127952, 127953, 
    128818, 128819, 128832, 128833, 129084, 
    129085, 129086, 129087, 129088, 129089, 
    129090, 129091, 129092, 129093, 129094, 
    129095, 129096, 129097, 129098, 129099, 
    129100, 129101, 129102, 129103, 129104, 
    129105, 129106, 129107, 129108, 129109, 
    129110, 129111, 129112, 129113, 129114, 
    129115, 129116, 129117, 129118, 129119, 
    129120, 129121, 129122, 129123, 129124, 
    129125, 129126, 129127, 129128, 129129, 
    129130, 129131, 129132, 129133, 129134, 
    129135, 129136, 129137, 129138, 129139
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00077

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