首先对英文文档建立倒排文档,然后根据建立的倒排文档,按照此检索算法对文档进行检索-First of all English documents to establish inverted file, and then in accordance with the establishment of the inverted file, in accordance with the retrieval algorithms for document retrieval
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001133s ]
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.085211s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001087s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001794s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001127s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003498s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000947s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003155s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014172s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001177s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 316797 [ RunTime:0.002728s ]