SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  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 (
    20724, 
    20725, 
    20726, 
    20728, 
    20729, 
    20730, 
    20731, 
    20732, 
    20733, 
    20738, 
    20739, 
    20742, 
    20743, 
    20834, 
    20835, 
    20836, 
    20837, 
    20838, 
    20839, 
    20840, 
    20841, 
    20842, 
    20843, 
    20844, 
    20845, 
    20846, 
    20847, 
    20848, 
    20849, 
    20850, 
    20851, 
    20852, 
    20853, 
    20854, 
    20966, 
    20967, 
    20968, 
    20969, 
    20970, 
    20971, 
    20972, 
    20973, 
    20974, 
    20975, 
    20978, 
    20979, 
    20980, 
    20981, 
    20982, 
    23837, 
    20984, 
    20985, 
    23838, 
    20988, 
    20989, 
    20990, 
    20991, 
    20992, 
    20993, 
    20994, 
    20995, 
    20996, 
    20997, 
    21000, 
    21001, 
    21002, 
    21003, 
    21004, 
    21032, 
    21033, 
    21034, 
    21036, 
    21037, 
    21038, 
    21039, 
    21040, 
    21041, 
    21045, 
    21046, 
    21047, 
    21050, 
    21051, 
    21054, 
    21055, 
    21056, 
    21057, 
    21058, 
    21059, 
    21060, 
    21061, 
    21062, 
    21063, 
    21066, 
    21067, 
    21068, 
    21069, 
    21070, 
    23840, 
    21072, 
    21073, 
    23839, 
    21495, 
    21496, 
    21498, 
    21499, 
    21500, 
    21501, 
    21502, 
    21503, 
    21504, 
    21507, 
    21508, 
    21510, 
    21511, 
    23827, 
    21234, 
    21235, 
    21236, 
    21237, 
    21238, 
    21239, 
    21243, 
    21246, 
    21165, 
    21166, 
    21168, 
    21169, 
    21170, 
    21171, 
    21172, 
    21173, 
    21176, 
    21177, 
    21178, 
    21179, 
    21180, 
    21181, 
    21183, 
    21209, 
    21210, 
    21212, 
    21213, 
    21214, 
    21215, 
    21216, 
    21217, 
    21220, 
    21221, 
    21222, 
    21223, 
    21224, 
    21225, 
    21227, 
    23824, 
    21344, 
    23825, 
    21346, 
    21347, 
    21348, 
    23826, 
    21353, 
    23828, 
    21432, 
    23829, 
    21434, 
    21435, 
    21436, 
    21437, 
    21441
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00350

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 169 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where