SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.000721s ]
SELECT COUNT(*) AS think_count FROM `yzn_gkk` `gkk` LEFT JOIN `yzn_jiangshi` `jiangshi` ON `gkk`.`relateteacher`=`jiangshi`.`id` WHERE ( `gkk`.`status`=1 AND `gkk`.`catid` = 31 ) [ RunTime:0.000436s ]
SELECT gkk.title AS ntitle,gkk.description AS ndesc,`gkk`.`listorder`,`gkk`.`id`,`gkk`.`catid`,`gkk`.`url`,`gkk`.`tags`,`gkk`.`relateteacher`,`gkk`.`startregion`,`gkk`.`timestart`,`gkk`.`shichang`,`gkk`.`price`,`jiangshi`.`title`,`jiangshi`.`thumb`,`jiangshi`.`teatag`,`jiangshi`.`usuacity`,`jiangshi`.`description` FROM `yzn_gkk` `gkk` LEFT JOIN `yzn_jiangshi` `jiangshi` ON `gkk`.`relateteacher`=`jiangshi`.`id` WHERE ( `gkk`.`status`=1 AND `gkk`.`catid` = 31 ) ORDER BY `gkk`.`listorder` DESC LIMIT 0,20 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.000664s ]
SELECT * FROM `yzn_jiangshi` WHERE ( `status`=1 AND `catid` = 12 ) ORDER BY `listorder` DESC LIMIT 0,10 [ RunTime:0.000953s ]
SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.000561s ]
SELECT * FROM `yzn_neixun` WHERE ( `status`=1 AND `catid` in(14,25,26,27,15,28,29,30,16,36,37,38,39,40,41,42,43,44,45,17,46,47,48,49,18,50,51,52,53,54,55,56,19,57,58,59,60,61,20,62,63,64,65,66,67,21,68,69,70,71,22,72,73,74,75,76,23,77,78,79,80,81,24,82,83,84,85,86,87,88,92,90,91,13) ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.000963s ]
