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 (
    93862, 
    93863, 
    93896, 
    93897, 
    93966, 
    93967, 
    93980, 
    93981, 
    93982, 
    93983, 
    93984, 
    93985, 
    93986, 
    93987, 
    93988, 
    93989, 
    94072, 
    94073, 
    94074, 
    94075, 
    94078, 
    94079, 
    94080, 
    94081, 
    94092, 
    94093, 
    94094, 
    94095, 
    94096, 
    94097, 
    94098, 
    94099, 
    94146, 
    94147, 
    94148, 
    94149, 
    94150, 
    94151, 
    94162, 
    94163, 
    94172, 
    94173, 
    94178, 
    94179, 
    94180, 
    94181, 
    94182, 
    94183, 
    94222, 
    94223, 
    94226, 
    94227, 
    94298, 
    94299, 
    94300, 
    94301, 
    94302, 
    94303, 
    94304, 
    94305, 
    94320, 
    94321, 
    94322, 
    94323, 
    94354, 
    94355, 
    94362, 
    94363, 
    94374, 
    94375, 
    94376, 
    94377, 
    94378, 
    94379, 
    94414, 
    94415, 
    94416, 
    94417, 
    94418, 
    94419, 
    94420, 
    94421, 
    94442, 
    94443, 
    94444, 
    94445, 
    94460, 
    94461, 
    94514, 
    94515, 
    94516, 
    94517, 
    94518, 
    94519, 
    94520, 
    94521, 
    94522, 
    94523, 
    94524, 
    94525, 
    94526, 
    94527, 
    94528, 
    94529, 
    94530, 
    94531, 
    94532, 
    94533, 
    94534, 
    94535, 
    94536, 
    94537, 
    94538, 
    94539, 
    94540, 
    94541, 
    94542, 
    94543, 
    94544, 
    94545, 
    94546, 
    94547, 
    94548, 
    94549, 
    94550, 
    94551, 
    94560, 
    94561, 
    94576, 
    94577, 
    94578, 
    94579, 
    94580, 
    94581, 
    94582, 
    94583, 
    94616, 
    94617, 
    94670, 
    94671, 
    94672, 
    94673, 
    94674, 
    94675, 
    94676, 
    94677, 
    94748, 
    94749, 
    94846, 
    94847, 
    94848, 
    94849, 
    94958, 
    94959, 
    95058, 
    95059, 
    95060, 
    95061, 
    106822, 
    106823
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00093

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 160 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