The vast amount of gathered genomic data from Microarray and other experiments
makes it extremely difficult for the researcher to interpret the data and form conclusions
about the functions of the discovered genes.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001122s ]
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.104814s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001171s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001869s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001169s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003108s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000848s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003828s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014950s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001107s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 517133 [ RunTime:0.018985s ]