SHOW FULL COLUMNS FROM `yzn_jiangshi` [ RunTime:0.000689s ]
UPDATE `yzn_jiangshi` SET `hits` = `hits` + 1 WHERE `id` = 20 [ RunTime:0.003072s ]
SELECT `jiangshi`.*,`jiangshi_data`.* FROM `yzn_jiangshi` `jiangshi` LEFT JOIN `yzn_jiangshi_data` `jiangshi_data` ON `jiangshi`.`id`=`jiangshi_data`.`did` WHERE `catid` = 12 AND `id` = 20 LIMIT 1 [ RunTime:0.000447s ]
SHOW FULL COLUMNS FROM `yzn_neixun` [ RunTime:0.000593s ]
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.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 `listorder` DESC LIMIT 0,20 [ RunTime:0.000995s ]
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.000911s ]
SHOW FULL COLUMNS FROM `yzn_gkk` [ RunTime:0.000542s ]
SELECT * FROM `yzn_gkk` WHERE ( `status`=1 AND `catid` = 31 ) ORDER BY `hits` DESC LIMIT 0,15 [ RunTime:0.000366s ]
