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 (
    20505, 
    20500, 
    20501, 
    20502, 
    20503, 
    20504, 
    18321, 
    18322, 
    18323, 
    18324, 
    18325, 
    18326, 
    18327, 
    18328, 
    18329, 
    18330, 
    18331, 
    18332, 
    18334, 
    18335, 
    18336, 
    18411, 
    18412, 
    18425, 
    18413, 
    18414, 
    18424, 
    18415, 
    18416, 
    18417, 
    18418, 
    18419, 
    18420, 
    18421, 
    18422, 
    18423, 
    19656, 
    19657, 
    19670, 
    19658, 
    19659, 
    19669, 
    19660, 
    19661, 
    19662, 
    19668, 
    19663, 
    19664, 
    19665, 
    19666, 
    19667, 
    19688, 
    19689, 
    19702, 
    19690, 
    19691, 
    19701, 
    19692, 
    19693, 
    19694, 
    19700, 
    19695, 
    19696, 
    19697, 
    19698, 
    19699, 
    19712, 
    19713, 
    19726, 
    19714, 
    19715, 
    19725, 
    19716, 
    19717, 
    19718, 
    19724, 
    19719, 
    19720, 
    19721, 
    19722, 
    19723, 
    19808, 
    19809, 
    19822, 
    19810, 
    19811, 
    19821, 
    19812, 
    19813, 
    19814, 
    19815, 
    19816, 
    19817, 
    19823, 
    19818, 
    19819, 
    19820, 
    19936, 
    19937, 
    19950, 
    19938, 
    19939, 
    19949, 
    19940, 
    19941, 
    19942, 
    19943, 
    19944, 
    19945, 
    19946, 
    19947, 
    23904, 
    23905, 
    23906, 
    23907, 
    23908, 
    23909, 
    23910, 
    23911, 
    23912, 
    23913, 
    23914, 
    23915, 
    23916, 
    23917, 
    23918, 
    24286, 
    24285, 
    24284, 
    24283, 
    24276, 
    24275, 
    24277, 
    24282, 
    24281, 
    24280, 
    24279, 
    24278, 
    24274, 
    24288, 
    24287, 
    20386, 
    20388, 
    20390, 
    20476, 
    20477, 
    20478, 
    20479, 
    20480, 
    20481, 
    20482, 
    20483, 
    20484, 
    20485, 
    20487, 
    20488, 
    20489, 
    20490, 
    20491, 
    20492, 
    20493, 
    20494, 
    20495, 
    20496, 
    20497, 
    20626, 
    20627, 
    20628, 
    20629, 
    20630, 
    20631, 
    20632, 
    20633, 
    20634, 
    20635, 
    20636, 
    20637, 
    20638, 
    20639, 
    20640, 
    20641, 
    20642, 
    20643, 
    20644, 
    20645, 
    20646, 
    20647
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00438

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