view_video.php use more cpu as it is most viewed page on the site. If you want to limit mysql usage on this page, you may need to remove some features like related video.

You may also try enabling cache in admin area, this cache sql results, may reduce cpu usage slightly.