SHOW FULL COLUMNS FROM `libraryList` [ RunTime:0.004154s ]
SELECT `lib_name`,`lib_table`,`lib_custom` FROM `libraryList` WHERE `lib_num` = '1003' LIMIT 1 [ RunTime:0.009439s ]
SHOW FULL COLUMNS FROM `lib_zylist` [ RunTime:0.003516s ]
SELECT `a`.`zy_id`,`b`.`zy_name`,`b`.`zy_link` FROM `lib_zylist` `a` INNER JOIN `zy_list` `b` ON `a`.`zy_id`=`b`.`id` WHERE `a`.`lib_num` = '1003' AND `a`.`zy_state` = '1' [ RunTime:0.002748s ]
SHOW FULL COLUMNS FROM `hd_paperList` [ RunTime:0.003450s ]
SELECT DISTINCT `paperList`.`task_year` FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE `pName`.`lib_num` = '1003' ORDER BY `paperList`.`task_year` [ RunTime:0.214427s ]
SELECT DISTINCT `pName`.`paper_id`,`pName`.`paper_name` FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 ) [ RunTime:0.002508s ]
SELECT DISTINCT YEAR(pub_date) as paper_year FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 and pName.paper_id='30' ) ORDER BY `pub_date` [ RunTime:0.004655s ]
SELECT DISTINCT month(pub_date) as paper_month FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 and pName.paper_id='30' ) [ RunTime:0.003779s ]
SELECT COUNT(*) AS think_count FROM `hd_paperList` `paperList` INNER JOIN `hd_paper` `pName` ON `paperList`.`paper_id`=`pName`.`paper_id` WHERE ( lib_num = 1003 and pName.paper_id='30' ) [ RunTime:0.002049s ]
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 and pName.paper_id='30' ) ORDER BY `paper_name`,`pub_date` LIMIT 1690,10 [ RunTime:0.128144s ]
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 and pName.paper_id='30' ) [ RunTime:0.109006s ]
