SHOW FULL COLUMNS FROM `_tsg_booklist` [ RunTime:0.004667s ]
SELECT COUNT(*) AS think_count FROM `_tsg_booklist` WHERE `libnum` = '1129' AND `datastate` <> -1 AND `zytype` = '100' LIMIT 1 [ RunTime:0.005806s ]
SELECT `id`,`bag`,`title`,`contributor`,`publisher`,`dateOfPublication`,`volnum`,`location`,`img`,`star` FROM `_tsg_booklist` WHERE `libnum` = '1129' AND `datastate` <> -1 AND `zytype` = '100' ORDER BY `id` LIMIT 0,15 [ RunTime:0.004189s ]
SELECT taskyear,count(taskyear) as num FROM `_tsg_booklist` WHERE `libnum` = '1129' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `taskyear` ORDER BY `taskyear` [ RunTime:0.006245s ]
SELECT type,count(type) as num FROM `_tsg_booklist` WHERE `libnum` = '1129' AND `datastate` <> -1 AND `zytype` = '100' GROUP BY `type` ORDER BY `type` [ RunTime:0.006472s ]