Sandbox

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 (
    24304, 
    24305, 
    15775, 
    15776, 
    21889, 
    21888, 
    22389, 
    22390, 
    22391, 
    22392, 
    22393, 
    22394, 
    22395, 
    22396, 
    22397, 
    22429, 
    22430, 
    22431, 
    22432, 
    22433, 
    22434, 
    22435, 
    22451, 
    22452, 
    22474, 
    22475, 
    23687, 
    23603, 
    21406, 
    21407, 
    21409, 
    21410, 
    21411, 
    21412, 
    21413, 
    21414, 
    21415, 
    21418, 
    21419, 
    21421, 
    21422, 
    21473, 
    21474, 
    21476, 
    21477, 
    21478, 
    21479, 
    21480, 
    21481, 
    21482, 
    21485, 
    21486, 
    21488, 
    21489, 
    19636, 
    19638, 
    19639, 
    19640, 
    19641, 
    19642, 
    19637, 
    15792, 
    15793, 
    15794, 
    15795, 
    15796, 
    15797, 
    15798, 
    15799, 
    15800, 
    15801, 
    15802, 
    15803, 
    15804, 
    15805, 
    15806, 
    15807, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    22398, 
    22399, 
    22400, 
    22401, 
    22402, 
    22403, 
    22404, 
    22405, 
    22406, 
    22407, 
    22408, 
    22409, 
    22410, 
    22411, 
    22412, 
    22413, 
    22414, 
    22415, 
    22416, 
    22417, 
    22418, 
    22419, 
    22420, 
    22421, 
    22422, 
    22423, 
    22424, 
    22425, 
    22426, 
    22427, 
    22459, 
    22460, 
    22462, 
    22463, 
    22465, 
    22466, 
    22467, 
    22469, 
    22470, 
    22471, 
    22472, 
    22473, 
    23587, 
    23588, 
    23589, 
    23590, 
    23591, 
    23688, 
    23592, 
    23593, 
    23594, 
    23595, 
    23596, 
    23597, 
    23598, 
    23599, 
    23673, 
    23674, 
    23675, 
    23676, 
    23677, 
    23678, 
    23679, 
    23680, 
    23681, 
    23682, 
    23683, 
    23684, 
    22442, 
    22443, 
    22444
  ) 
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		162	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

Result

pair_id	object_id	object_type	image_id	type
27592	15775	variant_image	23167	V
27593	15776	variant_image	23168	V
30529	21888	variant_image	26106	V
30530	21889	variant_image	26107	V
30789	22396	variant_image	26367	V
30790	22397	variant_image	26368	V