 |
|
|
EXPLAIN SELECT langsetid,langvars,langvals FROM dn051_language
WHERE langcache='1' AND langpackid='1' 0.00026EXPLAIN SELECT * FROM dn051_news WHERE catid = '24' ORDER BY newsid desc LIMIT 0,3 0.00018EXPLAIN SELECT * FROM dn051_news WHERE catid = '9' ORDER BY newsid desc LIMIT 0,3 0.00013EXPLAIN SELECT * FROM dn051_news WHERE catid = '21' ORDER BY date_post desc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '19' ORDER BY newsid asc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '23' ORDER BY date_post asc LIMIT 0,3 0.00012EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00011EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00011EXPLAIN SELECT * FROM dn051_news WHERE catid = '18' ORDER BY newsid DESC LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '20' ORDER BY date_post asc LIMIT 0,3 0.00011EXPLAIN SELECT * FROM dn051_news WHERE catid = '13' ORDER BY date_post asc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '16' ORDER BY newsid desc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_mods WHERE active='yes' AND mod_fold!='map' AND mod_fold!='info' AND mod_fold!='user' ORDER BY mod_posit 0.02223EXPLAIN SELECT * FROM dn051_article_cat WHERE parentid='0' 0.02133EXPLAIN SELECT * FROM dn051_news_cat WHERE parentid='0' 0.00042EXPLAIN SELECT * FROM dn051_polling WHERE poll_act='yes' AND poll_finish > '1268168400' ORDER BY poll_start DESC LIMIT 5 0.00916EXPLAIN SELECT * FROM dn051_link_cat WHERE parentid='0' 0.00396