EXPLAIN SELECT langsetid,langvars,langvals FROM dn051_language
WHERE langcache='1' AND langpackid='1' 0.00026
EXPLAIN SELECT * FROM dn051_news WHERE catid = '24' ORDER BY newsid desc LIMIT 0,3 0.00015
EXPLAIN SELECT * FROM dn051_news WHERE catid = '9' ORDER BY newsid desc LIMIT 0,3 0.00012
EXPLAIN SELECT * FROM dn051_news WHERE catid = '21' ORDER BY date_post desc LIMIT 0,3 0.00008
EXPLAIN SELECT * FROM dn051_news WHERE catid = '19' ORDER BY newsid asc LIMIT 0,3 0.00013
EXPLAIN SELECT * FROM dn051_news WHERE catid = '23' ORDER BY date_post asc LIMIT 0,3 0.00009
EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00009
EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00014
EXPLAIN SELECT * FROM dn051_news WHERE catid = '18' ORDER BY newsid DESC LIMIT 0,3 0.00009
EXPLAIN SELECT * FROM dn051_news WHERE catid = '20' ORDER BY date_post asc LIMIT 0,3 0.00010
EXPLAIN SELECT * FROM dn051_news WHERE catid = '13' ORDER BY date_post asc LIMIT 0,3 0.00009
EXPLAIN SELECT * FROM dn051_news WHERE catid = '16' ORDER BY newsid desc LIMIT 0,3 0.00008
EXPLAIN SELECT * FROM dn051_news_cat WHERE catid='13' 0.00033
EXPLAIN SELECT newsid,public,cpu,title,textshort,image_thumb,image_align,image_alt,comments FROM dn051_news
WHERE catid='13' AND act='yes' AND (stpublic=0 OR stpublic<'1268211415') AND (unpublic=0 OR unpublic>'1268211415')
ORDER BY public desc LIMIT 0,40 0.00046
EXPLAIN SELECT catid,parentid,catcpu,catname,
catdesc,icon,total FROM dn051_news_cat
ORDER BY posit ASC 0.00010
EXPLAIN SELECT COUNT(newsid) AS total,
SUM(hits) AS hits FROM dn051_news
WHERE act='yes' AND (stpublic=0 OR stpublic<'1268211415')
AND (unpublic=0 OR unpublic>'1268211415') 0.01075
EXPLAIN SELECT COUNT(newsid) AS total FROM dn051_news WHERE catid='13' AND act='yes' AND (stpublic=0 OR stpublic<'1268211415') AND (unpublic=0 OR unpublic>'1268211415') 0.00035
Новости
