SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.000578s ]
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` = 82 AND `jiangshi`.`usuacity` like '%山东省/济南%' ) [ RunTime:0.000428s ]
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` = 82 AND `jiangshi`.`usuacity` like '%山东省/济南%' ) ORDER BY `neixun`.`listorder` DESC LIMIT 0,20 [ RunTime:0.000443s ]
SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.000607s ]
SELECT * FROM `yzn_jiangshi` WHERE ( `status`=1 AND `catid` = 12 ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.000907s ]
SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.000558s ]
SELECT * FROM `yzn_gkk` WHERE ( `status`=1 AND `catid` = 31 ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.000364s ]
鲍明忠
