SHOW FULL COLUMNS FROM `_tsginfo` [ RunTime:0.003938s ]
SELECT `diqu`,`json_name`,`diqu_name`,`tsgName`,`pv`,`islogin`,`url`,`libcss` FROM `_tsginfo` WHERE `tsgNum` = '0202' LIMIT 1 [ RunTime:0.000566s ]
SHOW FULL COLUMNS FROM `_tsg_zylist` [ RunTime:0.003598s ]
SELECT GROUP_CONCAT(zyType) as zy FROM `_tsg_zylist` WHERE `libnum` = '0202' LIMIT 1 [ RunTime:0.000797s ]
SHOW FULL COLUMNS FROM `_tsg_datalist` [ RunTime:0.003303s ]
SELECT taskYear,sum(num) as issue_sum FROM `_tsg_datalist` WHERE `dataType` = '300' AND `libnum` = '0202' GROUP BY `taskYear` ORDER BY `taskYear` [ RunTime:0.000880s ]
SELECT dataType,sum(num) as issue_sum FROM `_tsg_datalist` WHERE `libnum` = '0202' GROUP BY `dataType` ORDER BY `dataType` [ RunTime:0.000875s ]
SHOW FULL COLUMNS FROM `type_grain` [ RunTime:0.003200s ]
SELECT `typeName` FROM `type_grain` WHERE `data_type` = '300' ORDER BY `id` [ RunTime:0.018756s ]
泰达图书馆 