?
6 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 * FROM _sections WHERE section_id=212 = 1 (fetching section)
SELECT art.article_id, art.title, art.photo, CHAR_LENGTH(art.intro) AS introcount, CHAR_LENGTH(art.text) AS textcount, art.date, art.commentable, art.date, artsec.expiry_date, auth.name AS author_name, COUNT(comm.comment_id) AS commentnum , sec.section_id 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 , _articlesections AS artsec, _sections AS sec WHERE artsec.article_rid = art.article_id AND sec.section_id = artsec.section_rid AND artsec.section_rid = 212 AND (art.language = 'en' OR art.language = '') AND ( artsec.expiry_date >= CURRENT_TIMESTAMP OR artsec.expiry_date < "1970-01-01" OR ( artsec.expiry_date IS NULL AND ( sec.default_expiry=0 OR sec.default_expiry IS NULL OR DATE_ADD(art.date, INTERVAL sec.default_expiry SECOND) >= CURRENT_TIMESTAMP ) ) ) GROUP BY art.article_id ORDER BY art.date DESC LIMIT 0,11 = 0 (fetching article list)
SELECT art.article_id,art.title,art.intro,LENGTH(art.text) AS text,DATE_FORMAT(art.date,"d-M-y, h:i a") AS date FROM _articles AS art, _articlesections AS artsec, _sections AS sec WHERE artsec.article_rid=art.article_id AND artsec.section_rid=sec.section_id AND sec.journal_rid=1 AND sec.name LIKE "%_NEWS_%" AND (sec.language='en' OR sec.language='') = 4 (fetching news boxes)
SELECT section_id,name FROM _sections WHERE journal_rid=1 AND parent_section_rid = 212 AND hidden=0 ORDER BY ordering = 4 (fetching subsection list)
