 |
|
|
EXPLAIN SELECT langsetid,langvars,langvals FROM dn051_language
WHERE langcache='1' AND langpackid='1' 0.00022EXPLAIN SELECT * FROM dn051_news WHERE catid = '24' ORDER BY newsid desc LIMIT 0,3 0.00320EXPLAIN SELECT * FROM dn051_news WHERE catid = '9' ORDER BY newsid desc LIMIT 0,3 0.00039EXPLAIN SELECT * FROM dn051_news WHERE catid = '21' ORDER BY date_post desc LIMIT 0,3 0.00028EXPLAIN SELECT * FROM dn051_news WHERE catid = '19' ORDER BY newsid asc LIMIT 0,3 0.00199EXPLAIN SELECT * FROM dn051_news WHERE catid = '23' ORDER BY date_post asc LIMIT 0,3 0.00416EXPLAIN SELECT * FROM dn051_news WHERE catid = '17' ORDER BY newsid desc LIMIT 0,3 0.00066EXPLAIN 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.00027EXPLAIN SELECT * FROM dn051_news WHERE catid = '20' ORDER BY date_post asc LIMIT 0,3 0.00243EXPLAIN SELECT * FROM dn051_news WHERE catid = '13' ORDER BY date_post asc LIMIT 0,3 0.00158EXPLAIN SELECT * FROM dn051_news WHERE catid = '16' ORDER BY newsid desc LIMIT 0,3 0.00714EXPLAIN DELETE FROM dn051_subscribe_users WHERE subactive='0' AND regtime < 1279831959 0.00984