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.image_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 (
    20439, 
    20432, 
    20433, 
    20434, 
    20435, 
    20436, 
    20437, 
    20438, 
    13994, 
    14010, 
    14002, 
    14033, 
    14024, 
    14005, 
    14025, 
    14021, 
    14028, 
    14003, 
    14011, 
    14012, 
    13998, 
    14000, 
    14032, 
    14027, 
    14034, 
    15545, 
    15546, 
    13248, 
    13270, 
    13249, 
    13271, 
    13250, 
    13272, 
    13251, 
    13273, 
    13252, 
    13274, 
    13253, 
    13275, 
    13254, 
    13276, 
    13255, 
    13277, 
    13256, 
    13278, 
    13257, 
    13279, 
    13258, 
    13280, 
    13882, 
    13260, 
    13282, 
    13261, 
    13283, 
    13262, 
    13284, 
    13263, 
    13285, 
    13264, 
    13286, 
    13265, 
    13287, 
    13266, 
    13288, 
    13267, 
    13289, 
    13268, 
    13290, 
    13269, 
    13291, 
    17546, 
    17547, 
    23902, 
    23903, 
    17551, 
    17552, 
    17554, 
    17555, 
    17556, 
    17558, 
    17559, 
    17561, 
    17562, 
    17563, 
    20406, 
    20407, 
    20408, 
    20409, 
    20410, 
    20411, 
    20412, 
    20413, 
    20416, 
    20417, 
    20418, 
    20419, 
    20420, 
    20421, 
    20422, 
    16185, 
    16186, 
    23726, 
    23927, 
    23725, 
    24011, 
    23727, 
    24012, 
    23728, 
    24010, 
    23729, 
    24013, 
    15410, 
    15411, 
    15429, 
    15412, 
    15413, 
    15414, 
    15415, 
    15416, 
    15417, 
    15418, 
    15419, 
    15420, 
    15421, 
    15422, 
    15423, 
    15424, 
    15425, 
    15426, 
    15427, 
    15428, 
    15104, 
    15105, 
    15553, 
    15106, 
    15107, 
    15554, 
    15108, 
    15109, 
    15110, 
    15111, 
    15112, 
    15113, 
    15114, 
    15115, 
    19555, 
    19556, 
    19558, 
    19550, 
    19549, 
    19559, 
    19553, 
    23730, 
    23731, 
    23732, 
    23733, 
    23734, 
    23735, 
    23736, 
    23737, 
    23738, 
    23739, 
    23740, 
    23741, 
    23742, 
    23743, 
    23744, 
    23745, 
    23746, 
    23747, 
    23748, 
    23749, 
    20536, 
    20537, 
    20538, 
    20539, 
    20540, 
    20541, 
    20542, 
    20543, 
    20544, 
    20545, 
    20546, 
    20547, 
    20548, 
    20549, 
    20550, 
    20551, 
    20552, 
    20553, 
    20554, 
    20555, 
    20556, 
    20557, 
    13652, 
    13654, 
    13657
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00433

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		197	Using index condition; Using filesort
1	SIMPLE	cscart_images	eq_ref	PRIMARY	PRIMARY	3	mahm3t_cs443.cscart_images_links.image_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