SHOW FULL COLUMNS FROM `_tsg_booklist` [ RunTime:0.005056s ]
SELECT COUNT(*) AS think_count FROM `_tsg_booklist` WHERE `libnum` = '0219' AND `datastate` <> -1 AND `zytype` = '110' LIMIT 1 [ RunTime:0.005493s ]
SELECT `id`,`bag`,`title`,`contributor`,`publisher`,`dateOfPublication`,`volnum`,`location`,`img`,`star` FROM `_tsg_booklist` WHERE `libnum` = '0219' AND `datastate` <> -1 AND `zytype` = '110' ORDER BY `id` LIMIT 0,15 [ RunTime:0.009220s ]
SELECT taskyear,count(taskyear) as num FROM `_tsg_booklist` WHERE `libnum` = '0219' AND `datastate` <> -1 AND `zytype` = '110' GROUP BY `taskyear` ORDER BY `taskyear` [ RunTime:0.006731s ]
SELECT type,count(type) as num FROM `_tsg_booklist` WHERE `libnum` = '0219' AND `datastate` <> -1 AND `zytype` = '110' GROUP BY `type` ORDER BY `type` [ RunTime:0.005862s ]