SHOW FULL COLUMNS FROM `_tsginfo` [ RunTime:0.003883s ]
SELECT `diqu`,`json_name`,`diqu_name`,`tsgName`,`pv`,`islogin`,`url`,`libcss` FROM `_tsginfo` WHERE `tsgNum` = '3200' LIMIT 1 [ RunTime:0.000732s ]
SHOW FULL COLUMNS FROM `_tsg_zylist` [ RunTime:0.003408s ]
SELECT GROUP_CONCAT(zyType) as zy FROM `_tsg_zylist` WHERE `libnum` = '3200' LIMIT 1 [ RunTime:0.000840s ]
update _tsginfo set pv = pv +1 where tsgNum = '3200' [ RunTime:0.002852s ]
SHOW FULL COLUMNS FROM `_tsg_booklist` [ RunTime:0.005085s ]
SELECT COUNT(*) AS think_count FROM `_tsg_booklist` WHERE `libnum` = '3200' AND `datastate` <> -1 AND `zytype` = '100' LIMIT 1 [ RunTime:0.005653s ]
SELECT `id`,`bag`,`title`,`contributor`,`publisher`,`dateOfPublication`,`volnum`,`location`,`img`,`star` FROM `_tsg_booklist` WHERE `libnum` = '3200' AND `datastate` <> -1 AND `zytype` = '100' ORDER BY `id` LIMIT 0,15 [ RunTime:0.008409s ]
SELECT taskyear,count(taskyear) as num FROM `_tsg_booklist` WHERE `libnum` = '3200' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `taskyear` ORDER BY `taskyear` [ RunTime:0.006311s ]
SELECT type,count(type) as num FROM `_tsg_booklist` WHERE `libnum` = '3200' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `type` ORDER BY `type` [ RunTime:0.006531s ]