SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.000997s ]
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(82,83,84,24) AND `jiangshi`.`usuacity` like '%山东省/济南%' ) [ RunTime:0.000637s ]
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(82,83,84,24) AND `jiangshi`.`usuacity` like '%山东省/济南%' ) ORDER BY `neixun`.`listorder` DESC LIMIT 0,20 [ RunTime:0.000620s ]
SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.000731s ]
SELECT * FROM `yzn_jiangshi` WHERE ( `status`=1 AND `catid` = 12 ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.001190s ]
SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.000686s ]
SELECT * FROM `yzn_gkk` WHERE ( `status`=1 AND `catid` = 31 ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.000401s ]
鲍明忠
