SHOW FULL COLUMNS FROM `_tsg_datalist` [ RunTime:0.003517s ]
SELECT taskYear,sum(num) as issue_sum FROM `_tsg_datalist` WHERE `dataType` = '300' AND `libnum` = '1103' GROUP BY `taskYear` ORDER BY `taskYear` [ RunTime:0.000679s ]
SELECT dataType,sum(num) as issue_sum FROM `_tsg_datalist` WHERE `libnum` = '1103' GROUP BY `dataType` ORDER BY `dataType` [ RunTime:0.000833s ]
SHOW FULL COLUMNS FROM `type_grain` [ RunTime:0.003132s ]
SELECT `typeName` FROM `type_grain` WHERE `data_type` = '300' ORDER BY `id` [ RunTime:0.019389s ]
温州市图书馆 