SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.000701s ]
UPDATE `yzn_jiangshi` SET `hits` = `hits` + 1 WHERE `id` = 20 [ RunTime:0.003270s ]
SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.000576s ]
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) AND `relateteacher` = 20 ) ORDER BY `listorder` DESC LIMIT 0,100 [ RunTime:0.000941s ]
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 `listorder` DESC LIMIT 0,20 [ RunTime:0.000913s ]
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.000875s ]
SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.000526s ]
SELECT * FROM `yzn_gkk` WHERE ( `status`=1 AND `catid` = 31 ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.000375s ]