SHOW FULL COLUMNS FROM `navbar` [ RunTime:0.000601s ]
SELECT * FROM `navbar` WHERE `show` = 1 ORDER BY `orders` DESC LIMIT 7 [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `sorts` [ RunTime:0.000458s ]
SELECT `sortid`,`sortname`,`parentid`,`navbarid` FROM `sorts` WHERE `show` = 1 AND `is_navbar` = 1 AND `navbarid` IN (1,2,3,5,6,7,8) ORDER BY `orders` DESC [ RunTime:0.000270s ]
SHOW FULL COLUMNS FROM `class` [ RunTime:0.000424s ]
SELECT `classid`,`classname` FROM `class` WHERE `show` = 1 AND `navbarid` IN (1,2,3,5,6,7,8) ORDER BY `orders` DESC LIMIT 10 [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `news` [ RunTime:0.000449s ]
SELECT COUNT(*) AS think_count FROM `news` `n` INNER JOIN `sorts` `s` ON `n`.`sortid`=`s`.`sortid` WHERE `s`.`navbarid` = '7' [ RunTime:0.000997s ]
SELECT `n`.`newid`,`n`.`title`,`n`.`pic`,`n`.`descr`,`n`.`author`,`n`.`addtime` FROM `news` `n` INNER JOIN `sorts` `s` ON `n`.`sortid`=`s`.`sortid` WHERE `s`.`navbarid` = '7' ORDER BY `n`.`addtime` DESC LIMIT 130,10 [ RunTime:0.002016s ]
SHOW FULL COLUMNS FROM `activities` [ RunTime:0.000430s ]
SELECT `activitiid`,`title`,`pic`,`descr` FROM `activities` WHERE ( elite=1 ) AND ( status=1 ) ORDER BY `activitiid` DESC LIMIT 4 [ RunTime:0.000216s ]