 |
|
|
EXPLAIN SELECT langsetid,langvars,langvals FROM dn051_language
WHERE langcache='1' AND langpackid='1' 0.00019EXPLAIN SELECT * FROM dn051_news WHERE catid = '24' ORDER BY newsid desc LIMIT 0,3 0.00227EXPLAIN SELECT * FROM dn051_news WHERE catid = '9' ORDER BY newsid desc LIMIT 0,3 0.00023EXPLAIN SELECT * FROM dn051_news WHERE catid = '21' ORDER BY date_post desc LIMIT 0,3 0.00019EXPLAIN SELECT * FROM dn051_news WHERE catid = '19' ORDER BY newsid asc LIMIT 0,3 0.00140EXPLAIN SELECT * FROM dn051_news WHERE catid = '23' ORDER BY date_post asc LIMIT 0,3 0.00332EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00053EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00008EXPLAIN SELECT * FROM dn051_news WHERE catid = '18' ORDER BY newsid DESC LIMIT 0,3 0.00025EXPLAIN SELECT * FROM dn051_news WHERE catid = '20' ORDER BY date_post asc LIMIT 0,3 0.00227EXPLAIN SELECT * FROM dn051_news WHERE catid = '13' ORDER BY date_post asc LIMIT 0,3 0.00135EXPLAIN SELECT * FROM dn051_news WHERE catid = '16' ORDER BY newsid desc LIMIT 0,3 0.00659EXPLAIN SELECT p.*,SUM(v.vals_voices) AS total FROM dn051_polling p
LEFT JOIN dn051_polling_vals AS v ON (p.pollid=v.pollid)
WHERE p.poll_finish > '1280437219' AND p.poll_act='yes'
GROUP BY p.pollid DESC LIMIT 0,10 0.04327
Новости
