SHOW FULL COLUMNS FROM `libraryList` [ RunTime:0.004242s ]
SELECT `lib_name`,`lib_table`,`lib_custom` FROM `libraryList` WHERE `lib_num` = '1003' LIMIT 1 [ RunTime:0.008968s ]
SHOW FULL COLUMNS FROM `hd_paperList` [ RunTime:0.004165s ]
SELECT paperList.id,pName.paper_name,paperList.record_id,paperList.pub_date,DATE_FORMAT(paperList.pub_date,'%Y%m%d') as vol,paperList.task_year,pName.lib_num as lib_num FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 ) ORDER BY `paper_name`,`pub_date` LIMIT 3240,10 [ RunTime:0.362527s ]
SELECT SUM(`page_num`) AS think_sum FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 ) [ RunTime:0.209724s ]
