SHOW FULL COLUMNS FROM `_tsginfo` [ RunTime:0.004483s ]
SELECT `diqu`,`json_name`,`diqu_name`,`tsgName`,`pv`,`islogin`,`url`,`libcss` FROM `_tsginfo` WHERE `tsgNum` = '2606' LIMIT 1 [ RunTime:0.000750s ]
SHOW FULL COLUMNS FROM `_tsg_zylist` [ RunTime:0.003551s ]
SELECT GROUP_CONCAT(zyType) as zy FROM `_tsg_zylist` WHERE `libnum` = '2606' LIMIT 1 [ RunTime:0.000679s ]
update _tsginfo set pv = pv +1 where tsgNum = '2606' [ RunTime:0.002264s ]
SHOW FULL COLUMNS FROM `_tsg_booklist` [ RunTime:0.004686s ]
SELECT COUNT(*) AS think_count FROM `_tsg_booklist` WHERE `libnum` = '2606' AND `datastate` <> -1 AND `zytype` = '100' LIMIT 1 [ RunTime:0.005455s ]
SELECT `id`,`bag`,`title`,`contributor`,`publisher`,`dateOfPublication`,`volnum`,`location`,`img`,`star` FROM `_tsg_booklist` WHERE `libnum` = '2606' AND `datastate` <> -1 AND `zytype` = '100' ORDER BY `id` LIMIT 0,15 [ RunTime:0.008913s ]
SELECT taskyear,count(taskyear) as num FROM `_tsg_booklist` WHERE `libnum` = '2606' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `taskyear` ORDER BY `taskyear` [ RunTime:0.006141s ]
SELECT type,count(type) as num FROM `_tsg_booklist` WHERE `libnum` = '2606' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `type` ORDER BY `type` [ RunTime:0.005985s ]