SHOW FULL COLUMNS FROM `_tsg_booklist` [ RunTime:0.004309s ]
SELECT COUNT(*) AS think_count FROM `_tsg_booklist` WHERE `libnum` = '3200' AND `datastate` <> -1 AND `zytype` = '100' LIMIT 1 [ RunTime:0.005636s ]
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 120,15 [ RunTime:0.008778s ]
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.006075s ]
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.006293s ]