ruTorrent instant search
Makes the search results appear as you type
Usage
When you are searching for local torrents in the upper right corner. The results appears as you type.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001419s ]
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.095821s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001006s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001257s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001039s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003175s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001060s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004624s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015844s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001124s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 287018 [ RunTime:0.010848s ]