此为工程用的物料表的后期的转换程序,前地程序通过写数据到此,它再将之转换为EXCEL文档-this works for the materials used for table conversion late in the process, before the adoption of procedures to write data to this point, it be further converted to Excel files
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001075s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.084313s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001125s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001910s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001176s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003582s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001013s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003250s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015847s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001364s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 292386 [ RunTime:0.001265s ]