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 (
    166822, 166823, 166826, 166827, 166830, 
    166831, 166878, 166879, 167178, 167179, 
    167180, 167181, 167182, 167183, 167240, 
    167241, 167242, 167243, 167244, 167245, 
    167246, 167247, 167248, 167249, 167250, 
    167251, 167252, 167253, 167254, 167255, 
    167256, 167257, 167258, 167259, 167260, 
    167261, 167262, 167263, 167264, 167265, 
    167266, 167267, 167268, 167269, 167270, 
    167271, 167272, 167273, 167652, 167653, 
    167658, 167659, 167660, 167661, 167780, 
    167781, 167804, 167805, 167806, 167807, 
    167808, 167809, 167810, 167811, 167872, 
    167873, 167874, 167875, 167876, 167877, 
    167964, 167965, 167970, 167971, 167972, 
    167973, 167974, 167975, 167978, 167979
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00045

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