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 (
    165248, 165249, 165348, 165349, 165350, 
    165351, 165352, 165353, 165354, 165355, 
    165414, 165415, 165586, 165587, 165956, 
    165957, 166036, 166037, 166038, 166039, 
    166046, 166047, 166048, 166049, 166050, 
    166051, 166052, 166053, 166054, 166055, 
    166056, 166057, 166058, 166059, 166060, 
    166061, 166062, 166063, 166064, 166065, 
    166166, 166167, 166648, 166649, 166650, 
    166651, 166652, 166653, 166654, 166655, 
    166656, 166657, 166658, 166659, 166898, 
    166899, 166900, 166901, 166902, 166903, 
    166982, 166983, 166984, 166985, 166986, 
    166987, 167080, 167081, 167082, 167083, 
    167084, 167085, 167086, 167087, 167088, 
    167089, 167090, 167091, 167092, 167093
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00051

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