这个程序是我们的大作业,里面有语法分析,词法分析,四原式等等,里面有具体内容和事例,看看就能明白-this procedure is our largest operation, which has syntax analysis, lexical analysis, the four original type and so on, there are specific details and examples, see we can understand
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001151s ]
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.105233s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001453s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001916s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001548s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005450s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001398s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006901s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023294s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001091s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 187371 [ RunTime:0.014640s ]