SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.003259s ]
SELECT COUNT(*) AS think_count FROM `yzn_neixun` `neixun` LEFT JOIN `yzn_jiangshi` `jiangshi` ON `neixun`.`relateteacher`=`jiangshi`.`id` WHERE ( `neixun`.`status`=1 AND `neixun`.`catid` in(86,87,88,92,85) ) [ RunTime:0.003720s ]
SELECT neixun.title AS ntitle,neixun.description AS ndesc,`neixun`.`listorder`,`neixun`.`id`,`neixun`.`catid`,`neixun`.`url`,`neixun`.`tags`,`neixun`.`relateteacher`,`jiangshi`.`title`,`jiangshi`.`thumb`,`jiangshi`.`teatag`,`jiangshi`.`usuacity`,`jiangshi`.`description` FROM `yzn_neixun` `neixun` LEFT JOIN `yzn_jiangshi` `jiangshi` ON `neixun`.`relateteacher`=`jiangshi`.`id` WHERE ( `neixun`.`status`=1 AND `neixun`.`catid` in(86,87,88,92,85) ) ORDER BY `neixun`.`listorder` DESC LIMIT 60,20 [ RunTime:0.002799s ]
SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.009365s ]
SELECT * FROM `yzn_jiangshi` WHERE ( `status`=1 AND `catid` = 12 ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.002493s ]
SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.014568s ]
SELECT * FROM `yzn_gkk` WHERE ( `status`=1 AND `catid` = 31 ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.019425s ]