 |
|
|
EXPLAIN SELECT langsetid,langvars,langvals FROM dn051_language
WHERE langcache='1' AND langpackid='1' 0.00048EXPLAIN SELECT * FROM dn051_news WHERE catid = '24' ORDER BY newsid desc LIMIT 0,3 0.00012EXPLAIN SELECT * FROM dn051_news WHERE catid = '9' ORDER BY newsid desc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '21' ORDER BY date_post desc LIMIT 0,3 0.00008EXPLAIN SELECT * FROM dn051_news WHERE catid = '19' ORDER BY newsid asc LIMIT 0,3 0.00009EXPLAIN SELECT * FROM dn051_news WHERE catid = '23' ORDER BY date_post asc LIMIT 0,3 0.00009EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00009EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00009EXPLAIN SELECT * FROM dn051_news WHERE catid = '18' ORDER BY newsid DESC LIMIT 0,3 0.00009EXPLAIN SELECT * FROM dn051_news WHERE catid = '20' ORDER BY date_post asc LIMIT 0,3 0.00010EXPLAIN SELECT * FROM dn051_news WHERE catid = '13' ORDER BY date_post asc LIMIT 0,3 0.00028EXPLAIN SELECT * FROM dn051_news WHERE catid = '16' ORDER BY newsid desc LIMIT 0,3 0.00009EXPLAIN SELECT down.downid,down.public,down.cpu,down.title,down.textshort,
down.image_thumb,down.image_align,down.image_alt,cat.catid,cat.catcpu,cat.catname,cat.icon
FROM dn051_down AS down LEFT JOIN dn051_down_cat AS cat ON (down.catid = cat.catid)
WHERE act='yes' AND (stpublic=0 OR stpublic<'1280437495') AND (unpublic=0 OR unpublic>'1280437495')
ORDER BY public DESC LIMIT 5 0.02439EXPLAIN SELECT art.artid,art.public,art.cpu,art.title,cat.catid,cat.catcpu,cat.catname,cat.icon
FROM dn051_article AS art LEFT JOIN dn051_article_cat AS cat ON (art.catid = cat.catid)
WHERE act='yes' ORDER BY public DESC LIMIT 5 0.00054
Новости
