?

4 queries, seconds
SELECT * FROM _journals WHERE journal_id=1 = 1 (fetching journal info)
SELECT name,section_id FROM _sections WHERE journal_rid=1 AND hidden!=1 AND parent_section_rid=0 AND ( language="" OR language="en" ) ORDER BY ordering = 18 (fetching visible top sections)
SELECT art.article_id,art.title,art.intro,art.date,art.commentable,art.introincluded,art.watched, auth.name AS author_name, auth.email AS author_email, COUNT(comm.comment_id) AS commentnum FROM _articles AS art LEFT JOIN _authors AS auth ON auth.author_id=art.author_rid LEFT JOIN _comments AS comm ON comm.article_rid=art.article_id WHERE art.article_id=83 GROUP BY art.article_id = 1 (fetching article)
SELECT * FROM _comments WHERE article_rid=83 ORDER BY date ASC = 4 ()